How to read your Whatnot Seller Weekly Orders Report

Direct answer: if you run your Whatnot shop only on the on-stream sales total, you miss the real ledger. The Seller Weekly Orders Report is the official export that describes every transaction — orders, refunds, tips, shipping — and it is the reliable base for KPIs, margin, and pricing decisions.

This guide decodes the critical columns, common traps, and an import workflow that turns the CSV into a post-show cockpit. WhatCopilot is not affiliated with Whatnot: you upload the file yourself — no account scraping.

What is the Seller Weekly Orders Report?

Each CSV row is a seller ledger transaction. It is not a simplified receipt: it is marketplace accounting detail. WhatCopilot imports this file to rebuild net revenue, trends, products, buyers, and livestreams.

• Covers order_earnings, order_refund, tips, shipping charges, and other ledger movements.
• Follows Whatnot’s export cadence — export after important live blocks.
• Independent of Seller Analytics screens: useful for archives, multi-shop, and external analysis.
• Lets you cross-check fees and commissions against observed net.

The columns that actually matter

You do not need every column. Three fields drive most seller decisions: net, buyer view, and purchase cost.

transaction_amount — the net

transaction_amount is a net figure: Whatnot commission, payment processing fees, and typical seller shipping are already deducted. Refunds carry a negative amount and subtract from the total naturally. Aggregate this column for net revenue.

buyer_paid — the buyer’s view

buyer_paid is what the buyer actually paid (item price + shipping − coupon). It drives buyer-facing revenue and average order value. Do not confuse buyer_paid with transaction_amount: the gap is mostly marketplace fees.

cost_of_goods — no COGS, no margin

cost_of_goods is only populated if you entered it in Whatnot. Without COGS, WhatCopilot can compute net revenue but not estimated margin — so fill that field before exporting. Deep dive: How to calculate your real Whatnot seller margin.

Worked example: one line, two readings

Here is why the same lot can “do $80” on stream and ~$65 in the ledger. Figures are illustrative — exact rates change; always verify the Whatnot Help Center.

Common mistakes reading the CSV

• Summing buyer_paid and treating it as cash in the bank.
• Ignoring order_refund rows (negative amounts) in totals.
• Exporting without filling COGS on strategic lots.
• Comparing two lives on stream gross without CSV net.
• Mixing exports from two shops into one workspace.

Recommended import workflow

1. 1

   Enter COGS

   On important lots, before the show or right after. Without this, margin stays a blind spot.

2. 2

   Export the report

   Download the Seller Weekly Orders Report from the Whatnot seller area.

3. 3

   Import into WhatCopilot

   Upload the CSV into the correct shop workspace — no scraping.

4. 4

   Read the KPIs

   Check net revenue, estimated margin, top products / buyers, and livestream comparison.

5. 5

   Adjust the next live

   Floor pricing, inventory, and pace: decide with the ledger, not chat vibes.

Go deeper

Reading the net is only step one: also map Whatnot fees & commissions, compare Seller Analytics vs WhatCopilot, and follow the complete Whatnot seller guide. Ready to import? See WhatCopilot pricing.