When you have a smaller number of orders in your WooCommerce store.

In the case of the migration of a WooCommerce stoo difficult as well.

Also, when you have a whole lot of orders to all of them, going about making the changes one by one is not really an option.

The common practice of importing data do is find the right plugin that can import the data error-free and effortlessly for you. This article explains how you can import the orders and order data using Order/Coupon/Subscription Export Import Plugin for WooCommerce.

Features of the Import Orders Plugin

Let’s see the features of the plugin and how it can help to import the orders and order metadata.

• The plugin can import data from an XML file or from a CSV file.
• Depending on the location of the plugin, there are two methods with which you can upload the CSV/XML file – by selecting the file from the local computer, or by providing the FTP details to fetch the file from a remote server.
• The columns of the CSV file need not necessarily align with the WooCommerce order data fields. For this, you can easily map the column headers of the files using the plugin. This is especially useful when migrating from other e-commerce platforms.
• Auto import orders located on a remote server on regular intervals using Cron Job.
• Import order metadata from different shipping providers using an XML file.

But first things first…

Before importing to be taken care of.

1 – The plugin takes a CSV or an XML file as an input. So you should have a CSV file or an XML file prepared and ready beforehand. You can either use a plugin to a CSV/XML file or prepare the file yourselves.

You can use Order/Coupon/Subscription Export Import Plugin for WooCommerce to a CSV or an XML file.

2 – Prior to. Otherwise during the import orders will not be associated with the right the right data.

Now let’s see how we can import the order details from a CSV/XML file tore.

Importing Orders

After you have installed and activated the plugin go to the import page of the plugin as shown below.

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 the server, then 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.
3. You get the mapping file option(s) for audown list as shown below:
   

   Mapping File

4. Update order if exists: check this box if you want to update the existing orders with the information in the CSV/XML file
5. Create User: By enabling this checkbox, if while importing the orders, the user corresponding to an order is not found, a new user will be created.
6. Enter the delimiter which separates the mapping values.
7. Click Upload file and Import. The import window appears as shown below:
   

   Orders import page

8. You can map the fields(Woocommerce fields) with column headings ( CSV file header). Map a particular field of Map down list as shown below:
   

   Mapping the Field

   Select a required option from the drop-to order_id .

   Note: Mapping is very helpful if you are importing CSV from some other e-Commerce platform like Magento.

   Evaluation field

   It is used to modify the field are as given below:

   

   Settings for Evaluation fields

   • Assign any required constant value to field (=)
     For Example: Suppose, you want to Order Status. Under Evaluation field, write =completed in Order Status row.
   • Add any required value to the field (+)
     For Example: Suppose, you want to Shipping Total. Under Evaluation field, write +5 in Shipping Total row.
   • Reduce any required value from the field (-)
     For Example: Suppose, you want to reduce 5 from Order Total. Under Evaluation field, write -5 in Order Total row.
   • Multiply by any required value to the field (*)
     For Example: Suppose, you want to Shipping Tax Total by 1.05. Under Evaluation field, write *1.05 in Shipping Tax Total row.
   • Divide by any required value to field (/)
     For Example: Suppose, you want to divide Cart Discount by 2. Under Evaluation field, write /2 in the row.
   • To Convert the order date to WooCommerce format, provide your CSV date format in evaluation field.
     For Example: In CSV,  If you have entered the date in the correct PHP format as @ d/m/yy H:i:s ( @ 13/07/2016 4:24:25) , then under Evaluation field, you must maintain the same date format as @ d/m/yy H:i:s  in the order_date row. Then the plugin internally converts it in WooCommerce format as 2016-07-13 4:24:25.
   • Append any field by the required value
     For Example: Suppose, you want to append Billing Company by Pvt Ltd. Under Evaluation field, write &Pvt Ltd in billing_company row.
   • Prepend any field by the required value
     For Example: Suppose, you want to prepend Billing First Name by Mr/ Mrs. Under Evaluation field, write &Mr/Mrs[VAL] in Billing First Name row.

   Note: Hover the mouse on ‘?’ (Help), you can see the information about Evaluation field. For more information on Evaluation field, See Evaluation field in Order Export Import Plugin for WooCommerce article.

9. After mapping all the required field, you can save these mapping and evaluation fields in a file (user-defined) by using Mapping file name field.
10. Click Submit.
11. According dow appears as shown below: