How to Export and Import Orders in XML File from WooCommerce

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!

This tutorial explains how to Export/Import WooCommerce Order XML file using Order / Coupon / Subscription Export Import Plugin for WooCommerce. Please refer to the product page to know more about the plugin features.

Overview

Order / Coupon / Subscription Export Import Plugin for WooCommerce allows you to easily export or update orders details to your store into the XML file format. You can export/update existing hundreds, even thousands, of orders using one file which saves your effort and time of manually adding order information.
The plugin also exports individual orders from Orders listing page, export all orders or specified orders by offset/limit with a certain date range in bulk.

For updating orders to your online store, you must import XML file which is in WooCommerce format. This import file contains information about the orders along with the Order ID.

Order Import/Export

Under Order Import/Export tab, you can export/update the order.

Export Orders

If you export order using the plugin, you can get the XML file which contains the data about all the orders of your online store.
Export orders in XML format
Export orders in XML format

You can export all the required orders by using the Export Orders option. The window is as shown below:

  1. Select the Order Export Type as WooCommerce.
  2. Order Statuses:  Select order statuses for which you want to export orders from the given list:
    order statuses
    Order statuses
  3. Offset: Enter the order row number at which you wish to start the export.
  4. Limit: Enter the maximum number of orders that you wish to export.
  5. Start Date: Select the date from which you want to export the orders by clicking on the calendar icon.
  6. End Date: Select the date till which you want to export the orders by clicking on the calendar icon.
  7. Click Export Orders, the XML file gets auto-downloaded to your computer. The sample orders XML file is as shown below:
    Exported orders
    Exported orders

Export order(s) from Order Page

Orders Listing Page
Orders Listing Page

You can directly download the export file with all the fields. To do that, navigate to Dashboard > WooCommerce > Orders. The Orders listing page appears as shown below:

  • Click Download to WooCommerce XML button to export single order to an XML file.
  • To export bulk orders, select them. From Bulk Action drop-down list, select Download as WooCommerce XML and click Apply. It is shown as shown below:
    Bulk Action drop-down list
    Bulk Action drop-down list

    All the information about selected Orders gets auto-downloaded to the XML file.

Add/Update Orders by Importing XML File

The plugin takes WooCommerce Order XML file as input which is exported from this plugin. It updates all details of the orders by importing XML file.

Sample Import XML File
Sample Import XML File

Note: If there is any mistake in your import file, your order update may not work as expected. For Sample WooCommerce Order XML import file, navigate to Help tab. Sample Import file is as 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.

Import orders in XML format
Import orders in XML format

The Import Screen appears as shown below:

Order XML Import Page
Order XML Import Page

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. Click Choose File to browse a required XML file from your computer. Click Upload file and Import.

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. The import window appears as shown below:
    Orders successfully imported
    Orders successfully imported
Individual order page
Individual order page

You can see the order gets updated with custom fields as shown below:

Help

order XML help tab
order XML help tab

Under Help tab, you can find sample Export and Import XML with documentation as shown below:

Settings

Order XML settings tab
Order XML settings tab

Under Settings of menu tab, you can set the FTP settings for exporting the WooCommerce order from FTP server. Also, you can auto-export / import WooCommerce Order. The window appears as shown below:

  1. Select the checkbox to enable FTP import/export Orders.
  2. Enter FTP Server Host/IP.
  3. Enter FTP User Name.
  4. Enter FTP Password.
  5. Enter the FTP Port number.
  6. Select Use FTPS checkbox to connect securely.
  7. Enter the Export Path of the server where the file will be exported to.
  8. Enter the Export Filename of the exported file.
  9. Enable Passive mode to passively send the data to the server.
  10. Choose Enabled option to Automatically Export Orders from FTP Server Host/IP.
  11. Enter the required Export Start time for exporting the Orders.
  12. Enter the time interval in minutes for exporting Orders.
  13. Choose Enabled option to Automatically Import Orders from FTP Server Host/IP.
  14. Enter the complete path name including the name of the Import File.
  15. Enter the required Import Start time for importing the Orders.
  16. Enter the time interval in minutes for importing Orders.
  17. Select Update Orders if exist checkbox to update existing orders with the updated details. The Merging is possible only if the ID of order already exists in your online store. Otherwise, the order is imported as a new one.
  18. Select Exclude Already Exported checkbox if you do not want to export the orders that have already been exported in the new XML file.
  19. Click Save Settings to save settings.
    For more information about corn job, please refer Setting Up The Cron Job.

After FTP settings, the Order XML file gets exported to the root directory of FTP the server.

Check out our  Order / Coupon / Subscription Export Import Plugin for WooCommerce.

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 *