Currently I am on Magento 2.4.2 which was upgraded from 2.3.0. The issue which I am facing right now is that I am not able to see any products displayed on category page.

After debugging the below file:


and below function in the above path:

public function getCollection(\Magento\Catalog\Model\Category $category)

I found the collection query which is as below:

SELECT `e`.* FROM `catalog_product_entity` AS `e` WHERE (NULL)

I guess WHERE(NULL) condition might be the culprit here.

Any idea why am I getting this WHERE(NULL) condition and any suggestions to resolve this

  • there could be several reasons for product not getting displayed 1st one and most common is reindexing also make sure that your elasticsearch configuration are coorect and working? please confirm
    – Pramod
    Jun 18 at 10:45
  • Yes have indexed too and elastic search configuration are correct as well.. but cant get rid of products not displaying
    – Nisith
    Jun 18 at 10:54
  • @Nisith check is there any third party extension which may affect the sql query. Try disabling third party extensions. Jun 18 at 11:46

Your Answer

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

Browse other questions tagged or ask your own question.