Update different combination prices

[PhilJeweler]

Hi.

 

I need to update a lot of combination prices at the same time and I don't know why. I know that I can update a group of product prices using SQL in the database, for example:

 

UPDATE `ps_product` SET `price` = `price` * 1.10

 

But when I have a product with several combinations, this doesn't work, and I don't know where is the combination table.

Thanks for the help and sorry for my english, I'm improving it slowly.

[PhilJeweler]

Any help please?

[musicmaster]

Actually your example might not work - as you need to update the price in ps_product_shop too.

 

It would take me at least ten minutes to find out how combinations are exactly programmed in Prestashop. It is too complicated to remember. If I remember well the prices are in ps_product_attribute.

 

You might also try my script: http://www.prestashop.com/forums/topic/185401-free-script-product-mass-edit-category-multi-edit-order-edit/

[PhilJeweler]

Thank you for your response and help, musicmaster.

 

I have used your script and it looks great, nice job, but it isn't work to edit mass combinations (or I don't know how). It works fine for other tasks.

[musicmaster]

Nice that you like the script.

 

What do you mean by mass combinations?