stepPlentyONE Skip to content

Step: PlentyGetVariations - REST API

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
childrenFilter STRING Filter schränkt das Ergebnis auf Varianten ein, die (aktive) Children haben. Nein
  • Alle
  • Varianten mit Children
  • Varianten mit aktiven Children
bundleType STRING Verwenden Sie diesen Filter Pakete bzw. Paketbestandteile zu filtern. Nein
  • Alle
  • Nur Pakete
  • Nur Bestandteile
  • Nur Pakete oder Bestandteile
  • Weder Paket und noch Bestandteil
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
VariantIDSINGLENein
itemId STRING Verwenden Sie diesen Filter um eine bestimmte Artikel-ID zu filtern. Mehrere IDs können durch Komma getrennt werden. Begrenzt auf max. 100 Item IDs. Nein
numberExact STRING Verwenden Sie diesen Filter um eine Varianten mit dieser Varianten-Nummer zu filtern. Nein
plentyID STRING Verwenden Sie diesen Filter um Varianten eines bestimmten Mandanten (Shops) zu filtern. Mehrere IDs können durch Komma getrennt werden. 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 bestimmten Tags (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. Mehrere Hersteller-IDs können Komma-getrennt angegeben werden. 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
  • 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
  • Datum/Zeitstempel
  • Artikel Informationen
  • Artikel Texte
  • Artikel Merkmale
  • Cross-Selling Artikel
  • Versandprofile
  • Artikel Bilder
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
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
batchSize NUMBER Legt die Anzahl der Varianten pro Seite / API-Aufruf fest. Verwenden sie diese Option, um festzulegen wie viele Variante pro API Call abgerufen werden. Diese Option kann verwendet werden, falls Fehler oder timeouts beim Abruf auftreten. Versuchen Sie in diesen Fällen die Anzahl der Varianten pro API Call zu verkleinern. Der maximale und der Standardwert ist 250. Nein

Outputs

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

Name Datentyp Beschreibung Pflichtfeld Werte
variations SPREADSHEET Ein SPREADSHEET mit den abgerufenen Varianten aus plentymarkets. Ja
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Pflichtfeld Standardwert
identifierSINGLEThe identifier column to import Spreadsheet into a Datastore.Nein
VariantIDSINGLEThe ID of the variationNein
ItemIDSINGLEThe item ID of the item that this variation belongs toNein
parent_identifierSINGLEThe parent_identifier column to import Spreadsheet into a Datastore.Nein
MainVariantIDSINGLEThe variation ID of the item's main variationNein
IsMainSINGLEBoolean flag that indicates if the variation is the main variation of the itemNein
IsMainVariantSINGLEFlag that indicates if the variation is the main variation of the itemNein
VariantNumberSINGLEThe unique variation number of the variationNein
ExternalItemIDSINGLEThe external variation ID of this variation. The external variation number is optional and allows importing items and variations from external systems to plentymarketsNein
ModelSINGLEThe model of the variationNein
MainWarehouseIDSINGLEThe ID of the main warehouse of the variationNein
VariantNameSINGLEThe name of the variationNein
BundleTypeSINGLEIndicates the bundle type of the variation.Nein
AvailabilityIDSINGLEThe availability of the variationNein
IsActiveSINGLEFlag that indicates if the variation is active. Only active variations can be offered in the online store and/or on marketsNein
PurchasePriceSINGLEThe net purchase price. Value e.g. is used for price calculationsNein
MovingAveragePriceSINGLEThe moving average purchase price of the variationNein
VATInternalIDSINGLEThe ID of the VAT rate of the variation. VAT rates are created for each client (store) and linked to the variationNein
ExtraShippingCharge1SINGLEThe 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 selectedNein
ExtraShippingCharge2SINGLEThe 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 orderNein
UnitsContainedSINGLEThe number of sales units contained in one packageNein
PalletTypeIdSINGLEThe ID of the pallet typeNein
PackingUnitsSINGLEThe number of packing units if the item consists of multiple packagesNein
PackingUnitTypeIdSINGLEThe ID of the packing unit typeNein
TransportationCostsSINGLEThe net transportation costs for the variation. This value is used for price calculations and for calculating the acquisition priceNein
StorageCostsSINGLEThe net storage costs for the variationNein
CustomsSINGLEThe customs rate in percentNein
CustomsTariffNumberSINGLEThe customs tariff number of the variation; usually a 11 digit code number based on the Harmonised SystemNein
OperatingCostsSINGLEThe operating costs for the variation in percentNein
StockLimitationSINGLEThe stock limitation for the variation.Nein
AutomaticClientVisibilitySINGLEIndicates if the variation is set as available for any clients (stores)Nein
IsHiddenInCategoryListSINGLEFlag 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.Nein
IsVisibleInListIfNetStockIsPositiveSINGLEFlag 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.Nein
IsInvisibleInListIfNetStockIsNotPositiveSINGLEFlag 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).Nein
IsVisibleIfNetStockIsPositiveSINGLEFlag 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.Nein
IsInvisibleIfNetStockIsNotPositiveSINGLEFlag 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. Nein
IsAvailableIfNetStockIsPositiveSINGLEFlag 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.Nein
IsUnavailableIfNetStockIsNotPositiveSINGLEFlag 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.Nein
CategoriesInheritedSINGLETrue if categories are inherited from the main variation.Nein
ReferrerInheritedSINGLETrue if markets/referrer are not inherited from the main variation. ID of the item's main variation = Inheritance of markets is active.Nein
ClientsInheritedSINGLETrue if clients (stores) are not inherited from the main variation. ID of the item's main variation = Inheritance of clients (stores) is active.Nein
SalesPricesInheritedSINGLETrue if sales prices are not inherited from the main variation. ID of the item's main variation = Inheritance of sales prices is active.Nein
SupplierInheritedSINGLETrue if suppliers are not inherited from the main variation. ID of the item's main variation = Inheritance of suppliers is active.Nein
WarehousesInheritedSINGLETrue if warehouses are not inherited from the main variation. ID of the item's main variation = Inheritance of warehouses is active.Nein
PropertiesInheritedSINGLETrue if properties are not inherited from the main variation. ID of the item's main variation = Inheritance of suppliers is active.Nein
TagsInheritedSINGLETrue if Warehouses are not inherited from the main variation. ID of the item's main variation = Inheritance of warehouses is active.Nein
AvailableUntilSINGLEThe last date the item will be available for saleNein
WidthMMSINGLEThe width of the variation in millimetres (mm)Nein
LengthMMSINGLEThe length of the variation in millimeters (mm)Nein
HeightMMSINGLEThe height of the variation in millimetres (mm)Nein
WeightGSINGLEThe 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.Nein
WeightNetGSINGLEThe net weight of the variation in gramms (g). This is the weight of the variation without packaging.Nein
MayShowUnitPriceSINGLEDisplay unit price in the online storeNein
MaximumOrderQuantitySINGLEThe 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.Nein
MinimumOrderQuantitySINGLEThe minimum order quantity. Decimal values are possible to allow orders by weight or length.Nein
IntervalOrderQuantitySINGLEThe quantity intervals the variation can be ordered in. Decimal values are possible to allow orders by weight or length.Nein
PickingSINGLEThe order picking type of the variation. Possible values: single_picking, no_single_picking, exclude_from_picklist, null (no order picking type)Nein
PositionSINGLEThe position of the variation. Value is inherited from the item's main variation if inheritance is active.Nein
ParentVariationIDSINGLENein
ParentItemVariationQuantitySINGLENein
EstimatedAvailableAtSINGLEThe estimated delivery date of variations on reorder.Nein
PriceCalculationIdSINGLEThe ID of the price calculation linked to the variation.Nein
ReleasedAtSINGLEThe 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.Nein
ItemProducerIDSINGLEThe ID of the manufacturer of the itemNein
ItemProducerNameSINGLEThe manufacturer name of the itemNein
ItemProducerExternalNameSINGLEThe external manufacturer name of the itemNein
ItemStockTypeSINGLEThe stock type of the item.Nein0
ItemStoreSpecialSINGLEOption to present items more prominently in the online store.Nein
ItemConditionSINGLEThe condition of the item.Nein
ItemAmazonFedasSINGLEThe FEDAS product classification key of the item.Nein
ItemUpdatedAtSINGLETimestamp of the last date and time the item was updated.Nein
ItemFreeText1SINGLEThe content of the free text field 1.Nein
ItemFreeText2SINGLEThe content of the free text field 2Nein
ItemFreeText3SINGLEThe content of the free text field 3Nein
ItemFreeText4SINGLEThe content of the free text field 4Nein
ItemFreeText5SINGLEThe content of the free text field 5Nein
ItemFreeText6SINGLEThe content of the free text field 6Nein
ItemFreeText7SINGLEThe content of the free text field 7Nein
ItemFreeText8SINGLEThe content of the free text field 8Nein
ItemFreeText9SINGLEThe content of the free text field 9Nein
ItemFreeText10SINGLEThe content of the free text field 10Nein
ItemFreeText11SINGLEThe content of the free text field 11Nein
ItemFreeText12SINGLEThe content of the free text field 12Nein
ItemFreeText13SINGLEThe content of the free text field 13Nein
ItemFreeText14SINGLEThe content of the free text field 14Nein
ItemFreeText15SINGLEThe content of the free text field 15Nein
ItemFreeText16SINGLEThe content of the free text field 16Nein
ItemFreeText17SINGLEThe content of the free text field 17Nein
ItemFreeText18SINGLEThe content of the free text field 18Nein
ItemFreeText19SINGLEThe content of the free text field 19Nein
ItemFreeText20SINGLEThe content of the free text field 20Nein
ItemTypeSINGLEThe type of the item. Because Set items are managed using a separate route, this value is always Default.Nein
ItemCreatedAtSINGLETimestamp of the date and time the item was created.Nein
ItemIsShippableByAmazonSINGLEFlag 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.Nein
ItemPositionSINGLEThe position of the itemNein
ItemOwnerIdSINGLEThe PlentyONE user that is assigned as owner of this item.Nein
ItemProducingCountryIDSINGLEThe ID of the country in which the item was manufactured.Nein
ItemCustomsTariffNumberSINGLEDepracated: The field customsTariffNumber was removed from the Item and added to the Variations.Nein
ItemRevenueAccountSINGLEThe revenue account the item is linked to. An individual revenue account can be saved for each item in plentymarkets. If this is not done, PlentyONE automatically determines a revenue account based on the VAT rate.Nein
ItemCouponRestrictionSINGLEIndicates if the item can be purchased using a promotional coupon.Nein
ItemConditionApiSINGLEThe condition of the item that is transferred to markets via API.Nein
ItemIsSubscribableSINGLEFlag that indicates if the item can be ordered as a subscription item. If yes, the item can be ordered for delivery at regular intervals.Nein
ItemAmazonFbaPlatformSINGLEIndicates the platform used for Fulfilment by Amazon (FBA).Nein
ItemAmazonProductTypeSINGLEThe Amazon product type of the item. List of IDs: https://www.plentymarkets.co.uk/manual/data-exchange/data-formats/item/Nein
ItemEbayPresetIdSINGLEThe eBay preset IDNein
ItemEbayCategorySINGLEThe eBay category 1 of the item. This category is used when a new listing is created.Nein
ItemEbayCategory2SINGLEThe eBay category 2 of the item. This category is used when a new listing is created.Nein
ItemEbayStoreCategorySINGLEThe ID of the eBay store category 1 of the item. This value is used for new listings.Nein
ItemEbayStoreCategory2SINGLEThe ID of the eBay store category 2 of the item. This value is used for new listings.Nein
ItemRakutenCategoryIdSINGLEThe ID of the Rakuten category of this item.Nein
ItemMarking1IDSINGLEFlag 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 flagNein
ItemMarking2IDSINGLEFlag 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 flagNein
ItemAgeRestrictionSINGLEThe 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.Nein
ItemFeedbackSINGLEThe 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.Nein
ItemTextsName1SINGLEThe 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.Nein
ItemTextsName2SINGLEAlternative item name that can be used e.g. for markets. Character limit: max. 240 charactersNein
ItemTextsName3SINGLEAlternative item name that can be used e.g. for markets. Character limit: max. 240 charactersNein
ItemTextsShortDescriptionSINGLEThe preview text of the item. This short description text can be displayed as a teaser in item lists.Nein
ItemTextsMetaDescriptionSINGLEThe 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.Nein
ItemTextsDescriptionSINGLEThe detailed description of the item.Nein
ItemTextsTechnicalDataSINGLETechnical data of the item.Nein
ItemTextsKeywordsSINGLEHTML meta keywords to tag the item for search engines. More than one keyword can be separated by commas.Nein
ItemTextsUrlPathSINGLEThe 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.Nein
ItemTextsLangSINGLEThe language of the item text.Nein
ItemPropertyGroupsMAPNein
ItemPropertyIDsMAPNein
ItemPropertiesMAPDeprecated, please use 'ItemPropertiesJSON' instead of this column. Item Properties (backendname as key) and values as Map.Nein
ItemPropertiesJSONMAPItem Properties (backendname as key) and values as JSON Map.Nein
ItemPropertiesWithGroupsMAPDeprecated, please use 'ItemPropertiesWithGroupsJSON' instead of this column. Item Properties with group name and values as Map.Nein
ItemPropertiesWithGroupsJSONMAPItem Properties with group name and values as Map.Nein
ItemImageUrlsMULTIPLEVALUENein
ItemImageUrlsMiddleMULTIPLEVALUENein
ItemImageUrlsPreviewMULTIPLEVALUENein
ItemImageIDsMULTIPLEVALUEList of ImageIDsNein
ItemImageWidthMULTIPLEVALUEList of image widthNein
ItemImageHeightMULTIPLEVALUEList of image heightNein
ItemImageLastUpdateSINGLELast item image updated atNein
ItemShippingProfilesMULTIPLEVALUENein
ItemCrossSellingCrossItemIDsMULTIPLEVALUENein
ItemCrossSellingTypesMAPNein
VariationStocksNettoMAPNein
VariationStocksPhysicalMAPNein
UnitCombinationIdSINGLENein
UnitIDSINGLEThe id of the unitNein
UnitContentSINGLEThe content of the unitNein
AvailabilityUpdatedAtSINGLEThe time the availability of the variation was last modified.Nein
AdditionalSkuUpdatedAtSINGLEThe time any additional sku of the variation was last modified.Nein
BarcodeUpdatedAtSINGLEThe time any barcode of the variation was last modified.Nein
UpdatedAtSINGLEThe time any field of the variation was last modified.Nein
BundleComponentUpdatedAtSINGLEThe time any bundle component of the variation was last modified.Nein
CategoryUpdatedAtSINGLEThe time any category of the variation was last modified.Nein
ClientUpdatedAtSINGLEThe time any client of the variation was last modified.Nein
DefaultCategoryUpdatedAtSINGLEThe time any default category of the variation was last modified.Nein
ImageUpdatedAtSINGLEThe time any image of the variation was last modified.Nein
MarketUpdatedAtSINGLEThe time any market of the variation was last modified.Nein
MarketIdentNumberUpdatedAtSINGLEThe time any market ident number of the variation was last modified.Nein
RelatedUpdatedAtSINGLEThe 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.Nein
SalesPriceUpdatedAtSINGLEThe time any sales price of the variation was last modified.Nein
SkuUpdatedAtSINGLEThe time any sku of the variation was last modified.Nein
SupplierUpdatedAtSINGLEThe time any supplier of the variation was last modified.Nein
PropertyUpdatedAtSINGLEThe time any property of the variation was last modified.Nein
WarehouseUpdatedAtSINGLEThe time any warehouse of the variation was last modified.Nein
TagUpdatedAtSINGLEThe time any tag of the variation was last modified.Nein
CommentUpdatedAtSINGLEThe time any comment of the variation was last added.Nein
CreatedAtSINGLEThe time the variation was created.Nein
DefaultCategoryIDsMAPMap of all default categories, eg. clientId1=cat1;clientId2=cat4;...Nein
Category1_PathMULTIPLEVALUENein
Category1_IDSINGLENein
Category1_LevelSINGLENein
Category1_NameSINGLENein
AllCategoryIDsMULTIPLEVALUENein
AllCategoryPathIDsMULTIPLEVALUENein
VariationBarcodesMAPNein
Variant_AttributeValueIDsMAPNein
Variant_FrontendAttributeNameMAPNein
Variant_BackendAttributeNameMAPNein
VariationClientIDsMULTIPLEVALUEList of the clients (stores, webshops) of the variationNein
ImageUrlsMULTIPLEVALUENein
ImageUrlsMiddleMULTIPLEVALUENein
ImageUrlsPreviewMULTIPLEVALUENein
ImageIDsMULTIPLEVALUEList of ImageIDsNein
ImageWidthMULTIPLEVALUEList of image widthNein
ImageHeightMULTIPLEVALUEList of image height)Nein
VariationMarketNumberEPIDsMAPMap of Epids (CountryID=Epids) of variationNein
VariationMarketNumberASINsMAPMap of ASINs (CountryID=ASIN) of variationNein
VariationMarketIDsMULTIPLEVALUEList of market ids linked to variationNein
VariationSalesPricesMAPNein
VariationMarketSkusMAPNein
VariationAccountMarketSkusMAPNein
VariationSupplierItemNumberMAPNein
VariationSupplierPurchasePriceMAPNein
VariationSupplierLinkIdMAPNein
VariationWarehouseReorderLevelMAPNein
VariationWarehouseMaximumStockMAPNein
VariationWarehousestockTurnoverInDaysMAPNein
VariationWarehouseStockBufferMAPNein
VariationWarehouseStorageLocationMAPNein
VariationPropertyIDsMAPDeprecated, please use 'VariationPropertyIDsJSON' instead of this column. Variation Properties (id as key) and values as Map.Nein
VariationPropertiesMAPDeprecated, please use 'VariationPropertiesJSON' instead of this column. Variation Properties (name as key) and values as Map.Nein
VariationPropertyIDsJSONMAPVariation Properties (id as key) and values as JSON-Map.Nein
VariationPropertiesJSONMAPVariation Properties (name as key) and values as JSON map.Nein
VariationTagIDsMULTIPLEVALUENein
VariationTagNamesMULTIPLEVALUENein