Questions tagged [data-migration-tool]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
25 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 (...
0
votes
2answers
49 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 ...
0
votes
1answer
21 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 ...
0
votes
2answers
129 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 ...
0
votes
1answer
49 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-...
0
votes
0answers
49 views

Migrate Custom Module Magento 1.9.X to Magento 2.4.1

I have run the data migration tool for Magento 1.9.2.4 to M 2.4.1 All Magento's default tables data is migrated. Now I want to migrate data of custom modules of M1. I have followed the instructions ...
0
votes
1answer
30 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 ...
0
votes
2answers
40 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: ...
0
votes
1answer
44 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 ...
1
vote
1answer
24 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 ...
0
votes
2answers
41 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 ...
0
votes
1answer
61 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/...
0
votes
1answer
36 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 &...
0
votes
1answer
15 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/...
0
votes
0answers
53 views

Magento 1.9.4.5 - Dataflow Advanced Profiles - Add Category Names to Products Export CSV File

I have been beating my head against a wall for a few days now trying to figure out a workaround to Export all of my Products. I have around 6500 products currently and trying to use the standard ...
0
votes
1answer
33 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 ...
0
votes
0answers
30 views

Magento 2 data migration tool delta mode Delta delivering failed

I have migrated my store data from magento1.9.3.10 to magento2.3.3 1 month before using magento2 data-migration-tool, all know migration take months so client has updated their catalog in magento1.9.3....
0
votes
0answers
52 views

Data migration tool. migrate:settings error “Access denied for user 'root'@”

I try to migrate data around two local environments running on docker and they are set by expose: - "8080" - "3000" in docker-compose.yml When i starting: bin/console exec migrate:...
1
vote
2answers
150 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 ...
0
votes
2answers
95 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 ...
0
votes
1answer
74 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
1
vote
0answers
34 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 ...
1
vote
0answers
32 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???
1
vote
0answers
28 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
0
votes
1answer
73 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][...
1
vote
1answer
73 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 ...
0
votes
0answers
35 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-...
1
vote
1answer
85 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 ...
0
votes
0answers
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 ...
0
votes
1answer
54 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 ...
1
vote
0answers
76 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 ...
1
vote
1answer
31 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. ...
4
votes
1answer
476 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 ...
0
votes
2answers
353 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 ...
0
votes
2answers
157 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/...
2
votes
2answers
1k 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! ...
1
vote
2answers
134 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 <...
0
votes
1answer
52 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, ...
0
votes
1answer
596 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. ...
0
votes
2answers
48 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 ...
0
votes
0answers
27 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
0
votes
1answer
93 views

How to exclude order and customer data while migrating from magneto 1 into magento 2?

How to skip order and customer data while migrating from magneto 1 into magento 2 Magento 1 version : 1.9.2.4 Magento 2 version : 2.3.4
0
votes
2answers
87 views

Data migration tool [ERROR]: Integrity check failed due to “core_config_data” document does not exist in the destination resource

I'm starting with a blank M2 data with no extensions installed. Using the data migration tool from ce 1.9.3.1 to ce 2.3.4 with the following command php bin/magento migrate:settings --auto vendor/...
0
votes
1answer
127 views

After migration from magento 1 to magento 2. All customer page problem

After migrating from M1 to M2 everything seemed to function fine, but when I press the "All customers" page from backend, there is an exception. This is what it spit out: [2020-04-13 21:58:05] main....
0
votes
1answer
74 views

Allow tinytext in db_schema.xml magento 2

I'm doing a custom migration from Magento 1.9 to Magento 2.3.4 , in one of the custom module on Magento 1.9 it uses tinytext as table column type, therefore I tried to recreate this module using ...
0
votes
1answer
36 views

Document adminnotification_inbox can not be copied directly

while data migrating from magento 1.9.2.3 to Magento 2.3.4 with data migration tool, the error as shown in the screenshot is displayed. Could anyone please enlighten me on why it occurs and the fix ...
1
vote
1answer
294 views

: [WARNING]Mismatch of Datatypes Source Document. yotpo_rich_snippets. Fields: review_count

During the data migration from Magento 1.9.2.3 to magento 2.3.4 with data migration tool, this warning is displayed. Not sure if it is to be ignored or looked into. Please help me get to the root ...
0
votes
1answer
27 views

During the Data migration with Data Migration Tool, the following error as seen in the screenshot is encountered, Is it safe to ignore it

during the Data migration with Data Migration Tool, the following error as seen in the screenshot is encountered. Is it safe to ignore it.
0
votes
1answer
52 views

Foreign Key Constraint

the following error as seen in the screenshot came up during the data migration from M1 to M2 using data migration tool. Please share your views as to how I go about eliminating this error with a ...
1
vote
1answer
233 views

Migrating custom tables from M1

Data Migration Tool was used to migrate our Magento store from 1.9.2.2 to Magento 2.3.3 successfully. Upon inspection of the Magento 2 DB, I found out the custom tables weren't migrated which are 6 of ...