It’s 11 p.m. and you’re a founder with 200 orders to ship by Friday. Your spreadsheet says you have 60 of the best-selling dress in stock, but the warehouse person just texted “only 12 left.” A customer emails demanding a refund for an item you were sure you sent. Welcome to the stage where spreadsheets quietly turn from helper to saboteur.
The crossover moment we see most
An online fashion boutique selling 150 SKUs across three marketplaces hit this wall. Returns were running at 18%, which is normal for fashion, but they were handling returns with the same spreadsheet they used for fresh stock. The result: items sat in a “returns” box for two weeks while the website kept selling them as available. That mismatch alone cost the boutique about $6,000 a month in cancelled orders and angry reviews.
Making returns a first-class process
ERP Consulting started by separating returned inventory visually in the workspace and in the system. Every return got a status: restockable, damaged, or refund-only.
- Restockable items are inspected and photographed within 24 hours, then made available online with the original photos
- Damaged items moved to a discount list automatically, instead of hiding in a drawer for weeks
- Refund-only items trigger the refund the same day, which stopped the “where is my money?” emails
Buying decisions improved too
Once returns were tracked accurately, the boutique could see which colours and sizes actually came back. That sounds niche, but it was gold. Their return rate on a certain floral dress was 31%, mostly because the fabric ran small. They changed the size chart, and returns on that item dropped to 12%. Good return data tells you what to fix before customers decide to stop buying.
Now the founder runs the whole business on a single screen: stock by location, orders in flight, and return status per item. The spreadsheet still exists, but only for planning next season’s styles, which is what it’s actually good for. If your marketplace order volume has grown 30% three years in a row, that’s a sign you outgrew the spreadsheet. ERP Consulting will tell you to make the switch in the off-season, not with 200 orders on your desk tomorrow morning.