Remove Attribute from all products?

[blindeyecreative]

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

[blindeyecreative]

Like maybe with a PHP SQL patch or something?

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

[Ajeh]

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?

[blindeyecreative]

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

There is no option value because it is text.

[Ajeh]

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;

[blindeyecreative]

Thanks. That worked perfectly.

[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

[clydejones]

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"

[HairWeavon]

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-es...mpoo-p-75.html

Thanks in advance

[gjh42]

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:

<!--bof Attributes Module -->

 <br>

<!--eof Attributes Module -->

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

<!--bof Attributes Module -->
<!--eof Attributes Module -->

Perhaps you modified the code for layout purposes? The <br> is not correct XHTML ( <br /> ) and thus not from the stock code.