Magento 2.3 - How to update Migrated Data?

[Aveeva]

I already migrated Magento 1 data to Magento 2.3.4, during development we got few orders placed in Magento 1 as well as new customers registered in Magento 1. How to update the migration data i mean how to sync as per date data to Magento 2.3.4? Is any advice for this case?

[Nishu Jindal]

Hi @Aveeva ,

For Migrate the latest data which comes on the website after the migration process, we can use Delta Migration.

While MIgration, Data-migration-tool creates some views which keep track of the data which has been migrated and which are new.

For better understanding about delta migration check below link:

https://magento.stackexchange.com/questions/194359/best-plan-about-delta-migration

Hope it helps you!

Problem Solved! Click Kudos & Accept as Solution!

[Bhanu Periwal]

Hi @Aveeva 

Kindly refer below link for migrate new orders after migration:
https://devdocs.magento.com/guides/v2.4/migration/migration-migrate-delta.html

It may help you to resolve issue.

It issue resolve, please click on 'Kudos' & Accept as Solution!

[Aveeva]

@Bhanu Periwal  If run "php bin/magento migrate:delta vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.2.3/config.xml " getting the following error. SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes. How to solve this?

[Nishu Jindal]

Hi @Aveeva ,

To solve this issue, please follow the below steps:

1. connect to your database in SSH.

2. Run command: show variables like 'max_allowed_packet';

3. set global max_allowed_packet=33554432;

4. exit from the database.

5. Connect to DB again to check new value.

6. Run the Delta migration command again.

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!

[Marcus - LitExtension Expert]

Hi @Aveeva,

There are two main ways that you can use to migrate recent data from your Magento 1 store to the new one. 

The first method is using Magento Data Migration Tool to sync recent data to your new store. You can refer to this link for more detailed information of the process.

Otherwise, you can also use data migration service to transfer your recent data automatically and quickly. You will be able to select what entities you want to migrate including products, customers, orders, passwords, SEO URLs etc. and try free demo before performing the full migration. 

Hope this can help you! Let me know if you need further assistance. 

_____________

If issue solved, Click Kudos & Accept as Solution.

[Aveeva]

@Nishu Jindal  After successfully updated memory limit then run

php bin/magento migrate:delta vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.2.3/config.xml

I am getting the following error, 

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '4799  
  0-1' for key 'CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID' 

FYI the table CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID not exits in DB.

[Nishu Jindal]

Hi @Aveeva ,

For delta migration few points needs to be considered.

1. Hope you haven't added any new entries in magento 2 database after migration (customers, products etc.)

2. Check below solution for your issue

 This was occurred due to the inconsistency into database tables.

cataloginventory_stock_item
catalog_product_entity

I have removed the all inconsistency data using below query:

DELETE FROM cataloginventory_stock_item where product_id NOT IN (select entity_id from catalog_product_entity)

You can check how much records before perform the delete.

select count(*) from cataloginventory_stock_item where product_id NOT IN (select entity_id from catalog_product_entity)

Please take backup before doing any operation on database.

Hope this helps you!

Problem Solved! Click Kudos & Accept as Solution!

[Aveeva]

@Nishu Jindal  If i run following command 

select count(*) from cataloginventory_stock_item where product_id NOT IN (select entity_id from catalog_product_entity)

Value return 0, shall i processed delete command?

[Nishu Jindal]

Hi @Aveeva,

If there is no record then there shouldn't be any effect after delete command as well.

Can you please try do reindexing and check whether it completed successfully or not.

Thanks!