Questions tagged [data-migration]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
5
votes
1answer
2k 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
61 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
1answer
100 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
186 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
321 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
1answer
118 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
150 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
173 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
183 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
82 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
1answer
79 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 ...
6
votes
1answer
240 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 ...
2
votes
2answers
2k 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
247 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
414 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 ...
1
vote
0answers
688 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/...
0
votes
1answer
76 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.
4
votes
2answers
1k 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
1answer
670 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 <...
1
vote
0answers
138 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
97 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
1answer
62 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
2answers
365 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
42 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
434 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
89 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
259 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 ...
0
votes
2answers
2k views

Element 'block', attribute 'class': 'about-us' is not a valid value of the atomic type 'blockClassType'

I migrated M1 data to M2 using ubertheme data migration pro. When I install a theme to my site and load the home page, I am getting the following exception: 1 exception(s): Exception #0 (...
2
votes
1answer
450 views

How can we insert new records in magento2 db using sql queries [closed]

Let us know the exact way to import bulk data to DB using queries.
2
votes
0answers
69 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
1answer
230 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. ...
0
votes
1answer
255 views

Magento 2.2.5 Data Migration Tool

I am having the below 2 issues, I disabled the EAV Step, only to be hit with another error (the EAV Step issue) I am using a fresh Magento 2 database to test this, I am using Magento migration tool 2....
1
vote
1answer
421 views

Magento1 to Magento2 data migration

I am new to Magento2, I need some guidance from magento geeks for migrating data from magento1 to magento2. Quick Overview I received a system that was built in magento2 from scratch. So I think ...
1
vote
1answer
83 views

Is there any option to migrate only orders from magento1 to magento2?

My scenario is : I have migrated all data from Magento1 to Magento2 using live DB backup. So I could not use delta migration for the incremental changes. But I need to migrate the newly created orders ...
0
votes
0answers
20 views

Can we import huge amount of data through insert statements in sql queries in magento2?

We need to import huge data to magento database. Can anyone suggest me how can we achieve this through sql queries?or is there any standard approach other than code changes?
2
votes
3answers
2k views

Magento 2 SHA1 Password is not Accepting after Migration

I have Migrated Magento 1.9.1.0 website in Magento 2.2.4,all data is migrated successfully. When I am trying to login from front-end with existing old customer(Magento1) it generating error "You did ...
0
votes
0answers
425 views

Column not found: 1054 Unknown column 'catalog_product_entity_varchar.ebay_template_new' in 'field list'

I have migrated data from Magento CE 1.9.2.0 to CE 2.2.5 Migration is successfully for data of old Magento 1 to latest Magento 2 version. While I am trying to save the product from admin or ...
2
votes
0answers
150 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 --...
0
votes
2answers
252 views

Getting “Could not read config file” error during product save

I've Migrated Magento1 to Magento2.2.5, when I updated a product either changing any field or not then getting "Could not read config file" error:- Please visit on below screenshot for the same :- ...
0
votes
5answers
1k views

Data Migration error In magento 2 intergrity constraint violation : duplicate entry :1-Migration_Default

Error : SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-Migration_Default' for key 'EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME' I reinstall the setup with a fresh ...
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.
0
votes
1answer
197 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
379 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:...
0
votes
3answers
1k views

Magento 2.2.3: Merging error in data migration tool

Acutally, We migrated our data once but now most of development has done. So, i need to merge new data in existing database. I fired migrate:delta command but gives error: Deltalog for customer_entity ...
1
vote
1answer
68 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-...
0
votes
1answer
160 views

After M1 to M2 migration, Checkout page blank (only logo is showing)

I've migrated from Magento 1.9.3.4 to Magento 2.1.8 but when I goto checkout page (after adding a product to cart) it shows empty page, the only logo is showing, while other pages are fine. ...
0
votes
1answer
835 views

Exception #0 (Exception): Item (Magento\Catalog\Model\Product\Interceptor) with the same ID “217” already exists

This Error is coming on Magento 2.2.3 frontend after Migrating the data from Magento 1.9 Exception #0 (Exception): Item (Magento\Catalog\Model\Product\Interceptor) with the same ID "217" already ...
0
votes
0answers
70 views

During Data Migration Getting Access Violation Issue

During data migration from Magento1 to Magento2, I'm getting the following issue:- SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual ...
0
votes
1answer
430 views

Issue:- Incompability in data issue Source document: eav_attribute_group. Field: attribute_group_name. Error:

During Magento1.9.3.4 to Magento2.1.8 Migration Getting following issues :- Incompatibility in data. Source document: eav_attribute_group. Field: attribute_group_name. Error: The product attribute ...
0
votes
1answer
1k views

Magento2 - Category Filter not working with Amasty Layered Navigation after Magento2 Migration (2.2)

Category Filter not working with Amasty Layered Navigation after Magento2 Migration (2.2). Others attributes filter working fine except category.