Articles in this category

How do I export my customer data from Subbly?

Data export is possible through various sections of your Subbly dashboard. Data will be exported in the CSV file which you can use to further manage exported data. 


Exporting orders list

You can export your orders lists (of both pending orders or already shipped orders) from the Orders panel of your admin (click here). 

After applying appropriate filters to the list, make sure to click on the Export CSV button on the right side of the search bar as shown in the picture below.

Then choose which columns will be sent.

Next, once you click on Export, an email will be sent to the email address of the account owner, or the staff members who requested the export.

Finally, click on download and your browser will instantly download the exported file.

For Safari users only: You can download orders in Safari as well, although prompted with Source page initially, upon clicking on Download. When downloading the files open them in a new tab, then right-click or two-finger tap on the trackpad and this will call the system's context menu, and then you will be able to save the file. The file will be automatically saved in the CSV format.

Exporting customers list

If you want to export your customers' list instead, you can head over to the Customers section (click here). 

After applying appropriate filters (you can filter between active/inactive customers, or you can filter them by customer's tags), you can run an export by clicking on Export CSV button right beside filters. 

Just like for orders export, an email will be sent to the address of the account owner, or the staff members who requested the export, in order to download it.


Exporting subscriptions list

Go to the Subscriptions section (right here), filter by any particular or relevant criteria like labels, products or coupon applied, and click on Export CSV.

Just like for orders export, an email will be sent to the address of the account owner, or the staff members who requested the export, in order to download it.


Exporting Invoices

To export invoices, go to your Invoices section under the Customers tab.

Filter by any particular or relevant criteria like invoice status, products, customer tags or coupon applied and click on Export CSV.

Just like for orders export, an email will be sent to the address of the account owner, or the staff members who requested the export, in order to download it.


Exporting transactions

For those looking for the Quickbooks integration, although we don't have a direct integration with QB, you can use this one to export historical transactions in CSV and use that CSV to import into Quickbooks. Here you'll see how to export transactions in CSV. 

As of introduction of the Billing Engine version 2, you are now able to seamlessly export your previous transactions in CSV. This is very important as you are now able to export taxes as the separate column which will make tax reporting pretty much straightforward. 

In order to export transactions' CSV, you need to go here on your admin, select the date span for the transactions you're wanting exported and click on Export CSV

Just like for orders export, an email will be sent to the address of the account owner, or the staff members who requested the export, in order to download it.


Filtering options

Before taking out any export from your admin, or before performing any bulk action, it's important to understand different filtering options which will make it possible to narrow down the search of customers/invoices/orders that you'd want to action on. Subbly has different filtering facilities which can be broadly separated to

  • event filters (such as filtering by tags, products, or shipping countries...)
  • date filters (which can take into consideration both the creation date or the shipping date of the order for example).

Depending on the filters applied, Subbly will create a different dataset on your admin. You can reset the filters anytime by clicking the Reset button as in the picture below, which will reverse and negate any previously applied filters.

Different filters can be applied to the dataset at any given time.

As an example, you can filter the orders based on the creation date and only for the orders that are currently in awaiting delivery status. Additionally, you can use the date filter formatting to filter only those orders created since the 1st of May 2022 as in the picture below.

Similar to this one, you can use any other combination of filters to more closely filter out the dataset you need to action upon or export.


FAQ

Can I choose which columns to export?

Yes, by clicking the Export CSV button you will be prompted the following widget, in which you will be able to select any specific column you wish to export. Choosing columns is available while exporting Orders, Customers, Subscriptions and Invoices.

Can I add columns to the CSV's?

Unfortunately, this is not possible. If you're wanting to suggest adding some more columns in the CSV please make your suggestion here

Where can I see my customer's preferences?

Please check this article to learn about the available options!

Did you find this resource helpful?
Return to top
Ready to get started
with Subbly?
Try for free