Developer forum

Hi Mario

That is not very simple. In order for that to work, you need to have the stock levels for all products that you potentially need to list. So if the complete list is 10.000 products, you need to calculate the stocklevels for all of them. That will never work very well because of serious performance issues. If your lists are always 'small' i.e. 50 products, you can increase paging size to 50, get all products, calculate stock live and then remove the ones not in stock. But will only work with one page short lists.

Queries work on data that is stored in the index - and if you change the results after the query has been executed, paging, facets, counts etc. will not work anymore. So that is not a good way to go.

So the best way is to calculate stock for all products with intervals - i.e. 15 minutes or 1 hour or whatever in BC/NAV, move that data to DW and update the index, and then use that almost precise information to display the list. Of course it will have some false positives sometimes, but it will work and solve the problem.

BR Nicolai

Thank you, Nicolai.
that is the kind of solution that we have considered. We also tried stock calculation based on productGroup, but as you said, too many products - performance issues. I should definitely update DW.

Technical question:
out of curiosity, why this notification is not triggered?
​
namespace xyz.LiveIntegration.NotificationSubscribers
{
    [Subscribe(Dynamicweb.Ecommerce.Notifications.Ecommerce.Querying.BeforeQuery)]
    public class BeforeQueryNotify : NotificationSubscriber
    {
        public override void OnNotify(string notification, NotificationArgs args)
        {
            //some code..
        }
    }
}