Bulk Edit: Used For Display Purposes Only

[blackhalo]

Hi guys, I really screwed up...

When I setup my product attributes (dropdown menu),
I overlooked the "Used For Display Purposes Only" feature,
and now people are choosing the wrong dropdown options!

Unfortunately, ZenCart seems to require this particular setting be configured manually, per product...
but I have too many products to do this, one at a time.

Is there a way I can edit this directly in the database, to speed up the process?

I'm semi-familiar with PHPMyAdmin...
I'm just curious if this would be a faster method, or if there's any other options?

I have to fix this asap!
Thanks for any tips.

[kobra]

I believe that the paid/commercial version of easy populate will handle that attribute entry

[Ajeh]

Set 1 Product correctly in the Admin to have the Display Only set right ...

Look in phpMyAdmin at the table:
products_attributes

Search for that products_id

What are the settings for:
options_id
options_values_id

where the
attributes_display_only

is set to 1

Do ALL of your Products need this particular Option Name/Option Value combo set to 1?

[blackhalo]

Thank you both for the tips...

I have EP Pro, but unfortunately the 'Attributes' aspect is very limited... (http://www.zencartbuilder.com/forums...ght=attributes)
that was a good idea tho Kobra, it hadn't occurred to me!

I managed to figure out what I needed in PHPMyAdmin (thank you Ajeh for pointing the direction)...
I'm not confident enough with writing SQL, so I just did it manually.

It was short work with Firefox' search/highlight feature and some "Page Down / 1" clicks...
not the most efficient, I know... but only took about 20 minutes.

Thanks again for the focus, both of you... problem solved!

[Ajeh]

Thanks for the update that you were able to fix this ...

[jenpen]

Ajeh, I find I have this problem too, across two sites.
I set up one product correctly then located it in products_attributes table. The options_id and options_values_id where the
attributes_display_only is set to 1 (twice) are 1 and 43, and 2 and 44. What do I do now? ALL of my products need this particular Option Name/Option Value combo set to 1. Jen

[Ajeh]

Backup your database ...

Then, just for the heck of it, backup your products_attributes table separately to another filename ...

In theory ...

to change all Attributes with options_id 1 and options_values_id 43 to have the attributes_display_only set to 1 use:

UPDATE products_attributes SET attributes_display_only = 1 WHERE options_id = 1 and options_values_id = 43;

to change all Attributes with options_id 2 and options_values_id 44 to have the attributes_display_only set to 1 use:

UPDATE products_attributes SET attributes_display_only = 1 WHERE options_id = 2 and options_values_id = 44;

See if that works for you ...

[jenpen]

Woohoo!!! Solved. Now I'll do the other site. Thank you, that really coulda been a headache.

[Ajeh]

Remember us fondly when you are rich and famous ...

[jenpen]

Ha ... in this profession?
But I have funded you guys a few coffees in the past.