Import same Sub Cat Names in different Categories

Hi there,
first of all, sorry about me englisch.
I try to fill my shop via CVS import - in gernerel, it works great.
But i´ve a tiny problem.
i use in differnet (main)categorys sub-categories with the same name, for example:

Main-categorie-name: Honda
Sub-Categorie-name: Mirrows

Main-categorie-name: Kawasaki
Sub-Categorie-name: Mirrows

Yes, the example ist stupid, but i hope you know what i mean!

If i try to import via CSV i fill the collum "categories": Honda;Mirrows and in a different row Kawasaki;Mirrows

but some times ( not every time) the product in the subcategorie "Mirrows" from Kawasaki is schown in the Supcategorie of Honda.
What do i made wrong?

Is it possible to use the ID of the (existing) Categories in my CSV Data, if yes, do i have tu set e extra collum-name like "Categories_id" or do i´ve to set a parameter in the field (id_1;id_2)?

Thanks for your help,
Cleese

nicolas,

To use the category ids, are the values separated by a comma? Like:
product_code;categories
my_product1;23,45,68
my_product2;5,11,12,56

Thanks!

I understand the theory, but when I save a .CSV from Excel I can't get it to work. This is what my Excel sheet looks like:

product A	cat-red,cat-white;cat-blue,cat-orange
product B	cat-a;cat-b;cat-c;cat-d
product C	cat-1,cat-2,cat-3,cat-4

This is the result of the category-tree after the import:

Article category
└ cat-d
└ cat-c
└ cat-b
└ CAT-BLUE
└ cat-a
└ cat-1
└ CAT-RED
└ cat-2
└ cat-3
└ cat-4

How can I can this:

Article category
└ cat-a
...└ cat-a1
...└ cat-a2
...└ cat-a3
└ cat-b
...└ cat-b1
...└ cat-b2
...└ cat-b3
└ cat-c

Important: I had to type the three dots "..." in front of the └ to show the structure. This forum doesn't support multiple spaces. The three dots don't mean anything.

I understand your comment. To clearify it, this is want I would like to have:

Article category
└ cat-a
...└ cat-a1 > contains product A, B, C
...└ cat-a2 > contains product C
...└ cat-a3 > contains product C
└ cat-b
...└ cat-b1 > contains product A, B, C
...└ cat-b2 > contains product A, B, C
...└ cat-b3 > contains product B
└ cat-c > contains product A

How to I put this in my Excel-sheet? And in what column(s) ?
Thanks.

I have not been able to get this to work properly in 3 days time now.

Lets say I have:
Banner Stands
--Retractable Banner Stands
--Cut Vinyl
Retractable Banner Stands
Floor Graphics
--Cut Vinyl
Corrugated Signs

When importing, I have this in the categories field "Banner Stands;Retractable Banner Stands;Cut Vinyl;Retractable Banner Stands;Floor Graphics;Cut Vinyl;Corrugated Signs"

Now based on that all products should appear in all Cats and Sub Cats. However, they do not appear in --Retractable Banners Stands, --Cut Vinyl but they do appear in --Cut Vinyl under Floor Graphics. So how exactly does this "import" process work?