Bulk increase product options (attributes) via sql

[Rachael w.]

I have hundreds of thousands of items listed in my shop. I have about 300,000 listed with attributes or options. I need to increase the price of those options to a particular dollar amount. Can anyone tell me how to go about doing that?

 

**********************************************************************************

Example:

 

All blue, red, green and yellow shirts are $15. 

 

Options are: S + 0 (default option)

                    M + $10

                    L  + $10

                   XL + $20

 

I need to change the Mediums and larges to $25 and the xl to $33.

 

-----------------------------------------------------------------------------------

 

I also have purple shirts that are more expensive $20 with more expensive options.

 

Options are: PS + 0 (default option)

                    XL + $20

                   XXL + $20

                   XXXL + $40

 

I need to change the XL AND XXL to $35 and the XXXL to $43.

***********************************************************************************

 

So, I look at my database and I've found the options_values_price. This is associated separately with every product. I need to change the attribute price for each product in bulk, but not every product. I need to only do the red, green and yellow shirts at one price and the purple shirts at another. 

 

I am hoping I am just over complicating a simple matter, but I can't wrap my head around how to do this.

I'm guessing I could do this (with some additions): 

update `products_attributes` set `options_values_price` = `options_values_price`

but this would just change all the options prices, not differentiate from the two different products options prices. 

[Rachael w.]

well I found this:

UPDATE products_attributes

SET options_values_price = '16'
WHERE (options_values_price) = '19'

However, its only going to change the price from one # to another #. Some products need to go higher than others. So can I set it to the category of the product or something to differentiate those products to be changed?

[Rachael w.]

Nobody knows?

 

I've come up with this: 

UPDATE products_attributes 
SET options_values_price = 35.0000 
where options_values_id = 2;

I've made a list of the options and their corresponding values_id. 

 

Option_values_id #2 is named purple shirt large.

 

I would like this sql statement to change the options on all products with the option_values_id of 2 (purple shirt large) from $17.50 to $35.00.

 

I hate to run the query without someone looking at it for me and confirming it would work without messing up the entire sites option structure.