Migrated products are not displaying

All the products are moved over to Magento2  but I have to manually save them to get them to appear on the site. I have tried reindexing but that doesn’t resolve the issue. Is there a DB query that could resolve this issue?

3 answers

Profile photo of ubdev Staff 71680.00 $tone 5 days ago

Hi Chris, 
Please check if the migrated root category has been assigned to the default store of your M2 default website.
Once you assign the migrated category, you need to reindex and clean the Magento cache once again.
Also please check the product quantity and stock status as well. Out of stock products will not be shown. 
Ubertheme team

Profile photo of Chris Roseanu 10.00 $tone 4 days ago

Yes I already did all the steps you had suggested. These products are in stock.
None of the products are showing up unless I manually save them. 

Profile photo of Mall Staff 153110.00 $tone 4 days ago

Hi Chris,

None of the products are showing up unless I manually save them. 

So, that is a strange issue. Please check once again and make sure you did reindex the data successfully. You can try to reindex the data by running the following CLI command:
php -dmemory_limit=-1 -f bin/magento indexer:reindex
php -f bin/magento cache:clean

If the issue still persists, then provide me information about your instance:

  • URL and admin credentials of your M2 instance
  • SSH credentials of your M2 instance
  • Let me know the path to the M2 folder

I will help to check further and get back to you then.
PS. Please mark your reply private or simply switch this ticket to the private mode, then it’s safe to share your site info here. Only you and our technical team can access it. 


Please login or Register to Submit Answer

Written By