Zum Inhalt springen

SellerCentralGetOrders - SP-API

Version: v2

← SP-API Add-On Übersicht

Ruft Bestellungen aus Amazon SellerCentral ab.


Inputs

Das sind die Optionen, mit denen man den Step konfigurieren kann.

NameDatentypBeschreibungPflichtfeldWerte
accountACCOUNTIhr KontoJa
limitSTRINGBegrenzen Sie die Anzahl der Bestellungen.Nein
includedDataSTRINGLISTWählen Sie zusätzliche Daten aus, die im Ergebnis verfügbar sind.Nein
  • Besteller
  • Lieferadresse
  • Bestellumsatz, OrderItems-Umsatz
  • Kosten Bestellpositionen
  • Sonderangebote für Bestellpositionen
  • Stornierung von Bestellpositionen
  • Versand- und Lieferdetails
  • Bestellpakete
orderStatusSTRINGLISTFilter für Fulfillment-Status (Standard: Alle).Nein
  • Versandt
  • PendingAvailability
  • Ausstehend
  • Nicht versandt
  • Teilweise versandt
  • Storniert
  • Nicht erfüllbar
fulfillmentChannelSTRINGLISTFiltert Bestellungen nach Fulfillment-Kanal (Standard: Alle).Nein
  • Erfüllt durch Amazon (FBA)
  • Vom Verkäufer erfüllt (MFN)
marketplaceSTRINGLISTWählen Sie einen Marktplatz aus.Nein
  • Deutschland
  • USA
  • Vereinigtes Königreich Großbritannien
  • Australien
  • Kanada
  • Irland
  • Spanien
  • Japan
  • Frankreich
  • Belgien
  • Indien
  • Italien
  • Mexiko
  • Niederlande
  • Polen
  • Schweden
  • Vereinigte Arabische Emirate
  • Singapur
  • Türkei
createdAfterDATETIMEDatumsfilter, der Elemente zurückgibt, die nach einem bestimmten Datum erstellt wurden. (Wird häufig in Kombination mit der letzten Laufzeit des Flows verwendet.) Sie müssen mindestens den Filter „createdAfter” oder „lastupdatedAfter” verwenden.Nein
createdBeforeDATETIMEDatumsfilter, der Elemente zurückgibt, die vor einem bestimmten Datum erstellt wurden. (Wird häufig in Kombination mit dem aktuellen Zeitstempel verwendet.)Nein
lastupdatedAfterDATETIMEDatumsfilter, der Elemente zurückgibt, die nach einem bestimmten Datum aktualisiert wurden. (Wird häufig in Kombination mit der letzten Laufzeit des Ablaufs verwendet.) Sie müssen mindestens den Filter „createdAfter” oder „lastupdatedAfter” verwenden.Nein
lastupdatedBeforeDATETIMEDatumsfilter, der Elemente zurückgibt, die vor einem bestimmten Datum aktualisiert wurden. (Wird häufig in Kombination mit dem aktuellen Zeitstempel verwendet.)Nein
amazonOrderIdSTRINGEine AmazonOrderId ist eine von Amazon definierte Bestellkennung im Format 3-7-7.Nein

Outputs

Das sind die Ergebnisse des Steps, die von nachfolgenden Steps, nach der Ausführung verwendet werden können.

NameDatentypBeschreibungWerte
outputSPREADSHEETDas Ergebnis Spreadsheet.
Folgende Felder sind im Output enthalten:

FeldDatentypBeschreibungStandardwert
rowTypeSINGLEType of output row.
identifierSINGLEThe identifier column to import Spreadsheet into a Datastore.
parent_identifierSINGLEThe parent_identifier column to import Spreadsheet into a Datastore.
amazonOrderIdSINGLEAn Amazon-defined order identifier, in 3-7-7 format.
purchaseDateSINGLEThe date when the order was created.
lastUpdateDateSINGLEThe 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.
fulfillmentStatusSINGLEThe current order status.
fulfillmentChannelSINGLEWhether the order was fulfilled by Amazon (AFN) or by the seller (MFN).
earliestDeliveryDateSINGLEThe 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.
latestDeliveryDateSINGLEThe 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.
earliestShipDateSINGLEThe 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.
latestShipDateSINGLEThe 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.
shipmentServiceLevelCategorySINGLEThe shipment service level category of the order.Possible values: Expedited, FreeEconomy, NextDay, SameDay, SecondDay, Scheduled, Standard.
marketplaceIdSINGLE
salesChannelSINGLEThe sales channel of the first item in the order.
orderTypeMULTIPLEVALUE
isBusinessOrderSINGLEWhen true, the order is an Amazon Business order. An Amazon Business order is an order where the buyer is a Verified Business Buyer.
isPrimeSINGLEWhen true, the order is a seller-fulfilled Amazon Prime order.
isPremiumOrderSINGLEWhen 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_amountSINGLEThe total charge amount for this order.
orderTotal_currencyCodeSINGLEThe three-digit currency code of total charge for this order.
orderAliasIdsMAPMap of alternative identifiers that can be used to reference this order, such as seller-defined order numbers.
sellerOrderIdSINGLEA seller-defined order identifier.
shippingAddress_addressTypeSINGLEThe type of address.
shippingAddress_addressLine1SINGLEThe street of shipping address.
shippingAddress_addressLine2SINGLEAdditional street of shipping address information.
shippingAddress_addressLine3SINGLEAdditional street of shipping address information.
shippingAddress_citySINGLEThe city of shipping address.
shippingAddress_stateOrRegionSINGLEThe state or region of shipping address. Sometimes this field is populated instead of city.
shippingAddress_countryCodeSINGLEThe country code of shipping address. A two-character country code, in ISO 3166-1 alpha-2 format.
shippingAddress_countySINGLEThe county of shipping address.
shippingAddress_nameSINGLEThe shipping address name.
shippingAddress_phoneSINGLEThe shipping address phone number. Not returned for Fulfillment by Amazon (FBA) orders.
shippingAddress_postalCodeSINGLEThe postal code of shipping address.
shippingAddress_municipalitySINGLEThe municipality of shipping address.
deliveryPreference_addressInstructionSINGLE
deliveryPreference_deliveryCapabilitiesSINGLE
deliveryPreference_dropOffLocationSINGLE
associatedOrdersMAPOther orders that have a direct relationship to this order, such as replacement or exchange orders.
buyerInfo_buyerCompanyNameSINGLEThe company name of the buyer.
buyerInfo_buyerNameSINGLEThe name of the buyer.
buyerInfo_buyerEmailSINGLEdeprecated, field was removed from amazon sp api
buyerInfo_purchaseOrderNumberSINGLEThe purchase order (PO) number entered by the buyer at checkout. Returned only for orders where the buyer entered a PO number at checkout.
orderItem_orderItemIdSINGLEAn Amazon-defined order item identifier.
orderItem_quantityOrderedSINGLEThe number of items in the order.
orderItem_ASINSINGLEThe Amazon Standard Identification Number (ASIN) of the item.
orderItem_titleSINGLEThe name of the item.
orderItem_sellerSKUSINGLEThe seller stock keeping unit (SKU) of the item.
orderItem_conditionTypeSINGLEThe condition of the item. Possible values: New, Used, Collectible, Refurbished, Preorder, Club.
orderItem_conditionNoteSINGLEThe condition of the item as described by the seller.
orderItem_conditionSubtypeSINGLEThe subcondition of the item. Possible values: New, Mint, Very Good, Good, Acceptable, Poor, Club, OEM, Warranty, Refurbished Warranty, Refurbished, Open Box, Any, Other.
orderItem_buyerCustomizedURLSINGLEBuyer information for custom orders from the Amazon Custom program.
orderItem_isGiftSINGLEWhen true, the item is a gift.
orderItem_giftMessageTextSINGLEA gift message provided by the buyer.
orderItem_giftWrapLevelSINGLEThe gift wrap level specified by the buyer.
orderItem_quantityShippedSINGLEThe number of shipped items.
orderItem_quantityUnfulfilledSINGLEThe number of unfulfilled items.
orderItem_iossNumberSINGLEThe 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_earliestScheduledDeliveryWindowSINGLEThe beginning of the time period, in ISO 8601 format. Returned only for orders with a scheduled delivery window.
orderItem_latestScheduledDeliveryWindowSINGLEThe end of the time period, in ISO 8601 format. Returned only for orders with a scheduled delivery window.
orderItem_cashOnDeliverySINGLE
orderItem_palletDeliverySINGLE
orderItem_recipientAgeVerificationSINGLE
orderItem_recipientIdentityVerificationSINGLE
orderItem_signatureConfirmationSINGLE
orderItem_itemProceedsTotal_amountSINGLEThe total amount of the order item
orderItem_itemProceedsTotal_currencyCodeSINGLEThe three-digit currency code of item total amount.
orderItem_itemPrice_amountSINGLEThe selling price amount of the order item
orderItem_itemPrice_currencyCodeSINGLEThe three-digit currency code of item selling price amount.
orderItem_shippingPrice_amountSINGLEThe shippingPrice amount of the order item
orderItem_shippingPrice_currencyCodeSINGLEThe three-digit currency code of item shippingPrice amount.
orderItem_promotionDiscount_amountSINGLEThe promotionDiscount amount of the order item
orderItem_promotionDiscount_currencyCodeSINGLEThe three-digit currency code of item shippingPrice amount.
orderItem_CODFee_amountSINGLEThe CODFee amount of the order item
orderItem_CODFee_currencyCodeSINGLEThe three-digit currency code of item CODFee amount.
orderItem_giftWrapPrice_amountSINGLEThe giftWrapPrice amount of the order item
orderItem_giftWrapPrice_currencyCodeSINGLEThe three-digit currency code of item giftWrapPrice amount.
orderItem_itemTax_amountSINGLEThe tax amount of the order item
orderItem_itemTax_currencyCodeSINGLEThe three-digit currency code of item tax amount.
orderItem_shippingTax_amountSINGLEThe shipping tax amount of the order item
orderItem_shippingTax_currencyCodeSINGLEThe three-digit currency code of shipping tax amount.
orderItem_promotionDiscountTax_amountSINGLEThe promotion discount tax amount of the order item
orderItem_promotionDiscountTax_currencyCodeSINGLEThe three-digit currency code of promotion discount tax amount.
orderItem_CODFeeDiscount_amountSINGLEThe COD fee discount amount of the order item
orderItem_CODFeeDiscount_currencyCodeSINGLEThe three-digit currency code of COD fee discount amount.
orderItem_shippingDiscount_amountSINGLEThe shipping discount amount of the order item
orderItem_shippingDiscount_currencyCodeSINGLEThe three-digit currency code of shipping discount amount.
orderItem_promotionIdsMULTIPLEVALUEA list of promotion identifiers provided by the seller when the promotions were created.
orderItem_buyerCancelReasonSINGLEExplanation provided for why the cancellation was requested.
orderItem_cancelRequesterSINGLEEntity that initiated the cancellation request for this item.
package_referenceIdSINGLEA unique identifier for this package within the context of the order.
package_carrierSINGLEThe carrier responsible for transporting this package to the customer.
package_createdTimeSINGLEThe exact time when this shipping package was created and prepared for shipment.
package_shippingServiceSINGLEThe purchase order (PO) number entered by the buyer at checkout. Returned only for orders where the buyer entered a PO number at checkout.
package_trackingNumberSINGLEThe carrier-provided tracking number that customers can use to monitor the package's delivery progress.
package_shipTimeSINGLEThe exact time when this package was handed over to the carrier and began its journey to the customer.
package_statusSINGLECurrent status and detailed tracking information for a shipping package throughout the delivery process.
package_detailedStatusSINGLEGranular status information providing specific details about the package's current location and handling stage.
package_itemQuatitiesMAPA map of all order items included in this specific package and their quantities.
package_itemTransparencyCodesMAPA map of all order items included in this specific package and their transparency codes.