Razorpay analytics: revenue by channel

Setup steps

1. In Razorpay, open Account & Settings → API Keys and generate a live key pair.
2. In ProductLense, open Settings → Billing connections → Razorpay and paste the key id and secret.
3. In Razorpay Dashboard → Webhooks, add a webhook endpoint with the URL ProductLense shows after you save the connection (pattern https://api.productlense.app/api/webhooks/{provider}/{connection_id}).
4. Set a webhook secret, tick the events listed below, and paste the same secret into ProductLense.
5. ProductLense backfills 12 months of payments and refunds. INR amounts are converted to USD at the ECB daily rate and kept in INR too.

Credentials and permissions

Webhook

URL pattern, shown with your connection id after you save:

https://api.productlense.app/api/webhooks/razorpay/{connection_id}

Events: payment.captured, payment.failed, refund.processed, subscription.activated, subscription.charged, subscription.cancelled

Verification: X-Razorpay-Signature header: HMAC-SHA256 of the raw body.

What ProductLense reads

Customers

Customers with email.

Subscriptions

Subscriptions; each plan is fetched once and cached for its amount and interval.

Payments

Captured payments.

Refunds

Processed refunds.

Fees

The fee on each payment, which includes GST.

What ProductLense never touches

• Never creates, changes, refunds or cancels anything: read-only API calls and incoming webhooks only.
• Never moves money, issues payouts, or reads bank account details.
• Never sees full card numbers; providers do not expose them.
• Never sends your customer data to the AI model: Ask and the daily insight see aggregates only.

Match payments to your users

Add pl_user_id to the notes of Razorpay customers or payments to match by id rather than email.

const rzp = new Razorpay({
  key: 'rzp_live_...',
  order_id: order.id,
  prefill: { email: user.email },
  notes: { pl_user_id: user.id },
});
rzp.open();