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 ...
- 669
20
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&...
- 2,236
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 ...
- 386
6
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
- 36.1k
6
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 ...
- 1,306
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 ...
- 5,454
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 ...
- 2,470
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 ...
- 123
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 ...
- 3,570
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
- 1,286
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 ...
- 6,450
4
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;
...
- 812
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!
- 813
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....
- 1,705
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 ...
- 455
3
votes
Accepted
Is it possible to copy all customer related data migrate to another magento 2 database?
As I understand your question, you want to copy the basic information of customers (with their addresses) from one Magento installation to another one.
To do this, you don't need to dig into the ...
- 10.2k
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 ...
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 ...
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 ...
- 199k
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
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 ...
- 810
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
*/
...
- 688
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 ...
- 277
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.
- 91
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 ...
- 6,166
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 ...
- 990
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 .
- 149
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
...
- 3,018
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 ...
- 1,160
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 ...
- 812
Only top scored, non community-wiki answers of a minimum length are eligible