Warqa w Qalam
A complete stationery retail platform combining custom brand identity, customer e-commerce storefront, barcode POS cashier, supplier invoicing, inventory management and sales analytics
- Role
- Brand identity + full-stack engineering
- Timeline
- 2026
- Platforms
- Web · Windows · Server
- 3 في 1
- connected store, POS & stock
- باركود
- barcode checkout & stock
- موردين
- supplier invoices & payables
- هوية كاملة
- custom brand & illustrations
Overview
Business problem & context
Stationery and school-supply retailers manage thousands of seasonal SKUs across books, notebooks and art supplies while selling simultaneously through an online storefront and in-store POS cashier counters without stock drift or supplier invoice discrepancies
System Architecture
System layers & components
A unified e-commerce storefront and retail ERP built on Laravel 12 across 120 database tables (32 migrations) and 236 routes (184 staff/auth API routes + 52 web storefront routes), verified by 572 automated tests (7,786 assertions) and Playwright E2E suites
Customer Storefront & Brand System
Public e-commerce storefront with custom Warqa w Qalam brand identity
- 52 Web Storefront Routes
- 643 Preserved Brand Assets
- Cart, Checkout & Order Tracking
- Responsive RTL Arabic UI (1440px / 390px)
POS Cashier, Purchasing & Inventory ERP
Barcode POS, supplier invoicing, stock ledger & analytics
- 184 Staff & Operations API Routes
- Fast Barcode POS + Thermal 58/80mm Print
- Supplier Invoices & A4 PDF Engine
- Sales Trend & Margin Analytics
Data & Verification Core · Laravel 12
120 relational tables & 572 automated tests
- 32 Declarative Migrations (120 Tables)
- 572 Automated Tests (7,786 Assertions)
- Playwright Browser Verification
- Immutable Stock & Financial Ledgers
Data Model
Database schema & core tables
A 120-table relational schema connecting multi-variant stationery catalogs with supplier purchase invoices, POS cashier shifts, online orders and an append-only stock movement ledger
| Table | Role in the system |
|---|---|
products / categories / product_variants | Stationery & book catalog, barcodes, categories and pricing tiers |
pos_sessions / pos_orders / pos_payments | Cashier shift sessions, barcode checkout orders and split tenders |
supplier_invoices / purchase_items | Supplier purchase invoices, unit cost tracking and warehouse receiving |
stock_movements / inventory_counts | Document-backed stock ledger, cycle counts and variance reconciliation |
Implementation
Key technical decisions
Unified stock ledger across online storefront and physical POS
Every online checkout, POS cashier sale and supplier invoice receipt posts to a single stock movement ledger, eliminating overselling between web and in-store channels
Direct brand-to-UI pipeline from custom Illustrator assets
Crafted the custom Warqa w Qalam logo, mascot illustrations and warm stationery palette, preserving 643 brand assets directly into responsive storefront and ERP components
572 automated tests with 7,786 assertions + Playwright E2E
Every operational module across purchasing, POS, accounting and thermal/A4 printing is gated by 572 PHPUnit feature tests and headless Playwright browser verification
Security
Security & access control
- Strict separation between public storefront routes (52) and RBAC-protected staff API endpoints (184)
- Immutable invoice totals and document-backed inventory movements prevent silent balance edits
- Automated verification of thermal 58/80mm receipts, A4 PDFs and session security guards
Code Highlight
Warqa w Qalam production verification suite summary
Schema : 120 tables across 32 declarative migrations
Routes : 236 total (184 staff/auth API routes + 52 web storefront/account routes)
Test Suite : 572 passed tests · 7,786 assertions (0 failures)
Print : A4 PDF documents + 58mm / 80mm thermal POS receipts
Brand : 643 preserved brand & UI assets verified at 1440×900 & 390×844 Product Screens
System screenshots
Web & desktop interfaces
Mobile app screens
Summary
Outcome & status
Complete stationery e-commerce, POS and ERP platform with custom brand identity, passing 572 automated tests across 120 database tables