Software Updates

Add automated segmentation + Brevo sync

• Implement Virgil's segmentation spec v1
• Lifecycle stages: LEAD, ACTIVE, LAPSED, DORMANT
• VIP tiers: NONE, VIP, TOP_SQRT (power-law √N), WHALE
• Country → Language auto-mapping (12 countries)
• All k_ prefixed attributes synced to Brevo
• Admin API for manual sync + stats
• Single customer sync for webhooks
• Nightly cron job (4am UTC) for full recompute
• Comprehensive documentation

dynamic segments API, segment selector, test email dialog, integrate into campaign wizard, docs

Reorganize documentation into logical folder structure

• Created organized folder structure:
• translations/ - All Portuguese translation docs
• analytics/ - Analytics audit and refactoring docs
• marketing/ - Marketing and lead management docs
• integrations/google/ - Google AdSense, Analytics, Merchant Center
• integrations/stripe/ - Stripe webhook docs
• features/ - Feature-specific documentation (hero-mosaic, orders, wholesale, etc.)
• security/ - Security audit and fixes
• performance/ - Performance optimization docs
• mobile/ - Mobile optimization checklists
• ios-app/ - iOS integration docs
• deployment/ - Deployment procedures
• bugfixes/ - Bug fix documentation
• database/ - Supabase and migration docs
• competitors/ - Competitor analysis
• project-management/ - Project tracking docs
• general/ - General reference materials
• Created comprehensive INDEX.md for easy navigation
• Moved 66+ root-level .md files into appropriate folders
• Maintained existing subfolder structure
• Better organization for finding documentation quickly

Mobile optimization for media page and language selector improvements

• Responsive grid layout: 2 columns on mobile, 3 on tablet, 4+ on desktop/larger screens (up to 6)
• Improved spacing with smaller gaps on mobile (gap-3) and standard gaps on larger screens (sm:gap-4)
• Responsive text sizes: smaller on mobile, standard on tablet/desktop
• Responsive button sizes: h-7/w-7 on mobile, h-8/w-8 on tablet/larger
• Icon size scaling: h-3/w-3 on mobile, h-4/w-4 on tablet/larger
• Responsive filter section: single search bar, then 2-column filter/sort on mobile, 3-column on sm+
• Improved padding: p-2 on mobile, sm:p-3 on tablet/larger
• Responsive header layout: stacked on mobile, row layout on tablet/larger
• Responsive dialog: max-height with scroll for mobile
• Better touch targets on mobile while maintaining desktop UI polish
• Display language name alongside flag (e.g., '🇺🇸 English')
• Hide language name on very small screens, show on sm+ (hidden sm:inline)
• Improved button styling with better text sizing

Add missing Portuguese translations for marketing pages and improve language selector UI

• Convert AdminLanguageSelector from 2 buttons to dropdown menu for better space utilization
• Add missing translation keys: filterByType, searchByProductName, tryAdjustingFilters, tryDifferentSearchTerm, clickToSelectVideos, loadingAnalytics, noDataYet, vsPreviousPeriod, heroPerformance, noDataMessage
• Wire media/page.tsx to use translations for search placeholder, filter dropdown, sort items, loading state, and empty state messages
• Wire video/page.tsx to use translations for upload dialog, search placeholder, loading state, and empty state messages
• Wire analytics/page.tsx to use translations for header, time range select, stat cards, tabs, and data loading messages
• Both English and Portuguese translations included for all new keys

add comprehensive marketing translation completion guide

wire up translations in all marketing pages - media, video, and analytics now fully support PT/EN

add complete Portuguese translations for marketing pages - email campaigns, promotions, media, and analytics fully translated

create unified /admin/marketing hub — move email, promotions, media; add media/video pages and API endpoints; update navigation

improve email signup popup visibility and simplify copy

• Changed X and minimize buttons to use text-foreground color
• Added hover:bg-accent background for better visibility
• Now visible on all screen types including OLED
• Reduced font size from text-xs (12px) to text-[11px]
• Added leading-tight for better line spacing
• Now fits on single line without wrapping
• Title: 'Join Katura' (simpler, more welcoming)
• Body: 'Receive a $100 gift instantly—yours to spend on any piece that speaks to you.'
• Button: 'Join' (clean, simple)
• Removed repetitive explanation
• Matches mom's conversational, warm writing style from Voice Guide

simplify email marketing for non-technical users

• Added to desktop header next to user dropdown
• Updated mobile nav with external link icon
• Removed from sidebar footer
• Welcome Email
• New Collection Announcement
• Sale/Promotion
• Christmas/Holiday
• Valentine's Day
• Re-engagement (We Miss You)
• Thank You
• VIP Early Access
• Step 1: Choose template from visual gallery
• Step 2: Customize with drag-and-drop editor
• Step 3: Select audience (simple options)
• Step 4: Review and send
• Progress indicator shows where you are
• Visual grid of templates with categories
• Filter by: Welcome, Collections, Promotions, Holidays, etc.
• Click to select, shows checkmark when selected
• Browse uploaded images
• Search functionality
• Quick insert into emails
• Floating help button on marketing pages
• Step-by-step guide for creating campaigns
• Tips for writing good emails
• Personalization tag reference
• FAQ section
• Prominent 'Start Creating' CTA for beginners
• Clean, welcoming interface

Rename migration files from 'jared' to 'competitor'

Add copy writing reference completion summary

Archive 9 Jewel Vox blog posts to Copy Writing folder, add comprehensive README

Add hero explainer for mom, rewrite FAQ in Katura voice, archive Shopify copy

Full hero impression tracking system

hourly rotation, analytics schema, impression tracking spec, rename competitor docs

add visual drag-and-drop email editor for marketing campaigns

• Install react-email-editor (Unlayer) for WYSIWYG email design
• Create VisualEmailEditor component with three modes: Visual, HTML, Preview
• Add Katura-branded default template with gold buttons and dark header
• Support merge tags for personalization (firstName, lastName, email, company)
• Update campaign creation wizard to use visual editor as primary option
• Update template creation page to default to visual editor
• Export forwardRef methods for parent components to access exportHtml()
• Add AudienceQueryFilter type export to validations module
• SQL migration created and run successfully - all marketing tables created

update AudienceQuery imports to use validations module

resolve AudienceQuery duplicate export conflict

correct type assertions for Json to AudienceQuery conversions

correct SQL migration field names and types to match Prisma schema

add in-app marketing (Brevo integration, templates, campaigns, UI & settings)

Update dashboard stats to show trailing 12 months revenue and orders

Fix order source display to use actual source field instead of computed value

Force clean rebuild to fix 500 errors

Remove broken debug endpoint to fix build

Force push debug endpoint

Add debug session endpoint with DB check

Fix user deletion to cascade delete audit logs and verification tokens

Fix hydration error in employees page - use consistent date format

Fix React hydration error #418 in analytics pages - use client-only LiveClock component

Add working signout page at /signout

Add debug session endpoint

Use feminine form by default in Portuguese invitation emails

• 'Convidada' instead of 'Convidado(a)'
• 'Prezada' instead of 'Prezado(a)'
• 'Bem-vinda' instead of 'Bem-vindo'

Fix employee invitation flow: language support, auto-login, and status activation

• Change title to 'Create Your Password' for invitations (vs 'Reset Password')
• Add full Portuguese translation support
• Read language from URL param (?lang=pt or ?lang=en)
• Auto-sign in employees after creating password
• Redirect to /admin (or /employee-login if signin fails) instead of /login
• Show 'Account Activated!' success message for invitations
• Reset password API now sets isActive=true when employee accepts invitation
• Returns employee info and adminLocale for proper redirect handling
• All invite routes now include &lang= param in the invite URL
• Employees now show 'Active' instead of 'Inactive' after accepting invitation

Remove role display from employee invitation emails

• Removed 'Your role: Manager' / 'Sua função: Gerente' section
• Cleaner email template with just welcome message and call-to-action
• Role is still stored internally but not displayed to the user

Add language selector to resend invitation and default language to edit employee

• Add resend invitation dialog with language selector (instead of immediate send)
• Add 'Default Language' field to Edit Team Member dialog
• Store adminLocale in database for each employee
• Use employee's stored language as default when resending invitations
• Update GET /api/admin/users to return adminLocale
• Update PUT /api/admin/users/[id] to save adminLocale

Fix employee invite email: use actual logo image, inline styles for email compatibility

• Use actual logo image from https://katura1999.com/brand/logo.png
• Switch from CSS classes to inline styles (better email client compatibility)
• Use table-based layout for consistent rendering across email clients
• Use link tag instead of @import for Google Fonts
• Add proper fallback fonts (Georgia, Times New Roman)

Redesign employee invitation emails with Katura branding and language selection

• Created centralized email template at src/lib/email/templates/employee-invite.ts
• Styled to match Katura website branding (Playfair Display font, dark stone header)
• Removed 'invited by' text per request
• Removed all emojis from email content
• Added English and Portuguese language translations
• Added language selector dropdown to both 'Invite via Email' and 'Add Team Member' dialogs
• Updated all invite routes (/api/admin/users, /api/admin/invite, /api/admin/invite/resend) to accept language parameter

switch from Resend to Brevo for employee invitation emails

• Uses existing sendBrevoEmail helper from lib/email/brevo.ts
• No additional API key needed - uses existing BREVO_API_KEY
• Updated all 3 invite routes: /api/admin/users, /api/admin/invite, /api/admin/invite/resend
• Tagged emails with 'employee-invite' for tracking in Brevo

fix Prisma Json field type casting in wholesale store pipeline

switch from Supabase Auth to Resend for employee invitation emails

• All invite routes now use Resend API for reliable email delivery
• Generates tokens stored in VerificationToken table
• Links point to /reset-password with token for password setup
• Removes dependency on Supabase Auth email (unreliable on free tier)
• Updated fix-employee-invitations script to use Resend

set isActive for invite flow, send Supabase invite when creating employees; improve client invitation messaging; add fix-employee-invitations script