Re: Prepaid monthly subscription order fulfillment question
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59971
interpreted = N
texte = It seems to me that you would have two field values to use. the Date that the subscription was made: "SUB_DATE" and the Subscription term: "SUB_TERM" Maybe one more field to show the last date sent: "LAST_SENT" From those two values I think a fulfillment sendmail tpl could calculate the dates that the email gets sent out.. maybe hit by a trigger every so often. something like (abridged): [text]sub_date=[lookup returnfield=SUB_DATE][/text] [text]sub_months=[lookup returnfield=SUB_TERM][/text] [text]last_sent=[lookup returnfield=LAST_SENT][/text] [text]dates=[!] [/!][loop start=1&end=[sub_months]][!] [/!][math date]{[sub_date]}+{0[index]/00/0000}[/math],[!] [/!][/loop][!] [/!][/text] [showif ,[listwords words=[dates]&delimiters=,][url][word][/url][delimiter][/listwords]^[url][date][/url]] [hideif [url][last_sent][/url]=[url][date][/url]] [sendmail ...] [/sendmail] [replace db=blay&eqIDdatarq=ID]last_sent=[date][/replace] [committdatabase db=] [/hideif] [/showif] ....would be one way to do it ;-) Donovan Sal D'Anna wrote: > Hello, > > I have a client that sells three, six, and 1 year subscriptions. Their > customers receive a monthly package until their subscription expires. > > For example, the customer buys a 6 month subscription which gets paid in > full, including shipping. The new order gets sent to the fulfillment > company to ship the first month. The question is, how should I set up the > system to send the fulfillment email the other 5 months? Should I add an > expiration date field, or a number_left field that reduces the subscription > by one whenever a new shipment is sent? > > > Any ideas? > > > Sal D’Anna -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
It seems to me that you would have two field values to use. the Date that the subscription was made: "SUB_DATE" and the Subscription term: "SUB_TERM" Maybe one more field to show the last date sent: "LAST_SENT" From those two values I think a fulfillment sendmail tpl could calculate the dates that the email gets sent out.. maybe hit by a trigger every so often. something like (abridged): [text]sub_date=[lookup returnfield=SUB_DATE][/text] [text]sub_months=[lookup returnfield=SUB_TERM][/text] [text]last_sent=[lookup returnfield=LAST_SENT][/text] [text]dates=[!] [/!][loop start=1&end=[sub_months]][!] [/!][math date]{[sub_date]}+{0[index]/00/0000}[/math],[!] [/!][/loop][!] [/!][/text] [showif ,[listwords words=[dates]&delimiters=,][url][word][/url][delimiter][/listwords]^[url][date][/url]] [hideif [url][last_sent][/url]=[url][date][/url]] [sendmail ...] [/sendmail] [replace db=blay&eqIDdatarq=ID]last_sent=[date][/replace] [committdatabase db=] [/hideif] [/showif] ....would be one way to do it ;-) Donovan Sal D'Anna wrote: > Hello, > > I have a client that sells three, six, and 1 year subscriptions. Their > customers receive a monthly package until their subscription expires. > > For example, the customer buys a 6 month subscription which gets paid in > full, including shipping. The new order gets sent to the fulfillment > company to ship the first month. The question is, how should I set up the > system to send the fulfillment email the other 5 months? Should I add an > expiration date field, or a number_left field that reduces the subscription > by one whenever a new shipment is sent? > > > Any ideas? > > > Sal D’Anna -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/
Donovan Brooke
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:
RE: [WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019)
TaxTotal Problem (1997)
[shownext max (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[WebDNA] feature request - .hdr files (2011)
Kill the webcat process (2000)
New Lawsuit Alleges Unitedhealth/Pacificare Deceived (2006)
Items XX to XX shown (1997)
WebCat cannot handle compatible search parameters? (1997)
Generating Pages (1999)
WebTen? (1997)
Cache problem (2002)
One more try (1997)
RE: type 2 errors with ssl server (1997)
ImageMagick Commands? (2003)
RE: groups and [ShowNext] (1997)
ConvertChars (1998)
Protecting Realms (1998)
[WebDNA] [ipaddress] - [RealIP] - Not working properly (2016)
Emailer help....! (1997)