Questions tagged [data-migration]

The tag has no usage guidance.

131 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
1answer
281 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 ...
4
votes
3answers
2k views

Magento 2.1.7 customer login issue

when I try to log in as a customer to shop I got notice error: "An unspecified error occurred. Please contact us for assistance." When I register as a new customer to shop it seems to work ok - ...
3
votes
0answers
54 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?
3
votes
1answer
171 views

Magento 2: Data migration Class error

I tried to migrate data from Magento 1.9.2.2 to Magento 2.2.2 for testing. I am getting below error [2018-02-14 11:45:37][INFO][mode: data][stage: volume check][step: EAV Step]: started 100% [====...
3
votes
0answers
1k views

The element 'product.info.options' already has a child with alias 'text' - Magento 2.2.0

After data migration (1.9.1 CE - 2.2.0 CE) I got the below error when I click add to cart button in magento 2 we can't add this item to your shopping cart right now I did research about this but ...
2
votes
0answers
23 views

Data migration: “Init vector must be a string of 16 bytes” due to old weakly encrypted data in the database - what to do?

I'm migrating a Magento 1 store to Magento 2.3.4 and I'm encountering an error at the data migration "Map Step". In Mcrypt.php line 81: [Magento\Framework\Exception\LocalizedException] Init ...
2
votes
0answers
639 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: ...
2
votes
1answer
25 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 ...
2
votes
0answers
71 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
0answers
151 views

Store is not found+Data Migrating From M1.8.1.0 To M2.2.4

Step 1:- php bin/magento migrate:settings --auto vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.8.1.0/config.xml It's working fine for me. Step2:- php bin/magento migrate:data --...
2
votes
1answer
202 views

Data migration tool : How can i use time zone handler for order purchase time for magento 1 server on IST timezone

I use the tool for migrate my data from my 1.9.2.4 to magento2.2.2 It works except a problem with date of purchase. There is a difference of 5:30 hours, however the time zone on M1 Server is IST (...
2
votes
1answer
371 views

Magento2 - when customer Sign Out then error occurred: “No such entity with id = 0”

After data migration process I fetched one problem. Problem is when customer Sign Out from the account then this error occurred, No such entity with id = 0 When I refresh the page again then ...
2
votes
0answers
242 views

Data Migration From Magento 1.9.1 to 2.1.9

I am using magento data migration tool. I followed http://devdocs.magento.com/guides/v2.3/migration/migration-migrate-data.html [PDOException] SQLSTATE[23000]: Integrity constraint violation: ...
2
votes
0answers
70 views

Magento 2 data migration error ConfigurablePrices step mismatch of entities:catalog_product_entity_decimal

I'm migrating data from M1 v1.8.0.0 to M2 v2.2.0, and receiving this error at the volume check for ConfigurablePrices: [2018-01-08 05:56:59][INFO][mode: data][stage: data migration][step: ...
2
votes
1answer
241 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. ...
1
vote
0answers
18 views

Can I use a different DB with my Magento 2.3.5?

I have done some work on a site, basically theme, graphics, content and such. I want to keep that work without losing it but I need to use a different database. The current one got corrupted when ...
1
vote
0answers
11 views

Different language code for Magento 1.9 to Magento 2.3 migarion

I have a multi store in my magento 1.9 and i successfully migrated to Magento 2.3.4 one of my stores have language code and store code set to zn_HK in my Magento 1.9 , but in Magento 2.3.4 there is no ...
1
vote
1answer
37 views

Magento2 - Destination fields are not mapped. Document: paypal_settlement_report_row. Fields: store_id

I tried to do migration from Magento1.9.3.8 to Magento2.3.4, when I ran the Magento Data migration tool I always got this error: Destination fields are not mapped. Document: ...
1
vote
0answers
28 views

language translation and migration

I've used the data migration tool to move from magento 1.6.2 into magento 2.2.7 I've some issues (mainly on backend) where it seems as if magento doesn't properly put text, instead it displays curly ...
1
vote
0answers
72 views

Magento2.3.3 Facing Error during Data migration

I am trying to migartion from Magneto1.9.3.10 to Magento2.3.3 but I am facing error during [Eav Step] data migration like: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does ...
1
vote
1answer
71 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
72 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
0answers
139 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
0answers
186 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
208 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
63 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
40 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
49 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
0answers
75 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
0answers
126 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 ...
1
vote
0answers
284 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 ...
1
vote
1answer
316 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
43 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
0answers
26 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 ...
1
vote
0answers
207 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
34 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
391 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
699 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 ...
1
vote
0answers
20 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 ...
1
vote
0answers
639 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 ...
1
vote
0answers
61 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 ...
1
vote
1answer
122 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 ...
1
vote
0answers
83 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 ...
1
vote
1answer
263 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 "...
1
vote
0answers
807 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/...
1
vote
0answers
141 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 ...
1
vote
0answers
24 views

Importing Only Customers and Orders after Site is Complete

Is it possible to migrate only Customers and Orders part, if I modify map files if rest of the website is complete? or will it through error in that case.
1
vote
1answer
203 views

Data Migration Tool - Messes up Products on Frontend 1.9.2.4 to 2.2.4

I'm trying to migrate the customers and orders only from 1.9.2.4 to 2.2.4 for Magento. I have edited the config.xml and the map.xml. However, whenever I run the migration the products in my 2.2.4 are ...
1
vote
0answers
384 views

data migration stage - step: map step

I'm trying to migrate and got the following: [2018-06-17 01:19:50][INFO][mode: data][stage: data migration][step: Customer Attributes Step]: started 100% [============================] Remaining Time:...
1
vote
1answer
69 views

Magento 2.2 adminside products edit getting error

After Data migration from Magento 1.9.1.1 to 2.2 admin side products edit getting the error. Warning: Invalid argument supplied for foreach() in /var/www/html/new/vendor/magento/module-catalog-...