Orders Drill-Down

See how profit is calculated on every single order

The P&L gives you the big picture. The Orders page lets you zoom in on any individual order and see exactly how its profit was calculated — every cost line, every fee, every deduction. When something looks wrong, you can override it on the spot.

All Plans
Orders List

Every order, every margin

The orders list shows every order in the selected period with revenue, COGS, fees, net profit, and margin percentage in a sortable table. You can search by order number, filter by date range, and sort by any column. Orders with missing COGS are flagged in amber. Refunded orders show in red. You see 25 orders per page with pagination.

The table is designed to help you spot patterns quickly. Sort by margin to find your worst-performing orders. Sort by profit to find your best. Filter to a specific week to see if a promotion helped or hurt. The color coding makes it immediately obvious which orders are healthy and which need investigation.

OrderDateRevenueCOGSFeesNet ProfitMarginStatus
#12389 Apr 28 $247 $112 $38 $97 39.3% Paid
#12388 Apr 28 $185 $89 $29 $67 36.2% Paid
#12387 Apr 27 $420 $210 $63 $147 35.0% Paid
#12386 Apr 27 $92 $68 $18 $6 6.5% Missing COGS
#12385 Apr 26 $310 $155 $47 -$12 -3.9% Refunded
Order Detail

Full profit waterfall per order

Click any order in the list and a detail modal opens showing the complete profit calculation for that specific order. At the top, you see the order header — order number, date, payment gateway used, customer type (new or returning), country, and UTM source if available. Status badges show financial status, fulfillment status, and any flags like missing COGS, test order, or dispute.

Below that is the revenue waterfall: gross revenue, minus refunds, minus discounts (noted but not double-counted), arriving at net revenue. Then COGS is subtracted to reach gross profit. Then shipping, transaction fees, payment processing fees, taxes, and per-order fees are subtracted to reach contribution margin. Each line shows the exact amount and how it was calculated.

At the bottom, you see payment reconciliation — how much cash was received, refunded, and outstanding — and a line-item table showing each product in the order with quantity, unit price, unit cost, total, and profit per item. This level of detail means you can trace exactly why an order was profitable or unprofitable, down to the individual product.

Note that ad spend and custom overhead are period-level costs, not per-order. They appear in the P&L but not in the order detail, because attributing a monthly rent charge to individual orders would be misleading.

Order #12389
Paid Fulfilled
Apr 28, 2026 · Stripe · New Customer · US · utm: google/cpc
Gross Revenue $247.00
− Refunds $0.00
Net Revenue $247.00
− COGS −$112.00
Gross Profit (CM1) $135.00
− Shipping −$18.00
− Payment Fees −$5.93
− Tax −$14.07
Contribution Margin (CM2) $97.00
Line Items
Pro Jersey Blue (L) ×2 $69.40
Cap Classic ×1 $27.60
Cost Overrides

When the calculated cost is wrong, fix it on the spot

Cost rules work for 95% of orders. But sometimes the real cost is different — a supplier gave you a one-time discount, a customer needed express shipping, or a product was sourced from a different vendor. For these cases, you can override COGS or shipping cost directly on the order. The profit recalculates instantly.

The original calculated values are preserved alongside the override, so you always have an audit trail. You can also add a note explaining why the override was made — useful when your team is reviewing orders later or when your accountant asks why a number changed.

COGS Override

Replace the calculated COGS with the actual cost you paid. Original value preserved for audit.

Shipping Override

Replace the calculated shipping with the real carrier charge — useful for negotiated rates or express shipping.

Override Note

Add a reason so your team knows why the numbers changed. Shows in the order detail and export.

Edge Cases

Every order type, handled correctly

Real Shopify stores don't just have clean, paid orders. They have partial refunds, disputes, test orders, edited orders, COD orders, and draft orders. NetNet handles all of them. Partial refunds reduce revenue proportionally. Disputes are tracked separately from voluntary refunds. Test orders are excluded from totals but still visible. Edited orders update automatically when Shopify sends the webhook. Each order type gets a status badge so you can see exactly what happened.

Full refunds
Partial refunds
Chargebacks
Test orders
Edited orders
Draft orders
COD orders
Multi-currency

Stop guessing.
Start knowing.

Free plan. No credit card. Install in 60 seconds.

Install Free on Shopify