Using ProductCart - Authorders Tabl

Print Page | Close Window

Authorders Tabl

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4350
Printed Date: 04-March-2025 at 8:31pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Authorders Tabl

Posted By: SharpDataInc
Subject: Authorders Tabl
Date Posted: 07-March-2011 at 3:41pm

Customers are placing orders using their credit cards and are receiving the emails with a transactionid from Authorize.Net. I thought the table authorders was suppose to be tied to the idOrder with the trans_id from authorize.net. There are NO records in this table, though customers are receiving information that their order was processed and we are getting the green flag for paid. Doesnt PC get the transactionid back and create a record for it?

Thanks

SDI

-------------
Sharp Data Incorporated

Replies:

Posted By: ProductCart
Date Posted: 07-March-2011 at 3:53pm

Information is saved to the database only when Autorize.Net is set to Authorize Only. For details on this, please see: http://wiki.earlyimpact.com/developers/ordersaving - http://wiki.earlyimpact.com/developers/ordersaving

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: SharpDataInc
Date Posted: 07-March-2011 at 6:46pm

Mmmm, i dont see the flag anywhere in PC. How can you set that flag "Authorize Only"? Its not under the payment options, and I cant find "Auth_Only" flag. Settings.asp doesnt have it, neither does the SaveOrd.asp or OrderVerify.asp....

Thanks for the help!
SDI

-------------
Sharp Data Incorporated

Posted By: ProductCart
Date Posted: 07-March-2011 at 6:54pm

It's the "Transaction Type" setting on the page where you set the settings for Authorize.net.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: SharpDataInc
Date Posted: 07-March-2011 at 6:54pm

Wait is this the dropdown for "...payment status to:". Set that to "Authorized", then once the transaction is authorized and funds are transferred it sends the transactionId back to PC and the records get created in the Authorders table w/ the transaction numbers in the 'trans_id' field. Is that the ticket?

Thanks
SDI

-------------
Sharp Data Incorporated

Posted By: ProductCart
Date Posted: 07-March-2011 at 6:57pm

Please see our reply above.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: SharpDataInc
Date Posted: 07-March-2011 at 6:58pm

Okay, great thanks it was set to "Sale". So what is the purpose of the payment status? If I set that to "Authorized", does the flag change once the transaction is complete? Should that be anything particular for it to work as I changed it to "Authorize Only", or is mainly for interanal use only where the merchant would change it?

Thanks
SDI

-------------
Sharp Data Incorporated

Posted By: ProductCart
Date Posted: 07-March-2011 at 7:08pm

The "Payment Status" is an internal "status" flag. Yes, it will change when you batch-process an order since ProductCart knows that a successfully batch-processed order has also been captured on the payment gateway side (and therefore can be considered "Paid").

http://wiki.earlyimpact.com/productcart/orders_payment_status - More on the payment status

Imagine a "Net 30" custom payment option, for which there is no payment gateway involved, and you can see why the Payment Status flag exists within the Control Panel, independent of the payment gateway.

-------------
The ProductCart Team

Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software

Posted By: SharpDataInc
Date Posted: 07-March-2011 at 7:30pm

Great! This is good stuff! Okay now we already have some orders and I set that flag for "Authorize Only". There is a record now in the Authorder table, solid! But there isnt a trans_id, does that get filled in later when its processed by Authorize.Net and it sends a ID number for PC?

Thanks for all the information and help!
SDI

-------------
Sharp Data Incorporated

Posted By: SharpDataInc
Date Posted: 07-March-2011 at 8:50pm

They have 3 records now; authcode has numbers, transtype is "AUTH_ONLY", CC, encrypted numbers, every field is filled in. Looks good except no "trans_id", is there something else I am missing?

-------------
Sharp Data Incorporated

Posted By: SharpDataInc
Date Posted: 07-March-2011 at 8:55pm

Ah, looking further in to this, I see the "Transaction ID:" in the Payment Details section under the Payment Status tab for the buyer(clicking on 'View&Process Order'). Where is that field located?

Thanks
SDI

-------------
Sharp Data Incorporated

Posted By: SharpDataInc
Date Posted: 07-March-2011 at 8:58pm

Ha, answering my own questions. Its not in the Authorders table its in the orders table gwTransID! I got it, thanks!

SDI

-------------
Sharp Data Incorporated