Authorders Tabl

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
SharpDataInc Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2010 Location: Chicago Status: Offline Points: 0	Post Options Post Reply Quote SharpDataInc Report Post Thanks(0) Quote Reply Topic: Authorders Tabl 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

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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
	The ProductCart Team Home of ProductCart shopping cart software

SharpDataInc Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2010 Location: Chicago Status: Offline Points: 0	Post Options Post Reply Quote SharpDataInc Report Post Thanks(0) Quote Reply 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

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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 shopping cart software

SharpDataInc Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2010 Location: Chicago Status: Offline Points: 0	Post Options Post Reply Quote SharpDataInc Report Post Thanks(0) Quote Reply 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

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply Posted: 07-March-2011 at 6:57pm
	Please see our reply above.
	The ProductCart Team Home of ProductCart shopping cart software

SharpDataInc Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2010 Location: Chicago Status: Offline Points: 0	Post Options Post Reply Quote SharpDataInc Report Post Thanks(0) Quote Reply 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

ProductCart Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group ProductCart Team Joined: 01-October-2003 Status: Offline Points: 135	Post Options Post Reply Quote ProductCart Report Post Thanks(0) Quote Reply 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"). 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 shopping cart software

SharpDataInc Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2010 Location: Chicago Status: Offline Points: 0	Post Options Post Reply Quote SharpDataInc Report Post Thanks(0) Quote Reply 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

SharpDataInc Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 10-August-2010 Location: Chicago Status: Offline Points: 0	Post Options Post Reply Quote SharpDataInc Report Post Thanks(0) Quote Reply 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