Rating 5 stars - 1 votes

Magento 2 Import Orders

How to Import Products to Magento 2: Check step-by-step tutorial to upload products in Magento 2

A busy store gets a bunch of orders on a daily basis, so when there occurs the need for Magento 2 import orders procedure, it is obviously a challenge as the admin panel is missing the ability to import orders from CSV to Magento.

Why You May Need to Bulk Import/Export Orders in Magento 2

You may need to move sales information when you are migrating to other store, from ERP system or accounting software or upgrading from older version to newer.

Often happens the situation when you run two installs of your Magento website, the production and the development one, so you might need to transfer order data to live website.

Magento Order Import Approaches

Since there is no built-in button for this, the task requires certain development knowledge, time and efforts. Good for you if you have a full-time developer who can extract the necessary sales data from the database directly and then add info to a new store database or can write script to perform the task by means of coding.

If you do not want to spend additional budget on developer and have no special tech skills yourself, you can use had a reliable ready-made Magento 2 order export / import extension.

Store Manager for Magento (PRO and Enterprise editions) app provides you with an easy way to export and import orders within Magento installations with a few clicks. It allows you to create a file, make on-fly changes and upload it in one go!

Why to Choose Store Manager for Magento to Import/Export Orders?

Here are a few points that make this extension stand apart the others:

  • Bulk export / import of necessary (selected) Magento orders with related order details (ordered items, totals, discounts etc) as well as related customer data (billing/shipping address) and email
  • Ability to map fields in case of different column names (different database structure, depending on Magento versions)
  • Possibility to create customer’s account on the fly in case the client does not exist in database (Enterprise edition only)
  • Multiple Magento installations support (PRO, Enterprise editions of app)
  • Free 14-day version of PRO edition available, so you can do the task even without fees!

Magento Order Import Instructions

Store Manager for Magento provides an easy and safe way to import/export all or selected/filtered orders and related customer information. It includes the following steps:

- The File with Orders Data

If you are trying to transfer sales data from one Magento shop to another, to receive the spreadsheet with orders info you can export data from source Magento using Store Manager.

Just go to Orders section of Store Manager app and from the main menu launch Import/Export Wizard and select Export operation.

Magento import orders
Magento import orders

You can save to spreadsheet all the orders or only those which were selected or filtered before the procedure. Moreover, you can choose what exactly fields you would like to be exported moving them from the left to the right pane of the window.

Magento import orders
Magento import orders

Detailed step-by-step guide on Magento order export you can read here -


- Import Steps

1) Run import/export wizard of Store Manager and select ‘Import’ operation.
2) Select CSV or TXT file with orders info from the folder at you PC or if it is placed remotely you can use options to load files through http or ftp link -

Magento import orders
Magento import orders

Note:If the original CSV file has been exported from Magento ver. 1.x and now you are importing orders into Magento 2.0.x store, you may experience compatibility issues (for example, with the order item_product_options or weee_tax_applied fields). We recommend contacting our support team via the Live Chat that you can find at the bottom of this page and our specialists will assist you with the import process.

3) Make sure that the file was loaded properly at preview and delimiters step.

Magento import orders
Magento import orders

4) Tick the box to import sales data to corresponding store view in case you use multi-store Magento installation.

Magento import orders
Magento import orders

5) At the step of mapping you can link CSV columns to database fields related to orders. This is useful in case source and target Magento databases have different structure or in case your file is formatted in some specific way.

Magento import orders
Magento import orders

Also select identifiers (order ID or increment ID) to differentiate your orders and purchased items.

Note: With Enterprise edition you have the chance to import orders along with customers info and create clients’ accounts on-the-fly.

With PRO edition you can import customers records (info on customer) belonging to order, but actual clients accounts will not be created. Imported orders cannot be mapped to existing customers accounts.

Standard edition does not include orders import functionality.

6) If you during import changed your mind and want to upload only a few orders as a test, you can select rows to start import from and to. No need to return and edit the file.

Magento import orders
Magento import orders

7) Import options step currently allows to import all the order records as new.
Note! Order numbers and IDs are auto-incremented, it means that after the upload all orders will have new order numbers and IDs (the ones indicated in the file will be ignored).

Magento import orders
Magento import orders

- Magento 2 Order Import Results

After you hit ‘Import’ you will see changelog on procedure progress.

Important! Note order invoices cannot be uploaded during order import.
Ability to import comment history fields has been added starting from ver. 3.9.0 of Store Manager for Magento

Magento import orders
Magento import orders

When it is finished, you can check the results - new orders have been added to Orders section of Store Manager.

Magento import orders
Magento import orders

Magento orders import/export can be done with minimal efforts on your side with Store Manager application! Import orders FREE!

Related Articles:

Card image

Magento Order Management with POS

The list of benefits provided by Magento integration with POS system and instructions on how to use the POS. Read More...

Card image

How to Remove Magento 2 Order?

Check how to delete Magento 2 order without breaching Magento limits. Read More...

Card image

Magento 2 Order Status Flow

Find out how to easily manage Magento status overflow by changing order status and adding custom order statuses. Read More...

Card image

Magento 2 Abandoned Cart Recovery via Followup Emails

Guides on how to get the list of customers with abandoned carts and send them an email reminder using a specific template. Read More...

Jeeva Rathinam
Jeeva Rathinam • 06/14/2017

I need Order Import demo csv, and how can i add multiple products with difference price.

Magento Store ManagerMod Jeeva Rathinam • 06/14/2017

Hello Jeeva!

If I have understood you correctly, you need to import orders with multiple ordered products. To have the template of file that can be used for orders import via Store Manager for Magento software, you can export orders and check the columns of your CSV file. There is 14-day free trial version of Store Manager for Magento app, so you can download it and check how it works.

Hope this helps.

bryan pace
bryan pace • 06/10/2017

If invoices cannot be imported, does this mean all orders will be uploaded as Pending/Processing, with no record of captured payment?

Magento Store ManagerMod bryan pace • 06/12/2017

Hello Bryan!

Thank you for being interested in our software.
Actually, orders will be imported with current order statuses. If necessary, it is possible to change order status to Pending/Processing right during order import or after it and generate invoices for uploaded orders.

Teodor Pavlovich
Teodor Pavlovich • 03/31/2017

Can I keep the order number when I import orders from an old store to the new one?

Magento Store ManagerMod Teodor Pavlovich • 03/31/2017

Thank you for your question.
Store Manager imports all the orders as new entities. Respectively order numbers and IDs are autoincremented. Having imported orders to Store Manager, you will find their numbers and IDs different from ones, you had in the import file.