Problem 2 of 2 (was: Shipping Confusion)

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 33641
interpreted = N
texte = My second issue is calculating shipping costs. We're selling books, whose shipping is $5/book. Simple. We're also selling posters. The mailing tubes cost $5 to ship, too, but people can order multiple copies of one poster or single copies of different posters -- all of which can go into the same $5 tube. Right now, it would cost a cost of $20 to ship 4 posters, which is absurd.John Peacock had this suggestion, which a) I don't know how to implement and b) will have customers complaining that they only want to buy the posters -- not mailing tubes:Set the UnitShipCost for the posters to be $0 and then scan the cart for any posters on the page just before you purchase. I would add a new line item for the Poster Shipping Tube instead of trying to mess with the shipping. Then if the person bought posters and books, you would have shipping for books in shipping and the Poster Tube as a seperate line item.For now, I think I'd settle for this solution if I could figure out how to make it work! How does one search the lineitems and add a lineitem based on the result? The logic is simple enough, but I'm having a hard time with it...Here's a simplified version of the code I've got at this point on my invoice.tpl:[orderfile cart=[cart]][SetHeader cart=[cart]]shipVia=[url][__shipVia][/url]&shipToState=[url][__shipToState][/url]&CartIPAddress=[ipAddress][/SetHeader][lineitems] [SetLineItem cart=[cart]&index=[lineindex]]quantity=[interpret][quantity[lineindex]][/interpret]&textA=[url][lookup db=tantramar_publishing.db&lookinfield=sku&value=[url][sku][/url]&returnfield=title][/url][/SetLineItem] [/lineitems]

Final Invoice

Change Quantities, Shipping, or Shipping destination | Shop Some More

Your Final Invoice Contains the Following Items:

Your Order Number is #[cart]

[lineItems] [/lineItems]
[lineIndex][quantity][sku][textA]$[price]$[format .2f][math][quantity]*[price][/math][/format]
Subtotal$[subTotal]
[ShipTostate] Tax Rate: [taxRate]%$[taxTotal]
Shipping & Handling
(all items shipped via [shipVia])
$[shippingTotal]
Grand Total$[grandTotal]

Please enter the following information so that we may process your order.

[include file=invoiceinfo.inc]

[/orderfile] -- Regards,Christopher Mackay, Multimedia Developer Tantramar Interactive, http://www.tantramar.com/ 506/364-1097 cell: 364-7659 fax: 536-2409------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Problem 2 of 2 (was: Shipping Confusion) (Christopher Mackay 2000)
  2. Re: Problem 2 of 2 (was: Shipping Confusion) (Christopher Mackay 2000)
  3. Re: Problem 2 of 2 (was: Shipping Confusion) (Rob Marquardt 2000)
  4. Re: Problem 2 of 2 (was: Shipping Confusion) (John Peacock 2000)
  5. Re: Problem 2 of 2 (was: Shipping Confusion) (John Butler 2000)
  6. Re: Problem 2 of 2 (was: Shipping Confusion) (Christopher Mackay 2000)
  7. Re: Problem 2 of 2 (was: Shipping Confusion) (John Peacock 2000)
  8. Re: Problem 2 of 2 (was: Shipping Confusion) (Christopher Mackay 2000)
  9. Re: Problem 2 of 2 (was: Shipping Confusion) (John Butler 2000)
  10. Problem 2 of 2 (was: Shipping Confusion) (Christopher Mackay 2000)
My second issue is calculating shipping costs. We're selling books, whose shipping is $5/book. Simple. We're also selling posters. The mailing tubes cost $5 to ship, too, but people can order multiple copies of one poster or single copies of different posters -- all of which can go into the same $5 tube. Right now, it would cost a cost of $20 to ship 4 posters, which is absurd.John Peacock had this suggestion, which a) I don't know how to implement and b) will have customers complaining that they only want to buy the posters -- not mailing tubes:Set the UnitShipCost for the posters to be $0 and then scan the cart for any posters on the page just before you purchase. I would add a new line item for the Poster Shipping Tube instead of trying to mess with the shipping. Then if the person bought posters and books, you would have shipping for books in shipping and the Poster Tube as a seperate line item.For now, I think I'd settle for this solution if I could figure out how to make it work! How does one search the lineitems and add a lineitem based on the result? The logic is simple enough, but I'm having a hard time with it...Here's a simplified version of the code I've got at this point on my invoice.tpl:[orderfile cart=[cart]][SetHeader cart=[cart]]shipVia=[url][__shipVia][/url]&shipToState=[url][__shipToState][/url]&CartIPAddress=[ipaddress][/SetHeader][lineitems] [SetLineItem cart=[cart]&index=[lineindex]]quantity=[interpret][quantity[lineindex]][/interpret]&textA=[url][lookup db=tantramar_publishing.db&lookinfield=sku&value=[url][sku][/url]&returnfield=title][/url][/SetLineItem] [/lineitems]

Final Invoice

[cart]>Change Quantities, Shipping, or Shipping destination | [cart]>Shop Some More

Your Final Invoice Contains the Following Items:

Your Order Number is #[cart]

[cart]> [lineitems] [/lineItems]
[lineIndex][quantity][sku][textA]$[price]$[format .2f][math][quantity]*[price][/math][/format]
Subtotal$[subTotal]
[ShipTostate] Tax Rate: [taxRate]%$[taxTotal]
Shipping & Handling
(all items shipped via [shipVia])
$[shippingTotal]
Grand Total$[grandTotal]

Please enter the following information so that we may process your order.

[include file=invoiceinfo.inc]

[/orderfile] -- Regards,Christopher Mackay, Multimedia Developer Tantramar Interactive, http://www.tantramar.com/ 506/364-1097 cell: 364-7659 fax: 536-2409------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Christopher Mackay

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:

Formatting (2000) shipping costs (1997) calculating tax rates, mail order solutions and version 2 (1997) verification (2004) Nested Lookups (1998) Help name our technology! (1997) Plugin or CGI or both (1997) NT version (1997) Help name our technology! (1997) WebCat2final1 crashes (1997) Nested Loops and SHOWIFs (1997) Re:Item options w/ price adjustment (1997) space at start of menu (2000) Frames and [cart] (1998) Works! (1997) WebCat2 - [SendNews] (1997) RE: Symantec VIsual Page 1.0.3 (1997) Reversed words (1997) Problems setting MIME Headers (1998) Nested tags count question (1997)