Reference information - discount calculation

Edit on GitHub

This topic contains the information that you need to know when working with discount calculations in the Discount calculation tab.

Calculator Type

The discount can be calculated in two ways:

  • Percentage Value: The discount is calculated as a percentage of the discounted items. If selected, you will need to set the percentage value (e.g. 25)
  • Fixed Value: A fixed amount is discounted. If you select this type, you will need to specify the amount (Gross, or Net, or Both) for each currency used in your store.


Product Price Calculator Plugin Amount Discount Applied Price to Pay
50 € Calculator Percentage 10 5 € 45 €
50 € Calculator Amount 10 € 10 € 40 €

Discount Application Type

You can select one of the following options:

  • Query String
  • Promotional Product

Query String

You can use a query to define discount conditions. Only products that satisfy the query’s conditions are discountable. Queries also define if the discount is applied to one or several products. Discount conditions are set by using either Query Builder or by specifying a Plain query.

Use the Query Builder to construct queries (guided) or the Plain query field to enter them (free text). You can switch between both modes by clicking the corresponding button (note: incomplete queries cannot be transferred between the two modes). Query Builder Discount_Calculation_Query

Plain Query Discount_Calculation_Plain Query

The query builder lets you combine different conditions with connectors (AND and OR). Multiple conditions (rules) can be added and grouped in this way. Each condition (rule) consists of:

  • field (e.g. attribute.color)
  • operator (e.g. equal: =)
  • value tokens (e.g. blue)
The fields and values are defined by your shop data.

These tokens are used to build plain queries too. The pattern of the plain query is as follows: Plain Query Pattern

You can find plain query examples in the following table. |Plain query|Explanation| |—|—| |day-of-week = ‘1’|Discount applies if the order is placed on Monday.| |shipment-carrier != ‘1’ AND price-mode = ‘GROSS_MODE’|Discount applies if the shipment carrier with the attribute “1” is not chosen and gross pricing is selected.| |currency != ‘EUR’ OR price-mode = ‘GROSS_MODE’|Discount applies if the selected currency is not Euro or the pricing mode is gross.|

See [Token Description Tables](/docs/scos/user/back-office-user-guides/202009.0/merchandising/discount/references/token-description-tables.html
for more information.)

Discount promotion to product

Sometimes, it is more profitable to give away free products or provide a discount for the products that are not yet in the cart instead of the ones that are already there. This discount application type enables you to do just that. When a customer fulfills the discount conditions, the promotional product appears below other items. The SKU of the promotional product you wish to be available for adding to cart is entered in the Abstract product sku field. Then, you enter the Quantity of the chosen promotional product to be available for adding to cart. Application type

You can either give away the promotional product completely for free or provide a discount for this product by specifying the percentage value or a fixed amount to be discounted from the promotional product’s price (when giving the product for free, the percentage value should be 100%, while the fixed-price value should be equal to the product’s price).