automatic hide product when quantity 0

[ebaobao]

Hello,
Is there an option to automatically not display the product if its stock quantity is 0?
Thanks.

[DrByte]

Admin->Configuration->Stock ... set "if product quantity is 0, set product status to" ... to 0
This will disable any products whose quantity comes to zero after making the change.

[ebaobao]

thanks drbyte,
i knew there was a setting in there some where!

[ebaobao]

just a small note. if you change the quantity to 0 from admin, it won't automatic change the status. but if you are going to change the quantity from admin to 0 why not just change the status

[Ajeh]

That is a very good point to bring up ...

Only Products who have their stock or quantity drop to <= 0 during the completion of an order will get set to products_status 0 ... or Out of Stock ...

If you change the products_quantity manually, you will also have to manually set the product to Out of Stock or products_status 0 ...

NOTE: If all Products that have products_quantity of <= 0 you could run the following SQL in the Tools ... Install SQL Patches ...

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

Thanks again for pointing out something that is often times overlooked ...

[notageek]

Hi. To avoid matching over 400 products one-by-one with a new download from my dropshipper, I set all products in the store to zero. I then overwrote the settings by uploading a current easy populate file with the correct product quantities for the non-zero-quantity products.

I thought I would be able to then just set products with zero quantity to not show up in the store. I went to Admin>Configuration>Stock and did not find an option "if product quantity is 0 set status to 0."

The only option I seem to have is to show zero-quantity products as "sold out."

So is my only option now to compare all the products, and delete or make inactive the ones no longer available, one by one?

I do have "Products status in Catalog when out of stock should be set to" set to zero.

Thanks.

[notageek]

I suppose the solution, if not going the route of the SQL patch mentioned above, is to now download the store through Easy Populate and set all zero products to inactive status, and re-upload. At least the zero quantity products will now be evident in the store download, quicker than a comparison one-by-one.

[Ajeh]

If you want to set the products_status of ALL Products to 0 where the products_quantity = 0 ... then backup your database, then you can use:

UPDATE products SET products_status = 0 WHERE products_quantity = 0;

Now none of these will show in the Store as the products_status is 0 ...