ReturnsIntel Guide
How to Find Which Shopify SKUs Cost You the Most in Returns
returnsintel.com/resources/how-to-find-skus-costing-most-in-returns
The highest return rate is not always the biggest problem
A SKU can have a high return rate and still create little financial exposure because it sells in low volume. Another SKU can have an ordinary rate but produce far more returned units and operational work because it is a bestseller.
Rank every SKU through three separate lenses:
- Observed exposure: attributable refunded merchandise value and any known shipping, label, or return fees.
- Returned-unit volume: the number of units that came back from the selected sale cohorts.
- Cohort return rate: returned units from the sale cohort divided by units sold in that same cohort.
Compare rate with sales volume
| SKU | Units sold | Cohort return rate | Returned units | Initial read |
|---|---|---|---|---|
| SKU A | 1,000 | 10% | 100 | Moderate rate, large operational and financial footprint |
| SKU B | 20 | 40% | 8 | Alarming rate, but a much smaller current footprint |
SKU B deserves investigation, especially if it is new or strategically important. SKU A may still be the first commercial priority because improving it by only a few percentage points could prevent more returned units.
Build an honest return-cost ladder
Start with observed values and add estimates only when their source is reliable. This keeps a useful prioritization model from pretending to be a perfect profit calculation.
- Level 1, merchandise exposure: attributable refunded merchandise value.
- Level 2, known return spend: add labels, carrier charges, platform fees, and other recorded costs.
- Level 3, handling estimate: add inspection, processing, and restocking labor only when the assumption is documented.
- Level 4, inventory loss: add non-restocked unit cost, markdown, or write-off only when reliable COGS and disposition data exist.
Keep observed and estimated columns separate. A merchant should be able to see which part came directly from records and which part came from an operating assumption.
Connect costly SKUs to repeated return reasons
A ranked list identifies where to look. Reasons, variants, and channels suggest what to change. Shopify exposes return reasons and product variant SKU at the time of sale, which makes more specific investigation possible when the underlying data is complete.
| Repeated signal | First investigation |
|---|---|
| Size or fit | Size chart, garment measurements, fit notes, and variant-specific patterns |
| Not as described | Product copy, specifications, photography, color representation, and expectation setting |
| Defect or quality | Supplier lot, production batch, component, packaging, and quality-control records |
| Wrong item or damaged | Picking accuracy, warehouse process, carrier handling, and packaging |
Generic reason lists can conceal the real cause. Where volume supports it, break a priority SKU down by size, color, category, channel, supplier, and fulfillment path.
Choose one SKU where impact, rate, and a repeated reason overlap
- Start with the SKUs creating the most observed exposure.
- Remove products whose high total is explained entirely by enormous sales volume and an ordinary rate, unless a small improvement would still be valuable.
- Look for a rate that is meaningfully above comparable products or the SKU's own earlier mature cohorts.
- Prefer a SKU with a concentrated, actionable reason over one with scattered or missing reasons.
- Record one change, an owner, and the affected sale date.
- Re-measure the next mature cohort rather than judging the newest sales too early.
Work through the Shopify Return Leakage Checklist before making the decision, or review the cohort return-rate formula if the monthly numbers are not yet trustworthy.
Further reading: Shopify's ecommerce returns management guide discusses shipping, inspection, handling, restocking, and return reasons by SKU and category.
Keep learning
Checklist
Return leakage checklist
Audit the data, calculate a cohort return rate, rank the right SKUs, and turn one finding into an investigation.
Guide
Calculate return rate by SKU
Use the original sale month, a consistent return window, and a clear rule for returns, refunds, and exchanges.
Guide
Why return rate looks wrong
A 150% result can be valid for returns processed versus sales made in one month, but it is not a sale-cohort return rate.
Find the SKUs driving your returns
ReturnsIntel attributes returned units to their original sale cohorts, separates rate from volume, and helps you investigate repeated reasons. Start with the Free plan.