U-Shop ERP Ecosystem
U-Shop is an enterprise-grade ERP and operations ecosystem. It features an administrator web panel built in Next.js 16 using Prisma ORM to schedule rosters, compile reports, and track inventory audits, coupled with an Expo React Native mobile app for store staff to execute geofenced clock-ins, scan stock, and manage shifts with TanStack React Query and Supabase.
Interface Gallery (Scroll & Click to Expand)
Core Features
Dual-Platform Command Suite
Integrated desktop administration portal (Next.js) for shift roster compilation, paired with a high-speed mobile client (React Native) for on-the-floor store staff.
Expo Barcode Scanner
In-app Camera integration utilizing Expo Camera to scan product EAN/UPC labels and update quantities in under 200ms.
Intelligent HR Scheduler
Digital staff rosters, shifts checking logs, and profile leaf triggers matching user sessions in real-time.
Supabase & React Query Cache
Asynchronous query handlers and data syncing with TanStack React Query and Supabase database endpoints, enabling secure, offline-first mobile support.
Prisma ORM & SQLite
Locally persistent relational database schemas with custom seeds, migrations, and structural PDF/JSON data exporters.
Technical Deep Dive
Asynchronous State Caching & Supabase Sync
Engineered the React Native application using TanStack React Query and @supabase/supabase-js client libraries. Queries implement structural caching and retry patterns so local operations are held in local state and compiled offline, syncing automatically with cloud databases upon restoration.
Expo Camera Vision & Barcode Parser
Developed a high-speed scanner view utilizing expo-camera and expo-barcode-scanner. By piping active camera streams into lightweight structural filters, the mobile client reads grocery barcodes, queries matching SKUs, and updates inventory lists instantly without rendering lag.
Relational Database Schema & Prisma Migrations
Architected the Next.js control center around Prisma ORM. Configured complex relational models (Checklists, Shifts, Leaves, Inventories) utilizing Prisma migrations and custom data seeds, ensuring complete data consistency across both web and mobile channels.
Performance Benchmark
"Architected a unified full-stack ERP ecosystem combining a Next.js 16 web control center and an Expo React Native mobile app with Supabase and Prisma, automating employee shifts and reducing inventory discrepancies by 40%."