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 workif someone put a single lineitem in with a qty more than 5. If you want toknow the total qty of *all* items in the cart, you'd need to add them allup using [math]. Also, set the unitShipCost formula to 0.0, because you'regoing to be doing the whole calculation in shipCost instead.shipCost [mathshow=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 productdatabase, called Discount, with a price of -5.00, and on your invoicetemplate put a [AddLineItem cart=[cart]&sku=Discount] inside a [ShowIf]based on how many products were ordered. This basically adds a new item tothe 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 | Typhoon619/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 workif someone put a single lineitem in with a qty more than 5. If you want toknow the total qty of *all* items in the cart, you'd need to add them allup using
[math]. Also, set the unitShipCost formula to 0.0, because you'regoing to be doing the whole calculation in shipCost instead.shipCost [mathshow=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 productdatabase, called Discount, with a price of -5.00, and on your invoicetemplate put a [AddLineItem cart=
[cart]&sku=Discount] inside a
[showif]based on how many products were ordered. This basically adds a new item tothe 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 | Typhoon619/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:
test (2002)
Max Record length restated as maybe bug (1997)
Out of the woodwork (2007)
[WebDNA] 6.2 Monitor (2012)
multi-paragraph fields (1997)
[WebDNA] How much does it cost now? (2008)
PCS Frames (1997)
PCS Frames (1997)
vs (1997)
[CART] inside a [LOOP] (1997)
time and welcome (1999)
WC Database Format (1997)
WC2.0 Memory Requirements (1997)
[Webcat 2]Next (1997)
credit card (1997)
A multi-processor savvy WebCatalog? (1997)
Nested vs conditional (1997)
File Upload (1997)
Encrypt a page/template (2002)
Which GUI HTML editors work with WC ? (1997)