---
title: "A Guide to Enabling and Configuring Flat Catalog in Magento 2"
url: "https://magecomp.com/blog/enable-flat-catalog-magento-2/"
date: "2022-05-03T10:00:45+00:00"
modified: "2022-05-03T10:00:45+00:00"
author:
  name: "Gaurav Jain"
  url: "https://magecomp.com/"
categories:
  - "Magento Tutorials"
word_count: 343
reading_time: "2 min read"
summary: "Running a large Magento 2 store demands better performance and faster loading times to maintain user experience. It becomes difficult to handle a large number of products in the database."
description: "Improve store performance with flat catalog in Magento 2. To configure flat catalog, go to Stores>Settings>Configuration>Catalog"
keywords: "Magento Tutorials"
language: "en"
schema_type: "Article"
related_posts:
  - title: "Fixed: PHP Fatal Error “Allowed Memory Size” in Magento 2"
    url: "https://magecomp.com/blog/fixed-php-fatal-error-allowed-memory-size-magento-2/"
  - title: "What is Magento 2 Marketing Tools & How to Use It?"
    url: "https://magecomp.com/blog/magento-2-marketing-tools/"
  - title: "How to Disable Compare Products for Magento 2"
    url: "https://magecomp.com/blog/how-to-disable-compare-products-for-magento-2/"
---

# A Guide to Enabling and Configuring Flat Catalog in Magento 2

_Published: May 3, 2022_  
_Author: Gaurav Jain_  

![How to Enable Configure Flat Catalog in Magento 2](https://magecomp.com/blog/wp-content/uploads/2022/05/How-to-Enable-Configure-Flat-Catalog-in-Magento-2-1024x512.webp)

Running a large Magento 2 store demands better performance and faster loading times to maintain user experience. It becomes difficult to handle a large number of products in the database.
Magento uses EAV (Entity-Attribute-Value) database model for products and categories. In the EAV model, the values are stored in a separate table for every data type. Product attributes in multiple tables will cause long and complex SQL queries for retrieving data.
The alternate option for this is Flat Catalog which creates a flat table that stores all information about the products and categories. The flat table is automatically updated based on the cron job scheduling. Hence, the flat catalog can speed up the processing of the catalog which will enhance the overall performance of the store.
Let’s learn How to Enable a Flat Catalog in Magento 2.
## Steps to Enable/Configure Flat Catalog in Magento 2:
- From the admin panel, navigate to **Stores > Settings > Configuration**.- Expand the **CATALOG** option from the left sidebar and select **Catalog**.- Enlarge the **Storefront** option
[![flat catalog configuration](https://magecomp.com/blog/wp-content/uploads/2022/05/flat-catalog-configuration.png)](https://magecomp.com/blog/wp-content/uploads/2022/05/flat-catalog-configuration.png)

- Set the **Use Flat Catalog Category** option to **Yes**.- Set the **Use Flat Catalog Product** option to **Yes**.
[![enable flat catalog](https://magecomp.com/blog/wp-content/uploads/2022/05/enable-flat-catalog.png)](https://magecomp.com/blog/wp-content/uploads/2022/05/enable-flat-catalog.png)

- Lastly, click **Save Config**.
## Verify Flat Catalog for Magento 2:
### Step 1: Check results for a Product
- From the Admin Panel, go to **Catalog > Products**.- Open any product in edit mode.- Change the **Product Name**.- And **Save**.
[![modify product name](https://magecomp.com/blog/wp-content/uploads/2022/05/modify-product-name.png)](https://magecomp.com/blog/wp-content/uploads/2022/05/modify-product-name.png)

Now search for the product in the storefront. You can notice the changes based on the cron job settings.
[![flat catalog product](https://magecomp.com/blog/wp-content/uploads/2022/05/flat-catalog-product.png)](https://magecomp.com/blog/wp-content/uploads/2022/05/flat-catalog-product.png)

### Step 2: Check results for a Category
- From the Admin Dashboard, move to **Catalog > Categories**.- Select any category and click on **Add Subcategory** button.- Activate the **Enable Category** radio button.- Give a name to the new category in the **Category Name** field. - And **Save**.

[![modify category name](https://magecomp.com/blog/wp-content/uploads/2022/05/modify-category-name.png)](https://magecomp.com/blog/wp-content/uploads/2022/05/modify-category-name.png)

Now check the created category list in the storefront. You can notice the changes based on the cron job settings.
[![flat catalog category](https://magecomp.com/blog/wp-content/uploads/2022/05/flat-catalog-category.png)](https://magecomp.com/blog/wp-content/uploads/2022/05/flat-catalog-category.png)

## Final Words:
This way you can configure a flat catalog for Magento 2. You can also configure [**Catalog Search in Magento 2**](https://magecomp.com/blog/configure-catalog-search-magento-2/). Share the tutorial with your Magento friends and stay in the loop with us.
**Happy Reading!**


---

_View the original post at: [https://magecomp.com/blog/enable-flat-catalog-magento-2/](https://magecomp.com/blog/enable-flat-catalog-magento-2/)_  
_Served as markdown by [Third Audience](https://github.com/third-audience) v3.5.3_  
_Generated: 2026-09-09 09:12:38 UTC_