Stack Exchange Network

Stack Exchange network consists of 174 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.

0
votes
0answers
14 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 ...
0
votes
0answers
22 views

Invalid parameter configuration provided for $sourceDocument argument of Migration\RecordTransforme

I am trying to migrate data from magento 1 to magento 2 but getting the error by Running this command : sudo php /var/www/m2.gocleaning.nl/bin/magento migrate:settings -r -a -vvv /var/www/m2....
0
votes
2answers
36 views

cannot connect to mysql on remote server

I am trying to migrate data from magento 1 to maganto 2. Both sites are on different server. So when I try to migrate by below command : sudo php /var/www/m2.gocleaning.nl/bin/magento migrate:...
0
votes
1answer
39 views

Migration error Warning: DOMDocument::loadXML(): Empty string supplied as

I am trying to migrate data from magento 1 to magento 2. Magento 1 is on abc.com and magento 2 is on xyz.com domains. I am getting this error: Warning: DOMDocument::loadXML(): Empty string supplied ...
0
votes
1answer
18 views

Data Migration Error related to CREATE TRIGGER

i'm getting the error when i try to run data step for the data migration tool. The extension "codisto" has been uninstalled while ago. Please advise [Zend_Db_Statement_Exception] SQLSTATE[42000]: ...
0
votes
1answer
34 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/...
0
votes
0answers
25 views

In Magento 2 will new sales overwrite migrated sales orders?

I'm currently migrating an existing Magento 1 site to Magento 2 and I wondered how the sales number would behave after migrating data. We’ve migrated all of our existing sales data from our Magento 1 ...
0
votes
0answers
27 views

Can we delete stores and orders before delta migration

We have a multistore site for which data is migrated from Magento 1 to Magento 2. We need to clean the database for some stores which are not active now. As the stores that we want to delete are not ...
0
votes
1answer
16 views

Migration from live or cloned Database & Delta Migration Question

From what I have read online, it's best to migration from the "cloned" database, instead of "live" database. Since the migration step will create logs in Magento 1 database for the next delta step. ...
0
votes
0answers
29 views

Column not found: 1054 Unknown column 'tier_price_1.percentage_value' error before magento migration

I am done my magento migration but then I show one error while indexing : unknow collum percentage_value And error is Column not found: 1054 Unknown column 'tier_price_1.percentage_value' in '...
0
votes
1answer
30 views

Import Magento1 admin users to Magento2

I have done data migration using data migration tool from magento 1.9.x to 2.2.4, but it doesn't import admin users as mentioned in the docs, and we need to manually copy the admin users. What I have ...
1
vote
0answers
30 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 ...
0
votes
1answer
32 views

Migrating Magento 1 customer Reward points to Magento 2

I'm currently trying to Migrate My data from Magento 1 to Magento 2 and running into some issues with migrating reward points. We have J2T installed on our current Magento 1.9 site which has been OK ...
2
votes
1answer
129 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 ...
0
votes
0answers
30 views

Error in reindexing after migration

I migrated database from Magento 1.9 to 2.2 When re-indexing I get the following error Category Products indexer process unknown error: SQLSTATE[42000]: Syntax error or access violation: 1064 ...
0
votes
0answers
27 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 ...
0
votes
0answers
23 views

Magento 1.9.3.10 to 2.2.3 Easiest Method?

Current Magento poduction version of Magento-1.9.3.10 and have a free domain that I can use to setup and test / staging version Magento2.2.3. I'm confused to the best method to migrate version ...
0
votes
1answer
42 views

Ubertheme error while Migrating date from Magento 1 to Magento 2

I am currently trying to Migrate datafrom our Magento 1 site to the Magento 2 site. We've installed the Ubertheme tool and set the details up in the extension. but every time I try to set up the ...
0
votes
0answers
16 views

Magento Migration 1.9.2.2 to 2.2.6 Requested site not found error after settings migration

I have a Magento site running 1.9.2.2 I planned to migrate to most recent version using the data migration tool provided by Magento and followed the steps given in documentation. I was able to migrate ...
4
votes
0answers
45 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 ...
0
votes
0answers
21 views

Magento 2 data migration how can i migrate customer custom attribute value

How can i migrate customer custom attribute value, i just gone through document but i did't find the proper solution.
0
votes
0answers
13 views

Magento Data migration Document has ambiguous configuration: sales_flat_order

i am getting this error "Document has ambiguous configuration: sales_flat_order" while data migration
0
votes
1answer
104 views

How to manually import/migrate orders & customers from Magento1 to Magento 2 database tables?

What is the best way to manually move the orders and customers to Magento 2.2.6 from Magento 1.8.1 without any third part extensions? there are around 100 records only. I was able to migrated all ...
1
vote
1answer
55 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 "...
0
votes
1answer
59 views

Data migration tool - Magento 2 - Donot Reset the current position of migration to start from the beginning

Do not Reset the current position of migration to start from the beginning In the Destination database, the data migration tool will truncate the table but we need the data that exist in the ...
0
votes
0answers
90 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/etc/...
0
votes
1answer
32 views

Product URL going on 404 page after data migration in magento2

After Data Migration M1=>M2 (1.9.2.4=>2.2.6). Add to cart and Product Page is not working. Product Page Url is going on 404 page. Please Help me if any one have solution.
1
vote
2answers
152 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 ...
0
votes
0answers
122 views

Magento 2 Cusomer and Order Migration Mismatch of entities in the document: sales_order_grid

I've migrated the customers&Orders from Magento 1.9.0.1 Version to Magento 2.2.6 Version so that I have implemented migration-tool. in in my config.xml, I have the following code config.xml <...
0
votes
0answers
32 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 ...
0
votes
1answer
52 views

Migration from Magento 1 to Magento 2 data

I am trying to migrate data from Magento 1 to Magento 2. I using below code. php bin/magento migrate:data --reset vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.8/config.xml I ...
0
votes
0answers
21 views

Using UB Data Migration tool

I am trying to use UB Data Migration Lite - 1.0.6. In this regard I am getting below error.
0
votes
1answer
35 views

IS_REQUIRED error on Migration from Magento 1.9.2.2 to 2.2.6

I'm trying some dry run to migrate data from Magento 1.9.2.2 to 2.2.6. After some adjustment, I'm stuck on the following error [2018-10-28 14:57:56][INFO][mode: data][stage: data migration][step: Map ...
0
votes
0answers
40 views

Magento 2 data migration error like Source fields are not mapped.?

Magento 2 data migration i got an error like below image followed below answer but again faced an issue Source fields are not mapped - migration error is there any other solution?
0
votes
2answers
83 views

How to Change Weight Unit in Magento 2 for Migrated Products

I have recently migrated my store from OpenCart. I have around 2700+ products. In OpenCart Grams as unit was available but not available in Magento 2. Is there any non-programing option available to ...
0
votes
1answer
29 views

Skip same product data migration tool Magento 2

How we can skip the same product data migration? Any reference would be helpful Thanks.
0
votes
1answer
212 views

Magento2 data migration faild at Map Step with message Record structure does not contain field points_action

[2018-10-07 04:21:39][INFO][mode: data][stage: integrity check][step: Url Rewrite Step]: started 100% [============================] Remaining Time: < 1 sec [2018-10-07 04:21:39][INFO][mode: data][...
0
votes
1answer
23 views

How to migrate gift card account

I have approx 2000 records in gift card account in magento1. Now i want to migrate that records in new magento2. is it possible to migrate in new magento2 if few products or few customers are not ...
0
votes
0answers
45 views

Product's Images' URLs are not same after migrating from Magento 1.9 to Magento 2.2

I have migrated Magento 1.9 to Magento 2.2.2 using magento-migration-tool and after that, I have updated an image of the product which I have also update in Magento 1.9 but both images have different ...
0
votes
2answers
125 views

Element 'block', attribute 'class': 'about-us' is not a valid value of the atomic type 'blockClassType'

I migrated M1 data to M2 using ubertheme data migration pro. When I install a theme to my site and load the home page, I am getting the following exception: 1 exception(s): Exception #0 (...
2
votes
1answer
94 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
0answers
46 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
1answer
44 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. ...
0
votes
1answer
94 views

Magento 2.2.5 Data Migration Tool

I am having the below 2 issues, I disabled the EAV Step, only to be hit with another error (the EAV Step issue) I am using a fresh Magento 2 database to test this, I am using Magento migration tool 2....
1
vote
1answer
113 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
1answer
58 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 ...
0
votes
0answers
15 views

Can we import huge amount of data through insert statements in sql queries in magento2?

We need to import huge data to magento database. Can anyone suggest me how can we achieve this through sql queries?or is there any standard approach other than code changes?
0
votes
0answers
89 views

Magento 1.9.1.0 ce to 2.2.5 ce Migration Transform Data Type From TinyInt to SmallInt

I am working through a data migration profile for a large site. I'm currently mapping fields from modules and converting eav attributes. I have come across the error: [WARNING]: Mismatch of data ...
0
votes
2answers
519 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 ...
0
votes
0answers
29 views

How to Migrate two different Magento 1 instances to Magento 2?

I have two different instances of Magento 1 sites. It means different backends and DB. But the features are the same, the Theme is also the same. It makes sense for me to migrate both as different sub ...