[TYPO3-shop] Query related to discount in tt_products

[Franz Holzinger]

Hello saurabh,
> 
> But, I am asking something different.
> Suppose I am having several products under different categories and I
> want to allow a certain discount
> only on some products to a user. for eg.:-
> (a) discount of 10% only on product 'cola' under "Drink" category and
> 'Pizza' under "Food" category
>     and not on rest of the products, or
> (b) discount of 5% only on product 'cola' under "Drink" category and of
> 10% only on 'Pizza' under
>     "Food" category and not on the rest of the products.
> 
> Also, is it possible to set this kind of discount for different users
> with different discount-prices
> i.e.other than 10 and 15 ?
> 
Well, something has to be coded to use the WHERE-clause here.
pricecalc {
  10.type = count
  10.field = price
# cola with 10% discount
  10.where = uid = 34
  10.prod.1 = 0.9

Where the uid of cola e.g. is 34 and one bottle normally costs 1 Euro.
Then the endprice would be 0.9 Euro when at least 1 cola is bought.


> 
>> In the future the field where can define a SQL WHERE clause
>> to which the line is valid for. This has not been implemented yet.


Greets,

Franz