Magento – Get product collection by root category and all its subcategories in Magento 2

categorycollection;magento2product

How can I retrieve a product collection by a root category and from all its subcategories?

Eg:

Root Category (2 products)

Subcategory 1 (2 products)
Subcategory 2 (3 products)

So I want to retrieve all 7 products in the collection.

Best Answer

You can use like this:

/** \Magento\Catalog\Api\CategoryRepositoryInterface */
protected $categoryRepository;

/** \Magento\Catalog\Model\ResourceModel\Product\CollectionFactory */
protected $productCollectionFactory;

public function getAllProductOfSubcategories($categoryId, $storeId = null) {

    /** @var $result \Magento\Catalog\Model\ResourceModel\Product\Collection */
    $result = $this->productCollectionFactory->create();

    //get category at $storeId 
    try {
        $category = $this->categoryRepository->get($categoryId, $storeId);
    } catch (\Magento\Framework\Exception\NoSuchEntityException $noSuchEntityException) {
        return null;
    }

    return $result->addCategoryFilter($category);
}

*Note: Your category must Enable Anchor

*Note: run php bin/magento indexer:reindex just for make sure

Related Solutions

Magento – Product Collection for Subcategories of Subcategories

From what I understood you need all the categories that have a certain level, independently of their parent category.

If I got it right, try this:

$categories = Mage::getModel('catalog/category')->getCollection();
$categories->addAttributeToFilter('level', 4);
$categories->addAttributeToFilter('is_active', 1);

This is how you know what level value you need to use.
0 - Root of all roots (not visible in the backend)
1 - Catalog Root
2 - top level categories
3+ - go lower in the category tree.

If you need only the X level categories from a certain root category add these lines to the ones above:

Let's assume that your 'Products' category id is $mainId.

$rootId = Mage::app()->getStore()->getRootCategoryId();
$path = '1/'.$rootId.'/'.$mainId.'/'; //the slash at the end is very important.
$categories->addPathsFilter($path);

Magento – How to do a list with all categories and subcategories, from a given main-category

Try this.

Assume the ID of category "All Brands" is 3

    $parentCategoryId = 3;
    $childCategories = Mage::getModel('catalog/category')->getCategories($parentCategoryId);

  foreach ($childCategories as $child) {
        echo 'Name : ' . $child->getName() . '<br>'; // will print the sub category name
        echo 'Url : ' . $child->getRequestPath() . '<br><hr>'; // will print the URL
    }

NOTE: If you want to get more info about the sub category use below lines inside above foreach() loop.

$subCatData = $child->getData();

It will get an array of sub category data.

EDIT:

If you are in the category page you can get the current category ID by using below line of code. (instead of hard-coding the category ID use this way)

$ccurrentCategoryId = Mage::getSingleton('catalog/layer')->getCurrentCategory()->getId();

So now the code would be as follows in your scenario.

 $parentCategoryId = Mage::getSingleton('catalog/layer')->getCurrentCategory()->getId();
        $childCategories = Mage::getModel('catalog/category')->getCategories($parentCategoryId);

      foreach ($childCategories as $child) {
            echo 'Name : ' . $child->getName() . '<br>'; // will print the sub category name
            echo 'Url : ' . $child->getRequestPath() . '<br><hr>'; // will print the URL
        }

Best Answer

Related Solutions

Magento – Product Collection for Subcategories of Subcategories

Magento – How to do a list with all categories and subcategories, from a given main-category

Related Topic