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.
- Download the desired orders from Shopify, filtering for the desired date range. Follow the step by step guide here.
- Download the corresponding transactions from Airwallex, filtering for the same date range. Follow the step by step guide here.
- Join the two tables using the column “Payment Reference” in Shopify and “Order ID” in the Airwallex report. A sample sheet is provided here.
- 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.