Multi-Vertical Architect
Let’s talk
Enterprise Web & SaaS

BestPriceKSA: Enterprise Retail Command Center

Moving retail operations beyond the Spreadsheet Bottleneck with a centralized, audit-proof ERP for multi-location inventory and real-time financial analytics.

Executive Command Dashboard
Net Profit
NP
6 Profit Margins
Total Revenue
SR
Multi-store
Inventory Value
IV
Live ledger
Store Command Strip
WH
412
Store A
38
Store B
38
Store C
38
Quick Sale
From guessing → knowing
Replaced spreadsheets with an Audit-Proof workflow that eliminates Ghost Stock and the Blind Profit issue while enforcing 100% Accountability.
Financial Intelligence
Tracks 6 Profit Margins with cost-shifting logic and a Zero Double-Counting recovery module—so damages don’t inflate expense reports.
Live DomainComplexity: 8/10
ReactPHPMySQLRole-based accessReporting
Challenges

Tracking shifting cost-of-goods and multi-location stock movement without double-entry, while maintaining speed for day-to-day operations, strict auditing, and finance-grade accuracy across thousands of transactions.

Spreadsheet + third-party seller platforms create Blind Profit math, Ghost Stock desync, and zero accountability. BestPriceKSA centralizes multi-location inventory, purchasing, sales, and finance into a single command center with immutable audit trails.

React
PHP
MySQL
Role-based access
Reporting
In-Transit Verification (Electronic Handshake)

To eliminate Ghost Stock, transfers move into an In-Transit state (deducted from sender, not yet added to receiver). The receiving store verifies line-items, and the ledger auto-routes partial rejections and damages—without spreadsheet math or double counting.

Logic Peek — Status transitions update the ledger
type TransferStatus = "Pending" | "InTransit" | "Verified" | "Rejected";

function dispatchTransfer(transferId: string) {
  // Pending -> InTransit
  updateTransfer(transferId, { status: "InTransit", dispatchedAt: Date.now() });
  ledger.write({ type: "TRANSFER_OUT", transferId });
}

function verifyTransfer(transferId: string, received: Array<{ sku: string; qty: number }>) {
  // InTransit -> Verified (with partials handled as recovery/damage lines)
  updateTransfer(transferId, { status: "Verified", verifiedAt: Date.now(), received });
  ledger.write({ type: "TRANSFER_IN", transferId, received });
  finance.recompute({ transferId });
}
The invariant: every movement writes to the Immutable Stock Ledger first—then finance KPIs recompute from the ledger for Audit-Proof accuracy.
Architecture

A desktop-first ERP command center with KPI dashboards and a catalog-driven workflow. A Store Command Strip expands any SKU to show live stock across all stores horizontally, while Purchase Orders and In-Transit verification enforce an electronic handshake between locations.

Implemented a strict, workflow-first state machine (Purchase Order → In-Transit → Verified) backed by an immutable stock ledger and system activity log—so every movement updates finance automatically and remains audit-proof.

Results
Audit-ProofImmutable Stock Ledger6 Profit Margins100% Accountability

Moved operations from guessing to knowing: eliminated Ghost Stock drift, made net profit measurable under cost shifts, and delivered 100% accountability through an audit-proof ledger and user activity trails.

Performance & Scalability
  • High-performance catalog interactions designed for operational environments
  • Paginated logs and dashboard KPIs optimized for daily heavy usage