Set all categories to anchor Magento2 MySql

Published On - 21 October 2020

The Team Magento 2

This is a quick fix for those that have a large category structure in Magento 2, where all categories need to be set to Anchor

Open up phpMyAdmin and run the following sql command

UPDATE catalog_category_entity_int
SET value = 1
WHERE attribute_id = (SELECT attribute_id
FROM eav_attribute
WHERE attribute_code = ‘is_anchor’
LIMIT 1);