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:

   Copy <?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:

   Copy <?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

   Copy <?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.