AI-Driven Video Clipping & Social Media SaaS

Job ID: 40539336

Budget: ₹12,500 – ₹37,500 INR

Full-Stack AI Short-Form Video Clipping & Social Media SaaS like Vizard.ai , cliphi.com and klap
Target Deliverable: Minimum Viable Product (MVP) with Advanced Admin & User Controls

1. ARCHITECTURE & TECH STACK PREFERENCES
- Frontend: Next.js (App Router), React, Tailwind CSS, Shadcn/ui (optimized for desktop and mobile web viewports with local state persistence for Day/Night mode toggles).
- Backend: Python (FastAPI or Django REST Framework) preferred due to native library support for video processing (FFmpeg, MoviePy, yt-dlp).
- Database & Auth: Supabase (PostgreSQL) or Firebase. Must include secure email/password auth, Google OAuth, and integrated session management.

2. SYSTEM DATABASE SCHEMA & CORE MODELS
Developers must implement a relational database structure containing these explicit models:
- Profiles: (id, email, role ['user', 'admin'], credit_balance_minutes, stripe_or_payment_customer_id, theme_preference, created_at)
- Pricing_Packages: (id, name, credit_amount_minutes, price_inr, price_usd, discount_percentage, is_featured, is_active)
- Coupon_Codes: (id, code [unique], discount_percent, max_redemptions, current_redemptions, expires_at, is_active)
- User_Subscriptions: (id, user_id, package_id, status, current_period_end)
- Videos_Processed: (id, user_id, original_url, source_type ['upload', 'url'], status ['pending', 'transcribing', 'processing', 'completed', 'failed'], duration_seconds)
- Generated_Clips: (id, video_id, user_id, clip_title, start_time_seconds, end_time_seconds, virality_score, storage_url_mp4, is_scheduled, scheduled_time, is_posted)
- Newsletters_Sent: (id, subject, body_content, total_sent, created_at)

3. USER DASHBOARD & CORE FUNCTIONALITY
- Ingestion Terminal: Support local drag-and-drop file uploads (MP4) and URL pasting (YouTube, Instagram, TikTok links using yt-dlp on the backend).
- Automated Video Logic Mocking: Balance verification must happen before ingestion. If credits are sufficient, deduct appropriate minutes. For the MVP, provide a fully functioning interface connected to backend mocks that progress cleanly through transcription, timestamp evaluation, and composition.
- Interactive Editing Studio: The dashboard must show generated clip outputs on a grid. Each card requires: a video playback frame, an editable text field for titles, an explicit 'Download MP4' action path that pulls directly from the cloud storage bucket, and a secondary scheduling layout.
- Subtitle Customization Sidebar: Users must be able to change typography settings in real-time (fonts like Montserrat Bold, Impact; colors; text strokes) and toggle a rule to "Auto-add 3s trending random meme hook at video start."

4. MULTI-CURRENCY BILLING & GEOLOCATION DISPATCH
- Implement an automated location-routing loop at the app level. If the client IP is from India, lock the workspace to INR (₹) and deploy Razorpay SDK infrastructure. For international traffic, route to USD ($) utilizing Paddle or Lemon Squeezy (acting as a Merchant of Record).
- Build a dual-state credit interactive slider panel on the front page ranging from 300 minutes to 3,000 minutes. Fetch tiered configurations dynamically from the database table (applying a 20% discount above 1,000 credits, 40% above 2,500 credits). Includes a promo code redemption form that runs backend validations against active database coupons.

5. CONTENT CALENDAR & SOCIAL MEDIA QUEUE
- Each clip card must have an option to pick a target date/time and select platform destination toggles (YouTube Shorts, Instagram Reels, TikTok).
- Save these inputs into the `generated_clips` queue table and render a global visual "Content Calendar" view dashboard where the user can inspect, modify post times, or delete scheduled actions seamlessly.

6. MASTERS CONTROL OPERATIONS PORTAL (Gated at /admin)
Create an administrative control workspace restricted strictly to users with the 'admin' role flags. It must contain separate UI modules for:
- Packages & Inventory CRUD: Data tables to add, update, discount, or deactivate packaging tiers on the fly without updating codebase arrays.
- Coupon Code Engine: UI to spawn code strings with custom maximum limits, expiration dates, and discount rates.
- Wallet Overwrite Suite: Searchable client ledger allowing the admin to manually add/subtract minute token balances from profiles or override permissions.
- In-App Alerts & Newsletter Broadcast: Rich text template view to dispatch mass messages. The execution must insert tracking records into `newsletters_sent` and push instant UI alerts to user account side-drawers.
- Analytics Hub: Visual metric overview tracking Total Platform Revenue, Active Subscriptions, Total Videos Processed, and aggregate fleet remaining credits.

7. COMPLIANCE & SECURITY DELIVERABLES
- The application backend must process payment updates using secure, signed webhook listener endpoints (not client-side success callback loops).
- The global layout must implement responsive layout principles, smooth loading skeletons, custom toast feedbacks, and explicit legal page components (Terms of Service, Privacy Policy, Refund Policy) in the footer.