Backend: Status filter for status in Product Catalog seems not to work

[sascha_weiss]

Hey there,

we have a issue with our magento2 store after upgrading from Magento 2.2.6 to 2.2.10.

I would describe the details here, maybee someone can help us out.

In the backend on the Page "Catalog -> Products" it seems that the Status filter is not working correctly.

So if we chose "Status: Disabled", we see all products, even the enabled ones.

Our store is in "single store mode", so i think this is a problem with this. So i checked the database, and see that in many tables with a "store_id" field, we have two store_ids after the upgrade to Magento 2.2.10.

I had an backup of the database before the upgrade, and there it was all okay, there were only entries with store_id = 0.

But now after the upgrade we have many entries with store_id=1.

Is there any good solution to fix that? Or is this really the problem?

Thanks in advice.

Greetings

Sascha

[theMageComp]

Hello @sascha_weiss 

Are you running caching and indexing commands after making product disabled?

[Rahul Gupta]

@sascha_weiss  please run the below commands.

php bin/magento setup:upgrade
php bin/magento indexer:reindex
php bin/magento cache:flush

If you stuck anywhere do let me know.

Thanks

[Meetanshi]

Hello @sascha_weiss 

If you select a store view instead of "All Store Views", you'll notice that it will be working correctly.

According to https://github.com/magento/magento2/issues/23435, "This issue is in the older version of Magento, and the fix will be available in the upcoming release.”

To fix the issue you'll need to override app/code/Magento/Catalog/Ui/DataProvider/Product/ProductCollection.php and incorporate the fix from https://github.com/magento/magento2/commit/4adee3b19c1396251d29c54df3eb874d5c985388

Reference: https://magento.stackexchange.com/questions/283868/status-filter-is-not-working-in-admin

Thanks.

[sascha_weiss]

Hey @Meetanshi ,

the store is in "single Store mode", so we do not have any option to switch the store view.

And before the upgrade of 2.2.10 all was working fine.

But i would take a look in to the fix that you have linked.

Greetings, Sascha

[sascha_weiss]

@Rahul Gupta 

i tried this, but it does not have any effect.

All index and cache are now up to date. But the same behavier as before

[louis_thomsen]

hi @sascha_weiss, I have 2 ways for you to fix it:

1. Please disable single store mode.

2. Follow the instructions of @Meetanshi, this way is right for my case.