When managing multiple eCommerce businesses a major problem you may encounter is importing or exporting products, orders, and other store data from one store to other. You can’t rely on the default WooCommerce options. They are so limited and provide you with only some basic functionalities.

In that case, what you need is a plugin that eases your effort. Well, in this article, we will introduce you to a plugin that exactly does the same. We are talking about the import export subscription orders plugin that lets you import and export orders, subscriptions, and coupons.

If you are looking for an option to migrate all your store data we would recommend you to use the bundled plugin for import export WooCommerce store data. The plugin comes as a suite that includes WooCommerce orders, coupons, and subscriptions along with other store data like WooCommerce products, WooCommerce customers, and WordPress users.

To keep this article short, let’s focus on importing and exporting WooCommerce subscription orders. Before we begin, some of you might wonder why you would want to import or export subscription orders from WooCommerce. Let’s answer it.

Why do you need to import and export WooCommerce subscription orders?

Here are some of the reasons why people want to import or export WooCommerce subscription orders

  • To migrate your subscription orders to another store.
  • To create a backup for subscription orders.
  • To add new subscriptions to your store.
  • To bulk update the subscription orders in the store

With that being said, let’s dive in,

Note: Make sure you have purchased the ‘Order Coupon, Subscription Export Import’ plugin from WebToffee. Download the plugin file from My Account > Downloads.

How to export WooCommerce Subscription Orders?

To export subscription orders from your WooCommerce store, follow these steps.

Step 1: Plugin Installation

Open your WordPress dashboard and go to Plugins > Add New.

Upload the plugin file and Activate the plugin. 

Step 2: Export Subscriptions

Go to WebToffe Import Export (Pro) > Export.

Select Subscription as the post type and proceed to the next step.

Select Subscription as post type to export

Choose Quick export to quickly export subscription orders from your store. For this article, let’s choose Advanced export.

Select Advanced Export options

Step 3: Filter Data 

Here there are some filtering options for exporting subscriptions from your WooCommerce store. Before we explain the next step you might need to understand why we need filtering options here. 

Let’s say you want to export subscription orders on your WooCommerce store dated from January 2022 to March 2022. Or, you may want to check the subscription orders of a particular customer, you can make use of these filtering options available with the plugin.

Let’s see the options in detail.

Export Subscription: Filter data

Total number of subscriptions to export: You can set a maximum number of subscriptions to export.

Skip first n subscriptions: If you want to skip the first 10 subscription orders add 10 in the numeric field provided.

Statuses: Let’s say you want to export ‘On Hold’ subscription orders – set the status as ‘On hold’. Likewise, you can export subscription orders from your WooCommerce store based on their order status.

Order Date (From and To): Set the specific date for subscription orders to be exported. You can set from date and to date as well.

Next Payment Date: You can export subscription orders based on the next payment date.

Payment methods: Export subscription orders based on their payment methods. You can set multiple payment methods.

Email: You can export subscription orders of a specific customer by using their email ID.

Product: If you want to export subscription orders for a particular product, simply enter the product ID or title here.

Coupons: Export subscription orders based on the coupons applied while checkout.

Sort Columns: Select how you want to sort columns. By default, the columns will be sorted based on order ID.

Sort by: Set the sort order here. By default, the sort order will be set to Ascending. 

Proceed to the next step.

Step 4: Map and reorder export columns

You can map and reorder columns in the export file here. 

Export Subscription : Map and reorder export columns

Use the cross icon in the left corner to rearrange the fields in the column. 

Proceed to the next step.

Step 5: Advanced Export options

The advanced options listed here will help you set batch export count and allows you to schedule an export. You can save the settings as a template for future exports.

Export Subscription: Advanced options

Click Export to complete the export process.

You can see a success message saying Export file processing completed.

Exporting Subscriptions completed

Click on the Download file button to save the CSV file to your local storage.

How to Import WooCommerce Subscription orders?

To import subscription orders to your WooCommerce store, follow these steps.

Step 1: Select Subscription as the post type

Go to WebToffe Import Export (Pro) > Import.

Select Subscription as the post type and proceed to the next step.

Select Subscription as the post type to import

Step 2: Select an import method

Set the Import method as Advanced import.

Select Local as the Import from option.

Select Advanced Import Subscription and upload CSV file to import subscription orders

Click on the blank area to upload the CSV file you want to import.

Set the delimiter as used in the CSV to separate columns. By default, the comma will be set as the delimiter.

Set the date format in the input file.

Proceed to the next step.

Step 3: Map import columns

You can map import columns and customize the values in the columns.

Import Subscription : Map Import Columns

To add or edit values in the column field, click on the pen icon near any column.

Select any field for the input file and use any of the operators +*/-()&@ along with the attributes to change the respective value.

Set Values for column

Proceed to the next step.

Step 4: Advanced Import options

Here you can decide whether to update existing subscriptions, set batch import count, or schedule an import. You can also save the template file for future imports.

Import Subscription: Advanced options

To schedule an import:

Click on the Import/Schedule button and select Schedule.

Schedule Import using WordPress Cron

Set WordPress Cron as the schedule type to schedule the import depending on your website visitors. 

You can use Server Cron if you have a separate system to trigger the scheduled events.

Set the Interval and Start time

Click Schedule Now to schedule the import.

To import directly click on the Import/Schedule button and select Import.

​​Once the import is complete, a pop-up will appear displaying the number of successful and failed imports (if any).

Import Subscription progress log

Wrapping Up

The plugin discussed in this article can help you import and export WooCommerce orders, coupons, and subscriptions. Those who are looking for options to import and export WooCommerce orders, make use of the free plugin available in the WordPress plugin directory. 

You may be interested in reading our detailed article on how to synchronize WooCommerce subscriptions to a specific date. If you have any thoughts about this article in your mind, please let us know in the comments.

  • Was this Helpful ?
  • YesNo

Leave a Reply

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