How to Enable Flat Catalog in Magento 2

magento-2-tutorial
how-to
enable
flat
catalog

Using Flat Catalog will help you speed up your product collection instead of managing the catalog data in many table by the Entity Attribute Value (EAV). When your store applies the Flat Catalog, the new tables on the fly are generated and they will store every necessary data related to your product or category.

The flat catalog is updated automatically and quickly in every minute or according to your cron job regradless that your catalog contains more than 500,000 SKUs. Apparently, the flat catalog can also speed up the processing of catalog and cart price rules without any difficulties.

In this tutorial, I will guide you how to enable the flat catalog in the effective way.

Enable Flat Catalog:

  • Step 1: Activate the Flate Catalog
  • Step 2: Check the Results

Step 1: Activate the Flat Catalog

  • On the Admin Panel, Stores > Settings > Configurations.
  • On the left panel, under Catalog, select Catalog.
  • Open the Storefront section,
    • Choose Yes in the Use Flat Catalog Category field.
    • Choose Yes in the Use Flat Catalog Product field.

How to Enable Flat Catalog Flat Catalog Configuration

  • Save Config to complete.
  • When you see a system message about the cache update, tap the Cache Management link to flush the cache.

How to Enable Flat Catalog System Message

Step 2: Check the Results

#### Method 1: Check the Results for a Single Product * On the Admin Panel, Products > Inventory > Catalog. * Choose the row in the Inventory list to edit the corresponding product. * In the Name field, insert the text “_DEMO” to the product name. * Click on Save. * Open the home page on the new brower tab, you can check the results: * Search the item you edited. * Use the navigation to browse to the product under its assigned category.

To make sure the results are correct, let refresh the page and the change will display with your cron job schedule.

Method 2: Check the Results for Multiple Products

  • On the Admin Panel, Products > Inventory > Categories.
  • In the upper-left corner, choose the Store View to display, you can set for all store view or a specific store view as you need.
  • Choose an existing category from the category tree.
  • Click on the Add Subcategory link, and do as the following:
    • Enter the “Test Category” for the Name.
    • Choose Yes for Is Active field.
    • Save Category to save the settings.

How to Enable Flat Catalog Test Category

  • On the Category Products tab, click Reset Filter link to make all products visible.
  • Mark the checkbox of the products you want to add to the new category, then Save Category.

How to Enable Flat Catalog Add Products to Test Category

  • Open the home page on the new brower tab to browse to the category you added by the store navigation.

To make sure the results are correct, let refresh the page and the change will display with your cron job schedule.

Ref: Magento 2 User Guide



It comes to the end of tutorial: How to Enable Flat Catalog in Magento 2.

Please leave comments if you have any questions, feedbacks.

Comments for How to Enable Flat Catalog in Magento 2

You also may like these Magento 2 Extensions

One Step Checkout

$199
17 reviews

Layered Navigation

$149
7 reviews

Affiliate

$149
7 reviews

FAQ

$149
10 reviews

Zoho CRM

$249
no review

Store Locator

$199
no review

Shop By Brand

$99
no review

Better Blog

FREE
7 reviews