← All projects

SIMS: Custom Odoo Inventory System

Archived

An archived Odoo 19 repair-shop system for assets, jobs, logistics, labels, photos and access control.

OdooPythonERPPostgreSQLOWL

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 sims for assets, models, locations, repair jobs, shipments, receipts, POs, printing and reporting. Added cron jobs, sequences, record security and portal rules.
  • Built testbed_tracker for warehouse test beds, a compatibility matrix and saleable-unit gap analysis. Built compat_data for admin-curated ingestion with staged review and approval-only writes.
  • Built incentivision for incentives, bounties, awards and a storefront with approvals. Routed access through the org_groups seniority-and-department permission hierarchy.
  • Added mail_ext, ui_components and a Xero bridge for messaging-menu history, shared OWL backend primitives and accounting exports.