← All work

Specialty pharmacy & retail

Operations toolkit and AI analyst on NetSuite

One web app for store and back-office staff, with PO document capture, Zebra shelf labels, about 12 operations dashboards and an AI analyst that answers questions from live NetSuite data.

  1. Question
  2. Gemini
  3. SuiteQL tool
  4. Answer from live NetSuite
Operations toolkit and AI analyst on NetSuite
IllustrativeIllustrative: asking Merz AI about replenishment.
Client
Merz Apothecary ↗
Specialty pharmacy & retail
Stack
FastAPI, React, TypeScript, SuiteQL, NetSuite OAuth 2.0 M2M, PrintNode, Gemini, Docker, Railway

Results

  • About 12 dashboards, tested against the NetSuite saved searches they replace

The problem

Staff attached invoices and photos to POs by hand, printed shelf labels from item receipts, and relied on scattered saved searches for replenishment and transfers.

What I built

  • PO attachments. Search a PO and upload invoices, documents and item photos.
  • Shelf labels. Labels from item receipts print to Zebra printers through PrintNode, with layouts and a preview.
  • About 12 dashboards covering finance, sales, daily operations, revenue scorecard, replenishment, overage, open shipping orders, transfers and fulfillment. Automated tests check them against NetSuite.
  • Merz AI. A chat analyst runs SuiteQL against live NetSuite data, with separate finance, sales and operations contexts across subsidiaries.