Import Categories to SQL category table

Hi, I am using NopCommerce 2.3 and I imported categories from Excel spreadsheet into the SQL category table with all category ID and sub category ID mapped out. The data import was successfully and I do see all my categories in the database table. However, those categories imported didn't show on Category list nor on the website. Please help.

Thank you very much.

Hi,

Is it because you didn't make it as published?

Edit the category at the bottom of the page:
http://admin-demo.nopcommerce.com/Admin/Category/Edit/29

Thank you for your reply Sir. The categories data were added in the Category table but they are not showing up on the Website nor on the Categories list. And when I added them to the database, they were all marked as published.

autoparts wrote:
Make sure they are not marked as deleted

Thank you. I double checked the "Deleted" column, the item which in Parent Category was set to "True". After change that to "False", I see all the sub categories now. Thank you very much again.

Hello Auto Parts,

Could you please share excel sheet format for Import Categories.

I have same scenario, and want to upload categories in bulk.

Waiting for your response.

Thanks.