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:

    
  1. Re: Multiple prices per product ( Gary Krockover 2004)
  2. Re: Multiple prices per product ( Gary Krockover 2004)
  3. Re: Multiple prices per product ( Gary Krockover 2004)
  4. Re: Multiple prices per product ( Tim Robinson 2004)
  5. Re: Multiple prices per product ( Gary Krockover 2004)
  6. Re: Multiple prices per product ( Tim Robinson 2004)
  7. Re: Multiple prices per product ( Stuart Tremain 2004)
  8. Re: Multiple prices per product ( Gary Krockover 2004)
  9. Re: Multiple prices per product ( Tim Robinson 2004)
  10. Multiple prices per product ( Gary Krockover 2004)
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:

Running a store on BOTH http and https (1998) Emailer setup (1997) Comments in db? (1997) how to get [protect] tag from webcat3b3 to 3.03 on IIS working (1998) ShowNext Command (1997) month or year from date field in lineitems? (1998) Searching - FIELDNAMEtype=date FIELDNAMEtype=time (2004) Emailer (1997) WebCat2 - many [carts] on one template page? (1997) Return records from another (1997) docs for WebCatalog2 (1997) Webcatalog quitting (1997) Re:Why did PCS send me this? (1999) problem serving foreign languages text (1997) WebCatalog can't find database (1997) back button problem (1999) .. more on sliding discounts... (1997) Bug Report, maybe (1997) php vs WebCatalog (2000) Nested tags count question (1997)