How to export WooCommerce Orders to a CSV / Excel File

The Best WooCommerce Order Import Export Plugin

7,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

With WooCommerce Order / Coupon / Subscription Export Import Plugin, you can export WooCommerce orders into a CSV (Comma-Separated Values) format by using Microsoft Excel. In a spreadsheet, you can get all details about orders like shipping address, billing address, order total, information about line items, etc.

Now, let’s understand exporting of order details through example.

WooCommerce orders linting page
WooCommerce orders listing page

Suppose, orders are as shown below:

  1. Navigate to Admin settings ( Dashboard > WooCommerce > Order Im-Ex ) of Plugin. Under Order Import / Export tab, the Export window appears as shown below:Export Orders in CSV/Excel Format
  2. Order Statuses:  Select order statuses for which you want to export orders from the given list:
    Filter by order statuses
    Filter by order statuses
  3. Offset: Enter the order row number at which you wish to start the export.
  4. Limit: Enter the maximum number of orders that you wish to export.
  5. Start Date: Select the date from which you want to export the orders by clicking on the calendar icon.
  6. End Date: Select the date till which you want to export the orders by clicking on the calendar icon.
  7. Delimiter: With this field, you can change the comma separated file to ‘|’ or ‘.” separated file according to your requirement.
  8. Columns: Select the checkbox for required columns if you want to export specific columns. With the Column Name field, you can modify the column header in the CSV file. To do that, simply enter the required column name for the specific column.
  9. Save the Export Mapping: Enter the name for the export mapping file. If the field is left empty no mapping file will be saved.
  10. Exclude Already Exported: Enable this field to exclude the products that have already been exported.
  11. Click Export Orders (CSV), the CSV file gets auto-downloaded to your computer. The sample orders CSV file is as shown below:
    Exported CSV
    Exported CSV

    Note: You can download the Sample Exported CSV.

The Best WooCommerce Order Import Export Plugin

7,000+ Active Installs as per WordPress Official Plugin Repository

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

3 thoughts on “How to export WooCommerce Orders to a CSV / Excel File

  1. Dave says:

    Hi, I do have a problem with exporting Orders, the Order-Im-Ex returns me empty csv. I don’t have any other options like the screenshot posted above… I only have the “Export Orders” button, and if I click it, it downloads an empty csv… Please help. Thanks!

    • Mark
      Mark says:

      Hi,

      It seems like you are having the basic version of the plugin which doesn’t have the filters to export orders as shown in the screenshot. The premium version of the plugin supports filters to export orders as shown above.

      Could you please mention which type of orders you are trying to export using the plugin. Please reaches us via support.

  2. prathinakumar
    prathinakumar says:

    Need Clarification:
    a) If i create a new field called as “Field AAA”, after “order note” in checkout page
    b) When i go to export order or subscriptions that new field data “Field AAA” will export automatically.

Leave a Reply

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