To export WooCommerce orders to CSV or Excel, open Import Export by RockStarLab → Export, choose WooCommerce Orders (8.0+), select the orders and columns you need, then download the completed CSV or XLSX file. Leave filters empty for all available orders, or narrow the selection for a particular report.
A useful order spreadsheet needs more than an order number and a total. It may also need billing details, payment status, product SKUs, variation IDs, quantities, shipping charges and refunds. This guide explains how to select those fields, read the resulting file correctly, and run the same task 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. Compare editions on the pricing page.
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.

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.
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.

“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
- Click Add Filter.
- Select Status.
- Choose Equals.
- Enter the stored status value, such as
completed,processingorpending. - Refresh the count and confirm the selection before continuing.

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.
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.

| 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 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.

| 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.

Before handing the file to someone else, check:
- Selection: row count and order identifiers match the intended status or reporting period.
- Columns: the file includes line items, refunds and other required fields.
- 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. For recurring reports, configure a repeated export schedule 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. 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 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
- Discovers abilities and reads
rsl-ie/get-capabilities. - Reads the schemas and inspects
rsl-ie-pro/get-content-schemaforwoo_order. - Starts
rsl-ie-pro/export-startwith the format, fields, options and request ID. - Monitors the returned job through
rsl-ie/job-get. - Retrieves the finished file through
rsl-ie/file-getand returns itsbrowser_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. For a restorable website backup, use the WordPress backup and restore guide.
See also: 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?
This tutorial uses the WooCommerce Orders content type in 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.

Comments 0
Have a question or a tip to share? Leave it below.