Advanced Search not searching SKUs in variants

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
joebeazelman
Lieutenant (LT)
Lieutenant (LT)
Posts: 78
Joined: Wed Mar 05, 2008 11:27 am

Advanced Search not searching SKUs in variants

Post by joebeazelman » Fri Sep 18, 2009 11:27 am

Advanced searches SKUs but only if they are not in the options/choices. Is there a way to get it to search the product and its variants.

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

Re: Advanced Search not searching SKUs in variants

Post by AbleMods » Sat Sep 19, 2009 3:56 am

Add the variant skus to the search keywords field on the main product record.
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


joebeazelman
Lieutenant (LT)
Lieutenant (LT)
Posts: 78
Joined: Wed Mar 05, 2008 11:27 am

Re: Advanced Search not searching SKUs in variants

Post by joebeazelman » Tue Sep 29, 2009 10:55 am


In the bug report, it says that in most cases merchants have dynamically generated SKUs. This may in fact be true for the majority of merchants selling a small number of products who can easily recode their existing SKU system to work with AC7. There are, however, merchants who sell hundreds or even thousands of different products whose customer's need this capability. Some merchants may have a small number of products but have a unique internal SKU generating system. Changing their SKU system to accommodate AbleCommerce's segmented sku system isn't feasible.

AbleCommerce should store SKUs as fixed strings. It will make it easy to search the product database and allows integration with back office systems that will need to lookup a SKU within AbleCommerce. The current system can work, but searching should just assume the SKUs are fixed. I see very little advantage in autogenerated segmented SKUs.

Post Reply