Adding Extra Category Attributes – Magento

(this example is for a second category description)

eav_attribute table within magento install

attribute_id           leave blank (take note of this when you insert as you will need it at a later point)

entity_type_id      3

attribute_code     description_second

attribute_model   leave blank

backend_model   leave blank

backend_type      text

backend_table     leave blank

frontend_model  leave blank

frontend_input    textarea

frontend_label     Second Description

frontend_class     leave blank

source_model      leave blank

is_required           0

is_user_defined   0

default_value       leave blank

is_unique                              0

note                        leave blank

eav_entity_attribute table within magento install

create new row

entity_attribute_id              leave blank

entity_type_id      3

attribute_set_id   3

attribute_group_id              4

attribute_id           (the number from above that you needed to write down)

sort_order            (this is the position you want this to be displayed in the general information tab)

catalog_eav_attribute table within magento install

these setting depend on what you want the attribute to be displayed like – its either 1 for yes or 0 for no. I usually ensure that WYSIWYG is enabled you descriptions, otherwise it always depends on your preferences.

Clear the Cache and Index and you can now edit this in your category under general setting tab.

To make this visible on front end, you will need to add this code where relevant. This code general goes into template/catalog/category/view.php – if it’s for a bottom description it can be placed at the far bottom.

<?php echo $_category->getData(‘description_second’)?>

If the above steps do not work, compare between an attribute that is in the same section as you want it, for example compare Second Description to the attributes of Description, to ensure that it is all correct.