Gold R10 search include variant sku?

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Gold R10 search include variant sku?

Post by AbleMods » Fri Nov 06, 2015 11:59 am

Does the Able search include variant SKU or just product SKU?
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Gold R10 search include variant sku?

Post by mazhar » Fri Nov 06, 2015 10:35 pm

Variant Sku searches are only supported through SQL provider.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Gold R10 search include variant sku?

Post by AbleMods » Fri Nov 06, 2015 11:01 pm

Ok so SQL FTS doesn't include variant sku, but regular SQL provider does?
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Gold R10 search include variant sku?

Post by mazhar » Mon Nov 09, 2015 12:33 am

Yes only SQL provider does support and that too in admin searches. Both FTS provider doesn't support this function directly but any search keywords having - in them will be passed to SQL provider for processing. This means while using FTS provider you can search variants with SKU having - in them due to this indirect use of SQL provider.

Post Reply