We have a problem with the product list filtering and sorting. The product page needs a price sorting, and the prices are fetched live from the ERP. That is, prices aren't stored into the DW database. All prices are 0 for DW, so all products have 0 price when we build the indexes of the repository.
We tried to implement a Dynamicweb.Ecommerce.Notifications.Ecommerce.ProductList.BeforePaging notification, to sort the prices before being rendered. It works ok when all the products of a category are shown. But when selecting a facet, the page is still showing all the products, not just the filtered products. So there is a "misadjustment" between the sorting and the facets.
How may we implement the price sorting when the price is not in the database?