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!