Attributes Price Markup

[Ajeh]

If the goal is for Attribute Price to change:

10.00 to 13.20
100.00 to 121.20
5.00 to 7.20
99.00 to 120.00

then use the SQL of:

UPDATE products_attributes as pa 
LEFT JOIN products as p ON  pa.products_id = p.products_id
LEFT JOIN products_options_values as pov ON pov.products_options_values_id = pa.options_values_id
SET pa.options_values_price = ((pa.options_values_price +1.00) * 1.20)
WHERE p.master_categories_id = 67;

NOTE: Be sure to backup your database before trying this ...

[Nick1973]

If the goal is for Attribute Price to change:


then use the SQL of:

UPDATE products_attributes as pa 
LEFT JOIN products as p ON  pa.products_id = p.products_id
LEFT JOIN products_options_values as pov ON pov.products_options_values_id = pa.options_values_id
SET pa.options_values_price = ((pa.options_values_price +1.00) * 1.20)
WHERE p.master_categories_id = 67;

NOTE: Be sure to backup your database before trying this ...

Ok thanks again Linda, thats exactly what I need.

[Nick1973]

Ok thanks again Linda, thats exactly what I need.

Actually Linda while I need that solution I also need it globally so would I do something like

UPDATE products_attributes SET options_values_price = options_values_price +1.00 * 1.20;

if I wanted to update every products attributes by £1.00 and then add 20% globally?

[Ajeh]

I would use:

UPDATE products_attributes SET options_values_price = ((options_values_price +1.00) * 1.20);

NOTE: Again, be sure to backup and test this to ensure that all is right in the world when done ...

[Nick1973]

Thanks again Linda, I think thats everything I need now on this part.

Happy New Year by the way

[Ajeh]

You are most welcome ... glad that you have this all sorted out ...

Have a great New Year!