JP2003223483A - Trader selection supporting system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a system capable of reflecting the intention of a buyer, imposing a small load on a trader, and rationally selecting the trader in a trader selection supporting system having a menu enumerating traders information in a plurality of trade fields when a buyer and a seller select the traders. <P>SOLUTION: This trader selection supporting system is provided with trader DB and displays trader group information including, at least, group features, etc., 405f and 407f of the trader group itself in a menu 71. This system is also provided with selecting means 54 and 55 selecting the trader group while referring to the display. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a vendor selection support system. More specifically, for example, the present invention relates to a vendor selection support system that selects a vendor from a plurality of fields such as a construction company, an equipment dealer, and a real estate agent in order to order a custom-built house.

[0002]

2. Description of the Related Art For example, in a custom-built house, as mentioned above, a plurality of industries are involved. And, usually, a contractor selects a trader in many fields of industry,
We are designing and constructing houses.

By the way, the purchaser who is the owner desires to reflect the characteristics of the house in the design and construction. For example, the owner may desire a European-style model for cold regions. However, if a business operator in some business fields can only deal with the Japanese environment in a normal environment, the owner's hope may not be fulfilled, the business operator's burden may be increased, or the profit margin may be reduced.

[0004]

In view of the above-mentioned conventional circumstances, an object of the present invention is to provide a trader who can reflect the intention of the purchaser, has a small load on the trader, and can reasonably select the trader. To provide a selection support system.

[0005]

In order to achieve the above object, a feature of the vendor selection support system according to the present invention is that a vendor DB that stores information of vendors in a plurality of business fields,
The purchaser and / or the seller have a menu listing the vendors when selecting the vendors, and the menu can display a group of vendors having vendors in a plurality of business fields. At least the group information such as the group characteristics of the group itself is displayed, and a means for selecting the trader group is provided.

[0006] Here, it is desirable that the purchaser and / or the seller have means for searching the group of traders by group characteristics. Further, it is desirable that the group information includes member information of the trader group.

Further, the trader may be provided with means for searching the trader group by group characteristics and registering itself in the searched trader group.

[0008] Then, it may be provided with means for searching and displaying a business type that does not belong to the trader group.

[0009]

As described above, according to the feature of the vendor selection support system according to the present invention, the vendor group based on the group feature is formed, so that the vendor can reasonably select a job and the load is small. became. Moreover, by searching for and selecting the characteristics of the trader group, the purchaser can easily reflect his or her wishes. Moreover, since the group of companies is introduced through the network, etc., it has become possible to further promote the reduction of indirect costs.

Other objects, configurations and effects of the present invention will be apparent from the following embodiments of the invention.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, referring to the attached drawings,
The present invention will be described in more detail. FIG. 1 is a diagram showing a trader selection support system 1 of an electronic commerce (hereinafter “EC”) server according to the present invention. This EC server vendor selection support system 1 includes a network 2 that connects computers, a server computer 3 that manages product information, a buyer computer group 4, a seller computer group 5, and a vendor computer group 6. It has and. The network 2 constitutes the Internet according to a communication protocol such as TCP / IP and realizes data communication between a plurality of computers. The server computer 3 may be composed of a plurality of computer groups, and each computer group 4, 5, 6 is provided with client computers 4a, 5a, 6a, which are examples of a plurality of information terminals.

In the present embodiment, the sale of custom-built homes will be described as an example. "Purchaser" is "owner" and "trader"
"Housing contractors, equipment companies, real estate agents, etc."
Is. The "seller" may be a home sales specialist, but the "seller" may also serve as this, and
In some cases, "trader" and "seller" belong to the same capital series. A "group" is a collection of "traders" such as "construction shops, equipment companies, real estate agents, housing-related businesses".

Client computers 4a, 5a,
6a and the server computer 3 are not shown in the drawing by C
It is provided with a storage device such as a PU, a memory and a hard disk, a bus for data and addresses, and an interface such as a mouse, a keyboard and a display. In this specification, "database" is abbreviated as "DB".

The server computer 3 displays a database, which will be described later, by a WWW (World Wide Web) browser or the like in response to a request from a plurality of client computers 4a, 5a, 6a, and updates the recorded contents. And each means or component shown below is realized by software.

FIG. 2 shows a system block diagram of the server computer 3. In the computer main body 10, the hardware is omitted and only the software configuration is displayed. Application software is DB
The server 11 and the WWW server 12. The DB server 11 is a relational database application, and forms 13, which determine the display format,
A script 14 for processing specific data and a query 15 for searching data of specific conditions are used. Also,
Purchaser DB 16 that records information about buyers, seller DB 17 that records information about sellers, trader DB 18 that records information about traders, trader group (hereinafter referred to as “group”)
A group DB 19 that manages information on the above and an industry table 20 that stores the types of industries are provided.

Each of the DBs 16 to 19 and the business type table 20 is processed by the form 13, the script 14 and the query 15, and is associated with the hypertext 21 displayed by the WWW browser, and the network 2 (via the WWW server 12 and the router 3a). Published on the Internet).

The server 3 of FIG. 2 has a purchaser DB 16 and a seller DB 1 each having the fields shown in Tables 1 to 4.
7, a trader DB 18, a group DB 19, and an industry table 20. In addition, reference numerals 101 to 4 in the drawings and tables
Each item shown in 08 indicates a field as a structure of the database. Further, reference numeral 101f with f in the drawing
Each of the items shown in FIG.
These fields are displayed or input on the screen corresponding to the fields of 408. In the following notation, the word "field" may be omitted for the sake of shortening the document.

[0018]

[Table 1] [Buyer DB16] 101 Purchaser ID 102 Buyer password 103 Buyer name / name 104 Buyer Address 105 Seller ID 106 construction area 107 Construction type 108 date 109 budget 110 desired features

[0019]

[Table 2] [Seller DB17] 201 Seller ID 202 seller password 203 Seller name / name 204 Seller Address 205 Seller URL

[0020]

[Table 3] [Company DB18] 301 Supplier ID 302 Supplier password 303 Supplier name / name 304 Business Address 305 PR 306 Supplier URL 307 Business area 308 Industry Field 309 Group ID group

[0021]

[Table 4] [Group DB 19] 401 Group ID 402 Group password 403 Group name 404 Group leader ID 405 Group PR 406 Available area 407 Group characteristics 408 Group URL

[0022]

[Table 5] [Industry table 20] Body design Body construction Interior Exterior Electrical construction Communication work Landscaping Finance / Insurance real estate

In each of the above DBs, each ID 101, 20
1, 301 and 401 are index fields,
It is a key item for maintaining the uniqueness (unity) of each record. Each ID 101, 201, 301, 401 is
Although it is good to add automatically so that the natural number increases by 1,
The mail address (e-mail address) or home page address (URL) of each subject may be used as the ID. The passwords 102, 202, 302, 402 are automatically assigned in correspondence with the IDs 101, 201, 301, 401. Name / Name 103, 203, 303, 4
03 and each address 104, 204, 304 are input by each subject, but the group name 403 is input by, for example, a group leader selected from a trader forming a group. Each URL 205, 306, 408
Realizes links to websites of sellers, vendors and groups. Construction planned area 106, construction type 107 such as new construction or renovation, date 108 for delivery, budget 109,
The desired feature 110 is stored in the purchaser DB 16 when the buyer who is the owner inputs or selects it according to his / her wish.

Desired feature 110 and group feature 407
Is selected with a mouse or the like from pre-registered items displayed in a drop-down list format. These items are prepared from various viewpoints such as pure Japanese style, early American style, European style, etc., technical types such as cold climate, high humidity, dry climate, and construction methods. To be done.

The trader PR 305 is a PR comment of the trader, and the trader's DB 1 by the trader together with the trader's workable area 307 and the trader's industry field 308 such as interior and exterior.
8 is input.

The group PR 405 indicates the group policy such as "mastering Japanese-style architecture made of cypress".
R, entered by the group leader.

Then, between these DBs, the seller ID 105 of the buyer DB 16 is associated with the seller ID 201 of the seller DB 17. Also, group DB1
The group ID 401 of 9 is the group ID group 309 of the trader DB 18, and the group leader ID 404 is the trader D.
Each is associated with the vendor ID 301 of B18.

Construction planned area 106, area available for contractors 3
07 is input by the purchaser and the trader, respectively. Also,
The applicable area 406 of the group DB 19 is the group I.
Based on the relation between D401 and the group ID group 309 of the trader DB 18, it is automatically extracted and transcribed by the above query and script as the least common divisor of the trader applicable area 307.

Next, an example of a display screen on the client computers 4a, 5a and 6a and a data processing procedure on the server 3 will be described with reference to FIGS. The processing procedure on each computer is basically the form file 13, script file 1
4 and the query file 15.

As shown in FIG. 3, a trader who accesses the server computer 3 to join the trader group selects and inputs an appropriate item from the login screen, and the trader entry menu 70 is displayed on the screen display 50 of the client computer 6a. Is displayed. Then, the input items are transmitted to the server computer 3 by operating the input button 51, the cancel button 52 or the previous screen return button 53 displayed on the screen displayed on the client computer 5a.

Items that are required to be input are a registered trader ID 301f and a trader password 302f. In addition, the input field 6 shown in the drop-down list
0, for example, pure Japanese style, Early American tone,
Select the desired feature that suits the vendor from items such as European style.

After the input is completed, the input button 51
When is pressed, the already-registered trader-supportable area 307 corresponding to the record of the trader ID 301f and the industry field 308 of the trader are specified. Then, the available area 40 of the group DB 19 including the available area 307 for the vendor
6 is searched by the query, and the group ID 401 of the trader group corresponding to the available area 406 is acquired (FIG. 10, step S1).

Then, the trader group corresponding to the group feature 407 of the group DB 19 that matches the desired feature selected from the drop-down list 60 is extracted from the trader groups extracted in step 1, and the group ID 401 of the extracted group is acquired. Yes (Step S
2). Supplier group DB with this group ID 401
From 19, the supplier group name 403, the supplier group leader ID 404, and the supplier group PR 407 are specified.
Further, the trader name / name 303 of the group leader is specified from the group leader ID 404, and the description contents such as a list are extracted from these (step 3).

By comparing the group ID 401 with the belonging group ID group, the trader ID 301 of each trader participating in the group is specified (step S4). Supplier ID 3
The industry type 308 of the trader is specified from 01, and by referring to the industry type table 20, industries other than the industry type 308 of the group participant are extracted from the types of industry stored in the industry type table 20 (step S5). . Then, the above processing result is displayed on the screen display 50 as shown in FIG. 4 (step S6).

In FIG. 4, as a result of the above processing, the group list menu 71 appears on the display screen 50, and the individual area 54 for displaying the contents of each DB field displays the available area 406f and the group feature 407f, respectively. To be done. On the other hand, the list field 55 is D
A field sequence listing one or more records of B, the group name 403f of the trader group identified in steps 1 to 5, and the trader name 30 of the group leader.
3f, PR 405f of each group, and industry field list 61 not participating in the trader group are displayed for each group.
If multiple records are displayed, scroll bar 56
Can be moved by. 57 is a display record number. Here, the trader selects the record by referring to the non-participating industry field list 61 displayed in the record and moving the mouse cursor to the record of the trader group that wants to participate and clicking.

When any row is selected in FIG. 4 and the input button 51 is pressed, the group member list menu 72 shown in FIG. 5 appears on the display screen 50. The group list menu 71 is also a result display screen as in FIG. 4, and the group name 403f and the group leader 403f are set in the individual field 54 for inputting to each of the DB fields 101 to 408 or displaying the contents of each DB field. A trader name / name 303f, an available area 406f, a group feature 407f, a group PR 405f, a group URL 408f, and a non-participating field list 61 are displayed. On the other hand, the list field 55 is a field string that enumerates one or more of these DB fields as a menu, as in FIG.
301f, trader name / name 303f, trader address 304
When f and the industry field 308f are displayed for each trader and a plurality of records are displayed, the scroll bar 56 can be used to move the information, and the information of the traders participating in the group can be browsed. Also, the group URL 408
You can also refer to the HP of the group by clicking.

After browsing the information of the vendors that make up the group, the vendor pushes the input button 51 to transfer the necessary items to the fields of each DB, and the procedure for applying to join the group is completed. In particular, the group ID 401 is added to the belonging group ID group 309 of the trader DB 18, and these are associated with each other.

Next, a case will be described in which the purchaser who is the construction owner himself selects a group of contractors who order construction.
In the following description, mainly only the points different from the above description will be referred to.

A purchaser who accesses the server computer 3 to select a trader group enters appropriate items on the login screen. Thereafter, the purchaser registration menu 73 shown in FIG. 6 is displayed on the screen display 50 of the client computer 4a. Purchaser name / famous place 103
f, planned construction area 106f, construction type 107f, due date 1
Input necessary items in the fields of 08f, budget 109f, and desired feature 110f. Then, by pressing the input button 51, these input items are changed to the purchaser DB 16 of the purchaser concerned.
Memorized in.

The planned construction area 106 and desired feature 110 input to the purchaser DB 16 are collated with the applicable area 406 and group feature 407 of each group DB 19 by a query and a script, and a supplier group that matches the purchaser's request is extracted. To be done. Then, the extracted trader groups are displayed in the trader group list menu 71 shown in FIG.
Client computer 4a as a menu similar to
Is displayed in.

Here, when the purchaser selects the record of the trader group and presses the input button 51 in the same manner as in the previous embodiment, the business field 308 and the business field table 20 of each trader DB 18 constituting the trader group are displayed. Is checked. Then, as shown in FIG. 7, a group belonging member list menu 74 similar to that shown in FIG. 5 is displayed. If the user wishes to join the group, he / she selects the input button 51, and accordingly, the group member status display menu 75 of FIG.
Is displayed.

When the group includes contractors of all the industrial fields required for construction, a confirmation display 62 "All the industrial fields are available in this group" is displayed, and the input button 51 is pressed. Pressing completes the selection of supplier groups. On the other hand, when the type of industry necessary for fulfilling the purchaser's request is not available in the relevant group, a confirmation display 63 is displayed that "some of the types of industry are not available in this group". And, in this confirmation display 63,
An option button 64a for "leaving the selection to the group leader" and an option button 64b for "selecting a trader for each industry field" are displayed, and either one of them is selected. When the option button 64a is selected, the input button 51 is pressed to leave the selection of the trader group to the leader.

When the option button 64b is selected and the input button 51 is pressed, an additional vendor selection menu 76 similar to that shown in FIG. 5 is displayed as shown in FIG. Using the information of the planned construction area 106 of the purchaser, a trader applicable area 307f whose records are limited by a query and a script is displayed. The purchaser selects a trader from such a list.

On the other hand, when a group of vendors who can fulfill the demands of the buyer cannot be found, or when the leader is left to select the vendors for the shortage of industries, the planned construction area 106 of the buyer DB 16 and the vendor DB 18 are selected. Area 30
7 are related, and the companies that the area concerned overlaps are extracted,
An email will be sent to the extracted vendors to encourage the formation of a vendor group. Meanwhile, the client computer 4 of the buyer
A trader list such as the list field 55 shown in FIG. 5 may be displayed in a, and the purchaser may select a trader appropriately to form a trader group.

Finally, the possibilities of other embodiments of the present invention will be listed. In the above-described embodiment, the purchaser selects the trader group while performing input / browsing. However, instead of the purchaser, a seller such as a sales agent of the house purchaser ID1.
01 and the buyer password 102 may be used to log in to the server computer 3 and select an appropriate trader group on behalf of the buyer.

In the above embodiment, the business category 308 of the trader DB 18 is only one category, but a plurality of business categories may be stored.

In the above embodiment, the purchaser, seller, and trader connect to the server 3 via the computers 4-6. However, these are not only computers,
It is also possible to connect to the server 3 with an information terminal such as a mobile phone or PDA. The present invention can be constructed as a client-server system in which a client, which is an information terminal, accesses a server to perform processing.

In the above embodiment, the object to be sold on the EC server is described as a "custom house". However, the targets for sale include products and services other than real estate. For example, in the case of automobile sales, there are interior options, exterior options, tires, finance / insurance, etc. as industry classifications.

When the "trader" and the "seller" are the same entity, the trader DB and the seller DB may be configured as the same DB.

In the above embodiment, the group feature 407f is displayed outside the list field 55 on the screen of FIG. However, this group feature 407f may be displayed in the list field 55 in the same manner as or instead of the group PR 405f.

[Brief description of drawings]

FIG. 1 is an explanatory diagram of a vendor selection support system.

FIG. 2 is an explanatory diagram showing a software configuration in a server of the vendor selection support system.

FIG. 3 is an inquiry screen on the client of the vendor selection support system, and is a screen explanatory diagram for the vendor to log in to register itself.

FIG. 4 is a list of trader groups based on the input result to FIG.

FIG. 5 is a list of members belonging to a group selected in FIG.

FIG. 6 is a condition setting screen for a purchaser or a seller to select a trader after logging in.

FIG. 7 is a list display menu of members who belong to a certain group when the purchaser selects a certain group.

8 is a selection result display screen displayed after the input to FIG.

FIG. 9 is a list display menu of adders that can be added to a certain group.

FIG. 10 is a flowchart for narrowing down a supplier group.

[Explanation of symbols]

1 supplier selection support system 2 network 3 server computer 3a router 4 Purchaser computer groups 4a, 5a, 6a Client computer 5 seller computer groups 10 computer body 11 DB server 11 12 WWW server 13 form files 14 Script file 15 Query file 16 Purchaser DB 17 Seller DB 18 trader DB 19 group DB 20 industry table 21 Hypertext 50 display screen 51 New registration button 52 Cancel button 53 Previous screen return button 54 individual fields 55 List Field 56 scroll bar 70 Supplier Entry Menu 71 Group List Menu 72 Group member list menu 73 Buyer Registration Menu 74 Group membership menu 75 Group member status display menu 76 Additional supplier selection menu

   ─────────────────────────────────────────────────── ─── Continued front page    (72) Inventor Takakatsu Toyota             4-3-11 Kitakuhoji, Chuo-ku, Osaka-shi, Osaka Prefecture             No. Nextware Co., Ltd. (72) Inventor Keiji Urakubo             Nara City Nara City Gakuen Yamato-cho 1-157-2 (72) Inventor Yoshimasa Sakamaki             3-6-6 Katsuragi, Kita-ku, Kobe-shi, Hyogo

Claims (5)

[Claims] 1. A trader DB that stores information on traders in a plurality of business fields, and a menu that lists the traders when a buyer and / or a seller select a trader, and the menu includes a plurality of menus. It is possible to display a group of traders having traders in the field of business, and the menu displays at least group information such as group characteristics of the group itself. Support system. 2. The vendor selection support system according to claim 1, further comprising means for allowing a purchaser and / or a vendor to search the vendor group by the group feature. 3. The group information includes member information of the trader group.
Alternatively, the vendor selection support system described in 2. 4. The trader selection support system according to claim 1, further comprising means for a trader to search the trader group by group characteristics and to register itself in the searched trader group. 5. The trader selection support system according to claim 1, further comprising means for searching and displaying a business type that does not belong to the trader group.