If you are migrating your business to Outseta from other subscription or membership management tools, you can easily import your existing subscribers into Outseta.
Best of all, if you're migrating from another product that processes payments with Stripe you can also import your existing customers' payment information making the migration process almost completely seamless for your existing subscribers.
Preparing your data for import
If you want to import existing subscribers or members, you'll perform an Account import in Outseta.
1) Start by going to CRM > ACCOUNTS and clicking IMPORT ACCOUNTS > GET TEMPLATE (SUBSCRIBER FIELDS).
If you prefer to work in Google Sheets, you can copy our OUTSETA SUBSCRIBER IMPORT TEMPLATE here instead.
This templates contains only the fields required to successfully import subscriptions. You can add any additional fields that you'd like to import as their own columns.
2) Copy and paste your existing subscriber data into the template file provided. The import process involves importing three buckets of information:
- Account Information
- Subscription Information
- Payment Information
This information allows us to recreate your existing customers' subscriptions in Outseta.
Account Information
This information identifies your member or subscriber. The required fields are:
- Name—The name used to identify the account.
- Account Stage—The billing stage the account is in. This will be a value like "Trialing" or "Subscribing."
- Primary Contact Email—The email address of the primary contact for the account.
This information is typically exported from your existing CRM, membership software, or Stripe account—basically anywhere we can grab an account name and email address from.
Subscription Information
This information helps us reproduce each customers' current subscription in Outseta. The required fields are:
- Subscription Start Date—The date that the subscription originally started. This must be a date in the past.
- Subscription Renewal Date—The date the subscription will renew and the customer will first be charged by Outseta. This must be a date in the future. For one-time plans (which don't renew), set this date to 12/30/2099.
- Subscription Renewal Term—Enter monthly, quarterly, yearly, or one-time.
- Subscription Plan UID—The Subscription Plan UID is how we identify the subscription plan you want to map the customer to in Outseta. You can find this value once you setup your pricing plans in Outseta by navigating to BILLING > PLANS and clicking on the name of any of your pricing plans.
This information is typically exported from Stripe or your existing subscription or membership management platform. Most often you'll access this information by doing a Subscriptions Export in Stripe. Please make sure to set the date range to ALL and include ALL COLUMNS in your export.
Payment Information
If you are migrating from another product that also processes payments with Stripe, we can also import each customers' credit card details so they don't need to re-enter this information.
The required fields are:
- Stripe Customer Token (Customer ID)—This token identifies the customer in your Stripe account. It typically starts with cus_.
- Stripe Payment Token (Card ID)—This token identifies the default payment method for the customer in Stripe. It typically starts with either pm_ or card_.
This information is accessed by doing a Customer Export in Stripe. Please make sure to set the date range to ALL and include ALL COLUMNS in your export.
NOTE: If for any reason your export does not include the Card ID or other payment information required for import, please email support(at)outseta.com. This is common—while you may have credit card information for each of your customers stored in Stripe, it may not be set as what Stripe calls the default_source and thus won't be included in your export file. We have a tool that can set the payment information for each customer automatically to the default_source so that it can be included in your export file.
Now that you know all of the information you'll need to successfully import subscribers into Outseta, you're ready to get started. Save your import file as a CSV.
If you need help preparing your data, email [email protected]. We offer this service free of charge to paying customers.
Importing your data
Before you import all of your existing subscribers into Outseta, we highly recommend that you do a Pilot Import where you import 3-5 subscribers prior to your entire data set. This gives you the opportunity to make sure the Pilot Import goes smoothly and all of your subscriber data is mapping as you'd expect.
Assuming all goes well with your pilot import, follow the steps below to complete your import.
1) Go to CRM > ACCOUNTS > IMPORT ACCOUNTS and select UPLOAD FILE. On the subsequent screen click UPLOAD FILE.
2) Select your file. The subsequent screen will ask you to map fields between your import file and Outseta.
- The INCOMING FIELDS represent fields in your import file.
- The DESTINATION FIELDS represent fields in Outseta.
Map your field appropriately then click CONTINUE.
3) The following screen will show you how many rows in you spreadsheet have Valid vs Invalid data. Be sure to turn click on Invalid—rows that will have problems importing will be highlighted, and if you hover over the data you'll see an explanation of the issue any Invalid contain.
By far the most common issue will be rows with a Subscription Renewal Date in the past. For example, if it's January 15, 2025 and you import a monthly subscription with a Subscription Renewal Date of January 1, 2025 the row will be called out as Invalid. In this scenario, simply update the Subscription Renewal Date to February 1, 2025.
Once you fix or delete any Invalid rows, click SUBMIT DATA.
4) That's it! Your data is now importing—sit tight. As the message says, it will take anywhere from 2 to 15 minutes to import your data depending on the size of your import.
Once completed, it's worth spot checking a few accounts to see that their subscription information looks correct and that payment information is shown on their Account record like you see in the example below.
Final Steps
1) Once your import has completed successfully, make sure to cancel your previous subscriptions. Otherwise your customers may end up getting charged both by Outseta and your previous payment provider. Cancel the pre-existing subscriptions however you would normally cancel a subscription—this may be directly in Stripe, or it may be done through your membership software provider depending on the product you're migrating from.
2) The final step after a successful import is to get your subscribers to establish a password with Outseta. There are two different approaches to consider here:
- Email users a link to a "Reset Password" page
- Send users Outseta's "Confirmation Email"
Email users a link to a "Reset Password" page
Outseta provides a hosted page to all customers where users can input their email address to reset their password. After importing your subscribers, you can send your subscribers an email prompting them to go to this page to establish a password.
The URL of your page will be in the format: https://yourdomain.outseta.com/auth?state=forgotPassword
Make sure to update the bolded "yourdomain" section of the URL to reflect the URL of your Outseta account.
Send users Outseta's "Confirmation Email"
You can send Outseta's Confirmation Email (which walks the new subscriber through the process of setting their password) in bulk by going to CRM > ACCOUNTS and selecting the accounts that need to establish a password. Next, click SEND CONFIRMATION EMAIL.
NOTE: At this stage you've already imported your subscribers so they have an existing Account in Outseta—they just haven't established their password yet. If you want to make any copy edits to the confirmation email that the user will receive, you can access the email template by going to SETTINGS > TEMPLATES > EMAILS. The CRM - REGISTRATION CONFIRMATION template is the one that will be sent.
3) IMPORTANT—If you have existing drip email campaigns setup in Outseta (for example, emails sent to new subscribers) importing new subscribers will trigger those drip email campaigns. If you don't want your imported accounts to receive these emails, you should temporarily put your drip campaigns back in "Draft" mode so the imported accounts won't receive these emails.
That's it! Congrats and welcome to Outseta. Shoot us an email at [email protected] if you need any help importing your data.
Video Demo of Subscriber Import Process
If you'd like to see a video demonstration of the subscriber import process end-to-end, you can watch Geoff both prepare data for import and complete a subscriber import below.
Helpful Tips, Tricks, and Tools
A few tips, tricks, and tools that might be helpful having done a whole lot of these imports!
Subscription Expiration Date—Add this column to your import file if you want a subscription to end on a specific date.
Subscription Discount Code—Add this column to your import file if you want to automatically apply a discount code to a subscription. The discount code must be configured in Outseta first.
Split text to columns—The "Split text to columns" feature is in Google Sheets (found under the DATA tab) is helpful if you have Full Names (Tom Brady) than you want to split into First Name (Tom) and Last Name (Brady) fields. Choose the "Space" option to identify where the split should occur.
Concatenate—A helpful function in combining names together. The "Split text to columns" function may inadvertently split longer names into multiple columns. Concatenate can help you combine those names back together (this is common with longer names like Thomas Julian Edelman Brady).
VLOOKUP or Google Sheets Merge Sheets Extension by Ablebits—Preparing your data most often starts with merging your "Subscriber" and "Customer" data from Stripe based on a common value found in your export files. We recommend using the "Customer ID" value for this purpose.
If you're familiar with Google Sheets, Excel, or spreadsheets in general then the VLOOKUP function is a common method of doing this. If you're not, the "Merge Sheets Extension" for Google Sheets is a great option—you can watch me use this extension in the video demonstration above.