Additional attributes

The column additional_attributes allows importing values for all attributes not part of the standard format CSV, including user-defined columns.

Remember that for an attribute of types listed below, the value is always the admin storage and never one of the scopes
  • Yes/No

  • Select

  • Multi-select

  • Dropdown

  • Text field

  • Visual field

The value rendered is displayed either at the end or in the beginning of the selected store view and for all other attribute types.

Enclosing, Escaping, and Delimiter

Since the default multi-field separator , separates the key-value pairs with the option values to be imported, it is necessary to enclose the entire value of the column with double apostrophes ".

Examples

Table 1. In unusual constellations, the double apostrophes ( " ) must get enclosed by another additional double apostrophe ( "" ) as well.
sku additional_attributes

MB-2401

"color=black,""features=Audio Pocket|Laptop Sleeve, 15 inches"""
Table 2. If values of additional attributes contain a double apostrophe ( " ), e.g. Laptop "Sleeve", they must be enclosed with a backslash ( / ) or by another additional double apostrophe ( "" ) as well.
sku additional_attributes

MB-2401

"color=black,features=Audio Pocket|Laptop ""Sleeve"""
Table 3. If additional value attributes contain double apostrophes ( " ) as well as commas ( , ), these must also be enclosed and escaped by another additional double apostrophes ( """ ).
sku additional_attributes

MB-2401

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

If a backslash ( \ ) is used as an escape character to remove the delimiter, e.g. Laptop \"Sleeve\" the delimiter ( \ ) is not automatically removed, but stored in the database as well.

Multiselect Attributes

  • For multiselect attributes, more than one value is specified for an attribute

  • The values must be separated by a character, which by default is the pipe ( | )

Table 4. If for the multiselect attribute activity, the values gym and hiking, trails are to be selected, then the column additional_attributes must get structured as the following example shows.
sku additional_attributes

MB-2401

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

Multiselect attributes are the only values that will use the separator ( | ) for multiple values.

Configuration

In addition to the general CSV configuration at subject level, Pacemaker Import Community allows us to override default values which use a comma ( , ) for the multiple fields and a pipe ( | ) for the multiple value separators.

Unlike the general CSV configuration, it must be done at the global level and is valid for all operations, subjects, and observers.

It is possible to override the default configuration by adding and overriding the setting value for multiple-field-delimiter or multiple-value-delimiter or for both, as described in the following configuration example shown.

{
  "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" : { ... }
}