Case study · E-commerce · Education · Lahore
A school-book store parents can shop by class.
SchoolBooksExperts is a Lahore store for school books, stationery, gifts, toys and costumes. We built the full platform: storefront, checkout and the admin the team runs it from every day.

Client
SchoolBooksExperts, Lahore
Storefront
~30 pages
Admin
15 screens
Database
22 tables, all secured
01The challenge.
Parents buying for a new school year need the exact books for their child’s school and class, and the store needed to sell far more than books — stationery, gifts, toys, sports items and costumes — without its staff updating everything by hand.
02What we built.
- Find Books by School — choose the school and class and see the full list, with bundles.
- Search with ISBN, product pages with reviews, wishlist and cart.
- Three-step checkout, order tracking, Google login and an account area.
- Six categories with their own filters: Books, Stationery, Gifts, Toys & Games, Sports Items and Character Costumes.
- 15 admin screens: dashboard, products with CSV import/export, bundles, schools, categories, orders, reviews, customers, coupons, banners, marketing, reports, settings and an activity log.
03Security and reliability.
Prices are calculated on the server, every table is protected with row-level security, and orders, stock and reviews follow rules customers cannot bypass — fixes we prioritised in a full code audit before launch.
Technology.
React 19TanStack Start (SSR)SupabaseTailwind CSSshadcn/uiZod