Table
Your table structure for importing parameters has to be very precise, and it has to be in CSV UTF-8 format.
Your table needs to have five columns.
product_identifier
Into this column you need to add either your product's ID, Code, or EAN. Do note that these need to be the same type for all products in this file.
If you need to add multiple parameters to one product, simply add the product into multiple rows, as shown in the example.
parameter_set_name
The name of this column will hold an additional piece of information, namely, the default language of your account. The language has to be added in ISO 639-1 form, a.k.a. in two-letter format, and has to have a period before it.
In the example file, that is English (.en). It can also be Estonian (.et), Spanish (.es), or any other language that can be set as the default language of an account.
Into this column you need to add your parameter set's name in the account's default language. You can see this under Settings -> Configuration and can find the identifier format HERE.
parameter_name
The name of this column will hold an additional piece of information, namely, the default language of your account. The language has to be added in ISO 639-1 form, a.k.a. in two-letter format, and has to have a period before it.
In the example file, that is English (.en). It can also be Estonian (.et), Spanish (.es), or any other language that can be set as the default language of an account.
Into this column you need to add your parameter's name in the account's default language. You can see this under Settings -> Configuration.
parameter_type
Into this column you must add the type of the parameter. The possible types are these:
- text
- number
- decimal
- boolean
- list
- multilist
parameter_value
Here you add the value of the parameter for the item. Examples are in the example file.
For the Multiple-Selection List, the values must be separated by a comma and a space.
Import
Once you have your file and are ready to import your parameters, go to PIM -> Product PIM Parameters Import.
Upload your CSV file and select the delimiter (generally it is simply a comma).
Now you need to choose the Product Identifier that you set in the first column of the table. Choose either Product ID, Product Code, or Product EAN/UPC.
Choose which products you want to update (active products only or all states), and choose the import type.
The import types are:
- Update and create
- Updates and creates parameter set, parameters, and product selected values. Uses account default language name values to identify existing records.
- Create all as new
- Creates all entries in the import as new and selects the values for products
- Update and create parameters only
- Only creates and updates parameter sets, parameters, and their options. Product identifier column is not used.
- Update product values only
- Only updates product selected values. If parameter sets and parameters do not exist then the rows will be skipped.
After setting all of the configurations, click Create and Confirm.
Known Issues
Currently the Multiple-Selection List parameter_value does not work as it should, it only imports the first choice.
This can NOT be fixed by importing the same parameter with a different value multiple times, this will simply overwrite the value.
This can NOT be fixed by adding the same parameter name and type to multiple rows, only adding extra values. (See example below)
