Additional attributes

The column additional_attributes allows import values for all attributes that are not part of the default CSV format, including the user-defined columns.

Remember always that for an attribute of type [Yes/No|Select|Multi-select|Dropdown|Text field|Visual field] the value is always the admin store’s value and never one of the scopes.

The rendered value is the one by the selected store view, either in the back or front; it is also the case for all other attribute types.

Enclosing, Escaping, and Delimiter

As the default multiple field separator, which separates the key-value pairs with the option values to be imported, is a comma (,) it is necessary to enclose the complete value of the column with double apostrophes (").

Additionally, if only one of the attribute option values also contains a comma, e. g. the value Laptop Sleeve, 15 inches, the complete key-value pair additionally has to be enclosed with double apostrophes (").

It leads to unusual constellations, as those double apostrophes (") has to be escaped with double apostrophes (") again see

sku …​ additional_attributes …​


"color=black,""features=Audio Pocket|Laptop Sleeve, 15 inches"""

In case the values of additional attributes contain a double apostrophe ("), e. g. like Laptop "Sleeve" those have to be escaped with a backslash or a double apostrophe (") itself like

sku …​ additional_attributes …​


"color=black,features=Audio Pocket|Laptop ""Sleeve"""

It will also be possible that the values of additional attributes contain double apostrophes (") as well as commas (,). Those have to be enclosed and escaped like

sku …​ additional_attributes …​


"color=black,""features=Audio Pocket|Laptop ""Sleeve"", 15 inches"""

Please keep in mind that when an escape character, which defaults to backslash (\), is used to escape the delimiter, e. g. Laptop \"Sleeve\" the delimiter will not be removed automatically, instead it will be stored in the database.

Multiselect Attributes

In the case of Multiselect Attributes, more than one value for an attribute is specified. Those values have to be separated by character, which by default is the pipe (|).

For example, if the Multiselect Attribute activity should have the values gym and hiking, trails selected, the column additional_attributes must look like

sku …​ additional_attributes …​


"""activity=gym|hiking, trails"",""features=Audio Pocket|Laptop Sleeve, 15 inches"""

The Multiselect Attributes are the only values that use the multiple value delimiter.


Beside the general CSV configuration on subject level Pacemaker Community Edition (CE) allows to override the default values, which are a comma (,) for the multiple fields and a pipe (|) for the numerous value separator.

In contrast to the general CSV configuration, this has to be done on the global level and is therefore valid for all operations, subjects, and observers.

It is possible to override the default configuration by adding either one of or both multiple-field-delimiter and multiple-value-delimiter to the configuration file like

  "magento-edition": "CE",
  "magento-version": "2.3.2",
  "operation-name" : "add-update",
  "installation-dir" : "/var/www/magento",
  "multiple-field-delimiter" : ",",
  "multiple-value-delimiter" : "|",
  "databases" : [ ... ],
  "loggers" : [ ... ],
  "operations" : { ... }