add 2 new columns to the eCart object:
dicount1
discount2
on the calculations tab, add to new calculations:
totalDiscount1:
[discount1] * [Quantity]
totalDiscount2:
[discount2] * [Quantity]
Next On the discount tab, create 2 discounts:
Name: 1000kg - 3000kg
Triggers:
Subtotal For Any Column:
If the subtotal for column 'Total Weight' is '>' a value of '1000'
AND
Subtotal For Any Column:
If the subtotal for column 'Total Weight' is '<=' a value of '3000'
Calculation:
Column Subtotal:
Subtotal of Column 'totalDiscount1' 'plus '0'
Name: over 3000kg
Triggers:
Subtotal For Any Column:
If the subtotal for column 'Total Weight' is '>' a value of '3000'
Calculation:
Column Subtotal:
Subtotal of Column 'totalDiscount2' 'plus '0'
in the add to cart button for each product, set the Price Column to the regular price. Set the discount1 column to the discount for the second weight break (i.e. 5 for product 1, 10 for product 2), and set discount2 to the discount amount for the third weight break (i.e. 10 for product 1, 15 for products 2)
