numero = 15039
interpreted = N
texte = Actually Ray, I never tried your idea because I realized that I don't think I could do it. What would I do with the decimal point? That would be a nasty database. So, Here is where we are with the shipping issue. I think we have found a bug? Grant thought that maybe the problem is that the shipping formula was using the subtotal before the new subtotal was calculated. But that is not the problem because I now have the ShoppingCart.tmpl calculating a subtotal and the shipping is still incorrect. We have figured out that the shipping will calcute correctly if we reload the invoice page. For example, if I purchase ten $20 robes, the shipping returns the cost of one robe, but then if I go back to the ShoppingCart page, don't change anything, and then go to Invoice.tmpl again the shipping is correct for the ten $20 robes.Any ideas on how fix this problem? And for a temp. fix in time for holiday shopping: Is there a way to make the page automatically load twice or anything?Thank you very much,Janna >Ken,>>I don't understand. Isn't [subtotal] a webcatalog thing? There is no >formula anywhere that I have found. >>Also, I figured out the shipping comes out correctly when there are >different items adding up to the amt, but if I use the quantity field >(ex: ten $15 candles versus one $150 robe) the subtotal says the right >number but the shipping is wrong. The shipping is calculated based on >only on item. >>So, I think the solution is to write subtotal to a different field name, >the do the lookup using that new field. I did this for the title using > >then referring to textA on the emails. So I wrote > >in the invoice and the formula says >shipCost [showif [textB]<20.00]1[/showif][showif [textB]>19.99][showif >[textB]<40.00]3[/showif][/showif][showif [textB]>39.99][showif >[textB]<60.00]5[/showif][/showif][showif [textB]>59.99][showif >[textB]<100.00]7[/showif][/showif][showif [textB]>99.99][showif >[textB]<10000.00]10[/showif][/showif]>>But it still doesn't work. Is there another way to write this? Maybe >using the [header2] field? (I already use [header1] for the shiptostate.>>Any info you have would be greatly appreciated! >>Thank you,>Janna>>>>Maybe your [subtotal] formula needs an adjustment?>>>>Sincerely, Ken Grome>>WebDNA Solutions>>http://www.smithmicro.com/webdnasolutions/>>>>.>>>>>>>>>******************************>Janna S. Kohen>Big Mind Media L. L. C.>http://www.bigmindmedia.com/>janna@bigmindmedia.com >>
Associated Messages, from the most recent to the oldest:
Actually Ray, I never tried your idea because I realized that I don't think I could do it. What would I do with the decimal point? That would be a nasty database. So, Here is where we are with the shipping issue. I think we have found a bug? Grant thought that maybe the problem is that the shipping formula was using the subtotal before the new subtotal was calculated. But that is not the problem because I now have the ShoppingCart.tmpl calculating a subtotal and the shipping is still incorrect. We have figured out that the shipping will calcute correctly if we reload the invoice page. For example, if I purchase ten $20 robes, the shipping returns the cost of one robe, but then if I go back to the ShoppingCart page, don't change anything, and then go to Invoice.tmpl again the shipping is correct for the ten $20 robes.Any ideas on how fix this problem? And for a temp. fix in time for holiday shopping: Is there a way to make the page automatically load twice or anything?Thank you very much,Janna >Ken,>>I don't understand. Isn't [subtotal] a webcatalog thing? There is no >formula anywhere that I have found. >>Also, I figured out the shipping comes out correctly when there are >different items adding up to the amt, but if I use the quantity field >(ex: ten $15 candles versus one $150 robe) the subtotal says the right >number but the shipping is wrong. The shipping is calculated based on >only on item. >>So, I think the solution is to write subtotal to a different field name, >the do the lookup using that new field. I did this for the title using > >then referring to textA on the emails. So I wrote > >in the invoice and the formula says >shipCost [showif [textB]<20.00]1[/showif][showif [textB]>19.99][showif >[textB]<40.00]3[/showif][/showif][showif [textB]>39.99][showif >[textB]<60.00]5[/showif][/showif][showif [textB]>59.99][showif >[textB]<100.00]7[/showif][/showif][showif [textB]>99.99][showif >[textB]<10000.00]10[/showif][/showif]>>But it still doesn't work. Is there another way to write this? Maybe >using the [header2] field? (I already use [header1] for the shiptostate.>>Any info you have would be greatly appreciated! >>Thank you,>Janna>>>>Maybe your [subtotal] formula needs an adjustment?>>>>Sincerely, Ken Grome>>WebDNA Solutions>>http://www.smithmicro.com/webdnasolutions/>>>>.>>>>>>>>>******************************>Janna S. Kohen>Big Mind Media L. L. C.>http://www.bigmindmedia.com/>janna@bigmindmedia.com >>
Janna S. Kohen
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...