Dutton Brown — 2026 Fulfillment Report

Fulfillment Time (Days to Ship) i Bars show count of orders falling into each ship-time bucket. Counts are filtered by the active pill above. Numbers above each bar = count in that bucket.

Product Mix Shipped

Samples

Carrier Mix

Top Shipping Destinations

Shipping Method

Order Tiers i Sample — only sample line items (SKU starts SAC or name contains "sample")
Core — order subtotal between $40.01 and $5,000 (primary metric, excludes samples and large orders)
Small Accessory — order subtotal $0.01–$40 (bulbs, rods, small hardware)
Large — order subtotal greater than $5,000 (reported separately so they don't skew AOV)
Zero Dollar — non-sample order with $0 subtotal (free items, replacements)

Fulfillment Time (Days to Ship) i Bars show count of orders falling into each ship-time bucket. Counts are filtered by the active pill above. Numbers above each bar = count in that bucket.

Product Mix Shipped

Samples

Carrier Mix

Top Shipping Destinations

Shipping Method

Order Tiers i Sample — only sample line items (SKU starts SAC or name contains "sample")
Core — order subtotal between $40.01 and $5,000 (primary metric, excludes samples and large orders)
Small Accessory — order subtotal $0.01–$40 (bulbs, rods, small hardware)
Large — order subtotal greater than $5,000 (reported separately so they don't skew AOV)
Zero Dollar — non-sample order with $0 subtotal (free items, replacements)

Fulfillment Time (Days to Ship) i Bars show count of orders falling into each ship-time bucket. Counts are filtered by the active pill above. Numbers above each bar = count in that bucket.

Product Mix Shipped

Samples

Carrier Mix

Top Shipping Destinations

Shipping Method

Order Tiers i Sample — only sample line items (SKU starts SAC or name contains "sample")
Core — order subtotal between $40.01 and $5,000 (primary metric, excludes samples and large orders)
Small Accessory — order subtotal $0.01–$40 (bulbs, rods, small hardware)
Large — order subtotal greater than $5,000 (reported separately so they don't skew AOV)
Zero Dollar — non-sample order with $0 subtotal (free items, replacements)

Fulfillment Time (Days to Ship) i Bars show count of orders falling into each ship-time bucket. Counts are filtered by the active pill above. Numbers above each bar = count in that bucket.

Product Mix Shipped

Samples

Carrier Mix

Top Shipping Destinations

Shipping Method

Order Tiers i Sample — only sample line items (SKU starts SAC or name contains "sample")
Core — order subtotal between $40.01 and $5,000 (primary metric, excludes samples and large orders)
Small Accessory — order subtotal $0.01–$40 (bulbs, rods, small hardware)
Large — order subtotal greater than $5,000 (reported separately so they don't skew AOV)
Zero Dollar — non-sample order with $0 subtotal (free items, replacements)

Fulfillment Time (Days to Ship) i Bars show count of orders falling into each ship-time bucket. Counts are filtered by the active pill above. Numbers above each bar = count in that bucket.

Product Mix Shipped

Samples

Carrier Mix

Top Shipping Destinations

Shipping Method

Order Tiers i Sample — only sample line items (SKU starts SAC or name contains "sample")
Core — order subtotal between $40.01 and $5,000 (primary metric, excludes samples and large orders)
Small Accessory — order subtotal $0.01–$40 (bulbs, rods, small hardware)
Large — order subtotal greater than $5,000 (reported separately so they don't skew AOV)
Zero Dollar — non-sample order with $0 subtotal (free items, replacements)

Shopify ↔ QuickBooks Reconciliation

Shopify Net Revenue = subtotal_price on each order minus refunds issued in the same month (this report's "Revenue Shipped"). QB Total Income = QuickBooks P&L Total Income line, accrual basis, including shipping/expedite/protection fees. Both sides now net refunds in the same period — residual gaps come from timing (ship date vs invoice date), wholesale, and shipping/fee inclusion.

Why the two numbers differ i Three forces drive the gap, all expected:
Timing — Shopify counts on the ship date; QB books on the invoice date. An order placed Mar 28 and shipped Apr 4 hits Shopify's April but QB's March. Cancels over a year, swings any single month.
Refunds — Both sides now net partial refunds in the period they were issued (Policy B). Any residual gap here is not from refunds.
Income mix — QB Total Income includes shipping, expedite fees, package protection. Shopify subtotal does not. So even on the same order, QB will read $5–10 higher per shipping line.

Treat Shopify as the operational truth — what shipped, when, by whom.
Treat QuickBooks as the accounting truth — what's booked, what's recognized, what the accountant works from.
The gap should be small and explained. A gap larger than ~10% in any month is worth investigating: probably a timing artifact, possibly a refund cluster, occasionally a wholesale invoice booked outside Shopify.

Data sources

Shopify — pulled live each report run via the Shopify Admin API.
QuickBooks — read from data/quickbooks/monthly-income.csv. This file is updated when: (a) new monthly P&L CSVs are exported into data/quickbooks/, or (b) the QB MCP server is queried for fresh data (most recent month-end may lag actuals). The latest month often shows "—" while QB is still being closed.