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: 
SELECT
  SUM(order_net_revenue) AS net_revenue,
  SUM(order_total_revenue) AS total_revenue,
  SUM(COALESCE(order_net_duties, 0)) AS net_duties,
  SUM(order_total_revenue + COALESCE(order_net_duties, 0)) AS total_revenue_plus_duties
FROM `your_project.sm_transformed_v2.obt_orders`
WHERE is_order_sm_valid = TRUE;
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.