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:
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:
Help with Shipping Costs (1997)
$Quit, $CloseDatabase corrections (1997)
[Replace] (2000)
WebCatalog for guestbook ? (1997)
when is date system date or order date? (1997)
Help!!!! Purchases not going through! FIXED! (1997)
TeaRoom Order fields email account remain empty even thoughthewy are filled. (1997)
multiple product databases (1997)
What port is Email on ? (2000)
Search Context: How to set Max=N? (2000)
lookup command (1999)
could someone please try this - it's very quick and easy (2000)
One more time (1997)
background (2001)
Follow-Up to: Removing [showif] makes a big difference in speed (1997)
Shell barcode generation (2006)
Running _every_ page through WebCat ? (1997)
[include file=filename.inc&strip=t] (2002)
math versus text (2005)
Automatic POST arg sending? (1998)