Product Profitability Analysis: How to Find Your Most (and Least) Profitable Products
Why Product-Level Profit Analysis Is the Most Important Thing You Can Do
Most ecommerce store owners look at their product catalog and see: best sellers, worst sellers. But that's the wrong lens. What you should see is: most profitable, least profitable.
Your top-selling product might be losing money on every sale. Your slowest product might be your highest-margin item. Without product-level profit analysis, you're flying blind.
The Product Profitability Formula
For each product, calculate:
Product Profit = Selling Price - COGS - (Ad Spend / Units Sold) - Transaction Fee - Shipping Cost
Let's analyze a real product catalog:
| Product | Price | COGS | Ad Cost/Unit | Fees | Shipping | Profit/Unit | Margin |
|---|---|---|---|---|---|---|---|
| T-Shirt | €29 | €8 | €6 | €0.87 | €4 | €10.13 | 34.9% |
| Hoodie | €59 | €22 | €12 | €1.77 | €6 | €17.23 | 29.2% |
| Phone Case | €19 | €3 | €9 | €0.57 | €3 | €3.43 | 18.1% |
| Mug | €15 | €4 | €8 | €0.45 | €5 | -€2.45 | -16.3% |
The mug is losing money on every sale. But if you only looked at revenue, you'd see it selling well and think everything is fine.
The 4 Product Categories
After analyzing profitability, every product falls into one of four categories:
Stars (High Profit, High Volume)
Your best products. Increase ad spend, create variants, and protect margins.
Cash Cows (High Profit, Low Volume)
Hidden gems. These products are profitable but undersold. Test more marketing to increase volume.
Question Marks (Low Profit, High Volume)
Popular but barely profitable. Raise prices, reduce ad spend, or find cheaper suppliers.
Dogs (Low Profit, Low Volume)
Cut these. They're taking up catalog space and ad budget that could go to better products.
How to Optimize Your Product Mix
- Kill the dogs — Remove or stop advertising products that lose money
- Fix the question marks — Raise prices by 10-15% or cut ad spend
- Grow the cash cows — Test new ad creatives and audiences
- Protect the stars — Monitor margins closely, don't discount them
Automate This With ProfitBoard
Doing this analysis manually in spreadsheets works — but it's slow and error-prone. ProfitBoard automatically calculates profit per product and highlights your most and least profitable items. You see your stars and dogs in seconds, not hours.
Use ProfitBoard to Track Your Real Profit Automatically
Stop guessing. ProfitBoard shows you exactly where your money goes — in 60 seconds.