> ## Documentation Index
> Fetch the complete documentation index at: https://docs.upstackdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Cancelled Orders: Count of Orders Cancelled Before Fulfillment

> Track the number of cancelled orders in your Shopify store. Monitor checkout friction, payment failures, and inventory issues with order cancellation counts.

<Tip>
  The total number of orders cancelled before fulfillment in your Shopify store.
</Tip>

## Formula

<Info>
  **Cancelled Orders** = **COUNT** ( Orders ) **WHERE** status = cancelled
</Info>

### Formula Components

| Metric                                                                                | Definition                                               |
| ------------------------------------------------------------------------------------- | -------------------------------------------------------- |
| [**Orders**](/reference/metrics/orders/counts/orders)                                 | Total number of orders placed                            |
| [**status = cancelled**](/data-dictionary/measures-and-dimensions#visitor-dimensions) | Filters to orders marked as cancelled before fulfillment |

| Metadata        |                             |
| --------------- | --------------------------- |
| **Type**        | Number                      |
| **Data Source** | [Shopify](/sources/shopify) |
| **Aggregation** | Count                       |

***

## Example

Your store had **69 cancelled orders** during Q1 across 4,200 total orders:

| Month    | Cancelled | Cancellation Rate              |
| -------- | --------- | ------------------------------ |
| January  | 18        | 1.3%                           |
| February | 27        | 1.9% (payment processor issue) |
| March    | 24        | 1.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

| Scenario                  | Action                                            |
| ------------------------- | ------------------------------------------------- |
| Monitor checkout health   | Track cancellations as percentage of total orders |
| Diagnose payment issues   | Compare against payment failure rates             |
| Detect inventory problems | Correlate spikes with stockout events             |
| Segment by customer type  | Compare new vs returning customer cancellations   |

***

## Related Metrics

| Metric                                                                     | Relationship                           |
| -------------------------------------------------------------------------- | -------------------------------------- |
| [Cancelled Amount](/reference/metrics/orders/adjustments/cancelled-amount) | Dollar value of these cancelled orders |
| [Refund Count](/reference/metrics/orders/adjustments/refund-count)         | Orders refunded after fulfillment      |
| [Refund Amount](/reference/metrics/orders/adjustments/refund-amount)       | Dollar value of refunds                |
| [Orders](/reference/metrics/orders/counts/orders)                          | All orders including cancelled         |
| [Net Revenue](/reference/metrics/orders/revenue/net-revenue)               | Revenue after all adjustments          |

[See all Adjustment metrics →](/reference/metrics/orders/adjustments)