Migrate Magento 1.7 separate store to Magento 2 multistore (just customers and history)

Question

We need to migrate the Customers and Orders History from Magento 1.7 to a Multistore Magento 2.

I was using the migration tools and tried to migrate at least the customers:

  <steps mode="data">
    <step title="Customer Attributes Step">
        <integrity>Migration\Step\Customer\Integrity</integrity>
        <data>Migration\Step\Customer\Data</data>
        <volume>Migration\Step\Customer\Volume</volume>
    </step>
  </steps>

But I was unsuccessful.

Though, the migration output was successfully:

$php bin/magento migrate:data /fullpath/vendor/magento/data-migration-tool/etc/ce-to-ce/1.7.0.0/config.xml


    [2017-05-22 08:59:21][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started
    [2017-05-22 08:59:21][INFO][mode: data][stage: setup triggers][step: Stage]: started
    [2017-05-22 08:59:21][INFO][mode: data][stage: data migration][step: Customer Attributes Step]: started
    [2017-05-22 08:59:21][INFO][mode: data][stage: volume check][step: Customer Attributes Step]: started
    [2017-05-22 08:59:21][INFO][mode: data][stage: volume check][step: Customer Attributes Step]: Migration completed%              

There is no customer records in admin panel

I have already a couple of days of struggling but I'm keep getting dead ends. Please help me to solve issue.

Maybe it is better to migrate first everything in a Multistore? What do you think?

---

Update

Sadly, I didn't receive any feedback to this problem.

So, I decided to take a longer run, not sure if it will get me to the end result though:

1. Configured a Magento 2 multistore websites with all 4 websites + stores.
2. I started to migrate every Magento 1.7 store into a separate Magento 2 store. That means for all 4 stores of Magento 1.7 I ended up with another 4 stores of Magento 2.
3. Then I exported the customers: Systems > Export > Customer Main File to a CSV file, edited the CSV file to reflect the Website Id and store ID I was importing to.

Now, the next point on the Agenda: How to migrate the sales Data or at least just the orders history???!!

If anyone has any any suggestion please give a hand of help - and I'll be for ever grateful :).

Thank you.

Answer 1

Checklist before starting migration:

• You should start migration in fresh magento 2 with No sample-data. Please make sure to take backup of site and database.
• Create a copy of database (M1 database) which need to mirgate to M2 site. Connect to this database and Both will be on same hosting.
• Make sure you check the connection by test file to both database. This makes sure our migration work better.
• Config.xml file path must be :Root-Site/vendor/magento/data-migration-tool/etc/ce-to-ce/1.7.0.0/config.xml

Now we will start migration. I expect you have installed correct version of migration tool.

To migrate customer and orders history: We only need to deal with DATA method and data-mode only need below content:

 <step title="Customer Attributes Step">
     <integrity>Migration\Step\Customer\Integrity</integrity>
     <data>Migration\Step\Customer\Data</data>
     <volume>Migration\Step\Customer\Volume</volume>
 </step>

<step title="Map Step">
     <integrity>Migration\Step\Map\Integrity</integrity>
     <data>Migration\Step\Map\Data</data>
     <volume>Migration\Step\Map\Volume</volume>
 </step>
 <step title="OrderGrids Step">
     <integrity>Migration\Step\OrderGrids\Integrity</integrity>
     <data>Migration\Step\OrderGrids\Data</data>
     <volume>Migration\Step\OrderGrids\Volume</volume>
 </step>
 <step title="SalesIncrement Step">
     <integrity>Migration\Step\SalesIncrement\Integrity</integrity>
     <data>Migration\Step\SalesIncrement\Data</data>
     <volume>Migration\Step\SalesIncrement\Volume</volume>
 </step>

Mapping of map.xml:

<map_file>etc/ce-to-ce/1.7.0.0/map.xml</map_file>

Crypt key:

<crypt_key>e07mfa00b35f52628ae81d89c4a8cc6db</crypt_key> <!-- ADD your crpted key here from M1 -->

Execute below command in root of M2 installation. There should not any change in this command and config file MUST be in this location.

php bin/magento migrate:data -r --reset vendor/magento/data-migration-tool/etc/ce-to-ce/1.7.0.0/config.xml

Clean,flush and reindex from CLI. You will be able to see orders and customers in Admin dashboard.

Map.xml file play important role in migration.If there is any error, post in comment. I will update answer according to your need.