Updating Attribute Pricing

[harry2cool]

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 :)

[Ajeh]

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

[harry2cool]

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.

[Ajeh]

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

[harry2cool]

for the first attribute value

options_id:96
options_values_id: 418


For the 2nd one:

options_id: 96
options_values_id: 419

[Ajeh]

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

[harry2cool]

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

[Ajeh]

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

[femsawyer]

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.