Categories separated with commas create groups of categories

[alwayspaws]

I uploaded some products with multiple categories separated by commas.

Instead of the products being associated with the correct categories, a new category was created by stringing them together.

Is this a bug? I originally didn't use spaces but was told to use spaces in between the category and comma for multiple categories.

The example is a dog dress that should be in the dog clothes main category and the dog dresses subcategory.

[spidawebs]

You need to use a semi colon instead of a comma to separate the categories in your spreadsheet

[alwayspaws]

Thanks @spidawebs I need to check this with @mdekker to see if it's the same problem. We discussed this in another forum that we're trying to make sure everyone can use the same separators and also now, we can use any spreadsheet format, which is great to know! Here:

https://forum.thirtybees.com/topic/470/csv-problems-missing-short-descriptions-headers-too-big/65

@mdekker said "I also did some tests BTW and noticed that importing xls, xlsx, whatever, works pretty fine. You just have to demand that the multiple value columns are in the right format. (Separated by a comma, values that can contain a comma are quoted ")."

I think the Category column is a multiple value column if you're trying to use more than one category. Same for tags.

I don't want to make changes until it's confirmed because several updates were made to thirty bees.

[alwayspaws]

@spidawebs Absolutely right as you were before. Using semicolons was the only way my csv imports worked to place products in the correct categories. Thank you!

[alwayspaws]

@mdekker said in Categories separated with commas create groups of categories:

Ohh indeed. My info was outdated. Sorry for the confusion.

Oh! I sure am glad I thanked spidey before you said that! :) thank you!

In thirtybees "outdated" can mean as little as one day.