That gets a bit more complicate ...
But you could try, to update the Attribute Prices ONLY in master_categories_id 67 to use:
NOTE: Backup your database before trying this ...Code: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.20 WHERE p.master_categories_id = 67;


Reply With Quote
