Questions tagged [flat-catalog]

Denotes questions related to flat catalog feature of magento

Filter by
Sorted by
Tagged with
0
votes
1answer
470 views

Rolled back transaction has not been completed correctly while saving product

We have been facing an issue while saving products & categories at the admin end we are getting Rolled back transaction has not been completed correctly. We are using Magento 2.3.1 EE Can anyone ...
4
votes
2answers
7k views

What are the differences between EAV and Flat catalogs?

Can anyone provide a clarification on the differences between EAV and Flat catalogs, when accessing the sub categories of a category?
34
votes
5answers
20k views

How to set a store ID on Mage_Catalog_Model_Resource_Product_Collection?

The task is trivial. I need to get list of products for particular store view with a flat catalog enabled. The most obvious solution is the following: $collection = Mage::getResourceModel('catalog/...
16
votes
2answers
19k views

When should I use the category flat table option?

As a follow-up to a previous question I would like to know: When should I use the category flat table option? While googling I found an advice to enable it "when you have very much categories". But ...
4
votes
2answers
4k views

How to get disable product collection whenever flat enable at frontend

In my system flat setting has been enable for products and as per as magento system magento exclude disable products from product collection whenever flat table is creating. That why we can not get ...
1
vote
1answer
208 views

Starting with Magento 2.3.0+, the use of a flat catalog is no longer a best practice and is not recommended

Can anyone shed some more light on why Magento recommends against this now? Other than the short description they have in their dev docs. Continued use of this feature is known to cause performance ...
10
votes
4answers
14k views

Magento Indexer Not Adding Attribute to flat table in custom attribute

Magento Not adding custom Attribute to flat table..... I have a market place extension...which have some attribute but some attributes not adding to flat table...due to my extension not working.... ...
9
votes
3answers
2k views

Force products collection to use EAV instead of flat table

In Magento 2, how can I temporarily disable the flat catalog? I have a product collection associated with a frontend store and want it to be loaded via EAV tables. I looked how the collections ...
5
votes
4answers
6k views

Get child categories tree when Flat Catalog Category is enabled in admin in Magento 2

How to get child categories from selected parent category when "Use Flat Catalog Category" is enabled? I need to create a small menu which displays all sub-categories of current category in a ...
5
votes
3answers
7k views

Magento 2: Using a Flat Catalog is Helpful for Performance?

We can configure Flat Catalog for Category & Products from Admin -> Stores -> Configuration -> Catalog -> Catalog -> Storefront Tab. If it improves the performance of Magento, then ...
5
votes
2answers
1k views

Image attribute in Product Flat Catalog

I have a Magento 1.8 CE and I figured out that when using "Product Flat Catalog", the attribute "image" is not collected. How can i add that attribute to "Product Flat Catalog" It is not possible to ...
2
votes
1answer
5k views

Custom Attribute and value not Appearing in Flat Product table if Attribute is not in…Product Listing,Product Listing,Layered Navigation

Basically I installed one market place module in my website......that have a validation attribute...but which is not ...Product Listing,Product Listing,Layered Navigation...so when I use Flat Product ....
1
vote
1answer
77 views

Delete or Save category works in bootstrap file but not in my custom API controller when flat categories are enabled

I am trying to create and delete categories in Magento 2 but am facing some issues while doing it when Flat Categories option is enabled. The weird thing is, my code works fine when called from a ...
1
vote
1answer
4k views

Getting products position while using flat tables

Regarding the answer from Vinai here https://magento.stackexchange.com/a/5775/199 I have one follow-up question: How can I get the ProductPosition array when I use flat category tables? In my system ...
0
votes
4answers
8k views

Base table or view not found: 1146 Table 'cpaneluser_magento.catalog_category_flat' doesn't exist'

I am getting following error while trying to reindex catalog_category_flat (Category Flat Data). I did tried to repair the database with PHPMyAdmin and magento database repair tool but still not fix. ...