What's new
Order shipping breakdown — a new
order_shippingtable with gross, net, and subtotal shipping amounts for each order.Fulfillment origin geography — a new
order_fulfillment_line_itemstable showing where each shipment originated, including origin country, state, city, address, and fulfillment center. Split and partial shipments are represented individually, so multi-location fulfillment is fully preserved.Product type is now included on order line items.
What this enables
You can now break down revenue by both destination geography (where orders ship to) and origin geography (where they ship from), and analyze shipping costs directly alongside order and line-item data — including common views like Revenue by State and Revenue by Country.
Availability
These tables and fields are live now and will populate with your current data automatically on the next scheduled sync — no action or backfill request needed. Reach out to your Blue Onion contact if you'd like help incorporating them into your existing queries or dashboards.