Updating product catalog from file

[Guest]

I'm looking for opinions on the best route to update prices and quantities from an outside CSV file provided by my distributor.

The feed columns does not match my product DB so I can't just replace files within Easy Populate. As I understand it, EP would require me to extract the info from my DB, modify it by hand, and then upload it. Doing that would be just as time consuming as what I do now.

 

I currently add new items by CSV file inserted from within my webhost's DB control panel. And update by hand with a slightly modified quick stock updater contribution. But it takes forever to bring up my distributor's site and hand compare prices and quantities for literally thousands of items. So I need some kind of interface that extracts from the CSV feed products_model, products_quantity, and products_price and updates the OScommerce product catalog with any records it finds that match.

 

I'm thinking I could us a php interface like quick stock updater that pulls the records of the feed, displays it, but then updates the OScommerce DB with the new data where the product_model matches.

 

so, what's the best way to do this? Anyone have any opinions?

 

Diana

[web-project]

try the Easy Populate module at:

http://addons.oscommerce.com/info/500

[Guest]

try the Easy Populate module at:

http://addons.oscommerce.com/info/500

 

 

 

Easy Populate & Products Attributes

for osCommerce Online Merchant v2.2

 

Easy Populate makes it simple to populate your OSC store with products without using the web interface at all.

 

Easy Populate lets you download all your products into a csv file, edit them in the spreadsheet of your choice, and the reupload them to update your products, changing prices, categories, quantities, etc.

 

If new manufacturers, categories, or subcategories are found in the data, they are created for you on the fly.

 

This is based on the Excel Upload 1.51 from dynamok.

 

 

Alex,

 

Thanks for the suggestion, but based on the above description of EP it seems that I still would have to modify the downloaded product list by manual compare and adjustment. Which is what I am doing now and trying to get away from. If I am mistaken, could you please offer some more detail about how you are thinking EP should work for me?

 

My product DB is not in the same format as the supplier provided file in products listed nor columns/table setup. I'm looking for some way to make this nearly automated, pulling the records from the supplier file and updating the product DB. I'm not asking for someone to provide the code (unless someone wants to) but just the basic how to... whether its a php page or SQL code on the DB backend.

 

Diana

[Guest]

I'm try to install the EP now just need to ask befoe t stuff it completly once i have completed the // **** Temp directory ****

define ('EP_TEMP_DIRECTORY', DIR_FS_CATALOG . 'temp/'); part dose the following code need to be placed in the config file or left where it is

 

ty for you help dj