Cloud PWA AV Inventory App

I need a cloud-hosted inventory management web application that runs smoothly in any desktop browser and, crucially, installs as a Progressive Web App on iPhone Safari. The shop operates in two distinct inventory modes:
• a constantly rotating general stock room, and
• job-specific stock that must be tracked line-by-line against an uploaded Bill of Materials.

A Claude AI agent can be used to parse each BOM, flag incoming parts, and even suggest schema tweaks; the new front-end simply needs to call its endpoints and surface the results clearly to staff. Real-time stock updates and rich, downloadable reporting are the highest priorities, so the datastore and UI should reflect changes instantly and expose historical movement without lag.

Core deliverables:
1. Responsive browser interface with installable PWA wrapper (manifest, service worker).
2. Two-mode inventory logic tied to the Claude AI agent’s API for BOM parsing, arrival reporting, and on-the-fly schema changes.
3. Live quantity syncing and a reporting dashboard that can filter by date range, job number, or part category and export to CSV/PDF.
4. Clean, cloud-deployable codebase and concise setup docs so I can push updates or scale resources later.
5. Hosting on Netlify using their free tier; code must comply with Netlify's requirements.

Open to suggestions how to make this project as easy as possible. Show More