Re: Prepaid monthly subscription order fulfillment question
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59982
interpreted = N
texte = I was thinking I could make the Categories in the Cat_Calendar.db torepresent each subscription type. Then each time someone orders, it willpost to the calendar.db and use the DAT_STARTDATETIME and theDAT_ENDDATETIME as the subscription parameters and the Cart Number as theDat_ID for each entry.Sal D'Anna-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Ofdevaulw@onebox.comSent: Wednesday, November 10, 2004 2:48 PMTo: WebDNA TalkSubject: Re: Prepaid monthly subscription order fulfillment questionI don't know the answer to your question because I have not worked with thecalendar db. If you mean that each fill is simply an entry on a calendar (you could alsodo the subscription renewals/expirations). That doesn't sound like too muchtrouble (search by month, put results in a table, sort table and present byday), but if that's not what you mean, perhaps you can provide a little moredescription. Bill-----Original Message-----From: Sal D'Anna
Sent: Wed, 10 Nov 2004 14:12:00 -0800To: "WebDNA Talk" Subject: Re: Prepaid monthly subscription order fulfillment questionDo you think it would be difficult to incorporate this into the Calendar inSitebuilder and use the calendar.db as the relational db? This way, theshipper could just check the Calendar to see what needs to be shipped bymonth, day, or week.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Ofdevaulw@onebox.comSent: Wednesday, November 10, 2004 12:34 PMTo: WebDNA TalkSubject: Re: Prepaid monthly subscription order fulfillment questionIdeally you'd want separate dbs for client=>subscriptions=>fills.Relationships as one to many, one to many. This is the best way to trackthe data IMHO. It would also allow you to skip fills for vacations and the like. Bill-----Original Message-----From: Sal D'Anna Sent: Wed, 10 Nov 2004 11:26:00 -0800To: "WebDNA Talk" Subject: Prepaid monthly subscription order fulfillment questionHello,I have a client that sells three, six, and 1 year subscriptions. Theircustomers receive a monthly package until their subscription expires.For example, the customer buys a 6 month subscription which gets paid infull, including shipping. The new order gets sent to the fulfillmentcompany to ship the first month. The question is, how should I set up thesystem to send the fulfillment email the other 5 months? Should I add anexpiration date field, or a number_left field that reduces the subscriptionby one whenever a new shipment is sent?Any ideas?Sal D?Anna-------------------------------------------------------------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 toWeb Archive of this list is at: http://webdna.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 toWeb Archive of this list is at: http://webdna.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 toWeb Archive of this list is at: http://webdna.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 toWeb Archive of this list is at: http://webdna.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I was thinking I could make the Categories in the Cat_Calendar.db torepresent each subscription type. Then each time someone orders, it willpost to the calendar.db and use the DAT_STARTDATETIME and theDAT_ENDDATETIME as the subscription parameters and the Cart Number as theDat_ID for each entry.Sal D'Anna-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Ofdevaulw@onebox.comSent: Wednesday, November 10, 2004 2:48 PMTo: WebDNA TalkSubject: Re: Prepaid monthly subscription order fulfillment questionI don't know the answer to your question because I have not worked with thecalendar db. If you mean that each fill is simply an entry on a calendar (you could alsodo the subscription renewals/expirations). That doesn't sound like too muchtrouble (search by month, put results in a table, sort table and present byday), but if that's not what you mean, perhaps you can provide a little moredescription. Bill-----Original Message-----From: Sal D'Anna Sent: Wed, 10 Nov 2004 14:12:00 -0800To: "WebDNA Talk" Subject: Re: Prepaid monthly subscription order fulfillment questionDo you think it would be difficult to incorporate this into the Calendar inSitebuilder and use the calendar.db as the relational db? This way, theshipper could just check the Calendar to see what needs to be shipped bymonth, day, or week.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Ofdevaulw@onebox.comSent: Wednesday, November 10, 2004 12:34 PMTo: WebDNA TalkSubject: Re: Prepaid monthly subscription order fulfillment questionIdeally you'd want separate dbs for client=>subscriptions=>fills.Relationships as one to many, one to many. This is the best way to trackthe data IMHO. It would also allow you to skip fills for vacations and the like. Bill-----Original Message-----From: Sal D'Anna Sent: Wed, 10 Nov 2004 11:26:00 -0800To: "WebDNA Talk" Subject: Prepaid monthly subscription order fulfillment questionHello,I have a client that sells three, six, and 1 year subscriptions. Theircustomers receive a monthly package until their subscription expires.For example, the customer buys a 6 month subscription which gets paid infull, including shipping. The new order gets sent to the fulfillmentcompany to ship the first month. The question is, how should I set up thesystem to send the fulfillment email the other 5 months? Should I add anexpiration date field, or a number_left field that reduces the subscriptionby one whenever a new shipment is sent?Any ideas?Sal D?Anna-------------------------------------------------------------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 toWeb Archive of this list is at: http://webdna.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 toWeb Archive of this list is at: http://webdna.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 toWeb Archive of this list is at: http://webdna.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 toWeb Archive of this list is at: http://webdna.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://webdna.smithmicro.com/
"Sal D'Anna"
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:
Calculating multiple shipping... (1997)
PCS Frames (1997)
PROBLEM (1997)
re: Default contains WEBDNA (1998)
encrypt/decrypt failing (2000)
Re:What file? (1997)
& not allowed in db by definition? (1999)
RE: [WebDNA] Digital Ocean /WebDNA is not configured to accept (2019)
Internet Explorer 6 Form problems (2005)
docs for WebCatalog2 (1997)
too many nested [xxx] (1997)
[WebDNA] DNA suffix (2008)
[SHOWNEXT] Examples (1997)
Problem with updating 2.1b7 -> 2.1.1 (1998)
WebCatalog NT beta 18 problem (1997)
PROBLEM (1997)
NY taxRates.db? (1997)
webCat craps httpd (2005)
problems with WebCat-Plugin (1997)
Custom WebCat Prefs ... (1997)