Shopify profit calculator: a worked Shopify study

A unit, with the media plan written out

Say the product is a desk lamp. Put your supplier quote and your own ad account in place of every figure. This is not a result from a live store.

• Price. $79
• Product cost. $22
• Shipping you pay to deliver. $9
• Left before ads. $48 (72% gross, before delivery)
• Break-even ROAS. 1.65, which is price divided by what is left before ads

Ad cost per purchase is CPM ÷ (1,000 × click-through rate) ÷ conversion rate. CPM is the price of 1,000 impressions. At a $12 CPM, a 1.2% click-through rate, and a 2.0% conversion rate, the estimate is $50 per purchase. Those rates are placeholders, not a benchmark. Contribution before ads is $48, so this media plan loses $2 on the sale. If the ad account already has a cost per purchase, use that and ignore this estimate.

How to read it

The estimated ad cost is higher than the $48 left before ads, so this teaching plan loses $2 on the sale. You would not “optimize the creative” to rescue a plan whose arithmetic already fails. You would change the price, the delivered cost, or the assumption, then type your real cost per purchase into the profit calculator.

The same unit’s break-even return, ignoring the placeholder rates, is 1.65. That second number is the one to pin on a brief when you do not trust a click-through guess.

One notebook, invented so the subtraction can move

This is one invented notebook. It is not a catalog item, not a shop, and not a comment on stationery. Say the price typed for one unit is 24 dollars. Example product cost is 6 dollars. Example shipping you pay is 5 dollars. Example fee you choose to include is 80 cents. Example ad cost attached to this one unit is 7 dollars. Nothing else is in the stack. Hold the scope at one unit for the whole sheet.

The 7 dollars is not a daily budget and not a cost that any platform produced. It is a typed attachment so the subtraction has an ad line. Every later step changes one line and then puts it back before the next change. That rule is what keeps the notebook as one example instead of a pile of unrelated sums.

The base subtraction

Start at 24 dollars. Subtract product cost of 6, which leaves 18. Subtract shipping of 5, which leaves 13. Subtract the fee of 0.80, which leaves 12.20. Subtract the ad cost of 7, which leaves 5.20. Profit in the base example is 5.20 dollars. The intermediate 12.20 dollars is what remains before ads. It is not profit after ads, and it should not be reported as the calculator's result once the 7 dollars is included.

Add the costs in the other direction to check. 6 plus 5 is 11. 11 plus 0.80 is 11.80. 11.80 plus 7 is 18.80. Revenue 24 minus 18.80 is 5.20. Same dollars. If you type these lines, the screen should show 5.20 dollars of profit. A different screen result means a line was missed or doubled.

Add one allowance you choose to type

The base has no returns. Now type an example return allowance of 2 dollars on this same unit, as a cost you are choosing to include for the illustration. Profit becomes 5.20 minus 2, which is 3.20 dollars. The notebook did not become a worse product in the world. You added a line. Remove the 2 dollars before any other edit so the base returns to 5.20.

Notice that 2 dollars did not flip the sign. The remainder stayed positive and got thinner. A later real sheet might use a different allowance computed from real orders. This 2 dollar figure must not travel into that sheet. It exists to show that an extra cost you care about belongs inside the subtraction, not in a footnote nobody subtracts.

What the dollars are if the ad line is removed

Return to the base lines, then remove only the ad cost. Price 24, product 6, shipping 5, fee 0.80. The remainder is 12.20 dollars. Call that remainder contribution before ads in this example, not profit after advertising. If a note reports 12.20 as profit while ads are still being bought, the note is using a thinner stack than the operation.

Put the 7 dollars back. Profit is 5.20 again. The gap between 12.20 and 5.20 is exactly the ad attachment. When someone claims the notebook 'makes 12 dollars,' ask whether the ad line is in the sentence. In this example it is not, at 12.20. At 5.20 it is.

Change only shipping

With the base restored, change shipping from 5 dollars to 8 dollars. The extra 3 dollars comes straight out of profit. 5.20 minus 3 is 2.20. Walk it from the top if you want: 24 minus 6 minus 8 minus 0.80 minus 7 equals 2.20. The ad line is innocent in this particular swing. A conversation that starts with creative, for this swing only, is aimed at the wrong invoice.

Restore shipping to 5 dollars. Profit is 5.20 again. The point of the edit was sensitivity, not a claim that shipping a notebook costs 8 dollars. No carrier quoted 8 dollars. You typed 8 to see the remainder move by the same amount.

Drop the fee on purpose, then put it back

From the base, omit the 0.80 fee. Costs are 6 plus 5 plus 7, which is 18. Profit is 24 minus 18, which is 6 dollars. The offer did not improve by 80 cents of real performance. The definition got quieter. Anyone comparing 6 dollars with the base 5.20 dollars, without noticing the missing fee, will think the second sheet is better.

Put the fee back. The honest base is 5.20 with the fee named. On a small remainder, an unnamed fee is a large share of the story even when the fee itself is under a dollar. That is the habit this notebook is for: say the small line out loud.

Change only the price

Restore the full base, then change only price, from 24 dollars to 21 dollars, as if a discount were being tested on the same cost stack. Profit becomes 21 minus 18.80, which is 2.20 dollars. The discount cost 3 dollars of profit because every cost line stayed. A discount that also changes conversion is a different question, and this sheet has no conversion figure in it.

Restore price to 24. Do not carry 21 forward. The edit shows why a promotion needs a new subtraction rather than a shrug. Three dollars off a unit that only had 5.20 left is most of the remainder. Whether the promotion is still worth it depends on facts this example does not contain. Do not invent those facts.

The note beside the notebook

The note lists price 24, product 6, shipping 5, fee 0.80, ads 7, scope one unit, and profit 5.20 dollars. It lists the side edits: a 2 dollar allowance leaves 3.20, shipping at 8 leaves 2.20, omitting the fee shows 6, price at 21 leaves 2.20, and dropping ads shows 12.20 before advertising. A reader can rebuild each figure.

The note does not say the notebook is a good product, a bad product, or a product you should advertise at 7 dollars. It does not name a supplier. It does not claim a shop sold these units. It is a record of subtraction. A real invoice starts a new note rather than 'updating' this invention into a history.

Uses that break the example

Do not paste 5.20 into an ad account as a bid or a cost cap. Do not call 7 dollars a usual cost to acquire an order. Do not say notebooks return 5.20 dollars. This notebook, with these typed lines, leaves 5.20 dollars in the example. Change any line and the dollars change, as the edits already showed.

Do not staple this notebook to the candle used for a percentage elsewhere. They are different inventions with different prices and different costs. Combining them would pretend two worksheets were one shop. Keep this sheet about dollars. If you need the same lines as a percent of spend, divide profit by all spend on a fresh ROI sheet and label that percent as ROI.

One last rebuild of the base

Add the base costs from the fee upward. 0.80 plus 7 is 7.80. 7.80 plus 5 is 12.80. 12.80 plus 6 is 18.80. 24 minus 18.80 is 5.20. The base still holds. Stop. Adding a subscription, a bundle, or a second notebook would be a new example, and this sheet promised one.

If you want a percentage of price that stops before shipping and ads, take price and product cost to /profit-margin/ and do not call the result profit. Gross margin on these two lines would be a different reading from 5.20 dollars. Leave that reading on that page so the dollar remainder stays intact here.

Shopify questions