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
2answers
374 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 ...
4
votes
0answers
120 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 ...
3
votes
1answer
608 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
1answer
738 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
411 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

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
24 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
139 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% [====...
3
votes
3answers
1k 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 - ...
2
votes
1answer
65 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
510 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 ...
2
votes
2answers
161 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
142 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
810 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
415 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
57 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
133 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
0answers
116 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
307 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
188 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
46 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
61 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
576 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
118 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
2answers
757 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
3answers
210 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 ...
1
vote
1answer
244 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
3answers
143 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
576 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
152 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
944 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
2answers
2k 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 ...
1
vote
1answer
35 views

After data migration it is happening when i click on any product link in magento 2.2.0?

Exception #0 (Magento\Framework\Config\Dom\ValidationException): Element 'reference': This element is not expected. Line: 1309
1
vote
0answers
55 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: ...
1
vote
1answer
19 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 ...
1
vote
0answers
26 views

Migrate category and product urls from magento 1 to magento 2

How to migrate only category and product urls from magento 1 database to magento 2. I am using magento 2.2.6 Thanks Pradeep
1
vote
1answer
105 views

Delta migration error in magento 2

I am working on magento migration using default magento migration tool. Followed all the steps and migrated data successfully. I followed the below procedure to migrate data: Took the dump of M1 ...
1
vote
1answer
149 views

Migrate only products from Magento 1 to Magento2

I am using Magento data-migration tool and am able to do migrate all data successfully. My requirement was to: migrate only customers migrate only Orders migrate only Products Followed below link ...
1
vote
0answers
19 views

what is the best way to copy live data to staging with most recent important data

I upgraded to 2.3.1 from 2.1.x copied the old site to new server and everything has been upgraded working!! I plan to change the DNS when ready. now i need to grab the most recent order and costumers ...
1
vote
0answers
472 views

Magento 2.3 migration issue, configurable products causing 503 error

I'm facing those issues after data migration from Magento 1.9.4 to Magento 2.3 : configurable products are causing 503 server error on front-end. categories with configurable products are causing 503 ...
1
vote
0answers
44 views

Magento 1.9.0.1 to 2.2.6 data-migration issue

Magento data-migration process all done and all data showing but products add and edit feature not working. when we click on product edit action then we will face issue check below error: PHP ...
1
vote
1answer
78 views

Data migration tool installation error Magento 2.3

I am facing below error when try to install data migration tool from command line. I have fresh magento installation and I am trying to install data migration tool from repo.magento.com and ...
1
vote
0answers
79 views

How to migrate products changes after delta migration from m1 to m2?

I have done data migration from m1 to m2, after that changes have been made in m1 products. Now i want to migrate product changes from m1 to m2. I have done delta migration but as we know it doesn't ...
1
vote
1answer
135 views

If change the url key of Migrated products it doesn't work,still old url is calling,on category page url key is working but strange

I have migrated from Magento 1 to Magento 2 and when updating/changing the URL key of a migrated products "Test" from "test" to "test2" still getting old URL of this product on the frontend "...
1
vote
0answers
250 views

Undefined offset: 150 in /vendor/magento/data-migration-tool/src/Migration/Step/Eav/Data.php on line 813

Preconditions source: magento 1.9.3.10 destination: Magento 2.2.6 3rd party extensions installed Steps to reproduce php bin/magento migrate:data -r -a vendor/magento/data-migration-tool/...
1
vote
0answers
93 views

Magento 2.25 customer and order migration Mismatch of entities in the document

I've migrating Customer and Order from Magento 1.9.0.1 to Magento 2.2.5 version, for the Customer and Order migration I've reviewed the following post and implemented in my local. How to migrate only ...
1
vote
0answers
23 views

Importing Only Customers and Orders after Site is Complete

Is it possible to migrate only Customers and Orders part, if I modify map files if rest of the website is complete? or will it through error in that case.
1
vote
0answers
331 views

data migration stage - step: map step

I'm trying to migrate and got the following: [2018-06-17 01:19:50][INFO][mode: data][stage: data migration][step: Customer Attributes Step]: started 100% [============================] Remaining Time:...