Skip to main content
The total number of orders cancelled before fulfillment in your Shopify store.

Formula

Cancelled Orders = COUNT ( Orders ) WHERE status = cancelled

Formula Components

MetricDefinition
OrdersTotal number of orders placed
status = cancelledFilters to orders marked as cancelled before fulfillment
Metadata
TypeNumber
Data SourceShopify
AggregationCount

Example

Your store had 69 cancelled orders during Q1 across 4,200 total orders:
MonthCancelledCancellation Rate
January181.3%
February271.9% (payment processor issue)
March241.7%

How It Works

Cancelled Orders counts all orders marked as cancelled in Shopify before fulfillment. Unlike refunds, cancellations represent orders that never shipped. Spikes often correlate with payment failures, inventory stockouts, or customer-initiated order changes.

When to Use

ScenarioAction
Monitor checkout healthTrack cancellations as percentage of total orders
Diagnose payment issuesCompare against payment failure rates
Detect inventory problemsCorrelate spikes with stockout events
Segment by customer typeCompare new vs returning customer cancellations

MetricRelationship
Cancelled AmountDollar value of these cancelled orders
Refund CountOrders refunded after fulfillment
Refund AmountDollar value of refunds
OrdersAll orders including cancelled
Net RevenueRevenue after all adjustments
See all Adjustment metrics →