Everything you need to get started: how to pull your weekly data from each marketplace, what this tool analyses, and a full glossary of every term and metric you'll see on the dashboard.
Open ⚙️ Advanced Settings on the dashboard to override these defaults per category or per platform. Blank category & platform = global default. Most-specific match wins.
Upload your weekly sales CSV and get an instant health check on every SKU you sell across online marketplaces.
Supports Amazon, Flipkart, Myntra, Meesho, Ajio, and Urban Ladder. One CSV upload covers all platforms.
| Term | Type | Meaning | Example |
|---|---|---|---|
| SKU | Input | Stock Keeping Unit — your unique product identifier. One SKU can sell across multiple platforms. | TSHIRT-RED-L |
| date | Input | Date of the sales row in your CSV. Must be within the last 7 days for weekly analysis. | 2024-04-15 |
| units_sold | Input | Number of units sold on that date for that SKU + platform combination. | 12 units |
| revenue | Input | Total revenue (₹) collected for those units on that day, after marketplace fees if applicable. | ₹2,400 |
| returns | Input | Number of units returned by buyers on that date for that SKU. | 2 units |
| inventory | Input | Units currently in stock at the end of that day. Used to detect stockouts and dead stock. | 85 units |
| price | Input | Selling price per unit (₹) on that date. Used to detect price erosion vs. COGS. | ₹200 |
| platform | Input | Marketplace name for that row. Accepted values: Amazon, Flipkart, Myntra, Meesho, Ajio, UrbanLadder. | Amazon |
| category | Input | Product category. Used for grouping in reports. Free text — use consistent naming. | Apparel |
| cogs | Input | Cost of Goods Sold per unit (₹). Optional column — used for P&L and price erosion detection. Rows with cogs = 0 are excluded from the COGS average. | ₹120 |
| EMA Velocity | Metric | Exponential Moving Average of daily units sold, weighted toward recent days. More responsive than a simple average — a sudden sales drop shows up quickly. | 2.3units/day |
| Avg Sales | Metric | Simple 7-day average of daily units sold. Used alongside EMA to confirm trend direction. | 2.1units/day |
| Return Rate | Metric | Returns ÷ Units Sold, expressed as a percentage. Triggers the high-returns risk rule when it exceeds the configured threshold (default 15%). | 16%8 returns / 50 sold |
| Weeks of Stock | Metric | Current inventory ÷ weekly sales velocity. A very high number (e.g. 20+ weeks) signals potential dead stock. | 18weeks of stock |
| Health Score | Metric | A 0–100 composite score combining sales velocity, return rate, stockout risk, and price margin. Higher is healthier. Drives the AT_RISK / WATCH / HEALTHY status. |
WATCH
68/100
|
| Net Loss | Metric | Total estimated ₹ loss for a SKU = deadstock loss + stockout loss + return loss. Dead stock and stockout losses are mutually exclusive per SKU. |
₹4,800
net loss this week
|
| Deadstock Loss | Risk | Estimated capital tied up in unsellable inventory. Calculated as inventory × COGS when the SKU has near-zero velocity. |
₹24,000
200 units × ₹120
|
| Stockout Loss | Risk | Estimated revenue missed because inventory hit zero. Calculated as days-out-of-stock × EMA velocity × price. |
₹3,000
3 days × 5u × ₹200
|
| P&L | Metric | Profit & Loss per SKU = Revenue − (COGS × units_sold) − Return Loss. Positive = profit, negative = loss. |
₹720
₹2,400 − ₹1,440 − ₹240
|
| Impact ₹ | Metric | The estimated ₹ value of taking the recommended action vs. doing nothing. Actions are ranked by this figure, highest first (top 10 shown). | ₹8,500if restocked today |
| COGS per Unit | Metric | Average cost per unit, computed only from rows where cogs > 0 (COGS dilution guard). Rows with cogs = 0 are excluded so free/sample rows don't distort the average. | ₹135avg · 5 rows |
| AT_RISK | Status | Health Score below 40. SKU has one or more active risk rules triggered. Needs urgent action. |
AT RISK
28/100
dead stock
|
| WATCH | Status | Health Score 40–70. Early warning signs present. Monitor closely and plan action within 1–2 weeks. |
WATCH
55/100
return rate rising
|
| HEALTHY | Status | Health Score above 70. No active risk rules. SKU is performing within normal parameters. |
HEALTHY
84/100
all clear
|
| Dead Stock | Rule | SKU with very low EMA velocity (below threshold, default 0.5 units/day) and significant inventory on hand. Capital is tied up with no near-term sales prospect. |
📦 Slow-moving stock
0.1 u/day · 300 in stock
|
| Stockout | Rule | Inventory at or near zero while demand (EMA velocity) is positive. Revenue is being lost every day this continues. |
🚫 Out of stock
0 units left · 4.2 u/day demand
|
| High Returns | Rule | Return rate exceeds the configured threshold (default 15%). Indicates quality, sizing, or listing issues. |
🔄 Too many returns
22% return rate
|
| Price Erosion | Rule | Selling price has fallen below COGS per unit — every sale made at a loss. Requires immediate pricing correction. |
Price Erosion
₹180 price < ₹200 COGS
|
| Demand Spike | Rule | EMA velocity has jumped significantly above its recent average — a sales surge is underway. Flag to restock before hitting a stockout. |
📈 Demand spike
2 → 9 u/day in 3 days
|