How to mass edit the attribute flags?

[Yuchant]

I need all my attributes to have a "display only" flag on their first choice. is there any way to edit these display flags per product in an easy populate like way?

I dont see any global options to make all option value X display only. Thanks!

[Yuchant]

I need all my attributes to have a "display only" flag on their first choice. is there any way to edit these display flags per product in an easy populate like way?

I dont see any global options to make all option value X display only. Thanks!

I decided to hit every product and set the flag. but thats 300 clicks or so. there must be a better way! ! : (

[Ajeh]

You need to know what the fields are for:
options_id
options_values_id

Then you can set the field:
attributes_display_only

to 1 for being Display Only YES ...

Be sure that you backup your database first and you can use something like:

UPDATE products_attributes SET attributes_display_only = 1 WHERE options_id = XX and options_values_id = YY; 

This can be run in the Tools ... Insert SQL Patches ...

[Yuchant]

Thank you so much. You can solve everything!

[Ajeh]

You are most welcome ...