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.