Add new field to orders and order_details

[iijb]

Hi all,

 

I added two fileds branch_code and batch_no to stock_available table. These two fields will update on new stock entry. I also created branch_code field to orders table and a batch_no to order_details table. 

 

I would like to insert branch_code( to orders table) and batch_no (to order_details table) when placing a new order. But I cant find any INSERT code for adding to orders table and order_details table for adding a new order. Please help me for how can I do it.

 

Thanks in advance

iijb

[bellini13]

you could create a module that hooks "newOrder", which is invoked every time a new order is created.  You could then update that orders record and update your custom fields with whatever logic you need to implement