Re: Cart questions
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13899
interpreted = N
texte = >> Does GrandTotal show up?>>Yes, this always displays whatever the shipping fee is.Then it's not really showing the true grand total, is it? Sounds like price is not getting calculated at all (always 0.0), which sounds like your earlier problem. My guess is that once we get price working, then [SubTotal] will start working too.>I have [lookup>db=Products.db&lookInField=SKU&value=[SKU]&returnField=price]. If I put>this directly in the shopping cart template it displays the price>correctly but the price field is always 0.00 in the cart file.Are you sure you're quitting WebCatalog or otherwise flushing databases after you change your formulas.db? If not, you could be making lots of changes without WebCatalog ever seeing a new formula. If you just put the [lookup] from above in for the price formula (like from GeneralStore example) and you're not seeing a price show up in the order, then you've got serious problems, along the lines of a chewed-up database or mis-named SKU field, or $ in your price field or something like that.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMasterSan Diego, CA 92128 | SiteGuard619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>> Does GrandTotal show up?>>Yes, this always displays whatever the shipping fee is.Then it's not really showing the true grand total, is it? Sounds like price is not getting calculated at all (always 0.0), which sounds like your earlier problem. My guess is that once we get price working, then [SubTotal] will start working too.>I have [lookup>db=Products.db&lookInField=SKU&value=[SKU]&returnField=price]. If I put>this directly in the shopping cart template it displays the price>correctly but the price field is always 0.00 in the cart file.Are you sure you're quitting WebCatalog or otherwise flushing databases after you change your
formulas.db? If not, you could be making lots of changes without WebCatalog ever seeing a new formula. If you just put the
[lookup] from above in for the price formula (like from GeneralStore example) and you're not seeing a price show up in the order, then you've got serious problems, along the lines of a chewed-up database or mis-named SKU field, or $ in your price field or something like that.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMasterSan Diego, CA 92128 | SiteGuard619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
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:
resorting found set (2005)
Error Log.db --however (1997)
select multiple 2 more cents (1997)
Line Endings (2007)
RE: Can a database get stomped by simultaneous access? (1997)
ANother SHOWIF problem (1997)
problems with 2 tags (1997)
ODBC problems between webcatalog and filemaker pro (2001)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
New index for docs (1997)
Major Security Hole (1998)
WebCat2b15MacPlugin - [protect] (1997)
Serial Number Question (1997)
FM and Webcat together? (1998)
WebCat2: multiple currency support (1997)
unable to launch acgi in WebCat (1997)
request for comment tag (1998)
Practice runs ? (1997)
Improved ISAPI extension (2004)
Custom formulas.db (1998)