Delete all product attributes magento

Delete all product attributes magento

August 19, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Delete all product attributes magento

Removing All Product Attributes in Magento Efficiently

As an e-commerce developer, you may sometimes need to remove all product attributes from your Magento store, especially when dealing with extensive multi-select or dropdown options that have accumulated over time through imports. This process involves deleting attribute options as well as the respective attributes themselves.

Understanding the Attribute Delete Process

Magento stores product attributes in two main tables: catalog_eav_attribute and eav_attribute. Additionally, the attribute options are stored in the catalog_eav_attribute_option_value table for multi-select or dropdown types. To completely remove all attributes:

  1. First, delete the attribute options.
  2. Then, delete the actual attributes.

Deleting Attribute Options in Bulk

The most efficient way to delete a large number of record sets is by using MySQL’s DELETE statement with a subquery to identify the rows to be deleted. However, it’s crucial not to execute raw SQL queries directly on production databases without proper backup and testing.

First, create a backup of your database:

mysqldump -u [username] -p[password] [database_name] > backup.sql

Then, use the following prepared statement to delete attribute options in bulk. Replace [attribute_id] with the ID of the attribute you want to remove.

DELETE FROM catalog_eav_attribute_option_value WHERE option_id IN (
    SELECT eao.option_id
    FROM catalog_eav_attribute as eaa
    JOIN eav_attribute as ea ON eaa.attribute_id = ea.attribute_id
    JOIN catalog_product_entity AS cpe ON eaa.entity_type_id = cpe.entity_type_id
    JOIN catalog_eav_attribute_option_value AS eao ON eaa.option_id = eao.option_id
    WHERE eaa.attribute_id = [attribute_id]
);

Deleting Attributes from the Database

After removing the options, delete the actual attributes using a similar approach targeting the catalog_eav_attribute and eav_attribute tables.

DELETE FROM catalog_eav_attribute WHERE attribute_id = [attribute_id];
DELETE FROM eav_attribute WHERE attribute_id = [attribute_id];

Deleting Attributes Through Magento’s API

For a more secure and controlled deletion process, you can use Magento’s SOAP or REST API to delete attributes programmatically. This method ensures that the changes are logged and can be reverted if needed.

To learn more about Magento’s API endpoints for attribute management, visit our guide on working with Magento APIs at Laravel Company.

Testing Your Changes

After executing these SQL statements or API calls, always verify that the attributes and options have been correctly removed. You can do this by checking the database tables manually or reloading your store’s product edit pages.

Conclusion

Deleting all product attributes in Magento involves a two-step process: first removing the attribute options and then deleting the actual attributes from the database. It’s essential to backup your data before performing these operations and to test them thoroughly on staging environments before applying them to production stores.

If you’re looking for more advanced techniques or need assistance with custom Magento development, feel free to reach out to our team of expert developers at Laravel Company. We specialize in delivering high-quality e-commerce solutions tailored to your business needs.

Catalog Database Import/Export

Our network