Magento Snippets Set all categories to is_anchor 1 Find attribute_id SELECT * FROM eav_attribute where attribute_code = 'is_anchor' Update all of them with anchor_id from above (usually is ID 51) UPDATE `catalog_category_entity_int` set value = 1 where attribute_id = 51