Amazon orders: Null State Codes

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.

Amazon orders- Null State Codes 1

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