This guide will show you how to import attribute sets into the system using a CSV file using the Akeneo-style structure. With the correct CSV format, you can create or update multiple attribute sets at once, saving time and avoiding errors in manual entry.

Below is a step-by-step guide that describes required columns, how to use language codes, and common error messages. Follow the examples and make sure your CSV is saved in UTF-8 encoding.

Step-by-step instructions

Prepare the header row of the CSV file

• If you did not use the export template, create a CSV file with at least the following columns:
  • code ( required, if missing in update, create first in the control panel or database)
  • title[fi] , title[en] (and other necessary language columns)
  • attributes (comma separated)
  • sort_order (integer)
• Make sure the column names are in exactly the correct format, for example title[fi] and not title_fi .

Fill in the rows with the attribute set data

• Each row represents one attribute set.
• code column specifies the code of the set (for example, frame_fork ).
• Language-specific columns (such as title[fi] ) contain the name of the set in that language.
• The value in attributes column is a comma-separated list of attribute codes that belong to this set (e.g. front_fork,frame,rear_shock ).
• sort_order determines the order in which the set is displayed in the user interface.

Verify the number of columns and language codes

• The order is not mandatory, but the column names are.
• For example, if you add the Swedish language, use the column name title[sv] .
• Check that each row has the same number of columns as the header row. The system compares the number of columns directly to the header.

Save and upload to CSV system

• Save the file in UTF-8 format so that the characters work correctly.
• Upload the file to the system (e.g. via the Import function) or according to your chosen process.

Example line

The following table illustrates what a line might look like when you want to create or update an attribute set in three languages (FI, EN, SC).

In a CSV file, this same line (with the default ; separator and " encloser) could look like this (on one line):

frame_fork;Runko ja Haarukka;Frame and Fork;Haarukka SC;front_fork,frame,rear_shock;2

If the title line is, for example:

code;title[fi];title[en];title[sc];attributes;sort_order

...then the above information matches these columns.

Check for any error messages

• The most common reasons for import failure are:
  • Missing or misspelled title line.
  • Incorrect column name format (e.g. TITLE[fi] or title_fi ).
  • Rows have a different number of columns than the header.
• In practice, the system may report errors such as:
  • “No CSV file uploaded.”
  • “Cannot open CSV file.”
  • “CSV missing header row.”
  • "CSV error on row X: expected Y columns, got Z."

Where do you edit from?

• For example, if you have the Import function in the system's admin panel, go there and select the CSV file you just created to upload.
• Similarly, the Export function allows you to first take the template out, edit it, and then import it back.

Summary

1. Create a CSV file with required columns ( code , attributes , sort_order , and language columns such as title[fi] ).
2. Be sure to use the correct column names, paying attention to the language codes in square brackets.
3. Make sure each row has the same number of columns as the header row.
4. Upload the file to the system and monitor any error messages so you can correct the CSV if necessary.

These instructions will make importing attribute sets quick and straightforward. Also, check out the option to export past data to get a clear model of the CSV structure.