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:
No Subject (1998)
Help! WebCat2 bug (1997)
NT version (1997)
AppleScript/.db (was:FTP to WebStar) (2001)
WebCommerce: Folder organization ? (1997)
ftp to webstar (2001)
Page Breaks in Word (2003)
WebCat2b15MacPlugin - [protect] (1997)
Separate SSL Server (1997)
many-to-one problem (1998)
WebSTAR plugin update (2004)
Re:2nd WebCatalog2 Feature Request (1996)
Date search - yes or no (1997)
Comments in db? (1997)
For those of you not on the WebCatalog Beta... (1997)
Simple Database close connection (2001)
New WebCatalog Version !!! (1997)
LetterRip and WebCat & more (1998)
rename a file (1997)
Forcing Paragraph Breaks on Results (1998)