Hello all,

I am trying to set up a tiered "insurance" fee to be added to my shipping rates that we are receiving from UPS, to be based on the cart total.

We have a UPS shipping provider configured and working as needed, but I need to add an additional amount to the order using the following pricing tiers.

<$100 --- no charge
$100-300 --- 2.70
>$300 --- 2.70 + .90 for every $100

I don't care how the charge is implemented:

• It could be added to the shipping cost
  
• It could be considered "handling"
  
• If there is some other option avail, I'm open to that too
  

It seems to me that the "Wrapper" or "Order Rules" shipping methods should allow me to manually achieve what I am looking for, but they don't appear to allow for incremental costs IN ADDITION TO the UPS rates, based on the Order Subtotal.

When I select the cost to be "Rates From" UPS... it only allows me to set a multiplier... I really just need to add a fixed rate, to be added to the UPS cost.

I can't find any documentation on how they are supposed to work. Also, I would prefer to NOT have to manually define every $100 increment between $300 and +Infinity to account for all cart sizes.

Any thoughts or help would be greatly appreciated.

Thanks!

Edited by user Friday, March 18, 2016 10:52:18 AM(UTC)  | Reason: Not specified

Thanks again Aaron! Your suggestion was exactly what I needed to implement.

For the good of anyone stumbling across this post in the future with a similar problem, here is what I did to solve the problem.

1. Copy-Paste the file "BVSoftware.Bvc5.Core\BusinessRules\OrderTasks\ApplyHandling.vb" to a new folder located at /App_Code/Workflows
   
2. Rename the pasted file to "ApplyInsuranceAsHandling.vb"
   
3. Update the "TaskId" and "TaskName" methods with a new GUID an new name respectively
   
4. Updated the "Execute" method to include my custom login inside the "If (Not isPlaced)" condition
   
5. Added a line to the file /App_Code/TaskLoader.Custom.vb to register my new OrderTask: result.Add(New BusinessRules.OrderTasks.ApplyInsuranceAsHandling)
   
6. Log into BVAdmin. Go to Options -> Workflows. Edit "Calculate Order" and delete the "Apply Handling" entry. Select my new "Apply Insurance As Handling" OrderTask and add it to the end of the list.
   
7. For clarity, I relabeled "Handling" to "Insurance" on the front-end cart checkout page, so customers would know what they are paying for.