I mapped sales_flat_order table of magento 1.9 to sales_order table of magento 2 and push the csv from mysqlworkbench. and orders was migrated in the database. The orders are even displaying in the frontend.

The products and customer data migration was done before this. Is there any problem in this migration... Anyone have gone through the same order migration process ?


I think we should map some more tables:

Magento 1                     || Magento 2
sales_flat_order                 sales_order
sales_flat_order_address         sales_order_address
sales_flat_order_grid            sales_order_grid
sales_flat_order_item            sales_order_item
sales_flat_order_payment         sales_order_payment
sales_flat_order_status_history  sales_order_status_history

If we had the invoices and shipments, we need to map more tables.

Note: when we want to clear the order from Magento 2, we can use this module.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.