CODEWITHSUNDEEP
prestashopprestashop-1.6
Hari Prakash
Hari Prakash

Reputation: 38

CSV Imported categories not listed in PrestaShop Catolog->Categories

I am using PrestaShop Version 1.6.1.4. I have created a CSV for Categories and uploaded it successfully but the catogories and the sub-categories are not shown in Catolog->Categories. When I configure a Module "Top Horizontal Menu" in that under Available items Categories can be seen and added to UI as well. When I click on the category in UI 404 error pages comes. Any idea how to fix this? Thanks in advance.

The below image is from Top Horizontal Menu Module where JEWELLERY is category and the other below them are sub category. Top Horizontal Menu

Thw below image shows that the categories CSV is uploaded successfdully

enter image description here

But it is not listed under Catolog->Categories refer the below image for this

enter image description here

Upvotes: 0

Views: 924

Answers (2)

Hari Prakash
Hari Prakash

Reputation: 38

First when I added categories from CSV, the categories is not getting displayed in Catalog->Categories but when I add one category manually then it is displayed in Catalog->Categories but cannot add subcategories to it.

I think there should be some issues in Presta Shop.

For example : I manually added "Testing" as one category. It was added as main category by default. Then both "Home" and "Testing" categories can be seen in Catalog ->Categories. After this I tried to add the subcategories to "Home" categories through CSV, it worked out.

PrestaShop is expecting the category to be listed in Catalog->Categories to add the subcategories to it even if that particular category is in DB. Now I can add the sub categories to what ever Main Categories needed and also the products are also getting listed under the subcategories through CSV. But I dont know why it is not getting added to Catalog->Categories initially when I add from CSV.

Now in DB ps_category table the records are as expected as you have listed.

Upvotes: 1

Indrė
Indrė

Reputation: 1136

Prestashop ps_category table.

This is the default Prestashop categories (table ps_category). Please check if you have only one row with is_root_category = 1. This must be a category ID 2 (id_category = 2), your site Home category.

And please check if all three categories ID 1, 2, 3 in your table looks the same in columns id_parent, id_shop_default, level_depth, is_root_category.

Upvotes: 0

Related Questions