How to Export & Import WooCommerce Subscription Orders

Planning to migrate your WooCommerce subscription orders but realized there’s no built-in way to do it? Don’t worry, there’s a simple workaround. In this article, we’ll show you how to easily import and export subscription orders using the WooCommerce Subscriptions plugin.

If you’re moving your store to a new platform, transferring all your subscription orders is a big deal, but it can also be a bit tricky. Since subscriptions are linked to products, customers, and past orders, accurately transferring everything can be challenging.

Doing it all manually requires a significant amount of time and effort, and there is a higher risk of making mistakes. That’s where a plugin can help.

In this post, we’ll examine one such tool: the Order, Coupon, and Subscription Import Export for WooCommerce plugin by WebToffee. It makes importing and exporting subscription orders easy and hassle-free. However, first, let’s discuss why migrating subscriptions is important and how using a plugin can make the process smoother.

When you export WooCommerce subscription orders, the export file can include the key data needed to recreate or update subscriptions in another store.

Depending on the export settings and selected columns, the subscription export file may include:

• Subscription ID
• Customer details
• Billing and shipping details
• Subscription status
• Parent order details
• Product and line item details
• Payment method
• Order date
• Trial period details
• Billing interval and billing period
• Start date
• Next payment date
• End date
• Coupon details
• Taxes, fees, and totals
• Subscription meta fields

This data is useful when migrating subscriptions to another WooCommerce store, creating backups, making bulk edits, or syncing subscription records between stores.

There are many reasons why a store owner wants to import or export WooCommerce subscriptions. Here are a few:

• Migrating to Another Store – Some store owners find managing subscription orders and regular orders in their WooCommerce store challenging, prompting them to consider migrating their WooCommerce subscriptions to another store.
• Bulk Updates – Import export actions are also carried out to update the subscriptions in bulk when significant changes are involved.
• Add New Subscriptions – When adding new subscriptions to your WooCommerce store, importing and exporting them is necessary to reflect the changes in other stores and manage them effectively.
• Creating Backups – You don’t want to trouble your customers if something goes wrong with your store. They’ll expect their subscription products to be delivered on time. Exporting subscription orders to a CSV or Excel file as the data to create a backup is a smart way to prevent issues and keep your customers satisfied.

Now that you know the benefits of importing and exporting WooCommerce Subscription orders, let’s dive into the step-by-step guide on importing and exporting WooCommerce subscription orders.

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

Step 1: Install & Activate Import Export Order Coupon and Subscription Plugin

Ensure you have purchased the Import Export Order, Coupon, and Subscription plugin from WebToffee.

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

Step 2: Select Subscription as Post Type for Export

• Go to Webtoffee Import Export (Pro) > Export.
• Select Subscription from the dropdown menu.

Proceed to the next step to select the export method.

Step 3: Select Advanced Export Method

There are two opinions here: you can either select 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.

Let’s proceed with the Advanced export.

Step 4: Filter Data for Exporting WooCommerce Subscriptions

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 filters, you can proceed to the next step.

You can use these filters based on your requirements.

Proceed to the next step for column renaming and reordering.

Step 5: 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.

Step 6: Advanced Export Options

Following are some advanced export options available in the plugin.

• Exclude already exported: Exclude already exported subscription orders.
• Exclude line items: Select Yes to exclude line items.
• Export file format: Set the export file format.
• 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.

At times, you might need to export WooCommerce subscription orders to an Excel file since they’re simple to manage and organize.

You can choose the XLS or XLSX file format to export subscription orders to an Excel file.

• Finally, click on Export to export subscription orders.

You can see a prompt message, ‘Export file processing completed.’ There, click on Download file to download the exported file.

Here is a preview of the export file opened in Excel.

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

Importing subscriptions will be easier if you have exported the Subscription orders using the same plugin.

The steps below will guide you in importing subscription orders to your WooCommerce store.

Step 1: Select Subscription as Post Type to Import

• Go to Webtoffee Import Export (Pro) > Import.
• Select Subscription from the dropdown menu.

Proceed to the next step to select the import method.

Step 2: Select Advanced 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.

• Select Local from the drop-down list to upload the exported file from your local storage.

Other import options are available, such as from URL and FTP. You can try this sample subscription file for performing a sample import on your store site.

• Then, upload the exported subscription data file.
• Set the delimiter and date format.

Proceed to the next step.

Step 3: Map Subscription Import Columns

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

Proceed to the next step.

Step 4: Configure Advanced Subscription Import Options

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.

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

• To import directly, choose Import from the Import/Schedule button.

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

Some WooCommerce stores use both subscriptions and memberships together. For example, a customer may purchase a subscription product that gives them access to a membership plan.

If you’re searching for WooCommerce membership import, it’s important to understand that subscription import and membership import are not always the same process.

A WooCommerce subscription usually contains recurring billing details, renewal dates, subscription products, payment methods, and customer order data. A WooCommerce membership may include access rules, membership plans, member status, start dates, expiry dates, and user access permissions.

If your memberships are connected to subscription products, export and import the subscription data carefully so the recurring billing records are preserved. However, membership-specific data may need to be migrated separately using a membership import/export tool or the import options provided by your membership plugin.

Before migrating a store that uses both memberships and subscriptions, check:

• Whether memberships are created through subscription purchases
• Whether membership access depends on active subscription status
• Whether your membership plugin supports member import/export
• Whether user accounts are migrated before importing subscriptions
• Whether product IDs and customer IDs match in the destination store

This helps ensure that customers keep the correct subscription billing records and membership access after migration.

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 mentioned in this article will help you migrate your WooCommerce store orders, coupons, and subscriptions.

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

Hopefully, this article helped you migrate your WooCommerce subscription orders. Do you have any thoughts you’d like to share? Drop them in the comments.