Category language versions and CSV import now available

During CSV import, the system reads the file row by row and updates or creates categories based on the following rules:

• categories_code: This is a required field that uniquely identifies the category. If the code is new, a new category is created. If it already exists, the existing category is updated.

• parentcode: This optional field defines the parent category’s code. If provided and recognized, the category will become a child of that parent category. If the parent code is provided but not found, the system can either create a new parent category or skip the value, depending on configuration.

• Language-specific columns: For example, categoriesname[fi], categoriesname[en] update the TABLECATEGORIESDESCRIPTION table. If a language row does not yet exist, it will be created automatically.

• Other columns: For example, catfrontpageimg, categoriesindex, and categoriesurl[fi]_ update the respective data fields if a value is provided in the CSV row.

Creating new language rows

When a new category is created, the system can automatically generate empty language rows in the TABLECATEGORIESDESCRIPTION table for each language. Only the languages included in the CSV will be overwritten.

Key points

• If categories_code or parentcode is missing entirely, the row may be skipped or saved with default values.

• The CSV file must have exactly the same number of columns in each row, and multilingual fields must be marked in the format [fi], [en], [sv], etc.

Summary

Category CSV import allows for a fast and flexible way to manage your store structure. It is recommended to start by exporting your categories, editing the CSV file, and then re-importing it.

If you need further details or assistance, please contact our support team.