Products Quantity Box Shows

[Brianne]

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

[Ajeh]

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

[Brianne]

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

[Ajeh]

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

[Brianne]

Thanks Ajeh, I will give it a go.
Regards
Brianne

[Brianne]

That worked a treat Ajeh
Many Thanks
Brianne

[Ajeh]

Thanks for the update that this was able to work for you to update the display of the quantity boxes ...