Questions tagged [data-migration]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
17
votes
1answer
2k views

Best plan about delta migration

Three months before I migrated Magento 1.9.3.3CE to Magento 2.1.7EE I added/update CMS content. Install 20+ extensions and configured all. For testing, I altered some of the products, orders, ...
9
votes
1answer
460 views

Data Migration > Eav step error

Data Migration > EAV Step SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-Migration_Default' for key 'EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME' i have find ...
5
votes
0answers
156 views

Magento Migration Unable to serialize value from sales_flat_order_item

I'm getting error while Migrating data from 1.9.3.3 to 2.2.6 CE. Error I'm getting is like below: Could not unserialize data of sales_flat_order_item.product_options with record id 7. I've ...
4
votes
3answers
2k views

Magento 2.1.7 customer login issue

when I try to log in as a customer to shop I got notice error: "An unspecified error occurred. Please contact us for assistance." When I register as a new customer to shop it seems to work ok - ...
3
votes
1answer
1k views

Warning: Error while sending QUERY packet. - Magento Migration

I'm migrating from Magento 1.9.3.3 CE to Magento 2.3.0 EE, I'm facing the below error. Warning: Error while sending QUERY packet. PID=5859 in vendor/magento/data-migration-tool/src/Migration/...
3
votes
2answers
706 views

Data MIgration failed

While Practicing on data migration in magento 1. I got this error, and i found that i have to ignore these attributes in eav attribute file. am i right? But i don't know how to convert this into XML ...
3
votes
1answer
837 views

magento 2 data migration tool ignore table by mask

I'm creating map.xml file to ignore some tables in DB. And I have a lot of tables with prefix 'old'. Can I create one rule for all this tables and don't create one by one? Something like <ignore&...
3
votes
1answer
475 views

Migrate Magento EE 1.14.3.1 to Magento CE 2.1.7

How to migrate Magento Enterprise Version 1.14.3.1 to Magento Community Version 2.1.7? I am not getting perfect solution for migrate from M1 Enterprise to M2 Community. Official Data-migration-tool ...
3
votes
1answer
37 views

What is use of direct_document_copy in data migration config.xml

I have recently migrate M1 DB to M2 DB there is option in config.xml called direct_document_copy <!-- Set direct_document_copy = 1 for better performance. NOTE: 'source' and 'destination'...
3
votes
1answer
50 views

order time difference from magento 1 to magento 2 after migration

I have migrated Magento 1.9.3.1 to Magento 2.3.0 I have setup timezone India Standard Time(Asia/Kolkata). After migration created_time have differences of 5:30 hours. How can I fix the issue? For ...
3
votes
1answer
43 views

Magento 2: No data migration tool matching version

My Magento version is 2.2.9. No matching data migration tool exists. What should I do? Should I install Magento version 2.2.7?
3
votes
1answer
25 views

Host Migration with Differing Tables

I'm going to be doing a hosting migration from an old provider. I'm moving a live site and a testing site over. They both have separate Magento 1.9.3 back-ends and separate databases. I've made ...
3
votes
1answer
143 views

Magento 2: Data migration Class error

I tried to migrate data from Magento 1.9.2.2 to Magento 2.2.2 for testing. I am getting below error [2018-02-14 11:45:37][INFO][mode: data][stage: volume check][step: EAV Step]: started 100% [====...
2
votes
3answers
380 views

Data Migration not procceds after Map Step

ubuntu@ip-172-31-32-129:/var/www/magento$ sudo php bin/magento migrate:data -r vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.1/config.xml Reset the current position of ...
2
votes
1answer
72 views

Magento1 to Magento2 Migration Process Step

Magento1 to Magento2 Migration Process Step Know you free tool plugin available and file both migration Lets me know
2
votes
2answers
173 views

Migration error Magento 1.9.3.2 to 2.1.8

I have Migrated from Magento ver 1.9.3.2 to Magento ver 2.1.8 successfully using Data Migration tool. In admin, catalogs and customers showing fine on grid but after clicked on it showing below ...
2
votes
1answer
226 views

How can we insert new records in magento2 db using sql queries [closed]

Let us know the exact way to import bulk data to DB using queries.
2
votes
1answer
933 views

Magento 2. Migration. Map customer attribute

Can a customer_attribute be mapped during a M1 -> M2 data migration, if so can anyone provide any clues on how to do that? e.g M1 attribute tel => M2 attribute telephone
2
votes
1answer
444 views

Error while executing migration - Magento 1 to Magento 2

Migrating (trying to) but there is an error with I don't know what to do. [Symfony\Component\Console\Exception\CommandNotFoundException] There are no commands defined in the "migrate" namespace. ...
2
votes
0answers
252 views

Magento 2 customer data migration & volume check failed?

I would like to migrate only customers data using magento2 data migration tool. Can anyone suggest how to resolve the below error when migrating data [2019-08-06 12:20:19][INFO][mode: data][stage: ...
2
votes
1answer
22 views

An exception was printed during migration, but I don't know what it means

An exception was printed to the console during migration. Please tell me what you mean. My migration procedure is as follows. 1.Installed Magento version 2.2.6. 2.The application and database were ...
2
votes
0answers
64 views

Migrating from Shopify: Manual or Migration Tools?

The company I work at has been using Shopify for about 3 years. Due to expanding business requirements, we want to migrate to Magento 2. With Shopify, the site is running with workarounds so it has ...
2
votes
0answers
146 views

Store is not found+Data Migrating From M1.8.1.0 To M2.2.4

Step 1:- php bin/magento migrate:settings --auto vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml It's working fine for me. Step2:- php bin/magento migrate:data --...
2
votes
1answer
155 views

Data migration tool : How can i use time zone handler for order purchase time for magento 1 server on IST timezone

I use the tool for migrate my data from my 1.9.2.4 to magento2.2.2 It works except a problem with date of purchase. There is a difference of 5:30 hours, however the time zone on M1 Server is IST (...
2
votes
1answer
332 views

Magento2 - when customer Sign Out then error occurred: “No such entity with id = 0”

After data migration process I fetched one problem. Problem is when customer Sign Out from the account then this error occurred, No such entity with id = 0 When I refresh the page again then ...
2
votes
0answers
198 views

Data Migration From Magento 1.9.1 to 2.1.9

I am using magento data migration tool. I followed http://devdocs.magento.com/guides/v2.3/migration/migration-migrate-data.html [PDOException] SQLSTATE[23000]: Integrity constraint violation: ...
2
votes
1answer
48 views

Magento 2 Data Migration. Redundant tables from M1

The official docs on migrating data say: Remove outdated and redundant data from your Magento 1 database before migration. Such data may include logs, order quotes, recently viewed or compared ...
2
votes
0answers
62 views

Magento 2 data migration error ConfigurablePrices step mismatch of entities:catalog_product_entity_decimal

I'm migrating data from M1 v1.8.0.0 to M2 v2.2.0, and receiving this error at the volume check for ConfigurablePrices: [2018-01-08 05:56:59][INFO][mode: data][stage: data migration][step: ...
2
votes
0answers
729 views

The element 'product.info.options' already has a child with alias 'text' - Magento 2.2.0

After data migration (1.9.1 CE - 2.2.0 CE) I got the below error when I click add to cart button in magento 2 we can't add this item to your shopping cart right now I did research about this but ...
2
votes
1answer
152 views

Magento 2 Migration Error customer_eav_attribute and index_process_event

I am getting error during migration from Magento 1.9.3.1 to Magento 2.2.4. [2018-01-09 09:01:32][ERROR]: Foreign key (FK_CSTR_EAV_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID) constraint fails on source database. ...
1
vote
1answer
298 views

Magento1 to Magento2 data migration

I am new to Magento2, I need some guidance from magento geeks for migrating data from magento1 to magento2. Quick Overview I received a system that was built in magento2 from scratch. So I think ...
1
vote
2answers
852 views

Magento 2.2 data migration Duplicate store_group_name Entries

I am trying to migrate a store from 1.9.2.2 to Magento 2.2 using the Magento data migration tool but unfortunately when running the tool the error appears [PDOException] SQLSTATE[23000]: ...
1
vote
2answers
68 views

Magento 2 Data Migration time difference?

We have migrated M1 customers and orders from M2.3.1 successfully with the datamigration tool but we are facing some discrepancy with the time differences. The best example is customer create_at &...
1
vote
2answers
119 views

Is it possible to copy all customer related data migrate to another magento 2 database?

I want to know how I can copy only customer related data to another Magento 2 database If it is possible then what are the tables that I can copy to the second DB Magento ver 2.2.6
1
vote
3answers
175 views

Magento 1 migrate to Magento 2 process

I just have a question about the migration process from M1 to M2. Run the data migration tool. Test thoroughly on the new M2 store Run the incremental migration tool. Switch to new M2 store. Can ...
1
vote
2answers
670 views

What are m2_cl tables in magento?

I am working on Magento Data Migration from 1.9 to 2.2. I customised some code and suppressed some of the possible errors of integrity constraints to execute the tool properly and get the data. ...
1
vote
1answer
342 views

Magento 2 single store mode still exports products for both store views?

Why is a magento 2 site in single store mode still exporting products from global and store view scores? These products were intially migrated using the data-migration-tool from magento 1
1
vote
1answer
53 views

Magento 2 Reorder functionality missing for migrated orders

We have migrated customers and orders data from M1 (1.14.3.1 EE) to M2 (2.3.1 commerce) successfully But when we are doing testing at the admin end for the orders found that the Reorder button was ...
1
vote
4answers
70 views

Magento 2 data migration triggers table missing in M1

We have successfully migrated data from M1 to M2 using the data migration tool. We have a custom table called md_cybersource which is mapped to magedelight_cybersource in map.xml When we run delta ...
1
vote
2answers
61 views

Magento2.3.2 During data migration I got Only enties mismatch error . Only orders data in not migrated

My migration is from Magento 1.9.1.0 to Magento 2.3.2. I ran the below command : php -dmemory_limit=-1 bin/magento migrate:data vendor/magento/data-migration-tool/etc/opensource-to-opensource/1....
1
vote
1answer
45 views

Categories mapping when migrate from Magento 1 to Magento 2

Can anyone tell me whether it's possible to have a migration with categories mapping on migration for magento 1 to magento 2 and how can I do this?
1
vote
2answers
53 views

Magento 2 - Mirasvit RMA data migration from M1 to M2

We have migrated products, customers and orders details from M1 to M2 using https://devdocs.magento.com/guides/v2.3/migration/migration-tool-install.html now we would like to migrate RMA Mirasvit data ...
1
vote
1answer
72 views

How to migrate email templates only from M1 to Magento 2?

We have installed migration tool in Magento 2.3.1 EE (composer require Magento/data-migration-tool:2.3.1 ) would like to migrate M1 commerce edition (1.14.3.1) to Magento 2.3.1 EE. We have migrated ...
1
vote
1answer
95 views

Error 'Mismatch of data types…' printed during data migration to Magento 2

The following error was output during data migration to Magento 2. If you receive such an error, which file would you like to edit? Also, please tell me how to write. Mismatch of data types. Source ...
1
vote
1answer
60 views

Migrate Static Blocks and multi stores from One Magento to Another

What is the best way to migrate Magento Content i.e Blocks, Pages, and All content from one Magento instance to another. I have 2 Magento setups. One of which has all data and another is fresh Magento....
1
vote
1answer
160 views

Magento 2 : Please upgrade your database while database is newer than required

I am getting this error when moving Magento 2 website to Google Cloud (Click to Deploy). I have merged theme files and media files and it worked fine. When I have connected to my old database it ...
1
vote
1answer
77 views

Is there any option to migrate only orders from magento1 to magento2?

My scenario is : I have migrated all data from Magento1 to Magento2 using live DB backup. So I could not use delta migration for the incremental changes. But I need to migrate the newly created orders ...
1
vote
2answers
1k views

Magento 2 SHA1 Password is not Accepting after Migration

I have Migrated Magento 1.9.1.0 website in Magento 2.2.4,all data is migrated successfully. When I am trying to login from front-end with existing old customer(Magento1) it generating error "You did ...
1
vote
1answer
359 views

Magento 1.9.3.4 -> 2.1.8 data migration tool error

I have tested steps of the import one at a time to determine that the issue occurs right after the map step. When I migrate customer and sales data using the data migration tool I get the following ...
1
vote
2answers
3k views

Magento 2 : How can i read Xml file data

I have product file in XML format. I just need to read this file and import those data. I have already use simplexml_load_file(file path) but it will work only small size of file. Is there any other ...