Skip to content

Shopcart Ecommerce Recreation

Ecommerce implementation with separate client and API, SQLite accounts, sessions, carts, checkout, and receipts.

How it’s built

How it’s built

Shopcart Ecommerce Recreation · Full-stack ecommerce recreation with Paystack checkout and SQLite

I recreated the Shopcart storefront as a React client and an Express 5 API on Node's built-in SQLite, with 18 API routes and 8 tables. It has scrypt password hashing, SQLite-backed sessions with CSRF tokens, guest carts that merge on sign-in, and Paystack hosted checkout confirmed by both return-URL verification and signed webhooks. Orders get timelines and printable receipts.

API routes
18
SQLite tables
8
assertions in the smoke test
53
products / categories
16 / 7

Technology and what it does here

Express 5
API, rate limiting, CSRF checks and serving the built frontend
node:sqlite
Built-in SQLite for products, users, sessions, carts, orders and payments
Paystack
Transaction initialize and verify plus HMAC-signed webhook reconciliation
node:crypto
Scrypt hashing, timingSafeEqual, hashed session IDs and webhook signatures
React 19 + Vite
Catalog, cart, checkout, orders and print views
node:assert smoke test
Spawns the server and exercises auth, cart, order and webhook flows

Implementation details

  • Orders carry an idempotency key with UNIQUE(user_id, idempotency_key) and amounts are stored in kobo as integers.
  • Webhooks accept Paystack's modern signature header with 5-minute timestamp tolerance and fall back to legacy x-paystack-signature.
  • Payment initialisation rejects any authorization_url whose host is not checkout.paystack.com.

Technologies

  • SQLite
  • Sessions
  • Checkout

Next project · Academic Researcher

MLGuard

Portfolio assistant

Gabriel’s projects, experience, and research