how to import and export Woocommerce orders

How to Import & Export WooCommerce Orders with Free Plugin

If you’re running a WooCommerce store, you know how important it is to keep your orders organized and accessible. But what happens if you need to move your store to a new host or platform? Or what if you want to keep a backup of your orders? In these cases, it’s helpful to know how to import and export WooCommerce orders.

We Offer Woocommerce Services!

Reach new heights with our WooCommerce services. Our developers can make your website beyond your expectations according to your business needs..

View Service!

In this article, we’ll walk you through the steps of importing and exporting orders. We’ll also provide tips on making the process as smooth as possible. So whether you’re just getting started with WooCommerce, or you’ve been using it for a while, this article will be helpful for you.

What is a WooCommerce Order?

An order is a record of a purchase made by a customer through WooCommerce. It contains the details of the ordered product(s), quantity, and price(s). In WooCommerce, orders are stored as posts with the post type ‘shop_order.’ Each order has an associated order status (e.g., pending, processing, completed) and contains line items for each product purchased. 

Orders can be created manually in the admin interface or generated automatically when a customer completes checkout on your site.

What are the Different Parts of an Order?

When you view an order in WooCommerce, you’ll see several different parts: the order number, the date of the order, the status of the order, the customer’s name and contact information, and a list of items included in the order. 

To import or export WooCommerce orders, you must first understand what data is stored in order. An order post contains the following data:

– Order date

– Customer details (name, email address, etc.)

– Shipping address

– Billing address

– Payment method 

– Line items (products purchased, quantity, price, etc.)

– Order total 

– Order status 

How do we Import an Order into WooCommerce?

To import an order into your WooCommerce store, first, make sure that you have created a new order in your WooCommerce account. Once you have created the new order, follow these steps to import it into your WooCommerce store:

1) You need to install and activate Product Import Export for WooCommerce plugin then Go to WebToffee Import Export (Basic).

2) In the first step, you must select the order as the post type.

3) Choose the method of import from Quick Import, Pre-saved template, or Advanced Import.

A. Quick Import

It would be best to use this option primarily when the output file was exported with the same plugin as the input file.

B. Pre-saved Template 

Using this method, select the option to import a previously saved template from the dropdown. The filter criteria are retained, and column specifications are applied according to the selected file.

C. Advanced Import

The advanced options will guide you through the process of filtering and selecting columns required to import a file. It is also possible to save your selection as a template so that you can access it in the future. 

4) The next step is to Map Import Columns. This section allows you to map import columns under the following three fields:

  1. Default Fields – These are the fields that WooCommerce will use if no other column matches the name of the import column. 
  1. Custom Meta Fields – These are additional custom fields that you can add to your orders. 
  1. Hidden Meta Fields – These are any fields that WooCommerce will ignore when importing data. They help exclude certain columns from being imported or for hiding specific information from view in your admin area.

5) Finally, choose Batch Import/Scheduling to finish. Orders can be imported directly into your store or scheduled using FTP. 

You can schedule the import by choosing WordPress Cron or server Cron. Now, finally, you can import directly by clicking on import. 

The import status will include the number of successful and failed imports displayed once the process is complete. 

Video version of how to import Woocommerce orders:

How do we Export Orders from WooCommerce?

If you’re running a WooCommerce store, you might need to export your orders from time to time. Maybe you’re switching to a new e-commerce platform, or you need to send order information to a fulfillment center. Whatever the reason, exporting orders from WooCommerce is relatively easy. 

1) In your WordPress dashboard, WebToffee Import Export (Basic).

2) Choosing a post type – You first need to select the order as the post type.

3) Now choose an export method-To export your data; select one of the following options:

A. Quick export

By selecting the Custom meta and Hidden meta checkboxes, you can include fields from those groups. This will export the basic and standard fields for each type of post. 

B. Pre-saved template 

 Select the option to export data. Select a previously saved template from the Export template dropdown. Filter the data and click the Export button to complete the action.

C. Advanced export

This option provides you with a detailed process of filtering, column selection, and advanced export options, which can also be saved as a template for future use.

4) The next step is filler data. Here to export WooCommerce orders, you need to filter the data that needs to be exported. You can do this by specifying the total number of orders to export (the actual number of orders you want to export), the number of skipped first n orders, and order IDs. You can also filter orders by their status type (e.g., completed, processing, etc.) and by specific products.

5) Next, the column names appearing in the “Map and reorder export columns” section can be edited if required. You can view the last saved preferred names and choices by selecting a pre-saved template. 

To reorganize the columns, you have the choice to move them to your preferences according to the default fields, custom meta, or hidden meta. Tick the checkbox to your requirements and move to the next step.

6) Now, the final step is Advanced Options/Batch Export/Scheduling. 

Here you can exclude previously exported orders, export line items into separate columns, and specify a filename for the exported file. If left blank, the system generates a default name. Both CSV and XML file formats are available. The delimiter for CSV files is always by default, and you can also enable FTP export and schedule exports.

You can batch export your orders by selecting the desired dates and time range, or you can even schedule the export to finish at a later date. Plus, now that you have your WooCommerce orders all organized and in one place, it’s time to export them so you can move on to the next phase of your business. Once everything is finished, click on the “Finish Export” button, and everything will be saved.

Looking for video version on how to export Woocommerce orders? Here we go:


So, whether you’re using WooCommerce to manage your business or need a backup, importing and exporting orders is a great way to keep everything in order. By following these simple steps, you’ll be able to quickly move your store to a new platform or host or back up your current orders.

I hope this article helps you to know how to import and export Woocommerce orders easily. If you have any questions or suggestions don’t hesitate to leave your thoughts below.

Leave a Comment

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