Hey Everyone,
I'm currently trying to setup an online store, my wholesaler provides all their product info via .CSV file. The file from my wholsaler has about 6000 items. I cleaned up the file and have all the products I want to use in my store. Everything uploads correctly. Great, good...Anyhow now how do I update my .CSV without overwriting all the formatting I already did? There is pretty much two coloums I need to change that are always need updating daily: STOCK and PRICE.

I guess all I'm asking is how to take the raw .CSV from wholesaler and compare and replace the price and stock coloums of my EDITED .CSV I've been using excel to edit my csv...

Any Ideas will help

Hope to hear from you all soon....

I would compare the stock numbers in the your price list with the updated price list and if the new price is different update your price. If you data is in a database all you need is an update routine.

Im a beginner, everything is in a .csv file. Do i have to import it to a database for this tow work or can it be done in excel?

How is the data stored in your online store software? I can't think of an easy way to use Excel to update from a csv file directly.

It's stored in a mySQL database. Which all the data is imported via the .csv, the .csv for the card has to be setup a specific way.

I think I may need a script or a program that can search and compare my PARTNUMs and then replace price and stock if the PARTNUM match.

I was thinking this way

A VB Script or any language,

Which allows me to specify my Shopping cart .CSV then specify my updated wholesaler .CSV - The script would then compare wholesaler.csv with Shoppingcart.csv by PARTNUM. If the PARTNUMs match change, then change price and stock field within Shoppingcart.csv with price and stock from wholesaler.csv

Like I said before, any Ideas help we are at the start stage here.