Item

The data format Item contains all of the data fields for item data. You can use this data format to export, edit and import the item data. Create and export the data format in the Data » Dynamic export menu. Import the data format in the Data » Dynamic import menu. The Exporting data and Importing data pages of the manual describe how you export and import the data format.

Pay close attention to the exact spelling of the data fields. The data cannot be processed if the data fields are spelled incorrectly.

1. Important notes

Each item is given a number (ID) and as such is also uniquely defined by the data field ItemID. The following three scenarios could occur for the export and import:

If the field ItemID is neither exported along with the export of item fields nor imported later on, then new items will be created with available item IDs.
If the data record ItemID is exported and later imported again, then changes will be made to the corresponding items.
If item data is imported with item IDs that do not yet exist in plentymarkets, then new items will be created with these item IDs.

If the import procedure Synchronisation is selected in the data export settings, then the item data will be synchronised during the import.

2. The 1:n problem

The 1:n problem, i.e. one to n, occurs when several characteristics were defined for one item. The following characteristics can be allocated to an item multiple times in plentymarkets:

Price lines

Every price set is uniquely defined by the field PriceID. If this ID is not specified, then a new price set will always be added and the existing prices will be deleted. If available, the existing price will be changed.

Categories

An item can be available in multiple categories at the same time. However, if category data fields (CategoryLevel) were entered during the import, then all of the previous category links for this item will be deleted.

Use the data format Category for new categories

It is not possible to use the data format Item for creating new categories. With the data format Item, you can only create new category links within the item. Use the data format Category instead to create new categories.

Item images

This data format allows you to import external images with the help of URLs. Existing item images will be replaced in the process. If multiple item images are imported, then these item images have to be separated by a comma without spaces when they are entered. If you do not want to replace the existing images, then import the images via FTP upload.

3. Overview of the data fields

Table 1 explains the data fields for the Item data format in alphabetical order as well as filter options that you set in the Filter tab of the data format.

Table 1. Data fields of the data format **Item**
Field name	Explanation	Filter
CategoryLevel1Name - CategoryLevel6Name	Category name of the corresponding level 1 - 6. During the data import, only one category link will be imported per item. If an item has multiple category levels, then these levels may be deleted during the import or re-import. Therefore, do not use these data fields for the category import. The data format ItemCategories is available for categories.	Activate the filter and select the name of the category level from the drop-down list.
CategoryRakuten	Rakuten category
CategoryYatego	List of the Yatego categories for these items (separated by commas)
IsNet	True = Prices (ItemPrices) will be exported as net. False = Prices (ItemPrices) will be exported as gross.
ItemAction	Sales specials; special display mode 1 = Special offer 2 = New items 3 = Top items
ItemAgeRestriction	Age rating; numerical value 0 = None available 3 = Released for ages 3 and up 6 = Ages 6 and up 12 = Ages 12 and up 16 = Ages 16 and up 18 = Ages 18 and up 50 = Not marked 88 = Not required 99 = Still unknown
ItemAmazonFBA	Fulfillment by Amazon (FBA) 0 = Do not use 1 = AMAZON EU 2 = AMAZON FE 3 = AMAZON NA -1 = FBA and SellerCentral
ItemAmazonProductType	Amazon product type; for possible values, see amazon_product_type value table.	Activate the filter and select the Amazon product type for the item from the drop-down list.
ItemAPICondition	Item condition. This is transferred via the API to other markets 0 = New 1 = Used but as new 2 = Used but very good 3 = Used but good 4 = Used but acceptable 5 = Factory seconds
ItemCondition	Item condition 0 = New 1 = Used 2 = New and in original packaging 3 = New with label 4 = Factory seconds
ItemCustomsTariffNumber	Customs tariff number
ItemDeepLink	The item’s URL
ItemDraft	Item template ID. The ID of a category, which was defined as an item template
ItemEbayCategory	eBay category; used when a new listing is created.
ItemEbayCategory2	eBay category 2; used when a new listing is created.
ItemEbayPreset	ID of the listing’s option template. The listing template settings are used when creating new listings.
ItemEbayShopCategory	ID of the first eBay shop category. This value is used for new listings.
ItemEbayShopCategory2	ID of the second eBay shop category. This value is used for new listings.
ItemFEDAS	FEDAS product classification key. The setting is found under Item » Edit item » Open item » Open variation » Tab: Multi-Channel
ItemFreeTextField1 - ItemFreeTextField20	Free text fields that can be displayed in the online store or on eBay. The setting is found under Item » Edit item » Open item » Open variation » Tab: Fields
ItemID	Unique item ID; maximum numerical value 2^31	Activate the filter, select the operator and enter the value.
ItemImageURL	Image URL; format: JPG The image will be imported and saved on the plentymarkets server. Separate multiple URLs with a comma. *Note*: When importing item images, the new images will not be added to the already existing images. Rather, they will replace the existing images.
ItemInsertedTimestamp	Date and time when the item was created. Format: dd.mm.yyyy hh:mm *Note*: The field is available for the export only.
ItemLastUpdateTimestamp	Last change to an item; date and time. Format: dd.mm.yyyy hh:mm
ItemMarking1	Flag 1 as ID (1-31), symbols. 0 = no flag	Activate the filter, select the operator and the flag from the drop-down list.
ItemMarking2	Flag 2 as ID (1-11), personal icons 0 = no flag	Activate the filter, select the operator and the flag from the drop-down list.
ItemModel	Item model name
ItemNoCoupon	Coupon 0 = Possible 1 = Prohibited 2 = Purchasable with coupon only
ItemOriginCountry	The item’s manufacturing country
ItemProducer	The item’s manufacturer A manufacturer is not created automatically in the system when using this data format. Rather, the manufacturer has to already be available in the system. Make sure that you spell the name of the manufacturer correctly when using this data field.
ItemProducerID	The item’s manufacturer ID	Activate the filter and select the manufacturer from the drop-down list.
ItemProductType	Item type 0 = Stocked item 1 = Production item 2 = Colli 3 = Special order item
ItemRevenueAccount	Revenue account
ItemSCOMinPrice	All of the Second Chance Offers and best offers that are above this minimum price will automatically be accepted.
ItemSerialNumber	The item’s serial number
ItemShippingWithAmazonFBA	Amazon Multi-Channel 1 = Yes 0 = No
ItemSubscription	Can the item be ordered as a subscription? 0 = No 1 = Yes
ItemTextDescription	Item description
ItemTextKeywords	HTML meta keywords (search terms); separated by commas (word1,word2,word3).
ItemTextLang	Available languages: de / en / fr / it / es / tr / nl / pl / nn / da / se / cz (German, English, French, Italian, Spanish, Turkish, Dutch, Polish, Norwegian, Danish, Swedish, Czech)
ItemTextMeta	Item description in the source text; important for search machines
ItemTextName	Item name
ItemTextName2 and ItemTextName3	Additional names of the item
ItemTextShort	Short item description; preview text
ItemTextTechnicalData	The item’s technical data
ItemTextURLContent	The item’s URL path
NeckermannProductTypeEpAT	Neckermann product type; Enterprise version Austria
NeckermannProductTypeCdAT	Neckermann product type; Cross-Docking version Austria
PrimaryVariationActive	Y = Main variation is active, i.e. it is available in the online store and on markets. N = The main variation is not active. Setting Active in the Settings tab of the main variation
PrimaryVariationAutoStockInvisible	Y = Main variation becomes invisible automatically in the online store if no positive net stock is available. N = Main variation stay visible in the online store if no positive net stock is available. Setting Not available if net stock is 0 or negative in the Settings tab of the main variation
PrimaryVariationAutoStockNoPositiveStockIcon	The item’s availability icon 0 = Has to be deactivated manually. 1 = Hide when there is no net stock.
PrimaryVariationAutoStockPositiveStockIcon	The item’s availability icon 0 = Main variation has to be activated manually. 1 = Main variation is displayed if net stock is positive.
PrimaryVariationAutoStockVisible	Main variation automatically is visible in the online store if stock is available. 0 = No 1 = Yes
PrimaryVariationAvailability	ID of the availability of the main variation; System » System settings » Item » Availability menu Setting Availability in the Settings tab of the main variation
PrimaryVariationAvailableUntil	Last date that the main variation is available. Setting Available until in the Settings tab of the main variation Format: DD.MM.YYYY
PrimaryVariationCustomNumber	Number of the main variation Setting Variation No in the Settings tab of the main variation
PrimaryVariationExternalID	External ID of the main variation Setting External variation ID in the Settings tab of the main variation
PrimaryVariationExtraShippingCharge1; PrimaryVariationExtraShippingCharge2	Extra shipping charge of the main variation Settings Extra shipping charge 1 and Extra shipping charge 2 in the Settings tab of the main variation
PrimaryVariationHeightMM	Height of the main variation in millimetres (mm)
PrimaryVariationIntervalOrderQuantity	The quantity intervals the main variation can be ordered in. Decimal values are possible to allow for orders by weight or length. Setting Interval order quantity in the Settings tab of the main variation
PrimaryVariationLengthMM	Length of the main variation in millimetres (mm)
PrimaryVariationLimitOrderByStockSelect	Limit the main variation to stock 0 = No limitation 1 = Limited to net stock 2 = Do not administer stock for this item Setting Limitation in the Settings tab of the main variation
PrimaryVariationMainWarehouse	ID of the main warehouse of the main variation Setting Main warehouse in the Settings tab of the main variation
PrimaryVariationMaximumOrderQuantity	Maximum order quantity of the main variation Setting Max. order quantity in the Settings tab of the main variation
PrimaryVariationMinimumOrderQuantity	Minimum order quantity of the main variation Setting Min. order quantity in the Settings tab of the main variation
PrimaryVariationModel	Model name of the main variation
PrimaryVariationName	Name of the main variation Setting Variation name in the Settings tab of the main variation
PrimaryVariationPurchasePrice	Net purchase price of the main variation Setting Purchase price (net) in the Settings tab of the main variation
PrimaryVariationReleaseDate	Date on which the main variation becomes available. Setting Release date in the Settings tab of the main variation Format: YYYY-MM-DD hh:mm:ss
PrimaryVariationStorageCosts	Storage costs of the main variation Setting Storage costs (net) in the Settings tab of the main variation
PrimaryVariationTransportationCosts	Net transportation costs of the main variation
PrimaryVariationUnitCombinationContent	Quantity contained within the unit Value of the Content filed in the Settings tab of the main variation
PrimaryVariationUnitContained	Units contained Setting Units contained in the Settings tab of the main variation
PrimaryVariationUnitID	ID of the unit of the main variation; list of IDs can be found in the System » System settings » Item » Availability menu Selection in the Content drop-down list in the Settings tab of the main variation
PrimaryVariationVAT	ID of the main variation’s VAT code (Value added tax); menu System » System settings » Client » Select client » Locations » Select location » Accounting 0 = Data record A 1 = Data record B 2 = Data record C 3 = Data record D
PrimaryVariationWeightG	Main variation’s gross weight in grams (g)
PrimaryVariationWeightNetG	Main variation’s net weight in grams (g)
PrimaryVariationWidthMM	Width of the main variation in millimetres (mm)
VariationAttributes	List of the attributes and attribute values linked to the main variation. The internal attribute name is followed by a colon and then the internal name of the attribute value. More than one attribute values are separated by a semicolon. *Example:* colour:red;purple

4. Overview of the synchronisation fields

The data fields that are listed in table 2 are available for data synchronisation. These data fields are compulsory synchronisation fields. At least one of the data fields from the following table must be selected for synchronisation. For the selected data field, select the option Synchronisation as Import procedure.

Table 2. Data fields with the import procedure set to **Synchronisation**
Field name	Explanation
ItemID	Item ID
PrimaryVariationCustomNumber	Number of the main variation
PrimaryVariationExternalID	External ID of the main variation

ItemID field

The field ItemID is usually a mandatory synchronisation field. However, this field does not necessarily have to be used for this data format. You can use any of the fields listed. One field is sufficient for the synchronisation.

5. Overview of the procedures

In the Procedures tab, select which procedures you want to be carried out during the data export. Activate the ItemLastUpdateTimestamp procedure. Select the set the current date option from the drop-down list. A timestamp will be added to items during the import, indicating when the items were last changed.

6. amazon_product_type value table

An overview of the Amazon product types is available here. The table contains the ID, the name of the export format, the product type, and the names of the main categories and subcategories in plentymarkets.