DDeskSolutions

Developer Integration Guide

This guide is designed for technical teams looking to integrate PrintShop Manager with external accounting software (e.g. QuickBooks, Xero), custom CRM portals, or automated inventory tracking nodes.

1. Cloud Webhook Integrations

When an operator updates a job status on the shop floor, the local sync module publishes an HTTPS payload to your configured webhook endpoints.

Webhook Event Payload Example:

{
  "event": "job.status_updated",
  "timestamp": "2026-07-11T16:16:00Z",
  "data": {
    "orderId": "ORD-9042",
    "jobName": "Catalog Print Run",
    "oldStatus": "Prepress",
    "newStatus": "Printing",
    "operatorId": "OP-401",
    "pressName": "Digital Press 04"
  }
}

To configure webhooks, log in to your cloud dashboard, navigate to Developer Settings > Webhooks, and click Add Endpoint.

2. Local Database Schema

If you operate in air-gapped secure mode, you can audit records directly inside the local SQLite database.

Core SQLite Tables:

  • jobs: Stores order IDs, operator logs, press targets, and sheet count logs.
  • inventory: Tracks paper rolls, ink levels, reorder thresholds, and batches.
  • estimations: Stores pricing sheets, coatings, PMS colors, and quote records.

3. Database Sync Protocol

The synchronization module uses a SQLite log-based queue to ensure data is updated reliably even when connections drop:

  1. Local Writes: Transactions are written to local tables and added to sync_queue.
  2. Sync Daemon: A background thread checks for connection availability.
  3. Encrypted Push: Transactions are encrypted using AES-256 and pushed to the cloud server.
  4. Acknowledge Check: The cloud server confirms receipt, and the daemon clears the transaction from the local sync_queue.