> This page is for version v2 (default).
> For other versions, use one of these documentation indexes:
> - v2 (default): https://developers.clearpay.co.uk/v-2/llms.txt
> - v1: https://developers.clearpay.co.uk/v-1/llms.txt

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://developers.clearpay.co.uk/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://developers.clearpay.co.uk/_mcp/server.

# Shopify Order Reconciliation

This page consists of six sections:

* [Search for a specific Order in Shopify](#search-for-a-specific-order-in-shopify)
* [Reconcile Orders from Shopify Orders export](#reconcile-orders-from-shopify-orders-export)
* [Search for all Orders by payment method in Shopify](#search-for-all-orders-by-payment-method-in-shopify)
* [Export all Orders by payment method in Shopify](#export-all-orders-by-payment-method-in-shopify)
* [Search for country-specific Orders in Shopify](#search-for-country-specific-orders-in-shopify)
* [Create Custom Report by Payment Method](#create-custom-report-by-payment-method)

> **Note**
>
> Shopify provide a detailed guide to [Searching, viewing, and printing orders](https://help.shopify.com/en/manual/orders/manage-orders/search-view-print-orders). Use this guide in the Shopify help center in conjunction with the information on this page of the Clearpay guide.

## 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](/merchant-portal) and paste it in search bar after `receipt.payment_id:`

Here is an example in the Shopify *Orders* tab:

![search-for-a-specific-order-new.png](/_fern-img/7c10dae889857576e2205f3d736b19b58e2fc705fea6ebcc69a08a2acbe9e76e.webp)

To access the Shopify Admin, use this [URL](http://shopify.com/admin/orders?query=receipt.payment_id%3A).

## 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](/merchant-portal).

## 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](https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types) from Shopify, along with [this information](https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/custom-reports) on custom reports.