Hi Folks,

I have altered the orders table to add a new field customers_coupon, this field allows me to save coupon number that's been used during the order. Could someone tell me from which file/script a new order is inserted in orders table?. I can see (via phpmyadmin) that tis new entry is created once we arrive to checkout_confirmation.php. But I could notfigure which script performs it.

here is the field I added to checkout_process.php

$sql_data_array = array('customers_id' => $customer_id,
'customers_name' => $order->customer['firstname'] . ' ' . $order->customer['lastname'],
---> 'customers_coupon' => $order->info['coupon'], <--- (I've tried many hardcoded values here)
'customers_company' => $order->customer['company'],
'customers_street_address' => $order->customer['street_address'],

I'm using paypal standard as payment method


Thanks for help.