The Unshipped Orders Report provides a list of all orders that have not been shipped as of the moment that you request the report.
To request a report of unshipped orders, follow these steps:
A status box appears confirming your request and begins processing your order information to produce the report.
After you generate a report, you can pick up the report from a list of generated reports:
After you download the Unshipped Orders report, you can open it in any database or spreadsheet program, such as Microsoft Access or Microsoft Excel.
Here is a list of the fields that appear on an Unshipped Orders Report, with definitions and examples for each. Please note, your report may display more fields or fewer fields depending on your account setup.
Field name | Definition | Example |
---|---|---|
order-id | Amazon's unique identifying number for an order. This important number is a reference for shipping confirmation and post-order processing. | 736-1234567-1234567 |
order-item-id | Amazon's unique identifying number for an item in an order. This important number is used as a reference for shipping confirmation and post-order processing. | 0583563777345 |
purchase-date | The date and time that the order was placed. Unless you specify a different shipping lead time, you have agreed to ship the order within two business days of this date. | 2014-13-08T18:00:22+00:00 |
payments-date | The date and time that Amazon processed the payment for the order. | 2014-13-08T11:00:22-07:00 |
reporting-date | The date and time that the order changed from pending to unshipped making it ready to be shipped. | 2014-13-08T18:30:41+00:00 |
promise-date | The date when the order was promised to be shipped to the customer. | 2014-14-08 |
days-past-promise | The current number of days past the promise date. | 3 |
buyer-email | The e-mail address of the buyer. | JoeSmith@somecompany.com |
buyer-name | The name of the buyer. | Joe Smith |
buyer-phone-number | The phone number of the buyer. | 0818555111 |
sku | Stock Keeping Unit. Your unique identifier for the product. | sku123 |
product-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 |
currency | The currency used for the transaction. | EUR |
quantity-shipped | The quantity of the item that has already been shipped. | 1 |
ship-service-level | The fulfilment service level that the buyer paid for when ordering the item; that is, Standard or Expedited. | standard |
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. | Apt. 12 |
ship-address-3 | The third line of the "Ship to" address. | c/o Joe's Company |
ship-city | The city for the "Ship to" address. | Amsterdam |
ship-state | The region or state of the "Ship to" address. The value depends upon the country of origin. Note: the state abbreviation can vary depending on how it was entered by the customer. | North Holland |
ship-postal-code | The postal code of the "Ship to" address. The value depends upon the country of origin. | 1071 DJ |
ship-country | The international standard two-letter country code (ISO 3166 compliant). | NL |
gift-wrap- text | The message that should appear on the gift card. | Happy Birthday. |