Don't show 0 quantity products.

[scottb]

I have several hundred products in a store. The products are refurbished and sometimes I have none in inventory.

How can I set the products with zero quantity to not display?

[Pixxi]

Admin->configuration->stock:

Check stock level true
Subtract stock true
Allow Checkout false

Products status in Catalog when out of stock should be set to 0

[scottb]

Will this be an upgrade in future versions?

The ability for a product to turn its status to off when it reaches a predefined inventory level such as 0 or 10 or whatever.

It would save a lot of time when you have have lot of products.

[Ajeh]

This is built in that when stock goes to <= 0 from a completed order the status can be turned to 0 to not show the product or left at 1 and then show the Sold Out vs the Add to Cart ...

You can also make your own image such as a Out of Stock ... Back Order etc. to better suit your needs ...

[scottb]

I understand that.

I want the product not to display at all if it is sold out. No sold out button, no not available button, or anything.

I sell refurbished cell phones. When the quantity reaches 0, I may never get that particular model phone again.

[Pixxi]

Admin->configuration->stock:

Check stock level true
Subtract stock true
Allow Checkout false

Products status in Catalog when out of stock should be set to 0

It does that as standard - just change your settings in admin->configuration->stock to the above and it will work

[Ajeh]

NOTE: this setting affects stock on the order confirmation ... it does not affect existing products with products_quantity = 0 ...

You would need to update those products manually or run a global update such as:

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

This can be run in the Tools ... Install SQL Patches ...

Be sure to Backup your database before running this ...

[scottb]

Ajeh,

Thanks. That should do it.

[scottb]

It worked like a charm.

[Ajeh]

Thanks for the update that this worked for you ...