Amazon Fulfilled Shipments Report

FBA sellers can download a text file (.txt) report of completed shipments. The Amazon Fulfilled Shipments Report lists completed Amazon-fulfilled shipments for the time period that you select.Report data is updated shortly after an item has been dispatched, typically within several hours but in rare instances up to 24 hours after shipment.

The report contains all completed shipments reported to FBA during the specified time period. This may not include all items that were dispatched during that time frame if they have not yet been reported to our system. Those items will be reported in a future time period. This ensures that the report data will always be consistent for any given date range.

The report includes order, shipment and item data including price and shipping address information. In addition to downloading the report through the Seller Central interface, sellers with developer capability can use Marketplace Web Services (Amazon MWS) to request the report programmatically.

Request for the Amazon Fulfilled Shipments Report

You can retrieve reports up to 18 months old and within a maximum date range of 31 days. Requests for older reports or wider date ranges may be rejected by the system. If you have a large number of orders, it may take a while to generate your report. To generate reports quickly, specify shorter date ranges. Please note that this report provides information at the shipment level. To know which orders went out in a specific date range, please use the "All Orders" report.

To generate the Amazon Fulfilled Shipments Report, perform the following steps:

1. Click the "Order Reports" link found under Reports > Fulfilment.
2. In the Request an Order Report section, select the number of prior days you would like to include. Select "Exact Dates" to set a specific time range. You can request up to one month of data in a single report.
3. Select "Amazon Fulfilled Shipments Report" from the left-hand navigation panel.
4. Click the "Request Report" button.

Download the Report

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

1. On the Order Reports page, in the Check Report Status & Download section, find the report you want to download. If it is ready, a "Download" button will be available.
2. Click the "Download" button. The Save As dialog box will appear.
3. Choose a folder location and click "Save."

How to Read the Amazon Fulfilled Shipments Report

After you download the report, you can open it in any database or spreadsheet program, such as Microsoft Access or Microsoft Excel. Please note the following:

• Shipment dates are based on when the shipment was reported to the system, which is generally a few hours after the actual ship date. Other reports may calculate shipment dates differently. All dates are in GMT.
• Customer phone numbers and addresses are not shown in the report to comply with our privacy policies.

Here is a list of the fields that appear on the shipment report, as well as definitions of those fields and examples for each one.

Field Name	Definition	Example
amazon-order-id	Amazon’s unique, displayable identifier for an order.	058-3718414-0463502 or S01-3718414-0463502
merchant-order-id	A unique identifier optionally supplied for the order by the Merchant.	my-order
shipment-id	Encrypted Amazon shipment id	A13HTCT6TX9QAP
shipment-item-id	Encrypted Amazon shipment item id	AW5K6OE4N1SER
amazon-order-item-id	Amazon’s unique, displayable identifier for an item within the order.	175179673121
merchant-order-item-id	A unique identifier for an item within the order.	my-order-item-1
purchase-date	The date the order was placed.	2003-07-14T18:53:56-07:00
payments-date	The date the buyer's credit card was charged and order processing was completed.	2003-07-14T18:53:56-07:00
shipment-date	The date the shipment was completed (shipped) by the fulfillment center	2003-07-14T18:53:56-07:00
reporting-date	The date the data for this report became available in the FBA data store.	2003-07-14T18:53:56-07:00
buyer-email	The e-mail address of the buyer.	dodson@companyname.co.uk
buyer-name	The full name of the buyer.	Sean Dodson
buyer-phone-number	The phone number of the buyer.	Note: This information will not be provided, in compliance with Amazon's privacy policy.
sku	A merchant-defined unique identifier for a product.	HarryPotter3
product-name	The short title for the product, displayed in bold on the detail web page and in the title bar of the browser window.	Snowboard
quantity-shipped	The number of this item that were shipped.	1
currency	The currency used for the purchase. Supported currencies include GBP, EUR, USD, CAD and JPY.	GBP
item-price	The amount that the buyer paid for the item. Amount is aggregate of the quantity, not unit price.	15
item-tax	The amount that the buyer paid for item tax. Amount is aggregate of the quantity, not unit price.	0
shipping-price	The amount that the buyer paid for shipping. Amount is aggregate of the quantity, not unit price.	5.95
shipping-tax	The amount that the buyer paid for shipping tax. Amount is aggregate of the quantity, not unit price.	0
gift-wrap-price	The amount that the buyer paid for gift wrap. Amount is aggregate of the quantity, not unit price.
gift-wrap-tax	The amount that the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price.
ship-service-level	An enumerated value that determines the type of fulfillment service that the buyer expects the merchant to use (e.g., Standard v. Expedited)	Standard
recipient-name	Name field of a standard address.	Sean Dodson
ship-address-1	The first line of a standard address.	11 Main St
ship-address-2	The second line of a standard address.	Apt. 12
ship-address-3	The third line of a standard address.	c/o Joe's Company
ship-city	The city of a standard address.	Slough
ship-state	The state or region of a standard address.	Berks., Berkshire
ship-postal-code	The postal (zip) code of a standard address.	SL1 1QP
ship-country	ISO 3166 standard two-letter country code.	UK
ship-phone-number	The phone number associated with the ship-to address.	1-425-555-5678
bill-address-1	The first line of a standard address.	Note: This information will not be provided, in compliance with Amazon's privacy policy.
bill-address-2	The second line of a standard address.	Note: This information will not be provided, in compliance with Amazon's privacy policy.
bill-address-3	The third line of a standard address.	Note: This information will not be provided, in compliance with Amazon's privacy policy.
bill-city	The city of a standard address.	Note: This information will not be provided, in compliance with Amazon's privacy policy.
bill-state	The state or region of a standard address.	Note: This information will not be provided, in compliance with Amazon's privacy policy.
bill-postal-code	The postal (zip) code of a standard address.	Note: This information will not be provided, in compliance with Amazon's privacy policy.
bill-country	ISO 3166 standard two-letter country code.	Note: This information will not be provided, in compliance with Amazon's privacy policy.
item-promotion-discount	Promotion discount applied to the order item.	-6.5
ship-promotion-discount	Promotion discount applied to shipping.	-4.25
carrier	The name of the carrier the package was shipped with.	UPS
tracking-number	The carrier's tracking number for the package.	1Z861E7F0340512285
estimated-arrival-date	The estimated date of delivery to the customer.	2010-01-09T04:00:00+00:00
fulfillment-center-id	The unique identifier from which fulfillment center the order was shipped.	LTN1
fulfillment-channel	Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN)	AFN or MFN
sales-channel	The source of the order.	Amazon.co.uk