Magento – How to get list of all subcategories which are set “Include in Navigation Menu” as no

categorymenunavigation

I have tried to get all sub categories which are not include in navigation menu but those are being active, of current category in list page.

$children = Mage::getModel('catalog/category')->getCategories(10); //10 current category id

Even this category collection also return only subcategories which are include in navigation menu.

How to get category which isn't include in navigation menu?

Best Answer

Try this:

$collection = Mage::getResourceModel('catalog/category_collection')
    ->addAttributeToSelect('*')
    ->addAttributeToFilter('is_active', 1) //only active categories
    ->addAttributeToFilter('include_in_menu', 0) //only categories not included in menu
    ->addAttributeToFilter('parent_id', 10)//get only subcategories of the category with id 10
    ->addAttributeToSort('position')//sort by position
;

foreach ($collection as $category) {
    //do something with $category
}

Related Solutions

Magento – Get subcategories of parent category when FLAT categories enabled

$_category = Mage::getModel('catalog/category')->load(CATEGORY-ID);    
    $_categories = $_category
                    ->getCollection()
                    ->addAttributeToSelect(array('name', 'image', 'description'))
                    ->addIdFilter($_category->getChildren());

    foreach ($_categories as $_category):
       echo $_category->getName();
    endforeach;

Magento – How to add custom attributes as top navigation menu items

This may not be exactly what you need, and it will not work if you have a lot of attributes but it might help you.
I recommend you this free extension. It allows you to build custom product lists and add links to them in the main menu based on some rules. The rules are managed in the same way as you manage the catalog discount rules.
A full description on what it does and how can be found here.

So you have to create a rule for each attribute and each value of that attribute.
You might need to work a bit on it to group the menu items somehow.
Like I said, if you have a lot of attributes and a lot of values for them it may not work for you.

Best Answer

Related Solutions

Magento – Get subcategories of parent category when FLAT categories enabled

Magento – How to add custom attributes as top navigation menu items

Related Topic