how do i not display out of stock items?

[proseller]

Hello,

I was wondering if there is an option in the admin area to not display items that are out of stock in my store.

I am using 1.3.9a

Thanks
Lexxie

[jc8125]

admin->configuration->stock->Products status in Catalog when out of stock should be set to 0

[gilby]

admin->configuration->stock->Products status in Catalog when out of stock should be set to 0

As well as...
admin->configuration->stock->Subtract stock->true

And probably...
admin->configuration->stock->Check stock level->true
admin->configuration->stock->Allow Checkout-> false

[Volkman]

I am trying to do the same thing, and have set all the settings above appropriately, yet my zero stock items still show up.

Have had this issue forever and can't figure out how to keep the products from showing.

Currently running 1.3.9h

[Ajeh]

Changing the setting will manage future Orders and mark Products as Out of Stock (products_status = 0) when Product Quantity (products_quantity) <= 0 ...

However, changing the setting does not change the existing Products where products_quantity <= 0 to be products_status = 0 ...

You can update your database products table by:

1 Backup your database

2 run the following in the Tools ... Install SQL Patches:

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

[Volkman]

Ah ha! Thank you. That did the trick. I would have never figured that out!

[Ajeh]

You are most welcome ... thanks for the update that this is working for you now ...