How to Import WooCommerce Orders Into Your Shop –

How to Import WooCommerce Orders Into Your Shop - WP Mayor

Whether you’re migrating from one system to another, or need to keep your orders up to date, you’re probably looking for a simple solution to import your data into your online shop. WP All Import is great at just that. It lets you import pretty much any data to your WordPress store.

Throughout the past few weeks, we’ve been taking a deep dive into how you can use this plugin to help you maintain your store by importing WooCommerce products and WooCommerce customers to your site.

In this post, I’ll be taking you through a step-by-step process of how you can successfully import your WooCommerce orders efficiently.

For the purpose of this guide, it is ideal for you to have your products and customers already set up.

Create a new WooCommerce order import

WP All Import allows three ways of uploading your data from XML or CSV files:

  1. Manually upload a file
  2. Download a file from a specific feed or file URL (supports Dropbox and Google Sheets/Google Drive files)
  3. Use an existing file on your server

Thankfully, this plugin not only gives you the ability to upload and import new data, but it also lets you update it as time goes by. If you’re interested in scheduling updates automatically, you’ll want to opt for the second option and have your file located in a Dropbox folder or Google document so that the plugin can easily access it at any time.

For this example, however, I will be uploading a file manually. Once you’ve selected your file, select WooCommerce Orders from the drop-down menu and continue to Step 2. Here you can filter through your orders to only import selected items. Alternatively, you can skip this step and continue to Step 3.

Map WooCommerce order data to import fields

WP All Import is very simple to set up. On the right-hand side of your screen, you will find all your orders displayed as cards – in this case, I have 135 orders. You can easily flip through them to see all your orders. All you need to do to start importing information is to drag and drop the data from these cards, into the respective import fields.

This process tells the plugin which information should go where making importing into WordPress all that much easier for you.

Give this a go by selecting “set with XPath” under Order Details and dragging and dropping your order status and order date from the right-hand side of the screen into the correct fields.

Billing details

Next, we need to decide whether we’re going to import guest customer orders or match existing customers to our new orders. For the latter, you can match by:

  • Username
  • Email
  • Custom Field
  • User ID



This article was written by Gabriella Galea and originally published on WP Mayor.

Disclosure: Some of the links in this post are "affiliate links." This means if you click on the link and purchase the product, We may receive an affiliate commission.

Leave a Comment

You have to agree to the comment policy.

Scroll to Top