I want to update an attribute on multiple products

To save me having to manually change an attribute on 300+ ads can anybody tell me how i can just update a single attribute on all ads. I have tshirts and I want to charge £1.50 fr XXl sizes. Now all the t shirts have differing attributes including size variations thats why I want to update a single attribute. Does that makes sense?

For this Attribute, what are the:
options_id
options_values_id

and you want ALL products_attributes that are using these values to be set to:
1.50

correct?

Size
xl

yes

Go to the Option Name Manager ... what is the value for the ID on: Size

Go to the Option Value Manager ... what is the value for the ID on: xl

1

&

8

Assuming you mean that the options_id is 1 and the options_values_id is 8 ...

You could use:

UPDATE products_attributes SET options_values_price = 1.50 WHERE options_id = 1 and options_values_id = 8;

NOTE: backup your database before making changes like this ...

Ajeh:

Assuming you mean that the options_id is 1 and the options_values_id is 8 ...

You could use:

UPDATE products_attributes SET options_values_price = 1.50 WHERE options_id = 1 and options_values_id = 8;

> 
> NOTE: backup your database before making changes like this ...

Thank you, Ajeh! Just what I was looking for!! :D

Thanks for the update that this worked for you ... :smile: