Skip to content

PlentyGetVariations - PlentyONE

Version: REST 1.0

← PlentyONE Add-On Übersicht

Dieser Step ruft Varianten- und Artikelinformation aus plentymarkets ab.

Benötigte Plentymarkets REST API  Berechtigungen:

  • Artikel > variation > show
  • Artikel > item > show
  • Artikel > Attribute > Attribute anzeigen
  • Artikel > Attributnamen > Attributnamen anzeigen
  • Artikel > Attribute > Attribute anzeigen
  • Artikel > Attributwerte > Attributwerte anzeigen
  • Artikel > Attributwertnamen> Attributwertnamen anzeigen
  • Artikel > Artikelbilder > Bilder anzeigen
  • Artikel > Barcodes > Barcodes anzeigen
  • Artikel > itemCrossSelling > show
  • Artikel > Hersteller > Hersteller anzeigen
  • Artikel > Merkmale > Merkmale anzeigen
  • Artikel > propertyGroup > show
  • Artikel > propertyGroupName > show
  • Artikel > Merkmalnamen > Merkmalnamen anzeigen
  • Artikel > Merkmaltyp Auswahl > Merkmaltyp Auswahl anzeigen
  • Artikel > Verkaufspreise > Verkaufspreise anzeigen
  • Artikel > Varianten - Bilder > Bilder anzeigen
  • tag > show
  • tagRelationship > show

Anhang: Feldmapping PlentyGetItemsBase STEP (SOAP API) zu PlentyGetVariations (REST API)

PlentyGetItemsBase

(SOAP API)

PlentyGetVariations

(REST API)

Kommentar
ItemID ItemID  
VariantID VariantID  
SKU "0-0-" + VariantID  
MainVariantID MainVariantID  
IsMainVariant IsMainVariant  
ItemNo VariantNumber  
ExternalItemID ExternalItemID  
Model Model  
EAN1-4 in VariationBarcodes  
ISBN  in VariationBarcodes  
MainWarehouseID MainWarehouseID  
phyStockMainWarehouse in VariationStocksPhysical  
netStockMainWarehouse in VariationStocksNetto  
StorageLocationID nicht mehr vorhanden PlentyGetCurrentStocks Step verwenden
Texts_Name ItemTextsName1  
Texts_Name2 ItemTextsName2  
Texts_Name3 ItemTextsName3  
Texts_ShortDescription ItemTextsShortDescription  
Texts_LongDescription ItemTextsDescription  
Texts_MetaDescription ItemTextsMetaDescription  
Texts_Lang ItemTextsLang  
Texts_Keywords ItemTextsKeywords  
Texts_TechnicalData ItemTextsTechnicalData  
ImageUrl0-4 in ItemImageUrls oder ItemImageUrlsMiddle oder ItemImageUrlsPreview  
AllImagesList ItemImageUrls  
Availability_AllMandantIds VariationClientIDs  
Availability_AvailabilityID AvailabilityID  
Availability_AvailableUntil AvailableUntil  
Availability_Inactive aus IsActive  
Availability_Webshop in VariationMarketIDs  
Availability_WebAPI in VariationMarketIDs  
Availability_AmazonFBA ItemAmazonFbaPlatform  
Availability_AmazonFEDAS ItemAmazonFedas  
Availability_AmazonMultichannel in VariationMarketIDs  
Availability_AmazonMultichannelCom in VariationMarketIDs  
Availability_AmazonMultichannelDe in VariationMarketIDs  
Availability_AmazonMultichannelEs in VariationMarketIDs  
Availability_AmazonMultichannelFr in VariationMarketIDs  
Availability_AmazonMultichannelIt in VariationMarketIDs  
Availability_AmazonMultichannelUk in VariationMarketIDs  
Availability_AmazonProduct ItemAmazonProductType  
Availability_CouchCommerce in VariationMarketIDs  
Availability_GartenXXLDe in VariationMarketIDs  
Availability_Gimahhot in VariationMarketIDs  
Availability_GoogleShopping in VariationMarketIDs  
Availability_GrosshandelDe nicht mehr vorhanden  
Availability_Hitmeister in VariationMarketIDs  
Availability_Hood in VariationMarketIDs  
Availability_Laary in VariationMarketIDs  
Availability_Mercateo in VariationMarketIDs  
Availability_NeckermannAtCrossDocking in VariationMarketIDs  
Availability_NeckermannAtCrossDockingProductType nicht mehr vorhanden  
Availability_NeckermannAtCrossDockingProvisionType nicht mehr vorhanden  
Availability_NeckermannAtEnterprise in VariationMarketIDs  
Availability_NeckermannAtEnterpriseProductType nicht mehr vorhanden  
Availability_NeckermannAtEnterpriseProvisionType nicht mehr vorhanden  
Availability_Otto in VariationMarketIDs  
Availability_PlusDe in VariationMarketIDs  
Availability_Restposten in VariationMarketIDs  
Availability_Shopgate in VariationMarketIDs  
Availability_SumoScout in VariationMarketIDs  
Availability_Twenga in VariationMarketIDs  
Availability_Yatego in VariationMarketIDs  
Availability_Zalando in VariationMarketIDs  
Availability_Zentralverkauf in VariationMarketIDs  
ItemURL nicht mehr vorhaden  
DeepLink ItemTextsUrlPath  
BundleType BundleType  
TariffNumber ItemCustomsTariffNumber  
Position ItemPosition  
WebShopSpecial ItemStoreSpecial  
Stock_Limitation StockLimitation  
Category1_Path Category1_Path  
Category1_ID Category1_ID  
Category1_Level Category1_Level  
Category1_Name Category1_Name  
Category1_PathNames Category1_PathNames  
AllCategoryPaths AllCategoryPaths  
Condition ItemCondition  
Marking1ID ItemMarking1ID  
Marking2ID ItemMarking2ID  
LastUpdate UpdatedAt  
Inserted CreatedAt  
Published ReleasedAt  
ProducerID ItemProducerID  
ProducerName ItemProducerName  
ProducingCountryID ItemProducingCountryID  
Type ItemType  
VATInternalID VATInternalID  
PriceSet_ID nicht mehr vorhaden  
PriceSet_PurchasePriceNet PurchasePrice  
PriceSet_VAT nicht mehr vorhaden Mapping über VATInternalID möglich
PriceSet_RecommendedRetailPrice in VariationSalesPrices  
PriceSet_Price1 - 12 in VariationSalesPrices  
PriceSet_WeightInGramm WeightG  
PriceSet_Unit UnitID bei SOAP ISO, jetzt ID siehe https://developers.plentymarkets.com/rest-doc/introduction#units
PriceSet_Unit1 nicht mehr vorhaden  
PriceSet_Unit2 nicht mehr vorhaden  
PriceSet_BestOfferAutoAcceptancePrice nicht mehr vorhaden  
PriceSet_CarryingCosts TransportationCosts  
PriceSet_InventoryCosts StorageCosts  
PriceSet_ItemShipping3 ExtraShippingCharge1  
PriceSet_ItemShipping4 ExtraShippingCharge2  
PriceSet_HeightInMM HeightMM  
PriceSet_LengthInMM LengthMM  
PriceSet_WidthInMM WidthMM  
PriceSet_Lot UnitContent  
PriceSet_Position Position  
PriceSet_Package PackingUnits  
PriceSet_TypeOfPackage PalletTypeId  
PriceSet_PackagingUnit UnitsContained  
PriceSet_RebateLevelPrice6 nicht mehr vorhaden  
PriceSet_RebateLevelPrice7 nicht mehr vorhaden  
PriceSet_RebateLevelPrice8 nicht mehr vorhaden  
PriceSet_OperatingCostsPercental OperatingCosts  
PriceSet_ScoMinimumPrice nicht mehr vorhaden  
PriceSet_TollPercental Customs  
FreeText1-20 ItemFreeText1-20  
OthersAPICondition ItemConditionApi  
Properties ItemProperties  
PropertiesWithGroups ItemPropertiesWithGroups  
PropertyGroups ItemPropertyGroups  
ParcelServicePresetIDs ItemShippingProfiles  
LinkedItemsItemIDs ItemCrossSellingCrossItemIDs  
Variant_AttributeValueIDs Variant_AttributeValueIDs  
Variant_FrontendAttributeName Variant_FrontendAttributeName  
Variant_BackendAttributeName Variant_BackendAttributeName  
VariantImages in ImageUrls oder ImageUrlsMiddle oder ImageUrlsPreview  
VariantImagesMap nicht mehr voranden  
AllVariantImages nicht mehr voranden  

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 plentymarkets.
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