Orders

Orders with financial, fulfillment and line-item data.

34 fields — 22 dimensions, 12 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 orders
  SHOW order_count
  GROUP BY order_name
  SINCE -30d

See Querying with SoloQL for the language.

Fetch records

curl -H "Authorization: Bearer esk_live_..." \
  "https://api.ecomsolo.com/v1/orders?page_size=50&fields=order_name,order_number,email"

Any field marked ✅ below can be returned, requested via fields=, and used as an equality filter (?field=value). Fields marked aggregate only exist for COUNT-style questions and have no value on a single record — ask SoloQL for those. See Fetching records.

Fields

Field	Type	Role	Records	Description
`order_name`	string	dimension	✅	Order name, e.g. #1001.
`order_number`	number	dimension	✅	Sequential order number.
`email`	string	dimension	✅	Customer email on the order.
`customer_name`	string	dimension	✅	Customer display name.
`financial_status`	string	dimension	✅	Payment status (paid, pending, refunded, etc.).
`fulfillment_status`	string	dimension	✅	Fulfillment status (fulfilled, partial, unfulfilled, etc.).
`order_status`	string	dimension	✅	Open, archived or cancelled.
`currency`	string	dimension	✅	Order currency code.
`sales_channel`	string	dimension	✅	Channel the order was placed on.
`source_name`	string	dimension	✅	Order source (web, pos, draft_order, etc.).
`gateway`	string	dimension	✅	Payment gateway.
`location_name`	string	dimension	✅	Location attributed to the order.
`tags`	string	dimension	✅	Comma-separated order tags.
`is_test`	boolean	dimension	✅	Whether this is a test order.
`created_at`	date	dimension	✅	When the order was created.
`processed_at`	date	dimension	✅	When the order was processed.
`cancelled_at`	date	dimension	✅	When the order was cancelled.
`order_count`	number	metric	aggregate only	Number of orders in the group (document count — value_count on createdAt). Sums across stores.
`total_price`	money	metric	✅	Total order price including taxes, shipping and discounts.
`subtotal_price`	money	metric	✅	Line items price after discounts, before shipping and taxes.
`total_tax`	money	metric	✅	Total tax charged.
`total_discounts`	money	metric	✅	Total discount amount applied.
`total_tip`	money	metric	✅	Total tips received.
`net_payment`	money	metric	✅	Payments received minus refunds.
`total_outstanding`	money	metric	✅	Amount still owed on the order.
`items_count`	number	metric	✅	Number of items in the order.
`total_weight`	number	metric	✅	Total order weight in grams.
`line_item_sku`	string	dimension	✅	SKU of an ordered line item.
`line_item_title`	string	dimension	✅	Title of an ordered line item.
`line_item_quantity`	number	metric	✅	Units ordered of a line item.
`line_item_price`	money	metric	✅	Unit price of a line item.
`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'.