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	Alpha-numeric	- 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)	Alpha-numeric	- 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	Alpha-numeric	- 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	Alpha-numeric	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)	Alpha-numeric	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	Alpha-numeric	- 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	Alpha-numeric	- 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.