Back to blog
12 min read Export Guides

How to Export All WooCommerce Orders into CSV or Excel

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.

Select WooCommerce Orders as the export content type
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.

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

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

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

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

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

Leave a comment

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

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE