Inventory dashboard template for E-commerce
A inventory dashboard tailored for a online store. What is about to stock out, and what capital is trapped in dead stock? Upload your own CSV or Google Sheet and it charts stock on hand by sku, days of cover, dead-stock value automatically — free, no signup.
KPIs this dashboard tracks
the base for every reorder decision
translates stock into time-until-stockout
capital sitting on shelves that could be cash
turns a spreadsheet into an action list
the biggest recoverable revenue leak in online retail
normalizes sales against traffic swings
Charts it builds
- Stock vs reorder point — bar of
on_handbysku - Inventory value over time — line of
valuebydate
Columns your data needs
Map your spreadsheet to these (messy headers are matched automatically):
skuproducton_handreorder_pointunit_costlast_solddiscount_code
Benchmark
Typical e-commerce conversion sits at 2-3%; average return rates run 15-30% for apparel.
What to look for
For a e-commerce inventory view, the metrics that move decisions are stock on hand by sku and days of cover. Typical e-commerce conversion sits at 2-3%; average return rates run 15-30% for apparel.
FAQ
At minimum: sku, product, on_hand, reorder_point, unit_cost, last_sold, discount_code. Dashboard AI maps messy real-world headers to these automatically.
Stock on hand by SKU (the base for every reorder decision); Days of cover (translates stock into time-until-stockout); Dead-stock value (capital sitting on shelves that could be cash); Reorder alerts (turns a spreadsheet into an action list).
Typical e-commerce conversion sits at 2-3%; average return rates run 15-30% for apparel.
Paste a few rows of CSV (with a header row). Runs entirely in your browser — nothing is uploaded.