/
Following attributes are missing in Product Flat catalog - M2

Following attributes are missing in Product Flat catalog - M2

Problem

Following attributes are missing in Product Flat Catalog: EAN. Or any other Magento product attribute can be mentioned in the error message.

The error message says that given attribute is missing in Product Flat Calalog and thus is not available for the product export process.

Solution

Automated one-click solution

Just click on the link Add the attribute(s) to Product Flat Catalog dispalyed in the error message and execute profile again:

Manual solution

Step #1 - Enable Flat Catalog

Koongo Connector uses Flat Product and Flat Category data, so please make sure you have enabled these two settings. You can enable Flat by clicking on the link in the note or navigate to Stores -> Settings -> Configuration → System → Catalog → Storefront:

  • Use Flat Catalog Category = Yes
  • Use Flat Catalog Product = Yes


Step #2 - Check Product Attribute Detail

Navigate to the attribute's detail in Stores → Attributes  Product 

Then, set the option Use in Product Listing to Yes and save attribute details:

Step #3 - Reindex Product Index

If your server cron job runs properly, Product and Category Flat Catalog will be reindexed automatically.

You can force reindex via ssh by following command in your Magento 2 installation folder:

php bin/magento indexer:reindex

Step #4 - Flush Cache Storage

Click Flush Cache Storage button under System Tools → Cache Management: