ALPHA&CO POS System

A complete Point of Sale system for ALPHA&CO BOUWMATERIALEN & DESIGN in Belgium.

Features

• POS interface with product search and cart
• Product management with import wizard
• Customer management
• Sales history and documents
• Stock tracking
• Reports
• Settings

Tech Stack

• Next.js 14 with App Router
• TypeScript
• TailwindCSS + shadcn/ui
• SQLite + Drizzle ORM
• Authentication with httpOnly cookies

Installation

1. Clone the repository
2. Install dependencies: pnpm install
3. Copy environment: cp .env.example .env
4. Generate database: pnpm db:generate
5. Run migrations: pnpm db:migrate
6. Seed data: pnpm db:seed
7. Start development server: pnpm dev

Default Credentials

• Email: admin@alphaco.be
• Password: admin123

Deployment

Docker

docker-compose up -d

PM2

pnpm build
pm2 start ecosystem.config.js

Manual Test Checklist

• Login with default credentials
• Import products via Excel/CSV
• Add products to cart in POS
• Complete a sale
• View sale in history and documents
• Stock updates correctly

API Routes

• /api/auth/login - POST
• /api/auth/logout - POST
• /api/auth/me - GET
• /api/products - GET, POST
• And more...

Database Schema

See src/lib/drizzle/schema.ts for the complete schema.

License

MIT