
When a customer cancels an unshipped order, confirm the affected quantity and its physical status before releasing the reservation. Remove only the cancelled units from the commitment. Do not add units to on-hand stock unless a real stock movement requires it.
A cancellation, a refund and a stock release are separate events. Your customer record may say cancelled while the warehouse still holds the items in a packing area. This workflow helps one owner reconcile those records. It provides on-page examples, not a downloadable spreadsheet or an automatic inventory update.
Use it with the main customer-order tracking guide. For units already dispatched, use a return process rather than treating them as an unshipped cancellation.
Identify exactly what was cancelled
Record the original order ID, line ID, SKU, cancelled quantity, request time, confirmation reference and responsible owner. Specify whether the whole order or only one line changed. Preserve the original ordered quantity and shipment history.
For a substitution, record the cancelled commitment and the newly agreed SKU separately. A different size or color is not interchangeable stock. If the request has not been confirmed, put the affected units on a review hold rather than treating the customer commitment as resolved.
Check the physical status before releasing units
| Where the units are | Review action | Stock treatment |
|---|---|---|
| On the shelf, reserved only | Confirm cancellation and remove the affected reservation | On-hand stays the same; available stock may increase |
| Picked or packed, still on site | Stop dispatch and inspect the units before returning them to the sellable area | Release only units confirmed usable; keep damaged units blocked |
| Already dispatched | Check the actual shipment and any return arrangement | No automatic increase in on-hand stock |
| Status unclear | Assign an owner to reconcile warehouse and dispatch records | Keep affected units excluded from sale during review |
If a carrier has already collected the parcel, changing the order status does not bring the goods back. Record any received return and inspection separately. A processed refund is also not evidence that the stock has been received.
Work the reservation example
Fictional SKU MUG-BL has 20 units physically on hand. Eight are reserved for confirmed orders, two are blocked and one is held as a separate buffer. Those excluded groups do not overlap.
Available before cancellation = 20 − 8 − 2 − 1 = 9 units
The customer cancels three unshipped, usable mugs that belong to the eight-unit reservation. After confirmation, reserved stock becomes five. On-hand remains 20 because no goods entered or left the business.
Available after release = 20 − 5 − 2 − 1 = 12 units
Adding three to on-hand as well would produce a false stock count. Releasing the reservation makes existing units available; it does not create new units.
Alternative outcome: one of the three cancelled mugs is found damaged. Remove all three from that order's reservation, but move the damaged unit into the blocked group. Reserved becomes five and blocked becomes three. Available is 20 − 5 − 3 − 1 = 11. On-hand still remains 20 until your records separately account for a physical disposal or other movement.
Keep a release record you can review later
| Field | Fictional example |
|---|---|
| Order / line / SKU | ORD-318 / L1 / MUG-BL |
| Agreed unshipped cancellation | 3 units |
| Confirmation reference | Customer message C-318, confirmed by order owner |
| Physical check | 3 on site; 2 usable, 1 damaged |
| Reservation change | Remove 3 from this order's reservation |
| Blocked-stock change | Add 1 damaged unit to blocked stock |
| Money follow-up | Review refund separately against payment reference |
| Owner and completion reference | Named operator; timestamp of reviewed update |
Copy these fields into your own record. Keep a completion reference so the same cancellation cannot release stock twice. For a partial cancellation, retain the reservation still required by the active order.
Prevent a repeated cancellation from releasing stock twice
Give each confirmed cancellation a stable reference, such as CAN-318, linked to its order and line. Before updating reservations, check whether that reference already has a completed release. A second message about the same cancellation is a follow-up, not another three units to release.
Record the affected quantity, reservation before and after, physical review, operator and completion time. In the damaged-mug example, the recorded change is reserved eight to five and blocked two to three. If another operator opens the same completed task, the current figures are already five and three: subtracting three again would incorrectly expose stock committed to other customers.
If the customer changes the cancellation quantity afterward, create a linked amendment with the old and new agreed quantities. Reconcile the current commitment before making another stock change. Do not silently replace the original confirmation or replay the full original release.
Review money separately from stock
Check what was collected, what change the customer agreed and what adjustment is due under the applicable order terms. Keep the original collection and any refund transaction as separate entries with their references. A refund requested, a refund submitted and a refund settled should not be represented as the same event.
Do not infer a refund amount from the stock quantity alone when discounts, delivery charges or other adjustments apply. This record is an operational handoff, not a replacement for your payment provider or accounting records.
Use the free stock review for the before-and-after check
Open the free Reserved vs Available Stock Planner and enter current on-hand, reserved, blocked and buffer units for the SKU. Calculate the current snapshot, then update the confirmed reservation and blocked quantities and calculate again.
The tool shows zero-floor available units and reports a shortfall separately. It requires non-overlapping excluded groups. It does not release a reservation in Shopify, Etsy or another system, and it does not retain an order-by-order cancellation ledger. Keep the release record alongside your main order log.
Save the worksheet on your device or export its JSON backup for later editing. CSV and PDF are reports, not restorable backups. The free worksheet does not import into the paid application.
Close the handoff between orders and stock
Have the order owner confirm the cancelled commitment, the stock owner confirm physical status and the payment owner review any money adjustment. In a one-person business, these are three checks performed by the same person. Close the task only when each applicable check has a recorded result.
The paid Sales Management System offers a broader offline order and stock workspace. Check its user guide and preview for the workflow you need. This manual stock-release example does not promise that a status change in the app automatically performs every cancellation, refund and reservation adjustment.
Common questions
Does cancelling an order always increase on-hand stock?
No. For reserved units that are still physically present, on-hand is unchanged. Available stock can increase when the reservation is removed. Already shipped goods need a separately verified return.
Should I release all reserved units for a partial cancellation?
No. Release the confirmed cancelled portion, and keep the remaining customer commitment reserved where appropriate.
What if only part of the order shipped?
Match the cancellation to the unshipped units. Use the partial-shipment ledger to preserve dispatched quantities and outstanding commitments.
Platform references
Shopify's inventory-state documentation distinguishes physical on-hand quantities from committed and available inventory. Adobe Commerce's order-status documentation describes reservation changes after cancellations. Platform behavior varies; the stock examples above are our own manual calculations. Reviewed October 11, 2026.
Resolve a remaining shortage after the cancellation
A confirmed cancellation can reduce commitments without removing every shortage. Suppose a different fictional SKU has 20 on hand, 22 reserved, one blocked and no separate buffer. Releasing two verified unshipped reservations leaves 20 reserved: raw availability is still minus one. The Reserved vs Available Stock Planner shows zero available and a one-unit shortfall.
Review outstanding orders and accepted receipts before buying more. If purchasing is justified, compare consistent offers in the Supplier Quote Comparison planner. Do not add an incoming order to on-hand just to remove the shortage on paper, or replay the cancellation to release another two units.