AI Vector Search (Semantic)
| 开发者 | calingrim |
|---|---|
| 更新时间 | 2025年9月13日 02:35 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 6.8 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
AI Vector Search revolutionizes your WooCommerce store's search experience by combining traditional keyword search with cutting-edge semantic AI technology. Built on Supabase's powerful PostgreSQL backend with optional OpenAI embeddings, it delivers lightning-fast, highly relevant search results that understand customer intent, not just keywords.
🎯 Key Features
Smart Search Technology:
- Full-Text Search (FTS) - Lightning-fast PostgreSQL-powered keyword matching
- Semantic Vector Search - AI understanding of product meaning and context using OpenAI embeddings
- SKU & GTIN Search - Find products by partial SKU, EAN, UPC, or ISBN codes
- Hybrid Search - Combines multiple search methods for best results Intelligent Recommendations:
- Similar Products - AI-powered product recommendations on product detail pages
- Cart Recommendations - Smart upsell suggestions based on cart contents
- Category-Aware Suggestions - Recommendations that understand product relationships Advanced Integrations:
- Woodmart Theme Support - Seamless integration with Woodmart's live search
- Auto-Sync - Automatically sync products when saved/updated
- Batch Processing - Handle large catalogs with intelligent batching Developer-Friendly:
- Secure Key Management - Encrypted storage of API keys with master key support
- Row-Level Security - Built-in Supabase RLS policies
- Comprehensive Admin Interface - Status monitoring, health checks, and sync tools
- Your Keys, Your Control - All API keys stored securely in your WordPress database
- Encrypted Storage - Sensitive data encrypted with configurable master keys
- No Data Lock-in - Full control over your Supabase project and data
- HTTPS Only - All API communications secured with SSL/TLS
- 1,000 products: ~$0.05-$0.10
- 5,000 products: ~$0.25-$0.50
- 10,000 products: ~$0.50-$1.00 Supabase Free Tier Includes:
- 500MB database storage
- 50,000 monthly queries
- 500,000 edge function calls
- Perfect for small to medium stores
- E-commerce stores wanting better search relevance
- Large catalogs needing semantic understanding
- International stores with multi-language products
- Stores with complex product attributes and variations
- Developers seeking modern, scalable search infrastructure
安装:
Quick Start (5 Minutes)
- Install & Activate the plugin from WordPress admin or upload manually
- Set up Supabase:
- Create a free account at supabase.com
- Create a new project
- Copy your project URL and service key
- Configure Plugin:
- Go to Settings → AI Supabase
- Enter your Supabase URL and key
- (Optional) Add OpenAI API key for semantic search
- Install Database Schema:
- Copy the provided SQL from the setup guide
- Paste into Supabase → SQL Editor and run
- Sync Products:
- Visit Settings → Sync Products
- Click "Sync All Products" or use batch sync for large catalogs
- Visit app.supabase.com
- Go to Project Settings → API
- Copy your project URL and service role key OpenAI (Optional for Semantic Search):
- Visit platform.openai.com/api-keys
- Create a new API key
- Ensure billing is set up for embedding API usage
常见问题:
Is OpenAI required?
No! The plugin works great with just Supabase for fast keyword search. OpenAI is only needed for semantic (AI) search and enhanced recommendations. You can start with keyword search and add semantic features later.
How much does it cost to run?
Supabase: Free tier includes 50,000 monthly queries - perfect for most stores. Paid plans start at $25/month for high-traffic sites. OpenAI: One-time embedding cost of ~$0.05-$1.00 per 1,000 products. After initial setup, ongoing costs are minimal (only for new products).
Will this slow down my site?
No! Search queries run on Supabase's fast PostgreSQL infrastructure, not your WordPress server. This often makes search faster than default WooCommerce.
Does it work with my theme?
Yes! The plugin uses standard WordPress and WooCommerce hooks. It includes special integration for Woodmart theme's live search feature.
Can I customize the search behavior?
Absolutely! The plugin is built with developer hooks and filters. Need custom field indexing or search logic? Check our Premium setup service for advanced customization.
What happens to my data if I uninstall?
Your product data remains in your Supabase project - you have full control. The WordPress plugin only removes its settings and stops syncing. You can delete data from Supabase manually if desired.
Is it GDPR compliant?
The plugin only syncs product data (names, descriptions, prices, etc.) - no personal customer information. When semantic search is enabled, product text is processed by OpenAI according to their privacy policy.
Can I use this on multiple stores?
Yes! Each store gets its own unique Store ID, allowing multiple WooCommerce sites to use the same Supabase project while keeping data separate.
更新日志:
0.16.5 (Latest)
- New: WP-CLI schema installation commands for reliable database setup
- New: Direct PostgreSQL connection support with encrypted credential storage
- New: Three-tier installation system: Manual copy/paste, WP-CLI commands, and Admin interface buttons
- New: Migration Runner architecture for transactional database operations with rollback support
- New: Real-time installation progress feedback in admin interface
- Update: Enhanced admin interface with PostgreSQL connection configuration field
- Update: Improved security with encrypted PostgreSQL connection string storage
- Update: Better user experience with step-by-step setup guidance
- Update: Enhanced status checking with detailed environment diagnostics
- Fix: Improved error messages and troubleshooting guidance for failed installations
- New: Custom SQL upsert function for reliable product synchronization
- Fix: Product sync failures due to Row Level Security (RLS) policy conflicts
- Fix: Auto-sync triggering duplicate requests due to WooCommerce hook behavior
- Update: Enhanced GTIN field mapping for EAN/UPC/ISBN product codes
- Update: Improved Cost of Goods Sold (COGS) field detection and mapping
- Fix: Added track_click method
- New: Added analytics dashboard
- New: Fuzzy search
- New: Prepared for API managed API service alongside self-hosted
- New: Dual connection mode support (API Service vs Self-Hosted)
- New: License key activation system for API service
- New: Connection manager for seamless mode switching
- New: Enhanced admin interface with mode-specific guidance
- New: Welcome notices for new installations
- New: Plugin action links showing current mode
- Update: Refactored architecture to support both deployment options
- Update: Improved error handling and user feedback
- Update: Enhanced security for API communications
- Update: Increased match_threshold
- Fix: Woodmart AJAX integration
- Update: Improved readme file and documentation
- New: Enhanced SQL schema with partial SKU search
- New: Updated admin interface with better user experience
- New: Improved search result ranking and relevance
- New: Better admin notifications for SQL updates
- Fix: Resolved various edge cases in product sync
- New: Woodmart theme live search integration
- New: SKU/GTIN search fallback for better product discovery
- New: Complete plugin architecture refactor for better performance
- Fix: Improved search result accuracy and ranking
- Fix: Resolved embedding generation for missing products
- Fix: Status page statistics (division by zero errors)
- New: Admin notification system for database updates
- Update: Comprehensive readme improvements
- Update: Better documentation and setup instructions
- Fix: Product synchronization improvements
- New: Professional services banner and information
- Update: Enhanced plugin assets and branding
- Update: Improved readme file and documentation
- Fix: Removed debug logging that could impact performance
- Update: Documentation and user experience improvements
- Fix: Secure key storage for Supabase and OpenAI API keys
- Fix: Product recommendations and cart suggestions
- New: Enhanced encryption system with master key support
- Update: Improved security for sensitive data
- Update: Changelog formatting and documentation
- New: Automatic UUID generation for store identification
- Update: Renamed master key constant for better security
- Launch: Initial public release with full feature set