Post by cwdltd » Wed Sep 10, 2014 12:43 am

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 :)

New member

Posts

Joined
Sat Feb 23, 2013 1:46 am

Post by imdevlper18 » Wed Sep 10, 2014 2:53 pm

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.

Opencart Extensions | Professional opencart support | Support Ticket | support@cartbinder.com


User avatar
Active Member

Posts

Joined
Sun May 11, 2014 2:04 pm


Post by clittlehales » Wed Sep 10, 2014 9:42 pm

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

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

New member

Posts

Joined
Thu May 29, 2014 6:03 pm

Post by cwdltd » Mon Sep 15, 2014 6:11 pm

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

New member

Posts

Joined
Sat Feb 23, 2013 1:46 am
Who is online

Users browsing this forum: No registered users and 58 guests