Software Updates

Add comprehensive wholesale page and category page management

• Created /wholesale public page with full wholesale partnership content
• Added hero section with call-to-action
• Added benefits, requirements, terms, and FAQs sections
• Implemented wholesale application form with validation
• Added /api/wholesale/apply endpoint to handle applications
• Created category page management admin interface (/admin/pages)
• Added drag-and-drop product ordering for category pages (rings, necklaces, etc)
• Added WholesaleLead and CategoryPage models to database schema
• Added Wholesale link to footer navigation in COMPANY section
• Implemented SEO metadata for wholesale page
• Added CategoryPage model for managing product display order per category
• Added WholesaleLead model for storing wholesale applications
• Created SQL migration file for tables

Add filter implementation documentation

Add TYPE filter and Sterling Silver to metal options - make all filters functional

• Added TYPE filter for jewelry types (Ring, Necklace, Earrings, Bracelet)
• Added Sterling Silver to metal options
• Updated getProducts to support multiple metal types and jewelry types
• Filters now properly apply to product query with IN operator for multiple selections
• All three filters (TYPE, METAL, PRICE) now fully functional

Remove debug logging from sort dropdown and shop page

Fix photo upload reliability issues - add automatic retry and prevent collisions

• Added automatic retry logic with exponential backoff (3 attempts: 1s, 2s, 4s)
• Fixed image collision bug by switching to index-based matching instead of alt text
• Added Supabase storage-level retry for network resilience
• Improved file collision handling by generating unique filenames
• Added upload completion validation in product edit form
• Users cannot save while photos are still uploading
• Users get warning if photos have upload errors
• Updated photo state to track uploading, uploaded, and error status

replace browser alerts with custom in-house dialogs for product actions

• Replace duplicate success/error alerts with ConfirmationDialog
• Replace delete success/error alerts with ConfirmationDialog
• Add duplicateSuccessOpen, deleteSuccessOpen states
• Add errorDialogOpen for centralized error display
• Update ConfirmationDialog to hide cancel button when cancelLabel is empty
• Show success messages for 1.5-2 seconds before redirecting/refreshing
• All product action confirmations now use branded dialogs

implement infinite scroll with automatic load on visibility

• Add IntersectionObserver to detect when LOAD MORE button is visible
• Automatically load next 16 products when button enters viewport
• Keep manual click as backup option
• Add helpful hint text below button
• Trigger loading 100px before button becomes visible for smooth UX
• Applied to both shop and category pages

implement smart pagination with conditional LOAD MORE button

• Show 16 products initially instead of all
• LOAD MORE button only appears when there are more than 16 products
• Create client-side ShopProducts and CategoryProducts components
• Update shop page and category pages to use pagination
• Fetch 32 products server-side to check if more exist
• Smooth progressive loading on click

prevent dropdown menu from closing when opening confirmation dialogs

• Add dropdownOpen state to ProductActions component
• Prevent dropdown from closing when duplicate/delete is clicked
• Use setTimeout to show dialog after dropdown closes cleanly
• Ensures custom ConfirmationDialog appears instead of browser default

replace browser confirmation dialogs with custom in-house ConfirmationDialog component

• Create new ConfirmationDialog component using Shadcn/ui Dialog
• Integrate into product deletion flow with red styling for dangerous action
• Integrate into product duplication flow with standard styling
• Remove all window.confirm() calls from admin product management
• Both dialogs now use custom branded styling matching site design

Product image gallery navigation - make photo carousel functional

Sort functionality to preserve existing filters

Metal type and price filters on shop page, single primary photo constraint, and sidebar duplication

Fix product sort functionality and image display on shop page

Fix product save error when updating products with newly uploaded photos

Fix product photo management: enable photo deletion and photo replacement

Make ring size field conditional - only show for Ring jewelry type

Add image URL validation to prevent 404 errors on products page

Fix duplicate endpoint to use correct schema field names

Add product duplication feature with image URL validation and migration script

Implement product duplication with image URL validation

Create comprehensive diamond education page with 4Cs, shapes, certification, and buying tips

Simplify Prisma lazy wrapper with Proxy pattern

Use lazy-loaded Prisma wrapper to fix initialization issues

Use dynamic import for Prisma in shop page to fix initialization error

Fix Prisma client initialization using proper singleton pattern

Add dynamic route configuration to shop page to prevent static generation issues

Revert to standard Prisma initialization

Improve Prisma client initialization with better error handling and logging

Fix Prisma client initialization and use client directive placement

Implement database-driven /shop page with sorting by newest, price, and name

Convert diamond shape images to transparent backgrounds and remove CSS filters

Replace brightness filter with multiply blend mode for diamond shapes

Apply brightness filter to diamond shape images to remove grey background

Add white background to diamond shape image containers to eliminate grey tint