NetSuite integration

Our in-house NuORDER team has developed an integration with NetSuite. To ensure a smooth integration project, make sure your NetSuite portal is populated with product and customer data in advance.

 

Data flow

The data flow encompasses the following elements:

  • Product Data - from NetSuite to NuORDER
  • Customer Data - from NetSuite to NuORDER
  • Inventory Data - from NetSuite to NuORDER
  • Pricesheet Data - from NetSuite to NuORDER
  • Sales Orders - from NuORDER to NetSuite
  • Order Edits - from NetSuite to NuORDER
  • Order Shipments - from NetSuite to NuORDER
  • Order Creation - from NetSuite to NuORDER

back to top

Sync frequency

Whenever changes occur in NetSuite, such as items, inventory levels, or customer data, they are placed in a queue. The data feeds will be updated multiple times daily based on the agreed sync times. Orders will sync from NuORDER to NetSuite in approximately 15 minutes.

back to top

Turnaround time

The NetSuite integration project is expected to take approximately 12-16 weeks from the project kickoff to completion. This timeline encompasses all stages of the rollout, including:

  • Planning and discovery sessions
  • Data cleanup and preparation on your end for the NetSuite integration
  • Custom configuration and installation of the NuORDER bundle in NetSuite
  • Testing and review in the NuORDER sandbox
  • Adjustments as needed
  • Final review and sign-off
  • Transition from the sandbox to production
  • Post-launch troubleshooting

back to top

Your team's involvement

From your team, the following key roles will be involved:

  1. Your NetSuite Administrator or a technically proficient team member familiar with your NetSuite setup.
  2. A Sales or Operations Manager who understands your business structure and the sales process.

back to top

Your responsibilities

You will be responsible for:

  • Providing detailed information about your NetSuite setup and sales process.
  • Ensuring that your NetSuite portal is ready for integration (e.g., product, customer, and inventory data is populated in NetSuite).
  • Offering insights into data fields used in NetSuite and parameters for item/customer synchronization with NuORDER.
  • Making necessary bulk adjustments, such as adding new fields to your NetSuite data, for an optimal NuORDER user experience.
  • Designating & reviewing data in the NuORDER sandbox and providing feedback.
  • Creating & reviewing test orders in NetSuite and offering feedback.
  • Providing final approval for the go-live stage.
  • Monitoring data feeds daily after going live to ensure correctness.
  • Collaborating with us to address any unforeseen issues that may arise once your team is actively using NuORDER in the live sales environment.

back to top

NuORDER team's involvement

From the NuORDER team, you can expect:

  1. An Integration Manager who will serve as your main point of contact, overseeing the project and guiding you throughout the rollout.
  2. An Integration Engineer responsible for configuring and installing the NuOrder bundle in NetSuite, as well as designing field mappings and defining integration logic.

back to top

NuORDER's responsibilities

We will be responsible for:

  • Gaining an understanding of your specific NetSuite setup and sales process.
  • Installing the NuORDER bundle on your NetSuite account.
  • Customizing integration setup based on your unique data fields, logic, and business rules.
  • Synchronizing test data into the NuORDER sandbox.
  • Synchronizing test orders into NetSuite.
  • Ensuring a smooth transition from the sandbox to production.
  • Keeping your team updated throughout the process and addressing any delays as they arise.
  • Resolving any unexpected issues that may occur after the go-live stage.

back to top

Data transfer method

Data will be transferred using API.

back to top

Special considerations for NetSuite

Access to your NetSuite Account

Before we commence, please provide us with a login to your NetSuite account with Web Services enabled. It is advisable to set up a dedicated login during the project term.

To enable Web Services on your account:

  1. Go to Setup > Company > Enable features.
  2. Under the SuiteCloud tab, select "Web Services."
  3. Save.

Set preferences for Web Services:

  1. Go to Setup > Integration > Web Services.
  2. Disable mandatory custom field validation.

NetSuite Internal IDs

An essential requirement for the integration is to load all NetSuite Internal IDs into NuORDER. These IDs are critical for order synchronization between the two systems.

  • For Customers: The Internal IDs will be added to our "Company Code" field.
  • For Products: The Internal IDs will be added to our "UPC" field.

To display Internal IDs in NetSuite:

  1. Go to Home > Set Preferences.
  2. Enable the "Show Internal ID" option.
  3. Save.

back to top

System requirement callouts

Account Settings:

  1. Enable Token-Based Authentication: Under Setup > Company > Enable Features > go to SuiteCloud Tab > find Token-Based Authentication and set it to Yes/True.

back to top

Other Integrations

Please inform us of any other systems integrated with NetSuite, as this information may impact synchronization times.

back to top

What's supported

These are the capabilities and callouts for what's supported.

What's supported: Products

Capabilities
  • Creating and updating items: The NuOrder product integration will be able to identify the difference between new and existing items in our system. 
  • Customized data mapping: Your Implementation Manager will work with you to map NetSuite data to NuOrder required, standard, and/or custom fields. 
  • Pricing and Multiple currencies: Your NuOrder integration will sync default and wholesale prices for each currency. Additional NetSuite Price Levels can be supported through customer-level discounts or via a NetSuite Pricesheet integration. 
  • Price-per-size is supported. 
  • Removing Items: The NuOrder integration will be configured to archive or disable products in NuOrder based on custom fields from NuOrder's NetSuite bundle. 
  • Custom Sync Parameters: You will work with your Implementation Manager to specify the rules the integration should use to identify which items should be synced to NuOrder (e.g. Item Status, Category, checkbox at the item level, etc.).
  • Supported NetSuite Item Types
    • Inventory Items
    • Assembly Items

 

Callouts
  • UPC Codes: The Item NetSuite Internal ID is mapped to the NuOrder "UPC" field. If the actual UPCs are needed in NuOrder, they can be mapped to the "GTIN" or "UPC Code" fields. 
  • Parent/Child Items: If color and size variations are not included in the NetSuite matrix items, work with your Implementation manager which NetSuite fields should be mapped to the NuOrder Style Number, Color, and Size fields. 
  • Unsupported NetSuite Item Types
    • Groups 
    • Kits
    • Non-Inventory Items

 

What's supported: Companies 

Capabilities
  • Two-way customer sync is not supported: Your customers must originate in NetSuite and be synced to NuOrder with all the necessary account codes. (This is how NetSuite will recognize the customer when the order is synced back in.) Bi-directional syncing for customers is on our product roadmap for future development.
  • Creating and updating customers: The NuOrder company integration will be able to identify the difference between new and existing companies in our system. 
  • Customized data mapping: Your Implementation Manager will work with you to map NetSuite data to NuOrder required, standard, and/or custom fields. 
  • Multiple billing and shipping addresses for a single company are supported. 
  • Custom sync parameters: You will specific the rules for which customers should be synced to NuOrder (e.g. Customer type, groups, checkbox at the customer level, etc.).

 

Callouts
  • Two-way customer sync is not supported: Your customers must originate in NetSuite and be synced to NuOrder with all the necessary account codes. (This is how NetSuite will recognize the customer when the order is synced back in.) Bi-directional syncing for customers is on our product roadmap for future development.

  • Process for New Customers: When working with a new customer in NuOrder, you will need to save the order as a DRAFT. Your team will need to add the new customer record into NetSuite first. The customer will sync to NuOrder on the next run (within 30 minutes). Once the customer is visible in NuOrder, the sales rep can open their draft, select the customer, fill in the buyer's name and email address, and submit the official order.

 

What's supported: Buyers

Capabilities
  • Create buyers in NuOrder by extracting buyer name and email from NetSuite contacts
  • Delete buyers in NuOrder

 

What's supported: Inventory

Capabilities
  • Warehouses: Multiple warehouses are supported. You will specify which warehouse locations should be synced to NuOrder.
  • Immediate ATS (available-to-sell): The ATS extracts from the "quantity available" field in NetSuite. If different quantities should be visible in NuOrder, let your Implementation Manager know.
  • WIP (work-in-progress): WIP quantities can be extracted from NetSuite Purchase Orders, Transfer Orders, and Inbound Shipments. 
  • Prebook: For items that should have unlimited quantity available in NuOrder, the following custom fields will be utilized from the NuOrder-NetSuite bundle: 
    • Prebook (boolean)
    • Prebook Start Date (date) - optional 
    • Prebook End Date (date) - optional

 

Callouts
  • NetSuite Supply Allocation Tool: NuORDER's Inventory integration can work with NetSuite's free Supply Allocation Tool. If Supply Allocation is not configured within your NetSuite environment, please work with your NetSuite admin. The NuOrder Team cannot advise on how to properly configure the tool.

 

What's supported: Pricesheets 

Capabilities
  • Pricesheets will be used to support more granular pricing levels within a currency. For example, if a category of customers have product price points that differ from your other customers dealing in the same currency.
  • A price sheet will include a list of all items and the associated price, and whether the item is active for that particular price price sheet.
  • Pricesheets are often referred to as PriceLevels in NetSuite.

 

Callouts
  • Customers not assigned to a price sheet will receive the default wholesale and retail prices from the product data.

 

What's supported: Order export (NuOrder -> NetSuite)

Capabilities
  • Custom Sales Order Form: The Order Export will be configured to sync orders to NetSuite utilizing your existing NetSuite B2B sales order form.
  • Custom Fields: Your Implementation Manager will work with you to set up any custom NuORDER fields that should be mapped back to NetSuite needed for your Sales Order. 
  • Sync Parameters: NuOrder can export Pending, Approved, and/or Review orders. 
  • Sync Frequency: Orders will be exported to NetSuite in near real time (~5minutes).
  • Order Fulfillment Process: Orders will be exported to NetSuite with a "Pending Approval" or "Pending Fulfillment" status. Your team will then process the order per your normal approval/fulfillment process. 

 

Callouts
  • Importance of Internal IDs: When the integration exports an order to NetSuite, the NetSuite internal ID for the customer, address, and every item (to the size level) is sent to NetSuite. If any of the IDs are not valid in NetSuite (e.g. the record was deleted), the order will not be able to sync. If this happens, you will need to review the record that was not recognized and resolve the issue.
  • Sync Errors: NuOrder will provide your team with a list of common order sync errors, and what action needs to be taken to resolve it. It will be your team’s responsibility to review these notifications, and address any errors that occur.
    • These errors can include things like:
      • Invalid or missing Customer ID (Company code)

      • Invalid or missing Item ID (UPC)

      • Customer is on credit hold in NetSuite

 

What's supported: Order edits, creation, & shipments (NetSuite -> NuOrder)

Capabilities

NuOrder's 2way integration is comprised of: 

  • Order Creation will import orders created in NetSuite
  • Order Edits will import changes to existing NuORDER orders like: 
    • Price changes
    • Adding/canceling line items
    • Canceling orders
    • Shipping Costs
  • Order Shipments
    • Shipment & tracking information, including line items shipped 
    • Partial shipments are supported

 

Callouts
  • Required data to accept a 2way Order Integration for NetSuite: The customer record and all line items must exist in NuOrder to successfully update a NuOrder order.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request