cancel
Showing results for 
Search instead for 
Did you mean: 

SD Pricing: base price + scales + rounding

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Sounds to me as if you don't need a scale, but a formula