Items

Overview

The NetSuite Items integration synchronizes comprehensive product catalog data from NetSuite to Zudello, including pricing, descriptions, and inventory attributes for complete product management.

Integration Details:

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

Key Benefits

• Real-time product catalog synchronization
• Includes pricing and inventory data
• Supports multiple item types and configurations
• Maintains vendor and supplier relationships

Field Mappings

NetSuite Field	Zudello Field	Description	Data Type
itemid	ItemCode	Unique item identifier	String
displayname	ItemName	Item display name	String
isinactive	Status	true = INACTIVE, false = ACTIVE	String
salesdescription	Description	Sales description	String
baseprice	UnitPrice	Base selling price	Decimal
cost	UnitCost	Standard cost	Decimal
unitstype	UnitOfMeasure	Links to Unit of Measure	Relation
itemtype	ItemType	Item classification	String
taxschedule	TaxCode	Links to Tax Schedule	Relation
incomeaccount	IncomeAccount	Links to income Account	Relation
cogsaccount	COGSAccount	Links to COGS Account	Relation
assetaccount	AssetAccount	Links to asset Account	Relation
vendor	PreferredVendor	Links to preferred Vendor	Relation

API Configuration

SuiteQL Query Structure

The integration uses comprehensive SuiteQL queries to retrieve item data including pricing, accounting setup, and vendor relationships.

Authentication

• Method: Token-based Authentication (TBA)
• Required Permissions:
  • Items (View)
  • Item Records (View)
  • Lists → Items (View)
  • Vendors (View)
  • Accounts (View)

Sync Configuration

Incremental Sync Logic

The integration efficiently tracks product changes:

• Initial sync retrieves all item records
• Subsequent syncs fetch items where lastmodifieddate > last sync timestamp
• Pricing updates synchronized in real-time
• Inventory and cost changes tracked continuously

Data Transformation

• Status Conversion: NetSuite boolean isinactive (T/F) → Zudello string status (INACTIVE/ACTIVE)
• Price Formatting: Ensures consistent decimal precision for pricing
• Account Mapping: Links items to appropriate GL accounts

Processing Logic

1. Item Retrieval: Query modified item records
2. Price Validation: Verify pricing data accuracy
3. Account Linking: Associate items with GL accounts
4. Vendor Resolution: Link items to preferred vendors
5. Status Processing: Update active/inactive item flags
6. Type Classification: Apply standard item type categories

Troubleshooting

Issue	Possible Cause	Solution
Missing items	Permission restrictions	Verify Items view permissions
Pricing discrepancies	Currency conversion	Check multi-currency setup
Account mapping errors	Missing GL accounts	Ensure accounts sync first
Vendor link failures	Vendor permissions	Verify vendor access rights
Performance issues	Large catalog	Implement batch processing

Related Documentation

• NetSuite Integration Overview
• Inventory Management
• Pricing Configuration
• Vendor Management