How a Pune-based ethnic wear seller finally got control of his business — not through luck, but through data.
28 years old • Pune, Maharashtra • Online Seller since 2023
It was a Tuesday night in January 2026. Shubhan had just finished reconciling his Amazon and Flipkart payouts — something that took him 4 hours every week on a sprawling Excel sheet. His business was doing ₹8+ lakh a month. On paper, everything looked fine.
Then his wife, Priya, looked over his shoulder and asked: "Itna bechte ho tum — toh paisa kahan jaata hai?"
(You sell so much — where does all the money go?)
Shubhan opened his mouth to answer. And closed it. He didn't know. Not really.
Summer ethnic kurtas ordered in March still sitting in a Flipkart warehouse in December. Every day = storage fee + capital locked. Amazon showed "inventory" but never said "this is rotting."
One sherwani SKU had a 44% return rate. Shubhan was ordering more of it every month thinking it was selling well — because units shipped looked high. Nobody told him half came back.
His top-performing kurta ran out of stock 3 times in 6 months. Each stockout meant rankings dropped, ads wasted money, and competitors ate his sales. Zero warning, zero system.
Amazon gives you ASINs. Flipkart gives you FSN codes. Different date formats, different report structures. Combining them for one unified view? That's a part-time job by itself.
Wedding season, Diwali, Akshaya Tritiya — Shubhan knew they were coming but had no idea which SKUs would spike. He either over-ordered the wrong thing or under-stocked the right one.
By the time Amazon's business reports showed a trend, 2 weeks had already passed. Ordering decisions made on stale data meant chasing yesterday's numbers with today's money.
"Someone in our Amazon Sellers India group shared a tool. I almost scrolled past it. I'm glad I didn't."
Rahul Sharma: Yaar try karo ye tool — Seller Loss Minimizer. Mera ₹1.8L dead stock identify hua ek hi upload mein. No login, no subscription. Bas CSV upload karo.
(Hey, try this tool — Seller Loss Minimizer. It identified ₹1.8L of my dead stock in a single upload. No login, no subscription. Just upload the CSV and go.)
Shubhan had tried two other seller analytics tools before. One required a ₹4,000/month subscription. Another had a dashboard so complex he gave up after 20 minutes. When he saw the Seller Loss Minimizer link in his WhatsApp group, his reaction was skeptical. "Phir wahi bakwaas hogi." (Same nonsense again.)
But it was free. And it was a Sunday afternoon with nothing else to do. So he exported his last 4 weeks of Amazon and Flipkart data, cleaned up the columns, and hit Upload & Analyze.
The analysis took 3 seconds. What it showed him changed everything.
(In one week, ₹2.34 lakh in losses?)
The first upload was 4 weeks of data — 47 SKUs, 658 rows. The SLM analysis flagged 12 SKUs as AT_RISK and 9 as WATCH. Total predicted weekly loss: ₹2,34,500. Shubhan stared at the screen for a full minute. He refreshed the page. Same number.
The tool showed him exactly what was wrong and why — dead stock sitting unsold, a sherwani with a 44% return rate he'd been blindly restocking, and 3 bestsellers about to hit zero inventory. In one table. For free.
| SKU | Risk | Issue Detected | Inventory | Avg Sales/day | Est. Weekly Loss |
|---|---|---|---|---|---|
| ETH-SHWN-RED-XL | AT RISK | Dead Stock (156 units, 0.1 avg sales) | 156 | 0.1 | ₹21,060 |
| KRT-INDO-BLU-M | AT RISK | Return Rate 44% (HIGH) | 34 | 6.2 | ₹18,240 |
| KRT-CASU-WHT-L | AT RISK | Stock Out (0 inventory, 8.4 avg sales) | 0 | 8.4 | ₹58,800 |
| KRT-FEST-GRN-XL | AT RISK | Low Inventory (3 units, 4.1 avg sales) | 3 | 4.1 | ₹16,380 |
| ETH-SHWN-BLK-M | WATCH | Seasonal Spike (recentAvg 2.3× overall) | 22 | 3.8 | ₹9,100 |
| KRT-SILK-NAV-M | HEALTHY | No issues detected | 89 | 5.1 | ₹0 |
SLM identified 6 dead stock SKUs — slow-moving items with inventory piling up. Shubhan's instinct was to hold. His new instinct, guided by the numbers, was to move.
He ran a 30% clearance sale across all 6 dead stock SKUs on both platforms. He listed them in combo bundles on Flipkart. He created a "Last Chance" storefront on Amazon. In 7 days — 89 units moved. ₹89,300 in cash recovered that would have otherwise depreciated further.
The indo-western kurta (KRT-INDO-BLU-M) had a 44% return rate. Customers were ordering, receiving — and sending it back. SLM didn't just flag the risk, it told Shubhan the magnitude: ₹18,240/week in return losses.
He dug into the returns feedback: "Size runs large," "colour different from photo," "fabric not as shown." Classic listing problems. He rewrote the description, added a proper size chart with chest measurements, updated photos with real model shots, and added a "size up recommended" note.
Two weeks later when he re-uploaded data: return rate dropped from 44% → 18%. Revenue on that SKU actually went up because fewer returns meant more net sales counted.
SLM's stockout and low-inventory alerts were the clearest money Shubhan had ever seen. Three SKUs — all with strong average sales — were either at zero or dangerously low. He had been buying based on gut feel. Now he had a signal.
He placed emergency restocking orders for all three within 24 hours of the SLM analysis. KRT-CASU-WHT-L — his casual kurta — had been at zero inventory for 11 days. The moment it was back in stock, it sold 84 units in the next 7 days alone.
| SKU | Issue | Action Taken | Units Sold (Next 7d) | Revenue Captured |
|---|---|---|---|---|
| KRT-CASU-WHT-L | Stock Out | Emergency restock 200 units | 84 | ₹83,160 |
| KRT-FEST-GRN-XL | Low Inventory (3 units) | Restocked 150 units | 61 | ₹54,900 |
| KRT-SILK-NAV-M | Projected stockout in 4 days | Pre-emptive restock 100 units | 48 | ₹43,200 |
In Week 5, SLM's Seasonal Spike rule fired for 4 wedding sherwani SKUs. Their recent 2-week average was 2.3× their overall average — a clear leading indicator of a demand surge. Shubhan had seen this before in previous years but always reacted too late, running out of stock mid-season.
This time, he had the signal 10 days before Akshaya Tritiya. He doubled his order for all 4 wedding SKUs and ran targeted Sponsored Product ads. The result: ₹1.84 lakh in sherwani revenue in one week — his single best week ever on that sub-category.
By week 6, Shubhan's weekly SLM upload had become a Sunday evening ritual — faster than brewing a cup of chai. Upload the CSV, read the analysis, take action on anything flagged. 30 minutes of clarity for the entire week ahead.
The results were not magic. They were math, consistently applied. 47 SKUs under control. The full formula set behind these numbers — dead stock detection, return-loss attribution, BE-ACOS — is published as a peer-reviewable preprint: Quantifying Seller-Side Revenue Leakage on Indian E-Commerce Marketplaces (Zenodo, CC-BY-4.0). Dead stock cleared. Return rates down. Best sellers always in stock. Seasonal spikes captured in advance.
"Pehle lagta tha business chal raha hai. Ab pata hai ki business grow kar raha hai. SLM ne woh dikhaya jo Amazon aur Flipkart ke dashboards kabhi nahi dikhate — exactly kahan paise ja rahe hain. Pehle mahine mein hi ₹2 lakh ka farak pad gaya."
(Translation: "Earlier it felt like the business was running. Now I know it's growing. SLM showed what Amazon and Flipkart dashboards never do — exactly where the money is going. The difference showed up in the very first month.")
Your Amazon dashboard shows you one SKU at a time. Your Flipkart report is in a different file. If you're not combining them weekly into one view, you're flying blind on 80% of your business.
Dead stock doesn't announce itself. High return rates are invisible without math. SLM surfaces the signal. All you have to do is act — quickly, decisively, before the loss compounds.
One upload showed Shubhan the problem. Six weeks of uploads gave him full control. Data is not a one-time event. The sellers who win are the ones who look at their numbers every week, not every quarter.
His story isn't unique. Thousands of online sellers are sitting on recoverable losses right now — they just can't see them yet. Your first upload takes 60 seconds. The analysis is instant. The clarity is yours, free.
📈 Analyze My SKUs — It's FreeNo signup. No subscription. Upload your CSV and go.