I have about 150 products in the same Product Category that have 2 priced attributes that need the price changed. There are a bunch of attributes, but I only need to change 2 of them.
From reading various threads it appears the best way to easily do this is with SQL.
I found some threads where people used the following SQL to do this:
I went to my Option Value Manager and found the ID for the attribute option name (it's 2) I want to change price on.Code:UPDATE `products_attributes` SET `options_values_price` = '4.0000' WHERE options_values_id = "PRODUCTS_VALUE_ID";
So, here is what I think I would run (changing price to $6):
Code:UPDATE `products_attributes` SET `options_values_price` = '6.0000' WHERE options_values_id = "2";
The problem I see with this SQL (for my situation) is that I only want to change the attribute option price in one category. If I run that SQL it will change it in all categories on entire site.
Is there a way to modify this SQL to just perform the update in one category?
The category ID is 10
The first attribute option needs to change from 2.00 to 4.00
The second attribute option needs to change from 4.00 to 6.00
Thank you for your time.



