Skip to main content
Skip table of contents

How to reconcile between Shopify, XPay and gateway transactions ?

Since XPay onsite app is a registered app and Shopify does not allow the registered apps to show Order ID on Payment gateways. However I am sharing few steps below on how to reconcile between Shopify , XPay and the payment gateway.

Payment ID/transaction ID is a uniform identifier available across all platforms (Shopify, XPay and BAFL). Use it to get Shopify order number on XPay/BAFL export

image-20241220-090536.png

How to use Payment/Transaction ID to get order ID through Vlookup:

  • Before applying VLOOKUP, you need to fetch Shopify export and XPay or BAFL export

  • Payment ID/transaction ID is a uniform identifier available across all platforms (Shopify, XPay and BAFL)

  • In Shopify export you should remove all extra columns and only keep two columns i.e. Payment ID and Order ID

image-20241220-090815.png

  • Similarly, in XPay export you should remove rest of columns and only keep Order ID and Status column, as below :

image-20241220-090928.png

  • Now we have to apply VLOOKUP. So our aim is to get Shopify Order ID in front of Payment ID on XPay export. In video below you can find instructions how to apply VLOOKUP and fetch required order ID:

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close