# How to double a shipping surcharge based on item quantity

Thread began 3/10/2017 2:07 pm by Robert Crespo | Last modified 3/13/2017 12:22 pm by Ray Borduin | 105 views | 3 replies |

## 3/10/2017 2:07 pm  |  #1 Robert Crespo

### How to double a shipping surcharge based on item quantity

To the WebAssist Gurus,

I have a question regarding how I can increase a shipping surcharge based on the number of items in the shopping cart. Currently, I have UPS doing the real-time shipping quote for every item in the shopping cart. However, UPS has increased their shipping charges for packages over 48" in width. Any package over 48" inches in width receives a \$10.50 surcharge. If someone purchases two of the same item that is over 48 inches long, how can I program the eCart Object to charge this \$10.50 surcharge twice? (Or 3, 4, 5 or more times?)

Please see the attached image of how I am currently trying to accomplish this.

However, I am already facing an issue with the way I am approaching this problem. Since I have dozens of items that are over 48 inches in width, if I keep adding conditional statements based on the item number, only one shipping surcharge is applied. For example, if item #20 is added to the shopping cart, then that get's a \$31.50 surcharge. Also, if item #21 is added to the shopping cart is, then it should add an additional \$31.50 shipping surcharge. The way I have things now, I am only seeing one shipping surcharge in the cart. Just so you know, items #20 and #21 consist of 3 oversized boxes which is why the shipping surcharge is \$31.50 and not \$10.50.

Any help you can give in trying to get these shipping charges working will be greatly appreciated.

Regards,
Robert

## 3/10/2017 2:38 pm  |  #2 Ray BorduinWebAssist

I'd add an Oversized column to the cart and set it to 1 or 0 in the add to cart process. Then add a calculation to the cart:

TotalOversized = [Quantity] * [Oversized]

Then create a shipping charge "Based on Subtotal of Column TotalOversized * 10:50"

## 3/10/2017 3:07 pm  |  #3 Robert Crespo

Ray,

I never thought of doing it that way. Thank you for shedding light on this approach. I think that this solution is superior because I can set a numeric value for each oversized item. Some items will have an oversized value of 1 for one box, some will have an oversized value of 3 for 3 oversized boxes. I think I will add a database field called "Oversized" and add the numeric values there which will then get based along when the customer adds the item into the shopping cart. I will let you know if this approach is successful.

Thank you,
Robert

## 3/10/2017 3:39 pm  |  #4 Robert Crespo

Ray, I wanted to let you know that your suggestion worked like a charm. My shopping cart is collecting the correct amount for the shipping surcharge. Thank you for you help once again.

Regards,
Robert

## Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

## Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

## Everything else!

Close Window

Account or customer service questions?

Need technical support?

Content

Layout

Ease of use

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Window

## We were unable to retrieve the attached file

Close Window

### Attach and remove files

• Text Formatting
• Insert Element
• Block Formatting
• Cancel
Close Window

Close Window

#### This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --