Category import not working?

when I export categories, delete all existing categories I am unable to get those multiple "Others" child categories. How can I work a bulk import/export in such cases?
What version of nopCommerce ?

When you export the categories each of the "Others" categories should have a unique Id in the ParentCategoryId column

Then when you import the "Others" categories the should then associate with each of the existing categories with a CategoryId equal to the ParentCategoryId in the import file

In Catalog Settings, is this field selected or not:
   Export/Import categories using name of category

Please clarify " delete all existing categories".  Are you actually deleting all the categories and expecting that the category import will recreate the entire category tree (hierarchy)?

Hi Sergie,

I am trying to import a category list that has something like, "Others" sub category under multiple parent categories. I could create it on the application.

But when I export categories, delete all existing categories I am unable to get those multiple "others" child categories.

How can I work a bulk import/export in such cases?

Hi. Please check that you have the catalog settings.exportimportproductcategorybreadcrumb setting enabled, it should allow loading the same subcategories in different categories


Hi Sergie,

I am trying to import a category list that has something like, "Others" sub category under multiple parent categories. I could create it on the application.

But when I export categories, delete all existing categories I am unable to get those multiple "others" child categories.

How can I work a bulk import/export in such cases?

Category Import normally works fine
Do you have Id's in the first column in the Execl file - if so remove them
If you have categories with parents you may need to import the categories without parents first
Then export all categories and add the new categories and set the ParentCategoryId as required
You can export a standard Category file from the demo to check you have the correct format
See https://admin-demo.nopcommerce.com/Admin/Category/List

Regards importing Orders I have a Plugin that will import orders
See https://www.selectsystems.com.au/import-export-manager

I have enabled it in my catalog settings.

But yet it does not let me upload categories when there's a scenario like this

Category A Subcategory Others
B under Category B Subcategory Others.

It throws the error:


PS - The file I tried to import is here:
https://cctsplo365-my.sharepoint.com/:x:/g/personal/vignesh_ck_cctsglobal_com/EXy0-cipH4VKvIY5FPps67IBWp9XiaUFXjtIfHc88ZMj9w?e=VBL2k6