Ahmed AlsaidyProduct & Systems Engineer
← All projects
Connected storefront, POS & inventory
Client System

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
Warqa w Qalam stationery e-commerce storefront with custom brand identity
Warqa w Qalam stationery e-commerce storefront with custom brand identity Click to expand ⤢

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

Architecture diagram of Warqa w Qalam and ManageX unified storefront, offline POS, and stock ledgerARCHITECTURE BLUEPRINT · OMNICHANNEL & OFFLINE POS120 TABLES · 572 TESTS · 80MM THERMALONLINE STOREFRONTWarqa w Qalam Web52 Public Web RoutesCart · Checkout · OrdersRTL Mobile + DesktopIN-STORE & OFFLINE LANBarcode POS & ManageX• Works Without Internet• USB Barcode Scanner• 58/80mm Thermal & A4Signed Offline LicenseERP & RBAC ENGINELaravel 12 / FastAPI• 184 RBAC Staff APIs• 6-Role Permission Guard• Supplier Purchase Orders• Server Print PDF Engine• Margin & Sales Analytics572 PHPUnit Tests7,786 Assertions + E2EIMMUTABLE LEDGER DBPostgreSQL (120 Tables)Stock LedgerDocument-Backed OnlyCash TreasuryAppend-Only ShiftsPartner Sub-LedgersSuppliers & CustomersMandatory Audit TrailNo silent balance edits
L1

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)
L2

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
L3

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
Tech Stack — Technologies used:
  • Laravel
  • PHP
  • PostgreSQL
  • SQLite / Drizzle
  • Playwright E2E

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

01

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

02

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

03

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

warqa-w-qalam/README.md · TXT
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

Summary

Outcome & status

Complete stationery e-commerce, POS and ERP platform with custom brand identity, passing 572 automated tests across 120 database tables

Next project Mandobi → Multi-role delivery platform

Technical Evaluation · GCC / Remote / Egypt

Building an operational system, rescuing an AI cloud stack, or hiring a Product Engineer on retainer?

Complete the 30-second scope qualifier so our first conversation goes directly into system architecture, milestones, and budget fit.