Know a company with years of records? Refer it and earn up to $100K
System export guide

Export Orders From WooCommerce: CSV, Products and Customers

How to export orders from WooCommerce to CSV, export products and customers, pull every order through the REST API, and choose an order export plugin.

Short answerChecked

To export orders from WooCommerce without a plugin, go to Analytics, then Orders, set the date range and click Download. A one-page report downloads at once; a longer one is emailed to you as a link that works for a week. Products export from Products, All Products, Export, and customers from the Customers report. For every order field and line item, use the REST API or an order export plugin.

Emailed download link
Valid one weekWooCommerce Analytics
REST API page size
10 by defaultChange it with per_page
Order storage on new stores
HPOS tablesDefault since WooCommerce 8.2
A server rack with blue patch cables and a laptop showing a ticket queue
Key points
  • Core WooCommerce exports orders through Analytics, products through the product CSV exporter and customers through the Customers report.
  • Large Analytics downloads arrive by email, and the link works for one week.
  • The REST API returns every order with line items and addresses, 10 orders per page by default, with a read-only key.
  • Order and customer files hold names, emails, phones and addresses. Core WooCommerce does not handle card numbers.

How do you export orders from WooCommerce?

Each kind of record exports from its own place, and core WooCommerce covers most of them without a plugin:

RecordWhere to export itWhat you getLimits to know
Orders (sales report)Analytics, Orders, DownloadA CSV of the Orders report, including the payment methodMulti-page reports are emailed; a refund adds a second row
Every order field and line itemREST API: GET /wp-json/wc/v3/ordersJSON for each order with line items, billing and shipping addresses and totalsNeeds an API key; 10 orders per page by default
ProductsProducts, All Products, ExportA CSV in the product import schema, optionally with custom metaVariation names may lose attribute values
CustomersWooCommerce, Customers, DownloadA CSV with names, emails, order counts, total spend, location and phone numbersGuest orders with one email become one customer
One person's dataTools, Export Personal DataAn HTML file for a privacy requestNot a bulk export
Scheduled or custom exportsAn order export plugin or extensionCSV, Excel, XML or JSON with the fields you pickCheck that it supports HPOS

The sections below walk through each route, then show how to check that two exports agree before you rely on them.

How do you export WooCommerce orders to CSV?

The built-in route is the Orders report in WooCommerce Analytics:

  • Go to Analytics, then Orders, and set the date range at the top of the page.
  • To narrow the export, choose Advanced filters under Show. The report filters by order status, products, coupon codes, customer type, payment method, refunds, tax rates and product attribute (WooCommerce).
  • Click Download: "If you would like to download a copy of the data contained in the report table, use the Download link upper right corner of the table header" (WooCommerce).
  • "If all the report data can be shown on a single screen, without pagination, the CSV file will download immediately." If not, WooCommerce builds the file in the background, and "Once the data is ready to be downloaded, an email will be sent to the address that is attached to your WordPress account with a link to download the file."
  • Use the link within a week: "The emailed download link remains available for one week and can be used more than once during that time."

Two details change your totals. "Refunded orders have two rows in the report: one for the date of the original order and one for the date of refund", and statuses you have excluded in Analytics settings are left out (WooCommerce). On a store that predates Analytics, check Analytics, Settings first: "if your store has Customer and Order data prior to the new Analytics and Sales Reports feature, you may want to import the data to ensure reports are accurate" (WooCommerce).

To get WooCommerce orders into Excel, open the CSV in Excel or import it into a spreadsheet, and keep the original file untouched. The Analytics report is built for sales reporting, so check its columns in a test download. If you need every billing and shipping field, or one row per line item, use the REST API or an export plugin.

How do you export WooCommerce products?

Products have their own tool: "WooCommerce includes a built-in CSV tool for importing, exporting, and bulk-updating products" (WooCommerce).

  • Go to Products, All Products and click Export.
  • Choose the columns, or leave Export all columns selected.
  • Choose product types and categories, or leave the defaults to export the whole catalog.
  • Tick Yes, export all custom meta if plugins store product data you need. Those columns start with meta:.
  • Click Generate CSV. The browser downloads the file.

"A CSV exported with WooCommerce already follows the required schema", so the same file can "move product data between stores". Variations are rows of their own, tied to the parent by its SKU or ID in the Parent column. One quirk: "WooCommerce may exclude attribute values from variation names in exported CSV files", so tell variations apart by SKU and attribute columns, not by name. To export a few items, select them in the product list and use the Export selected button (WooCommerce).

How do you export customers from WooCommerce?

Use the Customers report. Go to WooCommerce, then Customers, filter if you need to, and "Select Download to export the current customer view as a CSV file." Larger reports are prepared in the background and emailed (WooCommerce).

Two things surprise people. Guests are included and grouped: "When a guest places multiple orders with the same email address, WooCommerce associates those orders with the same customer record." And the file holds more than the screen shows: "CSV downloads include Billing phone, Shipping phone, and Role, with Role as the final column, even when the phone columns are hidden in the table." Treat a customer export as personal data from the moment it downloads.

For one person's privacy request, use the WordPress tool instead. "WordPress can export personal data associated with an email address to an HTML file", and WooCommerce adds that person's addresses, orders and download logs to it (WooCommerce).

Export WooCommerce orders with the REST API or the database

For a full history with every field, use the REST API. Create a key under WooCommerce, Settings, Advanced, REST API, and give it read access only; the access level "can be Read access, Write access or Read/Write access" (WooCommerce REST API docs). Then call GET /wp-json/wc/v3/orders, which "helps you to view all the orders", each with its line items and billing and shipping addresses.

  • Page through the results. "Requests that return multiple items will be paginated to 10 items by default"; raise per_page and step through page=1, 2, 3.
  • Read the totals first: "The total number of resources and pages are always included in the X-WP-Total and X-WP-TotalPages HTTP headers."
  • Export one period at a time with after and before. The after parameter will "Limit response to resources published after a given ISO8601 compliant date", and before does the reverse.
  • Save each page as it arrives and keep the order ID on every row; it is the key that joins orders, refunds and line items.

Developers sometimes export straight from the database. Know where orders live first: "HPOS is enabled by default for new installations from WooCommerce 8.2 onward" (WooCommerce). In those custom tables, wc_orders "Stores core order records, including order status, currency, totals, and dates", and wc_order_addresses "Stores billing and shipping addresses for each order" (WooCommerce). Older stores may still keep orders in WordPress posts storage, so check which storage is active before you write SQL.

Do you need a WooCommerce order export plugin?

Not for a one-time sales report. A plugin earns its place when you need one row per line item with custom fields, formats other than CSV, or exports that run on a schedule. Two widely used options, named as examples rather than recommendations:

WooCommerce's own Customer / Order / Coupon Export extension exports customers, orders or coupons "in CSV or XML format, individually or in bulk", and can "Automatically export and send your file to a remote server via FTP, HTTP POST, or email" (WooCommerce documentation). Advanced Order Export For WooCommerce, a free plugin in the WordPress.org directory, lets you "select from various formats to export the data in such as Excel, CSV, XML, JSON, PDF and HTML", and its page says "The plugin is fully compatible with HPOS."

Check before you installWhy it matters
HPOS compatibilityNew stores keep orders in HPOS tables; a plugin that reads the old tables can miss orders
One row per order or per line itemLine-item rows are needed to study products; order rows are needed to count orders
Custom fields and metaSubscription, booking and shipping plugins keep their data in meta fields
Date filters and schedulingExports by period keep files small and repeatable
Where files are sentFiles emailed or sent by FTP carry the same customer data as the store

Can you export where WooCommerce orders came from?

Yes, if order attribution was turned on when the orders were placed. The feature "makes use of a last-click attribution model", and "If the URL that referred the visitor to your site includes UTM parameters, we parse these and store the source, medium, campaign, content, and term parameters" (WooCommerce). The Orders screen also "includes a new column that displays the order origin".

The limit is history: "Order Attribution Tracking data is available only to orders generated when this feature is enabled." To compare orders with ad spend, export the attribution fields with each order and match campaigns to your ad reports by date. The same join is explained step by step for another platform in exporting Shopify orders and joining them to ads data.

Worked example: exporting three years of orders (illustrative)

A fictional store, invented for this page, exports its order history for 2023 to 2025 before it moves platforms. It pulls the orders twice, by two routes, so it can check one against the other. All figures are made up.

FileRouteRowsCheck
orders-2023.jsonl, orders-2024.jsonl, orders-2025.jsonlREST API, read-only key, after and before set to each calendar year4,812 / 6,240 / 7,035 ordersEach file matches X-WP-Total for its year
analytics-orders-2023-2025.csvAnalytics, Orders, Download (emailed link)17,854 rows447 failed and cancelled orders were excluded statuses; 214 refunds added a second row
products.csvProducts, Export, all columns and custom meta1,126 rows: 312 products and 814 variationsVariations matched by SKU and attributes, not by name
customers.csvWooCommerce, Customers, Download9,904 customersIncludes guests grouped by email; contains phone numbers
Net sales by yearAPI line totals less refunds, compared with Analytics net sales$412,380 / $538,910 / $601,225Small gaps traced to refunds dated in the following year

The check is the point: when two routes agree, the owner knows nothing is missing before the old store is switched off. Write down what each column means in a data dictionary while the people who set up the store still remember.

Common mistakes when exporting WooCommerce data

Most bad exports come from a few avoidable errors.

  • Counting Analytics rows as orders. A refunded order appears twice, once on the refund date.
  • Exporting after retention cleanup has run. WooCommerce can clear old orders on a schedule, and "WooCommerce anonymizes cleaned-up completed and refunded orders so sales statistics remain accurate" (WooCommerce). Check Accounts and Privacy first; a blank setting keeps data, a set period removes it.
  • Creating an API key with write access for a read-only export, and leaving it active afterward.
  • Identifying variations by name, when the exporter may drop attribute values from variation names.
  • Expecting attribution data on orders placed before the feature was enabled.
  • Mixing time zones between the store, the API filters and the spreadsheet, so late-night orders land on the wrong day.
  • Emailing a full order or customer CSV around the team. It holds names, emails, phones and addresses.

Is a WooCommerce order history a data asset?

It can be, once it is complete and clean. AI data buyers have asked Origin for records from direct-to-consumer brands whose ads data joins to their store orders. Published buyer requirements for e-commerce order, inventory and shipment tables ask for three to five or more years of history, a consistent schema and, ideally, ongoing refreshes, with customer identities removed. A store that exported its history as above, with attribution fields kept, holds the start of that record. See licensing payments and transaction data for the wider picture.

What must come out first: customer personal data. Order records carry names, emails, phones and billing and shipping addresses, and the orders table also keeps the "IP address used to create the order" (WooCommerce developer blog). Drop those fields, replace customer and order IDs with tokens that keep repeat purchases linked, and reduce addresses to a region (how to de-identify company data). Card numbers should not be there at all, because core WooCommerce "does not handle cardholder data or process payments directly" (WooCommerce), but check what your payment gateway wrote into order notes and meta. Then check your privacy policy and the laws that apply (GDPR and CCPA in data licensing). This is general information, not legal advice.

Origin is an independent data partner. Your company decides what is shared and signs any license itself, and a buyer may pay Origin when a deal closes.

Does your company hold records like these? See what your data is worth.

Common questions

How do I export all WooCommerce orders to CSV?

Go to Analytics, then Orders, set the date range to cover all your orders and click Download. A report longer than one page is built in the background and emailed to you, with a link that works for one week. Older stores should import historical data in Analytics settings first. For every field and line item, page through the REST API instead.

Can I export WooCommerce orders without a plugin?

Yes. Core WooCommerce exports the Orders report from Analytics as a CSV, products from the product CSV exporter and customers from the Customers report. Developers can pull every order through the REST API with a read-only key. A plugin is only needed for custom columns, formats other than CSV, line-item rows with every field, or scheduled exports.

How do I export WooCommerce orders to Excel?

Download the Orders report from Analytics as a CSV and open it in Excel, or use an export plugin that writes Excel files directly. Check that Excel has not changed dates, long order numbers or postal codes with leading zeros, and keep an untouched copy of the original CSV before you edit anything.

How do I export WooCommerce products with variations?

Go to Products, All Products, click Export, keep all columns and all product types, then click Generate CSV. Each variation is its own row, tied to its parent product in the Parent column. Identify variations by SKU and attribute columns, because WooCommerce may drop attribute values from variation names in the exported file.

How do I export a customer list from WooCommerce?

Open WooCommerce, then Customers, set any filters and click Download to get a CSV. The file includes guests, grouped by email address, and includes billing and shipping phone numbers even when those columns are hidden on screen. Large lists are prepared in the background and emailed. Store the file as personal data and delete copies you no longer need.

Why does WooCommerce email my order export instead of downloading it?

Because the report spans more than one page. When all the data fits on one screen, the CSV downloads immediately; otherwise WooCommerce builds it as a background job and emails a link to the address on your WordPress account. The link works for one week and can be used more than once. Check your spam folder if it does not arrive.

What should I look for in a WooCommerce order export plugin?

Look for HPOS compatibility, a choice between one row per order and one row per line item, support for custom fields from your other plugins, date filters, and scheduled delivery if you need it. Check where it sends files, because exports carry customer names, emails and addresses. Test any plugin on a staging copy of the store first.

Does a WooCommerce order export include credit card numbers?

It should not. Core WooCommerce does not handle cardholder data or process payments directly, and gateways that use off-site checkout or hosted fields keep raw card data off your site. Exports still hold names, emails, phones, addresses and payment method names, and some gateways add references to order notes or meta, so review a sample before sharing any file.

Sources and further reading

What is your company’s data worth?

AI companies pay $20K to $5M for company records. Six questions, no files.