close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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 | 1557 views | 9 replies |

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!

Sign in to reply to this post

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]

Sign in to reply to this post

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

Sign in to reply to this post

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.

Sign in to reply to this post

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

Sign in to reply to this post

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.

Sign in to reply to this post

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

any advice would be helpful

Sign in to reply to this post

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.

Sign in to reply to this post

BeDigital94844Beta Tester

Flat Rate Shipping Discount

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

I'll try that today-

Sign in to reply to this post

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.

Sign in to reply to this post
loading

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