excel import with parent category

Is there a way to specify the parent category in the excel import sheet ?

I have PARENT1>>PARENT2>>CAT1  AND PARENT4>>PARENT5>>CAT1

So both routes have the same category and seems nopcommerce puts the product in only one spot .
I need it in both spots and without having to change the category name .

I see that there was a fix for this (https://github.com/nopSolutions/nopCommerce/issues/2314)
but it is not specified how I indicate the parent in the excel file .

This stack overflow question may help you.

Are you telling me I have to code this in .NET ?

No , I am talking about how to do this with existing excel file and using NopCommerce Import button and that's it .
Can it be done or no ? There is supposed to be a fix ( see link i posted ) .

I had a quick look at the code at it seems that what you should have in the categories import field is:

"PARENT1>>PARENT2>>CAT1;PARENT4>>PARENT5>>CAT1"

I believe it is looking for the '>>' and ';' separators.

However, I just tested this and I'm not sure this is working correctly.

Its late here so I don't have time to look at it now but if I get chance I'll have a look at this more tomorrow (unless someone else can confirm this).

Yeah I tried that but it didn't work . NoPCommerce informed that it can't find category "PARENT1>>PARENT2>>CAT1"

My bad .

Correct format is "PARENT1 >> PARENT2 >> CAT1;" . So has to be space between the words and the arrows .
It works now .

Of course it does!! :-)

Thanks for letting me know.