Skip to main content
Global-E can introduce duties on international Shopify orders. In current standard SourceMedium order tables, duties are exposed separately from the standard revenue fields.

Standard revenue fields

For current sm_transformed_v2 order tables:
  • Net Revenue = Gross Revenue + Discounts + Refunds
  • Net Revenue Before Refunds = Gross Revenue + Discounts
  • Total Revenue = Net Revenue + Net Shipping + Net Taxes + Net Shipping Taxes
These standard fields do not add duties directly into order_net_revenue or order_total_revenue. Duties appear in separate fields such as:
  • order_gross_duties
  • order_duty_refunds
  • order_net_duties
See Revenue Fields for the canonical revenue definitions.

How to analyze Global-E duties

If you need a duties-inclusive view for international orders, include the duty fields explicitly in your query or dashboard calculation. For example:
Some custom dashboards or historical reports may handle Global-E duties differently. When reconciling a specific dashboard, confirm whether the tile uses standard order_* revenue fields or a custom duties-inclusive calculation.