Magento How to display/list all categories from catalog category flat table

Magento How to display/list all categories from catalog category flat table

July 17, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento How to display/list all categories from catalog category flat table

Magento: Loading All Categories from Flat Catalog Category Table

Enabling flat catalog data for better performance is a common optimization strategy in Magento. However, it can sometimes break existing functionality if the code isn’t updated to work with the flat tables. Let’s discuss how to retrieve all categories and their subcategories correctly when using flat category data.

Understanding Flat Catalog Category

When you enable “Use Flat Catalog Category”, Magento populates the catalog_category_flat_store_* tables with pre-calculated data about your categories. This includes information like the parent ID, position, is_active flag, etc. The idea is to reduce the number of joins required when fetching category data.

Why Your Previous Code Isn’t Working

Your previous code worked fine because it was using the standard Mage_Catalog_Model_Category collection without flat data enabled. However, once you switch to flat data, Magento no longer populates the standard tables with category information, so your old code fails.

The key issue is that getChildren() and addIdFilter($_category->getChildren()) won’t work properly when using flat data. The getChildren() method returns an array of child IDs based on the regular tables, not the flat ones.

Retrieving Categories with Flat Data

To fetch all categories and their subcategories from the flat table, you should use Magento’s built-in methods for dealing with flat catalogs. Here’s how to do it:

$_category = Mage::getModel('catalog/category')
                ->setStoreId(Mage::app()->getStore()->getId())
                ->getCollection()
                ->addAttributeToSelect(array('url_key','name','image','all_children','is_anchor','description'))
                ->addAttributeToFilter('is_active', 1)
                ->addFieldToFilter('level', array('gt' => 0))
                ->setOrder('position', 'ASC')
                ->load();

foreach ($_category as $_cat) {
    echo $_cat->getName() . '<br/>';
}

This code retrieves all active categories (excluding the root category, which has level = 0) and orders them by position. It uses the standard collection methods but doesn’t rely on any specific table.

Getting Subcategories

To retrieve subcategories for a specific parent category, you can use the following:

$_category = Mage::getModel('catalog/category')->load(CATEGORY_ID);
$_subcats = $_category->getCollection()
                      ->addAttributeToSelect(array('url_key','name','image'))
                      ->addFieldToFilter('parent_id', array('eq' => CATEGORY_ID))
                      ->setOrder('position', 'ASC')
                      ->load();

foreach ($_subcats as $_subcat) {
    echo $_subcat->getName() . '<br/>';
}

This code retrieves all subcategories for a given category ID, ordered by position.

Conclusion

When working with flat catalog data in Magento, it’s crucial to use the correct methods provided by Magento. The Mage_Catalog_Model_Category collection has built-in support for retrieving categories and their relations from the flat tables.

Remember that once you enable flat data, you cannot mix and match methods designed for standard tables. Always ensure your code is compatible with the current catalog configuration (flat or standard).

For more advanced Magento development topics like this one, check out our comprehensive guides at Laravel Company.

Catalog Database Performance Errors

Our network