TOPIC:

Hello,
I have installed the Shipping by Rules plugin.
I found it excelent and perfect idea! Congruts!
I have some questions though,I need to do some calculations a little bit complicated in our eshop.
For the shippment in Greece when the total weight of the products is under 2 kilos, the shipping cost is 3 euros.
Above 2 kilos for every extra kilo the extra cost is 0.90/kg until 9 kilos and 0.70/kg above.
In all cases, if the total amount is up to 42euros the sippping cost is FREE.
Is it possible?

I started to write this rule:
Name=ACS Standard; Weight<=2; Shipping=3
Name=ACS Standard; 2<Weight<=3; Shipping=3.9
Name=ACS Standard; 3<Weight<=4; Shipping=4.8
Name=ACS Standard; 4<Weight<=5; Shipping=5.7
.....
....on and on and on
...
until where do I stop¿?

I am not sure if this is correct. I should stop at some point, on some weight. But what if some customer orders more products (more weight)?

I am sure there must be something more mathematically correct..
Could you please help me with the rules I have to apply?
Thank you in advance!

Dear Dorothea,
You are absolutely right with your doubts about when to stop the rules. In the free version of the plugin, no mathematical expressions are supported, so you can only give fixed bounds, and you must explicitly list each kg range. Of course, you customer can always make an order that is just a little heavier than the highest weight that you gave in your last rule...

With the advanced (i.e. paid) version of the plugin, you can easily write these rules using a formula:

Best regards,
Reinhold

Thank you! I am glad I know it is possible to do this!
Can you please tell me, where do I perchase the paid version? I only see one download arrow in the page.
Also I wonder if the weight calculates the total weight in the cart?
There are products that the weight are in onz, but the shipping in all products have to be calculated in kg. Does it converted automaticaly?

Hello again,

can you please explain what do you calculate here 3+7*0.9+ceil(Weight-9)*0.7?
I am lttle confused. What ceil means?

Also in a particular country I want shipping cost 3,5euros until 2kilos and every extra kilo 1euro extra charge.
I bought the advanced Shipping by rule to write the rule:
Name=Your order is {weight}kg. ACS NET 2; Weight<=2; Shipping=3.5
Name=Your order is {weight}kg. ACS NET 2; 2<Weight; Shipping=3.5+ceil(Weight-2)*1
The weight of some products I have in the cart is 2.551455kg I wonder, can it be rounded at 2.5?
The shipping cost is 4.5, I suppose it is correct as the company will charge 3kilos! :)

Also in another country the extra cost of 1euro will be at every extra 0.5kilo, instead of 1kilo, how do I apply the rule?

Thank you in advance!

"ceil" is a function that rounds up to the next whole number ("ceil" is shorthand for ceiling), so e.g. ceil(7.8) returns 8, while ceil(7) returns 7 (as 7 is already a whole number).

The individual terms of 3+7*0.9 + ceil(Weight-9)*0.7 mean the following:
-) The first 2kg are 3 Euro (the first term)
-) The next 7kg (each kg above 2, up to 9kg) are 0.9 Euro each, so 7*0.9 in total
-) Finally, each kg above 9kg is charged 0.7 Euro. Weight-9 is the weight exceeding 9kg, eg. 9.45 kg is 0.45 kg above 9kg. For this 0.45kg a full kg is charged, so we round it up to the next whole kg, which is exactly what ceil is doing.

To charge 1 Euro for every 0.5kg, you can simply multiply the weight by 2 and handle it similarly to the 1 Euro/kg case. Or you can first round up to the next 0.5kg and then multiply by 2:or equivalently:
Regarding your request how to round the weight for display: You'll have to define a custom variable that stores the weight rounded to a given accuracy, e.g. rounded to the next 0.1 step. Note, however, that 2.551455 will be rounded to 2.6! Also, since you charge 1 Euro for each additional kg, ie. 2.01 will still count as 3 kg, you should not round to the nearest 0.1 kg step, but rather always round UP to the next 0.1kg step:
Best regards,
Reinhold

Hello,
I used and changed the above code so I wrote this:

Name= - Zone 2 - Delivery 2-4 days. Weight: {weight}kg. ; Weight<=0.5; Shipping=39.60
Name= - Zone 2 - Delivery 2-4 days. Weight: {weight}kg. ; 0.5<Weight;
Shipping=39.60+10*2*(ceil(Weight,0.5)-0.5)

I am almost sure it was working..
Now I updated to 6.1.7 and I get an error:
when I have more than 500gr in the cart
Unknown rule type '' encountered for rule 'Name= - Zone 2 - Delivery 2-4 days. Weight: {weight}kg. ; 0.5
What am I doing wrong??

what I need is 39,60euro for the first 0.5kilo
and for every 0.5kilo extra charge 10euro.

Thank you!

Joomla version 3.6.4
Advanced Open Tools 6.1.7

test please make an order from Iceland
shop.nutritionglobaltrading.com/en/

Dear Dkaneloglou,
Sorry for the late reply.
About your error: To me it looks like the second and third lines should actually be one line with no line break before the shipping.
The error message says that the second rule does not have any type, ie. it does not specify shipping costs (no Shipping=..., no NoShipping) and also does not define a variable or extra shipping charges.

If you remove the linebreak before the Shipping=... on the third line, things should work.

Best regards,
Reinhold