Changelog

Today's release focuses on massive improvements to our data ingestion engine, giving users more ways to import their historical data while bulletproofing our background workers.

Added

• Manual CSV Import: Added a robust client-side CSV importer. Users can now manually upload their Teachable transaction exports to populate their dashboards.
• Tiered Import Limits: Implemented smart file-size limits for CSV uploads (10MB for Core users to get a "cold start", 50MB for premium tiers).
• Onboarding Dashboard: Added a new "Cold Start" view to the Financials dashboard, clearly presenting users with their data connection options (Automated API Sync vs. Manual CSV Upload).
• Dynamic Upsells: Added custom marketing copy capabilities to locked features, explaining exactly what users unlock when they upgrade.

Updates

• Permission Simplification: Streamlined our access control logic. The Core plan now officially supports manual data imports to help new users experience the platform faster.
• Background Worker Efficiency: Upgraded the QStash background sync engine to detect terminal authentication errors (like an invalid API key) and gracefully abort, saving server resources.
• Database Schema: Upgraded the Transaction schema to natively capture Product Names, ensuring imported CSV data (which lacks Teachable Course IDs) still beautifully populates dashboard charts.

Fixed

• Bug: Fixed a critical "Ghost Tenant" database crash where overlapping Teachable transaction IDs across different accounts would cause imports to fail.
• Bug: Fixed an issue where the CSV importer would crash on batch duplicate transactions. (Deduplication is now handled efficiently in-memory before saving).
• Bug: Fixed a UI bug where invalid Teachable API keys would fail silently in the background. The dashboard now instantly flags the user with a helpful error message and a link to update their settings.
• Bug: Fixed a naming mismatch in the feature lock UI between the "Scale" and "Mastery" subscription tiers.

Today we focused on reviewing the excellent feedback we've received via email and videos from our beta users.

Added

• Sorting Columns: Added sorting options to the transaction and VIP tables for easy sorting by LTV and number of enrollments.
• Custom Date Range Filter: Added a custom date range filter to the transaction table and VIP views.

Updates

• UI Improvement: Added info badge to show exactly what date period the data table is showing.

Fixed

• Bug: Connected Google Sign in so that users can now sign in with their Google account.
• Bug: Fixed a problem where new users would not be able to create a new subscription.
• Bug: Fixed a bug where the pricing table would not display the monthly price.

Today's update brings powerful new CRM metrics to the student profile, laying the groundwork for better insights, alongside several key bug fixes for historical transaction data.

Added

• Student Lifetime Value (LTV): Updated the LTV metric to the student profile that dynamically calculates total revenue generated by a student, automatically deducting any partial or full refunds.
• Risk Indicator Badges: The student profile now automatically flags high-risk accounts with visual warning badges if a student has a history of standard refunds or bank chargebacks.
• CSV Importer UI (Beta): Shipped the foundation for the new Insight tier's drag-and-drop CSV importer dropzone (parsing logic coming soon).

Changed

• Discount Detection: Upgraded the discount detection logic to strictly check for the presence of a coupon_id, eliminating bugs caused by cross-currency exchange rate math.
• Discount Badges: Updated the "COUPON APPLIED" badge to the transaction table for easily identifying discounted sales.
• Payout Normalization: Hardcoded the "Paid" column in the transaction table to exclusively format as USD, accurately reflecting Teachable's backend payout normalization regardless of the local list price currency.

Fixed

• List Price Display Bug: Fixed an issue where the transaction list price would display as $0 for archived or custom-bundled plans. The system now correctly pulls the exact historical final_price from the original receipt.
• Refund Math Accuracy: Patched the LTV calculation engine to use the exact amount_refunded field from the API, ensuring perfect math across both partial and full refunds without relying on fragile status strings.
• UI Table Styling: Resolved an HTML/Tailwind layering bug that was preventing custom row background colors and hover states from displaying properly in the transaction table.

Today we completed a major architectural overhaul of our data synchronization engine. By migrating from synchronous server actions to a resilient, background-driven queue system, we've positioned the platform to handle schools with hundreds of thousands of transactions without timing out or exceeding API limits.

🚀 Major Improvements

• QStash Background Worker Implementation: Replaced the vulnerable while(true) loop in Next.js server actions with a recursive background worker powered by Upstash QStash. This ensures that long-running imports are decoupled from the frontend and can run reliably in the background.
• Adaptive Time Windowing: Implemented a "smart" sync cursor that automatically adjusts its time window. The engine now attempts to sync in 1-month chunks for speed but automatically downshifts to 1-day or 1-hour increments if it detects a period with more than 10,000 transactions, staying safely within Teachable's pagination limits.
• Incremental Sync Logic: Introduced smart incremental syncing. The engine now detects previous successful syncs and only pulls the last 5 days of data for existing schools, drastically reducing API overhead and Upstash message usage.
• Schema Simplification: Streamlined the Transaction model by removing redundant schoolId fields in favor of our internal encrypted tenantId partitioning.

🛠 Technical Changes

• Teachable SDK Enhancements: Modified lib/teachable.ts to support an override context, allowing background workers to bypass Clerk authentication and inject decrypted API keys directly into requests.
• Real-time Progress Polling: Refactored SyncManager.tsx to poll the database state. The UI now accurately reflects background progress even if the user navigates away and returns to the dashboard.
• Automated Retries: Leveraged QStash's built-in retry logic to automatically handle Teachable API 429 (Rate Limit) errors with exponential backoff.

🔒 Security & Access

• RBAC Refinement: Centralized feature gating in lib/access-rules.ts by integrating the checkPermission helper from lib/plan-details.ts. This ensures that Admin vs. Staff permissions are consistently applied across all subscription tiers.
• Worker Authentication: Secured the new /api/qstash/sync endpoint using QStash signature verification to ensure only authorized queue messages can trigger data processing.

This release includes a major overhaul of our subscription tiers to better align with the value we provide, alongside critical infrastructure upgrades and mitigations for third-party API instability.

Added

• Pricing Page Safeguards: Added a highly visible warning banner to the pricing page clarifying that an active Teachable Pro plan (or higher) is strictly required to unlock the API and webhook access Optio needs.
• Import Feature Gating: Restructured the historical data import strategy to align compute costs with customer Lifetime Value (LTV). Core is now real-time webhook only, Insight will support CSV uploads, and Mastery retains the premium background API sync.
• Smart Quota Resets: Added defensive logic to the Stripe webhook listener so that email limits (quota.emailsSent) only reset on genuine recurring subscription payments, ignoring manual one-off invoices.
• Update Notice: Added a link to the changelog and repo hash on GitHub (for internal tracking) into the update notice banner.

Changed

• Tier Renaming: Completely overhauled the subscription tier names from Starter, Growth, and Scale to Core, Insight, and Mastery. This eliminates UI and marketing confusion with Teachable's native plan names.
• Database Migration: Successfully executed a database-wide update across the MongoDB tenants collection, safely mapping all existing user records to the new plan identifiers.
• Stripe Webhook Resiliency: Refactored the POST webhook listener for Stripe renewals. The mapping function now safely supports the new uppercase STRIPE_PRICE_* environment variables while retaining legacy ID fallbacks, ensuring existing users are never accidentally downgraded during their billing cycle.

Fixed

• Teachable Pagination Crashing: Investigated and mitigated a critical failure where the Teachable API threw unhandled exceptions ("error": "unknown") during paginated batch requests. Isolated the issue to specific malformed records on their backend and adjusted our internal import strategy to handle their API's fragility.

We've deployed a major update to how Optio handles permissions, specifically focusing on the new Tutor role, alongside a critical database upgrade that isolates financial configurations from course management.

🛡️ Tutor Role-Based Access Control (RBAC)

Tutors now have a strictly walled-off experience to ensure they only see the students and courses relevant to their assigned subjects.

• Smart Course Filtering: Tutors navigating to the Courses view will now only see courses that are mapped to their assigned categories (e.g., a "Math" tutor only sees Math courses).
• Filtered Student Directory: The Student Directory now pre-filters API requests so Tutors only see students who are actively enrolled in their specific courses, eliminating data leakage.
• Robust Category Matching: The category matching engine was overhauled to be case-insensitive and support comma-separated lists. An admin can now map a course to "Math, Science", and tutors assigned to either category will securely gain access.

🗄️ Architecture: Settings Data Split

Previously, financial product aliases and course categories shared a single database field (productMappings). This created a risk where a VA cleaning up financial dashboards could accidentally overwrite a Tutor's course access.

• Two Distinct Maps: The database has been cleanly split into productOverrides (used exclusively for Financial reporting) and courseCategories (used exclusively for Tutor RBAC).
• Dedicated Manager UIs: We launched two separate UI views in the Settings dashboard:
  • Product Name Overrides: A manual mapping tool for VAs and Admins to clean up raw Teachable Bundle IDs on the Financials dashboard.
  • Course Categories: A new, smart UI that automatically fetches and searches through all Teachable courses, allowing Admins to assign categories with a seamless auto-save feature.

🐛 Bug Fixes & Stability

• Zod Schema Modernization: Upgraded the Teachable API response validation to use Zod's modern looseObject() pattern, ensuring unexpected future payload changes from Teachable don't break the application.
• Sentry / Clerk Middleware Crash Resolved: Fixed a persistent issue where automated bot traffic requesting missing static assets (like favicon.png) bypassed the Next.js proxy matcher but triggered the root layout's auth() check, causing false-positive crashes in Sentry.
• Prop Cleanup: Standardized prop drilling across the Student Lookup and Financial components to properly reflect the new productOverrides nomenclature.

Today, we are rolling out our changelog so everyone can see what's available in our latest release.

Added

• A simple markdown changelog.

Changed

• Improved the footer navigation links.

A major leap forward in financial reporting. The new Sync Manager allows schools to pull in historical transaction data to generate beautiful, server-side rendered financial pulses.

Added

• Transaction Sync Manager: A robust sync feature to safely import your Teachable transaction history.
• Financial Pulse Dashboard: Daily revenue trend graphs, tooltips, and server-side rendering for lightning-fast financial insights.
• Whales Tracking: Advanced models to identify and track your highest-spending "Whale" students.
• Founder Tier & Feature Locking: Rolled out the exclusive Founder tier and implemented dynamic feature locking based on active subscription tiers.
• Legal: Published official Privacy Policy and Terms of Service.

Fixed

• Strict enforcement of LTV views: Virtual Assistants without explicit financial permissions can no longer view Lifetime Value data.
• Fixed the team quote calculation bug.
• Corrected redirect URLs to properly utilize environment variables in production.

This release introduces our self-serve billing infrastructure and gives school owners more control over how their courses are mapped within Optio.

Added

• Stripe Integration: Full checkout, webhooks, and a self-serve customer billing portal.
• Product Mapping & Course Hiding: You can now map specific products and hide certain courses from your dashboard views.
• Announcements: New admin capability to push platform announcements.
• VIP Views: Initial mockups and data structures for tracking high-value students.

Fixed

• Fixed edge cases resulting in duplicated tenants and improved user linking during onboarding.
• Addressed upgrade/downgrade logic issues, including removing "none" plan errors from the billing view.
• Fixed multiple bugs related to the admin-initiated invite system, token generation, and invite messaging.
• Platform owners no longer count towards the admin seat limits.

A massive update that defines our core value proposition: secure, granular control for scaling schools. We've officially rebranded from Cato to Optio and completed our core Teachable integration.

Added

• Granular Role-Based Access Control (RBAC): Complete overhaul of our permissions system allowing for highly specific access rules across the platform.
• Teachable API Bridge: The main data conduit connecting Optio to your Teachable school is now fully operational.
• Official Rebrand: All branding, UI, and references updated to Optio.

Fixed

• Restored and stabilized the tenant creation flow, including edge cases for empty domains.
• Fixed multiple Next.js build errors and integration bugs related to Clerk middleware and school connection states.
• Ensure user synchronization occurs flawlessly when loading the dashboard layout.

Moving beyond infrastructure, this update introduces the first analytical capabilities to help schools understand their student base better.

Added

• Insights & Home Dashboard: A brand new high-level overview of school performance.
• Student Directory: Initial concept rollout for searching and managing the student roster.
• LTV & Retention Tracking: New features to track Student Lifetime Value (LTV) and course retention metrics.
• Student Notes: The ability for team members to edit, delete, and manage notes on individual student profiles.
• Team Settings: Expanded control over team member configurations.

Fixed

• Resolved an issue with the missing dashboard client on initial load.

Welcome to the first official development log! The core foundation of the application has been laid down, focusing on top-tier security and a seamless user experience.

Added

• Clerk Authentication: Enterprise-grade security for user sign-ins and team management.
• Database & Security: Implemented MongoDB with secure encryption protocols and dynamic tenant context to keep school data strictly isolated.
• School Settings Page: Secure area for API key management with masking and role-based navigation.
• User Management Dashboard: A dedicated space to manage active users and view actual course enrollment statuses.
• Theming: Full light and dark mode support across the entire application interface.