Import Export WooCommerce Subscription Orders: Step-by-Step Guide

Import Export WooCommerce Subscription Orders: Step-by-Step Guide

Have you ever considered migrating your WooCommerce subscription orders? Then, you must be annoyed by the fact that WooCommerce misses out on that option. Fear not, when it comes to WooCommerce, there’s always a solution out there.

We are here to help you import and export subscription orders from WooCommerce. In this article, we will be discussing the Import Export Order, Coupon, and Subscription plugin by WebToffee. The plugin lets you import and export WooCommerce orders, coupons, and subscriptions from your store site. You can migrate orders from one store to another, export orders into a CSV file, and more.

If you want help with migrating all your store data, you can use our import export suite for WooCommerce plugin. The suite includes:

  • Import and Export Products of all Types
  • Orders, Coupons, and Subscriptions
  • WordPress Users and WooCommerce Customers
  • Product Ratings and Reviews
  • Migrate product categories and tags

If you want to set up WooCommerce subscriptions in your store, you can do so with our WooCommerce subscriptions plugin.

Before we begin, some of you may want to know why you should consider migrating subscription orders from your WooCommerce store. So let’s go into detail.

Benefits of Import Export WooCommerce Subscriptions

There are many reasons why a store owner wants to import or export Woocommerce subscriptions. Following are some:

1. Migrate subscription orders to another store.

Some store owners find it difficult to manage subscription orders along with regular orders in their WooCommerce store, so they’re looking for migrating WooCommerce subscriptions to another store.

2. Bulk update WooCommerce subscriptions

You can bulk update WooCommerce subscription orders by modifying the import file.

3. Add new subscriptions to WooCommerce store

Add new subscriptions to your WooCommerce store, import subscriptions from other stores, and manage all your subscription orders with the export file.

4. Creating backup for subscription orders

You don’t want to trouble your customers when there’s an error with your store. They’ll be expecting their subscription products to be delivered on time. So creating a backup for WooCommerce subscription orders is a good idea to save your customers from trouble.

Now that you are aware of the benefits of importing and exporting WooCommerce Subscription orders, let’s dive into the step-by-step guide on how to import and export WooCommerce subscription orders.

Make sure you have purchased the Import Export Order, Coupon, and Subscription plugin from WebToffee and installed it on your WordPress dashboard.

To install the plugin:

  • Download the plugin file from My Account > Downloads on your WebToffee account.
  • Upload the zip file to your WordPress Plugin directory.
  • Activate the plugin.

Export WooCommerce Subscription Orders

Follow the below steps to export WooCommerce Subscription order to a CSV file.

Step 1: Select Subscription as post type

Go to Webtoffee Import Export (Pro) > Export.

Select Subscription from the dropdown menu.

Export Subscription Orders Step 1 : Select a post type

Proceed to the next step to select the export method.

Step 2: Select an export method

There are two opinions here, you can either quick export or go for advanced export.

Quick export – It lets you export all the basic fields for subscription orders

Advanced export – Gives you advanced options for exporting WooCommerce subscription orders. It includes data filtering, column header renaming, and more.

Export Subscription Orders Step 2: Select an export method

Let’s proceed with Advanced export.

Step 3: Filter data

Here are the filtering options available to export WooCommerce Subscription orders. This step is optional. If you want to export all subscription orders from your store without applying any filters, you may proceed to the next step.

  • Total number of subscriptions to export: Enter the total number of subscription orders you want to export.
  • Skip first n subscriptions: Allows you to skip the first ‘n’ number of subscriptions.
  • Statuses: Export subscriptions based on their status. Eg: Pending, Active, On Hold, etc.
  • Order Date (From and To): Export subscription orders placed between the specified time period.
  • Next Payment Date: Export subscription orders based on the next payment date.
  • Payment methods: Export subscription orders based on payment method.
  • Email: Export subscription orders based on email.
  • Product: Export subscription orders for a specific set of products.
  • Coupons: Export subscription orders based on the applied coupon.
  • Sort Columns: Sort the exported data based on the selected columns in the order specified.
  • Sort By: Set the sort order for exporting subscription orders.
Export Subscription Orders Step 3 : Filter data

You can use these filters based on your requirements.

Proceed to the next step for column renaming and reordering.

Step 4: Map and reorder export columns

You can rename and reorder columns in the export file from here.

Use the cross icon on the right side of the column option to drag and drop the columns.

You can change the column name for the export file by simply editing the text fields.

Export Subscription Orders Step 4 : Map and reorder columns

Step 5: Advanced options/Batch export/Scheduling

Following are some advanced export options available in the plugin.

Exclude already exported: Export already exported subscription orders.

Exclude line items: Select Yes to exclude line items.

Export file format: Set the export file format. CSV and XML supported.

Delimiter: Set the delimiter for separating columns.

Enable FTP export?: Select Yes if you want to enable FTP export, else select No. The plugin supports scheduling export.

Export in batches of: Set the export batch count.

Export Subscription Orders Step 5 : Advanced Options

You can save these options for future exports.

Select Save template > Enter a Template name > Click Save.

Finally, click on Export to export subscription orders.
You can see a prompt message ‘Export file processing completed’.

Click on Download file to download the exported file.

Now let’s see how to import subscription orders to a WooCommerce store.

To Import WooCommerce Subscription Orders

The below steps will guide you to import Subscription orders to your WooCommerce store.

Step 1: Select subscription as the post type

Go to Webtoffee Import Export (Pro) > Import.

Select Subscription from the dropdown menu.

Import Subscription Orders Step 1 : Select a post type

Proceed to the next step to select the import method.

Step 2: Select an import method

Import method: You can go for Quick import or Advanced import. Advanced import options will take you through the entire process of filtering, column mapping, and other advanced options. Let’s go with the Advanced import option.

Step 3: Upload the import file

Import from: Select local from the drop-down list to upload the exported file from your local storage. There are other import options as well like from URL, and FTP. You can try this sample subscription file for performing a sample import on your store site.

Import Subscription Orders Step 2 : Select an import method

Proceed to the next step.

Step 4: Map import columns

The following options will help you map the import columns in the CSV/XML file to that of the WooCommerce subscription fields.

Import Subscription Orders Step 3: Map import columns

Proceed to the next step.

Step 5: Advanced options/Batch import/Scheduling

The following options will help you set the batch import count, schedule an import, and more.

Here you can update subscription data in your WooCommerce store.

Import Subscription Orders Step 4: Advanced Options

You can either schedule an import or go for a direct import.

Import directly

Choose Import from the Import/Schedule button.

After importing you can view the import log with the number of successful and failed imports (if any).

Wrapping Up

Store owners who sell subscription-based products on their WooCommerce store may need to import and/or export subscription orders for various reasons. The plugin we mentioned in this article will help you migrate your WooCommerce store orders, coupons, and subscriptions.

If you are looking for options just to import export WooCommerce orders, you can try our free plugin available in the WordPress plugin library.

Hopefully, this article helped you in migrating your WooCommerce subscription orders. Any thoughts you’d like to share? Drop in the comments.