Retail & E-commerce

Which products actually make money, and which quietly lose it.

Revenue is easy to see; profit and dead stock are where the money hides. Dashlytics reads your sales the way a retail analyst would and tells you what to stock more of, what to discount, and what's tying up cash.

What your analyst looks at first

Profit and margin by product (once cost is added)
Dead and slow-moving stock trapping capital
Repeat-purchase rate and average order value
Revenue concentration across your top SKUs
34.5%
Gross margin, computed per SKU
example, computed from your data

What a generic dashboard tool misses in retail & e-commerce

A generic chart tool will happily rank your products by revenue, and that chart is actively misleading in retail. The bestseller list and the profit list are rarely the same, because a high-turnover line sold at a thin margin can earn less than a slow line sold at a fat one. Discounting makes it worse: the products that move fastest are often the ones that move because they are discounted. Until cost sits next to revenue, every ranking on the screen is a popularity contest rather than a profit statement.

The columns this needs from your file

You do not need all of these to start. The first three build a working dashboard; each one after that unlocks a specific analysis.

  • Order or invoice date
  • Product name or SKU
  • Quantity sold
  • Unit price or line total
  • Cost per unit (unlocks margin and dead stock)
  • Stock on hand (unlocks dead stock value)

Messy headers, several sheets in one workbook and mixed date formats are handled on upload, because real exports look like that. Every figure is computed from your rows and reconciles against the source file, and a Data Readiness score tells you how far to trust the result before you act on it.

Frequently asked questions

How do I find which products are actually profitable?

Add a cost column to your product list and upload it alongside your sales export. Margin is computed per product as revenue minus cost over revenue, then ranked, so the products earning the most and least are visible immediately. Without cost data, no tool can tell you this, and any that appears to is guessing.

What is dead stock and how is it valued?

Dead stock is inventory that has stopped selling. Counting units is not the useful part; multiplying those units by what you paid for them is, because that product is the cash you cannot spend. We compute sales velocity per product, flag the lines that have gone quiet, and value what they are holding.

What columns does a retail dashboard need?

A date, a product name and a quantity or amount are enough to build sales, product and customer views. Adding cost per unit unlocks margin and dead-stock value. Adding stock on hand sharpens the dead-stock figure. Messy headers and multiple sheets are handled on upload.

Add a cost column to unlock true profit, margin, and which bestsellers are quietly losing money.

Try it on your data →See a live demo
← All industries