Re: Multiple prices per product
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58092
interpreted = N
texte = What does your formula entry look like? I assume you'll have to set one of the lineitem text variables with the name of the size chosen eg textA=size2, and then use that value to do a lookup for the price in the formulas.db. Something like this maybe: Name Formula price [lookup db=products.db&lookInField=sku&value=[sku]&returnField= price[GetChars start=1&end=1&from=end][textA][/GetChars]] Regards, Tim > From: Gary Krockover
> Reply-To: (WebDNA Talk) > Date: Fri, 28 May 2004 00:20:21 -0500 > To: (WebDNA Talk) > Subject: Multiple prices per product > > Digging through the archives has not yielded a result, though it's been > asked a few times; wondering if anybody has successfully figured out the > multiple prices per item conundrum? > > example of catalog.db: > > skucategorybrandtitlesize1price1size2price2 > size3price3 > 1HorsesSPRINGTIMEBreather6 tubes51.0012 > tubes90.0024 tubes162.00 > > The products page displays each size/price combo for the sku, the visitor > can choose one of the options - adding that item (size/price) to the cart. > > Each combo of formulas.db and formvariables to pull out and set the price > depending on the size yields a 0.00 amount showing in the cart for [price]. > > TIA, > GK > > > ------------------------------------------------------------- > 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 > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
What does your formula entry look like? I assume you'll have to set one of the lineitem text variables with the name of the size chosen eg textA=size2, and then use that value to do a lookup for the price in the formulas.db. Something like this maybe: Name Formula price [lookup db=products.db&lookInField=sku&value=[sku]&returnField= price[GetChars start=1&end=1&from=end][textA][/GetChars]] Regards, Tim > From: Gary Krockover > Reply-To: (WebDNA Talk) > Date: Fri, 28 May 2004 00:20:21 -0500 > To: (WebDNA Talk) > Subject: Multiple prices per product > > Digging through the archives has not yielded a result, though it's been > asked a few times; wondering if anybody has successfully figured out the > multiple prices per item conundrum? > > example of catalog.db: > > skucategorybrandtitlesize1price1size2price2 > size3price3 > 1HorsesSPRINGTIMEBreather6 tubes51.0012 > tubes90.0024 tubes162.00 > > The products page displays each size/price combo for the sku, the visitor > can choose one of the options - adding that item (size/price) to the cart. > > Each combo of formulas.db and formvariables to pull out and set the price > depending on the size yields a 0.00 amount showing in the cart for [price]. > > TIA, > GK > > > ------------------------------------------------------------- > 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 > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Tim Robinson
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:
Date Formats (1997)
WebCatalog for guestbook ? (1997)
ShippingCosts (1998)
[OT] HTML EMAIL program wanted (1999)
[sendmail] questions... (1997)
WebCommerce: Folder organization ? (1997)
emailer (1997)
setcookie getcookie on the same page (2003)
Deleting Orders (1997)
required fields (1998)
Purchase *file=* bug? (2003)
Advice needed. (1998)
Mixing and/or in searches (1998)
GoLive CyberStudio 1.0.1 (1997)
PIXO support (1997)
Help! WebCat2 bug (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
[setcookie] & [redirect] (1998)
Search/sort in URL Was: GuestBook example (1997)
OK, here goes... (1997)