Sell on Amazon Sign in
This article applies to selling in: United States

Amazon-Fulfilled Shipments Report

You can download a text file (.txt) report of completed shipments of orders that Amazon has fulfilled. 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 shipped, typically within several hours. At times, data may not populate until 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 shipped 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, sellers with developer capability can use Amazon Marketplace Web Services (Amazon MWS) to request the report.

Request the Amazon-Fulfilled Shipments Report

Reports can be requested for shipments up to 18 months in the past and within a maximum date range of 31 days. Requests for older reports or wider date ranges may be cancelled by the system. If you have a large number of orders, it may take a while to generate your report. Specifying shorter date ranges can help your reports get generated faster. Note that this report is designed to provide information at the shipment level. If you would like to know which orders went out in a specific date range, please use the "All Orders" report.

To request an Amazon-Fulfilled Shipments Report, follow the steps below:

  1. Click the Order Reports link found under Reports > Fulfillment.
  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 drop-down.
  4. Click Request Report

Download the report

After you generate a report, you can pick up the report from a list of generated reports. 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.

When you click the Download button, a Save As dialog box will appear. Choose a folder location and click Save.

Note: When you open the report in a spreadsheet program such as Microsoft Excel, depending on the language you might discover that some of the text is garbled. If you encounter this problem you can open the file using a UTF-8 compatible reader. The Excel Import Wizard provides the option of selecting the File Origin. Select "65001 : Unicode (UTF-8)" and the text will not be garbled.

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

  • 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 billing addresses are not shown in the report to comply with our privacy policies. Customer email addresses are encrypted.

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. 37329900000000
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 encrypted email address of the buyer. 12345abc@marketplace.amazon.com
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 order to comply 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. Chocolate Truffles
quantity-shipped The number of this item that were shipped. 1
currency The currency used for the purchase. Supported currencies include USD, CAD, GBP, EUR, and JPY. USD
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. 3151 Glenmanor Place
ship-address-2 The second line of a standard address.

ship-address-3 The third line of a standard address.

ship-city The city of a standard address. Los Angeles
ship-state The state or region of a standard address. California
ship-postal-code The postal (ZIP) code of a standard address. 90039
ship-country ISO 3166 standard two-letter country code. US
ship-phone-number The phone number associated with the ship-to address.
Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-address-1 The first line of a standard address.
Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-address-2 The second line of a standard address.
Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-address-3 The third line of a standard address.
Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-city The city of a standard address.
Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-state The state or region of a standard address.
Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-postal-code The postal (zip) code of a standard address.
Note: This information will not be provided in order to comply with Amazon's privacy policy.
bill-country ISO 3166 standard two-letter country code.
Note: This information will not be provided in order to comply 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. 7/14/2003
fulfillment-center-id The unique identifier from which fulfillment center the order was shipped. LEX1
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.com
Sign in to use the tool and get personalized help (desktop browser required). Sign in


Was this article helpful?
Thank you for your feedback
How can we improve this help page? Note: This form doesn’t create a support case. Please specify what you think is wrong with the content itself.
1000
What was helpful?
1000
Thanks again for your help!
Thank you for your feedback. If you have more questions, please Contact Us.

Reach Hundreds of Millions of Customers

Start Selling On Amazon


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