I deleted all the products and categories via
SQL queries (i used this answer https://magento.stackexchange.com/a/283404/73525 )
after i have recreated all
i have categories in the categories page admin panel
but when i go to product edit page
not showing that categories
i tried this one but no working
UPDATE catalog_category_entity SET level = (SELECT LENGTH(path)-LENGTH(REPLACE(path,'/','')) AS tmpl FROM (SELECT * FROM catalog_category_entity) AS table1 WHERE catalog_category_entity.entity_id = table1.entity_id); 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,"/%"));
how I can fix this issue