How to calculate your real Whatnot seller margin
Net revenue, COGS, average order value, and refund rate: formulas, worked scenarios, and a checklist to run collectibles-shop profitability on Whatnot.
Key takeaways
- Gross revenue (buyer_paid) is not the net that hits your account.
- WhatCopilot estimated margin = SUM(transaction_amount) − SUM(cost_of_goods) on earnings/refunds.
- Cross margin with AOV: a big live with low AOV can be less profitable.
- Without entered COGS, you fly blind on real profitability.
- Refunds crush net as hard as marketplace fees.
- Compare live formats (volume vs premium) on margin, not only gross.
Many Whatnot sellers track gross revenue (buyer_paid) without seeing the net amount that actually hits their account. The gap, commission + fees + shipping, can easily exceed 15%. Without real margin, you optimize volume, not profitability.
Formula, worked scenarios, and a method to cross margin, average order value, and refunds. Goal: decide lot by lot and live by live, not by gut feel.
Buyer-facing sales vs net revenue
buyer_paid tells you what the customer paid. transaction_amount tells you what remains after typical marketplace fees in the ledger. For a collectibles shop, net is the cash KPI; gross mainly supports marketing and average order value. Column detail: How to read your Whatnot Seller Weekly Orders Report.
What the live shows
- Sales total / winning bids
- Chat energy and pace
- Cumulative buyer_paid (buyer view)
What the ledger says
- transaction_amount = net after typical fees
- Negative refunds included
- Margin only when COGS is filled
The estimated margin formula
WhatCopilot estimated margin = SUM(transaction_amount) for order_earnings and order_refund − SUM(cost_of_goods). It is not accounting or tax advice, but it is an actionable signal after every livestream, especially when you enter COGS before exporting.
- Estimated margin = Σ transaction_amount (earnings + refunds) − Σ cost_of_goods
- Net revenue alone = Σ transaction_amount (no COGS)
- AOV ≈ average buyer_paid on retained orders
- Missing COGS → net revenue OK, estimated margin unavailable or misleading.
- Negative refunds → they naturally reduce net and margin.
- Premium vs volume lots → compare margin by SKU, not only show gross.
Three scenarios: same gross, different margins
Imagine three lives at ~$2,000 buyer_paid. The “good show” feeling is identical. The margin is not.
18%
Volume show
Many low lots, high COGS
32%
Mixed show
BIN + auctions, tracked COGS
41%
Premium show
Fewer lots, higher floors
- Ledger net (transaction_amount) ≈ $1,650 after typical fees
- Volume show: COGS $1,350 → margin ≈ $300 (18% of gross)
- Mixed show: COGS $1,000 → margin ≈ $650
- Premium show: COGS $820 → margin ≈ $830
- Live gross unchanged, lot structure changes everything
Cross margin with average order value
A high-gross live with a low AOV can be less profitable than a smaller live with premium lots. WhatCopilot’s Livestreams module exists for that comparison: sales, pace, buyers, and estimated margin side by side.
Flag high-sales / weak-margin lives
Those are candidates to reformat, not to copy blindly.
Find SKUs that dilute
High COGS, floors too low, or lots that drive refunds.
Test a premium format
Fewer lots, better floors, clearer offer in thirty seconds.
Re-import and validate
The CSV decides: did net margin follow the format change?
Refund rate and margin
Refunds do not only hurt morale, they crush net. Track order_refund volume, recurring reasons (photo quality, description, shipping), and fix them before you scale live frequency.
- Blurry or shadowy photos → “not as shown” disputes.
- Incomplete descriptions (sealed? graded?) → missed expectations.
- Slow shipping or weak packaging → refunds plus hidden costs.
Price floor before you open the lot
Margin is decided before the auction. Compute a floor: COGS + approximate fees + minimum acceptable margin. Opening under that floor should be a conscious call (clearance, buyer acquisition), not a pacing accident.
- Lot COGS = $35
- Approx fees + shipping = $10
- Minimum wanted margin = $15
- Floor ≈ $60, do not open at $20 “for energy”
Next steps
Product picture: Seller Analytics vs WhatCopilot · complete seller guide. Ops: increase sales · retain buyers · fees and commissions.
FAQ
- What is WhatCopilot’s estimated margin formula?
- SUM(transaction_amount) for order_earnings and order_refund − SUM(cost_of_goods). It is not official accounting, it is an actionable signal after every livestream.
- Should shipping be in COGS?
- Seller shipping is typically already reflected in the ledger net. COGS should mainly cover lot purchase / prep cost. Pick a method and stay consistent.
- How do I improve margin without killing volume?
- Cut negative-margin SKUs, raise auction floors, push premium lots, and compare live formats in the Livestreams module.
- What minimum margin should I target?
- It depends on category and cashflow. First set a per-lot floor (COGS + fees + minimum margin), then validate after CSV import.
- Does estimated margin replace my accountant?
- No. It is a seller operating tool. For tax and formal books, work with a professional.
- Why do two lives with the same gross have different margins?
- SKU mix, auction floors, refunds, and COGS. Gross hides structure; margin reveals it.