How to Export WooCommerce Orders to a CSV / XML File
The Best WooCommerce Order Import Export Plugin
20,000+ Active Installs as per WordPress Official Plugin Repository
#1 in Customer Satisfaction
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.
Steps in Exporting WooCommerce Orders
Now, let’s understand the exporting of order details through an example. A sample order listing will be as shown below:
WooCommerce orders listing page
- Navigate to Admin settings ( Dashboard > WooCommerce > Order Im-Ex ) of Plugin. Under the Order Import / Export tab, the Export window appears as shown below:
WooCommerce Order Export
- Order Statuses: Select order statuses for which you want to export orders from the given list:
Filter by order statuses
- Product: Filter the orders by selecting products from this field. The order containing these selected products will only be exported.
- Coupon: Filter the orders by entering coupon codes separated by commas in this field. The order applied with the specified coupon code will only be exported.
- Offset: Enter the order row number at which you wish to start the export.
- Limit: Enter the maximum number of orders that you wish to export.
- Start Date: Select the date from which you want to export the orders by clicking on the calendar icon.
- End Date: Select the date till which you want to export the orders by clicking on the calendar icon.
- Delimiter: With this field, you can change the comma separated file to ‘|’ or ‘.” separated file according to your requirement.
- 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.
- Save the Export Mapping: Enter the name for the export mapping file. If the field is left empty no mapping file will be saved.
- Exclude Already Exported: Enable this field to exclude the products that have already been exported.
- Export line items into separate columns: Check this option to export line items in separate columns while exporting.
- Include hidden metadata: If you want to include custom metadata of the order in the export, especially from third-party plugins, then tick this checkbox.
- Click Export Orders (CSV) or Export Orders (XML), the CSV/XML file gets auto-downloaded to your computer . The sample orders CSV file is as shown below:
Exported CSV
Note: You can download the Sample Exported CSV.
The Best WooCommerce Order Import Export Plugin
20,000+ Active Installs as per WordPress Official Plugin Repository
#1 in Customer Satisfaction
WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product
Buy Now!
Comments (15)
kerli
December 21, 2020
In Brazil we have a document called CPF / cnpj and I need it to be exported together in the report. it’s possible?
Mark
December 22, 2020
Hi,
If the CPF data is stored with the order details as metadata in the database then it can be exported using the plugin along with the order details.
eM
May 25, 2020
Is it possible to set this plugin up to export orders automatically when new order occured?
Alan
May 26, 2020
Hi,
Currently there is no option to export the order automatically when a new order is placed. The plugin supports scheduling the export only by providing an export interval time. Eg: If the interval time is provided as 30 min then the export will occur automatically every 30 minutes.
cameron
April 1, 2020
import won’t work if you are trying to import orders on a different system where a meta->id = the order->id. is there an option to “create new order as import” or do we have to manually change the order id in the csv?
Alan
April 2, 2020
Hi,
You may please import the orders by unmapping the Order ID column during mapping or change the ID in the CSV file to a different number or delete the Order ID column from the CSV. WordPress will automatically assign the next available ID to the imported orders. Please note that unmapping/deleting/changing value in the ID column can result in importing the order with a new order number.
Mark
December 20, 2019
Can this be configured to export orders to a file on server via cron job instead of as download? So don’t have to be logged in to run it?
Alan
December 21, 2019
Hi,
Yes, using the plugin you can schedule an automatic export of orders to an FTP server so that you don’t have to log in to export them.
Ian Darby
November 25, 2019
How do I export different order line items into lines, not columns!
Sage 200 needs each line item on a different line, not a different column!
Alan
November 26, 2019
Hi,
By default, there is no option in the plugin to export the line item data into separate rows. Could you please share with us a sample CSV file format you would like to have in the CSV file so that we can check it. Please reach us via support.
Debbie
September 19, 2019
Sept 18, 2019 I get the following error when trying to export my orders:
Fatal error: Call to undefined method WC_Order_Refund::get_amount() in /home/content/41/11453441/html/wp-content/plugins/order-import-export-for-woocommerce/includes/exporter/class-wf-orderimpexpcsv-exporter.php on line 184
Alan
September 19, 2019
Hi,
Could you please reach us via support. Our support team will follow you up from there.
Dave
December 4, 2018
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
December 5, 2018
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.
prathinakumar
February 22, 2018
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.