WooCommerce Export Tools

Export WooCommerce orders, customers and products

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

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.

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.

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.

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.

xport 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.

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
  4. For “Field #2” set:
    • EnabledYes
    • TitleCost
    • TypeOrder Shortcode
    • Value

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=&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=&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
0
    0
    Your Cart
    Your cart is emptyReturn to Shop