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

[jnsgioia]

The important thing is to have a different symbol as a field delimeter and a multivalue delimiter. In your first csv you were using a comma for both.

[alwayspaws]

OK, moving full steam ahead - for the 20th time today! lol

[jnsgioia]

@alwayspaws :) hope it works this time :)

[alwayspaws]

@jnsgioia Me, too. :) Trying now!

[alwayspaws]

So I tried twice and got this error now:

Errors occurred: Dog Clothes; Dog Hoodies (ID: null) cannot be saved Property Category->name is not valid Dog Clothes; Dog Hoodies cannot be saved

Before, it was working with categories field like this: Dog Clothes; Dog Hoodies

[alwayspaws]

@daokakao by the way, I sent you the actual whole original .ods but things have changed since then.
The combination names are size,color since that was fixed, instead of size;color.

I removed all the products except the hoodie for all these tests. The image url is also updated in my latest ones. Just letting you know.

[alwayspaws]

@jnsgioia I know you can't spend your whole life trying to fix this, so don't worry about leaving. :)

[jnsgioia]

Ok, I think I now see your problem. Am I correct in that in the file you sent to @DaoKakao you had a semi colon between size and color and you changed it to a comma recently?

[alwayspaws]

No that isn't the problem. It was changed months ago by Mdekker. That's why I wrote @DaoKakao that note just now.

Here is how I work with spreadsheets: I first save as .ods so I can highlight and copy and replace as much as I need to. Once it looks good, I convert it to .csv. Then I upload it.

[alwayspaws]

I need to see why I have these errors suddenly, even though those categories have existed since the very beginning.

Errors occurred: Dog Clothes; Dog Hoodies (ID: null) cannot be saved Property Category->name is not valid Dog Clothes; Dog Hoodies cannot be saved

[jnsgioia]

The problem is in the file you first posted you have a comma between your fields as well as between size and color. In the error you just got it is because for categories you are using a semi colon as a multivalue separator but you told the upload that the multivalue separator is a comma. I think if you change the comma between the size and color to a semi colon and save the file with the field separator as a comma it should work.

Do I now have you completely confused? :)

[alwayspaws]

OK I'll change back to size;color but all we are doing is reversing all the work that was fixed two months ago. :(

[alwayspaws]

What I need is to be able to create .ods and work on it and convert it to .csv when I'm ready.

[alwayspaws]

@jnsgioia

Is this correct?

To open csv's:

To open the csv: select comma.

Then go to save as copy.

On the first popup box make sure “edit filter settings” is checked.

Then on the second popup box make sure the field delimiter that is checked is the semicolon.

Make sure the box that says “save cell content as shown” IS CHECKED.

on admin csv import page: field separator as a semicolon and the multivalue as a comma

[DaoKakao]

@alwayspaws Why don't you make a sandbox environments for new features testing? It will ease your life. I can send my version of CSV for you. just try to import it?

[alwayspaws]

@DaoKakao I don't know how. I wish I did! By the way I use a Mac. I tried Xampp, etc last year and just couldn't get it to work.

Is that what you mean for the sandbox?

Yes, I'd like to try your version of the CSV. Thank you.

[alwayspaws]

@jnsgioia so now I have size;color and categories are: Dog Clothes; Dog Hoodies

I tried to import and now I got this again:

Errors occurred: Dog Clothes; Dog Hoodies (ID: null) cannot be saved Property Category->name is not valid Dog Clothes; Dog Hoodies cannot be saved Validating data...

[jnsgioia]

Did you save it with field delimeter - comma

and import it (in tb bo) with field delimiter comma multivalue ; (opposite of what I told you above)

[DaoKakao]

Sandbox is kind a sandox for playing around with new features/modules/themes, et c. - i.e. this is testing installation of your shop, not for production.

I use more windows PC, so it would be bit difficult to explain some things about macs, but this isn't impossible :)

[alwayspaws]

@jnsgioia said in How do I use a csv import for a large amount of colors & sizes for a single product?:

Did you save it with field delimeter - comma

and import it (in tb bo) with field delimiter comma multivalue ; (opposite of what I told you above)

@jnsgioia said in How do I use a csv import for a large amount of colors & sizes for a single product?:

Did you save it with field delimeter - comma

and import it (in tb bo) with field delimiter comma multivalue ; (opposite of what I told you above)

on admin csv import page: field separator is a semicolon and the multiple value is a comma

[alwayspaws]

@daokakao said in How do I use a csv import for a large amount of colors & sizes for a single product?:

Sandbox is kind a sandox for playing around with new features/modules/themes, et c. - i.e. this is testing installation of your shop, not for production.

I use more windows PC, so it would be bit difficult to explain some things about macs, but this isn't impossible :)

Is this something I have to pay for? I can try it without bothering you. :) I'm currently using a test copy of my site in TB.

[jnsgioia]

@alwayspaws reverse them :)

If you save the csv with a comma delimiter have the tb field separator comma, if you save it with a semi colon have the tb field delimiter semi colon

[DaoKakao]

@alwayspaws No, this is free - you should organize a sandbox by yourself. Here's an alternative for XAMPP: https://www.mamp.info/en/ - for MAC. If you encounter the problems with APACHE/NGINX configuration - i can help you

@alwayspaws said in How do I use a csv import for a large amount of colors & sizes for a single product?:

I’m currently using a test copy of my site in TB.

This is exactly what the sandbox is

[alwayspaws]

@jnsgioia This is very confusing.

[alwayspaws]

@daokakao said in How do I use a csv import for a large amount of colors & sizes for a single product?:

@alwayspaws No, this is free - you should organize a sandbox by yourself. Here's an alternative for XAMPP: https://www.mamp.info/en/ - for MAC. If you encounter the problems with APACHE/NGINX configuration - i can help you

@alwayspaws said in How do I use a csv import for a large amount of colors & sizes for a single product?:

I’m currently using a test copy of my site in TB.

This is exactly what the sandbox is

I will try that. I'm having problems with the import.