Set Product Qty Maximum for 1500 products?

[GTrotter]

I have uploaded all my products to ZenCart using Easy Populate but I need to set the "Product Qty Maximum" to "0" for all of these products as I do not want the user to be able to enter a quantity number (people will only ever buy one unit of each product). I do not seem to be able to set this field using Easy Populate.

Is there another way of doing this without setting each one individually?

Thanks

Gary

[Ajeh]

Product Maximum of 0 means unlimited ...

Product Maximum of 1 means 1 can be ordered ...

You may want to hide the quantity box so that they cannot change it ... this will make the quantity box on listings switch to Buy Now buttons ...

You can update all of your Products, if ALL products are to be 1 only, by using this in the Tools ... Install SQL Patches ...

UPDATE products SET products_quantity_order_max=1; 

[GTrotter]

Oops "0" and "1" mix up!

Thank you for your help with this - it worked a treat.

Gary

[Toddlesnz]

Hi I have a similar problem, I wish to change the maximum order size to "2" for all my products. Do you just go to Tools->Install SQL patches and then type the above php code into the "Enter the query to be executed:" text box, change the relevant value (in my case to "2"), and then click the send button? Or am I missing some steps? I searched for a thread on how to use this tool, but no luck.

Obviously DB backup comes first, just in case. I am running 1.3.8A with the DB patched to 1.3.8.

[Ajeh]

Backup your database first ...

Then, to make the maximum quantity per product set to 2 you can use the command from above as:

UPDATE products SET products_quantity_order_max=2;

[bryanck]

I have this problem too, i presume this could only be controlled for each order (i.e. nothing to stop an user placing a 2nd order).

any solution can stop an user placing a 2nd order?

[bryanck]

Sorry Ajeh, this question was discuzz in http://www.zen-cart.com/forum/showthread.php?t=117678