SIMS: Custom Odoo Inventory System
ArchivedAn archived Odoo 19 repair-shop system for assets, jobs, logistics, labels, photos and access control.
At a glance
- Outcome: Modeled a medical-equipment refurbisher’s assets, jobs, shipments, purchasing, labels and photos in Odoo 19, replacing a legacy inventory app, spreadsheets and manual steps.
- Status: Archived. The modernization push was cut for scope and time.
- Role: Started as a team effort; I built most of the system.
- Stack & libraries: Python, Odoo 19, OWL, PostgreSQL, qrcode, Pillow, boto3, S3-compatible photo storage and Odoo.sh deployment.
- Source: Private employer tooling; this page is the case study.
- What outlasted it: The label-printing integration, which I extracted into Repair Shop Automation.
- Limitations: Never reached production. Demonstrates data-model work at scale, not a shipped system.
Modules
- Built
simsfor assets, models, locations, repair jobs, shipments, receipts, POs, printing and reporting. Added cron jobs, sequences, record security and portal rules. - Built
testbed_trackerfor warehouse test beds, a compatibility matrix and saleable-unit gap analysis. Builtcompat_datafor admin-curated ingestion with staged review and approval-only writes. - Built
incentivisionfor incentives, bounties, awards and a storefront with approvals. Routed access through theorg_groupsseniority-and-department permission hierarchy. - Added
mail_ext,ui_componentsand a Xero bridge for messaging-menu history, shared OWL backend primitives and accounting exports.