Skip to main content

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

To top