JP2012033139A - Product guide system and method, and computer program and recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To allow a user to extract product relevant information including different data for each area for each customer for each area easily in a product guide system.SOLUTION: A product guide system includes an information processing device 10 that can be accessed via an external terminal 20, and databases 11-13 storing product relevant information connected to the information processing device 10. To the information processing device 10 for supplying the external terminal 20 with the product relevant information in response to an access from the external terminal 20 is connected a user management table 15 where a user ID for specifying a user is associated with an area ID of an area to which the user belongs. The product relevant information stored in the databases 11-13 is also associated with the area ID of an area to which the product relevant information belongs. When the information processing device 10 receives the user ID from the external terminal 20, the information processing device 10 obtains the area ID of the area of the user from the user management table 15 to extract and output the product relevant information related to the area where the user resides from the databases 11-13 on the basis of the obtained area ID.

Description

  The present invention relates to a product guidance system in a production business that is deployed in a wide area, and more particularly to a wide area online ordering system for cataloging and ordering spare parts managed by region via a computer network. The present invention relates to a product guide system and method, a computer program, and a recording medium that are preferably used.

For example, a manufacturer of a production machine or the like may supply machine products throughout the country or globally. In this case, an online ordering system related to sales of spare parts is often configured and serviced so that the supply of spare parts (for example, parts and dedicated materials) related to machine products can be easily handled. Yes.
In general, the online ordering system related to sales of spare parts or the product management system for managing spare parts, etc., is generally managed by centrally managing the information of multiple databases that register inventory, prices, catalogs, etc., with the part ID as the main key. Yes. These databases are often located in different departments (eg, sales, design, procurement, field service) that manage information.

  For example, Patent Document 1 describes a system configuration in which a sales department terminal, a design department terminal, a manufacturing department terminal, a procurement department terminal, and a production system simulator are linked. In this system, information related to a product for which an order has been received is acquired by an order information receiving unit, and information related to components constituting the product for which an order has been received is acquired by a component information acquisition unit. The procurement method classification unit acquires the procurement method of the parts that make up the product, and sorts the reference destination into the manufacturing part information generation unit, the purchased part information generation unit, and the subcontracted part information generation unit according to the procurement method. Yes. At this time, the database is linked and used with the component ID as the primary key.

Japanese Patent No. 4241816

  However, for example, in sales of spare parts, available stock, prices, and product catalogs differ from region to region, and are often not managed by a single database. In particular, in the sales of spare parts in overseas expansion business, the difference in available stock, price, and product catalog by region is remarkable, and it is more often not managed by a single database. Therefore, a function for switching data to be displayed for each user's area is required.

  Moreover, in the system of the above-mentioned patent document 1, since component ID is made into the main key, there also exists a malfunction that the link with the customer information database managed for every customer cannot be taken. Therefore, even though the products and parts delivered to a specific customer are limited, the entire database must be searched, the search is time consuming and burdensome for the searcher, and the time is limited. If so, it may not be possible to search for suitable supplements.

  The present invention was devised in view of such a problem, and product-related information having different data for each region can be easily extracted for each region. Further, product-related information is extracted for each customer. It is an object of the present invention to provide a product guide system and method, a computer program, and a recording medium that can be used.

  In order to achieve the above object, the product guidance system of the present invention includes an information processing apparatus accessible from an external terminal, a database connected to the information processing apparatus and registered with product related information related to the product, The information processing apparatus outputs the product related information from the database to the external terminal in response to access from the external terminal, and the information processing apparatus includes the external terminal A user management table in which a user ID for identifying a user and a region ID of a region where the user is located is connected, and a region ID of a region to which the product related information belongs is also included in the product related information in the database. When the information processing apparatus receives the user ID during access from the external terminal, the user management table Obtaining a region ID of the region where the user is located, extracting the product related information regarding the region where the user is located from the database based on the region ID, and outputting the product related information to the external terminal. .

  In the database, an inventory database in which inventory information and delivery date information of a member related to the product and a region ID related to the member are linked and registered, price information of a member related to the product, and a region related to the member A price database registered in association with an ID; a catalog database in which catalog information of a member related to the product and an area ID related to the member are registered; and customer information related to the product; It is preferable that at least one of a customer database registered with a region ID associated with the customer is provided.

It is preferable that maintenance information regarding the customer's product is added to the customer database.
In the catalog information registered in the catalog database, the name of the product assigned according to the region and / or the name of a member related to the product is registered in association with the region ID. Is preferred.
The information processing apparatus associates a product ID of the product, a region ID of a region to which the product-related information belongs, and a product name of the product, and the product name is changed before the product name is changed. It is preferable that a product name maintenance table that can be written as the name and the product name after the change is connected.
It is preferable that the catalog information includes production stop information or compatible member information for members related to the product.
The user management table includes language information of the region along with the region ID of the region where the user is located, and the information processing apparatus converts the product related information extracted from the database into the language of the region. It is preferable to output to the external terminal.

  The database is an integrated database obtained by allocating and integrating a region ID of a region to which the data recording device managing the product belongs to a database recorded in the data recording device of each region, and the information processing device When the user ID is received at the time of access from a terminal, the region ID of the region where the user is located is acquired from the user management table, the database of the region where the user is located is accessed, and the region where the user is located It is preferable to extract the product related information regarding and output to the external terminal.

  The product guidance method of the present invention comprises an information processing apparatus accessible from an external terminal, and a database connected to the information processing apparatus and registered with product related information, wherein the information processing apparatus is accessed from the external terminal. In accordance with the product information, the product information is output from the database to the external terminal, and the information processing apparatus includes a user ID for identifying a user of the external terminal and a region where the user is located. A user management table associated with a region ID is connected, and a region ID of a region to which the product related information belongs is also associated with the product related information in the database, and the information processing apparatus is connected to the external terminal. When the user ID is received during access from the user, the area ID of the area where the user is located is acquired from the user management table. And extracting the product related information related to the region where the user is located from the database based on the acquired region ID, and outputting the extracted product related information to the external terminal. Yes.

It is preferable that the product-related information output to the external terminal includes a name of the product and / or a name of a member related to the product given according to the region.
The product guide program of the present invention is characterized in that the product guide method described above is programmed so as to be controllable by a computer.
The recording medium of the present invention is characterized in that the product guide program is recorded in a computer-readable format.

According to the present invention, a user management table is provided in which a user ID and a region ID of a region to which the user belongs, and the region ID of the region to which the product related information belongs is also linked to the product related information in the database. Since information related to the user's area is output to the accessing user, information unnecessary for the user is eliminated, and only necessary information appropriately limited can be acquired. As a result, the time and labor required to acquire information about the product can be greatly reduced. For example, when ordering a spare part as product-related information, the ordering work can be made more efficient.
In addition, by registering the name of the product assigned according to the region in the catalog information of the catalog database and displaying it appropriately, the convenience for the user is improved.
If the catalog information includes production stop information or compatible member information for a member related to a product, the convenience for the user is further improved.

In particular, when products are developed all over the country or globally, there is a huge amount of product-related information, and this regional information is used to properly organize and supply this huge amount of information. Doing so will lead to a significant improvement in service.
For example, in spare parts sales, the available inventory, prices, and product catalogs differ by region and are often not managed by a single database. By preparing integrated integrated databases and extracting only the information that identifies the region using the region ID as a key from the information in these databases, it is possible to supply appropriately limited information, which is also significant in terms of sales Lead to improved service.

It is a block diagram which shows the structure of the product guidance system concerning 1st Embodiment of this invention. It is a figure which shows the structure of the databases concerning 1st Embodiment of this invention. It is a block diagram explaining the process of the product guidance system concerning 1st Embodiment of this invention. It is a flowchart explaining the process of the product guidance system concerning 1st Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 1st Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 1st Embodiment of this invention. It is a block diagram which shows the structure of the product guidance system concerning 2nd Embodiment of this invention. It is a figure which shows the structure of the database concerning 2nd Embodiment of this invention. It is a figure which shows the structure of the user management tables concerning 3rd Embodiment of this invention. It is a flowchart explaining the process of the product guidance system concerning 3rd Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 3rd Embodiment of this invention. It is a figure which shows the structure of the user management tables concerning 4th Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 4th Embodiment of this invention. It is a block diagram which shows the structure of the product guidance system concerning 5th Embodiment of this invention. It is a figure which shows the structure of the databases concerning 5th Embodiment of this invention. It is a block diagram explaining the process of the product guidance system concerning 5th Embodiment of this invention. It is a flowchart explaining the process of the product guidance system concerning 5th Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 5th Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 5th Embodiment of this invention. It is a figure which shows the example of the product name maintenance table used for the product guidance system concerning 5th Embodiment of this invention. It is a block diagram which shows the structure of the product guidance system concerning 6th Embodiment of this invention. It is a figure which shows the structure of the databases concerning 6th Embodiment of this invention. It is a block diagram explaining the process of the product guidance system concerning 6th Embodiment of this invention. It is a flowchart explaining the process of the product guidance system concerning 6th Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 6th Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 6th Embodiment of this invention. It is a figure which shows the example of the product name maintenance table used for the product guidance system concerning 6th Embodiment of this invention. It is a figure which shows the structure of the databases concerning 7th Embodiment of this invention. It is a block diagram explaining the process of the product guidance system concerning 7th Embodiment of this invention. It is a flowchart explaining the process of the product guidance system concerning 7th Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 7th Embodiment of this invention. It is a figure which shows the example of a data display of the components name database of the product guidance system concerning 7th Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 7th Embodiment of this invention. It is a figure which shows the structure of the databases concerning 8th Embodiment of this invention. It is a block diagram explaining the process of the product guidance system concerning 8th Embodiment of this invention. It is a flowchart explaining the process of the product guidance system concerning 8th Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 8th Embodiment of this invention. It is a figure which shows the example of a data display of the components name database of the product guidance system concerning 8th Embodiment of this invention. It is a figure which shows the example of a display of the guidance by the product guidance system concerning 8th Embodiment of this invention.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
In each of the following embodiments, the present invention is applied to an online ordering system related to sales of spare parts (for example, parts and dedicated materials) such as machine products in a production business that is widely deployed throughout the country or around the world. A product guidance system will be described.

[First Embodiment]
First, a first embodiment of the present invention will be described with reference to FIGS.
As shown in FIG. 1, the product guidance system includes an information processing device 10 accessible from a client terminal (external terminal) 20, and databases 11 to 14 and a user management table 15 connected to the information processing device 10. Composed.

  As the databases 11 to 14, an inventory database 11, a price database 12, a catalog database 13, and a customer database 14 are prepared. The databases 11 to 14 are independent databases, and the information processing apparatus 10 integrates the inventory database 11, the price database 12, the catalog database 13, the customer database 14, and the user management table 15. The client can refer to necessary information from the database by accessing the server (information processing apparatus) 10 in which the system is installed from the PC terminal 20.

Among the databases 11 to 14, the stock database 11 and the price database 12 having regional characteristics may exist in a distributed manner for each region, or each region and the location where the information processing apparatus 10 is located. In addition, they may coexist.
As shown in FIG. 2, the inventory database 11 is also referred to as a member ID (hereinafter referred to as “component ID”) of a member related to the product (for example, a supplement such as a component or a dedicated material, hereinafter also simply referred to as “component”). ), Inventory information and delivery date information are registered as, for example, a table (inventory table) in association with an area ID where each member is used and prepared as inventory. Although only the data items are shown in FIG. 2, the part ID of each part, the number of each stock and the delivery date, and the area ID are registered for many members.

In the price database 12, as shown in FIG. 2, the part ID and price information of the parts related to the product are registered as, for example, a table (price table) in association with the area ID where each member is sold. It is. Although only the data items are shown in FIG. 2, the component ID, the price, and the region ID of the component are registered for many members.
As shown in FIG. 2, the catalog database 13 includes parts IDs of parts related to the product and catalog information (information for acquiring a catalog, here, product ID) handled by each member or a product related to each member. For example, it is registered as a table (catalog table) in association with a region ID. Although only data items are shown in FIG. 2, the component ID of each member (component), the catalog information, and the region ID are registered for many members.

As shown in FIG. 2, the customer database 14 is a product ID and user ID related to the product, and is registered as a table (customer information table), for example, in association with the region ID to which the user belongs. Although only data items are shown in FIG. 2, user IDs, product IDs, and area IDs are registered for many users.
As shown in FIG. 2, the user management table 15 is a table in which a user ID is registered in association with a region ID to which the user belongs.

When receiving a user access from the external terminal 20, that is, when logging on with a user ID, the information processing apparatus 10 refers to the user management table 15 and acquires a region ID associated with the received user ID. Then, in response to each information provision request from the user, information is provided by searching the databases 11 to 14 using the region ID as a key.
Although not shown in detail, the information processing apparatus 10 is connected to a data input unit (for example, a keyboard or a mouse), a data processing unit (CPU, memory, etc.) to which the data input unit is connected, and a data processing unit. And a computer having a data storage unit (large-capacity memory) and a processing result display unit (display unit, monitor display) connected to the data processing unit. The data processing unit is provided with the above processing functions by software (computer program).

Since the product guidance system according to the present embodiment is configured as described above, for example, product guidance processing is performed as shown in FIGS.
For example, when the user logs on with the user ID, the information processing apparatus 10 reads the user ID with the information input processing function (user information input unit) 10a, refers to the user management table 15 from the user ID, and receives the received user ID. The related area ID linked to is acquired. Further, the user ID and the area ID are delivered to the customer information table of the customer database 14 (step a2 in FIGS. 3 and 4).
When the user logs on, a window as shown in FIG. 5A is displayed on the user-side terminal 20, and the user inputs a password together with the user ID.

  Next, the information processing apparatus 10 refers to the customer information table of the customer database 14 based on the user ID and the region ID, acquires the related product ID, and catalog information displayed by the catalog search function (catalog search unit) 10b. (Step a4 in FIGS. 3 and 4). For example, in the data group as shown in FIG. 5B, a specific area (here, area B) is selected according to the area ID, and sent to the user-side terminal 20 to inform the user of FIG. A window as shown in FIG. 6 is displayed, and a selection is made as to which machine catalog is to be selected.

The region may be a domestic region, but here it is a region by country. For example, region A is Japan, region B is the United States, and region C is China.
When the user selects a catalog using the catalog search unit 10b, the catalog table in the catalog database 13 is referred to (step a6 in FIGS. 3 and 4).
Further, with respect to the selected catalog, the catalog table of the catalog database 13 is referred to, and a list of component IDs as shown in FIG. 5D is output to the user terminal 20 and its component search function (component search unit). 10c (step a8 in FIGS. 3 and 4).

Then, a window as shown in FIG. 6A is displayed to the user. The component search unit 10c, and selects which part the user has ordered, part ID, passes an area ID price table in the price database 12, the stock table of the inventory database 11 (FIG. 3, step a10 of FIG. 4).
To identify a part, the part ID is used, but even if the part ID is the same, there may be a subtle difference in the part depending on the area. Therefore, by specifying the area by the area ID and narrowing down the search range, the search time And avoid the inconvenience of providing a catalog of different parts, whether subtle in the wrong area.

The information processing apparatus 10 refers to the price database 12 and the inventory database 11 based on the selected component ID and region ID, and selects the price, among the data groups as shown in FIGS. Information on the currency unit, the number of stocks, and the delivery date is delivered to the order processing function (order processing unit) 10d as necessary (step a12 in FIGS. 3 and 4).
Finally, the information processing apparatus 10 designates purchase conditions in addition to information such as part ID, price, currency unit, inventory quantity, and delivery date as required, and an order form issuing function (order form issuing unit) 10e. To create a part order (step a14).

Then, a window as shown in FIG. 6D is displayed to the user to confirm the order.
According to the present apparatus and method, when a user logs in to the system, the corresponding area ID can be acquired from the user management table 15, the catalog display can be narrowed down, and the target product ID can be narrowed down. Become.

Thus, catalog search can be made efficient by limiting the search range to only products related to customers. Further, by limiting the disclosure range of customer information to only data associated with the customer ID, it is possible to prevent leakage of information of other customers.
When displaying the inventory data and price data of the parts selected in the catalog, the region ID and part ID can be used as search keys. Even for parts with the same ID, the availability and price of the stock can be switched for each area. It becomes possible to do.

[Second Embodiment]
Next, a second embodiment of the present invention will be described with reference to FIGS.
As shown in FIG. 7, the product guidance system includes an information processing device 10 accessible from a client terminal (external terminal) 20, and databases 11 to 14 and a user management table 15 connected to the information processing device 10. As the databases 11 to 14, an inventory database 11, a price database 12, a catalog database 13, and a customer database 14 are prepared.

  Normally, the catalog database 13 and the customer database 14 having no or little regionality among the databases 11 to 14 are provided at a base where the information processing apparatus 10 is located, and the regional inventory database 11 and the price database 12 are In the present embodiment, the integrated inventory database 11 and the integrated price database 12 are provided in the base where the information processing apparatus 10 is provided for the local inventory database 11 and the price database 12. , 12a, 12b, 12c,..., And 12a, 12b, 12c,... And the integrated inventory database 11 on a server accessible via the network. The database 11a, 11b, 11c of each place by the price database 12 ···, 12a, 12b, 12c, so that integrated management of ....

  FIG. 8 shows an example of the data configuration when the regional price databases 12a, 12b, and 12c are integrated into the unified price database 12A in this case. The price and currency unit data associated with the component ID are combined by adding the region ID to the key, and the component ID and region ID are newly managed as the main key. As a result, even if the part ID is the same, if the area to be managed is different, it is handled as different data.

In this example, the integration of price databases distributed by region is described, but the combination of databases to be integrated is not limited to this example.
Moreover, it is preferable to perform transmission to the integrated database of the database of each base at intervals (for example, 1 day to 1 month) which do not cause trouble in business.
According to the present embodiment, the information managed at each base is centrally managed in a state including part ID and area ID information, so that the latest information can be referred from other areas. As a result, the efficiency of the confirmation work is improved.

For example, in the first embodiment, when the logged-in user belongs to “Region A”, only the information of the region ID “Region A” is displayed to the user, which makes catalog search more efficient, It is possible to prevent leakage of customer information.
By transmitting data from the database distributed to each base to the integrated database at intervals that do not cause any business problems, the integrated database always reflects the latest information of each base. Also, as a system administrator, it is only necessary to update the database at each site as before, and there is an advantage that double management of the distributed database and the integrated database is unnecessary.

[Third Embodiment]
Next, a third embodiment of the present invention will be described with reference to FIGS.
In the present embodiment, as shown in FIG. 9, maintenance information (after-service information) related to the target product, such as a replacement result, a modification history, a traveling machine diagnosis report, and defect information, is added to the customer database.
Thereby, maintenance information can be used for after-sales service.
Therefore, a function is provided in the first stage of parts search, which refers to the customer database 14 shown in FIG. 9 based on the input user ID and area ID and presents a parts list linked to the after-service information to the customer.

For example, as shown in FIG. 10, the customer information table is referenced from the input user ID and area ID, and after-sales information related to the customer is searched (step b2).
Then, if there is a replacement result (step b4), the corresponding replacement item whose replacement time has come is presented to the user as a recommended replacement part list (step b6).
If there is a remodeling history (step b8), a recommended supplement list relating to the remodeled portion is presented to the user (step b10).

If there is a diagnosis report (step b12), a replacement parts list recommended in the report is presented to the user (step b14).
Furthermore, if there is defect information (step b16), a recommended replacement parts list relating to the defect portion is presented to the user (step b18).
After that, the process proceeds to a normal routine in which the user in FIG. 4 searches for catalogs and parts (step b20).

  For example, FIG. 11A shows an example of a list relating to these recommended replacement parts list (replacement parts replacement results), remodeling history, diagnosis report, and defect information. As shown in (b), a part purchase recommendation window can be displayed to advance the part purchase to the user. The display of the above list can give persuasive power in proceeding with parts replacement and the like, and can expect a business effect.

  After-sales service information whose user ID matches the customer ID will be disclosed, and the recommended parts list required for the customer will be presented with reference to the replacement results of the spare parts and the traveling machine diagnosis report. This also has the effect of reducing the time for searching for parts.

[Fourth Embodiment]
Next, a fourth embodiment of the present invention will be described with reference to FIGS.
In the present embodiment, the display language in the apparatus described in each of the above embodiments is replaced with a display language suitable for the region.
As shown in FIG. 12, the user management table 15 consisting of user IDs and area IDs has a data structure in which a selected language table 16 consisting of area IDs and selected languages is linked.
According to this, for example, when a user in the Japanese usage region logs in, the language is displayed in Japanese as shown in FIG. 13A, and when a user in the English usage region logs in, as shown in FIG. 13B. Displayed in English. In this example, the currency unit is also changed.

In the present embodiment, the information processing apparatus 10 has a screen for each language prepared based on the region ID, not limited to Japanese or English. It is not limited to Japanese and English.
In this way, by switching the display information for each user's region ID, data is automatically displayed in the region's standard language without the user having to select a language.

[Fifth Embodiment]
Next, a fifth embodiment of the present invention will be described with reference to FIGS.
In FIG. 14 and FIG. 15, the reference numerals already described are the same, and a part of the description is omitted.
As shown in FIG. 14, the product guidance system includes an information processing apparatus 10 accessible from a client terminal (external terminal) 20 and databases 11 to 11 connected to the information processing apparatus 10, as in the first embodiment. 14 and a user management table 15 and a product name maintenance table (also referred to as a product name maintenance table) 16.

  Among the databases 11 to 14, the inventory database 11, the price database 12, and the customer database 14 are the same as those in the first embodiment, and the description of these databases is omitted, but the catalog database 13 'has a data structure different from that of the first embodiment.

  That is, as shown in FIG. 15, the catalog database 13 ′ is similar to the first embodiment in that the part ID of the part related to the product, catalog information (information for acquiring a catalog, here, product ID) However, it is registered as a table (catalog table), for example, linked with each member or the region ID in which the product related to each member is handled, and also the product name and part name given according to each region Are registered in association with the region ID and component ID of the region. In FIG. 15, the stock database 11 and the price database 12 are not shown.

The parts related to the product are part configurations corresponding to the product specifications for each region, so there are parts that are unique to that region, but even parts that are similar to other regions, There are many cases where names (simply referred to as “part names”) are different. This also applies to product names (or brand names, simply referred to as “product names”), and even in the case of products that are similar to other regions, the names often differ from region to region.
The catalog database 13 ′ shown in FIG. 15 does not include the product ID, but may include the product ID.

  As described above, when the product name and the part name assigned according to each region are registered in association with the region ID and the component ID, when the user accesses this product guidance system, Since the product name and the part name corresponding to the region can be added and displayed, when the user refers to the catalog information, the region ID is determined by the user ID input by the information input unit with the product name or the part name. As a result, the reference range of each database table is switched in the downstream flow.

  For example, when the user logs on with the user ID, the information processing apparatus 10 reads the user ID with the information input processing function (user information input unit) 10a, refers to the user management table 15 from the user ID, and receives the received user ID. The related area ID linked to is acquired. Further, the user ID and the area ID are delivered to the customer information table of the customer database 14 (step a2 in FIGS. 3 and 4).

  As shown in FIG. 20, the product name maintenance table 16 is a table including items of a product ID, a region ID, an old product name, and a new product name. , B, and C, and the product name in each of the regions A, B, and D of the product whose product ID is C. Of these, the product ID in the region B of the product whose product ID is A In this example, the product name is changed from “Advance” to “Allmighty”.

The region may be a domestic region, but here it is a region by country. For example, region A is Japan, region B is the United States, and region D is Germany.
In this way, by associating the old product name and the new product name when the product name is changed by the product name maintenance table 16, the latest catalog of the product name is provided to the user as will be described later. be able to.

Since the product guidance system according to the present embodiment is configured as described above, for example, product guidance processing is performed as shown in FIGS.
For example, when the user logs on with the user ID, the information processing apparatus 10 reads the user ID with the information input processing function (user information input unit) 10a, refers to the user management table 15 from the user ID, and receives the received user ID. The related area ID linked to is acquired. Further, the user ID and the area ID are delivered to the customer information table of the customer database 14 (step c2 in FIGS. 16 and 17).
When the user logs on, a window as shown in FIG. 18A is displayed on the user-side terminal 20, and the user inputs a password together with the user ID.

  Next, the information processing apparatus 10 refers to the customer information table of the customer database 14 based on the user ID and the region ID, acquires the related product ID, and catalog information displayed by the catalog search function (catalog search unit) 10b. (Step c4 in FIGS. 16 and 17). For example, in the data group as shown in FIG. 18B, a specific region (here, region B, here, the United States) is selected according to the region ID, and sent to the user-side terminal 20, to the user, A window as shown in FIG. 18C is displayed, and the selection of which machine catalog to select is requested. At this time, the product name assigned according to each region is also displayed on the window.

When the user selects a catalog with the catalog search unit 10b (in this example, the catalog with the product name “Custom” is selected), the catalog table of the catalog database 13 is referred to (step c6 in FIGS. 16 and 17). .
Further, with respect to the selected catalog, the catalog table of the catalog database 13 ′ is referred to, and a list of component IDs as shown in FIG. 18 (d) is output to the user side terminal 20, and its component search function (component search unit) ) 10c (step c8 in FIGS. 16 and 17). At this time, a part name column is provided in the output part ID list, and part names assigned according to each region (in this example, “part 1”..., “Part1”... , “Teil 1”...

  Then, a window as shown in FIG. 19A is displayed to the user. At this time, the part name assigned according to each area is displayed on the window together with the part image. When the user selects and selects a part to be ordered (in this example, each of the parts name “part 4” and “part 546”), the part search unit 10c selects the part that the user wants to order, and the part ID and region ID. Are transferred to the price table of the price database 12 and the inventory table of the inventory database 11 (step c10 in FIG. 17).

When selecting this part, the user can select the part he / she wants to order using the part name used in the region, so that it is easier to identify the part than when selecting using the part ID, and the order can be made quickly. And it can be done smoothly, and it is difficult for incorrect orders to occur.
In addition, the component ID is used to identify the component. Even if the component ID is the same in different regions, there may be a slight difference in the component depending on the region, but a different component name is given depending on the region. Can be identified. Also, even if the part names are the same in different regions, the search range is narrowed down by specifying the region by region ID, so a catalog of parts can be provided according to that region, and misordering Not likely to occur.

Thereafter, as in the first embodiment, the information processing apparatus 10 refers to the price database 12 and the inventory database 11 based on the selected component ID and area ID, and the required data group [FIG. 6B]. , (C)], the price, the currency unit, the quantity of inventory, and the delivery date information are handed over to the order processing function (order processing unit) 10d (see step a12 in FIGS. 3 and 4).
Finally, the information processing apparatus 10 designates purchase conditions in addition to information such as part ID, price, currency unit, inventory quantity, and delivery date as required, and an order form issuing function (order form issuing unit) 10e. To create a part order (step a14 in FIGS. 3 and 4).

Then, a window as shown in FIG. 19B is displayed to the user to confirm the order.
As described above, according to the apparatus and method of the present embodiment, in addition to the effects of the first embodiment, the product name and the part name assigned to each region in the catalog database 13 ′ are also stored in the corresponding region. Products that are registered in association with the region ID and the component ID, and the product name and the component name are also displayed when the catalog information is displayed. Therefore, when the user orders the component, the product used in the region Since it is possible to place an order on the medium with reference to the name and the part name, it is easier to identify the part than when selecting using the part ID, the order can be made quickly and smoothly, and there is also an effect that an erroneous order is less likely to occur. Obtainable.

[Sixth Embodiment]
Next, a sixth embodiment of the present invention will be described with reference to FIGS.
21 and 22, the above-mentioned reference numerals indicate the same, and a part of the description is omitted.
As illustrated in FIG. 21, the product guidance system includes an information processing apparatus 10 that can be accessed from a client terminal (external terminal) 20 and databases 11 to 11 connected to the information processing apparatus 10, as in the fifth embodiment. 14 and a user management table 15, a product name maintenance table (product name maintenance table) 16, and a parts name database 17.

As shown in FIG. 22, the databases 11 to 14 are all the same as those in the first embodiment, and description of these databases is omitted. In FIG. 22, the stock database 11 and the price database 12 are not shown.
In the catalog database 13 of the present embodiment, as in the catalog database 13 ′ of the fifth embodiment, the part names assigned according to each area are registered in association with the area ID and the part ID of the corresponding area. Although not done, a part name database 17 is provided instead.

  As illustrated in FIG. 27, the part name database 17 is a part name corresponding to a part ID registered for each region (for each region ID) separately from the catalog database 13. When the user logs in to the product guidance system, the user's area ID is specified, and therefore, for each part of the logged-in user's product, the part ID is associated with the part name in that area. Information can be obtained.

  Here, the catalog database 13 is provided with a temporary storage data table (dynamic data table), and when the user logs in, the component corresponding to each component ID associated with the product used by the user is retrieved from the component name database 17. Are acquired in the catalog database 13 and transferred to the temporary storage data table.

Therefore, the temporary storage data table ensures information equivalent to the catalog database 13 ′ of the fifth embodiment in the catalog database 13 of the present embodiment.
In addition, as described above, the part name database 17 is provided separately from the catalog database 13 so that the catalog database 13 can be common in each region. When changing the part name, only the part name database 17 is rewritten. It focuses on the point that maintenance is well ensured.

Since the product guidance system according to the present embodiment is configured as described above, for example, as shown in FIGS. 23 to 27, product guidance processing is performed.
In this case, the region is a region for each country by exemplifying Japan, the United States, and Germany, but the region may be a domestic region.

First, when a user logs on with a user ID, the information processing apparatus 10 reads the user ID by using the information input processing function (user information input unit) 10a, refers to the user management table 15 from the user ID, and receives the received user ID. The related area ID linked to is acquired. Further, the user ID and the area ID are delivered to the customer information table of the customer database 14 (step d2 in FIGS. 23 and 24).
When the user logs on, a window as shown in FIG. 25A is displayed on the user-side terminal 20, and the user inputs a password together with the user ID.

  Next, the information processing apparatus 10 refers to the customer information table of the customer database 14 based on the user ID and the region ID, acquires the related product ID, and catalog information displayed by the catalog search function (catalog search unit) 10b. (Step d4 in FIGS. 23 and 24). For example, in the data group as shown in FIG. 25 (b), a specific region (here, region B, here, the United States) is selected according to the region ID, and sent to the user-side terminal 20, to the user, A window as shown in FIG. 25C is displayed, and a selection is requested as to which catalog of the machine is to be selected. At this time, the product name assigned according to each region is also displayed on the window.

When the user selects a catalog with the catalog search unit 10b (in this example, the catalog with the product name “Custom” is selected), the catalog table in the catalog database 13 is referred to (step d6 in FIGS. 23 and 24). . At this time, the part name in the region of the part corresponding to each part ID is transcribed in the temporary storage data table of the catalog database 13.
Further, with respect to the selected catalog, the catalog table of the catalog database 13 is referred to, and a list of component IDs as shown in FIG. 25 (d) is output to the user side terminal 20, and its component search function (component search unit) 10c (step d8 in FIGS. 23 and 24). At this time, a part name column is provided in the output part ID list, and part names assigned according to each region (in this example, “part 1”..., “Part1”... , “Teil 1”...

  Then, a window as shown in FIG. 26A is displayed to the user. At this time, the part name assigned according to each area is displayed on the window together with the part image. When the user selects and operates the parts he / she wants to order (in this example, the parts names “Part2” and “Part521”), the parts search unit 10c selects the parts he / she wants to order, and the part ID and area ID are priced. It is transferred to the price table of the database 12 and the inventory table of the inventory database 11 (step d10 in FIG. 24).

Also in this case, when selecting a part, the user can select a part that he / she wants to order using the part name used in the area, so it is easier to identify the part than when selecting using the part ID, Orders can be made quickly and smoothly, and erroneous orders are less likely to occur.
In addition, the component ID is used to identify the component. Even if the component ID is the same in different regions, there may be a slight difference in the component depending on the region, but a different component name is given depending on the region. Can be identified. Also, even if the part names are the same in different regions, the search range is narrowed down by specifying the region by region ID, so a catalog of parts can be provided according to that region, and misordering Not likely to occur.

Thereafter, as in the first embodiment, the information processing apparatus 10 refers to the price database 12 and the inventory database 11 based on the selected component ID and area ID, and the required data group [FIG. 6B]. , (C)], the price, the currency unit, the quantity of inventory, and the delivery date information are handed over to the order processing function (order processing unit) 10d (see step a12 in FIGS. 3 and 4).
Finally, the information processing apparatus 10 designates purchase conditions in addition to information such as part ID, price, currency unit, inventory quantity, and delivery date as required, and an order form issuing function (order form issuing unit) 10e. To create a part order (step a14 in FIGS. 3 and 4).
Then, a window as shown in FIG. 26A is displayed to the user to confirm the order.

  As described above, according to the apparatus and method of the present embodiment, in addition to the effects of the fifth embodiment, the part name database 17 is provided separately from the catalog database 13, so that the catalog database 13 is common to each region. When changing the component name, etc., only the component name database 17 needs to be rewritten, which has the advantage of facilitating maintenance.

[Seventh Embodiment]
Next, a seventh embodiment of the present invention will be described with reference to FIGS.
In FIG. 28 and FIG. 29, the above-mentioned reference numerals indicate the same, and a part of the description is omitted.
The schematic configuration of the product guidance system according to this embodiment is the same as that of the sixth embodiment shown in FIG.

  In the present embodiment, the configuration of the part name database 17 ′ is different from that of the sixth embodiment. That is, the information on the production stop flag and the compatible part ID is added to the part name database 17 ′ of the sixth embodiment in the part name database 17 ′ of the present embodiment.

  For example, FIG. 32 shows a data display example of the part name database 17 ′. As shown in FIG. 32A, as in the part name database 17 of the sixth embodiment, by region (by region ID). In addition to the main database in which the part name corresponding to the part ID is registered, as shown in FIG. 32 (b), for each part that has been discontinued, the production stop flag is linked. Thus, an auxiliary database is prepared in which information on IDs of compatible parts (compatible part IDs) that can be used as substitutes for parts that have been discontinued is linked.

  The auxiliary database shown in FIG. 32 (b) can be updated at any time by writing a production stop flag and a compatible part ID for the part when the production is stopped. In the present embodiment, an auxiliary database is provided for each region, and when a part is discontinued, a production stop flag and a compatible part ID are written into the auxiliary database and information on the compatible part is added. This compatible part information is obtained by associating the compatible part ID of the compatible part with the part name (part name in the region).

  In the example shown in FIG. 32B, the part with the part ID “1” and the part name “Part 1” is discontinued, and the ID of the compatible part that can be made a compatible part by adding a production stop flag to this part. “801” is written, and as the compatible part information, the compatible part ID “801” of the compatible part and the part name “Part 801” of the compatible part in the region are linked and written.

  Therefore, when the part name database 17 'is accessed, first, the main database [see FIG. 32 (a)] is called, and the auxiliary database [see FIG. 32 (b)] linked to the main database through the part ID is called. Thus, the part name “Part 801” can be provided together with the compatible part ID “801” as information on the compatible part to the part to which the production stop flag is added.

Since the product guidance system according to the present embodiment is configured as described above, for example, as shown in FIGS. 29 to 33, product guidance processing is performed.
In this case as well, the regions are shown as regions by country by exemplifying Japan, the United States, and Germany, but the regions may be domestic regions.

First, when a user logs on with a user ID, the information processing apparatus 10 reads the user ID by using the information input processing function (user information input unit) 10a, refers to the user management table 15 from the user ID, and receives the received user ID. The related area ID linked to is acquired. Further, the user ID and the area ID are delivered to the customer information table of the customer database 14 (step e2 in FIGS. 29 and 30).
When the user logs on, a window as shown in FIG. 31A is displayed on the user side terminal 20, and the user inputs the password together with the user ID.

  Next, the information processing apparatus 10 refers to the customer information table of the customer database 14 based on the user ID and the region ID, acquires the related product ID, and catalog information displayed by the catalog search function (catalog search unit) 10b. (Step e4 in FIGS. 29 and 30). For example, in the data group as shown in FIG. 31B, a specific region (here, region B, here, the United States) is selected according to the region ID, and sent to the user-side terminal 20, A window as shown in FIG. 31 (c) is displayed, and the selection of which machine catalog is selected is requested. At this time, the product name assigned according to each region is also displayed on the window.

  Then, when the user selects a catalog using the catalog search unit 10b (in this example, the catalog whose product name is “Custom” is selected), the catalog table of the catalog database 13 is referred to (step e6 in FIGS. 29 and 30). . At this time, the part name in the region of the part corresponding to each part ID is transcribed in the temporary storage data table of the catalog database 13.

Further, with respect to the selected catalog, the catalog database 13 is referred to, a part ID list is extracted from the catalog database 13 and outputted, and delivered to the part name database 17 '(step e8 in FIGS. 29 and 30).
Of the part ID list extracted from the catalog database 13, for the data containing the “production stop flag” in the part name database 17 ′, the “part name” corresponding to the “compatible part ID” is displayed in the part search unit. (Step e10 in FIGS. 29 and 30).

  That is, a window as shown in FIG. 33A is displayed to the user. At this time, the part name assigned according to each area is displayed on the window together with the part image. If the production stop flag is added to the part, the compatible part ID “801” and the part name “Part 801” of the compatible part in the region are also displayed to guide the compatible part. Then, when the user selects and selects a part (in this example, each of the part names “Part2” and “Part521”), the part search unit 10c selects the part that the user wants to order, and the part ID and region ID. Are transferred to the price database 12 and the inventory database 11.

Thereafter, as in the first embodiment, the information processing apparatus 10 refers to the price database 12 and the inventory database 11 based on the selected component ID and area ID, and the required data group [FIG. 6B]. , (C)], the price, the currency unit, the quantity of inventory, and the delivery date information are handed over to the order processing function (order processing unit) 10d (see step a12 in FIGS. 3 and 4).
Finally, the information processing apparatus 10 designates purchase conditions in addition to information such as part ID, price, currency unit, inventory quantity, and delivery date as required, and an order form issuing function (order form issuing unit) 10e. To create a part order (step a14 in FIGS. 3 and 4).
Then, a window as shown in FIG. 33B is displayed to the user to confirm the order.

As described above, according to the apparatus and method of the present embodiment, in addition to the effects of the sixth embodiment, for parts that have been discontinued, the user is informed that the parts are production discontinued parts and the IDs of compatible parts. Since the information with the part name of the part is displayed, the user can immediately grasp the status of the production stop and order a compatible part, which greatly improves convenience.
In the present embodiment, a part name database is derived from a main database [FIG. 32 (a)] that is substantially the same as the part name database 17 of the sixth embodiment and an auxiliary database [FIG. 32 (b)] related to production stop part assistance. Although the component name database 17 is configured only as an auxiliary database, the auxiliary database may be directly linked to the catalog database 13 ′ of the fifth embodiment through a component ID or the like.

[Eighth Embodiment]
Next, an eighth embodiment of the present invention will be described with reference to FIGS.
In FIG. 34 and FIG. 35, the above-mentioned reference numerals indicate the same, and a part of the description is omitted.
The schematic configuration of the product guidance system according to this embodiment is the same as that of the sixth embodiment shown in FIG.

  In the present embodiment, the configuration of the component name database 17 ″ is different from that of the sixth and seventh embodiments. That is, the component name database 17 ′ of the present embodiment includes the component name database 17 ′ of the seventh embodiment. Information about parts that have not been discontinued but have compatible parts is added to the auxiliary database.

  For example, FIG. 38 shows a data display example of the parts name database 17 ″. As shown in FIG. 38A, as in the parts name database 17 of the sixth and seventh embodiments, each area (area ID) is displayed. In addition to the main database in which the part ID and the part name corresponding to the part ID are registered, as shown in FIG. 38 (b), for each part that has been discontinued, the production stop flag is linked. In addition, information on compatible part IDs (compatible part IDs) that can be used as substitutes for parts that have also been discontinued is linked, and for parts that have not been discontinued but have compatible parts, substitute those parts. An auxiliary database in which information on compatible component IDs (compatible component IDs) is associated is prepared.

The auxiliary database shown in FIG. 38 (b) can be updated at any time by writing a production stop flag and a compatible part ID for the part when the part is stopped, and writes a compatible part ID when a compatible part is generated for the part. Can be updated at any time.
Also in this embodiment, an auxiliary database is provided for each region, and if a part is discontinued, or if a compatible part is generated that does not cause a production stop, the auxiliary database has a production stop flag and a compatible part ID, or The compatible part ID is written and information on the compatible part is added. This compatible part information is obtained by associating the compatible part ID of the compatible part with the part name (part name in the region).

  In the example shown in FIG. 38B, as in the seventh embodiment, the production stop flag and the compatible part ID “801” are written to the part with the part ID “1” whose production has been stopped, The compatible part ID “801” and the part name “Part 801” of the compatible part are linked and written. In addition to this, production of a part with the part ID “3” and the part name “Part 3” is not discontinued, but when a compatible part for this part is generated, the ID “802” of the compatible part is written and information on this compatible part is written. As shown, the compatible part ID “802” and the part name “Part 802” of the compatible part in the area are linked and written.

  Therefore, when the part name database 17 ″ is accessed, first, the main database [see FIG. 38 (a)] is called, and the auxiliary database [see FIG. 38 (b)] linked to the main database through the part ID is called. Thus, the component name “Part 802” can be provided together with the compatible component ID “802” as the compatible component information to the component to which the compatible component ID is added.

Since the product guidance system according to the present embodiment is configured as described above, for example, product guidance processing is performed as shown in FIGS.
In this case as well, the regions are shown as regions by country by exemplifying Japan, the United States, and Germany, but the regions may be domestic regions.

First, when a user logs on with a user ID, the information processing apparatus 10 reads the user ID by using the information input processing function (user information input unit) 10a, refers to the user management table 15 from the user ID, and receives the received user ID. The related area ID linked to is acquired. Further, the user ID and the area ID are delivered to the customer information table of the customer database 14 (step f2 in FIGS. 35 and 36).
When the user logs on, a window as shown in FIG. 37A is displayed on the user side terminal 20, and the user inputs the password together with the user ID.

  Next, the information processing apparatus 10 refers to the customer information table of the customer database 14 based on the user ID and the region ID, acquires the related product ID, and catalog information displayed by the catalog search function (catalog search unit) 10b. (Step f4 in FIGS. 35 and 36). For example, in the data group as shown in FIG. 37 (b), a specific region (here, region B, here, the United States) is selected according to the region ID and sent to the user-side terminal 20, A window as shown in FIG. 37C is displayed, and a selection is requested as to which catalog of the machine is to be selected. At this time, the product name assigned according to each region is also displayed on the window.

  Then, when the user selects a catalog with the catalog search unit 10b (in this example, the catalog with the product name “Custom” is selected), the catalog table of the catalog database 13 is referred to (step f6 in FIGS. 35 and 36). . At this time, the part name in the region of the part corresponding to each part ID is transcribed in the temporary storage data table of the catalog database 13.

Further, with respect to the selected catalog, the catalog database 13 is referred to, a part ID list is extracted from the catalog database 13 and output, and delivered to the part name database 17 '(step f8 in FIGS. 35 and 36).
Of the part ID list extracted from the catalog database 13, data that contains a “production stop flag” in the part name database 17 ″ and data that contains a “compatible part ID” that does not contain a “production stop flag” Displays the “part name” corresponding to the “compatible part ID” on the part search unit (step f10 in FIGS. 35 and 36).

  That is, a window as shown in FIG. 39A is displayed to the user. At this time, the part name assigned according to each area is displayed on the window together with the part image. If the production stop flag is added to the part, the compatible part ID “801” and the part name “Part 801” of the compatible part in the region are also displayed, and the production stop flag is added to the part. If the compatible part ID “802” is added, the compatible part ID “802” and the part name “Part 802” of the compatible part in the area are also displayed to guide the compatible part.

  Then, when the user selects and selects a part (in this example, each of the part names “Part2” and “Part521”), the part search unit 10c selects the part that the user wants to order, and the part ID and region ID. Are transferred to the price table of the price database 12 and the inventory table of the inventory database 11.

Thereafter, as in the first embodiment, the information processing apparatus 10 refers to the price database 12 and the inventory database 11 based on the selected component ID and area ID, and the required data group [FIG. 6B]. , (C)], the price, the currency unit, the quantity of inventory, and the delivery date information are handed over to the order processing function (order processing unit) 10d (see step a12 in FIGS. 3 and 4).
Finally, the information processing apparatus 10 designates purchase conditions in addition to information such as part ID, price, currency unit, inventory quantity, and delivery date as required, and an order form issuing function (order form issuing unit) 10e. To create a part order (step a14 in FIGS. 3 and 4).
Then, a window as shown in FIG. 33B is displayed to the user to confirm the order.

As described above, according to the apparatus and method of the present embodiment, in addition to the effects of the seventh embodiment, the production is not stopped, but the parts having compatible parts are compatible with the ID of the compatible parts. Since the information about the part name of the part is displayed, the user can select a compatible part as a candidate for ordering, which greatly improves convenience.
In the present embodiment, the part name database is derived from the main database [FIG. 32 (a)] substantially the same as the part name database 17 of the sixth embodiment and the auxiliary database [FIG. 32 (b)] related to the production stop part assistance. However, only the auxiliary database may be used as the part name database 17, and the auxiliary database may be directly linked to the catalog database 13 'of the fifth embodiment through the part ID or the like.

[Others]
Although the embodiments of the present invention have been described above, the apparatus, method, and computer program of the present invention are not limited to the above-described embodiments, and the above-described embodiments are within the scope of the present invention. It is also possible to carry out by changing a part of the above, or to implement only a part of the above-described embodiment or in various combinations.

DESCRIPTION OF SYMBOLS 10 Information processing apparatus 11 Inventory database 12 Price database 13, 13 'Catalog database 14 Customer database 15 User management table 16 Selection language table 17, 17', 17 "Parts name database 20 Client terminal (external terminal)

Claims (12)

An information processing apparatus accessible from an external terminal; and a database connected to the information processing apparatus and registered with product related information related to a product, wherein the information processing apparatus responds to an access from the external terminal. A product guidance system for outputting the product related information from the database to the external terminal,
The information processing apparatus is connected to a user management table in which a user ID that identifies a user of the external terminal is associated with a region ID of a region where the user is located,
A region ID of the region to which the product related information belongs is also linked to the product related information in the database,
When the information processing apparatus receives the user ID at the time of access from the external terminal, the information processing apparatus acquires a region ID of the region where the user is located from the user management table, and based on the region ID, the user from the database The product guidance system, wherein the product related information relating to the region where the product is located is extracted and output to the external terminal. The database includes
An inventory database in which inventory information and delivery date information of members related to the product and a region ID related to the members are linked and registered;
A price database in which price information of a member related to the product and a region ID related to the member are linked and registered;
A catalog database in which catalog information of a member related to the product and a region ID related to the member are linked and registered;
A customer database in which customer information related to the product and a region ID related to the customer are linked and registered;
The product guidance system according to claim 1, wherein at least one of the above is provided. The product guidance system according to claim 2, wherein maintenance information related to the customer's product is added to the customer database. In the catalog information registered in the catalog database, the name of the product assigned according to the region and / or the name of a member related to the product is registered in association with the region ID. The product guidance system according to claim 2 or 3, characterized by the above. The information processing apparatus associates a product ID of the product, a region ID of a region to which the product-related information belongs, and a product name of the product, and the product name is changed before the product name is changed. The product guide system according to any one of claims 1 to 4, wherein a product name maintenance table that can be written as a name and a changed product name is connected. 5. The product guidance system according to claim 2, wherein the catalog information includes production stop information or compatible member information for a member related to the product. In the user management table, the language information of the region is added together with the region ID of the region where the user is located,
The product according to claim 1, wherein the information processing apparatus converts the product related information extracted from the database into a language of the region and outputs the language to the external terminal. Guidance system. The database is an integrated database obtained by allocating and integrating the region ID of the region to which the data recording device managing the product belongs to the database recorded in the data recording device of each region,
When the information processing apparatus receives the user ID at the time of access from the external terminal, the information processing apparatus acquires the area ID of the area where the user is located from the user management table and accesses the database of the area where the user is located. The product guidance system according to claim 1, wherein the product related information relating to the region where the user is located is extracted and output to the external terminal. An information processing apparatus accessible from an external terminal; and a database connected to the information processing apparatus and registered with product-related information. The information processing apparatus receives the information from the database in response to access from the external terminal. A product guidance method for outputting product related information to the external terminal,
The information processing apparatus is connected to a user management table in which a user ID that identifies a user of the external terminal is associated with a region ID of a region where the user is located,
A region ID of the region to which the product related information belongs is also associated with the product related information in the database,
When the information processing apparatus receives the user ID at the time of access from the external terminal, obtaining a region ID of the region where the user is located from the user management table;
Extracting the product related information about the region where the user is located from the database by the acquired region ID;
And outputting the extracted product-related information to the external terminal. The product-related information output to the external terminal includes a name of the product and / or a name of a member related to the product given according to the region. The product guidance method described.   11. A product guide program, wherein the product guide method according to claim 9 or 10 is programmed to be controlled by a computer.   12. A recording medium in which the product guide program according to claim 11 is recorded in a computer-readable format.

Images