Project progress

A living checklist of what we've built and what's still needed before the site is fully ready for customers and the shop owner.

Overall progress

48%(11 of 23 complete)

Last updated 2026-06-13

11 done0 in progress12 to do

Public website

Pages visitors see today.

4/4 complete

Core pages (home, books, services, about, contact)
Done
Book / stationery / awards / gift departments from shop notes
Done
Shown on Books and Services; editable in admin when Supabase is live.
Printing & internet café service cards
Done
Static copy on /services — not editable in admin yet.
Project progress checklist page (/progress)
Done

Content & assets

2/5 complete

Homepage hero photo (public/herp.jpeg)
Done
Staff pick cover images in public/ or uploaded via admin
To do
Seed data references /book-cover-*.jpg; public/ currently has logo.png only.
Real contact info (address, hours, Google Maps)
Done
From Google Business Profile; add phone/WhatsApp when available.
Expanded About page (story, photos, team)
To do
Footer social links point to real profiles
To do
Links are # placeholders today.

Supabase & shop admin

Backend and owner tools — see SETUP.txt.

4/8 complete

Supabase project + .env.local (URL + anon key)
Done
Run SQL migrations 001 and 002 in Supabase SQL Editor
To do
Files: supabase/migrations/001_content_and_admin.sql, 002_book_covers_storage.sql
Create admin Auth user + admin_allowlist row
To do
npm run bootstrap:admin or Dashboard → Authentication + SQL insert.
Admin CMS (/admin) — items, staff picks & store categories
Done
Per-item inventory, prices, and stock
Done
store_items table + /admin/items; no online checkout yet.
Login, register, account, middleware protection
Done
SUPABASE_SERVICE_ROLE_KEY set (if using auth-disabled local dev)
To do
Required for /admin writes when DISABLE_AUTH is on.
Owner signed in and tested adding a staff pick + category
To do

Launch & production

1/4 complete

Remove DISABLE_AUTH / NEXT_PUBLIC_DISABLE_AUTH before production
To do
Deploy site (e.g. Vercel) with production env vars
To do
Run migrations on production DB (if separate from dev)
To do
GitHub remote (ScholarAIja/thelittlebookshop)
Done
Last push recorded locally: 2026-05-02.

Future (not in current scope)

Possible later — not required for first launch.

0/2 complete

Online cart / checkout
To do
Editable printing & café copy in admin
To do

This list lives in lib/project-checklist.ts and is updated when we finish work in the repo. For Supabase setup steps, see SETUP.txt.