What is the best way to migrate only the product data from Magento 1.9 to Magento 2?

A client wants the entire site redone in Magento 2 (no work has been started on this second site yet), except he wants/needs to copy over some data from the current site which is in Magento; what he wants migrated over is only the product data (products, their attributes, prices, categories etc).

What’s the best way to do this? I’ve read about this and it seems my options are:

  1. Editing the config.xml file and commenting out all the steps of migration except the necessary ones to migrate products, as discussed here: https://github.com/magento/data-migration-tool/issues/406

  2. Migrating the whole database and just deleting the rest.

  3. Migrating the whole database, exporting the products into a csv, and then resetting the site, and then importing the csv that only has the products; this option is discussed here, by someone claiming that option 1 could be problematic: https://magento.stackexchange.com/questions/155887/data-migration-tool-migrate-only-categorys-and-products

There may be more ways to do it, but I haven’t found any.

It’s worth noting that the client does at some point want to personally edit some of the products/add new ones before the site goes up, and wants to do so in a csv format (so either way, at some point the DB will have to be sent to a csv and then uploaded after changes).

What’s the most straightforward approach, to avoid as many problems and roadblocks as possible? One of the above, or some other approach?

submitted by /u/Mr_Crabman
[link] [comments]