Items won't go inactive when out of stock

[GSto]

I was trying to configure the stock options for the store I work for (Mbare) , and they want the items to be taken off the site when we are sold out. I went to Configuation > Stock , and set 'Products status in Catalog when out of stock should be set to' equal to 0. The items that we are sold out of are still showing up! how can I fix this?

[daver1510]

I feel your pain. I've been trying for a week now to keep out of stock inventory from showing up in catalog.

[Ajeh]

If you set the stock up so that when products_quantity hits <= 0 that the Product should be set to products_status 0 (removed from the Catalog) then this will work when Stock Tracking is turned on ...

However, existing Products that have products_quantity 0 will NOT be set to products_status 0 just because this switch is set, after the fact ...

The products_status is set during the checkout_process of the order ... and to adjust existing Products that have already gone to products_quantity <= 0 to be products_status 0 you need to do this either manually or you can issue a global update for this ...

NOTE: you can also set Products to show as Sold Out vs remove completely from the Catalog in the Stock settings as well ...

To globally update your Products to be products_status 0 when products_quantity is <= 0 you can run in the Tools ... Install SQL Patch ...

UPDATE products SET products_status = 0 WHERE products_quantity <= 0;