After you download the report, you can open it in any database or spreadsheet program, such as Microsoft Access or Microsoft Excel.
Fields and data availability
Here is a list of the fields that appear in the report, as well as definitions of those fields and examples for each one. If the field availability is restricted, this table indicates in which report variant the field is available as indicated in the Available Report column. Where left empty, the field is available in all shipment reports.
Field Name | Description | Example | Available Report |
---|---|---|---|
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. | 2012-07-14T18:53:56+ 00 :00 | |
payments-date | The date the buyer's credit card was charged and order processing was completed. | 2012-07-14T18:53:56+00 :00 | |
shipment-date | The date the shipment was completed (shipped) by the fulfillment center | 2012-07-14T18:53:56+ 00 :00 | |
reporting-date | The date the data for this report became available in the FBA data store. | 2012-07-14T18:53:56-07:00 | |
buyer-email | The e-mail address of the buyer. | ramesh@somecompany.in | |
buyer-name | The full name of the buyer. | Ramesh Patil
Note: This information is restricted for tax use cases in certain marketplaces.
|
Amazon Fulfilled Shipments – Tax Invoicing |
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. | Snowboard | |
quantity-shipped | The number of this item that were shipped. | 1 | |
currency | The currency used for the purchase. Supported currency is INR. | INR | |
item-price | The amount that the buyer paid for the item. Amount is aggregate of the quantity, not unit price. | 150 | |
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. | 50 | |
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. | Ramesh Patil
Note: This information is restricted for tax use cases in certain marketplaces.
|
Amazon Fulfilled Shipments – Tax Invoicing |
ship-address-1 | The first line of a standard address. | 11 Main St
Note: This information is restricted for tax use cases in certain marketplaces.
|
Amazon Fulfilled Shipments – Tax Invoicing |
ship-address-2 | The second line of a standard address. | Apt. 12
Note: This information is restricted for tax use cases in certain marketplaces.
|
Amazon Fulfilled Shipments – Tax Invoicing |
ship-address-3 | The third line of a standard address. | c/o Ramesh's Company
Note: This information is restricted for tax use cases in certain marketplaces.
|
Amazon Fulfilled Shipments – Tax Invoicing |
ship-city | The city of a standard address. | Bangalore | |
ship-state | The state or region of a standard address. | KA | |
ship-postal-code | The postal (zip) code of a standard address. | 560055 | |
ship-country | ISO 3166 standard two-letter country code. | IN | |
ship-phone-number | The phone number associated with the ship-to address. |
080 3327 3000
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. | 11 Main St
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. | Apt. 12
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. | c/o Ramesh's Company
Note: This information will not be provided in order to comply with Amazon's privacy policy.
|
|
bill-city | The city of a standard address. |
Bangalore
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. |
KA
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. | 560055
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. |
IN
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. | 2012-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.in |