Sales

Line-item sales — gross/net/total sales, discounts, returns, taxes and quantities by product, channel and customer.

152 fields — 126 dimensions, 26 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 sales
  SHOW orders
  GROUP BY product_title
  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
`product_title`	string	dimension	Display name of the product that your customers see.
`variant_title`	string	dimension	Display name of the product variant.
`sku`	string	dimension	SKU of the product variant.
`vendor`	string	dimension	Vendor of the product.
`product_type`	string	dimension	Type (category) that you've assigned to the product.
`product_title_at_time_of_sale`	string	dimension	Display name of the product at the time of its sale.
`product_variant_title_at_time_of_sale`	string	dimension	Display name of the product variant at the time of its sale.
`product_variant_sku_at_time_of_sale`	string	dimension	SKU of the product variant at the time of its sale.
`product_vendor_at_time_of_sale`	string	dimension	Vendor of the product at the time of its sale.
`product_type_at_time_of_sale`	string	dimension	Type (category) assigned to the product at the time of its sale.
`sales_channel`	string	dimension	Channel the sale was made on.
`order_name`	string	dimension	Name of the order the sale belongs to, e.g. #1001.
`financial_status`	string	dimension	Payment status of the order (paid, pending, refunded, etc.).
`customer_name`	string	dimension	Name of the customer.
`new_or_returning_customer`	string	dimension	Label specifying whether an order is from a new or returning customer.
`billing_country`	string	dimension	Billing country of the order.
`shipping_country`	string	dimension	Shipping country of the order.
`currency`	string	dimension	Order currency code.
`reason`	string	dimension	Why the sale line exists — ORDER for the original sale, ORDER_EDIT for order-edit additions, RETURN or REFUND for reversals.
`order_or_sales_reversal`	string	dimension	Whether the row is an order or a sales reversal — a return, cancellation or order edit.
`line_type`	string	dimension	Line type, e.g. Product, Shipping, Sale adjustment, Gift card.
`created_at`	date	dimension	When the sale occurred.
`orders`	number	metric	Distinct orders in the group — order/product line items only, matching the classic reports. Sums across stores.
`customers`	number	metric	Distinct customers in the group — order/product line items only, matching the classic reports. Sums across stores.
`sales_count`	number	metric	Number of sale line items in the group (document count — value_count on createdAt). Sums across stores.
`gross_sales`	money	metric	Line item price times quantity, before discounts, returns and taxes.
`net_sales`	money	metric	Gross sales minus discounts and returns.
`total_sales`	money	metric	Net sales plus taxes and shipping.
`average_order_value`	money	metric	Average value of orders placed, excluding any post-order adjustments.
`discounts`	money	metric	Total discounts applied to the line item.
`sales_reversals`	money	metric	Value of items removed from orders — returns, cancellations and order edits — before discounts and taxes.
`taxes`	money	metric	Total tax on the line item.
`shipping_charges`	money	metric	Amount customers spent on shipping.
`duties`	money	metric	Duties and import taxes charged on the line item.
`additional_fees`	money	metric	Additional fees charged on the line item.
`ordered_quantity`	number	metric	Units ordered.
`returned_quantity`	number	metric	Units returned.
`net_quantity`	number	metric	Ordered units minus returned units.
`billing_address_id`	string	dimension	Shopify identifier for the billing address.
`billing_address_1`	string	dimension	First line of the billing address.
`billing_address_2`	string	dimension	Second line of the billing address.
`billing_city`	string	dimension	City of the billing address.
`billing_company`	string	dimension	Company of the billing address.
`billing_first_name`	string	dimension	First name on the billing address.
`billing_last_name`	string	dimension	Last name on the billing address.
`billing_name`	string	dimension	Full name on the billing address.
`billing_phone`	string	dimension	Phone number on the billing address.
`billing_region`	string	dimension	State or province of the billing address (e.g., California, Ontario).
`billing_region_code`	string	dimension	State or province code of the billing address.
`billing_postal_code`	string	dimension	Postal code of the billing address.
`billing_country_code`	string	dimension	Country code of the billing address.
`shipping_address_id`	string	dimension	Shopify identifier for the shipping address.
`shipping_address_1`	string	dimension	First line of the shipping address.
`shipping_address_2`	string	dimension	Second line of the shipping address.
`shipping_city`	string	dimension	City of the shipping address.
`shipping_company`	string	dimension	Company of the shipping address.
`shipping_first_name`	string	dimension	First name on the shipping address.
`shipping_last_name`	string	dimension	Last name on the shipping address.
`shipping_name`	string	dimension	Full name on the shipping address.
`shipping_phone`	string	dimension	Phone number on the shipping address.
`shipping_region`	string	dimension	State or province of the shipping address (e.g., California, Ontario).
`shipping_region_code`	string	dimension	State or province code of the shipping address.
`shipping_postal_code`	string	dimension	Postal code of the shipping address.
`shipping_country_code`	string	dimension	Country code of the shipping address.
`pos_location_id`	string	dimension	Shopify identifier for your physical retail location.
`pos_location_name`	string	dimension	Name of your physical retail location.
`customer_email`	string	dimension	Email address of the customer.
`customer_first_name`	string	dimension	First name of the customer.
`customer_last_name`	string	dimension	Last name of the customer.
`customer_phone`	string	dimension	Phone number of the customer.
`customer_note`	string	dimension	Note on the customer.
`customer_tags`	string	dimension	Set of tags associated with the customer.
`customer_state`	string	dimension	Status of the customer's account.
`customer_currency`	string	dimension	Currency associated with the customer.
`customer_accepts_marketing`	boolean	dimension	Whether the customer accepts marketing.
`tax_exempt`	boolean	dimension	Whether the customer is tax exempt.
`verified_email`	boolean	dimension	Whether the customer's email is verified.
`customer_email_subscription_status`	string	dimension	Email marketing subscription status of the customer.
`email_opt_in_level`	string	dimension	Email marketing opt-in level of the customer.
`email_consent_updated_at`	date	dimension	When the customer's email marketing consent last changed.
`customer_sms_subscription_status`	string	dimension	The customer's SMS marketing subscription status.
`sms_opt_in_level`	string	dimension	SMS marketing opt-in level of the customer.
`sms_consent_updated_at`	date	dimension	When the customer's SMS marketing consent last changed.
`sms_consent_collected_from`	string	dimension	Where the customer's SMS marketing consent was collected.
`customer_first_order_date`	date	dimension	Date of the customer's first order.
`customer_first_order_id`	string	dimension	Shopify identifier for the customer's first order.
`customer_first_order_name`	string	dimension	Name of the customer's first order.
`customer_last_order_date`	date	dimension	Date of the customer's last order.
`customer_last_order_id`	string	dimension	Shopify identifier for the customer's last order.
`customer_last_order_name`	string	dimension	Name of the customer's last order.
`customer_number_of_orders`	number	dimension	Number of orders the customer has placed across all time.
`customer_amount_spent`	money	dimension	Amount the customer has spent across all time.
`order_utm_source`	string	dimension	UTM source of the campaign associated with the order.
`order_utm_medium`	string	dimension	UTM medium of the campaign associated with the order.
`order_utm_campaign`	string	dimension	UTM name of the campaign associated with the order.
`order_utm_content`	string	dimension	UTM content of the campaign associated with the order.
`order_utm_term`	string	dimension	UTM term of the campaign associated with the order.
`marketing_channel`	string	dimension	Marketing channel or platform that drove the order.
`order_marketing_event_type`	string	dimension	Type of marketing activity that led to the order.
`order_referrer_domain`	string	dimension	Domain of the site that led to the order.
`order_referrer_name`	string	dimension	Name of the site that led to the order.
`order_referrer_path`	string	dimension	Path of the site that led to the order.
`order_referrer_source`	string	dimension	Referrer type that led to the order (organic, email, etc.).
`order_referrer_url`	string	dimension	External page that referred a customer and led to the order.
`first_visit_landing_page`	string	dimension	Landing page of the customer's first visit before the order.
`last_visit_landing_page`	string	dimension	Landing page of the visit that resulted in the order.
`user_agent`	string	dimension	Browser user agent of the converting session.
`days_to_conversion`	number	dimension	Days from the customer's first visit to the order.
`total_sessions`	number	dimension	Number of sessions before the order was placed.
`is_b2b_order`	boolean	dimension	Label for whether the order is a B2B order.
`company_id`	string	dimension	Shopify identifier for the company.
`company_name`	string	dimension	Name of the company that placed the order.
`company_location_id`	string	dimension	Shopify identifier for the company location.
`company_location_name`	string	dimension	The company location or branch that placed the order.
`order_id`	string	dimension	Shopify identifier for the order.
`is_canceled_order`	boolean	dimension	Label indicating whether the order is canceled.
`cancelled_at`	date	dimension	When the order was cancelled.
`order_cancellation_reason`	string	dimension	Reason why the order was cancelled.
`delivery_method`	string	dimension	Delivery method of the order.
`order_email`	string	dimension	Email address on the order.
`order_fulfillment_status`	string	dimension	Order's fulfillment status, such as Fulfilled.
`order_number`	string	dimension	Number of the order.
`number_of_items`	number	dimension	Number of items on the order.
`order_status`	string	dimension	Status of the order (open, closed, cancelled).
`gateway`	string	dimension	Payment gateway of the order.
`order_note`	string	dimension	Note on the order.
`order_tag`	string	dimension	Tag associated with the order.
`tracking_number`	string	dimension	Shipment tracking number on the order.
`sale_item_type`	string	dimension	Whether the sale line is a product or a gift card.
`sale_id`	string	dimension	Shopify identifier for the sale line.
`line_item_id`	string	dimension	Shopify identifier for the line item.
`publication_id`	string	dimension	Shopify identifier for the sales channel publication.
`publication_name`	string	dimension	Name of the sales channel publication.
`barcode`	string	dimension	Barcode of the variant sold.
`product_tag`	string	dimension	Tag associated with the product.
`product_id`	string	dimension	Shopify identifier for the product, which may have multiple variants.
`product_variant_id`	string	dimension	Shopify identifier for the product variant.
`product_variant_price`	money	dimension	Price of the product variant.
`line_item_price`	money	metric	Sum of line item unit prices.
`line_item_discounts`	money	metric	Amount deducted from specific line items in the sale.
`line_item_discount_price`	money	metric	Line item price after discounts.
`line_item_tax`	money	metric	Tax on the line item.
`line_item_tax_rate`	percent	dimension	Tax rate applied to the line item.
`line_item_refunds`	money	metric	Refunded amount on the line item.
`gift_card_gross_sales`	money	metric	Gift card sales revenue, before discounts and sales reversals are factored in.
`gift_card_net_sales`	money	metric	Gift card sales revenue, discounts and sales reversals factored in.
`gift_card_discounts`	money	metric	Value of discounts on gift card sales.
`gift_card_outstanding_sales`	money	metric	Outstanding (unredeemed) gift card sales value.
`is_sale_adjustment`	boolean	dimension	Label specifying whether the sale was an adjustment.
`line_item_unit_grams`	number	dimension	Weight in grams of one unit of the line item.
`line_item_total_grams`	number	metric	Total weight in grams of the line item.
`store`	string	dimension	The shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.