1 Dashboard
2 Item List
3 Item Detail
4 Add/Edit
5 Scanner
6 Purchase Orders
7 Suppliers
8 Reports
Inventory Dashboard
9:41
Inventory
3 Items Low Stock
Tap to view items needing reorder
247
Total Items
3
Low Stock
$18.4K
Value
Categories
Plumbing
86 items · $6,240 value
Electrical
62 items · $4,180 value
HVAC
54 items · $5,120 value
General
45 items · $2,860 value
Quick Actions
Add Item
Scan
Order

InventoryDashboard overview with stats, categories, and quick actions

useQuery(api.inventory.items.getStats)


Item List
9:41
All Items
All
Plumbing
Electrical
HVAC
General
Sort by: Name A–Z
Copper Pipe 1/2"
SKU-PL-0042 · Plumbing
36 in stock · Reorder at 10
$8.50
/ft
14/2 Romex Wire
SKU-EL-0118 · Electrical
14 in stock · Reorder at 20
$0.75
/ft
R-410A Refrigerant
SKU-HV-0031 · HVAC
2 in stock · Reorder at 5
$145.00
/tank
PVC Elbow 90°
SKU-PL-0089 · Plumbing
120 in stock · Reorder at 25
$2.10
/ea
Sheet Metal Screws
SKU-GN-0201 · General
300 in stock · Reorder at 100
$12.50
/box

ItemList with search, category filters, stock level bars

useQuery(api.inventory.items.list) + useInventory()


Item Detail
9:41
Item Detail
Copper Pipe 1/2"
Plumbing
SKU-PL-0042
782940183625
Current Stock
36
Reorder Point
10 units
Pricing & Supplier
Unit Cost $8.50 /ft
Supplier Ferguson Supply
Last Ordered Feb 12, 2026
Usage History (6mo)
Sep Oct Nov Dec Jan Feb
Linked Jobs
Kitchen Sink Replacement
Used 12 ft · Feb 18
Basement Bathroom Rough-In
Used 28 ft · Feb 10
Water Heater Install
Used 8 ft · Jan 29

ItemDetail with stock adjustment, supplier info, usage history

useQuery(api.inventory.items.getById) + useMutation(api.inventory.items.adjustStock)

Add / Edit Item
9:41
Add Item
Save
Tap to add photo
Item Name
Copper Pipe 1/2"
SKU
SKU-PL-0042
Auto-generated from category + sequence
Category
Plumbing
Unit Cost
$8.50
/ft
Supplier
Ferguson Supply
Reorder Point
10
Minimum Order Quantity
25
Notes
Type M copper, suitable for residential water supply…
Save Item

ItemForm with photo upload, auto-SKU, category picker, supplier dropdown

useMutation(api.inventory.items.create) | useMutation(api.inventory.items.update)


Barcode Scanner
9:41
Scan Barcode
Align barcode within the frame
PVC Elbow 90°
SKU-PL-0089 · 120 in stock
Enter code manually
Recent Scans
Copper Pipe 1/2" · 9:38 AM Found
Unknown item · 9:35 AM New

BarcodeScanner camera viewfinder with scan overlay and history

expo-camera + useQuery(api.inventory.items.getByBarcode)


Purchase Orders
9:41
Purchase Orders
Active (4)
Completed (12)
PO-2026-0047
Ferguson Supply
Shipped
8 items
$1,240.00
Expected delivery: Feb 28, 2026
PO-2026-0046
Winsupply Ohio
Ordered
5 items
$680.50
Expected delivery: Mar 04, 2026
PO-2026-0045
Home Depot Pro
Draft
3 items
$320.00
Created Feb 22, 2026
PO-2026-0044
Ferguson Supply
Received
12 items
$2,150.00
Received Feb 20, 2026

PurchaseOrderList with active/completed toggle, status badges, tracking

useQuery(api.inventory.purchaseOrders.list) + usePurchaseOrders()


Supplier Directory
9:41
Suppliers
Ferguson Supply
Preferred
(330) 555-0142 · orders@ferguson.com
64 items
2–3 days avg
4.5
Winsupply Ohio
(330) 555-0287 · sales@winsupply.com
38 items
3–5 days avg
4.0
Home Depot Pro
(330) 555-0410 · pro@homedepot.com
22 items
1–2 days avg
4.8
Grainger
(330) 555-0519 · orders@grainger.com
15 items
2–4 days avg
3.5
Add New Supplier

SupplierDirectory with contact info, item count, delivery avg, ratings

useQuery(api.inventory.suppliers.list)


Usage Reports
9:41
Usage Reports
7 Days
30 Days
90 Days
YTD
Cost by Category
$4.2K
Total
Plumbing (32%)
Electrical (23%)
HVAC (23%)
General (22%)
Top Consumed Items
Copper Pipe
142 ft
14/2 Romex
320 ft
PVC Fittings
87 ea
Sheet Screws
4 box
R-410A
3 tank
Usage by Job
Kitchen Sink Replacement
6 items used · Feb 18
$284
Basement Bathroom Rough-In
14 items used · Feb 10
$1,120
HVAC Condenser Swap
4 items used · Feb 05
$890
Water Heater Install
3 items used · Jan 29
$456
Export Report

UsageReports with pie chart, top consumed bars, job-linked breakdown

useQuery(api.inventory.reports.getUsage) + useQuery(api.inventory.reports.getCostByCategory)


Data Architecture

Schema Tables

inventoryItems // SKU, barcode, stock, cost
inventoryCategories // Plumbing, Electrical, etc.
purchaseOrders // PO#, supplier, status, total
purchaseOrderItems // Line items per PO
suppliers // Name, contact, rating
usageLog // Item + job + qty consumed
stockAdjustments // Audit trail for +/- changes

Queries

getStats // totalItems, lowStock, value
listItems // search, category, sort
getItemById // full detail + usage
getByBarcode // scanner lookup
listPurchaseOrders // active/completed
listSuppliers // with item counts
getUsageReport // period, top items
getCostByCategory // pie chart data

Mutations

createItem
  args: name, sku, category, cost, supplier
updateItem
  args: itemId, partial fields
adjustStock
  args: itemId, delta, reason
createPurchaseOrder
  args: supplierId, items[], notes
updatePOStatus
  args: poId, status // draft→ordered→shipped→received
createSupplier
  args: name, email, phone, rating
logUsage
  args: itemId, jobId, quantity

Hooks

useInventory() // items, stats, search
  returns: items, stats, search, filters

usePurchaseOrders() // PO list + CRUD
  returns: orders, create, updateStatus

useBarcodeScan() // camera + lookup
  returns: scan, result, history

PO Statuses

draft // Being assembled by contractor
ordered // Submitted to supplier
shipped // Supplier dispatched
received // All items received + stocked
cancelled // PO cancelled before ship

Stock Level Thresholds

// Visual indicators
green → stock > 2x reorderPoint
yellow → stock ≤ 2x reorderPoint
red → stock ≤ reorderPoint

// Alert triggers
lowStock → notification + badge
outOfStock → urgent alert + PO suggestion
Inventory & Items
9:41
Inventory & Items
Categories
555
Total Items
12
Low Stock
$49.5K
Total Value
8
Pending Orders
Categories
Roofing Materials
142 items — $24.5K
142
Siding & Trim
89 items — $18.2K
89
Fasteners & Hardware
324 items — $6.8K
324
Orders & Suppliers
9:41
Orders & Suppliers
Details
Title
ABC Supply — Roofing Materials
Description
30-year architectural shingles, underlayment, flashing, and ridge caps.
Configuration
Low Stock Alerts
Auto-Reorder
Preview
Purchase Order #PO-4521
Order details with quantities, unit costs, delivery date, and supplier terms.
Performance
96%
In Stock
-7%
Cost Saved
$6.2K
On Order
Inventory Dashboard
https://app.3bids.io/contractor/inventory
3Bids
Inventory ⌘1
Scanner ⌘2
Orders ⌘3
Suppliers ⌘4
Reports ⌘5
MK
Mike Kowalski
Contractor
Settings ⌘,

Inventory Dashboard

1,247
Total SKUs
$124.5K
Inventory Value
18
Low Stock Alerts
97%
Fill Rate
Recent Activity
Roofing Materials
142 items — $24.5K
Siding & Trim
89 items — $18.2K
Fasteners & Hardware
324 items — $6.8K
Performance