Posted over 5 years ago. Visible to the public.

Add Category Attributes Through SQL Updates

This is creating a module which will update categories to include new attributes.

  1. inside app/etc/modules/yourmodule.xml put the following:

    <?xml version="1.0"?> <config> <modules> <Yourmodule_Sql> <active>true</active> <codePool>local</codePool> <Yourmodule_Sql> </modules> </config>
  2. Next, inside app/code/local/Yourmodule/Sql/etc/config.xml put the following:

    <?xml version="1.0"?> <config> <modules> <Yourmodule_Sql> <version>0.1.0</version> </Yourmodule_Sql> </modules> <global> <resources> <yourmodule_sql_setup> <setup> <module>Yourmodule_Sql</module> <class>Mage_Catalog_Model_Resource_Setup</class> </setup> </yourmodule_sql_setup> </resources> </global> </config>
  3. Next, your install script here: app/code/local/Yourmodule/Sql/sql/yourmodule_sql_setup/install-0.0.1.php

    <?php $this->startSetup(); $this->addAttribute('catalog_category', '[attribute code]', array( 'group' => 'General Information', 'type' => 'int', // can be int, varchar, decimal, text, datetime 'backend' => '', // If you're making an image attribute you'll need to add : catalog/category_attribute_backend_image 'frontend_input' => '', 'frontend' => '', 'label' => '[Attribute label here]', 'input' => '[attribute input here]', //text, textarea, select, file, image, multiselect 'class' => '', 'source' => '[source model for attribute]', // Only needed if using select or multiselect 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL, // Scope can be SCOPE_STORE, SCOPE_GLOBAL or SCOPE_WEBSITE 'visible' => true, 'frontend_class' => '', 'required' => false, // or true 'user_defined' => true, // or false 'default' => '', 'position' => 10, // Number depends on where you want it to display in the grid. )); $this->endSetup();
  4. Clear cache, refresh page and it should have it installed.

Owner of this card:

Last edit:
over 5 years ago
Posted by Simon to Magento
This website uses cookies to improve usability and analyze traffic.
Accept or learn more