AI eShop Optimizer

AI eShop Optimizer - AI Chat & Content Recommendations Plugin Welcome to AI eShop Optimizer, the premier AI-driven solution for intelligent customer engagement powered by the latest AI models from Anthropic and OpenAI. Works with or without WooCommerce - Perfect for:

• E-commerce sites with WooCommerce for product recommendations
• Corporate and content sites for intelligent chat assistance
• Merchant information sites that need AI-powered customer support The plugin provides advanced AI chat capabilities with semantic search powered by state-of-the-art embedding engines. For WooCommerce sites, it also enables product recommendations through our graph-database powered service at https://eshop-optimizer.com. Our advanced AI tools uncover latent patterns and consumer preferences, empowering you with strategic upsell and cross-sell propositions. The plugin also enables you to import with one click our recommendations - or any product recommendations in a csv file that conforms to our format - and to also monitor their performance using google UTM tags (which you may also use to monitor your own recommendations performace).

Features AI Product Recommendations

• Harness the power of a semantic graph database for unmatched product pairing suggestions.
• Dive deep into your sales data to extract bespoke upsell and cross-sell opportunities.
• Beta-test participants reported a remarkable 57%+ annual surge in sales.
• Privacy-centric: Opt out of sharing product and category names and product prices with limited impact to the quality of the recommendations.
• Effortlessly back up and export current Upsells and Cross-sells.
• Leverage Google GA4 insights to gauge the success of your recommended pairings.

AI-Powered Chat (FREE)

• Support for latest AI models from Anthropic Claude and OpenAI:
• Claude Opus 4.1, Claude Sonnet 4.5, Claude Haiku 4.5
• GPT-5, GPT-4, GPT-o1, GPT-3.5
• Advanced embedding engines for semantic product search:
• Voyage AI: voyage-3.5-large, voyage-3.5-lite, voyage-3-lite, voyage-finance-2
• OpenAI: text-embedding-3-large, text-embedding-3-small, text-embedding-ada-002
• Customizable chat templates for different use cases
• Smart product search and recommendations powered by AI embeddings
• Product catalog integration with semantic similarity matching
• Context-aware responses using customer behavior data
• Customizable chat appearance with multiple themes (Rounded/Square)
• Dynamic color customization for branding
• Session management and chat history tracking
• Floating chat widget with adjustable positioning
• Mobile-responsive design

Advanced Session Analytics

• Custom Class-Based Event Tracking - Track clicks on any element using custom CSS selectors
• Click Event Throttling - Prevent database flooding while maintaining accurate click counts
• Cookie Consent Bypass Mode - Toggle GDPR compliance for immediate tracking or compliance-first approach
• Product Image Click Tracking - Special tracking for product images with debounce to prevent duplicate events
• Anti-Double-Counting - Custom rules take precedence over standard tracking
• Automatic Cache Busting - Version strings with variable lengths for aggressive cache invalidation
• Multi-Layer Cache Compatible - Works with Nginx, Varnish, REDIS, WP Rocket, Cloudflare

How to Use

• Export and Back-Up Current Pairings Safely export existing upsells and cross-sells, which doubles as a reliable back-up. The Pro version also takes your current selections into account, potentially enhancing the AI's output.
• Accelerated Order Export (Enabled HPOS Required) Swiftly export up to 100,000 order items. The Pro version lifts the cap on orders, including comprehensive details like Order ID, Product ID, sequence, and more. Exclude product titles and prices at will. Maintain customer anonymity by withholding CustomerIDs, albeit with a slight compromise on recommendation precision. Opt for a seasonal sales analysis, focusing on trends pertinent to the current time of year. Refine Your Data with Our AI Engine Register at eshop-optimizer.com and submit your data. Within moments, receive refined upsell and cross-sell strategies for your leading products. Full catalog analysis available with the Pro version. eshop-optimizer.com respects your privacy and adheres to strick privacy guidelines. Our company's, Oxford Metadata Ltd, privacy provisions has been approved by both Google and Facebook. For further details please visit: https://eshop-optimizer.com/compliance
• Import Tailored Upsell and Cross-sell Strategies Implement the AI-crafted upsell and cross-sell suggestions via an easy-to-upload CSV file.
• Witness Enhanced Sales Marvel at the accuracy of our AI-driven recommendations and observe how they can boost your sales figures. We're so confident in our service that we offer free initial analyses - we believe you'll be eager for more and enthusiastic to spread the word! Experience the relevance of our recommendations and discover how AI can improve your store's sales. We offer free analyses, and we are confident that you'll want more and share our plugin with your friends!

For any queries or support, contact us at support@eshop-optimizer.com. Website: (https://eshop-optimizer.com)

Extract the contents of this plugin zip file into your wp-content/plugins/ directory locally. Upload the extracted folder to your website. Navigate to wp-admin/plugins.php on your dashboard. Find 'AI eShop Optimizer' and activate the plugin. Alternatively, install directly through WordPress: Go to the 'Plugins' menu in WordPress. Click 'Add New' and search for 'AI eShop Optimizer.' Install and activate directly from your dashboard.

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