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?

9 answers

Profile photo of Chris Roseanu 70.00 $tone October 28, 2020
Public

I finally figured out the problem.  I noticed that when I reindexed the site I was getting 
 Product Price index exception: No linked stock found
This was due to website inventory not being associated with Stocks.
I had to go to Stores -> Inventory -> Stocks and edit the Default Stock and assign it to all websites. Once I saved and reindexed again and cleared the cache all my products showed up.
This would be good to add to your Required Steps To Complete Migration Process.

#
Profile photo of ubdev Staff 98030.00 $tone October 18, 2020
Public

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. 
 
Regards,
Ubertheme team

#1
Profile photo of Mall Staff 184060.00 $tone October 19, 2020
Public

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. 
Regard,
Mall.

#3
Profile photo of ubdev Staff 98030.00 $tone October 28, 2020
Public

Hi Chris, 

Product Price index exception: No linked stock found
This was due to website inventory not being associated with Stocks.
I had to go to Stores -> Inventory -> Stocks and edit the Default Stock and assign it to all websites. Once I saved and reindexed again and cleared the cache all my products showed up.

Please continue with the process at your end. Actually, that issue occurred because you didn’t check the ‘Merge Default Websites’ setting. And that relates to Magento’s Stocks management when you have multiple frontend websites in M2.
Regards,
Ubertheme team

#4
Profile photo of Mall Staff 184060.00 $tone October 28, 2020
Public

Hi Chris,

Actually I did check Merge Default Websites and it was still a problem.

So, that was because your M1 had multiple websites. For other websites (not the default website) after being migrated to M2, these websites need to assign the ‘Default Stock’ in M2 too.

Regards,
Mall.

#6
Profile photo of Chris Roseanu 70.00 $tone October 28, 2020
Public

Yes and you didn’t suggest that fix! I had to figure it out on my own. That is why I am suggesting that you add it to your documentation, so users don’t have to bother you.

#7
Profile photo of ubdev Staff 98030.00 $tone October 29, 2020
Public

Hi Chris, 
Thanks for your suggestion. 
We have updated the common FAQ section here regarding this circumstance. This FAQ (part 3) is also included in the Readme manual that comes packed with UB Data Migration Pro package. 
We hope that helps. 
Regards,
Ubertheme team
 

#8

Please login or Register to Submit Answer

Written By

Comments