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).

Connector	Supported Features
Items	✅ Unit of Measures   ✅ Attributes   ✅ Name   ✅ Images   ✅ Family Code   ✅ Attachments   ❌ Stocks   ❌ Restock orders
Prices	❌ Not supported
Projected Stock	❌ Not supported
Orders	✅ Export
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, and export support for orders, 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
• Orders: Orders created in the OCP are exported when configured in the Order export flow

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
• No Stock Synchronization: Stock levels, projected stock, and restock orders are not synchronized
• Limited Orders Support: Orders are exported, but not imported
• 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

Webhook Subscriptions

The Exact Online connector supports webhook subscriptions to receive real-time notifications when data changes in Exact Online. This eliminates the need to rely solely on polling-based synchronization for detecting changes.

Supported Topics

Topic	Description
Accounts	Notifications when customer accounts are changed
Contacts	Notifications when contact persons are changed
Items	Notifications when items are changed

How It Works

The webhook subscription job automatically manages subscriptions for each connected administration:

1. The job checks which webhook subscriptions already exist for the administration.
2. For each supported topic, it creates a subscription if one does not already exist.
3. If a subscription was already created by another user within the same Exact Online customer, it is gracefully skipped.

When Exact Online detects a change in a subscribed topic, it sends a notification to the platform's webhook endpoint. The platform then processes the notification and triggers the appropriate synchronization flow.

Configuration

The webhook callback URL is configured per environment through infrastructure and does not require any manual setup. Each environment (production, acceptance, feature) automatically receives the correct callback URL pointing to the platform's webhook endpoint.