We are using OC 1.5.5.1 and have a supplier stock feed that updates a few times a day, however when it does update it doesn't always set 0 stocks to out of stock and we have to run an SQL command.
The command we are using is this:
Code: Select all
UPDATE oc_product SET stock_status_id = '5' WHERE quantity = '0'
Thank you for your help.