Software Updates

custom date ranges + multi-metric time series chart

• API: accept from/to date params alongside days preset, granularity param (hourly/daily/weekly)
• API: CTE-based timeSeries query combining ProductView + HeroEvent clicks + CartItem data
• UI: preset buttons (7D/14D/30D/90D/1Y) + custom date range picker with Apply
• UI: granularity toggle (hourly/daily/weekly) with smart defaults based on range
• UI: interactive multi-metric bar chart with views, hero clicks, cart adds
• UI: legend toggles to show/hide individual metrics, hover tooltips, summary row
• Backward-compatible: dailyViews still returned for any consumers

aggressive cookie clearing for sign-out

• Sign-out endpoint now clears ALL possible cookie name variants (authjs, __Secure-authjs, next-auth, __Secure-next-auth)
• Clears both with domain=.katura1999.com AND without domain (handles cookies set either way)
• All fetch calls now use credentials:'include' to ensure cookies are sent and received properly
• Uses .then(r => r.json()) instead of .finally() to ensure the Set-Cookie response is fully processed before redirecting

sign-out now uses custom endpoint to clear domain-scoped cookie

• NEW: src/app/api/auth/sign-out/route.ts
• user-menu.tsx, admin/layout.tsx, sign-out-button.tsx
• platform-admin-header.tsx, signout/page.tsx
• account/settings/page.tsx (delete account flow)
• wholesale-portal.tsx
• platform login-form.tsx

sign-out not working — use redirect:false + window.location.href

• user-menu.tsx (desktop dropdown + mobile nav)
• admin/layout.tsx (desktop dropdown + mobile dropdown)
• sign-out-button.tsx
• platform-admin-header.tsx
• signout/page.tsx

add homepage + cart attribution to per-product analytics, fix UTM capture

• Per-product page now shows 3 data sources instead of just ProductView: 1. Homepage Exposure: hero impressions + clicks by channel (Direct, Facebook, Instagram, etc.) 2. Cart Attribution: which channels led to add-to-cart for this product 3. Product Page Traffic: existing ProductView-based deep analytics
• Fixed UTM capture bug: was parsing UTMs from referrer URL (facebook.com) instead of the actual page URL (katura.com/creations/izzy?utm_source=facebook)
• Lowered ProductView bounce filter from 3s to 1s so views accumulate faster while campaigns are live
• API: 3 new parallel queries (heroImpressions, heroClicks, cartChannels) using same channelCaseSql classification as main dashboard

Meta Pixel + CAPI only fire conversion events for Meta traffic

• Before: AddToCart, Purchase, InitiateCheckout, AddToWishlist fired for
• ALL visitors. Meta's Custom Conversions dashboard showed inflated
• numbers (23 Add to Bag) because it counted Google/direct/organic
• traffic too.
• After: Conversion events only fire if visitor has confirmed Meta
• signals: _fbc cookie, fbclid param, facebook/instagram referrer,
• or utm_source=ig/fb/facebook/instagram/meta.
• ViewContent still fires for all visitors (needed for retargeting
• audience building).
• Applies to both client-side Pixel and server-side CAPI.

products page shows cart adds, channel funnels count unattributed carts

• Products table now merges ProductView data with CartItem data so every product with any activity (views OR cart adds) appears, with a new 'Add to Cart' column showing count + unique carts
• Channel funnels: count carts with null referrerChannel + null visitorId as 'Direct' (most likely in-app browser traffic that strips all tracking headers)
• Per-product deep-dive: funnel bars now show when there are cart adds even with 0 views (uses max of all stages as denominator)
• Corrected Izzy analysis: 3 carts are 'Direct', 2 are null channel — cannot confirm any came from Facebook/Instagram

update Izzy analysis with Stella's actual /bin/zsh.38 CPC data

• Rewrites all cost projections from assumed industry CPC to actual
• /bin/zsh.38. Changes projected spend-per-sale from -4K to -320.
• Adds CPC creep risk section and revised budget recommendations.

sign-out, per-product analytics, rename Impressions→Site Visits

• Sign-out: switch all 6 call sites from signOut({redirect:false})+manual redirect to signOut({callbackUrl:'/'}) so cookies actually clear
• Per-product analytics: new API /api/admin/analytics/product/[productId] and deep-dive UI page at /admin/stella/marketing/products/[productId] with funnel, traffic sources, engagement, geo, devices, UTM campaigns
• Rename 'Impressions' → 'Site Visits' (EN+PT) — these are HeroEvent homepage loads, not ad impressions; less confusing for Stella
• Products table now links product names to the deep-dive page
• Add Izzy Diamond Earrings campaign analysis MD for Stella

Fix SQL alias mismatch crashing marketing dashboard

• The sqlExcludeCartUser fragment uses c."userId" but the cartByChannel
• query had FROM "Cart" without an alias, causing a PostgreSQL error:
• 'missing FROM-clause entry for table c'. This 500'd the entire
• conversions API, and the layout set the error JSON as data, crashing
• on data.kpis.productViews.

Fix missing exclusion filter on cartByChannel query in channel funnels

include anonymous ProductViews in analytics (NULL userId was excluded)

• The Prisma { userId: { notIn: [...] } } filter excludes NULL values
• because NULL NOT IN (...) evaluates to NULL (falsy in SQL).
• Changed to: { OR: [{ userId: null }, { userId: { notIn: excludedUserIds } }] }
• This is what caused 'Product view tracking has no data yet' to show
• on the Stella Marketing dashboard — most product views are from
• anonymous (not-logged-in) visitors, so they all have userId=null.

perf+fix: exclude dev emails from analytics + parallelize conversions API

• Add EXCLUDED_EMAILS constant (rosserembrasil@gmail.com)
• Resolve excluded user IDs once, filter ALL analytics queries:
• ProductView: exclude by userId
• CartItem: exclude via Cart→User join
• WishlistItem: exclude via Wishlist→User join
• Order: exclude by email field
• Revenue/channel funnels: exclude from raw SQL queries
• Parallelize ~25+ sequential DB queries into 3 Promise.all batches:
• Batch 1: 14 KPI counts (views, carts, wishlists, orders, revenue, hero)
• Batch 2: 7 detail queries (cart detail, daily carts, recent events, wishlists, sales, revenue, website orders)
• Batch 3: 6 traffic/trend queries (channels, prev channels, hero devices, daily orders, wishlist conversion, daily channel trends)
• Batch 4: 4 channel funnel queries
• ProductView analytics: 9 queries in parallel
• Use Prisma.sql + Prisma.empty for safe dynamic SQL fragments
• Deduplicate channel CASE expression into shared channelCaseSql variable
• Expected ~3-5x faster page load for /admin/stella/marketing

remove duplicate '| KATURA' suffix from 31 page titles

• The root layout uses title.template = '%s | KATURA' which automatically
• appends '| KATURA' to every page title. But 31 storefront pages were
• manually including '| KATURA' (or variants like '| KATURA Fine Jewelry',
• '| KATURA Education') in their own titles, resulting in doubled suffixes
• like 'Your Cart | KATURA | KATURA' in browser tabs and GA4 reports.
• This caused GA4 to show multiple rows of 'Handcrafted Earrings &
• Minimalist Jewelry | KATURA' in the top pages report — because many
• different pages were all falling back to the same homepage title, making
• them indistinguishable in analytics.
• Now every page sets just its unique portion (e.g. 'Your Cart') and lets
• the template add '| KATURA' once.

add missing /collections/ → /creations/ redirects (SEO)

• /collections/necklaces → /creations/necklaces
• /collections/bracelets → /creations/bracelets
• /collections/rings → /creations/rings
• /collections/engagement-rings → /creations/engagement-rings
• /collections/wedding-bands → /creations/wedding-bands

fire AddToCart event on /cart page to satisfy Custom Conversion

• The 'Add to Bag' Custom Conversion has a compound rule:
• Event = AddToCart AND URL contains '/cart'
• The AddToCart event was only firing from product pages (URL like
• /creations/some-ring), so the URL condition never matched. Now we
• also fire AddToCart when the cart page loads with items, which
• satisfies both conditions simultaneously.

fire Meta ViewContent on /cart page + widen CSP for Facebook

• Two changes to ensure the 'Add to Bag' Custom Conversion activates:
• 1. Cart page now fires fbq('track', 'ViewContent') when the cart loads
• with items. This gives Meta an explicit event on the /cart URL, not
• just a PageView.
• 2. Widened CSP connect-src to include https://*.facebook.com (was only
• https://www.facebook.com). The pixel can beacon to subdomains like
• tr.facebook.com which weren't covered.

remove meta-pixel-test page — no longer needed

• All 4 Meta Custom Conversions will activate once the canonical fix
• deploys and the user visits /cart.

canonical URL bug — root layout was overriding all pages' canonical to homepage

• Removed alternates (canonical + languages) from root layout.tsx
• Added proper canonical to /cart layout (https://katura1999.com/cart)
• Added proper canonical to /checkout layout
• Created /checkout/success layout with proper canonical
• Pages that already set their own canonical (homepage, collections, products, etc.) are unaffected since they override independently.

add /meta-pixel-test page to activate Custom Conversions

• Fires AddToCart, InitiateCheckout, and Purchase standard events
• on a single page load so Meta's Custom Conversions move from
• Inactive → Active. Visit katura1999.com/meta-pixel-test to trigger.
• Delete this page once all conversions show Active in Meta.

fire Meta Pixel PageView on SPA navigations

• The Meta Pixel base snippet in layout.tsx fires fbq('track','PageView')
• only on the initial full page load. Subsequent client-side (SPA)
• navigations never sent another PageView, so URL-based Custom
• Conversions in Meta for /cart, /checkout, and /checkout/success
• never saw those page visits — showing 0 conversions despite the
• standard events (AddToCart, InitiateCheckout, Purchase) already
• being wired up in the code.
• Fix: PageViewTracker now fires fbq('track','PageView') on every
• SPA navigation (in addition to the existing GA4 page_view).
• Skips the initial render to avoid double-counting with layout.tsx.

add Google Tag Manager (GTM-WSV33RDH)

• GTM script in <head> (with nonce for CSP compliance)
• GTM noscript iframe after <body> for JS-disabled fallback
• Only loads on production domain (katura1999.com)

sign-out not working + video uploadDate timezone

• Fix signOut() not navigating: use redirect:false then window.location.href to force a full page reload (fixes same-URL no-op when already on /)
• Updated all 5 sign-out call sites: user-menu, sign-out-button, admin layout (x2), platform-admin-header
• Fix Google Search Console video structured data warnings: uploadDate now uses full ISO 8601 with timezone (was date-only)
• Fixed in structured-data.ts and video-sitemap.xml/route.ts

Sprint 5: Platform Completeness — CSV exports, CMS pages, domain management, navigation editor

• Orders CSV export (/api/platform/orders/export) with date/status filters
• Customers CSV export (/api/platform/customers/export) with segment filter
• Export CSV buttons added to Orders + Customers admin pages
• CMS Pages CRUD (API + /admin/pages UI) — create, edit, publish/draft, SEO fields
• Domain management (API + /admin/domains UI) — add, DNS TXT verify, set primary, SSL status
• Navigation menu editor (API + /admin/navigation UI) — header with dropdowns, footer links, reorder
• Sidebar updated with Pages, Navigation, and Domains nav items

Sprint 4: Essential Commerce Depth — collection/promotion edit pages, dynamic checkout shipping, gift cards admin, inventory dashboard, tenant-branded emails

• Collection detail + edit pages (/admin/collections/[id] & /edit)
• Promotion detail + edit pages (/admin/promotions/[id] & /edit)
• Dynamic shipping resolver (resolves from ShippingZone/ShippingRate tables, Stripe-compatible)
• Checkout route now uses tenant's shipping zones instead of hardcoded rates
• Gift Cards admin (issue, search, filter, status toggle, balance adjust)
• Inventory dashboard (stock levels, low stock alerts, quick adjustments)
• Tenant-branded transactional emails (order confirmation, shipping, refund)
• Sidebar updated with Gift Cards + Inventory nav items

rename Sell Gold & Silver to Buy & Sell Precious Metals, restore Pre-Owned Luxury Timepieces link

• Updated sellGoldSilver label across all 24 locales
• Added preOwnedWatches link (/timepiece-sourcing) back to clientCare footer section
• Updated preOwnedWatches label to include 'Luxury' across all locales

complete GA4 + Meta Pixel audit & fixes

• Wire view_item_list on category, collection, and all-creations pages
• Wire select_item on product card clicks with list context
• Wire view_cart on cart page load
• Wire add_shipping_info on checkout step transition
• Fix add_to_cart data (product name, price, quantity)
• Wire remove_from_cart in cart context
• Add ViewItemListTracker client component
• Wire trackSearch to search dialog
• Add structured data (JSON-LD) for About, Contact, Engagement pages
• Fix OG type on creations/[id] to 'article'
• Wire trackAddToWishlist to WishlistButton
• Wire trackSearch (Meta) to SearchDialog alongside GA4
• Wire trackLead to ContactForm on successful submission
• Wire trackLead to both newsletter forms (site-wide + Jewel Vox)
• Wire trackCompleteRegistration to register form
• Replace raw window.fbq AddToCart with trackMetaAddToCart utility (now includes content_name, value, currency)
• Differentiate sign-in pages: customer → 'My Account — Sign In', employee → 'Employee Portal — Sign In', register → 'Create Your Account'
• New employee-login layout.tsx with noindex/nofollow
• Fix double-branding in title template
• Add GOOGLE_ANALYTICS_MEGA_AUDIT.md
• Add META_PIXEL_MEGA_AUDIT.md (score: 6.1→8.8/10)

replace all mock data with real DB queries on products page

• BounceRateChart: now queries ProductView with duration/scroll thresholds grouped by product jewelryType (was hardcoded mock data)
• DayOfWeekChart: now queries ProductView + Order by ISODOW for real views/sales/revenue per weekday (was hardcoded mock data)
• ImageEngagementChart: now queries ProductView imagesViewed buckets with buy-click correlation (was hardcoded mock data)
• /api/admin/analytics/bounce-rate — real bounce rate by category
• /api/admin/analytics/day-of-week — real views+sales by day of week
• /api/admin/analytics/image-engagement — real image engagement data
• product-funnel: removed fake fallbacks, date-filtered ProductView
• funnel-trends: new daily/hourly trend API
• product-view-trends: per-product trends with 24h/7d/30d/90d
• checkout-start: new CHECKOUT_START event tracking
• ViewsTimeSeriesChart: replaced fabricated data with real API
• ProductViewTrendsChart: new component with time range selector

add 38 checkout validation tests — guards against all 4 production bugs

• Happy path: US, international, multi-item, gift, promo, all currencies
• Rejections: empty cart, invalid email, bad quantities, bad country codes
• Client/server parity: exact payload shapes the checkout page sends
• Tenant injection: orderItems include tenantId for nested creates

checkout 500 — nested OrderItem creates missing tenantId

• /api/create-payment-intent (web checkout)
• /api/checkout (Stripe Checkout Session)
• /api/checkout/payment-intent (mobile PaymentSheet)

expose error message in create-payment-intent for diagnosis