logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
judy at Web2Market  
#1 Posted : Monday, June 13, 2022 6:50:53 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 286

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
We have more clients wanted a faceted search, similar to what you are doing with Shop By so you might talk about doing a real faceted search instead of using product templates for it because of the performance issues using product templates. I had started out using Shop By on a site that had around 1000 products because they didn't want to pay for a third party and we thought performance might be OK because of the small number of products and it was really slow -6 to 9 seconds for filtering. I did make the performance acceptable(2 seconds for filtering) by decreasing the size of the InputValue in the ac_ProductTemplateFields table so that it could be indexed and changed the search source code (yes, they had purchased source code) so that it used = instead of like and that made the page fast enough. I think it would be even faster if there were separate tables for Shop By and the ac_ProductTemplateFields equivalent would have the InputChoiceId stored instead of text for InputValue. You could do that if you limited the InputChoices to use a dropdown in the admin instead of allowing a text field. The facets wouldn't be free text anyway, they would be limited to certain choices. For example, the language of a book could be limited to only specific choices and that way there wouldn't be any anomalies in wording either. Then you could include Category and Manufacturer and Price filters.
You could even include in it or separate from it an improvement to your search box where it shows top x products for the search in addition to suggested search terms. On of our developers did that for an AC9 site who wanted to get away from paying Nextopia and it's pretty slick.

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.