Admin Email Confirmation + Customer Company name not showing

[MjrGaelic]

This one has been driving me nuts for a while now. I've searched, and posted on it for a while and still don't have the customers company name showing up in the email that is sent to me.

 

Here is what I have done thus far:

 

In the data base I had to add:

 

Order table:

 

customers_company varchar(32)

delivery_company varchar(32)

(we don't care about billing *smile*)

 

So that was cool.

 

Then in my checkout_success.php I have:

 

$sql_data_array = array('customers_id' => $customer_id,

'customers_name' => $order->customer['firstname'] . ' ' . $order->customer['lastname'],

'customers_company' => $order->customer['company'],

'customers_street_address' => $order->customer['street_address'],

'customers_suburb' => $order->customer['suburb'],

'customers_city' => $order->customer['city'],

'customers_postcode' => $order->customer['postcode'],

'customers_state' => $order->customer['state'],

'customers_country' => $order->customer['country'],

'customers_telephone' => $order->customer['telephone'],

'customers_email_address' => $order->customer['email_address'],

'customers_address_format_id' => $order->customer['format_id'],

'delivery_name' => $order->delivery['firstname'] . ' ' . $order->delivery['lastname'],

'delivery_street_address' => $order->delivery['street_address'],

'delivery_company' => $order->delivery['company'],

'delivery_suburb' => $order->delivery['suburb'],

'delivery_city' => $order->delivery['city'],

'delivery_postcode' => $order->delivery['postcode'],

'delivery_state' => $order->delivery['state'],

'delivery_country' => $order->delivery['country'],

'delivery_address_format_id' => $order->delivery['format_id'],

'payment_method' => $order->info['payment_method'],

'cc_type' => $order->info['cc_type'],

'cc_owner' => $order->info['cc_owner'],

'cc_number' => $order->info['cc_number'],

'cc_expires' => $order->info['cc_expires'],

'date_purchased' => 'now()',

'orders_status' => DEFAULT_ORDERS_STATUS_ID,

'comments' => $order->info['comments'],

'currency' => $order->info['currency'],

'currency_value' => $order->info['currency_value']);

 

 

and somewhere down below all that I have:

 

// send emails to other people

if (SEND_EXTRA_ORDER_EMAILS_TO != '') {

tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO,

EMAIL_TEXT_SUBJECT . ' for' . $insert_company,

'Customer: ' .$order->customer['firstname'] . ' ' . $order->customer['lastname'] . "n" .

'Company: ' .$order->customer['company'] . "n" .

'Email: ' .$order->customer['email_address'] . "n" .

'Telephone: ' . $order->customer['telephone'] . "nn" .

nl2br($email_order),

STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, '');

}

 

(that was from Linda).

 

What seems to be happening is that the email is generated but the company name is not being grabbed from the customer_id.. I've confirmed, and the company names are in fact there..

 

The email that comes out of it all looks like: (edited of course):

 

Customer: correct

Company:

Email: correct

Telephone: correct

 

Parts Plus

------------------------------------------------------

Order Number: correct

Detailed Invoice: correct

Date Ordered: correct

 

lotsa comments here

 

Products

------------------------------------------------------

correct

------------------------------------------------------

Sub-Total: correct

Tax: $0.00 (we don't do taxes)

Total: correct

 

Delivery Address

------------------------------------------------------

correct minus company name..

 

Yes, of course both /includes/application_top.php and /admin/includes/application_top.php both have define('ACCOUNT_COMPANY', 'true');

 

I would really appreciate any fresh ideas, I'm all out..

 

Regards,

 

Ryan

[xarly]

Ryan,

 

I have a similar problem, the Company Name does not show up on the invoice.

Did you ever get an answer on this ?

 

Ben