Sell on Amazon Sign in
This article applies to selling in: Netherlands

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.

Individual sellers: This feature is only available to sellers with a Professional selling plan. Learn more by visiting Selling plan comparison.

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.

Note: If you manually generate an Unshipped Orders Report, the orders will still appear in the standard Orders 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.

Note:
  • The Orders Report file does not include the buyer's credit card information. It includes only the buyer email, name, phone number and ship-to address.
  • The ship-to address is as the buyer supplied it when they placed their order. Amazon does not perform address correction on a buyer's address.

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.
Sign in to use the tool and get personalised help (desktop browser required). Sign in


Reach Hundreds of Millions of Customers

Start Selling on Amazon


© 1999-2022, Amazon.com, Inc. or its affiliates