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 happy to 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:

    
  1. Re: Shipping costs question (Donovan 2002)
  2. Re: Shipping costs question - update (Mark Derrick 2002)
  3. Re: Shipping costs question (Mark Derrick 2002)
  4. Re: Shipping costs question (Donovan Brooke 2002)
  5. Re: Shipping costs question (lb Lawrence 2002)
  6. Shipping costs question (Mark Derrick 2002)
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 happy to 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)