All Products Minimum order 1

Any SQL Code to run to set all products to have a minimum order quantity of 1?

Currently there is a tonne of different quantities and I just want 1 only per product as the new minimum.

Thanks

Go to cpanel - database - product table - sql tab

And run the query below: Please note if you have database prefix, then add it in above query. Example, your prefix is "oc_"
The above query will be: This will update all products with minimum quantity to 1.

This free extension allows that.. (if you can't be bothered to modify files)

http://www.opencart.com/index.php?route ... on_id=3327

Thanks guys that worked a treat, didn't realise it would be so simple Oh well, thanks again