Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database daily update (discontinueds and backorders)


EthosPaul

Recommended Posts

Posted

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

Posted

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

Posted

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...