PlentyGetVariations - PlentyONE

Version: REST 1.0

← PlentyONE Add-On Übersicht

Ruft eine Liste von Varianten aus PlentyONE ab.

Inputs

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

Name	Datentyp	Beschreibung	Pflichtfeld	Werte
account	ACCOUNT	Ihre PlentyONE Verbindung	Ja
limit	STRING	Limitieren Sie die Anzahl der abgerufenen Varianten	Nein
lastUpdate	DATETIME	Verwenden Sie diesen Filter um alle Variaten abzurufen, die nach diesem Datum aktualisiert wurden.	Nein
lastUpdateTo	DATETIME	Verwenden Sie diesen Filter um alle Variaten abzurufen, die vor diesem Datum aktualisiert wurden.	Nein
createdFrom	DATETIME	Verwenden Sie diesen Filter um alle Variaten abzurufen, die nach diesem Datum erstellt wurden.	Nein
createdTo	DATETIME	Verwenden Sie diesen Filter um alle Variaten abzurufen, die vor diesem Datum erstellt wurden.	Nein
isActive	STRING	Verwenden Sie diesen Filter um aktive und inaktive Varianten zu filtern.	Nein	Alle Nur Aktive Nur Inaktive
isMain	STRING	Verwenden Sie diesen Filter Hauptvarianten zu filtern.	Nein	Alle Nur Hauptvarianten Ohne Hauptvarianten
isBundle	STRING	Verwenden Sie diesen Filter Bundle Varianten zu filtern.	Nein	Alle Nur Bundles Ohne Bundles
variantId	STRING	Verwenden Sie diesen Filter um eine Varianten mit dieser ID zu filtern. Mehrere Varianten IDs können Komma-getrennt angegeben werden.	Nein
variantIdSpreadsheet	SPREADSHEET	Ein SPREADSHEET, dass alle Varianten IDs enthält, die abgerufen werden sollen.	Nein
variantIdMappingDefinition	STRING	Das Mapping als JSON String	Nein
	Folgende Felder sind zu konfigurieren: Feld Datentyp Beschreibung Pflichtfeld Standardwert VariantID SINGLE Nein
itemId	STRING	Verwenden Sie diesen Filter um eine bestimmte Artikel-ID zu filtern	Nein
numberExact	STRING	Verwenden Sie diesen Filter um eine Varianten mit dieser Varianten-Nummer zu filtern.	Nein
numberFuzzy	STRING	Verwenden Sie diesen Filter um Varianten zu filtern, die diesen Wert in ihrer Varianten-Nummer enthalten (SQL LIKE). Beispiel: Wenn Sie in ihrem Shop Varianten mit Varianten Nummer von 1 bis 400 haben und eine 12 als Filterwert angeben, werden die Varianten mit den Nummern 12, 112, 120-129, 212 and 312 ausgegeben.	Nein
plentyID	STRING	Verwenden Sie diesen Filter um Varianten eines bestimmten Mandanten (Shops) zu filtern	Nein
flagOne	STRING	Verwenden Sie diesen Filter um Varianten mit einer bestimmte Markierung 1 (ID) zu filtern.	Nein
flagTwo	STRING	Verwenden Sie diesen Filter um Varianten mit einer bestimmte Markierung 2 (ID) zu filtern.	Nein
variationTagId	STRING	Verwenden Sie diesen Filter um Varianten mit einen bestimmten Tag (ID) zu filtern. Mehrere Tag-IDs können Komma-getrennt angegeben werden.	Nein
manufacturerId	STRING	Verwenden Sie diesen Filter um Varianten mit einen bestimmten Hersteller (ID) zu filtern.	Nein
stockWarehouseId	STRING	Dieser Filter beschränkt das Ergebnis auf Varianten die einen physikalischen Bestand (größer 0) im angegebenen Lager haben.	Nein
referrerId	STRING	Dieser Filter schränkt die Liste der Ergebnisse auf Varianten ein, die für bestimmte Märkte sichtbar sind. Trennen Sie mehr als eine Marktplatz ID durch ein Komma. In diesem Fall müssen alle Märkte an der Variante aktiv sein.	Nein
additionalFields	STRINGLIST	Wählen Sie aus welche zusätzlichen Varianten-Information abgerufen werden sollen. Bitte beachten Sie, dass die entsprechenden Spalten im Ergebnis leer sind, wenn diese nicht ausgewählt wurden. Hinweis: wählen sie nur die benötigen Informationen aus um die Datenmenge (Traffic) und Laufzeiten klein zu halten.	Nein	Verkaufspreise Varianten Attribute Varianten Kategorien Artikel Informationen Varianten Bildverknüpfungen Barcodes(EAN) Verfügbarkeit Märkte Verfügbarkeit Mandanten(Shops) Marktplatz Artikelnummer(ASIN,ePID) Marktplatz SKUs Lager Varianten Eigenschaften Lieferanten Varianten Tags Varianten Einheit Bestand
enableItemText	STRING	Diese Option ermöglicht den zusätzlichen Abruf von allen Versandprofilen des Artikels. Hinweis: Aktivieren Sie den Abruf nur wenn Sie die Informationen benötigen, damit Sie die Datenmenge (Traffic) und Laufzeiten klein zu halten.	Nein	Aktiviert Deaktiviert
enableProducerName	STRING	Diese Option ermöglicht den zusätzlichen Abruf von der Hersteller Namen. Hinweis: Aktivieren Sie den Abruf nur wenn Sie die Informationen benötigen, damit Sie die Datenmenge (Traffic) und Laufzeiten klein zu halten.	Nein	Aktiviert Deaktiviert
enableItemProperties	STRING	Diese Option ermöglicht den zusätzlichen Abruf von allen Artikel Merkmalen. Hinweis: Aktivieren Sie den Abruf nur wenn Sie die Informationen benötigen, damit Sie die Datenmenge (Traffic) und Laufzeiten klein zu halten.	Nein	Aktiviert Deaktiviert
enableItemCrossSellings	STRING	Diese Option ermöglicht den zusätzlichen Abruf von Cross-Selling Artikel. Hinweis: Aktivieren Sie den Abruf nur wenn Sie die Informationen benötigen, damit Sie die Datenmenge (Traffic) und Laufzeiten klein zu halten.	Nein	Aktiviert Deaktiviert
enableItemShippingProfiles	STRING	Diese Option ermöglicht den zusätzlichen Abruf von allen Versandprofilen des Artikels. Hinweis: Aktivieren Sie den Abruf nur wenn Sie die Informationen benötigen, damit Sie die Datenmenge (Traffic) und Laufzeiten klein zu halten.	Nein	Aktiviert Deaktiviert
enableItemImages	STRING	Diese Option ermöglicht den zusätzlichen Abruf von allen Artikel Bildern. Hinweis: Aktivieren Sie den Abruf nur wenn Sie die Informationen benötigen, damit Sie die Datenmenge (Traffic) und Laufzeiten klein zu halten.	Nein	Aktiviert Deaktiviert
language	STRING	Wählen sie die Sprache aus in der Texte, Merkmal Attribute, Kategorien etc. ausgegeben werden sollen.	Nein	Deutsch Englisch Französisch Italienisch Spanisch Türkisch Niederländisch Polnisch Norwegisch Dänisch Schwedisch Tschechisch Russisch Slowakisch Chinesisch Vietnamesisch Portugiesisch Bulgarisch Rumänisch Kroatisch Estnisch Ungarisch Litauisch Lettisch Finnisch Irisch

Outputs

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

Name	Datentyp	Beschreibung	Werte
variations	SPREADSHEET	Ein SPREADSHEET mit den abgerufenen Varianten aus PlentyONE.
	Folgende Felder sind im Output enthalten: Feld Datentyp Beschreibung Standardwert ItemID SINGLE The item ID of the item that this variation belongs to identifier SINGLE The identifier column to import Spreadsheet into a Datastore. VariantID SINGLE The ID of the variation parent_identifier SINGLE The parent_identifier column to import Spreadsheet into a Datastore. MainVariantID SINGLE The variation ID of the item's main variation IsMainVariant SINGLE Flag that indicates if the variation is the main variation of the item VariantNumber SINGLE The unique variation number of the variation ExternalItemID SINGLE The external variation ID of this variation. The external variation number is optional and allows importing items and variations from external systems to PlentyONE Model SINGLE The model of the variation MainWarehouseID SINGLE The ID of the main warehouse of the variation VariantName SINGLE The name of the variation BundleType SINGLE Indicates the bundle type of the variation. AvailabilityID SINGLE The availability of the variation IsActive SINGLE Flag that indicates if the variation is active. Only active variations can be offered in the online store and/or on markets PurchasePrice SINGLE The net purchase price. Value e.g. is used for price calculations MovingAveragePrice SINGLE The moving average purchase price of the variation VATInternalID SINGLE The ID of the VAT rate of the variation. VAT rates are created for each client (store) and linked to the variation ExtraShippingCharge1 SINGLE The extra shipping charge 1 for the variation. Extra shipping charges are useful for large or bulky items that are particularly expensive to ship. Charge 1 is added to the regular shipping costs for the first item of an order. If different variations are ordered, the extra shipping charge 1 of the variation with the highest charge 1 is selected ExtraShippingCharge2 SINGLE The extra shipping charge 2 for the variation. Extra shipping charges are useful for large or bulky items that are expensive to ship. Charge 2 is added to the shipping costs for any additional items of an order UnitsContained SINGLE The number of sales units contained in one package UnitCombinationId SINGLE The unit combination id of the variation PalletTypeId SINGLE The ID of the pallet type PackingUnits SINGLE The number of packing units if the item consists of multiple packages PackingUnitTypeId SINGLE The ID of the packing unit type TransportationCosts SINGLE The net transportation costs for the variation. This value is used for price calculations and for calculating the acquisition price StorageCosts SINGLE The net storage costs for the variation Customs SINGLE The customs rate in percent CustomsTariffNumber SINGLE The customs tariff number of the variation; usually a 11 digit code number based on the Harmonised System OperatingCosts SINGLE The operating costs for the variation in percent AutomaticClientVisibility SINGLE Indicates if the variation is set as available for any clients (stores) IsHiddenInCategoryList SINGLE Flag that indicates if the variation is hidden in the category list. If true, the variation will not be shown in any item category and will not be returned as a search result. The variation can only be accessed via its URL. IsVisibleInListIfNetStockIsPositive SINGLE Flag that indicates if the variation is visible in the item list of the online store if net stock is positive. If true, the variation automatically becomes visible in categories, search results and item lists (store specials, cross-selling, last seen items) when the net stock changes to positive. IsInvisibleInListIfNetStockIsNotPositive SINGLE Flag that indicates if the variation is invisible in the item list of the online store if net stock is not positive. If true and no net stock is available for the variation, the variation can only be opened using the direct URL. The variation is not shown in the categories, search results or item lists (store specials, cross-selling, last seen items). CategoryVariationId SINGLE Either the ID of the variation or the ID of the item's main variation. No other values are permitted. ID of the variation = Categories are not inherited from the main variation. ID of the item's main variation = Inheritance of categories is active. MarketVariationId SINGLE Either the ID of the variation or the ID of the item's main variation. No other values are permitted. ID of the variation = Markets are not inherited from the main variation. ID of the item's main variation = Inheritance of markets is active. ClientVariationId SINGLE Either the ID of the variation or the ID of the item's main variation. No other values are permitted. ID of the variation = Clients (stores) are not inherited from the main variation. ID of the item's main variation = Inheritance of clients (stores) is active. SalesPriceVariationId SINGLE Either the ID of the variation or the ID of the item's main variation. No other values are permitted. ID of the variation = Sales prices are not inherited from the main variation. ID of the item's main variation = Inheritance of sales prices is active. SupplierVariationId SINGLE Either the ID of the variation or the ID of the item's main variation. No other values are permitted. ID of the variation = Suppliers are not inherited from the main variation. ID of the item's main variation = Inheritance of suppliers is active. WarehouseVariationId SINGLE Either the ID of the variation or the ID of the item's main variation. No other values are permitted. ID of the variation = Warehouses are not inherited from the main variation. ID of the item's main variation = Inheritance of warehouses is active. AvailableUntil SINGLE The last date the item will be available for sale WidthMM SINGLE The width of the variation in millimetres (mm) LengthMM SINGLE The length of the variation in millimeters (mm) HeightMM SINGLE The height of the variation in millimetres (mm) WeightG SINGLE The gross weight of the variation in gramms (g). This weight includes the packaging for variations that are packaged separately. This value is used for calculating shipping packages and weight-based shipping costs. WeightNetG SINGLE The net weight of the variation in gramms (g). This is the weight of the variation without packaging. MayShowUnitPrice SINGLE Display unit price in the online store MaximumOrderQuantity SINGLE The maximum order quantity permitted per order. Decimal values are possible to allow orders by weight or length. Default value is 0. If value is 0, the maximum order quantity is unlimited. MinimumOrderQuantity SINGLE The minimum order quantity. Decimal values are possible to allow orders by weight or length. IntervalOrderQuantity SINGLE The quantity intervals the variation can be ordered in. Decimal values are possible to allow orders by weight or length. PackingUnitType SINGLE Deprecated field. ParentItemVariationQuantity SINGLE Deprecated field. Picking SINGLE The order picking type of the variation. Possible values: single_picking, no_single_picking, exclude_from_picklist, null (no order picking type) Position SINGLE The position of the variation. Value is inherited from the item's main variation if inheritance is active. EstimatedAvailableAt SINGLE The estimated delivery date of variations on reorder. CreatedAt SINGLE The time the variation was created. UpdatedAt SINGLE The time the variation was last updated. RelatedUpdatedAt SINGLE The time at which related information for this variation was last updated. Related information is defined as information that is linked to the variation, i.e. barcodes, categories, images, markets, clients (stores), prices, suppliers, warehouses and the default category. PriceCalculationId SINGLE The ID of the price calculation linked to the variation. StockLimitation SINGLE The stock limitation for the variation. IsVisibleIfNetStockIsPositive SINGLE Flag that indicates if the variation is visible in the online store if net stock is positive. If true, the variation automatically becomes visible when the net stock changes to positive. IsInvisibleIfNetStockIsNotPositive SINGLE Flag that indicates if the variation is invisible in the online store if net stock is not positive. If true, the variation automatically becomes invisible when the net stock changes to 0 or negative. IsAvailableIfNetStockIsPositive SINGLE Flag that indicates if the variation is available in the online store if net stock is positive. If true, the variation automatically becomes available when the net stock changes to positive. IsUnavailableIfNetStockIsNotPositive SINGLE Flag that indicates if the variation is unavailable in the online store if net stock is not positive. If true, the variation automatically becomes available when the net stock changes to 0 or negative. ReleasedAt SINGLE The release date of the variation. This is the date on which the variation will become available. The variation can be visible in the online store before this date, e.g. for preorders. ItemNo SINGLE Deprecated: Please use VariantNumber ItemProducerID SINGLE The ID of the manufacturer of the item ItemProducerName SINGLE The manufacturer name of the item ItemProducerExternalName SINGLE The external manufacturer name of the item ItemStockType SINGLE The stock type of the item. 0 ItemStoreSpecial SINGLE Option to present items more prominently in the online store. ItemCondition SINGLE The condition of the item. ItemAmazonFedas SINGLE The FEDAS product classification key of the item. ItemUpdatedAt SINGLE Timestamp of the last date and time the item was updated. ItemFreeText1 SINGLE The content of the free text field 1. ItemFreeText2 SINGLE The content of the free text field 2 ItemFreeText3 SINGLE The content of the free text field 3 ItemFreeText4 SINGLE The content of the free text field 4 ItemFreeText5 SINGLE The content of the free text field 5 ItemFreeText6 SINGLE The content of the free text field 6 ItemFreeText7 SINGLE The content of the free text field 7 ItemFreeText8 SINGLE The content of the free text field 8 ItemFreeText9 SINGLE The content of the free text field 9 ItemFreeText10 SINGLE The content of the free text field 10 ItemFreeText11 SINGLE The content of the free text field 11 ItemFreeText12 SINGLE The content of the free text field 12 ItemFreeText13 SINGLE The content of the free text field 13 ItemFreeText14 SINGLE The content of the free text field 14 ItemFreeText15 SINGLE The content of the free text field 15 ItemFreeText16 SINGLE The content of the free text field 16 ItemFreeText17 SINGLE The content of the free text field 17 ItemFreeText18 SINGLE The content of the free text field 18 ItemFreeText19 SINGLE The content of the free text field 19 ItemFreeText20 SINGLE The content of the free text field 20 ItemType SINGLE The type of the item. Because Set items are managed using a separate route, this value is always Default. ItemCreatedAt SINGLE Timestamp of the date and time the item was created. ItemIsShippableByAmazon SINGLE Flag that indicates if the item can be shipped with Amazon Multi-Channel. Amazon Multi-Channel Fulfillment is a service for fulfilling orders from sales channels other than Amazon platforms using inventory stored in the Amazon fulfillment center. ItemPosition SINGLE The position of the item ItemOwnerId SINGLE The PlentyONE user that is assigned as owner of this item. ItemProducingCountryID SINGLE The ID of the country in which the item was manufactured. ItemCustomsTariffNumber SINGLE Depracated: The field customsTariffNumber was removed from the Item and added to the Variations. ItemRevenueAccount SINGLE The revenue account the item is linked to. An individual revenue account can be saved for each item in PlentyONE. If this is not done, PlentyONE automatically determines a revenue account based on the VAT rate. ItemCouponRestriction SINGLE Indicates if the item can be purchased using a promotional coupon. ItemConditionApi SINGLE The condition of the item that is transferred to markets via API. ItemIsSubscribable SINGLE Flag that indicates if the item can be ordered as a subscription item. If yes, the item can be ordered for delivery at regular intervals. ItemAmazonFbaPlatform SINGLE Indicates the platform used for Fulfilment by Amazon (FBA). ItemAmazonProductType SINGLE The Amazon product type of the item. List of IDs: https://www.plentymarkets.co.uk/manual/data-exchange/data-formats/item/ ItemEbayPresetId SINGLE The eBay preset ID ItemEbayCategory SINGLE The eBay category 1 of the item. This category is used when a new listing is created. ItemEbayCategory2 SINGLE The eBay category 2 of the item. This category is used when a new listing is created. ItemEbayStoreCategory SINGLE The ID of the eBay store category 1 of the item. This value is used for new listings. ItemEbayStoreCategory2 SINGLE The ID of the eBay store category 2 of the item. This value is used for new listings. ItemRakutenCategoryId SINGLE The ID of the Rakuten category of this item. ItemMarking1ID SINGLE Flag 1 of the item. Flags can be used to organise and filter items. Each item can be assigned up to two flags. Possible values: 1 to 31, 0 = no flag ItemMarking2ID SINGLE Flag 2 of the item. Flags can be used to organise and filter items. Each item can be assigned up to two flags. Possible values: 1 to 11, 0 = no flag ItemAgeRestriction SINGLE The age customers must be to purchase the item. Items with an age rating of 18+ must be linked to a shipping profile for which the PostIdent option is activated. ItemFeedback SINGLE The feedback, i.e. rating, that this item received. Possible values are 1 to 5 or 1 to 10 depending on the maximum rating setting. An initial feedback can be saved for items. The saved value will then be displayed as the initial feedback. Every time new feedback is submitted, the average value will be recalculated automatically. ItemTextsName1 SINGLE The default name of the item. By default, this name is displayed in the online store. For Default items, this name is also used for markets. Character limit: max. 240 characters. ItemTextsName2 SINGLE Alternative item name that can be used e.g. for markets. Character limit: max. 240 characters ItemTextsName3 SINGLE Alternative item name that can be used e.g. for markets. Character limit: max. 240 characters ItemTextsShortDescription SINGLE The preview text of the item. This short description text can be displayed as a teaser in item lists. ItemTextsMetaDescription SINGLE The meta description of the item. This description is analysed by search engines and displayed in search results. This text should be treated as an advertising text to maximise click-through from search engine result pages. ItemTextsDescription SINGLE The detailed description of the item. ItemTextsTechnicalData SINGLE Technical data of the item. ItemTextsKeywords SINGLE HTML meta keywords to tag the item for search engines. More than one keyword can be separated by commas. ItemTextsUrlPath SINGLE The item's URL path in the online store. By default, the URL path consists of the categories and the item name. The path is assigned automatically when the item is created and is displayed as part of the URL when the item is selected in the online store. ItemTextsLang SINGLE The language of the item text. ItemPropertyGroups MAP ItemPropertyIDs MAP ItemProperties MAP Deprecated, please use 'ItemPropertiesJSON' instead of this column. Item Properties (backendname as key) and values as Map. ItemPropertiesJSON MAP Item Properties (backendname as key) and values as JSON Map. ItemPropertiesWithGroups MAP Depracated, please use 'ItemPropertiesWithGroupsJSON' instead of this column. Item Properties with group name and values as Map. ItemPropertiesWithGroupsJSON MAP Item Properties with group name and values as Map. ItemImageUrls MULTIPLEVALUE ItemImageUrlsMiddle MULTIPLEVALUE ItemImageUrlsPreview MULTIPLEVALUE ItemImageIDs MULTIPLEVALUE List of ImageIDs ItemImageWidth MULTIPLEVALUE List of image width ItemImageHeight MULTIPLEVALUE List of image height ItemImageLastUpdate SINGLE Last item image updated at ItemShippingProfiles MULTIPLEVALUE ItemCrossSellingCrossItemIDs MULTIPLEVALUE ItemCrossSellingTypes MAP VariationPropertyIDs MAP Deprecated, please use 'VariationPropertyIDsJSON' instead of this column. Variation Properties (id as key) and values as Map. VariationPropertyIDsJSON MAP Variation Properties (id as key) and values as JSON-Map. VariationProperties MAP Deprecated, please use 'VariationPropertiesJSON' instead of this column. Variation Properties (name as key) and values as Map. VariationPropertiesJSON MAP Variation Properties (name as key) and values as JSON map. VariationBarcodes MAP VariationSalesPrices MAP VariationClientIDs MULTIPLEVALUE List of the clients (stores, webshops) of the variation VariationMarketIDs MULTIPLEVALUE List of market ids linked to variation VariationMarketNumberEPIDs MAP Map of Epids (CountryID=Epids) of variation VariationMarketNumberASINs MAP Map of ASINs (CountryID=ASIN) of variation VariationMarketSkus MAP UnitID SINGLE The id of the unit 1 UnitContent SINGLE The content of the unit 1 ImageUrls MULTIPLEVALUE ImageUrlsMiddle MULTIPLEVALUE ImageUrlsPreview MULTIPLEVALUE ImageIDs MULTIPLEVALUE List of ImageIDs ImageWidth MULTIPLEVALUE List of image width ImageHeight MULTIPLEVALUE List of image height) DefaultCategoryIDs MAP Category1_Path MULTIPLEVALUE Category1_ID SINGLE Category1_Level SINGLE Category1_Name SINGLE Category1_PathNames MULTIPLEVALUE AllCategoryIDs MULTIPLEVALUE AllCategoryPaths MULTIPLEVALUE AllCategoryPathIDs MULTIPLEVALUE Variant_AttributeValueIDs MAP Variant_FrontendAttributeName MAP Variant_BackendAttributeName MAP VariationWarehouseReorderLevel MAP VariationWarehouseMaximumStock MAP VariationWarehousestockTurnoverInDays MAP VariationWarehouseStockBuffer MAP VariationWarehouseStorageLocation MAP VariationStocksNetto MAP VariationStocksPhysical MAP VariationSupplierItemNumber MAP VariationSupplierPurchasePrice MAP VariationSupplierLinkId MAP VariationTagIDs MULTIPLEVALUE VariationTagNames MULTIPLEVALUE