TOPIC:

Hi,
In my country some freight company regulations is mandatory to use insurance for categories of electronic products or the price is 10 times the shipping cost

I still cannot find the good script for this need, below is temporary solution.


I'm use conditions "2 in Categories OR Amount>1000000" for temporary, it should be "2 in Categories OR Amount>10*Shipping" but it's not work.

I need your suggestion and support.

Thanks,
Ruhanda

Complete script:
================
(translate for some variable: BeratPengiriman is Weight, Asuransi is Insurance)

Name=Masukan KODE POS (ZIP) yang benar untuk mendapatkan biaya pengiriman ; ZIP<=0; NoShipping
Name=Pembelian masih kosong Anda belum Memiliki/Memilih Produk ; Products<=0; NoShipping
Variable=Volumetrik;value=0
Variable=Asuransi;value=0
Variable=yesno;value="No"
Variable=Volumetrik;Volume!=0;value=ceil(Volume/6000)
Variable=BeratPengiriman;Volumetrik<=Weight;value=Weight
Variable=BeratPengiriman;Volumetrik>Weight;value=Volumetrik
Variable=Asuransi;2 in Categories OR Amount>1000000;value=(0.002*Amount)+5000
Variable=yesno;2 in Categories OR Amount>1000000;value="Yes"
Name= {City} Zona-8,1-2 Hari, Asuransi:{yesno}, {BeratPengiriman}Kg; 10001<=ZIP<=17435; Shipping=Asuransi+ceil(BeratPengiriman)*8000

The problem is that when the conditions and variable definitions are evaluated, the shipping cost is not yet determined, so you can't base your condition or variable on the resulting shipping costs.

Unfortunately, I don't have any suggestion for how to properly implement this...

Sorry,
Reinhold