We use cookies to improve our services and provide a better experience. By continuing to use this site, you agree with our Cookies Policy.

Tutorials

More than 400 step-by-step articles to guide you through online project development.
HomeTutorialsCMS TutorialsMagentoMagento Administration

How to Remove System Attributes

cPanel KVM

By default, the system attributes cannot be removed from the Magento attributes management. They need to be removed manually. The easiest way to do this by editing specific rows in the Magento database.

Follow these steps to remove system attributes

Login to Magento admin pane and navigate to “Catalog>Attributes>Manage Attribute Sets”.

Manage attribute sets

There you will find current product attributes.

Magento attributes list

Click on, for example, “Cell Phones” to explore its attributes. There you will find a list of attributes sorted by groups.

Magento attributes groups

If you attempt to delete any selected group, an error will pop up, saying “this group contains system attributes”. Therefore, it cannot be removed as long as it contains system attributes.

To make an attribute non-system you will need to log in to the database and edit the records in the “eav_attribute” table. If you’re not sure what the database details are, check the “app/etc/local.xml” file, which stores the database name, username and password.

Once connected, click on the Magento database to view its tables. In the table list, find the one named “eav_attribute” and click it to see its rows. To find a specific attribute you should look at the “attribute_code” column.

To make the process faster, you can use search that is located in the top menu of phpMyAdmin. This way you will be able to search for an attribute’s name in theĀ “attribute_code” column.

Finally, go back to Magento attribute manager and delete the attribute group whose attributes you have just set as non-system. You should now be allowed to delete them.

This is how you can customize Magento attributes to your requirements. All it takes is to edit a particular database table record in order to make the attribute non-system.

KVM VPS
Rate this Tutorial:
3 Comments Leave a Comment
  1. Kane

    Thanks for the article, but you left out the most important part of step 3.. WHAT to do.

    Once you’re in the database table “eav_attribute”
    Located the row(s) for the attributes you want to remove.
    Edit each row and change the value of “is_user_defined” from 0 to 1.
    (0 means it’s a system attribute, 1 means it’s a user/custom attribute.)

    Now you can delete the attributes through Magento’s backend by going to
    Catalog > Attributes > Manage Attributes
    Open the attribute(s) you want to delete.
    Click the “Delete Attribute” button.

    Hope this helps someone.
    Kane

    Reply
    • BIkash Kaushik

      Is there any problem if I delete all those rows related to those attributes directly.

      Reply
      • TobiasJ

        If you don’t want to delete the attribute itself and just want to disable it for some attribute sets you can set “is_user_defined” to ‘1’ via phpmyadmin (or other database management tools). Then you can simply remove it from the attribute set.

        Reply
Leave a Comment