I want to update an attribute on multiple products

[McGill]

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?

[Ajeh]

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?

[McGill]

Size
xl

yes

[Ajeh]

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

[McGill]

1

&

8

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