Skip to content

M2 Product Import “Multi Select” upload bug – Returns error when only 1 option given

I’m trying to bulk upload a whole bunch of product attributes. When I attempt to upload values for attributes with “Multi Select” values I get this error message.

  1. Value for ‘x’ attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1, 2, 5, 6, 8, 9, 10, 11

What I’ve noticed is that this error message is only displayed on the fields with 1 value submitted and only when uploaded in conjunction with other attribute values.
I am uploading under header “additional_attributes” with “,” as the separator and “|” as the multiple value separator.

I can take the values for attribute_1 and upload them individually completely fine, ie.

attribute_1=brand1|brand2|brand3

attribute_1=brand3

However, when I try and do this on multiple attributes, the 2nd row would return the above error ie.

attribute_1=brand1|brand2|brand3,attribute_2=size1|size2 (this one is fine)

attribute_1=brand3|,atrribute_2=size1|size3 (this one returns “1. Value for ‘attribute_1’ attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 2

Has anybody come across this before and has a fix or am I just going to have to split the data and upload one sheet per attribute?