I have imported products using data migration tool from M1 to M2. But some products does not show on frontend. When I save the product manually it appears on frontend but after reindexing it again vanishes. I am not getting what could be the reason for the same.


Mind the changes that occur in 'cataloginventory_stock_status' table after reindexing. In my case, Reindexing added a row like - 1-0-2(product_id-website_id-stock_id) while i had already a row like 1-1-2(product_id-website_id-stock_id). So, I fired query - Delete from 'cataloginventory_stock_status' where website='0' and stock_id=2`. This worked in mine case. Make suitable changes and its going to work. Always take backup before any changes.

This is not a good solution but its all i got.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.