Developer forum

We support millions of products - and sort by price or do price filtering with live prices while searching for something would take a long time and make your ERP server go into flames. Though it would look awesome, we do not support it. We simply cannot implement that in a way that can work...

Even with just 1000 products in a search, this would be impossible with just a little performance. Also to do facets and filtering, the values have to be in the index - and if prices are live that is not possible. If the values are not in the index, we would have to retrieve the entire search result, calculate all prices, sort and filter the result and then render the 30-ish products on that given page. It would be possible for search results with few products, but does not scale.

The best option is to import base prices on the products and let them be indexed and use them as an indicative price facet.

If you really want full customer specific price filtering, you need to calculate the price for each product and customer/customer group and add that to the index at index time. Then add an extension that will be able to do the filtering on the search against the index...

If you have any great suggestions that could work, please share.

BR Nicolai

I agree.

Just to add some thoughts to this, we run into this too because we use Live Integration for most all of our sites. We just tell our customers that we will sort based on their list price (the default price for the product that we have in batch). That will typically be the same sorting as their discounted price so it should be the same or almost the same. This is essentially the same as Nicolai said. I'm just confirming that we do that too.

Most people are fine with that and it performs well with minimal effort. 

Thanks for your input