Catalog and search have no products

[Hawksama]

Products not visible in category/search results despite collection totalRecords in multi-store setup

Preconditions

Magento Version : 2.4.7 and 2.4.7-p4 (CE)

ElasticSuite Version : 2.11.10 but I have also installed later on in my 2.4.7 instance the ES v2.11.8.3

Environment : Developer Mode

Third party modules : Hyva (issue persists even when disabled), [List other third-party modules if any]. Minimal modules enabled during testing.

Steps to reproduce

1. Configure multi-store setup (e.g., 10 websites, 25 store views, 10 store groups)
2. Generate products using setup:performance:generate-fixtures (~2000 products)
3. Check category page or search results using ElasticSuite
4. In list.phtml, observe $productCollection->getTotalRecords() vs $productCollection->count()

I am using Mark Shust docker installation. I tested Elasticsuite connected to Elasticsearch and Opensearch - the same issue. At first, after I deploy the fixtures, they are working, but then.. the next day it's not working.

Indices:

carabus@Portable Workstation /V/W/W/M/M/H/Modules that will need to be updated> curl -X GET "http://localhost:9200/_cat/indices?v"
health status index                                                   uuid                   pri rep docs.count docs.deleted store.size pri.store.size
green  open   magento2_store_view_5_thesaurus_20250215_003851         -8e2TqxYTean92AaxzqEQw   1   0          0            0       208b           208b
green  open   magento2_store_view_20_catalog_product_20250215_003543  vzW7rb-ETPqNTwqsOU-McA   1   0      24787            0     65.7mb         65.7mb
green  open   magento2_store_view_10_catalog_product_20250215_003023  -ifrxtoZSkiTTTLEk6BV2w   1   0      24787            0     67.1mb         67.1mb
yellow open   magento2_product_4_v2                                   jDmn8-rBQhaOpwf9gNC0Wg   1   1       2879            0     11.2mb         11.2mb
green  open   magento2_default_catalog_product_20250215_002546        FVcR6u-RTjO_Iec_pfHeOw   1   0      24787            0       66mb           66mb
yellow open   magento2_product_12_v2                                  dTb-8VW2RH2ZbeO_xgyFaQ   1   1       2879            0     11.3mb         11.3mb
green  open   magento2_store_view_22_thesaurus_20250215_003852        GZZ3C4JXTl-HZRMjPygOfQ   1   0          0            0       208b           208b
green  open   magento2_store_view_12_catalog_product_20250215_003124  20WPdkx5TEquxF5h9CZaHg   1   0      24787            0     66.6mb         66.6mb
green  open   magento2_store_view_22_catalog_product_20250215_003644  iodGtilHR1Kh8J5kq5_LWA   1   0      24787            0     65.7mb         65.7mb
green  open   magento2_store_view_3_thesaurus_20250215_003851         c_zzRKxHQsSNjLSBZQJoQQ   1   0          0            0       208b           208b
green  open   magento2_store_view_17_catalog_product_20250215_003402  vy_4f-F4RYyex6sJpRzNBw   1   0      24787            0     66.9mb         66.9mb
green  open   magento2_store_view_20_catalog_category_20250215_003850 KkKaCQNGTQynbaYeojKUrQ   1   0        100            0    119.9kb        119.9kb
green  open   magento2_store_view_13_catalog_category_20250215_003849 mptzqpFQRzSg6ibHD0GTrg   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_22_catalog_category_20250215_003850 YP-AmwMlT0u1IwhhOu8vqg   1   0        100            0    119.9kb        119.9kb
green  open   magento2_store_view_8_catalog_product_20250215_002923   wGRK700TRAGewMxrcJ9rlg   1   0      24787            0     67.1mb         67.1mb
green  open   magento2_store_view_11_catalog_category_20250215_003848 CY0fhx-KQNOXK9wMidy24A   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_17_catalog_category_20250215_003849 gwmX3Yg4Tru2EL_MwcTrEA   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_24_catalog_category_20250215_003851 M76A2ZeVSCOAPjRsbW1YeA   1   0        100            0    119.9kb        119.9kb
green  open   magento2_store_view_15_catalog_category_20250215_003849 0HU9-r9XQ-qfwsrqMaKXJA   1   0        100            0    119.8kb        119.8kb
yellow open   magento2_product_17_v2                                  i4gCD7K9SZKMpa97hYFahA   1   1       2879            0     10.2mb         10.2mb
yellow open   magento2_product_7_v2                                   Fedx2dslQ1m9BKf2iUjT8w   1   1       2879            0     11.1mb         11.1mb
green  open   magento2_store_view_13_thesaurus_20250215_003852        Hi3GhQP1RfOWDVqY0B28Ow   1   0          0            0       208b           208b
green  open   magento2_store_view_19_catalog_category_20250215_003850 0cWjGXmsR9iZ8sg1qE864g   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_19_catalog_product_20250215_003512  ftBO2xkESkS45DTLRczvMQ   1   0      24787            0     67.1mb         67.1mb
green  open   magento2_store_view_6_catalog_product_20250215_002822   1fS7HRcSSd62ZjsIcOPOZA   1   0      24787            0     67.1mb         67.1mb
green  open   magento2_store_view_9_catalog_category_20250215_003848  u2yHAf4oQ6KN75JFVq-ETA   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_5_catalog_category_20250215_003847  F0SnZ13USmq8vB4GLAYqRw   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_6_catalog_category_20250215_003847  MeJZ6CdwSdKgsD0bUTNm0A   1   0        100            0    119.8kb        119.8kb
yellow open   magento2_product_18_v2                                  VL3wJi7kQRa2nK7vKvd2Fw   1   1       2879            0     11.6mb         11.6mb
green  open   magento2_store_view_2_catalog_category_20250215_003846  _DzeTk3wRE6wjwVpZciPdA   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_16_catalog_product_20250215_003329  jz_OrDqdShmfRFJuvwOgww   1   0      24787            0     66.9mb         66.9mb
yellow open   magento2_product_2_v2                                   _t-6wkxsT76q14pG7QVkwg   1   1       2879            0     11.1mb         11.1mb
yellow open   magento2_product_10_v2                                  3ePbOzkVQRWWcp80mQ_4Bg   1   1       2879            0     11.1mb         11.1mb
green  open   magento2_store_view_2_thesaurus_20250215_003851         BpUAqYdYTUqDUWc-RCJk6g   1   0          0            0       208b           208b
green  open   magento2_store_view_20_thesaurus_20250215_003852        180TbVuNSvOTuEmmOvQSLw   1   0          0            0       208b           208b
green  open   magento2_store_view_25_catalog_product_20250215_003814  9ahBq_oxTmmykWeLNuT__g   1   0      24787            0     66.4mb         66.4mb
green  open   magento2_store_view_10_thesaurus_20250215_003852        yGU499aLQfWK6sp_vqbdNw   1   0          0            0       208b           208b
green  open   magento2_store_view_12_catalog_category_20250215_003848 sIM4puB4TyO38mS6jociIQ   1   0        100            0    119.5kb        119.5kb
green  open   magento2_store_view_16_catalog_category_20250215_003849 U2_Iyzv5SAKUKuAcjN-X9w   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_23_catalog_category_20250215_003850 00XZM3oeT6GoKFFq8waVRA   1   0        100            0    119.9kb        119.9kb
yellow open   magento2_product_15_v2                                  ZIj-h2p8SV-DAaWyJifuYw   1   1       2879            0     11.2mb         11.2mb
green  open   magento2_store_view_3_catalog_product_20250215_002650   SFk9-nQeS-uvWTGJqjTlPg   1   0      24787            0     67.1mb         67.1mb
yellow open   magento2_product_5_v2                                   C-Eod3boTZKyqOcpnZhsXQ   1   1       2879            0     11.2mb         11.2mb
green  open   magento2_store_view_11_thesaurus_20250215_003852        1KxVgM_bR3KmBs_L6UfjTg   1   0          0            0       208b           208b
yellow open   magento2_product_21_v1                                  gN6pk5ujTGK5d6Lr7jE04A   1   1          0            0       208b           208b
green  open   magento2_store_view_7_catalog_product_20250215_002851   dqcq7MSeRlKDlYc4dDUfyQ   1   0      24787            0     67.3mb         67.3mb
yellow open   magento2_product_21_v2                                  qxup_mheTpGCz-qQXKqIlQ   1   1       2000            0      6.7mb          6.7mb
green  open   magento2_store_view_12_thesaurus_20250215_003852        6Z1ne4-6QYKJm1QyWsgUZA   1   0          0            0       208b           208b
yellow open   magento2_product_8_v2                                   hrtirG3HSQqMTc9781eucA   1   1       2879            0     11.1mb         11.1mb
green  open   magento2_store_view_18_catalog_product_20250215_003440  Qi2H8LV8T2KoZqB4ugcPIw   1   0      24787            0     66.9mb         66.9mb
green  open   magento2_store_view_11_catalog_product_20250215_003052  wmWUPREJQL69h1E_gM7fuQ   1   0      24787            0     65.9mb         65.9mb
green  open   magento2_store_view_21_catalog_product_20250215_003613  67LstUZ_SDaN7amxpr9YUw   1   0      24787            0     65.7mb         65.7mb
yellow open   magento2_product_16_v2                                  ENm23BTySDKEx9OLZqv_gA   1   1       2879            0     11.1mb         11.1mb
green  open   magento2_default_thesaurus_20250215_003851              tP39rvjAR7OTPT2NdfqUnQ   1   0          0            0       208b           208b
green  open   magento2_store_view_4_thesaurus_20250215_003851         O50v_KmORee3vollQg0YAA   1   0          0            0       208b           208b
green  open   magento2_store_view_19_thesaurus_20250215_003852        tvIV08zeQi-VgdjjLRmrAA   1   0          0            0       208b           208b
yellow open   magento2_product_19_v2                                  PJ3vTFfjQLm_XPWqpxvnnQ   1   1       2879            0     11.2mb         11.2mb
green  open   magento2_store_view_9_catalog_product_20250215_002952   VaPCuF8QRt6TjTvwjnqQsQ   1   0      24787            0     67.1mb         67.1mb
green  open   magento2_store_view_23_thesaurus_20250215_003852        Rch3L-SjRh-3gsDk2bylxg   1   0          0            0       208b           208b
green  open   magento2_store_view_13_catalog_product_20250215_003155  w2ajl4qvTJyWEbphoJmweg   1   0      24787            0     67.1mb         67.1mb
green  open   magento2_store_view_14_thesaurus_20250215_003852        w15lF8muQRqwckcD5AG-vQ   1   0          0            0       208b           208b
green  open   magento2_store_view_21_thesaurus_20250215_003852        M3OAhka6QR6PL082N4s_Qg   1   0          0            0       208b           208b
green  open   magento2_store_view_2_catalog_product_20250215_002620   K30yqal-Thuad21DccpA8A   1   0      24787            0     67.1mb         67.1mb
yellow open   magento2_product_13_v2                                  K08wo_NCR8OQtDbTFnKJgg   1   1       2879            0     11.2mb         11.2mb
yellow open   magento2_product_3_v2                                   BPKQnIHjTNa4xippK7SyQw   1   1       2879            0     11.1mb         11.1mb
green  open   magento2_store_view_9_thesaurus_20250215_003852         gsKY-QSyRLuD4nT8sX2PUg   1   0          0            0       208b           208b
green  open   magento2_store_view_16_thesaurus_20250215_003852        _5Vr4UFbQLu80jJ0wPza2g   1   0          0            0       208b           208b
green  open   magento2_store_view_5_catalog_product_20250215_002751   enaLndywR6u-RiMX5pUVRw   1   0      24787            0     67.1mb         67.1mb
green  open   magento2_store_view_7_catalog_category_20250215_003847  amKVBihaSQSdlOwNH1d0qg   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_8_catalog_category_20250215_003848  8J9oWa1GToOtlB_bU3qrpg   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_4_catalog_category_20250215_003847  tOfV3uy8QR6E5W8kF-Y0oQ   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_4_catalog_product_20250215_002720   GnXHakopSDe2H5mpN21aGQ   1   0      24787            0     67.1mb         67.1mb
green  open   magento2_store_view_3_catalog_category_20250215_003847  Mlj4CZeZSEqlEMKqAvWU3Q   1   0        100            0    119.8kb        119.8kb
yellow open   magento2_product_14_v2                                  CJlgMYWzRKqzHTOZQJTKfQ   1   1       2879            0     11.2mb         11.2mb
yellow open   magento2_product_6_v2                                   p-C8qGVqSIayg9SMmv8o_g   1   1       2879            0     11.2mb         11.2mb
green  open   magento2_store_view_15_thesaurus_20250215_003852        U67gxtXNR1Cjs2ee7m1wyA   1   0          0            0       208b           208b
green  open   magento2_store_view_8_thesaurus_20250215_003851         TBbLrr5zR8CPX8O7DZzz2Q   1   0          0            0       208b           208b
green  open   magento2_store_view_15_catalog_product_20250215_003257  ds6Y__KCTxGOjVju7QWoKA   1   0      24787            0     66.5mb         66.5mb
green  open   magento2_store_view_24_catalog_product_20250215_003744  znOixtjBQUS-uaNJfL-mSA   1   0      24787            0     65.7mb         65.7mb
yellow open   magento2_product_20_v2                                  jp1oEWn2TLOOhOx1Z9WDVA   1   1       2879            0     11.2mb         11.2mb
green  open   magento2_store_view_14_catalog_product_20250215_003225  cGEL-wfoTROQY0EywWx0nw   1   0      24787            0     66.5mb         66.5mb
green  open   magento2_store_view_18_thesaurus_20250215_003852        p8ViSJ2vQDGIvURK5EjbRw   1   0          0            0       208b           208b
green  open   magento2_store_view_10_catalog_category_20250215_003848 G6mCEIw_REe0GUico174ZQ   1   0        100            0    119.8kb        119.8kb
yellow open   magento2_product_11_v2                                  nRa_Xj6vTZmWYa2Tpd7t7w   1   1       2879            0     11.5mb         11.5mb
yellow open   magento2_product_9_v2                                   9ln_wbdSQHywet8bx2HcFg   1   1       2879            0     11.1mb         11.1mb
green  open   magento2_store_view_7_thesaurus_20250215_003851         LTvAd9BpR_eXuqVwlnDacg   1   0          0            0       208b           208b
green  open   magento2_store_view_25_thesaurus_20250215_003853        PeNqWSQkQK-193gQd12B8w   1   0          0            0       208b           208b
green  open   magento2_store_view_21_catalog_category_20250215_003850 pLOtSUjuQL6-jsZazG-omA   1   0        100            0    119.9kb        119.9kb
green  open   magento2_store_view_25_catalog_category_20250215_003851 HfqBVsk-TROA71QW9sj-Rw   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_14_catalog_category_20250215_003849 cX9ET_byTOuyHO9vDFW9Vg   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_23_catalog_product_20250215_003714  _fDYdLUVTMCidnkttuHk9w   1   0      24787            0     65.7mb         65.7mb
yellow open   magento2_product_1_v2                                   lLqckoJxTf6VgSe0qCi2Xw   1   1       2879            0      9.8mb          9.8mb
green  open   magento2_store_view_17_thesaurus_20250215_003852        tYJAQWT5R3CqWtFTQg12JQ   1   0          0            0       208b           208b
green  open   magento2_store_view_18_catalog_category_20250215_003850 7gdowdCUS_2CjAVWXWIQiA   1   0        100            0    119.8kb        119.8kb
green  open   magento2_store_view_24_thesaurus_20250215_003853        SWgctpztTY2Zjb1WoeTPoA   1   0          0            0       208b           208b
green  open   magento2_store_view_6_thesaurus_20250215_003851         WkAHqkneSqSm6fmlquHRPg   1   0          0            0       208b           208b
green  open   magento2_default_catalog_category_20250215_003846       AIfiozWIQIGkzTnSM8k6Tg   1   0        100            0    119.9kb        119.9kb

bin/magento indexer:reindex:

[Hawksama]

I have tried #3391 but it does not happen to me. I get no errors in my logs. Everything seems to "work", but still get no products in search and category pages.

[romainruaud]

Can you check if the categories created by generate:fixtures are created with is_anchor=1 ?

Best regards

[romainruaud]

I am using Mark Shust docker installation. I tested Elasticsuite connected to Elasticsearch and Opensearch - the same issue. At first, after I deploy the fixtures, they are working, but then.. the next day it's not working.

https://github.com/markshust/docker-magento/blob/release/next/compose/compose.yaml#L145

This one ? There is no volume for Opensearch, which means it will get destroyed when you close the stack

[Hawksama]

Hi @romainruaud, thanks for your quick response. I verified that the generated fixtures are created with is_anchor enabled. However, after rebuilding the project on Sunday using sampledata:deploy, the issue with missing products reoccurred. I am indeed using that compose.yaml file.

Today, I also set up a volume for Elasticsearch in Docker to prevent it from being destroyed, as you suggested, but it still isn’t working. After implementing that change and running a reindex, I’m once again left without products – something seems to be off.

[Hawksama]

The fix in #3522 by limiting the Opensearch version is working for me! ElasticSuite connected to ES.

[romainruaud]

ah cool you were also affected by this issue in the end !

Perfect if this is resolved, I'm closing the issue.

regards

[Hawksama]

Regards! Thank you so much!