Full Text Search Provider $60.00
Full Text Search Provider for SQL Server
Download Trial Documentation Add to cart Email a friend
SQL Server Full-Text Search for nopCommerce Full Text Search for SQL Server replaces nopCommerce's default LIKE '%keyword%' product search with SQL Server's native Full-Text Search (FTS) engine. Instead of slow table scans, your store uses indexed FTS seeks — delivering faster, more accurate results even on large product catalogs.
The plugin integrates transparently with nopCommerce 4.90. All standard search filters — category, manufacturer, price range, vendor, ACL, availability date, and published status — continue to work exactly as before, while the underlying search engine becomes dramatically more capable.
Key Benefits Faster search on large catalogs — FTS index seeks replace full-table LIKE scans, reducing query time as your product count grows.More relevant results — choose between ExactMatch, OR, and AND search modes to match the way your customers actually search.Broader search coverage — extend search to product descriptions, SKU, product tags, manufacturer part numbers, and grouped products.Zero storefront disruption — all existing nopCommerce search filters and catalog rules remain fully intact.Safe fallback — if full-text search is disabled, the store automatically falls back to the built-in nopCommerce product search.Built-in diagnostics — a toggleable debug log helps you monitor search performance and troubleshoot issues without touching the server.Main Features FTS enable / disable toggle — turn SQL Server Full-Text Search on or off directly from the admin configuration page without touching the database manually.Three search modes — select ExactMatch (phrase search), Or (any keyword matches), or And (all keywords must match) to control how search terms are evaluated via SQL Server CONTAINS.Per-field search toggles — independently enable or disable FTS indexing for product descriptions, SKU, product tags, manufacturer part number, and grouped / associated products.SQL Server FTS status indicator — the configuration page shows whether the connected SQL Server instance supports Full-Text Search, so you always know the current state before making changes.Debug logging — enable a log file that records timing and diagnostic information; view, download, or clear the log directly from the admin panel. The log auto-clears when it exceeds 10 MB.Transparent DI integration — the plugin registers itself as the active ISearchProvider and replaces the built-in product service in nopCommerce's dependency injection container, requiring no core code changes.Why Buy This Plugin Building a custom SQL Server Full-Text Search integration for nopCommerce requires deep knowledge of the framework's product service layer, stored procedure design, DI overrides, and database schema migrations. This plugin delivers a complete, tested solution that handles all of that out of the box.
No custom development or database scripting required — install and configure through the standard admin panel. Stored procedures are pre-built and deployed automatically during installation. Search mode and field scope are fully configurable without any code changes. Safe fallback behavior protects your store if FTS is ever disabled. How It Works Install the plugin via the standard nopCommerce plugin manager. The installer automatically creates the required stored procedures and database objects.Open the configuration page at Admin → Full Text Search Settings → Configure to review the current SQL Server FTS support status for your database.Enable Full-Text Search using the toggle button on the configuration page. The plugin activates the FTS catalog on your SQL Server database.Choose your search mode — select ExactMatch, Or, or And depending on how you want multi-keyword queries to behave.Select the product fields to include in search — descriptions, SKU, tags, manufacturer part number, and grouped products can each be enabled independently.Shoppers search normally on your storefront — all search queries are now powered by SQL Server Full-Text Search, with full support for existing category, price, vendor, and other filters.Compatibility / Requirements nopCommerce version: 4.90, 4.80, 4.70, 4.60, 4.50, 4.40License: A FoxNetSoft serial number is required for production use. A 30-day trial is available after installation.Database: Microsoft SQL Server only — MySQL and PostgreSQL are not supported.SQL Server Full-Text Search: the Full-Text Search feature must be installed and enabled on your SQL Server instance. The plugin checks and displays this status but cannot install the SQL Server FTS feature itself.