Forums / Setting Up Categories, Products, Attributes / Products Quantity Box Show vs Easy Populate

Products Quantity Box Show vs Easy Populate

Views: 2,652

Results 1 to 3 of 3
24 Jan 2009, 3:13 AM
#1
lilleypadgifts avatar

lilleypadgifts

Totally Zenned

Join Date:
Jan 2007
Location:
Southern California
Posts:
550
Plugin Contributions:
0

Products Quantity Box Show vs Easy Populate

I can't seem to figure out how to NOT have the qty box show when I upload a file via Easy Populate.
I turned it off in Admin Config Prod Info, but when I uploaded a file of over 100 comics, they all have the Qty box unless I go in one by one and turn it off.
What field in the EP file controls this? and how can I do a mass edit to turn off the ones that are uploaded?

Thanks!

29 Jan 2009, 7:16 PM
#2
bunyip avatar

bunyip

Totally Zenned

Join Date:
Sep 2004
Location:
Western Massachusetts
Posts:
2,361
Plugin Contributions:
1

Re: Products Quantity Box Show vs Easy Populate

The products_quantity_order_max field in the products table is what would be used to set your max order qty to 1 (which automatically turns off the qty box).
I don't use EP, but I don't think it uses that field for uploads, so the database uses the default value, which is zero.

The easiest way to ensure that the value gets set to 1 is to change the default value of the field in the database.

You can do that either with phpmyadmin or by pasting the following sql query in Admin > Tools > Install SQL patches:

ALTER TABLE products CHANGE products_quantity_order_max products_quantity_order_max FLOAT NOT NULL DEFAULT '1';

To quickly update all your products that have max qty of 0 to be max qty 1, run this query from the install SQL patches tool:

UPDATE `products` SET `products_quantity_order_max` = 1 WHERE `products_quantity_order_max` = 0

Neville
An assumption is what you arrive at when you get tired of thinking...

20 Feb 2010, 9:18 PM
#3
khopek avatar

khopek

Totally Zenned

Join Date:
Aug 2006
Location:
portlandish, oregon
Posts:
795
Plugin Contributions:
0

Re: Products Quantity Box Show vs Easy Populate

Thank you! I have been trying to figure this out.. I ran

UPDATE products SET products_quantity_order_max = 1 WHERE products_quantity_order_max = 0
from the install SQL patches tool, however make sure to add a ';' at the end of the statement so it looks like
UPDATE products SET products_quantity_order_max = 1 WHERE products_quantity_order_max = 0;