ASPECTRIQ Supply Chain
A B2B supply-chain and fulfillment platform featuring live order delivery KPIs, supplier performance scoring, a 2,450+ SKU product catalog and role-based access control
- Role
- Full-stack engineering & UI design
- Timeline
- 2025 – 2026
- Platforms
- Web · Server
- 2,450+
- catalog products & SKUs
- 128 مورد
- suppliers & SLA tracking
- صلاحيات
- role-based access control
- تقارير حية
- delivery & stock KPIs
Overview
Business problem & context
B2B supply-chain operators coordinating hundreds of suppliers and thousands of purchase orders need real-time visibility into delayed shipments, supplier SLA compliance and strict role-based access control
System Architecture
System layers & components
An enterprise Arabic RTL supply-chain and supplier management platform built with React, TypeScript and Tailwind CSS featuring live fulfillment analytics, SKU catalog management and RBAC identity administration
Executive & Operations Console · React + TypeScript
Supply chain KPIs, delivery status breakdown & supplier SLA cards
- Order Fulfillment Analytics
- Supplier SLA Rating Matrix
- Delayed Order Alerts
- Native RTL Arabic Design System
Catalog & Order Fulfillment Engine
2,450+ SKU catalog & Affiliate · Fulfill · Deliver lifecycle
- SKU Stock Status & Thresholds
- Multi-Category Filtering & Search
- Supplier Assignment & Tracking
- Export & Audit Reports
Identity & RBAC Security Layer
Enterprise user lifecycle, role matrix & access policies
- Role-Based Access Control (RBAC)
- Department & Branch Scoping
- Session & Activity Auditing
Data Model
Database schema & core tables
Data model connecting suppliers, SKU catalogs, fulfillment orders, SLA performance metrics and RBAC user permissions
| Table | Role in the system |
|---|---|
suppliers / supplier_sla_metrics | Supplier profiles, on-time delivery rate and quality scorecards |
catalog_products / stock_levels | Product SKUs, categories, unit pricing and stock availability |
supply_orders / order_status_logs | Fulfillment orders and status transitions (delivered, in-progress, delayed) |
users / roles / role_permissions | Enterprise users, functional roles and granular permission grants |
Implementation
Key technical decisions
Automated supplier SLA scoring driven by actual delivery timestamps
Supplier reliability scores and on-time percentages are computed directly from order fulfillment timestamps rather than manual ratings
Dedicated enterprise identity and RBAC administration console
Isolated user and role administration into a dedicated security console governing read/write access across suppliers, pricing and financial reports
Security
Security & access control
- Role-based access control separating system admins, procurement managers and fulfillment operators
- Full auditability across order status transitions and catalog price updates
Code Highlight
Supplier SLA compliance calculation
export function computeSupplierSla(orders: ReadonlyArray<SupplyOrder>): SlaSummary {
const completed = orders.filter((o) => o.status === 'delivered' || o.status === 'delayed');
if (completed.length === 0) return { onTimeRate: 100, delayedCount: 0 };
const punctualCount = completed.filter((o) => o.deliveredAt <= o.promisedAt).length;
return {
onTimeRate: Math.round((punctualCount / completed.length) * 100),
delayedCount: completed.length - punctualCount,
};
} Product Screens
System screenshots
Web & desktop interfaces
Summary
Outcome & status
Cohesive Arabic B2B supply-chain system uniting executive analytics, SKU catalog management, supplier SLA tracking and RBAC security