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.

16
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
0answers
270 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
1answer
600 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&...
4
votes
0answers
75 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
2answers
154 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 ...
3
votes
1answer
382 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
23 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
51 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
1answer
393 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
1answer
111 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
2answers
284 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
124 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
281 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
124 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
166 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
58 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
460 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
82 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
150 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/...
1
vote
2answers
655 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
205 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
110 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
496 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
142 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
69 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
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
20 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
33 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
33 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
18 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
345 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
33 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
47 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
62 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
103 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
71 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
297 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
56 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
98 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
79 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
271 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
0answers
88 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 (...
1
vote
1answer
177 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 ...
1
vote
0answers
169 views

Associated simple products not showing in configurable product

In my magento2.1.5 (migrated from magento1.9) store, some configurable products are not showing any associated simple product in both admin and front-end. I need to set the simple products again in ...
1
vote
0answers
29 views

From Squarespace to Magento? [closed]

I'm going to move from Squarespace to Magento- does anyone have any recommendations on how to get my products, customer and order information into Magento?