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, WebMerchant 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster San Diego, CA 92128 | SiteGuard 619/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, WebMerchant 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster San Diego, CA 92128 | SiteGuard 619/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:
method of payment (1997)
includes and cart numbers (1997)
Great product and great job ! (1997)
America Online Issues (1998)
Out of the woodwork (2007)
Case statement (2003)
BUG: db= param of converchars within founditems loop (2005)
Serving images from databases (1998)
Adding headers to email (1997)
WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997)
WebDNA color code chart - oops (2002)
Frames and WebCat (1997)
Explorer 3.0/ Access Denied! (1997)
html pages not working (2003)
Interactive Docs (2007)
Re:E-mailer application times out (1998)
Word search (1997)
Is this possible, WebCat2.0 and checkboxes (1997)
Date Calulation (1997)
SiteGuard Use Question (1997)