Counts only open orders with fulfillment status unfulfilled or partial
Excludes orders where Shopify financial status is refunded or voided — these were cancelled without using the Cancel button and would otherwise appear as open
$0 orders are tracked separately and excluded from order count, unit counts, open value, and oldest-order age
Color = product title contains "color" (Dutton Brown names powder-coat variants with a "Color" prefix, e.g. "Color Legend 3 Sconce")
Expedites = orders tagged with "expedit" (case-insensitive)
Oldest open order = oldest order with at least one line item still having fulfillable quantity > 0 AND placed within the last 6 months. Orders older than 6 months are treated as stale (custom holds / data-quality issues) and excluded from this metric.
Avg days to fulfill = mean of (closed_at − created_at) for orders fulfilled in the last 30 days; excludes $0 orders