updating prices of products in virtuemart

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project 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.


Additional Project Description:
08/22/2013 at 18:46 CEST
The platform is Joomla 1.5.20 and Virtuemart 1.1.5 stable

08/22/2013 at 19:10 CEST
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 required:
Data Entry, Database Administration, PHP, Software Architecture, Website Management
Hire lionshop
Project posted by:
lionshop Slovenia
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 185
in 3 days
$ 180
in 2 days
$ 233
in 5 days
$ 35
in 5 days
$ 252
in 7 days
$ 255
in 3 days
$ 55
in 0 days
Hire StdNet
$ 188
in 10 days
$ 144
in 4 days
$ 140
in 5 days