MALL category export

An integral part of the MALL implementation is the selection of relevant categories where you can list your products. Find out how to do this below.

In this article you will find exports of all product categories updated from December 2022 for the Czech Republic, Slovakia, Hungary and Slovenia , downloadable below.

At the same time, all Category Trees are available through the API, here.

For manual insertion of products, this file is used for an informative overview of the MALL categories. You can find a similar overview when you create a product in the MALL Partner Portal in the tab Products - List of categories.

For linking Heureka XML feed type, this file serves as a basis for product management.

How to work with the file?

For an initial summary, we will list the names and meanings of the columns. Some columns may vary by country, but the structure is the same.

Column A - Shop ID - abbreviation of the country where the categories are based CZ, SK, HU, PL, SI

Columns B to J - Category Tree, Lvl1 - Lvl8 (cz, sk, hu, pl, si) - the sequential path of categories as it appears on the MALL/ Mimovrste website

Here you can take a look through the URL: https://www.mall.cz/chargers-autobattery.

Columns K to S - Lvl1 - Lvl8 eng - machine translation of categories into English (open the file using the "+" sign in the top bar)

Column T - URL of the category on the MALL/ Mimovrste website

Column V - TYPE ID - it is a product (P) or filter (F) category.
To get into a filtering category, it is necessary to specify the Product type ID and sorting parameters with the value of the parent category and add the parameter with the given value from the row of the filtering category. The filter category can be used to sort, for example, individual types of in-ear and over-ear headphones.
Therefore, never filter only the filter categories in the export. You will not see the parent category information that you need to assign products to a filter category.

Column W - Category ID (SAP ID) - MALL ID of the selected category e.g.: ND383 - Car battery charger. You will use these category codes to upload products.

Column X - Parameter - the technical name of the parameter, the so-called sorting (mandatory) parameters of products that must be specified for the product to be correctly classified into subsections of the category.
It is also necessary to pay attention to the spaces before and after the parameter and value. Errors in parameters and values will cause the product to not be displayed on the MALL/ Mimovrste website.

• Parameter ID: TYPE_OF_LIGHT → technical code of the sorting parameter

Column Y - Operator - according to the characters below you will use the individual values (value) in the parameters

• = → specific value indicated (need to specify for products exactly as indicated in the file)
• IN → one or more possible values (means "with at least 1 value", then allows to use one or more of the offered values)
  ATTENTION: Values are always separated by a comma on the website. It is necessary to select one or more of the values listed and list them individually for the parameter..
• → value other than the displayed value ("must not be this value", use a value other than the displayed value)
• >< → a range of two values (from - to) (for numeric parameters it means "a number in the range from to", for inclusion it is enough to specify a value in the given range)
  
  The system is case-sensitive, diacritic or space before or after a value.

Column Z - Value 1 - technical name of the value of the so-called sorting parameter from column X

Column AA - Value 1 original language - the value of the sorting parameter, which is always given in the language of the country

Column AB - Active - indicates the category as active (Y) and inactive (N)

Column AC - Visible - indicates the category whether it is visible (Y) or hidden on the MALL/ Mimovrste website

Column AD - Menu Item ID - unique identifier of the category and is used to call the category detail using API

Column AE - Fulltext query - displays the keywords required to assign a product to a given category
This column contains keywords that must be included either in the product name or in a short description of the product. Otherwise the product will not appear in the category.
If a column contains multiple values separated by a separator, it is sufficient that only one of these values appears in the labels. If an asterisk appears in the term, it is sufficient that the word in the label contains only the part before or after the asterisk.

If you can't find a suitable category, please contact your sales representative or contact us via Help Centre.