<Solved> How to use csv import for many colors & sizes for a single product?

[alwayspaws]

How do I make size and color choices easier for the customers to read?

[Baarssen]

Its a long list because you combined the attributes. It should be easier if you splitted it into 1 attribute for size, and 1 for color. Maybe you will have to do this manually. Maybe its some work, but it is a 1 time job, after that your attibutes are stored and you can use them any time.

In my webshops i also use lots of color and size attirbutes, and i have splitted them into 2 attributes. Some products of me have more then 5000 combinations.

[alwayspaws]

I have the attributes both ways in the attributes section of the back office. size,color and each by themselves.

[Baarssen]

i dont use spreadsheets, where do you use it for?

[alwayspaws]

@Baarssen I only use spreadsheets, but if you go to the BO - CSV import - combinations import - you can see the choices there.

[Baarssen]

I never have done that before. When i setup a product i use a combination module which creates the combinatiosn for me. For as far as i can see it combines in the import and shows it as 1 attribute instead of 2. But i think it should be possible what you want. Maybe 1 of our developers can help you out, dont think its that difficult.

Watch my attributes :)
https://www.screencast.com/t/vPU3NbrNOO

[alwayspaws]

I'm glad I don't have to deal with all that! I haven't had to use so many combinations in one item before. Thank you!

[jnsgioia]

I checked your site and the items you listed a while ago have the size and color split. The newest ones have them as one item. Did you change your csv file format recently?

If you are using a , as the multivalue separator it should import your size and color as two attributes not one. Your file looks like mine except I use ~ as my multivalue separator.

[alwayspaws]

@jnsgioia Thanks. I should have referred you to my screenshot in the beginning of my post. It shows the csv with the comma multivalue separator. The products you viewed only have a few choices. I changed and successfully have been using my csv for a long time. Nice to see you ?

[alwayspaws]

These products have many more colors and each have all the sizes. I've been using a comma as the multivalue separator and comma to separate the attributes.

[alwayspaws]

There's some detail I'm missing here but I can't see it so far.

[jnsgioia]

For some reason it is not recognizing the comma as a multivalue separator, that is why I asked if you had changed your file format recently. I guess I should have asked if you were using the comma when the earlier listings were uploaded.

The number of combinations shouldn't make any difference.

[zimmer-media]

@alwayspaws hi stephanie try this for example

variante (attrribute) wert (value) farbe (color) größe (size) select - is dropdown-option

csv-import-option i use comma and semicolon

[alwayspaws]

@zimmer-media Thank you for your time and effort!

I still can't get it to work. I separated the variante (combination attribute) with a comma: size, color

wert (combination value) size and color is XS,baby blue (no separator in between size and color)

Dropdown is set up for all my attributes. Field separators for the import are comma and semicolon.

I'm doing this on my test site, btw. With a comma between the combination values of size and color:

Test product:

[alwayspaws]

@lesley @mdekker @Traumflug @wakabayashi I think we have a bug in the csv imports. Screenshot: I used the same exact csv and the old product page is correct. I changed the ID # for the new upload to #700.

The new product page is wrong and so are all the newest products I have uploaded that have combinations sizes and colors.

Here is the csv file I used and all I did was change the Product ID

01507730688780test-10-11-17.csv

[zimmer-media]

@alwayspaws

you must change your csv-file with attributes - i have make it with 4 other stores, and it works fine for me. colum attribut eg you must write "color:select:0, size:select:1" colum value write "baby blue:0,XL:1"

[alwayspaws]

I uploaded my csv. Have there been any csv update changes since a month ago? All I do is upload products.

[zimmer-media]

@alwayspaws hmm i see your csv - i work with comma delimited csv - more option to edit see you csv in 2 row (first product line)

015077313329311507730688878-test-10-11-17.csv

[alwayspaws]

@zimmer-media That was terrific of you to show me how to update it. Thank you very much!

Is this new way to format combination names and values correct for me - single store.

[alwayspaws]

@zimmer-media

XS:0,aqua:1 - for all aqua sizes.

XS:0,baby blue:1 - for all of that color and so on?

[zimmer-media]

@alwayspaws it looks good - see my csv image on prev comment

[alwayspaws]

Hi, @zimmer-media I did and it seems a little confusing but thank you.

color:select:0, size:select:1” column value write “baby blue:0,XL:1

I really have to wait for @Traumflug @mdekker and @lesley because there was a lot of work done on csv imports a couple of months ago and a lot of changes. (I'm not being stubborn. I'm overwhelmed.)

[alwayspaws]

LadyDee - I need a break. not feeling well. sorry. sending best wishes to you!

[wakabayashi]

@alwayspaws Sorry, I can't help you on this one. I have never worked with csv imports. To be honest you know much more about it than me. I believe that, Markus or Michael know the technical part.

[jnsgioia]

@alwayspaws When I went to open the csv file in libreoffice calc it showed that the file has the field separator as a comma as well as the multivalue separator. I opened it in notepad and it does have the field separator as a comma.