Developer forum

Forum » Ecommerce - Standard features » Discount Included Products with Query not working

Discount Included Products with Query not working

Nuno Aguiar
Nuno Aguiar



Since the Discounts performance has been improved we were trying to use Queries again.


In the link above you can that I have a basic Query, and it's working when I assign it to excluded products, but not when I do it for Included. In the screencast I am using 9.8.5, but this was discovered on a customer with 9.8.6


Best Regards,

Nuno Aguiar


Oleg Rodionov Dynamicweb Employee
Oleg Rodionov

Hi Nuno,

I've created new TFS 80497 against the issue. The bug seems to be reproduced for Excluded Products as well, try to add extra product to cart (not under query output) - the product is without discount as well (compare it if Excluded Products is set via product selector). Thanks for observing.

BR, Oleg QA 

Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen

Do not use queries for discounts unless you hate your self and your customers. It has not been made faster.

Nuno Aguiar Dynamicweb Employee
Nuno Aguiar

Hi Nicolai,


I do not hate myself, but I won't reply about customers :P


The problem is their marketing campaigns:

  • I know they are a lot faster in 9.8 btw. In 9.7 they were a lot slower
  • They use queries to get a "list of products"
  • The criteria does not follow the ecom group structure - queries do
  • Their workaround is to create a query and then add the products to a dummy group and then to the discount
  • Currently they don't have the PIM, but we need to give it to them otherwise it would be impossible to even see what the query returns (you and I talked about a way to view queries in the backend, which would solve for this too)


Do you have another suggestion we could achieve a similar goal for a customer to manage? They do this frequently and at any given time may have 40 to 60 active discounts x 3 sites


Best Regards,

Nuno Aguiar


You must be logged in to post in the forum