Exact Online to Pipedrive Integration for a Dutch Wholesale Distributor

The Client

A Dutch wholesale distributor of decorative homeware, supplying garden centers and retail across the Netherlands and Germany. The business runs on Exact Online for ERP and accounting, App4Sales for field-sales order entry and the B2B webshop, and was rolling out Pipedrive as their new CRM for visit planning, account management and revenue analytics.

The project came in through an independent Pipedrive consultant leading the CRM rollout. He had the Pipedrive side mapped out in detail. He needed someone who could build the bridge — without quoting it like an enterprise SI.

The Problem

Exact held everything that mattered: orders, the full product catalog across multiple collecties, salespeople, account managers, invoice and payment statuses. App4Sales was pushing orders into Exact reliably. But Pipedrive — the system the field sales team would actually use day-to-day — knew nothing.

Sales reps were walking into customer meetings without knowing whether the last order had shipped or been paid. Account managers couldn't see their own pipeline. There was no way to spot dormant customers, no view of revenue per product category, no native analytics layer at all. Every report meant another Excel pull from Exact.

The brief was unusually clear: build a one-way authoritative sync from Exact to Pipedrive, in near real-time, without ever touching the App4Sales to Exact order flow. Exact stays master. Pipedrive becomes the analysis and field-sales layer on top.

Our Approach

Phase 0 — Verify Everything Against the Live API

Before sending a final scope, we hit the live Exact API: pulled real orders, mapped every status code combination, extracted salesperson GUIDs, validated the bulk endpoint with expanded order lines, and confirmed the product category structure. The result was a fully verified status map — no guesswork going into the build.

Phase 1 — Core Order Sync

The heart of the integration: every Exact SalesOrder becomes a Pipedrive Deal in the "Bestellingen" pipeline, linked to the right Organization (matched on debiteurnummer), owned by the right salesperson (mapped from Exact GUID), priced from the order total excluding VAT, with every order line mirrored as a Deal Product. Webhooks on the SalesOrders topic trigger the sync within seconds; a 5-minute poll runs as fallback.

The trickiest piece was status mapping. Exact tracks order state across three independent fields — Status, DeliveryStatus, and InvoiceStatus. We compressed the verified combinations into a priority-ordered logic that drives stage transitions cleanly: cancellations become lost deals, fully invoiced orders become won deals, partial deliveries land in "Wacht op backorder", complete deliveries pending invoicing land in "Verzonden".

Phase 2 — Historical Migration

Pipedrive does not expose a bulk-create endpoint for deals, and the creation timestamp is not writable via API. So we could not backdate historical orders the obvious way. Solved with a custom "Orderdatum" date field on the deal and a paced migration run, throttled against Pipedrive's daily token budget. On the Exact side, a handful of calls to the bulk SalesOrders endpoint with expanded order lines (1,000 records per page) covered the entire 12 months.

Phase 3 — Product Catalog and Category Sync

Products mirror from Exact into Pipedrive on a 15-minute schedule, delta-synced on modification date to keep API usage flat. Every order line carries its product's item group into a Pipedrive custom field, so the team can run native Insights reports on revenue per product category.

Phase 4 — Infrastructure and Compliance

The whole stack runs on a Hetzner VPS in Nuremberg — chosen specifically for AVG/GDPR jurisdiction. Docker Compose orchestrates N8N, PostgreSQL, and Traefik with auto-renewing Let's Encrypt SSL. Daily PostgreSQL dumps and weekly VPS snapshots. We delivered the legal package alongside the technical work: NDA, sub-verwerkersovereenkomst, and TBL — signed before a single API call hit production data.

What We Built

• 11 production N8N workflows covering organization sync, order-to-deal creation, line items, pipeline stage logic, product catalog sync, product category mapping, salesperson attribution, historical import, customer migration, conditional contact sync, and webhook intake
• Trailing-12-month order history migrated with original order dates preserved in a custom field
• Full Exact product catalog mirrored into Pipedrive on a 15-minute schedule
• Status-driven pipeline logic across all verified Exact status combinations
• Salesperson GUID-to-Pipedrive-user mapping with null-fallback handling
• Webhook subscription on Exact SalesOrders topic, with 5-minute scheduled poll as fallback
• Self-hosted N8N stack on a German VPS with daily automated backups
• Full AVG/GDPR legal package delivered alongside the technical build

The Result

Zero manual data entry between Exact and Pipedrive. New Exact orders surface as Pipedrive deals within minutes. The full trailing-12-month order history landed in the system on day one — not an empty CRM. Sales reps see invoice and payment status without leaving their pipeline. Account managers run revenue reports per customer, per category, per salesperson natively in Pipedrive Insights.

The Exact API budget sits comfortably under the daily limit. OAuth tokens auto-refresh on every workflow run, so the 14-day refresh window is never at risk. There have been zero sync-loop incidents on the conditional Pipedrive-to-Exact contact path.

The integration runs on a small German VPS — and the distributor owns every workflow file if they ever want to take it elsewhere.

Technology

• N8N (self-hosted) — workflow automation engine, unlimited executions on dedicated infrastructure
• Exact Online API with community node handling OAuth 2.0 lifecycle
• Pipedrive API v2 — used directly via HTTP Request nodes for endpoints the native node does not cover
• Hetzner VPS (Nuremberg, Germany) — AVG/GDPR jurisdiction by default
• Docker Compose — orchestration for N8N + PostgreSQL + Traefik
• PostgreSQL — production database backend for N8N
• Traefik — reverse proxy with auto-renewing Let's Encrypt SSL certificates
• Exact Online webhooks — SalesOrders topic subscription for near-real-time triggers