Guide
Fixing a failed or partial spreadsheet import
What a partial import means, the most common causes, and how to correct just the rows that failed.
An import that reports errors on some rows still succeeds on the valid ones — a bad row does not fail the whole file. The response lists which rows had a problem and why, so the fix is usually a corrected re-upload of just those rows, not the whole file again.
The most common cause by far: a missing or blank `status` on order history. Every order-history row needs a status — fulfilled for anything that already shipped, or the matching status for what actually happened to it. A blank status cell is rejected outright rather than guessed at, because there's no way to tell an unshipped order from a shipped one whose export simply dropped the column, and guessing wrong understates available stock in a way that's hard to notice later. If someone's history import is failing broadly, check this first.
Partial statuses need their matching quantity. A row marked partially_fulfilled, partially_cancelled, or partially_returned needs its corresponding quantity_* column filled in — the status alone doesn't say how much of the line moved.
Re-uploading the same file is always safe. A repeat upload of a file that already succeeded returns the original result rather than double- counting anything — there's no risk in trying again if someone's unsure whether their first attempt went through.
Limits: 8 MB and 2,000 rows per upload. A larger history needs to be split into batches.