Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [data-migration]

The tag has no usage guidance.

17
votes
1answer
1k 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
337 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
91 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
646 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
397 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
17 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
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
269 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/...
2
votes
1answer
54 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
157 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
115 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
403 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
2answers
351 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
0answers
54 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
127 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
102 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
290 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
126 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
0answers
173 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
44 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
59 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
503 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
101 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
689 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
1answer
221 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
126 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
521 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
147 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
74 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
808 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
3answers
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
22 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
0answers
70 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
0answers
61 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
398 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
38 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
0answers
61 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
69 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
110 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
82 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
309 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:...
1
vote
1answer
57 views

Magento 2.2 adminside products edit getting error

After Data migration from Magento 1.9.1.1 to 2.2 admin side products edit getting the error. Warning: Invalid argument supplied for foreach() in /var/www/html/new/vendor/magento/module-catalog-...
1
vote
0answers
100 views

Magento2 data migration Map Step error

While migrate the data from Magento 1.14.2.2 to Magento 2.2.3, I'm getting the below error. PHP Fatal error: Uncaught TypeError: Argument 1 passed to Migration\Step\Map\Data::getRecordTransformer() ...
1
vote
0answers
87 views

Indexing Issue after Update Magento 1 to Magento 2

After I had migrated my website from magento 1.9 to magento 2.1, Everything is working fine except for a few bugs i get this while running php bin/magento indexer:reindex SQLSTATE[23000]: ...
1
vote
1answer
284 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
1answer
179 views

Extending Magento 2 Data Migration Tools

Magento 2 provides a separated module for data migration: magento/data-migration-tool. During the migration, it needs to customize this module and implement some additional steps to port 3rd-party ...