Re: Discounts
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 46462
interpreted = N
texte = Yes, I would think so,...You can initially set it there.You can either keep the percent discount or the actual price after thepercent discount in the products.db. Then you will refrence this fieldevery time a product is entered. something like:[if [lookupdb=products.db&value=[SKU]&lookinfield=SKU&returnfield=MULTIPLIER]!][then][!][/!][math][lookupdb=products.db&value=[SKU]&lookinfield=SKU&returnfield=PRICE]*[lookupdb=products.db&value=[SKU]&lookinfield=SKU&returnfield=MULTIPLIER][/math][/then][else][!][/!][else][lookupdb=products.db&value=[SKU]&lookinfield=SKU&returnfield=PRICE][/else][/if]---code above might have false line breaks from email.---It gets tricky when you start to give tabled discounts based on quantity ordered ofitems withina particular category. ;-)DonovanClint Davis wrote:> Donovan,>> I should have specified that these are per-item sale prices calculated as a> percentage of the original price. It sounds like the formulas.db route is in> my best interest, true?>>-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------------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:
Yes, I would think so,...You can initially set it there.You can either keep the percent discount or the actual price after thepercent discount in the products.db. Then you will refrence this fieldevery time a product is entered. something like:[if [lookupdb=products.db&value=[SKU]&lookinfield=SKU&returnfield=MULTIPLIER]!][then][!][/!][math][lookupdb=products.db&value=[SKU]&lookinfield=SKU&returnfield=PRICE]*[lookupdb=products.db&value=[SKU]&lookinfield=SKU&returnfield=MULTIPLIER][/math][/then][else][!][/!][else][lookupdb=products.db&value=[SKU]&lookinfield=SKU&returnfield=PRICE][/else][/if]---code above might have false line breaks from email.---It gets tricky when you start to give tabled discounts based on quantity ordered ofitems withina particular category. ;-)DonovanClint Davis wrote:> Donovan,>> I should have specified that these are per-item sale prices calculated as a> percentage of the original price. It sounds like the formulas.db route is in> my best interest, true?>>-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------------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/
Donovan
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:
WebCat2 - storing unformatted date data? (1997)
downloadable txt file (2001)
RequiredFields parameter (1998)
ShipCosts database (1997)
Upgrading old WebCat Database Files (1997)
[WebDNA] New request for websites that currently run WebDNA (2009)
Can this be done? (1997)
[WebDNA] User sessions - cookies only or cookies and a (2016)
re:WebCatalog and Filemaker (1996)
suggestions for a Windows based text editor? (2004)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Forms Search Questions (1997)
hiding hyperlink info in URL field (1999)
Quit revisited (1997)
WebCat virtual postcard is done! Thanks for the help! (1998)
wild question (1998)
Plugin or CGI or both (1997)
FYI: virus alert (1996)
About [Loop] (2000)
emailer (1997)