Import Error – Sales

HI Support,
after 3000 Rows i have this error when i import my Salesorders from old Magento 1.9. to Magento 2.
Message: Mage2SalesQuoteItem: Row Total With Discount is too long (maximum is 12 characters).
I use the CLI Command > php bin/ubdatamigration run --step=7 --limit=500 for the import….have you any idea?
 
Thanks
Alex

3 answers

Profile photo of Mall Staff 184060.00 $tone August 15, 2018
Public

Hi there,

Message: Mage2SalesQuoteItem: Row Total With Discount is too long (maximum is 12 characters).

That issue because your database has some records which has bad data in the value of the field sales_flat_quote_item.row_total_with_discount 
To handle for that, you could do steps below:
+ Open the php file at path:
pub/ub-tool/protected/controllers/Step7Controller.php
and find to the code lines (there are two lines with below code):

if (in_array($key, array('weight', 'price', 

and replace that lines  by code line:

if (in_array($key, array('weight', 'price', row_total_with_discount,

+ Once done, you could continue with data migration in the step #7 by run below CLI command:
php bin/ubdatamigration run --step=7 --limit=500
Regards,
Mall.

#1
Profile photo of ubdev Staff 98390.00 $tone August 16, 2018
Public

Hi Alex, 
Glad it helps. 
In case you have any additional question, please get back to us here.
Regards,
Ubertheme team

#3

Please login or Register to Submit Answer

Written By

Comments