Magento – Why are both configurables and simples stored in sales_flat_order_item

configurable-productdatabasesales-ordersimple-product

I am working with sales_flat_order_item using direct sql and I can't make sense of why both configurable and simple products are inserted into the sales_flat_order_item table. What is the reason behind this?

It seems like a lot of redundant data to just keep track of whether the product was added via a configurable product page vs a simple product page.

I'm just trying to understand this behaviour in case I'm missing something which could impact the accuracy of my queries.

Best Answer

mageApprentice,Magento used for business logic.It main for variance feature of configurable.Whenever a configurable product cart it save two row one is configurable product details and another is child simple product .But importance thing is that both case sku of two row is same and it is simple sku. As it save two rows,Then you can easily get:

Simple and configurable data at any times using **product_id**
It help for coupon apply.
Sales Report
Another,when configurable item c in art you can get simple product image

But in visible of order item only show those item whose parent_item_id is null.Thus you can only show configurable product details in order.

Simple product is related to configurable item using item_id

enter image description here

Related Solutions

Magento – Unable to Get Inventory Status of Configurable Products

The issue I was running into was that loadByAttribute() does not act in the same way that load() does and therefore I would need to fetch the id of the simple product then once again load the simple product. Below is the corrected code:

$productId = $_item->getProductId();
$product = Mage::getModel('catalog/product')->load($productId);
if($product->getTypeId() == "configurable"){
    $sku = $_item->getSku();
    $simpProdId = Mage::getModel('catalog/product')->loadByAttribute('sku',$sku)->getId();
    $product = Mage::getModel('catalog/product')->load($simpProdId);
}
$invStatus = $product->getResource()->getAttribute('product_inventory_status')->getFrontend()->getValue($product);
$quantity = Mage::getModel('cataloginventory/stock_item')->loadByProduct($product)->getQty();

Magento – Best way to convert configurable products to simple products

Technically configurable products ARE simple products.

In Magento a configurable product is comprised of simple products which have permutations of values that make the parent unique. These attribute values, called super configurable attributes, are the values that make each SKU unique.

Example

Let's take an example of a t-shirt. Our t-shirt can have two super configurable attributes, size and color. For simplicity let's say we only offer two variants of each of those attributes:

Red Small T-shirt
Green Small T-shirt
Red Large T-shirt
Green Large T-shirt

Easy enough.

For a configurable product to be... well... configured; you would have to have created each of those simple SKUs. That means that you likely have those simple SKUs already.

So, no conversion is needed. Simply make sure that each of those simples are now Visible and In Stock and not Disabled. Then assign them to a category and you should be in business!

Best Answer

Related Solutions

Magento – Unable to Get Inventory Status of Configurable Products

Magento – Best way to convert configurable products to simple products

Example

Related Topic