Questions tagged [flat]
The flat tag has no usage guidance.
41 questions
0
votes
1
answer
73
views
What is the restriction on flat catalog if my store has more than 500K SKUs?
I have a customer with more than 5 million products and 2500 attributes. They are using
an external system to push products to specific ecommerce sites. They would like to push 500,000
product to ...
- 1,246
0
votes
1
answer
94
views
Magento 2 How load product by sku and boot the system minimally?
Me need minimal load system that get ONLY: Product Name, Product Type, Product Url, Thumbnail Url, Price, Sub products for Configurable.
Preferably use catalog_product_flat_ table (i think it's good ...
- 165
0
votes
1
answer
564
views
Magento 2 - Get disabled product by sku
I try to get disabled products by sku. These products are not in flat table, so I can't use collections to find them.
I tried some methods to find products, but it doesn't work Magento 2.3.2:
...
- 154
0
votes
1
answer
462
views
Magento 2 - Multi Flat shipping not showing frontend checkout [closed]
I am using Meetanshi Flatshipping extension. I have added flat rate in admin based on country but flat shipping is not showing on checkout page.I have 5 shipping methods for UK, only 4 are showing on ...
- 301
2
votes
1
answer
239
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 ...
0
votes
0
answers
28
views
Magento 1.8 Flat table disable after invoice not creating
Issue: Invoice not created.
Note: Flat tables activated. Problem disappears when Flat tables are disabled.
- 11
1
vote
1
answer
2k
views
How to add another flat rate shipping option?
Magento 1.9.1
Porto theme
I am trying to add another Flat rate shipping option.
I followed these steps here but I am not certain as to where to find the 2nd Flat rate shipping option:
How to add ...
- 280
6
votes
1
answer
626
views
Flat rate still showing after disabled
Magento 2.1.4 : Disabled flat rate via store > configuration > sales > shipping method like this:
I have already deleted the cache, upgrade, static content deploy but it keeps showing the flat rate ...
- 2,494
1
vote
2
answers
332
views
what is a flat catalog in Magento [duplicate]
I don't really understand what the flat catalog is?.
Will it change the appearance of my category pages?
My problem is that the product blocks are all squeezed together looking. Once clicked on, ...
- 19
1
vote
0
answers
82
views
Ultimate Multi Flat Shipping extension, stop rounding price [closed]
I have installed Ultimate Multi Flat Shipping extension to my magento application. I want to stop rounding price.As example when I enter 3.325,it saved as 3.33. I want to stop this and want to keep it ...
- 11
0
votes
1
answer
53
views
How to create entities related to themselves, magento 1.9
I sent this question some days ago:
"I'm using the module Ultimate Module Creator to create new entities and relate them to products, categories and between them.
But I don't know how to relate the ...
2
votes
1
answer
1k
views
Magento 2: Flatrate shipping price is not updating
In the first checkout step, where we are providing shipping address I'm updating flatrate price according to the zip code given. The updated price is saving to core_config_data table as usual.But when ...
- 386
0
votes
1
answer
304
views
Custom Category Attribute not in Repository
I created a custom category multiselect attribute. (it's even a custom source but that does not matter).
Everything is OK on save, admin forms OK, even the flat contains my values. ( thx to https://...
- 554
0
votes
1
answer
1k
views
Adding Tracking to sales_flat_order table
We use an module call iparcel for International Orders.
These orders get immediate tracking information and this updates in the correct tables needed for normal tracking use case, however, we use a ...
6
votes
3
answers
680
views
why magento doesn't enable flat model by default?
we can see that the following two options at
system > configuration > system > catalog
1.Use Flat Catalog Category
2.Use Flat Catalog Product
it is clear that the flat model reduces the ...
- 366
0
votes
1
answer
118
views
what are the flat tables created by magento system while indexing?
How magento creates flat tables and what are the entities that are converted to flat table?
Can you list all the flat tables created by magento?
What are the events which lead to indexing required?
0
votes
1
answer
263
views
The changes I do in back-end panel doesn't reflect in front-end.
I am new to Magento. I am trying to configure a Magento Site that runs 1.8 version. I want to provide free shipping to customers only if the order value is above 300, else charge 30 per delivery. I ...
- 1
0
votes
1
answer
943
views
Flat Rate and Table Rate
I have Flat rate shipping as the standard for all of my products $6.95, but I have a category that needs to be $14.95 because it is a tube and cost more to ship. How can I make $14.95 the default for ...
- 1
1
vote
2
answers
2k
views
How to Join an EAV to a Flat Table & Import Flat Table and Update EAV
This will be two parts
1.) Join an EAV to a Flat Table the Magento way
2.) Import into Flat Table that will update the EAV Table.
Basically be able to Export(Flat Table) and Import(with flat table) ...
- 657
0
votes
1
answer
88
views
Flat rate shipping option totally ignored
I have only one shipping method in my shop. $3.99 flat rate. Everything else is set to not be enabled.
Does anyone know why Magento would just ignore this shipping rule and apply what I can only ...
- 133
1
vote
0
answers
128
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 ...
- 469
0
votes
2
answers
308
views
Error after enabling flat categories and products
I enabled flat categories and products and then re-indexed the data. I also cleared the cache but I am still getting this error on the product page. Everything works perfect when the FLAT option is ...
- 175
0
votes
1
answer
212
views
How to include weight requirements for shipping method [closed]
So for a certain shipping method in our store(called flat rate) we want to charge two different flat rates: one for orders that weigh no more than 13 ounces, and another for orders between 14 ounces ...
- 101
2
votes
2
answers
1k
views
Index "catalog_product_flat" disappeared after update to 1.9x
After updating from 1.7.0.2 to 1.9.2.1 the catalog_product_flat index is not longer shown.
The index is neither shown in Magento Backend nor if i call
php shell/indexer.php info
It is activated ...
- 321
2
votes
1
answer
131
views
2 flat rates based on category
I have a magento shop that will be selling both frozen and non-frozen foods. I'm trying to figure out how to set two straight flat shipping prices. One for each.
As well as this, i need to set it so ...
- 131
0
votes
1
answer
44
views
getting category number without accessing category_flat
On occasion our category_flat table isn't available. This causes some areas of our codebase to break. How can I get the category number of a given category without accessing this table? Thx.
- 1,277
1
vote
1
answer
1k
views
Unable to reindex flat category
Magento 1.8.x; Ultimo theme
Didn't find anything for this probably popular problem.
After reindex categories on localhost I have this:
2015-04-29T11:20:44+00:00 DEBUG (7): Exception message: ...
- 3,846
0
votes
1
answer
611
views
RAW Query on sales_order_item seems not working
I'm trying to update a sales_order_item data without success.
No exception or error is returned with method A):
$data = array('order_item_custom_field'=> $product->getCustomFieldData());
$model ...
- 775
2
votes
2
answers
616
views
Cannot delete category if flat catalog index is enabled
I am using the following code to delete a category from my Magento installation programmatically:
$hostId = $model->getId()->getHost();
$category = \Mage::getModel('catalog/...
- 171
1
vote
3
answers
9k
views
4
votes
2
answers
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()
->...
- 1,101
2
votes
2
answers
3k
views
Retrieve table name from collection
How can I retrieve table name from Magento collection. My case: observer listens catalog_product_collection_load_before event. Here we can get product collection. But I need exactly which table is ...
- 6,234
0
votes
0
answers
399
views
Issue with EE 1.14, flat category and categories' url keys [duplicate]
I hope you can help me with this strange error.
Currently, we are working in a store with EE 1.14 and we are seeing a problem with category's url keys and url paths: They always return null. For ...
0
votes
1
answer
1k
views
catalog_product_flat is not taking new attributes
Flat product table, once enabled should be used solely to display a product.
Am I wrong ?
So, if I add attributes, how can I add these in the flat tables..?
example of a line I get on ...
- 131
1
vote
1
answer
142
views
Is there any reason not to include every attribute in the product flat tables ('Used in Product Listing" - Yes)
While building google product feeds, I found it necessary (or at least helpful) to add a few attributes to the product flat table which I normally don't use in my listings.
Is there any reason not ...
- 295
2
votes
1
answer
2k
views
Join stock information problems with flat products
I have this solution to filter out of stock products by joining a field from cataloginventory/stock_item (the is_in_stock field) from my product collection and this works as intended with non-flat-...
- 113
1
vote
1
answer
2k
views
Which attributes go into the catalog_product_flat* tables?
In app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Flat/Indexer.php (Magento 1.5)
or in app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php in later versions I believe:
...
- 1,318
2
votes
1
answer
137
views
total_weight column in sales_flat_shipment is always null in enterprise 1.13.0.2
As the title says: total_weight column in sales_flat_shipment is always null.
Can this be a bug?
- 431
2
votes
0
answers
501
views
how to create a 30% off promotion with flat shipping and exclude one category [closed]
I want to create a promotion that gives flat shipping rate and and 30% discount as well but I want to exclude one sale category from it.
I made one myself for the discount but whenever I add anything ...
- 31
-5
votes
1
answer
784
views
the table 'sales_quote_address' is no longer exists in 1.7 above
I found in 1.7 and 1.8 the table 'sales_quote_address'is no longer exist.
Then which table does the code 'Mage:getModel('sales/quote_address')' loaded?
How can I add one more column to the '...
- 97
1
vote
2
answers
638
views
Why would product not be indexed?
I have a configurable product which is enabled, and visible in catalog, search. It has a child product which is also enabled, and in stock. But the product is not visible on the frontend.
I have ...
- 1,116