Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [flat-catalog]

Denotes questions related to flat catalog feature of magento

2
votes
0answers
32 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 ...
1
vote
1answer
58 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
21 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
1answer
62 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(...
3
votes
0answers
29 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 ...
1
vote
1answer
326 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-...
0
votes
2answers
173 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 ...
0
votes
0answers
35 views

Re indexing not working properly. Magento 2

I am getting issue with some of the products in flat table are getting current date/time in created_at, whenever re-index command has been executed. I have also checked with changing that products ...
2
votes
2answers
103 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
35 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
116 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 ...
2
votes
1answer
251 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 ...
0
votes
2answers
110 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 ...
0
votes
0answers
33 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 ...
2
votes
0answers
75 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 ...
12
votes
0answers
669 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
1answer
254 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
77 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 ...
17
votes
1answer
3k 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
0answers
279 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 ...
0
votes
0answers
261 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 ...
1
vote
1answer
368 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. ...
0
votes
2answers
208 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?
0
votes
1answer
82 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 ...
0
votes
2answers
642 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 ...
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 ...
0
votes
2answers
566 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('...
2
votes
1answer
70 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, ...
2
votes
0answers
89 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 ...
2
votes
2answers
5k 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 ...
1
vote
1answer
384 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, ...
1
vote
2answers
140 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 ...
2
votes
1answer
265 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.14.2.4 ...
2
votes
0answers
59 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, ...
5
votes
4answers
4k 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 ...
0
votes
1answer
39 views

I have enabled flat categories, and after doing this some of my categories are not showing there related products?

I have enabled flat categories, and after doing this some of my categories are not showing there related products, infact when i click to the specific category it redirects me to the same page (...
8
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 ...
0
votes
1answer
27 views

Grey stripe started running through all my images

I've recently encountered a bizarre situation where a grey bar started showing up through all my generated images. The original image is clean and as it is being compressed a gray bar is added to all ...
0
votes
1answer
135 views

Why do child categories incorrectly inherit custom design from their parent when “Use Flat Catalog Category” is enabled?

On Magento 1.9.2.4, when "Use Flat Catalog Category" is set to "Yes", a child category will sometimes inherit the settings from its parent category, even if the dropdown for "Use Parent Category ...
0
votes
1answer
781 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 ...
2
votes
3answers
17k 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') ...
1
vote
0answers
443 views

Add custom category attribute in flat tables

There is an custom category attribute with code "filter_param". I want to use this attribute while preparing the top navigation menu and the flat tables are enabled. I want to access this attribute ...
2
votes
0answers
63 views

Non default store_view's product attribute value is not visible on frontend (product list) if store_view 0 EAV value is missing

Scenario: A Magento 1.7 store which has NO default values at all for some product attributes (like short_description). There is no entry in catalog_product_entity_text for store_view==0. (Even NO ...
1
vote
0answers
46 views

Filtering product collection producing incorrect behaviour with flat catalog enabled in admin

I am using the below code for get most-viewed product in my store front: $storeId = Mage::app()->getStore()->getId(); $products = Mage::getResourceModel('reports/product_collection') ->...
1
vote
1answer
133 views

Products in catalog_product_flat_1

Is it normal that not all our products are not listed in catalog_product_flat_1 even after I have reindexed catalog_category_product or did i reindex the wrong index here ? I want to avoid reindexing ...
1
vote
1answer
932 views

What triggers the partial re-index on attribute mass update?

I'm having a hard time figuring out what fires off the flat table update (partial re-indexing) when a attribute mass update is done from the Manage Catalog page in the admin. When you mass-update ...
5
votes
1answer
1k views

How to get rid of Base table or view not found: 1146 Table 'catalog_category_flat_store_1' doesn't exist?

Base table or view not found: 1146 Table 'catalog_category_flat_store_1' doesn't exist I have see some answer for this question but its quick fix after some time I have same issue. But I get this ...
1
vote
0answers
187 views

Custom product attribute source model and Flat tables

How to create new product attribute with custom source model (related to custom table), which will be built in Product flat table like normal Source attribute?
0
votes
1answer
104 views

Magento Flat Catalog Category/Product

I have a Magento 1.9.0.1 running for a year and it's a little bit slow when returning products, since they are a lot. I read about the flat catalog category and flat catalog product options and i want ...
1
vote
2answers
186 views

flat tables no meta title

Does anyone know why meta_title attribute is missing both for product and category flat tables? I can see meta_description and meta_keyword fields in the flat tables but no meta_title. So I am forced ...