Updating Attribute Pricing

I need to add $1 to 2 option values, the problem is I have over 500 of those products, is there an easy way to add price to certain option values.

Any help will be appreciated :)

If you were to look at all of the options_id and options_values_id and checked their actual values in the products_attributes ... do you notice if all of them are the same for where you need to add the $1.00?

Does every single one of these need to have the $1.00 added to the Attributes Price ( the options_values_price field) when options_id = XX and options_values_id = YY ...

All the 2 attribute values need to have the $1.00 added to the Attributes Price ( the options_values_price field) when options_id = XX and options_values_id = YY ...

2 attributes values of the same attribute name on all products need to have this price added.

What are the values of the options_id and options_values_id in the products_attributes table for these attribute values?

for the first attribute value

options_id:96
options_values_id: 418

For the 2nd one:

options_id: 96
options_values_id: 419

Back up your database first ... then you should be able to use the following to increase the attribute price (options_values_price) by $1.00 for Option Name 96 and Option Value 418 on the table :

UPDATE products_attributes SET options_values_price = options_values_price + 1.00 WHERE options_id = 96 and options_values_id = 418;

Then adapt that as needed ...

Thanks for a great help Ajeh :) ,
makes my life easier !

You are most welcome ... thanks for the update that this will work for you ... :smile:

Oh wow - I'm going to have to save this thread in my favorites. This is something I'm going to need about every 6 months when new supplier catalogs are released.
Sure wish something like this was built directly into the attributes section.

Several of my products have "add-on" products (required to complete the main product although the customer may already have them) I have the add-ons setup as attributes. It would be nice to have the price tied into the attribute somehow and not the individual product so that when I edit a main attribute price, it updates it across all products that include that attribute.

Would there be a better way to setup the products than I have above? I need more than just a cross-selling or suggestive selling function as I need them to know that they NEED these additional products to complete the main product if they don't already have them.