Mass Edit Attributes

[joshlfisher]

Can anyone help me with the syntax for this SQL Query?

I need to set options_values_price to 3.50 for every options_values_id that is equal to 1.

Thanks!

[Ajeh]

Backup your database before you do this ...

UPDATE products_attributes SET options_values_price = 3.50 where options_values_id = 1; 

This can be run in your Admin Tools ... Insert SQL Patches ...

Or, you can run it in phpMyAdmin ...

NOTE: if your tables use prefixes in your database then you will need to adjust the table name from options_values_id to something_options_values_id ...

[joshlfisher]

Thanks! Worked GREAT!