[Typo3-shop] Work method

Franz Holzinger franz at fholzinger.com
Wed Oct 26 18:39:28 CEST 2005


Hello Bill,

>> pricecalc {
>>   10.type = count
>>   10.field = price
>>   10.where =
>>   10.prod.1 = 4.99
>>   10.prod.2500 = 1000000.99
>> }
>>
> In other words it is best to set up 26,460 articles? Both quantity and 
> paper style affect price. Each article contains a style,a paper stock 
> (color variant field) and a quantity (gradings variant field). In other 
> words one article for each combination.
> 
> Artice 1 = CD Label
>            Yellow Permanent
>            Quantity 100
>            Price 10.00
> 
> Article 2 = CD Label
>             Yellow Permanent
>             Quantity 250
>             Price 17.00
> 
> Article 3 = CD Label
>             Yellow Permanent
>             Quantity 500
>             Price 25.00
> 
> and on and on it goes. 26,460 Articles x 5 Minutes per Article = 132,300 
> Minutes / 60 Minutes = 2,205 Hours. Am I missing something here? Of 
> course it won't take 5 minutes for all the articles, but you figure in 
> corrections and on and on it goes.
> 
This is where the
   10.where =
Settings in pricecalc are intended for, This settings defines for which 
records the field-comparison shall take place.
Here you can set a SQL where clause when this will be programmed in much 
less than 22 hours.


Franz



More information about the TYPO3-project-tt-products mailing list