The 5th annual nopCommerce conference will take place in India on the 10th-11th of October. Please find more about this event here

PayPal Standard plugin - credit card authorization code.

Posted: October 27, 2016 at 6:23 PM Quote #177910
I  am using PayPal Standard plugin to connect to PayPal. After order was paid by credit card in PayPal, I need to know credit card authorization code.

Can I use AuthorizationTransactionCode as credit card authorization code? or it is something else?

What the difference between AuthorizationTransactionCode and
AuthorizationTransactionId?

This fields are saved into the order table if processPaymentResult.Success is true. Are they are optional?

I tested PayPal locally, AuthorizationTransactionCode,
AuthorizationTransactionId and AuthorizationTransactionResult are null. What should I do to have the value in these fields?

Thanks.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: October 27, 2016 at 10:17 PM Quote #177916
I believe that PayPal Direct is the only out-of-the box payment provider that populates those fields.  (The Authorize.Net plugin does too, but it's no longer included out-of-the-box ;)

PayPal Standard does "log" a txn_id in the Order Notes.
This post/answer is useful
1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.noptools.com
Posted: October 28, 2016 at 8:16 AM Quote #177944
Could you please explain more about PayPal Standard does "log" a txn_id in the Order Notes.

What is txn_id? What table?


Thanks.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: October 28, 2016 at 1:22 PM Quote #177966
txn_id is a Unique Transaction ID, that is generated by PayPal
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: October 28, 2016 at 2:10 PM Quote #177969
I am not able to find this field in Order table.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: October 28, 2016 at 6:49 PM Quote #177970
It's in the [OrderNote] table.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.noptools.com
Posted: October 28, 2016 at 6:54 PM Quote #177971
It is no field txn_id in OrderNote table.

[Id] [int] IDENTITY(1,1) NOT NULL,
  [OrderId] [int] NOT NULL,
  [Note] [nvarchar](max) NOT NULL,
  [DownloadId] [int] NOT NULL,
  [DisplayToCustomer] [bit] NOT NULL,
  [CreatedOnUtc] [datetime] NOT NULL
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: October 29, 2016 at 10:04 AM Quote #177989
It's in the  [Note]  field.  You will need to parse it out.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.noptools.com
Posted: October 31, 2016 at 8:09 AM Quote #178033
My Note field has like this value ""Order placed" email (to store owner) has been queued. Queued email identifier: 37."
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.