Calculator

Show Order Insights

Upload your Whatnot order export and get a quick show snapshot: problem-order rate, net revenue, average order value and your top products.

Drop Your Whatnot Order Export Here

One file or several — each show becomes its own column in the comparison strip.

Your data stays in your browser. We don’t store or send your order file.

No show loaded yet

Upload an order export above and the show snapshot — problem-order rate, net revenue and your top products — appears here.

How This Is Calculated

Method

  • A problem order is any row with a non-empty cancelled_or_failed value. Everything else counts as valid.
  • Net revenue sums original_item_price on valid rows only.
  • Average order value = net revenue ÷ valid order count.
  • Problem-order rate = problem orders ÷ total rows.
  • Products are aggregated by product_name, falling back to sku when the name is blank.
  • If the export has no cancelled_or_failed column, every row is treated as valid and the page says so.

What It Excludes

  • Margin and profit: cost_per_item and total_cost are not used, as their meaning in the export is unverified.
  • Buyer identity: the shipping address is discarded at parse time and never displayed.
  • Geography, buyer loyalty, timing and coupon analysis.

How We Calculate It

  • One export row represents one order line at its listed item price.

Related Resources

Calculator

Live Show Profit Calculator

Enter one show's revenue and costs to see its show contribution and how each cost line affects it.

Profitability & Numbers · Streaming & Live Shows