Magento – Migrate only orders in magento 2 from Magento 1.9 using thesqlworkbench

magento2migration

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 ?

Best Answer

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.

Related Topic