Optional Shipping Insurance Module [Support Thread]

joe.davila:

Easy there. :blink:
I have all my tax rates set up in those tables. I don't want to wipe them out.
Oops. Never mind then.
I think it's just coincidence but Iowa has the geo_zone_id of 20, that's why the insert fails.

Do you know if the reference to 20 in the sql patch can be changed to a different number (one that is not yet in use in my zone and tax rate tables?

If I can simply change the value to 200, let's say, then I could insert the values without any issue. I just don't know if 20 is referenced somewhere in the code for the insurance module.

I don't know what to say about that. In my DB, the "International" zone has the ID of 20 (in the geo_zones table).

How many records do you have in geo_zones, anyway?

Here is how I got it to work, not sure on the order of creation...sorry

Make a new Zone called Shipping Insurance Zone

Make a new tax class called Shipping Insurance

Create a new tax rate for Shipping Insurance tax class with 0% as the tax rate.

Set up the Shipping Insurance Module the way you want it ( I only tried this with a percentage rate, didn't try tables)

--- I don't know if all of these steps are needed but after doing all the above the insurance fee shows up at the final checkout step right above the sub total line.

It would be nice if it was also visible on the shipping selection page so they aren't surprised to find an additional shipping fee after chosing their desired shipping method but I will take what I can get. I am tired of having the total shipping fees charged on high dollar items way off because the shipping module doesn't calculate the insurance fee correctly. NONE of the shipping modules ever got close to what I was being charged by my shippers. This has solved the problem.

Thanks!

One step that I forgot but that is required, on the Shipping Insurance Zone you created you must click on the "details" button then install all the country and all the zones for it to work.

Also you must select them in the free shipper configuration under Tax Class. Do not select anything in the Shipping Zone for it to work.

Thanks LRS, you saved me a lot of time

Hi

I've just installed this mod, and it's working fine, but I have one problem...

When a customer goes through checkout with the insurance included on their order, and then applies a discount coupon, the percentage is deducted from the insurance as well as from the order sub-total.

Does anyone have a way to prevent this?

Thanks,
Tija

The Optional Shipping Insurance Mod is installed but not doing anything. The settings are currently:

Shipping Insurance

Enable Insurance Module
true

Sort Order
500

Use Table Rates?
false

Alternate Insurance Type
percent

Insurance Percentage
5

Insurance Rate
$0.50

Increment Amount
$500.00

Amount Exempt From Fee
$50.00

Tax Class
--none--

No Insurance Fee on Virtual Products
true

No Insurance Fee on Gift Vouchers
true

No Insurance Fee on Free Shipping
true

Required Insurance Amount
$1,000,000,000.00

Insurance Zone 1
--none--

Zone 1 Insurance Table
50:1.65,100:2.05,200:2.45,300:4.60,400:5.50,500:6.40,600:7.30

Insurance Zone 2
--none--

Zone 2 Insurance Table
50:1.65,100:2.05,200:2.45,300:4.60,400:5.50,500:6.40,600:7.30

I had set the Required Insurance Amount to astronomical to see if that allowed the shopper to select it as an option. I've also tried setting that to zero.

We're using the USPS mod. How do I set this up so that it works?

Thanks,
Christy

christymreed:

The Optional Shipping Insurance Mod is installed but not doing anything. The settings are currently:

Shipping Insurance

Enable Insurance Module
true

Sort Order
500

Use Table Rates?
false

Alternate Insurance Type
percent

Insurance Percentage
5

Insurance Rate
$0.50

Increment Amount
$500.00

Amount Exempt From Fee
$50.00

Tax Class
--none--

No Insurance Fee on Virtual Products
true

No Insurance Fee on Gift Vouchers
true

No Insurance Fee on Free Shipping
true

Required Insurance Amount
$1,000,000,000.00

Insurance Zone 1
--none--

Zone 1 Insurance Table
50:1.65,100:2.05,200:2.45,300:4.60,400:5.50,500:6.40,600:7.30

Insurance Zone 2
--none--

Zone 2 Insurance Table
50:1.65,100:2.05,200:2.45,300:4.60,400:5.50,500:6.40,600:7.30

I had set the Required Insurance Amount to astronomical to see if that allowed the shopper to select it as an option. I've also tried setting that to zero.

We're using the USPS mod. How do I set this up so that it works?

Thanks,
Christy
You must define a zone for this module to work.

Can anyone confirm if this mod works on 1.3.9x?

And what if any gotchas may be?

There seems to be a newer version on the Numinix site, but it still says for 1.3.8.

I don't seem to be able to get onto the Numinix forum to ask there.

Thank you

Hi

I've recently installed and cloned this mod, using one for shipping insurance -- the other I have been trying to configure to use as express shipping.
The only problem I have is that I need the extra charge for express shipping based on weight, rather than order total. (i.e. 500g add $3, 1kg add $5, not $50 add $3, etc.)

Does anyone know how the coding of this mod can be changed to do this?

Any help would be much appreciated :)

Thanks,
Tija

Hi

Nice mod, but I have a wee problem which I need to sort out. Any help appreciated

I have a local sales tax that I need to apply to shipping insurance. Currently this mod shows the tax inclusive amount in the Order Confirmation screen. This is ok when shipping outside of my stores zone, but local regulations state that I must clearly show the amount of local sales tax being charged. In my case I see:

Sub-Total: $100.00
Flat Rate shipping: $7.50
Shipping Insurance: $11.50
Sales Tax @15%: $16.12
TOTAL : $135.12

So the Sales tax is not showing the $1.50 of sales tax included in the shipping insurance.

For "in-zone" orders I really need to see:
Sub-Total: $100.00
Flat Rate shipping: $7.50
Shipping Insurance: $10.00
Sales Tax @15%: $17.62
TOTAL : $135.12

For "out-of-zone" or international orders I dont need to charge sales tax on the goods, but I am still charged sales tax on the shipping and insurance. Really need to see
Sub-Total: $100.00
Flat Rate shipping: $11.50
Shipping Insurance: $11.50
TOTAL : $131.50

Note that in this case the shipping amount goes up.

Er um... help please :)

Why do you need to charge sales tax on shipping insurance? Do you make a profit on it? Normally you don't charge sales tax on shipping or shipping insurance unless you are making a profit on that.

I also have a question. Does anyone have GoogleCheckout installed? If so, how does that work with this mod? Is the shipping insurance cost passed on to GoogleCheckout just fine?

Thanks.

Hi,

Anyone been able to get optional insurance working for any country apart from the one the store is in? When delivering locally insurance is not available with my provider, however when delivering internationally it is.
:blink:
Ta

MortalWombat:

When a customer goes through checkout with the insurance included on their order, and then applies a discount coupon, the percentage is deducted from the insurance as well as from the order sub-total.

Does anyone have a way to prevent this?

Thanks,
Tija

Did you ever find a resolution for this? I'm having the same issue, as well as one other.

When I pay for my test order in full with a gift certificate, the shipping insurance is not deducted from the gift certificate amount, and a balance for the insurance is ending up showing owed in the total.

Example: Subtotal is 14.95. No Sales Tax. Shipping Insurance is 1.40. I have a gift certificate balance of 25.00. In the Gift Certificate area of the check out, I apply 16.35 of my Gift Certificate Account balance to the order. I click "Continue Checkout". The OT balance on the next page should be zero, but it's 1.40 - the amount of the shipping insurance.

I'm having this same issue with Priority Handling Fee - but that's another mod that unfortunately doesn't seem to have a support thread.

For whatever reason, the fees from neither of these mods can be paid for with a Gift Certificate, and coupons deduct from them separately from the OT.

Any suggestions are appreciated.

I'm not looking at this at all because I'm working overtime from another PC, but I wonder if perhaps changing the sort order of the order total modules will resolve this.. In other words I wonder if moving the shipping insurance's sort order above the gift certificate's sort order that it will apply the gift certificate to the shipping insurance.. (I think this is what I understand it is you want to have happen)

ScriptJunkie:

Did you ever find a resolution for this? I'm having the same issue, as well as one other.

When I pay for my test order in full with a gift certificate, the shipping insurance is not deducted from the gift certificate amount, and a balance for the insurance is ending up showing owed in the total.

Example: Subtotal is 14.95. No Sales Tax. Shipping Insurance is 1.40. I have a gift certificate balance of 25.00. In the Gift Certificate area of the check out, I apply 16.35 of my Gift Certificate Account balance to the order. I click "Continue Checkout". The OT balance on the next page should be zero, but it's 1.40 - the amount of the shipping insurance.

I'm having this same issue with Priority Handling Fee - but that's another mod that unfortunately doesn't seem to have a support thread.

For whatever reason, the fees from neither of these mods can be paid for with a Gift Certificate, and coupons deduct from them separately from the OT.

Any suggestions are appreciated.

DivaVocals:

I'm not looking at this at all because I'm working overtime from another PC, but I wonder if perhaps changing the sort order of the order total modules will resolve this.. In other words I wonder if moving the shipping insurance's sort order above the gift certificate's sort order that it will apply the gift certificate to the shipping insurance.. (I think this is what I understand it is you want to have happen)

Thanks for that tip Diva, it did the trick! It also worked for the priority handling fee mod. The only issue I have now is that my tax isn't calculating correctly. Sales tax is calculating based on the sub-total BEFORE coupons are applied.

However, I recognize this is off topic for this thread, so I'm off to do some searching on the forum :smile: I'm thinking that at some point I did something wrong with the sort order for the discount coupon when attempting to resolve that other issue.

Thanks again for your help :smile:

Someone please let me know if with this mod the insurance charge is listed as separate charge or is it added to shipping and handling.

Thanks.

Hi tj,

Shipping, Shipping Insurance, and Priority Order Handling are all listed separately. Now that I have all my OT Mod in the correct sort order, they show in this order:

 $84.92
 Sub-Total:


  -$21.23
 Discount Coupon: Welcome Coupon:


  $25.00
 Priority Handling:


  $5.99
 Illinois Sales Tax = 6.75%:


  $1.56
 United States Postal Service (First-Class Mail (2 - 5 days)):


  $2.15
 Shipping Insurance:


  -$98.39
 Gift Certificates Applied:


  $0.00
 Total:

kiddo:

Can anyone confirm if this mod works on 1.3.9x?

I'm using this mod, version 3.13 with ZC 139h. It is working perfectly now that I have the sort orders for my order total mods set up correctly. If there are any gotcha's, I haven't seen them yet.

kiddo:

There seems to be a newer version on the Numinix site, but it still says for 1.3.8.

There is indeed a newer version on the Numinix site. It is version 3.2.0 and it was built for ZC 138. I haven't upgraded my mod to this newer version, because the older version seems to be working fine for me.

The differences between the two versions are in the ReadMes on the Numinix site. The link for each version's ReadMe can be found in their respective mod download package.

I misspoke in my previous post. The change log outlining the differences between the versions is not in the ReadMe included in the download. It's actually on the download page for v3.2.0. Unfortunately, the changelog stops at v3.1.6, so there's no way to know what the improvements/fixes are for 3.2.0.

But, here's the link to the download and the changelog if you want it.