| rowType | SINGLE | Type of output row. | |
| identifier | SINGLE | The identifier column to import Spreadsheet into a Datastore. | |
| parent_identifier | SINGLE | The parent_identifier column to import Spreadsheet into a Datastore. | |
| amazonOrderId | SINGLE | An Amazon-defined order identifier, in 3-7-7 format. | |
| purchaseDate | SINGLE | The date when the order was created. | |
| lastUpdateDate | SINGLE | The date when the order was last updated.Note: LastUpdateDate is returned with an incorrect date for orders that were last updated before 2009-04-01. | |
| fulfillmentStatus | SINGLE | The current order status. | |
| fulfillmentChannel | SINGLE | Whether the order was fulfilled by Amazon (AFN) or by the seller (MFN). | |
| earliestDeliveryDate | SINGLE | The start of the time period within which you have committed to fulfill the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders. | |
| latestDeliveryDate | SINGLE | The end of the time period within which you have committed to fulfill the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders that do not have a PendingAvailability, Pending, or Canceled status. | |
| earliestShipDate | SINGLE | The start of the time period within which you have committed to ship the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders.Note: EarliestShipDate might not be returned for orders placed before February 1, 2013. | |
| latestShipDate | SINGLE | The end of the time period within which you have committed to ship the order.In ISO 8601 date time format. Returned only for seller-fulfilled orders.Note: LatestShipDate might not be returned for orders placed before February 1, 2013. | |
| shipmentServiceLevelCategory | SINGLE | The shipment service level category of the order.Possible values: Expedited, FreeEconomy, NextDay, SameDay, SecondDay, Scheduled, Standard. | |
| marketplaceId | SINGLE | | |
| salesChannel | SINGLE | The sales channel of the first item in the order. | |
| orderType | MULTIPLEVALUE | | |
| isBusinessOrder | SINGLE | When true, the order is an Amazon Business order. An Amazon Business order is an order where the buyer is a Verified Business Buyer. | |
| isPrime | SINGLE | When true, the order is a seller-fulfilled Amazon Prime order. | |
| isPremiumOrder | SINGLE | When true, the order has a Premium Shipping Service Level Agreement. For more information about Premium Shipping orders, see "Premium Shipping Options" in the Seller Central Help for your marketplace. | |
| orderTotal_amount | SINGLE | The total charge amount for this order. | |
| orderTotal_currencyCode | SINGLE | The three-digit currency code of total charge for this order. | |
| orderAliasIds | MAP | Map of alternative identifiers that can be used to reference this order, such as seller-defined order numbers. | |
| sellerOrderId | SINGLE | A seller-defined order identifier. | |
| shippingAddress_addressType | SINGLE | The type of address. | |
| shippingAddress_addressLine1 | SINGLE | The street of shipping address. | |
| shippingAddress_addressLine2 | SINGLE | Additional street of shipping address information. | |
| shippingAddress_addressLine3 | SINGLE | Additional street of shipping address information. | |
| shippingAddress_city | SINGLE | The city of shipping address. | |
| shippingAddress_stateOrRegion | SINGLE | The state or region of shipping address. Sometimes this field is populated instead of city. | |
| shippingAddress_countryCode | SINGLE | The country code of shipping address. A two-character country code, in ISO 3166-1 alpha-2 format. | |
| shippingAddress_county | SINGLE | The county of shipping address. | |
| shippingAddress_name | SINGLE | The shipping address name. | |
| shippingAddress_phone | SINGLE | The shipping address phone number. Not returned for Fulfillment by Amazon (FBA) orders. | |
| shippingAddress_postalCode | SINGLE | The postal code of shipping address. | |
| shippingAddress_municipality | SINGLE | The municipality of shipping address. | |
| deliveryPreference_addressInstruction | SINGLE | | |
| deliveryPreference_deliveryCapabilities | SINGLE | | |
| deliveryPreference_dropOffLocation | SINGLE | | |
| associatedOrders | MAP | Other orders that have a direct relationship to this order, such as replacement or exchange orders. | |
| buyerInfo_buyerCompanyName | SINGLE | The company name of the buyer. | |
| buyerInfo_buyerName | SINGLE | The name of the buyer. | |
| buyerInfo_buyerEmail | SINGLE | deprecated, field was removed from amazon sp api | |
| buyerInfo_purchaseOrderNumber | SINGLE | The purchase order (PO) number entered by the buyer at checkout. Returned only for orders where the buyer entered a PO number at checkout. | |
| orderItem_orderItemId | SINGLE | An Amazon-defined order item identifier. | |
| orderItem_quantityOrdered | SINGLE | The number of items in the order. | |
| orderItem_ASIN | SINGLE | The Amazon Standard Identification Number (ASIN) of the item. | |
| orderItem_title | SINGLE | The name of the item. | |
| orderItem_sellerSKU | SINGLE | The seller stock keeping unit (SKU) of the item. | |
| orderItem_conditionType | SINGLE | The condition of the item. Possible values: New, Used, Collectible, Refurbished, Preorder, Club. | |
| orderItem_conditionNote | SINGLE | The condition of the item as described by the seller. | |
| orderItem_conditionSubtype | SINGLE | The subcondition of the item. Possible values: New, Mint, Very Good, Good, Acceptable, Poor, Club, OEM, Warranty, Refurbished Warranty, Refurbished, Open Box, Any, Other. | |
| orderItem_buyerCustomizedURL | SINGLE | Buyer information for custom orders from the Amazon Custom program. | |
| orderItem_isGift | SINGLE | When true, the item is a gift. | |
| orderItem_giftMessageText | SINGLE | A gift message provided by the buyer. | |
| orderItem_giftWrapLevel | SINGLE | The gift wrap level specified by the buyer. | |
| orderItem_quantityShipped | SINGLE | The number of shipped items. | |
| orderItem_quantityUnfulfilled | SINGLE | The number of unfulfilled items. | |
| orderItem_iossNumber | SINGLE | The IOSS number for the marketplace. Sellers shipping to the European Union (EU) from outside of the EU must provide this IOSS number to their carrier when Amazon has collected the VAT on the sale. | |
| orderItem_earliestScheduledDeliveryWindow | SINGLE | The beginning of the time period, in ISO 8601 format. Returned only for orders with a scheduled delivery window. | |
| orderItem_latestScheduledDeliveryWindow | SINGLE | The end of the time period, in ISO 8601 format. Returned only for orders with a scheduled delivery window. | |
| orderItem_cashOnDelivery | SINGLE | | |
| orderItem_palletDelivery | SINGLE | | |
| orderItem_recipientAgeVerification | SINGLE | | |
| orderItem_recipientIdentityVerification | SINGLE | | |
| orderItem_signatureConfirmation | SINGLE | | |
| orderItem_itemProceedsTotal_amount | SINGLE | The total amount of the order item | |
| orderItem_itemProceedsTotal_currencyCode | SINGLE | The three-digit currency code of item total amount. | |
| orderItem_itemPrice_amount | SINGLE | The selling price amount of the order item | |
| orderItem_itemPrice_currencyCode | SINGLE | The three-digit currency code of item selling price amount. | |
| orderItem_shippingPrice_amount | SINGLE | The shippingPrice amount of the order item | |
| orderItem_shippingPrice_currencyCode | SINGLE | The three-digit currency code of item shippingPrice amount. | |
| orderItem_promotionDiscount_amount | SINGLE | The promotionDiscount amount of the order item | |
| orderItem_promotionDiscount_currencyCode | SINGLE | The three-digit currency code of item shippingPrice amount. | |
| orderItem_CODFee_amount | SINGLE | The CODFee amount of the order item | |
| orderItem_CODFee_currencyCode | SINGLE | The three-digit currency code of item CODFee amount. | |
| orderItem_giftWrapPrice_amount | SINGLE | The giftWrapPrice amount of the order item | |
| orderItem_giftWrapPrice_currencyCode | SINGLE | The three-digit currency code of item giftWrapPrice amount. | |
| orderItem_itemTax_amount | SINGLE | The tax amount of the order item | |
| orderItem_itemTax_currencyCode | SINGLE | The three-digit currency code of item tax amount. | |
| orderItem_shippingTax_amount | SINGLE | The shipping tax amount of the order item | |
| orderItem_shippingTax_currencyCode | SINGLE | The three-digit currency code of shipping tax amount. | |
| orderItem_promotionDiscountTax_amount | SINGLE | The promotion discount tax amount of the order item | |
| orderItem_promotionDiscountTax_currencyCode | SINGLE | The three-digit currency code of promotion discount tax amount. | |
| orderItem_CODFeeDiscount_amount | SINGLE | The COD fee discount amount of the order item | |
| orderItem_CODFeeDiscount_currencyCode | SINGLE | The three-digit currency code of COD fee discount amount. | |
| orderItem_shippingDiscount_amount | SINGLE | The shipping discount amount of the order item | |
| orderItem_shippingDiscount_currencyCode | SINGLE | The three-digit currency code of shipping discount amount. | |
| orderItem_promotionIds | MULTIPLEVALUE | A list of promotion identifiers provided by the seller when the promotions were created. | |
| orderItem_buyerCancelReason | SINGLE | Explanation provided for why the cancellation was requested. | |
| orderItem_cancelRequester | SINGLE | Entity that initiated the cancellation request for this item. | |
| package_referenceId | SINGLE | A unique identifier for this package within the context of the order. | |
| package_carrier | SINGLE | The carrier responsible for transporting this package to the customer. | |
| package_createdTime | SINGLE | The exact time when this shipping package was created and prepared for shipment. | |
| package_shippingService | SINGLE | The purchase order (PO) number entered by the buyer at checkout. Returned only for orders where the buyer entered a PO number at checkout. | |
| package_trackingNumber | SINGLE | The carrier-provided tracking number that customers can use to monitor the package's delivery progress. | |
| package_shipTime | SINGLE | The exact time when this package was handed over to the carrier and began its journey to the customer. | |
| package_status | SINGLE | Current status and detailed tracking information for a shipping package throughout the delivery process. | |
| package_detailedStatus | SINGLE | Granular status information providing specific details about the package's current location and handling stage. | |
| package_itemQuatities | MAP | A map of all order items included in this specific package and their quantities. | |
| package_itemTransparencyCodes | MAP | A map of all order items included in this specific package and their transparency codes. | |