A Guide to Enabling and Configuring Flat Catalog in Magento 2

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.

Contents

1 Steps to Enable/Configure Flat Catalog in Magento 2:
2 Verify Flat Catalog for Magento 2:
- 2.1 Step 1: Check results for a Product
- 2.2 Step 2: Check results for a Category
3 Final Words:

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

Set the Use Flat Catalog Category option to Yes.
Set the Use Flat Catalog Product option to Yes.

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.

Now search for the product in the storefront. You can notice the changes based on the cron job settings.

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.

Now check the created category list in the storefront. You can notice the changes based on the cron job settings.

Final Words:

This way you can configure a flat catalog for Magento 2. You can also configure Catalog Search in Magento 2. Share the tutorial with your Magento friends and stay in the loop with us.

Happy Reading!

Click to rate this post!

[Total: 5 Average: 5]

Gaurav Jain

Gaurav Jain is Co-Founder and Adobe Certified Expert-Magento Commerce Business Practitioner. Being Computer Engineer👨‍💻 and possessing Extensive Marketing skills he handles all kinds of customer Queries and his Happy😀 & Helping🙏 Nature makes customer's day Delightful. When he isn’t working, you’ll find Gaurav Reading on Books📖 or Traveling🚗. Also, he is Speaker at Magento Meetups.