/
Classic - Bulk Upload for Partners

Classic - Bulk Upload for Partners

Bulk Upload for Partners Overview

The Bulk Upload feature may be used to add Partners to Insellerate. Users must contact Insellerate Support to enable the permissions for this feature. Users can upload a CSV file containing all of the information on their Partner and the agent with whom they work.


Bulk Partner Upload Template

  1. Download and open the Bulk Partner Upload Template.

  2. Row 2 shows the sample date.

  3. Delete Row 2 when you are done reviewing the template.

  4. Add all of the Partner information.

  5. Save the Bulk Partner Upload Template.

  6. Upload the file.

How to Bulk Upload Partners

  1. Navigate to inFlow.

  2. Select Partners to open the Partner Registration screen.

     

  3. Click Bulk Upload.

     

  4. The Partner Bulk Upload screen opens.

     

  5. Select the Default Campaign to associate the uploaded Partners. (Review the Creating Campaigns for Partner Association article for more information on how to set up campaigns for Partners.)

     

  6. Select the Insellerate System Branch Association for the uploaded Partner Leads. The Branches Association will determine the visibility to the Partners.

     

  7. Select the Partner Type for the uploaded Partners.

     

  8. The Initial Status field is a view-only field that displays the initial status of the uploaded Partner. This is set when Creating Campaigns for Partner Association. This will be the starting status in the inFlow Pipeline Panel for an uploaded Partner.

     

  9. The Initial Activity field is a view-only field that displays the initial activity of the uploaded Partner. This is set when Creating Campaigns for Partner Association. This will be the starting activity in the inFlow Application Panel for an uploaded Partner.

     

  10. Add the CSV template to the Data Upload section. There are two options to upload the Partner Upload Template.

    • Drag and drop the file in the Data Upload section.

    • Click in the Data Upload section to access File Explorer to select the file for upload.

       

  11. Click the Bulk Upload button to add and upload your Partners.


How to Create a Partner Bulk Upload CSV File

  1. Download the Partner Bulk Upload CSV template.

  2. Complete all of the applicable fields in the template.

Field Explanations in Order of the Report Columns

  • External ContactTypeID is the Partner type.

    • If blank, it will default to Referral Partner.

The values in this column must be entered as a number.

Partner Type

ExternalContactTypeId

Partner Type

ExternalContactTypeId

Real Estate Agent

1

Title Agent

2

Escrow Agent

3

Attorney

4

Financial Planner

5

Insurance Agent

6

Personal

7

Existing Client

8

Builder

9

Mortgage Banker

10

Other

11

  • LiscenseId

    • This field can be used to add a license number associated with your Partner.

  • FirstName (Required Field)

    • Enter the Partner’s first name.

  • LastName (Required Field)

    • Enter the Partner’s last name.

  • Email (Required Field)

    • Enter the Partner’s email.

Warning: If you do not enter a Parter email in any row, the entire upload will fail.

  • MobilePhone

    • Enter the Partner’s mobile phone number.

  • WorkPhone

    • Enter the Partner’s work phone number.

  • Ext

    • Enter a work extension number, if applicable.

  • Website

    • Enter the website for the Partner.

  • City

    • Enter the city for the Partner.

  • State

    • Enter the state for the Partner.

  • ExternalIdentifier

  • Branch Association

    • Determines the branches that can see this Partner.

    • If blank, it will default to All.

Branch Association

BranchAssociation

Branch Association

BranchAssociation

All

1

{{Org-specific branch}}

Please ask your Insellerate representative.

  • Campaign ID

    • Enter the campaign that the Partner should be associated with.

    • If it is not entered or the system does not find an exact match, it will default to the Default Campaign selected on the Partner Bulk Upload screen.

  • AssignToUserID

    • Leave this field blank if using AssignToUserID.

    • This is the assignee associated with the Partner.

    • If it is not entered or the system does not find an exact match, it will default to the Default Assignee selected on the Partner Bulk Upload screen.

  • AssignToEmail

    • Leave this field blank if using AssignTo.

    • This is the assignee email address associated with the Partner.

    • If it is not entered or the system does not find an exact match, it will default to the Default Assignee email from the selection on the Partner Bulk Upload screen.

  • Address1

    • Enter the address for the Partner.

  • PostalCode

    • Enter the postal code for the Partner.

  • UserTitle

    • Enter the professional title for your Partner, if applicable.

  • ApprovalStatusID

    • Can be used to define the Partner’s status.

Approval Status

ApprovalStatusId

Approval Status

ApprovalStatusId

Application Pending

1

Application Denied

2

Active

3

Inactive

4

Suspended

5

Cancelled

6

Terminated

7

  • EntityID

    • This field can be used to store any value your organization wants to associate with a Partner.

    • Contact Insellerate Support to add the field to inFlow in the Partner Application Panel.

  • Notes

    • Add any applicable notes for a Partner.

  • AvatarUrl

    • Add a URL linking to a picture of a Partner.

  • Branch_Name

    • Add a branch name for your Partner.

  • Branch_Phone

    • Enter a branch phone number for your Partner.

  • Branch_Website

    • Enter a website for the branch of your Partner.

  • Branch_City

    • Enter a city for the branch of your Partner.

  • Branch_State

    • Enter a state for the branch of your Partner.

  • Branch_BranchAssociation

    • Determines the branches that can see this Partner.

    • If blank, it will default to All

Branch Association

BranchAssociation

Branch Association

BranchAssociation

All

1

{{Org-specific branch}}

Please ask your Insellerate representative.

  • Branch_Company_Name

    • Add a company name for your Partner.

  • Branch_Company_Website

    • Enter a website for your Partner’s company.

  • Branch_Company_ExternalContactCompanyId

    • Enter a company ID for your Partner.

    • This is the unique ID (assigned by Insellerate) of a company.

  • Branch_Company_OrgID

    • Enter a company organization ID.

  • Branch_Company_UserId

    • Enter the user ID for your Partner at their company.

  • Branch_Company_TpoId

    • Enter the company TPO ID.

  • Branch_Company_CompanyCode

    • Enter the company code for your Partner’s company.

  • Branch_Company_OwnerName

    • Enter the owner name for your Partner’s company.

  • Branch_Company_Phone

    • Enter the phone number for your Partner’s company.

  • Branch_Company_Fax

    • Enter the fax number for your Partner’s company.

  • Branch_Company_Email

    • Enter the email for your Partner’s company.

  • Branch_Company_WebsiteUrl

    • Enter the company website URL.

  • Branch_Company_NmlsId

    • Enter the company NMLS.

  • Branch_Company_SalesRepresentativeUserId

    • Enter the branch company sales representative user ID for your Partner’s company.

  • Branch_Company_City

    • Enter the branch company city for your Partner’s company.

  • Branch_Company_StateId

    • Enter the state ID for your Partner’s state.

  • Branch_Company_Address1

    • Enter the address for your Partner’s company.

  • Branch_Company_PostalCode

    • Enter the postal code for your Partner’s company.

  • Branch_Company_BranchAssociation

    • Determines the branches that can see this Partner.

    • If blank, it will default to All.

Branch Association

BranchAssociation

Branch Association

BranchAssociation

All

1

{{Org-specific branch}}

Please ask your Insellerate representative.

  • Branch_Company_ExternalContactCompanyLoanProductTypes

    • Enter the Types of Products offered by your Partners

Company Loan Product Type(s)

ExternalContactCompanyLoanProductTypes

Company Loan Product Type(s)

ExternalContactCompanyLoanProductTypes

Conventional

1

FHA

2

VA

3

USDA

4

HELOC

5

Other

6

FirstLien

7

SecondLien

8

  • Branch_Company_ExternalContactCompanyLoanPurposeTypes

    • Enter the Loan Purpose types offered by your Partners.

Company Loan Purpose Type(s)

ExternalContactCompanyLoanPurposeTypes

Company Loan Purpose Type(s)

ExternalContactCompanyLoanPurposeTypes

Purchase

1

No cash out refinance

2

Cash out refinance

3

Construction

4

Construction Perm

5

Other

6

  • Branch_Company_ExternalContactCompanyChannelTypes

    • Enter the Channel Type for your Partner.

Channel Type(s)

ExternalContactCompanyChannelTypes

Channel Type(s)

ExternalContactCompanyChannelTypes

Broker

1

Correspondent

2

Delegated

3

Non-Delegated

4

  • Branch_Company_ApprovalStatusId

    • Define the company Partner’s status.

Approval Status

ApprovalStatusId

Approval Status

ApprovalStatusId

Application Pending

1

Application Denied

2

Active

3

Inactive

4

Suspended

5

Cancelled

6

Terminated

7

  • Other Fields: Other1, Other2, Other3, Other4, Other5, Other6

    • Other fields are optional custom fields that can be used by your organization to store additional applicable data about your Partners.

  • Email1

    • This field can be used by your organization to add emails for team members who work with your Partner on their leads.

  • Email2

    • This field can be used by your organization to add emails for team members who work with your Partner on their leads.

 

Related content