0

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

enter image description here

but when i go to product edit page

not showing that categories

enter image description here

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

Your Answer

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

Browse other questions tagged or ask your own question.