Docs

Data Operations Articles & FAQ

export, subscription, api, active, customer, data

41075087

2022-08-19T13:07:45Z

2025-02-12T08:24:09Z

1416

0

0

255367

How to export customers data of all active subscribers?

How to export customers data of all active subscribers? 

Scope 

Report of a list of all our current subscribers with their names and email address.

How to download reports of specific subscriptions?

Summary 

We can download the subscription data from Subscription Index Page and from Export Data Page. You can also export it via API.

If you see the subscription, customer, or invoice index pages, as per the current configuration it displays it as 1000+ if the underlying data is more. To view the complete list you can click on the Export CSV option available in the index pages, and on the resulting CSV file, you can figure out the exact number of subscriptions present on your site.

Solution 

Export Subscription data via UI 

I. Subscription Index Page

Go to Subscription Index Page and you can download the report using Advanced Filter Options from 'Filter List'. Click on All Subscriptions > Active And Non Renewing.

You can also use multiple filters if required and then you can click on Export and download it using Export as CSV.

Note: On the recent UI enhancement you can now scroll the index pages - Customers, Subscriptions, Invoices, and Credit Notes vertically. Earlier, the pages will be paginated which may prolong your search however with the new enhancement as you scroll down the list it will load all other data in a single page. Refer to this link for more information. 

II. Import & Export Data:

Navigate to Settings > Import & Export Data > Export Data > Subscription > Select criteria to export.

You can download the report for current subscriptions that include the Active, Non-Renewing statuses. You can choose the subscription statuses from 'Status > Includes > Active, Non-Renewing'. You can also include other statuses such as Trial and Future as per your business requirements.

You can 'Preview' the data and 'Export' as a CSV file.

Once the export is initiated, it will be downloaded automatically on your device also this exported report will be available in Chargebee for the next 14 days under Settings > Import & Export Data > Export history.

The downloaded zip file will have multiple files as per the entities shown below.

The Subscription.csv file will have the list of subscriptions with the Customer ID, Customer Name, and Customer email address.

Export Subscription through API:

You can use the Export Subscriptions API and find the relevant parameters to export subscriptions by the status mentioned below.

Relevant Parameters:
subscription[status][operator]: Current state of the subscription
Supported operators : is, is_not, in, not_in
Possible values arefuture, in_trial, active, non_renewing, paused, cancelled

Example  subscription[status][is] = "active"

Related Articles 

While performing bulk operations, all the columns are consolidated into a single column in the template upload file.
How can I import multiple coupons into Chargebee using Bulk operations?
How can I export items with the import format on PC 2.0?
How to disable or remove the trial period from the multiple price points of multiple plans in bulk on PC 2.0 Chargebee site?
How do I migrate subscriptions from Stripe to Chargebee while continuing to use Stripe as my payment gateway?
Bulk upload subscriptions for an existing customer: Parallel processing of data
What bulk operations can I perform in Chargebee?
I am getting the "the column () appears more than once in file" while importing data into Chargebee. How can I fix this?
Types of addresses added for customers in Chargebee
How to export list of customers with excess payment?
How to add notes to a customer record that is visible only for the business's reference?
How to not send the cancel subscription emails to subscriptions that have a cancellation scheduled?
Euro currency display on invoice PDF - Symbol is displayed in the incorrect order.
How do I migrate subscriptions from a different billing system to Chargebee while using Stripe as my payment gateway?
Retrieving order information from Chargebee.
How to import credit notes?
What are all the bulk operations for Payment Method?
How to migrate offline customers into Chargebee?
How to export the billing periods associated to the subscriptions?
Bulk apply coupons to subscriptions
How to export order reference IDs?
Line items ID missing for tiered addons in the product catalog export
How to export subscriptions specific to a recurring addon?
I need to download a report for ‘Not Paid’ invoices within a specific period.
Is it possible to build a report to show all the customers and the total amount of usage (units)?
Extract new trial customers contact details on a daily basis
How can I export a list of customers with their billing and shipping addresses?
How to manually sync status for in-progress transactions?
How to collect payment for invoices in bulk?
How to create a report for invoices that have promotional credits applied?
How to export payments that was successful?
I want to create an advance invoice on a recurring basis via bulk operation. what are the values that I need to pass in the bulk operation CSV?
How to export list of customers who has payment method with auto-collection 'OFF'?
How to update customers' auto collection in bulk?
Was this article helpful?
Loading…