Creating category attribute

$installer = $this;

$installer->startSetup();

$entityTypeId     = $installer->getEntityTypeId('catalog_category');

$attributeSetId   = $installer->getDefaultAttributeSetId($entityTypeId);

$attributeGroupId = $installer->getDefaultAttributeGroupId($entityTypeId, $attributeSetId);

$installer->addAttribute('catalog_category', 'new_cat_attrb',  array(

    'type'     => 'int',

    'label'    => 'New Category Attribute',

    'input'    => 'text',

    'global'   => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,

    'visible'           => true,

    'required'          => false,

    'user_defined'      => false,

    'default'           => 0

));

$installer->addAttributeToGroup(

    $entityTypeId,

    $attributeSetId,

    $attributeGroupId,

    'new_cat_attrb',

    '11'                    //last Magento's attribute position in General tab is 10

);

$attributeId = $installer->getAttributeId($entityTypeId, 'new_cat_attrb');

$installer->run("

INSERT INTO `{$installer->getTable('catalog_category_entity_int')}`

(`entity_type_id`, `attribute_id`, `entity_id`, `value`)

    SELECT '{$entityTypeId}', '{$attributeId}', `entity_id`, '1'

        FROM `{$installer->getTable('catalog_category_entity')}`;

");

//this will set data of your custom attribute for root category

Mage::getModel('catalog/category')

    ->load(1)

    ->setImportedCatId(0)

    ->setInitialSetupFlag(true)

    ->save();

//this will set data of your custom attribute for default category

Mage::getModel('catalog/category')

    ->load(2)

    ->setImportedCatId(0)

    ->setInitialSetupFlag(true)

    ->save();

$installer->endSetup();







config file script:

<resources>

    <new_attribute_csv_setup>

      <setup>

        <module>New_Attribute</module>

        <class>Mage_Catalog_Model_Resource_Eav_Mysql4_Setup</class>

      </setup>

      <connection>

        <use>core_setup</use>

      </connection>

    </new_attribute_setup>

    <new_attribute_setup_write>

      <connection>

        <use>core_write</use>

      </connection>

    </new_attribute_setup_write>

    <new_attribute_setup_read>

      <connection>

        <use>core_read</use>

      </connection>

    </new_attribute_setup_read>

</resources>

How to create new category attribute in magento

Write below in your sql setup file in magento module
example file : mysql4-upgrade-0.2.8-0.2.8.1.php

$installer = $this;
/* @var $installer Mage_Catalog_Model_Resource_Eav_Mysql4_Setup */

$installer->startSetup();
// add category attributes for sub categories of coourse categories
$installer->addAttribute('catalog_category', 'new_category_attribute', array(
                        'group'    => 'General Information',
'type'              => 'int',
                        'backend'           => '',
                        'frontend'          => '',
                        'label'             => 'New attribute label here',
                        'input'             => 'select',
                        'class'             => '',
                        'source'            => 'eav/entity_attribute_source_boolean',
                        'global'            => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
                        'visible'           => true,
                        'required'          => false,
                        'user_defined'      => false,
                        'default'           => '',
                        'searchable'        => false,
                        'filterable'        => false,
                        'comparable'        => false,
                        'visible_on_front'  => false,
                        'unique'            => false,
                    ));
$installer->endSetup();

How to update product attribute code in magento

$installer = $this;
$installer->startSetup();
$installer->updateAttribute('catalog_product', 'old_attribute_code', array('attribute_code' => 'new_attribute_code'));
$installer->endSetup();

Script:

<?php
$write = Mage::getSingleton('core/resource')->getConnection('core_write');
$write->query("
  UPDATE eav_attribute val
  SET  val.attribute_code = "SET VALUE WHAT YOU WANT"
  WHERE  val.attribute_id = (
     SELECT attribute_id FROM eav_attribute eav
     WHERE eav.entity_type_id = 4
       AND eav.attribute_code = 'your-product-attribute-code'
    )
");

How to Update category attribute code in magento ?

$installer = $this;
$installer->startSetup();
$installer->updateAttribute('catalog_category', 'old_attribute_code', array('attribute_code' => 'new_attribute_code'));
$installer->endSetup();

Script:

<?php
$write = Mage::getSingleton('core/resource')->getConnection('core_write');
$write->query("
  UPDATE eav_attribute val
  SET  val.attribute_code = "SET VALUE WHAT YOU WANT"
  WHERE  val.attribute_id = (
     SELECT attribute_id FROM eav_attribute eav
     WHERE eav.entity_type_id = 3
       AND eav.attribute_code = 'your-category-code'
    )
");

How to get sub-categories of a specific parent category?

<?php 
$parentCategoryId = 107;
$cat = Mage::getModel('catalog/category')->load($parentCategoryId);
$subcats = $cat->getChildren();

?>

// Get 1 Level sub category of Parent category.

<?php 

foreach(explode(',',$subcats) as $subCatid)
              {
                $_category = Mage::getModel('catalog/category')->load($subCatid);
  if($_category->getIsActive()) {
    echo '<ul><a href="'.$_category->getURL().'" title="View the products for the "'.$_category->getName().'" category">'.$_category->getName().'</a>';
   echo '</ul>';
  }
}

?>

// Get 2 Level sub category of Parent sub category

<?php 
foreach(explode(',',$subcats) as $subCatid)
{
  $_category = Mage::getModel('catalog/category')->load($subCatid);
  if($_category->getIsActive()) {
    echo '<ul><a href="'.$_category->getURL().'" title="View the products for the "'.$_category->getName().'" category">'.$_category->getName().'</a>';
    $sub_cat = Mage::getModel('catalog/category')->load($_category->getId());
    $sub_subcats = $sub_cat->getChildren();
    foreach(explode(',',$sub_subcats) as $sub_subCatid)
    {
          $_sub_category = Mage::getModel('catalog/category')->load($sub_subCatid);
          if($_sub_category->getIsActive()) {
              echo '<li class="sub_cat"><a href="'.$_sub_category->getURL().'" title="View the products for the "'.$_sub_category->getName().'" category">'.$_sub_category->getName().'</a></li>';

 }
     }
     echo '</ul>';
  }
}
?>

// Get 3 Level sub sub category of Parent sub sub category

<?php 
foreach(explode(',',$subcats) as $subCatid)
{
  $_category = Mage::getModel('catalog/category')->load($subCatid);
  if($_category->getIsActive()) {
    echo '<ul><a href="'.$_category->getURL().'" title="View the products for the "'.$_category->getName().'" category">'.$_category->getName().'</a>';
    $sub_cat = Mage::getModel('catalog/category')->load($_category->getId());
    $sub_subcats = $sub_cat->getChildren();
    foreach(explode(',',$sub_subcats) as $sub_subCatid)
    {
          $_sub_category = Mage::getModel('catalog/category')->load($sub_subCatid);
          if($_sub_category->getIsActive()) {
              echo '<li class="sub_cat"><a href="'.$_sub_category->getURL().'" title="View the products for the "'.$_sub_category->getName().'" category">'.$_sub_category->getName().'</a></li>';
              $sub_sub_cat = Mage::getModel('catalog/category')->load($sub_subCatid);
              $sub_sub_subcats = $sub_sub_cat->getChildren();
              foreach(explode(',',$sub_sub_subcats) as $sub_sub_subCatid)
              {
                $_sub_sub_category = Mage::getModel('catalog/category')->load($sub_sub_subCatid);
                if($_sub_sub_category->getIsActive()) {
                    echo '<li class="sub_cat"><a href="'.$_sub_sub_category->getURL().'" title="View the products for the "'.$_sub_sub_category->getName().'" category">'.$_sub_sub_category->getName().'</a></li>';
                }
              }
           }
     }
     echo '</ul>';
  }
}

?>



If you want 4th, 5th,.... or n level category and so on sub categories than simple add this script.
Note:- For n level category please use recursion


<?php 

 // $sub_subCatid this is sub category id . means if you want 4 level than it will take 3 level subcategory Id.

 $sub_sub_cat = Mage::getModel('catalog/category')->load($sub_subCatid);
              $sub_sub_subcats = $sub_sub_cat->getChildren();
              foreach(explode(',',$sub_sub_subcats) as $sub_sub_subCatid)
              {
                $_sub_sub_category = Mage::getModel('catalog/category')->load($sub_sub_subCatid);
                if($_sub_sub_category->getIsActive()) {
                    echo '<li class="sub_cat"><a href="'.$_sub_sub_category->getURL().'" title="View the products for the "'.$_sub_sub_category->getName().'" category">'.$_sub_sub_category->getName().'</a></li>';
                }
              }

?>