How to Import Export WooCommerce Subscriptions Using Excel?

This article provides a detailed guide on how to import export WooCommerce subscriptions using an Excel file. We will utilize the premium version of the WebToffee Order Import Export plugin, known for its user-friendly interface, making it a top choice for WordPress import-export needs.

If you have subscription orders on your WooCommerce store, you might need to import or export subscription orders at some point. One of the most effective ways to manage this is by using an Excel file, which makes it simple to add, remove, or change data fields. The familiar layout of Excel allows you to handle your data in a straightforward and accessible way.

For example, if you have a subscription service, such as a monthly delivery, you might need to update pricing or customer details for several subscriptions at once. With Excel, you can easily change multiple orders simultaneously, avoiding the hassle of editing each one individually.

Using the Order Import Export plugin from WebToffee, you can quickly import export WooCommerce subscriptions. This plugin makes transferring order data straightforward, making it an important resource for store owners who oversee subscriptions.

The plugin also has a free version in the WordPress plugin library with some basic features. You can import export WooCommerce orders and coupons to a CSV file using the free version.

Without further ado, let’s get started!

Before we begin, make sure you have purchased the premium version, as Excel support is only available with the premium version.

Firstly, install and activate the plugin on your WordPress dashboard. If you need help installing the plugin, refer to this article.

After installing the plugin, follow the below steps to export WooCommerce subscriptions to Excel.

Step 1: Select Subscriptions as Post Type to Export

Once you have installed the plugin,

• Go to the WebToffee Import Export (Pro) > Export.
• Choose Subscription as the post type to export.

Then, proceed to the next step.

Step 2: Choose Advanced Export Method

In this step, you must choose an export method for exporting WooCommerce subscription orders. Here, you will have two options: Quick export and Advanced export.

With the Quick Export option, you can quickly export all the important fields for WooCommerce subscription orders. Meanwhile, the Advanced Export option gives you several filtering options, allowing for more precise control over the export process.

Let’s choose Advanced export here and proceed to the next step.

Step 3: Filter Data for Export

Here, you will have various filtering options for exporting WooCommerce subscription orders. Use these filters to export the data the way you want it.

Step 4: Rearrange Columns for the Export File

Here, you can reorder the columns for the export file. Simply drag and drop the columns to reorder them accordingly.

After making the necessary changes, click to proceed to the next step.

Step 5: Export WooCommerce Subscriptions to Excel

Here, you have some advanced options for exporting WooCommerce subscriptions.

You can exclude already exported orders and line items.

• Enter a file name for the export file.
• Choose the file format as XLS or XLSX.
• Select any advanced options you want to add.

After configuring the advanced options, click the Export button to complete the export process.

You can see a prompt message saying, ‘File ready for download.’ Click on the Download to download the exported file.

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

Now that you have learned how to export WooCommerce subscriptions let’s see how we can import subscription orders to WooCommerce using an Excel file.

Importing subscriptions will be easier if the input file is exported using the same plugin.

Step 1: Select Subscriptions as Post Type to Import

• Navigate to WebToffe Import Export (Pro) > Import from your WordPress dashboard.
• Choose Subscription as the post type to import.

Proceed to the next step to choose an import method.

Step 2: Select Advanced Import Method

Here, you can choose Quick Import if you exported WooCommerce subscription orders using the same plugin; otherwise, choose Advanced Import.

Let’s choose Advanced import and explore the available options.

• Select the location of the import file. Choose Local to select the import file from the local storage. You can also import data from FTP, external URLs, etc.
• Upload the export file.
• Set the Delimiter and Date format.

Proceed to the next step.

Step 3: Map Input File Columns With WooCommerce Subscription Fields

Here, you can map columns and fields for importing WooCommerce subscription orders. You can also bulk edit the fields from here.

Proceed to the next step.

Step 4: Advanced Import Options for WooCommerce Subscriptions

Here, you have some advanced options for importing WooCommerce subscription orders.

• Choose whether you want to update existing orders only.
• Select whether to skip or update if subscriptions already exist.
• Choose whether to skip or import as a new item if there is a conflict with the post ID.
• Enable the settings if you want to link related products using shortcode.
• Link products using SKU instead of Product ID.
• Delete non-matching subscriptions from store – You can choose whether to delete subscriptions from your store that are not included in the input file.

Choose the options based on your requirements.

• Click on Save template to save these settings or proceed to Import/Schedule.

You can schedule import or select Import to import WooCommerce subscriptions directly.

When the import task is finished, you can see the import progress log with the number of successful and failed imports (if any).

This article was intended to help you import or export WooCommerce subscription orders using an Excel file. You can use a single plugin to perform import and export tasks for your WooCommerce store.

If you are planning to create subscription orders for your WooCommerce store, try our WooCommerce subscription plugin to set up subscriptions easily.

Hope you find this article helpful. If you have any questions or feedback, please comment below, and we will get back to you.