Amazon orders report: no cancelled orders
An Amazon Seller Central All Orders report (Reports → Fulfillment → All Orders), a tab-separated file with one row per item.
Processed locally in your browser. File contents are not uploaded. No account needed.
Before and after
Made-up rows from the sample file, run through the same code Rote Workspace runs, when this page was built. Removed rows are struck through; changed cells are highlighted — point at one for its old value.
Original
| Row | order-status | item-price | item-tax | shipping-price |
|---|---|---|---|---|
| 2 | Shipped | 189.00 | 15.12 | 5.99 |
| 3 (removed) | Cancelled | 48.00 | 3.84 | 4.99 |
| 4 (removed) | ||||
| 5 | Pending | 1,299.00 | 103.92 | 0.00 |
| 6 | Shipped | 117.00 | 9.36 | 5.99 |
Result
| Row | order-status | item-price | item-tax | shipping-price |
|---|---|---|---|---|
| 2 | Shipped | 189.00 | 15.12 | 5.99 |
| 5 | Pending | 1299.00 (changed) | 103.92 | 0.00 |
| 6 | Shipped | 117.00 | 9.36 | 5.99 |
3 rows × 11 columns after the fixes · was 5 × 11 · 1 cell changed
7 more columns are not shown; they pass through unchanged.
Why
Totals from the orders report are wrong until cancelled orders are taken out and the money columns are read as numbers.
What it does
- Remove empty rowsOn the sample: 1 row removed
- Keep only the rows where "order-status" does not contain "cancel"; the other rows are removedOn the sample: 1 row removed
- Read "item-price", "item-tax", "shipping-price" as numbers (decimal mark: dot, 1,234.56); values that are not numbers are left as they areOn the sample: 1 cell changed
Your file needs these columns, spelled exactly: order-status, item-price, item-tax, shipping-price. If one is missing or renamed, the workflow tells you which step it breaks and does not run.
How to use it
Download the workflow
A small .json file with the steps above — no data. Want to try it first? Use the sample file (made-up rows).
Open your export
In the Data Workspace, choose your file. It is processed in your browser, not uploaded.
Import, review, run
Workflow → Import, choose the file — or skip the download: under Workflow → Templates, press Check & open. Each step is checked against your columns; press Run on this file, then Download.