Returns

Return requests (RMAs) — returned items with reasons, statuses and the product identity at time of sale, one row per return line item. Requires the read_returns scope; empty on stores that have not granted it.

20 fields — 19 dimensions, 1 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 returns
  SHOW returned_quantity
  GROUP BY return_id
  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
`return_id`	string	dimension	Shopify identifier for the return.
`return_name`	string	dimension	Display name of the return, e.g. #1001-R1.
`return_status`	string	dimension	Status of the return.
`return_line_item_id`	string	dimension	Shopify identifier for the return line item.
`return_line_item_reason`	string	dimension	Reason the item was returned. Requires the read_returns scope; blank on stores that have not granted it.
`return_customer_note`	string	dimension	Note provided by the customer when requesting the return.
`is_unverified_return_line_item`	boolean	dimension	Whether the return line item has not yet been verified.
`product_title_at_time_of_sale`	string	dimension	Title of the product as it was on the order the item came from.
`product_variant_title_at_time_of_sale`	string	dimension	Variant title as it was on the order the item came from.
`product_variant_sku_at_time_of_sale`	string	dimension	SKU as it was on the order the item came from.
`product_vendor_at_time_of_sale`	string	dimension	Vendor of the product as it was on the order the item came from.
`product_id`	string	dimension	Shopify identifier for the product.
`product_variant_id`	string	dimension	Shopify identifier for the product variant.
`order_id`	string	dimension	Shopify identifier for the order the return belongs to.
`order_name`	string	dimension	Name of the order the return belongs to, e.g. #1001.
`created_at`	date	dimension	When the return was created — the moment the customer requested it. The dataset's default date field, so SINCE/UNTIL window on this.
`request_approved_at`	date	dimension	When the return request was approved, for returns that were.
`closed_at`	date	dimension	When the return was closed, for returns that have been.
`returned_quantity`	number	metric	Number of items returned.
`store`	string	dimension	The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.