Questions tagged [data-migration]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
261 views

Magento 2 - Data Migration needs to ignore a custom table

Need to ignore a table from data migration, the table name is "store" where its a default table in Magento 2. Even updated the map.xml to ignore the store table by below code under document_rules ...
3
votes
0answers
1k 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
22 views

Copying Customers/Orders between Magento installations

I need to copy a subset of customers and orders from one Magento installation to another. While copying new entity IDs must be assigned thus existing ones are not overwritten. What would be your ...
1
vote
0answers
507 views

Magento 2 data migration errors how to solve

We have installed migration tool in the Magento 2.3.1 EE (composer require magento/data-migration-tool:2.3.1 ) would like migrate M1 commerce edition (1.14.3.1) to Magento 2.3.1 EE. When we execute ...
2
votes
1answer
27 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
1answer
521 views

Error 'Mismatch of data types....' printed during data migration to Magento 2

The following error was output during data migration to Magento 2. If you receive such an error, which file would you like to edit? Also, please tell me how to write. Mismatch of data types. Source ...
1
vote
0answers
51 views

About Problems Migrating Data From Magento 1.9.2.1 to Magento 2.2 .6

Magento 1.9.2.1 to Magento 2.2.6 encountered an error with EAV during the data migration process. The error is as follows. Notice: Undefined offset: 151 in /var/www/html/tertiary/vendor/magento/data-...
1
vote
1answer
168 views

Magento 2.3.1 Merge products from one database to another?

I have a staging and a production server for my Magento 2.3.1 project. The two databases have different data and configurations, so I can not just dump the mysql db and restore it. Is there a way to ...
1
vote
1answer
359 views

Migrate Static Blocks and multi stores from One Magento to Another

What is the best way to migrate Magento Content i.e Blocks, Pages, and All content from one Magento instance to another. I have 2 Magento setups. One of which has all data and another is fresh Magento....
1
vote
2answers
735 views

Is it possible to copy all customer related data migrate to another magento 2 database?

I want to know how I can copy only customer related data to another Magento 2 database If it is possible then what are the tables that I can copy to the second DB Magento ver 2.2.6
1
vote
0answers
30 views

Magento 2 table not found after Migration

Migrated data from Magento 1.9.3.8 using the migration tool Attempt to access or index Customers Expected result: (*) re-index customers or load customer tab Actual result: (*) Base table or view ...
0
votes
1answer
136 views

Processing stopped during data migration

Processing stopped during data migration. I don't know how to fix it. Could you tell me? Command executed: php bin/magento migrate:data vendor/magento/data-migration-tool/etc/opensource-to-...
0
votes
2answers
372 views

Errors Installing Data Migration 2.2.0 Tool with Composer

Running the different commands below and getting errors with each of them. How do I get the data migration tool to install? I also pasted in our composer.json file below. First Attempt This one ...
4
votes
1answer
199 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 ...
0
votes
1answer
40 views

How can we migrate the data and settings from one magento 2.3.0 to another 2.3.0

There is some functionality issue with my site. And, I want to be sure that Is this issue in default Luma or not? I want to migrate admin data on fresh Magento2.3.0
0
votes
2answers
131 views

migration Magento 1.9 to Magento 2.3

how to solve this error. I'm using GoDaddy server In Abstract.php line 144: SQLSTATE[28000] [1045] Access denied for user 'glamaa_mg4'@'localhost' (using password : YES) In Abstract.php line 128: ...
0
votes
2answers
173 views

Magento2 migration data between dev site and live site

After I did data migration on magento2. We implement the new function on the Magento dev website. The current Magento 1 site is, the live site and running. So, I would like to know: " How to ...
0
votes
0answers
19 views

Magento 2 Data Migration SQL error 'Column not found' Column in m2 DB but not in m1 DB

im having this error: Its the first data migration step, the integrity step. Anyone knows what to do with that? Thanks!
1
vote
0answers
258 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
38 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
693 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
1k views

Migrate only products from Magento 1 to Magento2

I am using Magento data-migration tool and can do migrate all data successfully. I required to: migrate only customers migrate only Orders migrate only Products Followed below link and achieved ...
1
vote
0answers
883 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
55 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 ...
2
votes
3answers
1k 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
458 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
728 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 ...
3
votes
1answer
108 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
10
votes
1answer
1k 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
27 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
81 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
73 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
3answers
529 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
921 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 ...
1
vote
1answer
317 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]: ...
6
votes
1answer
3k 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
66 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
1answer
108 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
211 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
698 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
1answer
135 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
215 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
200 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
313 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
95 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
1answer
176 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 ...
6
votes
1answer
499 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
4k 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
372 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
582 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 ...