Back to catalogue
Project
Shopcart Ecommerce Recreation
Ecommerce implementation with separate client and API, SQLite accounts, sessions, carts, checkout, and receipts.
How it’s builtHow 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
