Magento – Custom field in sales_flat_quote_item not being transferred to sales_flat_order_item

ordersquote

Both tables have the same custom field added to it.
I have an observer listening for "sales_quote_item_set_product". I'm setting the field like this:

$quoteItem->setData("custom_code", "TEST");

If I go to sales_flat_quote_item, I can see the custom_code field being populated with "TEST". Once I place the order, the corresponding entry in sales_flat_order_item still has custom_code==null.

Do I need to listen for another event? Is there one like sales_order_item_set_product? I searched around and didn't see anything.

Best Answer

I figured it out. I needed to add this to my extensions config.xml file:

    <fieldsets>
        <sales_convert_quote_item>
            <custom_attribute>
                <to_order_item>*</to_order_item>
            </custom_attribute>
        </sales_convert_quote_item>
        <sales_convert_order_item>
            <custom_attribute>
                <to_quote_item>*</to_quote_item>
            </custom_attribute>
        </sales_convert_order_item>
    </fieldsets>

Related Solutions

Magento 1.9 Orders – Order Confirmation Not Being Sent

Assuming you cleared cache, flushed apc/OPcache (if in use), ran compilation process (if in use), here is a small list of things to check:

Check if all 1.9.1 files have been copies over
Open app/code/core/Mage/Sales/Model/Order.php and look for queueNewOrderEmail method
If the method does not exist you don't have latest file
If the method exists check if some third party module is rewriting the class and check your local code pool for override of the given class

Magento 2 – How to Convert Custom Quote Field to Order Field

add the fields to both table quote and sales_order via a setup script in your module.

Then add an event in your module (see below)

 <?xml version="1.0"?>
    <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
            xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">
        <event name="sales_model_service_quote_submit_before">
            <observer name="quote_submit_before" instance="Vendor\Module\Observer\QuoteSubmitBefore" />
        </event>
    </config>

Finally save the quote data against your order

class QuoteSubmitBefore implements ObserverInterface
{

    /**
     * @param Observer $observer
     * @return void
     */
    public function execute(Observer $observer)
    {
       $quote = $observer->getQuote();
       $order = $observer->getOrder()

        $order->setData('field_custom', $quote->getData('field_custom'));      
    }
}

Best Answer

Related Solutions

Magento 1.9 Orders – Order Confirmation Not Being Sent

Magento 2 – How to Convert Custom Quote Field to Order Field

Related Topic