cancel
Showing results for 
Search instead for 
Did you mean: 

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

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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

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
1 REPLY 1

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

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.