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!

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]

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! :)

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.

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

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.

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

any advice would be helpful

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.

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

I'll try that today-

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.