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:

RE: Multiple Stores and WebCatalog Prefs (1997) Simple Database close connection (2001) Moment of Thanks (1997) notification solutions (1997) founditem align (1998) RequiredFields (2000) Re:Running 2 two WebCatalog.acgi's (1996) Virtual Domains (1998) Bulk Processing Offline (2004) HideIf ip= OR ip (1998) & in Lookups (1997) Interfacing a webcat front end registartion to CommunigatePRO (2000) Duplicates (1998) [subtotal] problems -- help? (1998) Summing fields (1997) Bug when including a db file ... ? (2000) WCS Newbie question (1997) minimalist shopping cart. (1997) Search inside Include (1998) YACBQ.....(Yet another checkbox question) (2000)