Search code examples
prestashopprestashop-1.6

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

Solution

  • 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.