I want to have two grid of products one that contain the products that belong to categ 1 and the second for the product that belong to categ 2. I don' t know the name of the table that contain all the attributes of products for example for customer we have the customer_grid_flat but for product every type of product have a different table that store the data please help me it's an emergency and thanks for help in every case


For products, each attribute is saved in different table as per the EAV. You can check eav_attribute table for entity_type_id=4. Check the value for the column backend_type. For example, it is int, then you should look the table for eav_attribute_int with that product id(entity_id column) and attribute_id column.

But if you have flat catalog enabled, then you can directly go to the table catalog_product_flat_1 and search with product SKU or entity_id and get the value of that attribute.

  • how to know that the flat catalog is enabled Jan 8 '19 at 13:23
  • i can't see the table catalog_product_flat_1 Jan 8 '19 at 13:25
  • You can check the following to check whether flat catalog is enabled. On the Admin Panel, Stores > Settings > Configurations. On the left panel, under Catalog, select Catalog. Open the Storefront section, Check in the Use Flat Catalog Category field, if yes then flat catalog is enabled. Check in the Use Flat Catalog Product field, if yes then flat catalog is enabled. Jan 8 '19 at 13:30
  • and if not can i enabled it and see see all the data of product in the table that you mentionet Jan 8 '19 at 13:33
  • Yes, you can see that in the table which I provided to you. You can give me some information for the same so that I can guide you better. Jan 8 '19 at 13:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.