Display Parent Category Products on Subcategory Page in Magento

categorycategory-productscategory-tree

Let's say I have a simple categories tree like this one :

Category 1
- Subcategory 1.1
- Subcategory 1.2
- …
- Subcategory 1.675

Some products should be visible for all subcategories, without having to manually select the 675 subcategories. I'd like to only assign these products to Category 1. Then, when I go to Subcategory 1.675 page, I should see products directly assigned to Subcategory 1.675, but also those assigned to Category 1.

How to get this behavior ? A module, or some custom code to change product listing query ?

Best Answer

I think an optimal solution for this would entail that a product collection for a given subcategory includes products belonging to its parent category, if the subcategory is flagged to allow such behavior.

Essentially, it comes down to adding an additional category (parent) filter to the product collection when you're on category 1.675, so that products in both 1 and 1.675 show up on. Here are the steps.

Create a category yes/no attribute. Something like include_parent_products/"Include parent products on display?". Once added, go to the category manage page for 1.675 and flag it yes.

Rewrite Mage_Catalog_Model_Layer::getProductCollection to load a modified collection if setting in step 1 is true.

$displayParentProducts = $this->getCurrentCategory()->getIncludeParentProducts();
if ($displayParentProducts) {
    $collection = $this->getCurrentCategory()->getProductCollectionIncludingParents();
} else {
    $collection = $this->getCurrentCategory()->getProductCollection();
}

Rewrite/Create a new method Mage_Catalog_Model_Category::getProductCollectionIncludingParents.

public function getProductCollection()
{
    $parentCategory = ...; // Find parent category
    $collection = Mage::getResourceModel('catalog/product_collection')
        ->setStoreId($this->getStoreId())
        ->addCategoryFilter($this)
        ->addCategoryFilter($parentCategory)
        ;
    return $collection;
}

With the above completed, category 1.675 will now display its products and its parent's as well.

Related Solutions

Magento Category Products – Sorting Products in Parent Category by Subcategories and Position

I've been trying to wrap my head around this for months and I've finally figured out what the problem is.

You need to make sure that every single product category has it's parent categories ticked also. For some reason, any higher categories than the sub are just added to the end of the collection (if the anchor is set). Here's a script I've written and placed into the shell folder so that it can be run manually or via cron:

<?php
/**     
 *
 * @category    Mage
 * @package     Mage_Shell
 * @copyright  Copyright (c) 2006-2017 X.commerce, Inc. and affiliates (http://www.magento.com)
 * @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 */

require_once 'abstract.php';

/**
 * Assign products to parent category
 *
 * @category    Mage
 * @package     Mage_Shell
 * @author      Liam McArthur <email-address@withdrawn.com>
 */
class Mage_Shell_Compiler extends Mage_Shell_Abstract {

    public function run() {

        $collection = Mage::getModel( 'catalog/product' )->getCollection()->addAttributeToSelect( '*' );

        foreach ( $collection as $product ) {

            $lastCategoryId = end( $product->getCategoryIds() );

            $category = Mage::getModel( 'catalog/category' )->load( $lastCategoryId );

            $ids = array();

            foreach ( $category->getParentCategories() as $parent ) {
                // Ignore root category
                if ( $parent->getId() != 2 ) {
                    $ids[] = $parent->getId();
                }
            }

            // Assign above categories to product
            $product->setCategoryIds( $ids );
            $product->save();
            echo $product->getSku() . " saved..." . PHP_EOL;

        }
    }

}

$shell = new Mage_Shell_Compiler();
$shell->run();

Magento 2.1 – Assign Products to Ancestor Categories Programmatically

There is a simple solution which Magento 2.x provides by default.

Go to Products > Categories.
Click on the (parent) category in which you want to show the products of the sub-category.
Under Display Settings, set Yes for Anchor field.
Save the category, flush Magento's cache and reindex.

Please let me know if the solution works for you.

Best Answer

Related Solutions

Magento Category Products – Sorting Products in Parent Category by Subcategories and Position

Magento 2.1 – Assign Products to Ancestor Categories Programmatically

Related Topic