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