search
Partners Support Log In
Martin Cogburn
Updated

Contents

    Back to Top

    Custom Import Services

    About Custom Import Services

    Applies to: ONTRAPORT Plus and above accounts.

    ONTRAPORT provides excellent options for Importing Contacts yourself, but some information cannot be imported or exported through your Administration login. To meet our client's needs, our Concierge Services Team provides custom import and export services, called Custom Import Services. This allows import or export of the items below. Check with us for other import or export requirements. Secure transmission of username, password or SFTP credentials is covered in the PGP Public Key Block section.

    Note: By submitting this request you are agreeing to be billed in 1 hour increments. Our QA team will estimate the time it will take to complete the task, along with an estimated date of completion (plus or minus one business day). If you approve you will then be charged 50% of the total estimate up front. Once the work has been completed, we will collect the remaining balance and notify you that your request has been fulfilled.

    Purchase History Imports

    Here is an example of a Contact's Purchase History in ONTRAPORT:

    You can have ONTRAPORT import your existing purchase history information into the Contact Record. Automation in ONTRAPORT can consider the purchase history for segmenting your Contacts into Groups, or for actions in Campaigns.

    The purchase history must be in a CSV format file. The header on the CSV file needs to have the same naming conventions as the fields in ONTRAPORT:

    • Email
    • First Name
    • Last Name
    • Full Name
    • City
    • State
    • Zip
    • Country
    • Order Date
    • Price
    • Order Total
    • Product Name
    • Payment Status
    • Quantity

    Any fields not provided will be left blank.

    The ONTRAPORT Contact ID number can be substituted for the Email address in the CSV file, if desired.

    The Order Date can be a full linux date and time stamp or a date and generic time such as "01/01/2019 12:00".

    We cannot import data with more than 50,000 individual products.

    Frequently Asked Questions

    Q. Can I import negative amounts into purchase history?

    A. No.

    Q. Do products need to be entered prior to the import of purchase history?

    A. No, we can add products during the import process. Make sure that your product name is uniform throughout the CSV file. Product names are case sensitive, so "Gold Membership" and "GOLD Membership" would be separate products after import.

    Q. Can I import multiple prices for the same product name?

    A. Yes, we can import multiple prices with same product name. Format the import file like this:

    List the purchase history sorted by Product name, with the secondary sort on the price field (in descending order) as shown. In the example, "Silver Membership" is sold at "99", "49" and "29".

    Q. Can the CSV file have billing address info on it and will it be imported?

    A. Yes, you can have a separate billing address in the import file.

     

    Cost: $150 per hour

    The same fees and processes apply to exporting the data.

    Credit Card Information

    Importing credit card information requires PCI compliant processes. Credit cards imported this way can continue to be used for recurring payments without having your customers re-enter their credit card details if you have also imported "open orders" (see below).

    Note: There are strict regulations for transferring credit card data, and it must be from one PCI compliant processor to another. We cannot accept credit card data directly from individuals or businesses that are not PCI compliant processors. If you have credit card information on file, please contact concierge@ontraport so we can determine the best method for importing. Please do not send any credit card data to us.

    Here are the steps you need to take to initiate the transfer of credit card data:

    1. Obtain contact information from the current PCI compliant processor holding the card data. This will be the person they designate to work with ONTRAPORT to transfer the information securely.
    2. Advise them that you have asked ONTRAPORT to transfer the credit card data.
    3. In most cases, they will have a "ticket" or "issue number" assigned for the upcoming transfer.
    4. Contact our Concierge Team at concierge@ontraport.com with the contact information and ticket or issue number.
    5. ONTRAPORT will work directly with your current PCI compliant processor to transfer the credit card data.

    Frequently Asked Questions

    Q. Can I just send you an Excel or CSV file with the credit card data?

    A. No. We will not accept credit card data in any format from any person or company that is not PCI compliant. It will be discarded. Please be aware that sending credit card data in an un-secure manner may be considered a data breach and expose you to legal liability.

    Q. If someone imports credit card data only, what can they do with this info? Is it just manual transactions?

    A. Imported credit cards act just like other credit cards in ONTRAPORT, allowing you to process manual transactions and continue with subscription or payment plan payments.

    Q. Do I have to have billing addresses imported along with the credit card information or can I just import credit card information? If we do import billing address, will it just populate in our Address fields or custom fields they create? Since the Address field is technically the shipping address, by default, how does this affect billing if at all?

    A. We do need the billing address imported with the credit card information. The billing address for each credit card is separate from the contact's regular address fields.

    Q. What if my contacts have multiple credit card numbers they use for my different products? Can you store multiple credit card numbers for a single contact in OP?

    A. We can store multiple credit card numbers. You will need to identify the credit card used for each open order for it to be applied properly. The last four digits of the card and the expiration date are used for matching credit cards to specific orders when importing Open Orders (see below).

    Cost: $150 per hour

    Note: The same fees and processes apply to exporting the data. We can export only to a PCI compliant processor, and cannot supply credit card data to our clients directly. We will provide a contact name, and a ticket number, for the other processor to contact us with the request.

    Open Orders

    A product sold with a payment plan or ongoing subscription generates "Open Orders" in ONTRAPORT that are processed when scheduled. You can have Open Orders imported after importing credit card information, allowing you to move your payment plans or subscription orders to ONTRAPORT. You should also configure your payment gateways prior to import so we can assign the order to a payment gateway.

    Open Orders are imported separately from purchase history and credit card details. The following fields need to be provided in the open order file:

    • Email
    • First and Last Name
    • Product Name
    • Product Id
    • Price and recurring rate
    • Next charge date
    • Payments remaining (if it's a payment plan)
    • Quantity
    • Payment Gateway name ONTRAPORT ID number

    If do any other style of billing besides monthly billing, then we will also need the following information:

    • Recurrence (day, month, week, quarter, year)
    • Unit (quantity)

    Frequenty Asked Questions

    Q. Can I enter a new transaction date for a subscription product in order to edit the recurring payment date?

    A. Sometimes our customers want to enter a new transaction for a subscription product and want to be able to edit the date their payment goes through so they keep the same billing date.

    Example case: Joe has a billing date of 1/18 in your old system and you charge him $50 per month recurring. You want to add that product into ONTRAPORT and not have Joe get charged until January 18th. If that's so, then you would want to create a product with a $0 trial for the first month. And then enter the monthly subscription price as normal. From there you can follow the instructions listed below. You see the 'game' is to get the product attributed to the contact record without charging them first. Once you've manually entered the order, follow the steps below to manually update their next billing date.

    • Find the Open Order section in the Contact Record
    • Click on the Open Order you wish to edit, a Subscriptions and Payment Plans section will appear below
    • Click the pencil icon to edit that order
    • Enter the next billing date as you wish (scroll down)
    • Click Save

    Q. Can I import multiple prices for the same product name?

    A. We can import multiple prices with same Product name. Format the import file like this:


    List the open orders sorted by Product name, with the secondary sort on the price field (in descending order) as shown. In the example, "Silver Membership" is sold at "99", "49" and "29".

    Q. At what time are open orders processed?

    A. All open orders run at on the date listed in the contact record at 1 A.M., Pacific Time. If you live in Australia and want to set your Open Order Date to fire on January 2, you'll want to set your Open Order Date to January 1 since it runs on Pacific Time.

    Q. Can you only import Open Orders when Credit Card information is also imported? Is there any way or reason why we would import Open Orders alone?

    A. You don’t need a credit card import as long as there's a credit card in the Contact Record. Also, you’ll need to let us know what payment gateway should be on the Open Order.

    Q. What does creating Open Orders in ONTRAPORT from Paypal entail?

    A. We cannot re-create open orders and subscriptions for PayPal.

    Cost: $150 per hour

    Note: The same fees and processes apply to exporting the data.

    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.

    The following fields are needed in your CSV file for import:

    • Email
    • Author ID (this should correspond to an ONTRAPORT User ID number)
    • The Note text to be added
    • Date Note was created

    Cost: $150/hr

    Affiliate or Partner Referral Data

    This is the data from an affiliate program from your former system. In ONTRAPORT, the affiliate program is called the Partner Program. You can have more than one Partner Program in ONTRAPORT, but an individual Partner can only belong to one Partner Program.

    Create the Partner Programs you need in ONTRAPORT first. During configuration you will decide if commissions are paid to the "First Referrer" or "Last Referrer". If you pay by "First Referrer" then the first Partner Program link a person clicks determines which Partner gets credit for the sale. This is often used to generate more leads and contacts, as Partners know they can "lock in sales forever" by getting prospects to opt in. If you pay by "Last Referrer" then the most recent Partner Program link determines who gets commission. "Last Referrer" is often used when closing the sale is more important than building the contact list, as Partners will work harder with every contact.

    Importing the affiliate or partner referral data allows you to keep the proper affiliate tied to the Contact Record for future sales and commissions.

    You need to create an Partner Program in ONTRAPORT and make sure the individuals who are your partners are in the Contact Record with all their details (you can import this information using our regular Contact Import). Then you need to provide two CSV files. The first one is to identify the Partner and the program they belong to. The CSV file should include:

    • Email
    • Partner Program

    The second CSV file is used to identify all the contacts that have a first and last referrer already set. This file must have the following fields:

    • Contact ID* (required field)
    • First Referrer (Contact ID)
    • Last Referrer (Contact ID)

    For example, if I want to add Colton as my first referrer and Pin as my last, the file needs the following: My contact ID, Colton's contact ID, Pin's contact ID.

    Cost: $150per hour

    Note: The same fees and processes apply to exporting the data.

    PGP Public Key Block

    Our PGP key is below. You can use this public PGP key to encrypt your communications with ONTRAPORT. We encourage the use of encryption when communicating login and password information to secure accounts, for SFTP use if ONTRAPORT needs to access your server, etc. Numerous resources exist for encrypting and decrypting PGP; a good place to start is the Gnu Privacy Guard (GnuPG) Project and their instructions on how to import a public key.

    When you encrypt a file or email message with our public key, only ONTRAPORT can open it with our private key. Software to help you create and store your own PGP key set:

    -----BEGIN PGP PUBLIC KEY BLOCK-----
    
    mQINBFw9R2oBEADj/dN7x2UmKBf60NVwuOS/67CxElgYXcencFrKav4dAPwrlT2t
    9Gr/fpAILSh9GcLryxgqpJSASMdIsS5TaJqsdJVWrMF3U/Ydq8tjFczgHZXDMahe
    OmGqRIh6viNnvIPiNop3FZvcS/50cNIvHKgAH9VybLoxy2rTufdFkgNudeCl+TYu
    imFYEh7ycI6+H22cw+RD3XR4Tw5lnYZ2X3RjLYWbiBYtSKHTnq4kK8/ldmn/m2+f
    eh2yCC59fzoGnHU75rr7WxgcAhTuuEUnNga0+ls7K5yFZ5D7K1ysBwaayATKi2Pb
    CW6ZnUEiDIuXQn9HusANsbitkpassp/Ky09h5lSWSZtN9MXgVV5hcnlka4XRnehO
    Jg1Zl/Y24RMtFDI9vjtoV3rBShPpkKsIc2KisaiNv+WAdh+/auDZLyxoX8l0TXfz
    m6fMtPk2X2kKMx8qyplMkfiGI57I1UDzYsW1IxA/7AWz3RwerZnw4/To2yjrhfAq
    ekBQHWmfivZnmXx+p6hQw2waRHsp7vOGOxt98xkI2VavVSxYuXx3b8hzH9XtRm3O
    gsot9qM4WxR+Zev/gaWWr9InQkYvWOUxgrOqSHrrABeV6wbw3qNg4qg89MqhBz0k
    FCA9ZXBMODgYJJGQi4SwlUYtqeFi9QHUWwd/S5b1xEXgR3wxkxgfhqkmVQARAQAB
    tCtPbnRyYXBvcnQgKE9udHJhcG9ydCkgPGFkbWluQG9udHJhcG9ydC5jb20+iQI+
    BBMBAgAoBQJcPUdqAhsDBQkB4TOABgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIXgAAK
    CRDJO+Ul5pe8nyklD/96CfrUM9fkcGiaJfpdFHk5yGEE9ZJMM/nTOR8o2Ob8933A
    jf1CMgNjiuP6okarhAUb5zXekPqzKVdT5DhfkErwrOa+H8UcOA8RtZ/iZUuTuLgx
    FkPkt/wdMTBFsF5+3xImau1bNp4Y4q88hQIMkhuiE9qmU+bZVo+8CqxdPfSvzsAO
    Wozmh25rgSjVaMp5Bx+LijcQMopxLxpQjK+O3dlRd5NNU+kUup3A/evzfeSjPfa/
    IU4/7o5VAn49hP+bI9hEUR0EQmYG5O7SK7dMUX4r4L/fmIAqlVNWqFZKjvizwuic
    PrAR2OnqrvzJJ/jvbzRTgUZTSrxir+OQq67p1ItFYBRBa+Nk0B2wojEL375NRg3x
    fP0NdpIJekpnjWAYqGk48uPTEkI++H+4p9TgbkI0ps5vwDB3+SIoE5LM/mvRNsBw
    onduRLe9i2rsNKRZIRpKYZ0GcF3V43haDNkZb6kHrTvt/ANRZb85bIvHdgCcrXTy
    cfgEDuo3R+Td4T12Y767xmuWdSEqRelA4Xf+aBfp5+8xYaFYaCQF/aNLs9VI3QDd
    a9qHA8ZNx802GOeO4RfjQ6+JucjnkxLtAbg1STzCVOXhA+JFLUZWuJNEzRvBpcUw
    0J+mHZu44b5FGxHYlM8XKYtdZiAEkjzAfq8SkUlSIBeTR3vTl1p0fR3JPIaQO7kC
    DQRcPUdqARAAsDAeYdWGGHqHnpCHhWBpYUGL+oGcFYMr/9XBxX/YnFACrf8uWyU3
    GsfY4xxiDeOzVjxbTCN9qYXS8utqv0WyvxdF8++UsUs8CJCopfHMZ656MArv1buP
    BMQkeCnAH8s7dkSVV2D2/kDmUOVtibQ12bm/C0pJMv6BLgMetwliKVBdH7BE+1wR
    GvPiI4HuMZOEe86ShemeEFLkJ4uQyNJwMjoAc4b+6u6Sxgsxy4SQmxwrQ4DqVeNS
    GlsJZt2omAF6M6JqQa0OV7G8SToXNnmDOH86BiP+JAqUQf1gJu1kMBenanIU7LHx
    65KQ6wsIVZvXlW/mjxGLH2c0L9ZbRb/sp8a3WBtBPy2tye8D2ojNu4a2jS+YmFeB
    7DAuGCe0s6+fjk+NoPLTKvp/Bl+wbNnIpGODMX7wxF4O0ZDJpYzDS3zBK3c9zvlK
    aV5hCcoGvVgI1iHZJHHPDokAWUj8NuW5miHAWFxQu4vJubibUt1NBOdM5UNKAeMi
    I4W1Vk0aWubBhhXz0GEkgD2WBGzusJoF69etdIdn6SY/x0mvhfqyEzidTWOt4QX4
    vkt6m83ohgY9LH8ETDHEn/U/5JJvf6lJfmeW+REyRsWHpPnPRJb/uTQp4qNmgiAW
    FAmEDxhCKU0hO4f87ySb9KeJf3I8G/Cm4kdTbJZl/1hmdZxC5KfE1gkAEQEAAYkC
    JQQYAQIADwUCXD1HagIbDAUJAeEzgAAKCRDJO+Ul5pe8nyKQEACuI+bOytndmi0L
    4pv3U0OMIPEiDHP02kHkCp1EFeE59sMBJSLGEtdOIoVXs9xVO45l0Xrv3abYMSFj
    WrWFse3gArjy8O35ZfDZ+H23sNB0TxCYBDqONwvvopa+bE01BYQgVVyOGDgzoX1t
    R2tZABuTO7+A3Ns9uvKBFI4GEk2gNltH6QSjmEbKwuC4NY+++YOO3OJIAuUHKb04
    cspD8G24JFXJyzjtTfXs6BaKaN27iupM/GAtY77pROk/e+VI/xE+nZbaixfAS0C1
    bZt2Mb6KlW8MKaKdFrYBB1MbeIStaHOtUaRaa2ODcbnKAy5eCNFSBZN80lF1IeoL
    0px+h1F0hob+jVBBpXOqHOuje5YCTzATLulU1TSohsk0H9I0lVOTvUn1n315zX5g
    Py7iWzhOSEoZfrzNLnQ8Kf9Yj3sJkf6rYmHnxk3BXX158pwVC/w2tlS8yrKxs6Sm
    dGLx9i8HskNAkxNYx7KCNOzgQ8luSWm8/Wz+g1Wp0hC1GXQrg4vj0p1di9E1hWyI
    t9U8Q7LMEUapyQqjKwHbzV9RGg/wLeKHiRI4SlPyjvgia8eier5PgTYS6MBEQeyj
    ERX0jh1juziZiHWK8/VxHBlyVCA2juWkqDMf5CyR6x7Qwbdrl9ppJ2K27W3OlzNh
    XCh3jshZF7+WQJdzPKBJgzvldQpJfQ==
    =M45g
    -----END PGP PUBLIC KEY BLOCK-----
    

    Articles in this section

    Created - Updated
    Have more questions? Submit a request

    Comments