Software Updates

add scrolling to language selector dropdown

• Added max-height and overflow-y-auto to language dropdown so it matches
• the height of currency selector instead of extending off-screen with
• 24 languages. Users can now scroll through the language list.

use correct User table in CustomerMarketingProfile view recreation

• The view queries the User table, not a Customer table. Matched the
• original definition from add_brevo_marketing_tables.sql.

expand to 24 languages, 30 currencies, full SEO, security fixes

• Flag emoji next to currency in 'keep currency' button
• Inverse language prompt when switching currencies
• All 24 locales in language selector with correct flags
• All 30 currencies organized by region in currency selector

translate all footer-linked pages into 10 languages

• Contact page + ContactCards + ContactForm client components
• Shipping & Delivery page
• Returns & Exchanges page (+ add generateMetadata)
• About page (milestones, values, certifications all translated)
• Careers page (+ translate generateMetadata)
• Privacy Policy page (+ add generateMetadata)
• Terms of Service page (+ add generateMetadata)
• Accessibility Statement page (+ add generateMetadata)

Contact page: hide phone for guests, remove email, WhatsApp button

• Phone number only visible to signed-in users; guests see a lock icon with a prompt to sign in or use the contact form below
• Removed email display entirely (ObfuscatedEmail card gone)
• WhatsApp card now has a green 'Open WhatsApp' button that links directly to wa.me with a pre-filled greeting
• Layout changed from 4-column to 3-column (Phone, WhatsApp, Hours)
• Extracted ContactCards client component for session awareness

Add compensation currency/pay period to employees, South American currencies, and product reviews

• Fix compensation inconsistency between /admin/employees and /admin/analytics/team
• Employees page now reads from TeamMemberPay (source of truth) with User model fallback
• Saving compensation from employees edit dialog syncs to both User and TeamMemberPay
• refreshEmployees now also refreshes pay records
• Add pay period selector (Weekly, Bi-Weekly, Semi-Monthly, Monthly, Quarterly)
• Add compensation currency selector with all supported currencies
• Show live exchange rate conversion in table and edit form (e.g. R$2.000/yr ≈ $540 USD)
• Add South American currencies: COP, PEN, CLP, ARS
• Added to SUPPORTED_CURRENCIES with symbols, flags, locales
• Added rounding rules and fallback exchange rates
• Added to currency selector footer under South America
• Added to Spanish language currency options
• SQL migration: add compensationCurrency column + QUARTERLY enum value
• Product reviews system (from previous session)

move ssr:false dynamic import to client component wrapper

• next/dynamic with ssr:false cannot be used in Server Components.
• Created LazyEmailSignupPopup client component that wraps the
• dynamic import, then import that from the server layout.

prioritize product image + name by deferring all non-critical fetches

• Add <link rel='preload'> for hero product image in HTML head (browser starts fetching immediately, before any JS loads)
• Defer cart/wishlist/exchange-rate API calls via requestIdleCallback (these now fire AFTER first paint instead of blocking it)
• Lazy-load EmailSignupPopup with next/dynamic + ssr:false (removes it from initial JS bundle; it has 7s delay anyway)
• Stream related products via Suspense instead of awaiting them (product hero renders immediately, related products stream in after)

eliminate duplicate API calls, remove reCAPTCHA from global layout, disable link prefetch spam

• Remove ReCaptchaProvider from root layout (saves ~800ms script load on every page)
• Make useRecaptcha hook safe without provider (graceful degradation)
• Add prefetch={false} to all Link components in header (~15 links)
• Add prefetch={false} to all Link components in footer (~25 links)
• Eliminate duplicate /api/wishlist call: WishlistButton now uses WishlistContext instead of its own useEffect fetch (saves ~1000ms redundant API call)
• Add Cache-Control headers to /api/products/[id]/variants (5min CDN cache)
• Removed: reCAPTCHA scripts (797ms + children)
• Removed: RSC prefetch spam for /cart, /wishlist, /jewel-vox, / etc (~600-750ms each)
• Removed: Duplicate /api/wishlist call (1011ms)
• Cached: Variants API (was 1296ms uncached, now CDN-cached for 5 min)

product gallery video/photo bug + page performance optimization

• Video no longer auto-plays on page load — plays only on hover over the first photo (hover-to-play with badge hint)
• Clicking thumbnails/arrows now correctly switches between still photos — video overlay only appears when actively playing
• Video preload changed from 'auto' to 'none' — eliminates the heavy video download that was blocking initial page load
• Video pauses and resets when navigating away from first image
• Added Play icon badge on first thumbnail to indicate video
• Wrap getProduct() in React cache() to deduplicate the call between generateMetadata() and the page component (was hitting DB twice for every page load)
• Parallelize getRelatedProducts() — 4 jewelry type queries now run via Promise.all instead of sequential for loop (4x faster)
• Parallelize getProduct() + getTranslations() with Promise.all
• Add Suspense boundary around SimilarProducts (AI recs) so the client-side fetch doesn't block initial page paint
• Add proper sizes attributes to all Image components for responsive image optimization
• Set priority only on first gallery image, lazy-load thumbnails
• Related product images sized 400x400 (was 200x200) to prevent blurry upscaling on retina displays
• Related products now link via slug instead of ID for cleaner URLs
• Added slug to related product select fields

design-your-ring mobile white glow + black-on-black username

• Add useEffect to set body/html background to #0a0a0f on mount, restoring original on unmount — eliminates white glow visible through iOS overscroll and layout gaps
• Pass isDarkPage prop from Header to UserMenu instead of fragile window.location check — fixes black text on dark header for logged-in users on design-your-ring and developer pages

stripe webhook endpoint URL and order payment status

• Fixed Stripe webhook URL: katura.vercel.app → katura1999.com
• Added missing webhook events: checkout.session.* events
• Manually confirmed KAT-MLH23A05 payment (webhook had failed delivery)
• Future orders will auto-confirm on payment_intent.succeeded

register form email-first, hero table migration SQL

• Registration: moved email field above name field on both /register and /register?promo=welcome100
• Registration: changed placeholder from 'Your full name' to 'Your Name'
• Migration SQL: drop+recreate HeroPinRule and HeroBoostRule with correct schema (slotIds[], startDate/endDate, createdBy, etc.) — fixes 500 on /admin/analytics/hero

hero pagination+pinning, ShipStation auto-export, platform gap analysis

• Hero analytics: paginated results up to 50/page (15/25/50 selector)
• Hero mosaic: admin pin management API + UI (force-include products)
• Collage API: pinned products get weight=100 for guaranteed display
• Product search API: added slug, price, jewelryType fields
• ShipStation: auto-export orders on Stripe payment confirmation
• ShipStation: 15-min cron sync added to vercel.json
• Gap analysis: comprehensive doc comparing promo page vs actual features

welcome gift $500 min, mobile popup centering, admin-editable offer, smart registration

• Popup centered on mobile (left-1/2 -translate-x-1/2)
• $100 gift only redeemable on orders over $500 (configurable)
• New /api/welcome-offer endpoint reads from WELCOME100 promotion
• Popup, register API, and checkout all read amounts dynamically
• Register page detects existing customers, prompts for password only
• check-email API returns set-password for any passwordless user
• Duplicate gift card issuance prevention for returning customers
• Auto sign-in after returning customer activates account

exclude trunk show from hero mosaic cache + redirect to cart on Add to Bag

• Added 'hero-mosaic' tag to ISR fetch and unstable_cache for on-demand revalidation
• Created /api/admin/revalidate-hero endpoint to bust mosaic cache
• Bulk edit trunk-show actions now auto-revalidate hero mosaic cache
• DB queries already correctly exclude trunk-show tagged products; issue was stale ISR/API cache from before tags were applied
• AddToCartButton now redirects to /cart by default after successful add
• Added redirectToCart prop (default true) for CTA reinforcement
• Wishlist uses redirectToCart=false to keep toast-only behavior

3-step checkout flow (Information → Payment → Confirmed)

• Redesigned checkout from 2-step to 3-step inline flow
• Step 1 (Information): contact, shipping address, gift options, promo codes
• Added sign-in/create-account option for guest customers
• Changed lead time notice from yellow/amber to stone color scheme
• Removed lead time checkbox, replaced with passive acceptance text
• Step 2 (Payment): Stripe PaymentElement with billing auto-filled from step 1
• Shows shipping summary with edit button to go back
• Step 3 (Confirmed): inline order confirmation (no redirect to /checkout/success)
• Shows order number, confirmation email, What Happens Next steps
• Continue shopping and view order status buttons
• Added 3-step progress indicator with emerald checkmarks
• Fixed PaymentForm to not redirect when onSuccess callback is provided
• /checkout/success route preserved as fallback for redirect-based payments (3DS, Pix)
• Added translations for all 10 languages (en, pt, de, es, fr, it, ja, ko, zh, ar)

tag-based trunk show system with bulk edit

• Products tagged 'trunk-show' are excluded from category pages, hero mosaic, and related products
• But keep their actual jewelryType (Bracelet, Earrings, etc.) for SEO
• POST /api/admin/products/bulk-edit - bulk add/remove trunk show tags
• /admin/products/bulk - bulk edit page with product selection and filters
• Trunk Show checkbox on individual product edit form
• category-page.tsx: tags filter instead of jewelryType check
• creations/page.tsx: tags filter for main shop
• creations/trunkshow/page.tsx: query by tag instead of jewelryType
• creations/[id]/page.tsx: related products exclusion by tag
• admin products/trunkshow API: query by tag
• admin products page: trunk show count by tag
• hero analytics/collage/cache: tag-based exclusion
• payment intent: tag-based trunk show detection
• Removed 'Trunkshow Special' from jewelry type dropdowns

reclassify 18 trunk show products to correct jewelry types, boosting hero eligibility from 71 to 89

• Updated 17 'Trunkshow Special' products to their actual types (Earrings, Bracelet, Necklace)
• Fixed 1 product with null jewelryType ('Pearl Stud Earrings Light Gold Round Orb' -> Earrings)
• Removed now-unnecessary trunk show exclusion filter from 3 locations:
• src/app/api/admin/analytics/hero/route.ts
• src/app/api/products/collage/route.ts
• src/lib/cache/collage-cache.ts
• Final distribution: Earrings=40, Necklace=27, Ring=13, Bracelet=9

Brevo eCommerce product sync for email editor Product Block

• Add src/lib/brevo/ecommerce.ts - full Brevo eCommerce API client (activate, create/update products, batch sync, categories, list)
• Add src/app/api/admin/brevo/products/route.ts - admin API for manual sync (activate, full sync, single product sync, list)
• Add src/app/api/cron/brevo-product-sync/route.ts - nightly cron syncs all active products + categories to Brevo at 5 AM
• Update daily cron to include product sync as Task 6
• Update vercel.json with brevo-product-sync cron schedule
• Batch fallback: if batch API fails, falls back to individual product sync so partial failures don't block the entire catalog

Fix hero mosaic eligibility: add Pendant type, trunk show exclusion, and storefront filtering

• Add 'Pendant' to JEWELRY_TYPES in collage route, analytics route, and collage cache
• Add explicit storefrontId filter to analytics route and collage cache (katura_storefront_001)
• Add NOT filter to exclude 'Trunkshow Special' products from hero mosaic
• Update category-to-type mapping: pendants -> 'Pendant' (was 'Necklace')
• Update analytics rules text to reflect current filtering criteria

Suppress CSS inline style and Tailwind class lint warnings

• Replace inline style={{ gridTemplateColumns }} with Tailwind grid-cols-N classes via lookup map in media/page.tsx
• Add tailwindCSS.lint.suggestCanonicalClasses: ignore to suppress z-[100]->z-100 and sm:w-[200px]->sm:w-50 class shorthand hints
• Add css.lint.inlineStyles: ignore at top level and per-language scope for any remaining inline style usage in TSX files

Fix 4 QA issues: header dark mode, design folder nav + previews, media size control, marketing redirect

• 1. Header dark mode (/design-your-ring): Account name/icon now properly
• inverts to white on dark pages (expanded isDarkPage check in user-menu)
• 2. Admin design page: Fixed folder detection (Supabase returns id=null for
• folders), fixed folder click navigation to build full paths, fixed back
• button to go up one level, added image previews with signed URLs in both
• grid and list views
• 3. Admin media page: Added adjustable grid size control (2-8 columns per row)
• with slider and +/- buttons for viewing more images at once
• 4. Marketing/media redirect: All 3 marketing/media sub-pages now redirect
• to /admin/media to eliminate redundancy

Fix 4 admin bugs: revenue mismatch, folder date, Leads0, drag-drop

• Customers page was showing all-time totalSpent from User model
• Dashboard shows trailing 12-month revenue from settled Orders
• Now both use the same calculation: 12-month settled order totals
• Label changed to 'Revenue (12 mo)' with consistent formatting
• Supabase Storage folder objects have null/empty created_at
• new Date(null) resolves to Unix epoch (12/31/1969)
• Added formatDate() helper that returns '—' for invalid/epoch dates
• Applied to both grid and list views, plus sort comparator
• Classic React bug: {0 && <Component/>} renders literal '0'
• Changed condition from 'item.badge && item.badge > 0' to 'Number(item.badge) > 0' which evaluates to boolean false
• Replaced relatedTarget-based dragLeave with drag counter pattern
• Added onDragEnter handler with Files type check
• Counter increments on enter, decrements on leave, resets on drop
• More reliable across browsers and nested DOM elements

Fix 4 admin issues: CAD drag-drop upload, taxonomy counts, birthday timezone, wholesale PT translations

• Added drag-and-drop file upload to the entire page and individual folders
• Folders visually highlight when dragging files over them (📁→📂)
• Added 'Upload to [folder]' button when inside a folder
• Empty folders now show drag-and-drop hint instead of generic message
• Product counts now match by productType/jewelryType/productCategory name
• Previously only counted ProductCategoryLink entries (always 0 for Shopify imports)
• Children categories also get enriched product counts
• Category creation: improved error handling, wrapped audit log in try/catch
• Added timeZone: 'UTC' to all birthday/anniversary date displays
• Fixed off-by-one day bug (UTC midnight → local timezone shift)
• Applies to customer detail page and linked people card
• Added wholesalePage section to AdminTranslations (EN + PT)
• Created WholesaleHeader reusable component for translated page titles
• Translated: WholesaleNav, WholesaleOverview, WholesaleAccountsClient, WholesaleLeadsClient, WholesaleSettingsClient
• All 5 wholesale pages and pipeline now use translated headers

Hero mosaic DESIGN YOUR RING button to point to /design-your-ring instead of /engagement/design

DESIGN YOUR RING button to use relative link instead of hardcoded absolute URL

Complete 5 admin panel tasks: CAD upload flow, hero mosaic audit, translations, bug fixes

update Design Your Ring button to external URL

• Changed home page CTA button from internal route /engagement/design to https://katura1999.com/design-your-ring
• Updated navigation config to use external URL for consistency
• Button now directs to external design-your-ring page

Re-enable commission rate fields in orders API

• Viewing commission rates on orders
• Seeing calculated commission amounts
• Full commission tracking integration with sales rep assignments

Add migration helper scripts for commission tracking

• add_order_commission_columns.sql: Quick fix for missing Order commission columns
• check_commission_migration_status.sql: Diagnostic script to check migration status

Remove commission rate fields from orders API to prevent 500 errors

• The orderCommissionRate and orderCommissionAmount fields were selected
• in the orders API query but may not exist in production database yet.
• Temporarily removed from API response to fix 500 errors.
• Commission tracking still works via /api/admin/commissions endpoint
• and the orders [id] route which handles commission calculation.

Add commission tracking and employee compensation system

• Commission Tracking: New /admin/goals Commissions tab with filterable table, bulk approve/pay, monthly totals
• Sales Rep Assignment: Dropdown on /admin/orders rows to assign sales rep; auto-calculates commission
• Employee Compensation: /admin/employees now has salary, hourly rate, commission rate, job title, department, start date, reports-to fields
• Page Restructuring: /admin/employees is Team Members only; /admin/employees/audit and /admin/employees/careers as separate pages
• Company Structure: New /admin/employees/company-structure page with recursive org chart, role/dept badges, stats
• Database: Added User compensation fields, Order sales rep tracking, new CommissionRecord model with status workflow
• API: New /api/admin/commissions route for commission management; updated orders and users routes
• UI: Enhanced employees table with commission/compensation columns (owner only), navigation bar for sub-pages

Update header logo to new AVIF design

• Add new header-logo.avif to public/brand/
• Update both mobile and desktop header logo references