Questions tagged [flat]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
23 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 ...
2
votes
1answer
30 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
0answers
12 views

Force use of Flat Tables in Rest API

I'm wondering how to force the use of FLAT Tables in Rest API. I have a product API which is using the Magento\Catalog\Model\ResourceModel\Product\CollectionFactory. I've enabled the Flat Tables in ...
0
votes
0answers
21 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.
1
vote
1answer
692 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 ...
3
votes
1answer
289 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 ...
0
votes
2answers
185 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, ...
1
vote
0answers
79 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 ...
0
votes
1answer
37 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
1answer
738 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 ...
0
votes
1answer
199 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://...
0
votes
1answer
747 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
3answers
519 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 ...
0
votes
1answer
98 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
1answer
132 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 ...
0
votes
1answer
740 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
vote
2answers
1k 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) ...
0
votes
1answer
66 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 ...
1
vote
0answers
104 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 ...
0
votes
2answers
250 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 ...
0
votes
1answer
201 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 ...
1
vote
2answers
933 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 ...
2
votes
1answer
107 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 ...
0
votes
1answer
30 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
vote
1answer
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: ...
0
votes
1answer
467 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 ...
2
votes
1answer
409 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/...
1
vote
3answers
7k views

Use Flat Catalog Category disable

Use Flat Catalog Category in Catalog is disable or Hide, Why?
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() ->...
2
votes
2answers
2k 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 ...
0
votes
0answers
374 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
1answer
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 ...
1
vote
1answer
139 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 ...
2
votes
1answer
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-...
1
vote
1answer
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
vote
1answer
121 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?
2
votes
0answers
500 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 ...
-5
votes
1answer
712 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 '...
1
vote
2answers
301 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
vote
1answer
2k views

Why some delivery methods are not available for some customers?

I have 4 shipping methods. The old customer gets only 2 methods. I've created the same customer with another email. It gets all 4 shipping methods. I dived into code and DB table ...