Products Quantity Box Show vs Easy Populate

[LilleyPadGifts]

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!

[bunyip]

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

[khopek]

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;