> ## 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.

# Returning Customer Cancelled Orders: Cancellations by Repeat Buyers

> Track cancelled orders from returning customers. Monitor repeat buyer cancellations to identify fulfillment issues and protect customer retention.

<Tip>
  The number of orders from returning customers that were cancelled before fulfillment.
</Tip>

## Formula

<Info>
  **Returning Customer Cancelled Orders** = **COUNT** ( Cancelled Orders ) **WHERE** [customer\_type = returning\_customer](/data-dictionary/measures-and-dimensions#visitor-dimensions)
</Info>

### Formula Components

| Metric                                                                                                  | Definition                                                 |
| ------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------- |
| [**Cancelled Orders**](/reference/metrics/orders/adjustments/cancelled-orders)                          | Total count of cancelled orders                            |
| [**customer\_type = returning\_customer**](/data-dictionary/measures-and-dimensions#visitor-dimensions) | Filters to orders from customers who have purchased before |

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

***

## Example

Your store had **22 Returning Customer Cancelled Orders** this month out of 2,340 returning customer orders:

| Week      | RC Cancellations | RC Orders | Cancel %               |
| --------- | ---------------- | --------- | ---------------------- |
| Week 1    | 4                | 580       | 0.7%                   |
| Week 2    | 8                | 610       | 1.3% (inventory issue) |
| Week 3    | 6                | 590       | 1.0%                   |
| Week 4    | 4                | 560       | 0.7%                   |
| **Total** | **22**           | **2,340** | **0.9%**               |

***

## How It Works

This metric counts orders placed by returning customers that were cancelled before fulfillment in Shopify. A customer is classified as "returning" if they have completed at least one previous purchase. Cancellations typically occur due to inventory stockouts, payment issues, or customer requests.

***

## When to Use

| Scenario                       | Action                                                      |
| ------------------------------ | ----------------------------------------------------------- |
| Protecting customer retention  | Monitor cancellation trends among your most valuable buyers |
| Investigating inventory issues | Spikes may indicate stockouts affecting repeat purchasers   |
| Measuring lost opportunity     | Pair with RC Cancelled Amount for dollar impact             |
| Comparing customer types       | Benchmark against new customer cancellation rates           |

***

## Related Metrics

| Metric                                                                                           | Relationship                                     |
| ------------------------------------------------------------------------------------------------ | ------------------------------------------------ |
| [RC Cancelled Amount](/reference/metrics/orders/adjustments/returning-customer-cancelled-amount) | Dollar value of these cancellations              |
| [Cancelled Orders](/reference/metrics/orders/adjustments/cancelled-orders)                       | Total cancellations (all customers)              |
| [NC Cancelled Orders](/reference/metrics/orders/adjustments/new-customer-cancelled-orders)       | Same metric for first-time buyers                |
| [Returning Customers](/reference/metrics/orders/customers/returning-customers)                   | Total returning customers (denominator for rate) |

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