search

magento / data-migration-tool

Magento Data Migration Tool
https://devdocs.magento.com/guides/v2.3/migration/bk-migration-guide.html
Open Software License 3.0
338 stars 199 forks source link

Why is cataloginventory_stock table ignored by default? #141

Closed milanstojanov closed 8 years ago

milanstojanov commented 8 years ago

Hello,

I've just finished a DB migration from 1.7.0.2 -> 2.1.0. Beside some standard things that required a manual resolution, everything went well.

However, none of my products are displayed on the frontend, which is caused by unknown stock (and reindex doesn't help). For some reason, in this commit https://github.com/magento/data-migration-tool/commit/c3abf85e3bc42adbe71b7b512aaabe0c7fe48164#diff-ba942c6a50b9e377cb7ae2f8162ebb27 cataloginventory_stock_status table is ignored, which I can't understand why.

Unless I am terribly missing something, stock tables should not be ignored. I would really like to hear thoughts on this.

Thanks, Milan

milanstojanov commented 8 years ago

All right, as it always goes - the solution clicks as soon as you post the question. :)

For some reason, website_id column in cataloginventory_stock table was 0, and it should have been 1 in my case. That's why Stock index didn't do anything.

Hopefully, this will help someone. I will close the issue.