5 replies to this topic

[samad]

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 not recognize which script performs it.

Thanks for help.

[burt]

checkout_process.php

[samad]

Ok, I know this page contains the code for inserting a new record in the orders table. But I have tried to add the new field as bellow without success

-------

$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

best regards

burt, on 03 September 2010, 16:36, said:

checkout_process.php

[samad]

Any help PLS?

[blackwater]

What is the type-field for the column you created in mysql? Is it VARCHAR?

[samad]

to Burt:

I've found the problem. As I'm using Paypal standard, the new order row is inserted from paypal_standard.php instead of checkout_process.php

thank you