Documentation for the Products, Order & Customers Export for WooCommerce plugin.

Documentation for Products, Order & Customers Export for WooCommerce Plugin

Author: WPFactory PluginsVersion: 2.0.11Updated: 2 months ago
Requires WordPress version: 4.4Tested up to WordPress version: 6.4

Settings

 

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
  • Nickname
  • 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