Unreliable stock & billing — spreadsheet web app to manage pharmacy inventory & sales

Independent and small-chain pharmacies—roughly 1.5 million outlets globally—routinely struggle with unreliable stock records, manual billing errors, and expiry-driven waste that erode margins and customer trust. These pain points are especially acute for operators still using desktop software or ad-hoc spreadsheets, where reconciliation, batch tracking and real-time visibility are time-consuming or nonexistent. A practical product would be a spreadsheet-style web app that preserves the familiar rows-and-formulas UX while adding cloud sync, barcode scanning, batch/expiry tracking, simple POS and automated billing reconciliation, plus optional AI-driven demand forecasting for replenishment. Built on a no-code/low-code stack (e.g., Apps Script + serverless endpoints) it could be deployed quickly, priced toward a $3K ACV customer profile and address a $4.5B TAM that scores 88/100 on market attractiveness with a revenue-potential estimate of 82/100. Current trends—faster SaaS adoption among independents, easier no-code integrations and accessible ML models—lower buyer friction and technical barriers for this approach. This idea can stand out by minimizing onboarding friction (keep the spreadsheet metaphor), offering pharmacy-specific features like batch expiry workflows and distributor integrations, and by delivering measurable wins (conservative estimates: 10–30% fewer stock-outs/expiries depending on data quality). Key challenges are real: the market is fragmented, incumbents and local POS vendors present medium competition, integrations and regulatory/compliance requirements add engineering and support costs, and customer acquisition will likely need regional sales or partnerships rather than pure self-serve.