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
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.
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
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.
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.
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
Actually I did check Merge Default Websites and it was still a problem.
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.
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.