Amazon order report

이 템플릿의 설명은 아직 번역되지 않아 영어로 표시합니다.

이 템플릿이 읽는 파일

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.