The real cost of a cancelled order
A refused cash-on-delivery order costs shipping both ways, packing and time, and earns nothing. How to make sure Insights counts cancellations correctly, then find the cities, products and payment methods behind them.
What one cancellation costs
The order came in on Saturday night. It was packed on Sunday, handed to the courier on Monday, attempted twice and refused at the door on Wednesday. The item is on its way back. Nothing was sold, and the store paid for every step.
On a cash-on-delivery store, a cancellation after dispatch has a direct cost: delivery, the return trip, packing, and the time spent confirming and chasing. It also has an indirect one. The stock was held for days and could not be sold to someone else, and the order inflated the order count you planned around.
Illustrative example: Cedar Home takes 600 orders a month at an average of EGP 800, and 15% are cancelled: 90 orders, EGP 72,000 that never became sales. Sixty of those were cancelled after dispatch. At EGP 60 for delivery, EGP 40 for the return and EGP 15 for packing, each cost EGP 115, or EGP 6,900 for the month. On 600 orders, every point of cancellation rate is 6 orders, or EGP 4,800 of sales at this order value.
Make the numbers honest first
Insights can only count a cancellation it can recognise. Each platform has its own order statuses, and some stores add custom ones for couriers, such as “returned to sender” or “delivery failed”. Under Settings, Order Status Mapping lists every raw status found in your synced orders with how many orders carry it, and lets you map each one to one of seven statuses: Pending, Processing, On Hold, Completed, Cancelled, Refunded or Partially Refunded. Discover refreshes the list, and saving applies the mapping to all existing orders and to future syncs.
If refused deliveries are mapped to Processing or Completed, they count as sales and the cancellation rate looks better than it is. Map them to Cancelled. The Cancellations report counts orders with the Cancelled status, and shows refunds separately as Refund Rate.
Then check Net Sale Definition on the same page. It sets which statuses count as a sale; the default is Completed and Processing. On a cash-on-delivery store a Processing order has not been paid yet, so some stores count only Completed. Whichever you choose, keep it, so the figures you noted in past reviews still match what the reports show.
What the Cancellations report shows
Cancellations shows Total Orders, Cancelled, Cancellation Rate, Refund Rate and Lost Revenue, the value of cancelled orders, for the selected dates, with Cancellation Rate Over Time underneath. Highest Cancellation Rate by City ranks cities with at least 2 cancellations by rate. Cancellation by Product shows cancelled orders, Units Lost and Lost Revenue for each product. WooCommerce stores using the Order Cancellation Reasons by ITX plugin can turn on Order Cancellation Reasons in Settings to see a breakdown by reason.
At Cedar Home, the city table shows Cairo with 30 cancellations from 300 orders (10%), Giza with 21 from 150 (14%) and Alexandria with 39 from 150 (26%). Alexandria has a quarter of the orders and 43% of the cancellations. City names come from the billing city customers type, so variants like “Alex” and “Alexandria” can appear as separate rows; add them together before you decide anything.
Two more views help. Orders has a Payment Analysis table with Success Rate % and Failure Rate % for each payment method, so you can compare cash on delivery with card. Geographic shows Fulfillment Time by Region, which is worth reading next to the cities that cancel most.
What to do with the numbers
The report shows where cancellations happen; the fix depends on why. For a city with a high rate, a confirmation call or WhatsApp message before dispatch costs less than a return trip, and gives the customer a chance to cancel before the courier leaves. For high-value orders, a small deposit is one option. For a product with a high cancellation rate, compare its photos, size guide and description with what actually arrives.
Change one thing at a time and give it a full month, so the next comparison tells you whether it worked.
A monthly cancellation check
Run it at the start of each month, for the month before.
- Settings, Order Status Mapping: click Discover and map any new raw status.
- Overview: compare the Cancelled/Refunded rate in Order Lifecycle with the month before, using Custom dates.
- Cancellations: note the five cities and five products with the highest rates.
- Orders, Payment Analysis: compare Failure Rate % for cash on delivery and for card.
- Choose one city or product, change one thing, and check it again next month.