Looking to export or import your WooCommerce orders?
Store owners often need to move order data for various reasons, such as migrating to a new site, syncing with a CRM or accounting tool, integrating with a shipping platform, bulk adding tracking numbers, or simply running a one-off report.
In this guide, we'll walk you through the order export and import process and also cover some advanced scenarios.
📑 Table of Contents
What You Can Do with WooCommerce Order Export and Import
WooCommerce order data includes a lot more than order numbers and totals. This data is useful for everything from accounting and fulfillment to customer relationships and reporting.
You can use the exported order data to:
- Share order data with your accountant or bookkeeper
- Sync orders to a shipping platform like ShipStation or a 3PL
- Send order data to a CRM like HubSpot or Salesforce
- Push order data to a Google Sheet for team collaboration
- Migrate orders to a new WooCommerce site or another platform
- Feed order data into an ERP like Odoo or NetSuite
- Run scheduled sales reports for stakeholders
Similarly, you can import the order data to:
- Migrate orders from another platform, like Shopify or Magento
- Bulk update orders with new tracking numbers or statuses
- Import orders from a partner or supplier feed
- Sync orders between two WooCommerce stores
- Load historical order data into a new store
Now that you have a good sense of the various use cases, let's start with the basic export and import processes, both of which take just a few minutes. From there, we'll move on to some advanced use cases that showcase what's possible. Throughout, we'll be using WP All Import and WP All Export.
Part 1: Exporting WooCommerce Orders
The basic WooCommerce order export process is straightforward. Once you have the WP All Export plugin installed along with the WooCommerce add-on, here's how to do it.
How to Export WooCommerce Orders
If you want to follow along and try before purchasing, you can use our convenient sandbox feature and select WooCommerce Store as the demo type.
1. Start a new WooCommerce order export
Navigate to All Export, then click New Export. Choose Specific Post Type, then select WooCommerce Orders from the dropdown. You'll see a summary showing the total number of orders that will be exported.
2. Add filters to export specific WooCommerce orders (optional)
If you want to export only specific orders, expand the Add Filtering Options panel. You can filter by any order field, including order status, date range, product, or customer. For this basic walkthrough, we'll export all orders.
3. Build your WooCommerce order export file
Click Customize Export File to open the Drag & Drop screen.
The left side is your column selection area. The right side is the Available Data panel, where all WooCommerce order fields are organized by category: Order, Customer, Items, Taxes & Shipping, Fees & Discounts, Notes, Refunds, Custom Fields, and Other.
To add a field, drag and drop it from the right side into the column area on the left. You can rearrange, rename, or remove columns as needed. The Add All button includes every available field at once.
4. Choose your WooCommerce order export type
On the same Drag & Drop screen, expand the Export Type panel near the bottom of the screen. You have two options:
- Spreadsheet: For CSV or Excel. CSV is the default, and you can also pick Excel File (XLS) or Excel File (XLSX) for true Excel output.
- Feed: For XML. Pick Simple XML Feed for standard XML, or Custom XML Feed for full structural control.
Choose Spreadsheet or Feed, then pick your specific format from the dropdown.
5. Configure and run the order export
Click Continue to move to the Export Settings screen. Here you can:
- Schedule the export to run automatically through Automatic Scheduling or manual cron jobs
- Adjust Advanced Options like batch size, real-time exports, or splitting large exports into multiple files
- Give your export a custom name
For now, click the green Confirm & Run Export button.
6. Download your WooCommerce order export file
After a few seconds, the Confirm & Run screen shows that your export is complete. Click CSV (or Excel or XML, depending on your earlier choice) to download your file.
You'll also see options for Scheduling, External Apps, and Export, Edit, Import. The Export, Edit, Import option lets you bulk edit orders after downloading. We'll cover that workflow in detail later.
That's the basic process using WP All Export. Most users have their WooCommerce orders exported in under five minutes.
What Fields Can Export from a WooCommerce Order
WooCommerce orders contain a lot more data than the basic order number and total. The fields in the Available Data panel are organized into the following categories:
- Order data: order ID, order key, order date, completed date, order status, order total, payment method, order currency
- Customer data: customer account info (email, user ID, customer note) plus full billing and shipping addresses (name, company, address, city, postcode, country, state, phone, email)
- Items: product ID, SKU, product name, product variation details, quantity, item cost, item total, per-item tax
- Taxes and shipping: line-item tax, shipping totals, shipping methods
- Fees and discounts: applied fees and coupon codes
- Notes: customer notes and internal order notes
- Refunds: total refunds, partial refunds, refund reasons, and refunded line items
- Custom fields: data added by WooCommerce extensions or third-party plugins like ACF, Meta Box, and JetEngine
- Other: any remaining order-related data
To include any of these, drag and drop them from the Available Data panel into your column selection area, or click Add All to include everything at once.
Part 2: Importing WooCommerce Orders
The basic WooCommerce order import process is just as straightforward as exporting. Once you have the WP All Import plugin installed along with the WooCommerce add-on, here's how to do it.
How to Import WooCommerce Orders
If you want to follow along and try before purchasing, you can use our convenient sandbox feature and select WooCommerce Store as the demo type.
1. Start a new WooCommerce order import
Navigate to All Import, then click New Import. You'll be prompted to choose how you want to provide your data. The options include:
- Upload a file: Choose a CSV, Excel, or XML file from your computer
- Use existing file: Reuse a file from a previous import
- Download from URL: Fetch a file from a remote URL on a schedule
For this walkthrough, we'll upload a file from the computer.
2. Select your order import file and target post type
After choosing your upload method, select the order file from your computer, then choose WooCommerce Orders as the post type. The plugin will automatically detect the file type and adjust the interface accordingly.
3. Add filters to import specific orders (optional)
If you want to import only specific orders, you can add filters before continuing. Use the Element, Rule, and Value dropdowns to define which records to import. For this basic walkthrough, we'll skip filtering and import all records.
4. Map your data to WooCommerce order fields
Next, the Drag & Drop screen appears. On the left side, you'll see the data panel with all WooCommerce order fields organized by category. On the right side, you'll see the columns from your import file.
Drag a column field from the right side and drop it onto the matching WooCommerce order field on the left. This tells the plugin which data in your file should go into which order field.
For example, drag the column that contains customer first names into the Billing First Name field. You can click the Preview button at the bottom to see exactly how the data will look on the order screen on the backend and frontend once imported.
Once satisfied, click the Continue to Import Settings button.
5. Run the WooCommerce order import
Once you're satisfied with the preview, click the Continue to Import Settings to move to the next page. Here, you can:
- Set a unique identifier (the plugin can auto-detect this for you)
- Choose what to do when the import runs again (create new orders, update existing ones, etc.)
- Schedule the import to run automatically
- Adjust Advanced Options
For now, click Confirm & Run Import.
After the import finishes, verify the imported orders in your WooCommerce dashboard under WooCommerce, then Orders.
That's the basic WooCommerce order import process using WP All Import. Most imports of a few hundred orders complete in a few minutes.
What Fields Can You Import into a WooCommerce Order
WooCommerce orders contain a lot more data than the basic order number and total (see the full field list in the export section above). When importing, you can map your file's columns to any of these order fields using the drag and drop interface.
Click the Preview button at the bottom to see exactly how the mapped data will look on the order screen once imported. This lets you verify your mapping before running the actual import.
What Else Can You Do with WooCommerce Order Export and Import?
The basic export and import process handles most order data, but WooCommerce orders often contain specialized data that requires extra attention. The most common scenarios are product variations, refunds, subscriptions, and custom fields from plugins like ACF, JetEngine, and MetaBox.
All of these are fully supported by WP All Export and WP All Import. Let’s look at.
How to Handle Specialized WooCommerce Order Data
The following sub-sections cover the most common types of specialized order data. Skip to the one that matches your scenario.
Export and Import WooCommerce Orders with Product Variations
If your store sells variable products (different sizes, colors, materials), your orders include line items tied to specific variations. Each variation has its own attributes, SKU, and pricing, and that data needs to travel with the order when you move it between stores or sync it with a 3PL.
The process is straightforward. On the export side, you include the variation fields from the Items section of the Available Data panel, which captures attributes, SKU, and per-variation pricing. On the import side, the key requirement is that the products must already exist on the destination site, since orders are matched to products using SKU. If the products don't exist yet, you'll need to import them first.
We have a detailed article on how to export and import WooCommerce orders with product variations that walks you through the full process, including how to handle special cases such as real-time export.
Export and Import WooCommerce Order Refunds
Refunds are a separate set of data within an order. Each refund has its own ID, reason, refunded line items, and amounts, with both full and partial refunds supported. When moving order data between stores or syncing with accounting software, the refund data needs to come along with the order.
The Refunds section of the Available Data panel includes all the refund fields, so you can include them in your export just like any other order data. On the import side, refund data is handled in a dedicated Refunds tab in the drag-and-drop screen, where you map your file's refund columns to the order's refund fields.
We have a detailed article on how to export and import WooCommerce order refunds that walks you through the full process, including how to handle full vs. partial refunds and preserve the link between refunds and their original orders.
Export and Import WooCommerce Subscription Orders
If you use the WooCommerce Subscriptions extension, your orders include subscription-specific data beyond the standard order fields. This includes subscription status, renewal dates, trial periods, and parent order references. The basic export and import loop handles standard order data, but subscription data needs extra attention to ensure subscriptions continue working correctly after a migration or sync.
The process requires the WooCommerce Subscriptions extension to be active on both sites. On the export side, subscription data is present in the Custom Fields panel under Items.
On the import side, the subscription data needs to be mapped carefully to preserve the relationships between the subscription, its parent order, and the customer.
We have a detailed article on how to export and import WooCommerce subscription orders that walks you through the full process, including how to preserve recurring behavior and link subscriptions to their parent orders and customers.
Export and Import WooCommerce Orders with ACF Custom Fields
Many stores add custom fields to orders using the Advanced Custom Fields (ACF) plugin. These fields include gift messages, personalization details, delivery windows, and internal notes. Both WP All Export and WP All Import have an ACF Add-On that makes these fields available in the drag and drop interface, just like standard order fields.
The process is simple once the ACF Add-On is active. On the export side, your ACF fields appear in the Available Data panel under the Advanced Custom Fields section, and you can include them in your export alongside standard order fields. On the import side, the Advanced Custom Fields Add-On section in the drag and drop screen lets you map your file's columns to the ACF fields, with options to update all ACF fields or only specific ones on subsequent runs.
We have a detailed article on how to export WooCommerce orders with ACF custom fields that walks you through the full process, including how to export ACF fields with data.
If you use any other custom field plugin, we have dedicated articles on those as well:
- How to Export Advanced Custom Fields (ACF)
- How to Export Meta Box Custom Fields
- How to Export JetEngine Fields
Real-World Workflows for WooCommerce Order Export and Import
The following section covers common real-world workflows that go beyond the basic export and import process. Click into whichever matches your situation.
Set Up a Real-Time Order Export to Google Sheets
For ongoing visibility into your orders, you can push each new order to a Google Sheet the moment it's placed on your site. This is useful for live dashboards, team collaboration, or any workflow that needs up-to-the-minute order data.
The process combines a real-time export trigger with a Zapier action. In the export settings, you enable the option to export each order in real time as it's completed. Then, in Zapier, you set up a trigger that fires on every completed export and an action that adds the order data as a new row in your Google Sheet. Once published, every new order flows into your sheet automatically.
We have a detailed article on how to set up a real-time WooCommerce order export to Google Sheets that walks you through the full process, including the exact trigger and action settings in Zapier.
Export WooCommerce Orders for Bookkeeping`
If you share order data with your accountant or bookkeeper, they typically need a specific set of fields: order totals, taxes, fees, line items, and payment information. The exact format depends on the accounting tool, but most need CSV or Excel with consistent column layouts.
The process is straightforward. On the export side, you build an order export that includes exactly the fields your bookkeeper needs, often grouped by order, customer, and line item. You can schedule the order export to run automatically on a weekly or monthly cadence so the data is always current.
We have a detailed article on how to export WooCommerce orders for bookkeeping that walks you through the full process, including the specific fields and formats that work best for accounting tools.
Export WooCommerce Orders to Shipping Platforms
If you use a shipping aggregator like ShipStation, EasyPost, or a 3PL's platform, you typically need to feed orders in a specific format that the platform can read. Most shipping platforms accept CSV or XML, but the column or element layout is usually specific to the platform.
The process is flexible. You can build a custom export layout that matches your shipping platform's required format, including only the fields the platform needs: order ID, shipping address, line items, weights, and so on. You can also schedule the export to run automatically and use Zapier to push the data to the shipping platform in real time.
We have a detailed article on how to export WooCommerce orders to shipping platforms that walks you through the full process, including how to match your export layout to common shipping platform requirements.
Final Thoughts - WooCommerce Order Export and Import
You can get your first export or import done in just a few minutes. From there, the same process grows with you as your needs get more complex. What starts as a simple monthly export to your bookkeeper might eventually become a real-time feed to your shipping platform or a full migration to a new store. The workflow stays the same regardless of complexity.
The order data in your WooCommerce store isn't locked in. You can move it to accounting tools, shipping platforms, CRMs, ERPs, spreadsheets, or other WooCommerce stores. The export and import setup handles the movement, so you're not stuck with manual workarounds.
Frequently Asked Questions - WooCommerce Order Export and Import
Can I export orders with custom checkout fields?
WP All Export integrates with various custom fields plugins and can automatically detect most fields added by checkout field plugins. The fields appear in the Available Data panel, usually under Custom Fields or Other. You can drag and drop them into your export just like standard order fields, and they'll travel with the data on import.
How do I handle orders with custom order statuses?
WP All Export captures the order status field as it is, including any custom statuses added by plugins. The status is exported as a text value. If you're importing to a store without the same custom statuses, create them first or map the status to an existing one.
Can I export orders that are still in draft or pending status?
WP All Export exports all orders by default, regardless of status (pending, processing, completed, cancelled, etc.). To export only specific statuses, you can use the Add Filtering Options panel to filter by order status. This is useful for reporting on in-progress versus completed orders.
