Updating an Attribute Price Globally

I've done some search on the forum before posting but I still need a certain answer for this.

From what I read I understood that this can only be done by altering the SQL? No option available in the admin for that, correct? If so, I've got my answer, thanks!

I know that I could easily use copy attribute to categories but my products do not contain the same attributes...its quite specific for each product so doing it that way is a no-go.

P.S., is there an option in the admin that makes attributes sort by price?

This is something I'd really like to be able to do.

I have set up categories with 3 products in each, a small, medium and large. Each of these products has 1 or 2 attributes. (Dependant attributes would've been great, but at the moment I had to set it up like this).

The price for the attributes is the same for all "Small" products, all "Medium" products, etc. It would be fantastic to be able to set a price for each Option Value as it would avoid going through each product in turn.

Any ideas or thoughts on if this is possible would be great. :smile:

Set up a Product with the Attributes and Prices manually ...

Browse, via phpMyAdmin, the products_attributes table and look for the values in:
options_id
options_values_id

Once you can identify the Option Name and Option Value, you could run a SQL command to update the prices ...

Backup your database before attempting this or you will be doomed ... :eek:

UPDATE products_attributes SET options_values_price = XX.XX WHERE options_id = YY and options_values_id = ZZ;

where XX.XX is the Price for the Attribute and YY is the Option Name (options_id) for Size and ZZ is the Option Value (options_values_id) for Small ...