# Free Shipping is not calculating correctly

Thread began 11/16/2009 5:53 pm by larsentim278054 | Last modified 1/11/2010 5:27 pm by Jason Byrnes | 1524 views | 9 replies |

## 11/16/2009 5:53 pm  |  #1 larsentim278054

### Free Shipping is not calculating correctly

I'm trying to offer Free shipping for certain products only. (There's a bunch)

Anyhow - The way I thought I had to do it was go into Ecart, and go to discounts, and add a discount - and have a trigger of "If presence of item ## == true" and then do OR and then add the next item #, and so on. And then for the Calculation - I initially chose "Based on UPS shipping quote" and I also tried what the PDF states to use "Flat Rate" and input "\$this->GetShipping()" in the value. Both gave the same results: When someone purchases ONE of those items, it works fine, but if someone purchases one of those, and then something else that's NOT on that list - it gives the discount amount of the TOTAL UPS shipping quote - NOT just the item that is supposed to get the discount.

Am I doing something wrong? I'm guessing I can't use "If presence of item ## == true" because that will discount the entire shipping amount no matter what's in the cart, as long as one of those items are in the cart. I need it to ONLY discount that particular item's shipping quote amount. How do I do this??

Thanks!

## 11/17/2009 3:20 pm  |  #2 Jason ByrnesWebAssist

UPS Shipping rate is calculated based on weight.

Set the weight of the items that should not be charged shipping to 0.

In the UPS calculation on the shipping tab, add another trigger:
AND
Subtotal for any column:
If the Subtotal of Column [TotalWeight] is [>] a value of [0]

## 11/17/2009 3:26 pm  |  #3 larsentim278054

I suppose that would work, but then the customers don't know the weight of the product (some are heavier than others, and it's important to know this because some products will be carried all over the place by the customer (car seats, etc)... So that's not a good solution. Plus that won't show what they are getting discounted. (it's nice to show "\$23 Off!) or something like that, depending on the weight.

So I assume it could be done the same way you would add a discount percent to only SOME items, right? Why would it be different? I just can't figure out how to do it. How do you assign certain items with a value? (I know it was said to add a column to the cart, and then in the add to cart button for those that you want the discount for, put this value in it, but the add to cart button is showing on a list of items that are generated based on the database, not by me manually adding the button). So how would I do this?? Or am I way off track here... (very possible! :)

## 11/17/2009 5:21 pm  |  #4 Jason ByrnesWebAssist

Where you are using UPS Rate look up to get the shipping amount it will be very difficult to display the amount saved saved by the "free shipping", it will require a fair bit of hand coding to accomplish.

You would have to have 2 UPS Server behaviors. one to look up the shipping rate for the entire cart. The other to lookup the shipping rate to be discounted. eCart was not designed to have 2 shipping rate lookup behavior for the same shipping vendor, so we cannot support this.

As for you question about adding the column to the cart, since you are using a database, you also have to create a column in your products table. In the database yopu will asign the value 1 or 0 to each product.

In the add to cart button, you will bind the cart column to the column from the recordset.

## 1/09/2010 6:32 pm  |  #5 dan377928

Originally Said By: Jason Byrnes
UPS Shipping rate is calculated based on weight.

Set the weight of the items that should not be charged shipping to 0.

In the UPS calculation on the shipping tab, add another trigger:
AND
Subtotal for any column:
If the Subtotal of Column [TotalWeight] is [>] a value of [0]

When i do this i get an error No Packages to ship

## 1/11/2010 5:27 pm  |  #6 Jason ByrnesWebAssist

either remove the failure redirect URL in the shipping sever behavior, or add an if statement around the shipping server behavior code.

<?php if(\$<cartName>->DisplayInfo("TotalWeight") > 0) { ?>
<?php
<shipping erver behavior code>
?>
<?php } ?>

where <cartName> is the name of your eCart object.

## 12/03/2009 12:34 pm  |  #7 BeDigital94844Beta Tester

### Flat Rate Shipping Discount

Jason-

I have a similar issue- eCart 4.5 CS3 Php

I have 3 Flat rate shipping settings that are selected by a drop down menu
Standard, Next Day, and International - these are stored as a session- and work just fine.

The client wants to add a holiday special "Free Shipping" on all orders over \$75 until 12/25/2009

I looked at adding a discount rule but, that did not see to work- as it did not over ride the standard shipping

After reviewing the Forum- I wonder if I should be modifying the Flat Rate rules

## 12/03/2009 2:29 pm  |  #8 Eric Mittman

I think that the easiest way for you to implement this would be to alter the existing shipping rules that you have in place. For the trigger you should add a new condition, you will use AND at the beginning and for the condition you would use subtotal of the entire cart is < 75. Adding this extra condition to the trigger should ensure that the shipping is not charged if the total is \$75 or greater. You would need to manually change this back after the special is over.

## 12/05/2009 11:20 am  |  #9 BeDigital94844Beta Tester

### Flat Rate Shipping Discount

Thank you Eric- for the help.
I appreciate your time and the explanation-

I'll try that today-

## 12/07/2009 4:41 pm  |  #10 Eric Mittman

Let us know if you need any more assistance with this or if it is working correctly for you. If you are having trouble with it let us know about the bad result you are getting.

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