Questions tagged [flat-catalog]

Denotes questions related to flat catalog feature of magento

Filter by
Sorted by
Tagged with
26
votes
1answer
1k views

Magento Profiling - Why so many EAV: Magento\Eav\Model\Config::getAttribute?

I'm just reviewing the speed of a store and just wondering if anyone knows more about why I have over 100 EAV: Magento\Eav\Model\Config::getAttribute 0.006978 rows within my profiler. It's just I do ...
0
votes
0answers
8 views

Auto set and unset flat product catalog in Magento 1.9

I am going to create one script for programmatically apply catalog price rule for that I want to first disble flat catalog and after apply need to enable again. Any way to do it programmatically?
0
votes
1answer
20 views

Does enabling category and product flat data will affect performance in Magento 2?

I have huge doubt in flat data feature in Magneto 2. If I enable product and category flat data in Magento 2. Will it affect the website performance heavily ?
1
vote
0answers
23 views

Flat catalog tables considered a bad practice since M2.1.x and above? [duplicate]

Magento no longer recommends the use of a flat catalog as a best practice. Continued use of this feature is known to cause performance degradation and other indexing issues. A detailed description and ...
0
votes
1answer
959 views

Should I disable flat catalog?

My Magento store has around 60,000 products. We use flat tables. We are in the process of separating them into different attribute sets, and are adding lots of new attributes to assist with filtering ...
1
vote
1answer
60 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 ...
4
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 ...
19
votes
3answers
5k views

Magento 2: Are Flat Tables Still a Thing?

Are flat tables still a thing we need to worry about in Magento 2? I know there's UI where we can turn the flat tables on, but I'm unsure how well they've been tested, and if they're even needed ...
0
votes
1answer
314 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 ...
0
votes
1answer
89 views

Magento2 : Getting Error when enabled Flat catalog Category and Product

I am using magento 2.3.2. My site takes too much to load. I enabled flat catalog category and Flat catalog product. See https://prnt.sc/pgr3xu. But on site when i click on any product it gives me ...
1
vote
1answer
56 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 ...
0
votes
0answers
141 views

Issue with flat catalog table product collection in Magento 1.9

I am facing an issue regarding magento product collection as I have some additional product attribute and use general way to get product collection like: Mage::getModel('catalog/product')->...
1
vote
0answers
84 views

Product's Tax Class change to “None” on Reindex. Any ideas?

We've just migrated from Magento 1.9.2.2 to Magento 2.2.8. We noticed in the last couple of days some orders are created without billing any tax. When We go check the product We notice the tax class ...
0
votes
0answers
28 views

Flat Catalog Product rebuild error in magento 1.3

Can any one help me to solve this error https://prnt.sc/omfwt3 I am getting this error when i try to Rebuild Flat Catalog Product in magento 1.3
9
votes
4answers
13k 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.... ...
4
votes
1answer
50 views

custom attribute

I have a custom attribute which is not displayed after the activating use flat directory category, moreover, I did not activate the visible_on_ front, but I still did not get any results.
1
vote
0answers
41 views

Get data from eav instead of flat table

I am trying to get product collection programmatically and product flat table structure is enabled. I don't want to disable product flat table, this will hurt frontend performance. Just for my script ...
2
votes
1answer
62 views

out of stock products in flat tables

while selecting the products from flat table. out of stock products are missing. Is there any configurations that will populate the out of products also in flat table? Where the flat tables can be ...
2
votes
1answer
82 views

How do I add the manufacturer attribute to sales_flat_order_item?

Hi we use the manufacturer attribute a lot. And often in code we have to grab it separately because it is stored as a product attribute. question: Is it possible, just like the flat_catalog tables, ...
4
votes
0answers
70 views

Is it possible to reduce the default varchar size in catalog_product_flat? (M2)

I have a seemingly common problem. With too many custom attributes that are necessary and no way to change them in a way that would make the use of the default flat catalog possible I am searching for ...
2
votes
0answers
49 views

Why is product flat collection disabled in checkout / cart pages since CE 1.9.4.0 / EE 1.14.4.0?

Since CE 1.9.4.0 / EE 1.14.4.0 cart and checkout controllers have preDispatch method updated with the following changes: which forces product collections to use EAV tables instead of ...
6
votes
0answers
2k views

Loading a product collection through multiple stores

We've created an additional indexer that is started by using the backend indexer functions. We have flat tables enabled. We have multiple storeviews that correspond to different languages. The ...
1
vote
1answer
189 views

I assume this is not normal but i have catalog_product_index_eav table and then catalog_product_index_eav_replica table

I'm not sure why and if it's normal but i'm assuming it's not suppose to be there. Lately, i've been having some problems with saving products and getting these errors on the admin upon save: ...
0
votes
0answers
54 views

Remove specific product from Solr core while deleting product in magento 1.9

Is there any better way to deleting the product from Solr core while deleting the product from Magento admin. When I delete a product , it doesn't actually reflected or removed the product from Solr ...
0
votes
3answers
894 views

magento get products only works with disabled Flat Catalog Product

we would like to check if products exists with the following code: $foundProduct = Mage::getModel('catalog/product')->loadByAttribute('sku', $sku); We only get positive results if "Use Flat ...
0
votes
1answer
127 views

Magento 2 - Enabling Flat Catalog causes SQL error. Reading from “report” tables

When I enable the flat catalog in my Magento 2.2.5 installation, I get an error. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.name' in 'field list', query was: SELECT COUNT(...
1
vote
1answer
660 views

Magento 2: When use Flat Catalog Product it gives SQL error

When I am changed setting for Flat Catalog Product to Yes, it gives SQL error in magento 2. Stores >> Configuration >> Catalog >> Catalog Is this known bug in magento 2.2.6? I have done re-...
2
votes
1answer
482 views

Enabling Use Flat Catalog Products Results In Frontend Pages Not Loading

I am running Magento 1.9.3.8 and would like to enable Use Flat Catalog Product as I have over 100k skus. After enabling it, rebuilding the indexes, and clearing cache, the frontend will not load. It ...
3
votes
3answers
19k views

How to filter product collection using category id in flat mode

I have flat mode enabled and I need to filter the product collection using category id, but I am not able to. Here below is my code... $productCollection = Mage::getModel('catalog/product') ...
0
votes
2answers
355 views

Magento 2 flat catalog category not available

I would like to enable Flat Catalog Category in our multistore Magento 2 (2.1.9), but I cannot find the option in Store > Configuration > Catalog > Catalog > Storefront What could be the cause of ...
2
votes
2answers
265 views

Magento 1 catalog_product_flat_1 corrupt

We have disabled the option to use catalog flat product. Not we have a corrupt DB message: magento.catalog_product_flat_1 Error : Incorrect information in file: './magento/catalog_product_flat_1....
1
vote
0answers
163 views

Running simple Data Flow import profile deletes records

I encountered a very weird issue. I am trying to run a very basic import data flow profile (done it a hundred times before) by using selected Magento columns: sku, category_ids and status which looks ...
0
votes
1answer
263 views

Magento 2 - Cant update categories programmatically Flat::validate()

Please could someone advise why I am getting this error when calling my code below: Uncaught Error: Call to undefined method Magento\Catalog\Model\ResourceModel\Category\Flat::validate() namespace ...
1
vote
2answers
342 views

How to get all Products including disabled in Magento 1.3

I have spent hours trying to find how to get a simple thing like all products - including the disabled ones. My apologies , this is such an old version! I have looked up most of the posts on stack ...
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 ...
2
votes
2answers
838 views

Product attribute keeps being “null” in flat table

I'm having a magento installation with flat product tables activated. As I need an attribute in collections I've set it to "Used in Product Listing", the rest is a pretty simple textfield for all ...
2
votes
0answers
89 views

Are catalog rules completely broken in Magento 1 with flat tables enabled? Or, how can these SQL queries ever work as intended?

I've discovered that some of the SQL queries Magento is using to generate catalogrule discounts are completely nonsensical, leading to products receiving discounts even though they should not. This ...
0
votes
0answers
35 views

Problem buy using Catalog Price Rules

Set catalog prices with date in future. The special price will be deleted after 2-3 days in the product data (all rules regarding) , although the date is not yet reached. problem strikes with flat ...
0
votes
1answer
339 views

Steps to change from flat structure to EAV

We're having problems with indexing and I want to see if switching from the flat structure to EAV resolves it. I can't find anything online that deals with switching like this (lots going from EAV to ...
1
vote
0answers
83 views

Changing “Use Flat Catalog Category/Product” To Yes Changes The Head Of My Website

Recently we have decided to change the option of our website to use the flat catalogue category/product to speed up our website, which works! But we have now come across a problem where when doing ...
0
votes
0answers
412 views

Restoring flat tables after truncate

I am planning to truncate catalog_product_flat_* tables to fix the Catalog Serach Index per this StackOverflow answer. “There was a problem‍​​ with reindexing process.” after product import In the ...
1
vote
1answer
545 views

Category Flat Data problem: description is missing in flat table without indexing error

I'm working on M1 CE 1.7.0.2. I've enabled Use Flat Catalog Category from backend (catalog/frontend/flat_catalog_category = 1). Then I reindex php shell/indexer.php --reindexall without any error. ...
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 ...
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 ...
0
votes
0answers
288 views

Flat product/category tables producing category URL instead of product on list view

I have enabled the flat product and category tables on a development site to test before using live, and for some reason product links in category views now link back to the category itself rather ...
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. ...
1
vote
2answers
543 views

M2: Category Flat Data re-indexing never finishes?

So I know this used to be a common problem in M1.x. However, I only recently noticed this in our M2.1.3 environment. How can I flush/wipe the Category flat data index and rebuild from scratch?
4
votes
2answers
2k views

How to addFieldToFilter for attribute special_price with flat product tables?

In a class which extends Mage_Catalog_Model_Layer I have the following code: $collection = Mage::getModel('catalog/category') ->load($rootCategoryId) ->getProductCollection() ->...
0
votes
1answer
88 views

Unable to retrieve custom attribute after enabling “Use Flat Catalog Product”

I have a custom attribute for the product, Which is a Multi-select. I created this attribute with php script as shown below. The attribute's "Used in Product Listing" is set to true. But im unable to ...
1
vote
2answers
2k views

Get sub-categories of parent with flat catalog enabled Magento 2

I have the following code in a phtml fill that is called in a static block and produces a list of sub-categories for the parent. It currently does not work when flat catalog is enabled. Can anyone ...