Sales taxes

Sales tax collected per tax line by jurisdiction, tax name, rate and channel.

98 fields — 95 dimensions, 3 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_taxes
  SHOW tax_line_count
  GROUP BY tax_country
  SINCE -30d

See Querying with SoloQL for the language.

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

Fields

FieldTypeRoleDescription
tax_countrystringdimensionCountry the tax was collected in.
tax_regionstringdimensionRegion/province the tax was collected in.
tax_citystringdimensionCity the tax was collected in.
tax_namestringdimensionName of the tax (e.g. VAT, State Tax).
tax_ratepercentdimensionTax rate as a fraction (0.05 = 5%).
filed_by_channelstringdimensionWhether the sales channel / marketplace facilitator remits the tax ("Filed by channel") rather than the merchant ("Not filed"). One of Shopify's default taxes group-by columns.
sales_channelstringdimensionChannel the sale was made on.
order_namestringdimensionName of the order, e.g. #1001.
payment_statusstringdimensionPayment status of the order.
customer_namestringdimensionName of the customer.
line_typestringdimensionLine type, e.g. Product, Shipping, Sale adjustment, Gift card.
order_or_sales_reversalstringdimensionWhether the tax line is on an order or a sales reversal — a return, cancellation or order edit.
currencystringdimensionCheckout currency code.
created_atdatedimensionWhen the tax line was recorded.
merchant_of_record_countrystringdimensionCountry of the merchant of record for the sale.
merchant_of_record_regionstringdimensionRegion of the merchant of record for the sale.
order_idstringdimensionUnique identifier of the order.
line_item_idstringdimensionUnique identifier of the order line item.
order_fulfillment_statusstringdimensionFulfillment status of the order.
order_includes_dutiesbooleandimensionWhether the order includes duties.
is_canceled_orderbooleandimensionWhether the order was canceled.
order_cancellation_reasonstringdimensionThe reason the order was canceled.
order_tagstringdimensionTag applied to the order.
order_sales_channelstringdimensionChannel the order was placed on.
sale_sales_channel_idstringdimensionIdentifier of the channel the sale was made on.
order_sales_channel_idstringdimensionIdentifier of the channel the order was placed on.
is_b2b_orderbooleandimensionWhether the order was placed by a B2B company.
company_idstringdimensionIdentifier of the B2B company on the order.
company_namestringdimensionName of the B2B company on the order.
company_location_idstringdimensionIdentifier of the B2B company location on the order.
company_location_namestringdimensionName of the B2B company location on the order.
billing_address_idstringdimensionIdentifier of the billing address.
billing_citystringdimensionCity of the billing address.
billing_companystringdimensionCompany on the billing address.
billing_countrystringdimensionCountry of the billing address.
billing_postal_codestringdimensionPostal or ZIP code of the billing address.
billing_regionstringdimensionRegion/province of the billing address.
shipping_address_idstringdimensionIdentifier of the shipping address.
shipping_citystringdimensionCity of the shipping address.
shipping_companystringdimensionCompany on the shipping address.
shipping_countrystringdimensionCountry of the shipping address.
shipping_postal_codestringdimensionPostal or ZIP code of the shipping address.
shipping_regionstringdimensionRegion/province of the shipping address.
pos_location_idstringdimensionIdentifier of the POS location the sale was made at.
pos_location_namestringdimensionName of the POS location the sale was made at.
utm_sourcestringdimensionUTM source parameter that referred the order.
utm_mediumstringdimensionUTM medium parameter that referred the order.
utm_campaignstringdimensionUTM campaign parameter that referred the order.
utm_contentstringdimensionUTM content parameter that referred the order.
utm_termstringdimensionUTM term parameter that referred the order.
traffic_typestringdimensionType of traffic that led to the order.
referring_mediumstringdimensionMedium that referred the visitor to the store.
referring_platformstringdimensionPlatform that referred the visitor to the store.
order_referrer_sourcestringdimensionSource that referred the order.
order_referrer_namestringdimensionName of the referrer that led to the order.
order_referrer_domainstringdimensionDomain of the referrer that led to the order.
order_referrer_sitestringdimensionSite of the referrer that led to the order.
order_referrer_urlstringdimensionFull referrer URL that led to the order.
order_referrer_pathstringdimensionPath of the referrer that led to the order.
referring_channelstringdimensionChannel that referred the visitor to the store.
order_landing_page_urlstringdimensionFull landing page URL of the order's first session.
order_landing_page_pathstringdimensionLanding page path of the order's first session.
order_marketing_event_idstringdimensionIdentifier of the marketing event attributed to the order.
order_marketing_event_targetstringdimensionTarget of the marketing event attributed to the order.
order_marketing_event_typestringdimensionType of the marketing event attributed to the order.
product_idstringdimensionUnique identifier of the product.
product_titlestringdimensionCurrent title of the product.
product_title_at_time_of_salestringdimensionTitle of the product when the sale was made.
product_typestringdimensionCurrent type of the product.
product_type_at_time_of_salestringdimensionType of the product when the sale was made.
product_collectionstringdimensionCollection the product belongs to.
product_tagstringdimensionTag applied to the product.
product_vendorstringdimensionCurrent vendor of the product.
product_vendor_at_time_of_salestringdimensionVendor of the product when the sale was made.
product_variant_idstringdimensionUnique identifier of the product variant.
product_variant_skustringdimensionCurrent SKU of the product variant.
product_variant_sku_at_time_of_salestringdimensionSKU of the product variant when the sale was made.
product_variant_titlestringdimensionCurrent title of the product variant.
product_variant_title_at_time_of_salestringdimensionTitle of the product variant when the sale was made.
product_variant_pricemoneydimensionPrice of the product variant when the sale was made (Shopify's 'Product variant price').
staff_idstringdimensionIdentifier of the staff member who made the sale.
staff_member_namestringdimensionName of the staff member who made the sale.
marketstringdimensionMarket the order is attributed to.
store_idstringdimensionIdentifier of the store the sale belongs to.
store_namestringdimensionDisplay name of the store the sale belongs to.
order_risk_levelstringdimensionShopify's fraud risk level for the order (none/low/medium/high).
shopify_protect_statusstringdimensionShopify Protect status of the order (active = protected/covered).
shopify_protect_eligibilitystringdimensionWhether the order is eligible for Shopify Protect.
is_physical_storefrontbooleandimensionWhether the sale happened at a physical (POS) storefront.
product_statusstringdimensionCurrent product lifecycle status (active/archived/draft).
product_variant_compare_at_pricemoneydimensionCurrent compare-at price of the product variant.
order_landing_page_hoststringdimensionHost of the order's landing-page URL.
marketing_channel_handlestringdimensionHandle of the marketing channel that drove the order.
marketing_delivery_channelstringdimensionDelivery channel type of the marketing event.
tax_line_countnumbermetricNumber of tax lines in the group (document count — value_count on createdAt). Sums across stores.
sales_taxesmoneymetricTax amount collected (negative for refunds).
sales_revenuemoneymetricNet sales (tax-exclusive) subject to tax, booked once per sale (negative for returns). Matches Shopify's net sales on the Taxes report.
storestringdimensionThe shop the record belongs to. Filter with WHERE store IN ('Shop name') or GROUP BY store.