Exporting and importing options of select and multiselect attributes with CSV

The attribute options, such as color choices, brands, or sizes, are often select or multiselect type fields. The management of these options is now efficiently handled in AI Commerce also using a CSV file.

Import and export occur through the management panel under Products → Attributes → CSV Export Options and CSV Import Options.

The structure of the CSV file is as follows:

code;title[fi];attribute;sort_order
sram;SRAM;brand;1
scott;Scott;brand;2
bbb;BBB;brand;3

• code: a unique identifier for the option

• title[fi]: the name of the option in the desired language

• attribute: which attribute the option is related to

• sort_order: the order of the selections

You can use the export file directly as a basis for the import. The file can be opened, for example, in Excel and easily edited.

The options do not affect other settings of the attribute but solely determine the selections visible to the user.

The system validates the structure of the CSV before importing and notifies if any columns are missing or if the code is already in use on another line.

For customers using the Akeneo integration, the code value can also be generated automatically through PIM.

This feature saves time and makes the management of options quick, especially in the context of multiple products and multilingual content.