Locations

Overview

The NetSuite Locations integration synchronizes location master data from NetSuite to Zudello, enabling comprehensive inventory tracking and multi-location operational management.

Integration Details:

• Direction: NetSuite → Zudello (📥 Inbound)
• Sync Type: Incremental
• Sync Frequency: Every 4 hours
• API Used: SuiteQL

Key Benefits

• Centralized location management
• Supports inventory tracking by location
• Enables location-based reporting
• Maintains location hierarchies and relationships

Field Mappings

NetSuite Field	Zudello Field	Description	Data Type
name	LocationName	Location name identifier	String
isinactive	Status	true = INACTIVE, false = ACTIVE	String
parent	ParentLocation	Parent location for hierarchy	Relation
subsidiary	Subsidiary	Associated subsidiary	Relation
address1	Address1	Primary address line	String
address2	Address2	Secondary address line	String
city	City	City name	String
state	State	State/province	String
zip	PostalCode	Postal/ZIP code	String
country	Country	Country name	String
phone	Phone	Contact phone number	String
includechildren	IncludeChildren	Consolidation indicator	Boolean

API Configuration

SuiteQL Query Structure

The integration queries location data with hierarchical relationships and address information for comprehensive location management.

Authentication

• Method: Token-based Authentication (TBA)
• Required Permissions:
  • Locations (View)
  • Lists → Support (View)
  • Subsidiaries (View)
  • Address Records (View)

Sync Configuration

Incremental Sync Logic

The integration maintains efficient location synchronization:

• Initial sync captures complete location structure
• Subsequent syncs retrieve locations where lastmodifieddate > last sync timestamp
• Maintains parent-child location relationships
• Address changes tracked for location updates

Data Transformation

• Status Conversion: NetSuite boolean isinactive (T/F) → Zudello string status (INACTIVE/ACTIVE)
• Address Standardization: Formats address data consistently
• Hierarchy Validation: Ensures parent locations exist before processing children

Processing Logic

1. Location Query: Retrieve modified location records
2. Hierarchy Processing: Process parent locations before children
3. Address Validation: Verify address completeness and format
4. Status Management: Update active/inactive location flags
5. Subsidiary Linking: Associate locations with subsidiaries
6. Consolidation Rules: Apply include/exclude children logic

Troubleshooting

Issue	Possible Cause	Solution
Missing locations	Permission restrictions	Verify Locations view permissions
Hierarchy errors	Parent not synced	Run full sync to rebuild hierarchy
Address format issues	Data validation	Check address field mappings
Subsidiary conflicts	Multi-subsidiary setup	Review subsidiary access
Performance degradation	Large location set	Optimize query with filters

Related Documentation

• NetSuite Integration Overview
• Inventory Management
• Multi-Location Setup
• Subsidiary Management