Can I set "No, Do not show Quantity Box" across the board?

[spawnie69]

Hey everyone!

I am looking to change all my products to "No, Do not show Quantity Box" on "Products Quantity Box Shows:" in the product listing.

Is there a sql line I can use to change this across the board or do I need to do this to all listings?

I just want tall my listings to show the 'buynow' button quickly and easily.

Thanks!

ZenCart Rocks!

[Ajeh]

To change ALL Product to Not show the Products Quantity Box, you could run in the Tools ... Install SQL Patches:

UPDATE products SET products_qty_box_status = 0;

[spawnie69]

Thanbks Ajeh. You are the best!
What if I just need if for a specific category?
Many Thanks.

[Ajeh]

Then you need to add a condition in the WHERE statement such as just for master_categories_id 12, you could use:

UPDATE products SET products_qty_box_status = 0 WHERE master_categories_id=12;