Re: Prepaid monthly subscription order fulfillment question
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59978
interpreted = N
texte = I don't know the answer to your question because I have not worked with the calendar db. If you mean that each fill is simply an entry on a calendar (you could also do the subscription renewals/expirations). That doesn't sound like too much trouble (search by month, put results in a table, sort table and present by day), but if that's not what you mean, perhaps you can provide a little more description. Bill -----Original Message----- From: Sal D'Anna
Sent: Wed, 10 Nov 2004 14:12:00 -0800 To: "WebDNA Talk" Subject: Re: Prepaid monthly subscription order fulfillment question Do you think it would be difficult to incorporate this into the Calendar in Sitebuilder and use the calendar.db as the relational db? This way, the shipper could just check the Calendar to see what needs to be shipped by month, day, or week. -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of devaulw@onebox.com Sent: Wednesday, November 10, 2004 12:34 PM To: WebDNA Talk Subject: Re: Prepaid monthly subscription order fulfillment question Ideally you'd want separate dbs for client=>subscriptions=>fills. Relationships as one to many, one to many. This is the best way to track the 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 -0800 To: "WebDNA Talk" Subject: Prepaid monthly subscription order fulfillment question 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 ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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 don't know the answer to your question because I have not worked with the calendar db. If you mean that each fill is simply an entry on a calendar (you could also do the subscription renewals/expirations). That doesn't sound like too much trouble (search by month, put results in a table, sort table and present by day), but if that's not what you mean, perhaps you can provide a little more description. Bill -----Original Message----- From: Sal D'Anna Sent: Wed, 10 Nov 2004 14:12:00 -0800 To: "WebDNA Talk" Subject: Re: Prepaid monthly subscription order fulfillment question Do you think it would be difficult to incorporate this into the Calendar in Sitebuilder and use the calendar.db as the relational db? This way, the shipper could just check the Calendar to see what needs to be shipped by month, day, or week. -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of devaulw@onebox.com Sent: Wednesday, November 10, 2004 12:34 PM To: WebDNA Talk Subject: Re: Prepaid monthly subscription order fulfillment question Ideally you'd want separate dbs for client=>subscriptions=>fills. Relationships as one to many, one to many. This is the best way to track the 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 -0800 To: "WebDNA Talk" Subject: Prepaid monthly subscription order fulfillment question 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 ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/
devaulw@onebox.com
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:
Not really WebCat (1997)
Is the list server working? (1998)
Templates in Memory (2000)
setting cookies for another domain? (2002)
Help with Shipping Costs (1997)
[OT] .php3 extension (2000)
Upgrade Installation (1998)
Okay, I give up... (1999)
Next X hits (1996)
WebCat cannot handle compatible search parameters? (1997)
default value from Lookup (was Grant, please help me) (1997)
emailer w/F2 (1997)
Change in Host? (1999)
Reminder for beta testers (2000)
shownext & math (1997)
Dynamically Generated Pages & WC? (2000)
Document Contains No Data (1998)
Emailer update for Mac? (1998)
Multiple cart additions (1997)
Webcat 3.0.5b9, b8 trigger failures ON WEBSTAR (1999)