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:

WebCat2b13MacPlugIn - More limits on [include] (1997) Using ticks (2000) WCS Newbie question (1997) slide show (2002) countdown to date (2003) Security Levels... Possible? (2000) Grep Question - MAY NEVER BE SOLVED (2003) Protect and Serve (1999) PCS Frames (1997) carriage returns in data (1997) Another new bug found ... (2000) WebCatalog2 Feature Feedback (1996) Garbage display after 100 records (was WebCatalog usage) (1997) Loosing Quantity (2000) formvars available in formulas.db? (2000) [showif] and equality (1998) [ot] Any One Want A WebDNA Billing Program? (2003) Hard Questions ? (1997) [ListFiles] Context Question (2004) [lineitems] and [writefile] (1998)