Skip to main content

Categories

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

Practical example: Importing new categories

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

1. Fields for matching categories

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

Category ID

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

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

Combined category name

Which column of your CSV file contains the complete category path? Choose this column from the first drop-down list and choose the separator from the second drop-down list. This option is useful if you want to update existing categories.

Category name level 1 - 6

Which column of your CSV file contains the category name for this level? Choose this column here.

2. Fields for mapping categories

Table 2 explains the fields that are available for mapping category data.

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

Table 2. Mapping fields for importing categories
Mapping field Permitted import values Default value Explanation

Category

Parent category ID

Numeric (internal ID)

- n/a -

Does a column of your CSV file list the ID of whichever category is directly above it? If so, then map the column to this data field.

Parent category name

Alphanumeric

- n/a -

Does a column of your CSV file list the name of whichever category is directly above it? If so, then map the column to this data field.

Type

item
container
content
blog

item

Enter one of the permitted import values into your CSV file. Which value you choose determines which category type will be assigned during the import.

In other words: If you open the category after it was imported and look at the Settings tab, then you’ll see that one of the following values was used for the Type setting.

  • item = Item (default setting)

  • container = Container

  • content = Content

  • blog = Blog

In link list

0
1

0

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the category will be displayed in the store navigation.

In other words: If you open the category after it was imported and look at the Settings tab, then you’ll see that one of the following values was used for the In link list setting.

  • 0 = Do not display

  • 1 = Display

right

all
customer

all

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the category will only be visible to users who have logged in.

In other words: If you open the category after it was imported and look at the Settings tab, then you’ll see that one of the following values was used for the Visible setting.

  • all = Public

  • customer = After login

Visible

0
1

0

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the category will be included in the sitemap.

In other words: If you open the category after it was imported and look at the Settings tab, then you’ll see that one of the following values was used for the Sitemap setting.

  • 0 = Do not display

  • 1 = Display

Delete category

0
1

0

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

  • 0 = No

  • 1 = Yes

Create parent category if not found

0
1

0

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

  • 0 = No

  • 1 = Yes

Category settings

Name
(Required field)

Alphanumeric

- n/a -

Enter the category name into the CSV file. Make sure you also select the language and webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that this name was entered into the Name field.

Description 1;
Description 2

Alphanumeric

- n/a -

Enter the category description into the CSV file. Make sure you also select the language and webstore within the Mapping area.

If you open the category after it was imported, then you’ll see that this text was entered into the Description 1 or Description 2 tab.

Short description;
Meta keywords;
Meta description;
Meta title;
URL name

Alphanumeric

URL name = Category name

Enter the text into the CSV file. Make sure you also select the language and webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that this text was entered into the corresponding field.

Position

Numeric

0

Enter the position number into the CSV file. Make sure you also select the language and webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that this number was entered into the Position field.

Template list;
Template product;
Template page
(only relevant for the old Callisto store)

Alphanumeric

ItemViewCategoriesList;
ItemViewSingleItem;
PageDesignContent

Enter the name of the template into the CSV file. Make sure you also select the language and webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that this template was selected.

Full text search

0
1

0

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the category will be added to the search index in the store. Make sure you also select the language and webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that one of the following values was used for the Full text search setting.

  • 0 = No

  • 1 = Yes

Robots

all
index
nofollow
noindex
nofollow_noindex

all

Enter one of the permitted import values into your CSV file. Which value you choose determines how search engine crawlers will deal with the page and any links on the page. Make sure you also select the language and webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that one of the following values was used for the Robots setting.

  • 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 placeholder

Y
N
L

Y

Enter one of the permitted import values into your CSV file. Which value you choose determines whether template variables and functions will be translated. Make sure you also select the language and webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that one of the following values was used for the Translate template variables and template functions setting.

  • Y = Yes

  • N = No

  • L = Template variables and template functions for links only

Canonical

Alphanumeric

- n/a -

Is there another category with the same content? If so, then enter the URL for this category into your CSV file. The URL is limited to a maximum of 256 characters. Make sure you also select the language and webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that this URL was entered into the Canonical field.

Elmar

Elmar-category

Alphanumeric

- n/a -

Enter the name of the Elmar category into the CSV file. Make sure you also select the webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that this Elmar category was selected.

Delete existing

0
1

0

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the Elmar category link should be deleted. Make sure you also select the webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that the Elmar category was deleted everywhere the number 1 was entered.

  • 0 = Do not delete

  • 1 = Delete

Client (store)

Active

0
1

0

Enter one of the permitted import values into your CSV file. Which value you choose determines whether the category will be activated for a particular store. Make sure you also select the webstore within the Mapping area.

If you open the category after it was imported and look at the Settings tab, then you’ll see that one of the following values was used for the Client (store) setting.

  • 0 = Not activated for the specified client.

  • 1 = Activated for the specified client.

To top