Smart Manager plugin is compatible with the official WooCommerce Subscriptions plugin. So you can export all your subscriptions data and also edit subscriptions directly using the Excel-like spreadsheet.
More so, Smart Manager also supports custom post types and custom fields added by other plugins. So you can export and manage data of other WooCommerce subscriptions plugins data as well.
This blog simply explains how you can export all your subscriptions data or data based on filters (advanced export) like exporting all active subscriptions, export subscriptions who churned last month and so on.
How to export all subscriptions in WooCommerce?
For those who entered late, Smart Manager plugin enables you to manage your WooCommerce store at a blazing speed. Bulk edit, advanced search, export, delete, duplicate…you can accomplish hours of mundane store operations within minutes.
- Once you install and activate Smart Manager plugin, go to your WordPress Admin panel.
- Next, click on Smart Manager. It will load the ‘Products’ dashboard by default in an Excel-like spreadsheet.
- Select Subscriptions dashboard from the drop-down. If you do not see any data, create at least one subscription product (if not already created) and then create a test subscription using the
WooCommerce > Subscriptions
page. Then Smart Manager will automatically detect and display all the subscriptions in the dashboard. - Click on the
Export CSV
button at the top.
That’s it. All your subscriptions data will be exported. You can export 70+ data fields related to subscriptions with Smart Manager.
How to export subscriptions based on filters?
You can apply advanced search and admin column filters and export only the required data.
Export data based on column filters
All you need is to use the ‘Columns’ functionality of Smart Manager.
For example, if you want to export data that contains only ID, date, status, line items and order total, simply show/hide columns in Smart Manager, apply search filters if required and then make an export. Here’s how to show/hide columns.
You can also arrange admin columns to decide which columns to appear first in the dashboard and also sort columns before making an export.
If you want to export all the same set of data frequently, i.e export only the required columns or filtered data every month, you can set up a custom view and save it.
So every time, you only have to choose the saved custom view from the drop down and click on export, without applying any column filters or search filters.
Let’s look at different types of export with Smart Manager based on search filters.
Export all active subscriptions
- Make sure the ‘Status’ column is enabled. If not, enable it first. Here’s how.
- Now click on the
Advanced Search
toggle. - Select
Status
from the dropdown, selectis
operator and chooseActive
. - Click on
Search
. - All your Active subscriptions data will be in front of you. Click on
Export CSV
.
That’s it.
Export all canceled/switched/pending cancellation/expired/on hold subscriptions
Same steps as above. Simply change the Status in the search conditions.
- Make sure the Status Column is enabled. If not, enable it first.
- Now click on the
Advanced Search
toggle. - Select
Status
from the dropdown, selectis
operator and choose the required status. - Click on
Search
. - All your required subscriptions data for the selected status will be in front of you. Click on the
Export CSV
button.
That’s it.
Note – For filtering based on multiple statuses, you can add condition groups and add status conditions in each group.
Export all active subscriptions for a day/week/month/year/any date range
- Make sure the Status column is enabled. If not, enable it first.
- Now click on the
Advanced Search
toggle. - Select
Status
from the dropdown, selectis
operator and chooseActive
. - Click on
Add a condition
. - Select
Date
from the dropdown, select the required operator and choose the date and time.
For today, select == operator.
For the week, month, year, select ‘greater than equal to’ and ‘less than equal to’ operators. - Click on
Search
. - All your Active subscriptions data for a specific period will be in front of you. Click on the
Export CSV
button.
That’s it.
Like active, you can export all your subscriptions data for canceled/switched/pending cancellation/expired/on hold subscriptions based on a date range.
Export subscriptions based on order total, email…
All you need is to apply search filters as mentioned above and you get exported data as required. Export data for:
- Order total is above or below some amount or between some values.
- All email ids that does not involve gmail.com.
- Billing period is quarterly.
- Next payment schedule is for Jun 2022.
…and hundreds of things based on your requirements.
That’s the reason for Smart Manager being called a powerful WooCommerce subscription exporter tool.
Advanced WooCommerce products export and orders export with Smart Manager
Not just subscriptions export, you also get advanced products export, orders export, coupons export…export for any post type with Smart Manager.
- For products, you can export products, variations, images, categories, attributes; product types like bookings, memberships, vendors…all data or with filters to CSV. More on advanced products export.
- For orders, you can export order status, order total, shipping and billing details, taxes, products purchased…all data or with filters to CSV. More on advanced orders export.
Go beyond export with Smart Manager
Smart Manager is not just an export tool but a tool that dons multiple hats:
- Manage any post type using an Excel-like spreadsheet and make changes directly.
- Bulk edit any post type – products, orders, coupons, subscriptions, users, pages, posts…
- Add new post type records directly to the grid.
- Delete products or any post type records in bulk.
- Duplicate all or selected records.
- Print PDF invoices for WooCommerce orders.
Winding up
Smart Manager export feature is not for subscriptions, but also for other post types.
So you don’t have to purchase multiple plugins to export different records for different post types.
Moreover, Smart Manager is a complete store management plugin that helps you save time and cost.