cancel
Showing results for 
Search instead for 
Did you mean: 

Weird problems uploading csv with multiselcts attributes

Weird problems uploading csv with multiselcts attributes

Hi,

I'm desperated. After tousands of tests, I'm not able to upload products with multiselect attributes.

 

This is what I do:

 

1. I created a csv file where in additional attributes i have two attributes:

- color: unique value attribute

- size_eu_multi: multiselect attribute

The structure in my csv in additional_attributes column is:

 

color=White,size_eu_multi=24|25|26|27,5,sw_featured=Yes

 

For a configurable product, each simple product row has different values, obviously.

 

2. I go to Magento backend, import and select Field separator "," and Multiple value separator "|" (without quotation marks).

 

When I clic on check data, it says:

 

Value for 'color' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1, 2, 3, 4, 5 

 

(All color values are well defined)

 

I tested it with other attributes and in one case, where the attribute had no predefined values, it took the hole cell values. I mean, if the structure were:

 

attribute_no_values=222,color=White,size_eu_multi=24|25|26|27,5,sw_featured=Yes

 

I can import it without problems, but the value imported in that case for "attribute_no_values" is "222,color=White,size_eu_multi=24|25|26|27,5,sw_featured=Yes".

 

So, my theory is that there should be a problem inside the cell to separate different attribute definitions.

 

If I select Multiple value separator as "," , I get no errors, all is imported perfectly but the multi select attribute values are not imported.

 

Where is the problem????

 

Thanks a lot!!!!

 

 

 

 

 

1 REPLY 1

Re: Weird problems uploading csv with multiselcts attributes

Hello,

 

I had the same problem and found solution. 

1. First of all change field separator from "," to ";" - because "," can be use ex. in description and magento does not manage with it.

2. By default multiselect attributes separator in magento is | and it is not choosable. The second separator which you chose is being using to separate many attributes in one column like additional_attributes.

 

In your case, save csv file with ";" separator field. On backend magento setup ";" as separator field and "," as second separator like here: https://prnt.sc/1q73t1z

 

Then you should been able to import it. Anyway the easiest way is to import each multiselect as separately column. So you can addsize_eu_multi as a column and give it values: 24|25|26|27

 

I am quite sure it will helps ;-) Good luck.