Questions tagged [data-migration]

The tag has no usage guidance.

4
votes
0answers
92 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
0answers
54 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
127 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
0answers
105 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
0answers
126 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% [====...
2
votes
0answers
174 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
59 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
0answers
505 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 ...
1
vote
0answers
23 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
0answers
73 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
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 ...
1
vote
0answers
400 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
42 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
0answers
64 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
72 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
0answers
83 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
23 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
0answers
313 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
0answers
102 views

Magento2 data migration Map Step error

While migrate the data from Magento 1.14.2.2 to Magento 2.2.3, I'm getting the below error. PHP Fatal error: Uncaught TypeError: Argument 1 passed to Migration\Step\Map\Data::getRecordTransformer() ...
1
vote
0answers
87 views

Indexing Issue after Update Magento 1 to Magento 2

After I had migrated my website from magento 1.9 to magento 2.1, Everything is working fine except for a few bugs i get this while running php bin/magento indexer:reindex SQLSTATE[23000]: ...
1
vote
0answers
180 views

Associated simple products not showing in configurable product

In my magento2.1.5 (migrated from magento1.9) store, some configurable products are not showing any associated simple product in both admin and front-end. I need to set the simple products again in ...
1
vote
0answers
375 views

Magento 2: 'Tax Class' is not showing in products from admin panel

After migrating data from Magento 1 to Magento 2, i can not see 'Tax Class' attribute from admin panel while editing a product. 'Stock Status' attribute is also missing. But when i create new product, ...
1
vote
0answers
214 views

Mismatch of entities in the document during migrate:data

I can see successfully migrate all the data except this warning is occuring "Mismatch of entities in the document" for some tables like, catalog_category_entity_text, catalog_category_product_index, ...
1
vote
0answers
642 views

Warning: imagecreatefromjpeg(): gd-jpeg, libjpeg: recoverable error: Premature end of JPEG file in /vendor/magento/framework/Image/Adapter/Gd2.php

Recently I have migrated the magento-1 (ver: 1.9.1.1) data to magento-2 (Ver: ver: 2.1.2) fress version using data migration tool. And it working perfectly in our local computer (localhost). I found ...
0
votes
0answers
13 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
0answers
12 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
24 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 $...
0
votes
0answers
16 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
0answers
53 views

Can we delete stores and orders before delta migration

We have a multistore site for which data is migrated from Magento 1 to Magento 2. We need to clean the database for some stores which are not active now. As the stores that we want to delete are not ...
0
votes
0answers
125 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
0answers
58 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 ...
0
votes
0answers
25 views

Magento 1.9.3.10 to 2.2.3 Easiest Method?

Current Magento poduction version of Magento-1.9.3.10 and have a free domain that I can use to setup and test / staging version Magento2.2.3. I'm confused to the best method to migrate version ...
0
votes
0answers
19 views

Magento Migration 1.9.2.2 to 2.2.6 Requested site not found error after settings migration

I have a Magento site running 1.9.2.2 I planned to migrate to most recent version using the data migration tool provided by Magento and followed the steps given in documentation. I was able to migrate ...
0
votes
0answers
51 views

Magento 2 data migration how can i migrate customer custom attribute value

How can i migrate customer custom attribute value, i just gone through document but i did't find the proper solution.
0
votes
0answers
67 views

Magento Data migration Document has ambiguous configuration: sales_flat_order

i am getting this error "Document has ambiguous configuration: sales_flat_order" while data migration
0
votes
0answers
225 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/etc/...
0
votes
0answers
261 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 <...
0
votes
0answers
25 views

Using UB Data Migration tool

I am trying to use UB Data Migration Lite - 1.0.6. In this regard I am getting below error.
0
votes
0answers
89 views

Magento 2 data migration error like Source fields are not mapped.?

Magento 2 data migration i got an error like below image followed below answer but again faced an issue Source fields are not mapped - migration error is there any other solution?
0
votes
0answers
100 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
0answers
15 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?
0
votes
0answers
109 views

Magento 1.9.1.0 ce to 2.2.5 ce Migration Transform Data Type From TinyInt to SmallInt

I am working through a data migration profile for a large site. I'm currently mapping fields from modules and converting eav attributes. I have come across the error: [WARNING]: Mismatch of data ...
0
votes
0answers
43 views

How to Migrate two different Magento 1 instances to Magento 2?

I have two different instances of Magento 1 sites. It means different backends and DB. But the features are the same, the Theme is also the same. It makes sense for me to migrate both as different sub ...
0
votes
0answers
314 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 ...
0
votes
0answers
147 views

Source documents are not mapped error during Data Migration Magento2

I am using Magento2 Data migration tool and followed the instructions Used below command to migrate settings. php bin/magento migrate:settings --reset < path to your config.xml > It is done ...
0
votes
0answers
44 views

Magento 2.2 search leading to var/log/report entry

when I try the search engine on my magento 2.2 front office, I have the following error : General error: 1191 Can't find FULLTEXT index matching the column list, query was: INSERT INTO `...
0
votes
0answers
15 views

Migrate Product Data from Magento 2.1.6 to Another Store 2.2.4 the right way

I wanted to know which is best way to Migrate only the products quickly, from one store to another store. Can it be done via Exporting the catalog tables from the existing store to the new store ...
0
votes
0answers
461 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
60 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
0answers
65 views

Migration: Magento CE 1.7.0.2 to Magento 2.2.0 CE

Migration process breaks due to below error: [system.db.CDbCommand] CDbCommand::fetchAll() failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.catalog_product_website' doesn't ...