'Magento 2.4.3 - Products are not showing in the catalog page after we import a database from Magento 2.3 site

we have a fresh build of Magento 2.4.3 which when we sync products from an api call works fine and the products display correctly but we want to import the database and products from an existing Magento 2.3.4 site. When we import the database the products are not showing on the catalog pages. The products are shown in the backend in the products listing and also under the categories tree and in products in category in the category page. Going directly to the products url key displays the product and show the breadcrumb for it's categories but none of the catalog listings show any products. The search pages return no results as well

we have checked the setting for elastic search in the core_config_data table and they seem correct and we have tried reindexing but the products still don't show. Any one any ideas as we are at a loss at what to try now.



Solution 1:[1]

You can check for errors in var/log. If you share specific errors in these files, the problem will be easier to solve.

Solution 2:[2]

I had the same problem. Magento falls back to use ES6 but your version needs ES7.

php bin/magento config:set  catalog/search/engine  elasticsearch7
php bin/magento cache:clean config
php bin/magento indexer:reindex

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 LitCommerce Expert
Solution 2 Militaru