1.4.8 - Store the weight of each order in the DB

Hello,

Using OpenCart v1.4.8.

I need to capture the total weight of each order after it has been confirmed and then store this value in a new column in the order table. Has anyone done this yet? If not, can someone point me to the the correct files that need to be altered in order to accomplish this?

Thank you.