WebCat 4.0 & WebMerchant

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 33642
interpreted = N
texte = I have my site set up to take orders and would like to have them processed through CyberSource via WebMerchant. At the end of my ordering process I have a [purchase] command that is accurately moving the order from the shopping_carts folder to the orders folder, however, nothing is showing up in the orders.db in the WebMerchant folder. If I use the Orders admin page nothing shows up.I thought WebCat and WebMerchant are integrated in 4.0 (from reading their web site). Do I have to manually put the order in the orders.db database or should this happen automatically? If auto, then how do I set it up?Thank you very much for all the help from this list.Max -- Max Utter President & CEO, menstoys.com 1113 Spruce Street, suite 103 Boulder, CO 80302max@menstoys.com office: 303 381-2502 fax: 303 381-2504 cell: 303 588-3813http://www.menstoys.com/store/home.asp> From: Christopher Mackay > Reply-To: (WebCatalog Talk) > Date: Sun, 25 Jun 2000 12:18:11 -0300 > To: (WebCatalog Talk) > Subject: Problem 2 of 2 (was: Shipping Confusion) > > 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][/u > rl]&CartIPAddress=[ipAddress][/SetHeader] > > [lineitems] > [SetLineItem > cart=[cart]&index=[lineindex]]quantity=[interpret][quantity[lineindex]][/inter > pret]&textA=[url][lookup > db=tantramar_publishing.db&lookinfield=sku&value=[url][sku][/url]&returnfield= > title][/url][/SetLineItem] > [/lineitems] > >

Final Invoice

> >

HREF=shoppingcart.tpl?command=showcart&db=tantramar_publishing.db&cart=[cart] > >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/ > ------------------------------------------------------------- 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: WebCat 4.0 & WebMerchant (WebDNA Support 2000)
  2. Re: WebCat 4.0 & WebMerchant (Max Utter 2000)
  3. Re: WebCat 4.0 & WebMerchant (Dennis J. Bonsall, Jr. 2000)
  4. Re: WebCat 4.0 & WebMerchant (John Butler 2000)
  5. Re: WebCat 4.0 & WebMerchant (Wendell Kozak 2000)
  6. Re: WebCat 4.0 & WebMerchant (Glenn Busbin 2000)
  7. Re: WebCat 4.0 & WebMerchant (Will Starck 2000)
  8. WebCat 4.0 & WebMerchant (Max Utter 2000)
  9. Re: Mac WebCat 4.0 Day Planner Hang (Chuck Rice 2000)
  10. Re: Mac WebCat 4.0 Day Planner Hang (WebDNA Support 2000)
  11. Mac WebCat 4.0 Day Planner Hang (Chuck Rice 2000)
  12. Mac WebCat 4.0 Day Planner Hang (Chuck Rice 2000)
  13. Re: Webcat 4.0 and security (Christer Olsson 2000)
  14. Re: Webcat 4.0 and security (Grant Hulbert 2000)
  15. Webcat 4.0 and security (Christer Olsson 2000)
I have my site set up to take orders and would like to have them processed through CyberSource via WebMerchant. At the end of my ordering process I have a [purchase] command that is accurately moving the order from the shopping_carts folder to the orders folder, however, nothing is showing up in the orders.db in the WebMerchant folder. If I use the Orders admin page nothing shows up.I thought WebCat and WebMerchant are integrated in 4.0 (from reading their web site). Do I have to manually put the order in the orders.db database or should this happen automatically? If auto, then how do I set it up?Thank you very much for all the help from this list.Max -- Max Utter President & CEO, menstoys.com 1113 Spruce Street, suite 103 Boulder, CO 80302max@menstoys.com office: 303 381-2502 fax: 303 381-2504 cell: 303 588-3813http://www.menstoys.com/store/home.asp> From: Christopher Mackay > Reply-To: (WebCatalog Talk) > Date: Sun, 25 Jun 2000 12:18:11 -0300 > To: (WebCatalog Talk) > Subject: Problem 2 of 2 (was: Shipping Confusion) > > 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][/u > rl]&CartIPAddress=[ipaddress][/SetHeader] > > [lineitems] > [SetLineItem > cart=[cart]&index=[lineindex]]quantity=[interpret][quantity[lineindex]][/inter > pret]&textA=[url][lookup > db=tantramar_publishing.db&lookinfield=sku&value=[url][sku][/url]&returnfield= > title][/url][/SetLineItem] > [/lineitems] > >

Final Invoice

> >

HREF=shoppingcart.tpl?command=showcart&db=tantramar_publishing.db&cart=[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/ > ------------------------------------------------------------- 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/ Max Utter

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:

[Shownext] (1997) Include a big block of text (1997) Frames and WebCat (1997) emailer (1997) Newspaper Portal (2005) [WebDNA] Best WebDNA version for OS X Server 10.5.8 on PowerPC? (2010) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Calculating multiple shipping... (1997) time and welcome (1999) Performance Issue (2000) [WebDNA] problems with [protect] on new OSX lion install (2012) [WebDNA] Mailing list failure !!! (2019) [protect] on NT? (1997) Download URL & access on the fly ? (1997) What am I missing (1997) can WC render sites out? (1997) taxTotal, grandTotal (1997) Just Testing (1997) Hiding HTML and breaking the page (1997) Showif for mulitple variations (1997)