Re: Prepaid monthly subscription order fulfillment question

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59973
interpreted = N
texte = 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Prepaid monthly subscription order fulfillment question ( "Sal D'Anna" 2004)
  2. Re: Prepaid monthly subscription order fulfillment question ( devaulw@onebox.com 2004)
  3. Re: Prepaid monthly subscription order fulfillment question ( "Sal D'Anna" 2004)
  4. Re: Prepaid monthly subscription order fulfillment question ( devaulw@onebox.com 2004)
  5. Re: Prepaid monthly subscription order fulfillment question ( Donovan Brooke 2004)
  6. Re: Prepaid monthly subscription order fulfillment question ( Donovan Brooke 2004)
  7. Prepaid monthly subscription order fulfillment question ( "Sal D'Anna" 2004)
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/ 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:

Help name our technology! (1997) Running 2 two WebCatalog.acgi's (1996) unable to run webcatalog locally (1998) Quitting WebMerchant ? (1997) syntax question, not in online refernce (1997) error -43 (1998) Almost a there but..bye bye NetCloak (1997) Size of File (2006) Press Release hit the NewsWire!!! (1997) Help name our technology! I found it (1997) IF/THEN, SHOWIF, and/or HIDEIF (2007) Shipping cost out of synch (1998) [WriteFile] problems (1997) For those of you not on the WebCatalog Beta... (1997) Error Lob.db records error message not name (1997) WebDNA for Window 2000 Server (2003) Quit revisited (1997) WebCat2_Mac RETURNs in .db (1997) Sample Tearoom Search Error - Solved! (1997) Smart caching problems with 2.1b3? (1997)