Order Item is not showing

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

Profile photo of Mall Staff 166570.00 $tone May 27, 2021
Public

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.
 

#1
Profile photo of Mall Staff 166570.00 $tone May 27, 2021
Public

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.

#3
Profile photo of Mall Staff 166570.00 $tone May 31, 2021
Public

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.

#5
Profile photo of Mall Staff 166570.00 $tone May 31, 2021
Public

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.

#10
Profile photo of Mall Staff 166570.00 $tone May 31, 2021
Public

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.

#11
Profile photo of co5wkc7910734 110.00 $tone May 31, 2021
Public

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

#12
Profile photo of Mall Staff 166570.00 $tone May 31, 2021
Public

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.

#13
Profile photo of co5wkc7910734 110.00 $tone May 31, 2021
Public

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

#14
Profile photo of Mall Staff 166570.00 $tone June 1, 2021
Public

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.
 

#15
Profile photo of ubdev Staff 84140.00 $tone June 1, 2021
Public

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

#17

Please login or Register to Submit Answer

Written By

Comments