Payments

Order payment transactions — gross, refunded and net payments by gateway, kind and status.

24 fields — 18 dimensions, 6 metrics. Date clauses (SINCE, UNTIL, DURING) use processedAt.

The live, authoritative list is always GET /v1/datasets — this page is regenerated from the same catalog, but the endpoint reflects exactly what is deployed.

Query it

FROM payments
  SHOW transactions
  GROUP BY payment_gateway
  SINCE -30d

See Querying with SoloQL for the language.

This dataset is queryable through SoloQL; it has no record-retrieval endpoint.

Fields

Field	Type	Role	Description
payment_gateway	string	dimension	Payment gateway used for the transaction.
is_shop_pay_transaction	boolean	dimension	Whether the payment came through Shop Pay. Blank on transactions with no digital wallet.
is_shop_channel_transaction	boolean	dimension	Whether Shopify counts the transaction as a Shop-channel sale. Blank means we could not ask the store, which is not the same as no.
transaction_sale_type	string	dimension	How the sale reached Shopify's Shop channel, such as Shop App. Blank means we could not ask the store, which is not the same as none.
gateway_handle	string	dimension	Raw gateway identifier (shopify_payments, gift_card, manual) — the machine name behind Payment gateway.
payment_method	string	dimension	Payment method behind the gateway — card brand, local method, or Shop Pay Installments.
transaction_kind	string	dimension	Transaction kinds include sale, authorization, capture, refund, etc.
transaction_status	string	dimension	Status of the transaction, such as success, pending, or failure.
transaction_id	id	dimension	Shopify identifier for the transaction.
order_id	id	dimension	Shopify identifier for the order.
order_name	string	dimension	Name or number of an order (customer-facing).
transaction_currency	string	dimension	Settlement currency of the transaction.
is_test	boolean	dimension	Whether the transaction was a test transaction.
processed_at	date	dimension	When the payment was processed.
created_at	date	dimension	When the transaction record was created.
transactions	number	metric	Number of payment transactions (document count).
transaction_amount	money	metric	Amount of all payment transactions.
gross_payments	money	metric	Amount of payments before any refunds.
refunded_payments	money	metric	Amount of refunded payments, as a negative amount.
orders_with_transactions	number	metric	Distinct orders that have at least one transaction in the group.
net_payments	money	metric	Amount of payments after any refunds.
store	string	dimension	The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.
store_id	string	dimension	The shop's raw identifier — what an export or the API reports. Same shops as Store, shown as ids.
store_domain	string	dimension	The shop's myshopify.com domain. Filter with WHERE store_domain = 'shop.myshopify.com'.