Amazon 订单报表

这个模板的说明尚未翻译，以下以英文显示。

这个模板读取的文件

The order report that Seller Central provides as a tab-delimited text file (.txt), one row per order item.

取得订单文件

• 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.

注意事项

• 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.