Docs

Data Operations Articles & FAQ

billing, shipping, address, export, download, filter, subscription, customer

41075087

2022-08-26T14:53:38Z

2025-02-12T08:24:13Z

398

1

0

255454

How can I export a list of customers with their billing and shipping addresses?

How can I export a list of customers with their billing and shipping addresses? 

Scope

How can I export the billing address?

How can I export the shipping addresses of our customers?

How to download the customer's address as a CSV file?

How to pull a report of the customers based on the states of particular country?

Summary

In Chargebee you can filter data as per your search criteria using the Advanced filter option. You can export Billing addresses from Customers Index Page, and the Shipping addresses from the Subscriptions Index Page.

Solution

Billing address:
This option is available under the Customers Index Page. Navigate to Filter list > Billing Address

We have a list of specific billing address filters such as:

  • Address Line1

  • Address Line2

  • Address Line3

  • City

  • State

  • Country Code

  • Zip

  • Validation Status

You can choose any one (or) combined search criteria using multiple filters to narrow down the results. To filter the billing address in general, you can use Country Code and use condition as 'is present' to pull up all the countries (or) 'contains' to get specific countries list.

If you would like to save a particular set of conditions (a filter) to use again at a later time, click on the Save filter option. It allows you to name it and store the filter for future purposes.

Shipping address:

This option is available under Subscription Index Page. Navigate to Filter list > Shipping Address

We have a list of specific shipping address filters such as:

  • First Name

  • Last Name

  • Email

  • Address Line1

  • Address Line2

  • Address Line3

  • City

  • State

  • Country Code

  • Zip

  • Validation Status

You can choose any one (or) combined search criteria using multiple filters to narrow down the results. To filter the billing address in general, you can use Country Code and use condition as 'is present' to pull up all the countries (or) 'contains' to get specific countries list.

Once you set the filter as per your requirement, then you can click on Export > Export as CSV.

Alternatively, you can export the Shipping address using the same filters from Import & Export Data > Export Data > Subscriptions > Select criteria to export > Shipping Address and then click 'Preview' to view the results and 'Export' to download the lists in CSV format.

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?
How to export customers data of all active subscribers?
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 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…