Software Updates

add supabase email templates and cart/wishlist counters

• Create branded email confirmation template with Supabase Storage logo
• Add storage setup guide for email assets
• Upload Katura logo to public storage bucket
• Remove quantity badges from checkout order summary
• Add cart item counter to shopping bag icon
• Add wishlist item counter to heart icon
• Create WishlistContext for wishlist state management
• Both counters show responsive badges with primary color styling

Add implementation summary for Stripe Payment Intents integration

implement Stripe Payment Intents with embedded Elements

• Add custom payment form with embedded Stripe Elements
• Implement two-step checkout flow (information → payment)
• Create PaymentIntent API endpoint for secure payment processing
• Add Stripe Elements provider with Katura brand theming
• Support Card, Apple Pay, Google Pay, and Link payment methods
• Enhance webhook handler for PaymentIntent success/failure events
• Update checkout page with multi-step progress indicator
• Add order lookup endpoints for success page
• Maintain backward compatibility with Checkout Sessions
• Add comprehensive Stripe Elements integration documentation
• Complete UI control while leveraging Stripe's payment processing
• 40+ payment methods via PaymentElement
• Built-in 3D Secure and fraud protection
• Real-time order creation and webhook-based confirmation
• Automatic Stripe Tax calculation (already configured)
• Email confirmations via Brevo CRM

implement stripe tax, fix cart & checkout, add multi-country support

• Implement Stripe Tax automatic calculation for accurate jurisdiction-specific taxes
• Add stripeCustomerId to User model for customer tracking
• Enable SessionProvider for useSession hook across app
• Fix cart page to use real API calls (updateItem, removeItem)
• Add ProductActions component with variant selection
• Add AddToCartButton to wishlist items
• Implement shipping calculation API with dynamic rates by country
• Add 44-country international selector (Americas, Europe, Middle East)
• Add state/province selectors for US, Canada, Mexico, Brazil (122 total)
• Fix international shipping to calculate immediately when country selected
• Remove placeholder 8% tax calculation - now handled by Stripe
• Update checkout UI to show tax calculated at Stripe checkout
• Add shipping cost display with proper free/paid indicators
• Session auto-fill for logged-in users (email/phone)
• Add gift message option with conditional textarea
• Implement currency formatting across checkout flow
• Add comprehensive documentation for all features

Remove invalid export from cart route handler

• mergeGuestCart is a helper function, not a Route export
• Next.js route handlers can only export HTTP method handlers (GET, POST, etc)
• Changed from 'export async function' to 'async function' to make it private
• Fixes Vercel compilation error

Remove unused ts-expect-error directive from UserSettingsPopover

• Removed unnecessary @ts-expect-error comment that wasn't suppressing actual errors
• Cleaned up comment that was not being used by stylelint
• Note: Inline styles for dynamic colors are necessary and won't block builds

Clean up UserSettingsPopover component

• Refactored color button mapping for readability
• Inline styles for dynamic colors are necessary and already allowed in ESLint config
• These legitimate dynamic color assignments cannot be moved to external CSS

Exclude onError from Button props in AddToCartButton component

• onError in component signature conflicts with HTML button onError event handler
• Added 'onError' to Omit to prevent type conflict
• Component's onError callback now properly typed for error messages

Convert null address fields to undefined in Stripe webhook handler

• Prisma JSON fields expect undefined, not null
• Updated buildAddress function to convert null values to undefined
• Fixes type mismatch error in shippingAddress assignment
• Regenerated Prisma client

Change Payment query from findUnique to findFirst for stripeCheckoutSessionId

• stripeCheckoutSessionId is not a unique field in Payment model
• Changed findUnique to findFirst to properly fetch payment by session ID
• Added type annotation for items mapping
• Regenerated Prisma client to resolve type conflicts

Update ProductVariant price field reference from 'price' to 'variantPrice'

• ProductVariant schema uses 'variantPrice' field, not 'price'
• Updated cart API endpoints to use correct field name
• Regenerated Prisma client to resolve type issues
• Fixes compilation errors in cart PATCH and DELETE handlers

Add database migrations and e-commerce setup scripts

• Add SQL migration for Cart, CartItem, Order, OrderItem, Payment, Shipment tables
• Create migration runner script for Prisma-based SQL execution
• Add comprehensive E-commerce implementation checklist
• Update environment configuration documentation
• All e-commerce database tables now ready and verified

Repair corrupted newsletter route file

Complete e-commerce implementation

• Add /api/cart endpoints (GET, POST, DELETE) with guest session support
• Add /api/cart/[itemId] for item update/delete operations
• Create CartContext for global cart state management
• Implement HTTP-only cookie-based sessions for guest carts (30-day TTL)
• Support cart merge on user login
• Wire checkout page to real cart data via useCart hook
• Submit { items, email, phone, shippingMethod } to /api/checkout
• Add /api/orders/by-session/[sessionId] endpoint for order lookup
• Update success page to fetch and display real order data from DB
• Add error handling and loading states
• Add upsertBrevoContact() function for CRM sync
• Add contact sync at: user signup, order completion, newsletter signup
• Add email templates: welcome, order confirmation, internal notification
• Configure Brevo list IDs via environment variables
• Welcome email sent on user registration
• Order confirmation email to customer after checkout
• Order notification email to support/ops for fulfillment
• Add CartProvider to locale layout
• Create AddToCartButton component with loading/success states
• Export cart utilities from /components/cart/index.ts
• Add ECOMMERCE_IMPLEMENTATION.md with complete setup guide

add comprehensive Brevo email integration guides and environment configuration reference

add Stripe webhook test endpoint and comprehensive documentation

• Create /api/webhooks/stripe/test endpoint for simulating webhook events
• Support three event types: checkout.session.completed, payment_intent.succeeded, payment_intent.payment_failed
• Test endpoint automatically disabled in production (security)
• Full database update simulation for order and payment records
• Event validation and order existence checks
• Add 14 comprehensive documentation files:
• STRIPE_TEST_ENDPOINT_CREATED.md - Status summary
• STRIPE_TEST_COPY_PASTE.md - Ready-to-use curl commands
• STRIPE_WEBHOOK_TEST_GUIDE.md - Complete testing guide
• STRIPE_TEST_ENDPOINT_QUICK_REF.md - Quick reference
• Plus 10 other setup and configuration guides

Fix TypeScript error and increase logo size by 17%

Reduce header logo size by 50%

Switch header logo to 'logo copy 2.png' and increase logo sizing

Adjust header dimensions

• Increased header height: h-24/h-28/h-32 → h-28/h-32/h-40
• Reduced logo size by 30%: h-16/h-20/h-24 → h-11/h-14/h-16

Add Bespoke page and fix header logo sizing

• Created /shop/bespoke page with full bespoke commission funnel
• Hero section with CTAs
• Unique pearls carousel for stone selection
• Past commissions gallery
• 4-step process section
• Commission inquiry form with file uploads
• Trust signals and FAQ section
• Added 'Bespoke' to navigation under Jewelry dropdown
• Created API endpoint for bespoke inquiries
• Added BespokeInquiry model to Prisma schema

Update popup delay and add shipping notice to products

• Increased email popup delay from 5 to 7 seconds
• Removed announcement bar from header
• Added shipping notice to product detail pages

Add email signup popup, update branding and legal pages

• Created email signup popup with $50 gift offer for first order
• Renamed blog to 'The Jewel Vox Blog'
• Enlarged Katura footer logo 2X and centered it
• Enlarged Katura header logo 50%
• Updated Privacy, Terms, Accessibility pages to remove direct contact info
• Added Contact Us button at bottom of legal pages

Add missing Task columns migration and documentation

• Created add_task_management_v2.sql migration to add missing columns:
• projectId, columnId, labels, riskLevel, blockedReason
• priorityScore, aiNotes, aiSuggestedNextStep
• Created Project, TaskColumn, Idea, TaskActivity tables
• Added TASK_MIGRATION_FIX.md with instructions for running in Supabase

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