I have an attribute (cost) correctly mapped from M1 to M2 but which is not migrating. I don’t understand why. I’ve confirmed the values exist in catalog_product_entity_decimal for M1 and M2, and ub_migrate_map_step_3_attribute_option correctly maps from Attribute 68 to 81. Thanks.
9 answers
Hi there,
Please provide me the phpMyadmin credentials of your M1 and M2 databases, I will help to check further into the product attribute ‘cost’ you mentioned. And I get back you to 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 can access.
Regards,
Mall.
Hi there,
I checked in your M1 and M2 databases and saw that:
Your M1 database had the attribute code ‘cost’ with the attribute id = 68 with the data like this screenshot: http://prntscr.com/q8lhli.
And in the log table of our module, you can see that our migration tool migrated and mapped to the attribute code ‘cost’ with the attribute id = 81 in your M2 database: http://prntscr.com/q8li75. And this is the data of that attribute migrated in M2: http://prntscr.com/q8lijl
So, it indicated that our module helped to migrate correctly that attribute (cost) and associated data. Please check again at your end.
Regards,
Mall.
Hi there,
SKU: 1107005
M1 Cost: 455.00
M2 Cost: 0.00
I checked that product SKU and saw the issue you mentioned. It seems that you changed the cost of that product after the first migration?
To update that migrated product, you need to run the delta migration in step #5 with the ‘update’ mode by using this command:
php -f bin/ubdatamigration run --step=5 --mode=update;
Regards,
Mall.
Unfortunately, after running the command you gave, the issue persists.
php -f bin/ubdatamigration run --step=5 --mode=update;
These are still the values:
M1 Cost: 455.00
M2 Cost: 0.00
Thanks.
Hi there,
Unfortunately, after running the command you gave, the issue persists.
That is strange. Please try once more with the following steps:
+ Run this SQL query in your M2 database:
UPDATE `ub_migrate_map_step_5` SET `created_time` = '2000-01-01 00:00:00', `offset` = 0 WHERE `entity_name` = 'catalog_product_entity';
+ Once done, run the delta migration in step #5 with the ‘update’ mode:
php -f bin/ubdatamigration run --step=5 --mode=update;
Regards,
Mall.
That did it! Thank you.
Hi there,
Glad that it helps. We close this ticket for now.
Regards,
Ubertheme team
