numero = 15035
interpreted = N
texte = I like to start a discussion about shipping. First question; how are other people doing shipping? Is everyone using the gen store method? And if you are, are you just shipping within CA or did you find zip codes for the whole country or world? To start the discussion: we have another catalog that sells only videos. The site is at http://www.acrossborders.com Since all the videos are the same size and weight, we calculate shipping based on quantity. Of course, it wasn't as easy as an simple 1-1, and I got beautiful help from Grant in creating the somewhat complex formulas that went into doing it. Now we have a catalog in which we need to calculate shipping based on the subtotal. Under $20 is $1, $21 to $40 is $3, etc. I am so far unable to do, but pushing along. The development site is at http://38.231.165.5/Osmosis/Search.tmpl Anyone else with other methods? 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. KohenBig Mind Media L. L. C.http://www.bigmindmedia.com/janna@bigmindmedia.com
Associated Messages, from the most recent to the oldest:
I like to start a discussion about shipping. First question; how are other people doing shipping? Is everyone using the gen store method? And if you are, are you just shipping within CA or did you find zip codes for the whole country or world? To start the discussion: we have another catalog that sells only videos. The site is at http://www.acrossborders.com Since all the videos are the same size and weight, we calculate shipping based on quantity. Of course, it wasn't as easy as an simple 1-1, and I got beautiful help from Grant in creating the somewhat complex formulas that went into doing it. Now we have a catalog in which we need to calculate shipping based on the subtotal. Under $20 is $1, $21 to $40 is $3, etc. I am so far unable to do, but pushing along. The development site is at http://38.231.165.5/Osmosis/Search.tmpl Anyone else with other methods? 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. KohenBig 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...