Advanced Order Export For WooCommerce

Wordpress Plugin
Download latest - 3.3.3

Developers

algol.plus

Download Stats

Today 578
Yesterday 726
Last Week 3,424
All Time 174,799


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 CSV, XLS, XML and JSON.

Features

  • select the fields to export
  • rename labels
  • reorder columns
  • export WooCommerce custom fields or terms for products/orders
  • mark your WooCommerce orders and run "Export as..." a bulk operation.
  • 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
  • XLS, CSV, TSV, PDF, HTML, XML and JSON formats

Use this plugin to export orders for

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

Have an idea or feature request? Please create a topic in the "Support" section with any ideas or suggestions for new features.

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 .


Releases (29 )

Version Release Date Change Log
3.3.3 2022-11-03
  • 2022-10-24 =
  • Fixed CSRF vulnerability
  • Added option "Strip tags from all fields" to section "Misc settings"
  • The "Link to edit order" field works for XLS format
  • Fixed bug - "Remove line breaks" option incorrectly replaced commas with spaces
  • Fixed bug - "Sum Items Exported" field was empty for XLS/PDF formats, mode "Summary report by products"
  • Fixed bug - PHP warning if all fields have undefined format
  • Updated Select2.js library
3.3.2 2022-08-08
  • 2022-08-08 =
  • Fixed XSS vulnerability
  • Fixed bug - filter "Orders Range" ignores space chars now
  • Fixed bug - export failed if product used webp images
3.3.1 2022-05-23
  • 2021-05-23 =
  • Fixed critical bug - mode "Add coupons as X columns" exported empty product data
3.3.0 2022-05-18
  • 2022-05-18 =
  • Allow to sort by any field, for XLS/PDF formats only
  • Output summary row, for XLS/PDF formats only
  • Added fields "Phone (Shipping)", "Currency Symbol", "Subscription Relationship"
  • Added fields "Qty-Refund","Amount-Refund", "Total Amount (inc. tax)" for "Summary report by products"
  • Fixed bug - added workaround for last versions of PHP 8.0 and 8.1, they have bug for ob_clean()
  • Fixed bug - option "Remove emojis" damaged last product in export
  • Fixed bug - field type "Link" ignored for XLS format
  • Fixed bug - long text (for some languages) breaks layout for section Setup Fields
  • Fixed bug - can't correctly export custom attribute if it was unused in variations
  • Fixed bug - wrong fee amount exported , in rare cases
  • Fixed bug - incorrect export for mode "Add products as XX columns", rare case too
  • Fixed bug - page was not loaded if website has 10,000+ coupons
3.2.2 2021-12-14
  • 2021-12-14 =
  • Fixed bug - PHP8 compatibility issues (deprecation warnings for XLS format)
  • Fixed bug - blank row was added after every 1000 rows (XLS format)
  • Fixed bug - money cells were empty if value
3.2.1 2021-11-11
  • 2021-11-11 =
  • Fixed critical bug - option "Format numbers" broke XLS format
3.2.0 2021-11-09
  • 2021-11-09 =
  • Speeded up XLS export
  • Added option "Remove emojis" (XLS format)
  • Added option "Remove line breaks" (CSV format)
  • Added field "Total volume"
  • New button "Add calculated field" in section "Setup Fields"
  • Fixed bug - photo missed in product search
  • Fixed bug - can't filter items if item has "&" in name
  • Fixed bug - PHP warnings for deleted taxonomy
  • Fixed bug - long links broke PDF cells
  • Fixed bug - ignored capability "export_woocommerce_orders"
3.1.9 2021-06-22
  • 2021-06-22 =
  • New field "Sum of Items (Exported)" for mode "Summary Report By Customers"
  • Added extra operators for filter by item meta
  • Correctly export description of variation
  • Correctly show alias for deleted role
  • Fixed bug - fatal error if variation was deleted
  • Fixed bug - unixtimestamp exported as number (not date) to Excel
  • Fixed bug - option "Export only matched product items" didn't work if order has variations of same product
  • Fixed bug - TAX fields (added via >Setup Fields>Other items) ignored shipping amount
3.1.8 2021-02-22
  • 2021-02-22 =
  • Fixed XSS vulnerability
  • Screen >WooCommerce>Orders can be sorted by column "Export Status"
  • New field "Order subtotal + Cart tax amount"
  • New field "Shipping Zone"
  • Added operators "IS SET" and "NOT SET" for item meta filters
  • Added option "Don't encode unicode chars" to section "JSON "
  • Fixed bug - some compatibility issues with PHP 7.4
  • Fixed bug - correctly support Loco Translate
  • Fixed bug - weight was rounded for XLS format
3.1.7 2020-12-09
  • 2020-12-09 =
  • New field "Summary Report Total Weight"
  • Added option to round "Item Tax Rate" (Misc Settings)
  • Added option "Force enclosure for all values" (CSV format)
  • Use billing email to calculate field "Customer Total Orders" for guests
  • The plugin supports capability "export_woocommerce_orders"
  • Fixed bug - PDF text didn't fit to cell by width
  • Fixed bug - field "Non variation attributes" showed wrong values for existing taxonomies
3.1.6 2020-09-21
  • 2020-09-21 =
  • New product fields "Item Cost (inc. tax)", "Stock Status", "Stock Quantity", "Non variation attributes"
  • New customer field "Customer Total Spent"
  • Added option "Add links to images" (HTML format)
  • Fixed bug - duplicates were shown in "Summary by products" mode
  • Fixed bug - field "Coupon Discount Amount" was empty
  • Fixed bug - fatal PHP error "Call to undefined method get_duplicate_settings()"
3.1.5 2020-08-26
  • 2020-08-24 =
  • Compatible with PHP 7.4
  • Added option "Format output" (XML format)
  • Added option "Don't break order lines by 2 pages" (PDF format)
  • Added option "Add links to images" (PDF format)
  • Added option "Try to convert serialized values" (Misc Settings)
  • Added fields "Summary Report Total Fee Amount", "Summary Report Total Tax Amount"
  • Fixed bug - 'wc doing it wrong' notice (direct access to product parent property)
  • Fixed bug - option "Change order status" worked only for button "Export w/o progress"
  • Fixed bug - option "Add products as "
3.1.4 2020-04-15
  • 2020-04-15 =
  • Prevent XSS attack (CVE-2020-11727). Thank Jack Misiura for reporting this vulnerability!
3.1.3 2020-03-24
  • 2020-03-24 =
  • Fixed CRITICAL bug - export via "Bulk actions" (at screen >WooCommerce>Orders) works incorrectly
3.1.2 2020-03-23
  • 2020-03-16 =
  • Added filter by order IDs (not order numbers!)
  • Added checkbox "Export only matched product items" to section "Filter by item and metadata"
  • Added checkbox "Shipping fields use billing details (if shipping address is empty)" to section "Misc Settings"
  • Added fields "Item Cost Before Discount", "Item Discount Tax" to section "Product order items"
  • Renamed field "Product Variation" to "Order Item Metadata"
  • Added some tooltips to sections inside "Set up fields"
  • Support tag {order_number} in filename
  • Fixed UI bugs for Firefox
  • Fixed bug - Preview was wrong if CSV format used non-UTF8 codepage
  • Fixed bug - some warnings in JS console
  • Fixed bug - Safari added .csv to any filename when we use TSV format
  • Fixed bug - wrong filters applied when user selected orders and exported them via bulk action
  • New hooks for product custom fields
3.1.1 2019-11-26
  • 2019-11-18 =
  • Field "Embedded product image" is exported by "Summary by product" mode (XLS/PDF/HTML formats)
  • Added checkbox to export item rows with a new line (TAB format)
  • Fixed incompatibility with "Advanced Custom Fields" plugin
  • Fixed bug - product static fields were empty sometimes
  • Fixed bug - adding fields worked incorreclty at tab "Product items"
  • Fixed bug - fields "Categories" and "Full names for categories" were empty for variable products
3.1.0 2019-11-11
  • 2019-11-11 =
  • Speeded up page loading and button "Preview"
  • Added filter "Products SKU" to section "Filter by product"
  • Added options for JSON format
  • Added vertical align for cells (PDF format)
  • New tabs "Product items", "Product totals" in section "Setup fields"
  • Order fields can be dragged to section "Products" (JSON/XML formats)
  • Added product field "SKU(parent)"
  • Added fields "Total Shipping","Total Discount","Total Items" for "Summary by customers" mode
  • Support "0" as max # of product columns (calculated based on exported orders)
  • Deleted products are exported by "Summary by products" mode
  • Fixed UI bugs for summary mode
  • New hooks for PDF format
  • Fixed bug - sorting (by order fields) conflicted with filtering by order custom fields
3.0.3 2019-08-29
  • 2019-08-29 =
  • Fixed CRITICAL bug - export wrong data if user added customer field "First Order Date" or "Last Order Date"
  • Fixed bug - customer fields "First Order Date" or "Last Order Date" were empty for guests
  • Fixed bug - wrong height for cells (PDF format only)
3.0.2 2019-08-20
  • 2019-08-20 =
  • Added "Summary by customers" report
  • Format PDF supports UTF8 chars
  • Added filter "Exclude products" to section "Filter by product"
  • New tab "Other items" (in section "Setup fields") allows to export tax/fee/shipping
  • Fixed bug - XLS export stops at wrong dates
  • Fixed bug - button "ESC" doesn't abort export (Safari only)
3.0.1 2019-07-22
  • 2019-07-22 =
  • Added product field "Product Name (main)" to export name of variable product (not name of variation!)
  • Added summary product fields to export discounts and refunds
  • Fixed bug - bulk exporting from orders page didn't work if you set date range filter at page "Export Now"
  • Fixed bug - it was impossible to add custom field at tab "User"
  • Fixed bug - filter "User roles" applied incorrectly
  • Fixed bug - filter "Item meta" showed wrong results if you tried to filter by different meta keys
3.0.0 2019-07-03
  • 2019-07-03 =
  • New format - HTML
  • Added order field "Link to edit order" (useful for HTML format)
  • Added product field "Embedded Product Image" (works for XLS and PDF formats only!)
  • Added order fields (for customer) - "First Order Date", "Last Order Date"
  • Added 'Hide unused' for order/product/coupon fields (dropdowns filtered by matching orders)
  • Allow to sort orders by any custom field
  • Fixed bug - fields with prefix "USER_" were shown for all tabs in section "Setup fields"
  • Fixed bug - the plugin exported all orders by default (including cancelled and refunded)
  • Fixed bug - bulk export didn't sort orders
  • Fixed bug - incompatibility with some coupon plugins
  • Fixed bug - tab "Tools" didn't show error if JSON is not valid
  • Removed a lot of outdated code
2.1.1 2019-02-18
  • 2019-02-14 =
  • Fixed critical bug - new version damages CSV and TSV parameters, so "Bulk action" doesn't work
2.1.0 2019-02-06
  • 2019-02-06 =
  • New format - PDF
  • Fixed some vulnerabilities
  • Added button "Reset settings"
  • Section "Setup fields" works on phone/tablet
  • New XLS option to avoid formatting - "Force general format for all cells"
  • Fixed bug - fields "Summary Report Total xxxx" stayed at bottom
  • Fixed bug - "Summary report" was not sorted by item name
  • Fixed bug - fields reset when user switches between flat formats
  • Fixed bug - field "full categories" was empty for variations
  • Tested for jQuery 3.0+
2.0.1 2018-12-10
  • 2018-11-14 =
  • Fixed bug - "total weight" and "count of unique products" were empty
  • Fixed bug - message "wrong Select2 loaded"
  • Fixed bug - UI issues after switching formats (CSV-XML-CSV)
  • Shows some instructions if user gets popup with empty error message
  • Shows warning if XML can not be built (PHP extension is not installed)
2.0.0 2018-11-07
  • 2018-10-24 =
  • It's a major update. Backup settings (tab "Tools") before upgrading
  • New section "Set up fields to export" - simplify UI, format fields, allow duplicates
  • Compatible with Woocommerce 3.5
1.5.6 2018-08-30
  • 2018-08-30 =
  • Added filter by user custom fields
  • Added order fields "Count of exported items", "User Website"
  • Added product fields "Product Id", "Variation Id", "Order Line Subtotal Tax"
  • Multiple custom fields with same title are exported as list (for order)
  • Format Shipping/Billing fields as string (Excel only)
  • Fixed compatibility issue with WP Redis cache
  • Fixed bug - "Progressbar" shows error message correctly
  • Fixed bug - "Progressbar" doesn't miss orders if both "Mark exported" and "Export unmarked only" are ON
  • Reduced memory footprint (options are not autoloaded)
1.5.5 2018-06-19
  • 2018-06-08 =
  • Added filter by item name
  • Added filter by item metadata
  • Added operators <,>,>=,<
1.5.4 2018-05-01
  • 2018-04-25 =
  • Prompting to save changes if user modifies settings
  • Product fields and order item fields were separated in popup "Setup fields"
  • Allow to filter by raw shipping methods (not assigned to shipping zones)
  • Record time of last export for the order (option "mark exported orders" must be ON)
  • Added order fields "Line number", "Order Subtotal - Cart Discount"
  • Added product field "Full names for categories"
  • Added operators "Is set", "Not is set" for custom fields
  • Added option "Enable debug output" to section "Misc Settings"
  • Added option "Cleanup phone" to section "Misc Settings"
  • Tags {from_date} and {to_date} can be used in filename
  • Fixed bug in UI if order item meta has many values
1.5.3 2018-04-24
  • 2018-02-12 =
  • The plugin is compatible with WooCommerce 3.3.1
  • Supports complex structures (arrays,objects) in the fields, export it as JSON string
  • Shows "download link" for iPad/iPhone
  • Added product field "Product URL"
  • Fixed bug for Excel dates