I have created a set of custom variable in my sales_flat_quote_item
and sales_flat_order_item
and saved custom field values into sales_flat_quote_item
using the observer <checkout_cart_product_add_after>
as below,
<checkout_cart_product_add_after>
<observers>
<ucs_catalogorder_checkout_cart_product_add_after>
<type>model</type>
<class>Ucs_CatalogOrder_Model_Observer</class>
<method>checkoutCartProductAddAfter</method>
</ucs_catalogorder_checkout_cart_product_add_after>
</observers>
</checkout_cart_product_add_after>
Then added the same into sales_flat_order_item
using below code snippet
<fieldsets>
<sales_convert_quote_item>
<card_wallet_amount>
<to_order_item>*</to_order_item>
</card_wallet_amount>
<card_handling_charges>
<to_order_item>*</to_order_item>
</card_handling_charges>
<user_preferred_delivery_mode>
<to_order_item>*</to_order_item>
</user_preferred_delivery_mode>
<message_title>
<to_order_item>*</to_order_item>
</message_title>
<message_description>
<to_order_item>*</to_order_item>
</message_description>
<card_library_image>
<to_order_item>*</to_order_item>
</card_library_image>
<wrapper_library_image>
<to_order_item>*</to_order_item>
</wrapper_library_image>
</sales_convert_quote_item>
</fieldsets>
But after completing the payment process the same has not been saved into either sales_flat_order
or sales_flat_quote
Then added the same into sales_flat_order_item using below code snippet
cannot understand question andBut after completing the payment process the same has not been saved into either sales_flat_order or sales_flat_quote
checkout_cart_product_add_after
custom values are being saved intosales_flat_quote_item
so<fieldsets>... </fieldsets>
save the same intosales_flat_order_item
. But$order = Mage::getModel('sales/order')->load($orderId);
get the details from sales_flat_order` so those custom fields onsales_flat_order_item
should be saved intosales_flat_order
. Its not happening.sales_flat_order_item
tosales_flat_order