Re: Need help with Shipping/Price discounts
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21942
interpreted = N
texte = >1. I want the totalshipcost to equal 0.00 when more than 5 products are >ordered. I've tried this in the formulas.db to no avail. > >shipcost [math][showif [quantity]>5]0*[/showif]2.00[/math]shipCost is evaluated once for each individual lineitem, so that would work if someone put a single lineitem in with a qty more than 5. If you want to know the total qty of *all* items in the cart, you'd need to add them all up using [math]. Also, set the unitShipCost formula to 0.0, because you're going to be doing the whole calculation in shipCost instead.shipCost [math show=f]totalQty=[lineitems][quantity]+[/lineitems]0[/math][math][ShowIf [totalQty]>5]0*[/ShowIf]2.00[/math]>2. I want a discount of $5.00 to be taken from the total order when 2 or >more products are ordered, total. Where is the best place for me to code >this? In the formula.db under Price?This is a little harder. I suggest you create a new SKU in your product database, called Discount, with a price of -5.00, and on your invoice template put a [AddLineItem cart=[cart]&sku=Discount] inside a [ShowIf] based on how many products were ordered. This basically adds a new item to the end of your list of products, so make sure it can only happen once (usually doing it on the final invoice page is good enough).Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>1. I want the totalshipcost to equal 0.00 when more than 5 products are >ordered. I've tried this in the
formulas.db to no avail. > >shipcost
[math][showif [quantity]>5]0*[/showif]2.00[/math]shipCost is evaluated once for each individual lineitem, so that would work if someone put a single lineitem in with a qty more than 5. If you want to know the total qty of *all* items in the cart, you'd need to add them all up using
[math]. Also, set the unitShipCost formula to 0.0, because you're going to be doing the whole calculation in shipCost instead.shipCost [math show=f]totalQty=
[lineitems][quantity]+[/lineitems]0[/math]
[math][ShowIf [totalQty]>5]0*[/ShowIf]2.00[/math]>2. I want a discount of $5.00 to be taken from the total order when 2 or >more products are ordered, total. Where is the best place for me to code >this? In the formula.db under Price?This is a little harder. I suggest you create a new SKU in your product database, called Discount, with a price of -5.00, and on your invoice template put a [AddLineItem cart=
[cart]&sku=Discount] inside a
[showif] based on how many products were ordered. This basically adds a new item to the end of your list of products, so make sure it can only happen once (usually doing it on the final invoice page is good enough).Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Card clearance, problems - solutions? (1997)
pdf files? (2001)
WebTen and WebCat (1997)
getting images' width/height (1998)
RE: Sorting error (1997)
Multiple Users.db Possible? (1997)
wee problem (2001)
Shownext problems (1999)
Bug or syntax error on my part? (1997)
Calculating multiple shipping... (1997)
Running _every_ page through WebCat ? (1997)
Practice runs ? (1997)
Entry point? Security w/ dbase helper? (1997)
Help name our technology! I found it (1997)
Creating main- and sub-category search (1997)
WCS Newbie question (1997)
Re:2nd WebCatalog2 Feature Request (1996)
2nd WebCatalog2 Feature Request (1996)
Problems problems problems (1997)
Falsifying [BROWSERNAME] (1998)