Authorize.net Gateway Approved order status not showing

[MarkBlank]

I am using v6.1.13 and Authorize.net as a payment gateway. I am using the order ID as a license key for my software and am trying to check the database for the order status, which remains as processing (in the order summary and order history sections) even after the order has been approved and completed. 

I assume that since there is a dropdown  that allows me to change the status, it doesn't update automatically. The only place I see that the order is approved is in the Transaction Logs tab for the order. I would like my software to log into the database and check that status to allow the license key to be used or not if the order was declined. I have been able to get all of the other info I need from the tables.

My questions are: 

Does Cubecart automatically update the status anywhere other than the transaction log?

If Auth.net response came back as declined, would the status "Processing" change to declined in the order summary overview tab or order history tab, but remains as processing if the order is approved?

If not, does it store that status in a database table? I can't find it if it does.

Or, is the transaction log populated with a call to Auth.net and is never really stored on the site?

Does anyone have another idea of how I may be able to check if the order was approved or declined?

I have been through all of the status columns I can find for a particular order in the database tables and changed them to something besides "1" or "2" and the transaction log status does not change. Also, if I tried to get the info from Auth.net, the Cubecart order ID is not associated with the Auth.net transaction ID, so that's out.

Thanks in advanced for any help!

[bsmither]

Welcome MarkBlank! Glad to see you made it to the forums.

1. It is the responsibility of the payment gateway module to move an order to Processing on a successful transaction (or to forceably move it to Pending if failed). The module is also responsible to log its actions in the transaction log. The module calls a routine in CubeCart's core code to make the move, and this code is responsible for emailing the customer, emailing the admin, adjusting stock levels, creating links to downloadable digital products, and updating the database table CubeCart_order_summary - the 'status' column is the code for the various states an order can have.

2. The module would force the order to Pending. In /modules/gateway/Authorize/gateway.class.php, we see that Authorize returns a response code. The module interprets that response code into a phrase, and this phrase is logged. It is shown in the Transaction Logs 'Status' column.

3. All order transactions are logged in CubeCart_transactions.

4. The table CubeCart_transactions is populated with data received by the payment gateway module when the payment processor makes an Instant Payment Notification (IPN).

5. Authorize.net should also email you when a transaction has happened - whether approved or otherwise. (This has generally been 98% reliable, give or take.) In CubeCart, there is a choice to have an email sent to the main admin and any sub-admins when an order goes to Pending or Processing (not both, and no other status). Also, in CubeCart's admin, Dashboard (the initial screen shown to you), Unsettled Orders tab, shows a list of all Pending and Processing orders.

6. The Authorize.net module sends the Cart Order Number as 'x_invoice_num' and as 'x_description'. (It's been awhile since I looked at my Merchant Account screens at Authorize.net, but I recall seeing the cart_order_id on the transaction details page. But probably not on any summary listing. The email Authorize.net sends, the "Merchant Email Receipt" has all desired data.

Edited January 25, 2018 by bsmither

[MarkBlank]

Hi bsmither,

Thank you for the reply! I am glad it was you who answered my question. I have read a lot of these forum posts and you know what you're doing with Cubecart. This is, by far, the best shopping cart software I have used (and I have used lots of them, paid or open source).

I somehow skipped the CubeCart_transactions table. I don't know how I missed it. Maybe because it was the last one on the list in phpMyAdmin or my brain is fried after writing 18,000 lines of code for accounting software along with writing tutorials and setting up the site and the gateway, PCI compliance..... etc.

You just gave me exactly what I needed and made me feel stupid, but providing the solution to my self-imposed, oversighted problem trumps my ego! You have my respect.

Thank you again and I hope extremely great things come your way for all of the help you provide CubeCart users!

 

Edited January 25, 2018 by MarkBlank