Category Search & Filter Improvements

[mouse_8b]

First, I'd like to thank the AC team for already improving on category search in R9. I found this thread earlier that was very helpful. In addition to offering Search By options on product templates, it would also be helpful to be able to sort on information that is already in the product info, just not in a template. Being able to filter by price, weight, color, and size fields from the product's regular attributes would be helpful. I can (and will) add some of these to the templates I am using, but this means manually duplicating data that the program already has. Filtering by options would also be neat, but I can see how that could be a lot more complex.

[mazhar]

Thank you for the feedback! Glad that you are making use of new feature. We have some improvements like price range in mind and will try to enhance the navigation in future releases. You can suggest improvements/features here http://ablecommerce.uservoice.com/forum ... merce-gold

[bigtires001]

Hello I came to the forum to ask but this thread may answer for me.

I have AbleCommerce for ASP.NET
VERSION: 7.0.8.5410

When managing the products, I am trying to use the search by SKU, however when an item had options like color it often has a new part number, and I cannot search for these part numbers. I have plans to upgrade to R10, would this fix the issue?

[Katie]

This feature was added in our last release of Gold R9. However, the variant based sku search is only available with SQL search provider. FTS based providers don't have this because they require an indexed key column which must be unique. After joining with variant table we may see multiple entries for same product so a unique constraint is not possible.

[bigtires001]

O ok thanks, well we use sql database so is that all that would be required beyond the R9 update?

[Katie]

Yes. You would just need to make sure that you are using the SQL search provider (not FTS or Lucene). This is a setting from the Configure > Store > General page.