updating prices of products in virtuemart

Job Description:


I need to populate my web shop with a lot of products from different suppliers.


VM category:Computer division;components;harddisk;

Suppliers of the products: 5

Number of items in the category: 80

Now my first problem is that i am using csv to import the products, but the ordering in excel takes time and also i cannot add pictures (because they are not on the server and i dont have the link to add) and i also have to setup filters for each product, so i have to insert products manually one by one.

The second problem is maintaining the prices. I would like to have a program or excell or some feature to use the excell worksheet the supplier send me with new price list to compare with the prices on my webpage. I would like that program would ream the excell document from before and the new one and warn me of the prices going up or down.

For all of the products on the site i can use the same number for the product as the supplier in the excell sheet.

I would also like to have an option if a product price went up, to change the price on the page on the fly. Besides looking and warning me for the price change i would need to change the prices for the web shop on the fly...either in the excell sheet or somewhere as to not need to open in VM each product and manually change the price.

Basically i need something that will make the price changing and having a lot of products on the page managable. I get excell lists of products with prices from different suppliers. They can have same items, but i would like the program to differentiate which products are on the web page from the unique number from the supplier that would match the SKU on the web shop. If there is a better or easyer way, please let me know.

The thing should be firstly tested before implemented on the live server.

Please send me the reply with the possible solution of the problem and how it would work.


The platform is Joomla 1.5.20 and Virtuemart 1.1.5 stable

examples of excell sheets. How the columns are sorted depends on the supplier. Usually the first column is the unique id of the product that would be the same as the SKU of the product

1phase - see the new items,if old items removed
2phase - see which items the price went up or down
3phase - check if the item on webpage and check the price
4phase - i can change the selling price on the fly so i dont need to open and click in virtuemart for each item

Compétences : Saisie de Données, Administration de Bases de données, PHP, Architecture Logicielle, Administration de Site Web

Concernant le client :
( 13 commentaires ) Ljubljana, Slovenia

Nº du projet : #4852679

13 freelances font une offre moyenne de 157 $ pour ce travail


Hi, I have long experience in Graphic Design, HTML5, jQuery,User Interface / IA, Website Design, SEO, Joomla, Wordpress, Magento,... and PHP. I am ready to start on your project. Please send me a Private Message if you Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(390 Commentaires)

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(277 Commentaires)

I am ready to do this job Sir.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(185 Commentaires)

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SE Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(19 Commentaires)

Hey, Ready to get this done fast. Thanks, Farhan

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(36 Commentaires)

I've been working in the field of Accounts, Audit, Income Tax, VAT & Company Law more than 07 (Seven) years. I have completed my post graduation in Accounting, also complete Chartered Accountants course that’s why I th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

I have a professional team who can do this job easily. We already done this kind of jobs.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

I'm graduated student in Informatic engineering and i'm searching for a job

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)

Hi Sir, Expert here to start now. PLEASE check PMB. Thanks...

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)