New
Mar 9, 2025
The language versions of categories and CSV import are key functions in the AI Commerce e-commerce system, enabling efficient management of categories.
CSV Import
In the CSV import function, the system reads the CSV file line by line and updates or creates new categories according to the following rules:
categories_code: This is a mandatory field that identifies the category. If the code is new, a new category will be created. If it already exists, the system will update the existing category.
parentcode: This field is optional and specifies the parent category's code. If a value is provided and recognized, the category becomes a child of this parent category. If the parentcode is given but not found, the system may create a new parent category or skip the value according to the configuration.
Language-specific columns: For example, categoriesname[fi], categoriesname[en] update the TABLECATEGORIESDESCRIPTION table. If the language row does not exist, it will be created.
Other columns: For example, catfrontpageimg, categoriesindex, categoriesurl[fi]_ update the corresponding data fields if values are provided for them in the CSV row.
Creation of New Language Rows
When a new category is created, the system can automatically create empty language rows in the TABLECATEGORIESDESCRIPTION table for each language. After this, only the languages present in the CSV will be overwritten.
Important Notes
If categoriescode or parentcode is completely missing, the row may be skipped or saved with default values.
The CSV file must have exactly the same number of columns on each row, and multilingual fields should be marked in the form
[fi], [en], [sv]etc.
Summary
Importing categories via a CSV file allows an efficient and flexible way to manage your store's structure. It is recommended to start with an export function, edit the CSV file, and then upload the changes with the import function.
If you need more information or assistance, you can always contact our customer service.
