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:
2nd try: possible to weight results of grouped fields search? (1998)
Group search doesn't work. (1997)
OT: Woa MacWorld (2003)
Databases (2000)
2.1 Stuff (1998)
Sorting by date (1997)
Mac Vs WindowsNT (1997)
Shopping Carts (2000)
webcat NT (1998)
PIXO Support (1997)
OFF-TOPIC: Check www.godaddy.com for me ... (2003)
Loss in Form (1998)
Cart problem (1999)
Sort Order on a page search (1997)
Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
Smith Micro Support powerd by PHP (2006)
Cold Fusion Buster (1997)
Word search (1997)
[WebDNA] Downloading a .xls file daily (2009)
WebCatalog can't find database (1997)