WooCommerce Export Tools

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

WooCommerce Export Tools - Module Tools

General Options

WooCommerce Export Tools - General Options

CSV Separator
Separator for CSV files.
Default: ,
UTF-8 BOM
Adds UTF-8 BOM sequence.
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.
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
Default: 1
Field #X – Enabled
Default: no
Field #X – Title
Default: None
Field #X – Type
Possible values: Order Meta; Order Shortcode.
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.
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.
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
Default: 1
Field #X – Enabled
Default: no
Field #X -Title
Default: None
Field #X -Type
Possible values: Order Meta; Order Item Meta; Order Shortcode; Product Meta; Product Shortcode.
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.
Default: None

Export Products Options

Tools exports products.

WooCommerce Export Tools - Export Products Options

Export Products Fields
Hold "Control" key to select multiple fields.
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.
Default: Export variable (main) product only
Additional Export Products Fields
Default: 1
Field #X – Enabled
Default: no
Field #X -Title
Default: None
Field #X -Type
Possible values: Product Meta; Product Shortcode.
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.
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.
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.
Default:
Customer Nr.; Billing Email; Billing First Name; Billing Last Name; Last Order Date

Tips & Tricks

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.

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

Leave a Reply

Comments

15 Comments

  1. Robin July 31, 2016 at 3:02 pm #

    Hi,

    Export tools does not work.
    For example, a clic on “Download CSV” button (“Export Orders tab selected”) makes a html file without orders data.

    Reply to thread

    • Booster Support Team July 31, 2016 at 5:32 pm #

      Hi,

      Could you please try installing development version – we made some changes to the module. The development version is here – http://booster.io/dev/. You will need to uninstall the old version first (don’t worry your saved settings won’t disappear). Please let me know how it went.

      Best regards,
      Tom

      Booster Support Team
  2. Francheska August 27, 2016 at 7:43 pm #

    Is it possible to add the product input fields to the export order? I need the fields to fill the orders.

    Reply to thread

  3. kb October 31, 2016 at 3:47 pm #

    Hi

    The “Order Date” field is blank in both the Orders.csv export and also in the Export Orders Tab (before you download).

    Running version 2.5.6

    Thanks

    Reply to thread

    • Booster Support Team November 1, 2016 at 1:39 am #

      Hi,

      Yes, we know about this bug. Already fixed – please download the development version 2.5.7 here – http://booster.io/dev/. You will need to uninstall the old version first (don’t worry your saved settings won’t disappear).

      Best regards,
      Tom

      Booster Support Team
  4. Craig December 12, 2016 at 5:59 am #

    Hi

    Can you add a custom export field to the orders? It appears you can only add one to the products? https://snag.gy/4DJu6f.jpg

    Is there a way to add custom fields to the orders, too?

    Reply to thread

    • Booster Support Team December 12, 2016 at 1:24 pm #

      Hi Craig,

      Sure, no problem. Please download the development version here – http://booster.io/dev/. You will need to uninstall the old version first (don’t worry your saved settings won’t disappear). And please let me know if it works as expected.

      P.S. If you like Booster, please leave us a rating.

      Best regards,
      Tom

      Booster Support Team
    • Aaron December 16, 2016 at 9:10 pm #

      I was not able to get the custom field data to be exported nor show up on the Export Orders tab. The Column for the custom field shows up but no data is shown. I am using your Dev plugin Version 2.5.9-dev

      Field #1
      Title: How did you hear about us?
      Type: Order Meta
      Value: order_wcj_checkout_field_1

    • Booster Support Team December 16, 2016 at 9:46 pm #

      Hi, Aaron,

      If using meta, please add underscore symbol before field id, i.e. _order_wcj_checkout_field_1.

      Best regards,
      Tom

      Booster Support Team
    • Aaron December 17, 2016 at 1:31 am #

      PERFECT! Thanks.

    • Craig January 11, 2017 at 3:02 am #

      Hi Tom

      Thanks for the development version download link. (Sorry to only be following this up now, I couldn’t make any alterations until now.)

      Can you confirm that I must delete the Booster plugin or the Booster Plus plugin (or both) before installing the development version (entitled Woocommerce-Jetpack-Master ).

      Thanks again!

  5. Craig January 24, 2017 at 10:10 am #

    Hi Tom

    In the “Export Order Items Options”, the “Item Meta” option (https://snag.gy/slHauP.jpg) throws the data across several columns, which then throws out the order of the following columns.

    The solution would be to add it last in the list. I guess I could do this by unchecking it form the default options and adding it as a custom field. But what do I use for “Type” (Order Meta?) and what do I use for “Value”?

    I’ve tried everything and scoured your site, but I cannot work out what generates the Item Meta data.

    Reply to thread

  6. Richard Pugh October 15, 2017 at 5:58 pm #

    Can you document how to use the product the “items products input fields” have used _wcj_product_input_fields_local_1 but with no success.

    Reply to thread

  7. Remy.Booster007 April 12, 2018 at 6:33 am #

    Hello,

    Is there a way to export the order items (or orders or products,…) not by order date but by a date set on a custom checkout field?

    I’m building a site for a bakery that only does delivery around the area so the main element is the “Delivery Date” set by the customer on checkout (custom field added by booster plus). I would like to have the report of all product ordered at a specific “Delivery date”

    I’m using Booster plus Version 3.5.2

    Thanks

    Reply to thread

  8. Jimmy August 24, 2018 at 6:55 am #

    Hi, Is it possible to add a column for SKU ID when exporting an list of orders? I’ve tried added an extra item, short code for SKU, but it shows no value after export.

    Kind regards
    /Jimmy

    Reply to thread