1. Purpose of Integration
- Syncs orders, inventory, customers, and financials between NetSuite and Shopify.
- Reduces manual data entry and improves operational efficiency.
- Enables scalable ecommerce operations with automated workflows.
2. Create a Role for Token-Based Authentication
Before creating the Integration Record, you must create a custom role with specific permissions to support token-based authentication.
Steps:
- Go to: Setup > Users/Roles > Manage Roles > New.
- Assign the following permissions with Full access:
- Access Token Management
- User Access Tokens
- Log in using Access Tokens
- Save the role and assign it to the integration user.
3. Create an Integration Record in NetSuite
This record enables secure API access between NetSuite and external platforms like Shopify.
Steps:
- Go to: Setup > Integrations > Manage Integrations > New.
- Fill in the following:
- Name: Example – Shopify Integration.
- State: Enabled.
- Authentication: Token-based (recommended).
- Save the record to generate:
- Consumer Key.
- Consumer Secret.
These credentials are used for secure API access from Shopify or middleware.
4. Set Up an SDF Project
SuiteCloud Development Framework (SDF) allows you to manage NetSuite customizations as code.
Prerequisites:
- Install SuiteCloud CLI or use SuiteCloud IDE (WebStorm or VS Code plugin).
- Enable NetSuite features:
- SuiteScript
- SuiteFlow
- SuiteBundler
- SuiteCloud Development Framework
Steps:
- Initialize the project:
- Command: `suitecloud project:create –projectname ShopifyIntegration`
- Import the integration record:
- Command: `suitecloud object:import –type integration –scriptid customintegration_shopify`
- Add supporting files:
- SuiteScript 2.0 scripts for Shopify webhooks (e.g., order creation).
- Custom records or workflows for data mapping.
- Deploy to NetSuite:
- Command: `suitecloud project:deploy`
5. Connect Shopify to NetSuite
Build a custom connector using RESTlets and Shopify Admin APIs.
Key integration points:
- Orders: Shopify to NetSuite Sales Orders.
- Inventory: NetSuite to Shopify stock levels.
- Customers: Shopify to NetSuite Customer records.
- Fulfillment: NetSuite to Shopify fulfillment status.