Global Snus CRM — Manufacturing & Production Tracking System

Global Snus CRM — Manufacturing & Production Tracking System The Problem

Global Snus ran their entire production tracking through disconnected spreadsheets. No audit trail, no live visibility for floor staff, no support for their bilingual (English/Lithuanian) workforce. Every batch's packaging spec — can color, lid color, batch number, barcodes — had to be tracked by hand, and there was no way to check queue status without physically asking someone.

I built a Django CRM around four core models that map directly to how the factory actually works:

Product — bilingual catalog (EN/LT) with pricing, supplier data, images, and a flexible JSON custom-fields schema so new attributes can be added without touching code.

Production Line — configurable lines with capacity limits and their own custom fields.

Manufacturing Queue Item — tracks a product through production with full packaging metadata: strength, pouch quantity, batch/expiry dates, can and lid color, sleeve type, barcode flags.

Product History — an automatic, signal-driven audit trail that snapshots and archives queue items the moment they're marked complete, keeping the active queue clean while preserving full traceability.

Bulk data import from Excel, CSV, and PDF — including intelligent column-name normalization to handle messy, inconsistent supplier file formats, and image extraction straight out of PDFs.

Live, per-line production dashboards built to run unattended on factory-floor screens, no login required, showing queue load against capacity in real time.

Modern admin UI on Django Unfold with custom branding, JSON-based custom-field editors, and thumbnail previews.

Full bilingual UX — session/cookie-based EN/LT switching across both admin and public-facing views.

LAN-first deployment: a self-contained Windows deployment via Waitress with automatic IP/firewall configuration and a guided launcher, so non-technical staff can run it without a sysadmin on call.

Replaced ad hoc spreadsheets with a structured, auditable production pipeline. Floor staff now get self-service visibility into queue status without needing admin access, and the schema can evolve through JSON custom fields without any further development work.