HomeHome Product Discus... Product Discus...SmithCartSmithCartTransmit or get the orderID when executing the after payment stored procedureTransmit or get the orderID when executing the after payment stored procedure
Previous
 
Next
New Post
9/8/2011 6:04 AM
 
Rico Ledaouf
10th Level Poster


Joined: 8/31/2011
Posts: 99

Hi,

 

Is there a way to know the orderID beeing processed in the stored procedure that ius executed after the payment has been validated ? Why haven't you added a stored procedure parameter like you have done wiht the webService ?

 

Thanks.
 
New Post
9/8/2011 1:18 PM
 
Mike Damico
9th Level Poster


Joined: 12/30/2010
Posts: 190

In our old store we use to have our OrderID passed through with the payment information from Authorize.net so that we knew which order number was being paid (without having to look). I'd like to know as well.
 
New Post
9/8/2011 3:23 PM
 
Scott Kelly
1st Level Poster


Joined: 3/11/2010
Posts: 1979
At the time the cart sends the transaction to the payment gateway the orderid is not created yet so it cant be passed before the credit card transaction is approved. I believe the core question here is how do i match up or reconcile transactions between the cart and gateway and the way that is done is the payment gateway returns a number of fields that the cart saves to the database that can be used to match up transactions in the cart with those on the payment gateway. The fields that are returned by the payment gateway and saved to the payment history table and viewable on the manage order details screen you can use to reconcile are as follows:

* Transaction ID
* Authorization Code

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
9/9/2011 7:11 AM
 
Rico Ledaouf
10th Level Poster


Joined: 8/31/2011
Posts: 99

Hi Scott and thanks for your answer.

 

As I stated in my last post, the web service already has the orderID as a parameter. As the stored procedure is called at the same step, the orderID must be available in the code section executed after payment. Why it is not transmitted to the stored procedure too ?

And it will be dangerous to consider that the order reccord is the reccord who reference the last payment reccord as 2 orders can be done at the same time (or near) and the PayPal IPN can be postponed (as indicated in the PayPal help).
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartTransmit or get the orderID when executing the after payment stored procedureTransmit or get the orderID when executing the after payment stored procedure




Questions? Contact us for answers!

Contact Us!