Skip to content

commercetoolsGetOrders - commercetools

← commercetools Add-On Übersicht

Fetch orders from commercetools.


Inputs

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

Name Datentyp Beschreibung Pflichtfeld Werte
account ACCOUNT commercetools API account Nein
limit STRING Limit number of orders. Nein

Outputs

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

Name Datentyp Beschreibung Werte
orders SPREADSHEET commercetools Orders
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Standardwert
identifier SINGLE
parent_identifier SINGLE
order_type SINGLE
order_id SINGLE
order_version SINGLE
order_versionModifiedAt SINGLE
order_lastMessageSequenceNumber SINGLE
order_createdAt SINGLE
order_lastModifiedAt SINGLE
order_lastModifiedBy_isPlatformClient SINGLE
order_lastModifiedBy_user SINGLE
order_createdBy_isPlatformClient SINGLE
order_createdBy_user SINGLE
order_customerId SINGLE
order_customerEmail SINGLE
order_totalPrice_type SINGLE
order_totalPrice_currencyCode SINGLE
order_totalPrice_centAmount SINGLE
order_totalPrice_fractionDigits SINGLE
order_country SINGLE
order_orderState SINGLE
order_syncInfo SINGLE
order_returnInfo SINGLE
order_taxMode SINGLE
order_inventoryMode SINGLE
order_taxRoundingMode SINGLE
order_taxCalculationMode SINGLE
order_origin SINGLE
order_shippingMode SINGLE
order_shippingAddress_id SINGLE
order_shippingAddress_firstName SINGLE
order_shippingAddress_lastName SINGLE
order_shippingAddress_streetName SINGLE
order_shippingAddress_streetNumber SINGLE
order_shippingAddress_additionalStreetInfo SINGLE
order_shippingAddress_postalCode SINGLE
order_shippingAddress_city SINGLE
order_shippingAddress_region SINGLE
order_shippingAddress_state SINGLE
order_shippingAddress_country SINGLE
order_shippingAddress_company SINGLE
order_shippingAddress_phone SINGLE
order_shippingAddress_email SINGLE
order_shippingAddress_additionalAddressInfo SINGLE
order_shipping SINGLE
order_lineItems SINGLE
order_customLineItems SINGLE
order_transactionFee SINGLE
order_discountCodes SINGLE
order_directDiscounts SINGLE
order_cart_typeId SINGLE
order_cart_id SINGLE
order_billingAddress_id SINGLE
order_billingAddress_firstName SINGLE
order_billingAddress_lastName SINGLE
order_billingAddress_streetName SINGLE
order_billingAddress_streetNumber SINGLE
order_billingAddress_additionalStreetInfo SINGLE
order_billingAddress_postalCode SINGLE
order_billingAddress_city SINGLE
order_billingAddress_region SINGLE
order_billingAddress_state SINGLE
order_billingAddress_country SINGLE
order_billingAddress_company SINGLE
order_billingAddress_phone SINGLE
order_billingAddress_email SINGLE
order_billingAddress_additionalAddressInfo SINGLE
order_itemShippingAddresses SINGLE
order_refusedGifts SINGLE
order_store_typeId SINGLE
order_store_key SINGLE
order_taxedPrice_totalNet.type SINGLE
order_taxedPrice_totalNet.currencyCode SINGLE
order_taxedPrice_totalNet.centAmount SINGLE
order_taxedPrice_totalNet.fractionDigits SINGLE
order_taxedPrice_totalGross.type SINGLE
order_taxedPrice_totalGross.currencyCode SINGLE
order_taxedPrice_totalGross.centAmount SINGLE
order_taxedPrice_totalGross.fractionDigits SINGLE
order_taxedPrice_taxPortions[0].rate SINGLE
order_taxedPrice_taxPortions[0].amount.type SINGLE
order_taxedPrice_taxPortions[0].amount.currencyCode SINGLE
order_taxedPrice_taxPortions[0].amount.centAmount SINGLE
order_taxedPrice_taxPortions[0].amount.fractionDigits SINGLE
order_taxedPrice_taxPortions[0].name SINGLE
order_taxedPrice_totalTax.type SINGLE
order_taxedPrice_totalTax.currencyCode SINGLE
order_taxedPrice_totalTax.centAmount SINGLE
order_taxedPrice_totalTax.fractionDigits SINGLE
order_taxedShippingPrice_totalNet.type SINGLE
order_taxedShippingPrice_totalNet.currencyCode SINGLE
order_taxedShippingPrice_totalNet.centAmount SINGLE
order_taxedShippingPrice_totalNet.fractionDigits SINGLE
order_taxedShippingPrice_totalGross.type SINGLE
order_taxedShippingPrice_totalGross.currencyCode SINGLE
order_taxedShippingPrice_totalGross.centAmount SINGLE
order_taxedShippingPrice_totalGross.fractionDigits SINGLE
order_taxedShippingPrice_taxPortions[0].rate SINGLE
order_taxedShippingPrice_taxPortions[0].amount.type SINGLE
order_taxedShippingPrice_taxPortions[0].amount.currencyCode SINGLE
order_taxedShippingPrice_taxPortions[0].amount.centAmount SINGLE
order_taxedShippingPrice_taxPortions[0].amount.fractionDigits SINGLE
order_taxedShippingPrice_taxPortions[0].name SINGLE
order_taxedShippingPrice_totalTax.type SINGLE
order_taxedShippingPrice_totalTax.currencyCode SINGLE
order_taxedShippingPrice_totalTax.centAmount SINGLE
order_taxedShippingPrice_totalTax.fractionDigits SINGLE
order_shippingInfo_shippingMethodName SINGLE
order_shippingInfo_price.type SINGLE
order_shippingInfo_price.currencyCode SINGLE
order_shippingInfo_price.centAmount SINGLE
order_shippingInfo_price.fractionDigits SINGLE
order_shippingInfo_shippingRate.price.type SINGLE
order_shippingInfo_shippingRate.price.currencyCode SINGLE
order_shippingInfo_shippingRate.price.centAmount SINGLE
order_shippingInfo_shippingRate.price.fractionDigits SINGLE
order_shippingInfo_shippingRate.freeAbove.type SINGLE
order_shippingInfo_shippingRate.freeAbove.currencyCode SINGLE
order_shippingInfo_shippingRate.freeAbove.centAmount SINGLE
order_shippingInfo_shippingRate.freeAbove.fractionDigits SINGLE
order_shippingInfo_shippingRate.tiers SINGLE
order_shippingInfo_taxRate.name SINGLE
order_shippingInfo_taxRate.amount SINGLE
order_shippingInfo_taxRate.includedInPrice SINGLE
order_shippingInfo_taxRate.country SINGLE
order_shippingInfo_taxRate.id SINGLE
order_shippingInfo_taxRate.subRates SINGLE
order_shippingInfo_taxCategory.typeId SINGLE
order_shippingInfo_taxCategory.id SINGLE
order_shippingInfo_deliveries SINGLE
order_shippingInfo_shippingMethod.typeId SINGLE
order_shippingInfo_shippingMethod.id SINGLE
order_shippingInfo_taxedPrice.totalNet.type SINGLE
order_shippingInfo_taxedPrice.totalNet.currencyCode SINGLE
order_shippingInfo_taxedPrice.totalNet.centAmount SINGLE
order_shippingInfo_taxedPrice.totalNet.fractionDigits SINGLE
order_shippingInfo_taxedPrice.totalGross.type SINGLE
order_shippingInfo_taxedPrice.totalGross.currencyCode SINGLE
order_shippingInfo_taxedPrice.totalGross.centAmount SINGLE
order_shippingInfo_taxedPrice.totalGross.fractionDigits SINGLE
order_shippingInfo_taxedPrice.totalTax.type SINGLE
order_shippingInfo_taxedPrice.totalTax.currencyCode SINGLE
order_shippingInfo_taxedPrice.totalTax.centAmount SINGLE
order_shippingInfo_taxedPrice.totalTax.fractionDigits SINGLE
order_shippingInfo_shippingMethodState SINGLE
orderitem_id SINGLE
orderitem_productId SINGLE
orderitem_productKey SINGLE
orderitem_name.de-DE SINGLE
orderitem_productType.typeId SINGLE
orderitem_productType.id SINGLE
orderitem_productType.version SINGLE
orderitem_productSlug.de-DE SINGLE
orderitem_variant.id SINGLE
orderitem_variant.sku SINGLE
orderitem_variant.key SINGLE
orderitem_variant.prices[0].id SINGLE
orderitem_variant.prices[0].value.type SINGLE
orderitem_variant.prices[0].value.currencyCode SINGLE
orderitem_variant.prices[0].value.centAmount SINGLE
orderitem_variant.prices[0].value.fractionDigits SINGLE
orderitem_variant.prices[0].key SINGLE
orderitem_variant.prices[0].country SINGLE
orderitem_variant.images SINGLE
orderitem_variant.attributes[0].name SINGLE
orderitem_variant.attributes[0].value SINGLE
orderitem_variant.assets SINGLE
orderitem_variant.availability.isOnStock SINGLE
orderitem_variant.availability.availableQuantity SINGLE
orderitem_variant.availability.version SINGLE
orderitem_variant.availability.id SINGLE
orderitem_price.id SINGLE
orderitem_price.value.type SINGLE
orderitem_price.value.currencyCode SINGLE
orderitem_price.value.centAmount SINGLE
orderitem_price.value.fractionDigits SINGLE
orderitem_price.key SINGLE
orderitem_price.country SINGLE
orderitem_quantity SINGLE
orderitem_discountedPricePerQuantity SINGLE
orderitem_taxRate.name SINGLE
orderitem_taxRate.amount SINGLE
orderitem_taxRate.includedInPrice SINGLE
orderitem_taxRate.country SINGLE
orderitem_taxRate.id SINGLE
orderitem_taxRate.subRates SINGLE
orderitem_perMethodTaxRate SINGLE
orderitem_addedAt SINGLE
orderitem_lastModifiedAt SINGLE
orderitem_state[0].quantity SINGLE
orderitem_state[0].state.typeId SINGLE
orderitem_state[0].state.id SINGLE
orderitem_priceMode SINGLE
orderitem_lineItemMode SINGLE
orderitem_totalPrice.type SINGLE
orderitem_totalPrice.currencyCode SINGLE
orderitem_totalPrice.centAmount SINGLE
orderitem_totalPrice.fractionDigits SINGLE
orderitem_taxedPrice.totalNet.type SINGLE
orderitem_taxedPrice.totalNet.currencyCode SINGLE
orderitem_taxedPrice.totalNet.centAmount SINGLE
orderitem_taxedPrice.totalNet.fractionDigits SINGLE
orderitem_taxedPrice.totalGross.type SINGLE
orderitem_taxedPrice.totalGross.currencyCode SINGLE
orderitem_taxedPrice.totalGross.centAmount SINGLE
orderitem_taxedPrice.totalGross.fractionDigits SINGLE
orderitem_taxedPrice.totalTax.type SINGLE
orderitem_taxedPrice.totalTax.currencyCode SINGLE
orderitem_taxedPrice.totalTax.centAmount SINGLE
orderitem_taxedPrice.totalTax.fractionDigits SINGLE
orderitem_taxedPricePortions SINGLE