Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Updating products_status field


goodbunny

Recommended Posts

My wholesale supplier provides me with a regularly updated .txt file that shows the status for every product. The inventory file lists the item number and the stock status (1 = in stock, 0 = out of stock); for example:

 

243,1

456,0

546,1

 

I want to update the products_status field using this file, instead of resorting to my current method of updating it through the admin tool (our extensive inventory makes this quite a chore!) Is there a contribution that exists that would handle this, or is there a query I can run in phpMyAdmin to make it happen?

 

I'm still learning my way around SQL and PHP, and this is outside of my capabilities...I have a feeling that there is an easy answer that I'm just not seeing! I greatly appreciate any assistance you may be able to provide.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...