All Products Minimum order 1

Quote

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 :)
cwdltd
New member
Posts
30
Joined
Sat Feb 23, 2013 1:46 am
Top

Re: All Products Minimum order 1

Quote

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
imdevlper18
Active Member
Posts
862
Joined
Sun May 11, 2014 2:04 pm
Location - Mumbai, India
Top

Re: All Products Minimum order 1

Quote

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
clittlehales
New member
Posts
38
Joined
Thu May 29, 2014 6:03 pm
Top

Re: All Products Minimum order 1

Quote

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
cwdltd
New member
Posts
30
Joined
Sat Feb 23, 2013 1:46 am
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: No registered users and 29 guests