All my disabled products don't show up in the product admin grid. I have no filters enabled on the view and tried re-indexing several times.

I'm on version 2.2.3

enter image description here

The screen above shows 89 products but I know if I can guess an unpublished product ID I can get to it by making the url manually.

  • Do you have multi stores/store view/websites? – Amit Bera Mar 8 '18 at 19:30
  • I do one is not in use just a demo, I have tried changing the filter for each store but the results do not change. – Daniel Harper Mar 8 '18 at 19:37
  • Can u please check grid setting at product grid.Please cross check it. Also Check customization ,may be override the grid collection – Amit Bera Mar 8 '18 at 19:41
  • @AmitBera what do you mean by customisation? a module? see screenshot above. – Daniel Harper Mar 8 '18 at 19:43

For other people with this issue (who do not want to update stuff directly in the database). I manage to fix this issue by simply forcing back the "Default View" as the user.

Image showing the location of the Default View button


We managed the same issue deleting all the records of the user where namespace="product_listing" in the table ui_bookmarks. Still no idea how to reproduce and properly fix it.

  • Thanks I'll give that a go, what is that table for? – Daniel Harper Oct 4 '18 at 17:00
  • Well that table is meant to save the configuration that users set for their grids, filters, columns, sorting, etc. However, I recently found that the problem in my case was that some products wasn't included in the prices index table, so ordering the table by price was the real cause of having less products in the result, and just sorting by another columns we ended with all the result I.e. ID. I guess this is a Magento's bug, so I'm trying to document it to create the issue report in Github. I'll paste the link here after sending the report. – Manuel García Solipa Oct 5 '18 at 17:56

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.