Global Attribute Price

[Phil S]

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?

[haredo]

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

http://www.zen-cart.com/showthread.p...ttribute-price

[Phil S]

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.

[Ajeh]

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;

[Phil S]

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!

[haredo]

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 ...