Re: Pricing based on quantity

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26276
interpreted = N
texte = on 1/19/00 7:45 PM, Brian Boegershausen at said to me:> You need to set up prices depending on the quantity in the database. > You coiuld have price 1 price 2 etc in your products.db > then in your formaulas.db use showifs to pick the price depending on the > quanitiy.Can someone please help me with the following formula?In my products database, I set up [price_1], [price_2]...[price_8] for each of the products. The pricing of the product is determined by the total number of items in the shopping cart. It does not matter how many of each item, just the total number in the entire cart. (This store is for videos, where each of the products cost the same amount, but the more you buy, the less they cost per piece).In the formulas database, I want to set it up so that once it figures out the number of items, it picks the correct price.For instance, if there are three items in the basket, then the price per item is [price_3]. If there are four items, the price is [price_4].How should this formula be set up?Thanks for any help.-- Jimi Sweet Big City BabyVisit http://www.jimisweet.com/ Visit http://www.bigcitybaby.com/------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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: Pricing based on quantity (Conrad Hubbard 2000)
  2. Re: Pricing based on quantity (Jimi Sweet 2000)
  3. Re: Pricing based on quantity (Bob Minor 2000)
  4. Re: Pricing based on quantity (Jimi Sweet 2000)
  5. Re: Pricing based on quantity (Brian Boegershausen 2000)
  6. Pricing based on quantity (Jimi Sweet 2000)
on 1/19/00 7:45 PM, Brian Boegershausen at said to me:> You need to set up prices depending on the quantity in the database. > You coiuld have price 1 price 2 etc in your products.db > then in your formaulas.db use showifs to pick the price depending on the > quanitiy.Can someone please help me with the following formula?In my products database, I set up [price_1], [price_2]...[price_8] for each of the products. The pricing of the product is determined by the total number of items in the shopping cart. It does not matter how many of each item, just the total number in the entire cart. (This store is for videos, where each of the products cost the same amount, but the more you buy, the less they cost per piece).In the formulas database, I want to set it up so that once it figures out the number of items, it picks the correct price.For instance, if there are three items in the basket, then the price per item is [price_3]. If there are four items, the price is [price_4].How should this formula be set up?Thanks for any help.-- Jimi Sweet Big City BabyVisit http://www.jimisweet.com/ Visit http://www.bigcitybaby.com/------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Jimi Sweet

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:[off] Promotions Co? (1997) Emailer problem with WC 2.1, NT, WebSite 2.1 (1998) Unknown error: OrderNotCreated (1997) newbie question about zip code search (2003) WebCat vs. ASP (1999) WebDNA 4.5 not starting on boot? (2002) "Advanced" Search Algorithm (2008) Sorting by date (1997) WebCatalog [FoundItems] Problem - LONG - (1997) Grouping search fields, etc. (1997) WebCat Admin access w/ClearlyHome p.i. (1997) no [include]s with encryption? (1998) RE: Can a database get stomped by simultaneous access? (1997) IIS4/WebCat3.0 Authentication (1999) carriage returns in data (1997) Open Databases on Restart (1999) WebCatalog for guestbook ? (1997) Email Spam a bit of Hell (2004) AAAH: stupid sendmail (2001) referrer and no caches (1997)