Skip to main content

Item

This page explains the matching and mapping fields that you can use while importing item and variation data. This page serves purely as a reference and it assumes that you already have a basic understanding of the ElasticSync tool.

Requirements

In order to import item data via ElasticSync, the following data records must be present in plentymarkets:

  • Categories (Item » Category menu)

  • Sales prices (Setup » Item » Sales prices menu)

In order to import variation data with attributes via ElasticSync, the following data records must be present in plentymarkets:

  • Attributes and attribute values (Setup » Item » Attributes menu)

Practical example: Importing new items

Imagine you’re new to plentymarkets and you want to import all of your items and variations at once. How would that work? Take a look at this practical example, which guides you through the process step-by-step.

1. Fields for item matching

Table 1 explains the fields that are available for matching item data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 1. Matching fields for importing items
Matching field Explanation

Variation ID

Variation no.

External variation ID

Barcode

Select the barcode type from the second drop-down list.

Item ID

For variations with attributes, use this field only in combination with attribute selection combination.

Attribute selection combination

For variations with attributes, use this field only in combination with the item ID. Select the format from the second drop-down list that contains the data of the file.

Supplier item No.

2. Fields for the item mapping

This chapter explains the fields that are available for mapping item and variation data.

Many different mapping fields are available for the Item sync type. As such, the following explanations have been divided into sub-chapters.

No mapping field? Default value applies!

If you don’t include a certain piece of information in your CSV file, i.e. if you don’t use a certain mapping field, then your item or variation will be given the default value.

2.1. Item

Table 2 explains the fields that are available for mapping various item data. These mapping fields correspond, e.g. to the tabs Global, Multi-Channel and Fields within the upper row of tabs in an item data record.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the item data record once it’s been imported, then you’ll see that the settings in the upper row of tabs were configured as follows.

Table 2. Fields for importing items
Mapping field Permitted import values Default value Explanation

Stock type

0
1
2
3

0

Corresponds to the drop-down list under:
Tab: Global » Area: Basic settings » Option: Type

  • 0 = Stocked item

  • 1 = Production item

  • 2 = Colli

  • 3 = Special order item

Store special

0
1
2
3

0

Corresponds to the drop-down list under:
Tab: Global » Area: Online store » Option: Store special

  • 0 = None

  • 1 = Special offer

  • 2 = New item

  • 3 = Top item

Manufacturer ID

Numeric (internal ID)

- n/a -

Corresponds to the drop-down list under:
Tab: Global » Area: Basic settings » Option: Manufacturer

Data is mapped according to the manufacturer ID in the menu Setup » Item » Manufacturers.

Manufacturing country

Numeric (internal ID);
0

Germany

Data is mapped according to the list of country IDs.

  • 0 = unknown

Revenue account

Numeric

0

Corresponds to the entry field under:
Tab: Global » Area: Basic settings » Option: Revenue account

Coupon for special offers

0
1
2

0

  • 0 = Permitted

  • 1 = Not permitted

  • 2 = Purchasable with coupon only

Condition

0
1
2
3
4

0

Corresponds to the drop-down list under:
Tab: Global » Area: Basic settings » Option: Condition

  • 0 = New

  • 1 = Used

  • 2 = New & with original packaging

  • 3 = New with label

  • 4 = Factory seconds

Condition for API

0
1
2
3
4
5

0

Corresponds to the drop-down list under:
Tab: Global » Area: Basic settings » Option: Condition for API

  • 0 = New

  • 1 = Used but as new

  • 2 = Used but very good

  • 3 = Used but good

  • 4 = Used but acceptable

  • 5 = Factory seconds

Subscription (yes/no)

0
1

0

Corresponds to the drop-down list under:
Tab: Global » Area: Basic settings » Option: Subscription

  • 0 = No

  • 1 = Yes

Serial number (yes/no)

0
1

0

Corresponds to the drop-down list under:
Tab: Global » Area: Basic settings » Option: Serial number

  • 0 = No

  • 1 = Yes

Shipping package (yes/no)

0
1

0

Corresponds to the drop-down list under:
Tab: Global » Area: Basic settings » Option: Shipping package

  • 0 = No

  • 1 = Yes

Fulfilment by Amazon (FBA)

0
1
2
3
-1

0

Corresponds to the drop-down list under:
Tab: Multi-Channel » Area: Amazon » Option: FBA Fulfillment

  • 0 = Do not use

  • 1 = AMAZON_EU

  • 2 = AMAZON_FE

  • 3 = AMAZON_NA

  • -1 = FBA and SellerCentral

Shipment by Amazon (FBA)

0
1

0

  • 0 = No check mark

  • 1 = Check mark

Amazon product type

Numeric

Unknown

Corresponds to the drop-down list under:
Tab: Multi-Channel » Area: Amazon » Option: Product type

Data is mapped according to the value table amazon_product_type.

Amazon FEDAS

0
1

FEDAS product group key

  • 0 = No

  • 1 = Yes

Listing template

Numeric (internal ID)

- n/a -

Corresponds to the drop-down list under:
Tab: Multi-Channel » Area: Listing default settings » Option: Listing template

Data is mapped according to the listing template ID in the menu Listings » Listings.

Listing category 1;
Listing category 2

Numeric

- n/a -

Corresponds to the entry field under:
Tab: Multi-Channel » Area: Listing default settings » Option: Category 1

Listing store category 1;
Listing store category 2

Numeric

- n/a -

Corresponds to the entry field under:
Tab: Multi-Channel » Area: Listing default settings » Option: Store category 1

Rakuten.de categories

Numeric (internal ID)

- n/a -

Corresponds to the entry field under:
Tab: Multi-Channel » Area: Category link » Option: Rakuten.de

Flag 1;
Flag 2

Numeric (internal ID)

- n/a -

Corresponds to the item’s flag.

Data is mapped according to the flag’s ID in the menu Setup » Item » Flags » Tab: Flag 1 or Flag 2

Age rating

0
3
6
12
16
18
50
88
99

0

Corresponds to the drop-down list under:
Tab: Global » Area: Basic settings » Option: Age rating

  • 0 = None available

  • 3 = Released for age 3 and older

  • 6 = Released for age 6 and older

  • 12 = Released for age 12 and older

  • 16 = Released for age 16 and older

  • 18 = Released for age 18 and older

  • 50 = Not marked

  • 88 = Not required

  • 99 = Still unknown

Item feedback

Numeric

0

Corresponds to the entry field under:
Tab: Global » Area: Online store » Option: Item feedback

Field 1;
Field 2;
Field 3;
…​
Field 20

Alphanumeric

- n/a -

Corresponds to free text fields 1 through 20 under:
Tab: Fields

Max. item order quantity

Numeric

0

Corresponds to the entry field under:
Tab: Global » Area: Basic settings » Option: Max. order quantity

Type

standard
multipack
set

standard

While creating a new item, this corresponds to the drop-down list under:
Tab for creating a new item » Area: Item data » Option: Type

  • standard = Default item

  • multipack = Multipack item

  • set = Set item

Manufacturer name

Alphanumeric

- n/a -

Corresponds to the drop-down list under:
Tab: Global » Area: Basic settings » Option: Manufacturer

Data is mapped according to the manufacturer’s name. If the manufacturer data record doesn’t already exist in the system, then a new manufacturer data record will be created.

Delete item

0
1

0

Do you want to delete some items and update others? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the item should be deleted.

  • 0 = No

  • 1 = Yes

2.2. Item sets

Table 3 explains the fields that are available for mapping item sets. These mapping fields correspond to your possibilities for adding components to an item set.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the item set once it’s been imported, then you’ll see that the settings in the Set tab were configured as follows.

Table 3. Fields for importing item sets
Mapping field Permitted import values Explanation

Add components (IDs, comma-separated)

Alphanumeric

ID and quantity of the items to be added to the set
Format: itemID:quantity,itemID:quantity

Remove components (IDs, comma-separated)

Alphanumeric

IDs of the items to be removed from the set

Discount

Decimal number

Discount on total price of set in %

2.3. Cross-selling

Table 4 explains the fields that are available for mapping cross-selling items. These mapping fields correspond to your possibilities for generating additional sales with cross-selling.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the item once it’s been imported, then you’ll see that the cross-selling links were configured as follows.

Table 4. Fields for importing cross-selling links
Mapping field Permitted import values Explanation

Delete all cross selling links

0
1

Do you want to delete all of the cross-selling links from the item data record? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the cross-selling links should be deleted.

  • 0 = No

  • 1 = Yes

Add cross-selling links

Alphanumeric

Do you want to create new cross-selling links? Enter information about the links in this format: Item-ID:RelationshipType;Item-ID:RelationshipType;etc.

Available relationship types:

  • Accessory = Accessory

  • ReplacementPart = Replacement part

  • Similar = Similar

  • Bundle = Item bundle

Delete cross selling links

Numeric

Do you want to delete some of the cross-selling links from the item data record? Enter the cross-selling links that should be deleted in this format: ItemID;itemID;etc.

2.4. Item texts

Table 5 explains the fields that are available for mapping item descriptions. These mapping fields correspond to the settings in the item text tab.

Enter the texts in your CSV file. Create one mapping per language. If you open the item once it’s been imported, then you’ll see that these texts were saved for the item.

Table 5. Fields for importing item descriptions
Mapping field Permitted import values Explanation

Name;
Name 2;
Name 3

Alphanumeric

Enter a name for the item in your CSV file. Make sure you also select the language within the Mapping area.

Corresponds to the entry field under:
Tab: Texts » Option: Name 1, 2, 3

Preview text

Alphanumeric

Enter a preview text for the item in your CSV file. Make sure you also select the language within the Mapping area.

Corresponds to the entry field under:
Tab: Texts » Option: Preview text

Meta description

Alphanumeric

Enter a meta description for the item in your CSV file. Make sure you also select the language within the Mapping area.

Corresponds to the entry field under:
Tab: Texts » Option: Meta description

Item text

Alphanumeric

Enter a text for the item in your CSV file. Make sure you also select the language within the Mapping area.

Corresponds to the entry field under:
Tab: Texts » Option: Item text

Technical data

Alphanumeric

Enter technical data for the item in your CSV file. Make sure you also select the language within the Mapping area.

Corresponds to the entry field under:
Tab: Texts » Option: Technical data

URL path

Link

Enter a URL path for the item in your CSV file. Make sure you also select the language within the Mapping area.

Corresponds to the entry field under:
Tab: Texts » Option: URL path

Meta keywords

Alphanumeric

Enter meta keywords for the item in your CSV file. Make sure you also select the language within the Mapping area.

Corresponds to the entry field under:
Tab: Texts » Option: Meta keywords

2.5. Shipping profile

Table 6 explains the fields that are available for mapping shipping profiles. These mapping fields correspond to your possibilities for linking shipping profiles to items.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the item once it’s been imported, then you’ll see that the shipping profiles were linked as follows.

Table 6. Matching fields for shipping profiles
Mapping field Permitted import values Explanation

Shipping profile ID

Numeric

Enter the ID of whichever shipping profile should be linked to the item.

You can look up the shipping profile IDs in the menu Setup » Orders » Shipping » Settings » Tab: Shipping profiles.

Shipping profiles (separated by commas)

Numeric

Do you want to link more than just one shipping profile? Enter the IDs of all the shipping profiles that should be linked to the item. Enter the IDs in this format: Profile-ID1,Profile-ID2,…​

You can look up the shipping profile IDs in the menu Setup » Orders » Shipping » Settings » Tab: Shipping profiles.

Delete shipping profile links (profile IDs, comma-separated)

Alphanumeric

Do you want to delete some of the links? Enter the IDs of all the shipping profiles that should no longer be linked to the item. Enter the IDs in this format: Profile-ID1,Profile-ID2,…​

You can look up the shipping profile IDs in the menu Setup » Orders » Shipping » Settings » Tab: Shipping profiles.

2.6. Item variations

Table 7 explains the fields that are available for mapping variation data. These mapping fields correspond to the information in the lower row of tabs within an item data record.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the settings in the lower row of tabs were configured as follows.

Table 7. Matching fields for variations
Mapping field Permitted import values Default value Explanation

ID

Numeric

- n/a -

Corresponds to the variation ID.

Item ID

Numeric

- n/a -

Corresponds to the item ID.

Position

Numeric

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Basic settings » Option: Position

Active

0
1

0

  • 0 = No check mark

  • 1 = Check mark

Variation no.

Alphanumeric

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Basic settings » Option: Variation No.

Model

Alphanumeric

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Basic settings » Option: Model

External variation ID

Alphanumeric

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Basic settings » Option: External variation ID

Availability

Numeric (internal ID)

1

Corresponds to the availability symbols 1 through 10 under:
Tab: Variation ID » Tab: Settings » Area: Availability » Option: Availability

Net purchase price

Numeric

0

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Costs » Option: Net purchase price

Mov. av. purchase price (net)

Numeric

0

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Costs » Option: Moving average purchase price (net)

Price calculation

Numeric (internal ID)

- n/a -

Applies a price calculation to whichever prices were saved for the variation. In other words, it corresponds to the third drop-down list under:
Tab: Variation ID » Tab: Settings » Area: Sales prices

Data is mapped according to the price calculation ID in the menu Setup » Item » Calculation » Open price calculation.

Stock limit

0
1
2

1

  • 0 = None

  • 1 = To net stock

  • 2 = Do not administer stock for this variation

Visibility of client: Visible automatically if net stock is positive;
Visibility of client: Invisible automatically if net stock is 0 or negative

0
1

0

Corresponds to the checkbox with the same name under:
Tab: Variation ID » Tab: Settings » Area: Availability

  • 0 = No check mark

  • 1 = Check mark

Availability of online store Available automatically if net stock is positive
Availability of online store Not available automatically if net stock is 0 or negative

0
1

0

Corresponds to the checkbox with the same name under:
Tab: Variation ID » Tab: Settings » Area: Availability

  • 0 = No check mark

  • 1 = Check mark

Visibility of item list: Visible automatically if net stock is positive;
Visibility of item list: Invisible automatically if net stock is 0 or negative

0
1

0

Corresponds to the checkbox with the same name under:
Tab: Variation ID » Tab: Settings » Area: Availability

  • 0 = No check mark

  • 1 = Check mark

Main warehouse

Numeric (internal ID)

- n/a -

Corresponds to the drop-down list under:
Tab: Variation ID » Tab: Settings » Area: Shipping » Option: Main warehouse

Data is mapped according to the warehouse ID in the menu Setup » Stock » Warehouse » Open warehouse » Settings.

Max. order quantity

Numeric

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Availability » Option: Max. order quantity

Min. order quantity

Numeric

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Availability » Option: Min. order quantity

Interval order quantity

Numeric

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Availability » Option: Interval order quantity

Available until

Date
(DD.MM.YYYY)

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Availability » Option: Available until

Release date

Date
(DD.MM.YYYY)

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Availability » Option: Release date

Name

Alphanumeric

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Basic settings » Option: Variation name

Gross weight in g;
Net weight in g

Numeric

0

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Dimensions » Option: Gross weight and Net weight

Make sure you enter the weight in grams rather than kilograms.

Width mm;
Length mm;
Height mm

Numeric

0

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Dimensions » Option: Length/Width/Height

Make sure you enter the dimensions in millimetres.

Extra shipping charge 1;
Extra shipping charge 2

Numeric

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Shipping » Option: Extra shipping charge 1 and Extra shipping charge 2

Units contained

Numeric

1

Packaging unit. Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Dimensions » Option: Units contained

Number of packing units

0
1
2
…​
20

- n/a -

Corresponds to the first drop-down list under:
Tab: Variation ID » Tab: Settings » Area: Shipping » Option: Packing units

Use this mapping field together with Packing unit type.

Packing unit type

0
1
2
…​
39

- n/a -

Use this mapping field together with Number of packing units.

  • 0 = No packaging

  • 1 = Bale

  • 2 = Dispenser

  • 3 = Coil

  • 4 = Roll pallet

  • 5 = Colli

  • 6 = Container

  • 7 = Bucket

  • 8 = Cask

  • 9 = Bottles

  • 10 = European flat pallet

  • 11 = Structural frame

  • 12 = Gas cylinder

  • 13 = Pallet cage

  • 14 = Hobbock

  • 15 = Half pallet

  • 16 = Pallet of food items

  • 17 = Wooden coaster

  • 18 = IBC container

  • 19 = Pitcher

  • 20 = Wicker bottle

  • 21 = Case

  • 22 = Canister

  • 23 = Customer pallet

  • 24 = Cardboard box

  • 25 = Composite packaging

  • 26 = Package

  • 27 = Ring

  • 28 = Roll

  • 29 = Sack

  • 30 = Unit

  • 31 = Tank

  • 32 = Drum

  • 34 = Crate

  • 35 = Quarter pallet

  • 36 Other pallets

  • 37 = Bin

  • 38 = One-way pallet

  • 39 = Foil bag

Net transportation costs

Numeric

0

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Costs » Option: Net transportation costs

Net storage costs

Numeric

0

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Costs » Option: Net storage costs

Customs

Numeric (Percentage value)

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Costs » Option: Customs

Customs tariff number

Numeric

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Costs » Option: Customs tariff number

Operating costs

Numeric (Percentage value)

- n/a -

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Costs » Option: Operating costs

VAT

Numeric (Percentage value)

Corresponds to the drop-down list under:
Tab: Variation ID » Tab: Settings » Area: Costs » Option: VAT

Bundle type

bundle = Variation is a bundle
bundle_item = Variation is a bundle component

Visibility of item list: Always invisible

0
1

  • 0 = No

  • 1 = Yes

Show unit price

0
1

0

Calculate gross weight from bundle components;
Calculate net weight from bundle components;
Calculate net purchase price from bundle components;
Calculate moving average purchase price (net) from bundle components

0
1

  • 0 = No

  • 1 = Yes

Note: These check boxes are only visible for item bundles.

Order picking

single_picking
no_single_picking
exclude_from_picklist

no_single_picking

  • single_picking = Single order picking possible

  • no_single_picking = Single order picking not possible

  • exclude_from_picklist = Exclude from pick list

Delete variation

0
1

0

Do you want to delete some variations and update others? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the variation should be deleted.

  • 0 = No

  • 1 = Yes

Number of the main variation

Alphanumeric

Make available for client despite negative net stock

0
1

0

Corresponds to the lock symbol in Tab: Availability » Area: Client (store).

Background info: plentymarkets can automatically remove variations from the online store if they are no longer in stock. This automatic process is controlled by the settings in Tab: Settings » Area: Availability.

Use this mapping field if you want to manually make the variation visible in the online store despite the fact that it’s not in stock.

This setting remains valid until new stock is booked for the variation. Once net stock for the variation becomes positive, the availability and visibility settings if net stock is 0 or negative take effect again.

  • 0 = Variation will not manually be made visible

  • 1 = Variation will manually be made visible

2.7. Barcodes

Table 8 explains the fields that are available for mapping barcode data. These mapping fields correspond to your possibilities for assigning barcodes to items.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the item once it’s been imported, then you’ll see that the barcodes were linked as follows.

Table 8. Fields for importing barcodes
Mapping field Permitted import values Explanation

Code

Alphanumeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Barcode » Option: Code

Enter the alphanumeric code into your CSV file. Select the barcode type from the second drop-down list in the Mapping area.

Delete barcode

0
1

Do you want to delete a barcode from the item data record? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the barcode should be deleted.

  • 0 = No

  • 1 = Yes

Select the barcode type that should be deleted from the second drop-down list in the Mapping area.

2.8. Sales prices

Table 9 explains the fields that are available for mapping prices. These mapping fields correspond to your possibilities for saving prices for variations.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the prices were saved as follows.

Table 9. Fields for importing variation prices
Mapping field Permitted import values Explanation

Price

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Sales prices » Option: Price

Enter the monetary amount in your CSV file. Select the sales price from the second drop-down list in the Mapping area.

Delete price

0
1

Do you want to delete a price from the item data record? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the price should be deleted.

  • 0 = No

  • 1 = Yes

Select whichever sales price should be deleted from the second drop-down list in the Mapping area.

Net price (Yes/No)

0
1

Is the monetary price a net price? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the price will be a net price.

  • 0 = No (it’s a gross price)

  • 1 = Yes (it’s a net price)

Select the sales price from the second drop-down list in the Mapping area.

2.9. Categories

Table 10 explains the fields that are available for mapping category data. These mapping fields correspond to your possibilities for sorting items into categories.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the categories were linked as follows.

Table 10. Fields for importing categories
Mapping field Permitted import values Explanation

Category ID

Numeric (internal ID)

Links one category to the variation. Corresponds to the information under:
Tab: Variation ID » Tab: Categories » Area: Linked categories » Option: ID

Enter a category ID into the CSV file. You can find the category IDs in the menu Item » Category (ID appears when you move your mouse over a category).

Position

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Categories » Area: Linked categories » Option: Position

Enter the position number in the CSV file.

Is Neckermann.de main category

0
1

  • 0 = No

  • 1 = Yes

Category name

Alphanumeric

Links one category to the variation. Corresponds to the information under:
Tab: Variation ID » Tab: Categories » Area: Linked categories » Option: Category

Enter the complete category path, separated by semicolons. For example:
Shoes;Unisex

Delete all category links

0
1

Do you want to delete all of the category links from the item data record? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the links should be deleted.

  • 0 = No

  • 1 = Yes

Note: The categories themselves will not be deleted. The links will simply be removed from the variation.

Category IDs (separated by commas)

Alphanumeric

Links multiple categories to the variation. Corresponds to the information under:
Tab: Variation ID » Tab: Categories » Area: Linked categories » Option: ID

Enter the category IDs into the CSV file. Separate the IDs with commas. For example:
ID1,ID2,ID3,etc

You can find the category IDs in the menu Item » Category (ID appears when you move your mouse over a category).

Category names (separated by commas)

Alphanumeric

Links multiple categories to the variation. Corresponds to the information under:
Tab: Variation ID » Tab: Categories » Area: Linked categories » Option: Category

Enter the complete category path, separated by semicolons. Separate the category paths with commas. For example:
Shoes;Unisex,Shoes;Women,Shoes;Men

Delete links (Category IDs, separated by commas)

Alphanumeric

Do you want to delete some of the category links from the item data record? Enter the IDs of whichever categories should be deleted into your CSV file. Separate the IDs with commas. For example:
ID1,ID2,ID3,etc

You can find the category IDs in the menu Item » Category (ID appears when you move your mouse over a category).

Note: The categories themselves will not be deleted. The links will simply be removed from the variation.

Delete links (Category names, separated by commas)

Alphanumeric

Do you want to delete some of the category links from the item data record? Enter the names of whichever categories should be deleted into your CSV file. Separate the category paths with commas. For example:
Shoes;Unisex,Shoes;Women,Shoes;Men

Note: The categories themselves will not be deleted. The links will simply be removed from the variation.

Create not found categories

0
1

Do you want to create the category, if this category doesn’t already exist? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the category should be created.

  • 0 = No

  • 1 = Yes

2.10. Default categories

Table 11 explains the fields that are available for mapping default category data. These mapping fields correspond to your possibilities for specifying which category is most appropriate.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the standard category was linked as follows.

Table 11. Fields for importing default categories
Mapping field Permitted import values Explanation

Category ID

Numeric (internal ID)

Links the default category to the variation. Corresponds to the information under:
Tab: Variation ID » Tab: Categories » Area: Default categories

Enter a category ID into the CSV file. You can find the category IDs in the menu Item » Category (ID appears when you move your mouse over a category).

Category name

Alphanumeric

Links the default category to the variation. Corresponds to the information under:
Tab: Variation ID » Tab: Categories » Area: Default categories

Enter the complete category path, separated by semicolons. For example:
Shoes;Unisex

Create not found categories

0
1

Do you want to create the default category, if this default category doesn’t already exist? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the default category should be created.

  • 0 = No

  • 1 = Yes

2.11. Stock

Table 12 lists the fields available for importing stock data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 12. Fields for importing stock
Mapping field Permitted import values Explanation

Warehouse

Numeric (internal ID)

Can only be used in combination with quantity and storage location.

Quantity

Numeric

Can only be used in combination with warehouse and storage location.

Storage location

Numeric (internal ID)

Can only be used in combination with warehouse and quantity.

2.12. Client (store)

Table 13 explains the field that is used for mapping the client availability. This mapping field corresponds to your possibility to make the variation available for specific clients.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the client availability was saved as follows.

Table 13. Matching fields for importing client availabilities
Mapping field Permitted import values Explanation

Active

0
1

Do you want to make the variation available for a specific client (store)? Enter one of the permitted import values into your CSV file. Which value you choose determines whether a check mark () will be placed next to the client.

  • 0 = No

  • 1 = Yes

Select the store that should be activated from the second drop-down list in the Mapping area.

2.13. Markets

Table 14 explains the field that is used for mapping the marketplace availabilities. This mapping field corresponds to your possibility to make the variation available for specific markets.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the market availabilities were saved as follows.

Table 14. Fields for importing market availabilities
Mapping field Permitted import values Explanation

Active

0
1

Do you want to make the variation available for specific markets? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the market will be included in the following list:
Tab: Variation ID » Tab: Availability » Area: Markets

  • 0 = No

  • 1 = Yes

Select the market that should be activated from the second drop-down list in the Mapping area.

2.14. Attributes

Table 15 explains the fields that are available for mapping attribute links. These mapping fields correspond to your possibilities for saving attributes for variations.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that it was created with the following attributes.

Table 15. Fields for importing attribute links
Mapping field Permitted import values Explanation

Attribute selection combination

Alphanumeric

Combination of Attribute name (internal) and Attribute value (internal) in the format
attributeName:valueName; or attributeName<>valueName<||>
Import of more than two attribute links.
Note: Every attribute selection combination must be unique for each variation.

Attribute ID

Numeric

Import of up to two attribute links.
Tip: If two links exist, the IDs must be in different columns. Create a mapping in the format attributeName:valueName; and an additional mapping in the format attributeName<>valueName<||> and assign the separate columns.

Attribute Name

Alphanumeric

Import of up to two attribute links.
Tip: If two links exist, the names must be in different columns. Create a mapping in the format attributeName:valueName; and an additional mapping in the format attributeName<>valueName<||> and assign the separate columns.

Value name

Alphanumeric

Import of up to two attribute links.
Tip: If two links exist, the names must be in different columns. Create a mapping in the format attributeName:valueName; and an additional mapping in the format attributeName<>valueName<||> and assign the separate columns.

Value ID

Numeric

Import of up to two attribute links.
Tip: If two links exist, the IDs must be in different columns. Create a mapping in the format attributeName:valueName; and an additional mapping in the format attributeName<>valueName<||> and assign the separate columns.

Create not existing values

0
1

Do you want to create the attribute values, if they don’t already exist? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the attribute values should be created.

  • 0 = No

  • 1 = Yes

2.15. Item images

Table 16 explains the fields that are available for mapping item images. These mapping fields correspond to your possibilities to save images for items and for variations.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the item images were saved as follows.

Table 16. Matching fields for importing item images
Mapping field Permitted import values Explanation

Image ID

Numeric (internal ID)

The image’s internal ID. You can look up image IDs, e.g. by exporting your item images.

Position

Numeric

Corresponds to the entry field under:
Tab: Images » Option: Position

Enter the position number in the CSV file.

File name

Alphanumeric

Corresponds to the information under:
Tab: Images » Click on the image » File name up top

Enter the file name into the CSV file.

Base64 data

Alphanumeric

URL

Alphanumeric

Corresponds to the information under:
Tab: Images » URL

Enter the URL into the CSV file.

Multi URL (separated by commas)

Alphanumeric

Corresponds to the information under:
Tab: Images » URL

Enter multiple image URLs and position numbers into the CSV file. Use the following format.
image1url;positionImage1,image2url;positionImage2
If no position is transferred, the position corresponds to the order of the URLs.

Note: If you use this mapping field, then you will not be able to individually control the availabilities. In other words, the images will automatically be available for all clients, referrers and listings. If you want to control which clients, referrers and listings the image is available for, then use the mapping field URL instead.

Delete images

0
1

Do you want to delete all of the item’s images? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the images should be deleted.

  • 0 = No

  • 1 = Yes

Delete images (IDs, comma-separated)

Numeric (internal ID)

Do you want to delete some of the item’s images? Enter the IDs of whichever images should be deleted into your CSV file. Use commas to separate the IDs. You can look up image IDs, e.g. by exporting your item images.

Delete images (Urls, comma-separated)

Alphanumeric

Do you want to delete some of the item’s images? Enter the URLs of whichever images should be deleted into your CSV file. Use commas to separate the URLs.

Link to variation

0
1

Do you want to link the image to the variation? Enter one of the permitted import values into your CSV file.

  • 0 = Deletes an existing link

  • 1 = Links the image to the variation

Availability client (store)

Numeric (internal ID)

Corresponds to the drop-down list under:
Tab: Images » Option: Availability

Making the image available for clients:

  • Enter the plenty-IDs of all the clients that should be activated. Separate the IDs with commas. You can find the plenty-IDs in the menu Setup » Client » Select client » Settings » Option: Plenty ID

  • Alternatively, enter -1 to activate all clients.

Making the image unavailable for clients:

  • Enter 0 into your CSV file.

  • Alternatively, leave the line empty in the CSV file.

Note: This mapping field cannot be combined with the mapping field Multi URL (separated by commas). Use the field URL instead.

Availability referrers

Numeric (internal ID)

Corresponds to the drop-down list under:
Tab: Images » Option: Availability

Making the image available for referrers:

  • Enter the IDs of all the referrers that should be activated. Separate the IDs with commas. You can find the referrer IDs in the menu Setup » Orders » Order referrer

  • Alternatively, enter -1 to activate all referrers.

Making the image unavailable for referrers:

  • Enter 0 into your CSV file.

  • Alternatively, leave the line empty in the CSV file.

Note: This mapping field cannot be combined with the mapping field Multi URL (separated by commas). Use the field URL instead.

Availability listings

Numeric (internal ID)

Corresponds to the drop-down list under:
Tab: Images » Option: Availability

Making the image available for listings:

  • Enter the IDs of all the listings referrers that should be activated. Separate the IDs with commas. You can find the listing referrer IDs in the menu Setup » Orders » Order referrer

  • Alternatively, enter -1 to activate all listings.

Making the image unavailable for listings:

  • Enter 0 into your CSV file.

  • Alternatively, leave the line empty in the CSV file.

Note: This mapping field cannot be combined with the mapping field Multi URL (separated by commas). Use the field URL instead.

Name

Alphanumeric

Corresponds to the entry field under:
Tab: Images » Option: Name

Enter the name of the item image into the CSV file. Use the following format.
Name1:Language1:AlternativeText1,Name2:Language2:AlternativeText2

Alternative names

Alphanumeric

Corresponds to the entry field under:
Tab: Images » Option: Alternative text

Enter the alternative text for the item image into the CSV file. Use the following format.
AlternativeText1:Language1,AlternativeText2:Language2

Market attribute link (attribute value ID)

Numeric (internal ID)

Corresponds to the drop-down list under:
Tab: Images » Option: Market attribute link

Enter the ID of the attribute value into the CSV file.

Remove all availabilities

0
1

Do you want to remove all of the availabilities? Enter one of the permitted import values into your CSV file.

  • 0 = No

  • 1 = Yes

2.16. Characteristics

Table 17 explains the fields that are available for mapping characteristic links. These mapping fields correspond to your possibilities for linking characteristics to items.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the item once it’s been imported, then you’ll see that the characteristics were linked as follows.

Table 17. Fields for importing characteristic links
Mapping field Permitted import values Explanation

ID

Numeric (internal ID)

Links the characteristic to the item. Corresponds to the information under:
Tab: Characteristics » Area: Characteristics

Enter a characteristic ID into the CSV file. You can find the characteristic ID in the menu Setup » Item » Characteristics.

Characteristic combination

Alphanumeric

Enter the combination of back end name, value and language into the CSV file. Enter this information in the following format:
Name1:Value1:Language1;Name2:Value2:Language2 etc.

Note: Don’t use this mapping field e.g. if your value is a URL with a colon. Since colons are used to separate the name, value and language, the colon within a URL would not be understood correctly. Instead, use three separate fields to import such characteristics: Characteristics / ID, Characteristics / Value and Characteristics / Language.

Internal name

Alphanumeric

Links the characteristic to the item. Corresponds to the information under:
Tab: Characteristics » Area: Characteristics

Enter the internal name into the CSV file. You can find the internal name in the menu Setup » Item » Characteristics.

Value

Alphanumeric

Corresponds to the value of the characteristic under:
Tab: Characteristics » Area: Characteristics

Enter the value into the CSV file. Depending on the type of characteristic, the value could be e.g. a text or a number.

Selection ID

Numeric (internal ID)

Only for characteristics of the type Selection Links a characteristic’s selection values by their IDs.

Enter a selection ID into the CSV file. You can find the selection ID in the menu Setup » Item » Characteristics » Open a characteristic of the type Selection.

Language

Letters

Only for characteristics of the type Text. Specifies which language the text was written in.

Enter a language code into the CSV file.

Delete (yes/no)

0
1

Do you want to remove the characteristic from the item data record? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the characteristic should be deleted.

  • 0 = No

  • 1 = Yes

Note: The characteristic itself will not be deleted. The characteristic will simply be removed from the item data record.

2.17. Properties

Table 18 explains the fields that are available for mapping property links. These mapping fields correspond to your possibilities for linking properties to variations.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the properties were linked as follows.

Table 18. Fields for importing property links
Mapping field Permitted import values Explanation

ID

Numeric (internal ID)

Links the property with a variation. Corresponds to the information under:
Tab: Variation ID » Tab: Properties or Texts

Enter a property ID into the CSV file. You can find the property IDs in the menu Setup » Settings » Properties » Configuration.

Language

Letters

Only for properties of the type Text or Short text. Specifies which language the text was written in.

Enter a language code into the CSV file.

Value

Alphanumeric

Corresponds to the property’s value under:
Tab: Variation ID » Tab: Properties or Texts

Enter the value into the CSV file. Depending on the type of property, the value could be e.g. a text or a number.

Description

Alphanumeric

Internal name

Alphanumeric

Links the property with a variation. Corresponds to the information under:
Tab: Variation ID » Tab: Properties or Texts

Enter the internal name into the CSV file. You can find the internal names in the menu Setup » Settings » Properties » Configuration.

Property combination

Alphanumeric

Enter the combination of back end name, value and language into the CSV file. Enter this information in the following format:
Name1:Value1:Language1;Name2:Value2:Language2 etc.

Property selection combination (names)

Alphanumeric

Only for properties of the type Selection. Enter the combination of property name, selection value name and language into the CSV file. Enter this information in the following format:
PropertyName1:SelectionValueName1:Language1;PropertyName2:SelectionValueName2:Language2

Property selection combination (IDs)

Alphanumeric

Only for properties of the type Selection. Enter the combination of property ID, selection value ID and language into the CSV file. Enter this information in the following format:
PropertyID1:SelectionValueID1:Language1;PropertyID2:SelectionValueID2:Language2

Selection ID

Numeric (internal ID)

Only for properties of the type Selection. Links a property’s selection value by its ID. Enter the selection ID into the CSV file.

You can find the selection IDs in the menu Setup » Settings » Properties » Configuration » Open property » Values.

Multi-selection IDs (comma-separated)

Numeric (internal ID)

Only for properties of the type Multi-selection. Links a property’s selection values by their IDs. Enter the selection IDs into the CSV file. Separate them with commas.

You can find the selection IDs in the menu Setup » Settings » Properties » Configuration » Open property » Values.

Delete (yes/no)

0
1

Do you want to remove the property from the variation data record? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the property should be deleted.

  • 0 = No

  • 1 = Yes

Note: The property itself will not be deleted. The property will simply be removed from the variation data record.

2.18. Variation tags

Table 19 explains the fields that are available for mapping tags. These mapping fields correspond to your possibilities for linking tags to variations.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the tags were linked as follows.

Table 19. Fields for importing tag links
Mapping field Permitted import values Explanation

Tag ID

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Tags

Enter a tag ID into the CSV file. You can find the tag IDs in the menu Setup » Settings » Tags » Open tag.

Tag name

Alphanumeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Tags

Enter a name for the tag in the CSV file. You can find the tag names in the menu Setup » Settings » Tags » Open tag.

Tag names
(separated by commas)

Alphanumeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Tags

Enter the names of multiple tags in the CSV file. Use commas to separate the names like so:
name1,name2,name3…​

You can find the tag names in the menu Setup » Settings » Tags » Open tag.

Delete all tag relationships

0
1

Do you want to remove all of the tags from a variation? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the tag links should be deleted.

  • 0 = No

  • 1 = Yes

Note: The tags themselves will not be deleted. The tags will simply be removed from the variation.

Delete the given tag relationships (name, comma-separated)

Alphanumeric

Do you want to remove some of the tags from a variation? Enter the names of the tags that should be removed in the CSV file. Use commas to separate the names like so:
name1,name2,name3…​

You can find the tag names in the menu Setup » Settings » Tags » Open tag.

Note: The tags themselves will not be deleted. The tags will simply be removed from the variation.

Delete the given tag relationships (IDs, comma-separated)

Alphanumeric

Do you want to remove some of the tags from a variation? Enter the IDs of the tags that should be removed in the CSV file. Use commas to separate the IDs like so:
id1,id2,id3…​

You can find the tag IDs in the menu Setup » Settings » Tags » Open tag.

Note: The tags themselves will not be deleted. The tags will simply be removed from the variation.

2.19. Inheritance

Table 20 explains the fields that are available for mapping inheritance. These mapping fields correspond to your possibilities for passing data on with the inheritance function.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the inheritance functions were activated or deactivated as follows.

Table 20. Fields for importing inheritance
Mapping field Permitted import values Explanation

Category

0
1

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the inheritance should be activated.

  • 0 = Deactivated

  • 1 = Activated

Markets

0
1

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the inheritance should be activated.

  • 0 = Deactivated

  • 1 = Activated

Client

0
1

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the inheritance should be activated.

  • 0 = Deactivated

  • 1 = Activated

Purchase price

0
1

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the inheritance should be activated.

  • 0 = Deactivated

  • 1 = Activated

Supplier

0
1

Should the inheritance function be activated or deactivated under:
Tab: Variation ID » Tab: Supplier

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the inheritance should be activated.

  • 0 = Deactivated

  • 1 = Activated

Warehouse

0
1

Should the inheritance function be activated or deactivated under:
Tab: Variation ID » Tab: Warehouse

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the inheritance should be activated.

  • 0 = Deactivated

  • 1 = Activated

Availability

0
1

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the inheritance should be activated.

  • 0 = Deactivated

  • 1 = Activated

Properties

0
1

Should the inheritance function be activated or deactivated under:
Tab: Variation ID » Tab: Properties

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the inheritance should be activated.

  • 0 = Deactivated

  • 1 = Activated

Tags

0
1

Should the inheritance function be activated or deactivated under:
Tab: Variation ID » Tab: Settings » Area: Tags

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the inheritance should be activated.

  • 0 = Deactivated

  • 1 = Activated

2.20. Content

Table 21 explains the fields that are available for mapping content. These mapping fields correspond to your possibilities for specifying the content and unit of a variation.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the content was saved as follows.

Table 21. Fields for importing content
Mapping field Permitted import values Default value Explanation

Content unit

Numeric (internal ID)

Piece

Corresponds to the drop-down list under:
Tab: Variation ID » Tab: Settings » Area: Dimensions » Option: Content

Enter the unit’s ID into the CSV file. You can find the unit IDs in the menu Setup » Item » Units.

Note: Use this mapping field in combination with Content value.

Content value

Numeric

1

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: Dimensions » Option: Content

Enter the numerical content into the CSV file.

Note: Use this mapping field in combination with Content unit or Content measuring unit (ISO).

Content Units of measure (ISO)

Alphanumeric ISO code

Piece

Corresponds to the drop-down list under:
Tab: Variation ID » Tab: Settings » Area: Dimensions » Option: Content

Enter the unit’s ISO code into the CSV file. You can find the ISO codes in the menu Setup » Item » Units.

Note: Use this mapping field in combination with Content value.

2.21. ASIN/ePID

Table 22 explains the fields that are available for mapping ASIN/ePIDs. These mapping fields correspond to your possibilities for saving ASIN/ePIDs for variations.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the settings were saved as follows under Tab: Settings » Area: ASIN/ePID.

Table 22. Fields for importing ASIN/ePID
Mapping field Permitted import values Explanation

Country

Numeric (internal ID)

Corresponds to the first drop-down list under:
Tab: Variation ID » Tab: Settings » Area: ASIN/ePID

In other words: Corresponds to the country platform, e.g. Amazon Germany, eBay France, eBay UK, etc.

Enter the country ID in your CSV file. You can find the country IDs in the menu Setup » Orders » Shipping » Settings » Tab: Countries of delivery.

You can also find a list of IDs in the online manual.

Type

ASIN
ePID

Corresponds to the second drop-down list under:
Tab: Variation ID » Tab: Settings » Area: ASIN/ePID

Enter one of the permitted import values into your CSV file. Which value you choose determines whether you are working with an ASIN or an ePID.

Position

Numeric

Value

Alphanumeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Settings » Area: ASIN/ePID

Enter the ASIN or ePID in your CSV file.

Delete (IDs, comma-separated)

Numeric (internal ID)

Do you want to remove some of the ASINs or ePIDs from a variation? Enter the IDs of the ASINs or ePIDs that should be removed in the CSV file. Use commas to separate the IDs like so:
ASIN-ID1,ASIN-ID2,ASIN-ID3 etc.

2.22. Warehouse

Table 23 explains the fields that are available for mapping warehouse data. These mapping fields correspond to your possibilities for specifying where a specific variation is stored.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the settings in the Warehouse tab were saved as follows.

Table 23. Fields for importing warehouse data
Mapping field Permitted import values Explanation

Zone

Numeric

Corresponds to the drop-down list under:
Tab: Variation ID » Tab: Warehouse » Column: Zone

Select the appropriate warehouse from the second drop-down list in the Mapping area.

Storage location type

none
small
medium
large
europallet

  • none = No type selected

  • small = Small

  • medium = Medium

  • large = Large

  • europallet = Euro pallet

Select the appropriate warehouse from the second drop-down list in the Mapping area.

Reorder level

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Warehouse » Column: Reorder level

Select the appropriate warehouse from the second drop-down list in the Mapping area.

Maximum stock

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Warehouse » Column: Maximum stock

Select the appropriate warehouse from the second drop-down list in the Mapping area.

Stock turnover (in days)

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Warehouse » Column: Stock turnover (in days)

Select the appropriate warehouse from the second drop-down list in the Mapping area.

Storage location

Numeric (internal ID)

Corresponds to the drop-down list under:
Tab: Variation ID » Tab: Warehouse » Column: Suggested storage location

Data is mapped according to the storage location ID in the menu Setup » Stock » Warehouse » Open warehouse » Storage locations.

Select the appropriate warehouse from the second drop-down list in the Mapping area.

Stock buffer

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Warehouse » Column: Stock buffer

Select the appropriate warehouse from the second drop-down list in the Mapping area.

Batch (yes/no)

0
1

Corresponds to the checkbox under:
Tab: Variation ID » Tab: Warehouse » Column: Charge

  • 0 = No check mark

  • 1 = Check mark

Select the appropriate warehouse from the second drop-down list in the Mapping area.

Best before date (yes/no)

0
1

Corresponds to the checkbox under:
Tab: Variation ID » Tab: Warehouse » Column: MHD

  • 0 = No check mark

  • 1 = Check mark

Select the appropriate warehouse from the second drop-down list in the Mapping area.

Delete warehouse link

0
1

Do you want to remove the warehouse from a variation? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the warehouse should be deleted.

  • 0 = No

  • 1 = Yes

Select the appropriate warehouse from the second drop-down list in the Mapping area.

Note: The warehouse itself will not be deleted. The warehouse will simply be removed from the variation.

2.23. Supplier

Table 24 explains the fields that are available for mapping supplier data. These mapping fields correspond to your possibilities for adding suppliers to variations.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the settings in the Supplier tab were saved as follows.

Table 24. Fields for importing supplier data
Mapping field Permitted import values Explanation

Supplier link ID

Numeric

ID of the link between variation and supplier
This ID is automatically generated by plentymarkets. The ID is not visible in your plentymarkets system. Rather, the ID is only saved in the background. If you want to see the ID anyway, then you’ll need to export this information from your plentymarkets system. You can do this with the export format VariationSupplier in FormatDesigner.
The mapping field Supplier link ID may or may not be a required value. It depends on what exactly you want to do. For example, you need this field if you want to create suppliers while you import items.

Purchase price in system currency

Decimal number

Corresponds to the entry field under:
Tab: Variation ID » Tab: Supplier » Column: Purchase price in system currency

Enter the number in your CSV file.

Minimum purchase

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Supplier » Column: Minimum purchase

Enter the quantity in your CSV file.

Supplier item No.

Alphanumeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Supplier » Column: Supplier item No.

Enter the external item number into your CSV file.

Last price query

Date
(Y-m-d H:i:s)

Corresponds to the entry field under:
Tab: Variation ID » Tab: Supplier » Column: Last price query

Enter the date of the last price negotiation into your CSV file.

Note: Enter the date in this format:
2020-04-24 00:00:00
If you would prefer to use a different date format, then specify this format in the import options.

Delivery time in days

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Supplier » Column: Delivery time in days

Enter the number of days into your CSV file.

Discount

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Supplier » Column: Discount

Enter the discount percentage into your CSV file.

Note: The discount will only be applied to reorders if the discountable option was also activated.

Discountable

0
1

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the check mark will be placed.

  • 0 = No check mark

  • 1 = Check mark

Packaging unit

Numeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Supplier » Column: Packaging unit

Enter the numerical value into your CSV file.

Purchase price in account currency

Decimal number

Corresponds to the entry field under:
Tab: Variation ID » Tab: Supplier » Column: Purchase price from account

Enter the number in your CSV file.

Supplier item name

Alphanumeric

Corresponds to the entry field under:
Tab: Variation ID » Tab: Supplier » Column: Supplier item name

Enter the external name into your CSV file.

Supplier ID

Numeric

Corresponds to the supplier’s contact ID as listed in the menu CRM » Contacts.

Tip: Set the Type filter to Supplier to only show contacts of the type Supplier.

Supplier name

Alphanumeric

Corresponds to the supplier’s name as listed in the menu CRM » Contacts.

Tip: Set the Type filter to Supplier to only show contacts of the type Supplier.

Delete supplier link

0
1

Do you want to remove the link between the supplier and the variation? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the link should be deleted.

  • 0 = No

  • 1 = Yes

2.24. SKU

Table 25 explains the fields that are available for mapping SKUs. These mapping fields correspond to your possibilities for saving SKUs for variations.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the settings were saved as follows under Tab: Availability » Area: SKU.

Table 25. Fields for importing SKU
Mapping field Permitted import values Explanation

Market ID

Numeric

Data is mapped according to the order referrer ID in the menu Setup » Orders » Order referrer.

You can also find a list of IDs in the online manual.

Account ID

Numeric

Data is mapped according to the marketplace account ID. For example, you can find the account IDs in the following menus:

Amazon

Setup » Markets » Amazon » Settings

eBay

Setup » Markets » eBay » Settings » Account settings

Rakuten.de

Setup » Markets » Rakuten.de

Note: Not every marketplace has an account ID. For example, Check24 does not have a marketplace account ID. In such cases, enter 0 as the account ID.

SKU

Alphanumeric

Enter the SKU in your CSV file.

Parent SKU

Alphanumeric

Enter the parent SKU in your CSV file.

Delete SKU

0
1

Do you want to remove the SKU from a variation? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the SKU should be deleted.

  • 0 = No

  • 1 = Yes

2.25. Additional SKU

Table 26 explains the fields that are available for mapping additional SKUs. These mapping fields correspond to your possibilities for saving additional SKUs for variations.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the settings were saved as follows under Tab: Availability » Area: Additional SKU.

Table 26. Fields for importing additional SKU
Mapping field Permitted import values Explanation

ID

Numeric

An existing SKU ID

Market ID

Numeric

Data is mapped according to the order referrer ID in the menu Setup » Orders » Order referrer.

You can also find a list of IDs in the online manual.

Account ID

Numeric

Data is mapped according to the marketplace account ID. For example, you can find the account IDs in the following menus:

Amazon

Setup » Markets » Amazon » Settings

eBay

Setup » Markets » eBay » Settings » Account settings

Rakuten.de

Setup » Markets » Rakuten.de

Note: Not every marketplace has an account ID. For example, Check24 does not have a marketplace account ID. In such cases, enter 0 as the account ID.

SKU

Alphanumeric

Enter the SKU in your CSV file.

Existing SKU

Numeric

The current value of an SKU

Match by ID or existing SKU

0
1

  • 0 = No

  • 1 = Yes

Delete additional SKU

0
1

Do you want to remove the additional SKU from a variation? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the additional SKU should be deleted.

  • 0 = No

  • 1 = Yes

2.26. Bundle

Table 27 explains the fields that are available for mapping item bundles. These mapping fields correspond to your possibilities for adding components to a bundle and removing components from a bundle.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the bundle once it’s been imported, then you’ll see that the components were added or removed as follows.

Table 27. Fields for importing bundles
Mapping field Permitted import values Explanation

Item bundle components

Alphanumeric

Adds components to a bundle. Enter the variation ID and quantity of the bundle component into your CSV file. Use a colon to separate the variation ID and quantity. Use a semicolon to separate multiple components. Example:
VariationID:Quantity;VariationID:Quantity;etc.

Item bundle components (variation numbers)

Alphanumeric

Adds components to a bundle. Enter the variation number and quantity of the bundle component into your CSV file. Use a colon to separate the variation number and quantity. Use a semicolon to separate multiple components. Example:
VariantionNumber:Quantity;VariationNumber:Quantity;etc.

Delete bundle components

Alphanumeric

Deletes components from a bundle. Enter the variation ID of whichever bundle component should be deleted into your CSV file. Use a semicolon to separate multiple variation IDs. Example:
VariationID;VariationID

Delete bundle

0
1

Deletes all of the components from a bundle. You don’t need to specify the variation IDs of each individual component since all of the components will be deleted at once.

  • 0 = No

  • 1 = Yes

2.27. Serial number

Table 28 explains the fields that are available for mapping serial numbers. These mapping fields correspond to your possibilities for creating a pool of serial numbers within an item data record.

Enter one of the permitted import values into your CSV file. Which value you choose determines how the setting will be configured when it’s imported.

In other words: If you open the variation once it’s been imported, then you’ll see that the serial number settings were saved as follows.

Table 28. Fields for importing serial numbers
Mapping field Permitted import values Explanation

ID

Numeric

Corresponds to the field under:
Serial number symbol in the upper row () » Area: Serial numbers » Option: ID

Enter the serial number ID into your CSV file.

Number

Numeric

Corresponds to the field under:
Serial number symbol in the upper row () » Area: Serial numbers » Option: Serial number

Enter the serial number into your CSV file.

Delete Serial number

0
1

Do you want to remove the serial number from a variation? Enter one of the permitted import values into your CSV file. Which value you choose determines whether the serial number should be deleted.

  • 0 = No

  • 1 = Yes

3. Required values for various item sync procedures

Table 29 gives several different examples of things that can be done with item syncs. The table lists the required values for each scenario.

Table 29. Procedures for item syncs
Procedure Required values

Item description

Update item description

  • Name

Shipping profile

Update shipping profile

  • Shipping profile ID

Variation tags

Delete all tag links

  • Delete all linked tags = 1

Delete tag

One tag:

  • Tag ID
    or

  • Tag name

Multiple tags:

  • Tag names (separated by commas)

Variations

Create variation

  • ID of the default category
    or

  • Name of the default category

Add variation to item

  • Content quantity

  • Content unit
    or

  • Content quantity

  • Content Units of measure (ISO)

and

  • Item ID
    or

  • Main variation ID

For variations with attributes, the following applies in addition:

  • Attribute selection combination
    or

  • Attribute (name or ID)

  • Value (name or ID)

Update content

  • Content quantity

  • Content unit
    or

  • Content quantity

  • Content Units of measure (ISO)

Barcodes

Change barcode

  • Code via barcode mapping

Categories

Link category

  • Category ID
    or

  • Category name

Tip: Create additional mappings to import more categories.

Update link

  • Category ID
    or

  • Category name

Variation prices

Change price

  • Price via sales price mapping

Default categories

Link default category

  • Category ID
    or

  • Category name

Update default category

  • Category ID
    or

  • Category name

Stock

Update stock

  • Warehouse

  • Quantity

  • Storage location

Item images

Delete all images before upload

  • Delete images = 1

Save images

  • Multi URL
    or

  • URL
    or

  • File name

  • Base64 data

Update images

  • Image ID

Link image with variation

  • Multi URL
    or

  • URL

Characteristics

Save characteristics

  • Characteristic combination
    or

  • Internal name

  • Language

  • Value
    or

  • ID

  • Language

  • Value

Update characteristics

  • Characteristic combination
    or

  • Internal name

  • Language

  • Value
    or

  • ID

  • Language

  • Value

Properties

Link a property

  • ID

  • Language

  • Value

Supplier

Link supplier

  • Purchase price

  • Supplier link ID (leave empty for new links)

and

  • Supplier ID
    or

  • Supplier name

Update supplier

  • Purchase price

  • Supplier link ID

and

  • Supplier ID
    or

  • Supplier name

SKU

Add SKU

  • Market ID

  • SKU

  • Account ID

Update SKU

  • Market ID

  • SKU

  • Account ID

Bundle

Create bundle

  • Item bundle components

Delete bundle components

  • Delete bundle components

Delete bundle

  • Delete bundle = 1

To top