adding fields to order table

[d1rage5]

I need to add a few fields to the orders table.

customers_lastname
and
customers_firstname

and make sure that it pulls this info from the customer table.

right now it pulls customers_name and puts it together but i am working on an xml export that has to have first and last name separate

Can someone help on this?

[d1rage5]

ok i was able to add the two fields.

Now how would i go about getting the data to populate on new orders now, dont really care about old orders.

[Ajeh]

Do a search in the Tools ... Developers Tool Kit ... in the bottom input box for:
delivery_name
billing_name
customers_name

This should give you an idea of where an existing field from the orders table is addressed ...

NOTE: customers_name is used for other things, but look for the similarities between these ...

[d1rage5]

This is the only thing i really found that looks close......

/xxxxxx/includes/classes/order.php

Line #138 : $this->delivery = array('name' => $order->fields['delivery_name'],

Line #579 : 'delivery_name' => $this->delivery['firstname'] . ' ' . $this->delivery['lastname'],

So would i add something like the following?

$this->customer = array(
'firstname' => $order->fields['customers_firstname'],
'lastname' => $order->fields['customers_lastname'],

and / or this ?

$sql_data_array = array(
'customers_firstname' => $this->customer['firstname'],

'customers_lastname' => $this->customer['lastname'],

[d1rage5]

OK got it working

only add these two fields

'customers_firstname' => $this->customer['firstname'],
'customers_lastname' => $this->customer['lastname'],

Under the following string

$sql_data_array = array(