Skip to main content

sales_taxes

The sales_taxes schema captures tax amounts applied to sales lines. It's best used when your reporting needs sale, order, product, channel, POS, address, staff, or line-type context.


Counts and calculations that let you track key business indicators. Metrics show up as the columns when queried.

Metrics you can use when querying FROM sales_taxes.

Anchor to managed_markets_taxes
managed_markets_taxes

Sales taxes collected from Global-e when Global-e buys from you and sells to customers, in your store's currency.

Anchor to sales_taxes
sales_taxes

The amount of tax applied to sales, in your store's currency. Use sales_taxes to report tax amounts over time or by location, tax name, or sales channel.


Attributes of your data that let you look more granularly at aspects of the data. Group and filter by dimensions to shape the rows your query returns.

Dimensions you can use when querying FROM sales_taxes.

Anchor to billing_address_id
billing_address_id

The unique Shopify identifier for the billing address. Use billing_address_id with billing_city, billing_region, or billing_country to show readable billing address details.

The day a tax was applied to a sale.

Anchor to day_of_week
day_of_week

The weekday a tax was applied to a sale, with values Monday through Sunday.

Anchor to filed_by_channel
filed_by_channel

Whether the sales channel filed taxes for the transaction, with values Filed, Not filed, and Unspecified.

The hour a tax was applied to a sale.

Anchor to hour_of_day
hour_of_day

The hour of day a tax was applied to a sale, with values 0 through 23.

Anchor to line_item_id
line_item_id

The unique Shopify identifier for the line item that the tax is tied to. Use line_item_id to filter taxes for a specific item on an order.

Anchor to line_type
line_type

The kind of sales charge the tax applies to, such as Product, Shipping, Duty, or Additional fee.

Anchor to merchant_of_record_country
merchant_of_record_country

The country where the merchant of record bought your products before selling them to customers

Anchor to merchant_of_record_region
merchant_of_record_region

The region where the merchant of record bought your products before selling them to customers

Anchor to minute
minute

The minute a tax was applied to a sale.

Anchor to month
month

The month a tax was applied to a sale.

Anchor to month_of_year
month_of_year

The month of year a tax was applied to a sale, with values 1 through 12.

Anchor to order_id
order_id

The unique Shopify identifier for the order that the tax belongs to. Use order_id to filter to a specific order or break tax results down by order.

Anchor to order_or_sales_reversal
order_or_sales_reversal

Label specifying whether the transaction adds or removes value from sales

Anchor to pos_location_id
pos_location_id

The unique Shopify identifier for your physical retail location. Use pos_location_id to filter tax results for a specific POS location.

Anchor to product_id
product_id

The unique Shopify identifier for the product on the taxed line. Use product_id to filter to a specific product or break tax results down by product.

Anchor to product_variant_id
product_variant_id

The unique Shopify identifier for the product variant on the taxed line. Use product_variant_id to filter to a specific variant or break tax results down by variant.

Anchor to quarter
quarter

The quarter a tax was applied to a sale.

Anchor to sale_sales_channel_id
sale_sales_channel_id

The unique Shopify identifier for the sales channel where the sale happened. Use sale_sales_channel_id to filter to a specific sales channel when you know its identifier.

Anchor to sales_channel
sales_channel

Name of the sales channel where the customer made a purchase

Anchor to sales_tax_id
sales_tax_id

The unique Shopify identifier for the sales tax entry. Use sales_tax_id to filter to a specific tax entry.

Anchor to second
second

The second a tax was applied to a sale.

Anchor to shipping_address_id
shipping_address_id

The unique Shopify identifier for the shipping address. Use shipping_address_id with shipping_city, shipping_region, or shipping_country to show readable shipping address details.

Anchor to shop_id
shop_id

The unique Shopify identifier for your store. Use shop_id with shop_name to show readable store labels.

Anchor to staff_id
staff_id

The unique Shopify identifier for the staff member associated with the order. Use staff_id to filter taxes tied to a specific staff member.

Anchor to tax_city
tax_city

The city where the tax was applied. Use tax_city to review sales taxes by tax location.

Anchor to tax_country
tax_country

The country used as the tax location for the sale.

Anchor to tax_name
tax_name

The name of the tax applied to the sale. Use tax_name to review amounts for specific taxes, such as a regional sales tax or value added tax.

Anchor to tax_rate
tax_rate

The rate used for the tax, shown as a percentage. Use tax_rate to group or filter taxes by the rate applied.

Anchor to tax_region
tax_region

The state, province, or region where the tax was applied. Use tax_region to review sales taxes by tax region.

The week a tax was applied to a sale.

Anchor to week_of_year
week_of_year

The week of year a tax was applied to a sale, with values 1 through 53.

The year a tax was applied to a sale.

Anchor to billing_city
billing_city

City of the billing address

Anchor to billing_company
billing_company

B2B customer associated with the billing address

Anchor to billing_country
billing_country

Country of the billing address (e.g., United States, Canada)

Anchor to billing_postal_code
billing_postal_code

Postal code of the billing address

Anchor to billing_region
billing_region

State or province of the billing address (e.g., California, Ontario)

Anchor to shop_name
shop_name

Name of your store

Anchor to product_title_at_time_of_sale
product_title_at_time_of_sale

The product name as it appeared when the item was sold.

Anchor to product_type_at_time_of_sale
product_type_at_time_of_sale

The product type or category assigned when the item was sold.

Anchor to product_variant_compare_at_price
product_variant_compare_at_price

The compare-at price of the product variant when the item was sold, in your store's currency.

Anchor to product_variant_price
product_variant_price

The price of the product variant when the item was sold, in your store's currency.

Anchor to product_variant_sku_at_time_of_sale
product_variant_sku_at_time_of_sale

The SKU of the product variant when the item was sold.

Anchor to product_variant_title_at_time_of_sale
product_variant_title_at_time_of_sale

The variant name as it appeared when the item was sold.

Anchor to product_vendor_at_time_of_sale
product_vendor_at_time_of_sale

The vendor assigned to the product when the item was sold.

Anchor to is_b2b_order
is_b2b_order

Whether the order is a B2B order, with values true and false.

Anchor to is_canceled_order
is_canceled_order

Whether the order is canceled, with values true and false.

Anchor to order_checkout_currency
order_checkout_currency

The currency the buyer saw at checkout when placing the order. Values are currency codes such as USD, CAD, EUR, and GBP.

Anchor to order_fulfillment_status
order_fulfillment_status

The order's fulfillment state, with values Fulfilled, Partial, Restocked, and Unfulfilled.

Anchor to order_includes_duties
order_includes_duties

Whether the order includes duties, with values true and false.

Anchor to order_name
order_name

The name or number of the order as the customer sees it.

Anchor to order_payment_status
order_payment_status

The order's payment state, such as Authorized, Paid, Partially refunded, or Pending.

Anchor to order_sales_channel
order_sales_channel

The sales channel where the order was placed, shown as a channel name such as Online Store or POS.

Anchor to order_sales_channel_id
order_sales_channel_id

The unique Shopify identifier for the order's sales channel. Use order_sales_channel_id with order_sales_channel to show readable channel labels.

Anchor to is_shop_referral_order
is_shop_referral_order

Whether the order was referred from the Shop app or shop.app, with values true and false.

Anchor to order_landing_page_path
order_landing_page_path

Path of the first page of the user session that resulted in the order

Anchor to order_landing_page_url
order_landing_page_url

First page of the user session that resulted in the order

Anchor to order_marketing_event_id
order_marketing_event_id

Shopify identifier for the marketing event associated with the order

Anchor to order_referrer_domain
order_referrer_domain

Domain of the site that led to the order

Anchor to order_referrer_name
order_referrer_name

The readable name of the site that led to the order.

Anchor to order_referrer_path
order_referrer_path

Path of the site that led to the order

Anchor to order_referrer_site
order_referrer_site

Site that led to the order

Anchor to order_referrer_source
order_referrer_source

The referrer type that led to the order, such as organic or email.

Anchor to order_referrer_url
order_referrer_url

External page that referred a customer and led to the order

Anchor to order_utm_campaign
order_utm_campaign

UTM name of the campaign associated with the order

Anchor to order_utm_content
order_utm_content

The UTM content value associated with the order, often used to distinguish ads, links, or content variations.

Anchor to order_utm_medium
order_utm_medium

The UTM medium associated with the order, such as email, social, or paid search.

Anchor to order_utm_source
order_utm_source

The UTM source associated with the order, such as Google, Facebook, or a newsletter.

Anchor to order_utm_term
order_utm_term

The UTM term associated with the order, often used for paid search keywords or other tracked terms.

Anchor to number_of_products_bought_together
number_of_products_bought_together

Total unique products in the same order

Anchor to number_of_variants_bought_together
number_of_variants_bought_together

The number of unique product variants in the same order, with each SKU counted a single time.

Anchor to products_bought_together
products_bought_together
<>

The product names that appear in the same order.

Anchor to products_bought_together_ids
products_bought_together_ids
<>

The Shopify product identifiers for products in the same order.

Anchor to variants_bought_together
variants_bought_together
<>

The product variant labels that appear in the same order, such as size, color, or style combinations.

Anchor to company_id
company_id

The unique Shopify identifier for the company. Use company_id with company_name to show readable company labels.

Anchor to company_name
company_name

Name of the company that placed the order

Anchor to company_location_id
company_location_id

The unique Shopify identifier for the company location. Use company_location_id with company_location_name to show readable company location labels.

Anchor to company_location_name
company_location_name

The company location or branch that placed the order

Anchor to referring_channel
referring_channel

Marketing channel that referred the customer to place the order

Anchor to referring_medium
referring_medium

The marketing medium that referred the customer to place the order, such as email, social, or search.

Anchor to referring_platform
referring_platform

The marketing platform that referred the customer to place the order, such as Google, Facebook, or Instagram.

Anchor to traffic_type
traffic_type

The type of traffic that led to the order, such as organic, paid, or direct.

Anchor to order_marketing_event_target
order_marketing_event_target

The platform or channel where the marketing activity was deployed, such as Email, Facebook, Google, or Instagram.

Anchor to order_marketing_event_type
order_marketing_event_type

The type of marketing activity that led to the order, such as Ad, Affiliate, Newsletter, or Retargeting. PLA means Product Listing Ads, and SEO means Search Engine Optimization.

Anchor to market
market

Market you've defined in Shopify, like a geographical market or customer group

Anchor to markets
markets
<>

Markets or customer segments associated with the order

Anchor to order_cancellation_reason
order_cancellation_reason

The reason specified for the order cancellation, such as Customer, Other, Fraud, or Inventory.

Anchor to order_risk_level
order_risk_level

The fraud risk level Shopify assigned to the order, with values Low, Medium, High, None, and Pending.

Anchor to order_is_shopify_protect_covered
order_is_shopify_protect_covered

Whether the order has met Shopify Protect fulfillment requirements, including proper shipping and tracking, with values true and false.

Anchor to order_is_shopify_protect_eligible
order_is_shopify_protect_eligible

Whether the order qualifies for Shopify Protect, with values true and false.

Anchor to order_is_shopify_protect_protected
order_is_shopify_protect_protected

Whether the order has full Shopify Protect coverage against fraud, with values true and false.

Anchor to order_tag
order_tag

Tag associated with the order

Anchor to order_tags
order_tags
<>

Set of tags associated with the order

Anchor to agentic_referring_channel
agentic_referring_channel

The AI agent or assistant that referred the session to your online store, with values ChatGPT, Google AI Mode and Gemini, Microsoft Copilot, and Shop.

Anchor to channel_handle
channel_handle

Name of the marketing channel or platform that drove the marketing engagement

Anchor to marketing_activity_id
marketing_activity_id

The unique Shopify identifier for the marketing activity. Use marketing_activity_id with marketing_activity_title to show readable activity labels.

Anchor to marketing_activity_status
marketing_activity_status

Current status of the marketing activity (such as Active or Paused)

Anchor to marketing_activity_title
marketing_activity_title

Name of the marketing activity

Anchor to marketing_activity_url_parameter_key
marketing_activity_url_parameter_key

URL parameter key for the marketing activity

Anchor to marketing_activity_url_parameter_value
marketing_activity_url_parameter_value

URL parameter value for the marketing activity

Anchor to marketing_automation_id
marketing_automation_id

Unique ID that Shopify uses to identify the marketing automation

Anchor to marketing_delivery_channel
marketing_delivery_channel

Channel through which the marketing activity is delivered

Anchor to marketing_event_id
marketing_event_id

Unique identifier for the associated marketing event

Anchor to marketing_platform
marketing_platform

The marketing platform that created the marketing activity, shown as a platform name.

Anchor to page_host
page_host

The host name of the session landing page.

Anchor to page_path
page_path

The path of the session landing page.

Anchor to page_url
page_url

The URL of the first page viewed in the session.

Anchor to referrer_url
referrer_url

External page that led to an online store session

Anchor to utm_campaign
utm_campaign

UTM name of the campaign associated with the session

Anchor to utm_content
utm_content

The UTM content value associated with the session, often used to distinguish ads, links, or content variations.

Anchor to utm_medium
utm_medium

The UTM medium associated with the session, such as email, social, or paid search.

Anchor to utm_source
utm_source

The UTM source associated with the session, such as Google, Facebook, or a newsletter.

Anchor to utm_term
utm_term

The UTM term associated with the session, often used for paid search keywords or other tracked terms.

Anchor to pos_location_name
pos_location_name

Name of your physical retail location

Anchor to product_status
product_status

The product's current publishing state, with values Active, Archived, Draft, Suspended, and Unlisted.

Anchor to product_title
product_title

Display name of the product that your customers see

Anchor to product_type
product_type

Type (category) that you've assigned to the product

Anchor to product_vendor
product_vendor

Vendor of the product

Anchor to product_collection
product_collection

Collection associated with the product

Anchor to product_collections
product_collections
<>

Set of collections associated with the product

Anchor to product_tag
product_tag

Tag associated with the product

Anchor to product_tags
product_tags
<>

Set of tags associated with the product

Anchor to product_variant_abc_grade
product_variant_abc_grade

The ABC grade assigned to the product variant based on its share of revenue. A-grade variants account for about 80% of revenue, B-grade for 15%, and C-grade for 5%.

Anchor to product_variant_sku
product_variant_sku

SKU of the product variant

Anchor to product_variant_title
product_variant_title

Display name of the product variant

Anchor to shipping_city
shipping_city

City of the shipping address

Anchor to shipping_company
shipping_company

Company of the shipping address

Anchor to shipping_country
shipping_country

Country of the shipping address (e.g., United States, Canada)

Anchor to shipping_postal_code
shipping_postal_code

Postal code of the shipping address

Anchor to shipping_region
shipping_region

State or province of the shipping address (e.g., California, Ontario)

Anchor to staff_member_name
staff_member_name

Name of the staff member associated with the order

Anchor to order_or_return
order_or_return

Label specifying whether the transaction adds or removes value from sales

Deprecated

Deprecated since 2026-07. Replaced by order_or_sales_reversal


Was this page helpful?