Developer forum

Hi Casper

There is no simple approach to this.

Discounts are related to a lot of things - like time, currencies, orders etc. etc. So if a product has a discount or not is very difficult to not do very buggy. That said, it is possible to get the most brutal part of a product discount into the index. But I have no specific handles for you.

I know Nuno have some code from old times doing part of this. You might find it here in the forum.

Or Nuno?

BR Nicolai

Hi Casper,

Can you expand on your final goal? Maybe we can find another solution for it.

As Nicolai described, what you need "can" be done, but shouldn't. It would force discounts to be only configured in a certain way, otherwise it becomes a very time-consuming and bug-prone. The problem becomes that the customer may forget the boundaries, or people change in the organization and documentation is no-help, so it becomes a bunny-trail of issues.

Best Regards,

Nuno aguiar

Hi both,

I understand the complexity of a product discount in an index (cached documents vs. instant product model)

What is the recommended method, if you want to filter/faceting on products that have a product discount?

So just if a product is member of a discount? Because you cannot see if the discount is actually valid.

You can create a discount extender that can find something out - here is a rough example - it will probably have performance problems and you need to fiddle what discounts you want to trigger true or false on.

namespace Dynamicweb.Ecommerce.Examples
{
    public sealed class IndexBuilderExtenderExample : IndexBuilderExtenderBase<ProductIndexBuilder>
    {
        public override void ExtendDocument(IndexDocument document)
        {
            if (document.ContainsKey("ID"))
            {
                string productid = (string)document["ID"];
                string variantid = (string)document["VariantID"];
                if (!string.IsNullOrEmpty(productid))
                {

                    bool productHasDicount = false;
                    double productDicountPercent = 0;

                    var product = Dynamicweb.Ecommerce.Services.Products.GetProductById(productid, variantid, useDefaultLanguage: true);
                    var priceContext = new PriceContext(Services.Currencies.GetDefaultCurrency(), Services.Countries.GetCountries().FirstOrDefault(), Services.Shops.GetDefaultShop(), null, false, DateTime.Now());

                    foreach (var discountInfo in product.GetDiscountMatrix(priceContext, string.Empty, 0))
                    {
                        if (discountInfo.Discount.Active && discountInfo.Discount.ProductQuantity <= 1)
                        {
                            //will find the first available discountInfo and use that percentage.
                            productHasDicount = true;
                            productDicountPercent = discountInfo.Discount.Percentage;
                            break;
                        }
                    }
                    if (productHasDicount)
                    {
                        document.Add("Custom_ProductHasDicount", "True");
                        document.Add("Custom_ProductDicountPercent", productDicountPercent.ToString("P2"));
                    }
                    else
                    {
                        document.Add("productHasDicount", "False");
                    }
                }
            }           
        }
    }
}