Page 1 of 1

All Products Minimum order 1

Posted: Wed Sep 10, 2014 12:43 am
by cwdltd
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 :)

Re: All Products Minimum order 1

Posted: Wed Sep 10, 2014 2:53 pm
by imdevlper18
Go to cpanel - database - product table - sql tab

And run the query below:

Code: Select all

UPDATE  `product` SET  `minimum` = 1 WHERE 1
Please note if you have database prefix, then add it in above query. Example, your prefix is "oc_"
The above query will be:

Code: Select all

UPDATE  `oc_product` SET  `minimum` = 1 WHERE 1
This will update all products with minimum quantity to 1.

Re: All Products Minimum order 1

Posted: Wed Sep 10, 2014 9:42 pm
by clittlehales
This free extension allows that.. (if you can't be bothered to modify files)

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

Re: All Products Minimum order 1

Posted: Mon Sep 15, 2014 6:11 pm
by cwdltd
Thanks guys that worked a treat, didn't realise it would be so simple :( Oh well, thanks again :) ;D