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:

SiteGuard Admin Feature ? (1997) WebCat2b12 Mac.acgi--[searchstring] bug (1997) TRAINING videos - Prove IT. (1998) Re:Email Problem (1997) OT: fckeditor weirdness (2005) InSecureTextVariables.... (2000) raw=T is broken in [include] (1997) all records returned. (1997) Quitting WebMerchant ? (1997) Database Field Additions (2000) PIXO support (1997) deadlock (2000) PIXO support (1997) Support ?? (1997) Share cost of training videos! (1998) Multiple 'Users.db' files not possible (1997) Deleting with contexts (2001) Webcat2, WebCommerce, Mod 10 etc. (1997) Setting up shop (1997) Searchable Archives? (2000)