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

Hi,

You can use ids directly in the "categories" column, like that:
product_code;categories
my_product1;XXX
my_product2;YYY

where XXX and YYY are the ids of your sub categories.
Or you can do like that:
product_code;parent_category;categories
my_product1;kawasaki;mirrows
my_product2;honda;mirrows

and that will add the products in their respective mirrows subcategories.

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!

yes, you can do like that.

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.

You don't have the same categories between each example you give.

What are cat-a1 cat-a2 etc ? How are they linked to the products A B and C ?

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.

You need to have that CSV:

product_code;parent_category;categories
;cat-a;cat-a1,cat-a2,cat-a3
;cat-b;cat-b1,cat-b2,cat-b3
product A;;cat-a1,cat-b1,cat-b2,cat-c
product B;;cat-a1,cat-b1,cat-b2,cat-b3
product C;;cat-a1,cat-a2,cat-a3,cat-b1,cat-b2

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?

In that case, you need to first create the categories on your website.
Once that's done, instead of using the names of the categories, use the ids of the categories (at least for the ones with the same name) and it will work.