White-Label AI Subscription Box Management Tool for Niche Box Operators

Build a white-label AI subscription box management SaaS on Next.js + Supabase + Stripe Billing. There are two user types: Operator (box brand owner) and Subscriber (end customer). The platform is multi-tenant — multiple box brands (operators) can use the platform simultaneously. Database schema (Supabase): - operators table: id, name, brand_name, logo_url, brand_color, stripe_account_id (for Connect — optional), config jsonb (tone_guidelines, box_size, curation_rules), created_at. RLS. - subscribers table: id, operator_id, email, first_name, stripe_customer_id, stripe_subscription_id, status ('active'|'paused'|'cancelled'), next_billing_date, created_at. RLS on operator_id. - subscriber_preferences table: id, subscriber_id, operator_id, preferences jsonb (flexible schema — stored as quiz answers), updated_at. - skus table: id, operator_id, name, description, category, remaining_stock int, unit_cost numeric, created_at. RLS on operator_id. - monthly_box_assignments table: id, subscriber_id, operator_id, month date (first of month), selected_skus jsonb (array of { sku_id, rationale }), curated_at, email_sent_at. - box_ratings table: id, subscriber_id, sku_id, month date, rating int (1-5), comment text, created_at. Operator admin pages (/operator/*): - /operator/dashboard — subscribers total, active vs. paused vs. cancelled, AI cost this month, upcoming billing count - /operator/subscribers — list with status, churn risk score badge, last box rating, next billing date. Click row to view subscriber detail. - /operator/subscribers/[id] — preference profile, box history, ratings chart, current risk score, manual box override for current month - /operator/skus — SKU catalog table (name, stock, category), add/edit/delete, bulk CSV import - /operator/curation — current month status: X of N subscribers curated. 'Run Curation' button triggers the AI curation batch. Preview of first 5 subscriber curation results. 'Approve & Queue Emails' button. - /operator/settings — brand name, logo, brand_color, tone_guidelines (textarea), curation_rules (textarea) Subscriber portal pages (/subscribe/* and /portal/*): - /subscribe/[operator_slug] — public subscription landing page: brand-styled, price, features, 'Subscribe' button → Stripe Checkout - /portal/[subscriber_id] — subscriber self-service: view current box assignment, skip next month, pause subscription, rate previous box items (star rating per item), update preferences Stripe Billing integration: - POST /api/stripe/create-checkout: creates Stripe Checkout Session with subscription price_id, success_url, cancel_url, metadata { operator_id, subscriber preferences JSON } - POST /api/webhooks/stripe: handle customer.subscription.created (create subscriber row, status=active), invoice.paid (update next_billing_date), customer.subscription.deleted (update status=cancelled), invoice.payment_failed (send dunning email via Resend) AI Curation Edge Function (Supabase: curate-monthly-boxes): - For each active subscriber in the operator's tenant: 1. Build prompt: subscriber name + preferences + past 3 box ratings + available SKUs with stock counts 2. Call Claude Haiku 4.5 with system: 'You are a subscription box curator. Select exactly {N} items from the available SKUs for this subscriber. Constraints: (1) do not select SKUs with remaining_stock < 5, (2) avoid SKUs the subscriber rated 1-2 stars previously, (3) select at most 2 items from any single category. Return JSON: [{ sku_id, rationale_one_sentence }]' 3. Parse response, validate all sku_ids exist in skus table 4. Deduct 1 from remaining_stock for each selected SKU 5. Upsert into monthly_box_assignments - Run as Trigger.dev scheduled job on the 25th of each month at 2am UTC per operator timezone Reveal Email Generation (as part of curation job, after all assignments complete): - For each subscriber with box_assignment: call Haiku 4.5 with the selected items and subscriber name - System: 'Write a warm, excited reveal email for a subscription box. Include the subscriber first name, list each item with its one-sentence rationale. 150-200 words. Subject line suggestion in the JSON response.' - Store generated email in monthly_box_assignments.reveal_email_html and .subject_line - Queue for send via Resend API at 9am subscriber-local-time on the 1st of the month Styling: Tailwind CSS. Operator admin: clean data-dense dashboard, dark sidebar. Subscriber portal: brand_color as primary color, brand logo top-left, warm consumer-facing design. No RapidDev branding in subscriber-facing pages. Environment variables: NEXT_PUBLIC_SUPABASE_URL, NEXT_PUBLIC_SUPABASE_ANON_KEY, SUPABASE_SERVICE_ROLE_KEY, ANTHROPIC_API_KEY, STRIPE_SECRET_KEY, STRIPE_WEBHOOK_SECRET, RESEND_API_KEY.