Re: Quantity discount on some items?

This WebDNA talk-list message is from

2000

It keeps the original formatting. numero = 36243
interpreted = N
texte = John,I set up a similar pricing system and used the Formulas.db to determine thevalue of [price].I have a value in my database that can be used for [price]. Which one isused depends on the quantity ordered. In my case, the price ranges are setfor:Quantity Price1-2 items price1to23-5 items price3to56-11 items price6to1112 items price12Over 12 items priceover12Here's some of my Formulas.db:Name Formulaprice [showif [quantity]<3][lookupdb=my.db&lookInField=sku&value=[sku]&returnField=price1to2][/showif][hideif[quantity]>5][showif [quantity]>2][lookupdb=my.db&lookInField=sku&value=[sku]&returnField=price3to5][/showif][/hideif][hideif [quantity]>11][showif [quantity]>5][lookupdb=my.db&lookInField=sku&value=[sku]&returnField=price6to11][/showif][/hideif][showif [quantity]=12][lookupdb=my.db&lookInField=sku&value=[sku]&returnField=price12][/showif][showif[quantity]>12][lookupdb=my.db&lookInField=sku&value=[sku]&returnField=priceover12][/showif]Note that this is all one long formula. Using a cr to clarify it will foulit up tremendously in real use.Maybe you can adapt it to your situation.Glenn>Here is a tough one,>>Let's say we have 3 products:>>A - $10.00 qty 10-99 & $9.00 qty >99>B - $20.00 qty 10-99 & $18.00 qty >99>H - $1.00>>The price of item H never changes, but the if more than 100 of items A, B,>or A+B is ordered the customer gets a 10% discount on items A and B. (I>really have A,B,C,D, and E that need to be discounted if any combination>adds up to more than 100)>>I picture it like so:>If the user orders more that 100 of A or B individually the price is set to>the discount value. - no problem. If the user orders 50 of A and 50 of B,>the prices of A and B need to be changed to the discount value. But how do I>do this after they have been added to the cart? I can't just to a general>10% discount, because if the user add any H it gets the discount added, and>it shouldn't.>-------------------------------------------------------------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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Quantity discount on some items? (John Peacock 2000)
Re: Quantity discount on some items? (Glenn Busbin 2000)
Quantity discount on some items? (John Davies 2000)

John,I set up a similar pricing system and used the formulas.db to determine thevalue of [price].I have a value in my database that can be used for [price]. Which one isused depends on the quantity ordered. In my case, the price ranges are setfor:Quantity Price1-2 items price1to23-5 items price3to56-11 items price6to1112 items price12Over 12 items priceover12Here's some of my formulas.db:Name Formulaprice [showif [quantity]<3][lookupdb=my.db&lookInField=sku&value=[sku]&returnField=price1to2][/showif][hideif[quantity]>5][showif [quantity]>2][lookupdb=my.db&lookInField=sku&value=[sku]&returnField=price3to5][/showif][/hideif][hideif [quantity]>11][showif [quantity]>5][lookupdb=my.db&lookInField=sku&value=[sku]&returnField=price6to11][/showif][/hideif][showif [quantity]=12][lookupdb=my.db&lookInField=sku&value=[sku]&returnField=price12][/showif][showif[quantity]>12][lookupdb=my.db&lookInField=sku&value=[sku]&returnField=priceover12][/showif]Note that this is all one long formula. Using a cr to clarify it will foulit up tremendously in real use.Maybe you can adapt it to your situation.Glenn>Here is a tough one,>>Let's say we have 3 products:>>A - $10.00 qty 10-99 & $9.00 qty >99>B - $20.00 qty 10-99 & $18.00 qty >99>H - $1.00>>The price of item H never changes, but the if more than 100 of items A, B,>or A+B is ordered the customer gets a 10% discount on items A and B. (I>really have A,B,C,D, and E that need to be discounted if any combination>adds up to more than 100)>>I picture it like so:>If the user orders more that 100 of A or B individually the price is set to>the discount value. - no problem. If the user orders 50 of A and 50 of B,>the prices of A and B need to be changed to the discount value. But how do I>do this after they have been added to the cart? I can't just to a general>10% discount, because if the user add any H it gets the discount added, and>it shouldn't.>-------------------------------------------------------------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://search.smithmicro.com/ Glenn Busbin

DOWNLOAD WEBDNA NOW!

Re: Quantity discount on some items?

2000

Top Articles:

Related Readings: