Don't show 0 quantity products.

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?

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

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.

:yes:

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 ...

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 :smile:

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 ...

Ajeh,

Thanks. That should do it.

It worked like a charm. :yes:

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

I had an exactly similar requirement (posted elsewhere)

Running the update statement:
*UPDATE products SET products_status = 0 WHERE products_quantity <= 0;*was necessary to force this value for products added with zero stock, rather than decremented to zero by sales. This finally, does hide the product from listing as I required - HOWEVER:

It doesn't stop it appearing in the "new for this month" list - as it was recently added. Can I suppress zero stock from this listing?