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.
Anchor to Use casesUse cases
- Tax by line type: Group
sales_taxesbyline_typeto split tax across products, shipping, and other line types. - Managed Markets: Compare
sales_taxesandmanaged_markets_taxesby month to separate domestic tax from tax collected on cross-border Managed Markets orders. - Channel and product: Break down tax amounts by
sales_channel,pos_location_id, orproduct_idto see where your tax liability comes from. - Address context: Use
billing_address_idandshipping_address_idwhen connecting tax records to address-level context.
Anchor to MetricsMetrics
Counts and calculations that let you track key business indicators. Metrics show up as the columns when queried.
Metrics you can use when querying .
- Anchor to managed_markets_taxesmanaged_
markets_ taxesmanaged_ markets_ taxes MONEYMONEY Sales taxes collected from Global-e when Global-e buys from you and sells to customers, in your store's currency.
- Anchor to sales_taxessales_
taxessales_ taxes MONEYMONEY
MONEY
A monetary amount representing currency values such as prices, revenue, costs, and discounts.
Anchor to DimensionsDimensions
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 .
- Anchor to billing_address_idbilling_
address_ idbilling_ address_ id IDENTITYIDENTITY - Anchor to daydaydayDAY_TIMESTAMPDAY_TIMESTAMP
The day a tax was applied to a sale.
- Anchor to day_of_weekday_
of_ weekday_ of_ week DAY_OF_WEEKDAY_OF_WEEK The weekday a tax was applied to a sale, with values Monday through Sunday.
- Anchor to filed_by_channelfiled_
by_ channelfiled_ by_ channel STRINGSTRING Whether the sales channel filed taxes for the transaction, with values Filed, Not filed, and Unspecified.
- Anchor to hourhourhourHOUR_TIMESTAMPHOUR_TIMESTAMP
The hour a tax was applied to a sale.
- Anchor to hour_of_dayhour_
of_ dayhour_ of_ day HOUR_OF_DAYHOUR_OF_DAY The hour of day a tax was applied to a sale, with values 0 through 23.
- Anchor to line_item_idline_
item_ idline_ item_ id IDENTITYIDENTITY - Anchor to line_typeline_
typeline_ type STRINGSTRING The kind of sales charge the tax applies to, such as Product, Shipping, Duty, or Additional fee.
- Anchor to merchant_of_record_countrymerchant_
of_ record_ countrymerchant_ of_ record_ country STRINGSTRING The country where the merchant of record bought your products before selling them to customers
- Anchor to merchant_of_record_regionmerchant_
of_ record_ regionmerchant_ of_ record_ region STRINGSTRING The region where the merchant of record bought your products before selling them to customers
- Anchor to minuteminuteminuteMINUTE_TIMESTAMPMINUTE_TIMESTAMP
The minute a tax was applied to a sale.
- Anchor to monthmonthmonthMONTH_TIMESTAMPMONTH_TIMESTAMP
The month a tax was applied to a sale.
- Anchor to month_of_yearmonth_
of_ yearmonth_ of_ year MONTH_OF_YEARMONTH_OF_YEAR The month of year a tax was applied to a sale, with values 1 through 12.
- Anchor to order_idorder_
idorder_ id IDENTITYIDENTITY - Anchor to order_or_sales_reversalorder_
or_ sales_ reversalorder_ or_ sales_ reversal STRINGSTRING Label specifying whether the transaction adds or removes value from sales
- Anchor to pos_location_idpos_
location_ idpos_ location_ id IDENTITYIDENTITY - Anchor to product_idproduct_
idproduct_ id IDENTITYIDENTITY - Anchor to product_variant_idproduct_
variant_ idproduct_ variant_ id IDENTITYIDENTITY - Anchor to quarterquarterquarterQUARTER_TIMESTAMPQUARTER_TIMESTAMP
The quarter a tax was applied to a sale.
- Anchor to sale_sales_channel_idsale_
sales_ channel_ idsale_ sales_ channel_ id IDENTITYIDENTITY - Anchor to sales_channelsales_
channelsales_ channel STRINGSTRING Name of the sales channel where the customer made a purchase
- Anchor to sales_tax_idsales_
tax_ idsales_ tax_ id IDENTITYIDENTITY - Anchor to secondsecondsecondSECOND_TIMESTAMPSECOND_TIMESTAMP
The second a tax was applied to a sale.
- Anchor to shipping_address_idshipping_
address_ idshipping_ address_ id IDENTITYIDENTITY - Anchor to shop_idshop_
idshop_ id IDENTITYIDENTITY - Anchor to staff_idstaff_
idstaff_ id IDENTITYIDENTITY - Anchor to tax_citytax_
citytax_ city STRINGSTRING - Anchor to tax_countrytax_
countrytax_ country STRINGSTRING The country used as the tax location for the sale.
- Anchor to tax_nametax_
nametax_ name STRINGSTRING - Anchor to tax_ratetax_
ratetax_ rate PERCENTPERCENT - Anchor to tax_regiontax_
regiontax_ region STRINGSTRING - Anchor to weekweekweekWEEK_TIMESTAMPWEEK_TIMESTAMP
The week a tax was applied to a sale.
- Anchor to week_of_yearweek_
of_ yearweek_ of_ year WEEK_OF_YEARWEEK_OF_YEAR The week of year a tax was applied to a sale, with values 1 through 53.
- Anchor to yearyearyearYEAR_TIMESTAMPYEAR_TIMESTAMP
The year a tax was applied to a sale.
- Anchor to billing_citybilling_
citybilling_ city STRINGSTRING City of the billing address
- Anchor to billing_companybilling_
companybilling_ company STRINGSTRING B2B customer associated with the billing address
- Anchor to billing_countrybilling_
countrybilling_ country STRINGSTRING Country of the billing address (e.g., United States, Canada)
- Anchor to billing_postal_codebilling_
postal_ codebilling_ postal_ code STRINGSTRING Postal code of the billing address
- Anchor to billing_regionbilling_
regionbilling_ region STRINGSTRING State or province of the billing address (e.g., California, Ontario)
- Anchor to shop_nameshop_
nameshop_ name STRINGSTRING Name of your store
- Anchor to product_title_at_time_of_saleproduct_
title_ at_ time_ of_ saleproduct_ title_ at_ time_ of_ sale STRINGSTRING The product name as it appeared when the item was sold.
- Anchor to product_type_at_time_of_saleproduct_
type_ at_ time_ of_ saleproduct_ type_ at_ time_ of_ sale STRINGSTRING The product type or category assigned when the item was sold.
- Anchor to product_variant_compare_at_priceproduct_
variant_ compare_ at_ priceproduct_ variant_ compare_ at_ price MONEYMONEY The compare-at price of the product variant when the item was sold, in your store's currency.
- Anchor to product_variant_priceproduct_
variant_ priceproduct_ variant_ price MONEYMONEY The price of the product variant when the item was sold, in your store's currency.
- Anchor to product_variant_sku_at_time_of_saleproduct_
variant_ sku_ at_ time_ of_ saleproduct_ variant_ sku_ at_ time_ of_ sale STRINGSTRING The SKU of the product variant when the item was sold.
- Anchor to product_variant_title_at_time_of_saleproduct_
variant_ title_ at_ time_ of_ saleproduct_ variant_ title_ at_ time_ of_ sale STRINGSTRING The variant name as it appeared when the item was sold.
- Anchor to product_vendor_at_time_of_saleproduct_
vendor_ at_ time_ of_ saleproduct_ vendor_ at_ time_ of_ sale STRINGSTRING The vendor assigned to the product when the item was sold.
- Anchor to is_b2b_orderis_
b2b_ orderis_ b2b_ order BOOLEANBOOLEAN Whether the order is a B2B order, with values
trueandfalse.- Anchor to is_canceled_orderis_
canceled_ orderis_ canceled_ order BOOLEANBOOLEAN Whether the order is canceled, with values
trueandfalse.- Anchor to order_checkout_currencyorder_
checkout_ currencyorder_ checkout_ currency STRINGSTRING 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_statusorder_
fulfillment_ statusorder_ fulfillment_ status STRINGSTRING The order's fulfillment state, with values Fulfilled, Partial, Restocked, and Unfulfilled.
- Anchor to order_includes_dutiesorder_
includes_ dutiesorder_ includes_ duties BOOLEANBOOLEAN Whether the order includes duties, with values
trueandfalse.- Anchor to order_nameorder_
nameorder_ name STRINGSTRING The name or number of the order as the customer sees it.
- Anchor to order_payment_statusorder_
payment_ statusorder_ payment_ status STRINGSTRING The order's payment state, such as Authorized, Paid, Partially refunded, or Pending.
- Anchor to order_sales_channelorder_
sales_ channelorder_ sales_ channel STRINGSTRING The sales channel where the order was placed, shown as a channel name such as Online Store or POS.
- Anchor to order_sales_channel_idorder_
sales_ channel_ idorder_ sales_ channel_ id IDENTITYIDENTITY - Anchor to is_shop_referral_orderis_
shop_ referral_ orderis_ shop_ referral_ order BOOLEANBOOLEAN Whether the order was referred from the Shop app or shop.app, with values
trueandfalse.- Anchor to order_landing_page_pathorder_
landing_ page_ pathorder_ landing_ page_ path STRINGSTRING Path of the first page of the user session that resulted in the order
- Anchor to order_landing_page_urlorder_
landing_ page_ urlorder_ landing_ page_ url STRINGSTRING First page of the user session that resulted in the order
- Anchor to order_marketing_event_idorder_
marketing_ event_ idorder_ marketing_ event_ id IDENTITYIDENTITY Shopify identifier for the marketing event associated with the order
- Anchor to order_referrer_domainorder_
referrer_ domainorder_ referrer_ domain STRINGSTRING Domain of the site that led to the order
- Anchor to order_referrer_nameorder_
referrer_ nameorder_ referrer_ name STRINGSTRING The readable name of the site that led to the order.
- Anchor to order_referrer_pathorder_
referrer_ pathorder_ referrer_ path STRINGSTRING Path of the site that led to the order
- Anchor to order_referrer_siteorder_
referrer_ siteorder_ referrer_ site STRINGSTRING Site that led to the order
- Anchor to order_referrer_sourceorder_
referrer_ sourceorder_ referrer_ source STRINGSTRING The referrer type that led to the order, such as organic or email.
- Anchor to order_referrer_urlorder_
referrer_ urlorder_ referrer_ url STRINGSTRING External page that referred a customer and led to the order
- Anchor to order_utm_campaignorder_
utm_ campaignorder_ utm_ campaign STRINGSTRING UTM name of the campaign associated with the order
- Anchor to order_utm_contentorder_
utm_ contentorder_ utm_ content STRINGSTRING The UTM content value associated with the order, often used to distinguish ads, links, or content variations.
- Anchor to order_utm_mediumorder_
utm_ mediumorder_ utm_ medium STRINGSTRING The UTM medium associated with the order, such as email, social, or paid search.
- Anchor to order_utm_sourceorder_
utm_ sourceorder_ utm_ source STRINGSTRING The UTM source associated with the order, such as Google, Facebook, or a newsletter.
- Anchor to order_utm_termorder_
utm_ termorder_ utm_ term STRINGSTRING The UTM term associated with the order, often used for paid search keywords or other tracked terms.
- Anchor to number_of_products_bought_togethernumber_
of_ products_ bought_ togethernumber_ of_ products_ bought_ together INTEGERINTEGER Total unique products in the same order
- Anchor to number_of_variants_bought_togethernumber_
of_ variants_ bought_ togethernumber_ of_ variants_ bought_ together INTEGERINTEGER The number of unique product variants in the same order, with each SKU counted a single time.
- Anchor to products_bought_togetherproducts_
bought_ togetherproducts_ bought_ together ARRAY<STRING>ARRAY<STRING> The product names that appear in the same order.
- Anchor to products_bought_together_idsproducts_
bought_ together_ idsproducts_ bought_ together_ ids ARRAY<INTEGER>ARRAY<INTEGER> The Shopify product identifiers for products in the same order.
- Anchor to variants_bought_togethervariants_
bought_ togethervariants_ bought_ together ARRAY<STRING>ARRAY<STRING> The product variant labels that appear in the same order, such as size, color, or style combinations.
- Anchor to company_idcompany_
idcompany_ id IDENTITYIDENTITY - Anchor to company_namecompany_
namecompany_ name STRINGSTRING Name of the company that placed the order
- Anchor to company_location_idcompany_
location_ idcompany_ location_ id IDENTITYIDENTITY - Anchor to company_location_namecompany_
location_ namecompany_ location_ name STRINGSTRING The company location or branch that placed the order
- Anchor to referring_channelreferring_
channelreferring_ channel STRINGSTRING Marketing channel that referred the customer to place the order
- Anchor to referring_mediumreferring_
mediumreferring_ medium STRINGSTRING The marketing medium that referred the customer to place the order, such as email, social, or search.
- Anchor to referring_platformreferring_
platformreferring_ platform STRINGSTRING The marketing platform that referred the customer to place the order, such as Google, Facebook, or Instagram.
- Anchor to traffic_typetraffic_
typetraffic_ type STRINGSTRING The type of traffic that led to the order, such as organic, paid, or direct.
- Anchor to order_marketing_event_targetorder_
marketing_ event_ targetorder_ marketing_ event_ target STRINGSTRING The platform or channel where the marketing activity was deployed, such as Email, Facebook, Google, or Instagram.
- Anchor to order_marketing_event_typeorder_
marketing_ event_ typeorder_ marketing_ event_ type STRINGSTRING 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 marketmarketmarketSTRINGSTRING
Market you've defined in Shopify, like a geographical market or customer group
- Anchor to marketsmarketsmarketsARRAY<STRING>ARRAY<STRING>
Markets or customer segments associated with the order
- Anchor to order_cancellation_reasonorder_
cancellation_ reasonorder_ cancellation_ reason STRINGSTRING The reason specified for the order cancellation, such as Customer, Other, Fraud, or Inventory.
- Anchor to order_risk_levelorder_
risk_ levelorder_ risk_ level STRINGSTRING The fraud risk level Shopify assigned to the order, with values Low, Medium, High, None, and Pending.
- Anchor to order_is_shopify_protect_coveredorder_
is_ shopify_ protect_ coveredorder_ is_ shopify_ protect_ covered BOOLEANBOOLEAN Whether the order has met Shopify Protect fulfillment requirements, including proper shipping and tracking, with values
trueandfalse.- Anchor to order_is_shopify_protect_eligibleorder_
is_ shopify_ protect_ eligibleorder_ is_ shopify_ protect_ eligible BOOLEANBOOLEAN Whether the order qualifies for Shopify Protect, with values
trueandfalse.- Anchor to order_is_shopify_protect_protectedorder_
is_ shopify_ protect_ protectedorder_ is_ shopify_ protect_ protected BOOLEANBOOLEAN Whether the order has full Shopify Protect coverage against fraud, with values
trueandfalse.- Anchor to order_tagorder_
tagorder_ tag STRINGSTRING Tag associated with the order
- ARRAY<STRING>ARRAY<STRING>
Set of tags associated with the order
- Anchor to agentic_referring_channelagentic_
referring_ channelagentic_ referring_ channel STRINGSTRING 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_handlechannel_
handlechannel_ handle STRINGSTRING Name of the marketing channel or platform that drove the marketing engagement
- Anchor to marketing_activity_idmarketing_
activity_ idmarketing_ activity_ id IDENTITYIDENTITY - Anchor to marketing_activity_statusmarketing_
activity_ statusmarketing_ activity_ status STRINGSTRING Current status of the marketing activity (such as Active or Paused)
- Anchor to marketing_activity_titlemarketing_
activity_ titlemarketing_ activity_ title STRINGSTRING Name of the marketing activity
- Anchor to marketing_activity_url_parameter_keymarketing_
activity_ url_ parameter_ keymarketing_ activity_ url_ parameter_ key STRINGSTRING URL parameter key for the marketing activity
- Anchor to marketing_activity_url_parameter_valuemarketing_
activity_ url_ parameter_ valuemarketing_ activity_ url_ parameter_ value STRINGSTRING URL parameter value for the marketing activity
- Anchor to marketing_automation_idmarketing_
automation_ idmarketing_ automation_ id IDENTITYIDENTITY Unique ID that Shopify uses to identify the marketing automation
- Anchor to marketing_delivery_channelmarketing_
delivery_ channelmarketing_ delivery_ channel STRINGSTRING Channel through which the marketing activity is delivered
- Anchor to marketing_event_idmarketing_
event_ idmarketing_ event_ id IDENTITYIDENTITY Unique identifier for the associated marketing event
- Anchor to marketing_platformmarketing_
platformmarketing_ platform STRINGSTRING The marketing platform that created the marketing activity, shown as a platform name.
- Anchor to page_hostpage_
hostpage_ host STRINGSTRING The host name of the session landing page.
- Anchor to page_pathpage_
pathpage_ path STRINGSTRING The path of the session landing page.
- Anchor to page_urlpage_
urlpage_ url STRINGSTRING The URL of the first page viewed in the session.
- Anchor to referrer_urlreferrer_
urlreferrer_ url STRINGSTRING External page that led to an online store session
- Anchor to utm_campaignutm_
campaignutm_ campaign STRINGSTRING UTM name of the campaign associated with the session
- Anchor to utm_contentutm_
contentutm_ content STRINGSTRING The UTM content value associated with the session, often used to distinguish ads, links, or content variations.
- Anchor to utm_mediumutm_
mediumutm_ medium STRINGSTRING The UTM medium associated with the session, such as email, social, or paid search.
- Anchor to utm_sourceutm_
sourceutm_ source STRINGSTRING The UTM source associated with the session, such as Google, Facebook, or a newsletter.
- Anchor to utm_termutm_
termutm_ term STRINGSTRING The UTM term associated with the session, often used for paid search keywords or other tracked terms.
- Anchor to pos_location_namepos_
location_ namepos_ location_ name STRINGSTRING Name of your physical retail location
- Anchor to product_statusproduct_
statusproduct_ status STRINGSTRING The product's current publishing state, with values Active, Archived, Draft, Suspended, and Unlisted.
- Anchor to product_titleproduct_
titleproduct_ title STRINGSTRING Display name of the product that your customers see
- Anchor to product_typeproduct_
typeproduct_ type STRINGSTRING Type (category) that you've assigned to the product
- Anchor to product_vendorproduct_
vendorproduct_ vendor STRINGSTRING Vendor of the product
- Anchor to product_collectionproduct_
collectionproduct_ collection STRINGSTRING Collection associated with the product
- Anchor to product_collectionsproduct_
collectionsproduct_ collections ARRAY<STRING>ARRAY<STRING> Set of collections associated with the product
- Anchor to product_tagproduct_
tagproduct_ tag STRINGSTRING Tag associated with the product
- ARRAY<STRING>ARRAY<STRING>
Set of tags associated with the product
- Anchor to product_variant_abc_gradeproduct_
variant_ abc_ gradeproduct_ variant_ abc_ grade STRINGSTRING 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_skuproduct_
variant_ skuproduct_ variant_ sku STRINGSTRING SKU of the product variant
- Anchor to product_variant_titleproduct_
variant_ titleproduct_ variant_ title STRINGSTRING Display name of the product variant
- Anchor to shipping_cityshipping_
cityshipping_ city STRINGSTRING City of the shipping address
- Anchor to shipping_companyshipping_
companyshipping_ company STRINGSTRING Company of the shipping address
- Anchor to shipping_countryshipping_
countryshipping_ country STRINGSTRING Country of the shipping address (e.g., United States, Canada)
- Anchor to shipping_postal_codeshipping_
postal_ codeshipping_ postal_ code STRINGSTRING Postal code of the shipping address
- Anchor to shipping_regionshipping_
regionshipping_ region STRINGSTRING State or province of the shipping address (e.g., California, Ontario)
- Anchor to staff_member_namestaff_
member_ namestaff_ member_ name STRINGSTRING Name of the staff member associated with the order
- Anchor to order_or_returnorder_
or_ returnorder_ or_ return STRINGSTRINGdeprecateddeprecated Label specifying whether the transaction adds or removes value from sales
IDENTITY
A unique identifier for a Shopify resource such as a customer, product, or order.
DAY_TIMESTAMP
A date value truncated to day precision.
DAY_OF_WEEK
A day within a week, used for weekday-based grouping and filtering.
STRING
A sequence of characters representing text data.
HOUR_TIMESTAMP
A timestamp truncated to hour precision.
HOUR_OF_DAY
An hour within a day, typically represented as an integer from 0 to 23.
MINUTE_TIMESTAMP
A timestamp truncated to minute precision.
MONTH_TIMESTAMP
A date value representing the start of a month.
MONTH_OF_YEAR
A month number within a year.
QUARTER_TIMESTAMP
A date value representing the start of a fiscal quarter.
SECOND_TIMESTAMP
A timestamp truncated to second precision.
PERCENT
A percentage value represented as a decimal, where 0.25 represents 25%.
WEEK_TIMESTAMP
A date value representing the start of a week.
WEEK_OF_YEAR
A week number within a year.
YEAR_TIMESTAMP
A date value representing the start of a year.
BOOLEAN
A true or false value representing binary states.
INTEGER
A whole number without decimal places, used for counts, quantities, and other discrete numeric values.
ARRAY
A list of values. The element type appears inside angle brackets, such as ARRAY<STRING>.