Applying Attribute Value prices Globally.

Hi,

Is there anyway I can price attribute values globally?

For example:-

I have around 150 products which can have a Plaque applied to them.....

I have an Option Name called:-

'Plaque Type'

and attribute values like :-

'Gold Finished Aluminum Plaque'
**
'Brass Plaque' **
**
etc.**

Obviously these also vary in price.

I want to know if I can change the price of an attribute value globally in Zencart , so the new price would be applied to every item that uses that specific attribute value, rather than having to go through my 150+ products and change the prices individually again

Im Using version Zencart v1.3.9h

Many Thanks,

Sushi

Do all your values priced the same???

What i am asking if you have Gold Finished Aluminum Plaque = $6
have you created another attribute that uses the same price???

Yes we will have the same attribute on other products that has the same price.

Back up your database first....
I always perform this on the test site first to see the changes..
If the .sql does not work properly, you can use the backup database to fix..

You will have to first find the options name id first..
To find this:
admin panel/ catalog/ option names/ on the left column you see ID and numbers below..

Lets say you have Gold Finished Aluminum Plaque with a price of $4.

So if Gold Finished Aluminum Plaque has an id of 3 and you want to change the price to $8

UPDATE products_attributes SET options_values_price='8.00' WHERE options_values_id ='3';

Then, go to the Tools ... Store Manager ... and run the:

Update All Products' Attribute Sort Orders
to match Option Value Default Sort Orders: Update

Correction to some wording:

So if Gold Finished Aluminum Plaque has an id of 3 and you want to change the price to $8

I should of said:

So if Plaque Type has an id of 3 and you want to change the price to $8

Cheers, haredo

will look into it.

Regards,

Sushi