Product Overview

Verified Against source code Version 3.0.0 Last updated: September 2026

What AquaDealers Is

AquaDealers is a vertical SaaS platform purpose-built for aqua feed and medicine dealers in India. It replaces paper billing books, Excel sheets, and WhatsApp-screenshot accounting with a single web application that handles billing, farmer credit tracking, inventory, and supplier management.

Technical Foundation

Frontend: Vite + React 18 single-page application (SPA), written in TypeScript
Backend: Supabase — PostgreSQL database, Supabase Auth, Edge Functions (Deno), Supabase Storage
Delivery: Progressive Web App (PWA) with offline billing support via Workbox service worker
Deployment: Static SPA deployed to CDN, Supabase manages all backend infrastructure

The entire application runs as a client-side SPA that communicates with Supabase's PostgREST API and custom RPC functions. There is no separate backend server — all business logic lives either in the frontend or in PostgreSQL functions and triggers.

Target Users

Primary: Aquaculture Dealers

Feed and medicine dealers in Andhra Pradesh and Telangana, India's largest aquaculture regions. These dealers:

Manage 50 to 500+ farmer accounts
Carry 10 to 100+ products (feed bags, medicines, supplements)
Track credit-based sales — most farmers buy on credit and settle after harvest
Create 5 to 20 bills per day
Operate from 1 to 3 branches (shops/godowns)

Secondary: Staff Members

Counter staff and branch managers who create bills and manage day-to-day operations on behalf of the dealer. Staff have:

PIN-based login (no email/password)
Branch-scoped access
Configurable permissions per module
Their own entry URL per shop/branch

Problems Solved

1. Manual Billing

Aqua dealers traditionally write bills in carbon-copy bill books. A single bill takes 2–3 minutes to write by hand, with frequent errors in totals and item calculations. AquaDealers reduces this to under 30 seconds — select farmer, pick products, enter quantities, done. The system auto-calculates totals, applies discounts, handles GST, and deducts stock in a single atomic transaction.

2. Farmer Dues Tracking

Tracking who owes what is the biggest pain point. Dealers maintain separate notebooks or Excel sheets, and reconciliation errors are common. AquaDealers maintains a real-time digital ledger per farmer with:

Automatic due updates via PostgreSQL triggers on every bill, payment, return, and cancellation
Ageing buckets (0–30, 31–60, 61–90, 90+ days) for collection prioritization
Billed vs. paid reconciliation on farmer statements
Settlement discount tracking

3. Inventory Management

Dealers lose money to expired stock and have no visibility into what's selling. AquaDealers provides:

FIFO lot tracking — each purchase creates a lot with quantity, cost, expiry date, and MRP
Automatic stock deduction on billing (oldest lots consumed first)
Expiry alerts — products nearing expiry are flagged
Multi-branch inventory — each branch maintains its own stock with transfer support
Movement history — every stock change (purchase, sale, return, transfer, adjustment) is audited

4. WhatsApp Invoicing

Farmers expect bills via WhatsApp. AquaDealers provides two mechanisms:

authkey.io API — template-based messages for bill notifications, payment receipts, and due reminders. Sends directly without opening WhatsApp.
wa.me links — pre-formatted deep links that open WhatsApp with the message pre-filled, used for statements and other communications.

The WhatsApp addon is a paid feature with per-message quota management.

5. Multi-Branch Operations

Dealers with multiple shops or godowns need unified management. AquaDealers supports:

Unified inventory across branches with branch-scoped stock levels
Stock transfers between branches preserving FIFO lot data
Branch-scoped data — bills, purchases, and cash book entries are tied to a branch
Branch-specific billing templates and invoice numbering
Staff assigned to specific branches via branch_ids UUID[]

Core Capabilities

Capability	Status	Description
Billing	Implemented	Atomic bill creation with stock deduction, payment, farmer due update in single transaction
Farmer Management	Implemented	Farmer profiles, ledger, statements, product-specific discounts, credit limits
Inventory	Implemented	FIFO lot tracking, expiry management, movement history, rate adjustments
Supplier Management	Implemented	Supplier profiles, purchase recording, supplier ledger, payment tracking
WhatsApp Integration	Implemented	Bill notifications via authkey.io API, wa.me links for statements
Offline Billing	Implemented	Service worker caches app shell; offline bills sync via `client_ref` idempotency
Multi-Branch	Implemented	Branch-scoped inventory, billing, cash book; inter-branch stock transfers
Staff Access	Implemented	PIN login, branch-scoped, 14-module permission system
Daily Book	Implemented	Register-style daily view with 9 sub-pages, date navigation, prefetching
Estimates	Implemented	Quotations using same bill flow but no stock/payment impact; convertible to real bills
Returns	Implemented	Stock restored to original FIFO lots (LIFO), excess becomes return credit
Cashbook	Implemented	Daily cash entries, opening/closing balance, linked to bills and payments
Reports	Implemented	Sales register, profit report, stock report, dues report, monthly finance pack
GST Billing	Implemented	Configurable GST rates per product, HSN codes, GST breakdown on invoices
Bill Editing	Implemented	Edit quantities, prices, discounts, dates, payments with full audit trail
Bill Cancellation	Implemented	Same-day only, unpaid bills only; reverses stock and farmer dues
Transaction Undo	Implemented	Universal undo via `transaction_events` table, 48-hour window
Stock Transfers	Implemented	Inter-branch transfers preserving FIFO lot data and movement audit
Rate Adjustments	Implemented	Per-lot rate changes with reason tracking and movement audit
Farmer Product Discounts	Implemented	Per-farmer per-product discount rates, auto-applied during billing
Crop Cycle	Partial	Basic crop tracking on farmer profile; full cycle management not yet complete
Profit per Product	Partial	Profit calculation exists in reports; per-product breakdown is approximate

Tech Stack

Core Framework

React 18 with TypeScript
Vite 5 — build tool and dev server
React Router v6 — client-side routing

Backend (Supabase)

PostgreSQL — 55+ tables, triggers, RLS policies
Supabase Auth — email/password for dealers
Edge Functions — Deno runtime for WhatsApp API, webhooks
Storage — bill signatures, product images

Styling

Tailwind CSS v4 with custom design tokens
Framer Motion — animations and transitions
Lucide React — icon library

State & Data

TanStack React Query — server state caching and offline support
Zustand — client-side state management
react-hook-form + Zod — form handling and validation

PDF & Reporting

jsPDF — programmatic PDF generation for reports and statements
html2canvas — DOM to canvas to PNG to PDF for bill invoices
Recharts — chart components for dashboard and reports

Infrastructure

vite-plugin-pwa + Workbox — service worker and offline caching
i18next — internationalization (English + Telugu)
PostHog — product analytics and session replays
Sentry — error monitoring and performance tracking

Version

Current version: 3.0.0 (as defined in package.json).

The application is a continuously deployed SPA. Version bumps in package.json mark significant milestones rather than individual releases.