ml-connector
Exact OnlineAmazon Seller Central

Exact Online and Amazon Seller Central integration

Exact Online runs your accounting, purchasing, and inventory. Amazon Seller Central runs your vendor-fulfillment orders and settlements. Connecting them keeps purchase data synchronized and payment reconciliation current. Purchase orders created in Exact Online can be matched against Seller Central vendor orders, invoices from both systems can be reconciled, and vendor payment events from Seller Central can be posted back into Exact Online's general ledger for accounting closure without re-keying. ml-connector bridges the two OAuth 2.0 systems and handles the different sync models each platform supports.

How Exact Online works

Exact Online is a cloud ERP and accounting platform exposing purchase orders, purchase invoices, purchase invoice lines, GL accounts, cost centers, cost units, items, accounts, and transaction lines through a REST API with OData v3 query syntax. Authentication uses OAuth 2.0 Authorization Code Grant with 10-minute access tokens and 30-day rotating refresh tokens. Exact Online webhooks push significant entity changes via HTTP POST with HMAC-SHA256 signatures, but webhook payloads contain only entity keys and must be hydrated via separate REST requests. Division ID is required for all API calls and must be fetched from the /api/v1/current/Me endpoint.

How Amazon Seller Central works

Amazon Seller Central exposes orders, order items, vendor purchase orders, vendor invoices, financial events, shipment events, refund events, and inventory via the Selling Partner API, a REST service with region-specific endpoints. Authentication uses OAuth 2.0 via Login with Amazon, with 1-hour access tokens granted per refresh_token grant. Amazon Seller Central does not support direct HTTP webhooks; push notifications require AWS EventBridge or SQS. Financial settlement events and invoice submission results cannot be pushed and must be polled via the Finances API and Orders API on a schedule. Access tokens are limited to 2048 bytes.

What moves between them

Purchase orders and invoices flow bidirectionally. Exact Online purchase orders sync to Seller Central vendor purchase orders on update. Seller Central vendor invoices flow back to Exact Online as purchase invoice lines, mapped to the GL accounts and cost centers defined in Exact Online. Vendor payment and settlement data from Seller Central is polled on a daily or weekly schedule and posted as journal entries into Exact Online's GL for accounting reconciliation. Invoices older than 2 years are not returned by Seller Central API.

How ml-connector handles it

ml-connector maintains both OAuth 2.0 token sets encrypted, refreshing access tokens on 401 responses and rotating Exact Online refresh tokens on each use. Exact Online division ID is fetched and cached at connection time. For outbound flow, when an Exact Online purchase order is updated, ml-connector posts it to Seller Central's vendor purchase order endpoint, mapped to the vendor account in Seller Central. For inbound flow, ml-connector polls Seller Central's Orders API, Finances API, and vendor invoice endpoints daily, hydrating the webhook notifications from Exact Online when they arrive, and posts settlement journal entries into Exact Online's GL with line items allocated to the matching cost centers. Because Seller Central's financial settlement events cannot be pushed, polling is mandatory on that path and is not optional. Rate limiting is handled with exponential backoff. Every record carries transaction timestamps and source references so manual adjustments in Exact Online can exclude already-synced periods.

A real-world example

A European SME manufacturer uses Exact Online for purchasing and accounts payable, and sells finished goods to distributors and retailers via Amazon Seller Central. Before integration, the procurement team managed purchase orders in Exact Online and vendor invoices in Seller Central separately, leading to duplicate invoices and reconciliation delays at month-end. With Exact Online and Seller Central connected, purchase orders and vendor invoices sync automatically, settlement payments from Seller Central flow into Exact Online's payables ledger, and the accounts payable team closes the books without manual matching and re-entry.

What you can do

  • Sync Exact Online purchase orders to Seller Central vendor purchase orders, keeping both systems current on procurement status.
  • Pull vendor invoices from Seller Central back into Exact Online as purchase invoice lines allocated to the correct GL accounts.
  • Poll Seller Central financial settlement and vendor payment events daily and post them into Exact Online's general ledger for automatic accounts payable reconciliation.
  • Bridge OAuth 2.0 tokens on both sides, refresh on expiry, and rotate Exact Online refresh tokens per its 30-day requirement.
  • Handle the asymmetry of Exact Online webhooks and Seller Central's polling-only settlement data with a single unified audit trail.

Questions

Which direction does data move between Exact Online and Amazon Seller Central?
Purchase orders and invoices move bidirectionally. Exact Online purchase orders sync to Seller Central vendor purchase orders. Seller Central vendor invoices and settlement events flow back into Exact Online as purchase invoice lines and GL postings. Because Seller Central does not support push notifications for financial settlements, the settlement data is polled rather than pushed.
Why does ml-connector poll Seller Central if Exact Online supports webhooks?
Exact Online webhooks are supported for purchase orders and invoices, but Seller Central does not offer direct HTTP webhooks; it requires AWS EventBridge or SQS. More importantly, Seller Central's financial settlement events and vendor invoice submission results cannot be delivered via any push mechanism and must be polled via the Finances API and Orders API on a schedule.
How are cost centers and GL accounts mapped between the two systems?
Cost centers and GL accounts are configured once per customer in Exact Online. When vendor invoices flow from Seller Central back into Exact Online, ml-connector maps each line item to the pre-configured GL account and cost center for that vendor, ensuring invoice lines post to the correct accounting dimension. Settlement payments are allocated to a single GL account per payment type configured at setup time.

Related integrations

Connect Exact Online and Amazon Seller Central

Free to use. Add your credentials, ping your real systems, and see if we fit.

Get started