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:

WebCat2: Items xx to xx shown, etc. (1997) OT: Weird table rendering w/ WebCat in Explorer (2005) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) Not really WebCat (1997) Menu to select product variations (1997) database performance/design question (2000) [WebDNA] Lookup inside grep?... (2011) WebCat2b15MacPlugin - [protect] (1997) WC2b15 File Corruption (1997) Dummy Credit Card Number for debug? (1997) Running 2 two WebCatalog.acgi's (1996) Server IP address? (1998) Using [Include] Context (1999) Help name our technology! I found it (1997) Updating a database once per day - An example (1998) [ShowNext] (2007) emailer prob (1998) FAX orders (1996) PCS Frames (1997) videos.. yak..yak (1998)