[TYPO3-shop] Query related to discount in tt_products

[Franz Holzinger]

Hello saurabh,

it is also possible to have a special discount only for some products.
There is pricecalc for the products where the price depends on the
amount of products someone buys.
There is discountprice very similar to pricecalc, but here the price of
one product is used and not a total price. Discountprice overrides the
pricecalc. 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. At
the moment this comparison only works with the price for one product.
Where one costs 4.99 Euro then with 100 pieces bought one will cost 2.49
Euro.

Greets,


> Hi Franz,
> 
> First of all, thanks for that Danish template.
> 
> I am using "Discount" in tt_products at two-levels:-
> (a) Product Level - Here, discount is coming for one or more products on
> basis of some calculation related to price and price(2).
> (b) User Level - Here, discount is coming for that user on all products
> on basis of a discount (%) field defined in back-end for that particular
> user.
> 
> Both are working fine.
> 
> But now I want to assign discount to a user only on certain products and
> not all products. Is it possible anyhow?
> 
> Thanks in advance,
> Saurabh Pareek
> 
>