Runnymede Gifts — Trade Giftware & Glassware

Runnymede Gifts A modern B2B trade platform for a heritage giftware wholesaler, replacing a dated brochure site with a full catalogue, account-gated pricing, and online ordering. Runnymede Gifts is a family-run wholesale supplier serving cathedrals, visitor attractions, churches, schools, and charities with faith and heritage giftware — from 3D laser-engraved crystal and olive wood lines to bespoke commissions. The business had outgrown its original static website: trade customers could browse products, but ordering relied on PDF forms, email, and phone, and there was no way to manage accounts, pricing, or orders in one place. The new platform gives approved trade buyers a clear path from registration to checkout, while keeping pricing and ordering strictly behind login. Public visitors can explore the catalogue and bespoke services without seeing trade prices, matching how the business actually sells. Key features: - Trade-only catalogue with prices hidden until approved account login - Online cart and checkout with email order confirmation (no on-site card payments — bank transfer workflow) - Trade account applications, admin approval, and customer invitations - Multi-user organisation accounts with suspend/reject controls - Product catalogue with variants, MOQ, pack sizes, and quantity price breaks - Bespoke quote enquiry workflow with file uploads and admin quote tracking - Customer order history, profile management, and wishlist - Admin dashboard for products, categories, customers, orders, settings, and reports - Marketing broadcast emails to approved trade customers (with unsubscribe handling) - Built-in business inbox — read and reply to customer email from the admin dashboard - AI-assisted product copy generation from supplier notes (admin-only) - Legacy catalogue migration from the old site and price lists (~150 SKUs) - Content pages, SEO-friendly product URLs, FAQ, delivery/returns, and legal pages Technical overview: Built as a full-stack Next.js application with Supabase Auth, PostgreSQL (Drizzle ORM), and Resend for transactional and broadcast email. Deployed on Vercel with row-level security policies on all database tables. The system models trade organisations, members, products, variants, orders, quote requests, and marketing broadcasts — designed around B2B rules rather than retail checkout patterns. Special attention was given to: - Trade-first access control — pricing, cart, and checkout gated by approved organisation status, not just “logged in” - Order workflow without a payment gateway — checkout captures a firm order snapshot and emails staff and customer; payment and invoicing stay in existing back-office processes (Sage) - Catalogue complexity — standard, personalisable, and bespoke-quote product types with ex-VAT pricing and minimum order thresholds - Operational tooling for a small team — admin inbox, order status tracking, customer management, and broadcast emails in one dashboard rather than scattered tools - Secure migration from legacy site — scripted product/price import, image recovery from the old website, and demo mode for development without a live database - Production hardening — RLS on Supabase, typed server actions, and structured runbook for deployment, DNS cutover, and key rotation Status The site is live at runnymedegifts.co.uk, serving the public catalogue and trade ordering flow. Ongoing work includes catalogue expansion, photography, and content refinements as the client continues to onboard trade accounts.