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.

1
vote
0answers
18 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
27 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
10 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
41 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
38 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
39 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
223 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
47 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
0answers
245 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
22 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
48 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
29 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
64 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
94 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
30 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
87 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
31 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
38 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
37 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
71 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
42 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
42 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
49 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
139 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
50 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
59 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
44 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
67 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
37 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
39 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
261 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
91 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
120 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
175 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
39 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
253 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
193 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
53 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
53 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
38 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
63 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
169 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
32 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
265 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
31 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
80 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 ...