WebToffee Logo
  • Home
  • Plugins
  • Shopify apps
  • Bundles
  • Blog
  • Documentation
  • Support
Login
cart 0

  • Getting Started
    • Plugin Setup
    • Import/Export Orders
    • Import/Export Coupons
    • Import/Export Subscription Orders
  • Import Orders
    • Import line items from product SKU
    • Import Orders from an XML file
    • Import WooCommerce Orders
    • Import all WooCommerce orders to...
    • Scheduling every 'X' hours
    • Preserving order numbers during import
  • Export Orders
    • Products-based order export in XML and XML cron
    • Export Orders to CSV/XML
  • Customized Export
    • Filter order export by coupons
    • Filter order export by ordered products
    • Export Orders with specific dates
    • Filter order export by order status
  • Meta Data
    • Export order metadata
  • Advanced Topics
    • Import/Export Orders into XML
    • Send email on order status change
    • Import Subscription Orders with parent/renewal orders
    • Modify Pre saved templates
    • Set up cron when site activity is less
    • Exclude exported orders in a new export
    • Server cron and server commands
    • Export order line items Into separate columns and rows
    • Modifying Import/Export Batch Count and Effects on Performance
    • Migrating WooCommerce orders
    • Export without user restrictions
  • Troubleshooting
    • Finding PHP Error Logs
    • Troubleshooting Guide- WooCommerce orders
    • Troubleshooting Guide-coupons
  • Code Snippet
    • Export URL Coupons Meta Data
    • Export customer role/order metadata
    • Alter UPS order XML export data
    • Import/Export Order Meta with Booking plugin
    • Export customer roles along with orders
    • Add custom metadata
    • Export UPS Tracking Code
    • Alter subscription export CSV
  • Third-Party Compatibility
    • Plugins
  • Changelog
    • Version 1.1.5

Home » Docs » Order / Coupon / Subscription Export Import Plugin for WooCommerce » How to export Orders to CSV / XML file using WooCommerce Order / Coupon / Subscription Export Import Plugin?

How to export Orders to CSV / XML file using WooCommerce Order / Coupon / Subscription Export Import Plugin?

Last updated on May 8, 2023

The WooCommerce orders can be exported in both CSV and XML file formats using the plugin, Order / Coupon / Subscription Export Import for WooCommerce . You can either download a Sample Order CSV or follow the steps mentioned below, to export the orders from your store.

  • As a first step, install and activate the plugin.
  • From the WP admin panel, navigate to the menu: WebToffee Import Export (Pro).
  • Click on Export and follow the steps in How to export orders .
  • On reaching step2, you can choose Quick export method and click on Export to download the file in CSV format.
    Quick-export-csv-file-format
    Note: Format of the file downloaded from the Pre-saved template method depends solely on the previously chosen Export file format.
  • You can also opt for the Advanced options/Batch export/Scheduling step and select the required Export File Format and export.
    export-in-csv-xml-formats

Sample of WooCommerce orders

Sample of WooCommerce orders in CSV format
CSV format
Sample of WooCommerce orders in XML format
XML format

Know more about Exporting and Importing WooCommerce orders.

  • Was this article helpful?
  • Yes, thanks!Not really

This article posted in Documentation, Export Orders, Getting Started, Order / Coupon / Subscription Export Import Plugin for WooCommerce, WooCommerce

Written by

WebToffee Team

WebToffee Team is a group of WordPress and WooCommerce enthusiasts consisting of expert developers, testing engineers, technical support engineers, and SMEs.

Comments (28)

  1. Yasen

    March 27, 2023

    Hello,

    Is it possible for this plugin to export custom XML of Woocommerce orders? Please explain how this should be done. Thanks.

    Reply
    • Vineetha

      March 29, 2023

      Hi Yasen,
      Thank for reaching out. By default, custom XMLs are not supported by the plugin. However, we can check the possibility of providing a custom code snippet for the pro version pluign to export custom XML. Please reach us via support for technical assistance.

      Reply
  2. Ab R

    April 7, 2022

    Hi,

    Is it possible for include custom fields into the export process? For example, there is a post order field that will be needed but it doesn’t look like you can include those in the export. The same needs to apply for the import when the data is being loaded back in.

    Reply
    • Alan

      April 13, 2022

      Hi,
      Yes, the pro version plugin supports exporting and importing of order custom fields. You may please export the orders with the Hidden metadata option enabled and the data will be exported to the CSV. Later on, you can use this exported CSV as a template to import data back.

      Reply
  3. Luke Morgan

    January 6, 2022

    hey,

    is it possible to run an import so that it will not change the order_number when importing the order but will allow for the order ID to be changed?

    basically we have 9150 orders and 377 subscriptions. We will have problems as there are post IDs in the migration destination that will conflict with order id’s that we are exporting.

    we need the orders to map to the correct subscription, meaning that this will break if the order numbers changed, but you can change the order id without issue for this.

    is there a way to allow for the order number to remain unchanged, so they map to the correct subscription, but for the order id ( post id of the order post type ) to be changed so it doesn’t conflict with an existing post in the new instance?

    Reply
    • Alan

      January 13, 2022

      Hi,
      The orders and subscriptions are linked using the ID and not the order number. Please enable the option Link related orders using _wt_import_key while importing subscriptions in order to link the order and subscription even if the ID changes.

      Reply
  4. michael

    December 28, 2021

    Hi,

    Is there a way of exporting only select items from the line item data. For example, in the line items I only want the SKU and not the product ID, product item total and subtotal.

    I would also like to find out if there is a way of doing this for the meta fields as well. For example, from in my meta:_wc_shipment_tracking_items column, I would like to retrieve and export only the customer_tracking_provider and the tracking_number.

    Reply
  5. David

    September 2, 2021

    Is it possible to export a list of WooCommerce Users along with the number of orders they made (not the orders themselves) over a specified date range?

    Reply
    • Mark

      September 8, 2021

      Hi,

      Sorry to say that by default there is no option to export the total number of orders that are purchased by each customer.

      Reply
  6. Anton

    May 14, 2021

    How to add “item price” to csv export
    – not “item_total”
    Thanx

    Reply
    • Alan

      May 21, 2021

      Hi,

      The price of the product will be exported to the line_item column. Can you please check the line item column where all the details of the item purchased will be exported?

      Reply
  7. Konrad Wielechowski

    May 3, 2021

    How to delete created template ?

    Reply
    • Alan

      May 8, 2021

      Hi,

      Sorry to say that currently there is no option to delete pre-saved templates. We will be including that option soon.

      Reply
  8. 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?

    Reply
    • 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.

      Reply
  9. eM

    May 25, 2020

    Is it possible to set this plugin up to export orders automatically when new order occured?

    Reply
    • 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.

      Reply
  10. 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?

    Reply
    • 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.

      Reply
  11. 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?

    Reply
    • 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.

      Reply
  12. 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!

    Reply
    • 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.

      Reply
  13. 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

    Reply
    • Alan

      September 19, 2019

      Hi,

      Could you please reach us via support. Our support team will follow you up from there.

      Reply
  14. 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!

    Reply
    • 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.

      Reply
  15. 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.

    Reply

Got any query? Please leave a comment or reach out to our support

Cancel reply

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

Webtoffee
Facebook
Twitter
Youtube
Linkein
WordPress

We develop awesome WordPress plugins & WooCommerce extensions to help build successful online businesses.

Trustpilot

© 2023 WebToffee. All rights reserved.

Our plugins

  • GDPR Cookie Consent
  • PDF Invoices & Packings Slips
  • Product Import Export Plugin
  • User & Customer Import Export
  • Import Export Suite
  • Sequential Order Numbers
  • Smart Coupons for WooCommerce
  • URL Coupons for WooCommerce
  • PayPal Express Checkout
  • Stripe Payment Gateway
  • Subscriptions for Woocommerce
  • Product Catalog Sync for Facebook
  • PrintNode for PDF Invoices
  • Order, coupon, subscriptions for WooCommerce
  • WordPress Backup and Migration
View more +

Get Started

  • Plugins
  • Testimonials
  • Affiliates
  • We're hiring

Help & Support

  • Documentation
  • Documentation (Basic)
  • FAQ
  • Support

Company

  • About Us
  • Terms & Conditions
  • Privacy Policy
  • Refund Policy
  • Support Policy
  • License Activation

© 2023 WebToffee. All rights reserved.

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies. However you may visit Cookie Settings to provide a controlled consent.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of the basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website, to store user preferences and provide you with content and advertisements that are relevant. Such cookies will be stored on your browser but only upon procuring consent.

You will also have the option to opt-out of these cookies should you want to. But opting out of some of these cookies may have an effect on your browsing experience as per the descriptions elucidated against the respective categories below.

Necessary
Always Enabled
The cookies defined under this category are absolutely essential for the website to function. Hence they are loaded by default irrespective if user consent.
CookieDescription
__cfruidCloudflare sets this cookie to identify trusted web traffic.
__stripe_midStripe sets this cookie cookie to process payments.
__stripe_sidStripe sets this cookie cookie to process payments.
cookielawinfo-checkbox-advertisementSet by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .
cookielawinfo-checkbox-analyticsSet by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Analytics" category .
cookielawinfo-checkbox-necessarySet by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Necessary" category .
cookielawinfo-checkbox-preferencesThis cookie is set by the GDPR Cookie Consent plugin to check if the user has given consent to use cookies under the "Preferences" category.
CookieLawInfoConsentRecords the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.
PHPSESSIDThis cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user sessions on the website. The cookie is a session cookie and is deleted when all the browser windows are closed.
viewed_cookie_policyThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not a user has consented to the use of cookies. It does not store any personal data.
Analytics
Analytics cookies help us understand how our visitors interact with the website. It helps us understand the number of visitors, where the visitors are coming from, and the pages they navigate. The cookies collect this data and are reported anonymously.
CookieDescription
_gaThis cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, campaign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randomly generated number to identify unique visitors.
_ga_BQH8MSKD4MThis cookie is installed by Google Analytics.
_gat_gtagIdentification code of website for tracking visits.
_gidThis cookie is installed by Google Analytics. The cookie is used to store information on how visitors use a website and helps in creating an analytics report of how the website is doing. The data collected including the number visitors, the source where they have come from, and the pages visited in an anonymous form.
_hjAbsoluteSessionInProgressHotjar sets this cookie to detect the first pageview session of a user. This is a True/False flag set by the cookie.
_hjFirstSeenHotjar sets this cookie to identify a new user’s first session. It stores a true/false value, indicating whether it was the first time Hotjar saw this user.
_hjidHotjar cookie. This cookie is set when the customer first lands on a page with the Hotjar script. It is used to persist the random user ID, unique to that site on the browser. This ensures that behavior in subsequent visits to the same site will be attributed to the same user ID.
_hjIncludedInPageviewSampleHotjar sets this cookie to know whether a user is included in the data sampling defined by the site's pageview limit.
_hjIncludedInSampleThis cookie is set to let Hotjar know whether that visitor is included in the sample which is used to generate heatmaps, funnels, recordings, etc.
_hjIncludedInSessionSampleHotjar sets this cookie to know whether a user is included in the data sampling defined by the site's daily session limit.
_hjTLDTestTo determine the most generic cookie path that has to be used instead of the page hostname, Hotjar sets the _hjTLDTest cookie to store different URL substring alternatives until it fails.
CONSENTYouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.
has_recent_activityThis cookie is used to signal to the code repository website if the user has browsed other website resources during the current session.
tk_aiGathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_lrThis cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_orThis cookie is set by the JetPack plugin on sites using WooCommerce. This is a referral cookie used for analyzing referrer behavior for Jetpack.
tk_qsGathers information for our own first-party analytics tool about how our services are used. A collection of internal metrics for user activity and is used to improve user experience.
tk_r3dThe cookie is installed by JetPack. Used for the internal metrics for user activities to improve user experience.
Advertisement
Advertisement cookies help us provide our visitors with relevant ads and marketing campaigns.
CookieDescription
_fbpThis cookie is set by Facebook to deliver advertisements when they are on Facebook or on a digital platform powered by Facebook advertising after visiting this website.
frThe cookie is set by Facebook to show relevant advertisements to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook Pixel or Facebook social plugin.
VISITOR_INFO1_LIVEA cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface.
YSCYSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages.
yt-remote-connected-devicesYouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
yt-remote-device-idYouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
Preferences
Preference cookies are used to store user preferences to provide them with content that is customized accordingly. This includes the language of the website or the location of the visitor.
CookieDescription
_gh_sessThis cookie is used to preserve users' states across page requests.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
CookieDurationDescription
_hjSession_137657130 minutesNo description
_hjSessionUser_13765711 yearNo description
_octo1 yearNo description available.
_zendesk_authenticatedpastNo description
_zendesk_sessionsessionNo description available.
_zendesk_shared_sessionsessionNo description available.
edd_wp_session12 hoursNo description available.
logged_in1 yearNo description available.
m2 yearsNo description available.
Save & Accept