Hidden frontEnd product

5 May 2011, 10:23 PM

#1

weramirez

New Zenner

Join Date:: Apr 2011
Posts:: 9
Plugin Contributions:: 0

Hidden frontEnd product

Hi;

i want to know if its possible hide a product once it have 0 stock units.

Best regards!

5 May 2011, 10:36 PM

#2

design75

Totally Zenned

Join Date:: Dec 2009
Location:: Amersfoort, The Netherlands
Posts:: 2,862
Plugin Contributions:: 5

Re: Hidden frontEnd product

Admin => Stock=> Products status in Catalog when out of stock should be set to => set to 0

9 May 2011, 5:19 PM

#3

weramirez

New Zenner

Join Date:: Apr 2011
Posts:: 9
Plugin Contributions:: 0

Re: Hidden frontEnd product

Hi;

I have set to 0 but products with stock 0 are visible for user yet, how does it works?

Best regards!

9 May 2011, 5:55 PM

#4

stevesh

Black Belt

Join Date:: Feb 2005
Location:: Lansing, Michigan USA
Posts:: 19,793
Plugin Contributions:: 2

Re: Hidden frontEnd product

The last item of a particular product has to be ordered and go through the checkout process before that product will be removed from the product listing. You can't just set the quantity to zero.

9 May 2011, 8:42 PM

#5

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Hidden frontEnd product

To get all of your Products caught up with this setting, you could run in the Tools ... Install SQL Patches:

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

from then on, as stevesh has explained, it will happen when Orders are completed on the checkout and when the quantity is less than or equal to 0 they will be marked as Out of Stock and not show in the Catalog until you change that setting ...