Skip to main content

Facet

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

Practical example: Importing new facets

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

1. Matching fields

Table 1 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 1. Matching fields for importing facets
Setting Explanation

Facet ID

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

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

Facet value ID

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

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

Facet name

Which column of your CSV file lists the facet name? Choose this column here. This option is useful if you want to create new facets.

Facet value name

Which column of your CSV file lists the facet value name? Choose this column here. This option is useful if you want to create new facet values.

2. Mapping fields

This chapter explains the fields that are available for mapping facet 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 plentymarkets: 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 facet will be given the default value.

2.1. Facet

2.1.1. CSS class

Enter a CSS name into the CSV file. This option currently has no function. In the future, it will be possible to design the facet with CSS.

Default value: No default value

Permitted import values: Alpha-numeric


2.1.2. Position

Where should the facet appear in the webshop? In other words, which facet should be displayed first, second, third, etc? Enter the position number in the CSV file.

Default value: 1

Permitted import values: Numeric


2.1.3. Sorting

Not relevant for the type "Price"

How should the values be sorted within the facet? For example, if you’re creating the facet “Brand name”, then you could sort the individual brands alphabetically.

Enter your preferred sorting method into the CSV file.

Default value: position

Permitted import values in CSV file Result in the back end

rate

Hit rate

position

Position

a_z

A-Z


2.1.4. Type

Required field for creating new facets.

What sort of facet do you want to create? Allow your customers to filter products by the following criteria: attribute, characteristic, property, brand name, availability, price range.

Enter the appropriate type into the CSV file. This setting can not be changed once you’ve created the facet.

Default value: No default value

Permitted import values in CSV file Result in the back end Explanation

dynamic

Attribute/characteristic

This type can be used for many different scenarios. The filter is linked to the attributes, characteristics or properties in your system. Example: Choose this type if you want to create the filter “Colour” or “Size”.

producer

Manufacturer

This type of filter is linked to the manufacturers in your system. Example: Choose this type if you want to create the filter “Brand name”.

price

Price

You do not need to link this type of filter with values. Example: Choose this type if you want to create the filter “Price range”. Webshop visitors can individually limit the filter from the lowest to the highest price of a category.

availability

Availability

This type of filter is linked to the availabilities in your system. Example: Choose this type if you want customers to filter for items that ship within 24 hours.

You can find the result of the import in the back end menu: Setup » Client » Settings » Services » Faceted search » Tab: Settings » Field: Type


2.1.5. Minimum number of hits

Not relevant for the type "Price"

Enter a number into the CSV file. This is the minimum number of results that a facet value must have, in order for it to be displayed in the online shop. Facet values will automatically be invisible in the online shop if they do not return the minimum number of results.

Default value: 1

Permitted import values: Numeric


2.1.6. Maximum number of facet values shown

Not relevant for the type "Price"

How many values should be displayed within a facet at maximum? Enter a number into the CSV file. A maximum of 250 values can be displayed per facet.

Default value: 50

Permitted import values: Numeric


2.1.7. Selection type

Not relevant for the type "Price"

What should happen when customers select multiple filter criteria? Should they see products that fulfil all of these criteria or any one of the criteria?

Enter your preferred selection type into the CSV file.

Default value: restrict

Permitted import values in CSV file Result in the back end Explanation

restrict

Restricting

Products will only be displayed if they fulfil all of the selected criteria. For example, imagine you sell grills. Webshop visitors should be able to filter for grills that have a warming rack and a lid and a temperature gauge. The results only include products that have all three functions.

multi

Multiple

Products will be displayed if they fulfil one of the selected criteria. For example, imagine you sell grills. Webshop visitors should be able to filter for grills that were manufactured by the company Weber or Tefal or Coleman.


2.1.8. Delete facet

Do you want to delete the facet?

Default value: 0

Permitted import values in CSV file Result in the back end

0

Facet will not be deleted

1

Facet will be deleted


2.2. Facet name

2.2.1. Name

Required field for creating new facets

Enter a name for the facet in the CSV file. This name is displayed in the online shop.

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 » Client » Settings » Services » Faceted search » Tab: Name


2.3. Facet value

Not relevant for the type "Price"

2.3.1. CSS class

Enter a CSS name into the CSV file. This option currently has no function. In the future, it will be possible to design the facet value with CSS.

Default value: No default value

Permitted import values: Alpha-numeric


2.3.2. Position

Where should the facet value appear in the webshop? In other words, which facet value should be displayed first, second, third, etc? Enter the position number in the CSV file.

Default value: 1

Permitted import values: Numeric


2.3.3. Delete facet value

Do you want to delete the facet value?

Default value: 0

Permitted import values in CSV file Result in the back end

0

Facet value will not be deleted

1

Facet value will be deleted


2.4. Facet value name

Not relevant for the type "Price"

2.4.1. Name

Required field for creating new facet values

Enter a name for the facet value in the CSV file. This name is displayed in the online shop.

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 » Client » Settings » Services » Faceted search » Tab: Values » Tab: Name


2.5. Link

Not relevant for the type "Price"

2.5.1. Type

What sort of back end information do you want to link the facet value to? Enter the appropriate type into the CSV file.

Selection properties

It is not currently possible to link the values of selection properties via import. This function has not yet been developed. Currently, the values of selection properties need to be linked manually.

Default value: No default value

Permitted import values in CSV file Result in the back end

character

Characteristic

property

Property

attribute

Attribute

availability

Availability

producer

Manufacturer

You can find the result of the import in the back end menu: Setup » Client » Settings » Services » Faceted search » Tab: Values » Tab: Link


2.5.2. Value ID

What specific piece of back end information do you want to link the facet value to? Enter the ID of the back end information into the CSV file.

Default value: No default value

Permitted import values: Numeric

You can find the result of the import in the back end menu: Setup » Client » Settings » Services » Faceted search » Tab: Values » Tab: Link

Where can I look up the IDs?
  • Setup » Item » Characteristics

  • Setup » Settings » Properties » Configuration

  • Setup » Item » Attributes » [Open attribute] » Tab: Values

  • Setup » Item » Availability

  • Setup » Item » Manufacturers


2.5.3. Delete link

Do you want to delete the link?

Default value: 0

Permitted import values in CSV file Result in the back end

0

Link will not be deleted

1

Link will be deleted

To top