Build a High-Conversion Affiliate & Review Website with Next.js, TypeScript, PostgreSQL, Prisma & Full Figma Design

Project Overview
I need an experienced full-stack developer/designer to build a custom-coded affiliate and product review website similar in quality/structure to a Wirecutter-style site. The website must be fast, SEO-friendly, mobile responsive, conversion-focused, and easy to manage from a custom admin dashboard.
This is a product-first architecture. Products must be independent database entities that can be reused across review pages, comparison pages, top 10 lists, buying guides, and category pages.
Required Stack (Non-Negotiable)
Frontend: Next.js 15+ (App Router), TypeScript, Tailwind CSS
Backend/ORM: PostgreSQL + Prisma ORM
State/Validation: TanStack Query, React Hook Form, Zod
Deployment: Vercel + Supabase or Railway
Goal: Excellent Core Web Vitals and strong PageSpeed performance
Website Must Support
Product reviews
Product comparisons
Top 10 / best product lists
Buying guides
Category pages
Blog/articles
Affiliate CTA buttons
Core Frontend Features
“At a Glance” review summary box
Product rating / score
Pros & cons blocks
Dynamic comparison tables
Sticky CTA on mobile
Auto-generated table of contents
FAQ sections
Related content
Top pick / featured badges
Author box
Last updated date
Affiliate disclosure sections
Breadcrumbs
Search functionality
SEO Requirements
Clean URL structure
Editable slugs, meta titles, descriptions, canonicals
Internal linking support
Sitemap generation
Robots handling
Schema/JSON-LD for Product, Review, FAQPage, BreadcrumbList
Optimized category and review pages
Image optimization, lazy loading, WebP/AVIF
ISR/caching strategy for speed
Database / Backend Requirements
Please build a scalable Prisma/PostgreSQL schema with at least:
Products
Reviews
Comparisons
Categories
Affiliate Links
Authors
FAQs
Redirects
Product Model Must Support
Name, slug, images
Brand
Short/long description
Specs
Pros/cons
Rating
Best for
Centralized affiliate link
Reuse across multiple content types
Admin Dashboard Requirements
A private custom admin dashboard is required and included in scope. It should allow easy management of:
Products
Reviews
Comparisons
Guides/articles
Affiliate links
Categories
SEO fields
Homepage sections
Menus/footer/sidebar content
Banners/ad placements
Admin Features Needed
Full CRUD
Centralized affiliate link manager
Site-wide link updating
Draft/publish workflow
Media upload support
Fact-check toggle
SEO controls
Easy homepage and layout management
Editor Requirement
Use TipTap or a similar editor that supports:
Headings
Images
CTA buttons
FAQ blocks
Pros/cons blocks
Product cards
Comparison tables
Figma Requirement
You must provide complete Figma designs for all key pages/templates before development starts, including desktop and mobile versions. This includes:
Homepage
Review template
Comparison template
Top 10 / buying guide template
Category pages
Blog/article pages
About
Contact
Legal pages
Development should start only after Figma approval.
Required Pages
Home
Blog
Review template
Comparison template
Top 10 / buying guide template
Category pages
About
Contact
Privacy Policy
Terms & Conditions
Affiliate Disclosure
Disclaimer
Editorial Policy
Website Behavior Expectations
Homepage sections should be modular and editable
Products must be reusable across reviews, lists, and comparisons
Updating a centralized affiliate link should update site-wide
Comparison tables should support reusable product data
Category pages should support SEO text and filtering/sorting where needed
Review pages should include trust and conversion elements
301 redirects should be manageable from admin
Site must be fully mobile responsive and fast
Milestones
Figma design approval
Database architecture + Prisma schema
Admin dashboard
Frontend templates and UI
SEO/schema/performance optimization
Testing, deployment, handoff
Deliverables
Full working website
Responsive frontend
Custom admin dashboard
PostgreSQL database + Prisma schema/migrations
Full Figma files
Production deployment
Source code
Documentation
Post-launch bug support
Please Share in Proposal
Relevant portfolio
Similar affiliate/review websites you built
Figma samples
Recommended architecture
Estimated timeline
Estimated budget
Your suggested approach for products, reviews, comparisons, SEO, and admin
If Freelancer still rejects it, paste this even shorter version:
Need a full-stack developer/designer to build a custom affiliate/review website using Next.js 15+, TypeScript, Tailwind, PostgreSQL, Prisma with full Figma design before development.
Site type: Wirecutter-style review/affiliate platform with:
Reviews
Comparisons
Top 10 lists
Buying guides
Category pages
Blog/articles
Must include:
Product-first architecture
Reusable product database entities
Dynamic comparison tables
Pros/cons
Ratings
Sticky mobile CTA
TOC
FAQ blocks
Author box
Last updated
Affiliate disclosure
Search
Breadcrumbs
Strong SEO structure
SEO:
Clean URLs
Editable metadata/slugs/canonicals
Sitemap
Robots
JSON-LD schema
Fast performance
Image optimization
WebP/AVIF
ISR/caching
Backend/admin:
Custom admin dashboard
CRUD for products, reviews, comparisons, guides, categories
Centralized affiliate link manager
Site-wide link updates
SEO controls
Homepage/layout management
Media uploads
Draft/publish workflow
Database models at minimum:
Products
Reviews
Comparisons
Categories
Affiliate Links
Authors
FAQs
Redirects
Editor:
TipTap or similar
Must support headings, images, CTA buttons, FAQ blocks, pros/cons, product cards, comparison tables
Figma required for:
Homepage
Review template
Comparison template
Top 10 template
Category pages
Blog/article pages
About
Contact
Legal pages
Deliverables:
Full website
Admin dashboard
Prisma schema/migrations
Figma files
Deployment
Source code
Documentation
Bug support after launch
Please send:
Portfolio
Similar projects
Figma samples
Timeline
Budget
Recommended architecture


check the project overview in the attached Show More