Amazon order report
Built from Amazon's documentation; reads the tab-delimited .txt file. Not yet checked against a real export.
Downloads
Built from public column lists and not yet checked against a real export. If a column name differs, the import reports the missing column.
The sample holds made-up data. Import it to see the template working in your app before using your own file.
The file this template reads
The order report that Seller Central provides as a tab-delimited text file (.txt), one row per order item.
Getting the order file
- Request an order report in Seller Central and download the .txt file.
- Import the .txt file as it is; do not convert it to Excel first.
Good to know
- Built from Amazon's documentation of the report columns and not yet checked against a real export.
- The quantity is quantity-purchased. In a report of unshipped orders, quantity-to-ship can be smaller; map that column instead if you want what is still to ship.
- The file must be UTF-8. Some marketplaces provide the report in another encoding (Japan, for example), which this version cannot read; re-save it as UTF-8 first.
- The date is read from the start of purchase-date (year-month-day). The time and time zone are ignored, so an order placed near midnight keeps the date written in the file.
- Order status is not filtered: every row in the file is imported.
How to use a template
- In SortingGo, open "1. Import", tap the import format menu and choose "Choose from the template library...".
- Find your marketplace and tap "Add and use for this import".
- Choose the order file your marketplace exported. You can also just choose the file: when the app recognises a marketplace report, it asks whether to use the matching template.
You can also add a template from a file: download its format file (.xlsx), then in SortingGo open "Custom Import Formats", tap "Import format" and choose it.
Requires SortingGo 1.9.6 or later.
Templates work on every plan. Free and Lite do not import the order number and product code; every other field, including the spec, is imported.
Column mapping
| SortingGo field | Column in the file |
|---|---|
| Order date | purchase-date |
| Customer | recipient-name |
| Product name | product-name |
| Quantity | quantity-purchased |
| Order number | order-id |
| Product code | sku |
Template not working?
Platforms change their export columns. If the import reports a missing column, send us the export with only its header row (delete every order row first) and we will update the template.
Where the column names come from
- developer-docs.amazon.com/sp-api/docs/order-reports-attributes
- developer-docs.amazon.com/sp-api/docs/report-type-values-order
Template updated 2026-10-05
SortingGo is not affiliated with or endorsed by the platforms named on this page. Their names belong to their owners and are used only to say which file a template reads.