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

$5000-10000 USD

Đã đóng

Đã đăng vào 26 ngày trước

$5000-10000 USD

Thanh toán khi bàn giao

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: [login to view URL] 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 [login to view URL] 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

Next.js

PostgreSQL

Full Stack Development

Content Management System (CMS)

Database Design

Web Development

Mã dự án: 40326620

Về dự án

181 đề xuất

Dự án từ xa

Hoạt động 19 ngày trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

181 freelancer chào giá trung bình $7.463 USD cho công việc này

@SBITServices

Hi, I will develop this dynamic and secure Affiliate & Review Website in React.js/Next.js web application. I’ll ensure it has all required functionalities, Robust, Secure, User frinedly. My Skills Include: a) Next,Js, React.js Development: Expertise in building and customizing web applications. b) Frontend Technologies: Proficient in Tailwind, Bootstrap, and JQuery. c) Backend Technologies: Experienced with Node.js, Laravel, Python. d) Database Management: Skilled in Postgresql, MySQL, MongoDB. e) Server Handling: Knowledgeable in AWS, Google Cloud, VPS, Apache, and Nginx. I will share my previous web applications in private chat. Lets connect in chat so that We discuss further. With Regards, Sai

$5.000 USD trong 45 ngày

5,0

(19 nhận xét)

5,0

@Hussainferozi313

Hi there! I understand you're looking for a skilled full-stack developer/designer to create a custom affiliate and review website similar to Wirecutter. With a focus on quality and attention to detail, I am confident in my ability to deliver a fast, SEO-friendly, and conversion-focused site that meets your goals. Let's work together to bring your vision to life! Looking forward to discussing further details and getting started on this exciting project. Thank you!

$5.000 USD trong 7 ngày

5,0

(6 nhận xét)

4,5

@MusouDigital

Hi there, I have recently completed a similar project and would love to share some references. Building a Wirecutter-style affiliate and product review website sounds right up my alley, and I would love to exceed your expectations with a fast, conversion-focused platform your audience deserves. I treat every project like my own pride and joy and I go out of my way to make sure you love the final design and functionality. With 9+ years in full-stack development, I'll deliver Figma designs for all key pages. You'll get a scalable, product-first site with reusable entities, dynamic tables, strong SEO (JSON-LD, ISR caching), and an intuitive admin dashboard for effortless CRUD, site-wide updates, and media management. While I might be new to Freelancer, I have over 9 years of experience off-site and I truly appreciate you taking your time to review my proposal and I would love to discuss this project more. Kind regards, Trichelle

$6.000 USD trong 40 ngày

5,0

(4 nhận xét)

2,9

@mrgamedev07

Hi , we have already made admin dashboard with dynamic link generation and with seo and blogs using next js .I can not show you here but love to show that to if you message me . We can go for next js static pages as export which will be much faster in performance . Our Timeline will be 3 months Budget - 5000$ we will use Next js for website React js for admin panel Would love to discuss more in meeting .

$7.500 USD trong 7 ngày

5,0

(5 nhận xét)

2,0

@Curveballsol

Hello, I can flawlessly fulfill all your project requirements. My skillset is directly aligned with your stack preference, making me the perfect candidate to tackle the task of building an affiliate and review website with a focus on performance and usability. Apart from technical prowess, my operational tidiness guarantees efficient CRUD operations, centralized affiliate link management, media uploads, fact-check toggling and crucial SEO controls. Be it designing 'At a Glance' summary box or implementing Pros & Cons blocks or setting up dynamic comparison tables - I have a proven record of creating components that effectively drive traffic and conversion. And finally, I'm greatly impressed with your commitment to detailed Figma designs as they enable precision-oriented development. Rest assured, I value coherent communication and timely feedback while providing comprehensive documentation at each project phase. Together, we can create the Wirecutter-style site you envision: fast, SEO-friendly and mobile responsive - True to its purpose of engaging and enriching users in their purchase decisions. Lets Chat

$8.000 USD trong 20 ngày