CSV imports

Import Whatnot Seller Weekly Orders Report CSVs into WhatCopilot: statuses, row stats, async processing, and shop targeting (max 25 MB).

Imports (`/app/imports` and `/app/imports/new`) are the source of truth for analytics. No CSV, no KPIs.

Role

Ingest official Whatnot weekly order exports per shop and monitor processing until data lands in Dashboard, Statistics, and tables.

Features

  • Import history: file name, date, status (`pending` / `processing` / `completed` / `failed`)
  • On completed: detected / new / updated / rejected row counts
  • Error message surface on failed jobs
  • Auto-poller while an import is active
  • New import: choose shop + upload CSV to signed storage (`csv-imports` bucket)
  • Also available from the app header Import menu (drag & drop dialog)
  • Limits: 25 MB max, soft cap ~100,000 rows

Use cases

  • Load historical weekly exports when onboarding
  • Keep analytics current with each new Whatnot report
  • After a show: import → link on Results → debrief plan vs actual in the show cockpit
  • Diagnose a failed upload via `error_message`

Limits

  • Demo: no new import button; `/imports/new` is blocked
  • Requires at least one Whatnot shop
  • WhatCopilot does not scrape Whatnot — sellers upload the official export

FAQ

Which file should I upload?
The official Whatnot Seller Weekly Orders Report CSV export for your seller account — not a custom spreadsheet unless it matches that format.
Why is my import stuck on processing?
Large files process asynchronously. The Imports list polls while status is pending or processing. If it fails, open the row for the error message.