EthosPaul Posted March 21, 2006 Posted March 21, 2006 We have a catalog of about 60,000 skus, most are five digit individual numbers. Every morning, the supplier sends us a csv file of the skus with quantity on hand. If an item is backordered, it is zero quantity. If discontinued, it is a T or marked inactive. Is there a way to daily "hit" the database with this list and take the items out of stock (or mark inactive) that are discontinued and change quantities? Any help with this would be greatly appreciated. Paul ------------
EthosPaul Posted March 21, 2006 Author Posted March 21, 2006 Also, the list they are sending me only has the v_products_model and the quantity, and status, nothing else. We can initiate any type of product info needed from the vendor, just need to find out how to hit the database. Paul ------------
Guest Posted March 21, 2006 Posted March 21, 2006 you would have to create a separate script to do the updates on all product related tables. there could be some hints here http://www.oscommerce.com/forums/index.php?showtopic=172479 and have a look on the easypopulate contribution if you could extract some code to that.
EthosPaul Posted March 21, 2006 Author Posted March 21, 2006 Thanks, will poke around on that topic and see if there is something that can be automated. I am open to outsourcing this project, pm me if someone can help. Thanks. Paul ------------
Recommended Posts
Archived
This topic is now archived and is closed to further replies.