Pharmacy Inventory

Persona

Role: Backend developer at a pharmacy chain (100+ locations, 2000 employees) modernizing their inventory and prescription fulfillment systems.

Each pharmacy location operates as a separate tenant, maintaining independent stock levels and fulfillment queues while corporate headquarters has cross-tenant visibility for purchasing and compliance reporting.

Business Problem

Pharmacies lose revenue from stockouts on high-demand medications and waste money on overstocked slow-movers. Prescription fulfillment delays frustrate patients when inventory is not synchronized with incoming orders. This scenario builds an inventory management system that tracks medication stock levels, automates reorder alerts when quantities drop below thresholds, and links prescriptions directly to available inventory.

Four-Step Application

This scenario works best as a four-step, human-in-the-loop application. The existing object model already gives this scenario a strong delivery backbone through Medication, Prescription, and SupplierOrder.

• Mission metric focus: better patient experience, lower administrative burden, and higher care quality.
• Human + AI pattern: Each step combines structured workflow data with chat assistance, background generation, document understanding, and accessible interaction patterns when they improve the experience.

Step 1. Capture demand and context

• Goal: Make it easy for the user to start the Pharmacy Inventory journey with complete, trusted context.
• Required data: Medication context such as name, ndc, quantity, and reorderPoint.
• AI support: Use chat to guide intake, generate clearer prompts, create accessible summaries, and assist with voice or vision-led capture when a form alone is not the best experience. EAI can support structured intake, chat workflows, and document-centred capture today; richer native multimodal capture may still need workflow extensions or connected services.
• Business impact: Improve completion rate, reduce first-touch effort, and raise customer or staff confidence in the UX from the very first interaction.
• EAI delivery: Model the intake as tenant-isolated object types and resources, then use actions, chat workflows, and document indexing or classification to keep the initial record complete and usable.

Step 2. Prepare the decision

• Goal: Turn the captured context into the next best action for Pharmacy Inventory without forcing the human reviewer to assemble the case manually.
• Required data: Medication state and history; Prescription fields such as patientId, dosage, refillsRemaining, and status.
• AI support: Run background summarisation, extraction, classification, recommendation drafting, and answer generation so a reviewer sees a prepared case instead of raw fragments. EAI delivers the structured records and AI workflow hooks for this today; specialised scoring engines, external rules, or advanced reasoning controls may still need integration work.
• Business impact: Reduce cycle time, improve quality and consistency, and protect the mission-critical metric before the case moves into execution.
• EAI delivery: Link records across the scenario, persist decision state as resources, and use workflow actions plus chat assistance to keep humans in control while AI prepares the work.

Step 3. Execute and collaborate

• Goal: Coordinate the actual work, handoffs, approvals, and user updates needed to deliver the service or outcome.
• Required data: Prescription actions such as fillPrescription; SupplierOrder fields such as supplier, items, totalCost, and status.
• AI support: Draft replies, produce work packets, monitor exceptions in the background, and surface the next action for each operator. EAI can orchestrate tenant-isolated records, actions, chats, and document workflows today; deeper system-to-system automation may require additional connectors or workflow capability.
• Business impact: Increase operator productivity, reduce rework across handoffs, and improve service consistency across the application journey.
• EAI delivery: Use linked object types, actions, resource updates, and workflow-triggered AI assistance so the team can execute in one model instead of splitting work across disconnected tools.

Step 4. Resolve, explain, and improve

• Goal: Close the loop with a clear outcome, an understandable explanation, and feedback that improves the next case.
• Required data: final status, outcome, audit history, and follow-up signals across Medication, Prescription, and SupplierOrder.
• AI support: Generate outcome summaries, customer-friendly answers, compliance-ready notes, management insights, and accessible follow-up content. EAI can store outcome records and support answer generation today, while richer proactive agents, advanced analytics, or channel-specific accessibility features may need additional product capability.
• Business impact: Increase trust, quality, and measurable business value through better patient experience, lower administrative burden, and higher care quality.
• EAI delivery: Keep the full audit trail in structured resources, use AI workflows to explain outcomes, and feed the resulting signals into future product, service, and operational improvement work.

EAI Platform Support By Step

EAI provides the safe service boundary for Pharmacy Inventory through Object Types, tenant-scoped resources, document processing, chat workflows, and CLI verification. For this scenario, the main records are Medication, Prescription, and SupplierOrder.

Process step	What EAI provides	Calling pattern
Step 1. Capture demand and context	Tenant-scoped intake resources for Medication context such as name, ndc, quantity, and reorderPoint. Object Type validation, starter forms, optional document intake, and chat-guided capture keep the first record complete.	Define fields in src/eai.config/object-types.ts, run eai types validate and eai types seed, create initial Medication records with useResources('Medication') or eai resources create Medication, and keep browser calls behind /api/eai/....
Step 2. Prepare the decision	Linked resource queries over Medication state and history; Prescription fields such as patientId, dosage, refillsRemaining, and status. Search, schema checks, document classification or RAG indexing, and chat summaries turn raw context into a prepared decision.	Use useResources('Medication') list/query/search patterns, verify shape with eai resources schema, use useDocuments().upload/classify/ragIndex, eai docs upload, eai docs classify, and eai docs index where supporting material exists, and send decision-support prompts through useChat(workflowId, 'chat') or eai chat send.
Step 3. Execute and collaborate	Resource updates and actions for Prescription actions such as fillPrescription; SupplierOrder fields such as supplier, items, totalCost, and status. Status changes, assignments, notes, generated work packets, and chat support keep humans in control during execution.	Model actions in the Object Type code, call client.resources.executeAction(type, id, action) or the app hook equivalent, update records through the app service layer, and verify with eai resources get/list/query.
Step 4. Resolve, explain, and improve	Outcome resources for final status, outcome, audit history, and follow-up signals across Medication, Prescription, and SupplierOrder. Audit-friendly links, indexed final documents, reporting snapshots, and answer generation make the result explainable and reusable.	Persist outcomes as resources, index final material with eai docs index or useDocuments().ragIndex, send explanation prompts with useChat or eai chat stream, and use eai resources aggregate/search for reporting checks.

Prompt, Code, And Service Pattern Mapping

The Object Type code example on this page is the implementation contract for the EAI platform services. eai-gofer should read that code as the source of truth for which resource, document, and chat calls belong in the app.

Use this prompt shape when asking eai-gofer or another coding agent to implement the scenario:

Use the EAI App Template. Model Pharmacy Inventory with Object Types for Medication, Prescription, SupplierOrder. Use useResources for records and actions, useDocuments for uploads/classification/RAG where documents appear, useChat for workflow assistance, and verify with eai types/resources/docs/chat commands. Use eai publicapi only when no named command covers the required platform call.

Scenario artifact	How it maps to EAI service calls
Four-step process	Step 1 becomes resource creation, Step 2 becomes resource query/search plus optional document or chat preparation, Step 3 becomes resource update/action calls, and Step 4 becomes outcome persistence plus explanation/reporting calls.
Object Type definitions	eai types validate, eai types seed, and eai resources schema make the model available and checkable before UI work starts.
Properties and indexes	Fields become useResources payloads, filters, list views, and eai resources create/list/query/search checks. Indexed fields should support lookup and triage, not duplicate canonical records.
Links between Object Types	Relationships become linked-resource UI, timeline context, and audit trails that app code loads through resource queries rather than separate bespoke stores.
Actions and status fields	Workflow buttons and operator transitions call resource action/update helpers, then verify state with eai resources get/list/query.
Document and chat prompts	Prompts should call the platform documents and chat patterns: useDocuments().upload/classify/ragIndex, eai docs upload, eai docs classify, and eai docs index for documents, and useChat, eai chat send, or eai chat stream for conversational assistance.

Object Types

Name	Key Properties	Links	Actions
Medication	name (text), ndc (text), quantity (number), reorderPoint (number), unitCost (number), expirationDate (date)	one-to-many → Prescription, one-to-many → SupplierOrder	adjustStock
Prescription	patientId (text), dosage (text), refillsRemaining (number), status (select: pending, filled, picked-up, cancelled), prescribedDate (date)	many-to-one → Medication	fillPrescription
SupplierOrder	supplier (text), items (text), totalCost (number), status (select: draft, submitted, shipped, received, cancelled), expectedDate (date)	many-to-one → Medication	submitOrder

CLI Workflow

1. Scaffold the project

   eai init pharmacy-inventory

2. Authenticate and pull environment

   eai login
   eai env pull --include-secrets

   If you are an external developer, see [Configuration](/docs/configuration) for login and local environment setup.

3. Define your Object Types

   Create the Medication, Prescription, and SupplierOrder types in src/eai.config/object-types.ts (see code example below).

4. Validate the type definitions

   eai types validate

   Tenant: pharmacy-inventory
   ✔ Medication — 6 props, 2 links, 1 action
   ✔ Prescription — 5 props, 1 link, 1 action
   ✔ SupplierOrder — 5 props, 1 link, 1 action
   
   ✔ All Object Types are valid

5. Seed types to the platform

   eai types seed

6. Create sample inventory

   eai resources create Medication --data '{"name": "Amoxicillin 500mg", "ndc": "0781-1964-01", "quantity": 240, "reorderPoint": 50, "unitCost": 0.45, "expirationDate": "2027-06-30"}'
   
   eai resources create Prescription --data '{"patientId": "PT-55021", "dosage": "500mg twice daily for 10 days", "refillsRemaining": 2, "status": "pending", "prescribedDate": "2026-03-01"}'

7. List current inventory

   eai resources list Medication

8. Start local development

   eai dev

Code Example

// src/eai.config/object-types.ts
export const objectTypes = {
  'pharmacy-inventory': [
    {
      name: 'Medication',
      displayName: 'Medication',
      description: 'A pharmaceutical product tracked in inventory',
      properties: [
        { name: 'name', type: 'text' as const, required: true, indexed: true },
        { name: 'ndc', type: 'text' as const, required: true, indexed: true },
        { name: 'quantity', type: 'number' as const, required: true },
        { name: 'reorderPoint', type: 'number' as const, required: true },
        { name: 'unitCost', type: 'number' as const, required: true },
        { name: 'expirationDate', type: 'date' as const, required: true },
      ],
      linkTypes: [
        { name: 'prescriptions', targetObjectType: 'Prescription', cardinality: 'one-to-many' as const },
        { name: 'supplierOrders', targetObjectType: 'SupplierOrder', cardinality: 'one-to-many' as const },
      ],
      actions: [
        {
          name: 'adjustStock',
          displayName: 'Adjust Stock',
          description: 'Increase or decrease medication quantity and log the reason',
          inputs: [
            { name: 'quantityChange', type: 'number' as const, required: true },
            { name: 'reason', type: 'text' as const, required: true },
          ],
        },
      ],
      status: 'published' as const,
    },
    {
      name: 'Prescription',
      displayName: 'Prescription',
      description: 'A medication prescription tied to inventory for fulfillment',
      properties: [
        { name: 'patientId', type: 'text' as const, required: true, indexed: true },
        { name: 'dosage', type: 'text' as const, required: true },
        { name: 'refillsRemaining', type: 'number' as const, required: true },
        {
          name: 'status', type: 'select' as const, required: true,
          defaultValue: 'pending',
          options: [
            { label: 'Pending', value: 'pending' },
            { label: 'Filled', value: 'filled' },
            { label: 'Picked Up', value: 'picked-up' },
            { label: 'Cancelled', value: 'cancelled' },
          ],
        },
        { name: 'prescribedDate', type: 'date' as const, required: true },
      ],
      linkTypes: [
        { name: 'medication', targetObjectType: 'Medication', cardinality: 'many-to-one' as const },
      ],
      actions: [
        {
          name: 'fillPrescription',
          displayName: 'Fill Prescription',
          description: 'Mark prescription as filled and decrement medication inventory',
          inputs: [
            { name: 'pharmacistId', type: 'text' as const, required: true },
          ],
        },
      ],
      status: 'published' as const,
    },
    {
      name: 'SupplierOrder',
      displayName: 'Supplier Order',
      description: 'A purchase order sent to a medication supplier',
      properties: [
        { name: 'supplier', type: 'text' as const, required: true, indexed: true },
        { name: 'items', type: 'text' as const, required: true },
        { name: 'totalCost', type: 'number' as const, required: true },
        {
          name: 'status', type: 'select' as const, required: true,
          defaultValue: 'draft',
          options: [
            { label: 'Draft', value: 'draft' },
            { label: 'Submitted', value: 'submitted' },
            { label: 'Shipped', value: 'shipped' },
            { label: 'Received', value: 'received' },
            { label: 'Cancelled', value: 'cancelled' },
          ],
        },
        { name: 'expectedDate', type: 'date' as const, required: true },
      ],
      linkTypes: [
        { name: 'medication', targetObjectType: 'Medication', cardinality: 'many-to-one' as const },
      ],
      actions: [
        {
          name: 'submitOrder',
          displayName: 'Submit Order',
          description: 'Send the purchase order to the supplier for fulfillment',
          inputs: [
            { name: 'supplier', type: 'text' as const, required: true },
            { name: 'items', type: 'text' as const, required: true },
          ],
        },
      ],
      status: 'published' as const,
    },
  ],
};

Key Takeaways

• Reorder automation: The reorderPoint property on Medication enables threshold-based alerts, so pharmacists can trigger supplier orders before stockouts occur.
• Fulfillment traceability: The fillPrescription action links prescription status changes to inventory decrements, maintaining an auditable chain from prescription to dispensing.
• Per-location tenancy: Each pharmacy location operates in its own tenant with independent stock levels, while the data model remains identical across all locations for consistent reporting.
• NDC-indexed lookups: Indexing the National Drug Code (NDC) field enables fast medication lookups via eai resources list Medication with filters, critical for high-volume dispensing workflows.