Inventory & Purchase Orders

Commercial AV integrators were tracking millions of dollars in staged equipment across spreadsheets. I designed our 0→1 Inventory, Purchasing & Receiving suite to connect vendor POs directly to warehouse bins, service vans, and active job schedules, unblocking enterprise pilot deals and driving an 8% lift in platform ARR and 8% year-over-year adoption growth.

My role

Product Design Lead in team of 3
Led research, systems-thinking UX, and UI, working with our PM and lead engineer.

Impact

  • +8% platform ARR
  • +8% YoY adoption

Connecting warehouse receiving to active job timelines unblocked enterprise accounts.

Real-time inventory ledger connecting warehouse stock directly to project allocations and job schedules.

The Problem: The Post-PO Blind Spot

In AV integration, an entire job site halts if a single $8,000 piece of equipment is missing on installation morning. Because D-Tools Cloud couldn't show whether delivered hardware was sitting on a warehouse shelf, staged for a job, or loaded on a service van, teams relied on Excel or third-party tools like Jetbuilt.

Goals

  • Connect purchasing, receiving, and staging in one ledger to eliminate double entry
  • Show real-time item status so project managers know what is on order, available, or already claimed by another job
  • Keep receiving fast enough for small teams while supporting serial-number tracking for larger commercial teams
  • Flag low stock automatically on high-turnover parts before installers run out on site

Research Insights

I interviewed 6 operations leads and mapped how they tracked gear outside our product. One power user maintained a 14-tab master spreadsheet with separate sheets per project, reconciliation logs, and low-stock rows highlighted by hand in yellow. It took her two hours every day to update, and counts were still out of date by noon.

  • Time sink: 2–3 hours daily reconciling stock, with 15–20% user-reported count errors
  • Workflow split: Small residential shops needed 10-second bulk check-ins, while commercial integrators needed serial numbers tied to warranties
  • Sales blocker: Sales leadership confirmed 5 massive enterprise potential accounts were frozen until we shipped post-PO staging visibility

Defining Decision: Connected Ledger vs. Simple Stock Table

The fastest engineering path was an isolated stock table where users typed in quantities manually. I pushed back because that would just move their spreadsheet chores inside our app. Instead, we tied inventory directly to purchase orders and project schedules so checking in a box at the loading dock immediately updates the project manager's install calendar.

Legacy spreadsheet workflow

Stock counts lived separately from purchasing and project schedules, so every handoff created another chance for inventory data to fall out of sync.

Third-party tool tax

Paying for separate tools that didn't integrate with D-Tools Cloud like Jetbuilt created duplicate data entry, disconnected project costs, and frequent tracking errors.

Unified inventory platform

A unified system tying POs directly to job schedules. Warehouse teams catch stock shortages early and eliminate manual count reconciliation.

System Model & Tradeoffs

The core design challenge was defining how an item moved across its lifecycle. A flat stock count fails operational teams because it doesn't explain what can actually be used today. We structured inventory around three sequential lifecycle stages, alongside an independent threshold warning for low stock:

Interactive Lifecycle Model

Click a lifecycle stage to simulate state transitions, or trigger the threshold warning to see how stock alerts coexist with allocations.

SKU: CR-DM-16X16

Crestron 16-Port 4K DigitalMedia Matrix Switcher

● Inbound: PO #4892
Current Location En Route (FedEx Freight · ETA Tomorrow)
Available for New Projects 0 units (6 expected)
Project Manager Impact Visible on calendar for install staging

Tradeoffs: Real-Time Sync vs. Shipping on Time

Early in scoping, I proposed real-time updates so that when a dock worker checked in a box of amplifiers, every open browser across the company updated instantly. Our lead engineer walked me through the cost: keeping persistent socket connections open across thousands of tenants would require a major backend rewrite, drop connections on spotty warehouse Wi-Fi, and blow past our 12-week Q4 deadline.

Instead, we updated the UI immediately for the person making the change and polled in the background for everyone else. If two project managers tried to claim the last video switcher at the exact same moment, a conflict dialog showed who got it first and offered a one-click PO request to order a replacement.

Balancing Fast Receiving with Serialization Audits

Residential installers receive dozens of commodity parts (Cat6 spools, HDMI cables, brackets) in minutes; forcing them through serial-number modals would bring their loading dock to a halt. Commercial contractors, on the other hand, need serial numbers and MAC addresses recorded for warranties and compliance audits.

For day-one physical dock operations, receiving clerks worked from desktop terminals at the warehouse intake bench paired with handheld USB or Bluetooth wedge barcode scanners (deferring mobile camera scanning to post-MVP). Scanning a barcode populated the active line item immediately without requiring manual keyboard entry.

I designed a dual-track receiving flow: a fast quantity stepper by default for bulk parts, paired with an optional serial-capture drawer for high-value gear (this path is determined by user settings and permissions):

Illustrative receiving flow
Cat6 Plenum 1000ft Bulk Cable (Blue) PO #4109 · Distributor: Liberty AV Solutions
Qty Received:
8 / 8
✓ All 8 Received

Quantity-first default: Zero required modals. Installers tap once to confirm bulk arrival and immediately load vans for the day.

Sony VPL-XW5000 4K Laser Cinema Projector Unit Cost: $5,999 · Warranty: 3-Year Commercial
✓ Serial Verified
Assigned Van: Service Van #3 (Tech: Marcus R.) Audit Trail: Warranty Registered to Job #309

Asset-level audit layer: Enforces serialization for high-value equipment without slowing down routine commodity receiving.

Shipping on a 12-Week Deadline

To hit our December deadline, we reused existing data tables, slide-over drawers, and status badges from our D-Tools component library. Skipping custom layout work saved two full sprints for the hardest edge cases: partial shipments, damaged returns, and split backorders.

When suppliers delivered incomplete orders, line items received a "Partially Received" status. This kept remaining quantities on backorder while immediately releasing checked-in units to project managers for staging and van assignment.

Advanced Inventory setup modal: converting stock to serialized assets, logging serial numbers, and printing QR labels.
Inventory automation rules for automatic check-in, conversion, and project reservations
Automation rules letting managers configure automated check-ins upon PO receipt and auto-reserve stock for scheduled installations.

Validation: Cutting Receiving from 4mins to 28s

In Round 1, our first receiving prototype forced warehouse staff to scan serial numbers for every single line item. Residential testers took over four minutes to check in an eight-item delivery, immediately rejecting anything that slowed down morning dock receiving.

By Round 3, separating bulk items from serialized gear (though this is always optional) cut median receiving time to 28 seconds, while commercial teams still captured high-value equipment without missing compliance steps.

Impact: Enterprise Deals and Recovered Warehouse Hours

The release drove an 8% lift in platform ARR and 8% year-over-year adoption growth, while operations leads recovered an estimated 10–15 hours a week previously spent on manual stock counts. During pilot rollout, one commercial contractor found over $42,000 in 'missing' equipment sitting untracked on overflow racks, avoiding a duplicate purchase order.

+8% Platform ARR lift
+8% YoY adoption growth
28s Median dock check-in
10–15h Saved weekly per ops lead

Lessons & Next Steps

In warehouse software, trust is binary. If a technician drives to a job site and the four switches the app said were in stock aren't in the van, they stop using the app and go back to pen and paper. This feature succeeded because every number explained its history: where the item came from, which project had it claimed, and when the replacement was arriving.

What comes next:

Once teams trusted the baseline counts, the next logical steps were mobile barcode scanning in the warehouse and auto-generating reorder POs when stock hits minimums. We held those back from the MVP on purpose to make sure the foundation was rock-solid first.