Company Blog Support
Martin Cogburn
posted

Contents

    Back to Top

    Note: Not all images and content apply to ONTRAPORT 5.
    For backwards compatibility, some articles cover legacy features.
    Please Contact Us if you run into any problems.

    Custom Dev Work

    About Custom Dev Work

    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 Dev Work. This allows import or export of the items below. Check with us for other import / 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

    What is Purchase History?

    The purchases your customers have made over time are recorded in the Contact Record's Purchase History section. Here is an example of a Contact's Purchase History: 




    Why would you want to import Purchase History?

    The main purpose of importing purchase history is record keeping. If you import your purchase history into our system you will have all your data in ONE place and you can use that data to run actions in ONTRAPORT.

     

    So you can see what Contacts have purchased from previous systems used for payment processing. You can create a Group based on the criteria "Purchase Products" - "contains" - "Gold Membership".

     

    You can then run Group Actions for this Group that purchased a particular Product - what would you like to happen to people that purchased a specific Product from your other payment processing system? Subscribe them to a Sequence that contains emails alerting them of a new similar Product you are now selling through ONTRAPORT?

     

    What does the Client need to prepare for Concierge to import their Purchase History?

    The Client needs to present Concierge with a CSV file with the info they would like imported into ONTRAPORT. The header on the CSV file needs to have the same naming conventions as the fields in ONTRAPORT:

    • Email or Contact ID

    • Order Date

    • Product Name

    • Price

    • Quantity

    • Total

    Frequently Asked Questions

    Q. Can I import negative amounts into purchase history?

    A. We CANNOT import negative amounts into purchase history.

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

    A. Products do not need to be entered prior to import of purchase history, but make sure that your product name is uniform throughout the entire file.

    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 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 the Devs import?

    A. The Developers are able to import separate billing addresses. Please make sure your request includes this information! The billing address will go in our "Address" field. We cannot separate "shipping" and "billing" addresses. By default, the "Address" field populates with shipping address information.

    Q. What about adding purchases to a contact already in the system for a given product?

    A. The product must already exist in the account in order to log it. However, we can override the price of the purchase in the case of discounts, sales, etc.

     

    What we need from you to import Purchase History

    Fields:

    • Contact ID*

    • Product ID*

    • Date (if not provided, date will log as 11:59:59pm 12/31/1969)

    • Sale Price (If not specified, will use the default product price)

    There's a decent amount of flexibility with regards to the date. It can be to-the-second specific or it can just be logged at a generic time (like noon).

    # of Products

    We need to know how many products you are importing: if it’s a HUGE amount (50,000+ products), then we will not be able to conduct the import. We DO NOT support shopping cart functionality and importing HUGE amounts of data will crash your account.

    Cost: $150/hr

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

     

    Credit Card Information

    What is importing credit card information?

    This is the action of taking credit card data from one payment processing system and importing it into ONTRAPORT so they can continue billing their clients through our payment processing.

    Why would I want to import credit card information?

    You’ll find it necessary to import credit card information if you want to:

    • Import credit card data if you want to move recurring payments into ONTRAPORT (and have us create Open Orders, see item #3 of approved Dev work)

    • Have a credit card # associated with your Contacts.

    • Have the ability to perform Manual Transactions with your Contacts

    What do you need to prepare for Concierge to import credit card information?

    You need to get the credit card information on an encrypted CD from your payment processor. The disc should be a PGP encrypted zip file with a key that is emailed to us separately and not included in the disc package. Here are the following steps after you have an encrypted CD ready to go:

    • Mail the encrypted CD to our office:

      • ONTRAPORT

      • ATTN: CTO ##### (Account Number or Ticket Number)

      • 2040 Alameda Padre Serra, Ste 220

      • Santa Barbara, CA 93103

    • Once the disc is mailed and received by our Chief Technical Officer (CTO) Pin, he will email you for the password

    • After the credit card information has been transferred, Pin will shred the CD.

    What information needs to be on the encrypted CD?

    Each credit card should have an email, first and last name, full address (street, city, state, zip) and credit card info. If a contact does not exist with a particular email, the Devs with create one when they import the card info.

    Frequently Asked Questions

    Q. Do I need to include the CVV?

    A. We DO NOT require CVV for the credit cards. This means when we move the credit card information over, we will not have the CVV (we can't store it for security purposes). You may want to discuss this move with their payment gateway first and make sure that we'll be able to do this and charge the open orders without a CVV. Usually the CVV check is just a setting in the gateway that you can enable/disable.

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

    A. This depends entirely on the payment gateway and what kind of CVV settings they have. If there is no CVV settings, you will be able to do everything that your specific payment gateway integration will allow them to do.

    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. The Billing address would be imported with the Credit Card info, not in the normal address fields. Unless we already have billing info on file, we will need the billing info with the credit card data.

    Q. If someone chooses to just import credit card data and nothing else (purchase history and open orders) what can they do with this info?

    A. Same as above, this depends entirely on the payment gateway and what kind of CVV settings they have. If there's no CVV settings, they should be able to do everything that their specific payment gateway integration will allow them to do.

    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 only house one credit card number per contact, so if someone uses different credit cards for payments they would have to be entered as a contact multiple times into our system. This means that each person would have to have a different email address associated to each credit card and that is not a best practice. There should be just one contact with one credit card associated to their record.

     

    Cost: $150/hr

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

     

    Open Orders

    What is an Open Order?

    When you sell a Product with a payment plan or an ongoing subscription, ONTRAPORT interprets this as an Open Order. You can only import Open Orders if you are importing credit card information as well. You are basically moving your subscription payments from one payment processing system over to OAP.

    Why would you import Open Orders?

    There really is no purpose of importing open orders WITHOUT importing credit card info. If we import open orders in our system, when their billing date comes around, it will decline because we don't have a credit card to charge.

    What can you do with Open Orders?

    Open orders will create a record for the contact's next billing date. If you import open orders and credit card information then the contact will continue on their billing cycle in our system.

    What we need from you to import Open Orders

    We assume either the contacts already have credit cards or they already gave us credit cards to import. Open Orders should NOT be part of the client's complete list .csv; they should be in a separate file removed from 'non-open orders'. The following fields need to be provided in the open order file:

     

    Fields:

    • Contact id (or email) - something unique so we can attach it to the correct contact

    • First and Last Name

    • Product Name

    • Product Id

    • Price and recurring rate

    • Next charge date

    • Payments remaining (if it's a payment plan)

    • Quantity (we'll assume 1 unless this one's set to something else)

    • Payment Gateway info for the orders and Payment Gateway id

    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/month recurring. You want to add that product into ONTRAPORT and not have Joe get charged until 1/18. 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 (in California).

    Tip: 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 can re-create open orders and subscriptions if PayPal is capable of exporting the following information:

    • Contact's email address

    • The product currently subscribed

    • Next bill date

    • The amount to be billed

    • Their credit card information

     

    Cost: $150/hr

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

     

    Notes

    What are Notes?

    The notes section is a great way of jotting down information on the fly that doesn’t fit in any given field. If you have a form on your website that invites notes or questions from visitors and you use the notes field in that form, this is where it'll show up. Also, the notes you take down from phone calls logged, and from tasks will go here.

     

    Why would you import Notes?

    You would want to import your notes from another system if you want to know a contact’s correspondence history or any notes about that contact from a previous system.

     

    What can you do with Notes?

    You can refer to the notes section in your contact's record and see what type of correspondence occurred in your previous system (but now lives in ONTRAPORT).

     

    What we need from you to import Notes into contact records?

    A CSV file with the following fields:

    • Contact's email address
    • Contact's First Name and Last Name (optional)
    • Contact ID number (optional - from ONTRAPORT)
    • Author ID (this should correspond to an ONTRAPORT User ID number)
    • The Note text to be added

     

    Cost: $150/hr

     

    Affiliate/Partner Referral Data

    What is Affiliate/Partner Referral Data?

    This is the data from an Affiliate Program built in another system. In ONTRAPORT, the affiliate program is called the Partner Program.

     

    First Referrer vs. Last Referrer

    First Referrer

    This means that when a sale gets made, the very first person whose affiliate link got clicked will get the commission, no matter how many other people's affiliate links get clicked in the interim.

     

    Last Referrer

    This means that the affiliate link that gets clicked last, or, most recently leading up to a sale is the one that will get paid, no matter who was the first one to refer the sale.

     

    Why would you import Affiliate Referral Data?

    Because you would like to run an Affiliate Program in our system as opposed to your previous system. Importing Affiliate Referral data allows the Client to attribute contacts with who referred them for the purpose of commission.

     

    What can you do with Affiliate Referral Data?

    Keep the Affiliate Referrals with their appropriate Contacts that were logged in your previous system.

     

    What we need from you to import Affiliate Referral Data?

    You need to create an Partner Program in ONTRAPORT. Then you need to provide two CSV files comprised of the following:

    • All the Affiliates - email and Affiliate Program they're currently on

    • Provide all the Referrals. Referral's email, Affiliate's email.

    What does Setting Referrers mean?

    When performing the import of Affiliate Referral data, we are adding a First and/or Last Referrer to the contact to handle commissions. In order for this to function properly, the contact listed as referrer MUST be already added to an Affiliate Program.

    Fields

    • Contact ID* (required field)

    • First Referrer (Contact ID)

    • Last Referrer (Contact ID)

    This will be anywhere from 1 to 3 fields. The first is the Contact ID of the person we're applying the referrer to. The other two refer to the contact IDs of the affiliates.

    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: $150/hr

    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) Projectlink and their instructions on how to import a public keylink.

     

    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 v1
    
    mQENBFX3N6MBCAC7LMjtaMW1klxoK6Hws7OgyL2nSptIbze8cmiCCXyjwHJqHv3C
    wNJIumRj5t5FRweSZSLTtaSBR4paRWhBScw6eStnZLvA+bw+0Hc03ODKxPd3cnJl
    kJQeysLplXsEzLC/8eyFt5ZKkaNdtTvfrf9m1qdeJen9X29N4uNL9p4lwLut22sL
    tFFNH70Em7nhWs5GWUp9ESCmtjl+SGQ4Y6tN5cOPUKCuZ17kcU2i3/I3JO4WPp2v
    5LAnd0wOdng7E4Mi+E7tWb6pmJM1WO2bE+8vU/224xO5AyWqEi+79QEB0oG6737U
    dBxH6SCdKe5Yer8cKN72B5/EuABCnO4qMAx3ABEBAAG0N0FudGhvbnkgQmFsZHdp
    biAoT05UUkFQT1JUIFFBKSA8YWJhbGR3aW5Ab250cmFwb3J0LmNvbT6JATgEEwEC
    ACIFAlX3N6MCGwMGCwkIBwMCBhUIAgkKCwQWAgMBAh4BAheAAAoJECHms+kEH4GO
    wFwH/1Ol9f/cQqN2KGjI7If/Gjl/LJ8wiHA3wbwdW3UMbhUkN84kW8PVTe8OTiZ4
    wMyqZ8q1lKQDu8xn88XgY6scvcvjN9oLaEa5GPj4GfF3YCL5dARyZxexCpcQ7eGp
    PhT5wHd3Lz1Nt1rlNeZwE5ks/SHniM+wUfgyXiZA7M5WQyqHxje/SI1L7fHgypwB
    taEujNvbJqLooJDRi0dEn+PWgpf5n5Zr6cvD69+euoRaaTvgLebpGVjcg9zFszON
    NpHzSlbsxQm7YNFm/iYpdb1/hoXykCpQg5HCk6ZUp+JruOGOgrF56o2TEY+8HuSY
    1xzmGYo4+TMUMAVK7ILaYBTixtW5AQ0EVfc3owEIALvBT1MtJu6lQjsfWIbD60i4
    Xjqoh8nH0ZMSk6EHIngjpIPRxIkjOmdmQLE5+WvBUODnBVAVFJSj/gXRFOjiS956
    wDXcC9bKSlLAmr8p17jzhDOkLEFo5TfZxAdB1YWBIu2etP1JmkauK1G7E5akwnOR
    JwiJ8BgUkaw4GoaO3e68h1mtUKJMH62Ire0lfg5YfQVXVwYUwva6HTTjd346Ph3S
    pbJ8GRgqZvMCmhccsPdOkzLZBIXrMV0z1hM5h6XswAIQD5I37U/wGAr2hj7IhryY
    8Q9bQ0K1rPcjLTyCHAQwN6wK08u9CIZ4imkpidrtTSOcNcX+KTrCWw6IsXVrC0MA
    EQEAAYkBHwQYAQIACQUCVfc3owIbDAAKCRAh5rPpBB+Bjvi0CACXfdl5Ckmx+KTk
    QvybkB/Kq7mbZcrWDjznuBmqrzkBdoYciH1VbkSThtMSq+PyGSPEo+Dhpc/It9hf
    +rxYMRDAQ1OIXv4hvtHmJpdsM9VfZzFWVcL5WLhaIcpSzYHQL0ZmLU9HEr7D2RWh
    Rhfmu1K+QCOF44Bz6kY2AxmcF+jAhIQFAGuexryuDePlQUErTyvdW5r2rJO+RXnD
    tnePkhNrV4HEAEl9WF+Ti6CaaaO33GpN5BymoSYvSvB9vtmbrBEc4gs9Yula1Wz0
    0bpiPrAciF0Ryv2dUvQxN/zTFYAoFzbaR0qR4UgWHg+dM6mNUY0aZnI+AyoCF4jg
    TzwJOW62
    =XHZu
    -----END PGP PUBLIC KEY BLOCK-----
    

     

    Articles in this section

    Have more questions? Submit a request

    Comments

    Powered by Zendesk