Home » Magento

Magento: How to delete System Attribute?

27 November 2009 4,672 views Popularity: 10% Share/Bookmark

0
email

Suppose, you want to delete an attribute. But there is no delete option while you edit the attribute. This means that the attribute is system attribute. System attributes cannot be deleted. Only user defined attributes can be deleted.

To delete the attribute, you have to make it user defined.

- Go to phpmyadmin
- Go to your magento installation database
- Go to eav_attribute table
- Browse table with attribute_code ‘YOUR_ATTRIBUTE_CODE’ OR browse the table with the attribute_id of your    attribute (‘your attribute’ means the attribute which you want to remove as system attribute)
- Edit the table row of your attribute
- Find the field ‘is_user_defined’
- Set it to 1

Now your attribute no longer remains System Attribute
Now you can delete it from Attribute manager

Related posts:

  1. Magento: How to select, insert, update, and delete data?
  2. Very simple add, edit, delete, display in PHP
  3. Magento: Adding attribute from MySql setup file
  4. Magento: How to delete / remove extension from MagentoConnect?
  5. Magento: How to get attribute name and value?
  6. Magento: How to search or filter by multiselect attribute in admin grid?
  7. Magento: How to get / filter all products by attribute value?
  8. Add, edit, delete, login, register in PHP :: A simple and complete tutorial
  9. Magento: Create, read, delete cookie
  10. jQuery: Grey out background and preview image as popup
  • Ruben

    It’s a effective solution but what can be the potential problems by doing this?
    Magento use some of this attributes in is core.
    Maybe by making the attribute disabled in the backend, the solution work without any troubles.

    Cheers

  • http://www.professionalblogger.com.br/ Diego Soares

    Nice article, I was trying to remove some fields from a disabled module. When I set is_user_defined to 1 my problems were solved.

    Thanks,

    Diego Soares

  • Kyle

    THANK YOU!

  • http://www.car-flags.eu/ Matthias

    After changing is_user_defined, the attribute does not appear in Magento 1.4.1.0.

    Any suggestions?

  • Jerry

    Thank you. Very helpful