Magento – Migrate only products from Magento 1 to Magento2

data-migrationmagento2magento2-migration-tool

I am using Magento data-migration tool and can do migrate all data successfully.

I required to:

migrate only customers

migrate only Orders

migrate only Products

Followed below link and achieved migrate only customers.

Magento 2: is it possible to migrate only customer using migration tool

Followed below link and achieved migrate only Orders.

Magento 2: Migrate only Customer and orders

Can anyone help me with how to migrate only products?

Referred to some links but they are not useful.

If anyone worked on migration please help me to achieve the above requirement.

Note: If there are any free migration script or migration can be done programmatically please share the links or ideas.

Migration can be done programmatically apart from the cli? If anyone tried this share the knowledge, please

Thanks

Best Answer

Please you can try migrate only products in this way:

1 backup your Magento2 database 2 in your tool > config.xml leave only "Map Step" and "ConfigurablePrices step" for mode="data". Like this

<steps mode="data">
        <step title="Map Step">
            <data>Migration\Step\Map\Data</data>
        </step>
        <step title="ConfigurablePrices step">
            <data>Migration\Step\ConfigurablePrices\Data</data>
        </step>
    </steps>

3 instead of $sourceDocuments = $this->source->getDocumentList(); paste the next code

$sourceDocuments =
    [
        'catalog_product_bundle_option',
        'catalog_product_bundle_option_value',
        'catalog_product_bundle_price_index',
        'catalog_product_bundle_selection',
        'catalog_product_bundle_selection_price',
        'catalog_product_bundle_stock_index',
        'catalog_product_enabled_index',
        'catalog_product_entity',
        'catalog_product_entity_datetime',
        'catalog_product_entity_decimal',
        'catalog_product_entity_gallery',
        'catalog_product_entity_group_price',
        'catalog_product_entity_int',
        'catalog_product_entity_media_gallery',
        'catalog_product_entity_media_gallery_value',
        'catalog_product_entity_text',
        'catalog_product_entity_tier_price',
        'catalog_product_entity_varchar',
        'catalog_product_link',
        'catalog_product_link_attribute',
        'catalog_product_link_attribute_decimal',
        'catalog_product_link_attribute_int',
        'catalog_product_link_attribute_varchar',
        'catalog_product_link_type',
        'catalog_product_option',
        'catalog_product_option_price',
        'catalog_product_option_title',
        'catalog_product_option_type_price',
        'catalog_product_option_type_title',
        'catalog_product_option_type_value',
        'catalog_product_relation',
        'catalog_product_website',        
    ]

4 migrate data with --reset

Related Solutions

Magento – How to Migrate Only Orders with Data Migration Tool

For orders, you will usually need customers as well.

I used answer when I first did this.

Only run the bin/magento migrate:data command. And with -r if you want to start from scratch.

In your config.xml, comment out the Eav and other steps you want to exclude:

<steps mode="data">
        <step title="Data Integrity Step">
            <integrity>Migration\Step\DataIntegrity\Integrity</integrity>
        </step>
        <!--<step title="EAV Step">
            <integrity>Migration\Step\Eav\Integrity</integrity>
            <data>Migration\Step\Eav\Data</data>
            <volume>Migration\Step\Eav\Volume</volume>
        </step>-->
        <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="Url Rewrite Step">
            <integrity>Migration\Step\UrlRewrite\Version191to2000</integrity>
            <data>Migration\Step\UrlRewrite\Version191to2000</data>
            <volume>Migration\Step\UrlRewrite\Version191to2000</volume>
        </step>-->
        <step title="Log Step">
            <integrity>Migration\Step\Log\Integrity</integrity>
            <data>Migration\Step\Log\Data</data>
            <volume>Migration\Step\Log\Volume</volume>
        </step>
        <step title="Ratings Step">
            <integrity>Migration\Step\Ratings\Integrity</integrity>
            <data>Migration\Step\Ratings\Data</data>
            <volume>Migration\Step\Ratings\Volume</volume>
        </step>
        <!--<step title="ConfigurablePrices step">
            <integrity>Migration\Step\ConfigurablePrices\Integrity</integrity>
            <data>Migration\Step\ConfigurablePrices\Data</data>
            <volume>Migration\Step\ConfigurablePrices\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="Tier Price Step">
            <integrity>Migration\Step\TierPrice\Integrity</integrity>
            <data>Migration\Step\TierPrice\Data</data>
            <volume>Migration\Step\TierPrice\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>
        <!--<step title="PostProcessing Step">
            <data>Migration\Step\PostProcessing\Data</data>
        </step>-->
    </steps>

Then in your map.xml ignore most product stuff with:

         <ignore>
             <document>catalog_category*</document>
         </ignore>
         <ignore>
             <document>catalog_compare*</document>
         </ignore>
         <ignore>
             <document>catalog_eav_attribute</document>
         </ignore>
         <ignore>
             <document>cataloginventory_stock*</document>
         </ignore>
         <ignore>
             <document>catalog_product_*</document>
         </ignore>
         <ignore>
             <document>core_*</document>
         </ignore>
         <ignore>
             <document>cms_*</document>
         </ignore>

Magento – Magento 2: How to we migration only customers and orders data using Data Migration tool

Yes, it is possible but you will have to modify a bit the config files to get what you need.

Here is an example of the Data Migration Tool config.xml used to migrate only customers and newsletters subscribers.

<?xml version="1.0" encoding="UTF-8"?>
<config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">
<steps mode="data">
    <step title="Data Integrity Step">
        <integrity>Migration\Step\DataIntegrity\Integrity</integrity>
    </step>
    <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="Newsletter Subscribers Step">
        <integrity>Migration\Step\Newsletter\Integrity</integrity>
        <data>Migration\Step\Newsletter\Data</data>
        <volume>Migration\Step\Newsletter\Volume</volume>
    </step>
</steps>
<steps mode="delta">
    <step title="Customer Attributes Step">
        <delta>Migration\Step\Customer\Delta</delta>
        <volume>Migration\Step\Customer\Volume</volume>
    </step>
</steps>
<source>
    <database host="172.x.x.x" name="source-db-name" user="dbuser" password="dbpassword"/>
</source>
<destination>
    <database host="172.x.x.x" name="source-db-name" user="dbuser" password="dbpassword"/>
</destination>
<options>
    <map_file>etc/ce-to-ee/1.7.0.0/map.xml</map_file>
    <customer_map_file>etc/ce-to-ee/map-customer.xml</customer_map_file>
    <customer_document_groups_file>etc/ce-to-ee/customer-document-groups.xml.dist</customer_document_groups_file>
    <customer_attribute_groups_file>etc/ce-to-ee/customer-attribute-groups.xml.dist</customer_attribute_groups_file>
    <delta_document_groups_file>etc/ce-to-ee/deltalog.xml</delta_document_groups_file>
    <map_document_groups>etc/ce-to-ee/map-document-groups.xml.dist</map_document_groups>
    <bulk_size>0</bulk_size>
    <direct_document_copy>0</direct_document_copy>
    <source_prefix />
    <dest_prefix />
    <auto_resolve_urlrewrite_duplicates>0</auto_resolve_urlrewrite_duplicates>
    <log_file>migration.log</log_file>
    <progress_bar_format>%percent%% [%bar%] Remaining Time: %remaining%</progress_bar_format>
    <upgrade_customer_password_hash>1</upgrade_customer_password_hash>
    <edition_migrate>ce-to-ee</edition_migrate>
    <edition_number>1.7.0.0</edition_number>
    <init_statements_source>SET NAMES utf8;</init_statements_source>
    <init_statements_destination>SET NAMES utf8;</init_statements_destination>
    <crypt_key>xxxxxxxxpatataxxxxxxxxxx</crypt_key>
</options>

In this example you can see how all unnecessary steps have been removed to leave only Customer Attributes Step which is in charge of customer migration.

Newsletter Subscribers Step is a custom step created to migrate specific data.

You can use this example to modify your config.xml file and migrate only customers and sales data.

Hope it helps.

Best Answer

Related Solutions

Magento – How to Migrate Only Orders with Data Migration Tool

Magento – Magento 2: How to we migration only customers and orders data using Data Migration tool

Related Topic