Ordering Max

[boogily]

I hope there is an easy answer to this. I have created a store with hundreds of items. Currently, there is no maximum on how much you can order.

Is there a way to change this maximum to how much "on-hand" quantity for the products? I am trying to avoid going through hundreds of products individually. I know I can change the max in each of the products page, but that would take forever and I would like to know of a shortcut. Any help would be great, thanks

[haredo]

Boo,
Check out this little thread to help you..

http://www.zen-cart.com/forum/showthread.php?t=122516

Notice #6, on how Ajeh uses Install SQL Patches,

1. You will use this:
2. UPDATE products SET products_quantity_order_max = XX;
3. Read post #6 for the XX value

Make sure to make a backup of your database before this procedure, if you make a mistake you can load the original database back

[boogily]

Just curious, could I go:

UPDATE products SET products_quantity_order_max = products_quantity

That would be neat. Then you would never have to change your max, just your on hand quantity