sandywp / plugins / woo-order-export-lite

Advanced Order Export For WooCommerce

5.0 out of 5 stars. 5.0 350 reviews

Export WooCommerce orders to Excel, CSV, XML, JSON, PDF and HTML. Best free order export plugin for WooCommerce.

Launch a sandbox with this plugin → No signup.
Ready in seconds.

v4.1.0 100,000+ installs WP 4.7+ PHP 7.4.0+

your-sandbox.sandywp.com/wp-admin
Advanced Order Export For WooCommerce running inside a SandyWP sandbox

What you get inside

6 screens
  • Default view after installation. Just click 'Express Export' to get results.

  • Filter orders by many parameters, not only by order date or status.

  • Select the fields to export, rename labels, reorder columns.

  • Button Preview works for all formats.

  • Add custom field or taxonomy as new column to export.

  • Select orders to export and use "bulk action".

About this plugin

This plugin helps you to easily export WooCommerce order data.

Export any custom field assigned to orders/products/coupons is easy and you can select from various formats to export the data in such as Excel, CSV, XML, JSON, PDF and HTML.

Features

  • select the fields to export
  • rename labels
  • reorder columns
  • export custom fields or terms for products/orders
  • group data by products or customers
  • export orders via bulk action from orders list
  • apply powerful filters and much more

Export includes

  • order data
  • summary order details (# of items, discounts, taxes etc…)
  • customer details (both shipping and billing)
  • product attributes
  • coupon details
  • order item metadata, etc.

Use this plugin to export orders for

  • sending order data to 3rd part drop shippers
  • updating your accounting system
  • analysing your order data

Pro version

Are you looking to have your WooCommerce products drop shipped from a third party? Our plugin can help you export your orders to CSV/XML/etc and send them to your drop shipper. You can even automate this process with Pro version .

Pro version features

For complete list of features – please visit Advanced Order Export For WooCommerce

Compatibility

The plugin is fully compatible with HPOS.
Our plugin correctly exports custom fields (added by 3rd-party plugins) in most cases. But for some complex plugins – you should use snippet.

Questions

I want to add a product attribute to the export

Check screenshot #5! You should open section “Set up fields”, open section “Product order items”(right column), click button “Add field”, select field in 1st dropdown, type column title and press button “Confirm”.

Same order was exported many times

You should open section “Set up fields to export” and set “Fill order columns for” to “1st row only”. The plugin repeats common information for each order item (by default).

I see only GREEN fields in section “Set up fields”

Please, unmark checkbox “Summary Report By Products” (it’s below date range)

Red text flashes at bottom during page loading

It’s a normal situation. The plugin hides this warning on successful load.

I can’t filter/export custom attribute for Simple Product

I’m sorry, but it’s impossible. You should add this attribute to Products>Attributes at first and use “Filter by Product Taxonomies”.

How can I add a Gravity Forms field to export?

Open order, look at items and remember meta name.
Visit WooCommerce>Export Orders,
open section “Set up fields”, open section “Product order items”(at right), click button “Add field”,
select SAME name in second dropdown (screenshot #5)

Plugin produces unreadable XLS file

The theme or another plugin outputs some lines. Usually, there are extra empty lines at the end of functions.php(in active theme).

I can’t export Excel file (blank message or error 500)

Please, increase “memory_limit” upto 256M or ask hosting support to do it.

5.0

350 reviews

  • 5 ★ 345
  • 4 ★ 2
  • 3 ★ 0
  • 2 ★ 1
  • 1 ★ 2

Ratings come from WordPress.org. SandyWP does not collect its own reviews.

sandywp / also on the shelf

Try another plugin

Spin up a real WordPress site in seconds.

Test plugins, build a demo, hand a client a link — then squash it and start again. No local setup, no Docker.