AI eShop Optimizer

1. 
2. 
3. 
4. 
5. 
6. 
7. 
8. 
9. 
10. 
11. 
12. 
13. 
14. 
15. 
16. 
17. 
18. 
19. 
20. 
21. 
22. 
23. 

4.2 – 2026-01-28

FEATURE UPDATE: Products for the Same Needs – Need-Based Recommendations

Products for the Same Needs
* NEW: Automatic product suggestions based on matching customer needs (pa_need attribute)
* NEW: Finds products sharing primary, secondary, or additional needs with the current product
* NEW: Rankings powered by pre-computed TotalItemSales from product catalogue for maximum performance
* NEW: Smart exclusion of existing upsells and cross-sells to prevent duplicate recommendations
* NEW: Stores up to 6 optimized suggestions per product in dedicated database table
* NEW: Display checkbox in Display Preferences: “Please display Products for the same needs”
* NEW: Generation checkbox in Operational Efficiency: “Please generate products with the same needs”
* NEW: Displays first on product pages (priority 10) before upsells, cross-sells, and related products
* NEW: Multi-tier caching support via AIEO Recommendations Cache (Object Cache + Database)
* NEW: Empty sections automatically hidden when no matching products exist
* Improved: Seamless integration with existing AJAX lazy loading infrastructure
* Improved: Skeleton loading animation while fetching recommendations

Technical Details
* NEW: wp_aieo_product_need_suggestions database table for persistent storage
* NEW: AI_eShop_Need_Suggestions class for generation logic
* NEW: same_needs added to cacheable recommendation types
* NEW: Generation runs as final step in Operational Efficiency batch processing

4.1 – 2025-12-06

FEATURE UPDATE: Advanced Analytics, Conversation Memory, Business Knowledge Base & Performance Optimizations

Advanced Statistics with Heatmap Drill-downs (Pro)
* NEW: Product category performance analytics with visual heatmap drill-downs
* NEW: Brand-level performance tracking with interactive heatmaps
* NEW: Click-to-drill functionality for exploring category and brand hierarchies
* Improved: Visual analytics for understanding product performance patterns

Conversation Memory
* NEW: AI chat now remembers previous questions within the same conversation
* NEW: Contextual follow-up responses that reference earlier discussion points
* Improved: More natural conversational flow with memory of user preferences mentioned earlier

Business Information Knowledge Base
* NEW: Site Identity configuration – define “What this site IS” and “What this site is NOT”
* NEW: Automatic WordPress tagline integration in AI context
* NEW: Prevents AI from misidentifying your business type (e.g., calling a clinic a “shop”)
* NEW: Import existing page content as knowledge base entries (text-only, HTML stripped)
* NEW: WooCommerce Shipping Zones integration – automatically sync all shipping rates and locations
* Improved: Zone-centric shipping data structure for accurate location-based queries

User Feedback System
* NEW: Thumbs up/down rating for each AI response
* NEW: User feedback stored for continuous improvement analysis
* NEW: Rating data helps identify areas for answer quality improvement

JavaScript Performance Optimizations
* NEW: Lazy initialization for session tracker – only activates on user interaction (click, scroll, mouse move)
* NEW: Lazy initialization for floating chat widget – full initialization deferred until button click
* NEW: Conditional asset loading – chat CSS/JS only loads when floating chat is enabled or shortcode is present
* NEW: Vanilla JS trigger button display for faster rendering (no jQuery dependency for initial display)
* Improved: Eliminated ~4s page load delay from session tracker
* Improved: Reduced page weight on pages without chat functionality

WooCommerce Table Rate Shipping Compatibility
* NEW: Full compatibility with WooCommerce Table Rate Shipping plugin
* NEW: Automatic import of shipping zones, rates, and conditions
* NEW: Zone-centric data structure with all postal codes and shipping methods per zone
* NEW: AI can now accurately answer “How much is shipping to [postal code]?” questions
* Improved: Only active shipping methods are imported (inactive methods excluded)

4.0 – 2025-11-27

MAJOR UPDATE: Dynamic AI Model Support + Database Collation Fixes + Anonymous User Chat Logging

Dynamic AI Model Registry
* NEW: Dynamic model selection from database – over 50 AI model flavours now available
* NEW: All Anthropic Claude models (Claude 4, Opus 4.5, Sonnet 4.5, Haiku 4.5 and all versions)
* NEW: All OpenAI models (GPT-5.1, GPT-5, GPT-4, GPT-o1, GPT-3.5 and all variants)
* NEW: All embedding models (Voyage AI, OpenAI) dynamically loaded from wp_aieo_ai_models table
* NEW: Model dropdowns in admin panel now populate directly from database registry
* Improved: Adding new AI models no longer requires code changes – just update the database

Database Collation Compatibility
* Fixed: Core product attributes table now uses correct charset collation
* Fixed: Core product vitals table now uses correct charset collation
* Fixed: Core variation vitals table now uses correct charset collation
* Fixed: All AIEO tables now consistently use utf8mb4_uca1400_ai_ci (or database default)
* Improved: Full compatibility with MariaDB 11.4, MariaDB 11.8, MySQL 5.7, and MySQL 9
* Improved: Removed problematic BINARY comparison in stored procedures

Anonymous User Chat History
* Fixed: Chat exchange logging now works correctly for anonymous (non-logged-in) users
* Fixed: Session tracking properly handles anonymous user conversations
* Improved: Re-ranking system properly logs all chat exchanges regardless of user status

Translation Improvements
* Fixed: Frontend chatbox now correctly loads translations from plugin languages directory
* Fixed: Translation loading priority adjusted for earliest hook execution
* Improved: Fallback translation loading from multiple locations

API Key Validation & Credit Check
* NEW: “Validate API Keys & Check Credits” button to verify all configured API keys
* NEW: Detects exhausted credits and displays warning with direct links to billing dashboards
* NEW: Quick access to Anthropic, OpenAI, and Voyage AI billing management pages
* NEW: Status indicators show Valid, Invalid, No Credits, or Not Configured for each provider

Database Optimization
* NEW: Added 6 missing Graph UUID indexes for optimal export performance (20 indexes total, up from 13)
* NEW: Indexes for all 9 UUID columns used in graph frequency calculations
* NEW: Product stats filter index for faster aggregation queries

3.6 – 2025-11-13

MAJOR UPDATE: MySQL 8 Full Compatibility + Advanced Search Re-ranking + Embedding Error Detection

Advanced Search Re-ranking System
* NEW: Configurable re-ranking weights for hybrid search results – control the balance between semantic similarity and keyword matching
* NEW: Dedicated “Re-ranking Weights” configuration section in AI Chat settings with real-time preview
* NEW: Semantic similarity weight slider (0-100%) – adjust how much AI embeddings influence search results
* NEW: Keyword matching weight slider (0-100%) – adjust how much exact text matches influence results
* NEW: Automatic normalization – weights always sum to 100% for perfect score balancing
* NEW: Visual feedback showing current weight distribution with color-coded indicators
* NEW: Three preset configurations: Semantic-focused (70/30), Balanced (50/50), Keyword-focused (30/70)
* NEW: Database schema migration for re-ranking weights with default 50/50 balanced configuration
* Improved: Search results now combine embedding similarity scores with keyword match scores using configurable weights
* Improved: More relevant search results by allowing merchants to tune for their specific product catalog
* Improved: Better handling of product variations vs parent products in search rankings

Embedding Error Detection & Reliability
* NEW: Comprehensive embedding failure tracking system for monitoring API reliability
* NEW: Real-time failure statistics showing success rate, average latency, and failure breakdown by error type
* NEW: Automatic retry logic with exponential backoff for transient API errors (rate limits, timeouts, network issues)
* NEW: Smart failure categorization: Rate Limits, Timeouts, Network Errors, Invalid Input, and Unknown Errors
* NEW: Failure trend analysis showing time-series data for the last 30 days
* NEW: Visual error rate graphs with color-coded severity indicators (green <1%, yellow 1-5%, red >5%)
* NEW: Detailed error logs with timestamps, error types, and affected content IDs
* NEW: Automatic recovery suggestions based on error patterns
* NEW: Database table wp_aieo_chat_embedding_failures for persistent failure tracking
* NEW: Failed items automatically flagged for priority retry in next training batch
* Improved: Embedding training now shows detailed progress including retry attempts
* Improved: API quota management with intelligent retry delays (60s for rate limits, 30s for timeouts)
* Improved: Better error messages during training with actionable recommendations
* Fixed: Embedding batch processing now handles partial failures gracefully
* Fixed: Training no longer stops on single item failures – continues with remaining items

MySQL 8 & Database Compatibility (100% MySQL 8 Support)
* NEW: Complete MySQL 8.0+ compatibility – plugin now works flawlessly on both MariaDB 11.4+ and MySQL 8.0+
* NEW: MySQL 8-specific database performance optimization with histogram statistics support
* NEW: Database Performance Optimization section now auto-detects MySQL 8 vs MariaDB and applies appropriate optimizations
* NEW: MySQL 8 histogram-based query planning for 20-30% faster customer and product statistics
* NEW: Descending indexes for MySQL 8 to optimize recent-order queries without reverse scans
* Fixed: DROP INDEX IF EXISTS syntax errors on MySQL 8 – now uses INFORMATION_SCHEMA checks (100% compatible)
* Fixed: CREATE OR REPLACE FUNCTION syntax errors – converted to MySQL 8 compatible drop-then-create pattern
* Fixed: Binary logging privilege handling – graceful degradation when log_bin_trust_function_creators is disabled
* Fixed: All 52+ MariaDB-specific syntax instances converted to cross-compatible code
* Improved: Stored functions now skip creation gracefully on MySQL 8 with binary logging restrictions
* Improved: Helper functions (aieo_drop_index_if_exists, aieo_drop_function_if_exists) for database compatibility
* Performance: Expected 38-48% improvement on MySQL 8 after applying database optimizations (5-6 minutes vs 9.5 minutes for 37K products)
* Performance: 13 composite indexes + histogram statistics on 6 key columns for optimal query performance

Additional Improvements
* Improved: Enhanced logging throughout embedding and search processes for better debugging
* Improved: Better error handling and user feedback during AI Chat configuration
* Improved: Database query optimization for embedding statistics and search queries
* Improved: Code organization with separate MySQL 8 optimization file for maintainability
* Fixed: Variation enrichment now properly handles missing parent product data
* Fixed: Embedding statistics now accurately reflect training status across all content types
* Updated: Documentation with MySQL 8 compatibility notes and performance tuning recommendations

3.5.2 – 2025-11-07

• Fixed: Welcome bubble positioning now follows floating widget position setting (bottom-left, bottom-center, bottom-right)
• Fixed: Welcome bubble positioning respects mobile position setting independently
• Fixed: Welcome bubble arrow positioning for all positions (left, center, right)
• Fixed: Chat close button height override for themes with aggressive button styling
• Fixed: Text domain loading for translations – now works on all WordPress versions for local development
• Chat Addon: Updated to version 3.5.2 with improved localization and UI fixes

3.5.1 – 2025-11-07

• Fixed: Fatal error on non-WooCommerce sites – AI Chat now properly checks for WooCommerce before calling product-specific functions
• Chat Addon: Updated to version 3.5.1 with improved compatibility for standalone WordPress sites

3.5 – 2025-11-07

• NEW: Advanced Session Analytics Infrastructure – Track customer attention and engagement like orders with detailed journey analytics
• NEW: Position Analytics – Automatically identify landing pages, exit pages, and bounce events for instant engagement insights
• NEW: Attention Economics Metrics – Measure time-on-page, scroll depth, click counts, and product revisits (hesitation metric)
• NEW: Conversion Funnel Tracking – Monitor checkout step progression from cart to order completion with drop-off point identification
• NEW: Journey Sequencing – Track event order and product view patterns for understanding customer behavior paths
• NEW: Custom Class-Based Event Tracking – Define custom CSS selectors to track clicks on any element (buttons, swatches, divs, images, etc.)
• NEW: Click Event Throttling – Optional throttling to prevent database flooding while maintaining accurate click counts
• NEW: Cookie Consent Bypass Mode – Toggle GDPR consent requirement for immediate tracking or compliance-first approach
• IMPROVED: Product image click tracking with 5-second debounce to prevent duplicate lightbox events
• IMPROVED: Custom tracking rules take precedence over standard tracking to prevent double-counting
• IMPROVED: JavaScript code generation is “baked in” as inline scripts for better performance
• IMPROVED: Automatic version bumping with variable-length strings for aggressive cache busting
• NEW: Multi-Layer Cache Compatibility – Session tracker now fully compatible with Nginx, Varnish, REDIS, WP Rocket, and Cloudflare
• NEW: Session-to-Order Linkage – Connect customer browsing sessions directly to WooCommerce order completions
• Improved: Client-side session generation for cache-proof tracking across aggressive caching environments
• Improved: Enhanced migration system with comprehensive schema validation for all attention analytics columns
• Improved: Archive table management now transfers all 20 analytics fields during scheduled cleanup
• Improved: Database indexes optimized for attention analytics queries (7 new indexes for performance)
• Fixed: Session schema migration now correctly detects missing attention analytics columns
• Fixed: Clean installations now create complete analytics schema with all 20 columns from activation

3.4 – 2025-11-06

• NEW: Configurable batch size parameter for embedding training – merchants can now adjust batch size (1-999 items) to control training speed and API rate limits
• NEW: Dynamic embedding statistics for all post types – stats section now automatically displays all custom post types with published content (was previously limited to Products/Pages/Posts)
• Fixed: Voyage AI taxonomy embeddings batch processing – resolved associative array key mapping issue that caused “Unknown API error” when processing categories and tags
• Improved: Unified batch processing implementation – both OpenAI and Voyage AI now use consistent associative array format for better code maintainability
• Chat Addon: Updated to version 3.4

3.3.3 – 2025-11-05

• NEW: Category-scoped AI Chat – Users can select specific product categories, post categories, or CPT taxonomies to focus chat responses
• NEW: Smart Category Auto-Selection – AI Chat automatically defaults to the top-level parent category of the current product/archive page (e.g., opens scoped to “Skincare” when viewing a product in “Skincare > Face Creams”)
• NEW: Related Products Slider in Chat – Visual product recommendations displayed in elegant slider format within chat responses
• NEW: Product Needs Attribute System – Merchants can define customer needs that products fulfill (primary, secondary, and additional needs)
• NEW: Heavily Weighted Needs in Embeddings – Primary and secondary needs get maximum emphasis in AI embeddings for accurate need-based matching
• NEW: Select All/Deselect All buttons for data analysis checkboxes for easier workflow management
• Improved: Object cache performance optimizations for category lookups and data retrieval
• Improved: More customization options for chat appearance and behavior
• Improved: Category hierarchy now uses dedicated hierarchy table instead of WooCommerce taxonomies for consistent cross-post-type support
• Fixed: Various minor styling fixes for better visual consistency across admin panels
• Chat Addon: Updated to version 3.3.3 with full category filtering and needs-based semantic search

3.3.2 – 2025-11-04

• Fixed: Embedding training duplicate product ID issue – eliminated infinite loops during batch processing in some prioritization options
• Fixed: AI Chat warning modal persistence – now properly removes after data analysis completion
• Improved: Database query optimization – added DISTINCT/GROUP BY to all ID-returning queries for duplicate prevention
• Improved: Performance indexes added to embeddings table (lookup_idx, stats_idx) for 10-20x faster queries
• Improved: Object cache bypass during critical embedding storage operations to prevent interference
• Improved: Multi-layer duplicate protection using array_unique() at function entry/exit points
• Improved: Index existence checks now use static variables instead of transients (no wp_options writes)
• Improved: All 8 priority metrics now supported with optimized GROUP BY queries
• Chat Addon: Updated to version 1.1.1 with sessionStorage support for warning state persistence

3.3.1 – 2025-11-03

• Fixed: Admin panel styling issues – cleaned up overlapping CSS rules and consolidated chat admin styles
• Fixed: Reduced plugin description to under 150 characters for WordPress.org compliance
• Improved: Chat addon CSS version bumped to force cache refresh for style updates

3.3 – 2025-11-03

• NEW: Plugin now works standalone without WooCommerce – perfect for corporate sites and merchant information pages
• NEW: Intelligent menu placement – integrates with WooCommerce when available, standalone top-level menu otherwise
• NEW: Custom network icon for better visual identification in WordPress admin
• NEW: Customizable AI Chat input placeholder text in settings
• NEW: AI Chat tab warning now shows on hover for better user guidance
• Improved: Shortened menu labels (“AI Optimizer”) to prevent UI wrapping on smaller screens
• Improved: Added descriptive submenu items with emoji icons for better navigation
• Improved: Updated to use future-proof Claude model alias (claude-sonnet-4-5)
• Improved: AI Chat warning only displays on WooCommerce sites (not needed for standalone content sites)
• Improved: AI Chat tab warning automatically refreshes after data analysis completes
• Fixed: Chat wrapper now properly fills custom popup width without margins
• Fixed: Send button arrow now points right (horizontally flipped)
• Fixed: JavaScript errors with e.target.closest() when clicking on text nodes in theme files

3.2.1 – 2025-11-02

• Fixed: Deduplication mode setting now saves correctly when changed via Training Mode dropdown
• Fixed: Product prioritization now correctly queries sales metrics from temp_orders table
• Fixed: Embedding statistics now accurately count only parent products (excludes individual variations)
• Fixed: All product queries now consistently filter by published status for accurate counts
• Fixed: Training and statistics now use matching data sources to prevent count mismatches

3.2 – 2025-11-01

• NEW: Support for Pages and Posts in visual editors (Elementor, WP Bakery, TagDiv Composer) – AI Chat now extracts content from page builders
• NEW PRO: Process Automation feature – Schedule automatic data analysis and embedding updates (daily/weekly at custom times)
• NEW PRO: Contextual Metadata – Enhanced chat with device profile, browsing history, and user preferences for personalized recommendations
• NEW PRO: AI Session Tracker (Beta) – Track customer engagement depth, product interactions, and cart behavior with zero cost alternative to Google Analytics BigQuery
• Improved: Added helpful documentation links for product priority metrics
• Improved: Better HTML structure for configuration sections in AI Chat settings
• Improved: Enhanced visual consistency across admin panels
• Fixed: Posts & Pages configuration header now extends properly across full width
• Fixed: Various minor UI/UX improvements

3.1.2 – 2025-10-31

• NEW: Added referral links tracking for better affiliate program management
• Improved: Enhanced tracking capabilities for referral campaigns
• Improved: Better analytics for referral link performance

3.1.1 – 2025-10-30

• CRITICAL FIX: Fixed activation race condition where core product tables weren’t created on first plugin activation
• CRITICAL FIX: Fixed “PROCEDURE already exists” errors during plugin activation by dropping procedures before creating them
• Fixed: Core tables now reliably created on initial activation without needing deactivate/reactivate
• Fixed: Stored procedures now recreate cleanly during activation without errors
• Fixed: Legacy stored procedures from older plugin versions now properly cleaned up during activation/deactivation
• Improved: More robust plugin activation process with idempotent procedure creation
• Improved: Complete database cleanup on deactivation (removes all procedures including legacy ones)
• Updated: Plugin tags to include AI Chat, OpenAI, Anthropic, Voyage, Multiple Embeddings, Reranking, Semantic Search

3.1

• NEW: Separate mobile and desktop widget positioning for optimal UX across devices
• NEW: Support for flexible dimension units (px, vh, %, vw) for responsive chat widget sizing
• Improved: Mobile chat widget responsiveness and input visibility
• Fixed: Chat widget positioning on mobile devices
• Fixed: Input box visibility on all screen sizes

3.0

• NEW: AI-Powered Chat feature with support for latest Anthropic Claude and OpenAI engines
• NEW: Support for cutting-edge AI models (Claude Opus 4.1, Claude Sonnet 4.5, Claude Haiku 4.5, GPT-5, GPT-4, GPT-o1, GPT-3.5)
• NEW: Advanced embedding engines for semantic search (Voyage AI: voyage-3.5-large, voyage-3.5-lite, voyage-3-lite, voyage-finance-2)
• NEW: OpenAI embeddings support (text-embedding-3-large, text-embedding-3-small, text-embedding-ada-002)
• NEW: Customizable chat templates for different use cases
• NEW: Product catalog integration with AI-powered semantic similarity matching
• NEW: Smart product search and recommendations powered by AI embeddings
• NEW: Customizable chat appearance with theme options (Rounded/Square)
• NEW: Dynamic color customization for complete branding control
• NEW: Session management and chat history tracking
• NEW: Floating chat widget with adjustable positioning
• NEW: Mobile-responsive chat design
• Improvement: WordPress coding standards compliance
• Improvement: Enhanced database query preparation
• Improvement: AI Session Tracker (Beta)
• Fix: Translation support improvements with proper translator comments
• Fix: Date/time functions now use timezone-safe gmdate()
• Fix: Chat input no longer inherits theme styles
• Fix: Various appearance issues

2.0

• Compatibility: Enhanced compatibility with MariaDB 11+ and MySQL 9.0
• Compatibility: Added support for PHP 8.4
• Fix: Removed hardcoded collation statements to use database defaults
• Fix: Prefixed admin CSS classes to prevent conflicts with other plugins
• Various minor bug fixes and improvements

1.0

• Initial release