Import of categories tree

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4.1
-- PHP version -- : 5.4.16
-- Browser(s) name and version -- : Chrome 41.0.2272.118 m

Hi, I have problems importing a category tree. the documentation does not answer my questions, so I post it here.
Ist is possible to import the categories tree separately from the product import, or do I have to do the import of categories and products in 1 step?
I have here a sample csv:
parent_category;categories;categories_namekey
1;100;cat1Level1
100;101;cat1Level2
100;102;cat2Level2
101;103;cat1Level3
101;104;cat2Level3
102;105;cat3Level3

it creates sub-categories (on level 2) with the ids as their names. Where is the problem?

Hi Nicolas
I am having similar problems to this. and I am not an expert with csv! So I have a tree like this
Product category
>GS&S
>FG
>EFG

So this is a category (GS&S) which has a sub category (FG) which also has another Sub, category within it.
I have tried exporting the CSV from my categories I have set up including category_depth?
How is this actually presented in the excle spread sheet. Sorry if I am asking the same question but I am struggling to equate the answers to an actual spread sheet. What are the headers for the columns?
Many thanks for your help in advance

Thats great thanks, I hadn'tappreciated that the new parent_category would be the immediate one above the category I require.
So I have around 8000 products and many multiple level categories. Can I import them all at the same time or should I set up the categories first as the products will be placed in the CSV along with their category; in the product catalogue serial number order.

Export is a great idea. I will do that.
Thanks,
Regards,
Bernhard

nicolas wrote: Hi,

The best is to do like the CSV you get when you click on the "export" button of the products listing:
First the categories tree is defined at the top of the CSV and then you get the products with the name of their category below.