Questions tagged [data-migration-tool]

denotes question related data-migration using data-migration-tool

Filter by
Sorted by
Tagged with
0 votes
0 answers
30 views

Removing: Magento 2 Data Migration Tables - The Client Chose OpenMage Instead

Around a year ago, a client considered moving to Magento 2 and at the advice of another developer, they installed the data-migration-tool to prepare for a migration to Magento 2. However, they ...
HenryHayes's user avatar
1 vote
0 answers
16 views

Magento 1 to Magento 2 Data Migration Tool Error Remaining Time: < 1 sec In Mysql.php line 109: SQLSTATE[42000]: Syntax error or access violation

I'm migrating data from 1.9.4.3 to Magento 2.4.6 and ran into this error on data migration using the Magento Data Migration Tool for 2.4.6 [2023-11-26T17:04:40.663535+00:00][INFO][mode: data][stage: ...
Nelz's user avatar
  • 11
0 votes
1 answer
772 views

How can we resolve this issue ? Deprecated Functionality: str_replace():

I'm trying to fix the error with this (return sprintf($path,str_replace('contents_', '', $content));) code but it's not working. anyone have idea how we can resolve it? Console error... [2023-02-...
dev.ma's user avatar
  • 1
0 votes
2 answers
123 views

I'm facing the migration issue magento 1.9.3.9 to magento 2.4.4

There are showing some errors in migration How we can resolve it. anyone can resolve this issue ?? E:\xampp81\htdocs\magento2>php bin/magento migrate:settings vendor/magento/data-migration-tool/etc/...
dev.ma's user avatar
  • 1
2 votes
1 answer
112 views

Database migration from magento 1.9.3.6 to magento 2.4.4-p2

For migrate Database I installed migration tool using composer require magento/data-migration-tool:2.4.4. After composer install run bib/magento setup:upgrade command. But it raises an error like ...
Chippy Ani's user avatar
0 votes
1 answer
767 views

Error after data-migration-tool update

After updating data-migration-tool I get this error every time I try to run the command: Warning: Could not check compatibility between Migration\Logger\Logger::addRecord(int $level, string $message,...
uziixd's user avatar
  • 3
0 votes
1 answer
129 views

Migration from Magento 1.6.2.0 to Magento 2.4.3 Undefined index: in Migration/Step/Eav/Integrity/ClassMap.php on line 111

I'm using the data-migration tool for migrating my site from Magento ver. 1.6.2.0 to Magento ver. 2.4.3. Getting below error while running migrate:data command. [2021-11-02 17:00:21][INFO][mode: data]...
Ivan Cunha's user avatar
2 votes
1 answer
189 views

Migrate multiple Magento 1 instance inside only one multistore Magento 2

I have two Magento 1 I want to migrate to Magento 2 withing the same instance. My goal is to have only one Magento 2 in the end. Site A => Magento 1.9.4.0 with 5 website inside Site B => ...
Taschert's user avatar
  • 559
0 votes
1 answer
141 views

During Data Migration from Magento 1.9.4.0 to Magento 2.4 getting some warning and updated product and categories are not showing in Magento 2

I want to move my data ( products , categories , sales e.t.c data ) from Magento 1.9.4.0 to Magento 2.4. So on during the migration i have created a module so on migration getting some warning and ...
Prits's user avatar
  • 626
0 votes
0 answers
98 views

How to migrate Magento 1 to Magento 2 using Migration script?

I'm new to migrating the Magento 1 site to Magento 2 site. But the Magento 1 site has some custom data so client has shared us some of the migration script to migrate the data. But I'm not sure how to ...
MagentoDev's user avatar
0 votes
1 answer
168 views

Magento data migration M 1.9.2.4 to M2.4.2 show integrity error & missing data in admin panel for product

I have am doing data migration via taking backup of production site db on local and installing new fresh M2.4.2 magento. Setting migration done successfully. Setting migration command: php bin/magento ...
Yogita's user avatar
  • 784
0 votes
3 answers
245 views

How to Data Migrate Magento 1.x to Magento 2.x

How to migrate from m1 to m2 steps wise solution to migrate data and all m1 configuration, If any step by step link or any solution or Magento tool to migrate the site, Please give me an idea or ...
MOHIT GOHEL's user avatar
0 votes
1 answer
48 views

How to run the Data Migration Tool with everything except for customer orders?

Magento 1.9.4 --> Magento 2.4.2p1 I mistakenly thought I could run the normal transfer of the Data Migration Tool and then run the delta command just to update the changes done on the original (...
Allysin's user avatar
  • 250
0 votes
2 answers
794 views

Which Magento 2 version is best to use

I want to build an e-commerce site and I'm new to Magento. Could you please suggest which version of Magento to use that is stable and has more extensions available in marketplace. Also, please ...
Jayendhar P's user avatar
0 votes
1 answer
103 views

Migrated Magento 1 Customer address does not show (shows variables as output instead)

First off, I have searched for a solution here, and on Github, this has never been answered specifically from what I can see, none of the answered items work. Migrated Magento 1 address information ...
CvRChameleon's user avatar
0 votes
2 answers
1k views

Magento 2 Data Migration "Integrity constraint violation: 1062 Duplicate entry ### for key 'SALES_CREDITMEMO_INCREMENT_ID_STORE_ID

I've been having issues while using the data migration tool to migrate data from Magento 1.9.3 to Magento 2.3: I already setup the config.xml to migrate only Customers and Sales. I then run the ...
Earthwarrior's user avatar
0 votes
1 answer
233 views

Magento Data Migration Tool For Third Party Extension or Custom Modules

I have done default migration using Data Migration Tool. Now I want to migrate data of my custom module for that I am following below link: https://devdocs.magento.com/guides/v2.4/migration/extend-the-...
Yogita's user avatar
  • 784
0 votes
1 answer
53 views

1.9.4.x to 2.3.6 data Migration not able to ignore table

When migrating data using Adobe's data migration tool I am receiving the following error... (see below). I have added sales_flat_quote to the source ignore document section. Yet I am still receiving ...
acctman's user avatar
  • 111
1 vote
2 answers
115 views

Where is customer_entity_static table in Magento?

while data:migration i get error Base table or view not found: 1146 Table customer_entity_static But there is no table with this name. Does anyone had similar problem with this table? Source: ...
SebastianT's user avatar
0 votes
1 answer
108 views

Data migration tool configuration

I've installed the data migration tool (https://devdocs.magento.com/guides/v2.4/migration/migration-tool-configure.html). Followed the steps to configure it by creating a separate module and ...
Marius's user avatar
  • 198k
1 vote
1 answer
44 views

Remigrate data to new M2 database

How can i remigrate data to new database after one migration? Workflow: Migrate data from M1 => M2. In M1 database new m2_cl tables created. Delete M2 table and try to migrate data from M1 one ...
SebastianT's user avatar
0 votes
2 answers
62 views

Migrating code & data from 1.9 to 2

Our site is currently running in PHP 5.4 with Magento 1.9. I want to migrate the site to the latest version of Magento along with PHP 7. We have created & used a lot of custom modules & using ...
Jayendhar P's user avatar
0 votes
1 answer
154 views

Data migration issue : SQLSTATE[23000]: Integrity constraint violation from maento 1.9 to magento 2.4.1

I am migrating the data from Magento 1 to magento 2.4.1 by running the following command php bin/magento migrate:data --reset vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.0.1/...
Jaisa's user avatar
  • 2,596
0 votes
1 answer
133 views

How to migrate product images before using Data Migaration tool from magento 1 to magento 2

I wish to migrate data from magento 1 to magento 2 using data migration tool. I know the procedure for migration using data migration tool. But i am having doubt on, how to migrate the product images &...
Jaisa's user avatar
  • 2,596
0 votes
1 answer
32 views

Data Migration Tool with splitted database

I would like to migrate data from my Magento 1 website to the new Magento 2 one. In the Magento 2 instance, I've splitted the database for performance reasons (https://devdocs.magento.com/guides/v2.4/...
WaPoNe's user avatar
  • 1,580
0 votes
1 answer
150 views

Customer Login not working after data migration From Magento 1.4.1 to Magento 2.3.3

I have migrated data from Magento 1.4.1 to Magento 2.3.3 using Magento Data Migration tool. Data has migrated successfully but Magento 1 customer login not working in Magento 2.3.3. I know there is a ...
Pritam Biswas's user avatar
1 vote
2 answers
332 views

Magento 2 - Data Migration Tool, unknown column store_id in customer_entity_varchar after data migration

I am trying to migrate a CE 1.9.4.5 site to CE 2.4.0 and have installed the data migration tool. I managed to migrate both Settings and data successfully. My orders, products, settings etc .. where ...
Prasanth M P's user avatar
0 votes
2 answers
583 views

Magento 2: Migrate changes made since last migration using non-live DB?

When we started development of our M2 project, we migrated all data to the new M2 project from M1. We did this using the Data Migration Tool. Because we did not want to mess with the live database, we ...
Louis B.'s user avatar
  • 1,112
0 votes
1 answer
196 views

Could not unserialize data of sales_flat_quote_item_option.value with record id 78558 Magento 2.3.5 Data Migration issue

[2020-08-11 14:35:47][WARNING]: Could not unserialize data of sales_flat_quote_item_option.value with record id 78558
Ravindrasinh Zala's user avatar
1 vote
0 answers
42 views

magento1 migrate to multiple magento 2 stores

Anyone knows what happen for all the migrate changes tables in m1, if I want to start migration to a new m2 store. E.g. I migrated m1 data to the first m2 store and all the deltalog tables (with ...
hln's user avatar
  • 125
1 vote
0 answers
40 views

Simple product not map into the Configurable product after migrate data from 1.9.2.4 to 2.3.5-p1

I'm trying to migrate data from 1.9.2.4 to 2.3.5-p1 with data-migration-tool but my configurable product didn't map with any simple product. How can i solve it???
Phuoc Le's user avatar
1 vote
0 answers
32 views

Migration from 1.9.3.x to Magento 2.3.5 issue multi-website data not migrate

I have migrated from Magento1.9.3.x to Magento2.3.5 after check multi-website data not convert. anyone, please guide how to check the issue. Thank You
Vishal Baraiya's user avatar
0 votes
1 answer
132 views

Customer and Orders empty after migration 1.9.2.1 to 2.3.5-p1

Im trying to migrate data from 1.9.2.1 to 2.3.5-p1 with the data migration tools but my table customer and orders remain empty ... The errors (who became warning with -a) are : [2020-06-30 06:11:28][...
tanguy belin's user avatar
1 vote
1 answer
172 views

Delta Migration: Integrity constraint violation: 1062 Duplicate entry

I have successfully done data migration. After migration, we placed order, create product and test everything. Now when we trying to run delta migration (also tried -a it is giving error like: Its ...
Pawan's user avatar
  • 5,846
0 votes
0 answers
44 views

Error When Install Data Migration Tool to Magento 2.3.1 with composer

I have run below commands with composer in Magento 2.3.1 and getting error like below. composer config repositories.magento composer https://repo.magento.com composer require magento/data-migration-...
Vamsi's user avatar
  • 107
1 vote
1 answer
143 views

Integrity constraint violation when reindexing after migration to Magento 2.3.5-p1

We are testing the migration of a store from Magento 1.9.4.5 to 2.3.5-p1 using the Magento Data Migration Tool (version 2.3.5). The migration completes without issue, however when reindexing on the ...
Chris's user avatar
  • 1,389
0 votes
0 answers
18 views

Migration from external db of Magento 1.X to Magento 2.X

can we use M1 db different it was earlier means suppose we migration m1_db.sql of a site in m2 but now we have another external db m1_db_1.sql different site's db and import this also into M2 will be ...
Magento Dev's user avatar
  • 1,264
0 votes
1 answer
83 views

After successful run of the magento data migration tool from 1.9.2.1 to 2.3.5-p1 orders do not display line items

I was able to get the Data Migration Tool to transfer our site's data and settings from v1.9.2.1 to v2.3.5-p1. There is one small problem that I can't figure out though. When I view orders on the ...
Don Moore's user avatar
1 vote
0 answers
184 views

Magento 2 - Data Migration Tool - Triggers

Intro Regarding the Data Migration Tool (M1 to M2), the migration creates m2_cl_ trigger tables that I can eventually run bin/magento migrate:delta will only update those triggered tables, or do they ...
CvRChameleon's user avatar
1 vote
1 answer
71 views

User registration error after migration

After Migration from Magento 1.9.2.4 to Magento 2.3.4 when I go to create a customer and fill all the information and click on submit(on front-end), it shows me an error We can't save the customer. ...
leitmotiv's user avatar
4 votes
1 answer
669 views

SQL error in [stage: data migration][step: EAV Step]: started

I have this issue where I get the following error in the [stage: data migration][step: EAV Step] In Mysql.php line 110: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an ...
Mike's user avatar
  • 323
0 votes
2 answers
938 views

Integrity constraint violation: 1062 Duplicate entry 'XXX-XXX' for key 'EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID'

Preconditions Migrating from Magento 1.9.3.10 Migrating to Magento 2.3.5-p1 using Data Migration Tool Steps to reproduce Run Settings migration as usual Run Data migration as usual Expected result ...
araujophillips's user avatar
1 vote
2 answers
360 views

Data Migration Tool [Connection refused] from AWS to Local dockerized enviroment

I'm trying to migrate my Magento 1 data from a DB located in AWS, to a Magento 2 in a local dockerized enviroment. When I run bin/magento migrate:settings -a -r -vvv app/code/Mymodules/Migration/etc/...
araujophillips's user avatar
2 votes
2 answers
2k views

Magento 2.3.5 - Data Migration - Products out of Stock Criteria (Configurable Products mostly)

Another issue regarding data migration from Magento 1.7.0.2 to Magento 2.3.5. Question: What are the conditions for products to display 'out of stock' in Magento 2? I am clearly missing something! ...
CvRChameleon's user avatar
1 vote
2 answers
244 views

Magento 2 data migration - MySQL versions (source/destination)

I have always migrated from a Magento 1 server database copy that is local and restored on MySQL 5.7 (on the same database host as my Magento 2 migrate database). I would usually use <...
CvRChameleon's user avatar
0 votes
1 answer
80 views

Data migration from 1.9.4.4 to 2.3.2 magento version

I want to migrate my data from 1.9.4.4 to 2.3.2. I am using data migration tool for this. I have installed it with no errors. But in /vendor/magento/data-migration-tool/etc/opensource-to-opensource, ...
XYZ's user avatar
  • 9
0 votes
1 answer
2k views

Magento 2.3: Parent Category page does not show any subcategory products after data migration

I just migrated from Magento 1.9 to Magento 2.3.4 and I have an anchor category that should be showing all the subcategories products, but somehow it does not show any of the subcategory products. ...
jojo's user avatar
  • 179
0 votes
2 answers
81 views

Migrating from Magneto 1 to Magento 2

I migrated all my settings, products etc from M1 to M2 recently. Our old site has while developing our new M2 site gained new customers and products. So what would happen if I choose to migrate my ...
Daniel's user avatar
  • 69
0 votes
0 answers
51 views

Is there any solution to transfer a partitular category and there sub category from magento 2 to another magento 2

I need to transfer a particular categories of products to another Magento 2 site with all the attributes image and all
Thankaraj J's user avatar
0 votes
1 answer
214 views

How to exclude order and customer data whilst migrating from Magento 1 to Magento 2?

How do I skip order and customer data whilst migrating from Magento 1 to magento 2? Magento 1 version : 1.9.2.4 Magento 2 version : 2.3.4
Hiren's user avatar
  • 1,091