Pending Credit Card Orders - Not posting orders after manual approval

[CherVickers]

Hello,
I've recently configured my credit card processing to allow me to 'validate' some iffy customer information before authorizing the order. So, the customer information goes over to Authorize and they get a message that their order is being reviewed. Authorize holds the order and I can go in and either approve it or void it.

About 98% of all my orders are approved online and fed back to me and do NOT go thru this 'special' process and are just fine.

So, back to the pending orders...
If I approve the order in authorize.net, the customer charge goes thru and I receive payment. However, I cannot figure out how to have Zen cart then go ahead and 'show' me the order in the order section of my admin pages in zencart. I have no order created (but I do show an order number in Authorize that is the next order number to be created).

Do I have to update the settings in my api? The payment settings in the module don't offer any option for this. I cannot figure out where I can configure in my admin how to do this? I talked with Authorize and they assure me they are sending the info back to zencart, but since it is not 'approve' - it is listed as FDS for review - it gets lost in space.

ideally, I would like to have these pending orders actually create orders and give me a 'pending' status so I can review.

CAn anyone tell me where to do this?

thanks!

[DrByte]

Which Authorize.net module are you using in your Zen Cart store? has it been altered for any reason?
What are all the settings (except for your private Transaction Key) for your authorize.net module, in your ZC admin?
What plugins do you have installed in your Zen Cart store?
What PHP version is your server using?
Are you saying that these FDS-hold orders are not present in your store at all? Can you find them using Search with the order number in authorize.net? What's an example order number in authorize.net for one of these held orders?

[CherVickers]

Sorry, should have listed that...

Authorize.net (AIM)

[CherVickers]

Settings have not been changed.. Just made the changes in Authorize to have orders pended until I can review.

Enable Authorize.net (AIM) Module - True
Transaction Mode - Production
Authorization Type - Authorize+Capture
Enable Database Storage - True
Customer Notifications - False
Merchant Notifications - True
Request CVV Number - True
Sort order of display. 0
Payment Zone - --none--
Set Completed Order Status - Processing [2]
Set Refunded Order Status - Pending [1]
Debug Mode - Log and Email

I have loads of plugs installed and a lot of custom code. Anything in particular that may cause issue?

PHP version - I use Hostgator so I am sure I am fine with that. (but I'm a noob so I cannot tell you)4

Are you saying that these FDS-hold orders are not present in your store at all? -. They are not present

Authorize.net back end shows me: Invoice #: 6347-xCcgis
Description: Ultra Pro-Tape (qty: 1) + HP Pro-Trucks (qty: 2) + Speedsters (qty: 1)

Can you find them using Search with the order number in authorize.net? What's an example order number in authorize.net for one of these held orders?

zencart admin shows: Error Error: Order does not exist. 6347

Does this help?
c

[DrByte]

Yes, that helps.

Another thing that could help is the Debug logs. You've got it set to Log-to-file-and-email. So I imagine you got an debug email from your store while order 6347 was being transacted. Can you paste that log information here? (I doubt the customer's identity is of any help for troubleshooting, so feel free to xxxxx that out for their privacy.)
If you didn't get it in an email, then it'll be in the /logs/ folder of your website server, so you can access it using FTP. The filename might look like 'AIM_Debug_0_1415164964_ewIN4.log' or 'AIM_Debug_6347_1415164964_ewIN4.log', shere the 1415164964 and ewIN4 will be different.

And the debug content will look something like:

Nov-05-2014 05:22:44=================================


Response Code: 1.
Response Text: (TESTMODE) This transaction has been approved.


Sending to Authorizenet: Array
(
[x_login] => *******
[x_tran_key] => *******
[x_relay_response] => FALSE
[x_delim_data] => TRUE
[x_delim_char] => |
[x_encap_char] => *
[x_version] => 3.1
[x_solution_id] => A1000003
[x_type] => AUTH_ONLY
[x_method] => CC
[x_amount] => 48.94
[x_currency_code] => USD
[x_market_type] => 0
[x_card_num] => XXXXXXXXXXXXXXXX1111
[x_exp_date] => ****
[x_card_code] => ****
[x_email_customer] => FALSE
[x_email_merchant] => FALSE
[x_cust_id] => 1
[x_invoice_num] => TEST-8-QhLzSD
[x_first_name] => Bill
[x_last_name] => Smith
[x_company] => JustaDemo
[x_address] => 123 Any Avenue
[x_city] => Here
[x_state] => California
[x_zip] => 12345
[x_country] => United States
[x_phone] => 12345
[x_email] => [email protected]
[x_ship_to_first_name] => Bill
[x_ship_to_last_name] => Smith
[x_ship_to_address] => 123 Any Avenue
[x_ship_to_city] => Here
[x_ship_to_state] => California
[x_ship_to_zip] => 12345
[x_ship_to_country] => United States
[x_description] => Die Hard With A Vengeance Linked (qty: 1) + Sample of Product General Type (qty: 1)
[x_recurring_billing] => NO
[x_customer_ip] => 172.22.22.1
[x_po_num] => Nov-05-2014 05:22:43
[x_freight] => 5.00
[x_tax_exempt] => FALSE
[x_tax] => 0.00
[x_duty] => 0
[x_device_type] => 8
[x_allow_partial_Auth] => FALSE
[Date] => November 5, 2014, 5:22 am
[IP] => 172.22.22.1
[Session] => ibefd1l95fl9036e2gbqr1i5dpou7oub
[x_test_request] => TRUE
[url] => https://test.authorize.net/gateway/transact.dll
)




Results Received back from Authorizenet: Array
(
[0] => Response from gateway
[1] => 1
[2] => 1
[3] => 1
[4] => (TESTMODE) This transaction has been approved.
[5] => 000000
[6] => P
[7] => 0
[8] => TEST-8-QhLzSD
[9] => Die Hard With A Vengeance Linked (qty: 1) + Sample of Product General Type (qty: 1)
[10] => 48.94
[11] => CC
[12] => auth_only
[13] => 1
[14] => Bill
[15] => Smith
[16] => JustaDemo
[17] => 123 Any Avenue
[18] => Here
[19] => California
[20] => 12345
[21] => United States
[22] => 12345
[23] =>
[24] => [email protected]
[25] => Bill
[26] => Smith
[27] =>
[28] => 123 Any Avenue
[29] => Here
[30] => California
[31] => 12345
[32] => United States
[33] => 0.00
[34] => 0.00
[35] => 5.00
[36] => FALSE
[37] => Nov-05-2014 05:22:43
[38] => 1D98F76B6E02D790D24E650CFE83F76E
[39] =>
[40] =>
[41] =>
[42] =>
[43] =>
[44] =>
[45] =>
[46] =>
[47] =>
[48] =>
[49] =>
[50] =>
[51] => XXXX1111
[52] => Visa
[53] =>
[54] =>
[55] =>
[56] =>
[57] =>
[58] =>
[59] =>
[60] =>
[61] =>
[62] =>
[63] =>
[64] =>
[65] =>
[66] =>
[67] =>
[68] =>
[69] => November 5, 2014, 5:22 am
[70] => 172.22.22.1
[71] => ibefd1l95fl9036e2gbqr1i5dpou7oub
[Expected-MD5-Hash] => 1D98F76B6E02D790D24E650CFE83F76E
[HashMatchStatus] => PASS
)




CURL communication info: Array
(
[url] => https://test.authorize.net/gateway/transact.dll
[content_type] => text/html
[http_code] => 200
[header_size] => 288
[request_size] => 201
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.539842
[namelookup_time] => 0.004372
[connect_time] => 0.087829
[pretransfer_time] => 0.32509
[size_upload] => 1167
[size_download] => 673
[speed_download] => 1246
[speed_upload] => 2161
[download_content_length] => 673
[upload_content_length] => 1167
[starttransfer_time] => 0.411473
[redirect_time] => 0
[redirect_url] =>
[primary_ip] => 64.94.118.151
[certinfo] => Array
(
)


[primary_port] => 443
[local_ip] => 10.0.2.15
[local_port] => 37050
)




RAW data received:
*1*|*1*|*1*|*(TESTMODE) This transaction has been approved.*|*000000*|*P*|*0*|*TEST-8-QhLzSD*|*Die Hard With A Vengeance Linked (qty: 1) + Sample of Product General Type (qty: 1)*|*48.94*|*CC*|*auth_only*|*1*|*Bill*|*Smith*|*JustaDemo*|*123 Any Avenue*|*Here*|*California*|*12345*|*United States*|*12345*|**|*[email protected]*|*Bill*|*Smith*|**|*123 Any Avenue*|*Here*|*California*|*12345*|*United States*|*0.00*|*0.00*|*5.00*|*FALSE*|*Nov-05-2014 05:22:43*|*1D98F76B6E02D790D24E650CFE83F76E*|**|**|**|**|**|**|**|**|**|**|**|** |*XXXX1111*|*Visa*|**|**|**|**|**|**|**|**|**|**|**|**|**|**|**|**|*November 5, 2014, 5:22 am*|*172.22.22.1*|*ibefd1l95fl9036e2gbqr1i5dpou7oub*

[CherVickers]

Yes. From Zen I get:

Subject: AuthorizenetAIM Alert 6347-xCcgis Dec-27-2014 12:12:45 6789475236

Dec-27-2014 12:12:45
=================================

Response Code: 4.
Response Text: Your order has been received. Thank you for your business!

Sending to Authorizenet: Array
(
[x_login] => *******
[x_tran_key] => *******
[x_relay_response] => FALSE
[x_delim_data] => TRUE
[x_delim_char] => |
[x_encap_char] => *
[x_version] => 3.1
[x_type] => AUTH_CAPTURE
[x_method] => CC
[x_amount] => 69.62
[x_currency_code] => USD
[x_card_num] => XXXXXXXXXXXXXXX7579
[x_exp_date] => 0623
[x_card_code] => ****
[x_email_customer] => FALSE
[x_email_merchant] => TRUE
[x_cust_id] => 6866
[x_invoice_num] => 6347-xCcgis
[x_first_name] => TyXXX
[x_last_name] => XXXX
[x_company] =>
[x_address] => 88XXXXX
[x_city] => RXXXX
[x_state] => FXXX
[x_zip] => 3XXXX
[x_country] => United States
[x_phone] => XXXXXXX
[x_email] => XXXXXa######################
[x_ship_to_first_name] => TXXXX
[x_ship_to_last_name] => XXXXa
[x_ship_to_address] => XXXX XXXX XXXX XX
[x_ship_to_city] => RXXX
[x_ship_to_state] => FXXX
[x_ship_to_zip] => 3XXXX
[x_ship_to_country] => United States
[x_description] => Ultra Pro-Tape (qty: 1) + HP Pro-Trucks (qty: 2) + Speedsters (qty: 1)
[x_recurring_billing] => NO
[x_customer_ip] => 173.65.241.93
[x_po_num] => Dec-27-2014 12:12:44
[x_freight] => 10.74
[x_tax_exempt] => FALSE
[x_tax] => 0.00
[x_duty] => 0
[x_allow_partial_Auth] => FALSE
[Date] => December 27, 2014, 12:12 am
[IP] => 173.65.241.93
[Session] => 90d457044d5814036b70534fa4587e6c
[url] => https://secure.authorize.net/gateway/transact.dll
)


Results Received back from Authorizenet: Array (
[0] => Response from gateway: Transaction held for review by merchant or fraud detection suite.
[1] => 4
[2] => 1
[3] => 253
[4] => Your order has been received. Thank you for your business!
[5] => 793115
[6] => U
[7] => 6789475236
[8] => 6347-xCcgis
[9] => Ultra Pro-Tape (qty: 1) + HP Pro-Trucks (qty: 2) + Speedsters
(qty: 1)
[10] => 69.62
[11] => CC
[12] =>
[13] => 6866
[14] => T(name_
[15] => K(name
[16] =>
[17] => 9(address
[18] => R(city
[19] => F(state
[20] => 33569
[21] => United States
[22] => 8XXXXXXXX
[23] =>
[24] => XXXXX######################
[25] => TXXX
[26] => KXXX
[27] =>
[28] => 9(address
[29] => R(city
[30] => Fxxx
[31] => 3xxx
[32] => United States
[33] => 0.00
[34] => 0.00
[35] => 10.74
[36] => FALSE
[37] => Dec-27-2014 12:12:44
[38] => 94345D546AF81A35CCC04C1868ED7959
[39] => M
[40] =>
[41] =>
[42] =>
[43] =>
[44] =>
[45] =>
[46] =>
[47] =>
[48] =>
[49] =>
[50] =>
[51] => XXXXXXX9
[52] => American Express
[53] =>
[54] =>
[55] =>
[56] =>
[57] =>
[58] =>
[59] =>
[60] =>
[61] =>
[62] =>
[63] =>
[64] =>
[65] =>
[66] =>
[67] =>
[68] =>
[69] => December 27, 2014, 12:12 am
[70] => 173.65.241.93
[71] => 90d457044d5814036b70534fa4587e6c
[Expected-MD5-Hash] => 94345D546AF81A35CCC04C1868EDXXXX
[HashMatchStatus] => PASS
[ErrorDetails] => Transaction held for review by merchant or fraud detection suite.
)


CURL communication info: Array
(
[url] => https://secure.authorize.net/gateway/transact.dll
[content_type] => text/html
[http_code] => 200
[header_size] => 288
[request_size] => 216
[filetime] => -1
[ssl_verify_result] => 0
[redirect_count] => 0
[total_time] => 0.758186
[namelookup_time] => 0.057633
[connect_time] => 0.072386
[pretransfer_time] => 0.138778
[size_upload] => 1110
[size_download] => 708
[speed_download] => 933
[speed_upload] => 1464
[download_content_length] => 708
[upload_content_length] => 1110
[starttransfer_time] => 0.160209
[redirect_time] => 0
)


RAW data received:
** removed by moderator **


and from Authorize I get:

-----Original Message-----
From: Authorize.Net Auto-Receipt [mailto:[email protected]]
Sent: Saturday, December 27, 2014 1:13 AM
To: JAMES VICKERS
Subject: Merchant Email Receipt

**Please DO NOT REPLY to this message. E-mail [email protected] if you have any questions.

========= SECURITY STATEMENT ==========
It is not recommended that you ship product(s) or otherwise grant services relying solely upon this e-mail receipt.

========= GENERAL INFORMATION =========

Merchant : PROWOOD FINGERBOARDS (1134837) Date/Time : 27-Dec-2014 1:12:44 EST

========= ORDER INFORMATION =========
Invoice : 6347-xCcgis
Description : Ultra Pro-Tape (qty: 1) + HP Pro-Trucks (qty: 2) + Speedsters (qty: 1) Amount : 69.62 (USD) Payment Method : American Express Type : Authorized and held for review

============== RESULTS ==============
Response : Your order has been received. Thank you for your business!
Authorization Code : 793115
Transaction ID : 6789475236
Address Verification : Address Information For This Cardholder Is Unavailable

==== CUSTOMER BILLING INFORMATION ===
Customer ID : 6866
First Name : XXX
Last Name : XXX
Company :
Address : 9XXXX
City : RXXXX
State/Province : FXXX
Zip/Postal Code : XXXXX
Country : United States
Phone : 8XXXX
Fax :
E-Mail : XXXX######################

==== CUSTOMER SHIPPING INFORMATION ===
First Name : XXXX
Last Name : XXXX
Company :
Address : 9XXXXXX
City : RXXXX
State/Province : FXXX
Zip/Postal Code : 3XXX
Country : United States

======= ADDITIONAL INFORMATION ======
Tax : 0.00
Duty : 0.00
Freight : 10.74
Tax Exempt : No
PO Number : Dec-27-2014 12:12:44

========== MERCHANT DEFINED =========
Date : December 27, 2014, 12:12 am
IP : 173.65.241.93
Session : 90d457044d5814036b70534fa4587e6c

[CherVickers]

I really don't think it is a bug, I think it is a setting that I do not know where to go to set!

[DrByte]

[0] => Response from gateway: Transaction held for review by merchant or fraud detection suite.
[1] => 4
[2] => 1
[3] => 253
[4] => Your order has been received. Thank you for your business!
[5] => 793115
[6] => U
[7] => 6789475236
[8] => 6347-xCcgis

When you posted here, you selected v1.5.0 as your ZC version. But the original code for ZC 1.5.0 (dated 2011) already has proper support for handling [3] => 253. Specifically, it sets the order-status to '1' (which in an unmodified ZC system is the numeric value for the "Pending" status), and saves the order along with a comment saying it's been held for review. It also mentions the "held for review" message in the admin-copy of the order-confirmation email.

Is it possible your authorizenet_aim.php module is from an older version of Zen Cart?

[CherVickers]

When you posted here, you selected v1.5.0 as your ZC version. But the original code for ZC 1.5.0 (dated 2011) already has proper support for handling [3] => 253. Specifically, it sets the order-status to '1' (which in an unmodified ZC system is the numeric value for the "Pending" status), and saves the order along with a comment saying it's been held for review. It also mentions the "held for review" message in the admin-copy of the order-confirmation email.

Is it possible your authorizenet_aim.php module is from an older version of Zen Cart?

I did not do the upgrade personally, but I certainly upload the latest version of authorize aim.php. I will give it a try. thanks!

[DrByte]

Be sure to do the POODLE fix to any v1.3.x or v1.5.0-1.5.3 modules: http://www.zen-cart.com/showthread.p...t-about-POODLE