numero = 20727
interpreted = N
texte = hmmm I still don't think I'm doing this right on search.tpl I haveCourier< We will need to know if you are a Member of ANLA <Along with the code from the rest of the general store template with a few sort modifcations which are working.On Results.tpl I have:Courier< along with the rest of results.tpl In formulas.db I have:Name Formulaprice [lookup db=catalog.txt&lookinField=sku&value=[sku]&returnField=[header1]]But on shoppingcart.tpl the price is still $0 Any Ideas?It went.....>>>>Tim, First off, you'll probably want to store the customer's membership status in a header variable like header1 instead of in each lineitem. the price calculation would be something like: [lookup db=catalog.txt&lookinField=sku&value=[sku]&returnField=[header1]] where you've got memis or nonis stored in [header1]. Then, if you want to change the price after the item has been added to the cart (i.e. they changed membership status), you'll also need to use a [setlineitem...] context like [lineitems][SetLineItem cart=[cart]&index=[lineindex]]password=yourpassword&price=[include incs/pricecalc.inc][/SetLineItem][/lineitems] where pricecalc.inc contains the same thing as the price line of your Forumlas.db. Good luck! Luke MeliaUpline P.S. I'm considering moving to San Diego. Anyone doing website development with WebDNA there? At 2:48 PM 10/28/98, you wrote:>>>>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<<<<<<<< ___________________________________________________________________________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.comUpline 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:
hmmm I still don't think I'm doing this right on search.tpl I haveCourier< We will need to know if you are a Member of ANLA <Along with the code from the rest of the general store template with a few sort modifcations which are working.On Results.tpl I have:Courier< along with the rest of results.tpl In formulas.db I have:Name Formulaprice [lookup db=catalog.txt&lookinField=sku&value=[sku]&returnField=[header1]]But on shoppingcart.tpl the price is still $0 Any Ideas?It went.....>>>>Tim, First off, you'll probably want to store the customer's membership status in a header variable like header1 instead of in each lineitem. the price calculation would be something like: [lookup db=catalog.txt&lookinField=sku&value=[sku]&returnField=[header1]] where you've got memis or nonis stored in [header1]. Then, if you want to change the price after the item has been added to the cart (i.e. they changed membership status), you'll also need to use a [setlineitem...] context like [lineitems][SetLineItem cart=[cart]&index=[lineindex]]password=yourpassword&price=[include incs/pricecalc.inc][/SetLineItem][/lineitems] where pricecalc.inc contains the same thing as the price line of your Forumlas.db. Good luck! Luke MeliaUpline P.S. I'm considering moving to San Diego. Anyone doing website development with WebDNA there? At 2:48 PM 10/28/98, you wrote:>>>>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<<<<<<<< ___________________________________________________________________________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.comUpline 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
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...