An inventive procurement system includes a requisition system for special item purchases that are not found when searching a catalog database. Using the requisition system the buyer is provided with the desired item while the information associated with the requisition is selectively added to a rule-based knowledge base as well as to an item database. In a preferred embodiment a common language generator has been used to normalize free form data using pre-determined rules to place the data into a class/attribute/value relationship. By having the item requisition follow the same relationship, the pre-determined rules may be updated and the free-form data associated with the item properly coded for inclusion into an item database.

Patent
   6892185
Priority
Jul 07 1999
Filed
Jul 07 1999
Issued
May 10 2005
Expiry
Jul 07 2019
Assg.orig
Entity
Large
90
14
all paid
19. A procurement method for ordering a special item comprising the steps of:
providing a common language generator;
providing an electronic common language generator knowledge base comprising predetermined rules and predetermined relationships;
searching for an item within an electronic database;
determining that said item is not within said electronic database;
after it is determined that said item is not within said electronic database performing the steps of:
(a) creating a structured requisition for uniquely describing said item,
(b) transmitting said structured requisition to at least one potential supplier,
(c) locating a desired supplier for said item, and
(d) adding information about said item from said structured requisition to said electronic database normalized by said common language generator according to said predetermined rules and relationships of said common language generator knowledge base.
1. A procurement system for purchasing a special item between a buyer of the special item and at least one supplier capable of supplying the special item, said system comprising:
a fulfillment system for communicating between said buyer and said supplier;
an electronic database associated with said fulfillment system, said special item not being located within said database;
an electronic knowledge base including a plurality of predetermined relationships and a plurality of predetermined rules;
a special requisition for containing a description of said special item;
a common language generator for normalizing said database with respect to said predetermined relationships in accordance with said predetermined rules of said knowledge base; and
said common language generator normalizing information obtained in part from said special requisition by using said knowledge base and adding the information to said database for future reference.
16. A method for continuously updating a procurement system comprising the steps of:
predetermining a set of rules to convert free form information associated with a catalog item into a normalized catalog item;
providing a common language generator having an electronic knowledge base comprising said predetermined set of rules and predetermined relationships;
establishing, by said common language generator using said knowledge base, a normalized electronic catalog database of normalized catalog items based on predetermined rules and relationships;
processing a request for a special item not located within said catalog database using said predetermined relationships;
specifying an additional relationship in a structured requisition to uniquely identify the special item;
normalizing information obtained from said structured requisition by said common language generator using said knowledge base; and
adding the information to said catalog database for future reference.
10. A procurement system for purchasing a desired item, comprising:
a normalized electronic catalog database comprising at least one unique catalog item, wherein each unique catalog item stored within said electronic catalog database is identified with respect to class, attribute, and value relationships;
a common language generator having a knowledge base, said knowledge base comprising a set of predetermined rules and said relationships used to convert free form catalog item information into said normalized electronic catalog database in accordance with said relationships;
an item selection device, said device relying on said relationships to locate the desired item within said electronic catalog database;
an item specifying device, said device being invoked after determining the desired item cannot be located by said item selection device within said electronic catalog database;
a structured requisition subsystem for creating a structured requisition to uniquely identify the desired item that cannot be located within said catalog database using said relationships and at least one new class, attribute or value added to said relationships;
said common language generator normalizing information obtained in part from said structured requisition by using said knowledge base and adding the information to said database for future reference.
2. A procurement system as recited in claim 1, wherein said electronic database of said fulfillment system comprises an electronic catalog database, said catalog database comprising catalog item information normalized with respect to said predetermined relationships in accordance with said predetermined rules of said knowledge base.
3. A procurement system as recited in claim 2, wherein said special requisition is partially normalized by said common language generator according to said predetermined rules, with said buyer suggesting enhancements to said predetermined relationships for creating a potential unique description of the special item.
4. A procurement system as recited in claim 3, wherein said special requisition is reviewed by said at least one supplier and includes a proposed modification to at least one of said predetermined relationships.
5. A procurement system as recited in claim 4, further comprising a new predetermined rule to uniquely identify the special item, said new predetermined rule based at least in part on said updated information contained within said special requisition.
6. A procurement system as recited by claim 4, wherein said predetermined relationships comprise class and attribute characteristics and said at least one supplier is a plurality of suppliers, said suppliers reviewing said special requisition and said fulfillment system normalizing said updated data received from each of said suppliers for comparison by said buyer, said buyer comparing said updated information based on identical class and attribute characteristics so as to provide a consistent basis for comparison between each special item available for purchase.
7. A procurement system as recited in claim 2, wherein said at least one supplier is identified with specific predetermined relationships, said fulfillment system comparing said special requisition prepared in accordance with said predetermined rules to select said at least one supplier to receive and review said special requisition.
8. A procurement system as recited in claim 2, wherein said update information related to the special item is normalized according to said predetermined rules and stored within said catalog database to uniquely identify the special item.
9. A procurement system as recited in claim 2, wherein said predetermined relationships include class, attribute and value characteristics.
11. A procurement system as recited in claim 10, wherein said relationships used to create said structured requisition further comprise identification of at least one supplier, said structured requisition being automatically sent to said identified at least one supplier by said system.
12. A procurement system as recited by claim 10, wherein said structured requisition is used to develop at least one new predetermined rule for uniquely identifying the desired item that cannot be located within said catalog database.
13. A procurement system as recited in claim 12, wherein said at least one new predetermined rule is added to said knowledge base to provide an update to said relationships.
14. A procurement system as recited in claim 13, wherein identifying information concerning the desired item is stored in said database in accordance with said relationships.
15. A procurement system as recited in claim 14, wherein the desired item becomes a catalog item available through said selection procedure after undergoing said specifying procedure.
17. A method as recited in claim 16, wherein said predetermined relationships include class, attribute and value characteristics and said additional relationship is at least one of class, attribute, or value.
18. A method as recited in claim 17, further comprising the steps of
updating said rules to incorporate said new class, attribute or value from said specifying.
20. A procurement method as recited in claim 19, further comprising the step of normalizing said database by said common language generator using said knowledge base such that information from said requisition is categorized in accordance with class, attribute and value relationships.
21. A procurement method as recited in claim 19, wherein said creating step includes a step of identifying normalized relationships for said item.
22. A procurement method as recited in claim 21, wherein said transmitting step includes the step of automatically identifying said potential supplier using said normalized relationships.
23. A procurement method as recited in claim 21, wherein said locating step includes the step of updating said normalized relationships to create a new relationship that uniquely identifies said item.
24. A procurement method as recited in claim 23, further comprising the steps of:
providing free form item data;
adding a new relationship to said knowledge base;
processing, by said common language generator, said free form item data through said knowledge base; and
updating said database with said processed free form item data.
25. A procurement method as recited in claim 21, wherein said adding step comprises using said new relationship.

The present invention relates in general to a procurement system. More specifically, the invention relates to a procurement system where a user completes a structured requisition form based predominantly on pre-existing normalized relationships to order an item not available in a catalog database. The form is used to specify the desired item and to selectively create updated normalized relationships for use in identifying the new item so that it and similar items may be placed in the catalog database when free form data is examined using the normalized relationships.

Procurement systems are well known. A buyer searches a catalog or a catalog database, locates material of interest, and places an order. A supplier then fulfills the order. However, special orders greatly complicate and slow down the entire procurement process as well as greatly increasing procurement expense. In practice, a buyer who cannot find an item located in a catalog must fill out a special requisition, also known as a special order request. However, no order is even placed until a potential supplier and related cost and delivery information is provided to the buyer for consideration.

The requisition is then sent to a procurement fulfillment organization. A fulfillment specialist reviews the special requisition and manually determines if there are any potential suppliers that can fulfill the special requisition. Potential suppliers are then contacted and they respond accordingly. Each of the suppliers has their own way of describing the items it carries. Thus, the fulfillment specialist must manually review each supplier proposal and determine which ones appear to be most favorable to the buyer.

Next, the buyer must receive the best proposals from the fulfillment specialist, determine which one appears to be the most appropriate for that organization, and manually go through a special order process for the special requisition to actually be fulfilled by a supplier. Worse yet, when the special order is finally fulfilled, all of the special effort that went into manually reviewing the requisition, manually determining potential suppliers, manually locating the best suppliers, and then actually fulfilling the special order is lost. Thus, the entire process must be re-initiated if a different buyer wants the same or a similar special order in the future.

Thus, there is a strong need for a procurement system that takes into account special requisitions and resulting special orders, and uses the information related to such special orders so that the effort spent on fulfilling each order is not lost. In particular, it would be highly desirable to be able to receive a special requisition, and use a methodology to automatically select most likely suppliers without human intervention. If such an automatic selection process were available, then the special requisition could automatically be sent to each vendor for review and quoting. Moreover, it would be highly desirable to be able to receive the information from each supplier in a consistent format so that review of the received information could be automated as well according to predetermined criteria to select the best supplier(s) for a possible special order. Additionally, it would be desirable to use the special expertise of both buyers and suppliers to create updated rules and item information associated with the special order. Therefore, future orders of the same item would not require the same special handling.

An inventive procurement system according to the present invention takes advantage of the information transferred between a buyer, a procurement fulfillment organization, hereinafter called a back office, and a supplier to automate and continuously update a catalog database of items.

In practice, a buyer searches for an item in a catalog database. If the item is not found, the user then creates a special requisition that will uniquely identify the desired item. The requisition is transmitted to the back office, which then forwards it to potential suppliers. One or more of the suppliers review and revise the requisition and send it back to the back office. The back office uses predetermined criteria to select one or more of the suppliers and then provides the buyer with the supplier information. The buyer may place an order for the special item.

A key advantage of the present invention is that both the catalog database as well as the special requisition are normalized using predetermined rules related to class, attribute, and value relationships that are already knows to the back office, and must be followed by the buyer to create the special requisition. Generally, these rules are stored in a knowledge base. When the back office receives free form item data, the free form data is processed through the knowledge base to create the normalized database that a user searches. The rules used to create the normalized database are made available to the buyer to locate a specific item.

Thus, when making a special requisition for an item not in the database, the buyer first identifies the item using all available class, attribute, and value relationships used to create the normalized database. The remaining class, attribute and value relationship information required to uniquely identify the desired special item are then suggested by the buyer and forwarded to the back office.

The back office uses the pre-existing information identified by the buyer to pre-select potential suppliers that are already associated with the selected classes, attributes, and values and automatically forwards the special requisition to them. Thus, no human intervention is required.

One or more of the suppliers review and revise the special requisition using the same relationship approach as followed by the buyer and dictated by the pre-existing rules of the knowledge base and then returns it to the back office. Thus, at least two experts (i.e., the buyer and the supplier) have proposed a revised normalization relationship to uniquely identify a desired item in accordance with the pre-determined rules. The revised normalization relationship may be used to create a new rule for the knowledge base to process future items with no further human intervention.

Moreover, by having a normalized item selection process, the desired item and related items may be readily added to a catalog database for future selection by other buyers. Such an approach takes advantage of the expertise of the buyer and supplier in fulfilling a special requisition while eliminating the need to undertake the same process for other buyers. The catalog database is automatically updated as required over time, generating catalog database updating in a real time fashion.

Yet another advantage of having a normalized approach to the special requisition process is to permit easy item comparison by a buyer. When more than one potential supplier of a desired item is located, having the item information in a normalized fashion according to class, variable and value relationships provides easy comparison of the various items by the buyer. Thus, comparison-shopping is expedited to the benefit of all parties since fewer returns are likely when the item criteria are clearly understood.

The features and inventive aspects of the present invention will become more apparent upon reading the following detailed description, claims, and drawings, of which the following is a brief description:

FIG. 1 is a schematic overview of key elements of the present invention including a buyer, supplier, and a back office with both the supplier and the buyer communicating with the back office.

FIG. 2 is a flow chart of a procurement system according to the present invention.

FIG. 3 is an example of an advanced search screen discussed with respect to the present invention.

FIG. 4 is an example of the hits located from undertaking an advanced search according to the present invention.

FIG. 5 is an illustration of the class hierarchy of the normalized item data according to the present invention where if gases are selected, at least two sub-classes of gases are provided.

FIG. 6 is an example of a parametric search screen provided after a leaf class has been selected.

FIG. 7 is an illustration of a product comparison screen according to the present invention.

FIG. 8 is a flow chart illustrating a preferred embodiment of a structured requisition subsystem according to the present invention.

FIG. 9 is a flow chart illustrating a preferred embodiment of a catalog update subsystem according to the present invention.

FIG. 10 is a representation of the relationships between the various elements of the present invention including the buyer, buyer interface application, back office (including catalog database, common language generator and knowledge base, and back office communications interface), and supplier/supplier interface application.

A procurement system 20 is illustrated in FIG. 1 that includes a buyer 22, a procurement fulfillment organization hereinafter referred to as back office 24, and suppliers 26. As shown by a communications link 28, buyer 22 communicates with back office 24 to search or select item information and to place an order. To facilitate the item order process, back office 24 has one or more catalog databases 32 that are normalized using a common language generator (“CLG”) and corresponding CLG knowledge base 30, discussed in greater detail below. In turn office 24 communicates with suppliers 26 as shown by communications link 34 to get information not in its catalog databases 32 or to forward an order received from a buyer 22. Then the appropriate supplier 26 or its agent ships the requested item directly to buyer 22, fulfilling the order as shown by line 36.

Procurement system 20 is illustrated in greater detail in FIG. 2. First, buyer 22 logs onto a buyer interface application 40, described in greater detail below with respect to FIG. 10, at start point 42. Next, buyer 22 determines at decision point 44 if it will be selecting an item from a hot list. A hot list is typically a listing of items associated with a particular buyer 22 based on past purchase history or preferences. In some cases it may represent the purchase history or preferences of the buyer's organization. Unlike catalog databases 32, a hot list is typically stored within application 40 and periodically updated to take into account discontinued items and the like.

If the desired item is found in the hot list as shown at decision point 52, then the user is next asked if there are any additional items to be ordered at decision point 54. If yes, then the item selected is temporarily stored at point 56 and buyer 22 returns to start point 42 to select the next desired item. If no additional items are desired then an order is created at point 58. The option to modify the item selection is permitted at decision point 60. If an item is to be modified, then buyer 22 is returned to start point 42. Otherwise, any additional information is entered as required at point 62 and the order is submitted at point 64. In many cases, specific approval is not required if the standard buyer catalog database 32 or a hot list 44 is used. In some cases, however, an approval process is required by the buyer's organization as shown at point 66. Once the order has been approved, it is then placed by the buyer's organization as shown at point 68. Back office 24 informs one or more suppliers 26 who fulfill the order as shown by item 36, and discussed with respect to FIG. 1. The items are shipped to the buyer 22 according to buyer purchasing preferences. Finally, the procurement process ends at termination point 69.

If an item is not found using the hot list at decision point 52, additional methods for locating a desired item are available. First, the user is returned to start 42. If the hot list option is not selected, then at decision point 70 buyer 22 is asked if she will be using a standard buyer catalog database 32. If yes, then the standard database 32 is selected at point 71. Typically, a buyer accesses a standard buyer catalog database 32 that has been put together by his organization for routine purchases and that represents the purchasing preferences of the organization. If not, then additional database catalog(s) may be used as shown at point 72. One possible database is a cumulative global database representing all items tracked by back office 24 for many suppliers and buyer organizations.

Once the desired database 32 has been selected, buyer 22 may conduct an advanced text search for a desired item as shown at decision point 74 and illustrated in FIG. 3. As shown in FIG. 3, buyer 22 may refine the area of searching be selecting a category as shown at point 76, enter a search string as shown at point 78, select boolean operators such as “OR” and “AND” as shown at point 80, and even select specific parameter fields to search as shown at point 82. Finally, the number of hits to display is selected at point 84. The user then reviews the search results at point 86. An example output according to one such search result is illustrated in FIG. 4. Then the system continues at decision point 52 as discussed above. However, if an item is not located and the user chooses to search a different set of catalog databases, then again selecting advanced text search at decision point 74 will pull up the most recent search. Thus, all of the search information does not have to be re-added.

More typically, however, a buyer 22 takes advantage of the normalization features of system 20 by navigating the organizational hierarchy of items stored within one or more databases 32 and uniquely identified using a class/attribute/value relationship rather than conducting an advanced search. Thus, if a text search is not conducted as shown at decision point 74, buyer 22 then selects item classes as shown at point 90. Buyer 22 drills down through the various item classes that are presented in a hierarchical format. As shown in FIG. 5, for example, selecting a class “gases” will present the sub-class under it. Selection of the sub-class will present the sub-sub-class and so on. The process continues as shown by decision point 92 until a leaf class (the last class in a class hierarchy) is selected.

Once a leaf class is selected, a parametric search engine is presented as shown at point 94. The parametric search engine presents the attributes associated with a specific item leaf class and valid values associated with each attribute. The attributes can be presented in a variety of selection objects, such as drop-down boxes, list boxes, and sets of check boxes as shown in the example of FIG. 6. The user selects the value and clicks an operator button. Within the Parametric Search, there is an undo button that removes the value in the search for items.

Typically there are three types of attributes: static, differentiating, and dynamic. SKU represents a specific item as defined by its differentiating attributes. For example, if an item is a shirt with differentiating attributes color and size, then blue XL shirt is a SKU. Static attributes define an intrinsic property of a product and do not vary based on a SKU. A differentiating attribute is an attribute that defines the uniqueness of a SKU. A dynamic attribute is an attribute that is associated with a product dynamically at buy time.

Once buyer 22 has selected all available attribute values then the buyer must determine if additional specifying is required as shown at decision point 96. If no additional specifying is required then system 20 passes to decision point 98. At decision point 98 the use of the class/attribute/value approach permits a comparison of multiple items that meet the parametric search criteria and the selection of the item that meets the buyer's specific requirements as best illustrated in the example of FIG. 7 and shown at point 100. While not illustrated in the Figures, item comparison may also be implemented when doing an advanced text search. By using the class/attribute/value approach, a consistent and specific determination of item elements is accomplished. In practice such an approach reduces buyer confusion regarding item features and provides a listing of all values available with respect to a specific attribute of interest to a specific buyer.

As shown in FIG. 7, additional item information may be reviewed by clicking on the hyperlink associated with the specific item. Moreover, information about the merchant or supplier 26 may be determined by clicking on the hyperlink next to the item. Additional information such as item identification number, manufacturer, units of measure, and pricing is also illustrated. Then system 20 continues as discussed above at decision point 52 where the item may be selected for purchase by clicking the “Add” icon and the process continues as discussed above until the procurement process is complete. If an item is not located using the class/attribute/value relationship approach then the user is returned to start 42. As with the advance text search option, if the select class option is again selected the most recent leaf category will be provided to avoid the need to re-enter all of the search criteria.

If a user desires additional specifying at decision point 96 of FIG. 2, then structured requisition subsystem 102 is invoked as shown in FIG. 8 to create a structured requisition. A key advantage of the invention is that buyer 22 has already reduced the scope of the item requisition through the familiar normalized selection process. Thus, in most cases item classes and subclasses have likely been determined. In many cases, the classes have been determined all the way down to a leaf class. However, if the leaf class has not been selected as shown at decision point 104, then buyer 22 is provided with a revised selection screen from which she can select from available classes to further refine the item selection process as shown at point 106. Unlike in the regular procurement process, however, the classes are not limited to the specified catalog database 32. Instead all the classes from the master or global catalog database 32 are made available to the user to expedite the item location process.

If a leaf class has already been selected or once a leaf class is determined, then a modified parametric search screen with the most recently selected acceptable class is provided at point 108. Similarly, unlike the regular item selection process discussed above, the attributes and value selections are not restricted to the database 32 originally selected by the buyer 22. Instead, they include all possible attributes and values for a selected leaf class in all catalog databases 32 available from back office 24. Thus, in many cases, a user will not have to manually enter any additional information into the modified parametric search screen. However, unlike the screen shown in FIG. 6, as shown at point 110 buyer 22 has the ability to add new values for any selected attribute to better identify a desired item as shown at point 112. For example, if a faster CD ROM drive is required, buyer 22 can add the speed of the drive required as a new value. Moreover, if a required attribute, such as screen size, is missing, the buyer may be given permission to add the newly desired attribute along with a desired value. In some cases, a buyer 22 may even be able to propose a new class hierarchy.

Under all circumstances a memo field is also provided for clarification of item requirements even if a buyer 22 is limited to only proposing new attribute values.

Once the structured requisition is completed at point 114, it is submitted to back office 24 by way of communications link 28. Communications link 28 was discussed with respect to FIG. 1, above. At the same time, buyer 22 is returned back to the calling point of system 20 at point 116 so that additional items may be selected or a partial order completed.

Upon receipt of the structured requisition at point 118, back office 24 reviews the requisition to determine if it is correct as shown at decision point 120. If not, then buyer 22 is notified at point 122 by way of link 28 and the structured requisition subsystem 102 terminates at end point 124.

If the requisition is correct, then it is compared with all items in the master database 32 corresponding to the selected classes/attributes/values as shown at decision point 126. If one or more matches are found at decision point 126, communications link 28 provides the purchase information to buyer 22 for order submission at point 128. In a preferred embodiment, an electronic mail message is sent to buyer 22 with a hyperlink that will be recognized by a web browser such as Netscape® Navigator or Microsoft® Explorer. Buyer 22 clicks on the hyperlink and is routed to a screen very similar to the comparison screen of FIG. 7, where the matches may be reviewed and the desired item selected. As discussed in greater detail below, buyer 22 preferably interacts with the buyer interface application 40 and back office 24, including databases 32 using a web browser. Upon selecting the desired item, buyer 22 is preferably immediately reinserted back into procurement system 20 as shown at point 130, returning to point 98, so that the purchase process may be completed.

A key advantage of the present invention occurs if the desired item is not in the master catalog database 32. At point 132 the structured requisition is automatically reviewed by back office 24 using the class/attribute/value information and normalized database information at its disposal. Based on the information provided by the buyer 22, automated systems of back office 24 route the structured requisition to potential suppliers as shown at point 134 using communications link 34. Communications link 34 was first discussed with respect to FIG. 1. Back office 24 knows the suppliers associated with particular classes and sub-classes of goods and can often fine-tune a requisition submission to very specific suppliers based on attributes and values provided within the structured requisition.

In a preferred embodiment, an electronic mail message is sent to potential suppliers again using hyperlink and web browser technology, as discussed above. Preferably, as discussed further below with respect to FIG. 10, supplier 26 interacts with a supplier interface application 135 using a web browser. As each supplier receives message at point 136, it clicks on the hyperlink and is brought to a screen where the structured requisition is provided within application 135. The supplier 26 may provide additional class/value/attribute information to better classify the item based on the specialized knowledge of the supplier and the items within its inventory. If the supplier has an item that it believes will meet the buyer's structured requisition criteria, it then submits a revised requisition as shown at point 138 that is then transmitted back to back office 24 by way of communications link 34 as shown at point 140. The revised requisition includes all of the item related information required by buyer 22 to make a purchasing decision. Under some circumstances portions of application 135 may even be part of back office 24, but the supplier 26 still requires some type of interface application such as a web browser.

Typically, all suppliers 26 receiving a structured requisition are given a predetermined amount of time to provide a revised requisition. When either the time for replying expires or all pre-selected suppliers provide a revised requisition, then at point 142 back office 24 compares the revised requisitions to determine the best supplier or suppliers for the specific buyer 22. Back office 24 uses a wide range of objective and subjective criteria to determine the best supplier(s) including geographic location, price, reputation, timeliness, and the like. Often, the criteria include those predetermined by the buying organization based on its specific requirements or desires. As a result, the wishes of the buying organization are automatically considered to expedite the purchase process and reduce both cost and inconvenience.

Once one or more items are screened as best meeting the needs of buyer 22, they are then provided to the buyer as shown at point 128, and discussed above.

As shown in FIG. 8, structured requisition subsystem actually forks at point 140. The first fork has been discussed above. However, the second fork, related to catalog update subsystem 150, is discussed in more detail in FIG. 9.

The use of a normalized parametric search has been discussed above. Every item in a catalog database is normalized in terms of class hierarchy with a final leaf class being followed by a series of attributes and attribute values. As a result of the normalization process, item determination and searching is greatly enhanced. When undertaking a structured requisition, the same normalized data is used to the extent that it is available to buyer 22. A specialized supplier having expertise with respect to the class/attributes/values with which a requisitioned item is associated then further refines the structured requisition. Thus, both a knowledgeable buyer 22 and a knowledgeable supplier 26 are providing normalized relationships between an item and its defining characteristics. The relationships are used to provide selective rule updates to the common language generator knowledge base 30 and to an associated catalog database 32 using the predetermined rules of the knowledge base, as updated from time to time, to convert raw or free form data into the preferred normalized format. Thus, once a catalog database 32 is established, the catalog database is continuously fine-tuned by suppliers, buyers, and changing market conditions of which both are aware.

While a separate knowledge base 30 is illustrated, it is possible to bypass the knowledge base 30 completely and update a database 32 directly, so long as the class/attribute/value relationships are maintained. An advantage of using a separate knowledge base 30, however, is where one or more new rules are specified that are later available to be able to normalize free form data.

As shown in FIG. 9, when a revised requisition is received from a specific supplier, the revised requisition is reviewed at point 152. The class/attribute/value relationships are extracted from the revised requisition and audited by back office 24 at point 154. The information is audited at point 156 by comparing it to existing class/attribute/value relationships to determine if the common language generated knowledge base requires one or more new predetermined rules with a subsequent refreshing to the catalog database of the updated information available for the item. Preferably, the information of several revised requisitions corresponding to a single structured requisition is compared to determine normalized consistency among various suppliers. Once the audit is completed, a determination is made at decision point 158 as to whether updated classes/attributes/values are required for the requisitioned item. If not, then the revised requisition is refined using pre-existing class/attribute/value information as shown at point 160. Then at decision point 162 the determination is made as to whether the requisitioned item should be imported into the supplier database associated with the specific supplier 26. If yes, then the supplier catalog database 32 is updated at point 164 using the updated information associated with the item and the sub-system then ends at termination point 166. If the supplier database 32 is not updated, then at decision point 168 the decision is made whether to import the requisitioned item into the master database(s) 32. If yes, then the master catalog database(s) are updated at point 170 using the updated information associated with the item. While not illustrated in the figure, the same approach may be used to update the standard buyer catalog database 32 instead of or in addition to the master database 32, if so desired. However, once the appropriate catalog database is updated, if any, sub-system 150 then ends at termination point 166.

Catalog database 32 has been designated fairly generically. The database 32 may be a separate database of items from a specific supplier. Alternatively it may be a composite database. When acting as a composite database, it may represent items from multiple suppliers that can be organized for and based on the buying habits of a single buying organization (e.g., the standard buyer catalog database discussed above) or upon the buying habits of a group of related buying organizations (e.g., as in hospitals and doctors' offices that are members of a group purchasing organization). Therefore, when a database 32 is updated, it may be any one or a combination of databases 32 depending on the desires of the supplier buyer 22 or her buying organization, suppliers 26, and back office 24.

At decision point 158 if the decision is made that the normalized information associated with the revised requisition is new, then the determination must be made whether to revise the common language generated knowledge base at decision point 172. If the decision is made not to update the knowledge base then sub-system ends at termination point 166. On the other hand, if the decision is made to update the knowledge base then it is updated with the new information at point 174. Then the decision must be made at point 176 whether to update existing catalog entries based on the updated knowledge base. If yes, then the entries are updated at point 178 using the updated normalized information that can be associated with the raw or free form item data associated with each entry. If no, then the entries are not updated. Then subsystem moves on to decision point 162 as discussed above.

The system based interaction between buyer 22, back office 24, and supplier 26 is explained in greater detail in FIG. 10. As shown in FIG. 10, buyer 22 interacts with a buyer interface application 40. Preferably, the interface is web based, permitting a buyer 22 to interact with application 40 using a standard web browser such as Netscape® Navigator or Microsoft® Explorer. Buyer 22 logs on and off from the browser to application 40 as shown by line 200. In turn the log on information is authenticated with a back office communications interface 202 as shown by communications link 28. As illustrated, besides authentication information, order placement information, structured requisition information, the buyer's supplier selection criteria, supplier availability, buyer notification or order status and the like is also communicated by way of communication link 28 between application 40 and interface 202. Even catalog data base information stored based on pointers provided by direct buyer inquiry to a database 32 may be sent using communications link 28.

After buyer 22 logs on, item selection is accomplished using a hot list, advanced text searching, class/attribute/value selection, or a structured requisition request as discussed above. The item selection process requires that a catalog database 32 be queried for information directly by buyer 22 as shown by line 204. An order submission is made as shown by line 64 and discussed above, that is passed to application 40 from buyer 22. Any required approval process is shown by item 66 and an order placement made after any approvals is shown by item 68, both of which were discussed above. Once an order is placed, order status may be passed from interface 202 to application 40 and then to buyer 22 as shown by line 206 until the order is fulfilled by a supplier 26.

If a structured requisition is required, the complete listing of available classes/attributes/values is retrieved from the master or global catalog database 32 as shown by line 208. The structured requisition is passed from buyer 22 to application 40 by line 210 where the structured requisition is submitted as shown at point 114, much as if it were an order. Alternatively, the information may be passed directly from buyer 22 to back office 24 by way of communications link 28. If one or more items is located using structured requisition subsystem 102, the information regarding item availability is typically passed from back office communications interface 202 to application 40. Next, the information is passed to buyer 22 in the form of an electronic message with a link pointing buyer 22 to a server with the desired item information. The hyperlinked information may be within back office 24 or transferred directly to application 40 as desired.

As shown in FIG. 10, buyer 22 has direct access to one or more catalog databases 32 that are not stored within buyer interface application 40. However, as shown by communications link 28 and discussed above, appropriate authentication is required before a user can access the catalog databases 32, requiring the use of the communication link 28 between buyer 22, application 40 and back office 24 with database 32. Once authentication is completed, buyer 22 can access database 32 as shown. As noted above, application 40 can also directly access database 32 by way of communications link 28 for database data corresponding to an item selected by a buyer 22 so that an order may be completed. The data elements transferred must be sufficient to 1) describe and identify the item including the normalized classes/attributes/values, part number, description, and 2) provide sufficient information to source the item, including vendor, cost, price, price history, and price expiration date. Typically, the data elements are transferred using pointer information provided by the inquiry of the database 32 by a buyer 22.

As shown in FIGS. 1 and 10, back office 24 itself is broken into a number of components. It includes catalog databases 32, back office communications interface 202, and the common language generator and CLG knowledge base 30. Each of the components can readily communicate with each other. For data transfer, a preferred mode of communication includes Extensible Markup Language (“XML”), which is a subset of the Standardized General Markup Language (“SGML”). HyperText Markup Language (“HTML”) is appropriate for small data transfers between various portions of procurement system 20.

In general, interface 202 is used to communicate with buyer 22 by way of application 40 as noted above. However, when accessing catalog databases 32, buyer 22 can preferably bypass buyer interface application 40 as long as authentication has been completed. Interface 202 is also used to communicate with supplier 26. As shown by line 216 all order placement, acceptance, and order status information is shared between interface 202 and supplier 26. When structured requisition subsystem 102 is being used, interface 202 provides the structured requisition as shown by line 218 and receives a revised requisition as shown by line 220. Supplier item data is shown by line 221. Each of these lines comprises a portion of communications link 34 shown in FIG. 1.

Supplier 26 has only limited contact with buyer 22 as shown in both FIGS. 1 and 10. The only direct contact between the two parties is when supplier 26 or its agent completes order fulfillment as shown by line 36.

Interface 202 uses information it receives from both buyer 22 and supplier 26 to selectively update catalog databases 32 as discussed with respect to catalog update subsystem 150 in FIG. 9.

Knowledge base 30 is the glue that relates an item selection process with the items actually stored within a database 32. It is formed using predetermined rules that have been established over time that relate items to class/attribute/value characteristics or relationships. These pre-determined relationships are pulled from CLG knowledge base 30 as shown by line 222 to be compared with potential classes/attributes/values received from supplier 26 as shown by line 220. Selective updating of the rules governing knowledge base 30 is shown by line 224. Line 226 represents the free form supplier item data to be normalized and then loaded into a database 32. The data is normalized using the class/attribute/value relationships that govern the common language generator and knowledge base 30.

Once the supplier data has been normalized using the class/attribute/value relationships of the CLG knowledge base 30, it is sent to an appropriate database 32 as shown by line 230 where the database entries are either imported or updated as shown by line 232. The complete listing of all class/attribute/value relationships used by CLG knowledge base 30 are also contained within databases 32 and transferred from the knowledge base as shown by line 234. These relationships are used to undertake parametric searching and item specifying as discussed above. The class/attribute/value relationships are then updated when required as discussed above with respect to FIG. 9.

The disclosed embodiments and examples are given to illustrate the present invention. However, they are not meant to limit the scope and spirit of the present invention. Therefore, the present invention should be limited only by the appended claims.

Van Etten, William R., Prator, Corey

Patent Priority Assignee Title
10108989, Jul 28 2011 TrueCar, Inc. System and method for analysis and presentation of used vehicle pricing data
10217123, Sep 09 2008 TrueCar, Inc. System and method for aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
10262344, Sep 09 2008 TrueCar, Inc. System and method for the utilization of pricing models in the aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
10269030, Sep 09 2008 TrueCar, Inc. System and method for calculating and displaying price distributions based on analysis of transactions
10269031, Sep 09 2008 TrueCar, Inc. System and method for sales generation in conjunction with a vehicle data system
10296929, Jun 30 2011 TRUECAR, INC System, method and computer program product for geo-specific vehicle pricing
10467676, Jul 01 2011 TrueCar, Inc. Method and system for selection, filtering or presentation of available sales outlets
10482510, Dec 21 2012 TrueCar, Inc. System, method and computer program product for tracking and correlating online user activities with sales of physical goods
10489809, Sep 09 2008 TrueCar, Inc. System and method for sales generation in conjunction with a vehicle data system
10489810, Sep 09 2008 TrueCar, Inc. System and method for calculating and displaying price distributions based on analysis of transactions
10504159, Jan 29 2013 TrueCar, Inc. Wholesale/trade-in pricing system, method and computer program product therefor
10515382, Sep 09 2008 TrueCar, Inc. System and method for aggregation, enhancing, analysis or presentation of data for vehicles or other commodities
10672047, Feb 07 2001 eXalt Solutions, Inc. Intelligent multimedia e-catalog
10679263, Sep 09 2008 TrueCar, Inc. System and method for the utilization of pricing models in the aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
10733639, Jul 28 2011 TrueCar, Inc. System and method for analysis and presentation of used vehicle pricing data
10740776, Jun 30 2011 TrueCar, Inc. System, method and computer program product for geo-specific vehicle pricing
10810609, Sep 09 2008 TrueCar, Inc. System and method for calculating and displaying price distributions based on analysis of transactions
10846722, Sep 09 2008 TrueCar, Inc. System and method for aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
10853831, Sep 09 2008 TrueCar, Inc. System and method for sales generation in conjunction with a vehicle data system
11107134, Sep 09 2008 TrueCar, Inc. System and method for the utilization of pricing models in the aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
11127057, Dec 08 2017 eXalt Solutions, Inc. Intelligent multimedia e-catalog
11132724, Dec 21 2012 TrueCar, Inc. System, method and computer program product for tracking and correlating online user activities with sales of physical goods
11182812, Sep 09 2008 TrueCar, Inc. System and method for aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
11244334, Sep 09 2008 TrueCar, Inc. System and method for calculating and displaying price distributions based on analysis of transactions
11250453, Sep 09 2008 TrueCar, Inc. System and method for sales generation in conjunction with a vehicle data system
11392999, Jul 28 2011 TrueCar, Inc. System and method for analysis and presentation of used vehicle pricing data
11532001, Jun 30 2011 TrueCar, Inc. System, method and computer program product for geo specific vehicle pricing
11580567, Sep 09 2008 TrueCar, Inc. System and method for aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
11580579, Sep 09 2008 TrueCar, Inc. System and method for the utilization of pricing models in the aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
11741512, Dec 21 2012 TrueCar, Inc. System, method and computer program product for tracking and correlating online user activities with sales of physical goods
11741514, Dec 08 2017 eXalt Solutions, Inc. Intelligent multimedia e-catalog
7299202, Feb 07 2001 EXALT SOLUTIONS, INC ; EXALT SOLUTIONS, INC , A DELAWARE CORPORATION Intelligent multimedia e-catalog
7305355, Jun 12 2000 Liberty Peak Ventures, LLC Universal shopping cart and order injection system
7328176, Jun 12 2000 Liberty Peak Ventures, LLC Universal shopping cart and order injection system
7334184, Mar 10 1999 Liberty Peak Ventures, LLC Method for online information sharing for completing electronic forms
7373314, Jun 15 2000 Liberty Peak Ventures, LLC Unified product purchasing method
7386475, Oct 05 2000 BLUE YONDER GROUP, INC Generation and execution of custom requests for quote
7412409, Jun 15 2000 Liberty Peak Ventures, LLC Online ordering medium and method
7512558, May 03 2000 Quantum Leap Research, Inc.; QUANTUM LEAP RESEARCH, INC Automated method and system for facilitating market transactions
7577592, Jun 12 2000 Liberty Peak Ventures, LLC Method, medium, and system for a universal shopping cart having order injection and common payment determination
7577593, Jun 12 2000 Liberty Peak Ventures, LLC Method, medium, and system for a universal shopping cart having order injection and common payment determination
7577594, Jun 12 2000 Liberty Peak Ventures, LLC Medium for a universal shopping cart having order injection and common payment determination
7580869, Jun 12 2000 Liberty Peak Ventures, LLC Method and system for a universal shopping cart having order injection and common payment determination
7624096, Nov 26 1999 Computer Associates Think, Inc Method of amending database contents
7644014, Oct 17 2001 Oracle America, Inc Document exchange framework for automated extensible markup language data in an e-procurement system and method
7835949, Jun 12 2000 Liberty Peak Ventures, LLC Method, medium, and system for universal shopping cart order injection and payment determination
7865403, Sep 27 2004 International Business Machines Corporation Method, system, and program for translating and interfacing between data pools and product information management (PIM) systems
7870033, Feb 07 2001 eXalt Solutions, Inc. Intelligent multimedia e-catalog
7925544, Jun 12 2000 Liberty Peak Ventures, LLC Method, medium, and system for universal shopping cart order injection and payment determination
8010375, May 11 2004 SAP SE Object model for global trade applications
8065189, Jan 15 2008 SCIQUEST INC. Method, medium, and system for automatically moving items from a first shopping cart to a second shopping cart
8065195, Jun 12 2000 Liberty Peak Ventures, LLC Method, medium, and system for universal shopping cart order injection and payment determination
8065202, Jan 15 2008 SCIQUEST INC. Form management in an electronic procurement system
8069096, May 27 2008 SCIQUEST INC. Multi-constituent attribution of a vendor's product catalog
8112317, Jan 15 2008 SCIQUEST INC. Providing substitute items when ordered item is unavailable
8140410, Sep 27 2004 International Business Machines Corporation Method, system, and program for translating and interfacing between data pools and product information management (PIM) systems
8161045, Feb 01 2007 The Boeing Company Use of associate memory learning agent technology to identify interchangeable parts in parts catalogs
8200552, Feb 07 2001 eXalt Solutions, Inc. Intelligent multimedia e-catalog
8219464, Sep 09 2008 TrueCar, Inc. System and method for sales generation in conjunction with a vehicle data system
8219465, Jun 15 2000 Liberty Peak Ventures, LLC Online ordering for a consumer
8285573, Jan 15 2008 SCIQUEST INC. Prioritizing orders/receipt of items between users
8359245, Jan 15 2008 SCIQUEST INC. Taxonomy and data structure for an electronic procurement system
8515817, Dec 31 2007 TRUECAR, INC Systems and methods of matching purchase requests with consummated sales
8521615, Sep 09 2008 TrueCar, Inc. System and method for sales generation in conjunction with a vehicle data system
8533064, Jun 12 2000 Liberty Peak Ventures, LLC Method and medium for universal shopping cart order injection
8533071, Feb 07 2001 eXalt Solutions, Inc. Intelligent multimedia E-catalog
8577749, Jun 12 2000 Liberty Peak Ventures, LLC Method, medium, and system for universal shopping cart order injection
8600822, Jun 15 2000 Liberty Peak Ventures, LLC Online ordering system and method utilizing normalized product feeds and insertion of order data without redirect
8676665, Jun 12 2000 Liberty Peak Ventures, LLC Method and medium for universal shopping cart order injection and payment determination
8682703, Jun 01 2007 Liberty Peak Ventures, LLC System and method for facilitating strategic sourcing and vendor management
8694429, Jan 15 2008 SCIQUEST INC ; SCIQUEST, INC. Identifying and resolving discrepancies between purchase documents and invoices
8756117, May 27 2008 SCIQUEST, INC. Sku based contract management in an electronic procurement system
8930244, Jan 15 2008 SCIQUEST, INC Method, medium, and system for processing requisitions
9020843, Sep 09 2008 TrueCar, Inc. System and method for aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
9020844, Sep 09 2008 TrueCar, Inc. System and method for calculating and displaying price distributions based on analysis of transactions
9111308, Sep 09 2008 TRUECAR, INC ; TRUECAR COM System and method for calculating and displaying price distributions based on analysis of transactions
9129325, Sep 09 2008 TRUECAR, INC ; TRUECAR COM; TRUECAR COM, INC System and method for aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
9189800, Jul 01 2011 TrueCar, Inc. Method and system for selection, filtering or presentation of available sales outlets
9230256, Jun 08 2001 W. W. Grainger, Inc. System and method for electronically creating a customized catalog
9245289, Jan 15 2008 SCIQUEST, INC. Taxonomy and data structure for an electronic procurement system
9245291, May 27 2008 SCIQUEST INC. Method, medium, and system for purchase requisition importation
9727904, Sep 09 2008 TrueCar, Inc. System and method for sales generation in conjunction with a vehicle data system
9754304, Sep 09 2008 TrueCar, Inc. System and method for aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
9754315, Feb 07 2001 eXalt Solutions, Inc. Intelligent multimedia E-catalog
9767491, Sep 09 2008 TrueCar, Inc. System and method for the utilization of pricing models in the aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
9811847, Dec 21 2012 TrueCar, Inc. System, method and computer program product for tracking and correlating online user activities with sales of physical goods
9818140, Sep 09 2008 TrueCar, Inc. System and method for sales generation in conjunction with a vehicle data system
9904933, Sep 09 2008 TrueCar, Inc. System and method for aggregation, analysis, presentation and monetization of pricing data for vehicles and other commodities
9904948, Sep 09 2008 TrueCar, Inc. System and method for calculating and displaying price distributions based on analysis of transactions
RE45371, Mar 10 1999 Liberty Peak Ventures, LLC Method for online information sharing for completing electronic forms
Patent Priority Assignee Title
4992940, Mar 13 1989 H-Renee, Incorporated System and method for automated selection of equipment for purchase through input of user desired specifications
5197005, May 01 1989 Intelligent Business Systems Database retrieval system having a natural language interface
5570291, Aug 24 1994 MOORE WALLACE USA LLC Custom product estimating and order processing system
5694551, May 20 1993 Moore Business Forms, Inc. Computer integration network for channeling customer orders through a centralized computer to various suppliers
5740425, Sep 26 1995 ZARBAÑA DIGITAL FUND LLC Data structure and method for publishing electronic and printed product catalogs
5758327, Nov 01 1995 COMDISCO, INC Electronic requisition and authorization process
5870717, Nov 13 1995 IBM Corporation System for ordering items over computer network using an electronic catalog
5970475, Oct 10 1997 QVALENT PTY LIMITED Electronic procurement system and method for trading partners
6009413, Nov 10 1994 Meta Platforms, Inc System for real time shopping
6014644, Nov 22 1996 PP INTERNATIONAL, INC , DBA PURCHASEPRO Centrally coordinated communication systems with multiple broadcast data objects and response tracking
6055516, Aug 10 1994 EPLUS INC Electronic sourcing system
6338050, Nov 16 1998 WHITELIGHT TECHNOLOGY, LLC System and method for providing and updating user supplied context for a negotiations system
6507856, Jan 05 1999 International Business Machines Corporation Dynamic business process automation system using XML documents
WO9802835,
////
Executed onAssignorAssigneeConveyanceFrameReelDoc
Jul 07 1999E-Plus Capital, Inc.(assignment on the face of the patent)
Sep 24 1999VAN ETTEN, WILLIAM R PROCURENET INC ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS 0102830861 pdf
Sep 24 1999PRATOR, COREYPROCURENET INC ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS 0102830861 pdf
May 15 2001PROCURENET, INC EPLUS INC ASSIGNMENT OF ASSIGNORS INTEREST SEE DOCUMENT FOR DETAILS 0119970856 pdf
Date Maintenance Fee Events
Nov 10 2008M1551: Payment of Maintenance Fee, 4th Year, Large Entity.
Nov 12 2012M1552: Payment of Maintenance Fee, 8th Year, Large Entity.
Nov 10 2016M1553: Payment of Maintenance Fee, 12th Year, Large Entity.


Date Maintenance Schedule
May 10 20084 years fee payment window open
Nov 10 20086 months grace period start (w surcharge)
May 10 2009patent expiry (for year 4)
May 10 20112 years to revive unintentionally abandoned end. (for year 4)
May 10 20128 years fee payment window open
Nov 10 20126 months grace period start (w surcharge)
May 10 2013patent expiry (for year 8)
May 10 20152 years to revive unintentionally abandoned end. (for year 8)
May 10 201612 years fee payment window open
Nov 10 20166 months grace period start (w surcharge)
May 10 2017patent expiry (for year 12)
May 10 20192 years to revive unintentionally abandoned end. (for year 12)