| identifier | SINGLE | The identifier column to import Spreadsheet into a Datastore. | |
| VariantID | SINGLE | The ID of the variation | |
| ItemID | SINGLE | The item ID of the item that this variation belongs to | |
| 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 | |
| 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 | |
| StockLimitation | SINGLE | The stock limitation for the variation. | |
| 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). | |
| 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. | |
| CategoriesInherited | SINGLE | True if categories are inherited from the main variation. | |
| ReferrerInherited | SINGLE | True if markets/referrer are not inherited from the main variation. ID of the item's main variation = Inheritance of markets is active. | |
| ClientsInherited | SINGLE | True if clients (stores) are not inherited from the main variation. ID of the item's main variation = Inheritance of clients (stores) is active. | |
| SalesPricesInherited | SINGLE | True if sales prices are not inherited from the main variation. ID of the item's main variation = Inheritance of sales prices is active. | |
| SupplierInherited | SINGLE | True if suppliers are not inherited from the main variation. ID of the item's main variation = Inheritance of suppliers is active. | |
| WarehousesInherited | SINGLE | True if warehouses are not inherited from the main variation. ID of the item's main variation = Inheritance of warehouses is active. | |
| PropertiesInherited | SINGLE | True if properties are not inherited from the main variation. ID of the item's main variation = Inheritance of suppliers is active. | |
| TagsInherited | SINGLE | True if 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. | |
| Picking | SINGLE | The order picking type of the variation. | |
| 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. | |
| PriceCalculationId | SINGLE | The ID of the price calculation linked to the variation. | |
| 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. | |
| 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 | (deprecated) The Amazon product type of the item. | |
| ItemAmazonProductType2 | SINGLE | The Amazon product type of the item. List of IDs: https://cdn02.plentymarkets.com/pmsbpnokwu6a/frontend/Amazon_Product-Type-Mapping.xlsx | |
| 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. | |
| UnitCombinationId | SINGLE | | |
| UnitID | SINGLE | The id of the unit | |
| UnitContent | SINGLE | The content of the unit | |
