WO2000022560A2 - Replenishment system and method for electronic commerce - Google Patents

Replenishment system and method for electronic commerce Download PDF

Info

Publication number
WO2000022560A2
WO2000022560A2 PCT/US1999/023590 US9923590W WO0022560A2 WO 2000022560 A2 WO2000022560 A2 WO 2000022560A2 US 9923590 W US9923590 W US 9923590W WO 0022560 A2 WO0022560 A2 WO 0022560A2
Authority
WO
WIPO (PCT)
Prior art keywords
customer
reorder
products
computer system
list
Prior art date
Application number
PCT/US1999/023590
Other languages
French (fr)
Other versions
WO2000022560A9 (en
WO2000022560A3 (en
Inventor
George A. Holt, Iii
Lehmann Li
Original Assignee
Indulge.Com
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Indulge.Com filed Critical Indulge.Com
Priority to AU64239/99A priority Critical patent/AU6423999A/en
Publication of WO2000022560A2 publication Critical patent/WO2000022560A2/en
Publication of WO2000022560A3 publication Critical patent/WO2000022560A3/en
Publication of WO2000022560A9 publication Critical patent/WO2000022560A9/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions

Definitions

  • the present invention relates generally to the transaction of commerce on a computer network, such as the Internet. More specifically, the present invention relates to the replenishment of products purchased through a computer network, such as the Internet.
  • Electronic commerce is quickly gaining popularity as an alternative method for selling and purchasing goods and services because e-commerce is able to provide benefits to both the merchant and the customer over traditional business practices. For example, for the merchant, e-commerce may help to reduce the costs and increase the efficiency of inventory management. For the customer, e- commerce may provide better prices and more personalized service.
  • e-commerce sites on the Web may be split into two categories: those selling consumable goods and those selling non-consumable goods and/or services.
  • Consumable goods are those goods that consumers use up or deplete, such as vitamins, shampoo, and disposable contact lenses, to give just a few examples.
  • Non- consumable goods are those goods that consumers do not use up or deplete (although they may eventually wear out or break down), such as books, music CDs, computers, and automobiles. Because of the nature of the goods it sells, a web site specializing in consumable goods has different user requirements than a web site specializing in non- consumable goods. For example, web sites specializing in consumable goods may attempt to provide some aid for a user to reorder supplies when supplies are expected to run low. In contrast, such aid is difficult, if not impossible, for non-consumable good suppliers.
  • the aids provided by the sites specializing in consumable goods have been in the form of historical lists of purchases or reminders based on simple reordering metrics. For example, some sites allow a user to recall a complete purchase history, including dates and description of purchases, which the user may then use to determine his or her needs. Additionally, one site allows a user to recall and reuse a past shopping list, to which additional items may be added and/or existing items may be deleted. Moreover, another site specializing in nutritional supplements provides email reminders to users, reminding them to reorder products.
  • the reminders are based on the daily recommended intake schedules of the actual products sold.
  • the aids provided by existing sites while somewhat helpful, have disadvantages.
  • the aid provided is passive in nature and thus requires significant consumer involvement in the reordering process. On these sites, a consumer must spend time recalling his or her historical list and must then analyze the list in some degree to determine his or her current needs.
  • the reminder may be untimely in many cases. For example, a consumer may not follow the daily recommended intake schedule or a consumer may buy a product for use by more than one person (e.g., for an entire family). In these cases, an email reminder based on daily recommended intake would be useless.
  • the first computer system has stored therein a database of products and a database of customers.
  • the second computer system has associated therewith an electronic address associated with a customer in the database of customers.
  • the method includes: receiving at the first computer system a selection of one or more products from the database of products from the customer; storing data in the first computer system indicating a reorder list for the customer responsive to the selection of one or more products; storing data in the first computer system indicating a reorder frequency for each of the one or more products in the reorder list; and transmitting an electronic notification over the network regarding at least one item in the reorder list responsive to the reorder frequency data associated with the at least one item.
  • the electronic notification is transmitted from the first computer system to the second computer system using the electronic address of the customer.
  • the electronic notification includes a reorder identifier uniquely associated with the customer and the reorder list.
  • the method may further include the step of receiving a communication at the first computer system from the customer that includes the reorder identifier to identify to the first computer system that the communication is in regard to the customer and the reorder list.
  • the network is the Internet and the electronic address is an email address.
  • the electronic notification is transmitted from the first computer system to the second computer system using the SMTP protocol.
  • the reorder identifier is a URL, which includes a base address and one or more appended arguments.
  • the base address may correspond to a CGI script or to an ASP server.
  • the reorder identifier may also be a URL that is included in an HTML page attached to the electronic notification.
  • the reorder identifier is uniquely associated with the electronic notification.
  • the reorder identifier is associated with a web page that includes information relating to the reorder list.
  • the method may further include the step of receiving at the first computer system data from the customer indicating a reorder frequency for each of the one or more products in the reorder list.
  • the step of storing data indicating a reorder frequency may comprise assigning a reorder frequency to at least one item in the reorder list based on consumption statistics for the at least one item.
  • the consumption statistics may be the average consumption of the at least one item by a group of people.
  • the consumption statistics may be based on the demographic characteristics of the customer.
  • the step of storing data indicating a reorder frequency may comprise assigning a reorder frequency to at least one item in the reorder list based on the past history of purchases of the customer.
  • the step of storing data indicating a reorder frequency may comprise assigning a reorder frequency to at least one item in the reorder list based on the past history of purchases of customers in the database of customers having similar profiles to the customer. The similar profiles may be based on demographic characteristics.
  • the method may further include the step of storing a voice message on a voice mail service of the customer, notifying the customer that the electronic notification has been transmitted. Additionally, the method may include the step of storing a voice message on an answering machine of the customer, notifying the customer that the electronic notification has been transmitted.
  • the database of customers includes a customer identifier and a customer password associated with the customer
  • the method further includes the steps of: receiving a communication by the first computer system over the network of the customer identifier and the customer password of the customer; receiving an additional selection of one or more products from the database of products from the customer; storing data in the first computer system indicating a shopping basket for the customer responsive to the additional selection of one or more products; and transferring at least one item from the shopping basket to the reorder list.
  • a data processing system for processing orders for products over a network coupled to at least one computer system.
  • the data processing system includes: a memory storage unit has stored therein a database of products and a database of customers, a customer in the database of customers has associated therewith an electronic address associated with the at least one computer system; means for receiving a selection of one or more products from the database of products from the customer; means for storing in the memory storage unit data indicating a reorder list for the customer responsive to the selection of one or more products; means for storing in the memory storage unit data indicating a reorder frequency for each of the one or more products in the reorder list; and means for transmitting from the data processing system to the at least one computer system an electronic notification over the network regarding at least one item in the reorder list responsive to the reorder frequency data associated with the at least one item.
  • the means for transmitting uses the electronic address of the customer.
  • the electronic notification includes a reorder identifier uniquely associated with the customer and the reorder list.
  • a system for ordering products over a network which includes: a first computer system coupled to the network, the first computer system having stored therein a database of products and a database of customers; a second computer system coupled to the network, the second computer system having associated therewith an electronic address associated with a customer in the database of customers; means for selecting one or more products from the database of products by the customer to establish a reorder list; means for associating a reorder frequency with each of the one or more products in the reorder list; means for storing each of the one or more products and its associated reorder frequency on the first computer system; and means for transmitting from the first computer system to the second computer system an electronic notification regarding at least one item in the reorder list based on the reorder frequency associated with the at least one item.
  • the means for transmitting uses the electronic address of the customer.
  • the electronic notification includes a reorder identifier uniquely associated with the customer and the reorder list.
  • Fig. 1 is a functional block diagram of a virtual store according to a preferred embodiment of the present invention
  • Fig. 2 is a diagram of a preferred embodiment of the main site page for a web site according to the present invention
  • Fig. 3 is an illustration of a preferred embodiment of the header frame of Fig.
  • Fig. 4 A is an illustration of a preferred embodiment of the browse frame of Fig. 2;
  • Fig. 4B is a web page including an example of a subcategory list
  • Fig. 4C is a web page including an example of a product list
  • Fig. 4D is a web page including an example of specific product information
  • Fig. 4E is a web page including another example of specific product information
  • Fig. 5 is a flowchart of the steps involved in browsing through the category and subcategory links for a specific product according to a preferred embodiment of the present invention
  • Fig. 6A is an illustration of a preferred embodiment of the shopping basket frame of Fig. 2, with the shopping basket empty;
  • Fig. 6B is an illustration of a preferred embodiment of the shopping basket frame of Fig. 2, with the shopping basket containing an item;
  • Fig. 7 is a flowchart of the steps of the check-out process according to a preferred embodiment of the present invention.
  • Fig. 8 A is an illustration of a web page containing fields for the entry of shipping information, according to a preferred embodiment of the present invention
  • Fig. 8B is an illustration of a web page for final purchase approval, according to a preferred embodiment of the present invention
  • Fig. 9 is an illustration of a web page containing order history information, according to a preferred embodiment of the present invention.
  • Fig. 10 is a flowchart of the steps for a login procedure according to a preferred embodiment of the present invention.
  • Fig. 11 is an illustration of a web page containing fields for the entry of login information, according to a preferred embodiment of the present invention.
  • Fig. 12 is an illustration of a web page containing fields for the entry of registration information, according to a preferred embodiment of the present invention.
  • Fig. 13A is an illustration of a web page containing fields for the entry of shipping information, according to a preferred embodiment of the present invention.
  • Fig. 13B is an illustration of a web page containing fields for the entry of payment information, according to a preferred embodiment of the present invention
  • Fig. 14 is an illustration of a web page containing options for monthly list editing, according to a preferred embodiment of the present invention
  • Fig. 15 is an illustration of a web page containing monthly list information, according to a preferred embodiment of the present invention.
  • Fig. 16A is an illustration of an email notification according to a preferred embodiment of the present invention.
  • Fig. 16B is another illustration of an email notification according to a preferred embodiment of the present invention.
  • Fig. 1 provides a functional block diagram of a virtual store according to a preferred embodiment of the present invention.
  • the virtual store of the present invention sells consumable goods, such as personal and healthcare products.
  • the virtual store includes a web site 10, an order fulfillment center 20, a web site administration and management center 30, a customer service headquarters 40, and a payment processing center 50.
  • all of these functions may be performed at a single location by a single organization, many of these functions (such as order fulfillment, web site management, customer service, and payment processing) may be contracted out to well-established independent third parties, who specialize in such functions.
  • information may be exchanged with such third parties through the Internet/public telephone network 60.
  • the web site 10 of the present invention comprises an automated process that depends on a collection of hardware and software.
  • the hardware includes server computers 100 to 105, such as the Compaq ProLiant 3000 Servers from Compaq Computer Corp. of Houston, Texas.
  • the server computers provide hot-swappable mirrored hard drives and power supplies.
  • the hardware also includes load balancing equipment 106, such as the Cisco LocalDirector product from Cisco Systems of San Jose, California. Load-balancing hardware allows multiple server computers to be represented by a single virtual IP address and balances Web requests to that IP address among the multiple servers running behind it.
  • load-balancing hardware allows the appearance of a single Web server to the Internet user, but behind the load-balancing hardware there may be many physical network servers acting in conjunction.
  • Load-balancing hardware also allows a web site to be easily scaled for greater web traffic by simply adding more physical servers.
  • the web site 10 also includes an ethernet switch 108, a firewall server 110, and a router 112, coupled in series as shown in Fig. 1.
  • the router 112 provides an interface between the Internet 60 and the internal network of the web site serviced by the ethernet switch 108.
  • the router may be, for example, the Cisco 7500 Series core router (Exodus N.O.C.) from Cisco Systems, Inc.
  • the ethernet switch 108 may be the Intel Express 510T from Intel Corporation.
  • the web site 10 may also include a modem 114 for communication through the telephone system with third party service providers who do not have Internet connectivity.
  • the modem 1 14 may be used a backup communication device with third party service providers who do have Internet connectivity.
  • the firewall server 110 positioned between the router 112 and the ethernet switch 108, provides the security features that are preferred for an online commerce application. These security features prevent unauthorized access to sensitive information such as inventory, customer information, and order history. Without security to protect it, this information might be used by non-authorized persons for criminal or malicious purposes.
  • Firewall servers are well-known in the industry.
  • a firewall server includes a workstation or server computer running firewall software.
  • the firewall workstation or server computer may be, for example, the Sun Ultra 5 from Sun Microsystems, Inc.
  • the firewall software preferably provides a good front end for managing security.
  • the firewall software preferably offers a stateful inspection mechanism, which utilizes communication-derived and application-derived state and context information. Stateful inspection makes it possible to upgrade a web site on a continuous basis, even as new protocols and applications become part of the Internet.
  • An example of firewall software that utilizes stateful inspection is Check Point Fire Wall- 1 software from Check Point Software Technologies, Ltd., of Redwood City, California.
  • the web site 10 preferably also utilizes Access Control Lists (ACLs) in its router 112 for inter-application server communication.
  • ACLs Access Control Lists
  • the web site 10 should also have the capability to encrypt all information if necessary.
  • the web site uses encryption whenever sensitive information is transmitted or data is likely to be snooped.
  • all web pages involving any customer information are preferably encrypted using Secure Sockets Layer (SSL), which is built into most web browsers.
  • SSL Secure Sockets Layer
  • the application environment of the virtual store according to the present invention can be best described as a web-enabled, multi-tier system. As the description indicates, there are multiple tiers involved in the application.
  • the first tier, or front end, is comprised of web browsers (not shown), such as Netscape Navigator from Netscape Corp. and Internet Explorer from Microsoft Corp., which are used by the customers of the virtual store.
  • the first tier includes the web pages that are visible with the web browsers.
  • the second or middle tier of the system includes one or more web servers 100.
  • the web servers 100 form the communication hub of the virtual store.
  • the web servers 100 assemble and provide the web pages viewed by customers with their web browsers.
  • the web servers are accessed at a unique address referred to as a Universal Resource Locator (URL).
  • URL Universal Resource Locator
  • the load balancing equipment 106 balances the web requests to this address among the multiple web servers.
  • An example of a URL for a web site's main page is "www.mybasics.com.”
  • the web pages generated by the web servers 100 are dynamic pages. Dynamic page generation allows the end user to receive a page incorporating both static and dynamic content.
  • the static content may include corporate logos, images and help information, while the dynamic content may include product, price, and customer account information.
  • the dynamic content of web pages typically is stored in a database.
  • the web servers 100 also provide the interface to the back-end systems that handle the data and the transactions associated with an electronic commerce site.
  • the web site 10 may include a database server 102 and an email server 104.
  • the database server 102 stores all customer account, customer order, and product information in relational databases.
  • the email server 104 allows email communication with customers.
  • the standby servers are used in case the normally functioning servers malfunction or are unavailable due to maintenance.
  • the web servers 100, database server 102, and email server 104 may run any well-known operating system and server software. For example, all of the servers may run the Microsoft Windows NT 4.0 operating system. In addition, the web servers 100 may run the Microsoft Internet Information Server (IIS) web server software.
  • the web server software may be enhanced by any well-known e-commerce software, such as Microsoft Site Server software, which provides the functionality necessary to build simple e-commerce sites, such as order processing and customer database wizards. If dynamic page generation is used, dynamic page generation software may be used, such as Microsoft Active Server Pages software, which is a component of the Microsoft Site Server software.
  • the database server 102 and standby database server 103 may run any well- known database software, such as Microsoft SQL 6.5 Server software.
  • the email server 104 and standby email server 105 may use any well-known SMTP-compatible email server software, such as SLmail software from Seattle Lab of Bothell, Washington.
  • a virtual store according to the present invention preferably offers at least two sales models.
  • a customer may make a one-time order.
  • the virtual store should provide this capability because most users will probably want to try a store's service before becoming a regular customer of the store.
  • the second sales model is that of the regular customer, who sets up a list of regular orders that are shipped periodically to the customer.
  • the customer can use the regular list to replenish consumable products with significantly less difficulty than reordering everything by browsing and searching.
  • the equivalent process in a physical store would be a customer walking in and having his or her shopping cart already filled with all the products he or she wants.
  • Fig. 2 illustrates the preferred components of the main site page for a web site according to the present invention.
  • the main site page includes three frames: a header frame 210, a browse frame 220, and a shopping basket frame 230.
  • Fig. 3 shows a preferred embodiment of the header frame 210 of Fig. 2.
  • the header frame 210 contains a login hyperlink 310 to a login page, an account/order hyperlink 320 to an account and order page, and a help/customer-service hyperlink 330 to a help and customer service information page.
  • the header frame 210 also includes a search prompt 340, which allows entry of a product name or keyword to search for on the web site.
  • the header frame 210 is included in every web page generated for the web site 10.
  • Fig. 4A shows a preferred embodiment of the browse frame 220.
  • the browse frame 220 contains a plurality of category hyperlinks 410 corresponding to the main product categories of the web site 10. Underneath each category hyperlink 410, there may be one or more levels of subcategory links 420.
  • the category and subcategory hyperlinks allow a user to shop for items by browsing through a hierarchical list of category and subcategory links until a specific product is found.
  • Fig. 5 provides a flowchart of exemplary steps involved in browsing through the category and subcategory links for a specific product.
  • the browse frame 220 (Fig. 4A) is displayed.
  • a category hyperlink 410 is selected from the browse frame 220
  • a list of subcategory hyperlinks 420 is displayed in step 510.
  • the subcategory list of Fig. 4B may be displayed in web page 400a.
  • a subcategory hyperlink 420 is selected in either steps 500 or 510, a product list for that subcategory is displayed in step 520.
  • a product list for that subcategory is displayed in step 520.
  • the product list of Fig. 4C may be displayed in web page 400b.
  • the product list preferably contains a product's description, size, and price.
  • a web page containing information about that specific product is displayed in step 530. Examples of web pages 400c and 400d for specific products are shown in Figs. 4D and 4E.
  • the specific product page includes an add-item hyperlink 430 and a quantity field 440.
  • the add-item hyperlink 430 allows a user to add an item to the user's shopping basket (shown in Fig. 4D) or to the user's monthly list (shown in Fig. 4E), both of which will be discussed in more detail below.
  • the quantity field 440 allows a user to select the number of an item to add to the shopping basket or monthly list.
  • the system checks, in step 540, whether the user is logged in to the web site 10. Preferably, the user must be logged in to the web site to add items to a shopping basket or a monthly list. Accordingly, if a user is not logged into the system, a login prompt (to be discussed more fully below) is displayed. If a user is logged in, the item selected by the user is added to the user's shopping basket or monthly list in step 550. The shopping basket frame or monthly list is then updated.
  • Figs. 6A and 6B show preferred embodiments of the shopping basket frame 230.
  • the shopping basket frame 230 contains a check-out hyperlink 610 for a check- out process, an empty-basket hyperlink 620 to empty the shopping basket, and an add- item hyperlink 630 to add items in the shopping basket to the user's monthly list.
  • the shopping basket contains a display area 640 for displaying the products currently in a user's shopping basket.
  • Fig. 6 A shows the display area 640 with a message indicating the basket is empty.
  • Fig. 6B shows the display area 640 when a product has placed in the shopping basket.
  • the display area 640 contains a quantity field 650 and an update hyperlink 660.
  • a user may edit the quantity of a product by entering a new quantity number in the quantity field 650 and selecting the update hyperlink 660. By entering a zero value in the quantity field 650, a product may be deleted from the shopping basket.
  • the shopping basket is maintained as long as a user is logged in to the web site and has not finished the check-out process. Items may be added at any time through the browsing procedure available through the browse frame or the search procedure available through the search prompt of the header frame. When items are placed in the basket, they may be edited or deleted from the basket at any time by entering a new quantity in the quantity field 650 and selecting the update link 660. The entire basket may also be deleted at any time by pressing the empty-basket hyperlink 620.
  • a user may also choose to add items in the shopping basket to a monthly list by selecting the add-item hyperlink 630. If the user decides to use the current basket to create or edit a monthly list, the system enters a monthly list management process, to be discussed below. Otherwise the user finishes adding items to the current basket and enters the check-out process by selecting the check-out hyperlink 610.
  • Fig. 7 shows a preferred embodiment of the steps of the check-out process.
  • step 700 when the check-out hyperlink 610 in the shopping basket has been selected, a shipping instructions page is displayed.
  • An example of such a web page 800a is shown in Fig. 8A.
  • the shipping instruction page contains a check box 805 indicating whether the user will accept partial shipments, a field 810 indicating the shipping method, and a name field 820, one or more address fields 830, and telephone number field 840.
  • the values in these fields default to the user's name, address, and telephone number (which is known once the user logs in to the system).
  • the shipping information page contains a continuation hyperlink 850, labeled "total,” which indicates that the user is finished entering the shipping information.
  • a final purchase approval page is displayed in step 710 (Fig. 7).
  • An example of the final purchase approval page 800b is shown in Fig. 8B.
  • the page contains purchase total information 860, credit card information 870, and billing information 880.
  • the page also contains a completion hyperlink 890, labeled "purchase,” which indicates completion of the purchase. Since some users may be concerned about providing credit card information over the Internet (even though such information is preferably encrypted), payment information may be provided instead to a customer service representative over the telephone.
  • Payment processing includes receiving an authorization for the purchase amount from the user's credit card institution. If authorization is received, in step 730, the user's order is registered and collected in a batch with other orders. The batches of orders are periodically transmitted to the order fulfillment center throughout a day. For example, the batches may be sent three times a day at 3 :00 PM, 10:00 PM, and 3 :00 AM. In step 740, a status message is displayed to the user indicating whether submission of the order was successful. If submission of the order was successful, a reference number for the order is returned to the user for tracking purposes or for other inquiries concerning the order.
  • a user may track and manage orders through the account/order hyperlink 320 (Fig. 3) of the header frame.
  • Fig. 9 shows a example of an account/order page 900 that is displayed when the account/order hyperlink 320 is selected.
  • the order/account page 900 contains the name of the user 910 (which is known to the system once the user logs in) and an order history list 920 for the user.
  • the order history list 920 preferably contains the order reference number, order date, purchase amount, status of the order, and the shipping tracking number.
  • the order/account page also contains an account hyperlink 930, which provides a user with the ability to update account information.
  • the order/account page also contains a continuation hyperlink 940, which allows a user to continue shopping on the web site.
  • a user prior to shopping, a user must login to the web site.
  • the login process identifies a user to the system.
  • the user may login by pressing the login hyperlink 310 in the header frame (Fig. 3).
  • a login prompt is automatically presented to the user.
  • Fig. 10 shows a flowchart of the steps for a preferred embodiment of the login procedure.
  • a login page is displayed.
  • An example of a such a page 1100 is shown in Fig. 11.
  • the login page contains an identification field 1110, such as a user's email address, and a password field 1120.
  • the login prompt also contains a completion hyperlink 1130, labeled "lookup,” which indicates that a user has finished entering the login information, and a registration hyperlink 1140 for new users.
  • the system queries the customer database (in the database servers) with the login information in step 1010.
  • step 1020 it is determined if the identification information has been found in the customer database and the password is correct. If the identification information has been found and the password is correct, in step 1040, the system checks whether the user was attempting to add an item to the shopping basket prior to logging in. If so, the item is added to the shopping basket in step 1150.
  • step 1070 the system returns the user to the last web page the user was viewing prior to logging in. If the user's identification information is not found in the customer database or the password is incorrect, an error message is displayed in step 1030.
  • the user When a user first visits the web site 10, the user preferably must register with the system prior to being able to shop or create a monthly list. New users may register at any time while browsing the site by selecting the login hyperlink 310 (Fig. 3) on the header frame and then selecting the registration hyperlink 1140 (Fig. 11) on the login prompt page. Preferably, registration is performed through a single web page, such as the page 1200 shown in Fig. 12. On the registration page, a user is preferably requested to enter such information as name 1210, email address 1220, password 1230, mailing address 1240 (which may be used as a default shipping and billing address), and telephone number 1250. When a user is finished entering registration information, a completion hyperlink 1260, labeled "register,” may be selected.
  • the registration procedure may allow a single user to set up multiple accounts, with multiple billing and shipping addresses (not shown in the figures).
  • Multiple billing and shipping addresses may be useful when a single user is responsible for shopping for multiple parties. For example, the child of a senior citizen may take on the responsibility for shopping for his or her parent as well as himself or herself. In this case, different orders may need to be shipped to different addresses.
  • the address to which an order should be shipped may be indicated by an account identification during the login procedure (not shown in the figures).
  • the web site allows a user to create a regular reorder list.
  • This list enables a user to easily manage items that the user orders on a regular basis. If a user has set up multiple accounts, the user may have multiple regular order lists, which are independent of each other.
  • Each item in the reorder list may have an independent cycle for replenishment. For instance, a user may create a list in which one item is reordered weekly, another is reordered monthly, and yet another is reordered every three months.
  • replenishment cycles in the system are based on a monthly unit of time. Month-based reordering is preferred to keep list management as simple as possible for both the user and the replenishment management system. Nonetheless, any reorder frequency may be used according to the present invention.
  • a monthly list is created or edited by selecting the add-item hyperlink 630 (Fig. 6) in the shopping basket, which is labeled "Add to Monthly List.” If a monthly list does not exist, a user is prompted to enter shipping and billing information in web pages 1300a and 1300b as shown in Figs. 13A and 13B, respectively. This information is the same as that requested during the check-out process, which was described with reference to Figs. 8 A and 8B. For those users concerned about transmitting billing information over the Internet, billing information may be submitted instead to a customer service representative using the telephone. This billing information may then be saved to the user's account, or the user may choose to resubmit the information using the telephone each and every time the monthly list is due for replenishment.
  • a monthly list already exists when a user selects the add- item hyperlink 630 the user is given three options as illustrated in Fig. 14.
  • the user may select one of the following hyperlinks in web page 1400: an add-basket hyperlink 1410, a replace-list hyperlink 1420, and an edit-list hyperlink 1430. If a user selects the add-basket hyperlink 1410, the items in the user's shopping basket are added to the user's monthly list. If a user selects the replace-list hyperlink 1420, the user's monthly list is replaced by the items in the user's shopping basket. If a user selects the edit-list hyperlink 1430, the user is simply transferred to his or her monthly list, which the user may then edit.
  • a user may edit his or her list through the account/order page 900 (Fig. 9).
  • the account/order page 900 may include a hyperlink to the user's monthly list (not shown in Fig. 9).
  • Fig. 15 shows a preferred embodiment of a user's monthly list.
  • the monthly list comprises a web page 1500 including several columns: a delete column 1510, an item column 1520, a quantity column 1530, a unit price column 1540, a frequency column 1550, a subtotal column 1560, and an estimated arrival column 1570.
  • the delete column 1510 allows a user to delete an item from the monthly list by selecting the hyperlink in that column for an item.
  • the item column 1520 provides a brief description of each item in the monthly list.
  • the quantity column 1530 provides a display of the number of an item to be shipped. The quantity of an item may be changed by selecting the appropriate "+" or "-" hyperlink in the quantity column.
  • the unit price column 1540 displays the unit price of an item.
  • the frequency column 1550 displays the reorder frequency of an item. The reorder frequency may be changed by selecting the appropriate "+" or "-” hyperlink in the frequency column.
  • the subtotal column 1560 provides the subtotal (the quantity times the unit price) for each item.
  • the estimated arrival column 1570 shows the next estimated date of arrival of each item. Each item is shipped soon after it is initially added to the monthly list. Thereafter, the shipping date is determined by the reorder frequency indicated in the frequency column 1550.
  • the monthly list also includes information 1575 regarding the total purchase amount for the entire list.
  • a hyperlink 1580 is included to change shipping and billing information.
  • Another hyperlink 1585 is included to save the monthly list.
  • Another hyperlink 1590 is included to add items to the monthly list. By selecting this hyperlink, a user is returned to the web site's main page, where the user may shop for more items by browsing or searching. When a user selects a specific product, however, a user is prompted to add the product to the monthly list, instead of to the shopping basket (see Fig. 4E).
  • a session can be defined as the series of steps or pages a user navigates while visiting a specific web site. Sites that require a user to log in, execute an ordered series of steps, and submit the transaction all revolve around the concept of a session.
  • state may be maintained throughout a session using various techniques. State may be maintained, for example, through the use of cookies.
  • a disadvantage in using cookies is the widespread public concern that cookies are an invasion of privacy because cookies are stored on a user's computer system and are readily available to any web site. Thus, it is possible for a web site to know the other web sites that a user has visited. Although users may choose not to accept cookies, rejecting cookies may cause web sites to become non-functional (i.e., unable to maintain state).
  • each web page that is transmitted to a user contains hyperlinks with unique URLs.
  • Each URL is unique to a user in that unique variable and value arguments are appended to a base URL.
  • the base URL is actually a script or program that processes the appended variable and value arguments.
  • Common Gateway Interface (CGI) programs are designed in such a manner. Special delimiters, such as a question mark, provide an indication as to the separation between the base URL and the appended variables and values.
  • the web server removes the appended variables and values and then transmits them to the program or script indicated in the base URL.
  • ASP Active Server Pages
  • CGI programs or scripts Microsoft's Active Server Pages
  • ASP is similar in concept to CGI programs, but provides more efficient use of computer resources than CGI programs. It should be noted that ASP involves dynamic content. That is, the URLs are generated dynamically by the ASP server, which communicates with the web server. The dynamic content is extracted from a database, while template HTML files, image files and the like are stored as static documents. The resulting dynamic page is generated from these pieces and returned to the user.
  • completion hyperlink 1595 When a user is finished editing the user's monthly list, the user selects a completion hyperlink 1595, labeled "Send Next Monthly Order.” (For first time users of monthly lists, the completion hyperlink 1595 may be labeled "Send First Monthly Order.")
  • This completion hyperlink 1595 causes the system to process the items that have been added or that are due for delivery in a similar manner to the check-out process that was described with respect to Fig. 7.
  • a user is not asked to enter shipping and billing information each time an order is processed; a user simply enters such information when the monthly list is first created (unless the user chooses to resubmit billing information over the telephone to a customer service representative each time an order is scheduled to be shipped).
  • the web site also includes an email notification system.
  • the email notification system works in conjunction with the customer account database stored in the database server. There are several email notifications that a customer can receive. An email notice may be sent immediately to a customer after an order has been successfully submitted for payment processing, thanking the customer for the order. A second email may be sent to the customer the following day, after the web site has received an order fulfillment summary from the order fulfillment center for the batches submitted on the previous day. This second email notifies the customer whether the order was successfully processed or whether any items were canceled due to problems with order fulfillment (such as inventory discrepancies at the warehouse facilities).
  • a customer who sets up a monthly list also receives a regular email notification a predetermined number of days before an item on the list is scheduled to be received by the customer. For example, a customer may receive an email notification five days before an item is scheduled to be received.
  • multiple email notifications may be sent to a customer. For example, an email notification may be sent twice: once ten days before an item is scheduled to be received and again five days before an item is scheduled to be received.
  • the email notification contains a unique embedded identifier that allows a customer to reorder the products on the regular list without going through the normal processes associated with ordering a product.
  • the identifier is unique in that it uniquely identifies the customer and is associated with the customer's monthly list.
  • the embedded identifier may be, for example, a hyperlink embedded in the email notification containing a unique URL that automatically logs a customer into the system and places the customer directly at the customer's monthly list page. This enables a customer to return to the web site instantaneously to confirm the order, without going through a logging in and selection process.
  • Figs. 16A and 16B provide examples of email notifications with unique hyperlinks embedded in them.
  • an email notification 1600a is shown as viewed with an email reader that does not support HTML text.
  • the email notification 1600a contains the URL of a hyperlink 1610.
  • the hyperlink 1610 contains a base address and appended arguments.
  • the base address is
  • Fig. 16B shows an email notification 1600b as viewed with an email reader that supports HTML text.
  • the hyperlink 1620 is not displayed as a URL, but is displayed instead as the label " «CLICK HERE»".
  • a customer would simply need to click on the hyperlink with a mouse pointer.
  • the email notification 1600b contains a URL similar to the URL of the email notification 1600a, but because of the sophistication of the email reader, the customer does not need to be bothered with the actual URL; the customer sees only a label associated with the URL.
  • Unique identifiers may be embedded in email notification in other ways.
  • the identifiers may also be part of an HTML page that is attached to the email.
  • the HTML page may contain information regarding the customer's monthly list, and the hyperlinks on the HTML page may be unique URLs that allow a customer to automatically login prior to performing a specified action associated with the hyperlinks, such as confirming the next order.
  • a failure to respond to the email by using the embedded identifier indicates that a user does not wish the order to be shipped.
  • the timing of the email notification is critical. On the one hand, if a customer does not believe that it is time to reorder when an email is received, the email may be ignored, in which case there is no further notification until the following cycle. On the other hand, if an email arrives too late, a customer may have gone to a physical store to replenish the needed items. Accordingly, it is greatly advantageous to assist a customer in setting up an accurate reorder frequency for each item.
  • a customer When a customer first creates a reorder list, the customer may not be knowledgeable about his or her consumption patterns and, thus, may not be able to provide an accurate reorder frequency.
  • a simple default reorder frequency may be used (for example, one month) for all items that the customer does not explicitly provide a value for, it is preferred to provide average household consumption statistics on an item-by-item basis for each item for which the customer does not explicitly provide a value.
  • Such statistics may be licensed, for example, from the ACNielson company of Stamford, Connecticut. Consumption statistics are available at the national, regional, and local levels, as well as by other demographics.
  • the consumption statistics used for each item are refined by using any pertinent demographic data available from a customer's account (e.g., the customer's geographic location, sex, age, etc.).
  • the web site preferably profiles the consumption of users and feeds that information into a replenishment expert system.
  • the replenishment expert system then is able to help a user refine the replenishment cycle of products on an itemized basis.
  • each user may be classified within a common profile group, and the group's usage statistics may be used as a starting point for a new user that is classified within the same group.
  • initial product replenishment cycles may also be based on users with similar profiles.
  • the usage patterns of the similar users who utilize the web site may be more accurate than general consumption statistics for average households.
  • the level of interaction between a user and the replenishment expert system may be varied.
  • a user may wish the replenishment expert system to simply suggest new replenishment cycles as time goes on, or a user may wish the replenishment expert system to automatically control the email notification system.
  • the replenishment expert system and email notification system establish a closed feedback loop, in which each continually drives the other to become more accurate.
  • the replenishment expert system may also be used with customers who enter single orders.
  • the products in a single order are no different from those in a monthly list, in that there may be average consumption statistics available for them.
  • an email notification may be sent to a single-order user.
  • the timeliness of this email notification is, of course, very important. If a customer receives such a notification at just the point in time when an item purchased is running low, the customer may be impressed by the timeliness of the notification and may become a regular user of the virtual store.
  • the email notifications are controlled by a scheduling utility provided by the operating system running on the servers.
  • Operating systems typically provide such scheduling utilities.
  • the "cron" utility allows a programmer to specify in a control file the times and dates a program should be executed.
  • the server software defines a "pipeline" model through which the workflow, interconnection, communication, and execution time of software modules are specified.
  • the order status and reorder notification emails are preferably scheduled with such a scheduling utility.
  • the scheduling utility may be configured to launch a program that looks for the order fulfillment summary file once a day (at a time when it is expected to have arrived). This program then reads the order fulfillment summary file and sends a status email (through the email server) to each customer who placed an order listed in the order fulfillment file.
  • the scheduling utility launches another program each day that queries the customer database.
  • the program queries the database for all customers who have a monthly list and are due for notification.
  • Customers will be due for notification a predefined number of days before an item in their monthly list is scheduled to be received (for example, five days). If a customer is due for notification, the customer's email address is retrieved from the customer's account, and an email reminder is constructed for that customer. As previously described, the email contains an embedded mechanism, such as a unique hypertext link, which allows the customer to return directly to his or her own monthly list page to confirm (and possibly edit) his or her order. If statistical and/or profiling is used to predict reorder frequency, each time a customer confirms and/or edits his or her monthly list, the replenishment expert system tracks this information to better estimate the customer's true replenishment needs. A similar program is also launched daily for those customers who have placed an order but do not have a monthly list. This program is scheduled to run daily and queries the database for customers who do not have a monthly list, have placed an order a predefined number of days previously (for example, twenty-five days previously), and have not received an email notification for the same order in the past.
  • This email is to impress the customer by the timeliness of the reminder and to entice the customer into creating a monthly list, rather than making single orders.
  • a web site according to the present invention provides an easy, convenient, and accurate way for customers to replenish products that they order on a regular basis.

Abstract

There is provided a system and method for processing orders for products through a network coupled to at least a first computer system and a second computer system. The first computer system has stored therein a database of products and a database of customers. The second computer system has associated therewith an electronic address, which is associated with a customer in the database of customers. The first computer system receives a selection of one or more products from the database of products from the customer. The first computer system then stores data indicating a reorder list for the customer responsive to the selection of one or more products. The first computer system also stores data indicating a reorder frequency for each of the one or more products in the reorder list. The first computer system then transmits to the second computer system an electronic notification over the network regarding at least one item in the reorder list responsive to the reorder frequency data associated with that at least one item. The electronic notification is transmitted using the electronic address of the customer. The electronic notification includes a reorder identifier uniquely associated with the customer and the reorder list.

Description

REPLENISHMENT SYSTEM AND METHOD FOR ELECTRONIC
COMMERCE
SPECIFICATION
BACKGROUND The present invention relates generally to the transaction of commerce on a computer network, such as the Internet. More specifically, the present invention relates to the replenishment of products purchased through a computer network, such as the Internet.
Electronic commerce (e-commerce) is quickly gaining popularity as an alternative method for selling and purchasing goods and services because e-commerce is able to provide benefits to both the merchant and the customer over traditional business practices. For example, for the merchant, e-commerce may help to reduce the costs and increase the efficiency of inventory management. For the customer, e- commerce may provide better prices and more personalized service. In recent years, an increasingly popular method of conducting e-commerce has been through the World Wide Web (the "Web") with the emergence of web sites specializing in a variety of products. For the purposes of this specification, e- commerce sites on the Web may be split into two categories: those selling consumable goods and those selling non-consumable goods and/or services. Consumable goods are those goods that consumers use up or deplete, such as vitamins, shampoo, and disposable contact lenses, to give just a few examples. Non- consumable goods are those goods that consumers do not use up or deplete (although they may eventually wear out or break down), such as books, music CDs, computers, and automobiles. Because of the nature of the goods it sells, a web site specializing in consumable goods has different user requirements than a web site specializing in non- consumable goods. For example, web sites specializing in consumable goods may attempt to provide some aid for a user to reorder supplies when supplies are expected to run low. In contrast, such aid is difficult, if not impossible, for non-consumable good suppliers. For example, while a bookstore web site obviously wants to entice a buyer to return to its site in the future, it is difficult to determine when the user should return as well as to suggest what the user should buy. Thus far, the aids provided by the sites specializing in consumable goods have been in the form of historical lists of purchases or reminders based on simple reordering metrics. For example, some sites allow a user to recall a complete purchase history, including dates and description of purchases, which the user may then use to determine his or her needs. Additionally, one site allows a user to recall and reuse a past shopping list, to which additional items may be added and/or existing items may be deleted. Moreover, another site specializing in nutritional supplements provides email reminders to users, reminding them to reorder products. The reminders are based on the daily recommended intake schedules of the actual products sold. The aids provided by existing sites, while somewhat helpful, have disadvantages. With regard to the sites providing historical purchase details, the aid provided is passive in nature and thus requires significant consumer involvement in the reordering process. On these sites, a consumer must spend time recalling his or her historical list and must then analyze the list in some degree to determine his or her current needs. With regard to an email reminder provided on the basis of the daily recommended intake of a product, the reminder may be untimely in many cases. For example, a consumer may not follow the daily recommended intake schedule or a consumer may buy a product for use by more than one person (e.g., for an entire family). In these cases, an email reminder based on daily recommended intake would be useless. Moreover, such an email reminder would not work with consumable products (such as shampoo or soap) that do not have a daily recommended intake schedule. Finally, even if such an email reminder were timely received, a consumer is required to spend time revisiting a site and reprocessing an order each time a product is needed. Accordingly, it is greatly desirable to provide a system and method that actively manages, simplifies, and facilitates the reordering and replenishment of consumable products.
SUMMARY OF THE INVENTION According to one aspect of the present invention, there is provided a method for processing orders for products through a network coupled to at least a first computer system and a second computer system. The first computer system has stored therein a database of products and a database of customers. The second computer system has associated therewith an electronic address associated with a customer in the database of customers. The method includes: receiving at the first computer system a selection of one or more products from the database of products from the customer; storing data in the first computer system indicating a reorder list for the customer responsive to the selection of one or more products; storing data in the first computer system indicating a reorder frequency for each of the one or more products in the reorder list; and transmitting an electronic notification over the network regarding at least one item in the reorder list responsive to the reorder frequency data associated with the at least one item. The electronic notification is transmitted from the first computer system to the second computer system using the electronic address of the customer. The electronic notification includes a reorder identifier uniquely associated with the customer and the reorder list.
The method may further include the step of receiving a communication at the first computer system from the customer that includes the reorder identifier to identify to the first computer system that the communication is in regard to the customer and the reorder list.
Preferably, the network is the Internet and the electronic address is an email address. Preferably, the electronic notification is transmitted from the first computer system to the second computer system using the SMTP protocol.
Preferably, the reorder identifier is a URL, which includes a base address and one or more appended arguments. The base address may correspond to a CGI script or to an ASP server. The reorder identifier may also be a URL that is included in an HTML page attached to the electronic notification. Preferably, the reorder identifier is uniquely associated with the electronic notification.
Preferably, the reorder identifier is associated with a web page that includes information relating to the reorder list. The method may further include the step of receiving at the first computer system data from the customer indicating a reorder frequency for each of the one or more products in the reorder list.
The step of storing data indicating a reorder frequency may comprise assigning a reorder frequency to at least one item in the reorder list based on consumption statistics for the at least one item. The consumption statistics may be the average consumption of the at least one item by a group of people. In addition, the consumption statistics may be based on the demographic characteristics of the customer.
The step of storing data indicating a reorder frequency may comprise assigning a reorder frequency to at least one item in the reorder list based on the past history of purchases of the customer. In addition, the step of storing data indicating a reorder frequency may comprise assigning a reorder frequency to at least one item in the reorder list based on the past history of purchases of customers in the database of customers having similar profiles to the customer. The similar profiles may be based on demographic characteristics.
The method may further include the step of storing a voice message on a voice mail service of the customer, notifying the customer that the electronic notification has been transmitted. Additionally, the method may include the step of storing a voice message on an answering machine of the customer, notifying the customer that the electronic notification has been transmitted.
Preferably, the database of customers includes a customer identifier and a customer password associated with the customer, and the method further includes the steps of: receiving a communication by the first computer system over the network of the customer identifier and the customer password of the customer; receiving an additional selection of one or more products from the database of products from the customer; storing data in the first computer system indicating a shopping basket for the customer responsive to the additional selection of one or more products; and transferring at least one item from the shopping basket to the reorder list.
In another aspect of the present invention, there is provided a data processing system for processing orders for products over a network coupled to at least one computer system. The data processing system includes: a memory storage unit has stored therein a database of products and a database of customers, a customer in the database of customers has associated therewith an electronic address associated with the at least one computer system; means for receiving a selection of one or more products from the database of products from the customer; means for storing in the memory storage unit data indicating a reorder list for the customer responsive to the selection of one or more products; means for storing in the memory storage unit data indicating a reorder frequency for each of the one or more products in the reorder list; and means for transmitting from the data processing system to the at least one computer system an electronic notification over the network regarding at least one item in the reorder list responsive to the reorder frequency data associated with the at least one item. The means for transmitting uses the electronic address of the customer. The electronic notification includes a reorder identifier uniquely associated with the customer and the reorder list.
In yet another aspect of the present invention, there is provided a system for ordering products over a network, which includes: a first computer system coupled to the network, the first computer system having stored therein a database of products and a database of customers; a second computer system coupled to the network, the second computer system having associated therewith an electronic address associated with a customer in the database of customers; means for selecting one or more products from the database of products by the customer to establish a reorder list; means for associating a reorder frequency with each of the one or more products in the reorder list; means for storing each of the one or more products and its associated reorder frequency on the first computer system; and means for transmitting from the first computer system to the second computer system an electronic notification regarding at least one item in the reorder list based on the reorder frequency associated with the at least one item. The means for transmitting uses the electronic address of the customer. The electronic notification includes a reorder identifier uniquely associated with the customer and the reorder list.
BRIEF DESCRIPTION OF THE DRAWINGS Exemplary embodiments of the present invention will now be described in detail with reference to the accompanying drawings in which:
Fig. 1 is a functional block diagram of a virtual store according to a preferred embodiment of the present invention;
Fig. 2 is a diagram of a preferred embodiment of the main site page for a web site according to the present invention; Fig. 3 is an illustration of a preferred embodiment of the header frame of Fig.
2;
Fig. 4 A is an illustration of a preferred embodiment of the browse frame of Fig. 2;
Fig. 4B is a web page including an example of a subcategory list; Fig. 4C is a web page including an example of a product list;
Fig. 4D is a web page including an example of specific product information; Fig. 4E is a web page including another example of specific product information;
Fig. 5 is a flowchart of the steps involved in browsing through the category and subcategory links for a specific product according to a preferred embodiment of the present invention;
Fig. 6A is an illustration of a preferred embodiment of the shopping basket frame of Fig. 2, with the shopping basket empty;
Fig. 6B is an illustration of a preferred embodiment of the shopping basket frame of Fig. 2, with the shopping basket containing an item;
Fig. 7 is a flowchart of the steps of the check-out process according to a preferred embodiment of the present invention;
Fig. 8 A is an illustration of a web page containing fields for the entry of shipping information, according to a preferred embodiment of the present invention; Fig. 8B is an illustration of a web page for final purchase approval, according to a preferred embodiment of the present invention;
Fig. 9 is an illustration of a web page containing order history information, according to a preferred embodiment of the present invention;
Fig. 10 is a flowchart of the steps for a login procedure according to a preferred embodiment of the present invention;
Fig. 11 is an illustration of a web page containing fields for the entry of login information, according to a preferred embodiment of the present invention;
Fig. 12 is an illustration of a web page containing fields for the entry of registration information, according to a preferred embodiment of the present invention;
Fig. 13A is an illustration of a web page containing fields for the entry of shipping information, according to a preferred embodiment of the present invention;
Fig. 13B is an illustration of a web page containing fields for the entry of payment information, according to a preferred embodiment of the present invention; Fig. 14 is an illustration of a web page containing options for monthly list editing, according to a preferred embodiment of the present invention;
Fig. 15 is an illustration of a web page containing monthly list information, according to a preferred embodiment of the present invention;
Fig. 16A is an illustration of an email notification according to a preferred embodiment of the present invention; and
Fig. 16B is another illustration of an email notification according to a preferred embodiment of the present invention.
DETAILED DESCRIPTION OF THE INVENTION Fig. 1 provides a functional block diagram of a virtual store according to a preferred embodiment of the present invention. Preferably, the virtual store of the present invention sells consumable goods, such as personal and healthcare products. The virtual store includes a web site 10, an order fulfillment center 20, a web site administration and management center 30, a customer service headquarters 40, and a payment processing center 50. Although all of these functions may be performed at a single location by a single organization, many of these functions (such as order fulfillment, web site management, customer service, and payment processing) may be contracted out to well-established independent third parties, who specialize in such functions. As shown in Fig. 1, information may be exchanged with such third parties through the Internet/public telephone network 60. The web site 10 of the present invention comprises an automated process that depends on a collection of hardware and software. As shown in Fig. 1, the hardware includes server computers 100 to 105, such as the Compaq ProLiant 3000 Servers from Compaq Computer Corp. of Houston, Texas. Preferably, the server computers provide hot-swappable mirrored hard drives and power supplies. The hardware also includes load balancing equipment 106, such as the Cisco LocalDirector product from Cisco Systems of San Jose, California. Load-balancing hardware allows multiple server computers to be represented by a single virtual IP address and balances Web requests to that IP address among the multiple servers running behind it. Thus, load- balancing hardware allows the appearance of a single Web server to the Internet user, but behind the load-balancing hardware there may be many physical network servers acting in conjunction. Load-balancing hardware also allows a web site to be easily scaled for greater web traffic by simply adding more physical servers.
The web site 10 also includes an ethernet switch 108, a firewall server 110, and a router 112, coupled in series as shown in Fig. 1. The router 112 provides an interface between the Internet 60 and the internal network of the web site serviced by the ethernet switch 108. The router may be, for example, the Cisco 7500 Series core router (Exodus N.O.C.) from Cisco Systems, Inc. The ethernet switch 108 may be the Intel Express 510T from Intel Corporation.
The web site 10 may also include a modem 114 for communication through the telephone system with third party service providers who do not have Internet connectivity. Alternatively, the modem 1 14 may be used a backup communication device with third party service providers who do have Internet connectivity.
The firewall server 110, positioned between the router 112 and the ethernet switch 108, provides the security features that are preferred for an online commerce application. These security features prevent unauthorized access to sensitive information such as inventory, customer information, and order history. Without security to protect it, this information might be used by non-authorized persons for criminal or malicious purposes.
Firewall servers are well-known in the industry. A firewall server includes a workstation or server computer running firewall software. The firewall workstation or server computer may be, for example, the Sun Ultra 5 from Sun Microsystems, Inc. The firewall software preferably provides a good front end for managing security. In addition, the firewall software preferably offers a stateful inspection mechanism, which utilizes communication-derived and application-derived state and context information. Stateful inspection makes it possible to upgrade a web site on a continuous basis, even as new protocols and applications become part of the Internet. An example of firewall software that utilizes stateful inspection is Check Point Fire Wall- 1 software from Check Point Software Technologies, Ltd., of Redwood City, California.
In addition to firewall software, the web site 10 preferably also utilizes Access Control Lists (ACLs) in its router 112 for inter-application server communication.
The web site 10 should also have the capability to encrypt all information if necessary. Preferably, the web site uses encryption whenever sensitive information is transmitted or data is likely to be snooped. For example, all web pages involving any customer information are preferably encrypted using Secure Sockets Layer (SSL), which is built into most web browsers.
The application environment of the virtual store according to the present invention can be best described as a web-enabled, multi-tier system. As the description indicates, there are multiple tiers involved in the application. The first tier, or front end, is comprised of web browsers (not shown), such as Netscape Navigator from Netscape Corp. and Internet Explorer from Microsoft Corp., which are used by the customers of the virtual store. The first tier includes the web pages that are visible with the web browsers.
The second or middle tier of the system includes one or more web servers 100. The web servers 100 form the communication hub of the virtual store. The web servers 100 assemble and provide the web pages viewed by customers with their web browsers. The web servers are accessed at a unique address referred to as a Universal Resource Locator (URL). (As discussed previously, the load balancing equipment 106 balances the web requests to this address among the multiple web servers.) An example of a URL for a web site's main page is "www.mybasics.com."
Preferably, the web pages generated by the web servers 100 are dynamic pages. Dynamic page generation allows the end user to receive a page incorporating both static and dynamic content. The static content may include corporate logos, images and help information, while the dynamic content may include product, price, and customer account information. The dynamic content of web pages typically is stored in a database. The web servers 100 also provide the interface to the back-end systems that handle the data and the transactions associated with an electronic commerce site. For example, the web site 10 may include a database server 102 and an email server 104. The database server 102 stores all customer account, customer order, and product information in relational databases. The email server 104 allows email communication with customers. Preferably, there is also provided a standby database server 103 and a standby email server 105. The standby servers are used in case the normally functioning servers malfunction or are unavailable due to maintenance.
The web servers 100, database server 102, and email server 104 may run any well-known operating system and server software. For example, all of the servers may run the Microsoft Windows NT 4.0 operating system. In addition, the web servers 100 may run the Microsoft Internet Information Server (IIS) web server software. The web server software may be enhanced by any well-known e-commerce software, such as Microsoft Site Server software, which provides the functionality necessary to build simple e-commerce sites, such as order processing and customer database wizards. If dynamic page generation is used, dynamic page generation software may be used, such as Microsoft Active Server Pages software, which is a component of the Microsoft Site Server software.
The database server 102 and standby database server 103 may run any well- known database software, such as Microsoft SQL 6.5 Server software. The email server 104 and standby email server 105 may use any well-known SMTP-compatible email server software, such as SLmail software from Seattle Lab of Bothell, Washington.
A virtual store according to the present invention preferably offers at least two sales models. In the first sales model, a customer may make a one-time order. The virtual store should provide this capability because most users will probably want to try a store's service before becoming a regular customer of the store. The second sales model is that of the regular customer, who sets up a list of regular orders that are shipped periodically to the customer. The customer can use the regular list to replenish consumable products with significantly less difficulty than reordering everything by browsing and searching. The equivalent process in a physical store would be a customer walking in and having his or her shopping cart already filled with all the products he or she wants.
The features of the web site 10 of Fig. 1 will now be discussed. The unique nature of a web application, in which every web page can provide hyperlinks to every other web page, makes it difficult to discuss functionality in a serial fashion. Nonetheless, this specification provides the basic features that customers utilize when executing a transaction on a web site according to the present invention. Each basic feature may be considered atomic in nature. Yet it must be realized that many of these features may be interlinked from many different web pages.
Fig. 2 illustrates the preferred components of the main site page for a web site according to the present invention. Preferably, the main site page includes three frames: a header frame 210, a browse frame 220, and a shopping basket frame 230.
Fig. 3 shows a preferred embodiment of the header frame 210 of Fig. 2. The header frame 210 contains a login hyperlink 310 to a login page, an account/order hyperlink 320 to an account and order page, and a help/customer-service hyperlink 330 to a help and customer service information page. The header frame 210 also includes a search prompt 340, which allows entry of a product name or keyword to search for on the web site. Preferably, the header frame 210 is included in every web page generated for the web site 10.
Fig. 4A shows a preferred embodiment of the browse frame 220. The browse frame 220 contains a plurality of category hyperlinks 410 corresponding to the main product categories of the web site 10. Underneath each category hyperlink 410, there may be one or more levels of subcategory links 420. The category and subcategory hyperlinks allow a user to shop for items by browsing through a hierarchical list of category and subcategory links until a specific product is found.
Fig. 5 provides a flowchart of exemplary steps involved in browsing through the category and subcategory links for a specific product. In step 500, the browse frame 220 (Fig. 4A) is displayed. When a category hyperlink 410 is selected from the browse frame 220, a list of subcategory hyperlinks 420 is displayed in step 510. For example, by selecting the "Men's Products" category hyperlink in Fig. 4A, the subcategory list of Fig. 4B may be displayed in web page 400a. When a subcategory hyperlink 420 is selected in either steps 500 or 510, a product list for that subcategory is displayed in step 520. For example, by selecting the "Razors and Blades" subcategory hyperlink in Fig. 4B, the product list of Fig. 4C may be displayed in web page 400b. As shown in Fig. 4C, the product list preferably contains a product's description, size, and price. At this point, by selecting a specific product from the product list, a web page containing information about that specific product is displayed in step 530. Examples of web pages 400c and 400d for specific products are shown in Figs. 4D and 4E.
In addition to information about a product, the specific product page includes an add-item hyperlink 430 and a quantity field 440. The add-item hyperlink 430 allows a user to add an item to the user's shopping basket (shown in Fig. 4D) or to the user's monthly list (shown in Fig. 4E), both of which will be discussed in more detail below. The quantity field 440 allows a user to select the number of an item to add to the shopping basket or monthly list.
If a user selects the add-item hyperlink 430, the system checks, in step 540, whether the user is logged in to the web site 10. Preferably, the user must be logged in to the web site to add items to a shopping basket or a monthly list. Accordingly, if a user is not logged into the system, a login prompt (to be discussed more fully below) is displayed. If a user is logged in, the item selected by the user is added to the user's shopping basket or monthly list in step 550. The shopping basket frame or monthly list is then updated. Figs. 6A and 6B show preferred embodiments of the shopping basket frame 230. The shopping basket frame 230 contains a check-out hyperlink 610 for a check- out process, an empty-basket hyperlink 620 to empty the shopping basket, and an add- item hyperlink 630 to add items in the shopping basket to the user's monthly list. In addition, the shopping basket contains a display area 640 for displaying the products currently in a user's shopping basket. Fig. 6 A shows the display area 640 with a message indicating the basket is empty. Fig. 6B shows the display area 640 when a product has placed in the shopping basket. When a product has been placed in the shopping basket, the display area 640 contains a quantity field 650 and an update hyperlink 660. A user may edit the quantity of a product by entering a new quantity number in the quantity field 650 and selecting the update hyperlink 660. By entering a zero value in the quantity field 650, a product may be deleted from the shopping basket.
The shopping basket is maintained as long as a user is logged in to the web site and has not finished the check-out process. Items may be added at any time through the browsing procedure available through the browse frame or the search procedure available through the search prompt of the header frame. When items are placed in the basket, they may be edited or deleted from the basket at any time by entering a new quantity in the quantity field 650 and selecting the update link 660. The entire basket may also be deleted at any time by pressing the empty-basket hyperlink 620.
A user may also choose to add items in the shopping basket to a monthly list by selecting the add-item hyperlink 630. If the user decides to use the current basket to create or edit a monthly list, the system enters a monthly list management process, to be discussed below. Otherwise the user finishes adding items to the current basket and enters the check-out process by selecting the check-out hyperlink 610.
Fig. 7 shows a preferred embodiment of the steps of the check-out process. In step 700, when the check-out hyperlink 610 in the shopping basket has been selected, a shipping instructions page is displayed. An example of such a web page 800a is shown in Fig. 8A. The shipping instruction page contains a check box 805 indicating whether the user will accept partial shipments, a field 810 indicating the shipping method, and a name field 820, one or more address fields 830, and telephone number field 840. Preferably, the values in these fields default to the user's name, address, and telephone number (which is known once the user logs in to the system).
The shipping information page contains a continuation hyperlink 850, labeled "total," which indicates that the user is finished entering the shipping information. When this hyperlink is selected, a final purchase approval page is displayed in step 710 (Fig. 7). An example of the final purchase approval page 800b is shown in Fig. 8B. The page contains purchase total information 860, credit card information 870, and billing information 880. The page also contains a completion hyperlink 890, labeled "purchase," which indicates completion of the purchase. Since some users may be concerned about providing credit card information over the Internet (even though such information is preferably encrypted), payment information may be provided instead to a customer service representative over the telephone.
Returning to Fig. 7, when a user selects the completion hyperlink 880, payment processing is performed in step 720. Payment processing includes receiving an authorization for the purchase amount from the user's credit card institution. If authorization is received, in step 730, the user's order is registered and collected in a batch with other orders. The batches of orders are periodically transmitted to the order fulfillment center throughout a day. For example, the batches may be sent three times a day at 3 :00 PM, 10:00 PM, and 3 :00 AM. In step 740, a status message is displayed to the user indicating whether submission of the order was successful. If submission of the order was successful, a reference number for the order is returned to the user for tracking purposes or for other inquiries concerning the order.
A user may track and manage orders through the account/order hyperlink 320 (Fig. 3) of the header frame. Fig. 9 shows a example of an account/order page 900 that is displayed when the account/order hyperlink 320 is selected. The order/account page 900 contains the name of the user 910 (which is known to the system once the user logs in) and an order history list 920 for the user. The order history list 920 preferably contains the order reference number, order date, purchase amount, status of the order, and the shipping tracking number. The order/account page also contains an account hyperlink 930, which provides a user with the ability to update account information. The order/account page also contains a continuation hyperlink 940, which allows a user to continue shopping on the web site.
Preferably, prior to shopping, a user must login to the web site. The login process identifies a user to the system. The user may login by pressing the login hyperlink 310 in the header frame (Fig. 3). Alternatively, if a user attempts to add an item to the shopping basket before logging in, a login prompt is automatically presented to the user.
Fig. 10 shows a flowchart of the steps for a preferred embodiment of the login procedure. In step 1000, a login page is displayed. An example of a such a page 1100 is shown in Fig. 11. The login page contains an identification field 1110, such as a user's email address, and a password field 1120. The login prompt also contains a completion hyperlink 1130, labeled "lookup," which indicates that a user has finished entering the login information, and a registration hyperlink 1140 for new users.
When a user selects the completion hyperlink 1130, the system queries the customer database (in the database servers) with the login information in step 1010. In step 1020, it is determined if the identification information has been found in the customer database and the password is correct. If the identification information has been found and the password is correct, in step 1040, the system checks whether the user was attempting to add an item to the shopping basket prior to logging in. If so, the item is added to the shopping basket in step 1150. In step 1070, the system returns the user to the last web page the user was viewing prior to logging in. If the user's identification information is not found in the customer database or the password is incorrect, an error message is displayed in step 1030.
When a user first visits the web site 10, the user preferably must register with the system prior to being able to shop or create a monthly list. New users may register at any time while browsing the site by selecting the login hyperlink 310 (Fig. 3) on the header frame and then selecting the registration hyperlink 1140 (Fig. 11) on the login prompt page. Preferably, registration is performed through a single web page, such as the page 1200 shown in Fig. 12. On the registration page, a user is preferably requested to enter such information as name 1210, email address 1220, password 1230, mailing address 1240 (which may be used as a default shipping and billing address), and telephone number 1250. When a user is finished entering registration information, a completion hyperlink 1260, labeled "register," may be selected. Optionally, the registration procedure may allow a single user to set up multiple accounts, with multiple billing and shipping addresses (not shown in the figures). Multiple billing and shipping addresses may be useful when a single user is responsible for shopping for multiple parties. For example, the child of a senior citizen may take on the responsibility for shopping for his or her parent as well as himself or herself. In this case, different orders may need to be shipped to different addresses. When multiple accounts are set up, the address to which an order should be shipped may be indicated by an account identification during the login procedure (not shown in the figures).
Advantageously, according to the present invention, the web site allows a user to create a regular reorder list. This list enables a user to easily manage items that the user orders on a regular basis. If a user has set up multiple accounts, the user may have multiple regular order lists, which are independent of each other.
Each item in the reorder list may have an independent cycle for replenishment. For instance, a user may create a list in which one item is reordered weekly, another is reordered monthly, and yet another is reordered every three months. Preferably, though, replenishment cycles in the system are based on a monthly unit of time. Month-based reordering is preferred to keep list management as simple as possible for both the user and the replenishment management system. Nonetheless, any reorder frequency may be used according to the present invention.
Once a customer creates a monthly list, that customer need never order using a shopping basket again. While it is possible for the customer to return and put in single orders at any time, it is also possible for the customer to place all subsequent orders by adding, removing, and re-timing items on the monthly list.
A monthly list is created or edited by selecting the add-item hyperlink 630 (Fig. 6) in the shopping basket, which is labeled "Add to Monthly List." If a monthly list does not exist, a user is prompted to enter shipping and billing information in web pages 1300a and 1300b as shown in Figs. 13A and 13B, respectively. This information is the same as that requested during the check-out process, which was described with reference to Figs. 8 A and 8B. For those users concerned about transmitting billing information over the Internet, billing information may be submitted instead to a customer service representative using the telephone. This billing information may then be saved to the user's account, or the user may choose to resubmit the information using the telephone each and every time the monthly list is due for replenishment.
If a monthly list already exists when a user selects the add- item hyperlink 630, the user is given three options as illustrated in Fig. 14. The user may select one of the following hyperlinks in web page 1400: an add-basket hyperlink 1410, a replace-list hyperlink 1420, and an edit-list hyperlink 1430. If a user selects the add-basket hyperlink 1410, the items in the user's shopping basket are added to the user's monthly list. If a user selects the replace-list hyperlink 1420, the user's monthly list is replaced by the items in the user's shopping basket. If a user selects the edit-list hyperlink 1430, the user is simply transferred to his or her monthly list, which the user may then edit.
Alternatively, if a monthly list already exists, a user may edit his or her list through the account/order page 900 (Fig. 9). In this case, the account/order page 900 may include a hyperlink to the user's monthly list (not shown in Fig. 9).
Fig. 15 shows a preferred embodiment of a user's monthly list. The monthly list comprises a web page 1500 including several columns: a delete column 1510, an item column 1520, a quantity column 1530, a unit price column 1540, a frequency column 1550, a subtotal column 1560, and an estimated arrival column 1570. The delete column 1510 allows a user to delete an item from the monthly list by selecting the hyperlink in that column for an item. The item column 1520 provides a brief description of each item in the monthly list. The quantity column 1530 provides a display of the number of an item to be shipped. The quantity of an item may be changed by selecting the appropriate "+" or "-" hyperlink in the quantity column. The unit price column 1540 displays the unit price of an item. The frequency column 1550 displays the reorder frequency of an item. The reorder frequency may be changed by selecting the appropriate "+" or "-" hyperlink in the frequency column.
The subtotal column 1560 provides the subtotal (the quantity times the unit price) for each item. The estimated arrival column 1570 shows the next estimated date of arrival of each item. Each item is shipped soon after it is initially added to the monthly list. Thereafter, the shipping date is determined by the reorder frequency indicated in the frequency column 1550. The monthly list also includes information 1575 regarding the total purchase amount for the entire list. A hyperlink 1580 is included to change shipping and billing information. Another hyperlink 1585 is included to save the monthly list. Another hyperlink 1590 is included to add items to the monthly list. By selecting this hyperlink, a user is returned to the web site's main page, where the user may shop for more items by browsing or searching. When a user selects a specific product, however, a user is prompted to add the product to the monthly list, instead of to the shopping basket (see Fig. 4E).
To distinguish between a user who is selecting items for a monthly list and a user who is selecting items for a shopping basket, the web site must maintain the state of a user session. A session can be defined as the series of steps or pages a user navigates while visiting a specific web site. Sites that require a user to log in, execute an ordered series of steps, and submit the transaction all revolve around the concept of a session.
Although the Web is based on the HTTP protocol, which is stateless, state may be maintained throughout a session using various techniques. State may be maintained, for example, through the use of cookies. A disadvantage in using cookies, however, is the widespread public concern that cookies are an invasion of privacy because cookies are stored on a user's computer system and are readily available to any web site. Thus, it is possible for a web site to know the other web sites that a user has visited. Although users may choose not to accept cookies, rejecting cookies may cause web sites to become non-functional (i.e., unable to maintain state).
Another technique to maintain state on the Web is through the use of the URL with variables and arguments. In this technique, each web page that is transmitted to a user contains hyperlinks with unique URLs. Each URL is unique to a user in that unique variable and value arguments are appended to a base URL. The base URL is actually a script or program that processes the appended variable and value arguments. Common Gateway Interface (CGI) programs are designed in such a manner. Special delimiters, such as a question mark, provide an indication as to the separation between the base URL and the appended variables and values. The web server removes the appended variables and values and then transmits them to the program or script indicated in the base URL.
Instead of CGI programs or scripts, Microsoft's Active Server Pages (ASP) technology may be used. ASP is similar in concept to CGI programs, but provides more efficient use of computer resources than CGI programs. It should be noted that ASP involves dynamic content. That is, the URLs are generated dynamically by the ASP server, which communicates with the web server. The dynamic content is extracted from a database, while template HTML files, image files and the like are stored as static documents. The resulting dynamic page is generated from these pieces and returned to the user. When a user is finished editing the user's monthly list, the user selects a completion hyperlink 1595, labeled "Send Next Monthly Order." (For first time users of monthly lists, the completion hyperlink 1595 may be labeled "Send First Monthly Order.") This completion hyperlink 1595 causes the system to process the items that have been added or that are due for delivery in a similar manner to the check-out process that was described with respect to Fig. 7. In the case of a monthly list, however, a user is not asked to enter shipping and billing information each time an order is processed; a user simply enters such information when the monthly list is first created (unless the user chooses to resubmit billing information over the telephone to a customer service representative each time an order is scheduled to be shipped). Advantageously, according to the present invention, the web site also includes an email notification system. The email notification system works in conjunction with the customer account database stored in the database server. There are several email notifications that a customer can receive. An email notice may be sent immediately to a customer after an order has been successfully submitted for payment processing, thanking the customer for the order. A second email may be sent to the customer the following day, after the web site has received an order fulfillment summary from the order fulfillment center for the batches submitted on the previous day. This second email notifies the customer whether the order was successfully processed or whether any items were canceled due to problems with order fulfillment (such as inventory discrepancies at the warehouse facilities). Advantageously, a customer who sets up a monthly list also receives a regular email notification a predetermined number of days before an item on the list is scheduled to be received by the customer. For example, a customer may receive an email notification five days before an item is scheduled to be received. Optionally, multiple email notifications may be sent to a customer. For example, an email notification may be sent twice: once ten days before an item is scheduled to be received and again five days before an item is scheduled to be received.
The email notification contains a unique embedded identifier that allows a customer to reorder the products on the regular list without going through the normal processes associated with ordering a product. The identifier is unique in that it uniquely identifies the customer and is associated with the customer's monthly list. The embedded identifier may be, for example, a hyperlink embedded in the email notification containing a unique URL that automatically logs a customer into the system and places the customer directly at the customer's monthly list page. This enables a customer to return to the web site instantaneously to confirm the order, without going through a logging in and selection process.
Figs. 16A and 16B provide examples of email notifications with unique hyperlinks embedded in them. In Fig. 16A, an email notification 1600a is shown as viewed with an email reader that does not support HTML text. The email notification 1600a contains the URL of a hyperlink 1610. The hyperlink 1610 contains a base address and appended arguments. The base address is
"http://wvvw.mybasics.com/mybasics/frame.asp," which refers to an ASP server. The base address is separated from the appended arguments by a question mark. The appended arguments are further delimited by the ampersand. Together, the appended arguments uniquely identify the customer and the customer's monthly list page. To use the URL, a customer may copy the URL into his or web browser. Fig. 16B shows an email notification 1600b as viewed with an email reader that supports HTML text. In this case, the hyperlink 1620 is not displayed as a URL, but is displayed instead as the label "«CLICK HERE»". To use the hyperlink 1620, a customer would simply need to click on the hyperlink with a mouse pointer. Of course, the email notification 1600b contains a URL similar to the URL of the email notification 1600a, but because of the sophistication of the email reader, the customer does not need to be bothered with the actual URL; the customer sees only a label associated with the URL.
Unique identifiers may be embedded in email notification in other ways. For example, the identifiers may also be part of an HTML page that is attached to the email. The HTML page may contain information regarding the customer's monthly list, and the hyperlinks on the HTML page may be unique URLs that allow a customer to automatically login prior to performing a specified action associated with the hyperlinks, such as confirming the next order. In each of the cases described above, a failure to respond to the email by using the embedded identifier indicates that a user does not wish the order to be shipped.
In addition, because most people have a voice mail service at work and/or an answering machine at home, which may be checked more often than their email, it may be desirable to leave a voice message with one of these services to alert a user that an email notification has been sent.
The timing of the email notification is critical. On the one hand, if a customer does not believe that it is time to reorder when an email is received, the email may be ignored, in which case there is no further notification until the following cycle. On the other hand, if an email arrives too late, a customer may have gone to a physical store to replenish the needed items. Accordingly, it is greatly advantageous to assist a customer in setting up an accurate reorder frequency for each item.
When a customer first creates a reorder list, the customer may not be knowledgeable about his or her consumption patterns and, thus, may not be able to provide an accurate reorder frequency. Although a simple default reorder frequency may be used (for example, one month) for all items that the customer does not explicitly provide a value for, it is preferred to provide average household consumption statistics on an item-by-item basis for each item for which the customer does not explicitly provide a value. Such statistics may be licensed, for example, from the ACNielson company of Stamford, Connecticut. Consumption statistics are available at the national, regional, and local levels, as well as by other demographics. Preferably, to best assist the customer in setting up a reorder frequency for each item, the consumption statistics used for each item are refined by using any pertinent demographic data available from a customer's account (e.g., the customer's geographic location, sex, age, etc.).
Once a customer begins ordering from the web site regularly, individual profiling becomes possible to better assist the customer in setting up accurate reorder frequencies. Therefore, the web site preferably profiles the consumption of users and feeds that information into a replenishment expert system. The replenishment expert system then is able to help a user refine the replenishment cycle of products on an itemized basis. Additionally, each user may be classified within a common profile group, and the group's usage statistics may be used as a starting point for a new user that is classified within the same group. Thus, as more consumers utilize the web site service, initial product replenishment cycles may also be based on users with similar profiles. The usage patterns of the similar users who utilize the web site may be more accurate than general consumption statistics for average households.
The level of interaction between a user and the replenishment expert system may be varied. A user may wish the replenishment expert system to simply suggest new replenishment cycles as time goes on, or a user may wish the replenishment expert system to automatically control the email notification system. In each case, the replenishment expert system and email notification system establish a closed feedback loop, in which each continually drives the other to become more accurate.
The replenishment expert system may also be used with customers who enter single orders. The products in a single order are no different from those in a monthly list, in that there may be average consumption statistics available for them. Thus, an email notification may be sent to a single-order user. The timeliness of this email notification is, of course, very important. If a customer receives such a notification at just the point in time when an item purchased is running low, the customer may be impressed by the timeliness of the notification and may become a regular user of the virtual store.
Preferably, the email notifications are controlled by a scheduling utility provided by the operating system running on the servers. Operating systems typically provide such scheduling utilities. For example, under the Unix operating system, the "cron" utility allows a programmer to specify in a control file the times and dates a program should be executed. In a server configuration with servers running the Microsoft Site Server software and the Windows NT 4.0 operating system, the server software defines a "pipeline" model through which the workflow, interconnection, communication, and execution time of software modules are specified.
The order status and reorder notification emails are preferably scheduled with such a scheduling utility. For the order status email, the scheduling utility may be configured to launch a program that looks for the order fulfillment summary file once a day (at a time when it is expected to have arrived). This program then reads the order fulfillment summary file and sends a status email (through the email server) to each customer who placed an order listed in the order fulfillment file.
For the reorder notification email, the scheduling utility launches another program each day that queries the customer database. The program queries the database for all customers who have a monthly list and are due for notification.
Customers will be due for notification a predefined number of days before an item in their monthly list is scheduled to be received (for example, five days). If a customer is due for notification, the customer's email address is retrieved from the customer's account, and an email reminder is constructed for that customer. As previously described, the email contains an embedded mechanism, such as a unique hypertext link, which allows the customer to return directly to his or her own monthly list page to confirm (and possibly edit) his or her order. If statistical and/or profiling is used to predict reorder frequency, each time a customer confirms and/or edits his or her monthly list, the replenishment expert system tracks this information to better estimate the customer's true replenishment needs. A similar program is also launched daily for those customers who have placed an order but do not have a monthly list. This program is scheduled to run daily and queries the database for customers who do not have a monthly list, have placed an order a predefined number of days previously (for example, twenty-five days previously), and have not received an email notification for the same order in the past.
The purpose of this email is to impress the customer by the timeliness of the reminder and to entice the customer into creating a monthly list, rather than making single orders.
Advantageously, a web site according to the present invention provides an easy, convenient, and accurate way for customers to replenish products that they order on a regular basis. Although the present invention has been described with reference to certain preferred embodiments, various modifications, alterations, and substitutions will be known or obvious to those skilled in the art without departing from the spirit and scope of the invention, as defined by the appended claims.

Claims

1. A method for processing orders for products through a network coupled to at least a first computer system and a second computer system, said first computer system having stored therein a database of products and a database of customers, said second computer system having associated therewith an electronic address associated with a customer in said database of customers, said method comprising: receiving at said first computer system a selection of one or more products from said database of products from said customer; storing data in said first computer system indicating a reorder list for said customer responsive to said selection of one or more products; storing data in said first computer system indicating a reorder frequency for each of said one or more products in said reorder list; and transmitting an electronic notification over said network regarding at least one item in said reorder list responsive to the reorder frequency data associated with said at least one item, said electronic notification being transmitted from said first computer system to said second computer system using said electronic address of said customer, said electronic notification comprising a reorder identifier uniquely associated with said customer and said reorder list.
2. The method of claim 1, further comprising the step of receiving a communication at said first computer system from said customer comprising said reorder identifier to identify to said first computer system that said communication is in regard to said customer and said reorder list.
3. The method of claim 1, wherein said network is the Internet.
4. The method of claim 1, wherein said electronic address is an email address.
5. The method of claim 1 , wherein said electronic notification is transmitted from said first computer system to said second computer system using the SMTP protocol.
6. The method of claim 1 , wherein said reorder identifier is a URL comprising a base address and one or more appended arguments.
7. The method of claim 6, wherein said base address corresponds to a CGI script.
8. The method of claim 6, wherein said base address corresponds to an ASP server.
9. The method of claim 6, wherein said URL is included in an HTML page attached to said electronic notification.
10. The method of claim 1 , wherein said reorder identifier is uniquely associated with said electronic notification.
11. The method of claim 1 , wherein said reorder identifier is associated with a web page comprising information relating to said reorder list.
12. The method of claim 1, further comprising the step of receiving at said first computer system data from said customer indicating a reorder frequency for each of said one or more products in said reorder list.
13. The method of claim 1 , wherein said step of storing data indicating a reorder frequency comprises assigning a reorder frequency to at least one item in said reorder list based on consumption statistics for said at least one item.
14. The method of claim 13, wherein said consumption statistics is the average consumption of said at least one item by a group of people.
15. The method of claim 13, wherein said consumption statistics is based on the demographic characteristics of said customer.
16. The method of claim 1 , wherein said step of storing data indicating a reorder frequency comprises assigning a reorder frequency to at least one item in said reorder list based on the past history of purchases of said customer.
17. The method of claim 1 , wherein said step of storing data indicating a reorder frequency comprises assigning a reorder frequency to at least one item in said reorder list based on the past history of purchases of customers in said database of customers having similar profiles to said customer.
18. The method of claim 17, wherein said similar profiles are based on demographic characteristics.
19. The method of claim 1 , further comprising the step of storing a voice message on a voice mail service of said customer, notifying said customer that said electronic notification has been transmitted.
20. The method of claim 1 , further comprising the step of storing a voice message on an answering machine of said customer, notifying said customer that said electronic notification has been transmitted.
21. The method of claim 1 , wherein said database of customers includes a customer identifier and a customer password associated with said customer, and further comprising the steps of: receiving a communication by said first computer system over said network of said customer identifier and said customer password of said customer; receiving an additional selection of one or more products from said database of products from said customer; storing data in said first computer system indicating a shopping basket for said customer responsive to said additional selection of one or more products; and transferring at least one item from said shopping basket to said reorder list.
22. A data processing system for processing orders for products over a network coupled to at least one computer system, said data processing system comprising: a memory storage unit having stored therein a database of products and a database of customers, a customer in said database of customers having associated therewith an electronic address associated with said at least one computer system; means for receiving a selection of one or more products from said database of products from said customer; means for storing in said memory storage unit data indicating a reorder list for said customer responsive to said selection of one or more products; means for storing in said memory storage unit data indicating a reorder frequency for each of said one or more products in said reorder list; and means for transmitting from said data processing system to said at least one computer system an electronic notification over said network regarding at least one item in said reorder list responsive to the reorder frequency data associated with said at least one item, said means for transmitting using said electronic address of said customer, said electronic notification comprising a reorder identifier uniquely associated with said customer and said reorder list.
23. The data processing system of claim 22, further comprising means for receiving a communication from said customer comprising said reorder identifier.
24. The data processing system of claim 22, wherein said network is the Internet.
25. The data processing system of claim 22, wherein said electronic . address is an email address.
26. The data processing system of claim 22, wherein said means for transmitting utilizes the SMTP protocol.
27. The data processing system of claim 22, wherein said reorder identifier is a URL comprising a base address and one or more appended arguments.
28. The data processing system of claim 27, wherein said base address corresponds to a CGI script.
29. The data processing system of claim 27, wherein said base address corresponds to an ASP server.
30. The data processing system of claim 27, wherein said URL is included in an HTML page attached to said electronic notification.
31. The data processing system of claim 22, wherein said reorder identifier is uniquely associated with said electronic notification.
32. The data processing system of claim 22, wherein said reorder identifier is associated with a web page comprising information relating to said reorder list.
33. The data processing system of claim 22, further comprising means for receiving data from said customer indicating a reorder frequency for each of said one or more products in said reorder list.
34. The data processing system of claim 22, wherein said means for storing data indicating a reorder frequency comprises means for assigning a reorder frequency to at least one item in said reorder list based on consumption statistics for said at least one item.
35. The data processing system of claim 34, wherein said consumption statistics is the average consumption of said at least one item by a group of people.
36. The data processing system of claim 34, wherein said consumption statistics is based on the demographic characteristics of said customer.
37. The data processing system of claim 22, wherein said means for storing data indicating a reorder frequency comprises assigning a reorder frequency to at least one item in said reorder list based on the past history of purchases of said customer.
38. The data processing system of claim 22, wherein said means for storing data indicating a reorder frequency comprises assigning a reorder frequency to at least one item in said reorder list based on the past history of purchases of customers in said database of customers having similar profiles to said customer.
39. The data processing system of claim 38, wherein said similar profiles are based on demographic characteristics.
40. The data processing system of claim 22, further comprising means for storing a voice message on a voice mail service of said customer, notifying said customer that said electronic notification has been transmitted.
41. The data processing system of claim 22, further comprising means for storing a voice message on an answering machine of said customer, notifying said customer that said electronic notification has been transmitted.
42. The data processing system of claim 22, wherein said database of customers includes a customer identifier and a customer password associated with said customer, and further comprising: means for receiving a communication by said data processing system over said network of said customer identifier and said customer password of said customer; means for receiving an additional selection of one or more products from said database of products from said customer; means for storing data in said memory storage unit indicating a shopping basket for said customer responsive to said additional selection of one or more products; and means for transferring at least one item from said shopping basket to said reorder list.
43. A system for ordering products over a network, comprising: a first computer system coupled to said network, said first computer system having stored therein a database of products and a database of customers; a second computer system coupled to said network, said second computer system having associated therewith an electronic address associated with a customer in said database of customers; means for selecting one or more products from said database of products by said customer to establish a reorder list; means for associating a reorder frequency with each of said one or more products in said reorder list; means for storing each of said one or more products and its associated reorder frequency on said first computer system; and means for transmitting from said first computer system to said second computer system an electronic notification regarding at least one item in said reorder list based on the reorder frequency associated with said at least one item, said means for transmitting using said electronic address of said customer, said electronic notification comprising a reorder identifier uniquely associated with said customer and said reorder list.
44. The system of claim 43, further comprising means for communicating with said first computer system using said reorder identifier to identify said customer to said first computer system.
45. The system of claim 43, wherein said network is the Internet.
46. The system of claim 43, wherein said electronic address is an email address.
47. The system of claim 43, wherein said means for transmitting utilizes the SMTP protocol.
48. The system of claim 43, wherein said reorder identifier is a URL comprising a base address and one or more appended arguments.
49. The system of claim 48, wherein said base address corresponds to a CGI script.
50. The system of claim 48, wherein said base address corresponds to an ASP server.
51. The system of claim 48, wherein said URL is included in an HTML page attached to said electronic notification.
52. The system of claim 43, wherein said reorder identifier is uniquely associated with said electronic notification.
53. The system of claim 43, wherein said reorder identifier is associated with a web page comprising information relating to said reorder list.
54. The system of claim 43, further comprising means for receiving data from said customer indicating a reorder frequency for each of said one or more products in said reorder list.
55. The system of claim 43, wherein said means for associating a reorder frequency comprises means for assigning a reorder frequency to at least one item in said reorder list based on consumption statistics for said at least one item.
56. The system of claim 55, wherein said consumption statistics is the average consumption of said at least one item by a group of people.
57. The system of claim 55, wherein said consumption statistics is based on the demographic characteristics of said customer.
58. The system of claim 43, wherein said means for associating a reorder frequency comprises assigning a reorder frequency to at least one item in said reorder list based on the past history of purchases of said customer.
59. The system of claim 43, wherein said means for associating a reorder frequency comprises assigning a reorder frequency to at least one item in said reorder list based on the past history of purchases of customers in said database of customers having similar profiles to said customer.
60. The system of claim 59, wherein said similar profiles are based on demographic characteristics.
61. The system of claim 43, further comprising means for storing a voice message on a voice mail service of said customer, notifying said customer that said electronic notification has been transmitted.
62. The system of claim 43, further comprising means for storing a voice message on an answering machine of said customer, notifying said customer that said electronic notification has been transmitted.
63. The system of claim 43, wherein said database of customers includes a customer identifier and a customer password associated with said customer, and further comprising: means for receiving a communication by said first computer system over said network of said customer identifier and said customer password of said customer; means for receiving an additional selection of one or more products from said database of products from said customer; means for storing data in said first computer system indicating a shopping basket for said customer responsive to said additional selection of one or more products; and means for transferring at least one item from said shopping basket to said reorder list.
PCT/US1999/023590 1998-10-13 1999-10-12 Replenishment system and method for electronic commerce WO2000022560A2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU64239/99A AU6423999A (en) 1998-10-13 1999-10-12 Replenishment system and method for electronic commerce

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US17056198A 1998-10-13 1998-10-13
US09/170,561 1998-10-13

Publications (3)

Publication Number Publication Date
WO2000022560A2 true WO2000022560A2 (en) 2000-04-20
WO2000022560A3 WO2000022560A3 (en) 2000-07-13
WO2000022560A9 WO2000022560A9 (en) 2001-07-05

Family

ID=22620364

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US1999/023590 WO2000022560A2 (en) 1998-10-13 1999-10-12 Replenishment system and method for electronic commerce

Country Status (2)

Country Link
AU (1) AU6423999A (en)
WO (1) WO2000022560A2 (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2002071282A1 (en) * 2001-03-02 2002-09-12 British American Tobacco Australia Limited Network based business to business portal for the retail convenience marketplace
EP1309932A1 (en) * 2000-06-14 2003-05-14 Johnson & Johnson Health Care Systems, Inc. On-line medical shopping system
AU2002233050B2 (en) * 2001-03-02 2005-02-24 British American Tobacco Australia Limited Network based business to business portal for the retail convenience marketplace
US7249065B2 (en) 2003-06-25 2007-07-24 International Business Machines Corporation Supplier proxy store to virtulize an external business entity
US8392018B2 (en) 2008-12-31 2013-03-05 Johnson & Johnson Vision Care, Inc. Apparatus and method for distributing ophthalmic lenses
US10115139B2 (en) 2013-11-19 2018-10-30 Walmart Apollo, Llc Systems and methods for collaborative shopping
US10679176B2 (en) 2014-09-30 2020-06-09 Walmart Apollo, Llc Inventory management based on geographic information of users
CN113222680A (en) * 2020-02-06 2021-08-06 北京沃东天骏信息技术有限公司 Method and device for generating order

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1997023838A1 (en) * 1995-12-26 1997-07-03 Catalina Marketing International, Inc. System and method for providing shopping aids and incentives to customers through a computer network
GB2315351A (en) * 1996-07-11 1998-01-28 Fujitsu Ltd Point-service systems for online shopping malls
WO1998009209A1 (en) * 1996-08-30 1998-03-05 Intertrust Technologies Corp. Systems and methods for secure transaction management and electronic rights protection

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH10162079A (en) * 1996-11-27 1998-06-19 Victor Co Of Japan Ltd Online shopping system, server, terminal, recording medium for the system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1997023838A1 (en) * 1995-12-26 1997-07-03 Catalina Marketing International, Inc. System and method for providing shopping aids and incentives to customers through a computer network
GB2315351A (en) * 1996-07-11 1998-01-28 Fujitsu Ltd Point-service systems for online shopping malls
WO1998009209A1 (en) * 1996-08-30 1998-03-05 Intertrust Technologies Corp. Systems and methods for secure transaction management and electronic rights protection

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
MCCLAIN K: "Computer reminder improves compliance. Med-Minder calls patients when their prescriptions need refilling" CHAIN STORE AGE EXECUTIVE, APRIL 1989, USA, vol. 65, no. 4, pages 67-68, XP000901426 ISSN: 0193-1199 *
PATENT ABSTRACTS OF JAPAN vol. 1998, no. 11, 30 September 1998 (1998-09-30) & JP 10 162079 A (VICTOR CO OF JAPAN LTD;NIPPON TELEGR & TELEPH CORP <NTT>), 19 June 1998 (1998-06-19) *

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1309932A1 (en) * 2000-06-14 2003-05-14 Johnson &amp; Johnson Health Care Systems, Inc. On-line medical shopping system
EP1309932A4 (en) * 2000-06-14 2005-05-04 Johnson & Johnson Health Care On-line medical shopping system
WO2002071282A1 (en) * 2001-03-02 2002-09-12 British American Tobacco Australia Limited Network based business to business portal for the retail convenience marketplace
AU2002233050B2 (en) * 2001-03-02 2005-02-24 British American Tobacco Australia Limited Network based business to business portal for the retail convenience marketplace
US7249065B2 (en) 2003-06-25 2007-07-24 International Business Machines Corporation Supplier proxy store to virtulize an external business entity
US8392018B2 (en) 2008-12-31 2013-03-05 Johnson & Johnson Vision Care, Inc. Apparatus and method for distributing ophthalmic lenses
US10109145B2 (en) 2008-12-31 2018-10-23 Johnson & Johnson Vision Care, Inc. Apparatus and method for distributing ophthalmic lenses
US10453292B2 (en) 2008-12-31 2019-10-22 Johnson & Johnson Vision Care, Inc. Apparatus and method for distributing ophthalmic lenses
US10115139B2 (en) 2013-11-19 2018-10-30 Walmart Apollo, Llc Systems and methods for collaborative shopping
US10679176B2 (en) 2014-09-30 2020-06-09 Walmart Apollo, Llc Inventory management based on geographic information of users
CN113222680A (en) * 2020-02-06 2021-08-06 北京沃东天骏信息技术有限公司 Method and device for generating order

Also Published As

Publication number Publication date
WO2000022560A9 (en) 2001-07-05
WO2000022560A3 (en) 2000-07-13
AU6423999A (en) 2000-05-01

Similar Documents

Publication Publication Date Title
US7475024B1 (en) System and method for distributing in real-time, inventory data acquired from in-store point of sale terminals
US6430540B1 (en) Method and system for monitoring and modifying a consumption forecast over a computer network
US20030014317A1 (en) Client-side E-commerce and inventory management system, and method
US20070124216A1 (en) Systems and methods for locating and purchasing proximal inventory items
US20020099622A1 (en) Merchant-affiliated direct wholesale marketing and fulfillment system
US20020072980A1 (en) System, method, and program for managing electronic shopping carts
US20030014323A1 (en) Computer system and method for ordering a product
CA2597960A1 (en) Methods and apparatus for selling shipping services online through a mediator&#39;s web site
US20130218728A1 (en) Virtual on-line pre-shopping system and method
KR19980041785A (en) Method and apparatus for performing computer-based on-line commerce using intelligent agent
US20030023506A1 (en) Virtual business restructuring methods
WO2001040901A9 (en) Demand aggregation and distribution system
US20100036746A1 (en) Virtual on-line pre-shopping system and method
WO2000022560A2 (en) Replenishment system and method for electronic commerce
US20030023513A1 (en) E-business systems and methods for diversfied businesses
EP1076866A2 (en) Telecommunication transmission system adapted for an electronic market place
US20030093327A1 (en) Systems and methods for processing an electronic request to purchase goods or services
JP2003157377A (en) Network system, purchase history presenting method, server device, program and recording medium
US20060136345A1 (en) Efficient schema supporting upsell features of a web-based business application
JPWO2003038700A1 (en) How to notify product information
KR20020007163A (en) System and method for generating virtual wish lists for assisting shopping over computer networks
WO2001071617A1 (en) Electronic commerce system with access to inventory data from multiple stores
US20030130898A1 (en) System to facilitate electronic shopping
WO2000046686A1 (en) E-commerce notification
US20030212570A1 (en) System and method for inquiring remaining quantity of orders

Legal Events

Date Code Title Description
ENP Entry into the national phase in:

Ref country code: AU

Ref document number: 1999 64239

Kind code of ref document: A

Format of ref document f/p: F

AK Designated states

Kind code of ref document: A2

Designated state(s): AE AL AM AT AU AZ BA BB BG BR BY CA CH CN CR CU CZ DE DK DM EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GH GM KE LS MW SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
AK Designated states

Kind code of ref document: A3

Designated state(s): AE AL AM AT AU AZ BA BB BG BR BY CA CH CN CR CU CZ DE DK DM EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: A3

Designated state(s): GH GM KE LS MW SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
AK Designated states

Kind code of ref document: C2

Designated state(s): AE AL AM AT AU AZ BA BB BG BR BY CA CH CN CR CU CZ DE DK DM EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG US UZ VN YU ZA ZW

AL Designated countries for regional patents

Kind code of ref document: C2

Designated state(s): GH GM KE LS MW SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

COP Corrected version of pamphlet

Free format text: PAGES 1/24-24/24, DRAWINGS, REPLACED BY NEW PAGES 1/18-18/18; DUE TO LATE TRANSMITTAL BY THE RECEIVING OFFICE

REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

122 Ep: pct application non-entry in european phase