How to Track Profit Per Product in Shopify

Why Product-Level Profit Tracking Is the Most Important Thing You Can Do

Most Shopify store owners look at their product catalog and see two categories: best sellers and worst sellers. But that's the wrong way to look at it. What you should see is: most profitable and least profitable.

Your top-selling product might be losing money on every single sale. Your slowest-moving product might be your highest-margin item. Without product-level profit tracking, you're making decisions based on incomplete data.

What Is Profit Per Product?

Profit per product is the actual money you keep after subtracting every cost associated with selling that specific product:

Product Profit = Selling Price - COGS - (Ad Spend ÷ Units Sold) - Transaction Fee - Shipping Cost

The key insight is that ad spend must be allocated per product. If you're spending €500/month on Facebook Ads promoting a specific product and selling 100 units, your ad cost per unit is €5 — and that comes straight off your margin.

Real Example: Analyzing a Product Catalog

Let's look at a typical Shopify store with four products:

Product	Price	COGS	Ad Cost/Unit	Fees	Shipping	Profit/Unit	Margin
Organic T-Shirt	€29	€8	€6	€0.87	€4	€10.13	34.9%
Premium Hoodie	€59	€22	€12	€1.77	€6	€17.23	29.2%
Phone Case	€19	€3	€9	€0.57	€3	€3.43	18.1%
Ceramic Mug	€15	€4	€8	€0.45	€5	-€2.45	-16.3%

The Ceramic Mug is losing €2.45 on every single sale. The more mugs you sell, the more money you lose. But if you only looked at revenue, you'd see it selling well and think everything is fine.

The 4 Product Categories

After calculating profit per product, every item in your catalog falls into one of four categories:

Stars — High Profit, High Volume

These are your best products. They make good money and sell well. Strategy: increase ad spend, create color/size variants, protect margins at all costs. The Organic T-Shirt in our example is a Star.

Cash Cows — High Profit, Low Volume

Hidden gems that are profitable but undersold. Strategy: test new ad creatives, try different audiences, create bundles with these products. The Premium Hoodie is a Cash Cow.

Question Marks — Low Profit, High Volume

Popular but barely profitable. Strategy: raise prices by 10-15%, reduce ad spend, find cheaper suppliers, or improve packaging efficiency. The Phone Case is a Question Mark.

Dogs — Low Profit, Low Volume (or Negative Profit)

These products are actively hurting your business. Strategy: stop advertising immediately, consider removing from catalog, or dramatically increase price. The Ceramic Mug is a Dog.

Why Shopify Doesn't Show You This

Shopify's built-in analytics shows you revenue per product, units sold, and conversion rate. But it has no concept of:

• Product-level COGS
• Ad spend allocated per product
• True profit per unit after all costs

This means Shopify will happily show you that your Ceramic Mug is a "top seller" while it's actually draining your bank account with every sale.

How to Calculate Profit Per Product Manually

If you want to do this in a spreadsheet, here's the process:

1. List every product with its selling price
2. Add true COGS — include packaging, handling, not just wholesale cost
3. Allocate ad spend — divide each campaign's spend by the products it promotes
4. Add transaction fees — typically 2.9% + €0.30 per transaction
5. Add shipping cost — your actual cost per shipment for each product
6. Calculate — Price minus all costs equals profit per unit

This works, but it's tedious and error-prone. Every time you change ad spend or costs, you need to recalculate everything.

How to Optimize Your Product Mix

Once you know profit per product, the optimization strategy is clear:

1. Kill the Dogs — Stop advertising products that lose money. Remove them or raise prices dramatically.
2. Fix the Question Marks — Raise prices by 10-15% or cut ad spend. Test whether volume drops enough to offset the margin improvement.
3. Grow the Cash Cows — Test new marketing channels and ad creatives for high-margin products that aren't selling enough.
4. Protect the Stars — Monitor margins closely. Don't discount these products. Increase ad spend carefully while watching profit per unit.

Automate Product Profit Tracking With ProfitBoard

Doing this analysis manually in spreadsheets works — but it's slow, error-prone, and you need to redo it every time costs change. ProfitBoard automatically calculates profit per product by combining your cost data with your sales data.

You see your Stars, Cash Cows, Question Marks, and Dogs in seconds — not hours. Enter your costs once, and ProfitBoard updates your product profitability in real time.

Use ProfitBoard to track your real profit per product automatically and stop losing money on products you thought were winners.