Advanced Order Export For WooCommerce
Advanced Order Export For WooCommerce
Description
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
- Export a single order immediately after a status change (e.g., after payment)
- Export orders on a flexible schedule
- Exported orders can be sent to multiple locations at once – via email, FTP, and various APIs
- Updating Google Sheets/Drive is also possible, but this requires Zapier service
For complete list of features – please visit Advanced Order Export For WooCommerce
Compatibility
Our plugin correctly exports custom fields (added by 3rd-party plugins) in most cases. But for some complex plugins – you should use snippet.
Installation
Automatic Installation
Go to WordPress dashboard, click Plugins / Add New , type ‘Advanced Order Export For WooCommerce’ and hit Enter.
Install and activate plugin, visit WooCommerce > Export Orders.
Manual Installation
Screenshots
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".
Faq
Please, review user guide at first.
Check some snippets for popular plugins or review this page to study how to extend the plugin.
Still need help? Create ticket in helpdesk system. Don’t forget to attach your settings or some screenshots. It will significantly reduce reply time 🙂
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”.
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).
Please, unmark checkbox “Summary Report By Products” (it’s below date range)
It’s a normal situation. The plugin hides this warning on successful load.
I’m sorry, but it’s impossible. You should add this attribute to Products>Attributes at first and use “Filter by Product Taxonomies”.
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)
The theme or another plugin outputs some lines. Usually, there are extra empty lines at the end of functions.php(in active theme).
Please, increase “memory_limit” upto 256M or ask hosting support to do it.
You should open tab “CSV” and set up ISO-8859-1 as codepage.
This button processes only first 5 orders by default, so you should run the export to see correct values.
Free version doesn’t save generated file on your webserver, you can only download it using browser.
Yes, you can email a request to aprokaev@gmail.com. We intensively develop this plugin.
Reviews
Excellent
By 
works 100%
awesome support
By 
i got awesome support, thank you
Perfect Plugin, Great Support!
By 
Perfect Plugin, Great Support!
Really impressive!
By 
It works really well, it's powerful, and the support was amazing!
Amazing Plugin and Support!
By 
This plugin does everything I need and more. I'm helping a non-profit export orders that include custom fields created by another plugin. I wasn’t sure if I could include this custom metadata in my reports, so I reached out to the developer. They responded within a few hours and helped me resolve the issue. Thank you!
Highly recommended, support is incredible!
By 
I have been using this plugin as well as several other Algol plugins and they work straight out of the box, if we have ever had any questions about the plugin Alex and his team have always got back to me extremely quickly and been very helpful. I would recommend this plugin highly.
Great plugin!
By 
It does EXACTLY what I need - filters orders by product and tells me who purchased that product. And you can export the results using various headings that you can turn on and off. Brilliant!
Better support than many premium plugins
By 
I had a self-created problem from the use of some plugin hooks and the author took care to get to the bottom of the issue.
Frankly I don't think I've ever received support like that on a plugin.
Finest Plugin Greatest Support
By 
This is one of the greatest plugin several features and support is just great if you are dealing with Alex that's it problem solved!
Highly recommended!
This plugin is everything that's right and more
By 
This plugin is everything that's right and definitely deserves your attention. Without a doubt, this is one of the best plugins for WooCommerce out there.
It is easy to use, lightweight, well coded and tremendously powerful. It also has very well divided features between the free version and the PRO version (which is very worthwhile, by the way).
And to top it off, THE SUPPORT… is simply out of this world. The patience to understand what is being asked and the incredibly good predisposition to achieve it are really outstanding and give a value like I never saw in other plugins.
You guys really nailed it and I take my hat off to the quality of the plugin and the service you provide.
Well done!
Changelog
4.0.5 – 2025-09-03
- Requires PHP 7.4+
- Updated library used to generate Excel files
4.0.4 – 2025-09-01
- Fixed bug – option “Skip fully refunded items” conflicted with mode “Export refunds”
- Fixed bug – fatal error when exporting refunds (if main order is missing)
4.0.3 – 2025-07-07
- Mode “Export refunds” supports product filters
- New option “Skip order having any excluded products” (>Filter by product)
- New fields “Brand”, “Cost of goods” (>Setup Fields>Products)
- Fixed bug – field “Coupon description” was empty
- Fixed bug – duplicates in export if many orders have same dates
- Fixed bug – PHP functions (added to section “Misc Settings”) shown error “Cannot redeclare function”
- Fixed bug – incorrectly declared HPOS compatibility
4.0.2 – 2025-04-01
- Fixed critical bug – fatal error on page load (if WooCommerce runs in mode “WordPress posts storage (legacy)”)
- Fixed critical bug – conflict with other plugins used outdated versions of same libraries (“FileBird Pro” and etc)
4.0.1 – 2025-03-26
- Uses new library to generate Excel files. If you created custom code to format Excel files – please migrate from PHPExcel to PhpSpreadsheet
- Fixed broken bulk actions
3.6.0 – 2025-03-04
- Changed behavior for mode “Export refunds”!
- New field “New or Returning” (>Setup Fields>Customer)
- Added option “Auto row height” to section “XLS”
- Fixed bug – product filters were applied to export via “Bulk actions”
- Fixed bug – wrong sorting for XLS/PDF formats, in mode “Export without progress”
3.5.8 – 2025-01-28
- Internal, not released
3.5.7 – 2025-01-20
- Added checkbox “Display summary row” to section “Setup Fields”
- Added option “Exclude free items” to section “Filter by item and metadata”
- New field “Quantity (Refunded)” (>Setup Fields>Product Order Items)
- New field “Tax Rates” (>Setup Fields>Product Order Items)
- Added tip (with expected action) for new field created via >Setup Fields>Add Field
- Fixed bug – wrong values in field “Currency symbol”
- Fixed bug – critical error for XLS format if sorting by numeric field
- Fixed bug – option “Export all products from the order” now ignored if all product filters are empty
- Fixed PHP8.4 notices and warnings
3.5.6 – 2024-11-11
- Fixed “PHP Object Injection” (CVE-2024-10828). Thank @webbernaut for reporting this vulnerability!
- New field “Cart Discount Amount(inc. tax)” (>Setup Fields>Cart)
- Fixed bug – field “Embedded product image” was empty if some CDNs were active
3.5.5 – 2024-10-11
- New field “GTIN/EAN” (>Setup Fields>Products)
- Hide item meta started with underscore, by default
- Fixed bug – extra html in item meta
- Minor bugs
3.5.4 – 2024-09-18
- Added extra checks and made error messages more informative
- Use user_id as grouping key for mode “Summary Report by Customers”, billing email is still used for orders made by guests
- Fixed bug – option “Skip Suborders” suppressed option “Export Refunds”
- Fixed bug – field “Product Variation” was wrong (some woocommerce hooks were not applied to it)
- Fixed bug – empty field “Total amount(inc tax)” for mode “Summary Report By Products”
- Fixed bug – some temporary files were not deleted after exporting XLS/PDF files
- Fixed bug – XLS failed to export arrays, in modes “Summary Report By Products/Customers”
3.5.3 – 2024-06-03
- Fixed PHP8 notices and warnings
- Fixed non-reported bugs, detected by PHPStan
3.5.2 – 2024-05-27
- XLS/PDF formats support AVIF product images
- Added “Stop renewal after” and “Subscription price” fields to >Setup Fields>Products (if Woo Subscriptions is active)
- Fixed bug – empty “Custom Fields” dropdown in section “Filter by order” (HPOS mode, big shops only)
- Fixed bug – missed header line for XLS/PDF if nothing to export
- Removed inactive suspicious function to avoid false warnings from security plugins
3.5.1 – 2024-04-25
- Reduced page loading time for stores with a huge number of orders
- Fixed bug – can’t mark/unmark exported orders if sync with legacy is off (HPOS mode)
- Fixed bug – can’t filter orders by “_billling” / “_shipping” order meta (HPOS)
- Fixed bug – can’t filter orders by “_payment_method” order meta (HPOS)
- Fixed bug – sections “Filter by billing/shipping” displayed empty dropdowns (HPOS)
- Fixed bug – field “customer_user” is 0 for guests now (reverted change)
- Fixed bug – some metas can not be read for orders (legacy mode)
- Fixed bug – customer stats was different in HPOS and legacy mode
- Fixed bug – PHP warnings for “Coupon description” field
- All dropdowns are searchable in section “Setup Fields”
3.5.0 – 2024-04-03
- The plugin requires at least WooCommerce 4.0.0
- Fixed bug – some address fields were empty for refunds
- Fixed bug – option “Shipping fields use billing details” ignored fields “Shipping Company” and “Shipping Phone”
- Fixed minor bugs, only for WooCommerce in legacy mode
3.4.6 – 2024-03-25
- New field “Origin” (>Setup Fields>Common)
- XLS format supports .webp product images
- Fixed bug – DESC sorting didn’t work for number/money fields (XLS/PDF formats)
- Fixed bug – PHP 8.1 errors for XLS format
- Fixed bug – empty section “Custom Fields” in “Filter by order”, if shop has 1000+ orders
3.4.5 – 2024-01-10
- Fixed RCE vulnerability
- Tweaked PDF format
- Fixed bug – sorting by Order fields didn’t work for XLS/PDF
- Fixed bug – PHP warnings for address fields
3.4.4 – 2023-11-27
- Fixed critical bug – some columns were empty (XLS format only)
- Added field “Full Address” to sections Billing and Shipping
- Minor UI tweaks in mobile view
- Fixed bug – >Filter by order>Custom Fields didn’t work, HPOS mode
3.4.3 – 2023-11-14
- Speed up calculation for fields “Customer Total Orders”, “Customer Total Amount” in “Summary report by customers” mode
- Added operator NOT LIKE, for filtering by user fields and order fields
- Added compatibility with plugin “Transients Manager”
- Replaced confusing icon “Σ” with text “Sum”
- Fixed bug – incorrect timezones used in filtering by date, HPOS mode
- Fixed bug – option “Shipping fields use billing details” didn’t work, HPOS mode
- Fixed bug – empty address fields for order refunds, HPOS mode
- Fixed bug – date fields were wrongly formatted if timestamp used in database
- DEV – moved common code from Extractor and Extractor_UI classes to traits
3.4.2 – 2023-07-26
- PDF format supports .webp product images
- Fixed bug – missed Bulk Actions in >WooCommerce>Orders (HPOS mode)
- Fixed bug – option “Do not set a page break between order lines” worked wrongly for PDF
- Fixed bug – field “Customer Role” was empty if user has multiple roles
- Fixed bug – PHP8 warnings and errors for XLS format
- Fixed bug – PHP8 warnings for PDF export
3.4.1 – 2023-04-11
- Internal, not released
3.4.0 – 2023-03-13
- Support High-Performance order storage (COT)
- Added field “Customer Paid Orders”
- Fixed bug – filter by paid/completed date ignored DST
- Fixed bug – role names were not translated in field “User role”
- Fixed bug – field format was ignored for fields added via >Setup Fields>Customer>Add Field
- Fixed bug – capability “edit_themes ” was not checked when importing JSON configuration via tab Tools
- Fixed PHP8 deprecation warnings for JSON,XML formats