Abstract:
This relates to a method and system for processing subscriptions and periodically-billed services. It shows different methods by the way of examples. It improves the e-commerce by increasing the traffic and amount of transactions between interested parties. One goal of the current business is to form partnerships with the largest online merchants, to integrate digital content subscriptions into their product offerings. It provides a method to receive these orders electronically from the merchant and pass them to the content provider to activate the customer&#39;s subscription.

Description:
BACKGROUND OF THE INVENTION  
       [0001]    With the increase use of computers and the Internet around the world, it is easier for people to distribute the content and information to potential consumers. This invention addresses one of these issues, which relates to a method and system for processing subscriptions and periodically-billed services. 
         [0002]    Prior art failed to teach the features of the current invention. For example, U.S. Pat. No. 6,542,874 by Walker et al., U.S. Pat. No. 6,343,275 by Wong, U.S. Pat. No. 6,473,740 by Cockrill et al., U.S. Pat. No. 7,028,300 by Goldick, U.S. Pat. No. 6,733,387 by Walker et al., U.S. Pat. No. 6,711,549 by Loeb et al. (of Synapse Group, Inc.), U.S. Pat. No. 6,421,652 by Loeb et al., U.S. Pat. No. 6,415,262 by Walker et al. (of Walker Digital, LLC), U.S. Pat. No. 6,167,435 by Druckenmiller et al., and U.S. Pat. No. 6,332,124 by Loeb et al. teach models/systems different from the current invention (and its variations/ embodiments). 
         [0003]    Another prior art is Amazon.com web site, where they offer The Wall Street Journal Online, with a one-year subscription. The major difference is that, for the Amazon.com web site, the information is not transmitted to a third-party. Therefore, it is very different from our invention. 
       SUMMARY OF THE INVENTION  
       [0004]    This invention relates to a method and system for processing subscriptions and periodically-billed services. It teaches different methods by the way of examples. It improves the e-commerce by increasing the traffic and amount of transactions between interested parties. One goal of the current business is to form partnerships with the largest online merchants, to integrate digital content subscriptions into their product offerings. It provides a method to receive these orders electronically from the merchant and pass them to the content provider to activate the customer&#39;s subscription. 
     
     
       BRIEF DESCRIPTION OF THE DRAWINGS  
         [0005]      FIG. 1  shows the solution overview. 
           [0006]      FIG. 2  shows the first part of the technical overview. 
           [0007]      FIG. 3  shows the second part of the technical overview. 
           [0008]      FIG. 4  shows the Administration (Admin.) Tool. 
       
    
    
     DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS  
     Business Overview: 
     Solution Strategy: Order Processing Platform: 
       [0009]    In one embodiment, the goal of the current business (let&#39;s call it “OurBusiness”) is to form partnerships with the largest online merchants, to integrate digital content subscriptions into their product offerings. It will provide a method to receive these orders electronically from the merchant and pass them to the content provider to activate the customer&#39;s subscription. Both the merchant and OurBusiness will receive a revenue share for each order, while the content provider benefits from the leads generated from the additional marketing channels. Customers will also benefit from a 30-day money back guarantee for any digital subscription orders placed through the merchant. 
         [0010]    The same engine/system can also be used for other applications, for example, raising e-fund, such as the ones used for kids in school projects. 
       High-Level Requirements: 
     A. Order Processing Platform: 
       [0011]    In one embodiment, OurBusiness order processing platform supports the following primary functions: 
         [0012]    Receive/validate individual or batch orders from online merchants for digital subscription services 24×7×365 
         [0013]    Receive/validate individual or batch cancellations from online merchants 24×7×365 for customer-initiated cancellations requested within 30 days of the order 
         [0014]    Store customer/order data in OurBusiness databases, for reporting, analysis, and customer service 
         [0015]    Submit orders/cancellations to content providers within an hour of receiving them from merchants 
         [0016]    Report any errors encountered during the receipt and processing of order/cancellation requests to merchants and content providers 
       B. Administration Tool: 
       [0017]    In one embodiment, OurBusiness administration tool is necessary to manage the following activities in support of the order processing platform: 
         [0018]    Set up and maintain merchant and content provider profiles 
         [0019]    Generate schema for merchants to use for submitting orders/cancellations to OurBusiness 
         [0020]    Map content provider data to the OurBusiness database 
         [0021]    Research customer/order details 
         [0022]    Generate/manage invoices (including applicable refunds) to merchants and content providers 
         [0023]    Produce a check file for paying merchants/content providers 
         [0024]    Provide business analysis reporting 
       Key Design Objectives: 
       [0025]    In one embodiment, the following objectives were considered as a part of the overall design of the OurBusiness solution: 
         [0026]    The solution should be flexible and extendible enough to support the variable data requirements and file formats for each content provider to receive orders and cancellations requests from the merchant via OurBusiness. 
         [0027]    The processes for receiving orders/cancellations from merchants and for submitting orders/cancellations to content providers (including all sub-processes for extracting, storing, and transforming data) should be automated. 
         [0028]    The solution should be designed with validation points/error handling at each hand-off to minimize the potential for data loss and integrity issues. 
         [0029]    The solution should be designed to allow processing of orders/cancellations 24-hours a day, 365 days a year. System monitoring scripts and logging should be utilized to provide OurBusiness administrators with the notification and details necessary to maintain the availability and accuracy of the order processing services. 
         [0030]    The solution should be designed to process orders/cancellations (either as individual or batch items) from the merchant and submit them to content providers within an hour of receipt. In addition, the solution should be designed to scale easily to support the growth of OurBusiness&#39;s business. 
         [0031]    All data submitted between the merchant, OurBusiness, and the content providers should be over a secure channel and/or encrypted using an industry-standard data encryption method. All sensitive customer information (e.g. credit cards) should be encrypted while stored in OurBusiness databases. 
         [0032]    The recommendations contained within this document are dependant upon the following: 
         [0033]    In order to receive the 30-day money-back guarantee, customers will need to cancel subscriptions within the first 30 days of their membership through the merchant. OurBusiness will not be responsible for processing cancellations through to the merchant if the customer cancels directly with the content provider. 
         [0034]    The revenue for merchants and OurBusiness will be based upon a one-time fixed payment for each new customer subscription generated—not as a recurring payment for each month a customer maintains the subscription. 
         [0035]    OurBusiness will utilize vendor software for producing checks for paying merchants/content providers. It is assumed that this software will accept a compliant check file produced by an external system. 
         [0036]    The actual method for submitting orders and cancellations (including encryption and error handling) to content providers is dependant upon the specific requirements of the content provider. 
         [0037]    Content providers will only require one schema/file format to support all subscriptions services and/or payment terms. 
       Solution Overview: General Order/Cancellation Process: 
       [0038]    In one embodiment, the flow chart of  FIG. 1  outlines the high-level activities that merchants, OurBusiness, and content providers will need to perform as a part of processing digital subscription orders and cancellations. 
         [0039]    For one embodiment, for account subscription, the merchant, OurBusiness, and content provider have the following relationship, with OurBusiness being in the middle (see  FIG. 1 ): 
         [0040]    Merchant performs the following tasks:
       1. Offer subscription product on-site.   2. Integrate any additional field collection within checkout process.   3a. Monthly term: process first monthly charge.   3b. Annual term: process annual charge.   4. Pass customer/order data to OurBusiness.   5. Receive success/error response from OurBusiness.   6. Message customer that they will receive email from content provider upon account activation (within 24 hours).       
 
         [0048]    OurBusiness performs the following tasks:
       1. Validate/store order data in OurBusiness database.   2. Format/send order data to content provider.   3a. Monthly term: invoice content provider.   3b. Annual term: invoice merchant.       
 
         [0053]    Content provider performs the following tasks:
       1. Process sign-up including schedule recurring payment.   2. Sends account activation email to customer.   3a. Monthly term: pay OurBusiness.   3b. Annual term: invoice OurBusiness.       
 
         [0058]    For account cancellation (within 30 days, for example), the merchant, OurBusiness, and content provider have the following relationship, with OurBusiness being in the middle (see  FIG. 1 ): 
         [0059]    Merchant performs the following tasks:
       1. Refund customer.   2. Notify OurBusiness of cancellation.   3. Receive success/error response from OurBusiness.   4. Message customers that they will receive email from content provider confirming account cancellation (within 24 hours, e.g.).       
 
         [0064]    OurBusiness performs the following tasks:
       1. Record cancellation in OurBusiness database.   2. Format/send cancellation to content provider.   3a. Monthly term: no invoice/refund.   3b. Annual term: invoice content provider, refund merchant.       
 
         [0069]    Content provider performs the following tasks:
       1. Cancel subscription and recurring payment.   2. Notify customer via email of cancellation.   3a. Monthly term: no invoice/refund.   3b. Annual term: refund OurBusiness.       
 
         [0074]    For one embodiment, the flow chart shown in  FIGS. 2-3  outlines the data management processes/services for the OurBusiness order processing platform. 
         [0075]    The recommendation to use XML for receiving orders/cancellations from merchant will allow OurBusiness to provide merchants a flexible, but standardized method that does not require heavily customized approaches to support each content provider. This is especially important for merchants supporting multiple content providers. In addition, by using XML, OurBusiness can more readily perform file and data validation, as well as ensure proper data mapping to OurBusiness databases, without having to develop heavily customized routines to support each new merchant. Finally, XML has been fairly universally adopted and it is expected that most content providers will also prefer to use this format for data exchange, given its flexibility. 
         [0076]    The use of web services will allow OurBusiness to provide a secure (via SSL), real-time, 24×7 method to merchants for posting individual or batch orders/cancellations. The web services will also allow for online success/error responses to merchants. 
         [0077]    For one embodiment, the following refers to the steps numbered/described in  FIGS. 2-3 : 
         [0078]    1. Optional: Content provider sends OurBusiness a schema/sample data file that is used to develop a XSLT stylesheet for producing a customized XML or text file. Stylus Studio (www.stylusstudio.com) is an off-the-shelf solution to support XSLT generation. 
         [0079]    2. OurBusiness develops a XML Schema Document (XSD) for merchants by mapping content provider data to the OurBusiness database. This schema may be used by any merchant offering the content provider&#39;s subscription product. 
         [0080]    3. The merchant submits the XML file containing order/cancellation data to OurBusiness via a service (TBD: HTTP Post, REST, SOAP, XML-RPC) over a SSL-secured channel. Additional encryption of credit card (and other sensitive data) may be implemented as appropriate. 
         [0081]    4. The OurBusiness service will authenticate the merchant, validate the XML data file, return a success/error response, and process the order/cancellation data into the OurBusiness database. Credit card data will be encrypted, while stored in the database. 
         [0082]    5. A scheduled extraction process will pull all un-submitted orders/cancellations to produce a XML data file for each content provider. The extraction job will refer to mapping tables populated via the Admin tool, to translate data values stored in the OurBusiness database to those required by the content provider. 
         [0083]    6. The XML data file will be run through a XSLT processor for formatting to a content provider-specific output (XML or text file) using the XSLT stylesheet previously generated. 
         [0084]    Note: OurBusiness may offer the content provider the option of using the XML file, produced by the extraction job as a standardized offering, if the content provider does not have specific formatting requirements for the data. 
         [0085]    7. The XML or text file will be sent to the content provider to either an ftp server, or posted to a web service, provided by the content provider. The method of file transmission (including encryption) needs to be defined through direct discussion with the content provider. Alternatively, OurBusiness can designate an ftp server for posting these files that the content provider can access to process these files. 
       Order/Cancellation Receipt: 
       [0086]    In one embodiment, merchants will submit a XML file containing orders or cancellations to a OurBusiness service, either as individual items or in batch. The XML submission will be validated against the schema specifically configured for the content provider, and return a success/error response for the file. The validations will ensure that all required fields and pre-defined values/restrictions have been received from the merchant before the data is processed into the OurBusiness system, or sent to the content provider. 
         [0087]    The XML file will then be parsed and processed one item at a time via a schedule batch process. Error records will be split from valid records and sent back to a merchant contact via email for correction and re-submission. Processing these items in batch is an initial recommendation to manage system performance that can be re-evaluated based upon the anticipated order volume. 
       Order/Cancellation Extraction and Formatting 
       [0088]    Scheduled jobs will run every 15 minutes (as an example) to process new orders/cancellations posted to the OurBusiness database. The jobs will perform the following tasks:
       Extract un-submitted orders/cancellations for each content provider.   Translate fields/values per content provider specifications, using mapping defined via the Admin tool.   Format data into a standardized XML file.   Submit XML to the XSLT processor for conversion to a content provider-specified file format (XML or text) using the stylesheet built through the XSLT generator.       
 
         [0093]    A OurBusiness administration tool is provided to support the setup of new merchants and content providers, along with invoice management and reporting necessary to manage the order processing platform. The modules shown in  FIG. 4  are supported. 
         [0094]    The Merchant Management module will be used to add, view, and edit merchant profiles. A merchant profile will contain the following information: 
         [0095]    Merchant Name &amp; ID 
         [0096]    Merchant Address 
         [0097]    Contact Information
       Primary   Customer Service   Technical Support       
 
         [0101]    Subscription Services
       Content Provider Service   Commission Plan
           Monthly   Annual   
               
 
         [0106]    Invoice Schedule 
         [0107]    The Content Provider Management module will be used to add, view, and edit content provider profiles. In addition, screens will be provided to define the schema (XSD) used by merchants to submit orders/cancels to OurBusiness. These screens also establish the mapping between the OurBusiness fields/values to the fields/values required by the content provider. The content provider profile will contain the following: 
         [0108]    Content Provider Name &amp; ID 
         [0109]    Content Provider Address 
         [0110]    Contact Information
       Primary   Customer Service   Technical Support       
 
         [0114]    Invoice Schedule 
         [0115]    Services/Product Profile
       Category   Service/Product Name   Description   Pricing
           Monthly   Annual   
               
 
         [0122]    Create Schema
       Data Map
           Product/Service
               Orders   Cancellations   
               Format (XSLT template)   
               
 
         [0128]    The Create Schema screens is used to produce the schema (XSD) used by all merchants to submit orders and cancellation requests to OurBusiness. In addition, these screens will map the specific values required by the content provider to the standardized values within the OurBusiness database. 
         [0129]    The Order Management screens will be used by OurBusiness to research customer and order information to handle any customer service related matters. These screens provide view-only capabilities to identify orders/cancellations by merchant, customer, content provider, and/or date. All order details stored within the OurBusiness database will be available for viewing. 
         [0130]    The Invoice Management screens will be used by OurBusiness to manage both invoices received from content providers, as well as generate invoices to merchants. In addition, payment status will be maintained for these invoices. 
         [0131]    Invoices Generation: The generation of invoices to merchants/content providers will be managed by a schedule job that will produce an invoice containing all charges for the period. The ability to view and manually re-generate these invoices will also be provided. Once payment has been received, OurBusiness will manually update the payment status for the invoice. 
         [0132]    Invoice Receipt: Screens will be provided to allow OurBusiness to enter details for invoices received from merchants/content providers, as well as produce a payment check file for import into a third-party accounting software. The status of the invoice can be updated either manually or automatically, as a result of producing the check file. 
         [0133]    Note: Ideally, OurBusiness would arrange an agreement with merchants and content providers to allow for net invoicing, in order to avoid having to have merchants/content providers invoice OurBusiness for any refunds resulting from cancellations. 
         [0134]    The following general reporting is available for viewing and output (Word, Excel) through the Reporting module: 
         [0135]    Invoicing Reports—reports on the amounts (charges and refunds) invoiced or paid to merchants and content providers. 
         [0136]    Activity Reports—reports on the number of orders, cancellations, and errors processed by merchants and content providers. 
         [0137]    Note: Each report will be configurable to allow OurBusiness the ability to filter by merchant, content provider, and/or date range. 
         [0138]    The hardware recommendation (an example for system architecture) for the OurBusiness order processing platform is intended to provide an infrastructure that offers the level of security and performance necessary for a 24×7 e-commerce business. The following configuration is recommended: 
         [0139]    The firewall device provides network security, restricting access to predefined, secure clients only and to allowed ports. 
         [0140]    Load balanced devices allow for one server to be unavailable due to planned (e.g., software upgrade) or unplanned downtime (e.g., hard disk, crash.). 
         [0141]    The staging server provides pre-deployment testing and post-deployment problem analysis. 
         [0142]    A replicated database server allows for unplanned downtime and system maintenance similar to the load balanced web servers. 
       EXAMPLES  
       [0143]    (In the examples below, Buy.com is the Merchant and Audible.com is the Content Provider.) 
       Example 1  
     Flow of Data (Best Case Scenario—With No Errors—Monthly Charge Scenario)  
       [0144]    Customer buys Ipod at Buy.com for $100. 
         [0145]    At checkout he/she is offered a subscription to Audible.com at $10 per month. 
         [0146]    Customer buys both by credit card. 
         [0147]    Buy.com sends customer information including credit card info to OurBusiness. 
         [0148]    OurBusiness sends customer information including credit card info to Audible.com. 
         [0149]    Audible.com sends an email to the customer specifying username (usually email address) and password (usually order number). 
         [0150]    Second month onwards, Audible.com charges $10 per month to the credit card. (Note: We always need credit card information for monthly charge orders. In fact, gift cards cannot be used to buy monthly charge services; gift cards can only be used to buy annual charge services.) 
       Example 2  
     Monthly Charge Scenario (Best Case—With No Errors and No Cancellations)  
       [0151]    Assumption 1: Per Month Charge is $10. 
         [0152]    Assumption 2: The money splits as follows: 
         [0153]    Total 12 month charge $120:
       (Buy.com $10; OurBusiness $20; Audible.com $90)   Buy.com charges $10   Buy.com keeps the $10 charge   OurBusiness invoices $20 Audible.com   Audible.com invoices $10 for the next 11 months (that makes them $110, but after paying OurBusiness $20, their net is $90)       
 
       Example 3  
     Flow of Money  
       [0159]    Annual Charge Scenario (Best case—with no errors and no cancellations) 
         [0160]    Assumption 1: Annual charge is $100 
         [0161]    Assumption 2: The money splits as follows:
       Total 12 month charge $100   (Buy.com $30; OurBusiness $25; Audible.com $45)   Buy.com charges $100   OurBusiness invoices Buy.com $70, (So Buy.com nets $30)   Audible.com invoices $45 to OurBusiness. (So OurBusiness nets $25, which is $70−$45)       
 
       Example 4  
     TimeLine—Best Case Scenario 
       [0167]    10:01 AM Person goes to www.buy.com 
         [0168]    10:10 AM Person places order 
         [0169]    10:20 AM Buy.com puts the order on ftp location 
         [0170]    10:30 AM OurBusiness Input robot picks up the order 
         [0171]    10:31 AM OurBusiness system reformats the order using Audible.com-defined format 
         [0172]    10:32 AM OurBusiness Output robot sends the order to Audible.com 
         [0173]    10:33 AM Audible.com system creates a new subscription account 
         [0174]    10:34 AM Audible.com sends email to Customer, asking him/her to use order ID as password 
       Example 5  
     Cancellation Scenarios 
       [0175]    Monthly charge scenario—Cancellation within the first 30 days: 
         [0176]    Customer Point of View: Entire amount gets refunded: Nets zero 
         [0177]    Merchant Point of View: Refunds entire amount to customer: Nets zero. 
         [0178]    Content Provider Point of View: Pays OurBusiness $20 bounty: Loses $20 
         [0179]    OurBusiness Point of View: Still gets paid by Content Provider: Gains $20 
       Example 6  
     Monthly Charge Scenario—Cancellation After Initial 30 Days  
       [0180]    Customer Point of View: Is redirected to ContentProvider to cancel: Loses all money that has already been charged: but will not be charged after that cancellation.: Loses 10* n dollars 
         [0181]    Merchant Point of View: Doesn&#39;t need to do anything, just redirect customer, the initial $10 charged does not need to be refunded: Nets $10. 
         [0182]    Content Provider Point of View: Already paid OurBusiness $20 bounty, but was expecting to make $110 by charging from the 2 nd  to the 12 th  month, with a net of $90. If the cancellation happens within the 2 nd  month, loses $10. If cancellation happens in 3 rd  month, nets zero. If cancellation happens in the 4 th  month, nets $10. (in 5 th  month, nets $20, and so on.) 
         [0183]    OurBusiness Point of View: Still gets paid by Content Provider: Gains $20 
       Example 7  
     Annual Charge Scenario—Cancellation Within the First 30 Days  
       [0184]    Customer Point of View: Entire amount gets refunded: Nets zero 
         [0185]    Merchant Point of View: Refunds entire amount to customer: Nets zero. 
         [0186]    Content Provider Point of View: Gets refunded the $25 it paid OurBusiness as bounty: Nets zero 
         [0187]    OurBusiness Point of View: Refunds the $25 it was paid by the ContentProvider. Also refunds the Merchant any money received: Nets zero 
       Example 8  
     Annual Charge Scenario—Cancellation After Initial 30 Days  
       [0188]    Customer Point of View: Is redirected to ContentProvider to cancel where he/she is given a pro-rated refund: Loses (n/12*100) 
         [0189]    Merchant Point of View: Doesn&#39;t need to do anything, just redirect customer, the initial $100 minus $70 paid to OurBusiness does not need to be refunded: Nets $30. 
         [0190]    Content Provider Point of View: Already paid OurBusiness $25 bounty, but was expecting to net $45, after $30 for Merchant and $25 for OurBusiness. If the cancellation happens within 6 months, refunds $50 and loses $5. After that, if cancellation happens in any month thereafter, nets some money. 
         [0191]    OurBusiness Point of View: Still gets paid by Content Provider: Gains $25 
       Table Design—Examples  
       [0192]    Field types will be defined later, based on type of Text, number, currency, Yes/No fields 
       Table: Customers 
       [0193]    ID 
         [0194]    FirstName 
         [0195]    LastName 
         [0196]    Address 1   
         [0197]    Address 2   
         [0198]    City 
         [0199]    State 
         [0200]    Zip 
         [0201]    Country 
         [0202]    Email 
         [0203]    PhoneNumber 
       Table: Orders 
       [0204]    ID 
         [0205]    CustomerID (Lookup table: Customers) 
         [0206]    ShipToCustomerID (Lookup table: Customers) (If empty, then Customer is the same as ShipToCustomer) 
         [0207]    PaymentType (Lookup table: PaymentTypes, with values Credit Card, PayPal, etc.) 
         [0208]    PaymentAmount 
         [0209]    ServiceID (Lookup table: Services) 
         [0210]    CreditCardType (Lookup table: CreditCardTypes, with values MasterCard, Visa, etc.) 
         [0211]    CreditCardNumber 
         [0212]    CreditCardExpiry 
         [0213]    MerchantID (Lookup table: Merchants) 
         [0214]    MerchantTransactionID 
         [0215]    PromotionCode (Lookup table: Promotions) 
         [0216]    DateAndTimeCustomerPlacedOrder (at Merchant) 
         [0217]    DateAndTimeOrderReceivedByOurBusiness 
         [0218]    DateAndTimeOrderSentToContentProvider 
         [0219]    DateAndTimeOrderConfirmedByContentProvider 
       Table: Services 
       [0220]    ID 
         [0221]    ContentProviderID (Lookup Table: ContentProvider, e.g. Audible.com) 
         [0222]    Name (e.g. Audible.com Monthly Service, Audible.com Annual Service, Audible.com Plus Service, etc.) 
         [0223]    Term (LookupTable: Terms with values, Annual, Monthly) 
         [0224]    SKU 
       Table: Budget 
       [0225]    (For example, Service A: January 2007—budgeted volume 100, February 2007—budgeted volume 200, etc.) 
         [0226]    ID 
         [0227]    ServiceID (Lookup table: Services) 
         [0228]    MonthYear (e.g. January 2007, February 2007, March 2007, etc.) 
         [0229]    NumberOfSalesPerMonth (100, 200, 300, etc.) 
       Table: Merchants 
       [0230]    ID 
         [0231]    Name 
         [0232]    Address 1   
         [0233]    Address 2   
         [0234]    City 
         [0235]    State 
         [0236]    Zip 
         [0237]    Email 
         [0238]    Fax 
         [0239]    MonthlyServiceCommision (e.g. 100%—So for every $10 they charge they keep $10) 
         [0240]    AnnualServiceCommission (e.g. 20%—So for $100 they charge, they keep $20, we invoice $80) 
         [0241]    InvoiceDetails (e.g. Invoice every month, Invoice beginning of month) 
         [0242]    MainContactID (Lookup table: Contacts) (The highest level contact we have access to) 
         [0243]    InvoicingContactID (The person to whom we send invoices) 
         [0244]    EmailContactID (The person to whom we send invoices) 
         [0245]    CustomerServiceContactID (The person who can be contacted, if there is a Customer Service issue) 
         [0246]    TechContactID (The person to whom we take any tech issues) 
         [0247]    RefundDetails (To be taken care of later) 
       Table: Promotions 
       [0248]    ID 
         [0249]    Name (e.g. TabDisplay, Checkout offer, etc) 
         [0250]    MerchantID (Lookup table: Merchants) 
       Table: Contacts 
       [0251]    ID 
         [0252]    Type (Lookup table: ContactTypes: Merchant, Content Provider, Other) 
         [0253]    FirstName 
         [0254]    LastName 
         [0255]    Title 
         [0256]    Address 1   
         [0257]    Address 2   
         [0258]    City 
         [0259]    State 
         [0260]    Zip 
         [0261]    Email 
         [0262]    PhoneNumber 
         [0263]    Fax 
       Table: MerchantFormats 
       [0264]    ID 
         [0265]    FormatName 
         [0266]    FormatDetails (To be taken care of later) 
       Table: ContentProviders 
       [0267]    ID 
         [0268]    Name 
         [0269]    Address 1   
         [0270]    Address 2   
         [0271]    City 
         [0272]    State 
         [0273]    Zip 
         [0274]    Email 
         [0275]    Fax 
         [0276]    CategoryID (Lookup table: Categories) 
         [0277]    MonthlyServiceRate (Percentage of 12 month charge) 
         [0278]    AnnualServiceRate (Percentage of 12 month charge) 
         [0279]    InvoicingNotes (e.g. InvoiceEveryMonth,) 
       Table: ContentProviderFormats 
       [0280]    ID 
         [0281]    FormatName 
         [0282]    FormatDetails (To be taken care of later) 
       Table: Categories 
       [0283]    (Categories of Content Providers) 
         [0284]    ID 
         [0285]    Name (Technology, Sports, Music, etc) 
       Table: InvoiceMaster 
       [0286]    ID 
         [0287]    InvoiceNumber 
         [0288]    InvoiceDate 
         [0289]    InvoicedToID (Merchant/Content Provider) 
         [0290]    Paid (Yes/No) 
       Table: InvoiceDetail 
       [0291]    ID 
         [0292]    InvoiceMasterID (Lookup table: InvoiceMaster) 
         [0293]    ServiceID (Lookup table: Services) 
         [0294]    Description 
         [0295]    Qty 
         [0296]    Rate 
       Table: Payments 
       [0297]    ID 
         [0298]    PaymentFrom (could be Content provider or Merchant) 
         [0299]    PaymentDate 
         [0300]    InvoiceID (Lookup table: InvoiceMaster) 
         [0301]    PaymentAmount 
         [0302]    CheckNumber 
       Table: Refunds 
       [0303]    ID 
         [0304]    DateTimeRefundOrderReceived 
         [0305]    RefundOrderID (Lookup table: Orders) 
         [0306]    OriginalOrderID (Lookup table: Orders) 
         [0307]    AmountRefundedToCustomer (could full amount charged, or prorated refund) 
         [0308]    RefundRequestWithin30Days (Yes/No field) 
       Table: InvoicesReceivedMaster 
       [0309]    ID 
         [0310]    InvoiceNumber 
         [0311]    InvoiceDate 
         [0312]    InvoicedBy (Merchant/Content Provider) 
         [0313]    Paid (Yes/No) 
       Table: InvoicesReceivedDetail 
       [0314]    ID 
         [0315]    InvoiceMasterID (Lookup table: InvoiceMaster) 
         [0316]    ServiceID (Lookup table Services) 
         [0317]    Description 
         [0318]    Qty 
         [0319]    Rate 
       Table: PaymentsSent 
       [0320]    ID 
         [0321]    PaymentDate 
         [0322]    InvoiceID (Lookup table: InvoicesReceivedMaster) 
         [0323]    PaymentAmount 
         [0324]    CheckNumber 
       Table: ErrorCodes 
       [0325]    ID 
         [0326]    ErrorCode (e.g. E 101 , E 102 , E 103 , etc) 
         [0327]    ErrorDescription (e.g. No email address, No CreditCard provided, Duplicate from same merchant, Duplicate from another Merchant) 
       Table: HoldingTableIn 
       [0328]    (All incoming data from the Merchants will first land in this temporary table. Special code might be needed to put data into this table. After that, code would only be needed to be written to work of the holding table.) 
       Table: HoldingTableOut 
       [0329]    (All outgoing data from the Database to the Content Providers will first be put it into this temporary table. Special code might be needed to take data from this table into various formats.) 
       Report Design—Examples:  
     Service Listing By Content Provider 
       [0330]    Displays all services we can offer, sorted by Content Provider, a Total number of services offered is displayed, at end of report. 
       Service Listing By Merchants 
       [0331]    Displays all services we offer, sorted by Merchants who are offering them 
       Services Utilization 
       [0332]    Displays all services against number of merchants offering them. Highlights any merchants not offering any services, and also services not being offered on any merchant. Any product being offered in two places by the same Merchant is counted twice. 
       Invoicing report Content Providers—Example: 
       [0333]    Content Provider: New York Times 
         [0000]    
       
         
               
               
               
               
             
               
               
               
               
             
           
               
                   
               
               
                 Service 
                 NumberSold 
                 Commission 
                 Amount 
               
               
                   
               
             
             
               
                   
               
             
          
           
               
                 TimeSelect Monthly 
                 300 
                 $20 
                 $6000 
               
               
                 TimeSelect Annual 
                 10 
                 $25 
                 $250 
               
               
                 Total Amount Invoiced: 
                 $6250 
               
               
                   
               
             
          
         
       
     
       Accounts Receivable Report 
       [0334]    A report displaying how much money Merchants or Content Providers owe us. 
       Accounts Payable Report 
       [0335]    A report displaying how much money we have to pay Content Providers. 
       YTD Reports—ContentProvider Summary 
       [0336]    A report displaying dollars made from various categories of Content Providers, sorted by Months. 
         [0000]    
       
         
               
               
               
               
               
             
               
               
               
               
               
             
           
               
                   
                   
               
               
                   
                 January 
                 February 
                 March 
                 Total 
               
               
                   
                   
               
             
             
               
                   
               
             
          
           
               
                 NY Times 
                 $5,000 
                 $5,500 
                 $6,000 
                 $35,000 
               
               
                 Brittannica 
                 $8,600 
                 $8,700 
                 $9,000 
                 $40,000 
               
               
                 Audible.com 
                 $6,000 
                 $8,600 
                 $9,200 
                 $50,000 
               
               
                 — 
               
               
                 — 
               
               
                 Total 
                 $18,000 
                 $23,000 
                 $33,000 
                 $190,000 
               
               
                   
               
             
          
         
       
     
       YTD Reports—Merchant Summary 
       [0337]    A report displaying dollars made from various categories of Content Providers, sorted by Months. 
         [0000]    
       
         
               
               
               
               
             
               
               
               
               
               
             
           
               
                   
                   
               
               
                   
                 January 
                 February 
                 March 
               
               
                   
                   
               
             
             
               
                   
               
             
          
           
               
                   
                 Best Buy 
                 $8000 
                 $5500 
                 $6000 
               
               
                   
                 Buy.com 
                 $9600 
                 $9700 
                 $10000 
               
               
                   
                 Amazon.com 
                 $7000 
                 $8600 
                 $9200 
               
               
                   
                 — 
               
               
                   
                 — 
               
               
                   
                 Total 
                 $22000 
                 $33000 
                 $43000 
               
               
                   
                   
               
             
          
         
       
     
       YTD Reports—Top Three 
       [0338]    Top three performers by volume amongst Content Providers 
         [0339]    Top three performers by dollars amongst Content Providers 
         [0340]    Top three performers by volume amongst Merchants 
         [0341]    Top three performers by dollars amongst Merchants 
         [0342]    Top three most utilized Services by volume 
         [0343]    Top three most utilized Services by dollars 
       YTD Reports—Bottom Three 
       [0344]    Bottom three performers by volume amongst Content Providers 
         [0345]    Bottom three performers by dollars amongst Content Providers 
         [0346]    Bottom three performers by volume amongst Merchants 
         [0347]    Bottom three performers by dollars amongst Merchants 
         [0348]    Bottom three least utilized Services by volume 
         [0349]    Bottom three least utilized Services by dollars 
       Error Report by Content Provider 
       [0350]    Number and type of errors per Content Provider 
       Error Report by Merchants 
       [0351]    Number and type of errors per Merchant 
         [0352]    Refund report per Merchant 
         [0353]    Monthly Volume Report for Merchants 
         [0354]    Monthly Volume Report for Content Providers 
       Content Providers 
       [0355]    Allows adding/editing of all content providers, list, volume report, dollar report 
       Services 
       [0356]    Allows adding/editing of all services, list, volume report, dollar report 
       Customers 
       [0357]    Lookup Customers for customer service problems. 
       Merchants 
       [0358]    Allows adding/editing of all merchants, list, volume report, dollar report 
       Invoicing 
       [0359]    Generate invoices, Enter payments received, Enter invoices received, Create checks 
       Weekly Reports 
       [0360]    All YTD reports 
         [0361]    The teachings given above are just examples of the invention, and any variations of the embodiments and examples above are also intended to be covered and protected by the current patent disclosure.