Let's talk Contact us. No cost. No obligation.

Fill out this form and we will contact you with in 24 hrs.




Knowledge Base

Magento Remove Super Attribute from Configurable Product

April 22, 2014

Sometimes we need to remove the Attribute from already build Configurable product. As it seem like a slightly tough process, it is yet achievable by removing it from MYSQL Raw Query. Although it is against the ‘Standard’ but works like a charm when required.

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

DELETE FROM catalog_product_super_attribute WHERE attribute_id = “attribute ID which should be removed”

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

About Tarun Vishnoi

Software Professional with around six years of experience in software industry. My area of expertise includes:- Php, Mysql, Magento, Joomla, Wordpress, Ajax, JQuery, Javascript, Json.