Calculate Your Real Product Profit Margin After Fees, Shipping and Ads

Get a per-unit profit table for one product, covering fees, shipping and ad spend, plus your break-even ad cost per sale and break-even ROAS.

You getInputs used, per-unit table and key numbers

Prompt

Prompt
Act as an ecommerce finance analyst who works with small online stores.

Your job is to calculate the true per-unit profit of one product I sell. Before you calculate, ask me these questions in one message and wait for my answers:
1. Selling price, and what the customer pays for shipping.
2. Product cost per unit, packaging, and what I pay for the shipping label.
3. Platform, payment and marketplace fees (percent and fixed), plus my return or refund rate.
4. My current ad spend per sale, and the profit margin I want to hit.

Rules:
- Use only the numbers I give you. If one is missing, state the assumption you used and label it "assumed".
- Show every line in dollars per unit and as a percent of the selling price, rounded to 2 decimals.
- Calculate the profit left before ads first, then subtract ad cost. Keep the two steps separate.
- The break-even ad cost per sale equals the profit before ads. Also give the break-even ROAS.
- Give exactly 3 levers to improve margin, each with its new per-unit profit.

Output format:
1. Inputs used (short list)
2. Per-unit table: Line item | $ per unit | % of price
3. Key numbers: profit before ads, net profit, net margin, break-even ad cost per sale, break-even ROAS, max ad cost for my target margin
4. Three levers, each with the math

End with one line on which assumptions carry the most risk. This is not tax or accounting advice. Check tax treatment with an accountant.

Example output

At a glanceWhere the $34 candle price goes, per unitNet profit is $5.69 per unit, a 16.74% margin
  • Ad cost per sale: $9.50
  • Product cost: $8.50
  • Shipping label: $6.80
  • Net profit: $5.69
  • Payment fee: $1.29
  • Packaging: $1.20
  • Returns allowance: $1.02

Example for: a Shopify soy candle store selling a $34 candle with free shipping, spending $9.50 in Meta ads per sale and targeting a 20% net margin.

1. Inputs used
  • Selling price: $34.00 (customer pays $0 shipping)
  • Product cost: $8.50. Packaging: $1.20. Shipping label: $6.80
  • Payment fee: 2.9% + $0.30
  • Returns allowance: 3% of price (assumed, based on "a few returns a month")
  • Ad cost per sale: $9.50. Target net margin: 20%
2. Per-unit table
Line item$ per unit% of price
Selling price34.00100.00%
Product cost-8.5025.00%
Packaging-1.203.53%
Shipping label-6.8020.00%
Payment fee-1.293.79%
Returns allowance-1.023.00%
Profit before ads15.1944.68%
Ad cost per sale-9.5027.94%
Net profit5.6916.74%
3. Key numbers
  • Profit before ads: $15.19
  • Net profit per unit: $5.69 (16.74% margin)
  • Break-even ad cost per sale: $15.19
  • Break-even ROAS: 34.00 / 15.19 = 2.24. Your current ROAS is 3.58.
  • Max ad cost for a 20% margin: 15.19 − 6.80 = $8.39 per sale. You are $1.11 over it.
4. Three levers
  1. Raise the price to $38. The payment fee rises to $1.40 and returns to $1.14, so profit before ads is $18.96. Net profit is $9.46, a 24.89% margin.
  2. Cut ad cost per sale to $8.00. Net profit is $7.19, a 21.15% margin, which clears your target.
  3. Charge $4.95 shipping on orders under $50. This offsets your label cost to $1.85. Net profit is $10.64, a 31.29% margin. Conversion may drop, so test it on one product first.

Biggest risk: the 3% returns rate is assumed. If it is really 8%, profit before ads falls to $13.49.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • It asks for your real costs before calculating, so the margin reflects your store and not generic industry averages.
  • It shows profit before ads separately, which gives the break-even ad cost per sale and ROAS directly.
  • It requires the math behind each lever, so you can compare price, ad and shipping changes on the same basis.

Use this before you scale ads or change prices. Have your supplier invoice, shipping label cost, payment fee rates and recent ad spend per order ready. Works in ChatGPT, Claude or Gemini.

Common edits

  • Ask it to compare 3 products side by side in one table to see which one deserves the ad budget.
  • Add Amazon FBA fees or a monthly app cost spread across your expected units per month.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Business