Properties

This page explains the matching and mapping fields that you can use while importing properties and property groups. This page serves purely as a reference and it assumes that you already have a basic understanding of the import tool.

1. Matching fields

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

Table 1. Matching fields for property data
Setting Explanation

Property ID

Which column of your CSV file lists the property IDs? Choose this column here. This option is useful if you want to update existing properties.

Background info: Every new property automatically receives an ID, which can not be changed. The ID is used to uniquely identify the property. Because the ID is unique, it’s a good way to check whether the imported data record already exists in PlentyONE.

Property name

Which column of your CSV file contains the property name? Choose this column here. Then select the name’s language from the second drop-down list. This option is useful if you want to create new properties.

Property group ID

Which column of your CSV file lists the group IDs? Choose this column here. This option is useful if you want to update existing property groups.

Background info: Every new property group automatically receives an ID, which can not be changed. The ID is used to uniquely identify the group. Because the ID is unique, it’s a good way to check whether the imported data record already exists in PlentyONE.

Property group name

Which column of your CSV file contains the property group name? Choose this column here. Then select the name’s language from the second drop-down list. This option is useful if you want to create new property groups.

2. Mapping fields

This chapter explains the fields that are available for mapping property data. Use these fields to specify which column of your file corresponds to which data field in your system.

Basic procedure:

  1. In your CSV file: Enter a valid import value into a column.

  2. In PlentyONE: Assign this column to the appropriate mapping field.

  3. After the import: Check the result in the back end.

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 property will be given the default value.

2.1. Property

2.1.1. Position

Required field for creating a new property

Which property should be displayed first, second, third, etc? Enter a position number in the CSV file. If the variation, contact or storage location has multiple properties, then these properties will be displayed in ascending order by their position numbers.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Entry field: Position

2.1.2. Name

Required field for creating a new property

Enter the property name in the CSV file. Write the text in your system’s default language. Additionally, use the field Name / Name if you want to save the name in other languages too.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Entry field: Name

2.1.3. Section

Required field for creating a new property

What do you want to use the property for? Enter the corresponding section in the CSV file.

Default value: No default value

Permitted import values in CSV file Options in the drop-down list in the back end

item

Items

contact

Contact

stock

Storage location

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Drop-down list: Section

2.1.4. Property type

Required field for creating a new property

What sort of property do you want to create? Enter the corresponding type in the CSV file.

Default value: No default value

Permitted import values in CSV file Options in the drop-down list in the back end

empty

None

date

Date

file

File

int

Whole number

float

Decimal number

html

HTML

string

Character string

text

Text

selection

Selection

multiselection

Multi selection

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Drop-down list: Property type

2.1.5. Group id

Specifying a group is mandatory. However, you can either specify the group with the mapping field Group id or Assign to groups.

Every property must belong to at least one group. Enter the group’s ID in the CSV file.

Default value: No default value

Permitted import values: Numeric (internal group ID)

Input format: ID

Example: 12

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Drop-down list: Group

2.1.6. Delete property

Do you want to delete the property?

Default value: 0

Permitted import values in CSV file Result in the back end

0

Property is not deleted.

1

Property is deleted.

2.1.7. Remove from groups

Do you want to remove the property from a group? Enter the group’s ID in the CSV file.

Default value: No default value

Permitted import values: Numeric (internal group ID)

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Drop-down list: Group

2.1.8. Assign to groups

Specifying a group is mandatory. However, you can either specify the group with the mapping field Group id or Assign to groups.

Every property must belong to at least one group. Enter the IDs of all the groups in the CSV file. Use commas to separate multiple group IDs.

Existing groups will not be overwritten. In other words, if the property already belongs to a group and you import a second group, then the property will belong to both groups. Use the field Remove from groups if you want to remove an existing group.

Default value: No default value

Permitted import values: Numeric (internal group IDs)

Input format: ID,ID,ID

Example: 12,7,32

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Drop-down list: Group

2.2. Selection

2.2.1. Delete all values

Not recommended. Instead, use the import type Properties: Selection values.

Do you want to delete all of the values that were saved for a property of the type “Selection”?

Default value: 0

Permitted import values in CSV file Result in the back end

0

The selection values will not be deleted.

1

All of the selection values will be deleted.

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Values

2.2.2. Delete one value

Not recommended. Instead, use the import type Properties: Selection values.

Do you want to delete a value from a property of the type “Selection”?

Default value: No default value

Permitted import values: Numeric (internal value ID)

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Values

2.2.3. Add value(s)

Not recommended. Instead, use the import type Properties: Selection values.

Do you want to add a value to a property of the type “Selection”? Enter the name of the value in the CSV file. If you want to save multiple values, enter the names into the column one after the other. Separate them by semicolon and do not use a space between them.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Values

2.3. Name

2.3.1. Name

Enter the property name in the CSV file.

In contrast to the field Property / Name, you can use this field to save the property name in multiple languages. Add the field once per language.

Default value: No default value

Permitted import values: Alpha-numeric

Also use the drop-down list to select the language.

You can find the result of the import in the back end menu: Setup » Settings » Properties » Configuration » Entry field: Name

2.4. Group

2.4.1. Position

Required field for creating a new property group

Which property group should be displayed first, second, third, etc? Enter a position number in the CSV file. If the variation, contact or storage location has properties from multiple groups, then these groups will be displayed in ascending order by their position numbers.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu: Setup » Settings » Properties » Groups » Entry field: Position

2.4.2. Name

Required field for creating a new property group

Enter the name of the property group in the CSV file. Write the text in your system’s default language. Additionally, use the field Variation Property Group Name / Name if you want to save the name in other languages too.

Default value: No default value

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu: Setup » Settings » Properties » Groups » Entry field: Name

2.4.3. Delete group

Do you want to delete the property group?

Default value: 0

Permitted import values in CSV file Result in the back end

0

Group will not be deleted

1

Group will be deleted

2.4.4. Remove variation properties

Do you want to remove the properties from the group?

Default value: 0

Permitted import values in CSV file Result in the back end

0

Properties will not be removed

1

Properties will be removed

2.4.5. Add variation properties

Do you want to add properties to the group? Enter the property ID into the CSV file.

Default value: No default value

Permitted import values: Numeric

2.5. Group name

2.5.1. Name

Enter the name of the property group in the CSV file.

In contrast to the field Property group / Name, you can use this field to save the group names in multiple languages. Add the field once per language.

Default value: No default value

Permitted import values: Alpha-numeric

Also use the drop-down list to select the language.

You can find the result of the import in the back end menu: Setup » Settings » Properties » Groups » Entry field: Name

2.5.2. Description

Enter a description of the property group into the CSV file. If you want to save the description in multiple languages, then add the field once per language.

Default value: No default value

Permitted import values: Alpha-numeric

Also use the drop-down list to select the language.

You can find the result of the import in the back end menu: Setup » Settings » Properties » Groups » Entry field: Description

2.6. Group option

2.6.1. Group type

How many additional options or services should your customers be able to choose from the group? Enter the corresponding type in the CSV file.

Default value: none

Permitted import values in CSV file Options in the drop-down list in the back end

none

None

select

Select

multiselect

Multiselect

You can find the result of the import in the back end menu: Setup » Settings » Properties » Groups » Drop-down list: Group type

2.6.2. Surcharge type

Do you plan on offering extra services or options for an additional fee? If so, then specify whether the surcharge should be treated as a percentage or as a fixed price, e.g. 5% or 5 EUR.

Default value: No default value

Permitted import values in CSV file Options in the drop-down list in the back end

flat

Flat

percental

Percental

You can find the result of the import in the back end menu: Setup » Settings » Properties » Groups » Drop-down list: Surcharge type

2.7. Amazon

The following chapter contains information about the available fields for linking properties with Amazon via the import.

2.7.1. Category

Required field for linking properties with Amazon

Enter the category name into the CSV file.

Default value: none

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Setup » Settings » Properties » Configuration » tab: Amazon.

2.7.2. Field

Required field for linking properties with Amazon

Enter the field name into the CSV file.

Default value: none

Permitted import values: Alpha-numeric

You can find the result of the import in the back end menu Setup » Settings » Properties » Configuration » tab: Amazon.

2.7.3. Platform

Required field for linking properties with Amazon

Enter the Amazon platform into the CSV file.

Default value: none

Permitted import values in CSV file Options in the drop-down list in the back end

de

Amazon.de

uk

Amazon.co.uk

us

Amazon.com

fr

Amazon.fr

it

Amazon.it

es

Amazon.es

ca

Amazon.ca

mx

Amazon.com.mx

nl

Amazon.nl

pl

Amazon.pl

se

Amazon.se

tr

Amazon.tr

ae

Amazon.ae

You can find the result of the import in the back end menu Setup » Settings » Properties » Configuration » tab: Amazon.