Price Type is too long (maximum is 7 characters)

i am running the tool and getting this error on step5 product migration
[error] [ub_data_migration] Mage2CatalogProductOptionTypePrice: Price Type is too long (maximum is 7 characters).

1 answer

Profile photo of Mall Staff 184060.00 $tone June 12, 2020
Public

Hi there,

[error] [ub_data_migration] Mage2CatalogProductOptionTypePrice: Price Type is too long (maximum is 7 characters).

That issue occurred because your M1 database had at least one data record which had bad value on the ‘catalog_product_option_type_price.price_type‘ field.
 
You can run the following SQL query in your M1 database to look for that data record:

SELECT * FROM `catalog_product_option_type_price` WHERE LENGTH(`price_type`) > 7;

and then, you have to re-update the value (reduce the length of string value. Max length allowed is 7 characters) of the price_type field on all found data records.

+ Once done, you can continue with the data migration in step #5 as normal.
 
Regards,
Mall.

#

Please login or Register to Submit Answer

Written By

Comments