The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [data-migration]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

How to migrate Product custom options records from magento 1.7 to magento 2.x in product edit, order, invoice,Shipment and Credit memo?

I looking for the migrate Product custom options records from magento 1.7 to magento 2.x I have have migrated all the data from magento 1.7 to magento 2.2.6, but custom options not showing.
1
vote
1answer
25 views

Magento 2 Reorder functionality missing for migrated orders

We have migrated customers and orders data from M1 (1.14.3.1 EE) to M2 (2.3.1 commerce) successfully But when we are doing testing at the admin end for the orders found that the Reorder button was ...
3
votes
1answer
31 views

What is use of direct_document_copy in data migration config.xml

I have recently migrate M1 DB to M2 DB there is option in config.xml called direct_document_copy <!-- Set direct_document_copy = 1 for better performance. NOTE: 'source' and 'destination'...
1
vote
1answer
22 views

Magento 1 to 2 data migration issue: “cart price rules” are missing website and group selection from Magento 1

After migrating data from magento 1.6.2 to magento 2.3.2 the shopping cart price rules are missing the website and groups selection. For some reason the first 4 shopping cart price rules are not ...
1
vote
0answers
46 views

How migrate products from Magento database 1.9 to 2.3.2?

I migrate data from Magento 1.9 to Magento 2.3.2, after that customer adds new products to 1.9, so I'm in trouble. I have a database with new products that were added at Magento 1.9, but I don't know ...
1
vote
2answers
44 views

Magento 2 Data Migration time difference?

We have migrated M1 customers and orders from M2.3.1 successfully with the datamigration tool but we are facing some discrepancy with the time differences. The best example is customer create_at &...
1
vote
4answers
54 views

Magento 2 data migration triggers table missing in M1

We have successfully migrated data from M1 to M2 using the data migration tool. We have a custom table called md_cybersource which is mapped to magedelight_cybersource in map.xml When we run delta ...
1
vote
2answers
58 views

Magento2.3.2 During data migration I got Only enties mismatch error . Only orders data in not migrated

My migration is from Magento 1.9.1.0 to Magento 2.3.2. I ran the below command : php -dmemory_limit=-1 bin/magento migrate:data vendor/magento/data-migration-tool/etc/opensource-to-opensource/1....
1
vote
0answers
36 views

Magento 2 migration issue with payment transaction id

We are able to migrate data successfully with sales payment transaction table. map.xml <transform> <field>sales_payment_transaction.additional_information</field> ...
1
vote
2answers
30 views

disable or remove foreign keys during upgrade

During upgrade from v1.5.1.0 to v1.6.0 it is trying to drop a key but can't because of a foreign key. relevant lines in update script $installer->getConnection()->dropIndex( $installer->...
1
vote
0answers
26 views

Magento 2: After migration, Customer reindex is not working

This is the issue I face on indexing from terminal. column 'created_in' used in key specification without a key length, query was: CREATE TABLE IF NOT EXISTS `customer_grid_flat` Kindly help me to ...
1
vote
1answer
33 views

Data migration tool auto add prefix

When I launch data migration tool, I encounter the following error : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'm1.prefix_core_directory_storage' doesn't exist ... My old magento don'...
1
vote
1answer
33 views

Categories mapping when migrate from Magento 1 to Magento 2

Can anyone tell me whether it's possible to have a migration with categories mapping on migration for magento 1 to magento 2 and how can I do this?
3
votes
1answer
41 views

Magento 2: No data migration tool matching version

My Magento version is 2.2.9. No matching data migration tool exists. What should I do? Should I install Magento version 2.2.7?
1
vote
1answer
35 views

Attribute set is missing after upgrade to magento 2.2.9 from 2.2.6 which is migrated website from magento 1.x

I had migrated Magento 1 website to Magento 2.2.6, so after some days i had upgraded my Magento version to 2.2.9, after upgrade i can see that my attributes sets are missing and when i checked into ...
1
vote
0answers
17 views

Magento 2 data migration custom handler?

We are working on data migration using Magento 2 data migration tool. We would like to know how to write a custom handler for customer Id (or) product id. Could you please advise did any work on this....
1
vote
1answer
31 views

Magento 2 - indexer error after data migration magento 1.9.1.1 to 2.3.2

I'm trying to migrate data to magento 2 using the data migration tool, the migration goes fine but the indexor crash during catalog_product_price index with the error : SQLSTATE[42000]: Syntax ...
1
vote
2answers
44 views

Magento 2 - Mirasvit RMA data migration from M1 to M2

We have migrated products, customers and orders details from M1 to M2 using https://devdocs.magento.com/guides/v2.3/migration/migration-tool-install.html now we would like to migrate RMA Mirasvit data ...
1
vote
0answers
71 views

Can I migrate from Magento 1.9 to 2.0 when my site crashed?

My site on Magento has crashed, then the next day my hosting company said that there was an error somewhere with coding so I'm thinking now is the time to move from Magento 1.9 to 2.0. I set up the ...
1
vote
1answer
58 views

How to migrate email templates only from M1 to Magento 2?

We have installed migration tool in Magento 2.3.1 EE (composer require Magento/data-migration-tool:2.3.1 ) would like to migrate M1 commerce edition (1.14.3.1) to Magento 2.3.1 EE. We have migrated ...
1
vote
0answers
36 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 ...
2
votes
0answers
174 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
16 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
69 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
22 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
61 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
31 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
32 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
50 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
75 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
22 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
0answers
40 views

Migrate data from 3 websites to one multisite

We have 3 separate website instances in Magento 1. We want to migrate these 3 websites to Magento 2 and make them as multiple stores in a single instance. One approach would be to make the 3 websites ...
0
votes
0answers
18 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
1answer
77 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 ...
3
votes
1answer
45 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
0answers
23 views

Magento2 product migration issue

I am facing a very strange issue on Magento 2.2.7 I have migrated products from Magento 1 to 2. When I try to save and duplicate on the product page the process will become infinite and some time ...
0
votes
1answer
34 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
65 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
36 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
14 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!
0
votes
0answers
62 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
28 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
135 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
245 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
21 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
375 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
19 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
302 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
58 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
516 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 ...