How to Import Orders from an XML file to WooCommerce

If you have your order data in a CSV file and you are searching for a way to import them all to a WooCommerce website without any hassle, Order/Coupon/Subscription Export Import Plugin for WooCommerce has got you covered.

The plugin helps you to import the orders and the order related data stored in an XML file. The plugin helps you to import hundreds, even thousands of orders using one file using efficiently in a matter of minutes. This reduces a lot of time and effort that would have required if the orders were to be added manually.

To know more about the plugin and its features visit the product page of the plugin.

Now, let’s see how we can import an XML file using this order import/export plugin.

Methods to Import WooCommerce Orders in XML Format

The plugin takes the WooCommerce Order XML file as input which is exported from this plugin. It updates all details of the orders by importing the XML file. So, to import the orders on to the website you should have an XML file prepared beforehand.

A screenshot of a sample XML file is shown below.

Note: If Order ID exists in your online store, you can update or skip that particular order. otherwise, a new order gets created by importing Order XML.

Now, go to the admin side of the website and navigate to WooCommerce > Order Im-Ex and then to the Order XML tab.

From the Import Orders in XML Format section, click Update Orders, the window appears as shown below:

Select XML type as WooCommerce. During importing WooCommerce Order XML to your online store, you get the option to skip the existing order from updating or overwrite the existing order.

You can import the Order XML file by the following two methods:

Method 1: Select a file from your computer

Method 2: Provide FTP Details

If your XML file is on the 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 the FTP Port number.
6. Enter FTP Server Path.
7. Select the checkbox to use FTPS.
8. Select the checkbox to enable passive mode.
9. Click Upload file and Import.

After a successful import, the import window appears as shown below:

For more details about importing and exporting orders using the plugin, read the plugin documentation.