Hi, @jimmykwk, thanks for your interest.
Yes, it can be done, placing a rule for each range. First, set the group-by option as “all grouped as one”, to get global weight comparison.
Then, add rules in this way:
#1 WHERE Weight MIN >= 6, MAX <=10, Price 10$
#2 WHERE Weight MIN > 10, MAX <=11, Price 12$
#3 WHERE Weight MIN > 11, MAX <=12, Price 14$
…
#X WHERE Weight MIN > 19, MAX <=20, Price 30$
…please, note: 10kg will fulfill #1, but 10.1kg will fulfill #2
===
With Fish and Ships Pro, can be done with two rules, using the special action Math expression:
#1 WHERE Weight MIN >= 6, MAX <=10, Price 10$
#2 WHERE Weight MIN > 10, MAX <=20, Special Action Math expression:
result = 10 + ceil(weight – 10) * 2;
…weight will be replaced with the cart weight, and ceil makes a round up
=====
Please, confirm if this works as you expect
Kind regards,
Carles Martin
wp-centrics support team