Company Blog Support
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
    • Order Date
    • Product Name
    • Price
    • Quantity
    • Total

    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

    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-----
    Version: GnuPG v2.0.22 (GNU/Linux)
    
    mQINBFn7oTgBEAC2+Mz9KRNcj93hEtU8rxLQGv85QNSMhTPo1UL15Tqvo7S2rpDB
    HxPmLiS8N6ySrqgVeKjXtsCg2C8ArT+mxkaq7L6SgTciPV/FpmH6UGRzviAoDfG3
    hywFMiuTa6m0kU3MH3y46ltbuU4RZoGXVHaYFMRfOyOdIXQjkdjslcK6tP36R/nd
    hy7SlD8epOWfV+Dd6AEQrbta+ipoFF14jhsLZltonPRFW7WnkfBFlAyv+667OeI+
    FwfNi98M54Kbl8d0oRwafqEkQBC1blS+h59t/fVyZmlb3rz6v+YgLX6ANzaJaUrY
    rBnG4KPbymoiXPBIfH44eoHFY4aum1VWy18I8IL5BOlsqvQzbMWusQk5/wYxiAqZ
    GZRTjBPDv6vh51F/sDl3q1EHPeGDFEkOSGFdSsEvKSSNqzG6qL4PWKY4bEQNc5DB
    E6yo1UD9G9CLkpjziH9ZnhPu8I5Ci880emZ2eGNLkR5iCOD5ONU4BL77Vr7WZvBm
    +cTXP3+asOVdtpSVc5ddTitdIo6GNPXk8WaApuswWAkdJfztxpb8JB0xoPA+AY0W
    ls/GqhxbLXIWdvYT+2xSSO4BdvU3rDBrWikNUd87amgXZuqvT3uLfy+zsDKpGGjI
    op/mD3kW60t9nv8hNNBS5WrmX3a5tzBNNpQVKgSyiyuDDmzPlHjnQDGrSQARAQAB
    tB9PbnRyYXBvcnQgPGFkbWluQG9udHJhcG9ydC5jb20+iQI/BBMBAgApBQJZ+6E4
    AhsDBQkB2pwABwsJCAcDAgEGFQgCCQoLBBYCAwECHgECF4AACgkQhbQhguCcaqeN
    LhAApkCkCIK40d7SxdcIUwNAoa/mSlgxPCcgnOJHA05AA3xy0lxm22BbvoK9fLRU
    LsNjUHz1N8fW3SVbZ/+GkKhc2C/L1q/ANAnrVxN7nRPJHy7HWQQjdoKEhCidPzo8
    AskBOv9RzjYCV81SEHRE/COrvAgYI2rgZ02gNz8Nm5SklO27lMHIPukVmQLcQBXk
    kdoY2ukBWeKDcLloCr+TqhqWTit/ql+R5iLeFpXuPPlGlrPGynw4lZCd7XLJQz73
    QbFwvsXwuXkHAFPmTjI8WA3ws74uJah+LWPU2JDKjderK4NN8kU2b6KeyGNsniF/
    L3oNW3JFMF+QUYG5TLP0011r4GIrwxbTExdlg91jnt5J8EZoWYn7+UBiFXHFBZ5M
    Ex5wAyiDVeiFftMdWGO2zwu0Jo762TBXKBbpVpFQN2wYTCEeoV9XgD4wH/joU8+8
    73Caf/AU5utDqvmRwutiHG6F3tlzNzPO9UVIOs9svGiXJnRL5Y1g2fGtFQQ0RFw5
    UZdQpoaomfg6y7TkeX1jBL7riVHpEQPQ20GMkoGwmJGVyQ425GUrY5pKa9tO2o8K
    ic3OVHes/Q8mHJ4/a7CBC5Ou8D4WE14j1VK3/OmfFnV/gwA9xdqNv4YLvJRl0O/L
    DI0E1g0hAAZbR2y32blCZETXriQgcMHMcU9kMgLR155R9Qa5Ag0EWfuhOAEQAN6N
    sE4emjCb+mg5uDImPMiEy03NB3LG8hPHSUEGTHYTmY5eTvPWFT9lTf7Tzsq03Xs2
    Wd3EBW8dFE7kIDA6wlTfeRNci37m0m5cGWOUZ+SJIWeiNbPEHUmJRHsYukosccce
    yd9UsNRlHwcIyQXstJS9LVY5T6ckRhwh9VNHT3jqLC3z9qt4n0r8woRHAgo8l5M9
    f4gHaczDAjQICkg5TWjcQFX7vMCQMyaew9Ub5BIcaIIs1HSp++gjqlVl5OkwdqB7
    y4nyLgUN7bO2o+50uu74LSnCT4B2oRb4mb+27TeCZ/75jdpbeOde4Yx523ctBSw1
    r6NzZdE+K5CDEVN894x3VUKPPD0hkxYtM9+kSjc0Nb0y/xKfNuJjQiviePPIr8vB
    3w6P4dzqaT0CyhX03NSbviEaL1MS/ZXMRu1qQXMgigg7KjF1R3pyFpS+hiOqYWau
    QNjDSIQK+FlQa7CWIzlcQ3lI8gWIzuIsbvDOEj6sLRmSii0ra7dOvCXokkL9ibfS
    O5+GpwBdWm8rp7bV1cWTcAbbKaiVMJnVBEbctbvyil1ykYQ/Lx9J9CBnTdEMANX+
    fDnGOEAlisB9qBtioRXHRyfr/4n1FTsqW1GTtE6KOmjF69PF9IEEuuA6JWwuhH2e
    CerGcmzwfkhcaeMOvSSuyD7VpgpanhZeDI1X6vctABEBAAGJAiUEGAECAA8FAln7
    oTgCGwwFCQHanAAACgkQhbQhguCcaqe3aQ/9HP6ZI4uvAxZTY6Z0x0Ql9ib95MpL
    LnftofCzH5iT7tfxiaym54o9qNb0nZktqIkJAAfLrskSMsoo6ywrOgIAu9YIVYGr
    OzhNPDE0RUE03DxtRZWn+Wr5q+Zqo6jSckOoiSBICad3Ob2aqcPOHCDUwrLZ2buh
    FJ3sJimc8Hf2VU/6Phvi1z0RUouyNBPJJFZKLsmBw/VOHLY3WOryb1hkAB6Amh2w
    aooy4PFXuaAvsydqxZIeCwNIQXzmIdy3ZChvvYnsYXy+2tn4krl1ANyZ/ASGRlMh
    wFGkr4kG4Lohg3hJgvtoEXf6GaRwnwMw6IyxOMdqtwRl6yeCLy1iKVgDbYCUTbuu
    9BrL2xFXro/0SyTeXlmTMnqmq7bR1MrQp0tjOxm0panQNRiBHajmj7xm4WBgJyP4
    Ln5jwPGt9qsXwhp5KFrlw5bogL64fOq9lacOh4KW+ZhYP8qxfAKo4dkyW+KkTe+g
    r0ZcSzSHuw35iglI+6XfCxRuW9V+ZtkVazHEiwv1zaWwqPfQ40u0FBrXJQQSDuyQ
    LeTcg8UkFaLxRVdSFbF1HVlgy55vfcNmdjaIBqX7VAbHYm8DyXAMKlviAQwh+ZQ/
    tQ9TC56U3f4NAoZLqXscn3Lh79JRMfe9OL9yvyWw1W4pJKwAZNMW32o+5OGZG5Gx
    z0WZd816TMY6Weg=
    =4iEh
    -----END PGP PUBLIC KEY BLOCK-----
    

    Articles in this section

    Created - Updated
    Have more questions? Submit a request

    Comments

    Powered by Zendesk