Products Quantity Box Shows

1 Oct 2009, 5:51 AM

#1

New Zenner

Join Date:: Jul 2009
Posts:: 14
Plugin Contributions:: 0

Products Quantity Box Shows

Is it possible to globally change a product setting ?
Products Quantity Box Shows:
I have over 200 products and wish to set them all so that the Products Quantity Box Shows.
Thanks
Brianne

1 Oct 2009, 5:41 PM

#2

ajeh

Oba-san

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

Re: Products Quantity Box Shows

There are a few reasons for this ...

1 You have it set on the Product to be turned off and need to update the products table ...

to set ALL Products to show a quantity box use:

UPDATE products SET products_qty_box_status = 1;

2 You have turned off the display of the quantity box in various areas of your shop and it would be easier to see an URL to where you are having problems ...

3 Your templates and overrides are preventing the quantity box from showing and you could try switching to the Classic Template to see if this is the case ...

2 Oct 2009, 1:49 AM

#3

brianne

New Zenner

Join Date:: Jul 2009
Posts:: 14
Plugin Contributions:: 0

Re: Products Quantity Box Shows

Thanks Ajeh
I am not having a problem as such, just wish to update ALL products to show quantity box.
First part of your answer looks promising:
UPDATE products SET products_qty_box_status = 1;
How would I implement this please?

Brianne

2 Oct 2009, 3:36 AM

#4

ajeh

Oba-san

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

Re: Products Quantity Box Shows

You would backup your database and then run that either via phpMyAdmin in the SQL ... or you can run that in your Zen Cart Admin in the Tools ... Install SQL Patches ...

2 Oct 2009, 6:56 AM

#5

brianne

New Zenner