Overview
SISL Optima Connector is a two-component plugin connecting Magento 2.4.x to Comarch ERP Optima running on your Windows Server.
What you get
Sisl_Optima— Magento module (PHP 8.2/8.3) with admin panel, cron, order observerSisl.Sync.Service— .NET 8 microservice installed as a Windows Service on the Optima box; reads Optima SQL Server, exposes HMAC-signed REST
What it does
| Direction | Synced | Default frequency |
|---|---|---|
| Optima → Magento | products (code, name, EAN, unit, price) | every 1h (cron, dropdown in admin) |
| Optima → Magento | stock levels (from PZ/PW/MM documents) | every 15 min |
| Magento → Optima | orders (FA) — TBD v0.4.0, in v0.3.x the payload is dumped to xml-out/ but no invoice is created in Optima |
— |
| license.sisl.pl → Magento | license verification | daily 03:00 |
Who needs this
Polish-market Magento shops using Comarch Optima for accounting and inventory who are tired of expensive SaaS-only integrations (5–15k zł/year). Self-hosted, 300 zł net / month subscription, the code stays inside your network, cancel anytime.
What it won't do (v0.3)
- Realtime push Optima → Magento — sync is pull-based via cron (price changes visible after next tick)
- Deletion of products marked as "skasowane" in Optima — they stay in Magento as orphans
- Full bidirectional customer sync Magento → Optima (v0.3 ships Optima → Magento only — the Magento address book is not pushed back to Optima)
v0.3 added these features (opt-in, default OFF; details in Configuration → 5. v0.3):
- Multi-store mapping — different Optima pricelists + SKU prefixes per website
- Order updates / full lifecycle — auto-create Magento Invoices/Shipments from Optima FA/PAR/WZ
- Bidirectional customer sync — Optima
KntKarty→ Magentocustomer_entity
Technical requirements
- Magento 2.4.7+, PHP 8.2 or 8.3
- Comarch ERP Optima 2024.1+ with SQL Server access (
Trusted_Connectionfrom local account) - Windows Server 2019+ for the microservice (.NET 8 runtime bundled in the binary)
- Network connectivity between shop and Optima server: LAN, IPSec/OpenVPN, or Tailscale (recommended)
- Outbound HTTPS to
license.sisl.plfrom the Optima server (for license checks)
Next: Architecture →