on 05-25-2007 1:43 PM
Have anyone done pricing like this example
Products base price is 100 000 euros/100 000 pcs
The second products costs 900 euros /1000pcs (and the price rounding should be up to next *900 eur)
So when customer orders
101 000 pcs -> 100 000 eur + 900eur = 109 000 eur
110 000 pcs -> 100 000 eur + 10*900eur = 109 000 eur
120 000 pcs -> 100 000 eur + 20*900eur = 118 000 eur
Also the rounding should go as follows so when customer orders
100 501 pcs -> 100 000 eur + 900 = 100900
Also the number of pieces can be under the base amount (and price) so when customer orders
90 000 pcs -> 100 000 eur 10*900 eur = 91 000 eur
And the roundings should be the same way as above
99 499 pcs -> 100 000 eur - 900 = 99 100 eur
Maybe it can be handled with three different condition types and scales (scale every 1000) but it will be very difficult for user to maintain, because the prices are customer/product-based and the number of pieces varies from 50 000 to 150 000 pieces.
Has anyone had similar challenges ?
Regards
Arja
Sounds to me as if you don't need a scale, but a formula
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.