Skip to main content
  1. Home
  2. Data exchange
  3. Importing data
  4. Importing data with ElasticSync

Importing data with ElasticSync

This page of the manual describes how to import data using ElasticSync. Importing data is recommended if you want to add new items, customer data or stock etc. to your plentymarkets system and you already have this data available in digital format. ElasticSync allows to carry out data imports by creating so-called syncs. You can import your data manually or automatically.

General settings

1. Creating a sync

The steps for creating and importing syncs are identical for all sync types. As such, the steps described in the following apply to all sync types.

Go to Data » ElasticSync to create, edit and manage syncs. Here, you can see an overview of all syncs. With a sync, you can assign the data of a file that is accessible via FTP or HTTP to the data in plentymarkets and import them. When creating a sync, you save information about the data source. Furthermore, it is important that you determine data for the matching and that you assign which data of your file corresponds to the data in plentymarkets. Use the matching to set what data is to be used to try to identify if a data record already exists or not. Use the mapping to set which column in your file corresponds to which data field in plentymarkets. In the end, set an import interval. Proceed as described below to create a sync.

Set the import interval in the end to avoid that a sync is carried out too early

It is recommended to set the import interval in the end. By doing so, you avoid that a sync is already carried out while you still carry out matching and mapping settings.

Creating a sync:

  1. Go to Data » ElasticSync.

  2. Click on Add sync.
    → The editing area New sync is displayed.

  3. Carry out the settings. Pay attention to the information given in Table 1.

  4. Save the settings.
    → The sync is created and the matching settings of the sync open.

Table 1. Creating a sync
Setting Explanation

Basic data

Name

Enter a name. This name is displayed in the overview and can be used for the search.

Type

Select the type from the drop-down list.

  • Contacts, companies and addresses = Select to import contact, company and address data.

  • Item = Select to import item and variation data.

  • Categories = Select to import category data.

  • Attributes = Select to import attribute data.

  • Properties = Select to import property data.

  • Notes = Select to import note data.

  • Order = Select to import order data.

  • Warehouse = Select to import storage locations.

  • Properties = Select to import properties.

Import

Data type

Select the file format of the import file.
Currently, CSV is the only available option.

Character set

Select the character set of the file or the option Detect automatically.

Starting in line

Select a line starting from which the data should be imported.

Header is included

Select whether the import file contains a header.

Separator

Separator

Select the field separator that is set in the import file in order to separate the data fields (columns) of a data record from each other.
Possible separators are Semicolon, Comma, Tab and Pipe.

Delimiter

Select delimiters within the fields that may contain multiple values.
* " = individual values within one field are separated by double quotation marks. * ' = individual values within one field are separated by single quotation marks.

Source

Source

Select FTP, HTTP or SFTP.
Depending on the selected option, the following settings are displayed:

FTP = Host, port, username, password and file name are displayed.

  • Host (Mandatory field) = Enter the host of the FTP server.
    Tip: Use the FTP access included in your plentymarkets system.

  • Port = Port of the FTP server. If no port is entered, the standard port (22) is used.

  • User name (Mandatory field) = Enter the user for the FTP access.

  • Password (Mandatory field) = Enter the password for the FTP access.

  • File name = Enter the path and the name of the file from which the data is to be imported. Note: You can use wildcard characters in the field File name by e.g. replacing a part of the file name with a *. Only use wildcard characters in combination with the option Move file to archive when import was successful.

  • Move file to archive when import was successful = If this option is activated, the import file is automatically moved to the new folder Archive in the FTP directory once import was successfully.

HTTP = Select External URL or File upload from the drop-down list HTTP options.

  • External URL = Enter the URL to access the import file.
    Tip: Save the file on your plentymarkets Webspace.

  • File upload = Upload a file from your local hard disk.
    Important: The file is saved to a public bucket on S3. This means that everyone who know the URL can access the file.

  • Authentication: Select whether an authentication is required to access the file.

    • none = no authentication required

    • HTTP authentication = an authentication is required for each user and password

SFTP = Host, port, username, password and file name are displayed.

  • Host (Mandatory field) = Enter the host of the FTP server.

  • Port (Mandatory field) = Port of the FTP server. If no port is entered, the standard port (22) is used.

  • User name (Mandatory field) = Enter the user for the FTP access.

  • Password (Mandatory field) = Enter the password for the FTP access.

  • File name = Enter the path and the name of the file from which the data is to be imported. Note: You can use wildcard characters in the field File name by e.g. replacing a part of the file name with a *. Only use wildcard characters in combination with the option Move file to archive when import was successful.

  • Move file to archive when import was successful = If this option is activated, the import file is automatically moved to the new folder Archive in the FTP directory once import was successfully.

2. Setting the import options

The import options can be found in the Matching area. The import options apply both for the matching and for the mapping.

Setting the import options:

  1. Go to Data » ElasticSync.

  2. Click on the sync within the sync overview.

  3. Click on Matching.

  4. Determine the import options. Pay attention to the information given in Table 2.

  5. Save the settings.

Table 2. Import options for syncs
Import option Explanation

If no data matched

Select Skip or Create.

  • Import new data, update existing = If data can be found by means of the matching fields, a new data record, e.g. a new item or a new order, is added. At the same time, existing data is updated.

  • Only update existing data = Existing data is updated. If no data can be found by means of the matching fields, the data record is not imported.

  • Only import new data = Only new data records are imported, i.e. any data for which no matching data is found based on the synchronisation fields.

Decimal number

Select German spelling or English spelling.

  • German spelling = Decimal numbers are separated by a comma and a full stop serves as thousands separator.

  • English spelling = Decimal numbers are separated by a full stop and a comma serves as thousands separator.

Data format

Enter the date format. If the date in the file corresponds to the standard format Y-m-d H:i:s, it is not necessary to enter another format. Other formats, however, must be entered here. All php-compliant date formats are allowed.

3. Setting the matching

After you created a sync, open it to carry out further settings. First, you select the fields that should be used for matching the data. Determine what should happen if no existing data can be found during the matching process.

Matching is optional

Matching fields are optional settings. If you do not select a matching field, the data in your file cannot be assigned to existing data in your system. You can determine one, multiple or all matching fields. The displayed matching fields are different for each sync type.

Setting the matching:

  1. Go to Data » ElasticSync.

  2. Click on the sync within the sync overview.

  3. Click on Matching.

  4. Carry out the settings.

  5. Save the settings.

4. Creating the mapping

With a mapping, you specify which column of your file corresponds to which data field in your system. Without this mapping, no data can be imported.

Determining the mapping:

  1. Go to Data » ElasticSync.

  2. Click on the sync within the sync overview.

  3. Click on Mapping.

  4. Click on Add mapping.

  5. Enter a name for the mapping.

  6. Enter a position for the mapping (optional).

  7. Save the settings.
    → The available mapping fields differ according to the sync type.

  8. Select the data fields for the mapping by placing a checkmark in the fields.
    → The selected data fields are added to the mapping.

  9. Select a column from your file for each data field or select the option Own value.

  10. Save the settings.

Limitation for mappings

The maximum number of possible characters for mappings is 65535.

[NOTE].Own value

The option Own value allows to import a fix value for the data field. This fix value is thus identical for each data record that is imported via this sync.

[#1510]=== Activating lines of a mapping for the import

In the Mapping section, you can activate all lines for the import with just one click. Alternatively, you can decide individually for each line whether you want it to be active or inactive, thus, whether it should be considered in the import or not.

Activating lines for the import:

  1. Go to Data » ElasticSync.
    → The overview opens.

  2. Click on a sync.
    → The Mapping overview opens.

  3. Click on a mapping.
    → The mapping opens.

  4. On the left, click on Activate all, in order to consider all lines in the import.

  5. Alternatively, in a line, click on Activate line in order to just consider this line in the import.

  6. Save the settings.

[NOTE].View of the mapping

On the left side of the mapping you can see the import data of the CSV file that have to be mapped on the plentymarkets page. The plentymarkets data fields are shown on the right. The preview displays the first 6 values of the CSV file.

[#1520]=== Replacing values with the RegEx function

In order to consider a CSV file during the import as desired, the so-called RegEx function can be applied. Thanks to this function, data is manipulated during the import through commands. Thus, no changes need to be made to the CSV file anymore.

The following two examples will give an overview of the process.

Example 1:
Input: “24.12.2017”
Search pattern*: /^(\d+)\.(\d+)\.(\d+)$/
Replace pattern: $3﹣$2﹣$1
Result: “2017-12-24”

Example 2:
Input: “Doe, John”
Search pattern: /^(\w+), (\w+)$/
Replace pattern: $2 $1
Result: “John Doe”

Explanation of the examples:
Right at the beginning, there is the input. In a first step, the pattern to be searched for is inserted as search pattern. Afterwards, in the replace pattern, it is changed in such a way that it is output during the import as required. Finally, the result is output in the desired pattern which will be considered in the CSV file.

Replacing values:

  1. Go to Data » ElasticSync.

  2. Click on a sync.
    → The mapping opens.

  3. In the field Source, select the value Regular expression.
    → The options for Regular expression open.

  4. In the field Value, enter the column name of the CSV file (e.g. Package number, Order ID etc.).

  5. In the field Search, enter the Search pattern.

  6. In the field Replace, enter the Replace pattern.

  7. Save the settings.
    → The data fields are updated.

[NOTE].Info about RegEx

For further information on the RegEx function, see this page or this page. On the latter, the RegEx engine setting has to be changed to PCRE. This can be done in the dropdown menu on the top right where Javascript is preset.

[#1520]=== Own assignment

With the own assignment you can assign existing values in a CSV file to other values in the system. This enables to define, which value is supposed to be imported for which ID. In addition, if there is no assignment defined for a value in the CSV file, you can specify a default value. If no default value is specified, the original value is imported.

Defining an own assignment:

  1. Go to Data » ElasticSync.
    → The overview opens.

  2. Click on a sync.
    → The overview of the mapping opens.

  3. Click on a mapping.
    → The mapping opens.

  4. In the dropdown menu of the field Source, select the option Own assignment.

  5. Fill in the fields. Pay attention to the information given in [table-own-assignment].

  6. Save the settings.

.Own assignment

Field Setting

Type

Name of the CSV column (e.g. Delivery country)

Default value

Value, if no assignment was found (e.g. 1)

From

Original value in the CSV file (e.g. DE for Germany)

To

Value, to which the original value shall be mapped (e.g. 1 for DE, 10 for GB etc.)

5. Filtering import data

You can use filters to limit the data to be imported. You find the filters in the Mapping area.

Multiple filters are linked with an AND condition

If you use multiple filters, only those data records are imported that correspond with all filters. Thus, the filters are linked with an AND condition.

Adding the filter:

  1. Go to Data » ElasticSync.

  2. Click on the sync within the sync overview.

  3. Click on Mapping.
    → An overview of the mapping is displayed.

  4. Open the mapping.

  5. Click on Filter in the toolbar.

  6. Select the column from your file that you would like to filter.

  7. Select an operator.

  8. Enter a value.

  9. Click on Add filter.
    → The filter is saved.

  10. Add additional filters as necessary.
    → Only data that meets all filter criteria is imported.

6. Viewing the sync logs

Log entries are created for each sync that is carried out. You can view these log entries.

Viewing the sync logs:

  1. Go to Data » ElasticSync.

  2. Click on History.
    → The sync logs are displayed.

7. Copying syncs

It is possible to copy one sync or multiple syncs at the same time. In this way, you can use syncs that you have already configured in order to quickly create a new sync.

Copying syncs:

  1. Go to Data » ElasticSync.

  2. Activate one or multiple syncs.

  3. Click on Copy sync.
    → The sync is copied. (copy) is added behind a copied sync.

8. Exporting and importing a sync

You can import and export syncs. Furthermore, you can save syncs locally and import syncs from other users.

Exporting and importing a sync:

  1. Go to Data » ElasticSync.

  2. Activate one or multiple syncs.

  3. Click on Export sync.
    → The sync is automatically downloaded.

  4. Click on Import sync.
    → The option Import sync is expanded below the menu.

  5. Click on Select file.
    → The file browser opens.

  6. Click on Upload file and select the file.

  7. Place a checkmark next to the file that you would like to upload and click on Select.
    → The file is added.

  8. Click on Import.
    → The sync is imported.

Importing syncs from another plentymarkets system

If you would like to import syncs from another plentymarkets system, you have to adjust the matching and mapping settings. It is only possible to import .json files.

9. Testing the sync and importing data

It is possible to test and carry out syncs. Testing allows you to quickly know whether your file can be imported correctly.

Testing the sync

If you select Test sync, only the first ten lines of the import file are imported.

[#1710]== Processing jobs in the queue

The queue enables the import of large amounts of data. Before being imported, the import file is broken down into packages and processed in so-called jobs. A job consists of 750 lines of a CSV file. However, import files with less than 750 lines also make a job. Whenever a sync is started, the CSV file is split up into the respective jobs and is put into the queue. In the queue, new jobs are permanently retrieved and the syncs are processed. There are two different statuses. The status Open jobs means that there are jobs in the queue waiting to be processed. Completed jobs on the contrary have already been processed and the data have been imported.

10. Activating/deactivating mappings

If you manage several mappings in the same sync, you can deactivate or activate specific mappings of the sync in the mapping overview using "activate-mapping". New mappings are active by default.

Sync types

1. Item

With syncs of the type Item, you import item and variation data.

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

  • Categories (Item » Categories menu)

  • Sales prices (System » Item » Sales prices)

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

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

1.1. Fields for item matching

Table 3 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 3. Matching fields for importing items
Matching field Explanation

Variation ID

Variation no.

External variation ID

Barcode

Select the barcode type of the barcode 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.

1.2. Fields for the item mapping

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

1.2.1. Item

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

Table 4. Fields for importing items
Mapping field Permitted import values Explanation

Type

default = Default item
multipack = Multipack item

If no item type is specified, the item is treated as a Default item.

Stock type

0 = Stocked item
1 = Production item
2 = Colli
3 = Special order item

Store special

0 = none
1 = Special offer
2 = New items
3 = Top items

Owner

Numeric (internal user ID)

For owner IDs, see System » Settings » User » Accounts

Manufacturer ID

Numeric (internal ID)

See System » Item » Manufacturer

Manufacturing country

Numeric (internal ID);
0 = unknown

For IDs see Country IDs

Customs tariff number

Numeric

Revenue account

Coupon for special offers

0 = Possible
1 = Prohibited
2 = Purchasable with coupon only

Condition

0 = New
1 = Used
2 = New and in original packaging
3 = New with label
4 = Factory seconds

Item condition

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

Item condition. This is transferred via the API to other markets

Subscription (yes/no)

0 = No
1 = Yes

Can the item be ordered as a subscription?

Serial number (yes/no)

0 = No
1 = Yes

Assign serial number?

Shipping package (yes/no)

0 = No
1 = Yes

Use shipping package?

Fulfilment by Amazon (FBA)

0 = Do not use
1 = AMAZON EU
2 = AMAZON FE
3 = AMAZON NA
-1 = FBA and SellerCentral

Shipment by Amazon (FBA)

0 = No
1 = Yes

FBA shipping?

Amazon product type

Numeric

For IDs see amazon_product_type value table

Amazon-FEDAS

FEDAS product group key

Listing template

Numeric (internal ID)

Listing category 1;
Listing category 2;

Numeric

Listing store category 1;
Listing store category 2

Numeric

Rakuten.de categories

Numeric (internal ID)

Flag 1

Numeric (internal ID)

ID of flag 1, see System » Items » Flags » Tab: Flag 1

Flag 2

Numeric (internal ID)

ID of flag 2, see System » Items » Flags » Tab: Flag 2

Age rating

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

Age rating

Item feedback

Numeric

Initial rating from 1 to 5 or 1 to 10

Field 1;
Field 2;
Field 3;
…​
Field 18

Alpha-numeric

Free text fields 1 to 18

Max. item order quantity

Numeric

Manufacturer name

Alpha-numeric

If not available in the system, a new producer is created.

Delete item

0 = No
1 = Yes

1.2.2. Cross-selling

Table 5 lists the fields available for importing cross-selling links. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

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

Delete all cross selling links

0 = No
1 = Yes

Add cross-selling links

Alpha-numeric

Cross-selling links in the format
Item ID:Reference type;Item ID:Reference type;etc.
Available relationship types:
Accessory = accessories
ReplacementPart = replacement part
Similar
Bundle = item bundle

Delete all cross selling links

Numeric

Cross-selling links in the format
ItemID; itemID;etc.

1.2.3. Item description

Table 6 lists the fields available for importing item descriptions. Create one mapping per language. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

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

Name

Alpha-numeric

Name 2;
Name 3

Alpha-numeric

Preview text

Alpha-numeric

Meta description

Alpha-numeric

Item text

Alpha-numeric

Technical data

Alpha-numeric

URL path

Link

Meta keywords

Alpha-numeric

1.2.4. Shipping profile

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

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

Shipping profile ID

Numeric

Shipping profiles (separated by commas)

Allows importing more than two shipping profiles

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

Alpha-numeric

1.2.5. Variations

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

Table 8. Matching fields for variations
Mapping field Permitted import values Explanation

ID

Numeric

Item ID

Numeric

Position

Numeric

Active

0 = No
1 = Yes

Is variation active, i.e. is it available in the online store and on markets?

Variation no.

Alpha-numeric

Model

Alpha-numeric

Model name

External variation ID

Alpha-numeric

Availability

Numeric (internal ID)

Net purchase price

Numeric

Purchase price

Mov. av. purchase price (net)

Numeric

Moving average price (net)

Price calculation

Numeric (internal ID)

Units contained

Numeric

Packaging unit; standard = 1

Number of packages

Numeric

Unit 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 = Role
29 = Sack
30 = Unit
31 = Tank
32 = Drum
34 = Crate
35 = Quarter pallet
36 = Other pallets
37 = Bin
38 = One-way pallet
39 = Foilbag

Net transportation costs

Numeric

Net storage costs

Numeric

Customs

Numeric

Percentage value

Operating costs

Numeric

Percent

VAT

Numeric (%)

Bundle type

bundle = variation is a bundle
bundle_item = variation is bundle component

Invisible in item list

0 = No
1 = Yes

Order picking

single_picking = Single order picking possible
no_single_picking = No single order picking possible
exclude_from_picklist

Stock limit

0 = No limitation
1 = To net stock
2 = No stock

Online store: Visible if net stock is positive

0 = No
1 = Yes

Online store: Invisible if net stock is 0 or negative

0 = No
1 = Yes

Available if net stock is positive

0 = No
1 = Yes

Not available if net stock is 0 or negative

0 = No
1 = Yes

Item list: Automatically visible if net stock is positive

0 = No
1 = Yes

Item list: Automatically invisible if net stock is 0 or negative

0 = No
1 = Yes

Main warehouse

Numeric (internal ID)

Max. order quantity

Numeric

Min. order quantity

Numeric

Interval order quantity

Numeric

Show unit price

0 = No
1 = Yes

tagVariationId

Numeric

Delete variations

0 = No
1 = Yes

Main variation ID

Alpha-numeric

Available until

Date

Last date that the main variation is available.

Release date

Date

Date on which the main variation becomes available.

Name

Alpha-numeric

Name of the variation

Gross weight in g

Numeric

Net weight in g

Numeric

Width in mm

Numeric

Length in mm

Numeric

Height in mm

Numeric

Extra shipping charge 1;
Extra shipping charge 2

Numeric

1.2.6. Barcodes

Table 9 lists the fields available for importing barcode data. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping per barcode type.

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

Code

Alpha-numeric

Delete barcode

0 = No
1 = Yes

1.2.7. Variation price

Table 10 lists the fields available for importing variation price data. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping per sales price.

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

Price

Numeric

Delete price

0 = No
1 = Yes

Deletes a linked price.

1.2.8. Categories

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

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

Categories

Category ID

Numeric (internal ID)

Alternatively, transfer the name of the category.

Position

Numeric

Is Neckermann.de main category

0 = No
1 = Yes

Category name

Alpha-numeric

  • Complete category path, separated by semicolons (e.g. shoes;unisex)
    or

  • Category ID

Tip: Create additional mappings to import more categories.

Delete all category links

0 = No
1 = Yes

Removes all linked categories.

Category IDs (separated by commas)

Alpha-numeric

The IDs of the categories that shall be linked to the variation.

Category names (separated by commas)

Alpha-numeric

Name of the categories that shall be linked to the variation.

Delete links (Category IDs, separated by commas)

Alpha-numeric

IDs of the categories that shall be removed from the variation.

Delete links (Category names, separated by commas)

Alpha-numeric

Name of the categories that shall be removed from the variation.

Default categories

Category ID

Numeric (internal ID)

ID of the default category

Automatically selected

N = No
Y = Yes

Category name

Alpha-numeric

Name of the default category

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

1.2.10. Client

Table 13 lists the fields available for importing client availabilities. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping for each client.

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

Active

0 = No
1 = Yes

1.2.11. Markets

Table 14 lists the fields available for importing market availabilities. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping for each market.

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

Active

0 = No
1 = Yes

1.2.12. Attributes

Table 15 lists the fields available for importing attribute links. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping for each format.

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

Attribute selection combination

Alpha-numeric

Combination of Attribute name (internal) and Attribute value (internal) in the format
Attribute name:Value name; or Attributname<>Value name<||>
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 Attribute name:Value name; and an additional mapping in the format Attribute name<>Value name<||> and assign the separate columns.

Attribute Name

Alpha-numeric

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 Attribute name:Value name; and an additional mapping in the format Attribute name<>Value name<||> and assign the separate columns.

Value name

Alpha-numeric

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 Attribute name:Value name; and an additional mapping in the format Attribute name<>Value name<||> 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 Attribute name:Value name; and an additional mapping in the format Attribute name<>Value name<||> and assign the separate columns.

1.2.13. Item images

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

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

Image ID

Numeric (internal ID)

Position

Numeric

File name

Alpha-numeric

Base64 data

Alpha-numeric

URL

Alpha-numeric

Link to item image

Multi URL (separated by commas)

Alpha-numeric

Several image URLs in the format
image1url;positionImage1,
image2url;positionImage2
If no position is transferred, the position corresponds to the order of the URLs.

Delete images

0 = No
1 = Yes

1 deletes all images of the item. Images that should not be deleted must be entered as URL in the sync.

Link to variation

0 = No
1 = Yes

1 links the image to the variation.
0 deletes an existing link.

Availability client (store)

Numeric (internal ID)

For client IDs, see System » Client » Open client » Settings
-1 activates all clients

Availability referrers

Numeric (internal ID)

For referrer IDs, see Order referrer IDs
Specify more than one referrer separated by commas.
-1 activates all referrers

Availability listings

Numeric (internal ID)

-1 activates all listings

Name

Alpha-numeric

Name of the item image in the format Name:Language1,Name:Language2

1.2.14. Properties

Table 17 lists the fields available for importing property links at the item level. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

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

ID

Numeric (internal ID)

See System » Item » Properties

Property combination

Alpha-numeric

Combination of back end name, value and language in the format
Name1:Value1:Language1;Name2:Value2:Language2 etc.

Internal name

Alpha-numeric

Value

Alpha-numeric

Language

Letters

Properties of the type Text only
For codes, see Languages

Delete (yes/no)

0 = No
1 = Yes

1.2.15. Properties

Table 18 lists the fields available for importing property links at the variation level. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

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

ID

Numeric (internal ID)

For IDs, see System » Settings » Properties » Configuration

Language

Letters

Properties of the types Text or Short text only
For codes, see Languages

Value

Alpha-numeric

Description

Alpha-numeric

Internal name

Alpha-numeric

Property combination

Alpha-numeric

Combination of name, value and language in the format
Name1:Value1:Language1;Name2:Value2:Language2 etc.

Selection ID

Delete (yes/no)

0 = No
1 = Yes

1.2.16. Variation tags

[Table-mapping-fields-tags] lists the fields available for importing tag links. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

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

Tag ID

Numeric

Tag name

Alpha-numeric

Tag names
(separated by commas)

Alpha-numeric

Tag list

Delete all linked tags

0 = No
1 = Yes

Delete all links?

Delete tag links (name, comma-separated)

Alpha-numeric

Delete tag links (ID, comma-separated)

Alpha-numeric

1.2.17. Inheritance

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

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

Category

0 = No
1 = Yes

Markets

0 = No
1 = Yes

Client

0 = No
1 = Yes

Sales price

0 = No
1 = Yes

Supplier

0 = No
1 = Yes

Warehouse

0 = No
1 = Yes

Availability

0 = No
1 = Yes

Tags

0 = No
1 = Yes

1.2.18. Content

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

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

Content unit

Numeric (internal ID)

For IDs, see Unit IDs
Alternatively, transfer content units of measure (ISO)

Content quantity

Numeric

Can only be used in combination with Content unit and Content units of measure (ISO).

Content Units of measure (ISO)

Alphanumeric ISO code

Alternatively, transfer Content unit

1.2.19. ASIN/ePID

[table-mapping-fields-ASIS-ePID] lists the fields available for importing ASIN/ePID data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

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

Country

Numeric (internal ID)

For IDs see Country IDs

Type

ASIN; ePID

Value

Alpha-numeric

1.2.20. Warehouse

Table 23 lists the fields available for importing warehouse data. During the import, plentymarkets checks if the imported data record already exists based on the matching field. Create one mapping per warehouse.

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

Zone

Numeric

Storage location type

none
small
medium
large
europallet

Reorder level

Numeric

Maximum stock

Numeric

Stock turnover (in days)

Numeric

Storage location

Numeric (internal ID)

Stock buffer

Numeric

Batch (yes/no)

0 = No
1 = Yes

Best before date (yes/no)

0 = No
1 = Yes

Delete warehouse link

0 = No
1 = Yes

1.2.21. Supplier

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

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

Purchase price

Numeric

The variation’s purchase price

Minimum purchase

Numeric

Supplier item No.

Alpha-numeric

External item number assigned to the variation by the supplier

Last price query

Date

Date of the last price negotiations

Delivery time in days

Numeric

Discount

Numeric

Percent

Discountable

0 = No
1 = Yes

Packaging unit

Numeric

Supplier ID

Numeric

Contact ID of the supplier, see CRM » Contacts
Tip: Set Type filter to Supplier to only show contacts of the type Supplier.

Supplier name

Alpha-numeric

For supplier name, see CRM » Contacts
Tip: Set Type filter to Supplier to only show contacts of the type Supplier.

Delete supplier

0 = No
1 = Yes

Unlinks the supplier from the variation.

1.2.22. SKU

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

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

Market ID

Numeric

For referrer IDs, see Order referrer IDs

Account ID

Numeric

ID of the market account
For Amazon, see System » Markets » Amazon » Settings
For eBay, see System » Markets » eBay » Accounts

SKU

Alpha-numeric

Parent SKU

Alpha-numeric

Delete SKU

0 = No
1 = Yes

1.2.23. Bundle

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

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

Item bundle components

Alpha-numeric

Variation ID:quantity;Variation ID:quantity,etc.

Delete bundle components

Alpha-numeric

Variation ID of bundle component

Delete package

0 = No
1 = Yes

1.2.24. Serial number

[Table-mapping-fields-serial-numbers] lists the fields available for importing serial number data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

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

ID

Numeric

ID of the serial number

Number

Numeric

Serial number

Delete Serial number

0 = No
1 = Yes

1.3. Mandatory values for sync procedures with items

Table 28 lists possible procedures for syncs of the type item and explains the required values.

Table 28. 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 for Quantity

  • Content for Unit
    or

  • Content for 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 for Quantity

  • Content for Unit
    or

  • Content for 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

  • ID of the image

Link image with variation

  • Multi URL
    or

  • URL

Properties

Save properties

  • Property combination
    or

  • Internal name

  • Language

  • Value
    or

  • ID

  • Language

  • Value

Update properties

  • Property combination
    or

  • Internal name

  • Language

  • Value
    or

  • ID

  • Language

  • Value

Supplier

Link supplier

  • Purchase price

and

  • Supplier ID
    or

  • Supplier name

Update supplier

  • Purchase price

and

  • Supplier ID
    or

  • Supplier name

SKU

Adding SKU

  • Marketplace ID

  • SKU

For eBay/Amazon, the following applies in addition:

  • Account ID

Update SKU

  • Marketplace ID

  • SKU

For eBay/Amazon, the following applies in addition:

  • Account ID

Bundle

Create bundle

  • Bundle components

Delete bundle components

  • Delete bundle components

Delete bundle

  • Delete bundle = 1

2. Category

With syncs of the type Category, you import category data.

2.1. Fields for category matching

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

Table 29. Matching fields for importing categories
Setting Explanation

Category ID

Category name combined

Select the separator from the second drop-down list.

Category name level 1 - 6

2.2. Fields for the category mapping

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

Table 30. Mapping fields for importing categories
Mapping field Permitted import values Explanation

Category

Parent category ID

Numeric (internal ID)

Parent category name

Alpha-numeric

Type

item
container
content
blog (not used)

Show in link list

0 = No
1 = Yes

right

all = Category and all sub-categories are visible to the public
customer = Category and all sub-categories are only visible to online store visitors that are logged in

Complies with back end setting Visible

Visible (sitemap)

0 = No
1 = Yes

Complies with back end setting Sitemap

Delete category

0 = No
1 = Yes

Details (mapping per combination of language and client (store))

Name

Alpha-numeric

Mandatory value

Description 1

Alpha-numeric

Description 2

Alpha-numeric

Short description

Alpha-numeric

Meta keywords

Alpha-numeric

Meta description

Alpha-numeric

Meta title

Alpha-numeric

URL name

Alpha-numeric

Position

Numeric

Template list

Alpha-numeric

Template product

Alpha-numeric

Template page

Alpha-numeric

Full text search

0 = No
1 = Yes

Robots

Alpha-numeric

all = Include the website of the category in search engine index and follow links on page.
index = Include in search engine index.
nofollow = Do not follow links on page.
noindex = Do not include in search engine index.
nofollow_noindex = Do not follow links and do not include webpage in search index.

Translate wildcard characters

Alpha-numeric

Y = Yes
N = No
L = Only template variables and template functions for links are translated

canonical

Alpha-numeric

URL of a category with the same content, max. 256 characters

Client (store) (mapping per client)

Active

0 = No
1 = Yes

Example 1: Price and stock synchronisation of a variation.

Create a sync to keep prices and stock of a variation up-to-date. Once the assignment for the sync took place, a mapping has to be created. To do so, select the plentymarkets fields VariationSalesPrice and VariationStock within the Select values area of the mapping. Next, select the sales prices (price, RRP) which should be updated for VariationSalesPrice. It is possible to update several different sales prices with one sync. Now link the filed of the data source. Not only can you select the warehouse for the stock but also the storage location. For VariationStock, select the warehouse for which stock should be booked. Optionally, select the storage location. To use the quantity from the data source, link the plentymarkets field quantity with the field of the data source. A stock correction is always carried out in the process.

Example 2: Importing item descriptions

Name, technical data and meta keywords should be imported for an item. First, select these plentymarkets fields within the Select values area of the mapping. Next, you have to select the language for this item descriptions. You can select more than one option. The fields Name, Technical data and Meta keywords are linked with the desired fields of the data source. This means that the entries listed in the data source will be now imported for the previously selected plentymarkets fields. In addition, use the filter options to further specify the import. For example, import the item descriptions only for items that belong to a specific brand.

3. Attribute

Syncs of the type Attribute allow you to import attributes and attribute values. Imported data is saved in the Settings » Item » Attributes menu.

3.1. Fields for attribute matching

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

Table 31. Matching fields attribute import
Setting Explanation

Attribute ID

ID of the attribute value

Attribute name

Attribute value name

3.2. Fields for the attribute mapping

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

Table 32. Mapping fields for importing attributes
Mapping field Permitted import values Explanation

Attribute

Internal name

Alpha-numeric

Position

Numeric

Image link possible

0 = No
1 = Yes

Attribute selection in the online store

dropdown
image
box

dropdown = Attributes are displayed as a drop-down list in the online store.
image = Attributes are displayed as image tiles in the online store.
box = Attributes are displayed as boxes with attribute values in the online store.

Groupable in item lists

0 = No
1 = Yes

Delete attribute

0 = No
1 = Yes

Value

Internal name

Alpha-numeric

Position

Numeric

Note

Alpha-numeric

Percentage

Numeric

Percentages for automatic distribution of attribute values

Delete attribute value

0 = No
1 = Yes

Attribute name

Name

Alpha-numeric

Create one mapping per language.

Attribute value name

Name

Alpha-numeric

Create one mapping per language.

4. Property

Syncs of the type Property allow you to import properties. Imported data is saved in the Settings » Item » Properties menu.

4.1. Fields for property matching

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

Table 33. Matching fields property import
Setting Explanation

Property ID

ID of the property group

Property name

Property group name

4.2. Fields for property mapping

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

Table 34. Mapping fields for importing properties
Mapping field Permitted import values Explanation

Property

Position

Numeric

Property group ID

Numeric

Unit

ISO code

For ISO codes of units, see Unit IDs

Internal name

Alpha-numeric

Searchable

0 = No
1 = Yes

Order property

0 = No
1 = Yes

Show on the item’s page in the online store

0 = No
1 = Yes

Show in the item listing in the online store

0 = No
1 = Yes

Display in order process

0 = No
1 = Yes

Show in PDF documents

0 = No
1 = Yes

Display as additional costs

0 = No
1 = Yes

Surcharge

Numeric

Property type

none
number
decimal number
selection
text
file

Delete property type

0 = No
1 = Yes

Property name

Name

Alpha-numeric

Create one mapping per language.

Description

Alpha-numeric

Create one mapping per language.

Property group

Internal name

Alpha-numeric

Percentage

0 = No
1 = Yes

Property group name

Name

Alpha-numeric

Create one mapping per language.

Description

Alpha-numeric

Create one mapping per language.

5. Contacts, companies and addresses

Requirements:

  • In order that the newly imported or updated countries of delivery are displayed in a contact data record in the contact overview, these countries of delivery must be activated in the System » Orders » Shipping » Options » Tab: Countries of delivery menu.

With syncs of the type Contacts, companies and addresses, you import new contact data or update existing data records. This data is for example the delivery address and invoice address, the date of birth of the contact, the customer type, contact options such as the private or business email address as well as company data.

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

  • Contacts (CRM » Contacts menu)

  • contact options such as telephone number and email address, if necessary

  • address data (invoice address, delivery address), if necessary

  • company data such as VAT number and payment due date, if necessary

5.1. Field for synchronising contacts, companies and addresses

Click on the following links to see the lists of the fields that are available for matching contact data, address data and company data:

By means of the identifiers Contact ID, Email, Invoice address ID and Delivery address ID in the Matching area, it is checked whether the imported data record is present in plentymarkets.

5.1.1. Mandatory values for sync procedures with contacts, companies and addresses

Table 35. Mandatory values for sync procedures with contacts, companies and addresses
Procedure Required values

Contacts

Creating a contact

  • Referrer

  • Type

Contact option

Create contact option

  • Value

Update contact option

  • Contact ID

  • fields to be changed

Address

Create address

  • Contact ID

  • Select at least one of the following options: Name1, Name2, Name3

  • Select at least one of the following options: Address1, Address2, Address3

  • Select at least one of the following options: Country ID or country ISO code

  • Town

Update address

  • Select at least one of the following options: Name1, Name2, Name3

  • Contact ID

  • fields to be changed

Address option

Create address option

  • Value

Update address option

  • Address ID

  • Contact ID

  • fields to be changed

Company

Creating a company

  • Company name

Update company

  • Company name

Sales representative

Create country

  • Contact ID

  • Company ID

Create postcode range

  • Contact ID

  • Company ID

Update country

  • Contact ID

  • Company ID

Update postcode range

  • Contact ID

  • Company ID

Assign a contact to a sales representative

  • Contact ID

6. Manufacturer

Syncs of the type Manufacturer allow you to import manufacturer data.

6.1. Fields for category matching

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

Table 36. Matching fields for importing manufacturers
Setting Explanation

Manufacturer ID

Manufacturer name

External manufacturer name

6.2. Fields for mapping manufacturers

[Table-mapping-fields-manufacturer] explains the fields that are available for mapping manufacturer data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 37. Mapping fields for importing manufacturers
Mapping field Permitted import values Explanation

Name

Alpha-numeric

External name

Alpha-numeric

Logo URL

Alpha-numeric

Homepage

Alpha-numeric

Street

Alpha-numeric

House No.

Alpha-numeric

Postcode

Alpha-numeric

Town

Alpha-numeric

Phone number

Alpha-numeric

Fax number

Alpha-numeric

Email

Alpha-numeric

Country

Alpha-numeric

PIXmania ID

Numeric

Neckermann.at Enterprise ID

Numeric

La Redoute ID

Numeric

Position

Numeric

Comment

Alpha-numeric

Deleting manufacturers

0 = No
1 = Yes

7. Orders

With syncs of the type Order, you import order data.

7.1. Fields for item matching

Currently, there is only one matching field for identifying orders. The following matching field is available:

  • Order ID

7.2. Fields for order mapping

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

Mandatory fields for order mapping

Note the fields flagged as mandatory listed in Table 38. If you do not activate these mandatory fields, orders are not mapped correctly.
Table 38. Mapping fields for importing orders
Mapping field Permitted import values Explanation

Order

ID of the type
Mandatory field

Numeric

Order types represent different business events. The following types are available:

  • Order = 1

  • Delivery order = 2

  • Return = 3

  • Credit note = 4

  • Warranty = 5

  • Repair = 6

  • Offer = 7

  • Advance order =8

  • Multi-order = 9

  • Multi credit note = 10

ID of the status

Numeric

ID of the status. You determine the IDs in the range between 1.0000 and 18.9999. The statuses can be found in the System » Orders » Status menu.

ID of the owner

Numeric

ID of the owner. An owner is a user who is assigned as owner. The ID of the owner thus corresponds to the ID of the user. The user ID can be found in the System » Settings » User » Accounts menu. Orders can be assigned to an owner. This is optional.

PlentyID
Mandatory field

Numeric

ID of the client. The plentyID can be found in the System » Client » Select client » Settings menu.

ID of the location

Numeric

ID of the location. The locations can be found in the System » Client » Select client » Locations menu.

Order item

Type
Mandatory field

Numeric

The order item types represent different cost positions of an order. The costs involved can be negative or positive. The ID of the order item type is expected by default. The types that are available, are listed with their type ID. If your column does not contain the IDs, carry out the mapping yourself.

  • Variation = 1

  • Item bundle = 2

  • Bundle component = 3

  • Promotional coupon = 4

  • Gift card = 5

  • Shipping costs = 6

  • Payment surcharge = 7

  • Gift wrap = 8

  • Unassigned variation = 9

  • Deposit = 10

  • Order = 11

The type Order is contained in multi-orders, for example.

Referrer

Numeric

The ID of the referrer is expected by default. The IDs can be found in the System » Orders » Order referrer menu. If your column does not contain the IDs, carry out the mapping yourself.

Name
Mandatory field

Alpha-numeric

Select the column that contains the name of the order item. It is expected that the names are saved in the language of the system by default.

Attribute value

Alpha-numeric

Select the column that contains the name of the attribute value. The name is expected in the language of the system.

VAT rate

Numeric

The percentage value of the VAT rate is expected by default. Whether the number is expected to be separated by a comma or a dot depends on the selected import options. Set the import options in the Matching area.

VAT amount

Numeric

Select the column that contains the amount of tax. The VAT amount for quantity 1 of the order item is expected by default. Whether the number is expected to be separated by a comma or a dot depends on the selected import options. Set the import options in the Matching area.

Quantity
Mandatory field

Numeric

Select the column that contains the number of an order item.

Variation ID

Numeric

The ID of the variation is expected by default. The IDs can be found in the Item » Edit item menu. If your column does not contain the IDs, carry out the mapping yourself.

Position

Numeric

Select the column that contains the position of the order item. The position serves for the sorting within the order. It is, however, not taken into consideration yet.

Currency
Mandatory field

Alpha-numeric

The ISO code of a currency, e.g. EUR for Euro, is expected by default.

Exchange rate

Numeric

Select the column that contains the exchange rate. The exchange rate must contain the currency translation rate from the order currency to the system currency. The system currency is set in the System » Orders » Payment » Currencies menu. Whether the number is expected to be separated by a comma or a dot depends on the selected import options. Set the import options in the Matching area.

Purchase price

Numeric

Select the column that contains the purchase price. The purchase price for quantity 1 of the order item is expected by default. The purchase price is not displayed in the order. However, it allows to calculate and display the return on sales. Whether the number is expected to be separated by a comma or a dot depends on the selected import options. Set the import options in the Matching area.

Gross price

Numeric

Select the column that contains the gross price. The gross price for quantity 1 of the order item is expected by default. Whether the number is expected to be separated by a comma or a dot depends on the selected import options. Set the import options in the Matching area.

Net price

Numeric

Select the column that contains the net price. The net price for quantity 1 of the order item is expected by default. Whether the number is expected to be separated by a comma or a dot depends on the selected import options. Set the import options in the Matching area.

Surcharge

Numeric

Select the column that contains the surcharge. The surcharge for quantity 1 of the order item is expected by default. Whether the number is expected to be separated by a comma or a dot depends on the selected import options. Set the import options in the Matching area.

Discount

Numeric

Select the column that contains the discount. The discount for quantity 1 of the order item is expected by default. Whether the number is expected to be separated by a comma or a dot depends on the selected import options. Set the import options in the Matching area.

Discount in percent

Numeric

Select the column that contains the percentage value for the discount. Whether the number is expected to be separated by a comma or a dot depends on the selected import options. Set the import options in the Matching area.

Order item properties

Value

Alpha-numeric

Select a property type and select the column that contains the property. The following properties for order items are available by default:

  • Warehouse

  • Weight

  • Width

  • Length

  • Height

  • External token ID

  • External item ID

  • Coupon code

  • Coupon type

  • Unit

  • External item ID

  • Reason for return

  • Item status

  • External order item ID

Individual property types for order items can be created via Interface or REST. However, they are not displayed in the UI.
To display the property warehouse in the UI, go to System » Orders » Settings and for the mapping of the warehouse, select option b). Alternatively, select option a) and click Edit on the items.

Address relation

Address ID

Numeric

Select whether the address is the invoice address or the delivery address of the order. Afterwards, select the column that contains the ID of the address. The address ID can be used to map already existing addresses of contacts. If it is an address, use the address mapping fields.

Order property

Value

Alpha-numeric

Select a property type and select the column that contains the property. The following properties for orders are available by default:

  • Warehouse

  • Shipping profile

  • Payment method

  • Payment status

  • External shipping profile

  • Language in documents

  • External order ID

  • Customer identification sign

  • Dunning level

  • Seller account

  • Flag

  • VAT number

Individual property types for Orders can be created via Interface or REST.

Order date

Date

Select the date type and the column that contains the date. The data format in the column must be of the same data format that you selected for the import options.

Order relation

Reference ID

Select an order relation and select the column that contains the reference ID. The following relations can be selected:

  • Contact - Sender: The reference ID is the ID of an existing contact and this contact is the sender of the order.

  • Contact - Recipient: The reference ID is the ID of an existing contact and this contact is the recipient of the order.

  • Account - Sender: The reference ID is the ID of an existing account and this account is the sender of the order.

  • Contact - Recipient: The reference ID is the ID of an existing account and this account is the recipient of the order.

  • Warehouse - Sender: The reference ID is the ID of an existing warehouse and this warehouse is the sender of the order.

  • Warehouse - Recipient: The reference ID is the ID of an existing warehouse and this warehouse is the recipient of the order.

Address

Regardless of which address field is selected, it is important to first select whether this field belongs to a delivery address or to an invoice address.

Name 1 (Company)

Select the invoice address or delivery address and select the column that contains the company name.

Name 2 (First name)

Select the invoice address or delivery address and select the column that contains the first name.

Name 3 (Last name)

Select the invoice address or delivery address and select the column that contains the last name.

Name 4 (Additional information)

Select the invoice address or delivery address and select the column that contains the additional name.

Address 1 (Street)

Select the invoice address or delivery address and select the column that contains the name of the street.

Address 2 (House number)

Select the invoice address or delivery address and select the column that contains the house number.

Address 3 (additional information)

Select the invoice address or delivery address and select the column that contains the additional address information.

Address 4 (Free)

Select the invoice address or delivery address and select the column that contains the address information that can be freely selected.

Postcode

Select the invoice address or delivery address and select the column that contains the postcode.

Town

Select the invoice address or delivery address and select the column that contains the name of the town.

Country ID

Numeric

Select the invoice address or delivery address and select the column that contains the country ID. The IDs of the countries of delivery are expected by default. The IDs can be found in the System » Orders » Shipping » Settings menu.

ID of State/Province

Numeric

List of all countries that have a state/province. The IDs of the states/provinces are also listed: link:PDF file with a list of states/provinces (in German)

VAT number

Alpha-numeric

Enter the VAT number of a contact

Telephone

Numeric

Select the invoice address or delivery address and select the column that contains the telephone number.

Email

Select the invoice address or delivery address and select the column that contains the email address.

Shipping package

Regardless of which package information is selected, you have to select a shipping package and use this to compare this information. Shipping packages are set up in the System » Orders » Shipping » Shipping packages menu.

Weight

Select the invoice address or delivery address and select the column that contains the package weight.

Package number

Select the invoice address or delivery address and select the column that contains the package number. Separate multiple package numbers by commas in one line or in multiple lines with one package number in each line.

Packing unit type

Select the invoice address or delivery address and select the column that contains the packing unit type. The ID of the packing unit type is expected by default.

  • 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 = Role

  • 29 = Sack

  • 30 = Unit

  • 31 = Tank

  • 32 = Drum

  • 34 = Crate

  • 35 = Quarter pallet

  • 36 = Other pallets

  • 37 = Bin

  • 38 = One-way pallet

  • 39 = Foilbag

8. Warehouse

With syncs of the type Warehouse, you import new storage locations or update existing ones.

In order to create or update storage locations via ElasticSync, a storage location must be created.

8.1. Fields for storage location matching

[table-matching-fields-storage locations] explains the fields that are available for matching storage locations. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

For further information about the the terms dimensions, levels and storage locations, refer to theSetting up a warehouse page of the manual.

Table 39. Matching fields for importing storage locations
Matching field Explanation

Warehouse ID

Warehouse ID

Level name

Name of the level, e.g. R01

Level ID

ID of the level

WarehouseLocationId

Storage location ID

WarehouseLocationName

Name of the storage location without path

8.2. Fields for the storage location mapping

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

For further information about the the terms dimensions, levels and storage locations, refer to theSetting up a warehouse page of the manual.

Table 40. Mapping fields for importing storage locations
Mapping field Explanation

Storage locations

Storage location Id

Storage location ID

Level ID

ID of the level

Storage location name

Name of the storage location without path

Purpose

Purpose of the storage location, e.g. removal from storage

Status

Status of the storage location,, e.g. active, inactive

Position

Position of the storage location (distance)

Storage location type

Type of the storage location, e.g. small, medium, large

Levels of storage locations

Level Parent ID

Partent ID of the level

Dimension ID

ID of the dimension, e.g. rack

Level Position

Position of the level

Level name

Name of the level, e.g. R01, R02 etc.

8.3. Adjusting the storage location

You can adjust storage locations via ElasticSync such as changing the name or the position of the storage location.

Adjusting the storage location:

  1. Go to Data » ElasticSync.

  2. Click on the sync within the sync overview.

  3. Click on Matching.

  4. Select the fields WarehouseID and Storage location ID.

  5. Select Skip as import option.

  6. Save the settings.

  7. Click on Mapping.

  8. Open the mapping from the overview.

  9. Expand the area Storage locations on the right-hand side.

  10. Select the fields Storage Location ID, Storage location name and Position.

  11. Save the settings.

8.4. Creating a storage location

You can create new storage locations with ElasticSync.

Creating a storage location:

  1. Go to Data » ElasticSync.

  2. Click on the sync within the sync overview.

  3. Click on Matching.

  4. Select the fields WarehouseID and Storage location ID.

  5. Select create as import option.

  6. Save the settings.

  7. Click on Mapping.

  8. Open the mapping from the overview.

  9. Expand the area Storage locations on the right-hand side.

  10. Activate the fields Level ID, Storage Location ID, Storage location name, Purpose, Status, Position and Storage location type.

  11. Expand the area Level of storage locations on the right-hand side.

  12. Activate the fields Dimension ID, Level Position and Level name.

  13. Save the settings.

[#2250]=== Deleting a storage location

You can delete storage locations with ElasticSync.

Deleting a storage location:

  1. Go to Data » ElasticSync.

  2. Click on the sync in the sync overview.

  3. Click on Matching.

  4. Select the field Storage location ID.

  5. Select Only update existing data as import option.

  6. Save the settings.

  7. Click on Mapping.

  8. Open the mapping in the overview.

  9. Expand the area Storage locations on the right-hand side.

  10. Activate the field Delete storage location.

  11. You can either delete all storage locations or only specific ones. Carry out the respective settings. Pay attention to the information given in [table-deleting-storage locations].

  12. Save the settings.

[[table-deleting-storage locations]].You can either delete all storage locations or only specific ones.

Setting Explanation

Deleting all storage locations

All storage location IDs that exist in the CSV file will be deleted.
For the Delete storage location value, select Own value.
Then select Yes or No.

Deleting only specific storage locations

Here, the CSV file contains two values: on the one hand there are the storage location IDs and on the other hand there are the values Yes and No by which you can determine whether the value should be deleted.

9. Facets

Syncs of the type Facets allow you to import facet data.

9.1. Fields for category matching

[Table-matching-fields-facets] explains the fields that are available for matching facet data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 41. Matching fields for importing facets
Setting Explanation

Facet ID

Facet name

Facet value name

9.2. Fields for mapping facets

[Table-mapping-fields-facets] explains the fields that are available for mapping facet data. During the import, plentymarkets checks if the imported data record already exists based on the matching field.

Table 42. Mapping fields for importing facets
Mapping field Permitted import values Explanation

Facet

CSS class

Alpha-numeric

CSS name

Position

Numeric

Sorting

rate = Relevance
position = Position
a_z = A-Z

Sorting search results

Type

dynamic = Attribute/characteristic (old properties)
producer = Manufacturer
price = Price
availability = Availability

Minimum number of hits

Numeric

Maximum number of facet values shown

Numeric

Selection type

restrict = Only one value can be selected
multi = More than one value can be selected

Deleting facet

0 = No
1 = Yes

Facet name

Name

Alpha-numeric

Create one mapping per language.

Facet value

CSS class

Position

Numeric

Position of a facet value in the online store

Delete facet value

0 = No 1 = Yes

Facet value name

Name

Alpha-numeric

Create one mapping per language.
To top