Software Updates

improve admin UI visibility and branding

• Add dark:bg-stone-700 background
• Add dark:text-stone-100 text color

properly paint admin wrapper to eliminate white strip

• Move background from main to outer wrapper div
• Add w-full min-h-screen to ensure full viewport coverage
• Add dark:bg-stone-900 for dark mode background
• Simplify AdminThemeProvider to only handle dark class toggle
• Remove layout styles from provider (handled by layout.tsx)
• Fixes white strip visible when content is centered in containers

improve admin header visibility and remove white strip

• Update AdminHeader background to white/dark:bg-stone-800
• Add explicit text colors for user name and chevron icon
• Add w-screen overflow-hidden to admin-root to prevent white strip
• Fixes header text visibility in both light and dark modes
• Ensures admin layout fills entire viewport without overflow

add dark mode background to admin main content area

• Add dark:bg-stone-900 to main element
• Fixes split light/dark background issue in dark mode
• Main content area now properly transitions with theme

provide AdminThemeContext before mount to prevent hook error

• Remove conditional context provision based on mounted state
• Always wrap children in AdminThemeContext.Provider
• Fixes 'useAdminTheme must be used within AdminThemeProvider' error
• AdminHeader can now safely use useAdminTheme hook

remove duplicate #admin-root ID causing hydration errors

• Remove duplicate id='admin-root' wrapper in layout.tsx
• Let AdminThemeProvider own the single #admin-root element
• Remove inline script (provider handles no-flash logic)
• Add flex h-screen classes to provider's root div
• Fixes React hydration errors on all /admin pages

comprehensive dependency system overhaul

• Fix Prisma version mismatch (@prisma/client 6.19.1)
• Add TaskDependency indexes for query performance
• Implement optimized cycle detection with max depth guard
• Add same-project dependency enforcement at API layer
• Add status guards to prevent completion with unresolved dependencies
• Add auto-unblock logic when blocker tasks complete
• Add comprehensive audit trail with DEPENDENCY_ADDED/DEPENDENCY_REMOVED
• Fix sidebar accessibility (aria-labels, title attributes)
• Fix dark mode flash with scoped CSS variables
• Add dark mode styling for forms, dialogs, dropdowns, toasts
• Fix script import paths (relative path corrections)
• Update Stripe API version to 2025-12-15.clover

add admin dark mode and task dependencies UI

• Add AdminThemeProvider with localStorage persistence (light/dark/system)
• Implement scoped dark mode for /admin pages only
• Add admin dark mode CSS variables and component overrides
• Create AdminThemeToggle in header with theme switching
• Add inline script to prevent flash of light theme on page load
• Install @radix-ui/react-tooltip dependency
• Create new Tooltip component
• Update task board API to include dependency data in responses
• Add Blocked and Blocks badges to task cards showing dependency status
• Create Dependencies tab in task drawer with full dependency management
• Support adding/removing task dependencies with search
• Show dependency status (completed/incomplete) with visual indicators
• Add activity log entries for DEPENDENCY_ADDED and DEPENDENCY_REMOVED

Add Admin Tasks Board (Asana/Trello-style) and organize documentation

• Admin Tasks Board with Kanban drag/drop
• Project-based task organization
• AI-powered task prioritization using OpenAI
• Ideas inbox for capturing and converting ideas to tasks
• Task dependencies, blockers, and risk tracking
• Complete audit log with TaskActivity tracking
• Project (with owner and columns)
• TaskColumn (Kanban lanes with WIP limits)
• Idea (raw ideas → convertible to tasks)
• TaskActivity (audit/event log)
• Extended Task with AI fields (priorityScore, aiNotes, etc.)
• POST/GET /api/admin/board/projects
• POST/GET /api/admin/board/columns
• POST/GET/PATCH /api/admin/board/tasks
• POST/GET/PATCH /api/admin/board/ideas
• POST /api/admin/board/ideas/[id]/convert
• POST/GET /api/admin/board/prioritize
• ProjectSidebar (project management)
• KanbanBoard (drag/drop task cards)
• TaskDrawer (detailed task editor with AI insights)
• /admin/tasks/board (main board)
• /admin/tasks/board/ideas (ideas inbox)
• rankTasks() function with OpenAI prioritization
• Analyzes due dates, dependencies, risk, impact
• Generates priority scores and suggested next steps
• Optional unblock strategy suggestions
• Organized 80+ markdown files into docs/ subfolder
• Created docs/INDEX.md for navigation
• Categorized docs by: guides, migrations, fixes, implementation, deployment, features, sql, summaries
• prisma/seed-tasks.ts with demo projects, tasks, and ideas
• Run with: npx ts-node prisma/seed-tasks.ts
• Added openai package for AI features
• Ensure OPENAI_API_KEY is set in .env for AI features
• Run migration: npx prisma migrate dev --name add_admin_board

comprehensive schema alignment and type fixes

• Fixed Decimal to number conversion in admin products page
• Removed empty include block in team pay route
• Changed deal.title to deal.name across all CRM routes
• Changed notes to crmNotes in CRM deals route
• Removed non-existent color field from CrmPipelineStage creation
• Fixed address1/address2/zip to addressLine1/addressLine2/zipCode in customer import
• Fixed productOrder JSON field handling (use spread conditional instead of null)
• Removed sku/location fields from InventoryItem (don't exist)
• Fixed ProductVariant creation (price/quantity don't exist, use actual fields)
• Fixed EngagementLead creation (firstName/lastName instead of name, removed source/preferredContact/budget fields)
• Fixed LeadStatus enum value (NEW instead of ACTIVE)
• Fixed JSON metadata type in recommendations

convert productOrder JsonValue to string for type compatibility

• productOrder from Prisma is JsonValue type, not string
• Convert to JSON string if it exists, or null if it doesn't
• Matches CategoryPageEditor interface expectation

remove productOrder: null from another CategoryPage creation

remove explicit null assignment for JSON field

• productOrder is a Json? field in Prisma, don't need to set it to null
• Omitting the field lets Prisma use the default (undefined/null)

remove password from Customer type, add hasPassword instead

• Created CustomerQueryResult type for Prisma query that includes password
• Updated Customer type to use hasPassword (boolean) instead of password field
• Map function now properly handles password extraction without exposing the hash

add missing stage fields (isWon, isLost) to select query and interface

• Updated getStages() to use select instead of include for explicit field selection
• Added isWon and isLost fields to Stage interface
• Made color field optional since CrmPipelineStage schema doesn't have it
• This fixes type mismatch between query result and Stage interface

correct CRM deal field names (name, closeDate) and types

• Changed deal.title to deal.name (actual schema field)
• Changed deal.expectedCloseDate to deal.closeDate (actual schema field)
• Added Decimal import and fixed type for deal.value
• Converted Decimal values to strings for currency formatting

add missing title and expectedCloseDate fields to CRM deals query

• Updated getDeals query to use select instead of include to explicitly include all required fields
• Fixed Deal type to use crmNotes instead of notes in _count

use Decimal type for RelatedProduct price in shop page

use Prisma Decimal type for price and caratWeight fields

remove non-existent diamondType field from loose diamonds page

• Changed diamondType to jewelryType (which actually exists in schema)
• Fixed type filter to use tags/name search instead of non-existent field
• Fixed syntax error in search query block

add missing diamondType field to loose diamonds query

• TypeScript was complaining that diamondType was missing from the query result but required by LooseDiamondProduct type. Changed from include to select to explicitly specify all required fields.

simplify Prisma configuration for Vercel compatibility

• Remove explicit output path from prisma schema (use default)
• Add .prisma/client to serverExternalPackages
• Remove standalone output (not needed for Vercel)
• Remove deprecated prisma config from package.json
• Simplify prisma.ts singleton

configure Vercel to bundle Prisma query engine binaries

• Add output: 'standalone' for serverless deployment
• Add outputFileTracingIncludes to ensure .prisma directory is included
• Update vercel.json to run prisma generate in buildCommand
• Simplify prisma.ts singleton pattern
• Remove redundant prisma generate from build scripts (handled by postinstall + vercel.json)

add comprehensive Prisma build error fix documentation

lazy-load Prisma Client to prevent build-time initialization errors

• Implement Proxy-based lazy initialization in prisma.ts
• Add webpack externals configuration for Prisma
• Update postinstall to always generate client
• Ensure Prisma binaries are bundled for Vercel deployment

add Prisma binary targets for Vercel deployment (rhel-openssl-3.0.x)

add debug endpoint to check product data on Vercel

make category queries case-insensitive and handle singular/plural forms

use webpack instead of turbopack for production builds (fixes Vercel middleware.js.nft.json error)

simplify middleware to minimal next-intl only for Vercel compatibility

use absolute imports in middleware for Vercel compatibility

simplify middleware to avoid Edge Runtime crypto issues

use Web Crypto API in middleware for Edge Runtime compatibility

add vector search and smart recommendations system

• Add pgvector support for semantic search with embeddings
• Implement ProductEmbedding and UserEvent models in Prisma
• Create /api/search/vector endpoint with blended vector+lexical search
• Create /api/recommendations endpoint for personalized suggestions
• Create /api/events endpoint for tracking views and purchases
• Add cookie-based anonymous user tracking (30 days, 50 items max)
• Implement backfill-embeddings.ts script for generating product embeddings
• Add embeddings.ts library with vector search utilities
• Add recommendations.ts library with recommendation engine
• Create VectorSearchBar component with semantic search
• Create ProductRecommendations components for display
• Add React hooks for search and recommendations (use-search.ts)
• Update middleware to initialize tracking cookies
• Fix sort dropdown to instantly update products without page refresh
• Add VECTOR_SEARCH_SETUP.md documentation
• Add SQL migration for vector_search_setup
• Blended vector and keyword search with RRF ranking
• Automatic fallback to keyword search if embeddings unavailable
• User event tracking for signed-in users (purchases, views, etc.)
• Anonymous tracking via HTTP-only signed cookies
• Personalized recommendations based on browsing history
• Similar products suggestions using vector similarity
• Popular products fallback when no personalization data
• Privacy-conscious with opt-out support

Add vercel.json config to fix middleware build

Fix i18n language selector to use cookie + reload

• Language selector now sets NEXT_LOCALE cookie and reloads page
• Works correctly with localePrefix: 'never' routing strategy
• Verified all jewelry fields are in product forms AND API routes
• Verified Smart sort is default and appears in dropdown
• SEO canonicals/hreflang correctly configured for no-prefix URLs

Add Smart sorting with click tracking and analytics

• Add clickCount and lastClickedAt fields to Product model
• Create /api/products/[id]/click endpoint for tracking views
• Add trackClick() to shop-products.tsx and category-products.tsx
• Add 'Smart' sort option (default) to sort-dropdown.tsx
• Update shop and category pages to default to Smart sorting
• Add Most Viewed Products section to admin analytics
• Create /api/admin/analytics/most-viewed endpoint

Add jewelry fields to products, implement task management system, fix i18n routing

• Added jewelry design fields (ringDesign, necklaceDesign, braceletDesign, earringDesign, hardwareFinish, hardwareMaterial, targetGender) to product forms
• Implemented complete task management system with Kanban/list views, dependencies, and comments
• Fixed i18n locale prefix issue: URLs now stay clean without /en/ prefix, language detection via cookie + middleware rewrite
• Moved proxy.ts to src/ for Next.js 16 compatibility
• Updated language selector to use next-intl's router.replace() with locale parameter
• Fixed TypeScript error in bulk-generate-descriptions.ts with proper DBProduct type
• Updated SEO/sitemap to use canonical URLs without locale prefixes
• Added i18n implementation guide and migration SQL for task management
• Updated admin navigation with Tasks link

prevent Stripe initialization at build time

• Move getStripe() call from module level to runtime in webhook route
• Add explicit type assertion to stripe proxy
• Fixes Vercel build error: 'STRIPE_SECRET_KEY is not set'
• Build now succeeds without environment variables
• Runtime still requires STRIPE_SECRET_KEY to be set in Vercel

Add bulk SKU generation and product media library

• Implement bulk SKU generation API endpoint and UI button
• Generates SKUs for all products without one in a single click
• Shows confirmation dialog and progress feedback
• Returns summary of succeeded/failed counts
• Only available to OWNER and MANAGER roles
• Create comprehensive product media library at /admin/media
• Browse and download product photos organized by jewelry type
• Smart filtering by type, search by name/SKU
• Sort by type (grouped) or alphabetically
• Individual and bulk download capabilities
• Direct links to product edit pages
• Fix Prisma field name issues in bulk SKU API
• Use correct field names: jewelryMaterial, metalType
• Handle null variant values safely
• Add product image API endpoint
• GET /api/admin/media/products returns all product images
• Includes product metadata (name, SKU, type)
• BULK_SKU_GENERATION.md - Feature guide and usage
• BULK_SKU_FIX.md - Technical fix documentation
• MEDIA_LIBRARY.md - Complete media library documentation

implement SKU generation system, AI descriptions, dynamic collections, and enhance admin UI

• Add SKU auto-generation with unique sequence counters (SkuCounter table)
• SKU format: TYPE-MATERIAL-NAME-VARIANT-SEQ (e.g., ER-AU-LUM-GLD-01)
• Add skuLocked and skuBase fields to Product model for manual SKU override
• Implement SKU preview and live generation in admin product forms
• Create OpenAI integration for AI-powered product descriptions
• Add /api/admin/ai/generate-description endpoint with fallback support
• Implement dynamic collections fetching (remove hardcoded collections)
• Create /api/admin/collections routes for CRUD operations
• Update product forms to fetch collections from database
• Add RefreshCw, Sparkles, Loader2 icons for UI improvements
• Improve SKU input with lock/unlock toggle for manual control
• Add description generation capability to both new and edit product pages