Category – Get Not Include_in_menu or Disabled

categoryce-1.9.0.1menu

On my start page I have a product slider block where I show categories. Now I would like to have a category that is not in the menu but in the slide.

Problem is that if disable the category of set include_in_menu to false I don't get the category in the slider. Here is the slider query:

    $_helper = Mage::helper('catalog/category');
    $children = $_helper->getStoreCategories(false, true, false)
        ->addAttributeToSelect('product_slider')
        ->addAttributeToFilter('product_slider', array('neq' => ''))
        ->addAttributeToFilter('path', array('like' => "1/{$rootCategoryId}/%"))
        ->addOrderField('product_slider')
        ->addOrderField('name');

How do I get a catgory with include_in_menu = false.

Best Answer

PiTheNumber you cannot get include_in_menu category using this code... try this

 $category=Mage::getModel('catalog/category')->load(Mage::app()->getStore()->getRootCategoryId());
$children = Mage::getResourceModel('catalog/category_collection)->addAttributeToSelect('url_key')
            ->addAttributeToSelect('*')
            ->addAttributeToSelect('all_children')
            ->addAttributeToFilter('is_active', 1)
            ->addIdFilter($category->getChildren())
            ->setOrder('position', Varien_Db_Select::SQL_ASC)
            ->joinUrlRewrite()
            ->load();

Related Solutions

Magento – How do display category icons/images when top-level category is selected

if you are in the category view page you can do the following.

$mainCategory = Mage::registry('current_category');
foreach ($mainCategory->getChildrenCategories() as $category){
    $collection = $category->getProductCollection()->addAttributeToSelect('image');//or thumbnail or small_image
    Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($collection);
    Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($collection); 
    $collection->addAttributeToSort('position');//or 'name' or any other attribute
    $product = $collection->setPage(1, 1)->getFirstItem();
    if ($product->getId()){//if the category has at least a valid product
       $imageUrl = Mage::>helper('catalog/image')->init($product, 'image')->resize(60);
       //do something with $imageUrl
    }
}

Magento 1 – How to Get Disabled Category Collection

I had the same problem as you:

I was passing the following into the addIdFilter:
$category->getChildren();

Internally, getChildren() as well as getAllChildren() use Mage_Catalog_Model_Resource_Category::getChildren() which explicitly joins the is_active attribute and returns ids of active children only.

But the resource model also has a getChildrenIds() method which does not add this join. Also it conveniently returns a comma separated list by default.

Solution

Replace

$categoryCollection->addIdFilter(explode(',', $parentCategory->getChildren()));

with

$categoryCollection->addIdFilter(
    $parentCategory->getResource()->getChildrenIds($parentCategory)
);

Best Answer

Related Solutions

Magento – How do display category icons/images when top-level category is selected

Magento 1 – How to Get Disabled Category Collection

Solution

Related Topic