close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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 | 46 views | 3 replies |

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

Sign in to reply to this post

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"

Sign in to reply to this post

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

Sign in to reply to this post

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

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

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 Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

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 --

Uploading file...