sql query or module change minimal quantity combination

[ilario]

hi

 

I would change the minimal quantity to all combinations of a product,

but all at once, I tried with

UPDATE `ps_product_attribute` SET `minimal_quantity` = xxx WHERE `id_product` = xxx


but I found that I have to change it even on the table `ps_product_attribute_shop`

you have already tried to make a sql-query?

thanks

 

ilario

[PascalVG]

If I understand well, you want to know how to update more tables in one single SQL statement?

 

If so, maybe this helps:

http://stackoverflow.com/questions/4361774/mysql-update-multiple-tables-with-one-query

 

My 2 cents,

pascal

[ilario]

hi

 

I would change the minimal quantity to all combinations of a product,

but all at once, I tried with

UPDATE `ps_product_attribute` SET `minimal_quantity` = xxx WHERE `id_product` = xxx

 

 

but I found that I have to change it even on the table `ps_product_attribute_shop`

 

you have already tried to make a sql-query?

thanks

 

ilario

 

I created the correct query to change the Minimal-quantity (prestashop 1.6)

UPDATE  ps_product_attribute_shop 
INNER JOIN ps_product_attribute
ON  ps_product_attribute_shop.id_product_attribute = ps_product_attribute.id_product_attribute 
SET ps_product_attribute_shop.minimal_quantity = 25
WHERE ps_product_attribute.id_product = 119