Modifying minimum quantity via PHPmyadmin

[Ajeh]

You just trip over these things the more you work with databases and php ...

Knowing what the code expects for settings, you can do global updates on numerous conditions like this ...

[Pauls]

Well I thought this worked Linda however in practice it doesn't ... I issued the SQL query UPDATE products SET products_quantity_mixed=0; which should in theory stop people buying odd amounts . For example I need people to buy a product in lumps of 12 and other products in lumps of 25, and although I can set the amount that people can buy in the shop if someone adds say 13 items to the cart the cart lets them through to checkout, I don't want this. The buyer must buy either 12 or 24 or 36 or 48 etc, ie multiples of 12 I cannot see anyway to make the cart do this ? The same is true for items of 25 they must be sold in lumps of 25, ie 25, 50, 75, not 26, 27 or 35 etc.

So to sum up some items need to be sold in quantities of, and I would also like to be able to modify categories rather than individual items as this way of modifying items will take me days of tedious individual pricing. Please help if you can, thanks.

[Ajeh]

IF you set the Product Units to 12 then you have to buy in units of 12 on each product then they have to buy 12 of any given product but can combine mixed attributes when mixed is turned on ...

[Pauls]

Thank you yes, I have found out that is the case, is there a way to do this to categories via SQL though? So, change all the Product Units to 12 in one category, 6 in another category, and 25 in yet another .. other than how I am currently doing it, ie manually one at a time for 900+ products !

[DrByte]

First you need to consider whether you are planning to update based on ALL the categories a given product is found in (ie: links), or only based on master-categories-id.

Then you'll have to consider whether this is supposed to happen for all products in all subcategories below the category you mention, or if it only happens for items at that one level.

Then, you'll have to write a SQL query with an appropriate combination of joins between the products table, the products_to_categories table, and the categories table, using the selection criteria for category/product selection resulting from those answers.