Payments

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

17 fields — 12 dimensions, 5 metrics. Date clauses (SINCE, UNTIL, DURING) use createdAt.

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.
gateway_handle	string	dimension	Raw gateway identifier (shopify_payments, gift_card, manual) — the machine name behind Payment gateway.
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.
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.