After Migrate Data from Magento 1, Products are not showing in category and search result

[eliacimd]

Hi. 

Recently, I installed a clean Magento CE 2.1.6 and just execute a Data Migration from CE 1.7.0.0 to CE 2.1.6, using the module magento/data-migration-tool. After adding multiple custom tables and fields to map.xml, the command execute:

php bin/magento migrate:data /var/inetpub/test.com/vendor/magento/data-migration-tool/etc/ce-to-ce/1.7.0.2/config.xml

And after some time, the console return me a  Migration completed message.

[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: Data Integrity Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: EAV Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: Map Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: Url Rewrite Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: Log Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: Ratings Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: ConfigurablePrices step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: OrderGrids Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: Tier Price Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: integrity check][step: SalesIncrement Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: setup triggers][step: Stage]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: data migration][step: EAV Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: volume check][step: EAV Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: data migration][step: Customer Attributes Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: volume check][step: Customer Attributes Step]: started
[2017-05-24 21:42:30][INFO][mode: data][stage: data migration][step: Map Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:43:19][INFO][mode: data][stage: volume check][step: Map Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:43:21][INFO][mode: data][stage: data migration][step: Url Rewrite Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:47:02][INFO][mode: data][stage: volume check][step: Url Rewrite Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:47:03][INFO][mode: data][stage: data migration][step: Log Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:59:41][INFO][mode: data][stage: volume check][step: Log Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:59:43][INFO][mode: data][stage: data migration][step: Ratings Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:59:43][INFO][mode: data][stage: volume check][step: Ratings Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:59:43][INFO][mode: data][stage: data migration][step: ConfigurablePrices step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:59:43][INFO][mode: data][stage: volume check][step: ConfigurablePrices step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:59:43][INFO][mode: data][stage: data migration][step: OrderGrids Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:59:44][INFO][mode: data][stage: volume check][step: OrderGrids Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 21:59:44][INFO][mode: data][stage: data migration][step: Tier Price Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 22:00:09][INFO][mode: data][stage: volume check][step: Tier Price Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 22:00:11][INFO][mode: data][stage: data migration][step: SalesIncrement Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 22:00:11][INFO][mode: data][stage: volume check][step: SalesIncrement Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 22:00:11][INFO][mode: data][stage: data migration][step: PostProcessing Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-24 22:00:15][INFO][mode: data][stage: data migration][step: PostProcessing Step]: Migration completedr

The products and categories are listed in admin page. Also, the categories are listed in frontend in menu without problem. But, when I enter to some category, this doesn´t display any product, Although it does show in the filters that there are some. When I searching for a product, it is not listed in the results either.

I executed a reindex and cache flush: 

php bin/magento indexer:reindex
php bin/magento cache:flush

But the problem persists. What coul be?

Thanks.

[Madvin]

Hello, 

I have reviewed your posted issue about the data related. I need to see your web store URL for analysis purpose. 

Please share it. 

[AbdulJaniBasha]

Just don't use the magento 2.1.6 version. It's terrible. Migrate again using magento 2.1.5. Run the indexer and clean cache you will see the products as you want. If you ate not interested changing the version. I don't know if this works or not but try to delete the pub/static folder( keep .htaccess), var/cahe var/generation var/page_cache var/view_preprocessed. And deploy content again and run indexer, clean cache(not sure, worth trying)