Software Updates

CRITICAL FIX: add locale prefix to all product URLs

• product-card-with-video.tsx (main product cards)
• compare-view.tsx (comparison page links)
• vector-search-bar.tsx (search results)
• product-collage-hero-client.tsx (homepage hero)
• dynamic-collections.tsx (collection cards)

allow marking orders as paid from any valid status

• Previously only PENDING orders could be marked as paid.
• Now allows marking from: PENDING, CONFIRMED, PROCESSING, IN_PRODUCTION, SHIPPED
• Still blocks: PAID, CANCELLED, REFUNDED, DELIVERED
• This enables marking private commission and in-person orders as paid
• after they've progressed through the workflow.

order source display and mark as paid button visibility

• Fixed order detail page to check order.source field instead of just isShopifyImport
• Now shows: Private Commission, In Person, Shopify, or Website Order badges
• Previously only showed for PENDING orders
• Now shows for PENDING, CONFIRMED, PROCESSING, IN_PRODUCTION, SHIPPED
• Excludes: PAID, CANCELLED, DELIVERED, REFUNDED

add complete Portuguese translations for employees page

• Added comprehensive employees translation section to AdminTranslations interface
• Includes 60+ translation keys covering all UI elements
• Updated employees-client.tsx to use useAdminTranslations throughout
• Translated: page headers, dialogs (invite/create/edit), form fields, role badges
• Translated: table headers, stats cards, empty states, toast messages
• All placeholders and help text now support both languages
• Portuguese translations follow admin interface patterns

add Portuguese translations for services page (initial)

• Add comprehensive services section to AdminTranslations interface
• Add 80+ English translations for services page
• Add 80+ Portuguese translations for services page
• Import useAdminTranslations hook in services-client
• Translate header, title, subtitle
• Translate create request button and dialog
• Translate toast messages (success, error)
• Support service types, statuses, priorities in both languages
• Translate form labels: customer, item, issue, estimates
• More translations to follow in next commit

add Portuguese translations for media page

• Add complete media section to AdminTranslations interface
• Add all English translations for media page
• Add all Portuguese translations for media page
• Update media page to use translation system
• Translate all UI text: title, subtitle, search, filters, buttons
• Translate photo counts, loading states, empty states
• Translate download, view, primary badge labels
• Support both English and Portuguese for all media library text

display correct order source in admin orders list

• Add source field to API orders list query
• Add customOrderDate field to API query
• Create getOrderSourceInfo helper function
• Update orders table to display actual source field
• Support multiple source types: KATURA_WEBSITE, SHOPIFY, IN_PERSON, PRIVATE_COMMISSION
• Show proper icons and colors for each source type
• Fix issue where order source changes weren't reflected in list

add SQL migration for Order.source column

• Add source column to track order origin
• Set default value to 'KATURA_WEBSITE'
• Update existing Shopify orders with 'SHOPIFY' source
• Add index for better query performance
• Ready to run in Supabase SQL Editor

improve error handling and debugging for order detail API

• Add detailed error logging in API route
• Fix type casting issues for order.source and order.customOrderDate
• Add better error reporting in frontend order page
• Add debugging logs to track order lookup process
• Handle missing order relationships more gracefully

resolve React hydration error #418 in create order dialog

• Replace native HTML input checkbox with Radix UI Checkbox component
• Add proper accessibility attributes to file input
• Fix type compatibility for onCheckedChange handler
• Prevents client/server HTML mismatch during hydration

update invite-user email template and add orders error handling

Lazy-load Resend to avoid build errors when API key not present

Add invite-user email template and employee invitation system

• Created branded invite-user.html email template for Supabase
• Added /api/admin/invite endpoint to send Supabase Auth invitations
• Added /api/webhooks/employee-signup to notify owners when employees join
• Updated employees page with 'Invite via Email' button
• Updated QUICK_START.md with complete setup instructions

Remove emojis and improve logo display with inline styles for better email client compatibility

Add branded magic link template for employee invitations

Match website fonts - add Playfair Display for headings and brand

Update logo URLs to use simpler filename without spaces

translate tasks TaskCard and fix imports

Fix orders API syntax error - remove duplicate code sections

Add manual migration instructions for source column

Make orders API resilient to missing source/customOrderDate columns - use select instead of include

Add migration for order.source and run migrations during vercel build

Force Vercel rebuild to regenerate Prisma Client

Add extensive logging to orders API to diagnose 500 error

Fix TypeScript file input ref typing in order dialogs

Add error handling for order transformation and fix paymentStatus type conversion

Add debugging and error handling for order source updates

Fix Prisma type issues in orders API - add type assertions for customOrderDate and source fields

Fix orders API 500 error - add source field to response with fallback

Add debug logging to orders page to diagnose empty orders issue

Fix admin orders page to use AdminI18nProvider instead of next-intl

• Replaced useTranslations() from next-intl with useAdminTranslations()
• Updated translation calls to use admin translation structure (t.orders.title)
• Fixed runtime error: 'Failed to call useTranslations because context not found'
• Admin pages use custom AdminI18nProvider, not NextIntlClientProvider
• Kept English as fallback for labels not yet in admin translations
• Portuguese translations already exist in AdminI18nProvider for orders

Add safer fallback for order source field

• If source is missing, infer from isShopifyImport
• Prevents errors on orders created before source field existed
• Production rebuild will regenerate Prisma types with source field

Improve analytics error logging for debugging 500 error

Add order source management and fix sorting by custom order date

• Orders now sort by customOrderDate (if set), then createdAt
• Added Order Source field with options:
• Katura Website (default)
• In Person
• Private Commission
• Shopify
• Other
• Changed 'Site' label to 'Katura Website' throughout
• Added Order Source card in order detail page with inline editing
• Updated orders API to include and update source field
• Updated Portuguese translations with new source options
• API already had correct sorting logic (customOrderDate nulls last, then createdAt)

Add Portuguese translations for admin Orders page

• Added comprehensive admin translation section to messages/pt.json
• Includes translations for:
• Common admin UI elements (buttons, actions, loading states)
• Status labels (pending, paid, in_production, shipped, etc.)
• Dashboard stats and labels
• Orders page (titles, table headers, filters, actions)
• Updated /src/app/admin/orders/page.tsx to use translations:
• Added useTranslations() hook
• Replaced all hardcoded English text
• Updated status humanization to use translation keys
• Table headers, filters, and action buttons now in Portuguese
• Created reference document at docs/admin-translations-pt.json

humanize status in list, include customOrderDate in API response

use error.issues instead of error.errors for Zod validation

expose delete, humanize status, persist customOrderDate, show attachments & address lines

add founding client status and manual customer creation

• Add isFoundingClient, foundingClientVerifiedAt, foundingClientVerifiedBy fields to User model
• Create database migration for new fields with indexes
• Implement discount calculation in lib/military-discount.ts
• Apply founding client discount at checkout (stackable with military/gift balance)
• Store discount in Stripe payment intent metadata
• POST /api/admin/customers - Create customer without password
• Customers can register later and account is linked automatically
• Support for military and founding client flags during creation
• PATCH /api/admin/customers/:id now supports isFoundingClient toggle
• Tracks who verified and when
• Existing customers without passwords can register
• Password added to existing account
• Preserves all history, orders, and special statuses

comprehensive audit, fixes, and new route scaffolding

• Fix: Remove double-fetch in products-tab.tsx
• Feat: Add SETTLED_ORDER_STATUSES constant and getAnalyticsOrderFilter() utility
• Feat: Scaffold 6 new analytics routes (funnel, attribution, search, retention, fulfillment, inventory)
• Docs: Add comprehensive audit and roadmap with findings, recommendations, and implementation plan