Selection and ordering of lamp components

[0002] The present invention concerns the automated selection of lamp components based on user supplied inputs and access to a database of component information based on the user supplied inputs.

[0003] Customers trying to purchase or find out about lamp components have traditionally called customer service representatives. After explaining their lamp needs, the customers have been told what products the lamp manufacturer had available to satisfy those needs. The customer service representative may have been using out of date information to try to match the customers stated needs with the products then available. Additionally, customers frequently want more information than they can get from a brochure or other documentation available to the customer service representative.

[0004] The present invention allows a potential customer to specify a product option or criteria and rapidly receive accurate up to the date product descriptions that most closely match that criteria.

[0005] One exemplary embodiment of the present invention features a method of supplying product information to a user by means of a computer interface. The interface presents a list of product choices and a means for a user to select one or more items from the list of product choices. In response to this selection a response is displayed which provides a number of options concerning one or more characteristic of the product. A user then makes choices concerning those options and based on these choices by the user, a computer searches a database for one or more products that produce a best fit to the customer specifications and conveying the results of said search to the user.

[0006] An exemplary embodiment of the present invention is performed by means of a computer server which accesses a database or databases concerning product characteristics and availability. An interface is presented on a viewing screen of a client computer with which the server computer communicates. This communications can occur over the Internet or via other suitable computer networks such as a local area network. The presently preferred interface is by means of Web pages that are viewed on a browser on the client computer.

[0007] These and other objects advantages and features of the invention will become better understood through a review of the following detailed description of an exemplary embodiment of the invention when considered in conjunction with the accompanying drawings.

[0008] FIG. 1 is an overview of a computer system including a server computer and a client computer for communicating with each other by means of a wide area network such as the Internet;

[0009] FIG. 2 is a functional block diagram of a component query process in accordance with the present invention;

[0010] FIGS. 3 and 3A-3G are flow charts showing an interaction process between a host and client computer; and

[0011] FIGS. 4, 5, 5A, 5B, 5C, 6 and 7 are illustrative web page depictions of user interfaces used in conjunction with the exemplary embodiment of the present invention.

[0012] FIG. 1 depicts two nodes 20, 22 of a wide area network 10 such as the Internet used in practicing an exemplary embodiment of the present invention. A first node 20 is a client node and contains a personal computer 24 running typical applications programs such as word processing and communications software. Installed on the personal computer 24 is so called browser software for navigating web sites on the world wide web. The world wide web is group of internet nodes that conform to standards promulgated by the World Wide Web Consortium.

[0013] FIG. 1 also includes a schematic representation of portions of a telecommunications system 30 for allowing the personal computer 24 to communicate using well established communications protocols with an internet service provider (ISP) computer 32. The computer 32 communicates with a server computer 50 (at the node 22) that is typically much more powerful than the personal computer 24 at the first node 20. The server 50 executes server software that communicates with other computers in the network 10. A node having a server that conforms with the world wide web standard will typically have a hard disk storage device that stores many web pages, possibly designed and maintained by disparate entities. The term host computer is often applied to the computer 50 since that compute acts as a host for multiple world wide web pages.

[0014] The present exemplary embodiment of the invention is for use by a manufacturer of electric light bulbs which are commonly referred to as lamps. These lamps can be fluorescent or incandescent and come in a variety of sizes and exhibit a variety of light emitting properties. In the preferred embodiment of the invention the server computer 50 of FIG. 1 is a dedicated computer which hosts web pages to facilitate responses to user inquiries concerning lamps or lamp components.

[0015] In accordance with the invention, a user at the first node 20 communicates with the server 50 by making selections from a list of options presented by the server 50 on a display terminal 26. More specifically, a user controlled input device such as a mouse 28 or keyboard 29 allows one or more product choices to be selected from a list of product choices. Based on the product or products chosen by the user, a next interface display provides a number of options concerning one or more characteristics of the product and allows the user to choose from those options. The results of this selection procedure are then transmitted to the server computer 50. The server 50 then uses known data mining processes to search an available products database (typically stored on the hard drive of the server) for one or more products that produce a best fit to the customer specifications. The results of the search are conveyed back to the user over the network 10. As seen in FIG. 1 the server computer 50, may conveniently be one node of a local area network 52 having multiple other nodes which might, for example, make up a company wide intranet of the lamp manufacturer.

[0016] FIGS. 4, 5, 5A, 5B, 5C, 6, and 7 are examples of suitable web pages for use in implementing the present invention. Such web pages originate from the server computer 50 and are transmitted via the internet nodes to the personal computer 24 where they are displayed by the browser software running on that computer. A main or default screen 100 (FIG. 7) provides a number of links to other screens in a hierarchy of screen pages that become accessible by clicking on a particular link. The default screen 100 lists a number of products commonly available from a lamp manufacturer. A last link 102 on the screen 100 allows the user to bypass the interactive process of closest fit product selection and immediately go to a product order screen shown in FIG. 6.

[0017] The process outlined above is described in more detail in the functional block diagram of FIG. 2 and the flow charts of FIGS. 3 and 3A-3G. The customer uses the personal computer web browser to access the system by entering a UTRL for a lamp manufacturer web page 60 that lists available products in a listing on the user screen 100 with links to other pages. The FIG. 3 flowchart includes a first step 70 of locating the lamp component web page 60. Listing 1 below illustrates the hierarchical ‘Product Category Guide’ web page of FIG. 7.

[0018] Listing 1

[0019] Formed Components

[0020] Nickel

[0021] Stainless Steel

[0022] Copper

[0023] Wire

[0024] Molybdenum

[0025] Tungsten

[0026] Glass

[0027] Order Product (102)

[0028] When viewing this page, the customer selects 71 a product type of interest such as molybedenum wire from this list of options on the screen 100 or clicks on the link 102 to an ‘Order Product’ page directly. Clicking on the molybedenum wire link 104 causes the server computer to display 72 a different web page for viewing by the user.

[0029] A product selection web page 62 (FIG. 4) allows the user to check on current availability of a product without having to place an actual order by entering 73 the item number into a text box 73a. The availability information will indicate lead time to shipment, or it will tell the user that the product is not presently available. The process of filling out the form of FIG. 4 is documented in FIG. 3A. The invention utilizes both general and specific product characteristics. (See FIG. 4). For the molybedenum wire ordering interface example of FIG. 4, the user can also control the number of potential matches by changing the diameter range in a section of the web page. Once a customer has ordered material, he or she can enter a customer number 74 each time they return to the web site. Once the form is filled out, the customer clicks on either a submit button 160 or a cancel button 162.

[0030] An available products database 64 is used to determine 75 the best match between a customer input and the available products. The available products database contains two main data portions. A first data portion 76 contains performance ratings for each characteristic of a material family. A second data portion 77 contains specific products available within each family and includes, for example, specific characteristics such as lead time and container information. The manufacturing plant updates 78 the specific characteristics based upon raw material, capacity, container, etc., constraints. After any update to a specific characteristic, the customer order database is queried 79 for open orders. If any are found, the customer order database is updated and an updated order acknowledgment is automatically sent by electronic mail 70 to the customer.

[0031] Data mining software 80 compares the customer's criteria with the performance ratings by family. The software contains algorithms 81 for determining the weight of each characteristic in determining the “match score” for that family. The software does not simply find the closest match but it also must achieve a minimum match score based upon technical requirements. (See FIG. 3Bb).

[0032] The match determination is done in two steps. At a first step 82 a general (family) match is performed. Then the specific match step 83 is performed. If there is no material family match, the screen shown in FIG. 5A is displayed 84. The user can send e-mail to an engineer for an explanation of why there was no match. If there is a material family match, but no specific product match, the screen shown in FIG. 5B is displayed 84. The user can choose to view the close matches by clicking on a link L that presents the screen shown in FIG. 5C. This allows the user to confirm that there was not a mistake in the search and that the presentation of the FIG. 5B was correct. If both the general and the specific criteria match, the screen in FIG. 5 is displayed 84.

[0033] FIG. 5 is a representative best available products screen 200. When there is a material family match, each characteristic is listed with the customer's criteria shown next to the product family rating for comparison. The user can click on a material family link 202 to see technical and performance data. The designation KW is a group of wire products made from a certain material. A separate page (not shown) lists applications and reasons for use of this family of materials, physical characteristics of this family of material and typical chemical compositions of this family of material.

[0034] A region 204 of the Best Available products page 200 contains a side by side listing of the customer's choice criteria from the previous page 62 and a product rating for the products chosen by the data mining software based on a search of the database using the customer criteria. When there is a specific product match, a next section or region 206 lists the items that meet the criteria with their values for each characteristic so the user can compare and select the optimum product. The available containers for the wire has a separate link 208 which can be selected for more information about packaging. This information relates to the material dimensions and capacity of the wire containers. The user can click on this link 208 to learn about the available containers. The user can select items of interest by checking a box 220 underneath them. The user can click on a link 210 to get a quotation on the checked items. This will display 85 the quotation/order form screen 250 (FIG. 6). The user can click on a link 212 to send an e-mail to an engineer for technical assistance. The information displayed in the screen 200 is inserted into the email and the user can add comments as desired.

[0035] FIG. 6 is a quotation/order form web page screen 250. FIG. 3Ea and FIG. 3Eb describe the process of displaying 85 this screen in greater detail. If any items were checked in FIG. 5 or the customer number 252 was entered on a previous screen, that information will be displayed in appropriate text boxes 252, 256 on this page. If a customer is new, he or she must register by means of a link 254. The user enters and modifies the item numbers, quantities and date desired text boxes. The description is automatically updated from the item number entry in the text box. The user can ask for a current quotation by clicking on the link 258 and an e-mail is sent to the sales department to determine the price, and an e-mail response 70 is sent to the customer within a specified time such as 24 hours. The user can enter an order for the product by clicking on the link 260.

[0036] When the customer places an order 86 for the product, the requested order is entered in the customer order database 66. (FIGS. 2 and 3F). The item information is compared to the available products database 64. If the item is not available, a field in the customer order database 66 is updated to indicate this. If the item is available, the lead time is determined 90 obtained from the available products database. A ship date field in the customer order database is updated based upon the lead time. An e-mail is sent 91 to the customer acknowledging the order, listing the ship dates, and indicating if any ordered items are not currently available. This is within 24 hours. An order is sent to the manufacturing plant to manufacture 92 the product.

[0037] Marketing analysis 93 is performed using the steps of FIG. 3G. The data from the product inquiry database is analyzed for marketing use. Several analyses are performed. Which option and option combinations are most requested for each characteristic. Using the data mining software, material family matches with requests are determined and which product families were most requested is determined. The data mining software identifies 95 which specific products were most requested. This data is made available to a marketing department at the lamp manufacturer to determine what new products should be developed or offered.

[0038] While the application has use over the internet, the disclosed process for providing information also has application by research and development engineers seeking to learn which current product may satisfy their research needs. Thus, the company wide intranet 52 could be used by a product engineer seeking the same type of best fit information available to an outside inquiry. This capacity could be used to password protect information that would be suitable for use by company personnel but not suitable for customers.

[0039] While the present invention has been described with a degree of particularity, it is appreciated that it is the intent that the invention include all modifications and alterations from the disclosed design falling within the spirit or scope of the appended claims.