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:

WebCommerce: Folder organization ? (1997) slightly OT: advertising schemes (2004) [ShowIf] and empty fields (1997) Automatic Forwarding using WebCat (1997) [LOOKUP] (1997) Caching [include] files ... (1997) acrobat -> wc (1998) & in Lookups (1997) Record Modified Date - SQL ? (2000) URGENT - CPU usage OSXS (2001) Windows-based Code Editor (2002) [WebDNA] fastcgi 7+ & [cart]? (2010) E-Mail (1998) RE: 2.01 upgrade problems (1997) Proper file locations (1997) [subtotal] problems -- help? (1998) Grep Ampersands (2008) Test (2002) Banner DNA (1997) Redirection based upon form variable (was: MOOOOOO) (2000)