What this guide covers
- ✓Why your overall return rate hides the real problem
- ✓How to segment returns by SKU, reason code, and customer segment
- ✓The "80/20 of returns" — how a few products drive most of the cost
- ✓How to use return reason data to fix product descriptions
- ✓A simple return rate dashboard you can build in 2 hours
Your overall return rate is the wrong number to watch
A 21% return rate sounds like a business-wide problem. In practice, it almost never is. In an ecommerce brand we audited ($2.4M annual revenue), the overall return rate was 21%. But when we broke it down by SKU, three product listings accounted for 60% of all returns. Every other product had a combined return rate under 9%.
The fix wasn't improving every product. It was fixing three product descriptions and adding a sizing guide to one listing. The overall return rate fell to 13% in 90 days — recovering $34,000 in annual shipping and restocking costs that had been classified as "cost of returns."
The 3 segmentations that reveal the real problem
Return rate by SKU
Export all returns for the last 6 months with SKU/variant attached. Calculate return rate per SKU (returns ÷ units sold). A SKU with a 40%+ return rate is an urgent problem. Most Shopify stores can export this directly from the Analytics or Orders section.
Return rate by reason code
If your returns portal collects reason codes ("wrong size," "not as described," "defective," etc.), group returns by code per SKU. "Not as described" is a product description problem you can fix immediately. "Wrong size" usually means your size chart is missing, wrong, or hard to find.
Return rate by customer segment
Group customers by number of orders (1-time buyers vs. repeat buyers). In most stores, 1-time buyers return at 2–3x the rate of repeat customers. This tells you whether your acquisition is attracting the wrong audience — or whether your onboarding is failing new customers.
Calculating the dollar cost of your return rate
Before prioritizing which SKUs to fix, calculate the actual cost — not just the return volume. For each high-return SKU, estimate: (return rate × units sold × average order value × 0.6). The 0.6 factor accounts for the combined cost of return shipping, restocking, potential markdown, and lost revenue from the original sale. This gives you a rough annual dollar impact per SKU.
Sort your SKUs by this number. The top 3–5 almost always account for more than half your total return cost. Fix those first.
The product description audit
For every high-return SKU where the primary reason code is "not as described" or "didn't match expectations," do this: read the product description as if you had never seen the product before. Then look at what customers actually received. Identify every gap between the two.
Common gaps: color descriptions that don't match photography, fabric feel not mentioned, dimensions missing or buried, fit described vaguely ("relaxed") when customers expect precise measurements. Fixing these rarely requires a product change — just better copy and more accurate photos.
Want us to find your return rate problem SKUs?
Our Data Clarity Audit includes a full return rate analysis by SKU, reason code, and customer segment — using your existing Shopify or platform exports. Flat fee, results in 10 days.
Book a Free Discovery Call