Remove Attribute from all products?

I would like to remove an attribute from all products (600+) but I've run into an issue because it has a text value.

I see the option to remove an attribute from all categories but because the option value is a text box, it does not appear in the selection choices.

Is there a way to remove this option from all products without going through every product manually?

Thanks,
Jon

Like maybe with a PHP SQL patch or something?

(sorry to add this my last post was no longer able to be edited.)

In phpMyAdmin, test for:

SELECT from products_attributes WHERE options_id= XX and options_values_id =0;

where XX is the Options Name options_id ... are those the ones you want to delete?

The option ID is #65 and I want to remove it from all products.

There is no option value because it is text.

Backup your database first ...

After you have backed up the database ... run the command:

DELETE from products_attributes WHERE options_id= 65 and options_values_id =0;

Thanks. That worked perfectly.

is there a way just to remove the attributes from a particular section of items, i need to do this for my website http://mauricedoodysales.ie/
without wiping everything in it?

Thanks

NiallO58:

is there a way just to remove the attributes from a particular section of items, i need to do this for my website http://mauricedoodysales.ie/
without wiping everything in it?

Thanks

admin -> catalog -> Attributes Controller

at the top of the page you'll find a row of buttons (one of which is "Delete All"

Hi,

For one of my product categories, I have set no attributes for these products but It keeps asking my customers to select an attribute. when there is clearly 'No Attributes Defined for the Product'

The above thread suggest "Delete All" in
admin -> catalog -> Attributes Controller
But this category does not show the 'delete all' option.

Can anyone help please. You can experience the issue here at http://www.hairweavon.com/african-essence-weaves-shampoo-p-75.html

Thanks in advance

I had no problem adding that product to cart, a couple of times, with or without a product with attributes already in the cart.

I do notice an oddity in view source of the product with no attributes:```html

There should be nothing at all between the comments if there are no attributes.html

hi,

thanks for your reply, Unfortunately I am not very technical and cant edit source code. So you think this is a code error?

I deleted the attribute all together and created a new one and its still asking me to select a color (the old attribute). would I need to delet it from the database also?

That product did not ask me to select anything, so you need to find out why it is behaving that way for you. Such a thing should not be dependent on who is visiting.

If you did not edit any code, then someone else did. What mods do you have on your site affecting attributes? Who else has worked on your site?