Software & Capabilities - PartVault & Pick-N-Light

Core Software & Cloud Architecture

Infrastructure & Storage

Multi-Tenant Isolated Database

Each user account receives a completely separate SQLite database instance (data/tenant_usr_xxx.db), guaranteeing zero cross-user data leakage and total privacy.

Individual tenant database files per user
Automated database persistence and local snapshots
Isolated inventory, vendors, and tool checkouts

Google Drive & Dropbox Sync

Automated cloud drive file routing. Documents are organized into PartsVault/Drawings/... and PartsVault/Specs/... with Production, Development, and Reference subgroups.

Enforced standardized folder tree hierarchy
Automatic document hyperlink file synchronization
Intelligent exclusion of non-document web links

Upload & View 2D & 3D Documents Online — No External Viewer Needed

Upload 2D engineering documents and multiple 3D CAD models per record, then view and inspect them online directly in your browser with no external viewer needed. View PDF datasheets, high-res images, and spreadsheets alongside interactive 3D WebGL models (OBJ, STL, STEP, GLTF, 3MF) with full 360° orbit rotation, zoom, wireframe toggle, and multi-angle inspection.

Multiple 3D Document Uploads: Attach multiple 3D files (OBJ, STL, STEP, GLTF, 3MF) per document record
No External Viewer Needed: Native in-browser WebGL 3D orbit, pan, zoom, and wireframe controls
Unified 2D & 3D Workflow: Multi-tab viewer for primary 2D schematics, secondary specs, and 3D CAD models

Assembly BOM & Pick Lists

Create complex multi-part component assemblies. Generate batch pick lists with automatic shortage calculations and LED light triggers during physical stock pulls.

Batch quantity requirements calculation
Automated inventory deduction upon build completion
Printable pick list sheets with bin locations

3D Print Materials Manager

Dedicated tracking for FDM filament spools (PLA, PETG, ABS, TPU) and SLA resin bottles. Tracks remaining grams/ml, empty spool tare weights, and print profiles.

Manufacturer & material print settings preset matrix
Speed, nozzle temps, bed temps, & exposure times
Physical 3/4" x 1.2" tag printing with QR codes

COMING SOON RFID INTEGRATION

Tool Checkout & Asset Tracking

Manage shared lab tools, diagnostic equipment, and field laptop devices. Tracks technician checkouts, serial number photos, bills of sale, and network IP parameters.

Mandatory S/N photos & bill of sale document uploads
Computer specifications (Admin Logins, IP, Subnet, IMEI)
Technician checkout history & return date logs

Advanced System Capabilities & Automation

Automation & Insights

Automated Reorder Advisory

Monitors stock levels against minimum threshold points. Automatically groups low-stock items by supplier and calculates lead-time reorder quantities and purchase order costs.

Proactive low-stock threshold alerting
Automatic grouping by preferred vendor
Purchase order cost & lead-time calculation

Dynamic 20-Field Customization

Customize visible table list columns across 20 distinct data fields. Rename User 1, User 2, User 3, and User 4 fields to custom labels like Thread Pitch or Wire Gauge.

Toggle and reorder 20 granular table columns
Customizable User 1 through User 4 header names
Persistent view state saved per tenant account

Vault Industry Config Templates

Load instant configuration presets for Fasteners, Electronics, Electrical, or Blank custom projects, or export your entire setup to a vault_config.json file.

Pre-packaged industry template presets
One-click schema and taxonomy initialization
Complete JSON export & import portability

Google SSO & Multi-Tenant Access

Seamless single-sign-on using Google credentials, plus isolated multi-tenant database authentication and role-based access control for team members.

One-click OAuth login via Google Identity
Role-based permissions per team technician
Secure JWT session token encryption

CSV Spreadsheet & Backup Export

Export full inventory databases to CSV spreadsheets or complete JSON backup files for offline archiving and migration between systems.

Instant spreadsheet exports of parts, BOMs, and bins
Full point-in-time JSON database snapshots
Offline data archival and disaster recovery

Usage & Velocity Analytics

Track 30-day and 90-day part consumption velocity, calculated daily usage rates, estimated days of supply remaining, and vendor spend history analytics.