๐ Product Margin Comparison Tracker
Add each of your products with its cost and selling price to compare profit margin and markup percentage across your whole lineup at a glance.
Three numbers per row
Each product is scored on its own cost and price, then the table is sorted by margin, highest first:
profit = price - cost
margin = profit / price × 100
markup = profit / cost × 100
The two starting rows show why both percentages are printed:
| Product | Cost | Price | Profit | Margin | Markup |
|---|---|---|---|---|---|
| A | $10 | $25 | $15 | 60.0% | 150.0% |
| B | $20 | $30 | $10 | 33.3% | 50.0% |
Same profit column, wildly different percentages: markup divides by cost, margin by price, so markup is always the larger number.
Reading the ranking without being fooled
- Rank order is not profit order. A leads on margin, but if B sells 100 units a month against A's 20, B brings in $1,000 of gross profit and A $300. Multiply each row's profit by realistic monthly volume before you act on the sort.
- Keep the cost basis identical across rows. If one product's cost includes inbound freight and another's does not, the comparison is measuring your bookkeeping rather than your products.
- Nothing here is deducted after the sale. Platform fees, discount codes, breakage and returns all come out of that profit column.
- A row with a cost of $0 reports 0.0% markup rather than an infinite one, so donated or free stock reads oddly.
Frequently asked questions
What is a good profit margin on a product?
It depends on the trade. Grocery and electronics resale run on thin single-digit margins and survive on volume, while handmade goods and services often need 50% or more to cover slow production. Compare against your own category, not a headline figure.
Should I drop the lowest-margin product?
Not on percentage alone. A low-margin line that sells constantly can pay more of the rent than a high-margin one that moves twice a month, and it may be what brings people in. Check profit per month and per hour of work first.
Why does the results list reorder as I type?
The summary card re-sorts by margin on every keystroke, so the best-margin product holds the top line. The input rows above it stay in the order you entered them.