Building a NetSuite-Shopify Integration with Celigo: Step-by-Step
Introduction
Manually syncing orders, inventory, and customer data between Shopify and NetSuite can drain operational efficiency and create room for costly errors. A proper integration ensures seamless data exchange, real-time inventory updates, and accurate financial reporting.
In this guide, we’ll walk you through how to build a NetSuite-Shopify integration using Celigo’s integrator.io — a leading iPaaS solution. Whether you’re new to integrations or refining an existing setup, this tutorial provides a clear, hands-on process to get your systems talking.
Who This Is For
This guide is designed for:
- NetSuite Administrators
- Shopify Store Managers
- eCommerce and Operations Managers
- IT Professionals managing system integrations
Step-by-Step Breakdown: Building the Integration
1. Prerequisites
- Active NetSuite and Shopify accounts
- Access to Celigo integrator.io
- NetSuite Token-Based Authentication (TBA) enabled
- Necessary API permissions in Shopify
2. Install the Shopify-NetSuite Integration App in Celigo
- Go to the Marketplace on integrator.io
- Search for “Shopify – NetSuite Integration App”
- Click Install and choose the appropriate environment (sandbox or production)
📝 Tip: Always test in a sandbox before deploying to production.
3. Configure Connections
a. Shopify Connection:
- In Celigo, go to Connections > + Create Connection
- Select Shopify as the application
- Use your Shopify store URL and API credentials (Admin API access token)
Fields to enter:
- Store name
- Access token
- API version (e.g., 2023-07)
b. NetSuite Connection:
- Select NetSuite as the application
- Use Token-Based Authentication
- Enter Account ID, Token ID, and Token Secret, Select Environment, iClient
🛡️ Security Tip: Use environment variables in Celigo to store credentials safely.
4. Configure Integration Flows
Key Flows Included:
- Shopify Order to NetSuite Sales Order
- NetSuite Item to Shopify Product
- Shopify Customer to NetSuite Customer
- NetSuite Fulfillment to Shopify Fulfillment
For each flow:
- Open the flow > Click Settings
- Map relevant fields (e.g., Shopify order ID → NetSuite external ID)
- Enable or schedule the flow (real-time or batch)
🛡️ Security Tip: Validate field mappings using Celigo’s data preview tool before enabling.
5. Testing and Validation
- Run test orders in Shopify
- Confirm if they sync correctly in NetSuite
- Monitor integration dashboard for errors
- Enable error notifications via email or Slack
Checklist:
- Order sync
- Inventory update
- Customer creation
- Fulfillment confirmation
Common Mistakes to Avoid
- Not enabling TBA in NetSuite before connection setup
- Misaligned item SKUs between Shopify and NetSuite
- Overlooking timezone mismatches in scheduled flows
- Forgetting to test with sandbox before going live
Result of Applying This
After successful implementation, you’ll eliminate manual data entry, reduce sync errors, and gain real-time visibility into orders, inventory, and customer data. Your operations team can focus on scaling the business instead of fixing data mismatches.
