Authorize.net (AIM) need Tranaction ID and Auth Code on merchant emails

[jeffmic]

Can the Authorize.net (AIM) Tranaction ID and Auth Code be inserted into the mechant email when it returns from auth only?

This is really important and a time saver to my business.

thanks,
Jeff Michaels

[jeffmic]

Just an added note:

I made a test order. I paid by credit card via Authorize.net (AIM).
I can see the Transaction ID and Auth Code in Admin/Customers/Orders at the bottom.

I went to the Authorizenet table in mySQL and the were no records...... ?!?

With that data still showing in the Admin/Customers/Orders page, where can this data be stored in mySQL.

Jeff

[DrByte]

The Admin "orders" page pulls that info from the orders_status_history table.

To add it to your admin-confirmation-emails, I would expect that this (for auth_net_aim) should work in theory (I have not tested this):
/includes/classes/order.php
approx line 971:

    // send additional emails
    if (SEND_EXTRA_ORDER_EMAILS_TO != '') {
      $extra_info=email_collect_extra_info('','', $this->customer['firstname'] . ' ' . $this->customer['lastname'], $this->customer['email_address'], $this->customer['telephone']);
      $html_msg['EXTRA_INFO'] = $extra_info['HTML'];
			
      global $payment_modules;
      if ($payment_modules->auth_code || $payment_modules->transaction_id) {
        $pmt_details = 'AuthCode: ' . $payment_modules->auth_code . '  TransID: ' . $payment_modules->transaction_id . "\n\n";
        $email_order = $pmt_details . $email_order;
        $html_msg['EMAIL_TEXT_HEADER'] = nl2br($pmt_details) . $html_msg['EMAIL_TEXT_HEADER'];
      }

      zen_mail('', SEND_EXTRA_ORDER_EMAILS_TO, SEND_EXTRA_NEW_ORDERS_EMAILS_TO_SUBJECT . ' ' . EMAIL_TEXT_SUBJECT . EMAIL_ORDER_NUMBER_SUBJECT . $zf_insert_id,
      $email_order . $extra_info['TEXT'], STORE_NAME, EMAIL_FROM, $html_msg, 'checkout_extra');
    }

[jeffmic]

thanks Doc,

I'm going to test this after I finish lunch and post my results.

Jeff

[jeffmic]

Sorry, it didn't work....

This is no Auth Code or Transaction ID from Authorizenet showing on this merchant confirmation email after inserting your code, but it's in the Admin as I listed above

thanks,
Jeff


Order Confirmation from Musical Creations Ltd.

Jxxxxxxxxxxx

Thanks for shopping with us today!
The following are the details of your order.
------------------------------------------------------
Order Number: 29
Date Ordered: Monday 30 October, 2006
Detailed Invoice:
https://xxxxxxxxxxxxxx

Products
------------------------------------------------------
1 x (FASHION) - FASHION BEATS CD = $14.95
------------------------------------------------------
Sub-Total: $14.95
US Postal Service (Priority Mail - Delivery Confirmation (2-3 days)): $5.50
NC TAX 7.0%: $1.05
Total: $21.50

Delivery Address
------------------------------------------------------
Jxxxxxxxxxx

Billing Address
------------------------------------------------------
Jxxxxxxxxx

Payment Method
------------------------------------------------------
Credit Card

Visa


-----
This email address was given to us by you or by one of our customers. If you
feel that you have received this email in error, please send an email to
[email protected]


-----
Copyright (c) 2000-2006 xxxxxxxxxx

Office Use Only:
From:
Email:
Login Name: xxxxxxxx
Login Email: xxxxxxxxx
Telephone: xxxxxxxx
IP Address: xxxxxxxxxx
Host Address: xxxxxxxxx
Date and Time: xxxxxxxxx

[DrByte]

hmmmm ....