I have a store in magento c.e 1.8 i have created categories but the category tree is not not showing up on product edit section.

I can see the categories in Manage Categories section.

Please help if someone know about this problem.

  • Any errors in the console? Check the response of the ajax request made when you click on the "Categories" tab. – Marius Mar 20 '14 at 11:45
  • might be a cache issue, have you flushed the cache – pzirkind Mar 20 '14 at 16:18

This Fix the issue (for me):

UPDATE catalog_category_entity SET children_count = (SELECT COUNT(*) FROM (SELECT * FROM catalog_category_entity) AS table2 WHERE path LIKE CONCAT(catalog_category_entity.path,"/%"));

Make a backup before execute the query.


I'm facing the very same problem checking the database we have the level category's attribute with a wrong value.

I solved running the query founds on this link

Solving problems with Category tree database information

hope this helps other

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.