Topics
Unshipped Orders Report
The Unshipped Orders Report is a tab-delimited text-file, which provides an up-to-date list of orders that have not yet been confirmed as shipped. This report will include orders that are also on the scheduled daily Order Reports, so be sure not to fulfill them twice.
Requesting an Unshipped Orders Report
- In your Seller Account, under Manage Orders, click Order Reports.
The Order Reports page appears. - Click Unshipped Orders.
The Unshipped Orders page appears. - Click the Request Report button.
A status box appears, confirming your request.
Downloading the Unshipped Orders Report
- To find the Unshipped Orders Report you requested, on the Unshipped Orders page click the Refresh button next to "Check Report Status & Download."
The requested report appears. - When the report has "Ready" under "Report Status" click the Download button next to it. When the "File Download" box appears, click Save, select the location on your computer where you will store your Unshipped Orders Reports and click Save again.
The report is downloaded and saved to your computer. - When the "Download complete" box appears, click "Open Folder," right-click the saved file, select "Open With" from the popup menu, and open the file with a spreadsheet or database program such as Microsoft Excel or Access.
Reading an Unshipped Orders Report
The Unshipped Orders Report lists all orders that have not been confirmed as shipped, as of the time you requested the report, and all of the information required for fulfilling the orders.
This is a list of the fields in an Unshipped Orders Report.
| Field name | Definition | Example |
|
order-id |
Amazon's unique identifying number for an order. This is an important reference number for shipping confirmation and order processing. |
104-3563777-5518068 |
|
order-item-id |
Amazon's unique identifying number for an item in an order. Note: This is not the same as the product ASIN. The order-item-id differs from order to order. |
05813563777345 |
|
purchase-date |
The date the order was placed. You must ship the order within two business days of this date. |
2009-11-19 |
|
promise-date |
The date when the order was promised to be shipped to the customer. |
2009-11-21 |
|
days-past-promise |
The current number of days past the promise date. |
3 |
|
buyer-name |
The full name of the buyer. |
Joe Smith |
|
sku |
Your merchant-defined unique identifier for the product. |
sku123 |
|
item-name |
The short title for the product, displayed in bold on the product's detail page and in the title bar of the browser window. |
Snowboard |
|
quantity-purchased |
The quantity of the item ordered. |
1 |
|
quantity-shipped |
The quantity of the item that has already been shipped. |
0 |
|
quantity-to-ship |
The quantity of the item that has not yet been shipped. |
1 |
|
ship-method |
The delivery method chosen by the customer. |
expedited |
|
recipient-name |
Name field of the "Ship to" address. |
Joe Smith |
|
ship-address-1 |
The first line of the "Ship to" address. |
11 Main St |
|
ship-address-2 |
The second line of the "Ship to" address. |
|
|
ship-city |
The city for the "Ship to" address. |
|
|
ship-state |
The province or region of the "Ship to" address. The value depends upon the country of origin. Note: the province abbreviation can vary depending upon how it was entered by the customer. |
MB |
|
ship-zip |
The postal code (or ZIP code) of the "Ship to" address. The format depends upon the country of origin. |
R3T 2T2 |
|
ship-country |
The international standard two-letter country code (ISO 3166 compliant). |
CA |
Seller Support
