=== AI eShop Optimizer === Description: Boost sales with AI-powered product recommendations and free AI chat featuring Claude Opus 4.1, GPT-5, and advanced Voyage AI embeddings. Effortlessly optimize upsells and cross-sells for store success! Tags: product recommendations, AI, sales optimization, upsells, store enhancement, AI chat, chatbot, Claude, OpenAI, embeddings, Voyage AI, Anthropic, multiple embeddings, reranking, semantic search Requires at least: 5.7 Tested up to: 6.8 Requires PHP: 7.4 Stable tag: 3.1.1 Woocommerce tested up to: 9.5 License: GPLv3 or later License URI: http://www.gnu.org/licenses/gpl-3.0.html Boost sales with AI-powered product recommendations and free AI chat featuring the latest Claude Opus 4.1, GPT-5, and Voyage AI embeddings. Effortlessly optimize upsells and cross-sells for store success! == Description == # AI eShop Optimizer - Optimal Product Recommendations & AI Chat Plugin Welcome to AI eShop Optimizer, the premier AI-driven solution designed to revolutionize your product catalog with smart, data-backed recommendations and intelligent customer engagement powered by the latest AI models from Anthropic and OpenAI. The plugin allows you to export your product catalogue and orders in a format that can be processed by 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 ## 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](mailto:support@eshop-optimizer.com). --- Website: (https://eshop-optimizer.com) == Installation == 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. == Changelog == = 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 * 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