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 shipment can be reported as:
FBA – Fulfilled by Amazon
FBM – Fulfilled by Merchant
Many companies use FBA, it's easier to have Amazon deliver the parcels and convenient for the customer, however, when using FBA, Amazon does not give the merchant a complete set of info before the package is shipped.
When customers buy products on Amazon, Amazon ‘owns’ the customer, they do not share full customer information back to the merchant.
For FBM, since the Merchant needs to ship the product to Amazon’s customer, they will get the shipping information in order to execute the shipment.
Often Null for Customer State Code, Order State Code, etc but may be filled in for the "Fulfillments Ship State", so that is the most comprehensive way of seeing customer geographic distribution.
The list below represents the data Amazon will provide upon the order is shipped:
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 |