Pricecalc, discountprice and creditpoints configuration 

The left edge of integers correspond to lines belonging together, the meaning of the right edge depends on the settings for each line. With pricecalc you will get a rebate only with the listed amounts, with discount price you will get a rebate also for all amounts in between.

• pricecalc: price calculation

Special Prices for the products. Where 1 product costs 4.99, 2 products will cost 8.99. With discount price this will form the price for one product. With pricecalc it is the price for all products together where 1 has cost 4.99 in the products folder. The discountprice overrides the pricecalc if possible, because this should be cheaper then. A price calculation from here will get replaced if price2 is used. Attention: getDiscountPrice must be 1 if you want to allow it for all customers.

Example:

pricecalc {
    10.type = count
    10.field = price
    10.sql.where = 
    10.prod.1 = 4.99
    10.prod.2 = 8.99
    10.prod.5 = 19.99
    20.type = count
    20.field = price
    20.sql.where = 
    20.prod.1 = 6.99
    20.prod.2 = 13.98
    20.prod.5 = 29.99
}

• discountprice: discount price calculation

Here the single prices for products are calculated depending on the count of articles, if type=count. The additive settings tells if all the products are counted together even from different lines. Use type = count and prod.type = percent if you want to give a rebate in percentage instead of the total price. But you must set a sql condition in this case in order not all products will offer this reduction.

Example:

discountprice.50 {
    type = count
    sql.where = color = 'rot'
    prod.type = percent
    prod.0 = 6
}

Example:

discountprice.50 {
    type = count
    sql.where = color = 'rot'
    prod.type = percent
    prod.0 = 6
}

Example:

discountprice {
    10.type = count
    10.field = price
    10.additive = 0
    10.sql.where =
    10.prod.1 = 4.99
    10.prod.100 = 2.49
    10.prod.1050 = 2.39
    20.type = count
    20.field = price
    20.sql.where =
    20.prod.1 = 6.99
    20.prod.100 = 2.59
    20.prod.1050 = 2.49
}

• Credit points:

This tells you how many credit points someone will get if he buys articles in the shop. The right values are the percentage of the price of the ordered articles, if type=price.

Example:

creditpoints {
    pricefactor = 0.5
    10.type = price
    10.prod.1   = 0.02
    10.prod.101 = 0.04
    10.prod.501 = 0.06
}

Only valid for discount price. If set all the products with any of these discount prices are counted together to calculate which discount price will apply. If unset only the products of the same price are counted.

Meaning of the right edge integer which usually gets calculated: count: the products count (pricecalc and discountprice only) price: the total price of all articles is used (creditpoints only)

SQL conditions over the records