This article applies to selling in: Spain
All Orders Report
This report provides order and item information for both FBA and seller-fulfilled orders including order status, fulfillment and sales channel information, and item details.
An online view of this report is not offered.
This report includes recent orders regardless of whether they have been shipped. Both FBA and seller-fulfilled orders are included enabling you to monitor and analyze demand across fulfillment and sales channels.
The report can be requested in two ways:
- By order date: Orders placed in the specified date range will be returned
- By last update: Orders that have changed (been placed or updated) in the specified date range will be returned.
The report does not include customer-identifying information.
Field definitions
| Field name | Description | 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 seller. | my-order |
| purchase-date | The date the order was placed. | 14-07-2010T18:53:56+ 00:00 |
| last-updated-date | The date of the most recent order update | 14-07-2010T18:53:56+ 00:00 |
| order-status | Current status of the customer order | Complete |
| fulfillment-channel | Indicates how the order was fulfilled, via Amazon (AFN) or Merchant (MFN) | Amazon |
| sales-channel | Channel through which the order was purchased | Amazon.es |
| ship-service-level | An enumerated value that determines the type of fulfillment service that the buyer expects the seller to use (for example, Standard vs. Expedited) | Standard |
| 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 |
| sku | A merchant-defined unique identifier for a product. | HarryPotter |
| asin | Amazon inventory ID | B000WON1Z0 |
| item-status | Current status of this item within the order. | Shipped |
| quantity-purchased | The number of this item that were purchased | 1 |
| currency | The currency used for the purchase. | EUR |
| item price | The amount the buyer paid for the item. Amount is aggregate of the quantity, not unit price. | 15 |
| item-tax | The amount 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. | 0 |
| gift-wrap-tax | The amount the buyer paid for gift wrap tax. Amount is aggregate of the quantity, not unit price. | 0 |
| promotion-ids | List of all item promotions applied to this order item | -6,5 |
| item-promotion-discount | Promotion discount applied to the order item. | -6,5 |
| ship-promotion-discount | Promotion discount applied to shipping. | -4,25 |
| ship-city | The city of a standard address. | Alcoy |
| ship-state | The state or region of a standard address. | Alicante |
| ship-postal-code | The postal (zip) code of a standard address. | 03081 |
| ship-country | ISO 3166 standard two-letter country code. | ES |
| default-ship-from-address-name | The warehouse or business name used in the Seller Central account shipping settings or template | John Doe |
| default-ship-from-address field-1 | First line of "Default Ship From" address | Abandoibarra Etorb. |
| default-ship-from-address-field-2 | Second line of "Default Ship From" address | Optional |
| default-ship-from-address-field-3 | Third line of "Default Ship From" address | Optional |
| default-ship-from-address-city | City of "Default Ship From" address | Alcoy |
| default-ship-from-address-state | State of "Default Ship From" address | Alicante |
| default-ship-from-address-country | Country of "Default Ship From" address | ES |
| default-ship-from-address-postal-code | ZIP code or postal code of "Default Ship From" address. Value format depends on destination country. | 03081 |
| actual-ship-from-address-name | The warehouse or business name that is chosen while confirming the order | John Doe |
| Actual Ship From Location (3 columns) actual-ship-from-address-1 | First line of "Actual Ship From" address | Abandoibarra Etorb. |
| actual-ship-from-address-field-2 | Second line of "Actual Ship From" address | Optional |
| actual-ship-from-address-field-3 | Third line of "Actual Ship From" address | Optional |
| actual-ship-from-address-city | City of "Actual Ship From" address | Alcoy |
| actual-ship-from-address-state | State of "Actual Ship From" address | Alicante |
| actual-ship-from-address-country | Country of "Actual Ship From" address | ES |
| actual-ship-from-address-postal-code | ZIP code or postal code of "Actual Ship From" address. Value format depends on destination country. | 03081 |
| tax-collection-model | Tax Collection Model or Tax Collection Responsible Party | MarketplaceFacilitator |
| IOSS Number | Import One Stop Shop (IOSS) number for the marketplace. Sellers shipping to the EU from non-EU must provide this IOSS number to their carrier where Amazon has collected the VAT on the sale. 12 alphanumeric characters with the following structure IMXXXYYYYYYZ | IMXXXYYYYYYZ |
Sign in to use the tool and get personalized help (desktop browser required).
Related articles
- Amazon-Fulfilled Shipments Report
- All Orders Report
- Customer Shipment Sales
Additional Help
