Results 1 to 10 of 416

Hybrid View

  1. #1
    Join Date
    Aug 2008
    Posts
    40
    Plugin Contributions
    0

    Default Re: Optional Shipping Insurance Module Support Thread...

    Easy there.
    I have all my tax rates set up in those tables. I don't want to wipe them out. 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.

  2. #2
    Join Date
    May 2008
    Posts
    452
    Plugin Contributions
    0

    Default Re: Optional Shipping Insurance Module Support Thread...

    Quote Originally Posted by joe.davila View Post
    Easy there.
    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?

  3. #3
    Join Date
    Feb 2006
    Posts
    130
    Plugin Contributions
    0

    Default Re: Optional Shipping Insurance Module Support Thread...

    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!

  4. #4
    Join Date
    Feb 2006
    Posts
    130
    Plugin Contributions
    0

    Default Re: Optional Shipping Insurance Module Support Thread...

    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.

  5. #5
    Join Date
    Feb 2006
    Posts
    130
    Plugin Contributions
    0

    Default Re: Optional Shipping Insurance Module Support Thread...

    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.

  6. #6
    Join Date
    Jul 2010
    Location
    USA
    Posts
    1
    Plugin Contributions
    0

    Default Re: Optional Shipping Insurance Module Support Thread...

    Thanks LRS, you saved me a lot of time

  7. #7
    Join Date
    Dec 2008
    Location
    Cheyenne WY
    Posts
    25
    Plugin Contributions
    0

    Default Re: Optional Shipping Insurance Module Support Thread...

    Quote Originally Posted by LRS View Post
    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!
    Thank You LRS, this worked for me. I spent over an hour tring to figure this our using the mod instructions and It only took 5 min using yours!!!

  8. #8
    Join Date
    Apr 2008
    Posts
    446
    Plugin Contributions
    1

    Default Re: Optional Shipping Insurance Module Support Thread...

    Hello everyone, I'm having an issue with this module in one of my stores I haven't experienced before. We recently made some changes and we're offering free shipping above certain amount for which in the shipping insurance module we changed this setting

    No Insurance Fee on Free Shipping
    Do not calculate insurance for products that have free shipping (includes gv and virtual products)


    from false to true, but I still see the shipping insurance being charged despite this setting. Shipping insurance shouldn't appear at all, or at least give a $0 amount. Free shipping is being calculated by the Free Shipping Options module and we're using the USPS module for shipping charges.

    Any idea why this is not working?

    Thanks!
    M.Valenti
    Contemporary Artist - Entrepreneur
    http://www.manuelavalenti.com - http://www.byvalenti.com

  9. #9
    Join Date
    Aug 2010
    Location
    Hartland, MI
    Posts
    303
    Plugin Contributions
    3

    Default Re: Optional Shipping Insurance Module Support Thread...

    Does anyone know how I could run a check for what shipping option the customer has selected and possibly make this module not show up???
    i.e. If a customer selects UPS shipping the optional insurance mod does not show.
    We've been having a lot of customers add on optional USPS insurance to UPS orders. We've even modified the titles to try and help clarify this but I don't think people bother to read it, they just see insurance and click it!
    Thx

  10. #10

    Default Re: Optional Shipping Insurance Module Support Thread...

    I solved this by putting a statement like the one below in bold red text just above the box they have to check to select the insurance:

    Do not add shipping insurance if your shipping method is this, that or the other, as shipping insurance is already included. (obviously you would replace "this", "that" or "the other" with the shipping methods that apply to your store).

    I don't want to sound like I don't care about my customers, because I do, but quite honestly if a statement in bold red text doesn't stand out well enough for them to see it, then so be it. At some point, customers need to be responsible for themselves and their online purchasing process.

    Quote Originally Posted by mikestaps View Post
    Does anyone know how I could run a check for what shipping option the customer has selected and possibly make this module not show up???
    i.e. If a customer selects UPS shipping the optional insurance mod does not show.
    We've been having a lot of customers add on optional USPS insurance to UPS orders. We've even modified the titles to try and help clarify this but I don't think people bother to read it, they just see insurance and click it!
    Thx
    Go that extra mile, you never know what's at the end of the road

    Empowerment Sanctuary

 

 

Similar Threads

  1. Optional Shipping Insurance Module Question
    By kminnich in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 7 Oct 2008, 01:16 AM
  2. Optional Shipping Insurance Module
    By Darkwander in forum Addon Shipping Modules
    Replies: 2
    Last Post: 9 Oct 2006, 02:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg