[SOLVED] Shipping by zipcode, actual weight and dimensional

Shipping by zipcode, actual weight and dimensional 23 Sep 2014 17:19 #1

febecas
Topic Author

Hello Reinold:

I bought Advanced Shipping by Rules Plugin for VirtueMart 2 and do not know if you can do what I need.

I have a transport rate in which the price must be applied according to the following variables:

1) Prices by zip code: 4 different areas for many postcodes penílsula each of the areas.
Another 4 more zones for the islands with a surcharge if they are smaller islands.

2) Price per weight: according to postal code with a weight range that goes from 1 kg to 2000 kg (from 10Kg to 10Kg).
When more than 2000 Kg = 2 € / kg (for example).

3) Bulk price: if (height x width x length) * 250 = x Kg, and if this result (x kg) is greater (>) than the actual weight, the weight per volume should be applied.

Can you help me with the correct syntax?
How you can make it as simplified as possible?
I've been looking through the forum and have not found a complete solution.

Best regards
Fernando

Shipping by zipcode, actual weight and dimensional 02 Oct 2014 17:49 #2

Reinhold
Offline
Posts: 1588

Dear Fernando,
Ad 1) You can use custom variables for the area checks (if many rules would have identical, very long postcode checks). See the documentation of the plugin (and the examples page linked from the documentation)

Ad 2) This can be done as follows:

Name=Below 2000kg; Weight<=2000; Shipping=1234
Name=Above 2000kg (2€ per kg extra); Weight>2000; Shipping=1234+ceil(Weight-2000)*2

Of course, you can add the postcode checks as additional conditions.

Ad 3) The issue here is how to calculate height, width and length of the order. It basically depends on how you stack the products into boxes. So there is not one correct width, height and length for an order, but many possible values. I'm afraid no computer can properly calculate width/height/length of an order.

Best regards,
Reinhold

Shipping by zipcode, actual weight and dimensional 03 Oct 2014 14:15 #3

febecas
Topic Author

Hello Reinhold, thanks for your reply

This rule works well, but how would the varible of ZIP?

Name=AND, CAT, GAL, hasta 5kg; 04000<=ZIP<04999 OR 08000<=ZIP<08999 OR 11000<=ZIP<11999 OR 14000<=ZIP<15999 OR 17000<=ZIP<18999 OR 21000<=ZIP<21999 OR 23000<=ZIP<23999 OR 25000<=ZIP<25999 OR 27000<=ZIP<27999 OR 29000<=ZIP<29999 OR 32000<=ZIP<32999 OR 36000<=ZIP<36999 OR 41000<=ZIP<41999 OR 43000<=ZIP<43999[/color];0.01<=Weight<=5; Shipping=8.71
Name=AND, CAT, GAL, hasta 10kg; 04000<=ZIP<04999 OR 08000<=ZIP<08999 OR 11000<=ZIP<11999 OR 14000<=ZIP<15999 OR 17000<=ZIP<18999 OR 21000<=ZIP<21999 OR 23000<=ZIP<23999 OR 25000<=ZIP<25999 OR 27000<=ZIP<27999 OR 29000<=ZIP<29999 OR 32000<=ZIP<32999 OR 36000<=ZIP<36999 OR 41000<=ZIP<41999 OR 43000<=ZIP<43999;5.01<=Weight<=10; Shipping=10.42
Name=AND, CAT, GAL, hasta 20kg; 04000<=ZIP<04999 OR 08000<=ZIP<08999 OR 11000<=ZIP<11999 OR 14000<=ZIP<15999 OR 17000<=ZIP<18999 OR 21000<=ZIP<21999 OR 23000<=ZIP<23999 OR 25000<=ZIP<25999 OR 27000<=ZIP<27999 OR 29000<=ZIP<29999 OR 32000<=ZIP<32999 OR 36000<=ZIP<36999 OR 41000<=ZIP<41999 OR 43000<=ZIP<43999;10.01<=Weight<=20; Shipping=13.48
Name=AND, CAT, GAL, hasta 30kg; 04000<=ZIP<04999 OR 08000<=ZIP<08999 OR 11000<=ZIP<11999 OR 14000<=ZIP<15999 OR 17000<=ZIP<18999 OR 21000<=ZIP<21999 OR 23000<=ZIP<23999 OR 25000<=ZIP<25999 OR 27000<=ZIP<27999 OR 29000<=ZIP<29999 OR 32000<=ZIP<32999 OR 36000<=ZIP<36999 OR 41000<=ZIP<41999 OR 43000<=ZIP<43999;20.01<=Weight<=30; Shipping=18.55
Name=AND, CAT, GAL, hasta 40kg; 04000<=ZIP<04999 OR 08000<=ZIP<08999 OR 11000<=ZIP<11999 OR 14000<=ZIP<15999 OR 17000<=ZIP<18999 OR 21000<=ZIP<21999 OR 23000<=ZIP<23999 OR 25000<=ZIP<25999 OR 27000<=ZIP<27999 OR 29000<=ZIP<29999 OR 32000<=ZIP<32999 OR 36000<=ZIP<36999 OR 41000<=ZIP<41999 OR 43000<=ZIP<43999;30.01<=Weight<=40; Shipping=23.2
Name=AND, CAT, GAL, hasta 50kg; 04000<=ZIP<04999 OR 08000<=ZIP<08999 OR 11000<=ZIP<11999 OR 14000<=ZIP<15999 OR 17000<=ZIP<18999 OR 21000<=ZIP<21999 OR 23000<=ZIP<23999 OR 25000<=ZIP<25999 OR 27000<=ZIP<27999 OR 29000<=ZIP<29999 OR 32000<=ZIP<32999 OR 36000<=ZIP<36999 OR 41000<=ZIP<41999 OR 43000<=ZIP<43999;40.01<=Weight<=50; Shipping=27.84
Name=AND, CAT, GAL, hasta 60kg; 04000<=ZIP<04999 OR 08000<=ZIP<08999 OR 11000<=ZIP<11999 OR 14000<=ZIP<15999 OR 17000<=ZIP<18999 OR 21000<=ZIP<21999 OR 23000<=ZIP<23999 OR 25000<=ZIP<25999 OR 27000<=ZIP<27999 OR 29000<=ZIP<29999 OR 32000<=ZIP<32999 OR 36000<=ZIP<36999 OR 41000<=ZIP<41999 OR 43000<=ZIP<43999;50.01<=Weight<=60; Shipping=32.55
Name=AND, CAT, GAL, hasta 70kg; 04000<=ZIP<04999 OR 08000<=ZIP<08999 OR 11000<=ZIP<11999 OR 14000<=ZIP<15999 OR 17000<=ZIP<18999 OR 21000<=ZIP<21999 OR 23000<=ZIP<23999 OR 25000<=ZIP<25999 OR 27000<=ZIP<27999 OR 29000<=ZIP<29999 OR 32000<=ZIP<32999 OR 36000<=ZIP<36999 OR 41000<=ZIP<41999 OR 43000<=ZIP<43999;60.01<=Weight<=70; Shipping=37.08

Best regards
Fernando

Shipping by zipcode, actual weight and dimensional 03 Oct 2014 16:28 #4

Reinhold
Offline
Posts: 1588

As the ZIP code check is always the same, you can store its result in a custom variable and reuse that in all rules (using "Condition=..." to indicate to the plugin that this is a condition rather than the shipping costs!):

Variable=zipcheck; Value= 04000<=ZIP<04999 OR 08000<=ZIP<08999 OR 11000<=ZIP<11999 OR 14000<=ZIP<15999 OR 17000<=ZIP<18999 OR 21000<=ZIP<21999 OR 23000<=ZIP<23999 OR 25000<=ZIP<25999 OR 27000<=ZIP<27999 OR 29000<=ZIP<29999 OR 32000<=ZIP<32999 OR 36000<=ZIP<36999 OR 41000<=ZIP<41999 OR 43000<=ZIP<43999;

Name=AND, CAT, GAL, hasta 5kg;  Condition=zipcheck; 0.01<=Weight<=5; Shipping=8.71
Name=AND, CAT, GAL, hasta 10kg; Condition=zipcheck; 5.01<=Weight<=10; Shipping=10.42
Name=AND, CAT, GAL, hasta 20kg; Condition=zipcheck; 10.01<=Weight<=20; Shipping=13.48
Name=AND, CAT, GAL, hasta 30kg; Condition=zipcheck; 20.01<=Weight<=30; Shipping=18.55
Name=AND, CAT, GAL, hasta 40kg; Condition=zipcheck; 30.01<=Weight<=40; Shipping=23.2
Name=AND, CAT, GAL, hasta 50kg; Condition=zipcheck; 40.01<=Weight<=50; Shipping=27.84
Name=AND, CAT, GAL, hasta 60kg; Condition=zipcheck; 50.01<=Weight<=60; Shipping=32.55
Name=AND, CAT, GAL, hasta 70kg; Condition=zipcheck; 60.01<=Weight<=70; Shipping=37.08

Best regards,
Reinhold

Shipping by zipcode, actual weight and dimensional 06 Oct 2014 10:21 #5

febecas
Topic Author

Thank you very much Reinhold, the variable for postal codes works perfectly.

Can you make a variable for shipping methods by volume (dimensional weight) just to some categories of VM2 ?. The terms of the variable I explained above in point 3).
I have some categories where the volume is always higher than the actual weight.

Best regards,
Fernando

Shipping by zipcode, actual weight and dimensional 07 Oct 2014 13:26 #6

Reinhold
Offline
Posts: 1588

I have put "dimensional weight" on my list of possible new feature of the plugin, but I don't know when or if I'm able to implement it. Main issues are:
- The minimum density for the dimensional weight needs to be configurable
- As you said, in your case the dimensional weight applies only to certain categories
- A proper user interface in the shipping config needs to include both of the above without distracting users that don't need a dimensional weight.

Best regards,
Reinhold

Shipping by zipcode, actual weight and dimensional 07 Oct 2014 15:32 #7

febecas Topic Author	Hello Reinhold, It really is a shame. Thank you very much for your help. Best regards, Fernando Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.