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:
Navigator 4.01 (1997)
Beta 18 (1997)
[lineitems] and [writefile] (1998)
Webcat/Webmerchant part II (1998)
Plugin or CGI or both (1997)
performans tests... (2001)
[WebDNA] passing a variable in an include - precedence (2015)
Close Databases Crash? (1998)
Categories (2000)
Plugin vs. CGI (1998)
with Link i need to (1997)
More on the email templates (1997)
Dark Horse Comics success story (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Execute Applescript (1997)
Show shoppingcart after remove last item (1997)
Search for specific characters in a string (2005)
PCS Frames-Default page is solution! (1997)
Using Cookie for client specific info? (1997)
WebCommerce: Folder organization ? (1997)