Help Center

Importing products from NetSuite

Sarah Bacchus
Sarah Bacchus
  • Updated

Our integration provides seamless product imports allowing you to manage your product data on NetSuite while we automatically retrieve the latest changes on a daily basis.

As a best practice, GoDataFeed and NetSuite recommend using the token-based authentication (TBA) method. This method is the most secure, easiest to maintain, and stabilizes the integration processes by reducing timeout and credentials errors.

In this article, we'll provide instructions on getting the authentication details from NetSuite for the token-based authentication, and how to update your GoDataFeed integration to use the token-based authentication method.

 

1. Verifying Your NetSuite Account has Token-Based Authentication Enabled

  • Log in to NetSuite. Navigate to Setup > Users/Roles > Access Tokens
  • If you do not have 'Access Tokens', you have to enable this feature in NetSuite
  • Navigate to Setup > Company > Enable Features > SuiteCloud
  • Under Manage Authentication, enable Token-Based Authentication

2. Creating Your NetSuite Token Authentication Information

Your GoDataFeed integration will require token authentication details from NetSuite. We recommend having a text editor open so you can copy and paste your NetSuite token values.

  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret

3. Create a new Role:

  • In NetSuite, on the top menu bar, navigate to Setup >Users/Roles >Manage Roles >New
  • On the New Role page, enter a name for the role
    • It is recommended to use something like GoDataFeed-<your company name> Integration
    • ie. GoDataFeed-Acme Integration
  • Under General
    • Center Type > select
      • System Administrator Center
    • Check these boxes
      • Do not restrict employee fields
      • Core administration permissions
  • Under Authentication check these boxes
    • Web services only role
  • In the Permissions menu
    • Go to Lists and select
      • Items
      • Item Collection
      • Custom Record Entries
    • In the Level drop-down list, select View
  • In the Setup menu
    • Select SOAP Web Services and User Access Tokens
    • In the Level drop-down list, select View
  • Click Add or Save to save the new role

4. Assign a User to Token-based Authentication Role

In NetSuite, you'll need to grant a user the token-based authentication role:

  • Navigate to Setup > Users/Roles > Manage Users
  • Use an existing user (a) or Create a new user account (b). We recommend creating a new, "dummy" user (many create a "GoDataFeed" user) so there's no chance of them being made inactive and losing the authentication
    • Select an existing user- this will take you to the user's Employee Record, where you'll need to click the Edit button
    • Create a user for this, create the Employee record (Lists > Employees > Employees > New) and grant them NetSuite access (in the Employee Record, navigate to the Access tab and check off 'Give Access')
    • Once the new employee is created, continue to step 3 while in the new User record
  • Locate the role you want to modify. Click the corresponding Edit or Customize link
  • Under Access, find the new role, click Add
  • Click Save to save this update to the Employee/User

4. Creating GoDataFeed Access for Token-based Authentication

The next step is to create an Integration record in NetSuite and to generate the authentication information needed to allow GoDataFeed to integrate.

  • In NetSuite, go to Setup > Integration > Manage Integrations > New
  • Enter a Name for your application - for example "GoDataFeed TBA"
  • Enter a Description, if desired - for example, "GoDataFeed Token-Based Authentication"
  • The application State is "Enabled" by default - leave it as such
  • Enter a Note, if desired
  • Under Authentication, check the Token-based Authentication and User Credentials boxes
  • Click The confirmation page displays the Consumer Key and Consumer Secret for this application - stay on this page and copy the Consumer Key and Consumer Secret values into a notepad or text app
    Warning: This is the only time the Consumer Key and Consumer Secret values will be 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 start again at step 2.1 to obtain new values.

5. Creating a TBA Token

  • In NetSuite navigate to Setup > Users/Roles > Access Tokens > New
  • On the Access Tokens page, click New Access Token
  • On the Access Token page
    • Select the Application Name - choose the Application Name you created in Step 2.2 above
    • Select the User you enabled with Full Access
    • Select the Role - "Full Access"
    • 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
  • Click Save
    • The confirmation page displays the Token ID and Token Secret - stay on this page and copy the Token ID and Token Secret values into a notepad or text app
      Warning 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 create a new token and obtain new values.

You've now successfully generated and copied down the NetSuite token values needed in GoDataFeed.

6. Complete GoDataFeed primary source settings and import products

Now that we have our authentication details, we can log in to GoDataFeed and update the Configuration Data in our integration.

  • Log in to GoDataFeed and navigate to Products > Primary Source
  • Select NetSuite from the drop-down list under 'Import Source' 
    • Account - this should be your NetSuite Account ID
    • Token ID - paste the Token ID you generated above
    • Token Secret - paste the Token Secret you generated above
    • Consumer Key - paste the Consumer Key you generated above
    • Consumer Secret - paste the Consumer Secret you generated above
  • Click SAVE to save your updated authentication.

As the last step, we recommend running your import by clicking on the IMPORT button

 

Additional articles:

 

Request custom import filters

Please contact us to request a customized import using API query filters based on any fields including custom fields. This may be helpful if you have many product records and only wish to import a subset. 

Was this article helpful?

0 out of 1 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.