Reconciling PayPal Express Checkout - checkout ID

Highlighted
Shopify Partner
9 0 0

Hi,

 

for the store we manage "friscoshop20" we use the API to implement the system integration of the store with ERP.
Sync also provides for order management.
One of the configured payment methods is the PayPal Express Checkout.
Our requirement is that the right information arrives at ERP for the reconciliation of payments made with PayPal. We checked the PayPal reconciliation data of another store (space23) and the IDs that Shopify sends to the payment provider are of the type:

c12144862658627.2
c12151102701635.1
c12152848711747.1

12514272444483: The green section, apparently is exactly the checkout_id (data easily available from the JSON of the order).

We don't understand the prefix and suffix.
The "C" probably means Checkout, but we must be sure of this and that it is not a variable data.

The suffix instead seems to be variable and it is not possible to understand how it is added and at what point of the flow between Shopify and the PayPal provider.

We need to understand where that value comes from. Or at least make sure that the suffix has ​​always ".N" format, to be able to exclude that in the reconciliation and resolve it only on the basis of the checkout_id.

 

Can you help us, please? It is very important for us.

 

Thanks a lot.

0 Likes
Highlighted
Shopify Partner
9 0 0

No reply?

0 Likes
Highlighted
Shopify Staff
Shopify Staff
592 72 131

Hey @ThinkingAbout_s,

 

You are correct that the c stands for checkout, this will always be the prefix used when sending the checkout_id to PayPal.

 

The suffix corresponds to the index of transactions on an order. The first transaction (successful or not) will be suffixed with 1, the next will be 2, etc. Note that failed credit card payments are still recorded on an order as a transaction attempt. So if a customer tries to pay with credit card and it's declined, the failed payment will be attached to the order as the first transaction. If that customer then successfully completes the payment with PayPal, the PayPal payment will become the 2nd transaction.

JB | Developer Support @ Shopify
 - Was my reply helpful? Click Like to let me know! 
 - Was your question answered? Click Accept as Solution 

1 Like