Amazon order report

Hướng dẫn của mẫu này chưa được dịch nên hiển thị bằng tiếng Anh.

Tệp mà mẫu này đọc

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

Lấy tệp đơn hàng

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

Lưu ý

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