Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Updating products_status field


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:






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


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

  • Create New...