No products are showing after Magento version upgrade (2.1.9 to 2.3.3).

[narendra_vyas]

Hi All,

I upgraded Magento version from 2.1.9 to 2.3.3.

Faced some Integrity constraints issues and resolved all of them.

After that admin worked fine.

But i am facing critical issue that products already in system are not been shown, tried creating new products and that are showing.

I am on Magento EE

With products around 2,20,000

Have checked products are enabled, added in website, are linked with category in admin
Also MSI is disabled already

I figured out that the issue is of indexing as in "catalog_category_product_index_store1" and "catalogsearch_fulltext_scope1"
there are too few entry after reindexing

The entry are in hunderds and it should have been in lakhs

Any suggestion ?

If anyone have faced same issue ?

thanks in advance

[mallikajai5922]

Run the following command :-

1.  Get Index Types Info

 php bin/magento indexer:info

From the output, you will see the code for index type Product EAV is catalog_category_product & catalogsearch_fulltext.

2. checking the status of all the index types by using this command:

 php bin/magento indexer:status

3. Reset all the indexes type

php bin/magento indexer:reset

4. Now catalog_product_attribute reindexed by using the following command:

php bin/magento indexer:reindex catalogsearch_fulltext
php bin/magento indexer:reindex catalog_category_product 

I hope it will help you Click Kudos and Accept as Solution.