Magento 2 category structure is displayed wrong

Question

For some reason my category structure on the frontend and admin panel show different results. Check image below:

On the frontend my category "DATORER" have 4 subcategories but in the admin panel I only have 2 active subcategories.

I'm importing the products and category structure from a system called IcePim and one thing to be noted is that the frontend are displaying the correct category structure I've set up in IcePim while it's being displayed wrong from the Admin panel.

Is there something I have missed to why they show different results?

I have run tried

• rm -rf var/di var/generation
• php bin/magento cache:flush
• php bin/magento setup:upgrade
• php bin/magento setup:di:compile
• php bin/magento indexer:reindex
• optimze database

Frontend

Admin panel

Answer 1

I believe it's a matter of value scoping. What I think happens is that during your data import, the values are set on the store view level, but when you enter the admin you don't see that directly from the start as you are initially browsing the Scope: All Store Views which is the default store (different than the store view that holds your data).

If you change the scope to be the store view (from the upper left corner of your category admin page), you should now see your category as enabled.

Please check and let me know if you need more details.

---

LE: we need to identify the values stored in your db:

let's retrieve the values stored on the category for the status attribute (replace <category_id> with the ID of your category of interest):

COMMERCE

select * from catalog_category_entity_int where row_id in (select row_id from catalog_category_entity where entity_id = <category_id>) and attribute_id in (select attribute_id from eav_attribute where attribute_code='is_active' and entity_type_id='3');

OPEN SOURCE

select * from catalog_category_entity_int where entity_id = <category_id> and attribute_id in (select attribute_id from eav_attribute where attribute_code='is_active' and entity_type_id='3');