Export WooCommerce Order Details to CSV / Excel

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

Check the video – Export WooCommerce orders

Export WooCommerce Data

This is a very powerful dashboard and allows you to export all woocommerce Order data. This is one of the dashboards available as part of this woocommerce reporting plugin

This is a very unique and user friendly way to preview your woocommerce orders and export them once you have selected what you need.

How do you select WooCommerce Orders to Export

It provides a date filter on the top. Using the date filter you can select the date range for all your orders.
You can then pick what order status you wish to preview (completed, cancelled, on-hold, processing etc)

On the left side, you can pick different meta data filters. These include all the additional meta fields your Woocommerce Store might have installed via plugins and extensions. Once you pick a meta field, you can then select the values you wish to zoom in.

And finally, you can select the number of rows you wish to export. Change this from the drop down.

Once all the rows are displayed, you can click on the Excel icon to export woo data

Filters for : WooCommerce export orders

Order Status completed 
Order Status  cancelled 
Order Status  failed 
Order Status  on-hold 
Order Status  pending 
Order Status  processing 
Order Status  refunded

Period Range for exporting details from woocommerce orders

Period RangeRolling 12 months
Period RangeFiscal Year to date
Period RangeCurrent Quarter
Period RangeCurrent Month
Period RangePrevious Quarter
Period RangePrevious Month
Period RangeLast 90 Days
Period RangeLast 30 days
Period RangeLast 14 Days
Period RangeLast 7 Days

Deposit orders and Meta Data Filters

IncludeDeposit Orders
ExcludeDeposit Orders
IncludeMeta Data
ExcludeMeta Data

List of WooCommerce Reports in the main plugin

Powerful Meta Data Filter

The meta data filter allows you to Include or Exclude certain meta fields from your export of woocommerce orders

  • Export all orders that contain a particular payment type (say paypal)
  • Export all orders that contain Paypal and Stripe as payment type
  • Export all Orders that are not paid via Paypal
  • Export all Orders that Ship to a particular country (e.g _shipping country is Australia)
  • Export all Orders that Ship to USA
  • Export all Orders that ship to particular States within USA (e.g Florida and Virginia)

Drill down to Order Line Items

In the latest update, we include a drill down mechanism. Once you find all your orders you can click on the order and the grid view below the main will show all the line level details. This is to verify and extract any product related information

Filter by Product Name

On the right hand side, you can see a list of all Product Names – SKUs. You can pick one product or multiple products. This filter will allow you to display all orders that contain the selected products.


This Export WooCommerce Order report was built using SQL Dashboard Creator and adapted as a full plugin for woo-commerce reports and dashboard

You should also check out Sales reporting by Country for woocommerce

You should definitely check out the Sales Trending/Analysis/Summary report available within the Ultimate WooCommerce Reporting plugin

Check how to Install Sales Reporting plugin for Woocommerce

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH