updating prices of products in virtuemart


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

Skills: Data Entry, Database Administration, PHP, Software Architecture, Website Management

See more: csv excel, suppliers products, excell program, example of number problem with solution, components of a division problem, product option import excel, import data web page, excel add csv import, data entry worksheet excel, match products, excell server, went lot, match prices, excel product supplier list, updating components, supplier computer, price changing products, virtuemart product category page, products change prices, excel populate worksheet worksheet, import excel data using, import data excel sheet, supplier price list, virtuemart product filters category, supplier list excel

About the Employer:
( 11 reviews ) Ljubljana, Slovenia

Project ID: #4852679

14 freelancers are bidding on average $157 for this job


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 More

$185 USD in 3 days
(239 Reviews)

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.

$180 USD in 2 days
(248 Reviews)

Hello,i am virtuemart K2K back end expert.i am ready to do this for [url removed, login to view] how many product you need to add in your cart??what your budget?/please provide me details then i will make few sampe for you.

$233 USD in 5 days
(196 Reviews)

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 More

$35 USD in 5 days
(20 Reviews)

Sir, I'm professional, innovative and positive approach Web Developer with good commend on PHP/MySQL, Ajax, Jquery, HTML, CSS, JavaScript, Drupal and Joomla, please check [url removed, login to view] for more details.

$252 USD in 7 days
(19 Reviews)

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

$255 USD in 3 days
(22 Reviews)

Dear Hiring Manager, I am large scale Data entry and Web Development Company on [url removed, login to view], I have already uploaded more than 1000K products on Magento backend With Photoshop work! I am Large scale Ecommerce Da More

$55 USD in 0 days
(2 Reviews)

Hi. I can help you. Some times ago I have do project like you.

$188 USD in 10 days
(13 Reviews)

I have experience with your project requirements , check pm.

$144 USD in 4 days
(4 Reviews)

I am ready to do this job Sir.

$140 USD in 5 days
(16 Reviews)

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 More

$155 USD in 3 days
(0 Reviews)

I am ready

$155 USD in 3 days
(0 Reviews)

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

$155 USD in 3 days
(0 Reviews)

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

$144 USD in 5 days
(0 Reviews)

DIGITAL PARTNER is IT Solutions-Design team based in Surabaya. Focusing on business development of our clients. Holding on the principle of win-win solution as our business strategy to launch and committed. we wanted More

$155 USD in 4 days
(0 Reviews)

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

$100 USD in 3 days
(0 Reviews)