Shopify Order Reconciliation

This page consists of six sections:

• Search for a specific Order in Shopify
• Reconcile Orders from Shopify Orders export
• Search for all Orders by payment method in Shopify
• Export all Orders by payment method in Shopify
• Search for country-specific Orders in Shopify
• Create Custom Report by Payment Method

Search for a specific order in Shopify

To find a specific order, do the following:

1. Go to Shopify Admin > Orders.

2. Enter the following in the Orders search bar, that is the search bar called Filter Orders: receipt.payment_id:

3. Copy the Merchant Order No. from the UK Business Hub and paste it in search bar after receipt.payment_id:

Here is an example in the Shopify Orders tab:

To access the Shopify Admin, use this URL.

Reconcile Orders from Shopify Orders export

To reconcile orders from the export, do the following:

1. Go to Shopify Admin > Orders

2. Enter clearpay in the Orders search bar:

3. Click Export.

4. Towards the right side of the exported table, a Payment ID column is now available. For Clearpay orders, this column is populated with the Merchant Reference No. from the UK Business Hub.

Search for all Orders by payment method in Shopify

To search for all orders by payment method, do the following:

1. Go to Shopify Admin > Orders.

2. Enter “clearpay” (include the quotation marks for an exact match) in the Orders search bar.

3. Click Save as to save this order filter.

Export all Orders by payment method in Shopify

To export all your orders by payment method in Shopify, do the following:

1. Go to Shopify Admin > Orders.

2. Enter “clearpay” (include the quotation marks for an exact match) in the Orders search bar.

3. Click the checkbox at the top of the column on the extreme left to select all the orders (see picture below) and click Export at the top right of the window.

4. The Export orders popup appears. Click the Selected [n] orders radio button, and select what type of file you want for the exported data.

5. Click Export orders.

Search for country-specific Orders in Shopify

This is a useful way to identify cross-border trade (CBT) orders. Do the following:

1. Go to Shopify Admin > Orders.

2. Enter “clearpay” (include the quotation marks for an exact match) in the Orders search bar.

3. Enter a search term in the search bar.

Create Custom Report by Payment Method

If you use Advanced Shopify or Shopify Plus to host your store, you can use the Custom Report feature to find Clearpay and Cash App Pay orders.

To do this, you create and run a custom report for Orders by Payment Type. Start by going to your store’s Shopify Admin page. Then go to Analytics > Reports > Create custom report.

For more information about how to run reports, see this information from Shopify, along with this information on custom reports.