Questions tagged [data-migration]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
72 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
413 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
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 ...
0
votes
2answers
68 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
45 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
203 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
229 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
90 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]: ...
3
votes
1answer
918 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
44 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
66 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
85 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
141 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
130 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
83 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
79 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
157 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
109 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
79 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
47 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
21 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 ...
5
votes
0answers
132 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
67 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
111 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
2answers
804 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
162 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
265 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 ...
1
vote
0answers
280 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/...
0
votes
1answer
67 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
627 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
390 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
101 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
68 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
30 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
54 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
123 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
273 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
39 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
336 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
59 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
158 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
1answer
795 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
167 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
58 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
126 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
179 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
265 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
77 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
17 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?