Oracle NetSuite Onboarding Guide - NetSuite

This guide shows you how to create an integration between your NetSuite account and your Square account. You use Square Bridge to configure and manage the integration. ${SQUARE_BRIDGE_GET_STARTED_SUGGESTION}

To enable the integration, Square Bridge must access your NetSuite account to synchronize with your Square account using data mappings that you provide. You complete the first five steps of this topic in your NetSuite environment to configure it for the integration. The next seven steps are completed in Square Bridge to provide the required NetSuite access tokens and to create the data mapping (see Oracle NetSuite Onboarding Guide - Square Bridge).

Important

You need to complete the Get Started with Square Integrations guide before proceeding.

Link to section

Prerequisites

Before you start working on the steps in this guide, be sure you can meet the following prerequisites:

  • Square and NetSuite permissions - You can integrate your NetSuite environment if you're the owner of a Square account or you have a role in your business such as a NetSuite IT professional, an accountant, or an external value-added reseller (VAR). Regardless of your role in your business, you must have the following permissions:
    • Full access to the Square account.
    • Administrator access to the NetSuite account.
    • Access to a Google or Microsoft account that can be shared among staff and used to log in to Square Bridge.
  • Add units of measure - The units that you use in NetSuite need to exist in your Square account. For more information, see Add NetSuite Units of Measure to your Square Account.
  • Install the Square for NetSuite SuiteApp - The SuiteApp is available in the Oracle NetSuite SuiteApps store. For information about installing the SuiteApp, see Install the Square for NetSuite SuiteApp.
Link to section

Step 1. Enable NetSuite platform permissions and features

Enable the features and permissions needed for Square Bridge to connect to NetSuite for data access. This configuration, which is completed in your NetSuite environment, must be done before configuring Square Bridge to sync data between NetSuite and Square.

You provide a NetSuite user with the required permissions before generating access tokens to be used by Square Bridge to sync with your NetSuite instance. You also need to turn on the NetSuite features needed by Square Bridge.

Square Bridge accesses NetSuite by using tokens issued to a NetSuite user. This is known as token-based authentication. Before you get the user access tokens, confirm that the necessary permissions for using token-based authentication are present for the user and their role.

In NetSuite, Enable features to support the integration:

  1. Choose Setup, choose Company, and then choose Enable Features. Choose the SuiteCloud subtab.
  2. Select the following checkboxes to enable the required features:
    • Client SuiteScript
    • Server SuiteScript
    • SOAP Web Services
    • Token-Based Authentication
Link to section

Step 2. Get NetSuite access tokens

To get access tokens, you need to identify a NetSuite user (employee record) to "own" the integration and then get that user's access tokens. The tokens are provided to Square Bridge so that it can access your NetSuite account safely and securely as that chosen user.

Note

Several NetSuite record types can be returned when you search by the user's name. For example, a Contact can be returned. Be sure that you choose only an Employee record. Roles cannot be attached and access tokens cannot be created for other record types.

Link to section

Choose an employee and assign the Square Bridge integration role

The following steps assign the "Square Bridge Integration" role to the NetSuite user is to be associated with all synced records.

  1. In the NetSuite search field, type the name of the chosen employee, for example "William Oller".

  2. In the search result, choose Edit to make changes to the employee associated with this integration.

    Screen capture from  Netsuite. Search field, employee name entered, with result

  3. In the user page—edit mode, choose Access, then Roles, and attach the role "Square Bridge Integration" and choose Save.

Important

The employee that you choose will be the "owner" of the integration. Records synced from Square Bridge will be created in NetSuite by this employee. If the chosen employee is deleted, the Square Bridge integration stops working until another employee is chosen and new tokens are generated.

Link to section

Generate access token

You generate the NetSuite access tokens using the following steps:

  1. In the NetSuite search field, type "Access Tokens".
  2. In the Access Tokens page, choose New Access Token
  3. In the APPLICATION NAME field, select the application "Square Bridge (custinteg_5abf5455e692)".
  4. Choose USER and select the employee from the previous section.
  5. Choose ROLE and select the role "Square Bridge Integration"
  6. Choose Save and your token ID and secret are displayed.
  7. Save the values for these fields:
    • Token ID
    • Token secret

Note

Until you provide these credentials to Square Bridge in the Integration Wizard (see Set the external source), you should save them in a secure location, such as a password manager note.

Link to section

NetSuite account ID

Your account ID can be found in NetSuite by choosing Setup, choosing Company, and then choosing Company Information (in the ACCOUNT ID field).

Link to section

RESTlet External URL

The Square Bridge catalog item sync depends on the RESTlet installed in NetSuite by the Square SuiteApp. To make that RESTlet available to Square Bridge, you need to get the URL string and save it. You provide it to Square Bridge in Enable synchronization support of the next section of this topic.

In NetSuite, choose Customization, choose Scripting, and then choose Scripts. Find the deployed script whose name is "Square Bridge Items and Inventory Search". Choose View, choose Deployments on the Script page, and then choose Square Bridge Items and Inventory Search RESTlet.

Copy the EXTERNAL URL of the Script Deployment. NetSuites-copy-external-url-of-script

Link to section

Step 3. Enable synchronization support

For Square Bridge to successfully sync data between Square and NetSuite, it needs to know what to map objects to in each system. For example, if Square Bridge attempts to sync a cash payment from Square to NetSuite, it needs to know to which account in NetSuite to assign that cash payment.

Square Bridge relies on NetSuite client JavaScript to enable the actual synchronization of data. SuiteScript must be enabled within NetSuite for the integration.

  1. Within NetSuite, choose Setup, choose Company, choose Enable Features, and then choose the SuiteCloud tab.
  2. Make sure the Client SuiteScript checkbox is selected.

NetSuite assigns unique internal IDs to every NetSuite record. When configuring Square Bridge, you must provide the internal IDs of many records so that objects can be successfully transformed during the sync process. One of the easiest ways to look up these internal IDs is by exposing them within the NetSuite graphical user interface.

  1. Go to the NetSuite home page by choosing the house icon in the navigation bar.
  2. On the home page, within the Settings block, choose Set Preferences.
  3. On the General tab, under the Defaults section, make sure that the Show Internal IDs checkbox is selected.
Link to section

Step 4. Create a default customer

If your NetSuite account doesn't have a default customer defined for each location, you need to create one. Square Bridge uses a default customer to assign orders to when an actual customer isn't specified in the order. The internal ID of your default customer is needed by the Square Bridge Integration Wizard if you sync orders from your Square account.

The default customer should have the status of CUSTOMER, but can have any name. For convenience, you can set the first name of the customer to "Default" and the last name to "Customer".

Link to section

Step 5. Create NetSuite non-inventory items for Square

Square orders can have items or quantities that don't map directly to the NetSuite transaction model. Square Bridge uses non-inventory items in NetSuite to enable an order to be represented correctly in both systems. In this step, you create several non-inventory items that map to Square items or quantities in the Square Bridge Integration Settings and Location Settings.

  1. In NetSuite, choose Lists, choose Accounting, and then choose Items.

  2. Choose New Item.

  3. Under Non-inventory Item, choose For Sale. The page heading in NetSuite should now be Non-inventory Item for Sale.

  4. Under Primary Information, enter names from the following table in the Item Name and Display Name fields.

    You can provide a different name as long as the name denotes its purpose and it's used for Square.

    Recommended item namePurpose
    SqRoundingItemIf there is a <$0.05 discrepancy between corresponding Square and NetSuite transaction documents, the item appears as a line item representing the difference.
    SqCustomDiscountThis item maps to discounts given in Square that aren't explicitly mapped within your Square Bridge Integration settings.
    SqGiftCardItemThis item maps to gift cards purchased in Square.
    SqGiftCardDiscountThe item maps to the discount given when a Square gift card is used in a transaction.
    SqTipThis item maps to tips given in Square.
    SqCustomAmountDepending on your Square setup, employees can charge customers arbitrary (or custom) amounts. This item maps to those custom amounts charged in Square.
    SqDefaultServiceChargeThis item maps to service charges in Square.
    SqAdhocDefaultItemDepending on your Square setup, employees can create a new one-off line item to charge a customer during a transaction. This item maps to those ad hoc line items.
  5. Under Classification, choose one or more Subsidiary options to use with Square. Choose Department, Class, and Location only if your organization requires these fields in a transaction line item.

  6. Under the Accounting tab, choose the non-taxable tax schedule. This might be S2. To verify, open the Tax Schedules page and read the description of each schedule.

Link to section

Square Bridge concepts

Understanding the following concepts is helpful while working through the steps in this guide.

Link to section

Data synchronization

NetSuite records are synced to the Seller Dashboard as objects. These objects include customers, catalog categories, and items.

Some Square objects can also be synced to NetSuite as records. These record types include customers, customer invoices, and inventory adjustments. Customer synchronization is bidirectional, which means updates made in either system are synced to the other system.

ObjectOriginSynchronize direction
CatalogNetSuitePush to Square
CustomersBothBidirectional
Payments & RefundsSquarePush to NetSuite
Invoices & Credit MemosSquarePush to NetSuite
Inventory adjustmentsSquarePush to NetSuite
Inventory levelsNetSuitePush to Square
Bank TransfersSquarePush to NetSuite

For more information about syncing details, see NetSuite Sync Mapping Reference.

Link to section

Bridge account

A Square Bridge account is an account used to gate access to one or more Square Bridge integrations. It's created automatically when you sign in with Microsoft or Google. When you sign in to Square Bridge, you can create and manage your business integrations. A Square Bridge account isn't a Square seller account. If you want to access the Seller Dashboard to manage Square account data, you need to log in to your Square seller account.

Square Bridge uses Microsoft and Google as authentication providers and doesn't currently support sharing access to the Square Bridge user interface with other users. Use a Microsoft or Google account you're comfortable sharing with your organization or create one if necessary.

The five tasks for configuring the integration are:

  • Configure NetSuite for Square Bridge.
  • Verify the existence of Square units of measure corresponding to NetSuite units.
  • Create discounts that are used at the Square Point of Sale.
  • Run the Square Bridge Integration Wizard.
  • Create account data mapping between NetSuite and Square Bridge.
Link to section

NetSuite data permissions

The Square NetSuite SuiteApp created a new NetSuite role when the application was installed. The role is assigned the permissions shown in the following tables.

Choose the Permissions tab on the role page and set the following permissions.

Link to section

Transactions

Transaction Permissions Level
Adjust InventoryEdit
Credit MemoEdit
Customer PaymentEdit
Customer RefundsEdit
InvoiceEdit
Make Journal EntryEdit
Transfer InventoryEdit
Link to section

Lists

List Permissions Level
CustomersView
ItemsView
AccountsView
ClassesView
ContactsView
CurrencyView
CustomersEdit
ItemsView
LocationsView
SubsidiariesView
Tax RecordsView
UnitsView
Link to section

Setup

Setup Permissions Level
Access Token ManagementFull
Accounting ListsView
Log in using Access TokensFull
SOAP Web ServicesFull
User Access TokensFull

When step 2 is complete, your user has all the permissions required for creating a set of access tokens to be used by Square Bridge for connecting to NetSuite as that user.

Link to section

Next step

Link to section

See also