Migrate sale qoute error

6 answers

Profile photo of Mall Staff 184060.00 $tone September 22, 2016
Public

Hi moneyok,
I have see the screenshot and see the root issue is:

Incorrect string value: ‘\xE0\xB8’ for column firstname…

That because your Magento 1 database has a bad data with the value of the ‘firstname’ field in the quote_address` table.
That bad value was not accept in the new rules of the Magento2.
See more about your bad data: http://i.prntscr.com/0d25782c71674b6da8a89554fe2f4dec.png
Before tell you a workaround to solve that issue, let’s provide me the Mysql credentials of your Magento 1 and the phpMyadmin URL of that database. I will check further and help you get out.
Regards,
Mall.

#3
Profile photo of moneyok 10.00 $tone September 23, 2016
Public

OK i’m migrate in localhost it work! and import in to my server (but super slow when migrate in localhost HaHa)

but i have a new question. when i import data sale 
now i have create a new order 

in Order id not continue to sort order id

ex.

last order id when migrate success Order # 100003913
but i create new order and then Order id # 000000001

pic* last order id
http://prnt.sc/clagfl

but now i new order 
http://prnt.sc/clagod

can run order id continue last order id ? or not it have a problem in Future data? 

#5
Profile photo of Mall Staff 184060.00 $tone September 23, 2016
Public

Hi moneyok,

last order id when migrate success Order # 100003913
but i create new order and then Order id # 000000001

That isn’t a issue, that is working rules of the Magento 2 core. You can see more about this at here: http://devdocs.magento.com/guides/v2.0/migration/migration-migrate-additional.html

The numbers of Orders, Invoices, Shipments, Credit Memos and RMA migrate as is. But after migration and switching to Magento 2 the numeration for newly created sales entities will be different.

Regards,
Mall.
 
 

#6

Please login or Register to Submit Answer

Written By

Comments