Add product attribute value into sales_flat_order table while create order from admin side

Hello Everyone,

Redemption Code is an attribute of catalog product and this is multiselect type attribute.

I want to save the redemption_code into sales_flat_order table for that i have created redemption_code field into sales_flat_order table.

I have implemented this functionality from the frontend side and it works fine there is no any issues from the frontend side.

But now i want to do this from the admin side, when i create order from the admin side that time i have to add this functionality for that i have rewrite the Mage_Adminhtml_Block_Sales_Order_Create_Search_Grid and added the redemption_code column and display the redemption code for the respective products into grid rows.

1) When i click “Add Products” button from the “Items Ordered” section then it will open 

grid with products and there i can select product and press “Add Selected Products to Order” button to add selected product into order. 

2) Now selected product has been added to order now here i want to display the redemption code in columns of selected product. 

3) when i click the “Submit Order” button then it will create order and save the order detail and product detail into sale flat order table along with i also want to store the redemption code for that product into sales flat order table.

Please let me know if someone have answer to my question. i am really very stuck at here.

Thanks,

Jignesh