Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

In Magento, is there a way to remove attribute from configurable product after already created?

In Magento, I have have a bunch of configurable products already created and now have a client that has changed their mind and wants to remove one of the attributes. I'm having a hard time figuring out how to do this b/c I keep getting an error message saying:

This attribute is used in configurable products. You cannot remove it from the attribute set.

I have tried going into the attribute and changing Use to Create Configurable Product from "yes" to "no", but that didn't seem to do anything when trying to remove attribute from existing products

like image 648
veilig Avatar asked Mar 13 '11 18:03

veilig


People also ask

How do I edit a configurable product in Magento 2?

Log in to the Admin Panel, go to Products>Catalog, preselect the needed Magento 2 configurable product from existing simple products or press Create New Attribute to get a new one.. Once it's set up, click the Add Configurations (if a configurable is just created) or Edit Configurations option.

How do I change the attributes in Magento 2?

To change the product attribute set in Magento, log in to the admin panel and go to Catalog > Manage Products. Select the needed Magento products and choose Change Attribute Set from the Action dropdown right on the grid.


1 Answers

To remove one super product attribute (as they are called) from all configurable products, you could execute this SQL query in the database:

DELETE FROM catalog_product_super_attribute
WHERE attribute_id = <id>

The table catalog_product_super_attribute links products to super product attributes. You can add and remove attributes to created configurable products there.

like image 163
Christian Davén Avatar answered Oct 06 '22 00:10

Christian Davén