21 votes
Accepted

Best plan about delta migration

Here are some Delta migration General understanding Data Migration Tool migrates data created only by Magento's own modules (eg. Orders, Customers Profile) and is not responsible for the code or ...
user avatar
18 votes
Accepted

Warning: Error while sending QUERY packet. - Magento Migration

Please try below changes in config.xml file at location magento/data-migration-tool/etc/opensource-to-commerce/1.9.3.3. I have faced same issue and below changes fixed my issue. <bulk_size>100&...
user avatar
  • 2,116
6 votes
Accepted

Data MIgration failed

If you are choosing data-migration tool of magento. Go to your magento2->vendor->magento->data migration tool. Hope you done the config.xml setup.Inside config.xml change class-map.xml.dist to ...
user avatar
  • 346
5 votes
Accepted

Magento1 to Magento2 data migration

Please check following steps for DATA MIGRATION FROM MAGENTO 1 to MAGENTO 2 Setup m1 database and setup m2 project Before start migration please install fresh magento, Also put magento1 database and ...
user avatar
  • 5,244
5 votes

Magento 2 Argument 1 passed getProductFromLocalCache() must be of the type string, null given, called

There is some blank SKU save into admin section so you need to change status for that. UPDATE **prefix_**catalog_product_entity SET sku='' WHERE sku IS NULL; Just run above query using you prefix if ...
user avatar
  • 1,246
4 votes

Migrate Magento EE 1.14.3.1 to Magento CE 2.1.7

The Data-migration-tool does not come with such functionality out of the box (and I guess it won't ever have) for obvious reasons not to mention the advantages and features you will loose if you ...
user avatar
  • 2,265
4 votes
Accepted

magento 2 data migration tool ignore table by mask

today I found a solution. It's works for me. <ignore> <document>old_*</document> </ignore> In my DB I have a lot of tables like "old_widget_instance_page_layout" and I ...
user avatar
4 votes
Accepted

Magento 2. Migration. Map customer attribute

There is not direct way to map an attribute with a given attribute_code from Magento 1 to another with another attribute_code from Magento 2. If both attributes have the same attribute_code an ...
user avatar
4 votes
Accepted

I am getting 'Unable to unserialize value' while editing a customer in magento 2.2

It was a 3rd party extension issue I found this solution helpful. https://magento.stackexchange.com/a/257393/70848
user avatar
4 votes

Magento1 to Magento2 Migration Process Step

Install Data Migration Tool 1) Check your Magento 2 version :- sudo php bin/magento --version 2) Install Data Migration Tool from repo.magento.com :- composer config repositories.magento ...
user avatar
  • 5,666
4 votes
Accepted

Migration magento 1 to magento 2 error

I have fixed it by run command line: php bin/magento setup:upgrade php bin/magento setup:static-content:deploy -f Hope it will help someone!
user avatar
4 votes
Accepted

Magento 2 Argument 1 passed getProductFromLocalCache() must be of the type string, null given, called

For affected product has no SKU. Add SKU for that product this error will be fixed. You can update directly from MySQL, the table name is: catalog_product_entity
user avatar
  • 34.4k
3 votes

magento 1 to magento 2 data migration issue

First take a backup of your Magento1 database. Please remove orphans record from your Magento1 database. after you solve Foreign key error. Remove 121,164 attribut_id row from catalog_eav_attribute....
user avatar
3 votes

Magento 2.2 data migration Duplicate store_group_name Entries

Magento 2 has new field 'code' in store_group table and it is automatically created from magento 1 store name.So it seems you have a duplicate store name in magento 1 First try to make the store name ...
user avatar
3 votes

Is it possible to copy all customer related data migrate to another magento 2 database?

All Customer Data Including Logs In This Table : customer_address_entity; customer_address_entity_datetime; customer_address_entity_decimal; customer_address_entity_int; customer_address_entity_text; ...
user avatar
3 votes

Magento 2 Data Migration time difference?

If your Magento 1 server has the time zone set to anything other than UTC, you must configure the offset to migrate timestamp fields. To transform time to a different time zone, use the Data Migration ...
user avatar
3 votes
Accepted

Magento2 Migrated custom customer attribute is not saving the value

After checking multiple things and digging down the database finally I found the issue, hence sharing the answer. The issue was after the migration the entry was missing in the eav_entity_attribute ...
user avatar
2 votes
Accepted

Magento 2 single store mode still exports products for both store views?

This is normal behavior. Single store mode can be enabled if you only have 1 store view. And this is a way to remove some store selection fields from different admin screens. If you have 2 or more ...
user avatar
  • 196k
2 votes
Accepted

Migration error Magento 1.9.3.2 to 2.1.8

Here you can find the answer i followed below link you can go through this. Go Through This Link
user avatar
2 votes

What are m2_cl tables in magento?

Tables starting from m2_cl are not default tables for Magento 1.9 version but they are created while using Magento data migration tool. They are basically deltalog tables. More details can be found ...
user avatar
2 votes

Magento 2 : How can i read Xml file data

You can try this way : namespace Vendor\ModuleName\Model; class ParseXmlClass { /** * @var \Magento\Framework\Module\Dir\Reader */ ...
user avatar
2 votes

Error while executing migration - Magento 1 to Magento 2

This error goes away when the data migration tool is installed using composer. I debugged bit deeper into this error and found that the module's code of adding its shell commands are not working ...
user avatar
2 votes

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

Root category anchor attribute need to be set "Yes". You can do this from the Admin => CATALOG => Catagories => Display Setting and set Anchor to Yes.
user avatar
  • 81
2 votes

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

Write custom MYSQL query without using Model Here is example how to write custom mysql query in Magento2. Suppose we have table employee with fields emp_id, emp_name, emp_code and emp_salary. Now ...
user avatar
  • 5,876
2 votes
Accepted

How to manually import/migrate orders & customers from Magento1 to Magento 2 database tables?

so I was able to migrate the customers and orders into the magento 2 again, without needing to use the delta migration step, nor empty the existing magento 2 orders/customers. I think it just ...
user avatar
2 votes

Data Migration > Eav step error

This error comes when we run migration command 2nd time on same database. kindly remove the database and again use fresh database and then do all the setting. Run migration command .
user avatar
2 votes
Accepted

Data Migration not procceds after Map Step

After Debugging at file :vendor/magento/data-migration-tool/src/Migration/Step/Map/Data.php Print Source table name and destination table find that issue with ...
user avatar
2 votes

Data Migration not procceds after Map Step

I realise you found the problem that was responsible in your particular case, but I thought I'd add an extra answer here, as my team had the same symptoms but a different explanation. Hopefully this ...
user avatar
  • 1,131
2 votes

Migrate Static Blocks and multi stores from One Magento to Another

All CMS pages and static blocks are saved in the following 4 tables: cms_page cms_page_store cms_block cms_block_store Hence, if you need to copy the content, just simply export data from these ...
user avatar
2 votes

Migrating data from Magento 2.1 to Magento 2.3 on a new server

Please check all below steps: First off all download database from old server and import to the new server. Then download all files from old server to transfer the magento root files to the new ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible