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
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.
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.
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.
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.
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.
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.
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
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.
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.
You can either schedule an import or go for a direct import.
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).
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.