Questions tagged [flat-catalog]

Denotes questions related to flat catalog feature of magento

Filter by
Sorted by
Tagged with
1 vote
1 answer
350 views

Flat catalog in Magento 2.4.*

Magento now uses ElasticSearch by default and the latter is the tested/recommended way to use Magento. However, the Flat Catalog options are still in the config and the the core code that drives these ...
Herve Tribouilloy's user avatar
1 vote
1 answer
51 views

Magento 1: MySQL failing on flat catalog / locked tables

I'm running quite an old Magento 1.9.2 instance, for a couple of weeks, it's going offline periodically because of MySQL load. MySQL server CPU usage is going over 1000% (one thousand), all cores are ...
medial's user avatar
  • 11
0 votes
0 answers
47 views

Unable to display products in flat table even after reindexing

I imported few products in magento2.4 and also enable Flat tables through configuration. After that I tried to run php bin/magento indexer:reindex but didn't display that product in ...
Unknown's user avatar
  • 581
0 votes
1 answer
993 views

magento 2- showing special price products on the product list page not working with flat catalog tables

I have created functionality to show all the special price products on the product list page by extending the core class \Magento\Catalog\Model\Layer. This functionality is working fine with default ...
Aatif's user avatar
  • 71
0 votes
0 answers
91 views

Unable to delete product entry in catalog flat tables on deleting product from admin in Magento2

I have enable catalog flat tables configuration. I try to delete product from admin but still it is displaying in frontend with message "Out of stock". Also i checked database entry for ...
Unknown's user avatar
  • 581
0 votes
0 answers
585 views

Magento 2: Error while create category programmtically: Call to undefined method Magento\Catalog\Model\ResourceModel\Category\Flat::getEntityTable()

I am creating a category programmatically in magento 2 in controller, but I am getting error Call to undefined method Magento\Catalog\Model\ResourceModel\Category\Flat::getEntityTable() I have also ...
Niraj Patel's user avatar
0 votes
0 answers
162 views

Magento 2.3 - Using a Flat Catalog not recommended but much faster

We run a Magento 2.3.5 store with 125.000+ products. Magento no longer recommends to use flat catalog sinds 2.1.x (https://docs.magento.com/user-guide/catalog/catalog-flat.html) But when we enable the ...
JGeer's user avatar
  • 1,416
0 votes
1 answer
143 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 ?
Aji's user avatar
  • 190
1 vote
0 answers
31 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 ...
Akif's user avatar
  • 1,522
1 vote
1 answer
1k 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 ...
Singleton's user avatar
0 votes
4 answers
3k 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 ...
Nagaraju Kasa's user avatar
0 votes
1 answer
233 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 ...
Nafsss's user avatar
  • 760
1 vote
1 answer
178 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 ...
Shankar Thyagarajan's user avatar
1 vote
0 answers
301 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 ...
jtalel's user avatar
  • 13
0 votes
0 answers
38 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
Nafsss's user avatar
  • 760
4 votes
1 answer
65 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.
mossio's user avatar
  • 71
1 vote
0 answers
124 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 ...
Waqar Ansari's user avatar
2 votes
1 answer
232 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 ...
manokarthick karthick's user avatar
1 vote
1 answer
387 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: ...
Head's user avatar
  • 157
0 votes
0 answers
99 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 ...
Aarief Mohideen's user avatar
0 votes
1 answer
257 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(...
buttons99's user avatar
5 votes
0 answers
141 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 ...
Tobi's user avatar
  • 153
1 vote
1 answer
950 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-...
1990rk4's user avatar
  • 593
0 votes
2 answers
588 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 ...
klaaskox's user avatar
  • 165
2 votes
2 answers
505 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....
JGeer's user avatar
  • 1,416
1 vote
0 answers
172 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 ...
DingDong's user avatar
0 votes
1 answer
530 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 ...
Goose84's user avatar
  • 2,581
2 votes
1 answer
863 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 ...
MagentoAaron's user avatar
1 vote
2 answers
497 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 ...
Martin Thompson's user avatar
0 votes
0 answers
42 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 ...
ManuHH's user avatar
  • 103
2 votes
0 answers
123 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 ...
Eric Seastrand's user avatar
31 votes
2 answers
2k 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 ...
harri's user avatar
  • 5,455
0 votes
1 answer
540 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 ...
jscar's user avatar
  • 787
1 vote
0 answers
91 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 ...
HudsonWY's user avatar
21 votes
3 answers
8k 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 ...
Alana Storm's user avatar
  • 44.3k
0 votes
0 answers
582 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 ...
Goose's user avatar
  • 428
0 votes
0 answers
316 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 ...
eddhall's user avatar
  • 379
1 vote
1 answer
833 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. ...
DarkCowboy's user avatar
1 vote
2 answers
1k 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?
TheNorthern_Light's user avatar
0 votes
1 answer
91 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 ...
Shan's user avatar
  • 355
0 votes
2 answers
905 views

Description attribute in Flat Catalog Table

I am using flat catalogs. I see that by default description product attribute is not in catalog_product_flat_* tables. Although short_description is. Why? If I set description to 'Used in Product ...
Konstantin Gerasimov's user avatar
1 vote
2 answers
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 ...
YorkieMagento's user avatar
0 votes
2 answers
727 views

filter product collection when flat product and category in ON

I've enabled flat tables. Now the new arrival products aren't appearing which is filtered by a particular category. Below code works when flat tables are disabled. $cat = Mage::registry('...
amitshree's user avatar
  • 6,966
2 votes
1 answer
109 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, ...
snh_nl's user avatar
  • 5,422
2 votes
0 answers
105 views

FEATURED and BEST SELLING product show on homepage more than listed in category

Previously i am using without "Use Flat Catalog Category " so, everything is correct , but due to slow performance o moved on Use Flat Catalog Category, problem is started from here. now FEATURED and ...
Niranjan's user avatar
5 votes
3 answers
9k 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 ...
Jackson's user avatar
  • 9,889
1 vote
1 answer
761 views

How can I load a product attribute from its flat table into a product object?

So I created a custom attribute, shipping, which is a drop down menu taking on three possible values. In its attribute settings I set the field Used in Product Listing to 'Yes', did a reindexation, ...
Pitt's user avatar
  • 121
1 vote
2 answers
212 views

Block cache and flat tables (Mage_Catalog_Block_Product_List)

We are using Magento Enterprise and use flat tables and automatic re-index. I have a block that extends Mage_Catalog_Block_Product_List. Block cache is enabled and block cache is tagged with all the ...
TheBlaze's user avatar
2 votes
1 answer
436 views

Adding Child Data to the Product Flat Index

Summary: Is there any action required to pull data from "child products" into configurables on flat tables other than setting global/catalog/product/flat/add_child_data to 1? App: Magento 1....
mpw's user avatar
  • 1,050
2 votes
0 answers
69 views

Category tree generating takes too much time

StackExchange! I've faced big problem with category tree generating process. I run $flat = Mage::getResourceModel('catalog/category_flat'); $categories = $flat->getCategories($parentCategoryId, 4, ...
Vasyl Malanka's user avatar