Webmerchant confirmation hooks?

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11265
interpreted = N
texte = Sorry if this is a bit long, but it may be useful food for thought for what other people want to do.Now, that we have got our online store working in handling orders, ship weight costs, downloads, emailing confirmations, etc., we wish to use the [append] construct to maintain what customers order in a separate series of databases that we wish to use WebCat's tmpl processing to handle internal housekeeping type of issues with the orders (e.g. print invoices, custom searches, order processing information updates (like when shipped), tax calculations to keep the IRS happy, etc.) through a regular web browser. We wish to avoid using FMP and applescripts for performance reasons. We are just beginning to structure the external database to be maintained/updated as orders come in and have come up with the following question concerning how we can update it as a result of webmerchant running macauthorize.What we are going to do as part of the final_invoice.tmpl is add the customer's order information to our own databases (it will be just like WebCat's <- series of tab delimited fields in several separate databases). Since this final_invoice.tmpl step occurs before webmerchant cranks the customer order through MacAuthorize for confirmation, our new order record in our database will have posted in a field concerned with card processing something like pending. Then based upon MacAuthorize's run on the order we wish to update that field as accepted or rejected. Since the resulting pages (thankyou and order rejection) that come from the final_invoice.tmpl don't have any cgi action associated with them because the customer is done at that point (except for downloads of course), the question is how to we then update our external database to the result of what webmerchant does?One idea we thought of is to fake out WebCat by asking it to lookup the first words in the email notifications generated by webmerchant as a result of macauthorize's run and if we found the email with the same [cart] reference we can infer if the order was rejected or accepted. This is sort of ugly kludge, so I was wondering if there is some hook from webmerchant that we can use to find out how the order went through the macauthorize processing that we can then update our separate database with. We want to perform this kind of operation in same automatic way like the email notification mechanism that webmerchant does now.Curt ---------------------------------------------------------------------- | William Curt Eggemeyer Curt@mail.bzzzzzz.com | | BeeHive Technologies, Inc. | | http://www.bzzzzzz.com with a WebCam in Pasadena, California | ---------------------------------------------------------------------- Associated Messages, from the most recent to the oldest:

    
  1. Webmerchant confirmation hooks? (w curt eggemeyer 1997)
Sorry if this is a bit long, but it may be useful food for thought for what other people want to do.Now, that we have got our online store working in handling orders, ship weight costs, downloads, emailing confirmations, etc., we wish to use the [append] construct to maintain what customers order in a separate series of databases that we wish to use WebCat's tmpl processing to handle internal housekeeping type of issues with the orders (e.g. print invoices, custom searches, order processing information updates (like when shipped), tax calculations to keep the IRS happy, etc.) through a regular web browser. We wish to avoid using FMP and applescripts for performance reasons. We are just beginning to structure the external database to be maintained/updated as orders come in and have come up with the following question concerning how we can update it as a result of webmerchant running macauthorize.What we are going to do as part of the final_invoice.tmpl is add the customer's order information to our own databases (it will be just like WebCat's <- series of tab delimited fields in several separate databases). Since this final_invoice.tmpl step occurs before webmerchant cranks the customer order through MacAuthorize for confirmation, our new order record in our database will have posted in a field concerned with card processing something like pending. Then based upon MacAuthorize's run on the order we wish to update that field as accepted or rejected. Since the resulting pages (thankyou and order rejection) that come from the final_invoice.tmpl don't have any cgi action associated with them because the customer is done at that point (except for downloads of course), the question is how to we then update our external database to the result of what webmerchant does?One idea we thought of is to fake out WebCat by asking it to lookup the first words in the email notifications generated by webmerchant as a result of macauthorize's run and if we found the email with the same [cart] reference we can infer if the order was rejected or accepted. This is sort of ugly kludge, so I was wondering if there is some hook from webmerchant that we can use to find out how the order went through the macauthorize processing that we can then update our separate database with. We want to perform this kind of operation in same automatic way like the email notification mechanism that webmerchant does now.Curt ---------------------------------------------------------------------- | William Curt Eggemeyer Curt@mail.bzzzzzz.com | | BeeHive Technologies, Inc. | | http://www.bzzzzzz.com with a WebCam in Pasadena, California | ---------------------------------------------------------------------- w curt eggemeyer

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:

Feature: TCPconnect via SSL (1999) Help!!!! (1997) [WebDNA] Error: Can't open order file. Ignoring [OrderFile] context Error: Error: expected [/APPLICATION], but found [/!] instead[/!] (2011) [carts] and databases (1997) [addlineitems] (1997) Smart caching problems with 2.1b3? (1997) [WebDNA] Authorization with .htaccess (2008) WebCat2b13MacPlugin - nested [xxx] contexts (1997) Multithreading of [replace] (1999) [listfields] context (2005) OT: WebDNA and LINUX (2004) Issue with plug-in Webcat, webstar 4.x, SSL and IE when using the backbuttom (2000) emailer on Windows Beta 18 (1997) Emailer setup (1997) weird G3 happenings (1998) major search problem (1998) Automated FTP from Shell (2004) [ShowCart]-- was ThankYou page problems (1997) SiteGuard Admin Feature ? (1997) Quick Data sorting questions (2002)