Questions tagged [flat-catalog]

Denotes questions related to flat catalog feature of magento

39 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
28
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 ...
6
votes
1answer
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 ...
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.
4
votes
0answers
93 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
51 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 ...
2
votes
0answers
100 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 ...
2
votes
0answers
103 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
0answers
63 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, ...
2
votes
0answers
68 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 ...
2
votes
0answers
2k views

Index Management - Catalog Category Flat Data - Stuck on processing

The Catalog Category Flat Data has been now stuck for weeks and i can't seem to fix it. I tried to change the corresponding table in the database: TRUNCAT catalog_product_flat_1, ...
1
vote
1answer
75 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
0answers
119 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 ...
1
vote
0answers
50 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 ...
1
vote
1answer
234 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: ...
1
vote
0answers
167 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 ...
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 ...
1
vote
0answers
498 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 ...
1
vote
0answers
48 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
0answers
193 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?
1
vote
1answer
181 views

Best sellers and Flat Catalog?

I have installed Magento and used a custom theme. I want to use a Best sellers widget on my homepage, but it doesn't work with Flat Catalog I have enabled on categories and products. As I understand ...
1
vote
0answers
120 views

Assign Sort Order of Product in Category with Catalog Flat Enabled

Hello I'd like to Assign Sort Order of Product in Category with Catalog Flat Enabled, is there a workaround to let this custom method I've created work without calling the admin store? Right now trows ...
1
vote
0answers
62 views

Flat tables enabled only for one store view

We have 2 store view: one "fr" and one "en". We keep getting an undefined method on "addAttributeToSelect" but only for one store view. I've used "var_dump" to display the result of this: $...
1
vote
0answers
713 views

Call to undefined method Category_Flat::getProductsPosition Model/Category.php on line 330

We are seeing an error in cron PHP Fatal error: Call to undefined method Mage_Catalog_Model_Resource_Category_Flat::getProductsPosition() in app/code/core/Mage/Catalog/Model/Category.php on line 330. ...
1
vote
0answers
745 views

Fatal error: Call to undefined method Mage_Catalog_Model_Resource_Category_Flat::getProductsPosition()

I have enabled flat catalog in the magento admin. When i want to post image and hyperlink to website from facebook it cause fatal error Fatal error: Call to undefined method ...
0
votes
0answers
7 views

Flat category is missing

My main issue is : In the category I'm not retieving any products when I call $currentCateg->getProductCollection() After some digging I found the request used to retrieve these products in the ...
0
votes
0answers
19 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 ...
0
votes
0answers
10 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
134 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 ...
0
votes
0answers
29 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
0
votes
0answers
63 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
139 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(...
0
votes
2answers
414 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
36 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
0answers
455 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
289 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
1answer
90 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
1answer
192 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
126 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 ...
0
votes
1answer
1k 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 ...