← Blog

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.

This guide gives the 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.

Formula in one place
  • 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

Illustrative scenario — live at $2,000 buyer_paid
  • 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.

  1. Flag high-sales / weak-margin lives

    Those are candidates to reformat — not to copy blindly.

  2. Find SKUs that dilute

    High COGS, floors too low, or lots that drive refunds.

  3. Test a premium format

    Fewer lots, better floors, clearer offer in thirty seconds.

  4. 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.

Quick floor math
  • Lot COGS = $35
  • Approx fees + shipping = $10
  • Minimum wanted margin = $15
  • Floor ≈ $60 — do not open at $20 “for energy”

Next steps

For the full product picture: Seller Analytics vs WhatCopilot and the complete Whatnot seller guide. To start CSV import and Orion: WhatCopilot pricing.

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.