Peanelle
Peanelle
Log InSign Up Free
All help articles
CSV Import

CSV import: common issues & fixes

Last updated 2026-04-24

Problem

You uploaded a TikTok Seller Center CSV and got one of these:

  • "Import failed" with no row count
  • Some rows imported, others flagged as errored
  • Everything imported but dashboard numbers look off

Cause

TikTok Seller Center changes their CSV column headers periodically, and exports vary by region (US vs. UK vs. MY) and by date range (settlement reports vs. order exports). Peanelle's parser handles 100+ column-name variations, but it can still choke on:

  1. File saved as .xlsx — Peanelle needs a true CSV. Open in Excel/Numbers and File → Save As → CSV (comma-separated).
  2. Encoding mismatch — TikTok exports are UTF-8. Excel sometimes saves as ANSI / Windows-1252 on export, which mangles non-ASCII product names. In Excel's Save As dialog, choose "CSV UTF-8 (comma-delimited)".
  3. Wrong report type — the "Income" report and "Orders" report have different columns. Peanelle expects the Orders report (export from Seller Center → Orders → filter your date range → "Export"). The Income report drops per-order detail and won't import correctly.
  4. Missing Order ID column — if your CSV has no Order ID / Order Number column at all (rare), all rows are rejected. Re-export with the default column set selected.

Resolution

  1. Confirm your file ends in .csv, not .xlsx.
  2. Open it in a plain text editor (TextEdit, Notepad). You should see the header row followed by comma-separated values. If you see angle brackets or binary garbage, it's not a real CSV — re-save from Excel as "CSV UTF-8".
  3. Confirm the first row includes columns with names like Order ID, Order Status, SKU, Subtotal After Discount, Created Time. Exact capitalization doesn't matter.
  4. Re-upload via Import → Browse Files or drag-and-drop.
  5. If the UI reports "N rows had errors", click the import result for the first few error messages — they'll name the row and the bad column.

Still stuck? File a support ticket from your account nav with Category: CSV Import and paste the first 2-3 rows of your file (strip the order ID column if you're privacy-conscious). We'll look at it.

Related Articles