How to Import WooCommerce Orders

The Best WooCommerce Order Import Export Plugin

7,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

When you have to add new information to your website, or you have to update the existing order’s details on your website, manually doing all the work is going to take forever. Especially when you have hundreds or thousands of orders to be added to the website.

You can import the orders and all the data related to the orders using Order/Coupon/Subscriptions Import Export Plugin for WooCommerce. The plugin helps you to import orders from a WooCommerce store, or any other e-commerce platform. It takes either a CSV file or an XML file as input. Even if the files contain hundreds of thousands of orders, all the orders in the files are effortlessly imported to the store in a matter of minutes.

This article explains how you can import the WooCommerce orders into your store using.

Prerequisites:

To import the orders into a WooCommerce store, first, you have to install and activate the plugin on your WooCommerce website.

Also, for importing, you must have a CSV or XML file prepared beforehand. You can either prepare the files manually or you can export the data using Order/Coupon/Subscriptions Import Export Plugin for WooCommerce or with the appropriate methods for other platforms.

Also, the CSV Import file must be in UTF-8 format. For more information about UTF-8 encoding, read How to save CSV / Excel File as UTF-8 Encoded?

Once you have the XML or CSV file prepared and ready, you can do the following steps to import the file into your WooCommerce store.

Import Orders

To import the orders into the WooCommerce store, go to the admin dashboard and navigate to WooCommerce > Order Im-Ex. This will take you to the plugin page. The plugin page looks as shown below.

order coupon subscription plugin page

Click on Import, and it will take you to the Import page. The Import Page looks as shown below.

order import settings page

There are two methods by which you can import the data. This is based on the location where the file is stored. The following are the two methods by which you can import the CSV or XML files.

  1. Method 1: Select a file from your computer. Click Choose File to browse a required CSV file from your computer.
  2. Method 2: Provide FTP Details. If your CSV file is on a server, then to import it,  you need to do FTP settings as given below:
    1. Select the checkbox to enable FTP import/export.
    2. Enter FTP Server Host/IP.
    3. Enter FTP User Name.
    4. Enter FTP Password.
    5. Enter FTP Port number.
    6. Enter FTP Server Path.
    7. Select the checkbox to use FTPS.
    8. Select the checkbox to use FTPS.

After you have chosen the appropriate method for importing the file, fill in the below fields as required.

  1. You get the mapping file option(s) for auto-mapping only if you save the mapped fields with a user-defined file name while Mapping the fields. Select the required mapping file from the Select a mapping file drop-down list as shown below:Mapping file
  2. Select the checkbox to enable passive mode.
  3. Select the checkbox to update the orders an order if it already exists in the store.
  4. Enter the delimiter which separates the mapping values.

Next, click on Upload file and Import. This will take you to the next important step in the import process, Map Fields. The window appears below.

order import mapping

The mapping fields are important to ensure the right data from the CSV/XML file are imported under the right data fields. This comes in handy when the data is being transferred from other e-commerce platforms.

After the mapping, click on Submit. This will import all the data from to the WooCommerce store. After a successful import, you will get a screen like this:Imported order

Merge Orders

When the aim of the import is to update the existing orders in bulk, the plugin can help you do that with ease. Consider a scenario where your existing orders got modified. To reflect that modified orders into your online store, you can update the current orders by importing modified order CSV file. This is called a merging of the order.

Steps to merge orders

Select Update order if exists checkbox for modifying orders as shown below:

import order update if exists 1

The Proceed to Import Mapping to map the fields of the CSV file and rest of the import process is the same as a regular import.

The Best WooCommerce Order Import Export Plugin

7,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Leave a Reply

Your email address will not be published. Required fields are marked *