Importing CSV problem

[BlizzardUK]

I have managed to import 900 products, but for some reason many are going in the wrong directories. It is a music site that I run and I am wondering if the word "CD" is confusing things. I don't think it can be spelling mistakes as I used a batch converter for them.

 

Here is how I put the categories on the CSV file...........

 

Home, Cliff Richard, CD

 

Home, The Shadows, CD

 

For some reason many of those I have down as "Home, The Shadows, CD" are ending up on the Cliff Richard CD section on my website.

 

How can I stop this happening ? Also all of them end up in the Home section which I don't want. Do I have to remove the word "home" ?

 

Any ideas ? Thanks

 

EDIT : I have solved it myself, I now use numbers, I had no idea you could, I was using text as the categories but numbering works best (check the URL for the category number). I am writing this edit to let anyone else know if they suffer the same issues.

Edited April 22, 2013 by BlizzardUK (see edit history)