Upload order data with costs, find your most and least profitable products. Free.
or click to browse · max 3 MB
Running product profitability calculator analysis...
Sent to — interactive charts, statistical results, R code, and AI insights.
Analyze another fileCalculates profit and margin for each product using revenue and cost data. Finds your most profitable products, loss leaders, and Pareto concentration — what percentage of products drive what percentage of profit.
Use this when you have order data with revenue and cost (or profit) per product and want to know which products actually make money.
If you don't have cost data, this won't work — use AOV Analysis for revenue-only insights. If you need pricing optimization, use Price Elasticity.
Built for: E-commerce manager, merchandiser, product manager, CFO
Typical data source: Order-level data with product names, revenue, cost or profit, and optionally categories
Order data with product-level revenue and profit
Minimum 50 rows · Best with 500-10000 orders
Calculate product-level P&L with margin analysis, Pareto concentration, loss leader detection, and trend tracking to identify which products are actually profitable
Your most profitable products ranked by total profit contribution. High revenue doesn't mean high profit — check the margin column.
Products that lose money. Some are intentional (drive traffic) but others are pricing mistakes. If a loss leader isn't driving profitable cross-sells, fix the price.
The 80/20 curve. Typically 20% of products generate 80% of profit. If it's more concentrated (10/90), you're over-dependent on a few SKUs.
How margins are spread across products. A bimodal distribution (peaks at high and low margins) suggests two distinct product tiers.
Profit by product category. Identifies which categories are profit engines vs cost centers.
Profitability at sub-category level
Profit over time. Declining trends in a category may signal rising costs or pricing pressure.
Complete product-level profit and loss statement
Plain-English interpretation — what the numbers mean, what's significant, and what to do next.
Need something simpler? Aov Analysis — No cost data — just revenue and order analysis
Need more power? Price Elasticity — Want to optimize pricing based on demand elasticity
Similar: Promotional Analysis
See our FAQ for details on pricing, data privacy, and how the analysis works. Every report includes a Methodology section showing the statistical test, assumptions checked, and diagnostics run.
Run any analysis on your own data — 60+ validated R modules, interactive reports, AI insights, and PDF export.
Try Free — No Credit Card