Re: multiple prices

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 20719
interpreted = N
texte = Okay what I've done is have two fields in the database, one called [memis] for member price and one called [nonis] for non-member price. both are veiw on the resutls and detail pages. On shoppingcart.tpl I have the form CourierMembershipStatus:<<in formulas.db I've tried-- price [textb] and -- price [lookup db=catalog.txt&lookinField=[textb]&returnField=price]Neither of these seems to work, any ideas? Thanks Tim I originally went.....>Add a field to the product database called MemberPrice and use a entry in>formulas.db to return the proper price based on the customers membership>status.>>Luke>>At 5:43 PM 10/27/98, you wrote:>>Hi all>>>>I'm using the general store template to build a rather simple publications>>catalog. The problem I'm having is that there is one price for members and>>a seperated price for non-members assigned to each sku. Now I know I can>>either duplicate the whole database and have two different entry points and>>have the price field different in the memberstore and nonmemberstore>>catalogs. I guess I could also duplicate each line item and change sku's>>and put in some sort of sorting field on each page to get the>>member/nonmember listing. Either way the vendor will confirm member>>status when they recieve the order. I guess what I'm trying to ask is there>>some extreemly simple way to set this up?>>>>Thanks>>>>Tim Taylor>>Webmaster>>http://www.growzone.com>>Tim@versa.com>>t h e s i t e f o r t h e>>g r e e n i n d u s t r y>>1.888.800.5904>>>___________________________________________________________________________>Upline Subscribers succeed faster. Find out why:>Send e-mail to why@upline.com for an instant FREE report!>___________________________________________________________________________>For software for Network Marketers, check out http://www.kaizensoft.com>Upline is Online: http://www.upline.com>___________________________________________________________________________> ============================ Luke Melia>|| In between stimulus ||>|| and response, || Snail Mail:>|| there is a small || 106 South St. Suite 209>|| space... || Charlottesville, VA 22902> ======= Victor Frankl ======= (804) 979-4427 x136 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)
  11. Size Options and Multiple prices (Paul 2003)
  12. Formulas and Multiple Prices (Glenn Busbin 2000)
  13. Multiple prices, one sku (Corky Kane 1999)
  14. Re: multiple prices (Luke Melia 1998)
  15. Re: multiple prices (Tim Taylor 1998)
  16. Re: multiple prices (Luke Melia 1998)
  17. Re: multiple prices (Tim Taylor 1998)
  18. Re: multiple prices (Luke Melia 1998)
  19. multiple prices (Tim Taylor 1998)
  20. Re: how to do multiple prices/item? (Sandra L. Pitner 1998)
  21. Re: how to do multiple prices/item? (Dale Stokdyk 1998)
  22. Re: how to do multiple prices/item? (Sandra L. Pitner 1998)
  23. how to do multiple prices/item? (Dale Stokdyk 1998)
  24. Re: Multiple prices (Grant Hulbert 1997)
  25. Re: Multiple prices (Robert Minor 1997)
  26. Re: Multiple prices (Grant Hulbert 1997)
  27. Re: Multiple prices (Robert Minor 1997)
  28. Re: Multiple prices (Grant Hulbert 1997)
  29. Multiple prices (Robert Minor 1997)
Okay what I've done is have two fields in the database, one called [memis] for member price and one called [nonis] for non-member price. both are veiw on the resutls and detail pages. On shoppingcart.tpl I have the form CourierMembershipStatus:<<in formulas.db I've tried-- price [textb] and -- price [lookup db=catalog.txt&lookinField=[textb]&returnField=price]Neither of these seems to work, any ideas? Thanks Tim I originally went.....>Add a field to the product database called MemberPrice and use a entry in>formulas.db to return the proper price based on the customers membership>status.>>Luke>>At 5:43 PM 10/27/98, you wrote:>>Hi all>>>>I'm using the general store template to build a rather simple publications>>catalog. The problem I'm having is that there is one price for members and>>a seperated price for non-members assigned to each sku. Now I know I can>>either duplicate the whole database and have two different entry points and>>have the price field different in the memberstore and nonmemberstore>>catalogs. I guess I could also duplicate each line item and change sku's>>and put in some sort of sorting field on each page to get the>>member/nonmember listing. Either way the vendor will confirm member>>status when they recieve the order. I guess what I'm trying to ask is there>>some extreemly simple way to set this up?>>>>Thanks>>>>Tim Taylor>>Webmaster>>http://www.growzone.com>>Tim@versa.com>>t h e s i t e f o r t h e>>g r e e n i n d u s t r y>>1.888.800.5904>>>___________________________________________________________________________>Upline Subscribers succeed faster. Find out why:>Send e-mail to why@upline.com for an instant FREE report!>___________________________________________________________________________>For software for Network Marketers, check out http://www.kaizensoft.com>Upline is Online: http://www.upline.com>___________________________________________________________________________> ============================ Luke Melia>|| In between stimulus ||>|| and response, || Snail Mail:>|| there is a small || 106 South St. Suite 209>|| space... || Charlottesville, VA 22902> ======= Victor Frankl ======= (804) 979-4427 x136 Tim Taylor

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:

webcat database helper question (2000) Document Contains No Data! (1997) WebCat for mass emailings (1997) Re:2nd WebCatalog2 Feature Request (1996) -- TEST -- (2003) Just Testing (1997) Email notification to one of multiple vendors ? (1997) WebCat consulting $ (1998) Using Plug-In while running 1.6.1 (1997) where to put code (1998) [WebDNA] Encode cookies ONLY via "method=Base64" (2008) web delivery (1997) Tmp Database Files?!? (2003) can WC render sites out? (1997) Setting up the server (1997) Off Topic: Help Wanted (1997) cookies (2004) syntax question, not in online refernce (1997) Large databases in WebCat (1997) WCS Newbie question (1997)