setup

Razorpay Integration Setup

You are setting up Razorpay payment integration. Follow these steps precisely.

Step 1: Install Dependencies

npm install razorpay
# or
pnpm add razorpay

Step 2: Environment Variables

Create or update .env.local:

# Razorpay API Keys
RAZORPAY_KEY_ID=rzp_test_xxxxx          # Test key (rzp_live_xxxxx for production)
RAZORPAY_KEY_SECRET=xxxxx               # API secret
NEXT_PUBLIC_RAZORPAY_KEY_ID=rzp_test_xxxxx  # Same as RAZORPAY_KEY_ID (client-side)
RAZORPAY_WEBHOOK_SECRET=xxxxx           # Webhook signature verification

# Plan IDs (create plans in Razorpay Dashboard first)
RAZORPAY_PLAN_MONTHLY=plan_xxxxx
RAZORPAY_PLAN_YEARLY=plan_xxxxx

IMPORTANT: Test keys start with rzp_test_, live keys with rzp_live_. Never commit secrets.

Step 3: Razorpay Client Singleton

Create a shared Razorpay instance. Do NOT create new instances per request.

// lib/razorpay.ts
import Razorpay from "razorpay";

// Validate required env vars at startup — fail early, not at first payment
const requiredEnvVars = [
  "RAZORPAY_KEY_ID",
  "RAZORPAY_KEY_SECRET",
  "RAZORPAY_WEBHOOK_SECRET",
] as const;

for (const key of requiredEnvVars) {
  if (!process.env[key]) {
    throw new Error(`Missing required environment variable: ${key}`);
  }
}

export const razorpay = new Razorpay({
  key_id: process.env.RAZORPAY_KEY_ID!,
  key_secret: process.env.RAZORPAY_KEY_SECRET!,
});

Step 4: Database Schema

You need these tables. Adapt to your ORM (Drizzle, Prisma, raw SQL):

Subscriptions Table

CREATE TABLE subscriptions (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id VARCHAR NOT NULL,
  plan_key VARCHAR NOT NULL,              -- e.g. "pro_monthly", "pro_yearly"
  razorpay_subscription_id VARCHAR UNIQUE NOT NULL,
  razorpay_plan_id VARCHAR NOT NULL,
  razorpay_customer_id VARCHAR,
  status VARCHAR NOT NULL DEFAULT 'created',  -- created|authenticated|active|halted|cancelled|completed|paused
  current_period_end TIMESTAMP,
  last_event_id VARCHAR,                  -- Webhook idempotency
  last_payment_id VARCHAR,
  cancelled_at TIMESTAMP,
  created_at TIMESTAMP DEFAULT NOW(),
  updated_at TIMESTAMP DEFAULT NOW()
);
CREATE INDEX idx_sub_user ON subscriptions(user_id);
CREATE INDEX idx_sub_rzp ON subscriptions(razorpay_subscription_id);