Hi Support,
I have migrated data from M1 to M2. But order item is not showing for some orders.
https://tinyurl.com/yj47mg3l
Thanks
Dinesh
17 answers
Hi Dinesh,
I have migrated data from M1 to M2. But order item is not showing for some orders.
https://tinyurl.com/yj47mg3l
That is strange. Did that issue happen on some migrated sales orders only?
It seems that these sales order had bad or special of data settings in M1 only. Did you see the ‘ordered items’ information of these sales orders in M1?
Could you check this in M1 again and then provide me some screenshots or a captured video on that information?
Regards,
Mall.
Hi Support,
in M1, the Order item is showing. https://tinyurl.com/yf83pm2h
Thanks
Dinesh
Hi there,
in M1, the Order item is showing. https://tinyurl.com/yf83pm2h
So, the issue you mentioned is strange.
What is the version of our module in your instance?
Please try run delta migration in step #7 of our module by run the CLI command below:
php -f bin/ubdatamigration run --step=7 --mode=update;
And then, recheck the issue you mentioned again.
Regards,
Mall.
Hi Support,
I have run the command but it is still not showing
Thanks
Dinesh
Hi Dinesh,
I have run the command but it is still not showing
That is strange. Please provide me information about your instance:
- URL and Admin credentials of your M2 instance
- SSH credentials of your M2 instance
- Let me know the path to the M2 folder
- phpMyadmin URL that allows me to view your M1 and M2 databases
- Sales Order IDs which had the issue you mentioned
I will help to check further and get back to you then.
PS. Please make sure you mark your reply private or simply switch this ticket to the private mode, then it’s safe to share your site info here. Only you and our technical team can access it.
Regards,
Mall.
Hi Support,
Then what is the solution to this issue? what do I need to fix this issue
Thanks
Dinesh
Hi Dinesh,
Then what is the solution to this issue? what do I need to fix this issue
Please give me a bit more time. I need to detect the bad ‘serialize’ string as I mentioned in the reply #8 and find a workaround to handle that case.
I will get back to you then.
Regards,
Malll.
Hi Dinesh,
To handle the case of the ‘serialize’ string as mentioned in the reply #8, I have added new tweak code in our module at the PHP file: pub/ub-tool/protected/models/UBMigrate.php.
Now, you can run delta migration in step #7 with the ‘update’ mode by running the CLI command:
php -f bin/ubdatamigration run --step=7 --mode=update;
Once done, please check the issue you mentioned again.
Regards,
Mall.
Hi Support,
In sales rule table there is too many records and it will take much time in update, is there anyway to skip salesrule for testing purpose.
Thanks
Dinesh
Hi Dinesh,
is there anyway to skip salesrule for testing purpose.
You can try these steps:
1. Open the PHP file at: pub/ub-tool/protected/controllers/Step7Controller.php
and find the code line:
if (in_array('rule_coupon', $selectedSalesObjects)) {
and replace it with:
if (!in_array('rule_coupon', $selectedSalesObjects)) {
(Note: That change is only for the testing purpose as you want)
2. And then, you can run delta migration in step #7 without migrating the sales rule data section.
Regards,
Mall.
Hi Mall,
Our data migration is too slow. We checked the server configuration and found that our server configuration is fine. can you please suggest what should we do to speed up the migration?
Thanks
Dinesh
Hi Dinesh,
Our data migration is too slow. We checked the server configuration and found that our server configuration is fine.
I checked via phpMyadmin that you shared and saw that you already finished data migration in step #7.
I saw there were a total of 7966 sales orders migrated from the M1 database to the M2 database:
- Total sales orders in M1: http://prntscr.com/13nlrar
- Total migrated sales orders in M2: http://prntscr.com/13nlqcc
And here’s the migration log data of the sales order migration in our module: http://prntscr.com/13nlnhe
Regards,
Mall.
Hi Mall,
Yes, we have migrated all data but to migrate 8000 orders it takes approx 5-6 hours. and I think it is too much time.
Thanks
Dinesh
Hi Dinesh,
Could you please let us know your current server capacity? (Hard Disk, CPU, Ram, etc.).
Actually, the data migration time depends on many factors including the volume of data and the server’s performance. You can consider a few things below to improve the performance:
- It’s always good to start with a good VPS server. The higher the better.
- Proceed migration steps using the command lines in CLI mode, after you complete all pre-migration setting steps (simply via UI dashboard)
- You should enable PHP Memcached as indicated in the user guide of our migration tool.
- And if possible, when you can enable the Keep Original IDs options, it will help to improve the performance better.
- Use SSD instead of a traditional HDD drive (this is one of the crucial factors)
- If you have a separate database host, you must enable a remote MySQL database connection to your Magento 1 database. Anyway, for the best performance, in big data, the source and destination databases on the same MySQL server are recommended.
Regards,
Ubertheme team