What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: shipping madness

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30402
interpreted = N
texte = Kenneth Grome wrote:> >Three categories of items: patterns, kits and finished > >quilts... They want shipping to be: > > > >(quote from them) > >1-12 patterns = $3 > >Anything else up to $150 = $6 > >Over $150 = free shipping > > > >Now I can deal with the last two no problem, but how the > >heck can I track up to 12 patterns _with_ other things > >ordered etc. and mix the shipping amounts? > > Just write a math formula that looks at the items in the order file > and determines the final shipping price based on those items. You do > not have to 'track' anything, all the data you need should be in the > order file when the person checks out. > > If the data you need for each item is not being added to the cart > file, you can change your shopping cart code so it adds the proper > data each time a new item is added, or when an existing item is > changed, then all the data you need *will* be in the cart file when > the person checks out, which means that data will be available to > your math formula that calculates shipping charges at the end of the > shopping trip ... >Okay fair enough... I was thinking along those lines anyway. My SKUs have category markers on them like 100P (P for pattern), 101Q (Q for quilt). So I guess I could try and write some code that checks on the invoice page for the number of SKUs listed with [lineitems] that end in P and if that's 12 or less tack on $3 dollars for shipping and treat the rest accordingly? Any hints? Use [math] and some [showifs] etc? Try and remember that we're not all experts at this yet. ;-)> >What if the > >customer orders 8 patterns (which would be $96) and 3 kits > >and a finished quilt totalling say $160 dollars... do I make > >that $3, $6, $3+$6, or free?!? Is this just silly? > > It's silly that you're asking *us* and not your client. If you don't > understand what your client wants, go get the project requirements > cleared up first! You cannot build a formula when you don't know > what the end results are supposed to be ... > --You've never had a client that doesn't know what _they_ want?? I didn't call them finicky for nothing you know. :-)Thanks for the help so far though.-- Parker Zero Echo Inc. http://zeroecho.net ------------------------------------------------------------- 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: shipping madness (Parker 2000)
  2. Re: shipping madness (Kenneth Grome 2000)
  3. shipping madness (Parker 2000)
Kenneth Grome wrote:> >Three categories of items: patterns, kits and finished > >quilts... They want shipping to be: > > > >(quote from them) > >1-12 patterns = $3 > >Anything else up to $150 = $6 > >Over $150 = free shipping > > > >Now I can deal with the last two no problem, but how the > >heck can I track up to 12 patterns _with_ other things > >ordered etc. and mix the shipping amounts? > > Just write a math formula that looks at the items in the order file > and determines the final shipping price based on those items. You do > not have to 'track' anything, all the data you need should be in the > order file when the person checks out. > > If the data you need for each item is not being added to the cart > file, you can change your shopping cart code so it adds the proper > data each time a new item is added, or when an existing item is > changed, then all the data you need *will* be in the cart file when > the person checks out, which means that data will be available to > your math formula that calculates shipping charges at the end of the > shopping trip ... >Okay fair enough... I was thinking along those lines anyway. My SKUs have category markers on them like 100P (P for pattern), 101Q (Q for quilt). So I guess I could try and write some code that checks on the invoice page for the number of SKUs listed with [lineitems] that end in P and if that's 12 or less tack on $3 dollars for shipping and treat the rest accordingly? Any hints? Use [math] and some [showifs] etc? Try and remember that we're not all experts at this yet. ;-)> >What if the > >customer orders 8 patterns (which would be $96) and 3 kits > >and a finished quilt totalling say $160 dollars... do I make > >that $3, $6, $3+$6, or free?!? Is this just silly? > > It's silly that you're asking *us* and not your client. If you don't > understand what your client wants, go get the project requirements > cleared up first! You cannot build a formula when you don't know > what the end results are supposed to be ... > --You've never had a client that doesn't know what _they_ want?? I didn't call them finicky for nothing you know. :-)Thanks for the help so far though.-- Parker Zero Echo Inc. http://zeroecho.net ------------------------------------------------------------- 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 Parker

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:

Problems appending to database (1997) WebCatalog for Postcards ? (1997) Writefile, Raw & include (2002) [sendmail] bug? (2000) fixed date problem (1997) RE: How much ram??? (1997) Newbie Tax Question (1997) [Announce] WebCatalog 3.0 Beta Program (1998) Fwd: Job Opening (2003) en/decrypt problem (1999) Email within tmpl ? (1997) Mac: LModelDirector bug fix (1997) [OT] Australian Dial-Up Access (2006) read and write you own cookies with webcat (1997) Re2: frames & carts (1997) Local redirects ... (2005) Help! WebCat2 bug (1997) Document Contains No Data! (1997) Backwards list behavior ... (1997) Comments in db? (1997)