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

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!

This tutorial explains how to setup Order / Coupon / Subscription Export Import Plugin for WooCommerce. Please refer to the product page to know more about the plugin features.

Overview

Order / Coupon / Subscription Export Import plugin is an ideal plugin for exporting and importing orders/coupons / subscription orders to/from your WooCommerce store for migrating an existing online store.

Import Order / Coupon / Subscription

Orders: You can import orders from WooCommerce store as well as another e-commerce platform. It exports orders from WooCommerce store to the CSV file. You can import/export/merge(update existing order) hundreds, even thousands, of orders using one file which saves your effort and time of manually adding order information.

Coupons: You can import/export/merge(update existing order) hundreds, even thousands, of coupons using one CSV file which saves your effort and time of manually adding coupon information.

Subscription orders: Since the subscription involves a product, customer, payment gateway and an order, migrating subscription orders can be very difficult. But this plugin provides you an easy and flexible way to import the subscription orders. You can import/export/merge(update existing subscription order) hundreds, even thousands, of coupons using one CSV file which saves your effort and time of manually adding information.

You can map your import columns to the appropriate WooCommerce data to import or merge orders, coupons and subscription order. You can also import data from a variety of sources, such as an uploaded CSV file on FTP, locally saved CSV file to your computer.

For importing orders/coupons/subscription orders to your online store, you must create a CSV(Comma-Separated Values) file which contains information about mapping fields in a tabular form. You can create CSV file by using a spreadsheet program, such as  Excel, or Google Spreadsheets. Save this file with extension.CSV.  After entering all details about orders/coupons/subscription orders in the spreadsheet, you can import to your online store.

Export Order / Coupon / Subscription

Plugin easily exports your WooCommerce shop orders, coupons, and subscription orders to CSV file with multiple powerful filters such as order status, date ranges, coupon types, subscription order status, etc. Even the plugin automatically upload your exports via FTP.

Order XML File Import Export

Order XML File Export Import for WooCommerce plugin allows you to easily export or update metadata of orders of your store into the XML file format required for printing the labels, shipment tracking, etc. by using Stamps.com/FedEx Desktop/UPS WorldShip/ Endicia Desktop Application. You can export/update existing hundreds, even thousands, of orders using one file which saves your effort and time of manually adding order information.
The plugin also exports individual orders from Orders listing page, export all orders or specified orders by offset/limit with a certain date range in bulk.

For updating orders to your online store, you must import XML file which is a reply from Stamps /FedEx Desktop/UPS WorldShip/ Endicia Desktop application which contains information about the orders (tracking number, postage cost, etc. ) along with the Order ID.

Pre-requisites

  • For using Subscription Orders Import/Export, you must set up your WooCommerce online store with the following plugins:
    • WooCommerce Subscriptions
    • WooCommerce payment (Stripe, PayPal) Gateway

Installation

After purchasing the Order / Coupon / Subscription Export Import Plugin for WooCommerce, plugin Zip file is available in MY ACCOUNT.

  1. Navigate to My Account -> API Downloads tab and download the plugin.
    Note: If you have Basic/Free version already installed, please Deactivate and Delete the Basic Version before installing Premium Version to avoid any conflict. Your plugin settings will be retained intact.
  2. Install the downloaded plugin zip into your WordPress / WooCommerce Site.
  3. You get Activation Key and Activation Email at My Account -> API Keys.
  4. Go to your site Admin and the Settings page of the plugin and activate it using email and key.

For detailed information about installing Plugins, See How to Download, Install, Activate & Update WooCommerce Plugin?

Navigating to Order / Coupon / Subscription Export Import Plugin for WooCommerce

After installing the plugin, you can navigate to it as given below:

  • Navigate to Plugins > Installed Plugins > Order / Coupon / Subscription Export Import Plugin for WooCommerce > Import Export link OR;
  • Navigate to Dashboard > WooCommerce > Order Im-Ex or Coupon Im-Ex, Subscription Order Im-Ex, or Order XML Im-Ex as per requirement. It is as shown below:
    WooCommerce Admin Menu
    WooCommerce Admin Menu

Order tab

You can import orders from WooCommerce store as well as another e-commerce platform. It exports orders from WooCommerce store to the CSV file. You can import/export/merge(update existing order) hundreds, even thousands, of orders using one file which saves your effort and time of manually adding order information. For more information about Order Import / Export, please refer How to Import and Export WooCommerce Orders using Order / Coupon / Subscription Export Import Plugin?

Coupon tab

You can import Coupon from WooCommerce store as well as another e-commerce platform. It exports Coupon from WooCommerce store to the CSV file. You can import/export/merge(update existing Coupon) hundreds, even thousands, of Coupons using one file which saves your effort and time of manually adding Coupon information. For more information about Coupon Import / Export, please refer How to Import and Export WooCommerce Coupon using Order / Coupon / Subscription Export Import Plugin?

Subscription Order tab

You can import Subscription Order from WooCommerce store as well as another e-commerce platform. It exports Subscription Orders from WooCommerce store to the CSV file. You can import/export/merge (update existing) hundreds, even thousands, of Subscription Orders using one file which saves your effort and time of manually adding Subscription Order information. For more information about Subscription Order Import / Export, please refer How to Import and Export WooCommerce Coupon using Order / Coupon / Subscription Export Import Plugin?

Order XML tab

Order XML File Export Import for WooCommerce plugin allows you to easily export or update metadata of orders of your store into the XML file format required for printing the labels, shipment tracking, etc. by using Desktop Application. You can export/update existing hundreds, even thousands, of orders using one file which saves your effort and time of manually adding order information. The available methods are as given below:

Order XML Help tab

Under Order XML Help tab, you can find sample Export and Import XML with documentation links as shown below:

Order Xml Help
Order XML Help

Import/Export Settings tab

Under settings of menu tab, you can set the FTP settings to export Order / Coupon / Subscription as well as XML Orders. Also, you can auto-export / import the Order, Coupon, Subscription, and XML Order.

The FTP Settings for Import/Export  as shown below:

FTP Settings for Export Orders
FTP Settings for Export Orders
  1. Select the checkbox to enable FTP import/export Orders.
  2. Enter FTP Server Host/IP.
  3. Enter FTP User Name.
  4. Enter FTP Password.
  5. Select Use FTPS checkbox to connect securely.
  6. Choose the Enabled option to Automatically Export Orders from FTP Server Host/IP.
  7. Enter the required Export Start time for exporting the Orders.
  8. Enter the time interval in minutes for exporting Orders.
  9. Choose the Enabled option to Automatically Import Orders from FTP Server Host/IP.
  10. Enter the required Import Start time for importing the Orders.
  11. Enter the time interval in minutes for importing Orders.
  12. Select Update Orders if exist checkbox to merge existing orders with the updated details. The Merging is possible only if the ID of order already exists in your online store. Otherwise, the order is imported as a new one.
    If the Update Orders if exist field is not checked while importing and if the IDs of the importing orders already exists in the store, the orders will be imported with a new ID. Otherwise, if the original order ID does not exist in the store, the ID for the order will be retained after the import.
  13. Select a required mapping file from the Select a mapping file drop-down list.
  14. Click Save Settings to save settings.
    For more information about corn job, please refer Setting Up The Cron Job.
    Similarly, you can set the FTP settings for import and export of coupon, subscription order, and XML order.

Delete Trashed Orders / all Orders/ all Coupons

As an Admin, you can delete the Trashed Orders, all orders, or all Coupons in a click. To do this, navigate to Dashboard > WooCommerce > System Status > Tools. It appears as shown below:

System Tools
System Tools
  1. Delete Trashed Orders: Click Delete Trashed Orders button to remove all the trashed orders.
  2. Delete Orders: Click Delete Orders button to remove all the orders from the online store allowing you to start with fresh orders.
  3. Delete Coupons: Click Delete All Coupons to remove all the coupons from the online store allowing you to start with fresh coupons.
  4. Delete Trashed Subscription Orders: Click Delete Trashed Subscription Orders button to remove all the trashed subscription orders.
  5. Delete Subscription Orders: Click Delete Subscription Orders button to remove all the subscription orders from the online store allowing you to start with fresh orders.

Check out our Order / Coupon / Subscription Export Import Plugin for WooCommerce.

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!

6 thoughts on “Setting Up Order / Coupon / Subscription Export Import Plugin for WooCommerce

    • WebToffee
      Mark says:

      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.

  1. Karen
    Karen says:

    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?

    • Anindo
      Anindo says:

      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.

Leave a Reply

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