{{item.notificationType}}:

PlentySearchOrders

Auftragsdaten abfragen

ext. Version: REST 1.0

Get Orders from a plentymarkets System.

Dokumentation im Handbuch aufrufen

Warum Synesty?

  • Zentrale Middleware für Anbindungen, Datenfeeds & Schnittstellen zur Automatisierung von Geschäftsprozessen
  • Keine Programmierkenntnisse notwendig - nur Drag&Drop und Konfiguration
  • Schneller und professioneller Support
Kostenlos testen Demo anfragen

Warum Synesty?

  • Zentrale Middleware für Anbindungen, Datenfeeds & Schnittstellen zur Automatisierung von Geschäftsprozessen
  • Keine Programmierkenntnisse notwendig - nur Drag&Drop und Konfiguration
  • Schneller und professioneller Support
Kostenlos testen Demo anfragen

Inputs

Name Datentyp Beschreibung Pflichtfeld Werte
account ACCOUNT Your account Ja
limitItems STRING Limit the number of fetched orders. Leave empty for unlimited. Nein Standardwert: 25
Order Type (type) STRINGLIST Filter order type. Nein
  • Sales order (Standardwert)
  • Delivery
  • Returns
  • Credit note
  • Warranty
  • Repair
  • Offer
  • Advance order
  • Multi-order
  • Multi credit note
  • Reorder
  • Redistribution
Last Update From (orderLastUpdateFrom) DATETIME LastUpdateFrom date to filter the orders, e.g. 2012-02-03 16:00 Nein
Last Update To (orderLastUpdateTo) DATETIME Filter to Date, e.g. 2012-02-05 16:00. Leave empty to filter until now. Nein
Insert Date From (orderInsertDateFrom) DATETIME InsertDateFrom date to filter the orders, e.g. 2012-02-01 16:00 Nein
Insert Date To (orderInsertDateTo) DATETIME Filter InsertDate to, e.g. 2012-02-06 16:00. Leave empty to filter until now. Nein
Completed Date From (orderCompletedDateFrom) DATETIME OrderCompleted date to filter the orders, e.g. 2012-02-01 16:00 Nein
Completed Date To (orderCompletedDateTo) DATETIME Filter OrderCompleted date to, e.g. 2012-02-06 16:00. Leave empty to filter until now. Nein
Referrer ID (referrerID) STRING Filter for plenty referrerID. Leave empty to select all. Nein
Order ID (orderID) STRING Filter for plentymarkets single Order ID or comma separated list of Order IDs. If you enter an Order ID, all other filters will be ignored. Nein
Order IDs SPREADSHEET (orderIdSpreadsheet) SPREADSHEET SPREADSHEET containing Order IDs. If you provide an Order ID SPREADSHEET all other filter options will be ignored. Nein
Order IDs mappingdefinition (mappingDefinition) STRING The mapping definition JSON String Nein
Folgende Felder sind zu konfigurieren:

Feld Beschreibung Datentyp Pflichtfeld Standardwert
OrderID Ganzzahl
ExternalOrderID Text
Contact ID (contactID) STRING Filter that restricts the search result to orders of one order contact. The id of the contact must be specified. Nein
External Order ID (externalOrderID) STRING Filter for plenty externalOrderID. Leave empty to select all. Nein
Order Status (orderStatus) STRING Filter for plenty order status. Leave empty to select all. Nein
Order Status From (orderStatusFrom) STRING Filter for plenty order status. Leave empty to select all. Nein
Order Status To (orderStatusTo) STRING Filter for plenty order status. Leave empty to select all. Nein
Warehouse ID (orderWarehouseID) STRING Filter for plenty warehouseID. Leave empty to select all. Nein
Webstore ID (storeID) STRING Filter for plenty Multishop ID. Leave empty to select all. Nein
Enable Variation Barcodes (enableVariationBarcodes) BOOLEAN If option is enabled the variation barcodes be returned. Nein
  • Enable
  • Disabled (Standardwert)
Enable PackageNumber (enablePackageNumbers) BOOLEAN If option is enabled the package number of orders will be returned. Nein
  • Enable
  • Disabled (Standardwert)
Enable Location (enableLocation) BOOLEAN If option is enabled the accounting location of the order will be returned. Nein
  • Enable
  • Disabled (Standardwert)
Enable Documents (enableDocuments) BOOLEAN If option is enabled the document informations of the order will be returned. Nein
  • Enable
  • Disabled (Standardwert)
Enable OrderComments (enableOrderNotes) BOOLEAN If option is enabled the order notes will be returned. Nein
  • Enable
  • Disabled (Standardwert)
Enable CustomerComments (enableCustomerNotes) BOOLEAN If option is enabled the customer notes will be returned. Nein
  • Enable
  • Disabled (Standardwert)
Enable OrderItem Warehouse Locations (enableStorageLocations) BOOLEAN If option is enabled the order item storage locations will be returned. Nein
  • Enable
  • Disabled (Standardwert)
Enable Payment Informations (enablePaymentInformations) BOOLEAN If option is enabled the order payment informations will be returned. Nein
  • Disabled (Standardwert)
  • Enable

Outputs

Name Datentyp Beschreibung
orders SPREADSHEET A SPREADSHEET containing the orders.
Folgende Felder sind im Output enthalten:

Feld Beschreibung Datentyp Pflichtfeld Standardwert
OrderHeadOrderID Ganzzahl
OrderHeadOrderTypeID Ganzzahl
OrderHeadOrderType Text
OrderHeadOrderStatus Dezimalzahl
OrderHeadResponsibleID Ganzzahl
OrderCreatedAt Text
OrderUpdatedAt Text
OrderCompletedAt Text
OrderPaidAt Text
OrderEstimatedShippingDate Text
OrderPlentyID Ganzzahl
OrderHeadCustomerID Ganzzahl
OrderCustomerAddressID ID of Address for update. Leave empty to create a new address (CustomerID required). Ganzzahl
OrderCustomerAddressTypeID TypeID can only be used for new addresses ('ID' column is empty)
Erlaubte Werte anzeigen
  • Invoice address (1)
  • Delivery address (2)
Ganzzahl
OrderCustomerAddressGender
Erlaubte Werte anzeigen
  • male
  • female
  • diverse
Text
OrderCustomerAddressCompany Text
OrderCustomerAddressFirstName Text
OrderCustomerAddressSurname Text
OrderCustomerAddressAdditionalName Text
OrderCustomerAddressStreet Text
OrderCustomerAddressHouseNumber Text
OrderCustomerAddressAdditionalAddress3 Text
OrderCustomerAddressAdditionalAddress4 Text
OrderCustomerAddressZIP Text
OrderCustomerAddressCity Text Ja
OrderCustomerAddressCountryID Ganzzahl Ja
OrderCustomerAddressStateID Ganzzahl
OrderCustomerAddressReadOnly true (Ja) / false (Nein)
OrderCustomerAddressContactPerson Text
OrderCustomerAddressVATNumber Text
OrderCustomerAddressExternalAddressID Text
OrderCustomerAddressEntryCertificate Text
OrderCustomerAddressTelephone Text
OrderCustomerAddressEmail Text
OrderCustomerAddressPostnumber Text
OrderCustomerAddressPersonalID Text
OrderCustomerAddressBBFC Text
OrderCustomerAddressBirthday Text
OrderCustomerAddressSessionID Text
OrderCustomerAddressTitle Text
OrderCustomerAddressCheckedAt Text
OrderCustomerAddressCreatedAt Text
OrderCustomerAddressUpdatedAt Text
OrderDeliveryAddressID ID of Address for update. Leave empty to create a new address (CustomerID required). Ganzzahl
OrderDeliveryAddressTypeID TypeID can only be used for new addresses ('ID' column is empty)
Erlaubte Werte anzeigen
  • Invoice address (1)
  • Delivery address (2)
Ganzzahl
OrderDeliveryAddressGender
Erlaubte Werte anzeigen
  • male
  • female
  • diverse
Text
OrderDeliveryAddressCompany Text
OrderDeliveryAddressFirstName Text
OrderDeliveryAddressSurname Text
OrderDeliveryAddressAdditionalName Text
OrderDeliveryAddressStreet Text
OrderDeliveryAddressHouseNumber Text
OrderDeliveryAddressAdditionalAddress3 Text
OrderDeliveryAddressAdditionalAddress4 Text
OrderDeliveryAddressZIP Text
OrderDeliveryAddressCity Text Ja
OrderDeliveryAddressCountryID Ganzzahl Ja
OrderDeliveryAddressStateID Ganzzahl
OrderDeliveryAddressReadOnly true (Ja) / false (Nein)
OrderDeliveryAddressContactPerson Text
OrderDeliveryAddressVATNumber Text
OrderDeliveryAddressExternalAddressID Text
OrderDeliveryAddressEntryCertificate Text
OrderDeliveryAddressTelephone Text
OrderDeliveryAddressEmail Text
OrderDeliveryAddressPostnumber Text
OrderDeliveryAddressPersonalID Text
OrderDeliveryAddressBBFC Text
OrderDeliveryAddressBirthday Text
OrderDeliveryAddressSessionID Text
OrderDeliveryAddressTitle Text
OrderDeliveryAddressCheckedAt Text
OrderDeliveryAddressCreatedAt Text
OrderDeliveryAddressUpdatedAt Text
OrderContactCustomerID Ganzzahl
OrderContactExternalCustomerID Text
OrderContactCustomerNumber Text
OrderContactType Ganzzahl
OrderContactFirstName Text
OrderContactSurname Text
OrderContactFullName Text
OrderContactEmail Text
OrderContactSecondaryEmail Text
OrderContactGender Text
OrderContactFormOfAddress Text
OrderContactNewsletter Text
OrderContactCustomerClass Ganzzahl
OrderContactIsBlocked Ganzzahl
OrderContactCustomerRating Ganzzahl
OrderContactDebitorAccount Text
OrderContactLanguage Text
OrderContactReferrerID Dezimalzahl
OrderContactPlentyID Ganzzahl
OrderContactResponsibleID Ganzzahl
OrderContactDateOfBirth Text
OrderContactLastLogin Text
OrderContactLastSalesOrder Text
OrderContactCreatedAt Text
OrderContactUpdatedAt Text
OrderContactTelephone Text
OrderContactFax Text
OrderContactMobile Text
OrderContactEbayName Text
OrderContactPaypalEmail Text
OrderContactPaypalPayerId Text
OrderContactKlarnaPersonalId Text
OrderContactPostident Text
OrderContactForumUsername Text
OrderContactForumGroupId Text
OrderContactSingleAccess Text
OrderContactContactPerson Text
OrderContactMarketplacePartner Text
OrderContactVAT_ID Text
OrderContactAccountId Ganzzahl
OrderContactAccountNumber Text
OrderContactAccountCompanyName Text
OrderContactAccountTaxIdNumber Text
OrderContactAccountValuta Ganzzahl
OrderContactAccountDiscountDays Ganzzahl
OrderContactAccountDiscountPercent Dezimalzahl
OrderContactAccountTimeForPaymentAllowedDays Ganzzahl
OrderContactAccountSalesRepresentativeContactId Ganzzahl
OrderContactAccountUserId Ganzzahl
OrderContactAccountDeliveryTime Ganzzahl
OrderContactAccountDealerMinOrderValue Text
OrderContactAccountCreatedAt Text
OrderContactAccountUpdatedAt Text
OrderHeadIsSystemCurrency true (Ja) / false (Nein)
OrderHeadCurrency Text
OrderHeadExchangeRatio Dezimalzahl
OrderHeadIsNetto true (Ja) / false (Nein)
OrderHeadTotalNetto Dezimalzahl
OrderHeadTotalBrutto Dezimalzahl
OrderHeadTotalVAT Dezimalzahl
OrderHeadTotalInvoice Dezimalzahl
OrderHeadPaidAmount Dezimalzahl
OrderHeadWarehouseID Text
OrderHeadShippingProfileID Text
OrderHeadMethodOfPaymentID Text
OrderHeadPaymentStatus Text
OrderHeadPaymentIDs Liste (Trennzeichen ; )
OrderHeadPaymentProperties Schlüssel-Wert-Paar
OrderExternalShippingProfile Text
OrderDocumentLanguage Text
OrderHeadExternalOrderID Text
OrderHeadCustomerReference Text
OrderHeadDunningLevel Text
OrderHeadSellerAccount Text
OrderHeadReferrerID Dezimalzahl
OrderHeadExternalDeliveryID Text
OrderHeadShippingCosts Dezimalzahl
OrderHeadShippingCostsNet Dezimalzahl
OrderHeadMarking1ID Text
OrderHeadCouponCode Text
OrderHeadCouponType Text
OrderHeadSalesTaxID Text
OrderHeadInvoiceNumber Text
OrderHeadPackageNumber Liste (Trennzeichen , )
OrderWeight Text
OrderWidth Text
OrderLength Text
OrderHeight Text
OriginOrderID Ganzzahl
ParentOrderID Ganzzahl
OrderLocationID Ganzzahl
OrderLocationCountryID Ganzzahl
OrderLocationName Text
OrderLocationClientID Ganzzahl
OrderLocationPlentyID Ganzzahl
OrderContactComments Text
OrderComments Text
OrderDocumentNumbers Schlüssel-Wert-Paar
OrderDocumentNumbersWithPrefix Schlüssel-Wert-Paar
OrderDocumentPaths Schlüssel-Wert-Paar
OrderItemsRowID The ID of the order item. Ganzzahl Ja
OrderItemsVariantID Variation ID of the order item. Ganzzahl
OrderItemsItemText Text
OrderItemsReferrerID Dezimalzahl
OrderItemsWarehouseID Ganzzahl
OrderItemsTypeID The ID of the order item type
Erlaubte Werte anzeigen
  • Variation (1)
  • Item bundle (2)
  • Bundle component (3)
  • Promotional coupon (4)
  • Gift card (5)
  • Shipping costs (6)
  • Payment surcharge (7)
  • Gift wrap (8)
  • Unassigend variation (9)
  • Deposit (10)
  • Order (11)
Ganzzahl
OrderItemsType Text
OrderItemsQuantity Dezimalzahl
OrderItemsVAT The vat amount, e.g. 19.0 for 19% VAT. Dezimalzahl
OrderItemsVATCountryID The ID of the VAT configuration. Ganzzahl
OrderItemsVATField The ID of the VAT rate's field. Ganzzahl
OrderItemsBundleRowID Ganzzahl
OrderItemsParentOrderItemsID Ganzzahl
OrderItemsEstimatedShippingDate The estimated shipping date in W3C date format(yyyy-MM-dd'T'HH:mm:ssXXX) of the order item. Text
OrderItemsWeight Text
OrderItemsWidth Text
OrderItemsLength Text
OrderItemsAmountPriceBrutto Dezimalzahl
OrderItemsAmountPriceNetto Dezimalzahl
OrderItemsAmountCurrency Text
OrderItemsAmountSurcharge Dezimalzahl
OrderItemsAmountDiscount Dezimalzahl
OrderItemsAmountPriceOriginalBrutto Dezimalzahl
OrderItemsAmountPriceOriginaNetto Dezimalzahl
OrderItemsAmountIsSystemCurrency true (Ja) / false (Nein)
OrderItemsAmountExchangeRatio Dezimalzahl
OrderItemsExternalItemID Text
OrderItemsVariantItemID Ganzzahl
OrderItemsVariantMainVariantID Ganzzahl
OrderItemsVariantIsMain true (Ja) / false (Nein)
OrderItemsVariantNumber Text
OrderItemsVariantExternalItemID Text
OrderItemsVariantModel Text
OrderItemsVariantName Text
OrderItemsVariantBundleType Text
OrderItemsVariantAvailabilityID Ganzzahl
OrderItemsVariantPurchasePrice Dezimalzahl
OrderItemsVariantWidthMM Ganzzahl
OrderItemsVariantLengthMM Ganzzahl
OrderItemsVariantHeightMM Ganzzahl
OrderItemsVariantWeightG Ganzzahl
OrderItemsVariantWeightNetG Ganzzahl
OrderItemsVariationBarcodes Schlüssel-Wert-Paar
OrderItemsID Ganzzahl
OrderItemsReasonForReturn Text
OrderItemsReturnStatus Text
OrderItemsProperties All order item properties as map (typeId=value). List of typeIds: https://developers.plentymarkets.com/rest-doc/order_order_item_order_item_property/details#get-all-order-item-propertys-for-one-order-item-by-its-order-item-id Schlüssel-Wert-Paar
OrderItemsOrderProperties All order item order properties as map (propertyId=value) Schlüssel-Wert-Paar
OrderItemsStorageLocationQuantity Schlüssel-Wert-Paar

Hilfe oder Projektsupport gewünscht?

Wenn Sie Hilfe bei der Einrichtung dieses Steps benötigen oder ein Projekt umsetzen wollen, dann unterstützen Sie unsere zertifizierten Partner. Partner finden