Magento – get products from multiple categories

category-productsmagento-1.9product-collection

There is an array of category ids i.e. array(18,19,25);

I want to get those products which has all these categories from above array. Product should present in 18,19 and 25.

Array values can be anything i.e. category ids.

Best Answer

Let's Assume you have categoryIds Array

$categories = array(18,19,25);

First You have to do category join

$collection->joinField(
    'category_id', 'catalog/category_product', 'category_id', 
    'product_id = entity_id', null, 'left'
);

Now add simple IN condition of collection

$pCollection->addAttributeToFilter('category_id', array('in' => implode(',', $categories)));

Related Solutions

Magento – Get all Categories of Products in Category – PHP

If you have a ready collection of products, then you can get all the categories that include current products without any binding to the product ID:

 <?php
$cats = [];
/** @var Mage_Catalog_Model_Product $_product */
foreach ($_productCollection as $_product) {
    $curProductCats = $_product->getCategoryIds();
    if (empty($curProductCats) || !is_array($curProductCats)) {
        continue;
    }
    $cats += array_flip($curProductCats); // Use the category id as key & merge prev. result with current
}
var_dump($cats);
?>

This code will return you the array, where categories ID will be the keys. This is the easiest way. In addition, you can modify the code according to your requirements.

Note, that such a cycles can slow down page loading speed when you have a large database.

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';
}

Best Answer

Related Solutions

Magento – Get all Categories of Products in Category – PHP

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

Related Topic