This report provides comprehensive, product-level details on shipped FBA customer orders including price, quantity, tracking, and shipping info.
FBA sellers 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.
The report includes order, shipment, and item data, including price and delivery address information. In addition to downloading the report, sellers with developer capability can use Amazon Marketplace Web Services (Amazon MWS) to request the 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:
After you generate a report, you can pick up the report from a list of generated reports. On the Order Reports page, in the Download report 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 dialogue box will appear. Choose a folder location and click Save.
After you download the 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 in the 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 supplied optionally for the order by the Merchant. | my-order |
delivery-id | Encrypted Amazon shipment ID | A13HTCT6TX9QAP |
delivery-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 that the buyer's credit card was charged and order processing was completed. | 2003-07-14T18:53:56+ 07:00 |
delivery-date | The date the delivery was completed (shipped) by the fulfilment centre | 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 email address of the buyer. | 12345abc@marketplace.amazon.com |
buyer-name | The full name of the buyer. | Sean Dodson
Note: This information is restricted for tax use cases in certain marketplaces.
|
buyer-phone-number | The phone number of the buyer. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
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-delivered | The number of items that were delivered. | 1 |
currency | The currency used for the purchase. Supported currencies include USD, AUD, CAD, GBP, EUR, and JPY. | AUD |
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 |
delivery-price | The amount that the buyer paid for the shipping. Amount is aggregate of the quantity, not unit price. | 5.95 |
delivery-tax | The amount that the buyer paid for the 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. | |
delivery-service-level | An enumerated value that determines the type of fulfilment service that the buyer expects the merchant to use (for example, Standard vs. Expedited) | Standard |
recipient-name | Name field of a standard address. | Sean Dodson
Note: This information is restricted for tax use cases in certain marketplaces.
|
delivery-address-1 | The first line of a standard address. | 3151 Glenmanor Place
Note: This information is restricted for tax use cases in certain marketplaces.
|
delivery-address-2 | The second line of a standard address. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
delivery-address-3 | The third line of a standard address. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
delivery-city | The city of a standard address. | Sydney CBD |
delivery-state | The state, region, or county of a standard address. | Sydney |
delivery-postcode | The postcode of a standard address. | 2000 |
delivery-country | ISO 3166 standard two-letter country code. | AU |
delivery-phone-number | The phone number associated with the deliver-to address. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
bill-address-1 | The first line of a standard address. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
bill-address-2 | The second line of a standard address. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
bill-address-3 | The third line of a standard address. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
bill-city | The city of a standard address. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
bill-state | The state, region, or county of a standard address. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
bill-postal-code | The postcode of a standard address. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
bill-country | ISO 3166 standard two-letter country code. |
Note: This information is restricted for tax use cases in certain marketplaces.
|
item-promotion-discount | Promotion discount applied to the order item. | -6.5 |
delivery-promotion-discount | Promotion discount applied to delivery. | -4.25 |
Carrier | The name of the carrier the package was delivered with. | Australia Post |
tracking-number | The carrier's tracking number for the package. | 1Z861E7F0340512285 |
estimated-arrival-date | The estimated date of delivery to the customer. | 14/7/2003 |
fulfilment-centre-id | The unique identifier from which fulfilment centre the order was delivered. | LEX1 |
fulfilment-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.au |