Variant Sku Search

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Variant Sku Search

Post by Katie » Mon Jan 29, 2018 5:55 am

We can have our SQL based search provider adjusted for this ability. Its complicated for FTS providers due to some constraints of Full Text Searches and how we manage our variants. For example considering most variant SKU will have pattern like BASESKU-VARSKU which means FTS will not be able to index such SKUs considering they have punctuation marks(-). If some one tries to search a keyword with punctuation marks on FTS provider it falls back to SQL Criteria queries.
If we look at Mazhar's post, and from what I also understand, is that FTS has a constraint where it will not be able to search or SKU's formatted with the hyphen.
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Post Reply