fbpx

Description

With WooCommerce Export Tools module you can export WooCommerce orders, customers and products. Data can be displayed on screen and exported to CSV and/or XML. You can select predefined or custom date range and filter the fields. Currently there are 5 tools available:

  • Export Customers
  • Export Customers from Orders
  • Export Orders
  • Export Orders Items
  • Export Products

WooCommerce Export Tools - Module Tools

General Options

WooCommerce Export Tools - General Options

CSV Separator
Separator for CSV files.__ALG_REMOVE__
Default: ,
UTF-8 BOM
Adds UTF-8 BOM sequence.__ALG_REMOVE__
Default: yes

Export Orders Options

Tools exports orders - one per line.

WooCommerce Export Tools - Export Orders Options

Export Orders Fields
Hold "Control" key to select multiple fields.__ALG_REMOVE__
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 Fields
__ALG_REMOVE__
Default: 1
Field #X - Enabled
__ALG_REMOVE__
Default: no
Field #X - Title
__ALG_REMOVE__
Default: None
Field #X - Type
Possible values: Order Meta; Order Shortcode.__ALG_REMOVE__
Default: Order Meta
Field #X - Value
If field's "Type" is set to "Meta", enter order meta key to retrieve (can be custom field name). If it's set to "Shortcode", use Booster's Orders shortcodes here.__ALG_REMOVE__
Default: None

Export Orders Items Options

Tools exports orders - one item per line.

WooCommerce Export Tools - Export Orders Items Options

Export Orders Items Fields
Hold "Control" key to select multiple fields.__ALG_REMOVE__
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 Fields
__ALG_REMOVE__
Default: 1
Field #X - Enabled
__ALG_REMOVE__
Default: no
Field #X -Title
__ALG_REMOVE__
Default: None
Field #X -Type
Possible values: Order Meta; Order Item Meta; Order Shortcode; Product Meta; Product Shortcode.__ALG_REMOVE__
Default: Order Meta
Field #X -Value
If field's "Type" is set to "Meta", enter order/product meta key to retrieve (can be custom field name). If it's set to "Shortcode", use Booster's Orders/Products shortcodes here.__ALG_REMOVE__
Default: None

Export Products Options

Tools exports products.

WooCommerce Export Tools - Export Products Options

Export Products Fields
Hold "Control" key to select multiple fields.__ALG_REMOVE__
Default:
Product ID; Name; SKU; Total Stock; Regular Price; Sale Price; Price; Type; Image URL; Short Description; Status; URL
Variable Products
Possible values: Export variable (main) product only; Export variation products only; Export variable (main) and variation products.__ALG_REMOVE__
Default: Export variable (main) product only
Additional Export Products Fields
__ALG_REMOVE__
Default: 1
Field #X - Enabled
__ALG_REMOVE__
Default: no
Field #X -Title
__ALG_REMOVE__
Default: None
Field #X -Type
Possible values: Product Meta; Product Shortcode.__ALG_REMOVE__
Default: Product Meta
Field #X -Value
If field's "Type" is set to "Meta", enter product meta key to retrieve (can be custom field name). If it's set to "Shortcode", use Booster's Products shortcodes here.__ALG_REMOVE__
Default: None

Export Customers Options

Tools exports customers from WordPress users list.

WooCommerce Export Tools - Export Customers Options

Export Customers Fields
Hold "Control" key to select multiple fields.__ALG_REMOVE__
Default:
Customer ID; Email; First Name; Last Name

Export Customers from Orders Options

Tools exports customers, extracted from WooCommerce orders.

WooCommerce Export Tools - Export Customers from Orders Options

Export Customers from Orders Fields
Hold "Control" key to select multiple fields.__ALG_REMOVE__
Default:
Customer Nr.; Billing Email; Billing First Name; Billing Last Name; Last Order Date

Tips & Tricks

Exporting Order Profit and Cost

If you need to export order profit and cost (calculated with Booster’s “Cost of Goods” module), please follow these steps:

  1. Go to “WooCommerce > Settings > Booster > Emails & Misc. > Export”.
  2. In “Export Orders Options” section, set Additional Export Orders Fields to 2 and click “Save changes”.
  3. Now for “Field #1” set:
    • EnabledYes
    • TitleProfit
    • TypeOrder Shortcode
    • Value[wcj_order_profit]
  4. For “Field #2” set:
    • EnabledYes
    • TitleCost
    • TypeOrder Shortcode
    • Value[wcj_order_items_cost]

Now if you open the “Export Orders” tool (in “Booster Tools > Export Orders”), you will be able to export it to CSV and/or XML.

Exporting Link to Order PDF Invoices

If you need to export order PDF documents (e.g. PDF invoices and packing slips) (generated with Booster’s “PDF Invoicing and Packing Slips” module), please follow these steps:

  1. Go to “WooCommerce > Settings > Booster > Emails & Misc. > Export”.
  2. In “Export Orders Options” section, set Additional Export Orders Fields to 2 and click “Save changes”.
  3. Now for “Field #1” set:
    • EnabledYes
    • TitleInvoice
    • TypeOrder Shortcode
    • Value:
      http://localhost/wp-admin/edit.php?post_type=shop_order&invoice_type_id=invoice&order_id=[wcj_order_id]&get_invoice=1
      * you need to replace http://localhost/ with your server
  4. For “Field #2” set:
    • EnabledYes
    • TitlePacking slip
    • TypeOrder Shortcode
    • Value:
      http://localhost/wp-admin/edit.php?post_type=shop_order&invoice_type_id=packing_slip&order_id=[wcj_order_id]&get_invoice=1
      * you need to replace http://localhost/ with your server

Now if you open the “Export Orders” tool (in “Booster Tools > Export Orders”), you will be able to export it to CSV and/or XML. Please note that even if PDF document was not created for the order, the link will still be produced. Also please note that by default, links to PDF documents will be only accessible to users with administrator or shop manager user role. You can modify that with “Allowed User Roles” option in “WooCommerce > Settings > Booster > PDF Invoicing & Packing Slips > Display & Misc.”.

Accessible through:
  • WooCommerce > Settings > Booster > Emails & Misc. > Export
Tested on WooCommerce 4.5.2 and WordPress 5.5.1
Plugin can be downloaded here. If there are any locked fields in the module, you will need to get Booster Plus to unlock them.