Unshipped Orders Report

The Unshipped Orders Report provides a list of all orders that have not been shipped as of the moment that you request the report.

Request an Unshipped Orders Report

To request a report of unshipped orders, follow these steps:

1. In Seller Central, click the Orders tab, and then click Order Reports.
2. On the Order Reports page, click on Unshipped Orders.
3. In the Request an Unshipped Order Report section, click the Request Report button.

A status box appears confirming your request and begins processing your order information to produce the report.

Download an Unshipped Orders Report

After you generate a report, you can pick up the report from a list of generated reports:

1. On the Order Reports page, click Unshipped Orders in the navigation bar.
2. Select the past number of days for which you would like to order information.
3. Under Download, click a report.
4. Pick a folder location on your computer and click Save.

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.