Not all products show under "Products in Category" when editing a category in the back-end.

Here is a screenshot showing the problem. In the category tree, it correctly shows 123 products in 'Commercial' category. But under the products section, only 9 appear (see bottom right).

Product tree / visible products count mismatch

Other categories are fine and show the same number of products in the tree and in the products list.

I've run the reindexer from the command line and this didn't help. For info, both 'Use Flat Catalog Category' and 'Use Flat Catalog Product' are set to Yes.

Magento version 2.3.4

PHP 7.3.16

Mysql Ver 15.1 Distrib 10.1.44-MariaDB


  • Your above image showing click reset filter link and after check Apr 16, 2020 at 16:02
  • I did try. Reset filter just removes the category filter, after which, all products show.
    – mattf10
    Apr 17, 2020 at 9:59
  • i don't understand your comment .Please explain me Apr 17, 2020 at 11:47
  • You're saying I should click the "Reset Filter" link. I did that and afterwards, all products in the store show. In other words, clicking the link just removes the filter for the category.
    – mattf10
    Apr 17, 2020 at 12:00

1 Answer 1


I found this similar question which points towards an answer: Magento 2 : Admin category products getting wrong count

Confusingly, the tree shows the products in the category, plus in all its subcategories (if Anchor is set to Yes in the Display Settings section). However, the Products in Category section only shows products in that particular category, and does not include child categories.

So the above image is actually correct since there are only 9 products in the Commercial category itself, with the rest in sub-categories.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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