---
title: "How to Export All WooCommerce Orders into CSV or Excel"
url: "https://wpimportexport.com/how-to-export-all-woocommerce-orders-into-csv-or-excel/"
description: "Export WooCommerce orders to CSV or Excel with status filters, customer details, SKUs, line items and refunds. Follow the admin steps or use an AI agent."
type: post
published: 2026-10-12T09:02:26+00:00
modified: 2026-11-14T10:39:54+00:00
categories: ["Export Guides", "WooCommerce", "WordPress Data Guides"]
tags: ["CSV Export", "Import Export by RockStarLab", "WP Import Export"]
docs_topics: ["WooCommerce"]
---

# How to Export All WooCommerce Orders into CSV or Excel

An order number and a total are rarely enough. Accounting wants tax and payment status, the warehouse wants SKUs, variation IDs and quantities, and refunds have to show up somewhere. In **Import Export by RockStarLab → Export**, choose **WooCommerce Orders (8.0+)**, select the orders and columns and download a CSV or XLSX file. Leave the filters empty for all orders, or narrow them for one report.

Below: which fields to pick for these columns, how to read the file, and how to run the same export with a connected AI agent.

## What you need before exporting orders

- An active WooCommerce store with orders to export.
- **Import Export by RockStarLab PRO**. WooCommerce Orders is a PRO content type; the free plugin alone does not provide this workflow.
- A WordPress account with access to the plugin’s export screens.
- Excel, LibreOffice Calc, Google Sheets or another application that reads your chosen format.

If needed, follow the [plugin installation guide](https://wpimportexport.com/how-to-install-import-export-by-rockstarlab-a-wordpress-import-export-plugin/). Compare editions on the [pricing page](https://wpimportexport.com/#pricing).

Decide what the file is for before selecting every field. A fulfillment list needs delivery addresses and order items. A sales review needs dates, statuses, currencies and amounts. A customer-service handoff may need order notes. Export only the customer information your recipient actually needs.

## Step 1: Choose WooCommerce Orders

Go to **Import Export by RockStarLab → Export** in your WordPress dashboard. Select **WooCommerce Orders (8.0+)** and click **Next Step**.

![Select WooCommerce Orders as the export content type](https://wpimportexport.com/wp-content/uploads/2026/11/orders-01-type.webp)

_Choose WooCommerce Orders (8.0+) to export order records._

This exports order records. The adjacent WooCommerce Products option exports the catalog instead. For current product prices, stock, descriptions or catalog images, follow the [WooCommerce product export tutorial](https://wpimportexport.com/how-to-export-woocommerce-products-to-csv-excel-or-xml/).

## Step 2: Export all orders or apply filters

The **Filter Data** screen shows **Total Items Available**. To export all available orders, leave the filter list empty. Review the count and continue to field selection.

![Export all available WooCommerce orders without filters](https://wpimportexport.com/wp-content/uploads/2026/11/orders-02-scope.webp)

_Leave filters empty to export all available orders._

“All orders” describes the selection, not the payment state. It can include pending, failed, cancelled or refunded orders as well as processing and completed orders. Do not treat the total of an unfiltered file as collected revenue.

### Export orders with a specific status

1. Click **Add Filter**.
2. Select **Status**.
3. Choose **Equals**.
4. Enter the stored status value, such as `completed`, `processing` or `pending`.
5. Refresh the count and confirm the selection before continuing.

![Filter WooCommerce orders by pending status](https://wpimportexport.com/wp-content/uploads/2026/11/orders-03-filter.webp)

_Use a status filter to narrow the order selection._

For example, `pending` selects orders awaiting payment. Use `completed` when the report specifically requires that status. A zero count can simply mean nothing matches. Compare the filter with **WooCommerce → Orders** before assuming an export problem.

### Select the right date for your report

The date fields include **Order Date**, **Date Modified**, **Completed Date** and **Paid Date**. They answer different questions. Order Date describes creation time; Paid Date is relevant to a recorded payment; Date Modified can include older orders changed recently.

Choose the field and the comparison offered for it, then enter the reporting boundary. For a monthly report, define both the beginning and end of the period. Check whether an end date represents midnight or the entire final day, and keep the store’s time zone consistent. Compare orders near the boundaries before relying on the file.

Other available fields can narrow the export by customer, amount or payment method. Use the stored value: a gateway’s internal identifier may differ from its display title. For additional patterns, see [WordPress export filter examples](https://wpimportexport.com/wordpress-export-data-filters-examples-how-to-use-them-effectively/).

## Step 3: Select the order fields

On **Select Fields**, build the **Export File Structure** from the available groups. Use **Add all** for a broad file, or select the fields required for your report. Each selected field displays the key behind its column.

![Choose order fields for CSV or Excel export](https://wpimportexport.com/wp-content/uploads/2026/11/orders-04-fields.webp)

_Build the file structure from order, customer, amount and item fields._

| Purpose | Useful fields | What to check |
| --- | --- | --- |
| Identify orders | `ID`, `order_number`, `order_status` | Keep a stable identifier when combining exports. |
| Report dates | `order_date`, `paid_date`, `completed_date`, `date_modified` | Choose the date that matches the reporting question. |
| Review amounts | `currency`, `order_total`, `order_subtotal`, `order_shipping`, `order_discount`, `total_tax` | Group totals by currency and avoid adding tax components twice. |
| Identify customers | `customer_id`, `billing_email`, billing names | Guest orders may have no registered customer account. |
| Prepare deliveries | Shipping name, company, address, city, postcode and country | Billing and shipping details are separate field groups. |
| Read purchased products | `order_items`, `item_count` | The array holds item records; item count represents units. |
| Review payments | `payment_method`, `payment_method_title`, `transaction_id` | Unpaid orders may have empty payment fields. |
| Retain supporting details | `shipping_lines`, `fee_lines`, `coupon_lines`, `refunds`, `order_notes`, `order_meta` | Array fields contain structured data within a cell. |

For a compact order report, start with ID, order number, status, order date, currency, total, billing email and payment method. Add **Order Items (Array)** for purchased products and **Refunds (Array)** for refund details.

Field transformations are available for selected columns. Keep the raw values for the first export; introduce formatting when the receiving system actually needs it. The [transformation functions guide](https://wpimportexport.com/content-transformation-functions-for-wordpress-import-and-export/) explains that workflow separately.

## Step 4: Choose CSV or Excel and start the export

Click **Next Step** to open **Export Format**. Choose **CSV** for a text-based exchange file or **XLSX** for an Excel workbook.

![Configure CSV headers delimiter filename and batch size](https://wpimportexport.com/wp-content/uploads/2026/11/orders-05-format.webp)

_Choose the export format, keep column headers and name the file._

| Format | Good fit | Important detail |
| --- | --- | --- |
| CSV | Importing into another tool or sharing a widely supported text format | Choose the expected delimiter. Read the file with a CSV parser that respects quoted cells. |
| XLSX | Opening a workbook in Excel or a compatible spreadsheet application | Choosing Excel does not flatten order items into separate rows. |
| JSON or XML | An integration that explicitly expects one of these formats | Confirm the receiver’s expected structure, not only the extension. |
| ODS | An OpenDocument spreadsheet workflow | Use it when that is the recipient’s preferred format. |

For CSV, keep **Include Header Row** enabled and choose the delimiter. Keep the spreadsheet header option enabled for XLSX too. Headers make the file understandable and help another importer map its fields.

Enter a **Custom export file name** without an extension, such as `woocommerce-orders-{job_id}`. The plugin adds the correct extension. The `{job_id}` placeholder distinguishes successive exports.

**Batch size** controls the number of orders processed per batch, not the total selection. Smaller batches can help on a constrained server. Orders with many items or notes may require more processing than simple orders, so there is no universal speed based on row count alone.

Click **Start Export** and wait for completion.

## Step 5: Download and check the file

The completion screen shows the exported count and a **Download Export File** button. Select **Download as ZIP** if you want the generated export packaged in an archive.

![Completed WooCommerce order export ready to download](https://wpimportexport.com/wp-content/uploads/2026/11/orders-06-complete.webp)

_Download the file after the export completes._

Before handing the file to someone else, check:

1. **Selection:** row count and order identifiers match the intended status or reporting period.
2. **Columns:** the file includes line items, refunds and other required fields.
3. **Values:** compare representative rows with their records under **WooCommerce → Orders**, including currency, quantities, status and amounts.

You can return to [Jobs Log to inspect completed exports](https://wpimportexport.com/how-to-use-jobs-log-and-schedule-wp-import-and-export-jobs/). For recurring reports, configure [a repeated export schedule](https://wpimportexport.com/how-to-schedule-repeated-exports-in-wordpress/) after the one-off output is correct.

## How line items, SKUs and variations appear

The order export uses **one row per order**. An order with two product lines does not automatically create two spreadsheet rows. Include `order_items` to retain the product lines as structured data inside the order row.

Each item can contain its name, product ID, variation ID, SKU, quantity, subtotal, total, taxes and item metadata. For a variation purchase, its variation ID and SKU identify the purchased option; metadata can retain attributes such as color.

Consider these two lines in one order:

| Product | SKU | Quantity | Line total |
| --- | --- | --- | --- |
| Hoodie with Logo | woo-hoodie-with-logo | 2 | 98.00 |
| V-Neck T-Shirt, blue variation | woo-vneck-tee-blue | 1 | 15.00 |

There are two item records but three units. An `item_count` of `3` is consistent with a two-element `order_items` array. Without extra shipping, tax or discounts, the order total is `113.00`.

CSV quotes structured values so commas inside them remain part of one cell. Do not split the file by every comma in a text editor. A long JSON cell may look clipped in Excel until you expand it; inspect the full value before assuming products are missing.

If your reporting tool requires one row per product, expand the item array downstream and keep the parent order ID on every resulting row. Do not sum the repeated order total once per product: use the appropriate line totals for product-level reporting.

## Order totals, payments and refunds are different values

A pending order can contain products and a total while its paid date and transaction ID remain empty. Include the status and payment fields to distinguish an order being placed from a payment being recorded.

A partial refund does not necessarily replace the original order total. For example, an order of `113.00` with a refund of `10.00` can retain both values. Keep refund data alongside the original total rather than expecting every amount column to become `103.00`.

For a file focused on refunds, use the [dedicated WooCommerce refund export guide](https://wpimportexport.com/how-to-export-all-woocommerce-refunds-to-csv-or-excel/). For payment reconciliation, compare the relevant payment records too; an order export is not a gateway settlement report.

## Export WooCommerce orders with an AI agent

A connected AI agent can use the plugin’s order export workflow instead of clicking through the wizard. It needs access to the PRO order-export abilities. Start with the [WordPress Abilities API and AI-agent setup guide](https://wpimportexport.com/how-to-use-the-wordpress-abilities-api-with-ai-agents-exports-imports-content-sync-and-backups/) if the connection is not ready.

Ask the agent to discover available abilities and read their input schemas first. This gives it the actual fields and options on your site instead of guessed parameters.

### Prompt: export all orders to CSV

> Connect to my WordPress site and discover the Import Export by RockStarLab abilities. Read the capability and WooCommerce order export schemas. Export all WooCommerce orders to CSV with a header row. Include order ID, order number, status, currency, order date, paid date, customer ID, billing email, total, order items and refunds. Use only supported field keys. Name the file woocommerce-orders-{job_id}. Do not modify orders, customers, products or settings. Monitor the job until completion, report the exported count and return the browser download link.

### Prompt: create an Excel order report

> Export all WooCommerce orders to an XLSX workbook using Import Export by RockStarLab. Discover the available fields first. Include identifiers, status, currency, creation and payment dates, totals, billing details, order items and refunds. Keep headers and original values. Do not flatten item arrays or change store data. Wait for completion and provide the download link with an explanation of array-valued columns.

### Prompt: prepare a monthly report

> Prepare a CSV export of WooCommerce orders created during October 2026 with status completed. Inspect the supported filters first and state the date boundaries and time zone you will use. Include order number, status, order date, paid date, currency, total, payment method, order items and refunds. If the available abilities cannot represent this exact selection, explain that before starting. Export only; do not update records. Report the count and download link.

Replace the example month and status with your reporting period. If the result is empty, ask the agent to check the selection instead of silently broadening it to all orders.

### What the agent does behind the scenes

1. Discovers abilities and reads `rsl-ie/get-capabilities`.
2. Reads the schemas and inspects `rsl-ie-pro/get-content-schema` for `woo_order`.
3. Starts `rsl-ie-pro/export-start` with the format, fields, options and request ID.
4. Monitors the returned job through `rsl-ie/job-get`.
5. Retrieves the finished file through `rsl-ie/file-get` and returns its `browser_download_url`.

The browser download link may require you to be signed into WordPress. A raw API endpoint can require API authentication instead. Ask for the browser link for an interactive download.

Open **Jobs Log** afterward and compare representative file values with the WooCommerce order screens, as you would for a manual export. A successful result means a completed file, not just a job that was started.

## Common export problems and what to check

| Symptom | Check |
| --- | --- |
| Zero matching orders | Review status values and dates. Confirm the orders exist and that you selected the intended date field. |
| Product lines are missing | Include Order Items (Array). An order total or item count does not replace item details. |
| CSV opens in one column | Import with the delimiter selected during export rather than relying on automatic detection. |
| Long JSON looks cut off | Inspect the complete cell value. Arrays are structured cell contents, not separate product columns. |
| Paid date is blank | Check the source order. Unpaid orders may legitimately lack recorded payment information. |
| Postcodes or identifiers change in Excel | Import those columns as text where necessary and keep the original download unchanged. |
| Custom information is absent | Review selected fields and order metadata. Another extension may store its information separately. |
| Export has not completed | Check job status and messages before creating a duplicate job. Review server processing and batch settings if stalled. |

## When you need migration or a full backup

A spreadsheet is useful for reporting and data exchange. It is not a complete store backup and does not, by itself, move the related catalog and customer accounts to another site.

For a site-to-site move, follow the [WooCommerce store data migration tutorial](https://wpimportexport.com/how-to-migrate-woocommerce-store-data-to-another-site/). For a restorable website backup, use the [WordPress backup and restore guide](https://wpimportexport.com/how-to-create-a-wordpress-website-backup-and-restore-it/).

See also: [Export WooCommerce Orders for Accounting](https://wpimportexport.com/export-woocommerce-orders-for-accounting/).

## Frequently asked questions

### Can I export all WooCommerce orders to Excel?

Yes. Choose WooCommerce Orders in Import Export by RockStarLab PRO, leave filters empty, select the fields you need, and choose XLSX. Enable the header row and download the workbook after the export completes.

### Can I export orders by status or date?

Yes. Use the Filters step to restrict the selection. For a status filter, select Status, choose Equals, and enter a stored status such as completed or pending. For a date-based report, choose the appropriate order date field and check the matching count before exporting.

### Does the order export include product SKUs and variations?

Include Order Items (Array) to retain product and variation IDs, SKUs, quantities, line totals and item metadata. In CSV and XLSX, this structured data occupies a cell within the order row rather than automatically becoming separate product rows.

### Why does an all-orders export include pending orders?

An unfiltered export includes orders regardless of payment status. Pending orders can have a total without a recorded payment. Include order status and paid date when separating paid and unpaid orders.

### Are refunds included in an order export?

Include Refunds (Array) to retain refund data alongside the order. Keep the original order total separate from refund amounts. For a refund-focused file, use the dedicated WooCommerce Refunds export workflow.

### Is WooCommerce order export available in the free plugin?

It uses the WooCommerce Orders content type of Import Export by RockStarLab PRO. The same PRO requirement applies when an AI agent starts a WooCommerce order export.

### Can an AI agent export orders without changing them?

Yes. A connected agent can discover the available abilities, inspect the order schema, start an export, monitor the job and retrieve the download link. Ask it explicitly to export only and not modify orders, customers, products or settings.

To build your order report, open **Import Export by RockStarLab → Export**, choose WooCommerce Orders, and start with the selection and columns your report needs.
