NetSuite Integration for Shopify — Complete Setup & User Guide

NetSuite Integration ‑ TM by TechMarbles is an enterprise-grade, two-way connector between Shopify and Oracle NetSuite. It automatically syncs orders, inventory, prices, products, and customers in both directions, and supports advanced commerce scenarios — Shopify Markets, B2B Company Catalogs, POS orders, purchase orders, multi-location inventory, multi-currency pricing, and conditional field mapping — so you never re-key data between your storefront and your ERP.

Built for high-volume enterprises and growing D2C/B2B brands alike, with reliable background sync (Shopify bulk operations + webhooks), detailed logs, and hands-on support from the TechMarbles team.

---

Overview & How It Works

The app keeps Shopify and NetSuite in step in both directions:

Shopify → NetSuite

• Orders → Sales Orders or Cash Sales (with optional Invoice / Cash Sale and Customer Deposit)
• POS orders → Sales Orders or Invoices
• Orders → Purchase Orders (for drop-ship / B2B flows, by customer tag or metafield)
• Customers → NetSuite customers or companies (B2B)
• Refunds → NetSuite credits/returns

NetSuite → Shopify

• Inventory / stock levels (multi-location, with quantity buffer and Units of Measure)
• Prices (by price level, mapped to Shopify Markets and B2B Company Catalogs, multi-currency)
• Products / items (titles, descriptions, vendor, type, barcode, dimensions, custom fields)
• Customers (import to Shopify)
• Refunds and fulfillment / tracking

Order and customer changes sync in near real time via webhooks; products and inventory use efficient Shopify bulk operations for high-volume catalogs. Every action is recorded in Logs.

---

1. Getting Connected (Configurations)

Open the app from your Shopify admin under Apps → NetSuite Integration. To establish a connection between NetSuite and Shopify, the following values are required:
1. NetSuite Host URL
2. NetSuite Account ID
3. NetSuite Consumer Key
4. NetSuite Consumer Secret
5. NetSuite Token ID
6. NetSuite Token Secret

To get the values for these fields, follow these steps:

• Login to your NetSuite account
• Go to Setup → Company → Company Information
• Here you will get the Account ID. Copy the account id and paste it into Shopify

• To get the Host URL, scroll down
• Go to Company URLs
• Copy the URL under SUITETALK (SOAP AND REST WEB SERVICES), and paste it into Shopify

2. To get the NetSuite Consumer Key and NetSuite Consumer Secret

Follow these steps to retrieve the Consumer Key and Consumer Secret:

• Go to the Setup → Integration → Manage Integrations → New
• Enter the name of the application (name could be of your choice for example, “TM Shopify NetSuite”)

• Uncheck the following two checkboxes:
  • TBA: AUTHORIZATION FLOW
  • AUTHORIZATION CODE GRANT
• Make sure the following two checkboxes are checked:
  • TOKEN-BASED AUTHENTICATION
  • USER CREDENTIALS

• Click the Save button
• After saving the Integration form You will get the CONSUMER KEY / CLIENT ID and CONSUMER SECRET / CLIENT SECRET
• Copy the Consumer Key and Consumer Secret and paste it into Shopify

3. To get the NetSuite Token ID and NetSuite Token Secret

Follow these steps to get the Token ID and Token Secret:

Your NetSuite role must have the permissions listed in Required User Role Permissions below.

1. Click the Home icon → Dashboard.
2. Click Manage Access Tokens under the Settings portlet.
3. Click New My Access Token.
4. Select the application created in Step 2 and click Save.
5. Copy the Token ID and Token Secret into the app immediately.

Verify the connection

Use Test API Credentials. On success you’ll see: “Congrats. API connection is successful.”

Required User Role Permissions

In NetSuite, Setup → User Roles → Manage Roles, give the role used for the connection:

NetSuite tab	Permission	Level
Transactions	Sales Order	Full
Transactions	Item Fulfillment	Full
Transactions	Fulfill Sales Order	Full
Transactions	Cash Sales	Full
Transactions	Find Transaction	Full
Reports	SuiteAnalytics Workbook	Full
Lists	Items	View
Lists	Location	View
Lists	Currency	View
Lists	Promotions	Full
Lists	Shipping Items	View
Lists	Customer	Full
Lists	Units	Full
Lists	Address List in Search	Full
Setup	REST Web Services	Full
Setup	User Access Tokens	Full
Setup	Integration Application	Full
Setup	SOAP Web Services	Full
Setup	Accounting Lists	Full

Click Save.

Creating a Role on NetSuite (optional)

Setup → User Roles → Manage Roles → New:

1. Enter a Role name.
2. Centre Type: Accounting Centre.
3. Check Do Not Restrict Employee Fields.
4. Subsidiary Restrictions: Selected.
5. Authentication: enable Web Services Only Role.
6. Assign the permissions in the table above.
7. Click Save.

Clear Temporary Cache

On the Configurations screen you can Clear Temporary Cache — Clear Customer Data and/or Clear Product Data. Use this only when changing the connected NetSuite database or troubleshooting a sync issue.

The NetSuite Integration for Shopify app syncs your orders, product inventory/prices, and customers. Its features offer deep enhancement capabilities when you use it with advanced mappings like currencies, subsidiaries, shipping methods, custom forms, sales reps, and classes or any other NetSuite field with conditional mapping features. We also provide an additional feature to sync item inventory/prices manually.