Alfred Digital Education

SPOC Inventory

Know every device. Every room. Every school.

A technology asset inventory manager built for NYC public school SPOC coordinators. Scan barcodes, photograph labels, track device condition and assignment by room, import from spreadsheets, and export filtered reports — all from any device, anywhere in the building.

Next.jsTypeScriptSupabasePostgreSQLTailwind
Features

Built for the hallway, not the office

Designed for coordinators who track hundreds of devices across multiple floors — on a phone, mid-walk.

Barcode & QR Scanning

Scan asset tags or serial numbers directly from a phone camera. The app auto-identifies the field being scanned and flips to the next target automatically.

AI Vision Extraction

Can't find a barcode? Photograph the device label and Claude AI extracts the asset tag, serial number, and model — no manual typing required.

Floor Plan & Room Management

Map your school's rooms on a visual floor plan. Assign devices to rooms, resize tiles on the grid, and see your inventory laid out spatially.

CSV & Spreadsheet Import

Bulk-import existing inventory from a Google Sheet or Excel file. A step-by-step wizard maps your columns and flags issues before committing.

Filtered CSV Export

Export your current inventory view — filtered by status, search term, or school — to a dated CSV file in one click.

Full-Text Search

Search across asset tags, serial numbers, models, and room names instantly. Postgres full-text search keeps results fast even at scale.

Device Model Library

Maintain a school-wide catalog of device models with photos. When scanning, the app matches against known models to pre-fill fields.

Role-Based Access

SPOC coordinators manage their own school's inventory. Row-level security in Postgres ensures no cross-school data leaks.

How It Works

Inventory in hand, not in a binder

1

Log in with your school email — a magic link lands in your inbox, no password needed.

2

Import your existing spreadsheet inventory via the CSV wizard or Google Sheets link.

3

Set up your floor plan: add floors, draw rooms, and assign them types.

4

Walk the building with your phone — scan barcodes or photograph labels to log devices.

5

Export a filtered report anytime for audits, budget requests, or end-of-year submissions.

Need an inventory tool for your organization?

We can build a custom asset tracking solution — tailored to your workflow, your devices, and your team.

Let's Talk