Forums / Setting Up Categories, Products, Attributes / Mass Add Quantity box to all products

Mass Add Quantity box to all products

Results 1 to 3 of 3

14 Jun 2011, 14:48

dgent

Totally Zenned

Join Date:: Nov 2009
Location:: UK
Posts:: 1,117
Plugin Contributions:: 0

Mass Add Quantity box to all products

Ive got a site with about 1500 products, entered by various people - None of the products have show quanitity box selected, so is there an SQL instruction I could run to turn on every single product to 'show quantity box'

14 Jun 2011, 15:46

ajeh

Oba-san

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

Re: Mass Add Quantity box to all products

In the Tools ... Install SQL Patches ... you could run:

UPDATE products SET products_qty_box_status = 1;

to enable the Product Quantity Box on ALL Products ...

14 Jun 2011, 16:27

dgent

Totally Zenned

Join Date:: Nov 2009
Location:: UK
Posts:: 1,117
Plugin Contributions:: 0

Re: Mass Add Quantity box to all products

Perfect thanks.