Global Attribute Price

I offer free shipping in the US for many of my products but charge for international shipping. Right now, I have it set with the option name as "International S&H " and the option value as "Add For Mailed International Orders". Every year, when the Post Office raises their rates, I'm forced to update every affected product.
I tried copying the attributes from one product to another but apparently the pricing soes not copy.

Is there any way to globally set the price of an option value so I can update the whole cart without having to open each products attribute controller and entering the new price?

this thread might get you on the right track ...

http://www.zen-cart.com/showthread.php?188895-Global-changes-to-Attribute-price

Thanks!

Yes, that seems to indicate an easier way to do it but unfortunately the OP simply stated that he figured it out without posting any details. I hate it when people do that. :(

If you want to update ALL Attributes with a specific options_id and options_values_id to a new Price with XX.XX is what to add to the current price and YYY is the Option Name ID and ZZZ is the Option Value ID you can use:

UPDATE products_attributes SET options_values_price = options_values_price + XX.XX WHERE options_id = YYY and options_values_id = ZZZ;

I finally finished updating everything manually but will file this away for next year. I promised my son I would never attempt playing with the database again (grin) so when they change the postage rates next year, I'll know what to ask him to do.
Thank you!

Phil,
Before you ever make a change to the database just use the cpanel to make a backup of it, so if you mess it up you can reload the original ...

You're suggesting I break a solemn vow and risk the wrath of he who provides me with free web hosting???

No.....I'm thinking I'm better off simply turning in a support ticket along the line of, "Hey, I'm smoking a whole Rib-Eye tomorrow and if you could take care of this small problem for me before you come over...." :)