Overview


Ontraport provides you with tools that allow you to easily import your contacts and their data into your account. However, there are some types of data that must be imported by our team, such as:

  1. Credit Cards
  2. Open Orders (subscription payments and payment plans)
  3. Purchase History
  4. Affiliate/Partner Referral Data
  5. Notes

If you are interested in having our team perform any or all of these custom imports for you, please follow the instructions below to prepare your data, and submit it for your custom import request to concierge@ontraport.com.

Before you begin the custom import process, it’s important to understand:

  • Importing custom data is a specialized process that can only be completed by our Engineering team. It is not possible for you or the Client Experience team to import this data.
  • The cost of a custom import is $150/hour, and typical imports take between 1-4 hours each. Please note, imports can take longer depending on the complexity of your needs.
  • To ensure that your sensitive data is protected, Ontraport will not retrieve or format any of the data and/or files required for your custom imports.
  • Ontraport will not contact your third party providers to discuss the data you’ve provided.
    1. The only exception is importing credit card information where the Engineering team works with the PCI compliant provider to import your data.

Project Breakdown


Here’s what to expect when you submit a custom import request:

  • Once you submit your request to concierge@ontraport.com, the Engineering team will review your ticket and provide an estimate of the total required work hours and days to complete the project.
  • After the estimate is handed off to the concierge team, we will send the account owner our “Custom Import Project Terms & Conditions” which includes your estimate and total cost for the project.
    1. Note, projects are billed 50% up front and 50% upon completion.
  • Upon receiving your signed terms and conditions, your files will be sent to the Engineering team to be imported.
  • When the project is complete, you will be billed for the remaining 50%.

To prepare your data


In order to import your data as quickly as possible, please follow these guidelines when preparing and formatting your CSV file:

  1. Date Format: If you are importing dates, use the YYYY-MM-DD or YYYY-MM-DD HH:MM:SS format.
    1. “HH:MM:SS” is optional unless it’s included in your data fields.
  2. Currency Format: Format your prices using exactly two decimal places (i.e., forty six dollars and twenty cents is 46.20). If your account’s currency code doesn’t support decimal places, such as JPY, you don’t need to include them.
  3. Column Header Format: Your CSV column header names need to exactly match the example “Import CSV Column Name” provided in each section — they are case-sensitive.
  4. Specify if you’d like to create new contacts if no match is found for a credit card, purchase or open order.
  5. Remove any blank column headers or blank lines from your CSV.

Credit cards


Importing credit card information is a PCI compliant process, and all information must be sent from one PCI compliant processor to another — we cannot accept credit card data directly from individuals or businesses that are not PCI compliant processors. Please do not send any credit card data to us.

If you have credit card information on file, please contact concierge@ontraport so we can determine the best method for importing.

To import credit card data:

  • Obtain contact information from your current PCI compliant processor holding the card data. This will be the person you designate to work with Ontraport to transfer the information securely.
  • Advise them that you have asked Ontraport to transfer the credit card data.
  • In most cases, they will have a “ticket” or “issue number” assigned for the upcoming transfer.
  • Contact our concierge team at concierge@ontraport.com with the contact information and ticket or issue number.Ontraport will work directly with your current PCI compliant processor to transfer the credit card data.

The file provider must send Ontraport a CSV file with the following information:

  1. Card Number
  2. Expiration Date
  3. Email Address – can be omitted if ‘contact ID’ is present
  4. Contact ID – can be omitted if ’email address’ is present
  5. Cardholder Billing Address
  6. Cardholder Billing City
  7. Cardholder Billing State
  8. Cardholder Billing Zip Code
  9. Cardholder Billing Country

The cardholder’s address will be used to construct the credit card data record unless you explicitly instruct us not to.

The imported credit cards can continue to process recurring payments without requiring your customers to re-enter their credit card details, if you have also imported “open orders.”

Open orders


If you want to import existing subscriptions or payment plans into your account, you can request a custom import for your open orders. Open orders are imported separately from purchase history and credit card details and can be imported to one payment gateway only.

To get started:

  1. Import your contact’s credit card information
  2. Set up your payment gateway so we can assign the order to it.

To create your CSV:

Create your file’s column names using the exact name provided under “CSV Column Name” and include the following fields:

Ontraport Field CSV Column Name Notes
Email email Optional if you include “contact_id”
Contact ID contact_ID (Optional) The contact ID in the app.

If you don’t include this we match on email.

First Name firstname Optional if you include “fullname” or “contact_id”
Last Name lastname Optional if you include “fullname” or “contact_id”
Full Name fullname Optional if you include “firstname” and “lastname” or “contact_id”
Product Name product_name If the product doesn’t yet exist in your account it will be created
Price price Follow the currency formatting guidelines
Quantity quantity
Original Charge Date payment_first_date (Optional) The date the open order was first charged

Follow the formatting guidelines for dates

Next Charge Date payment_next_date This is the next date that we’ll attempt to charge the card for this open order.

Follow the formatting guidelines for dates.

Important: If your next charge date is on or before your import date (PST), the open order will be charged on the next subscription billing run. If you have any questions about this, contact support@ontraport.com.

Billing Status billing_status The payment status of your open order

Choose from:

  1. current
  2. past_due
Type type What kind of open order you’re importing

Choose from:

  1. subscription
  2. payment_plan
Rate rate The billing frequency of the open order you’re importing

Choose from:

  1. day
  2. month
  3. quarter
  4. year
Payments Remaining payments_remaining The number of payments remaining — add “0” for recurring subscription.

 

Project delivery

The last step of the process is to inspect and approve a CSV that we’ll send you — generally by 12:30 P.M. PST — a complete list of open orders that were created, their corresponding contact names, proposed next charge dates and amounts in a CSV.

To complete your import, you must inspect and approve the CSV by 6:30 P.M. before that night’s subscription billing run. If approval is not completed, all of the open orders will be deactivated until further notice.

Purchase history


You can import your contacts’ existing purchase history information into their records.

To create your CSV:
Create your file’s column names using the exact name provided under “CSV Column Name” and include the following fields:

Ontraport Field CSV Column Name Notes
Email email Optional if you include “contact_id”
Contact ID contact_ID (Optional) The contact ID in the app.

If you don’t include this we match on email

First Name firstname Optional if you include “fullname” or “contact_id”
Last Name lastname Optional if you include “fullname” or “contact_id”
Full Name fullname Optional if you include “firstname” and “lastname” or “contact_id”
City city
State state
Zip Code zip_code
Country country
Purchase Date date
Unit Price price
Quantity quantity
Purchase total total
Product Name product_name The name of your product in Ontraport.

If the product name doesn’t exist in your account it will be created for you.

Payment Status status The collection status of the purchase

Choose from:

  1. paid
  2. refunded
  3. void
  4. writeoff
  5. declined
  6. collections

Affiliate/Partner referral data


Ontraport can import your affiliate or partner referral data so you can continue crediting your partners for the referrals they made in another account or system. To get started:

  • Create a Partner Program in Ontraport
  • Make sure that your partners are saved as contacts in your account — you can import this information normally.
  • Provide us with two CSV files:

CSV #1: This file identifies your partners and which program they belong to.
To create your CSV, include the following fields:

Ontraport Field CSV Column Name
Your partner’s email Partner Email
The name of the partner program they belong to Partner Program

 

CSV #2: This file identifies the contacts who have been referred to you, and their first and last referrer.

If you’d like more information about first and last referrers in Ontraport, check out this article.

To create your CSV, include the following fields:

Ontraport Field CSV Column Name
Your referred contact’s contact ID Contact ID
Their first referrer’s contact ID First Referrer
Their last referrer’s contact ID Last Referrer

Notes


In Ontraport, the Notes section can have notes submitted by the contact on a form or by you or your team member from within Ontraport.

To create your CSV, include the following fields:

Ontraport Field CSV Column Name Notes
Your contact’s email address Email
The Ontraport user ID of the author Author ID
The text to add to the note Note
The date the note was created Date Follow the formatting guidelines for dates