Managing Exact SKU Matches in Database Query
TLDR Sachyya is seeking to return exact product matches using SKU from a dataset. Kishore Nallan suggests disabling fuzzy matching by setting num_typos to 0 and prefix matching with prefix=false.
Jul 14, 2022 (15 months ago)
Sachyya
11:43 AMI have a dataset of products which is being queried by
query_by: sku,eon fields, on querying I want to get only the product having the exact match.For example if I query by
1234 , result shows products with sku 1234 and eon 123. But I want to show only the product with sku 1234. How can this be achieved?
Kishore Nallan
11:49 AM1234?Sachyya
11:50 AMKishore Nallan
11:59 AMKishore Nallan
11:59 AMKishore Nallan
11:59 AMprefix=false -- these two changes will ensure that you find the exact matches.Sachyya
12:55 PM
Typesense
Indexed 2779 threads (79% resolved)
Similar Threads
Implementation and Optimization of 'Similar Products' Feature
Stefan is considering using "curation" for pre-calculating similar products. Kishore Nallan suggests using preset API, but Stefan raised an issue with sorting based on non-stored values. The issue remains open for resolution.
Phrase Search Relevancy and Weights Fix
Jan reported an issue with phrase search relevancy using Typesense Instantsearch Adapter. The problem occurred when searching phrases with double quotes. The team identified the issue to be related to weights and implemented a fix, improving the search results.
Troubleshooting Typesense Instantsearch Adapter's 'filters' Property
Carl was unable to use the `filters` property of Typesense Instantsearch adapter for network call. Jason suggested using a scoped API key to combine filters and also recommended experimenting with dynamic filtering rules for multiple product numbers. Carl is satisfied with these solutions.