Error Message Step 7: Order Currency Code

When Migrating at Step 7 I get an error message: Mage2SalesOrder: Order Currency Code is too long (maximum is 3 characters)
 
How can I solve it or where to look?

3 answers

Profile photo of Mall Staff 184060.00 $tone February 26, 2019
Public

Hi there,

Mage2SalesOrder: Order Currency Code is too long (maximum is 3 characters)

That issue because your database has some records which has bad value in field: sales_flat_order.order_currency_code
(some values has length > 3 characters)
To continue, you must re-correct value of the order_currency_code field in some records in that table. You could use below SQL to listing for that bad records:

Select * From sales_flat_order Where Length (order_currency_code) > 3;

Once done, you could continue with data migration in the step #7 of our migration tool.
Regards,
Mall.

#1
Profile photo of ubdev Staff 98150.00 $tone February 27, 2019
Public

Hi Arjen,
Yes, please move forward with the migration process. If you have any other issue, please get back to us here.
Regards,
Ubertheme team

#3

Please login or Register to Submit Answer

Written By

Comments