I have a
Magento 2.2.2 build, I imported my products, categories and orders from a
Magento 1.6.2 (don't blame me, I just got this) build using cart2cart
Everything looks to be fine, until I tried to add a new product sub-category
The new category shows fine, but all the old categories (only sub-categories under main category) disappeared.
the categories do show on the front end navbar
the categories do show on the back end product edit page, where you select what category the product belongs to
the categories do not show on the category edit page, in the category tree.
I have tried refreshing cache, reindexing and relogging my user, I have given it a day and Googled the problem... I have found nothing close to this, and am at a loss on where to look next.
I assume it would be something I may need to toggle in the database, though with the categories showing on the product edit page I am not sure what, but I do not know where to begin looking for that, and do not want to mess with the database without knowing all the interactions
- I cannot delete the offending categories, because I can't access them on the edit page
- I cannot recreate the categories, because it would not allow me to keep the url key that my existing site uses, meaning a hit on ranking, I am sure, among other things like anyone who links to a product would get affected, also the old categories would still show on the menu (cant remove without access) and on product creation, causing problems and confusion there
I have found somewhat of a workaround for this.
I find the ID of the category in the database (
catalog_category_entity_varchar.entity_id) searching by the name, getting the id, and then I replace the id in the admin url
- go to manage categories
- click on any category
- replace the id in the url with the id of the item
- make your change
that change will stick, but the item may (or may not) disappear again.. it seems to stick better if you change its parent category