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.

0
votes
0answers
18 views

Magento 2 Undefined offset during migration

I'm getting next error during migrate:data Notice: Undefined offset: 1 in /var/www/magento/vendor/magento/data-migration-tool/src/Migration/Step/Eav/Data.php on line 455 $...
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
34 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 ...
0
votes
0answers
13 views

How to clean Magento 2.3.1 database contains Ultimo data and partial migrated data

How to clean Magento 2.3.1 database contains Ultimo data and partial migrated data Please provide scripts if you have Also I want to migrate only product & categories data. No theme, customer, ...
0
votes
1answer
129 views

Data migration from 1.9.2.4 to 2.3.1 - Failure

Please Help me on this, I have migrate data from magento 1.9.2.4 to 2.3.1 There is a error like this :- Notice: Undefined offset: 19 in C:\xampp\htdocs\magento\vendor\magento\data- migration-...
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 ...
0
votes
2answers
54 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 ...
0
votes
1answer
41 views

Migration Error: SQLSTATE[HY000] [1045] Access denied for user 'wnvjqhgtcr'@'xxx.xx.xx.xx' (using password: YES)

I am migrating data from Magento 1.9.3.1 to magneto 2.3.1 and getting Bellow error while I am running a command php bin/magento migrate:data -r vendor/magento/data-migration-tool/etc/opensource-to-...
1
vote
0answers
359 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 ...
2
votes
1answer
53 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
9
votes
1answer
283 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 ...
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 ...
0
votes
2answers
57 views

I am getting 'Unable to unserialize value' while editing a customer in magento 2.2

I did data migration from Magento 1.9 to Magento 2.2 and now I am unable to edit a customer. I am getting this on customer edit page in admin side. I tried this but it didn't work for me. I added ...
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 ...
0
votes
2answers
74 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
112 views

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

[![enter image description here][1]][1][![enter image description here][2]][2]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 ...
0
votes
1answer
35 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]: ...
1
vote
1answer
158 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
1answer
32 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
40 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
42 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
103 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
49 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
48 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
54 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 ...
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 ...
0
votes
0answers
52 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 ...
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 ...
0
votes
0answers
25 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
45 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
19 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
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 ...
0
votes
0answers
40 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
47 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
347 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
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 "...
0
votes
1answer
141 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
208 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
44 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.
2
votes
2answers
291 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
222 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 <...
1
vote
0answers
73 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
54 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
22 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
41 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
73 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
182 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
33 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
280 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][...