0

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

Thanks.

  • Your above image showing click reset filter link and after check – Mohit Patel Apr 16 at 16:02
  • I did try. Reset filter just removes the category filter, after which, all products show. – mattf10 Apr 17 at 9:59
  • i don't understand your comment .Please explain me – Mohit Patel Apr 17 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 at 12:00
0

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.

| improve this answer | |

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.