What is the best way to manually move the orders and customers to Magento 2.2.6 from Magento 1.8.1 without any third part extensions? there are around 100 records only.

I was able to migrated all the data and setting initially from the "clone" version of the live Magento 1 database to fresh Magento 2 database last month using the data-migration-tool. Now the magento 2 site is ready, i need to migrate the new orders and customer (for the past month, around ~50 records) to the Magento 2 site. I'm not able to get the delta migration tool work correctly. What is the way to manually move those records over, perhaps which database tables to copy the records from?

Thank you!

  • If the Magento 2 site isn't in production yet, could you not just clear the M2 database and do a full migration from M1 again? – Brett Dec 7 '18 at 4:21
  • Hi, can you advise how i can clear the m2 database? i'm afraid it will also clear out the changes i have made in m2. – Kris Wen Dec 7 '18 at 20:12
  • Easiest way is to just drop the database and run the installer again. If you're following good practices by putting your changes into modules, their setup scripts should create whatever tables are necessary. If you're talking about data changes, like CMS content, you can always back up that table first, then reset and reimport when you're done. – Brett Dec 9 '18 at 18:19

so I was able to migrate the customers and orders into the magento 2 again, without needing to use the delta migration step, nor empty the existing magento 2 orders/customers. I think it just overwrites the existing entries.

this is my config.xml data step looks like

        <steps mode="data">
            <step title="Data Integrity Step">
    <!--        <step title="EAV Step">
            </step>  -->
            <step title="Customer Attributes Step">
            <step title="Map Step">
    <!--        <step title="Url Rewrite Step">
            <step title="Log Step">
            <step title="Ratings Step">
            <step title="ConfigurablePrices step">
            </step>  -->
            <step title="OrderGrids Step">
    <!--        <step title="Tier Price Step">
            </step>  -->
            <step title="SalesIncrement Step">
            <!--<step title="PostProcessing Step">

this is the map.xml looks like

<?xml version="1.0" encoding="UTF-8"?>
 * Copyright © 2013-2017 Magento, Inc. All rights reserved.
 * See COPYING.txt for license details.
<map xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../map.xsd">

I saw you used the Magento database migration tool. I'm looking to only export orders and client data from Magento to Magento 2.2.7.

Could you post the complete code of both files you modified?



  • hey Steve, the complete code is too long to be posted as an answer ( as well as version different). For config.xml, comment out everything else leaving only the below 5 steps. For map.xml, add those 6 <ignore> rules above all other rules. make sure do a db backup before you try the migration. – Kris Wen May 31 '19 at 18:05

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.