stepPlentyONE Skip to content

PlentyAddVariations Step

Dieser Step ermöglicht den Import neuer Varianten zu Artikeln in Ihrem PlentyONE Shop.

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 Beschränken Sie die Anzahl der zu importierten Varianten. Leer lassen für unbegrenzt. Nein
productSpreadsheet SPREADSHEET Das Eingangs-SPREADSHEET, das die zu importierenden Variantendaten enthält. Ja
mappingdefinition STRING Die konfigurierte Zuordnung der Zielspalten. Nein
Folgende Felder sind zu konfigurieren:

Feld Datentyp Beschreibung Pflichtfeld Standardwert
ItemIDSINGLEID of item.Ja
NumberSINGLEThe unique variation number of the variation.Nein
ExternalItemIDSINGLEThe external variation ID of this variation. The external variation number is optional and allows importing items and variations from external systems to PlentyONE.Nein
ModelSINGLEThe model of the variation. Value is inherited from the item's main variation if inheritance is active.Nein
MainWarehouseIDSINGLEThe ID of the main warehouse of the variation.Nein
NameSINGLEThe name of the variationNein
AvailabilityIDSINGLEThe availability of the variation.Nein
IsActiveSINGLEFlag that indicates if the variation is active. Only active variations can be offered in the online store and/or on markets.Nein
PurchasePriceSINGLEThe net purchase price. Value e.g. is used for price calculations.Nein
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 variation.Nein
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 selected.Nein
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 order.Nein
UnitsContainedSINGLEThe number of sales units contained in one package.Nein
PalletTypeIdSINGLEThe ID of the pallet typeNein
PackingUnitsSINGLEThe number of packing units if the item consists of multiple packages. Value is 0 if an item is sent as one package. All items of an order that have the value 0 will be packed into one package.Nein
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 price.Nein
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
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
AvailableUntilSINGLEThe last date the item will be available for sale.Nein
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
PackingUnitTypeSINGLEThe ID of the packing unit typeNein
PickingSINGLEThe order picking type of the variation.Nein
PositionSINGLEThe position of the variation. Value is inherited from the item's main variation if inheritance is active.Nein
EstimatedAvailableAtSINGLEThe estimated delivery date of variations on reorder.Nein
PriceCalculationIdSINGLEThe ID of the price calculation linked to the variation.Nein
StockLimitationSINGLEThe stock limitation for the variation.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 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
IsUnavailableIfNetStockIsNotPositiveSINGLEThe 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
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
CategoryVariationIdSINGLEEither 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. optionalNein
MarketVariationIdSINGLEEither 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. optionalNein
ClientVariationIdSINGLEEither 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. optionalNein
SalesPriceVariationIdSINGLEEither 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. optionalNein
SupplierVariationIdSINGLEEither 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. optionalNein
WarehouseVariationIdSINGLEEither 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. optionalNein
UnitIDSINGLEThe id of the unitJa1
UnitContentSINGLEThe content of the unitJa1
CategoryIDSINGLECategory is required to create new Variations. Please enter at least a Category ID or Path to create new Variations.Nein
CategoryPathMULTIPLEVALUECategory is required to create new Variations. Please enter at least a Category ID or Path to create new Variations.Nein
BarcodesMAPEnter barcodes as map (BarcodeID=CodeValue;... e.g. 1=1243123;2=3446)Nein
SalesPricesMAPEnter prices as map (PriceID=PriceValue;... e.g. 1=131.23;2=34.46)Nein
AttributeValuesMULTIPLEVALUEEnter attribute value ids as semicolon separated list (e.g. 23;46)Nein
AttributeValuesStringMAPEnter attribute values as map of attribute backendname and attribute value backendname(e.g. Size=XL;Color=red)Nein
ClientIDsMULTIPLEVALUEEnter ClientIDs (PlentyIDs) as semicolon separated list (e.g. 23241;32412)Nein
MarketIDsMULTIPLEVALUEEnter MarketIDs as semicolon separated list (e.g. 4.01;4.12)Nein
attributeMode STRING Wählen Sie den Modus für die automatische Erstellung von Attributen und Attributwerten (Spalte 'AttributeValuesString'). Nein
  • Deaktiviert
  • Nur neue Attributwerte erstellen
  • Anlegen neuer Attribute und Werte
defaultLanguage STRING Setzen Sie die Standardsprache der Kategorien... 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 Pflichtfeld Werte
results SPREADSHEET Ein SPREADSHEET, das die Ergebnisse des Imports enthält. Ja
Folgende Felder sind im Output enthalten:

Feld Datentyp Beschreibung Pflichtfeld Standardwert
ItemIDSINGLEID of item.Ja
identifierSINGLEThe identifier column to import Spreadsheet into a Datastore.Nein
VariantIDSINGLEVariantID of created variation.Nein
parent_identifierSINGLEThe parent_identifier column to import Spreadsheet into a Datastore.Nein
MainVariantIDSINGLEVariantID of main variation.Nein
NumberSINGLEThe unique variation number of the variation.Nein
ExternalItemIDSINGLEThe external variation ID of this variation. The external variation number is optional and allows importing items and variations from external systems to PlentyONE.Nein
ModelSINGLEThe model of the variation. Value is inherited from the item's main variation if inheritance is active.Nein
MainWarehouseIDSINGLEThe ID of the main warehouse of the variation.Nein
NameSINGLEThe name of the variationNein
AvailabilityIDSINGLEThe availability of the variation.Nein
IsActiveSINGLEFlag that indicates if the variation is active. Only active variations can be offered in the online store and/or on markets.Nein
PurchasePriceSINGLEThe net purchase price. Value e.g. is used for price calculations.Nein
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 variation.Nein
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 selected.Nein
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 order.Nein
UnitsContainedSINGLEThe number of sales units contained in one package.Nein
PalletTypeIdSINGLEThe ID of the pallet typeNein
PackingUnitsSINGLEThe number of packing units if the item consists of multiple packages. Value is 0 if an item is sent as one package. All items of an order that have the value 0 will be packed into one package.Nein
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 price.Nein
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
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
AvailableUntilSINGLEThe last date the item will be available for sale.Nein
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
PackingUnitTypeSINGLEThe ID of the packing unit typeNein
PickingSINGLEThe order picking type of the variation.Nein
PositionSINGLEThe position of the variation. Value is inherited from the item's main variation if inheritance is active.Nein
EstimatedAvailableAtSINGLEThe estimated delivery date of variations on reorder.Nein
PriceCalculationIdSINGLEThe ID of the price calculation linked to the variation.Nein
StockLimitationSINGLEThe stock limitation for the variation.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 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
IsUnavailableIfNetStockIsNotPositiveSINGLEThe 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
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
CategoryVariationIdSINGLEEither 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. optionalNein
MarketVariationIdSINGLEEither 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. optionalNein
ClientVariationIdSINGLEEither 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. optionalNein
SalesPriceVariationIdSINGLEEither 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. optionalNein
SupplierVariationIdSINGLEEither 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. optionalNein
WarehouseVariationIdSINGLEEither 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. optionalNein
UnitIDSINGLEThe id of the unitJa1
UnitContentSINGLEThe content of the unitJa1