Jump to content

sql query or module change minimal quantity combination


ilario

Recommended Posts

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

Link to comment
Share on other sites

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
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...