> This page is for Afterpay.

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

# Shopify Order Reconciliation

Reconcile Afterpay US (New) or Cash App Pay orders on Shopify and ensure all transactions are accounted for.

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 Shopify guide along with the information on this page.

## 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 [Business Hub](https://hub.us.afterpay.com/us) 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. Optional: Enter **afterpay** in the Orders search bar.

3. Optional: Enter **"cash app pay"** in the Orders search bar. Notice the quotes for an exact match.

   ![cash-app-pay.png](/_fern-img/6c1dcdf66877b3382f413bf38cf6130bac7e14857f71f568ed09802d3eb77347.webp)

4. Click **Export**.

5. Towards the right side of the exported table, a *Payment ID* column is now available. For both Afterpay US (New) and Cash App Pay orders, this column is populated with the Merchant Reference No. from the [Business Hub](https://hub.us.afterpay.com/us).

For example, here is a Shopify export file:

For example, within the Business Hub the information appears like this:

![Shopify business hub](</_fern-img/3c002ab57139fb836eac93764b1dd98b3a8e3f2d9b85ca4b81a6f519a548ed3d.webp>)

## 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 **"Afterpay US (New)"** or **"Cash App Pay"** (include the quotation marks for an exact match) in the *Orders* search bar.

   ![search-for-all-orders.png](/_fern-img/bcdb910d4afeec3950621a42cb5a58822eef02c7c6b45637ef910673187229f3.webp)

3. Click **Save as** to save this order filter.

> **Info**
>
> If you use both the **Afterpay US (New)** payment app and the **Afterpay (New)** payment app, you can search for them separately.

## 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 **"Afterpay US (New)"** or **"Cash App Pay"** (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.

   ![export.png](/_fern-img/3f0188380873dfe7ef624e7f78d280c7e6f0706d2773abc806ab4ef5cd1f458b.webp)

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.

   ![export-orders.png](/_fern-img/48ffc817c3f1f79046854a489dd2f707f1a4cd4a52325a38dc17c75b168a2d8a.webp)

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 a search term in the search bar. For example, in the picture below, the search term is **canada afterpay**. This search shows all the Canadian Afterpay orders with their status and other information.

   ![country-specific.png](/_fern-img/1be51d37b9970e03e448691938bcf9161fbd10293f7abc7b46107387cab3b834.webp)

## 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 Afterpay US (New) 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.