Help Center

Import: Netsuite - 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.

Some merchants prefer a saved search export via FTP instead of the API integration. You can find the Oracle documentation in the following link:

View documentation 

Netsuite import setup steps

Expand each of the 7 steps below and complete the items in each step to setup your NetSuite import:

    • 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 that 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

  • 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
      • 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- Integration ie. GoDataFeed-Acme Integration

    • Under General > Center Type > select System Administrator Center
    • Check these boxes: Do not restrict employee fields and Core administration permissions
    • Under Authentication check this box: Web services only role

    • In the Permissions menu, go to Lists and select: Items, Item Collection, and 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, and click Add or Save to save the new role


    After you click save, if you have run out of user accounts, you may need to purchase more.

  • 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 > New) and grant them NetSuite access (in the Employee Record, navigate to the Access tab and check off 'Give Access')
    • 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

  • 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
    • 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.

        • In NetSuite navigate to Setup > Users/Roles > Access Tokens > New
        • On the Access Tokens page, click New Access Token
        • Select the Application Name - choose the Application Name you created 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
      • Log in to GoDataFeed and navigate to Import > Primary Source
      • Select NetSuite from the drop-down list under 'Import Source'
      • API Account ID - this should be your NetSuite Account ID - this is located at the beginning of your NetSuite URL - for example, if the URL is https://123456.app.netsuite.com/, then your account ID is 123456
      • 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
      • Token Secret - paste the Token Secret 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?

1 out of 2 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.