How can I reconcile orders in Shopify with payment sessions in Airwallex?

Shopify does not transmit order ID information to any third-party payment providers. Therefore, this guide will instruct you on how to download the CSV files from Shopify and Airwallex and combine them in Google Sheets or Excel using the shared identifier 'Payment Reference' in the Shopify report and 'Order ID' in the Airwallex report.

  1. Download the desired orders from Shopify, filtering for the desired date range. Follow the step by step guide here.
  2. Download the corresponding transactions from Airwallex, filtering for the same date range. Follow the step by step guide here.
  3. Join the two tables using the column “Payment Reference” in Shopify and “Order ID” in the Airwallex report. A sample sheet is provided here.
  4. You can also perform the join using excel or your own software with the CSV files. The matching columns are 'Payment Reference' in the Shopify report and 'Order ID' in the Airwallex report.
Share this article

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request