Re: Shipping costs question
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44787
interpreted = N
texte = Thanks for that, this is what I came up with:(We simply added a suffix to the sku to signify a no shipping charge item)Line breaks added for clarity.ShipCost [math show=f]sc=0[/math][lineItems][showif [sku]^ESD][math show=f]sc=[sc]+[price][/math][/showif][/lineItems][math show=f]sct=[subtotal]-[sc][/math][if [sct]=0][then]0[/then][else][showif [sct]>100.00]5.95[/showif][showif [sct]<100.00]2.95[/showif][showif [sct]=100.00]2.95[/showif][/else][/if]]Seemed like the easiest and quickest way to do it, although I'm always happyto find a shorter way! :-)Mark.on 1/11/02 6:47 pm, Donovan Brooke at donovan@ns1.ddbproductions.org wrote:> Mark, you will want to go through the lineitems to see if that> SKU is the cart. If it is you will want to subtract the price from> the [subtotal] and set that to a var. Then you can do your> code below only using the var instead of [subtotal]> > Donovan> > P.S.> A note, if you are going to have this as a promotion on different> products you could as easily put a field shippingcharge with> a value of yes or no or T or F and then query the products.db> for each item in the cart before shipping is calculated.> > > > Mark Derrick wrote:> >> Here's the scenario,>> We currently use the following in our formulas.db:>> shipCost [showif [subtotal]>100.00]5.95[/showif] [showif>> [subtotal]<100.00]2.95[/showif] [showif [subtotal]=100.00]2.95[/showif]>> >> But we now need to be able to sell a product for which there's a zero>> shipping charge. Which means that if this product is the only item in the>> cart, then the shipcost needs to be 0.>> >> Is there an easy way to achieve this?>> >> Thanks.>> > > > -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> > Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thanks for that, this is what I came up with:(We simply added a suffix to the sku to signify a no shipping charge item)Line breaks added for clarity.ShipCost [math show=f]sc=0[/math][lineitems][showif [sku]^ESD][math show=f]sc=[sc]+[price][/math][/showif][/lineItems][math show=f]sct=[subtotal]-[sc][/math][if [sct]=0][then]0[/then][else][showif [sct]>100.00]5.95[/showif][showif [sct]<100.00]2.95[/showif][showif [sct]=100.00]2.95[/showif][/else][/if]]Seemed like the easiest and quickest way to do it, although I'm always happyto find a shorter way! :-)Mark.on 1/11/02 6:47 pm, Donovan Brooke at donovan@ns1.ddbproductions.org wrote:> Mark, you will want to go through the lineitems to see if that> SKU is the cart. If it is you will want to subtract the price from> the [subtotal] and set that to a var. Then you can do your> code below only using the var instead of [subtotal]> > Donovan> > P.S.> A note, if you are going to have this as a promotion on different> products you could as easily put a field shippingcharge with> a value of yes or no or T or F and then query the products.db> for each item in the cart before shipping is calculated.> > > > Mark Derrick wrote:> >> Here's the scenario,>> We currently use the following in our formulas.db:>> shipCost [showif [subtotal]>100.00]5.95[/showif] [showif>> [subtotal]<100.00]2.95[/showif] [showif [subtotal]=100.00]2.95[/showif]>> >> But we now need to be able to sell a product for which there's a zero>> shipping charge. Which means that if this product is the only item in the>> cart, then the shipcost needs to be 0.>> >> Is there an easy way to achieve this?>> >> Thanks.>> > > > -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to> > Web Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Mark Derrick
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:
What really killed WebDNA? (2007)
linetiems in thankyou.tpl (1997)
Date problem still... (2004)
[getchars] questions (1997)
Erotic Sites (1997)
Classified Ads 4 Sale (1998)
Merging databases (1997)
Re:Help name our technology! (1997)
Comments in db? (1997)
[no_cache]?! (2000)
RE: 2.1 pricing? (1998)
[Semi-OT] Eaaaaaasy OSX FTP (2003)
RE: [input] questions (1997)
Still Stumped on ShowNext...HELP! (1997)
[searchString] (1997)
[WebDNA] WebDNA 8.2 Ubuntu 14.04 - Mail Pref Error (2017)
refresh (2000)
default value from Lookup (was Grant, please help me) (1997)
setting a cookie for the whole server (2004)
Categorizing by data (2001)