Re: WebDNA tags in WebMerchant email templates ...

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15802
interpreted = N
texte = > Yes, I know I can pass the SN thru to WebMerchant using one of the > header fields (or the textA-E lineitem fields). I also know that > WebMerchant will put this data into its approved email message that > gets sent to the buyer if I want it to. > > But that still doesn't solve my problem ... > > Because before I can put those SN's into the order file in the first > place, I have to *assign* them to that order ... which basically > means removing them from the SN database (or flagging them as > unavailable for future purchases) ... BEFORE they are paid for. > > That means every time a cc purchase fails, I have to go into the SN > database and *un-issue* the SN's which were improperly issued to the > failed purchase. > > Basically, this is the wrong way to go about it. Not that it won't > work, but the fact is that SN's should not be assigned until AFTER > the appropriate credit card charges are authorized ... right? > > All I want is to assign the SN's AFTER cc approval, not before, so I > don't have to go into the SN database every time an attempted > software purchase fails, just to reverse WebCat's assignment of SN's > that should never have been assigned in the first place.I don't think this was already suggested but you might do all of the serial number delivery on the Pick up page. (An email containing the serial numbers can be sent from this page as well. This isn't in the WebDNA below.) This solves the problem of un-issuing serial numbers. Here's some sample 'DNA:[lineItems] [TEXTA]
[name] is licenced for [quantity] cop[showif [quantity]=1]y[/showif][hideif [quantity]=1]ies[/hideif] of this product. [showif [textb]=T]
Your serial number(s) are:
[showif [interpret][lookup db=db/serialnumbers.db&lookinfield=cartnumb&value=[cart]&returnfield=taken¬fo und=F][/interpret]=T] [include file=dispenseWO.inc&cart=[cart]&quantity=[quantity]] [/showif] [showif [interpret][lookup db=db/serialnumbers.db&lookinfield=cartnumb&value=[cart]&returnfield=taken¬fo und=F][/interpret]=F] [include file=dispenseW.inc&cart=[cart]&quantity=[quantity]] [/showif] [/showif]
[/lineItems] dispenseW.inc contains: [loop start=1&end=[quantity]] [Search db=db/serialnumbers.db&eqtakendata=F&max=1&startat=1] [founditems] [serialnumber]
[replace db=db/serialnumbers.db&eqserialnumberdata=[serialnumber]&max=1&startat=1]taken=T &cartnumb=[cart][/replace] [/founditems] [/search] [/loop] dispenseWO.inc is a search for the cart number in the database if they've already been issued a serial number. [Search db=db/serialnumbers.db&eqcartnumbdata=[cart]&startat=1] [founditems] [serialnumber]
[/founditems] [/search]Hope this helps.Nathan Hyde Internet Services Casady & Greene email: nh_is@casadyg.com, nhyde@mail3.casadyg.com web page: http://www.casadyg.com and now http://www.macbundle.com Associated Messages, from the most recent to the oldest:

    
  1. Re: WebDNA tags in WebMerchant email templates ... (Kenneth Grome 1997)
  2. Re: WebDNA tags in WebMerchant email templates ... (Nathan Hyde 1997)
  3. Re: WebDNA tags in WebMerchant email templates ... (Kenneth Grome 1997)
  4. Re: WebDNA tags in WebMerchant email templates ... (Sandra L. Pitner 1997)
  5. Re: WebDNA tags in WebMerchant email templates ... (Kenneth Grome 1997)
  6. WebDNA tags in WebMerchant email templates ... (Kenneth Grome 1997)
  7. Re: WebDNA tags in WebMerchant email templates ... (Sandra L. Pitner 1997)
> Yes, I know I can pass the SN thru to WebMerchant using one of the > header fields (or the textA-E lineitem fields). I also know that > WebMerchant will put this data into its approved email message that > gets sent to the buyer if I want it to. > > But that still doesn't solve my problem ... > > Because before I can put those SN's into the order file in the first > place, I have to *assign* them to that order ... which basically > means removing them from the SN database (or flagging them as > unavailable for future purchases) ... BEFORE they are paid for. > > That means every time a cc purchase fails, I have to go into the SN > database and *un-issue* the SN's which were improperly issued to the > failed purchase. > > Basically, this is the wrong way to go about it. Not that it won't > work, but the fact is that SN's should not be assigned until AFTER > the appropriate credit card charges are authorized ... right? > > All I want is to assign the SN's AFTER cc approval, not before, so I > don't have to go into the SN database every time an attempted > software purchase fails, just to reverse WebCat's assignment of SN's > that should never have been assigned in the first place.I don't think this was already suggested but you might do all of the serial number delivery on the Pick up page. (An email containing the serial numbers can be sent from this page as well. This isn't in the WebDNA below.) This solves the problem of un-issuing serial numbers. Here's some sample 'DNA:[lineitems] [TEXTA]
[name] is licenced for [quantity] cop[showif [quantity]=1]y[/showif][hideif [quantity]=1]ies[/hideif] of this product. [showif [textb]=T]
Your serial number(s) are:
[showif [interpret][lookup db=db/serialnumbers.db&lookinfield=cartnumb&value=[cart]&returnfield=taken¬fo und=F][/interpret]=T] [include file=dispenseWO.inc&cart=[cart]&quantity=[quantity]] [/showif] [showif [interpret][lookup db=db/serialnumbers.db&lookinfield=cartnumb&value=[cart]&returnfield=taken¬fo und=F][/interpret]=F] [include file=dispenseW.inc&cart=[cart]&quantity=[quantity]] [/showif] [/showif]
[/lineItems] dispenseW.inc contains: [loop start=1&end=[quantity]] [Search db=db/serialnumbers.db&eqtakendata=F&max=1&startat=1] [founditems] [serialnumber]
[replace db=db/serialnumbers.db&eqserialnumberdata=[serialnumber]&max=1&startat=1]taken=T &cartnumb=[cart][/replace] [/founditems] [/search] [/loop] dispenseWO.inc is a search for the cart number in the database if they've already been issued a serial number. [Search db=db/serialnumbers.db&eqcartnumbdata=[cart]&startat=1] [founditems] [serialnumber]
[/founditems] [/search]Hope this helps.Nathan Hyde Internet Services Casady & Greene email: nh_is@casadyg.com, nhyde@mail3.casadyg.com web page: http://www.casadyg.com and now http://www.macbundle.com Nathan Hyde

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:

[WebDNA] Send Mail and SMTP Host (2015) WCS Newbie question (1997) WebCat and AppleShare 6.0 (1998) Webcat 2.0.1 date math bug -> Crash! (1997) Re:Emailer and encryption (1997) Setting up WebCatalog with Retail Pro data (1996) Another Large Database Questions (1997) Questions on Mac WC 3.0.5b13 (2000) textarea to page display (1998) sort problems....bug or brain fart? (1997) Zip Codes (2003) [WebDNA] Feature Request [TABLE ... &delimiters=] (2008) [SHOWNEXT] Examples (1997) [WebDNA] WebDNA slow processing (2011) Authenticating users without dialog box (1997) WebCatalog Hosting (1996) minimalist shopping cart. (1997) Line items in table cells (1997) OK, here goes... (1997) ConvertChars - german umlauts (1998)