Easily export all your orders or registered customers filtering results by price, date, customers, products, product variations, product categories, order statuses!
Note: The plugin, as WordPress, requires a minimum 5.5 PHP version.
CSV EXPORT MADE EASY
WCOE is a fast and powerful tool that lets the shop admins to export orders or registered and guest customers in one step.
Have you ever had the needing to export only some orders made by one or a set of customers? Export orders containing some particularly products?
Find and all the customers who have bought during a period or have spent at least a certain amount of money? Export complete customers list?
Now you can!
By WCOE plugin you can export all the shop orders and registered/guest customers filtering result by
- order status
- products and variations
- products categories
- total amount spent per order (range value: min/max)
- total amount spent per customer (Only if at least one customer has been selected)
SELECT WHICH ORDER INFOS TO EXPORT
Shop admin can select which orders infos to export…he can choose between more than 40!
PRODUCT CUSTOM FIELDS EXPORTATION
WCOE will optionally export product custom text fields. It has been tested with WooCommerce Product Add-ons and WC Fields Factory. Other plugins have not been tested and may not be compatible.
Item custom fields column will contain all custom fields using the following format:
Product1 field label1: custom field1 value ***** Product1 field label2: custom field value2 | Product2 field label1: custom field1 value ***** Product2 field label2: custom field value2
See the above example file link for detailed info.
ORDER AND CHECKOUT CUSTOM FIELDS EXPORTATION
WCOE will optionally export order and checkout custom fields added using the WooCommerce Custom Fields, Product Add-ons, Order Delivery Date for WooCommerce and User Extra Fields (User Extra Fields: will be only exported the fields marked to saved as order extra fields).
Checkout custom fields column will contain all custom fields using the following format:
Custom field label1: custom field1 value | Custom field label2: custom field2 value
EXPORTED FILE EXAMPLE
Example of generated Orders CSV
Example of generated Customers CSV
CUSTOMERS EXPORTED .CSV IS “WOOCOMMERCE CUSTOMER MANAGER” COMPATIBLE
Exported customers .csv file is 100% compatible with WooCommerce Customer Manager plugin. You can import the entire customers list without any problem!
HOW TO IMPORT INTO EXCEL
Generated file can be easily imported to excel by following these steps:
- Run Excel
- Import the data using Data -> Import External Data (or Import from Text) -> Import Data
- Select the csv file type and browse the directory where the .csv file is
- In the import wizard, choose Delimited file type and change the File Origin to 65001 Unicode (UTF-8) (quite at the bottom of the list)
- Click Next button and change the delimiter to comma (or semicolon, depens on which delimiter character you have selected)
- Click on Finish button
WCOE is WPML COMPATIBLE
WooCommerce Pre-sale, Time offer & Expiring System
Would like to export customer or orders that have at least on item that was in presale (presale managed wih WooCommerce Pre-sale, Time offer & Expiring System) ?
Just check the special option during the export configuration and a the plugin will generate a csv containing only orders (or customer) that has at least an item that was in presale!
export orders including olny some products. Search for the using product name, sku or id!
COLUMN/INFO TO EXPORT
= 4.5 - 10.12.20 = * Fixed an issue due to order and customers were not properly exported = 4.4 - 05.09.20 = * CSV now reported country and state names instead of codes = 4.3 - 16.05.19 = * The plugin now exports order vat number (created using the WooCommerce Eu Vat & B2B plugin) = 4.2 - 17.07.17 = * Fixed an issue that may prevent order to be exported = 4.1 - 15.06.17 = * Added option to export orders that have at leat one item that was in pre-sale: https://codecanyon.net/item/woocommerce-presale-time-offer-expiring-system/13335433 = 4.0 - 07.05.17 = * Added support to WPUEF order fields = 3.9 - 07.04.17 = * Improved compatibility with WooCommerce 3.0.4 = 3.8 - 15.12.16 = * Minor bugfix = 3.7 - 29.11.16 = * Fixed an issue due to Shipping country and state were swapped = 3.6 - 27.06.16 = * Fixed an issue with WooCommerce 2.6 = 3.5 - 01.06.16 = * Added support to "Order Delivery Date for WooCommerce" plugin = 3.4 - 31.05.16 = * Fixed a bug due to the order date and user roles column were inverted = 3.3 - 21.01.16 = * Feature added: is now possible exporting filtering by product variations = 3.2 - 23.01.16 = * Support for WooCommerce Custom Fields & Product Add-ons = 3.1 - 23.01.16 = * Role reporting on csv = 3.0 - 20.01.16 = * Support for guest customers = 2.9 - 18.01.16 = * Bug fix on customer search field = 2.8 - 10.12.15 = * Added 2 new columns: order private notes and order notes to customer = 2.7 - 10.12.15 = * Css bugfix = 2.6 - 07.12.15 = * Bugfix = 2.5 - 26.11.15 = * Fixed a bug that could prevend the correct "order note" field exportation = 2.4 - 23.11.15 = * Bugfix = 2.3 - 18.11.15 = * Added "Orders note" column = 2.2 - 17.11.15 = * Bugfix on "Shipping method" column = 2.1 - 12.11.15 = * httpss Bugfix = 2.0 - 09.11.15 = * Bugfix = 1.9 - 26.10.15 = * Bugfix = 1.8 - 20.10.15 = * Bugfix = 1.7 - 20.10.15 = * Bugfix = 1.6 - 19.10.15 = * Added custom field exportation = 1.5 - 01.10.15 = * Added logic operators = 1.4 - 23.09.15 = * Added new column for products SKUs = 1.3 = * Is now possible select which columns to export = 1.2 = * bugfix with unicode to utf8 encoding * added order date column to csv = 1.1 = * New filter: by customer total amount spent (used only if at least one customer has been selected) = 1.0 = * ReleaseSource