When you have Stock tracking on and Product Status goes to 0 when products_quantity goes to <= 0 ...
This means that when an order is completed and the stock (products_quantity) drops to <= 0 then the products_status goes to 0 ...
But if the products_quantity is 0 done manually or before this setting is set ... the products do not automatically change ...
You can change this by backing up your database then run this command in the Tools ... Insert SQL Patches ...
PHP Code:
UPDATE products SET products_status=0 where products_quantity=0;
Be sure to backup your database first as all of these products will be removed from display on your shop ...
Bookmarks