Attribute not migrating

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

Profile photo of Mall Staff 127680.00 $tone December 10, 2019
Public

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.

#1
Profile photo of Mall Staff 127680.00 $tone December 10, 2019
Public

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.
 

#3
Profile photo of Mall Staff 127680.00 $tone December 11, 2019
Public

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.
 
 
 

#5
Profile photo of master.sale 60.00 $tone December 11, 2019
Public

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.

#6
Profile photo of Mall Staff 127680.00 $tone December 11, 2019
Public

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.

#7

Please login or Register to Submit Answer

Written By

Comments