WebToffee Logo
  • Home
  • Plugins
  • Bundles
  • Blog
  • Documentation
  • Support
Login
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
    • Scheduling every 'X' hours
  • 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
    • 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.4

Documentation/Order / Coupon / Subscription Export Import Plugin for WooCommerce/Setting Up Order / Coupon / Subscription Export Import Plugin for WooCommerce

Setting Up Order / Coupon / Subscription Export Import Plugin for WooCommerce

Last updated on October 13, 2021

Overview

Order / Coupon / Subscription Export Import Plugin for WooCommerce is an ideal plugin for exporting and importing data either from the WooCommerce store or e-commerce platforms. With this plugin, you can easily import/export :

  • Orders
  • Coupons
  • Subscriptions

What do we provide?

  1. Migrate orders, coupons  and subscriptions using the same plugin.
  2. The main migration methods are:
    • Quick import/export
    • Based on a Pre-saved template
    • Advanced import/export
  3. Import/export data processing in batches, ensures successful import/export irrespective of its size/count. 
  4. One can automate migration via FTP profiles and schedules. 
  5. Detailed history, debug logs and cron schedules are other main peculiarities.

Pre-requisites

  • Make sure mbstring is enabled on the server.
  • Supports both CSV and XML file formats.
  •  Download a CSV with: 
    • Order Sample CSV
    • Coupon Sample CSV
    • Subscription Sample CSV
  • CSVs should be in UTF-8 format.

To begin with the plugin, download, install and activate.

Getting Started

Hooray!!.. You have successfully activated the plugin. From your WordPress dashboard, navigate through the WebToffee Import/Export(Pro) menu.

WebToffee Import Export(Pro) menu

The plugin consists of six different sub-menus :

  •  Export
  •  Import
  •  History
  •  Logs
  •  Scheduled actions
  • General settings

Let us have a look at each of these sub-menus in detail.

Export

Orders, coupons and subscriptions can be exported in just 5 steps:

  1. Select a post type: The available post types are Order, Coupon and Subscription.
  2.  Select an export method: Quick export, Pre-saved template and Advanced export are the provided export methods.
  3. Filter data: One can filter data with respect to the chosen post type.
  4. Map and reorder export columns: To map, edit and reorder export columns.
  5. Advanced Options/Batch Export: Provides advanced options for export and scheduling export.

Import

Orders, coupons and subscriptions can be imported in just 4 steps:

  1. Select a post type: The available post types are Order, Coupon and Subscription..
  2. Select an import method: Quick import, Pre-saved template and Advanced import are the provided import methods.
  3.  Map import columns: To map and edit import columns.
  4. Advanced Options/Batch Import: Provides advanced options for import and scheduling import.

For a detailed step-wise import export process, refer:

  • How to Import and Export WooCommerce Orders
  • How to Import and Export WooCommerce Coupons
  • How to Import and Export WooCommerce Subscriptions Orders

History

The History tab lists the runs and the status corresponding to every import/export with options to :

• Re-run: to re-run the action will take the user to the respective screen .

• Details: view a detailed history

• Delete: delete the entry

History section of the Import Export plugin for WooCommerce

To look into the History section:

  1. Click on WebToffee Import/Export(Pro) >  History
  2. One can sort the list with these available Filter options:
    • Post type: Order
    • Action type: All, Export, Import
    • Status: All, Finished
    • Sort by: Date descending, Date ascending
    • Max record/page: The maximum records to be included in a page

The actions will be listed in following statuses:

  • Success : Process completed successfully.
  • Failed :  Failed process triggered due to connection/permission or similar issues(unable to establish FTP/DB connection, write permission issues etc.).
  • Running/Incomplete : Processes that are running currently or that may have been terminated unknowingly(e.g, closing a browser tab while in progress etc).

Logs

The Logs tab lists developer logs mostly required for debugging purposes with options to perform the following actions:

  • View: to view detailed logs 
  • Delete: to remove the log
  • Download: to share the log report with the support team in case of issues

To look into the Logs section:Click on WebToffee Import/Export(Pro) > Logs

Logs section of the Import Export plugin for WooCommerce

To save the import Logs:

  1. Click on WebToffee Import/Export(Pro) > General Settings
  2. Click on General and choose “Yes” for the Save Import log to save the import log as a text file and make it available in the log section for debugging purposes.
  3. Click on Update Settings to finish.
Saving import logs in the Import Export plugin for WooCommerce

Scheduled Actions

The Scheduled Actions tab lists all the scheduled processes for import and export. One can disable or delete unwanted scheduled actions to:

  1. Reduce server load 
  2. Reduce the chances for failure of actively scheduled actions.
List of scheduled actions in the Import Export plugin for WooCommerce

General Settings

The General Settings helps to configure all the basic settings of the plugin.

Let us navigate through this section:

  • Click on  WebToffee Import/Export(Pro) > General Settings. 

This tab consists of four different sections: 

  1. General
  2. FTP settings
  3. Help Guide
  4. Licence

General

Here, you can configure the basic settings.

  • Enable history auto delete : You can enable auto-delete of import/export history by choosing ‘Yes’.
  • Maximum entries : Specify the maximum records to retain in history. It will limit the number of records with the status ‘Finished’ to the number you have specified. E.g: if you input a count of 50 the system will retain only the most recent 50 number of records with the status ‘Finished’. All other records of any other status e.g In Progress (that may be active as a part of the cron operation) will not be impacted by this count.
  • Default Export method : Choose a default export method from the three options: Quick export, Pre-saved template and Advanced export.
General tab in the Import Export plugin for WooCommerce
  • Default Export batch count : Specify the default number of records to be exported in a batch.
  • Save Import log : Choose ‘Yes’ to save the import log as a text file. This action will make the file available in the logs section. 
  • Default Import method : Choose an import method from three options: Quick import, Pre-saved template and Advanced import.
  • Default import batch count : Provide the default number of records to be imported in a batch. 100 is given by default.

Once you are done with configurations click Update Settings.

FTP Settings

The plugin is equipped to handle multiple FTP profiles. These dedicated FTP profile settings can be used to manage and manipulate easy scheduled import/export.

Adding new FTP profile in the Import Export plugin for WooCommerce

Help Guide

Provides direct links to resources like documentation and support.

Help Guide tab in the Import Export plugin for WooCommerce

Licence

After you have installed and activated the Order / Coupon / Subscription Export Import Plugin for WooCommerce on your website, you need to activate the plugin license to get notified about the plugin updates.

To do so, from the WordPress admin dashboard:

  1. Click WebToffee Import Export(Pro)> General>  License.

Know more about : Orders, Coupons, Subscriptions.

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

On this page

  • Overview
  • What do we provide?
  • Pre-requisites
  • Getting Started
  • Export
  • Import
  • History
  • Logs
  • Scheduled Actions
  • General Settings
  • General
  • FTP Settings
  • Help Guide
  • Licence

This article posted in Documentation, Getting Started, Getting Started, Order / Coupon / Subscription Export Import Plugin for WooCommerce, WooCommerce and tagged Order/Coupons/Subscriptions import export for WooCommerce, Set up guide

Written by

Vineetha

Vineetha is a technical content writer with a knack of simplifying complex information into readable content. She focuses on writing content in a conveyable and clear format.

Comments (36)

  1. Pieter Lamiroy

    Pieter Lamiroy

    November 16, 2020

    Hello,

    I have bought the PRO version but am facing a problem, i can schedule exports to FTP as a XML file, that works! But i when i try CSV files, nothing arrives in my folder.

    What can i do?

    Reply
    • Mark

      Mark

      November 17, 2020

      Hi,

      Please reach us via support.

      Reply
  2. Heiko Heiden

    Heiko Heiden

    September 4, 2020

    Hi, how can i import order and change the status to “shipped”? Also i need to insert the tracking number for my shipping method.

    Thanks!

    Reply
    • Alan

      Alan

      September 5, 2020

      Hi,

      In order to update the status of the order to “shipped” you may please provide the updated status and ID of the order in the CSV file and then update the order with the Update order if exists option enabled.
      Regarding “tracking number”, if you are using any third-party plugin to add a tracking number field to the orders then you may please export the order with the include hidden metadata option enabled and this custom field will be exported to the CSV file. Later on you may please use this CSV as a template to import data back.

      Reply
  3. Varsha Gupta

    July 29, 2020

    I am using this plugin for exporting woocommerce orders automatically to via FTP. But after the schedule i am getting error in exported csv “Unexpected error writing header”.
    Can you please tell me , whats going wrong in the setup.

    Reply
    • Alan

      Alan

      July 29, 2020

      Hi,

      Could you please share with us the exported CSV file via support so that we can check it.

      Reply
      • Varsha Gupta

        July 29, 2020

        Hey, I tried to export file though different FTP and I got empty csv exported file.

        Reply
  4. Laura

    July 15, 2020

    When I import orders via CSV, is there a way to trigger the ’email order details/invoice to customer’ action without doing it manually?

    Reply
    • Alan

      Alan

      July 17, 2020

      Hi,

      By default, there is no option to send emails to the customers including the order details/invoice. We can check the possibility of providing you with a custom code snippet for the premium version of the plugin so that order details or invoice will be sent to the users when importing. If you are interested in that then please reach us via support.

      Reply
  5. jamie

    June 3, 2020

    Looking to get started with importing orders with csv. not able to download or view the sample doc. any special instructions for that? or best / simplest way to create a CSV template to get started.

    Reply
    • Alan

      Alan

      June 5, 2020

      Hi,

      Here is the link to the sample order CSV file: https://www.webtoffee.com/wp-content/uploads/2016/09/Order_Sample_CSV.csv

      You can also get the sample template CSV file by exporting an order from your site using the plugin.

      Reply
  6. Luca

    May 27, 2020

    Is there a way to export only a certain state order? Like only processing or completed?

    Reply
    • Alan

      Alan

      May 28, 2020

      Hi,

      Yes, using the premium version of the plugin you can filter the order export based on the order status.

      Reply
  7. Eugene

    April 17, 2020

    Hello there,

    Looking for an export solution from Woocommerce and this is great, but in the csv templates I can see orders with single products only. Does your plugin supports exporting orders with multiple items(lines) and where I can find the template for that to check if it’s suitable for my ERP?

    Reply
    • Alan

      Alan

      April 17, 2020

      Hi,

      Yes, the plugin supports exporting orders containing multiple order items. Here is the sample CSV file containing multiple items in an order.

      Reply
      • eugene

        April 17, 2020

        Thanks! Appreciate! 😉

        Reply
      • Eugene

        April 20, 2020

        Hello again, Alan. One more question – is it possible to export ‘order lines’ each in new line/row(not colun)?
        What I am looking for, for the file with order to look like this:
        006(sku), 1(qty), 56(price)
        B11V2(sku), 5(qty), 111(price)… etc.

        We are willing to automatically create orders in our ERP, but parsing order lines where everything is in one cell is not a good idea. Any suggestions?

        Reply
        • Razvan M

          Mariana Florea

          May 28, 2020

          I am looking for the exactly the same functionality (like in the Advanced Order Export For WooCommerce plugin from Algol, which, however, does not have import)

          Reply
          • Alan

            Alan

            May 28, 2020

            Hi,

            We can provide you with a custom code snippet for the premium version of the plugin so that you can export the line items into separate rows instead of separate columns. Please reach us via support.

  8. Warren

    January 15, 2020

    When I try to export orders I get the following message
    This site can’t be reachedThe webpage at “site url”/wp-admin/admin.php?page=wf_woocommerce_order_im_ex&action=export might be temporarily down or it may have moved permanently to a new web address.
    ERR_INVALID_RESPONSE

    Reply
    • Alan

      Alan

      January 15, 2020

      Hi,

      We are able to export the orders without any issues in our test environments. The issue you are facing on your site might be due to some site-specific issues. Could you please reach us via support.

      Reply
  9. Michaël

    November 7, 2019

    Hi
    I’m trying to import my coupon with you plugin. My coupon have lower and upper case. The plugin convert every thing in lower case. Is it possible to have them not converted?
    Thanks!

    Reply
    • Alan

      Alan

      November 8, 2019

      Hi,

      Our plugin supports importing coupons having both lower and upper case letters. Please note that in the coupon list page all the coupon codes will be displayed in lower case letters. Please try opening/editing the imported coupon where you can see the correct imported coupon code.

      If the issue still persists please reach us via support.

      Reply
      • michael

        November 8, 2019

        That’s true, when I click on the coupon, it appears lowercase!
        Thanks

        Reply
  10. Fredrick Housel

    October 21, 2019

    Hi,

    I tried this out and it works mostly, but the few latest orders aren’t importing. In the log it looks like there’s a conflict with the importer trying to import some html and css… I checked the .csv file, there was some at the bottom, but even after cleaning that up, it still won’t import the newest orders. Not sure where it’s getting the html/css stuff.

    Reply
    • Alan

      Alan

      October 22, 2019

      Hi,

      Please reach us via support and share with us the CSV file you are importing. Our support team will follow you up from there.

      Reply
  11. Ajay

    April 11, 2019

    Hi

    We’re looking to use this plug in for exporting orders with several hundred order lines per order. Is there a way that we can export so that the products can be grouped so that the rows are the products and the columns are the customers? We would want to choose an order range.

    Reply
    • Alan

      Alan

      April 11, 2019

      Hi Ajay,

      Please share us a sample CSV file with the format you would like to have in the exported CSV. Please reach us via support.

      Reply
  12. jeremy.shreve

    jeremy.shreve

    April 4, 2019

    I am trying to use the export feature, but it is not exporting anything from my woocommerce addons (I use “check-out add’ons” plugin for woocommerce to add fields like “How did you hear about us?” and I need that data included in my export.

    Reply
    • Alan

      Alan

      April 4, 2019

      Hi,

      If you are using any third party plugin to create custom fields to the orders it will be stored as metadata. You may please export the orders with the option include hidden metadata checked and the custom metadata fields will be included in the exported CSV.

      Reply
  13. Fatma

    Fatma

    June 15, 2018

    csv export not included weight but i need that with export how i can add weight colums in export as well ?

    Reply
    • WebToffee Team

      Mark

      June 18, 2018

      Hi Fatma,

      By default, WooCommerce won’t store or display order total weight with the order details. Are you using any code snippet to do it? If yes, we can develop custom code snippet to export the data into the CSV if you provide corresponding meta key in which you are storing the data.

      Please reach us via support.

      Reply
  14. Erik

    Erik

    February 10, 2018

    I’ve done some own columns in the check out form. Is it possible to get them as well when I export the order to a CSV.file?

    Reply
  15. Karen

    Karen

    February 1, 2018

    I’m sure this question is answered somewhere… but I’m not sure whether to use the API key on our existing site that I’m exporting from? Or our staging site (which in a few month’s will be the production site) that I’m importing / merging into?

    Reply
  16. loison

    loison

    October 20, 2017

    Where can I find exported orders?

    Reply
    • Anindo

      Anindo

      October 21, 2017

      Hi loison,

      The exported orders will be downloaded as a csv.
      Or if you have an FTP connection setup, then your file will be downloaded in the FTP location.

      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 *

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

© 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

  • 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