Skip to content

Add batch inventory audit mode #6

@akifbayram

Description

@akifbayram

Problem

Users performing periodic inventory checks (e.g., verifying all items are still in their bins) have no structured workflow. They must open each bin individually and mentally compare physical contents with the app.

Proposed Solution

Add a guided audit mode that walks users through bins, letting them confirm, flag, or update contents.

API

  • POST /api/locations/:id/audits — create audit session: { bin_ids?: string[], area_id?: string } (defaults to all bins)
  • GET /api/locations/:id/audits/:auditId — audit status and progress
  • PUT /api/locations/:id/audits/:auditId/bins/:binId — record result: { status: "confirmed" | "flagged" | "updated", notes?: string, items?: string[] }
  • POST /api/locations/:id/audits/:auditId/complete — finalize audit

Data Model

  • audits table: id, location_id, started_by, started_at, completed_at, total_bins, confirmed_count, flagged_count, updated_count
  • audit_results table: audit_id, bin_id, status, notes, reviewed_by, reviewed_at

UI/UX

Starting an Audit

  • "Audit" button in the bin list page action menu
  • Pre-audit dialog: select scope (all bins, specific area, or manual selection)
  • Shows estimated count: "Audit 47 bins in Kitchen"

Audit Mode

  • Full-screen focused view, one bin at a time
  • Shows: bin name, area, icon, current items list, photos
  • Progress bar at top: "12 / 47 bins reviewed"
  • Action buttons:
    • Confirm (green checkmark) — contents match, move to next
    • Flag (yellow flag) — mark for follow-up, optional note, move to next
    • Edit (blue pencil) — inline edit items/notes, then save & move to next
    • Skip — skip for now, come back later
  • Swipe gestures: left to flag, right to confirm
  • "Exit Audit" with confirmation if incomplete

Audit Summary

  • Shown on completion: confirmed / flagged / updated / skipped counts
  • List of flagged bins with notes for follow-up
  • Option to export summary

Scope

  • Single-user audits (no multi-user concurrent audit tracking in v1)
  • Audit history stored for reference but no trend analysis
  • QR scan shortcut: scan a bin's QR during audit to jump to it

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions