Sale! Tested Perfect rating

Export WooCommerce

(2 customer reviews)

From: $14.99 / year

Export orders, products and customers from WooCommerce.

Clear

Description

Export WooCommerce plugin lets you export orders, products and customers from WooCommerce.

Orders can be exported as orders or as orders items.

Customers can be exported from WordPress users table or extracted from WooCommerce orders.

You can add unlimited number of additional meta fields to export.

Plugin settings are accessible via “Dashboard > WooCommerce > Settings > Export”. Export tools themselves are accessible via “Dashboard > WooCommerce > Export”.

General Options

Export WooCommerce - General Options

CSV Separator
Set separator used in exported CSV files.
Default: ,
CSV Wrap
CSV field wrapper. E.g.: "
Default: None
UTF-8 BOM
Adds UTF-8 BOM sequence to exported CSV files.
Default: yes
Content Length Header
Disable this if you are experiencing “endless” file download when using “Download CSV” or “Download XML” buttons.
Default: yes
User Capability
Set required user capability for CSV and XML export. For example try manage_woocommerce (for administrators & shop managers). Leave blank if you want all users (including not logged) to be able to export the data (not recommended).
Default: manage_options
Timepicker
Adds timepicker to all export tools (to “Custom” range).
Default: no

Secondary Separators Options

Export WooCommerce - Secondary Separators Options

Orders: Secondary Separator
Used in: “Order Product Input Fields”, “Backend Order Notes”, “Order Items” columns.
Default:  / 
Orders: Third Separator
Used in: “Item Product Input Fields”, “Order Product Input Fields”, “Item Meta”, “Item Variation Meta”, “Order Items” columns.
Default:
Customers: Secondary Separator
Used in: “User Roles” column.
Default:  / 
Products: Secondary Separator
Used in: “Stock Quantity”, “Total Stock”, “Regular Price”, “Sale Price”, “Price”, “Variation Attributes” columns.
Default: /

Advanced Options

Export WooCommerce - Advanced Options

Block Size
Number of items to process in one iteration.
Default: 1024
Time Limit
Export tools maximum time limit in seconds. If set to minus one, option is ignored and default time limit is used. If set to zero, no time limit is imposed.
Default: -1

Export Products Options

Export products tool.

Export WooCommerce - Admin Settings - Export Products Options

Possible product export fields are:

  • Product ID
  • Name
  • SKU
  • Total Stock
  • Stock Quantity
  • Regular Price
  • Sale Price
  • Price
  • Type
  • Variation Attributes
  • Image URL
  • Short Description
  • Description
  • Status
  • URL
  • Shipping Class
  • Shipping Class ID
  • Width
  • Length
  • Height
  • Weight
  • Downloadable
  • Virtual
  • Sold Individually
  • Tax Status
  • Tax Class
  • Manage Stock
  • Stock Status
  • Backorders
  • Featured
  • Visibility
  • Price Including Tax
  • Price Excluding Tax
  • Display Price
  • Average Rating
  • Rating Count
  • Review Count
  • Categories
  • Tags
  • Dimensions
  • Formatted Name
  • Availability
  • Availability Class
Export Products Fields
Hold “Control” key to select multiple fields. Hold “Control + A” to select all fields.
Default:
Product ID; Name; SKU; Total Stock; Regular Price; Sale Price; Price; Type; Image URL; Short Description; Status; URL
Additional Export Products Meta Fields
Sets the total number of additional export product meta fields to add. Save changes after you change this number.
Default: 1
Meta Field #X - Enabled
Enables/disables additional export product meta field.
Default: no
Meta Field #X - Title
Additional export product meta field title.
Default: None
Meta Field #X - Value
Additional export product meta field key to retrieve (can be custom field name). E.g.: _alg_msrp.
Default: None

Export Orders Options

Export orders tool.

Export WooCommerce - Admin Settings - Export Orders Options

Possible orders export fields are:

  • Order ID
  • Order Number
  • Order Status
  • Order Date
  • Order Time
  • Order Item Count
  • Order Items
  • Order Product Input Fields
  • Order Currency
  • Order Total
  • Order Total Tax
  • Order Payment Method
  • Order Notes
  • Billing First Name
  • Billing Last Name
  • Billing Company
  • Billing Address 1
  • Billing Address 2
  • Billing City
  • Billing State
  • Billing Postcode
  • Billing Country
  • Billing Phone
  • Billing Email
  • Shipping First Name
  • Shipping Last Name
  • Shipping Company
  • Shipping Address 1
  • Shipping Address 2
  • Shipping City
  • Shipping State
  • Shipping Postcode
  • Shipping Country
  • Backend Order Notes
Export Orders Fields
Hold “Control” key to select multiple fields. Hold “Control + A” to select all fields.
Default:
Order ID; Order Number; Order Status; Order Date; Order Time; Order Item Count; Order Items; Order Currency; Order Total; Order Total Tax; Order Payment Method; Order Notes; Billing First Name; Billing Last Name; Billing Company; Billing Address 1; Billing Address 2; Billing City; Billing State; Billing Postcode; Billing Country; Billing Phone; Billing Email; Shipping First Name; Shipping Last Name; Shipping Company; Shipping Address 1; Shipping Address 2; Shipping City; Shipping State; Shipping Postcode; Shipping Country
Additional Export Orders Meta Fields
Sets the total number of additional export orders meta fields to add. Save changes after you change this number.
Default: 1
Meta Field #X - Enabled
Enables/disables additional export order meta field.
Default: no
Meta Field #X - Title
Additional export order meta field title.
Default: None
Meta Field #X - Value
Additional export order meta field key to retrieve (can be custom field name).
Default: None

Export Orders Items Options

Export orders items tool.

Export WooCommerce - Admin Settings - Export Orders Items Options

Possible orders items export fields are:

  • Order ID
  • Order Number
  • Order Status
  • Order Date
  • Order Time
  • Order Item Count
  • Order Currency
  • Order Total
  • Order Total Tax
  • Order Payment Method
  • Order Notes
  • Billing First Name
  • Billing Last Name
  • Billing Company
  • Billing Address 1
  • Billing Address 2
  • Billing City
  • Billing State
  • Billing Postcode
  • Billing Country
  • Billing Phone
  • Billing Email
  • Shipping First Name
  • Shipping Last Name
  • Shipping Company
  • Shipping Address 1
  • Shipping Address 2
  • Shipping City
  • Shipping State
  • Shipping Postcode
  • Shipping Country
  • Item Name
  • Item Product Input Fields
  • Item Meta
  • Item Variation Meta
  • Item Quantity
  • Item Tax Class
  • Item Product ID
  • Item Variation ID
  • Item Line Subtotal
  • Item Line Total
  • Item Line Subtotal Tax
  • Item Line Tax
  • Item Line Subtotal Plus Tax
  • Item Line Total Plus Tax
  • Backend Order Notes
Export Orders Items Fields
Hold “Control” key to select multiple fields. Hold “Control + A” to select all fields.
Default:
Order Number; Order Status; Order Date; Order Currency; Order Payment Method; Item Name; Item Variation Meta; Item Quantity; Item Tax Class; Item Product ID; Item Variation ID; Item Line Total; Item Line Tax; Item Line Total Plus Tax
Additional Export Orders Items Meta Fields
Sets the total number of additional export orders items meta fields to add. Save changes after you change this number.
Default: 1
Meta Field #X - Enabled
Enables/disables additional export order item meta field.
Default: no
Meta Field #X - Title
Additional export order item meta field title.
Default: None
Meta Field #X - Type
Additional export order item meta field type. Possible values: Order Meta; Product Meta.
Default: Order Meta
Meta Field #X - Value
Additional export order item meta field key to retrieve (can be custom field name).
Default: None

Export Customers Options

Export customers tool. Customers are exported from WordPress users table, filtering users with WooCommerce customer role (by default).

Export WooCommerce - Admin Settings - Export Customers Options

Possible customers export fields are:

  • Customer Nr.
  • Customer ID
  • Email
  • First Name
  • Last Name
  • Login
  • Nicename
  • URL
  • Registered
  • Display Name
  • User Roles
  • Nickname
  • First Name
  • Last Name
  • Description
  • Billing First Name
  • Billing Last Name
  • Billing Company
  • Billing Address 1
  • Billing Address 2
  • Billing City
  • Billing Postcode
  • Billing Country
  • Billing State
  • Billing Phone
  • Billing Email
  • Shipping First Name
  • Shipping Last Name
  • Shipping Company
  • Shipping Address 1
  • Shipping Address 2
  • Shipping City
  • Shipping Postcode
  • Shipping Country
  • Shipping State
  • Last Update
  • Total Spent (Lifetime)
  • Order Count (Lifetime)
  • Last Order Date
Export Customers Fields
Hold “Control” key to select multiple fields. Hold “Control + A” to select all fields.
Default:
Customer ID; Email; First Name; Last Name
User Roles
Here you can select multiple user roles to export. If empty – all user roles will be exported.
Default: Customer

Export Customers from Orders Options

Export customers from orders tool. Customers are extracted from orders. Customers are identified by billing email.

Export WooCommerce - Admin Settings - Export Customers from Orders Options

Possible customers export fields are:

  • Customer Nr.
  • Customer ID
  • Customer First Name
  • Customer Last Name
  • Billing Email
  • Billing First Name
  • Billing Last Name
  • Billing Company
  • Billing Address 1
  • Billing Address 2
  • Billing City
  • Billing State
  • Billing Postcode
  • Billing Country
  • Billing Phone
  • Shipping First Name
  • Shipping Last Name
  • Shipping Company
  • Shipping Address 1
  • Shipping Address 2
  • Shipping City
  • Shipping State
  • Shipping Postcode
  • User Roles
  • Shipping Country
  • Last Order Date
  • First Order Date
  • Total Spent (Lifetime)
  • Order Count (Lifetime)
  • Total Spent (Period)
  • Order Count (Period)
  • Item Count (Period)
Export Customers from Orders Fields
Hold “Control” key to select multiple fields. Hold “Control + A” to select all fields.
Default:
Customer Nr.; Billing Email; Billing First Name; Billing Last Name; Last Order Date

2 reviews for Export WooCommerce

  1. pasmira (verified owner)

    simple but powerful.. Great Plugin!

  2. Seth

    Great plugin!

Add a review

Your email address will not be published. Required fields are marked *

24 thoughts on "Export WooCommerce"

  1. Hello,
    I want to export the total discount of the order, and since it is not within its configuration, I have tried with a meta field discount_total, however, it does not export anything. What am i missing?

  2. How i Import these customers & Orders CSV files

    1. Hi,

      Unfortunately, currently, the plugin is not designed for that – you can only export data.

      P.S. You can import the CSV with standard WordPress import tools though. For example, products with “WooCommerce products (CSV)” tool. However, I don’t think you can import customers or orders there.

  3. Hi, just bought pro version. I cannot download csv file. It appear “This page isn’t working heeladina.com is currently unable to handle this request.
    HTTP ERROR 500”

    Please help

    1. Hi,

      Could I log in to your site to check what’s going on? If that’s possible – my email is [email protected]

  4. Hello..
    i found some error, after downloading csv. there is error while converted text to column. previously i don’t have any problem. for your information i have the latest update wordpress and woocommerce..
    can you solved this

    1. If anyone else has a similar question – the problem was in another plugin which was outputting three empty lines on every page of the site (including back-end and front-end), so those three empty lines were also present in exported CSV files. After disabling the plugin, the problem seems to be gone – export is working normally now.

  5. Hello,
    I would like to buy the pro version, but while evaluating the plugin I created a CSV file.
    This file has a huge content displayed properly in the description field, but when I export the CSV it split content and start a new line.

    Before buying the plugin I want to be sure so solve this issue.

    Thank you

    Marco

    1. Hello,

      I found that the problem is related qith starting a new paragraph and the problem is also on xml file.

    2. Hi Marco,

      If I understood the issue correctly – could you please try setting the “CSV Wrap” option in “WooCommerce > Settings > Export > General” to "

    3. Hello,

      It doesn’t work with CSV as it add the tag to all fields.

      Basically the problem is that the content of a field is split on generating CSV file, every time there is a comma or a enter to start a new line or paragraph. I think there should be an instruction for not separate content of a field.

  6. Hi, can you make export download as. Xlsx?

    1. Hi,

      Unfortunately Excel’s XLSX format is not supported in plugin. Not sure if this is good enough, but I would suggest exporting it in CSV, then opening it with Excel and saving as XLSX.

  7. Hi thanks for the big support.. I have request again ☺️ can you make the export in range time not Just the Date..

    1. Hi,

      Sure, no problem. We’ve just released new plugin version 1.5.2, where I’ve added new “Timepicker” option to plugin’s “General” settings (in “WooCommerce > Settings > Export”). After enabling the checkbox, you will be able to pick a time in all tools’ “Custom” date range. Please check it out and let me know if something is not working as expected.

      P.S. If you like the plugin, please consider leaving us a rating.

  8. Hi, i just bought your plugin.
    I set in order items a order notes, but the result is blank in column order notes.
    why?

    1. any update on this?

    2. Hi,

      Sorry for a late reply. I’ve just checked and “Order Notes” column seems to be working fine here. Just to be sure – “Order Notes” column exports “Order notes” field that customer fills in on the checkout page. Is that what you need, or do you need “Order notes” that are set by admin on order edit page?

    3. yes, i mean order notes in admin pages/ dashboard order pages.. it will be great if we can export order notes in admin pages, its use to track history order in inventory

    4. Hi,

      Sure, no problem. We’ve just released new plugin version 1.5.1. After the update you will find new “Backend Order Notes” column in “Orders” and “Orders Items” settings (it’s at the end of the fields list). Please take a look and let me know if something is not working as expected or if you have any questions. And if you like the plugin, please consider leaving us a rating.

      P.S. “Backend Order Notes” field was added to Pro version only.

  9. I just installed the Export WooCommerce plugin but, I do not see where/how to access the export plugin.

    1. Hi,

      Plugin settings are accessible via “Dashboard > WooCommerce > Settings > Export”. Tools themselves are accessible via “Dashboard > WooCommerce > Export”.

      Hope that helps. Please let me know if you have any more questions.

  10. Hi – I have added the Product Input Fields for WooCommerce Pro plugin as well as the Export WooCommerce to our site, but I have no idea how to actually export the data being collected by the Input Fields. I need to export all of this data, along with the order details, to an excel sheet. Please help.
    Thanks!

    1. Hi,

      In case if anyone else has the same question – as discussed in private conversation – exporting data collected with Product Input Fields for WooCommerce plugin was added in version 1.2.1:

      Export Orders – “Order Product Input Fields” field.
      Export Orders Items – “Item Product Input Fields” field.

      Best regards,
      Tom

Leave a Reply

Your email address will not be published. Required fields are marked *

Changelog

1.5.3 - 05/08/2019

  • Fix - Export Customers from Orders - "Total Spent (Period)", "Order Count (Period)" and "Item Count (Period)" columns fixed (do_calculate_tmp_data).
  • Dev - Advanced Options - "Block Size" option added.
  • Dev - Advanced Options - "Time Limit" option added.
  • Dev - HTTP headers updated for both CSV and XML file exports.

1.5.2 - 10/05/2019

  • Dev - General - Datepicker - "Timepicker" option added.
  • Dev - General - Datepicker - Loading jquery-ui.css from code.jquery.com now.
  • Tested up to: 5.2.

1.5.1 - 04/05/2019

  • Dev - Export Orders / Orders Items - "Backend Order Notes" field added.
  • Dev - General - "Secondary Separators" options added.
  • Dev - General - "Raw" input is now allowed in "CSV Separator" and "CSV Wrap" options.
  • Dev - General - Settings descriptions updated.
  • Dev - "WC tested up to" updated.

1.5.0 - 12/03/2019

  • Fix - Datepicker fixed to include change month and year options. Date format forced to yy-mm-dd.
  • Dev - Export Customers from Orders - "Total Spent (Period)" field added.
  • Dev - Export Customers from Orders - "Order Count (Period)" field added.
  • Dev - Export Customers from Orders - "Item Count (Period)" field added.
  • Dev - Export Customers from Orders - "Total Spent (Lifetime)" field added.
  • Dev - Export Customers from Orders - "Order Count (Lifetime)" field added.
  • Dev - Export Customers from Orders - "First Order Date" field added.
  • Dev - Export Customers from Orders - "Customer First Name" field added.
  • Dev - Export Customers from Orders - "Customer Last Name" field added.
  • Dev - Export Customers - "Total Spent (Lifetime)" field added.
  • Dev - Export Customers - "Order Count (Lifetime)" field added.
  • Dev - Export Customers - "Last Order Date" field added.
  • Dev - General - "Content Length Header" option added.

1.4.0 - 16/02/2019

  • Dev - Export Customers - "Customer Nr." field added.
  • Dev - Export Customers - "User Roles" field added.
  • Dev - Export Customers - "Last Update" field added.
  • Dev - Export Customers from Orders - "Customer ID" field added.
  • Dev - Export Customers from Orders - "User Roles" field added.
  • Dev - Export Customers - "User Roles" option added.
  • Dev - Code refactoring.
  • Dev - Admin settings restyled.
  • Dev - readme.txt description expanded.

1.3.0 - 29/10/2018

  • Fix - "Download CSV" and "Download XML" buttons links fixed to include full home url.
  • Dev - "Reset Settings" option added.
  • Dev - Date range menu - Active link styling added.
  • Dev - Code refactoring.
  • Dev - Admin settings restyled.
  • Dev - Plugin URI updated.

1.2.1 - 13/06/2018

  • Dev - Export Orders - "Order Product Input Fields" field added.
  • Dev - Export Orders Items - "Item Product Input Fields" field added.
  • Dev - "WC tested up to" added to plugin header.

1.2.0 - 10/12/2017

  • Fix - Export restricted to users with manage_options capability only (and "General > User Capability" option added).
  • Fix - "Filter by All Fields" fixed.
  • Dev - WooCommerce 3.2.0 compatibility - Admin Settings - select option type display fixed.
  • Dev - General - "CSV Wrap" option added.
  • Dev - Code refactoring.
  • Dev - Settings array stored as main class property.
  • Dev - Admin Settings - Option descriptions minor update.

1.1.0 - 28/07/2017

  • Dev - WooCommerce 3.x.x compatibility - Orders - Using methods instead of accessing order properties directly.
  • Dev - WooCommerce 3.x.x compatibility - Orders - get_order_currency() replaced with get_currency().
  • Dev - WooCommerce 3.x.x compatibility - Orders - alg_get_order_item_meta_info() - has_meta() replaced with get_meta_data().
  • Dev - WooCommerce 3.x.x compatibility - Export Customers from Orders - Using methods instead of accessing order properties directly (fixes "Order properties should not be accessed directly" notice).
  • Dev - WooCommerce 3.x.x compatibility - Products - get_categories() and get_tags() replaced with wc_get_product_category_list() and wc_get_product_tag_list().
  • Dev - WooCommerce 3.x.x compatibility - Products - get_dimensions() replaced with wc_format_dimensions( get_dimensions( false ) ).
  • Dev - WooCommerce 3.x.x compatibility - Products - get_price_including_tax(), get_price_excluding_tax() and get_display_price() replaced with wc_get_price_including_tax(), wc_get_price_excluding_tax() and wc_get_price_to_display().
  • Dev - WooCommerce 3.x.x compatibility - Products - post->post_excerpt, post->post_content and post->post_status replaced with get_short_description(), get_description() and get_status().
  • Dev - WooCommerce 3.x.x compatibility - Products - get_formatted_variation_attributes() replaced with wc_get_formatted_variation().
  • Dev - WooCommerce 3.x.x compatibility - Products - get_total_stock() replaced with get_stock_quantity().
  • Dev - WooCommerce 3.x.x compatibility - Products - Using wc_get_product() instead of get_child().
  • Dev - WooCommerce 3.x.x compatibility - Products - Using methods instead of accessing product properties directly (fixes "Product properties should not be accessed directly" notice).
  • Dev - Filter export by date options added.
  • Dev - Export Customers from Orders - Code refactoring.
  • Dev - Export Customers from Orders - Shipping info fields added (9 new fields).
  • Dev - Export Customers - 24 new fields added.
  • Dev - Plugin link updated from http://coder.fm to https://wpcodefactory.com.
  • Dev - Plugin header ("Text Domain" etc.) updated.
  • Dev - POT file added.

1.0.0 - 22/12/2016

  • Initial Release.

Frequently Asked Questions

Q. When I'm exporting data to CSV, columns that include prices are split into several columns. How do I fix that?

A. The problem is that dot or comma in your price is treated as CSV separator. To fix that you can either change CSV Separator option in "WooCommerce > Settings > Export > General" and set it to e.g.: ;, or set CSV Wrap option in "WooCommerce > Settings > Export > General" to " – this way prices will be wrapped in quotes, which should keep them in single column, however, prices will be treated as a text (i.e. not as numbers) then.


Q. I want to add SKU to each item when exporting order items. How would I do that?

A. To add SKU to each item when exporting order items, you need to set:

  • Additional Export Orders Items Meta Fields in "WooCommerce > Settings > Export > Orders Items" to 1, then
  • Meta Field #1: Title to SKU,
  • Meta Field #1: Type to Product Meta and
  • Meta Field #1: Value to _sku.

Free version

This plugin is a premium version of free "Export WooCommerce" plugin.

Prices & Licenses

Single siteUnlimited sites
1 year[buy] $19.99 $14.99 / year[buy] $29.99 $24.99 / year
Lifetime[buy] $39.99 $29.99[buy] $59.99 $39.99

Installation and Updates

  • Buy the plugin 🙂
  • Download plugin's zip to your computer (you will receive an email with download link, or you can always download the plugin from your account).
  • Go to "Admin Dashboard > Plugins > Add New > Upload Plugin" and browse for downloaded zip file.
  • If plugin is successfully installed - you should see it added to the Plugins list.
  • To keep WPFactory items up to date, please install WPFactory Helper plugin and enter your site key.

Refunds

We want to ensure that you are 100% happy with your purchase, so if you feel the product(s) you purchased are not the best fit for your requirements and you attempted to resolve issues with product's author, we are offering 30 day money back guarantee refund policy.