SugarCRM SupportProduct GuidesSugar MarketSugar Market CRM Integration GuideNetsuite CRM
Sugar Market was formerly known as Salesfusion.

Netsuite CRM

Overview

This page covers integrating Sugar Market with Netsuite CRM, including configuring, syncing, and using data mappings.

Important: Review Integration Overview: All CRM Types before proceeding with this topic.

Supported Versions

Refer to the Sugar Market Supported Platforms page for the current list of Netsuite CRM versions that Sugar Market supports.

Installing the Sugar Market Bundle in Netsuite CRM

Step 1: Log in to Netsuite Account

Note: To gain access to install the bundle, we must grant your Netsuite Account permission to do so. Please reach out to your Sugar Market Marketing Automation Consultant with your Netsuite Account number to start this process.

Step 2: Install Bundle

If you are an account administrator or you have the SuiteBundler permission, you can complete the following steps to install our Sugar Market bundle in your account.

  1. Go to Customization > SuiteBundler > Search & Install Bundles, then search for "Sugar Market". Ensure that the version is at least 2.0 and Managed is Yes as this is where TBA is enabled.
  2. Review the Preview Bundle Install Page.
  3. Click the Install Bundle button to begin the installation process. After successful installation of the bundle you will see the new bundle installed with Status as check marked.

Configuring the Buyer's Journey Integration

The Buyer's Journey integration allows you to view the entire lifecycle of a prospect's marketing activity. With the Journey, your sales representatives will have access to our invaluable marketing journey, which is located in your contact and lead records directly in your CRM. This section explains how to set up the Buyer's Journey Integration in Netsuite CRM.

Step 1: New Configuration

  1. Go to Sugar Market > Sugar Market Configuration Overview > Sugar Market Configuration.
  2. Click on New.

Step 2: Enter Organization ID

While creating the new Configuration, record you will need to provide the Buyer's Journey URL as mentioned below as well as your Salesfusion OrganizationID:

  • Buyer's Journey URL: Enter the URL as follows: https://iframe.salesfusion.com/?
  • OrganizationID: This is the unique key you will generate from the Sugar Market app.
    1. Log into the Sugar Market App > User Menu > Account Configuration > Netsuite.
    2. Generate the Unique Organization Key (if you have not previously).
    3. Save Profile.
    4. Copy and paste the Unique Organization Key that was generated into this OrganizationID in Netsuite.

If you have multiple Sugar Market accounts/instances, and are syncing each of those to a unique Subsidiary in Netsuite, be sure to check the "Enable Multiple Subsidiary" checkbox, and define the Organization ID and Subsidiary for each.

Token-Based Authentication (TBA)

The following must be completed after the syncing user has been created. The next few steps are required to set up TBA within NetSuite. (Do note it will require Account Administrator level access).

Enable the Token-based Authentication Feature

  1. Go to Setup > Company > Setup Tasks > Enable Features.
  2. Click the SuiteCloud subtab.
  3. Scroll down to the SuiteScript section, and check the following boxes:
    • Client SuiteScript.
    • Server SuiteScript. Click I Agree on the SuiteCloud Terms of Service page.
  4. Scroll down to the Manage Authentication section, and check the Token-based Authentication box. Click I Agree on the SuiteCloud Terms of Service page.
  5. Click Save.

Create New Role for Token-Based Authentication

An account administrator can modify existing roles to add token-based authentication permissions, then assign users to those roles as needed. To create a new role that does not start with a list of associated permissions, go to Setup > Users/Roles > Manage Roles > New.

Steps to Complete

  1. Select Centre Type as "Classic Centre", and "Web Services Only Role".
  2. Click on the Permissions tab as seen in the screenshot, and add the permissions in the table below.

Tab Name

Entity

Level of

Access

Transactions

Opportunity

Edit

 

 

 

Lists

Employees

Edit

 

Employee Record

Edit

 

Customers

Edit

 

Contacts

Edit

 

CRM Groups

Edit

 

Tasks

Edit

 

Events

Edit

 

Perform Search

Full

 

 

 

Setup

Custom Entity Fields

Edit

 

Custom Body Fields

Edit

 

Customer Status

Full

 

Add Login in using Access Token

Full

 

Deleted Records

Full

 

Web Services

Full

Custom Records

Include all custom records created for Entities (Customer, Contact Opportunity) See here for more details

Edit

Assign Users to Token-based Authentication Roles

After modifying roles with the appropriate token-based authentication permissions, an account administrator can assign users to those roles. The following is a brief procedure for assigning a role to an existing employee. Our syncing user must be assigned to this newly created token role. To do so, follow these steps:

  1. Go to Lists > Employees > Employees.
  2. Click Edit next to the name of the employee you want to assign the token-based authentication role.
  3. Click the Access subtab.
  4. In the Role field, select the token-based authentication role for this employee.
  5. Click Add.
  6. Click Save.

Create Applications for Token-based Authentication

Account administrators must create applications for use with token-based authentication before tokens can be created and assigned to users. Administrators use the Integration record to create applications for use with token-based authentication. To do so, follow these steps:

  1. Go to Setup > Integration > Manage Integrations > New.
  2. Enter a Name for your application.
  3. Enter a Description, if desired.
  4. The application State is Enabled by default. (The other option available for selection is Blocked.)
  5. Enter a Note, if desired.
  6. Check the Token-based Authentication box on the Authentication subtab. Clear the User Credentials check box if you want Sugar Market to only be able to authenticate using tokens.
  7. Click Save.
  8. After clicking Save, you are presented with the Consumer Key and Consumer secret. Please make note or save these as they will be necessary to set up sync between Sugar Market and Netsuite. For security reasons, the only time the Consumer Key and Consumer Secret values are displayed is on the confirmation page. After you leave this page, these values cannot be retrieved from the system. If you lose or forget these credentials, you will need to reset them to obtain new values.
    Example Consumer Key and Consumer Secret:
    Installing Salesfusion - Netsuite - Key and Secret

Manage Token-based Authentication Tokens

Users assigned a role that has the Access Token Management permission can create, assig/n, and manage a token for any user in the company. For example, they could assign a token to those users who are assigned a role with only the Log in using Access To-kens permission. To create and assign a TBA token:

  1. Log in as a user with the Access Token Management permission.
  2. Go to Setup > Users/Roles > Access Tokens > New.
  3. On the Access Tokens page, click New Access Token.
  4. On the Access Token page:
    1. Select the Application Name.
    2. Select the User. (User with Token-based Authentication created on page 7)
    3. Select the Role.(TBA Role created on Page 6)
    4. The Token Name is already populated by default with a concatenation of Application Name, User, and Role. Enter your own name for this token, if desired.
  5. Click Save. After clicking Save, you will be presented with the Token ID and Token Secret. Please make note or save these as they will be necessary to set up sync between Sugar Market and Netsuite. For security reasons, the only time the Token ID and Token Secret values are displayed is on the confirmation page. After you leave this page, these values cannot be retrieved from the system. If you lose or forget these credentials, you will need to reset them to obtain new values.
  1. Create Saved search: Click on List > Search > Saved Searches > New
  2. Select entity for the saved search:
    1. For account and Lead entities, select 'Customer'.
    2. For Contact entity, select 'Contact'.
    3. For Opportunity entity, select 'Opportunity'
  3. Fill the required information as follows:
    1. Add Search title
    2. Make it Public
    3. Specify select criteria as per the entity:
      Account:
      Installing Salesfusion - Netsuite - Account
      Contact:
      Installing Salesfusion - Netsuite - Contact
      Note: For the Contacts of type Employee, we will be saving ownerId = 1 (default owner) in Sugar Market database, as employees does not have owner. For the contacts of type Vendor/Partner/Other Name, we will be saving account Id as 1 (default account) in Sugar Market database, as we are not syncing Vendor, Partner and Other Name entities].
      Lead:
      Installing Salesfusion - Netsuite - Lead
      Opportunity:
      Installing Salesfusion - Netsuite - Opportunity
      Note: Keep the criteria as empty.
      Note: You can add more filters as per your requirement for all of the four entities mentioned above.
    4. Click on result tab.
      1. Remove all the columns which get added by default from "columns" tab.
      2. Only add the Internal id and last modified fields.
      3. Also, remove all columns from the "drill down fields" tab.
      4. Check "Run unrestricted".
      5. Add Sort by "Last Modified".

Note: Only for contact entity, along with the internal id and last modified fields, add Owner field in the result column.

Accessing the Netsuite Connector

Your Sugar Market CRM Connector will provide access to set up and modify your password access, synchronization preferences and a timetable of the last completed sync with your CRM. To access the Netsuite Connector, you will log in to your Sugar Market account. From the user menu in the upper right-hand corner of the screen, choose Account Configuration.

Navigate to the External Connectors section and select "Netsuite CRM". The Netsuite CRM Configuration page displays.

Configuring the Netsuite Connector

Step 1: Syncing Credentials

The first thing you will do is enter the username and password that Sugar Market will use to access your Netsuite CRM. Remember if you change this password in Netsuite, you will need to update in this location as well. Otherwise, the sync will not be able to authenticate.

Fields:

  • Username: The Netsuite CRM username we should authenticate via your web services.
  • Password: The Netsuite CRM username's password.
  • Account Number: The NetSuite account number for the instance
  • Token based Authentication Details: These are generated by setting up Token-Based Authentication within your Netsuite CRM. For instructions on how to set this up, please see the Installing the Sugar Market Bundle in Netsuite CRM section of this page.

After entering the credentials as mentioned above, click Save Connection to the right.

Step 2: Syncing Dates

No Action Needed - this table will show you the last time Sugar Market has synced with your CRM. These will be updated once we have completed the initial integration.

Step 3: Entering Netsuite Details

Complete the Netsuite connection information. This will instruct our system how to connect to your CRM. Below is an explanation of each item:

Unique Organization ID

This is a GUID unique to the customer in Sugar Market for use as an authentication via the Journey IFrame.

Is OneWorld Account

Whether or not the NetSuite instance is of a OneWorld account.

Subsidiary Id

If the NetSuite instance of a OneWorld account, specify the Subsidiary Id for the instance we are integrating with.

Default User for New Leads

The user assigned as the default (catchall) owner of a new lead when it is pushed up to Netsuite and the user does not already exist in Netsuite (the user only exists in Sugar Market). When the user does not already exist in Netsuite, Sugar Market assigns the defined user in this setting as the lead record owner. The user name only populates this list after the initial sync is complete.

Step 4: Syncing Preferences

Set up your syncing preferences. This includes what information you want Sugar Market to sync down and what information you'd like Sugar Market to update and create, among other preferences. See the full explanation of each item below.

Pull Data

Pull Accounts

Whether or not Sugar Market should sync down Accounts from Netsuite CRM

Pull Contacts

Whether or not Sugar Market should sync down Contacts from Netsuite CRM

Pull Opportunities

Whether or not Sugar Market should sync down Leads from Netsuite CRM

Include Contacts and Leads without an email address (EmailAddress1 field)

Whether or not Sugar Market should include Contacts and Leads from Netsuite CRM that do not have email addresses assigned to them

Pull Marketing Lists to Distribution Lists

Whether or not Sugar Market should sync down Marketing Lists from Netsuite CRM

Keep Picklist values in sync

Whether or not Sugar Market should sync down PickList val-ues from Netsuite CRM

Push Data

Allow Updates for Lead and Contact Records

Allows Sugar Market to push updated values to Lead and Contact records in Netsuite CRM

Allow creation of New Leads and/or Contacts

Allows Sugar Market to create new Lead and/or Contact records in Netsuite CRM. The Sugar Market default is to create new records as Leads, unless the collected record has a specified CRMType as "Contact".

Allow Updating of mapped Score Field

Allows Sugar Market to push Scoring values to Netsuite CRM as mapped by Scoring Profiles

Allow Updating of

Unsubscribe Status

Allows Sugar Market to update the Unsubscribe status of Lead and Contact records in Netsuite CRM

Allow the creation of new Opportunities

Allows Sugar Market to create activity records in Netsuite from Opportunities created in Sugar Market.

Allow Sugar Market to create Tasks

Allows Sugar Market to create activity records in Netsuite from Tasks created in Sugar Market.

Allow Sugar Market to update the Delivery Status and Delivery Message

Direct Sugar Market to push the Delivery Status Message to a specific Lead/Contact field in Netsuite. This field should be a string field created in Netsuite.

Allow Sugar Market to push landing page completion data

Allows Sugar Market to push landing page completed to Lead or Contact activity records in Netsuite CRM

Allow Sugar Market to push Event data

Allows Sugar Market to push Event data completed to Lead or Contact activity records in Netsuite CRM

Step 5: Default Custom Form IDs

If using custom form for creation of new leads, contacts, opportunity, Tasks and Events you will need to provide Custom Form Ids. If using standard forms then default value is 0.

  • Custom Lead Form ID
  • Custom Contact Form ID
  • Custom Opportunity Form ID
  • Custom Task Form ID
  • Custom Event Form ID

Step 6: Sync Alert

Insert the email addresses of whom should be alerted should there be an issue with your sync. We typically recommend you include the CRM Admin and any primary Sugar Market Users. You can separate multiple email addresses with a semicolon.

CRM Mappings

The following fields, grouped by their tables in Sugar Market, are pulled down from Netsuite CRM into Sugar Market.

Accounts

Netsuite Field

Sugar Market Field

--

AccountID (primary key)

Netsuite's Account ID (primary key)

ID

CompanyName

AccountName

RegardingObjectId (foreign key)

(if multiple owners, we pull the first Netsuite owner)

OwnerID (foreign key)

Addr1

MailingStreet

State

MailingState

City

MailingCity

Zip

MailingZip

Contacts and Leads

Sugar Market does not have a Leads table, but they are differentiated in the Contacts table by the CRMType field.

Netsuite Field

Sugar Market Field

--

ContactID (primary key)

Netsuite's Contact ID (primary key)

ID

Netsuite's Account ID (foreign key)

AccountID (foreign key)

OwnerID (foreign key)

OwnerID (foreign key)

--

CRMType 

--

CreatedDate

--

LastUpdate

DateCreated

ExternalCRMCreatedDate

LastModifiedDate

ExternalCRMUpdatedDate

FirstName

FirstName

LastName

LastName

Email

Email

GlobalSubscriptionStatus

OpOut

(Does not map)

Source

Title

Title

Phone

Phone

MobilePhone

MobilePhone

Addr1

MailingStreet

State

MailingState

City

MailingCity

Zip

MailingZip

Opportunities

Netsuite Field

Sugar Market Field

--

OpportunityID (primary key)

Netsuite's Opportunity ID (primary key)

ID

PrimaryCompanyID (foreign key)

AccountID (foreign key)

PrimaryPersonID (foreign key)

ContactID (foreign key)

AssignedUserID (foreign key)

OwnerID (foreign key)

Title

OpportunityName

Title

Description

Status

Stage

ProjectedTotal

Amount

Probability

Probability

Users

Netsuite Field

Sugar Market Field

--

UserID (primary key)

Netsuite's user ID (primary key)

ID

FirstName

First_name

LastName

Last_name

FirstName + LastName

Name

Email

Username

Email

Email

GiveAccess

Status

Address1

Address1

Address2

Address2

City

City

State

State

Zip

Zip

Country

Country

Title

JobTitle

Phone

Phone_Number

Cell

MobilePhone

Salutation

Salutation

Push Only - Sugar Market's Task to Netsuite's Activity

Netsuite Field

Sugar Market Field

--

TaskID (primary key)

Netsuite's Activity ID (primary key)

ID

PrimaryPersonID (foreign key)

ContactID (foreign key)

CreatedDate

Create_Date

StartDate

DueDate

DueDate

DueDate

Message

DescriptionText

Title

Subject

TaskPriority

Priority

TaskStatus

Status

Netsuite Bundle Patch Notes

Netsuite Bundle Version 1.7

In order to follow guidelines of Netsuite's certification program we have upgraded our solution from an Unmanaged bundle to a Managed bundle. Clients will need to uninstall the unmanaged bundle then install the managed bundle.

Netsuite Bundle Version 1.6

Architectural updates to maintain Netsuite Certified.

Netsuite Bundle Version 1.5

Support for Multiple Subsidiaries.

Netsuite Bundle Version 1.4

The configuration of Iframe URL and Sugar Market Tab where Iframe is displayed.

Uninstall the Sugar Market Unmanaged Bundle From Netsuite

Step 1 - Login into Customer NetSuite Account.

Login into customer Netsuite account -> Go to Customization > SuiteBundler > Search & Install Bundles -> List. It shows the bundles list.

Step 2 - Search "Salesfusion Integration" unmanaged bundle.

Then search for "Salesfusion Integration" in the list and Ensure that the version is 1.6 or below - unmanaged bundle (this bundle must be already installed).

Step 3 - Uninstall the unmanaged bundle.

Click on "ACTION" -> Uninstall. It uninstalls the unmanaged bundle from the customer NetSuite instance.

Last modified: 2021-08-21 22:08:13