Adding an attribute to all products using SQL command?

[arniesbarmyarmy]

Hi, I would like to add a "Please select ..." as an attribute. I can do this for one product easily but i have hundreds of products that i would like to add this to. So I was wondering if there was a quick way of doing this? Perhaps an SQL command?

The sort of procedure that I want to do is:
- if the product has an attribute for size
- then add the "please select" option
- set Used for Display Purposes Only = YES
- set Default Attribute to be Marked Selected = YES

any suggestions would be much appreciated.. thanks

[Ajeh]

Backup your database ...

Did you back it up?

If you did not back it up ... you will be doomed ...

Now that you have backed up your database ... go to the Catalog ... Option Values Manager ...

Down at the bottom of the screen, just above the last grey box you will see the instructions:

Copy Option Name/Value to Products with existing Option Name ...
Select an Option Name and Value that currently exists on a product or products to add to all products or to only the products in the selected category that have the selected Option Name.
Example: Add Option Name: Color Option Value: Red to all Products with Option Name: Size
Example: Add Option Name: Color Option Value: Green with default values from Products ID: 34 to all Products with Option Name: Size
Example: Add Option Name: Color Option Value: Green with default values from Products ID: 34 to all Products with Option Name: Size for Categories ID: 65

Let's say I have an Option Name: Size and I want to add the Option Value Please Select to all Option Name Size ...

Pick from the first dropdown set:
Option Name to add: Size
Option Value to add: Please Select

Option Name to add to: Size

Leave set to the Radio Button: Ignore existing attributes and add only new attributes

And then, as you have backed up your database first, hit Insert ...

This will add that new Option Value for Size to all Products that have at least 1 Attribute for Option Name: Size ...

Nifty eh?

Now, to set the settings for that to be Default and Display Only, you need to get the options_id and options_values_id from the products_attributes table ... and you can learn the rest of the story ...

[arniesbarmyarmy]

Thank you so much for the advice!! It all worked perfectly, which has saved me a lot of time!

In case anyone would like to know, the SQL query I used was:

UPDATE products_attributes SET attributes_display_only = 1 WHERE options_values_id = 56; (Where the 56 is the ID for the "Please select" option)


Thanks Linda, much appreciated!

[Ajeh]

Some bunny is reading between the lines ...

Thanks for the update and posting ... the rest of the story ...