The following examples further illustrate the invention but, of course, should not be construed as in any way limiting its scope. The method of the invention comprises receiving purchase order information generated by a first entity wherein the purchase order information identifies the product or products that have been ordered, the customer (or member) who ordered the products, and the delivery information; receiving order status information generated by a second entity wherein the order status information is related to the purchase order information; receiving manufacturing status information, generated by a third entity, related to the purchase order information; receiving shipper status information, generated by a fourth entity, related to the purchase order information; and in response to user input, displaying on a web based display at least the current status of the purchase order information, the order status information, the manufacturing status information, and the shipper status information. In a preferred embodiment of the invention the first entity is a retailer, the second entity is a supplier, the third entity is a manufacturer, and the fourth entity is a shipper. User input to trigger the display of information can be provided by any of the above entities as well as a fifth entity such as a customer. Furthermore, in another embodiment of the invention, information that is displayed can be updated by at least one of the entities above.
The web page is updated periodically with data from the first database which receives updates from the second database. Preferably, the web page is updated every 15 minutes but other update intervals could be used as well. The first database receives data such as purchase order information, order status information, manufacturing status information, and shipper status information. In this embodiment that data originates from various other supplier systems such as ordering systems and scheduling systems as well as direct input into the web page. The data received may be stored in the first database.
Furthermore, in addition to displaying data to the entities, the web page also may receive data input from at least some of the entities. In this embodiment, the web page may receive data input by the customer, the retailer, the shipper, and the supplier. Other combinations of entities entering data into the display could also be used. For instance, the manufacturer may also enter data into the web page. Once the data is entered into the web page, it is transferred to the first database and then to the second database. Any suitable method of downloading (or uploading) data can be used. According to one embodiment, File Transfer Protocol (FTP) in a comma delimited format is used to download the data from the web page to the first database and then to the second database and vice versa. According to an embodiment, the information in the databases and the web page may be periodically “synced” such that differences in the data are recognized and resolved. For example, if a customer accesses the web page and updates or corrects their address information, during a syncing cycle this difference will be recognized and the new address information may be applied to a database.
In the embodiment depicted in
According the method, purchase order information is received by the first database depicted in
The first database of
The first database of
The first database of
Other data that may be received by the first database can include information indicating that the customer has cancelled the delivery, information indicating that there is a customer information problem, and information resolving a customer information problem and the date and time that the customer information problem was resolved. In the embodiment of
An entity accesses the web page through accessing a web site on the network. The web site may be secured by a login name and password. Once logged onto the site, orders can be searched using various criteria. Examples of such criteria include the purchase order number, the shipper waybill number, the customer phone number, or the customer last name. The first database is searched and information associated with the search criteria is returned. If the search criteria matches more than one record stored in the first database then a list of possibilities is presented. If the searcher is a retailer the list will include only those customers that placed their order through that retailer. In one embodiment, a list of possibilities will display information such as the purchase order number, the way bill number, the customer's last name, city, state, zip code and phone number will appear in a list of possibilities. The correct entry can then be selected from the list and then at least some current status information will be displayed for the order on a web page. If the searcher is a customer, the search criteria are the waybill number or purchase order number and the customer's zip code.
The web page, in response to this user input, displays the current status information related to each entity. For the embodiment of
As shown in
Adjacent to each entity icon are stage icons that identify various stages associated with each entity. Each stage icon, in the embodiment depicted in
Adjacent to the customer icon is the customer's name and address and phone number. Below the phone number are four customer stage icons. The first customer stage icon has a text label of “Order is placed,” the second customer stage icon has a text label of “Awaiting Delivery,” the third customer stage icon has a text label of “Delivered & Accepted,” and the fourth customer stage icon has a text label of “Member Cancelled at Pre-Call.” When the web page receives data indicating the customer has placed an order, the first customer stage icon changes color from gray to green, and the arrow between the customer icon and the retailer icon changes from gray to green. When the web page receives data indicating that the shipper scheduled a delivery date with the customer (member), the second customer stage icon changes color from gray to green and the scheduled date and time of delivery appears next to the second customer stage icon. When the web page receives data indicating that the product has been delivered and accepted by the customer, the third customer stage icon changes color from gray to green and the delivery date and time appears next to the third customer stage icon. If the web page receives data indicating that the order has been cancelled, the fourth customer stage icon changes color from gray to orange, flashes, and the date and time the order was cancelled appears next to the fourth customer stage icon.
Adjacent to the retailer icon is a retailer stage icon that has a text label of “Order is placed.” When the retailer stage icon changes color from gray to green, it indicates that the order has been placed with the supplier by the retailer. In this embodiment, there is only one stage for the retailer to perform in the order fulfillment process, therefore when the web page receives data indicating that the retailer has placed the order, the retailer stage icon is changed to green and the arrow between the retailer and the supplier is changed to green as well.
Adjacent to the supplier icon are two supplier stage icons. The first supplier stage icon has a text label of “Received Order” and the second supplier stage icon has a text label of “Verified & Sent to Order to Plant.” When the web page receives data indicating that the order has been received by the supplier from the retailer, the first supplier stage icon changes color from gray to green, and the date and time the order was received will appear next to the first supplier stage icon. Similarly, when the web page receives data indicating that the order has been verified by the supplier and sent to the manufacturing plant, the second supplier stage icon changes color from gray to green and the date and time the order was received appears next to the second supplier stage icon, and the arrow between the supplier icon and the manufacturing icon changes from gray to green.
Adjacent to the manufacturer icon are four manufacturer stage icons. The first manufacturer stage icon has a text label of “Received Order,” the second manufacturer stage icon has a text label of “Order in Production,” the third manufacturer stage icon has a text label of “Scheduled to ship to Home Direct,” and the fourth manufacturer stage icon has a text label of “Shipped to Home Direct.” In this embodiment, Home Direct is the name of the shipper. When the web page receives data indicating that the order has been received by the manufacturer from the supplier, the first manufacturer stage icon changes color from gray to green, and the date and time the order was received appears next to it. Similarly, when the web page receives data indicating that the order is in production at the manufacturer, the second manufacturer stage icon changes color from gray to green and the date and time the order entered production appears next to the second manufacturer stage icon. When the web page receives data indicating a scheduled ship date for the finished product from the manufacturer, the third manufacturer stage icon changes color from gray to green and the scheduled ship date appears next to the third manufacturer stage icon. When the web page receives data indicating that the product has been shipped to Home Direct (the shipper in this case), the fourth manufacturer stage icon changes color from gray to green and the date the order shipped appears next to the fourth manufacturer stage icon, and the arrow between the manufacturing icon and the shipper icon changes from gray to green.
Adjacent to the shipper icon are four shipper stage icons and two informational icons. The first shipper stage icon has a text label of “Received Product,” the second shipper stage icon has a text label of “Contacted Member,” the third shipper stage icon has a text label of “Scheduled Delivery” and the fourth shipper stage icon has a text label of “Successful Delivery to Member.” When the web page receives data indicating that the product has been received by the shipper, the first shipper stage icon changes color from gray to green, and the date and time the product was received appears next to it. Similarly, when the web page receives data indicating that the shipper contacted the customer (member), the second shipper stage icon changes color from gray to green and the date and time the contact occurred appears next to the second shipper stage icon. When the web page receives data indicating a scheduled delivery date from the shipper, the third shipper stage icon changes color from gray to green and the scheduled delivery date and time appears next to the third shipper stage icon. When the web page receives data indicating that the product has been successfully delivered, the fourth shipper stage icon changes color from gray to green and the date and time the product was delivered appears next to the fourth shipper stage icon, and the arrow between the shipper icon and the customer icon changes from gray to green.
The first informational icon has a text label of “Member Info Problem” and the second informational icon has a text label of “Member Cancelled at Pre-Call.” When the web page receives data indicating that there is a problem with customer (member) information, the first informational icon changes color from gray to orange, and flashes on and off. The date and time the problem was received appears next to the flashing icon. Similarly, when the web page receives data indicating that an order has been cancelled, the second informational icon changes color from gray to orange and flashes on and off. The date and time the cancellation occurred appears next to the flashing second informational icon.
The invention also encompasses a graphic display where additional information can be displayed if desired by the user. For example, such functionality could be provided by drill down capability or “mouse over” capability. In this particular embodiment, mouse over capability is implemented. A user wishing to get additional information can move the cursor over a part of the web page and additional information will pop up. An example of this is a user moving the cursor over the shipper. In doing so, the shippper's name, address and phone number appears on the screen. When the customer movers the cursor near the customer information the UPC, quantity, description of each product ordered appears on the screen.
The web page display has a plurality of buttons at the bottom of it. In the embodiment depicted in
If a user logs onto the web site and while of the web page clicks the update member button on the web page, an update screen pops up on the web page. An example of such a screen is shown in
The website will send the updated record and the date and the time to the first database via FTP. When received by the first database, the changes are applied to the records. When the web page receives the next update, the first informational icon will change from either gray (if the web page had not previously received data indicating that there was a problem with customer (member) information) or orange (if the web page had previously received data indicating that there was a problem with customer (member) information) to green and the date and time of the information update will appear next to the first informational icon. The changes are passed to the ordering and scheduling systems of the supplier and an alert message is sent to the retailer and shipper advising them that there has been a change in the records. In other embodiments, an alert message for the retailer and the shipper would appear on a special screen that each would have on the web site.
If a user clicks the order replacement button on the web page, an order exact replacement screen pops up on the web page and displays existing information from the purchase order and waybill as retrieved from the first database. An example of such a screen is shown in
The order exact replacement screen has fields for the user to input comments, employee ID, employee name and e-mail address (checked for validity). The embodiment shown in
Two buttons appear at the bottom of the screen. The user clicks the first button to submit the order for an exact replacement. The second button allows the user to cancel their inputs and to not to place an exact replacement order. Once the changes are accepted the popup window closes and a window is displayed with the message “Exact order placement has been processed. Click here to return back to the Protracker.” The website will send the updated record and the date and the time to the first database via FTP. When received by the first database, the changes are applied and passed to the second database. The new product order is then applied to the appropriate ordering and scheduling systems and the retailer is sent an alert notifying them of this activity. If a damaged or unacceptable product must be picked up and returned, a request for pickup and return is sent to the shipper to schedule.
If a user (retailer, supplier or shipper) clicks the cancel button on the web page, a cancel screen pops up on the web page and displays existing information from the purchase order and waybill as retrieved from the first database. An example of such a screen is shown in
Two buttons appear at the bottom of the screen. The user clicks the first button to submit the cancellation. The second button allows the user to not to place the cancellation. Once the changes are accepted the popup window closes and a window is displayed with the message “Cancellation—Pickup Product Only has been processed. Click here to return back to the Protracker.” The website will send the updated record and the date and the time to the first database via FTP. When received by the first database, the changes are applied to the first database records and passed to the second database. The cancellation of the order is then applied to the appropriate ordering and scheduling systems and the retailer is sent an alert notifying them of this activity. If an unacceptable product must be picked up and returned, a request for pickup and return is sent to the shipper to schedule. Applying the cancellation to the first database record will cause the second informational icon and the fourth customer stage icon to change to orange and flash on the web page when the web page is updated.
If a user clicks the warranty button on the web page, a warranty screen pops up on the web page and displays existing information from the purchase order and waybill as retrieved from the first database. An example of such a screen is shown in
Two buttons appear at the bottom of the screen. The user clicks the first button to submit the warranty current replacement. The second button allows the user to not to place the warranty current replacement. Once the changes are accepted the popup window closes and a window is displayed with the message “Warranty—Current Product Order Replacement has been processed. Click here to return back to the Protracker.” The website will send the updated record and the date and the time to the first database via FTP. When received by the first database, the changes are applied to the database record and passed to the second database. The new order is then sent to the appropriate ordering and scheduling systems and the retailer is sent an alert notifying them of this activity. If an unacceptable product must be picked up and returned, a request for pickup and return is sent to the shipper to schedule.
The retailer, supplier and shipper can update a customer's delivery information by accessing the web page via the Internet and selecting the button that says “Update Member” information. When that button is clicked a screen will appear that lets the retailer, supplier, and shipper enter the correct information. In some cases, both the phone number of the customer may be incorrect and the shipper is the first to discover it when the customer is called to arrange a delivery time. In those cases, the shipper may be unable to determine the correct customer delivery information and instead of updating the customer information the shipper may send an electronic message to the supplier alerting it to the information problem. The supplier then passes that information to the first database and which uploads the alert to the web site causing the first information icon to change color to orange.
In general the customer, the retailer, the supplier, the manufacturer, and the shipper can logon to the web site and view the web page displaying the status of an order. The visual depicted on the web page enables a user to quickly determine the status of the order, any cancellation or replacement of the order. The order being viewed is in green, any related orders are listed in gray below the order being viewed. Clicking on any of related orders will bring up the visual depiction of that order.
In another embodiment a user could click an icon on the screen to bring up a box for typing in a text message. The message can then be sent one of the entities and a live person can text message a response back.
In another embodiment there may be buttons on the web page to allow at least one entity to view metrics relating to their function in the order fulfillment. There may also be buttons on the web page that allow at least one entity to view at least one other entity's metrics with regard to the order. Examples of metrics that may be obtained are metrics that are performance based, cost based, quantity based, or error based. Other metrics may also be obtained.
According to an alternative embodiment of the invention, there is illustrated in
After creation of the order, the order information may be supplied to the supplier, an entity that is capable of fulfilling the order. The order information may be supplied to the supplier electronically, for example, through an Electronic Data Interchange (EDI) system, or through other ways, such as by telephone or email. In fact, each of the outer links in the illustration may be arranged by an EDI system. In other words, communications concerning an order between the customer and retailer, between the retailer and supplier, between the supplier and the manufacturer, and between the manufacturer and the shipper, may be performed conventionally, such as telephonically, through email or through an EDI system. As illustrated by a dotted line, the information link between the shipper and customer may limited, such as by telephone, just in case of problems.
Each of the separate parties may be enabled to access the order website obtain information about the current status of an order. Of course, the order website may contain information about a plurality of orders, so any of the separate parties may have access only to a subset of the total information available on the website. For example, the customer may have access only to order information on the order website for orders that were placed by that customer. In addition, the system may be configured to allow each of the separate entities to modify information relating to an order. The system may further be configured to limit the ability for a particular entity to modify the order information to only that subset of information that involves the activities of that particular entity. For example, the shipper may be limited to modifying or updating the customer address information, such as by supplying ZIP code or other information relating to the delivery of the product.
According to an embodiment of the invention, information for a particular order on the order website is supplied by the supplier from information from a supplier database. The supplier database as illustrated may represent merely a portion of a larger database maintained by the supplier. The portion illustrated, for example, may contain just the information necessary to support the order information on the order website. The supplier database and the order website may be arranged so that a syncing operation is performed periodically where differences between order information on both systems are determined and resolved. For example, the customer may have updated or modified the address information on the order website. During the next syncing cycle, this change will be discovered and the updated address information may be applied to the appropriate order information in the supplier database. Alternatively, in the event information in the supplier database is updated, the corresponding information in the order website for a particular order may be updated during the next syncing cycle.
Thus, as illustrated in
All references, including publications, patent applications, and patents, cited herein are hereby incorporated by reference to the same extent as if each reference were individually and specifically indicated to be incorporated by reference and were set forth in its entirety herein.
The use of the terms “a” and “an” and “the” and similar referents in the context of describing the invention (especially in the context of the following claims) are to be construed to cover both the singular and the plural, unless otherwise indicated herein or clearly contradicted by context. Recitation of ranges of values herein are merely intended to serve as a shorthand method of referring individually to each separate value falling within the range, unless otherwise indicated herein, and each separate value is incorporated into the specification as if it were individually recited herein. All methods described herein can be performed in any suitable order unless otherwise indicated herein or otherwise clearly contradicted by context. The use of any and all examples, or exemplary language (e.g., “such as”) provided herein, is intended merely to better illuminate the invention and does not pose a limitation on the scope of the invention unless otherwise claimed. No language in the specification should be construed as indicating any non-claimed element as essential to the practice of the invention.
Preferred embodiments of this invention are described herein, including the best mode known to the inventors for carrying out the invention. It should be understood that the illustrated embodiments are exemplary only, and should not be taken as limiting the scope of the invention.
This patent application claims the benefit of U.S. Provisional Patent Application No. 60/814,779, filed Jun. 19, 2006.
Number | Date | Country | |
---|---|---|---|
60814779 | Jun 2006 | US |