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
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
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 like this
Plan a Black Friday or Holiday Sale with Margin, Stock and Calendar Checks
You get an offer check table showing margin and stock days per product, a recommended discount, a day-by-day launch calendar with risk flags, and fixes.
Design a Loyalty Punch-Card Program That Protects Your Margins
Get two loyalty reward structures compared by true cost per returning visit, a recommended program with card wording, anti-abuse rules and a 90-day tracking plan.
Audit an Ecommerce Product Page for Conversion Problems and Rank the Fixes
Get a 1-5 scorecard of your product page across six fixed areas, plus a ranked list of concrete fixes sorted by likely impact versus effort.
Find Why Customers Return Products Using Your Return Reasons Data
Groups your pasted return reasons into root causes, estimates what each cause costs, and pairs each with a product page, packaging, or sizing fix ranked by cost.
Write a 3-Email Abandoned Cart Sequence That Protects Your Margins
You get three ready-to-send abandoned cart emails with send times, one objection per email, tested subject lines under 45 characters, and a discount that fits your margin.
Write a Four-Email Welcome Series for New Store Subscribers
Get four ready-to-send welcome emails covering brand story, bestsellers, a review or reply request, and a first-order nudge, each with subject lines and timing.