Software Updates

scoring normalization + seed real data for all 50 cities

• Fix scoring route to use min-max normalization (0-100 scale) instead of raw value * weight
• Invert negative weights (cost/friction metrics) so lower = better score
• Seed real-world data for 38 international cities (seed-market-data.cjs)
• Seed remaining 12 US cities (seed-remaining-us.cjs): Austin, Boston, Greenwich, Las Vegas, Naples, Newport Beach, Raleigh-Durham, San Diego, Seattle, Short Hills, Tysons, Washington
• All 50 cities now have 10 metric dimensions with confidence scores
• Add check-data.cjs utility to verify data coverage
• Add payroll module: 16 SQL migrations, API routes, tax engine, RBAC
• Add people directory pages

Use Prisma.JsonNull for nullable Json fields in audit.ts

• Prisma requires Prisma.JsonNull (not plain null) for nullable Json columns.

Order field is 'total' not 'totalAmount' in summary route

Remove invalid COMPLETED OrderStatus from summary route

• OrderStatus enum: PENDING, PAID, IN_PRODUCTION, SHIPPED, DELIVERED, CANCELLED, REFUNDED
• Was using non-existent 'COMPLETED' — replaced with valid statuses.

Restore 0-byte route files causing Vercel build failure

• api/admin/business-planning/budgets/route.ts (91 lines) — GET/POST budget CRUD
• api/admin/business-planning/summary/route.ts (145 lines) — P&L summary aggregation
• api/admin/business-planning/expansion/markets/route.ts (110 lines) — city rankings
• sizing-guide-a4.tsx (0 bytes, unreferenced)
• sizing-guide-us-letter.tsx (0 bytes, unreferenced)

AI Intelligence Layer — full transparency pipeline

• provenance.ts: Data source tracking, metric snapshot recording with 24h dedup
• collectors/world-bank.ts: GDP growth + tourism arrivals from World Bank API
• Analysis: strong/moderate/slow/contracting thresholds with confidence decay
• collectors/exchange-rates.ts: ECB rates with static fallback for 22 currencies
• Analysis: pegged currency detection, FX risk assessment
• collectors/overpass-luxury.ts: OSM luxury brand density (22 brands by Wikidata ID)
• Analysis: 5km radius, proxy index formula, mapping coverage confidence
• extractors/structured-extract.ts: GPT-4o structured extraction engine
• Enforces transparency: reasoning, evidence quotes, confidence notes
• extractors/rent-extractor.ts: AI rent benchmark extraction from real estate reports
• Specificity-based confidence: exact corridor vs city vs regional
• scoring/run-scoring.ts: Weighted scoring with min-max normalization
• Full factor breakdown: strengths, weaknesses, interpretations per metric
• Rank change detection vs prior run
• scoring/detect-anomalies.ts: 5 anomaly detection rules
• RANK_MOVEMENT, METRIC_SPIKE, CONFIDENCE_EROSION, DATA_STALENESS, NEW_ENTRANT
• scoring/generate-insights.ts: GPT-4o-mini weekly narrative reports
• Executive summary, opportunities, risks, action items with priorities
• Graceful fallback to structured-only report if AI unavailable
• index.ts: 6-phase orchestrator (collect → extract → score → detect → generate → store)
• Graceful degradation: each phase independent, partial results preserved
• api/cron/expansion-intelligence/route.ts: Weekly cron endpoint (Sunday 2am UTC)
• CRON_SECRET auth, skip flags, concise response summaries
• vercel.json: Added expansion-intelligence cron schedule
• determination: human-readable explanation of what this means
• factors[]: specific data points that drove the conclusion
• confidence: numerical score with documented decay rules
• evidence: source URLs, data years, extraction quotes

Monster v2 — Business Planning + Retail Expansion Intelligence

• P&L Overview with expense CRUD, revenue targets, real-time summary
• Forecasting with scenario modeling (3 pre-built scenarios + growth slider)
• Budget tracking by department with utilization %
• KPI Scorecards with RAG status (GREEN/AMBER/RED) and trend indicators
• Strategy & OKRs with objectives, key results, and initiatives
• Reports page (investor update, monthly review, tax prep templates)
• Market Rankings: 50-city scoring engine with configurable weights
• Site Selection: 50 retail corridors with rent benchmarks and filtering
• Store Economics: prototypes, rent/payroll/buildout benchmarks (4-tab view)
• Compliance Matrix: legal, tax, banking profiles for 21 countries
• Rollout Planner: multi-store timeline with runway impact
• 25+ new Prisma models for expansion intelligence
• SQL migration: 512 lines covering all tables
• City seed script: 21 countries, 50 cities, 50 corridors, 100 metric snapshots
• Scoring model (sm_default_v1) with 12 metric definitions
• All 12 API routes use Prisma typed model API (zero raw SQL mismatch risk)
• Business Planning navigation component with responsive desktop/tablet/mobile
• Full auth gating (OWNER/MANAGER only)
• All files verified: 0 TypeScript errors across 28 files

resolve useTranslations missing context error on /admin/cap-table

• The cap-table layout used next-intl's useTranslations() but the /admin
• route tree uses a custom AdminI18nProvider (not NextIntlClientProvider).
• NextIntlClientProvider only existed in the [locale] storefront layout.
• Fix: Split layout.tsx into a server component that reads the admin-locale
• cookie, loads the correct messages JSON, and wraps everything in
• NextIntlClientProvider. All client UI moved to cap-table-layout-client.tsx.
• This fixes the runtime error:
• Failed to call useTranslations because the context from
• NextIntlClientProvider was not found.

scope 'The Monster' — data-driven business planning (6 phases)

• Phase 1: Financial Dashboard & P&L Engine
• Phase 2: Forecasting & Scenario Modeling
• Phase 3: Budgets & Goal Alignment
• Phase 4: KPI Scorecards & Automated Insights
• Phase 5: Strategic Planning & Roadmap (OKRs)
• Phase 6: Business Intelligence Reports & Export

consolidate sidebar nav + CRM appointments tab + contractors section

• Remove Engagement Leads and Appointments from admin sidebar (now sub-tabs under CRM)
• Add Appointments as third tab in CRM (/admin/crm/appointments) with full calendar UI
• Redirect old /admin/appointments route to /admin/crm/appointments
• Update dashboard appointment links to new CRM route
• Add CRM keywords for appointment/engagement search terms
• Create Contractor model in Prisma (type, status, rates, tax/W-9 tracking)
• Add SQL migration for contractors table with enums and indexes
• Create full CRUD API at /api/admin/contractors with auth guards
• Build contractors page at /admin/employees/contractors with:
• Stats dashboard, search, type/status filters
• Create/edit/view dialogs with comprehensive form
• Table with name, type, contact, rates, status, W-9 columns
• Employee tab navigation with Contractors tab
• Add contractor keywords to sidebar search

add educational InfoTip tooltips + Portuguese i18n for all cap-table pages

• Created reusable InfoTip component (HelpCircle icon + Radix Tooltip)
• Added capTable namespace to en.json with 80+ educational tooltip strings
• Added full Portuguese translation of capTable namespace to pt.json
• Added InfoTips to all 12 cap-table pages: layout, overview, ownership, stakeholders, shares, options, convertibles, rounds, events, modeling (5 sub-components), subsidiaries, settings, compliance
• Every financial term (share classes, options, SAFEs, liquidation prefs, vesting, waterfall, dilution, etc.) now has a hover tooltip explaining it

split cap-table monolith (5,366 lines) into 12 separate route pages

• Created shared infrastructure: _lib/types.ts (interfaces, formatters, constants) and _lib/context.tsx (CapTableProvider + useCapTable hook)
• Created layout.tsx with shared header, nav bar, health checks, board approval banner, export dropdown
• Split into separate pages: overview, ownership, stakeholders, shares, options, convertibles, rounds, events, modeling, subsidiaries, settings, compliance
• Each page loads independently at /admin/cap-table/{section} for faster page loads
• Also includes BigInt serialization fix for cap-table API routes (bigint-serialize.ts utility)
• Original monolith preserved as page.tsx.old for reference

organize email marketing by month, fix Select empty value error, add rich text editor for Jewel Vox articles

• Create monthly subfolders (Feb-June 2026) for organized email marketing templates
• Move Valentine's 2026 campaign to february-2026/ subfolder
• Fix Select.Item empty value error in category selector (use 'none' sentinel value)
• Install TipTap rich text editor with formatting, color, alignment, lists, links, and image support
• Add RichTextEditor component with intuitive toolbar (headings, font sizes, bold/italic/underline, colors, alignment, lists, blockquotes, links, image upload/paste)
• Update article form to use RichTextEditor instead of plain textarea
• Add featured image file upload support with preview and remove button
• Improve UX for article creation/editing - mom can now format articles visually

translate WhatsApp tooltip in all 24 languages + move promo popup to bottom-left

• Added useTranslations('whatsappButton') for tooltip, aria-label, and title
• Added whatsappButton translations to all 24 language JSON files
• Tooltip now shows in visitor's language (e.g. French, Japanese, Arabic, etc.)
• Moved from bottom-right to bottom-left on desktop (sm:left-6)
• Avoids collision with WhatsApp bubble which sits at bottom-right
• Minimized state also parks at bottom-left
• Mobile remains centered at bottom (left-1/2 -translate-x-1/2)

hero mosaic layout for login & employee-login pages

• Split both login pages into server component (page.tsx) + client component
• Login page: login-form.tsx with 6×4 mosaic grid, Katura logo, no shadow
• Employee login: employee-login-form.tsx with same mosaic pattern
• Both fetch 20 product images from collage API (same as register page)
• Form sits in 2×2 center area, seamlessly blending with product tiles
• Mobile fallback: clean centered form on stone-50 background
• Preserved all existing logic: 3-step customer flow, employee audit logging

simplify mobile header to show only shopping bag icon

• Hide search, wishlist, and user menu icons on mobile screens
• Only display shopping bag icon on mobile to reduce header clutter
• Logo now has more prominent center position on mobile
• Search, wishlist, and account remain accessible via hamburger menu
• Icons reappear on tablet/desktop (sm breakpoint and above)

add comprehensive Ukrainian translations

• Translate common UI elements and navigation
• Add Ukrainian translations for homepage, hero, and trust signals
• Complete footer, engagement, education sections
• Translate product, shop, cart, wishlist sections
• Add blog and account Ukrainian translations
• Progress: significantly improved Ukrainian localization

Brevo product URLs /products/ → /creations/ to match actual site routes

• Root cause of marketing email 404s: Brevo ecommerce sync was using
• /products/{slug} but the site uses /creations/{slug}. This fixes the
• source. A product resync will update all URLs in Brevo.

fuzzy slug matching for partial/incorrect product URLs

• When exact slug not found, tries matching all keyword segments against
• active products. e.g. south-seas-pearls-diamond-clasp will match
• south-seas-pearls-on-diamond-and-14k-white-gold-clasp

add /products/ redirect to /creations/ for marketing email links