Tech Solutions / 2026
Inventory Lineage Platform
Turned messy inventory spreadsheets into a Django and Postgres platform with raw staging, lineage tracking, Woo imports, and admin-first CRUD.
Client
Parts + Product Distributor
Technologies
Django 5
PostgreSQL 16
Docker
Python 3.12
pandas
openpyxl
WooCommerce Imports
Lineage-first
Data model
Django + Postgres
Platform
Inventory trust
Primary gain
Tech Solutions
Project Type
01 – Challenge
The problem
Inventory and parts data lived in spreadsheets that were hard to trust, hard to normalize, and nearly impossible to evolve into a real operational system without losing the trail back to the raw source.
02 – Approach
The strategy
Built the data model around lineage from day one. Instead of jumping straight to a polished interface, the platform preserved raw imports, staging layers, and import logs so each cleaned record could still be traced back to its source.
03 – Solution
What was built
Delivered a Django application with Postgres, Docker-based local runtime, admin CRUD, import pipelines, lineage-aware staging, and WooCommerce import commands for moving inventory data into a controlled web-accessible system.
04 – Outcomes
The results
Moved inventory knowledge out of fragile workbook-only workflows
Created a cleaner path from raw data to usable operational records
Improved trust by preserving lineage instead of hiding cleanup steps
Established a platform foundation for future BOM and inventory management work
05 – The Story
How the work actually came together
The real challenge was trust. If the inventory data was cleaned without preserving where it came from, the new system would immediately start losing credibility.
That is why the project used raw and staging layers instead of pretending the spreadsheet could be normalized in one perfect pass.
Once lineage was protected, it became much easier to build the CRUD surface, import tools, and downstream Woo workflows on top of it.
That gives the business a data system it can actually grow, audit, and refine over time.
What mattered
The point was not to install software and walk away. The point was to create an operating layer the business could trust, improve, and own after handoff.
That meant documenting the system, making the workflow legible, and removing the extra work that shows up when teams are forced to manage operations across disconnected tools.
Next project
RV Inventory Sync Automation
Continue through the work to see another example of strategy, systems, and execution translated into a better operating result.
Think of me as your Director of Infrastructure and Operations à la carte. With extensive experience and a hands-on approach, I provide customized solutions to help your business grow and thrive.
Navigate
Contact
Availability
Currently accepting new engagements
© 2026 OCDATA – Michael Bennett
Currently accepting new engagements