Accepting credit cards, warehouses, and shipping and fulfilling orders
Hi.
I have a Shopify Plus account with several stores. I need to make a report on payouts, in terms of stores and bank accounts to which payout were made.
I am using Admin GraphQL version 2025-4. To get a list of bank accounts and payouts for them, I make the following request:
query Payouts( $first: Int = 1, $after: String, $reverse: Boolean, $sortKey: PayoutSortKeys, $query:String ) { shopifyPaymentsAccount { id bankAccounts(first: 10) { nodes { id bankName accountNumberLastDigits } } payouts( first: $first, after: $after, reverse: $reverse, sortKey: $sortKey, query: $query ) { edges { cursor node { id bankAccount { id bankName accountNumberLastDigits } legacyResourceId, issuedAt net { amount currencyCode } status transactionType } } pageInfo { endCursor hasNextPage } } } }
This query is behaving extremely strangely 😞
The BankAccount property of the payouts object is almost always null, except when we do not pass the query parameter to the request.
For most stores, the query returns the correct array of bank accounts in the BankAccounts property of the shopifyPaymentsAccount object. However, for one of the my stores, this object returns an empty array, nevertheless the fact that the billing account is configured correctly and there are payments to the bank account in the admin interface.
The application on whose behalf I am making the request has all the necessary rights, including read_shopify_payments_accounts and read_shopify_payments_bank_accounts.
Here is an example of a strange response to such a request:
{ "data": { "shopifyPaymentsAccount": { "id": "gid://shopify/ShopifyPaymentsAccount/999005909****", "bankAccounts": { "nodes": [] }, "payouts": { "edges": [ { "cursor": "eyJsYXN0X2lkIjoxMzk0OTUwODAzMTksImxhc3RfdmFsdWUiOjE3NDk1OTI3OTkwMDB9", "node": { "id": "gid://shopify/ShopifyPaymentsPayout/1394950****", "bankAccount": null, "legacyResourceId": "139495***", "issuedAt": "2025-06-10T21:59:59Z", "net": { "amount": "щ.6", "currencyCode": "EUR" }, "status": "SCHEDULED", "transactionType": "DEPOSIT" } } ], "pageInfo": { "endCursor": "eyJsYXN0X2lkIjoxMzk0OTUwODAzMTksImxhc3RfdmFsdWUiOjE3NDk1OTI3OTkwMDB9", "hasNextPage": true } } } } }
I would be grateful for any ideas: why is there no data in the paymenAccounts array?
June brought summer energy to our community. Members jumped in with solutions, clicked ...
By JasonH Jun 5, 2025Learn how to build powerful custom workflows in Shopify Flow with expert guidance from ...
By Jacqui May 7, 2025Did You Know? May is named after Maia, the Roman goddess of growth and flourishing! ...
By JasonH May 2, 2025