PayPal Standard plugin - credit card authorization code.

3 years ago
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.
3 years ago
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.
3 years ago
Could you please explain more about PayPal Standard does "log" a txn_id in the Order Notes.

What is txn_id? What table?


Thanks.
3 years ago
txn_id is a Unique Transaction ID, that is generated by PayPal
3 years ago
I am not able to find this field in Order table.
3 years ago
It's in the [OrderNote] table.
3 years ago
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
3 years ago
It's in the  [Note]  field.  You will need to parse it out.
3 years ago
My Note field has like this value ""Order placed" email (to store owner) has been queued. Queued email identifier: 37."