0

I am setting up a migration from 1.8.1.0 to 2.2.9. All product related data has been manually set up in the new store so I would like to ignore anything product related including all the eav tables.

The map.xml already contains entries like these (by default):

<ignore>
    <document>eav_attribute</document>
</ignore>
<ignore>
    <document>eav_attribute_group</document>
</ignore>
<ignore>
    <document>eav_attribute_set</document>
</ignore>
<ignore>
    <document>eav_entity_attribute</document>
</ignore>
<ignore>
    <document>eav_entity_type</document>
</ignore>

But after migration all my newly created custom eav attributes' options are gone. For clarification: these attributes only exist in the new magento 2 database.

Basically all I need is customer and order data to be migrated. That's why I put in these sections into my config.xml:

<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>
    <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>
</steps>

What am I missing?

Thank you

Improve this question
1

1 Answer 1

Reset to default
0

It is not possible to transfer only selected data from Magento Data migration tool. Magento data migration tool simply transfers data from table to table. It is built in this way to support data integrity and delta data transfer. Try to follow these steps to achieve the same.

  1. Install fresh Magento2.0 without sample data.
  2. Use data migration tool to transfer data.
  3. Now delete the product from this Magento.
  4. Export products from your Magento in which you have updated catalog
  5. Import your product data into this installation.

Note: If you want to use delta transfer then do not remove and add a new catalog before delta transfer.

Improve this answer
9
  • I don't want to selectively transfer data from tables. I want to skip some tables entirely. Only customer and order data should be migrated.
    – omsta
    Aug 23, 2019 at 12:26
  • It's not possible to ignore EAV tables. EAV tables also contain information about customer attributes. Best way is to transfer entire data and then delete data that you don't need.
    – Surendra Mishra
    Aug 25, 2019 at 6:07
  • Here comes the funny part (just found out about it): magento 2 does not use the eav tables for customers or customer addresses. All data is stored inside customer_entity and customer_address_entity. Checked it in another shop that has been running for a year now.
    – omsta
    Aug 29, 2019 at 9:16
  • really! have you checked eav_attribute table? Information about customer's attributes like first name, last name , details of their backend model are kept in it. for example search "Magento\Customer\Model\Customer\Attribute\Backend\Website" in backend_model field. eav_attribute table is used by the magento to store meta data of customer and products.
    – Surendra Mishra
    Aug 29, 2019 at 12:28
  • customer_entity_datetime, customer_entity_decimal, customer_entity_int, customer_entity_text, customer_entity_varchar... all empty and obviously not needed. The same goes for customer_address_entity tables. The term "EAV" was misleading in this case but they belong to the EAV system.
    – omsta
    Aug 30, 2019 at 7:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.