Possible to query for the payout date shown in the history log of an order?

Products and Orders APIs
1

Hello,
If we know the order number, is it possible to query the Shopify Admin API for this payout date highlighted below that appears in the order history? Our ERP will only be receiving the order number, not any other IDs, so we’d have to start querying based on the order number if possible and work our way to the payout date for that order.

image
image650×214 6.81 KB

Thank you

2

Hi Raphael,

Shopify Payments payouts are not directly linked to orders, but each payout is made up of balance transactions, and each balance transaction can be associated with an order. You need to search for balance transactions associated with the order, using the shopifyPaymentsAccount query which could look something like this:

query GetOrderBalanceTransactions {
  shopifyPaymentsAccount {
    balanceTransactions(first: 10, query: "order_name:#1001") {
      edges {
        node {
          id
          transactionDate
          associatedOrder {
            id
            name
          }
          associatedPayout {
            id
            issuedAt
          }
        }
      }
    }
  }
}
3

Hey @Liam-Shopify. Thank you for the response of @Raphael_Reyes.
I tried your GraphQL query for https://{my-store-name}.myshopify.com/admin/api/2025-04/graphql.json, but I got the error at the bottom of this message.

I also want to be able to fetch ANY FUTURE payout dates for single transactions (see image below).

image
image1184×489 41.4 KB

    "errors": [
        {
            "message": "Field 'issuedAt' doesn't exist on type 'ShopifyPaymentsBalanceTransactionAssociatedPayout'",
            "locations": [
                {
                    "line": 14,
                    "column": 13
                }
            ],
            "path": [
                "query GetOrderBalanceTransactions",
                "shopifyPaymentsAccount",
                "balanceTransactions",
                "edges",
                "node",
                "associatedPayout",
                "issuedAt"
            ],
            "extensions": {
                "code": "undefinedField",
                "typeName": "ShopifyPaymentsBalanceTransactionAssociatedPayout",
                "fieldName": "issuedAt"
            }
        }
    ]
}
4

Hi Liam, thank you for your suggestion.

We’re going to try a solution that we’ve come up with below which sounds similar.

  1. Get the order ID based on the store order number:
    GET https://.myshopify.com/admin/api/2025-04/orders.json?name=SHP11007

from the response there we will get an id such as 6148800905397.
“orders”: [
{
“id”: 6148800905397,
“admin_graphql_api_id”: “gid://shopify/Order/6148800905397”, …

  1. Next, we’ll fetch a list of payouts using:
    https://.myshopify.com/admin/api/2025-04/shopify_payments/payouts.json

This will return a number of payout IDs such as 114452234421
{
“payouts”: [
{
“id”: 114452234421,
“status”: “scheduled”,
“date”: “2025-06-14”,
“currency”: “USD”, …

  1. We’ll need to check all the payouts returned from step 2 and see if the order ID from the first query is included in any payout batch using the below (note id from #2 in the endpoint):
    https://.myshopify.com/admin/api/2025-04/shopify_payments/payouts/114452234421/transactions.json

This will give all the orders that were part of payout ID 114452234421, and we can check if the payout has the “source_order_id”: (order ID from step 1.). If it doesn’t we check the next payout ID in the payout list from step 2 until we find the payout ID that contains the order ID from step 1. We can get the date using “processed_at”.
{
“transactions”: [
{
“id”: 2712425201845,
“type”: “charge”,
“test”: false,
“payout_id”: 114452234421,
“payout_status”: “scheduled”,
“currency”: “USD”,
“amount”: “264.00”,
“fee”: “8.48”,
“net”: “255.52”,
“source_id”: 3063414653109,
“source_type”: “charge”,
“source_order_id”: 6148800905397,
“source_order_transaction_id”: 7712442941621,
“processed_at”: “2025-06-12T10:38:44-07:00”,
“adjustment_order_transactions”: null,
“adjustment_reason”: null
}, …

5

@juantheman I also got the same “issuedAt” error when I tried the query. We’ve looked and it seems it will require to search all the payouts for any specific orders to find out under which payout the order will be assigned. From there a date can be determined when it’s discovered which payout is associated with the order.