Item
The data format Item contains all of the data fields for item data. Create and export the data format in the Data » Dynamic export menu. The Exporting data page of the manual describes how you export 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.
Field name | Explanation | Filter |
---|---|---|
CategoryLevel1Name - CategoryLevel6Name |
Category name of the corresponding level 1 - 6. |
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. |
|
ItemAction |
Sales specials; special display mode |
|
ItemAgeRestriction |
Age rating; numerical value |
|
ItemAmazonFBA |
Fulfillment by Amazon (FBA) |
|
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 |
|
ItemCondition |
Item condition |
|
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 |
|
ItemInsertedTimestamp |
Date and time when the item was created. Format: dd.mm.yyyy hh:mm |
|
ItemLastUpdateTimestamp |
Last change to an item; date and time. Format: dd.mm.yyyy hh:mm |
|
ItemMarking1 |
Flag 1 as ID (1-31), symbols. |
Activate the filter, select the operator and the flag from the drop-down list. |
ItemMarking2 |
Flag 2 as ID (1-11), personal icons |
Activate the filter, select the operator and the flag from the drop-down list. |
ItemModel |
Item model name |
|
ItemNoCoupon |
Coupon |
|
ItemOriginCountry |
The item’s manufacturing country |
|
ItemProducer |
The item’s manufacturer |
|
ItemProducerID |
The item’s manufacturer ID |
Activate the filter and select the manufacturer from the drop-down list. |
ItemProductType |
Item type |
|
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 |
|
ItemSubscription |
Can the item be ordered as a subscription? |
|
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. |
|
PrimaryVariationAutoStockInvisible |
Y = Main variation becomes invisible automatically in the online store if no positive net stock is available. |
|
PrimaryVariationAutoStockNoPositiveStockIcon |
The item’s availability icon |
|
PrimaryVariationAutoStockPositiveStockIcon |
The item’s availability icon |
|
PrimaryVariationAutoStockVisible |
Main variation automatically is visible in the online store if stock is available. |
|
PrimaryVariationAvailability |
ID of the availability of the main variation; Setup » Item » Availability menu |
|
PrimaryVariationAvailableUntil |
Last date that the main variation is available. |
|
PrimaryVariationCustomNumber |
Number of the main variation |
|
PrimaryVariationExternalID |
External ID of the main variation |
|
PrimaryVariationExtraShippingCharge1; |
Extra shipping charge 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. |
|
PrimaryVariationLengthMM |
Length of the main variation in millimetres (mm) |
|
PrimaryVariationLimitOrderByStockSelect |
Limit the main variation to stock |
|
PrimaryVariationMainWarehouse |
ID of the main warehouse of the main variation |
|
PrimaryVariationMaximumOrderQuantity |
Maximum order quantity of the main variation |
|
PrimaryVariationMinimumOrderQuantity |
Minimum order quantity of the main variation |
|
PrimaryVariationModel |
Model name of the main variation |
|
PrimaryVariationName |
Name of the main variation |
|
PrimaryVariationPurchasePrice |
Net purchase price of the main variation |
|
PrimaryVariationReleaseDate |
Date on which the main variation becomes available. |
|
PrimaryVariationStorageCosts |
Storage costs of the main variation |
|
PrimaryVariationTransportationCosts |
Net transportation costs of the main variation |
|
PrimaryVariationUnitCombinationContent |
Quantity contained within the unit |
|
PrimaryVariationUnitContained |
Units contained |
|
PrimaryVariationUnitID |
ID of the unit of the main variation; list of IDs can be found in the Setup » Item » Availability menu |
|
PrimaryVariationVAT |
ID of the main variation’s VAT code (Value added tax); menu Setup » Client » Select client » Locations » Select location » Accounting |
|
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. |
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.
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.