catalog-flat-verify-category

Step 2: Verify the Results

Method 1: Verify the Results for a Single Product 1. On the Admin menu, select Catalog > Manage Products. Then, do the following: a. Choose a product to modify. Then, open the product in edit mode. b. In the Name field, add the text “_DEMO” to the product name. 2. Click the Save button. 3. On a new browser tab, …

config-catalog-frontend-flat-catalog

Step 1: Enable the Flat Catalog

1. On the Admin menu, select System > Configuration. Then in the panel on the left under Catalog, select Catalog. 2. Click to expand the Frontend section. Then, do the following: a. Set Use Flat Catalog Category to “Yes.” b. Set Use Flat Catalog Product to “Yes.” 3. When complete, click the Save Config button. 4. When prompted to refresh the …

config-catalog-frontend-flat-catalog

Setting Up a Flat Catalog

Before you enable a flat catalog for a live store, make sure to test the configuration in a development environment. Process Overview: Step 1: Enable the Flat Catalog Step 2: Verify the Results

config-catalog-frontend-flat-catalog

Flat Catalog

Magento typically stores catalog data in multiple tables, based on the Entity-Attribute-Value (EAV1) model. Because attributes are stored in many tables, SQL queries are sometimes long and complex. In contrast, a flat catalog creates new tables on the fly, where each row contains all the necessary data about a product or category. The flat catalog is updated automatically—either every minute, …