Magento 2.1 – Assign Products to Ancestor Categories Programmatically

categorycategory-productsmagento-2.1magento2

I am working on a Magento 2.1.7 shop and I have created a child-theme of Magento Blank

The products are organized into categories and subcategories. In other words, they are organized into parent categories and children categories.

Whenever a product is assigned, through the Magento admin, to a child category, I want it to be automatically assigned to all the ancestor categories of that child category.

I want to manually assign all the boot brands in the store to the "Boots" child category add I want all boots to be automatically put, by Magento, in the "Footwear" parent category.

Question: What is the programming solution that would do the job, recursively?

Best Answer

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.

Related Solutions

Magento Categories – How to Get Magento Categories by Array of Category IDs

Based on the comments....
Instead of $_categories->getParentId()>0 try to check

$_categories->getParentId() != 1 && $_categories->getParentId() != Mage::app()->getStore()->getRootCategoryId().

This should exclude the root of all roots (id 1) and the default root category of the store.

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.

Best Answer

Related Solutions

Magento Categories – How to Get Magento Categories by Array of Category IDs

Magento – Get all Categories of Products in Category – PHP

Related Topic