{"id":78158,"date":"2017-01-24T10:56:39","date_gmt":"2017-01-24T15:56:39","guid":{"rendered":"https:\/\/www.templatemonster.com\/help\/?p=78158"},"modified":"2017-08-24T05:13:56","modified_gmt":"2017-08-24T09:13:56","slug":"magento-2-enable-flat-catalog","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/magento-2-enable-flat-catalog.html","title":{"rendered":"Magento 2. How to Enable Flat Catalog"},"content":{"rendered":"<p>This tutorial will show you how to enable Flat Catalog in <a href=\"https:\/\/www.templatemonster.com\/magento-themes.php\" title=\"Magento Templates\" target=\"_blank\">Magento Templates<\/a>.<\/p>\r\n\r\n <div class=\"video-container\">\r\n\t<iframe src=\"https:\/\/www.youtube.com\/embed\/6yiNo6rsfII\"><\/iframe>\r\n<\/div>\r\n<p>Flat Catalog will help you to speed up your product collection instead of managing the catalog data in many tables by the Entity Attribute Value (EAV). When your store applies the Flat Catalog, the new tables are generated on the fly and store the necessary data related to your product or category.<\/p>\r\n<ol>\r\n\t<li><p>In order to enable it, navigate to the <strong>Stores > Settings > Configurations<\/strong> section in your admin panel.<\/p>\r\n\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_1.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_1.jpg\" alt=\"Magento_2_How_to_Enable_Flat_Catalog_1\" width=\"552\" height=\"563\" class=\"alignnone size-full wp-image-78159\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_1.jpg 552w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_1-147x150.jpg 147w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_1-294x300.jpg 294w\" sizes=\"(max-width: 552px) 100vw, 552px\" \/><\/a>\t\r\n\t<\/li>\r\n\t<li><p>Select <strong>Catalog<\/strong> on the left panel, under  the <strong>Catalog<\/strong>.<\/p>\r\n\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_2.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_2.jpg\" alt=\"Magento_2_How_to_Enable_Flat_Catalog_2\" width=\"560\" height=\"563\" class=\"alignnone size-full wp-image-78160\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_2.jpg 560w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_2-150x150.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_2-298x300.jpg 298w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_2-164x164.jpg 164w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/a>\t\r\n\t<\/li>\r\n\t<li><p>Open the Storefront section there.<\/p>\r\n\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_3.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_3.jpg\" alt=\"Magento_2_How_to_Enable_Flat_Catalog_3\" width=\"800\" height=\"307\" class=\"alignnone size-full wp-image-78161\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_3.jpg 800w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_3-150x58.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_3-300x115.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_3-768x295.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a>\t\r\n\t<\/li>\r\n\t<li><p>Choose <strong>&quot;Yes&quot;<\/strong> at the <strong>Use Flat Catalog Category<\/strong> and <strong>Use Flat Catalog Product<\/strong> fields.<\/p>\r\n\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_4.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_4.jpg\" alt=\"Magento_2_How_to_Enable_Flat_Catalog_4\" width=\"788\" height=\"313\" class=\"alignnone size-full wp-image-78162\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_4.jpg 788w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_4-150x60.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_4-300x119.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/01\/Magento_2_How_to_Enable_Flat_Catalog_4-768x305.jpg 768w\" sizes=\"(max-width: 788px) 100vw, 788px\" \/><\/a>\t\r\n\t<\/li>\r\n\t<li><p>Press the <strong>Save config<\/strong> button to save the  changes.<\/p>\r\n\t<\/li>\r\n\t<\/ol>\r\n<p>That is the end of the tutorial. Now you know how to enable flat catalog for your store.<\/p>\r\n<div class=\"inline-banner\">\r\n<a href=\"https:\/\/www.templatemonster.com\/service-center\/\">\r\n<img src=\"\/help\/files\/banners\/inline\/Banner-2-(835-x100).jpg\"\/>\r\n<\/a>\r\n<\/div>\r\n<p>Feel free to check the detailed video tutorial below:<\/p>\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=6yiNo6rsfII?width=1280&amp;height=720\" rel=\"prettyPhoto\">Magento 2. How to Enable Flat Catalog<\/a>","protected":false},"excerpt":{"rendered":"<p>This tutorial will show you how to enable Flat Catalog in Magento 2.<\/p>\n","protected":false},"author":106,"featured_media":78163,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[729],"tags":[2521,2315],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/78158"}],"collection":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/users\/106"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=78158"}],"version-history":[{"count":2,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/78158\/revisions"}],"predecessor-version":[{"id":82888,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/78158\/revisions\/82888"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/78163"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=78158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=78158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=78158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}