Skip to content

Exact Online

Exact Online is a comprehensive cloud-based ERP and accounting solution that helps businesses manage financial data, customer relationships, inventory, sales orders, and business processes. It provides real-time insights into business performance and supports multi-company, multi-currency operations with seamless integration across various business functions (source).

ConnectorSupported Features
Items✅ Unit of Measures   ✅ Attributes   ✅ Name   ✅ Images   ✅ Family Code   ✅ Attachments
Prices❌ Not supported
Stock❌ Not supported (read-only access)
Orders❌ Not supported (API available but not integrated)
Customers✅ Contact Persons   ✅ Addresses   ✅ Customer Attributes   ✅ Address Attributes   ✅ Contact Person Attributes   ✅ Customer Contact Details   ✅ Address Contact Details   ✅ Contact Person Contact Details   ✅ Name   ✅ Attachments

Settings

The Exact Online connector requires OAuth2 authentication and provides several configuration options for optimal synchronization performance.

Synchronization Settings

  • Sync Interval - Configurable synchronization frequency
  • Batch Size - Number of records processed per batch
  • Incremental Sync - Delta synchronization using Timestamp field
  • Error Handling - Comprehensive error handling with rollback support

Asset Management

  • Image Download - Automatic high-resolution image downloading
  • Logo Support - Customer logo asset management
  • Thumbnail Generation - Optimized thumbnails for UI display
  • Asset Caching - Local caching for improved performance

Synchronization Capabilities

Supported Operations

The Exact Online connector provides read-only synchronization for items and customers with comprehensive attribute coverage:

  • Items: 100+ attributes including basic information, classification, pricing, inventory, taxation, and custom fields
  • Customers: 150+ attributes including contacts, addresses, financial information, classifications, and communication details
  • Assets: Automatic downloading and caching of product images and customer logos

Synchronization Strategy

  • Incremental Sync: Uses Exact Online's Timestamp field for efficient delta synchronization
  • Bulk Processing: Configurable batch sizes for optimal performance
  • Transaction Safety: Database transaction management with rollback on errors
  • Rate Limiting: Built-in API rate limiting with exponential backoff retry logic

Data Mapping Features

  • Comprehensive Field Mapping: Detailed transformation between Exact Online and platform models
  • Multi-language Support: Support for localized product descriptions and names
  • Relationship Management: Proper handling of one-to-many relationships (customer-addresses, items-categories)
  • Custom Field Support: Extensible field mapping for Exact Online's free fields
  • Asset Integration: Automatic URL transformation and asset downloading

Current Limitations

  • Read-only Access: Items and customers can only be read from Exact Online, not written back
  • No Price Synchronization: Price information can be read but not synchronized
  • Limited Stock Support: Stock levels are accessible but no write-back synchronization
  • Orders Not Integrated: While Exact Online provides order APIs, they are not yet integrated with the platform
  • Single-direction Sync: Data flows from Exact Online to the platform only

Error Handling

  • API Error Parsing: Detailed error logging for API failures
  • Retry Logic: Automatic retry with exponential backoff for transient failures
  • Data Validation: Comprehensive validation before synchronization
  • Graceful Degradation: Partial sync completion with detailed error reporting