Category import csv

[spidawebs]

@alwayspaws You need to enter the category ID of the parent category in Entity ID. So go into Catalog > Categories to find the ID of the parent section. That's all you need to do (assuming your categories imported correctly and you have main categories with sub categories within them).

[alwayspaws]

I thought "home" was the parent. I don't see a number for it.

I have categories and subcategories because I can view them in admin: Example: Home / Grooming CATEGORIES: GROOMING subcategories: hair bows, bowties, etc.

[Havouza]

@alwayspaws Home is id 2

[alwayspaws]

@Havouza Thank you!

[alwayspaws]

I don't know what to enter in the other fields.

[alwayspaws]

I'm burned out.

[alwayspaws]

@spidawebs said in Category import csv:

@alwayspaws You need to enter the category ID of the parent category in Entity ID. So go into Catalog > Categories to find the ID of the parent section. That's all you need to do (assuming your categories imported correctly and you have main categories with sub categories within them).

This makes sense when I read it but when I go to the form, I don't know which is the parent section.

[spidawebs]

It sounds like you imported all your categories under home.

I personally separate my categories as follows

Home - Main Category -sub category -sub category -sub category - Main Category -sub category -sub category

So I might have 5 main categories and all related categories under each one of those. Then on the menu, the headings are the main categories and when you click on them it drops down to all the sub categories

[Havouza]

I have 7 parents under Home but 134 categories in all with the subs. I have 3 levels as most

[alwayspaws]

@spidawebs @Havouza

The column that says Root Category (0/1) - could that be the problem here?

[spidawebs]

Yes, it looks like you have the Parent and sub categories setup correctly. The Root may need to be 1 but I'm not 100% sure.

[Havouza]

No it should be 0

[spidawebs]

I think maybe your main Parent Categories need to have 1 for the Root. So:

Dog Clothes Grooming Dog Lovers Jewelry

etc

[Havouza]

NONO. The Root is the root and if they are set to one there will be many roots like for a multishop setup

[spidawebs]

@Havouza Oh OK. I don't know what else the problem could be then

[alwayspaws]

@spidawebs @Havouza Does anyone else have this problem?

I hope someone can figure it out!

[Havouza]

When I upload categories in PS I leave the Cell where it say Home as parent empty but thats me

[alwayspaws]

I'm in a big quandary.

[spidawebs]

Why are the sub categories not going under the parent category then? Should it be "Home;Dog Clothes" rather than just "Dog Clothes"?

[alwayspaws]

@spidawebs said in Category import csv:

Why are the sub categories not going under the parent category then? Should it be "Home;Dog Clothes" rather than just "Dog Clothes"?

I don't know and that's what the problem is.

[spidawebs]

On your test site it seems to be working exactly like that though?

You have Dog Lovers Jewelry as the main heading and then the sub categories drop down underneath it????

[Havouza]

My csv for cat import look like this. But not tested in TB only in PS

[alwayspaws]

@spidawebs said in Category import csv:

On your test site it seems to be working exactly like that though?

You have Dog Lovers Jewelry as the main heading and then the sub categories drop down underneath it????

Partly getting somewhere now.

[alwayspaws]

@spidawebs said in Category import csv:

Why are the sub categories not going under the parent category then? Should it be "Home;Dog Clothes" rather than just "Dog Clothe

Yes, it should be home, Dog Clothes and the related Dog clothes subcategories. Don't know why it's displaying the way it is but it doesn't display at all on my TB site.

[alwayspaws]

@Havouza said in Category import csv:

My csv for cat import look like this. But not tested in TB only in PS

@Havouza I'm going to look into this once I get back on the desktop. Thank you!