E-commerce returns: how to analyze products that sell well but reduce profit?
A product can be a bestseller and a financial problem at the same time. If returns are high, it creates support, logistics, discounting and resale costs.
Why returns change the sales picture
Sales reports often show orders and revenue at purchase time. Returns arrive later, so product performance is easy to overestimate. A product that looks strong in gross sales may be much weaker after returns.
A return is not only reversed revenue. It also means shipping, customer service, inspection, restocking, markdowns, damage and frozen inventory.
Return data worth collecting
| Data | What it shows | How it helps |
|---|---|---|
| Units sold | Gross sales scale. | Starting point for return share. |
| Returned units | Scale of the problem. | Shows products that need analysis. |
| Return reason | Why customers send it back. | Points to size, description, image, quality or expectation problems. |
| Shipping and handling cost | Logistics cost of the return. | Makes margin after returns realistic. |
| Condition after return | Whether it can be sold as new. | Shows markdown or loss cost. |
| Sales channel | Where the customer came from. | Some channels may create more returns. |
| Variant | Which size, color or model returns. | Finds problems in specific variants. |
Return metrics
- Return rate: returned units divided by units sold.
- Net sales: sales after subtracting returns.
- Margin after returns: margin after reversed revenue and handling costs.
- Return cost per unit: logistics, support, inspection, repackaging and markdown.
- Returns by reason: size, quality, description, image, damage or delayed delivery.
- Returns by channel: organic, ads, marketplace, newsletter or social commerce.
When is a bestseller risky?
| Signal | What it can mean | Decision |
|---|---|---|
| High sales and high return rate | The product promises more than it delivers. | Check images, copy, sizing and expectations. |
| High margin before returns, low after returns | Handling costs consume the result. | Limit promotion or change conditions. |
| Returns concentrated in one variant | Size, color, quality or variant description issue. | Fix or reduce exposure for that variant. |
| Returns from one channel | Traffic intent or ad message may be wrong. | Change creatives, targeting or landing page. |
| Product comes back damaged | Quality, packaging or carrier issue. | Check supplier, packaging and delivery process. |
How to reduce returns without reducing sales
The goal is not always to minimize returns at any cost. A restrictive policy can reduce trust. The goal is to reduce avoidable returns caused by unclear copy, weak images, missing size guidance or poorly matched campaigns.
- Add images showing scale, details and realistic color.
- Describe dimensions, material, use cases and limitations.
- Show size charts and fit guidance.
- Analyze return reasons separately by variant.
- Do not promote high-return products aggressively before fixing the cause.
- Compare returns by channel because the issue may be the ad, not the product.
Net cost of a return
A return should be counted as more than reversed revenue. Depending on the vertical and store policy, return cost can include outbound shipping, return label, support work, quality inspection, repackaging, cleaning, markdown, product value loss and frozen inventory.
| Cost component | Why it matters | How to measure it |
|---|---|---|
| Logistics | A return creates extra parcel movement. | Label, carrier, pickup and warehouse handling cost. |
| Customer support | Every return uses team time. | Average handling time times hourly labor cost. |
| Markdown | Returned products are not always resold as new. | Difference between regular price and resale price. |
| Lost availability | The product is temporarily unavailable for sale. | Days outside sellable inventory. |
| Damage risk | Not every return can be resold. | Share of returns moved to outlet or loss. |
Return reasons as an action map
A return reason should lead to a specific improvement. Size-related returns require different action than quality issues or products not matching images.
| Return reason | Possible cause | Action |
|---|---|---|
| Size does not fit | Weak size chart or unusual fit. | Add measurements, fit guidance and review signals. |
| Looks different than images | Images misrepresent color, scale or material. | Add natural-light photos, details and in-scale images. |
| Low quality | Supplier issue or expectation mismatch. | Check batch, copy, quality control and reviews. |
| Late delivery | Delivery promise does not match reality. | Improve delivery messaging and monitor carrier performance. |
| Multiple variants bought to try | Buy-to-try behavior, common in fashion and footwear. | Improve size advice, comparison images and fit descriptions. |
Returns and marketing budget
If campaigns optimize only toward purchase, they can promote products or audiences that frequently return orders. ROAS can look good in the ad platform while net profit is weak. At least monthly, connect returns with channel or campaign data.
- Compare return rate between campaigns and traffic sources.
- Calculate net ROAS after returns, not only purchase revenue.
- Check whether aggressive discounts increase poorly matched purchases.
- Exclude high-return products from prospecting until the cause is fixed.
- Separate acquisition channels from returning customer channels.
How to include returns in product ranking
If two products have similar sales and margin, but one has a much higher return rate, they should not be treated equally. Ranking should include net sales, margin after returns and customer experience stability.
A high-return product can be ranked lower until the team improves descriptions, variants, images or quality. This protects profit and reduces operational workload.
CSV data for returns analysis
The best file includes SKU, name, category, variant, units sold, returned units, revenue, cost, return reason, sales channel and return date. If you do not have everything, start with return rate and margin after returns by SKU.
Do not judge products only by gross sales
Upload a CSV file to Insighteo App and compare products by sales, profit, conversion and signals that help detect risky bestsellers.
Create an account and upload CSV