WebToffee Logo
  • Home
  • Plugins
  • Blog
  • Documentation
  • Support
Login
0

Order/Coupon/Subscription Export Import Plugin for WooCommerce – User Guide

Last updated on February 2, 2022

Overview

The free version of the 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

What do we provide?

  1. Migrate both orders and coupons 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. Detailed history and debug logs are other main peculiarities.

Pre-requisites

  • Make sure mbstring is enabled on the server.
  • Only CSV file formats are supported.
  •  Download a CSV with: 
    •    Order Sample CSV
    •    Coupon Sample CSV
  • CSVs should be in UTF-8 format.

To initiate the basic plugin version, install and activate.

Getting Started

Hooray!!.. You have successfully activated the plugin. On activation, a new menu “WebToffee Import/Export(Basic)” will appear in the WP admin panel’s sidebar. 

webtoffee-import-export-menu-basic

We can navigate to the plugin settings in two ways:

  1. WebToffee Import/Export(Basic) from WordPress dashboard.
  2. Plugins > Installed Plugins > Order / Coupon / Subscription Export Import Plugin for WooCommerce (BASIC)> Settings (the user will be taken to the General Settings window.)

The plugin consists of five different sub-menus :

  •  Export
  •  Import
  •  History
  •  Logs
  • General settings

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

Export

Orders and coupons can be exported in just 5 steps:

  1. Select a post type: The available post types are Order and Coupon.
  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.

Refer Exporting orders and coupons for detailed step-wise export process.

Import

Orders and coupons can be imported in just 4 steps:

  1. Select a post type: The available post types are Order and Coupon.
  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.

Refer Importing orders and coupons for detailed step-wise import process.

History

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

  • Re-run: re-runs the action by taking the user to the respective screen.
  • View log: view a detailed import log
  • Delete: deletes the entry
  • Download: This option appears only for export action type. Here, you can download the generated export file.
History section in the basic version of import export plugin

To look into the History section:

  1. Click on WebToffee Import/Export(Basic) >  History
  2. One can sort the list with these available Filter options:
    • Post type: ALL, Orders, Coupons
    • 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.

Logs

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

  • View: to view detailed logs along with the reasons for failed parsing if any.
  • Delete: to remove the log
  • Download: to share the log report with the support team in case of issues

Reach the Logs section by clicking on WebToffee Import/Export(Basic) > Logs

Note: To get the log files saved to the Logs menu, one has to save the import logs

Save Import Logs

  1. Navigate through WebToffee Import/Export(Basic) > General Settings
  2. On the General tab, choose “Yes” for Save Import log to save import log as text file and make it available in the log section for debugging purposes.
  3. Click on Update Settings to finish.

General Settings

The General Settings tab helps to configure all the basic settings of the plugin. Click on  WebToffee Import/Export(Basic) > General Settings , to reach this module.

The General Settings sub-menu consists of two sections: 

  1. General
  2. Help Guide

General

Here, you can configure the basic settings.

  • Default Export batch count : Here you can give the default count for the records to be exported in a batch.
  • Default import batch count : Specify the default number of records to be imported in a batch.

Advanced options

  • Maximum execution time: Increasing the time will avoid uninterrupted data transfer. To remove the time limit, set value to zero. Default value is 600 seconds.
  • Generate Import log : Here you can choose ‘Yes’ to generate the import log as a text file and to make it available in the log section.
  • Default Export method : Here you can choose a default export method from the three given options:
    1. Quick export (chosen by default).
    2. Pre-saved template
    3. Advanced export
  • Default Import method : Choose an import method from three options Quick import, Pre-saved template, and advanced import. 
  • Default Export method : Choose an export method from three options Quick export, Pre-saved template, and advanced export. 
  • Auto-delete history: You can auto-delete the history by choosing ‘Yes’. 
  • Maximum entries : Here, you can specify the maximum records to retain in history. It will limit the number of records with the status ‘Finished’. 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 will not be impacted by this count.
General Settings in the basic order import export plugin

Import export pre-saved templates

This section lists all the pre-saved templates that were saved during an import-export process. You can also delete the template file.

Click on Update Settings to save changes.

Help Guide

The section consists of two tabs: 

  1. Help Links: Provides direct links to resources like documentation and support.
  2. Sample CSV: To download sample CSVs of order and coupon.

Conclusion

Order management is a key component of any eCommerce business. Adding the Order/Coupon Import Export plugin to your store will make your business smooth by enabling easy management of hundreds and thousands of orders and coupons in your store. Click here to know about the plugin.

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

Written by

Haritha

Haritha writes for WebToffee on everything related to WordPress/WooCommerce plugins in simple tutorials, blogs, and documentation to help run your WooCommerce store.

Comments (8)

  1. Jerry

    March 7, 2022

    Hi , i’m still facing the issues of id conflicts is their any thing to generate new post id instead of sku

    Reply
    • Alan

      Alan

      March 17, 2022

      Hi,
      Please try deleting/unmapping the ID column and try importing so that a new ID will be assigned.

      Reply
  2. Ric Dev

    March 3, 2022

    Hi Team,

    Presale question:

    We did order migration using free version. While importing we got order id conflct issue .

    Warning:
    Importing Order(ID) conflicts with an existing post ID:*****

    If we use premium version will it be solved ? Migration can be done without any conflict?

    Please confirm.

    Reply
    • Alan

      Alan

      March 17, 2022

      Hi,
      In the premium version plugin, there is an option to assign new IDs if there are any ID conflicts during import. You can also unmap/delete the ID column during import to overcome the ID conflict. WordPress will automatically assign the next available ID to the imported post.

      Reply
  3. Jatin

    October 7, 2021

    How to add custom fields to import/export – specially asking related to plugin ” Google Listings and Ads ” .

    Reply
    • Mark

      Mark

      October 9, 2021

      Hi,

      If you are using any third-party plugin to create custom data fields to products it will be stored as metadata. You may please export the product with the option Hidden meta checked in the export mapping and the custom metadata fields will be included in the exported CSV. Later on, you can use the same exported CSV as a template to import data back.

      Reply
      • Ad

        October 18, 2021

        “the option Hidden meta checked in the export mapping”

        This looks to be a paid option only.

        Reply
        • Mark

          Mark

          October 19, 2021

          Hi,

          Yes, exporting and importing custom metadata is one of our premium features. Please check out the pro version plugin to export and import metadata.

          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 *

Order Export & Order Import for WooCommerce

Get free plugin

On this page

  • Overview
  • What do we provide?
  • Pre-requisites
  • Getting Started
  • Export
  • Import
  • History
  • Logs
  • Save Import Logs
  • General Settings
  • General
  • Help Guide
  • Conclusion

Get started with your WebToffee plugin!

Your plugin will be downloaded in a few seconds...

All you need to do is add the plugin to your WordPress website.

To install and activate the plugin, view our installation guide.

download now

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

© 2021 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

© 2021 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 defines under this category are absolutely essential for the website to function. Hence they are loaded by default irrespective if user consent.

CookieDescription
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.
_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.
_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.
_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.
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.
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.
Save & Accept