Magento 1.9 – Get All Products of a Specific Category Without Child Categories

categorymagento-1.9product-collection

I want to get specific category product collection, not include it's child category product in it .

Below code which i have tried.

$category = Mage::getModel('catalog/category')->load(5);
 $getCollections = $category->getProductCollection()
         ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
         ->addAttributeToFilter('visibility', 4)
         ->addAttributeToSelect('*');

can any one please help me ?

Best Answer

Try this:

$category = Mage::getModel('catalog/category')->load(5);
$isAnchorFlag = $category->getIsAnchor();
$category->setIsAnchor(false);
$getCollections = $category->getProductCollection()
         ->addAttributeToSelect(Mage::getSingleton('catalog/config')->getProductAttributes())
         ->addAttributeToFilter('visibility', 4)
         ->addAttributeToSelect('*');
$category->setIsAnchor($isAnchorFlag);

Related Solutions

Magento – Products from a category plus any children and get category ID for conditions from collection

Okay, so I'm actually getting somewhere by building a completely different collection...

$category_id = 3;
$collection = Mage::getModel('catalog/category')->load($category_id)
    ->getProductCollection()
    ->addAttributeToSelect('*') // add all attributes - optional
    ->addAttributeToFilter('type_id', array('eq' => 'configurable'))
    ->addAttributeToFilter('visibility', array('in' => array(Mage_Catalog_Model_Product_Visibility::VISIBILITY_BOTH, Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_SEARCH, Mage_Catalog_Model_Product_Visibility::VISIBILITY_IN_CATALOG)))
    ->addAttributeToFilter('status', array('eq' => Mage_Catalog_Model_Product_Status::STATUS_ENABLED))
    ->addStoreFilter($storeId);

And then fetch the category ID's from the loaded products:-

$cats = $product->getCategoryIds();

And loop through (as @paj suggested in the comments) to get the category data for each:-

foreach ($cats as $category_id) {
        $category = Mage::getModel('catalog/category')->setStoreId(Mage::app()->getStore()->getId())->load($category_id);             
    }

I'm then able to get what I want for each product like:-

$category->getId()
$category->getName()

Meaning my required mapping works well:-

if ($category->getId()==10) {
    $cmap = 'Clothing > Trousers';
}

Magento – Get all products of a category only – without products of its child categories

Figured it out myself.

$category_id = Mage::getModel('catalog/layer')->getCurrentCategory()->getId();
$category = Mage::getModel('catalog/category')->load($category_id);
$products = Mage::getModel('catalog/product')
    ->getCollection()
    ->addAttributeToSelect('*')
    ->addCategoryFilter($category)
    ->setOrder('price', 'ASC')
    ->load();

you can also use for more than one category as bellow:

$categoryIds = array(2,4);//category id

$collection = Mage::getModel('catalog/product')
                             ->getCollection()
                             ->joinField('category_id', 'catalog/category_product', 'category_id', 'product_id = entity_id', null, 'left')
                             ->addAttributeToSelect('*')
                             ->addAttributeToFilter('category_id', array('in' => $categoryIds))

I hope this will help you.

Best Answer

Related Solutions

Magento – Products from a category plus any children and get category ID for conditions from collection

Magento – Get all products of a category only – without products of its child categories

Related Topic