rowType | SINGLE | Type of output row. | Nein | |
identifier | SINGLE | The identifier column to import Spreadsheet into a Datastore. | Nein | |
amazonOrderId | SINGLE | An Amazon-defined order identifier, in 3-7-7 format. | Nein | |
orderStatus | SINGLE | The current order status. | Nein | |
marketplaceId | SINGLE | | Nein | |
salesChannel | SINGLE | The sales channel of the first item in the order. | Nein | |
orderChannel | SINGLE | The order channel of the first item in the order. | Nein | |
fulfillmentChannel | SINGLE | Whether the order was fulfilled by Amazon (AFN) or by the seller (MFN). | Nein | |
fulfillmentInstructionSupplySourceId | SINGLE | | Nein | |
purchaseDate | SINGLE | The date when the order was created. | Nein | |
orderType | SINGLE | | Nein | |
orderTotal_amount | SINGLE | The total charge amount for this order. | Nein | |
orderTotal_currencyCode | SINGLE | The three-digit currency code of total charge for this order. | Nein | |
cbaDisplayableShippingLabel | SINGLE | Custom ship label for Checkout by Amazon (CBA). | Nein | |
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. | Nein | |
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. | Nein | |
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. | Nein | |
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. | Nein | |
isEstimatedShipDateSet | SINGLE | When true, the estimated ship date is set for the order. Returned only for Sourcing on Demand orders. | Nein | |
easyShipShipmentStatus | SINGLE | The status of the Amazon Easy Ship order. This property is included only for Amazon Easy Ship orders.Possible values: PendingPickUp, LabelCanceled, PickedUp, OutForDelivery, Damaged, Delivered, RejectedByBuyer, Undeliverable, ReturnedToSeller, ReturningToSeller. | Nein | |
isGlobalExpressEnabled | SINGLE | When true, the order is a GlobalExpress order. | Nein | |
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. | Nein | |
numberOfItemsShipped | SINGLE | The number of items shipped. | Nein | |
numberOfItemsUnshipped | SINGLE | The number of items unshipped. | Nein | |
paymentMethod | SINGLE | The payment method for the order. This property is limited to Cash On Delivery (COD) and Convenience Store (CVS) payment methods. | Nein | |
promiseResponseDueDate | SINGLE | Indicates the date by which the seller must respond to the buyer with an estimated ship date. Returned only for Sourcing on Demand orders. | Nein | |
isReplacementOrder | SINGLE | When true, this is a replacement order. | Nein | |
replacedOrderId | SINGLE | The order ID value for the order that is being replaced. Returned only if IsReplacementOrder = true. | Nein | |
sellerOrderId | SINGLE | A seller-defined order identifier. | Nein | |
shipmentServiceLevelCategory | SINGLE | The shipment service level category of the order.Possible values: Expedited, FreeEconomy, NextDay, SameDay, SecondDay, Scheduled, Standard. | Nein | |
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. | Nein | |
isPrime | SINGLE | When true, the order is a seller-fulfilled Amazon Prime order. | Nein | |
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. | Nein | |
isSoldByAB | SINGLE | When true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU). By buying and instantly re-selling your items, ABEU becomes the seller of record, making your inventory available for sale to customers who would not otherwise purchase from a third-party seller. | Nein | |
isISPU | SINGLE | When true, this order is marked to be picked up from a store rather than delivered. | Nein | |
paymentExecutionDetail | MAP | Information about sub-payment methods for a Cash On Delivery (COD) order.Note: For a COD order that is paid for using one sub-payment method, one PaymentExecutionDetailItem object is returned, with PaymentExecutionDetailItem/PaymentMethod = COD. For a COD order that is paid for using multiple sub-payment methods, two or more PaymentExecutionDetailItem objects are returned. | Nein | |
paymentMethodDetails | MULTIPLEVALUE | A list of payment methods for the order. | Nein | |
defaultShipFromLocationAddress_addressLine1 | SINGLE | The street of default ship from location address. | Nein | |
defaultShipFromLocationAddress_addressLine2 | SINGLE | Additional street of default ship from location address information. | Nein | |
defaultShipFromLocationAddress_addressLine3 | SINGLE | Additional street of default ship from location address information. | Nein | |
defaultShipFromLocationAddress_city | SINGLE | The city of default ship from location address. | Nein | |
defaultShipFromLocationAddress_stateOrRegion | SINGLE | The state or region of default ship from location address. Sometimes this field is populated instead of city. | Nein | |
defaultShipFromLocationAddress_countryCode | SINGLE | The country code of default ship from location address. A two-character country code, in ISO 3166-1 alpha-2 format. | Nein | |
defaultShipFromLocationAddress_county | SINGLE | The county of default ship from location address. | Nein | |
defaultShipFromLocationAddress_district | SINGLE | The district of default ship from location address. | Nein | |
defaultShipFromLocationAddress_name | SINGLE | The default ship from location address name. | Nein | |
defaultShipFromLocationAddress_phone | SINGLE | The default ship from location address phone number. Not returned for Fulfillment by Amazon (FBA) orders. | Nein | |
defaultShipFromLocationAddress_postalCode | SINGLE | The postal code of default ship from location address. | Nein | |
defaultShipFromLocationAddress_municipality | SINGLE | The municipality of default ship from location address. | Nein | |
shippingAddress_addressLine1 | SINGLE | The street of shipping address. | Nein | |
shippingAddress_addressLine2 | SINGLE | Additional street of shipping address information. | Nein | |
shippingAddress_addressLine3 | SINGLE | Additional street of shipping address information. | Nein | |
shippingAddress_city | SINGLE | The city of shipping address. | Nein | |
shippingAddress_stateOrRegion | SINGLE | The state or region of shipping address. Sometimes this field is populated instead of city. | Nein | |
shippingAddress_countryCode | SINGLE | The country code of shipping address. A two-character country code, in ISO 3166-1 alpha-2 format. | Nein | |
shippingAddress_county | SINGLE | The county of shipping address. | Nein | |
shippingAddress_district | SINGLE | The district of shipping address. | Nein | |
shippingAddress_name | SINGLE | The shipping address name. | Nein | |
shippingAddress_phone | SINGLE | The shipping address phone number. Not returned for Fulfillment by Amazon (FBA) orders. | Nein | |
shippingAddress_postalCode | SINGLE | The postal code of shipping address. | Nein | |
shippingAddress_municipality | SINGLE | The municipality of shipping address. | Nein | |
buyerInfo_buyerCounty | SINGLE | The county of the buyer. | Nein | |
buyerInfo_buyerName | SINGLE | The name of the buyer. | Nein | |
buyerInfo_buyerEmail | SINGLE | The anonymized email address of the buyer. | Nein | |
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. | Nein | |
buyerInfo_taxInfoCompanyLegalName | SINGLE | The Tax information about the buyers legal company name. | Nein | |
buyerInfo_taxInfoTaxingRegion | SINGLE | The country or region imposing the tax. | Nein | |
parent_identifier | SINGLE | The parent_identifier column to import Spreadsheet into a Datastore. | Nein | |
orderItem_orderItemId | SINGLE | An Amazon-defined order item identifier. | Nein | |
orderItem_ASIN | SINGLE | The Amazon Standard Identification Number (ASIN) of the item. | Nein | |
orderItem_title | SINGLE | The name of the item. | Nein | |
orderItem_sellerSKU | SINGLE | The seller stock keeping unit (SKU) of the item. | Nein | |
orderItem_itemPrice_amount | SINGLE | The selling price amount of the order item | Nein | |
orderItem_itemPrice_currencyCode | SINGLE | The three-digit currency code of item selling price amount. | Nein | |
orderItem_itemTax_amount | SINGLE | The tax amount of the order item | Nein | |
orderItem_itemTax_currencyCode | SINGLE | The three-digit currency code of item tax amount. | Nein | |
orderItem_quantityOrdered | SINGLE | The number of items in the order. | Nein | |
orderItem_quantityShipped | SINGLE | The number of items shipped. | Nein | |
orderItem_conditionId | SINGLE | The condition of the item. Possible values: New, Used, Collectible, Refurbished, Preorder, Club. | Nein | |
orderItem_conditionNote | SINGLE | The condition of the item as described by the seller. | Nein | |
orderItem_conditionSubtypeId | 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. | Nein | |
orderItem_isGift | SINGLE | When true, the item is a gift. | Nein | |
orderItem_isSerialNumberRequired | SINGLE | When true, the product type for this item has a serial number. Returned only for Amazon Easy Ship orders. | Nein | |
orderItem_isTransparency | SINGLE | When true, transparency codes are required. | Nein | |
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. | Nein | |
orderItem_priceDesignation | SINGLE | Indicates that the selling price is a special price that is available only for Amazon Business orders. For more information about the Amazon Business Seller Program, see the Amazon Business website.Possible values: BusinessPrice - A special price that is available only for Amazon Business orders. | Nein | |
orderItem_scheduledDeliveryStartDate | SINGLE | The start date of the scheduled delivery window in the time zone of the order destination. In ISO 8601 date time format. | Nein | |
orderItem_scheduledDeliveryEndDate | SINGLE | The end date of the scheduled delivery window in the time zone of the order destination. In ISO 8601 date time format. | Nein | |
orderItem_deemedResellerCategory | SINGLE | The category of deemed reseller. This applies to selling partners that are not based in the EU and is used to help them meet the VAT Deemed Reseller tax laws in the EU and UK. | Nein | |
orderItem_storeChainStoreId | SINGLE | The store chain store identifier. Linked to a specific store in a store chain. | Nein | |
orderItem_shippingPrice_amount | SINGLE | The shipping price of the order item | Nein | |
orderItem_shippingPrice_currencyCode | SINGLE | The three-digit currency code of shipping price amount. | Nein | |
orderItem_shippingTax_amount | SINGLE | The shipping tax amount of the order item | Nein | |
orderItem_shippingTax_currencyCode | SINGLE | The three-digit currency code of shipping tax amount. | Nein | |
orderItem_shippingDiscount_amount | SINGLE | The shipping discount amount of the order item | Nein | |
orderItem_shippingDiscount_currencyCode | SINGLE | The three-digit currency code of shipping discount amount. | Nein | |
orderItem_shippingDiscountTax_amount | SINGLE | The shipping discount tax amount of the order item | Nein | |
orderItem_shippingDiscountTax_currencyCode | SINGLE | The three-digit currency code of shipping discount tax amount. | Nein | |
orderItem_promotionDiscount_amount | SINGLE | The promotion discount amount of the order item | Nein | |
orderItem_promotionDiscount_currencyCode | SINGLE | The three-digit currency code of promotion discount amount. | Nein | |
orderItem_promotionDiscountTax_amount | SINGLE | The promotion discount tax amount of the order item | Nein | |
orderItem_promotionDiscountTax_currencyCode | SINGLE | The three-digit currency code of promotion discount tax amount. | Nein | |
orderItem_CODFee_amount | SINGLE | The fee charged for COD service. | Nein | |
orderItem_CODFee_currencyCode | SINGLE | The three-digit currency code of fee charged for COD service. | Nein | |
orderItem_CODFeeDiscount_amount | SINGLE | The discount on the COD fee. | Nein | |
orderItem_CODFeeDiscount_currencyCode | SINGLE | The three-digit currency code of discount on the COD fee. | Nein | |
orderItem_productInfoDetail_numberOfItems | SINGLE | The total number of items that are included in the ASIN. | Nein | |
orderItem_promotionIds | MULTIPLEVALUE | A list of promotion identifiers provided by the seller when the promotions were created. | Nein | |
orderItem_pointsGranted | SINGLE | The number and value of Amazon Points granted with the purchase of an item. | Nein | |
orderItem_pointsMonetaryValue_amount | SINGLE | The monetary value of the Amazon Points granted. | Nein | |
orderItem_pointsMonetaryValue_currencyCode | SINGLE | The three-digit currency code of monetary value (Amazon Points granted). | Nein | |
orderItem_isBuyerRequestedCancel | SINGLE | When true, the buyer has requested cancellation. | Nein | |
orderItem_buyerCancelReason | SINGLE | The reason that the buyer requested cancellation. | Nein | |
orderItem_buyerCustomizedURL | SINGLE | Buyer information for custom orders from the Amazon Custom program. | Nein | |
orderItem_giftMessageText | SINGLE | A gift message provided by the buyer. | Nein | |
orderItem_giftWrapLevel | SINGLE | The gift wrap level specified by the buyer. | Nein | |
orderItem_giftWrapPrice_amount | SINGLE | The gift wrap price amount of the item. | Nein | |
orderItem_giftWrapPrice_currencyCode | SINGLE | The gift wrap price currency code of the item. | Nein | |
orderItem_giftWrapTax_amount | SINGLE | The tax amount on the gift wrap price. | Nein | |
orderItem_giftWrapTax_currencyCode | SINGLE | The tax amount currency code on the gift wrap price. | Nein | |