JP2002099703A - Information collection providing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To realize an information collection providing system capable of providing various analytic information speedily without assigning complicated and troublesome processing to a POS information provider. SOLUTION: 1 The POS result data of respective days is transmitted to an A super headquarter 1 from super stores A 11 to 13. 2 The POS result data collected from the respective stores are edited to have common layout and transmitted from the terminal of the headquarter 1 to a POS server 6 through the Internet 5. Among the POS result data which its own company transmits, dividing of the data whose providing to other member companies is to be permitted and the data whose providing is to be prohibited is set. 3 The server 6 integrates the POS result data from the respective members on the common layout and prepares an information permission/prohibition dividing management table. 4 In a permitted range, requested information is transmitted to the respective members via the Internet 5.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an information collecting and providing system for effectively utilizing POS information created by a retailer in a POS system widely used in the commodity distribution industry.

[0002]

2. Description of the Related Art In a retail business such as a supermarket, a POS system is introduced in many companies, and POS information created daily is sold and sold.
It is used for inventory management, store operation management, purchase management, customer information, and information analysis such as sales trend analysis. Since the POS information indicates the business contents of the company, the POS information is generally used in the company that created the POS information.

[0003] However, as the POS system has spread, the POS system, such as a comparative analysis of sales with other companies in the same industry, has been developed.
There has been a need to obtain various types of analysis information between peer companies using information, and recently, for example, a so-called RDS (Ryutsu Data Service) system has been introduced on a trial basis in order to meet this demand.

[0004] However, since the POS information essentially contains information that is to be kept secret from the company, the above-described conventional RDS
In order to use the system or the like, information that may be leaked to the outside is extracted from a large amount of POS information, and information analysis is performed between a plurality of companies that provide the extracted POS information. Accordingly, the processing of POS information becomes complicated and complicated in each company or in an inter-company information analysis company,
It is not enough in terms of timely provision of analytical information. In addition, the processing of the POS information is uniform, and the types of obtained inter-company analysis information are limited.

SUMMARY OF THE INVENTION The present invention has been made to solve the above-described problems, and is an information collecting apparatus capable of quickly providing various analysis information without imposing complicated processing on a POS information provider. The purpose is to realize a provision system.

[0006]

An information collecting and providing system according to a first aspect of the present invention collects and accumulates information from each of a plurality of members and, in response to a request from the member, transmits the accumulated information to the member. The collection of information from the above members is performed by dividing into the permission information that permits provision to other members and the prohibition information that prohibits provision to other members according to the setting of the member. Provision to members,
This is performed within the range of information from the member and permission information from other members.

The information collecting and providing system according to a second aspect of the present invention includes an accumulating means for accumulating information from the member, wherein the terminal means of each member and the accumulating means are connected by a transmitting means. The collection of information from the member and the provision of the information to the member are performed via the transmission means.

The information collecting and providing system according to a third aspect of the present invention includes a layout editing unit for storing information stored in the member-specific layout of each member in a predetermined common layout, and a stacking unit. Is designed to accumulate information in the common layout.

The information collection and provision system according to a fourth aspect of the present invention is a system in which a sales company is a member and POS information created by the sales company is information to be collected and provided.

In the information collection and provision system according to a fifth aspect of the present invention, the permission information and the prohibition information are classified according to the type of the layout item storing the POS information.

The information collecting and providing system according to claim 6 of the present invention is configured to classify permission information and prohibition information according to the type of product set by the member.

According to a seventh aspect of the present invention, there is provided an information collecting and providing system, wherein information relating to a product whose sales performance rank is higher than a predetermined rank during a predetermined period is permitted information, and information relating to a product having a rank lower than the predetermined rank is information. Is prohibited information.

[0013] Further, the information collection and provision system according to claim 8 of the present invention is characterized in that information relating to a product whose sales performance rank is lower than a predetermined rank in a predetermined period is permission information, and information relating to a product higher in rank than the predetermined rank. Is prohibited information.

According to a ninth aspect of the present invention, there is provided the information collecting and providing system, wherein the sales performance ranking in a predetermined period is higher than the predetermined first ranking, and the predetermined second ranking is lower than the first ranking. , And the information relating to the products lower than the first rank and higher than the second rank is prohibited information.

In the information collection and provision system according to the tenth aspect of the present invention, the information is provided to the terminal means of the member.
A menu for selecting prohibition is displayed, and information permission / prohibition division setting means for prompting the member to set information permission / prohibition division based on the display screen is provided.

The information collection and provision system according to the eleventh aspect of the present invention further comprises an information permission / prohibition division setting means capable of further discriminating other members and setting division of permission / prohibition of information. is there.

In the information collection and provision system according to the twelfth aspect of the present invention, the member (1) displays his / her own company name, (2) his / her company does not display his / her company name but belongs to his / her company. Allows selection of either displaying the affiliate group name or (3) not displaying the company name.
The prohibition category is set for members with the company name or company group name displayed in (1) or (2) above, and information provision to members who do not display the company name in (3) is prohibited. It is provided with permission / prohibition division setting means.

According to a thirteenth aspect of the present invention, there is provided an information collection and provision system, wherein a period of permission information can be set, and after the period elapses, the permission information is changed to prohibition information. Means.

According to a fourteenth aspect of the present invention, there is provided an information collecting and providing system which aggregates setting information from the information permission prohibiting section setting means according to any one of the tenth to thirteenth means for all members, and Information management means for specifying the permission / prohibition category of information on the common layout for each member, the type of information to be provided is displayed on the terminal means of the member, and information requesting the member to obtain based on this display screen Request information type input means for prompting input of type setting;
And providing information for determining whether or not the request information type can be read from the request information type input means based on the permission / prohibition category of the information management means, reading the readable information from the accumulation means, and sending it to the terminal means of the member. It is provided with processing means.

Further, the information collecting and providing system according to claim 15 of the present invention is arranged such that, when providing information on a product to a plurality of wholesalers who supply the product to a dealership company as a member, Is permitted to be provided only to wholesalers.

An information collection and provision system according to a sixteenth aspect of the present invention provides information about a product to a plurality of wholesalers who supply the product to a dealership company as a member. If different wholesalers supply products of the same type to a plurality of stores belonging to the dealership company, the information on the stores should be limited to the wholesalers that are the product suppliers to the stores. It was done.

[0022]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Embodiment 1 FIG. 1 is a diagram showing the overall configuration of an information collection and provision system according to the present invention. First, an outline of the information collection and provision system will be described as a first embodiment based on FIG. This system accumulates POS information created in a plurality of member companies registered in advance as a database on a POS server 6 via the Internet 5 and manages permission / prohibition of information disclosure, and then returns to the Internet again. 5 is provided to each member company with necessary analysis information.

First, in the figure, each of the A supermarkets 11, 12, 13 of the A supermarket headquarters 1 which is a member of the dealer company.
Is transmitted to the A super headquarters 1. This is performed in the existing operation system, and of course, the Internet may be used for this transmission. The B supermarket 2 also has the B supermarket 2
The POS result data is transmitted to the B supermarket headquarters 2 from 1 and 22. A wholesaler 3 and a B wholesaler 4 are also members, but in the present system, they are members solely for the purpose of obtaining information.

Then, the POS actual data collected from each store is transmitted from the terminals of the A super headquarters 1 and the B super headquarters 2 to the POS server 6 via the Internet 5. In this case, in each member company, the POS data is edited in a company-specific in-house layout.
Edit and send to the common layout set in this system. This makes it possible to process POS information from a plurality of companies in a unified manner.

Although the contents of the POS result data from each member company are transmitted in principle as they are (the layout is edited), as will be described in detail later, each member company transmits the POS data transmitted by itself using its terminal. Among the performance data, a category is set for permitting or prohibiting the provision to other member companies (information permission prohibition category setting means).

Then, the PO sent from each member company
While accumulating S performance data on a common layout,
An information permission prohibition division management table or the like is created based on the information permission prohibition information from each member company. The various analysis data obtained using the POS performance data accumulated in the POS server 6 is transmitted via the Internet 5 to each of the member companies 1 to 4 and the in-company stores 11 to 13, 21 and 22.
Shows the state of being provided for display on the terminal. The information type requested by the member can be set from the terminal of each member by the request information type input means described later. In addition,
In providing this information, the information is of course created within the permitted range by using the information permission prohibition division management table and the like.

The following effects can be obtained by introducing the information collection and provision system according to the present invention. (1) Conventionally, each company independently analyzes management information such as sales trends based on daily POS performance data. By introducing this system, it is possible to standardize and analyze data of a plurality of companies. As a result, it is possible to reduce computer investment costs, save labor, and reduce operation and maintenance costs as a whole. (2) High-value management information, such as a comparison of sales trends among companies, can be obtained quickly, and the degree of contribution to corporate activities is improved. (3) Since the use of the Internet allows companies to participate regardless of their business areas, P
Based on the OS data, for example, it is also possible to analyze a product trend in each region. (4) By participating in this system, wholesalers who deliver products to retailers can check daily sales trends of delivered products at any time, and can efficiently adjust production plans and take measures for sales plans. Can be planned.

Embodiment 2 In the second embodiment, details of the configuration and operation of the information collection and provision system according to the present invention will be described. FIG. 2 is a block diagram showing the information collecting and providing system according to the present invention. FIGS. 3 and 4 are diagrams showing the configuration of a master and a table used in the information collecting and providing system shown in FIG.

3 and 4, M1 is a company master, M2 is a password master, M3 is a store master, M4
Is a product master, M5 is a daily single item table, M6 is a disclosure company master, M7 is a disclosure analysis item table, M8 is a disclosure wholesale master, M9 is an analysis item master, M10 is a wholesale product master, and M11 is a wholesale master. Delivered retail goods master, M12
Is a public large classification master, M13 is a public medium classification A master, M14 is a public medium classification B master, and M15 is a public small classification master.

Next, an information providing and collecting system according to a second embodiment of the present invention will be described with reference to the drawings. First, when a company, for example, the A supermarket headquarters 1 newly participates in this system, a member is registered in the POS server 6 which is a system operator, and a logon code number (company code and ID) for online processing is provided. I'll give you Then, from the member terminal 1A of the A supermarket headquarters 1, the daily POS result data is
The output is transmitted to the S server 6.

In this case, the layout editing means 31 edits the POS data of the layout unique to the supermarket to a common layout which is unified by the present system and transmits the edited data. In the transmission operation, the member needs to perform the operation of member confirmation by inputting the login code and the login password set by the member, but this type of online means is commonly used. The description of the member confirmation operation will be appropriately omitted at each operation.

The POS result data transmitted from the member terminal 1A is stored in the accumulating means 60 of the POS server 6, and is accumulated as an information database 61 having a common layout. In addition, a product master 62 (for example, M4, 5, 10, 11, 12, and 12 shown in FIGS. 3 and 4) that defines correspondences for product names and codes, and also correspondences for business partners and supplier codes.
13, 14, 15), customer master 63
(For example, contents corresponding to M6, 7, 8, 9 shown in FIG. 4) are transmitted together.

Here, the administrator of the A supermarket headquarters 1 who has registered as a member (here, the administrator is the company (own company)
POS data management person in charge of the management department)
The operation of the information permission / prohibition section setting means 32 for setting the permission / prohibition section of the transmitted POS result data will be described.

First, in the flowchart of FIG. 5, when the member (administrator of the A super headquarters) logs on in step S1, his / her company code for determining whether or not the user is a logon target registered in advance in step S2. , ID,
Enter your password. Then, it is confirmed by the company master M1 and the password master M2 (step S3),
If they do not match, an error in the logon input is displayed (step S4), prompting the user to correct the input.

When a match is made and the logon is performed normally,
The member determines from the company code whether it is a supermarket (retail) or a wholesaler (wholesale) (step S5). Here, since it is a supermarket, it is next selected whether to input data or to analyze (step S6). Here, in order to input data, execution of data input (step S7) is executed according to the contents of the flowchart a.

Next, execution of data input (step S7)
Will be described based on the flowchart a in FIG.
First, in step D1 of FIG.
Enter your ID and password. Then, it is determined whether or not it is a logon manager code (step D2). That is, at the time of member registration, in addition to a logon code as a member, a code for a management department for setting an information permission prohibition category and a code for a business sales planning department for requesting an analysis result based on POS information are registered. In this step D2, this code is determined.

Then, it is confirmed by the company master M1 and the password master M2, and if they do not match, an error of the logon input is displayed (step D3) to prompt the user to correct the input. If they match and the logon is successful, the process proceeds to step D4. Next, the management menus displayed on the terminal screen are sequentially selected (step D4), and the following settings are made. Assuming that the super company information registration process is performed (step D5)
YES), the company name and the like are set on the super company information display screen shown in FIG. 7 (step D6).

That is, 1. Enter the display name when displaying the company name. When displaying, here, "A supermarket" is input. Do not enter if not displayed. 2.
When the company name is not displayed, the name of the organization to which the company belongs is registered. For example, as shown in the figure, if the user belongs to the "East Japan Supermarket Association" and the "West Japan Supermarket Association" and the fact can be displayed, registration is designated.

When the company name is displayed, information based on the POS data from another member who has permitted the information disclosure to the company can be obtained. If the name of the affiliated organization is displayed without displaying the company name, information based on the POS data from other members who have permitted the information disclosure to the affiliated organization can be obtained.

If no display is made, information based on POS data from other members cannot be obtained. If the system does not request inter-company analysis information but requests management analysis or the like based solely on the POS data of the own company, the company name need not be displayed.

Next, as shown in FIG. 6, if supermarket public information registration processing is to be performed (YES in step D7), an object for which publication is permitted is set on the supermarket public information display screen shown in FIG. 8 (step D8). ). First, 1. Then, a partner company to which information disclosure is permitted is set. When setting a partner company, a company to which disclosure is permitted may be selected from a list of retailers. If the publication period is to be limited, the publication permission period is set.

2. Is used to set the permission / prohibition category in the product type. In this case, the category is set in large classification units such as "perishable section". 3. Is used to input the number of product items to be disclosed, and the sales performance ranking for the predetermined period (for example, one month) is ranked in the top 100
This setting input is performed when the product is limited to the first place.

4. Is to set a data item, that is, a permission / prohibition category in the layout item type, and performs setting input of disclosure specification based on the displayed item list. 5. When the information created based on the POS result data permitted to be disclosed by the own company is provided to another member, the amount collected from the other member is input. The purpose is to increase the amount of public information from each member by compensating for the price of the disclosure (however, a description such as a master table of the amount of money for providing information is omitted).

Next, in FIG. 6, if the public information registration processing for wholesalers is to be performed (YES in step D9), wholesalers to whom disclosure is permitted are set on the wholesaler public information display screen shown in FIG. First, 1. Then, from the list of wholesalers, select the vendors whose publication is permitted, and also specify the publication period. This list of wholesalers is stored in the supplier master 6 which is sent separately from the member company and stored in the collecting means 60.
3 is displayed. 2. Then, a data item, that is, a permission / prohibition category in the layout item type is set.

3. Then, a product to be disclosed is designated by a product code or a JAN code. Or, a broad category of products,
The disclosure target can also be specified in the middle category and the small category. These lists are displayed using data of the product master 62 stored separately. 4. Then, input the collection fee at the time of publication.

Next, the operation of the information registration processing of the administrator of the wholesaler will be described. Returning to the flowchart of FIG.
In step S5, it is determined that it is wholesale. Next, input or analysis is selected (step S8). Here, in order to input data, data input is executed (step S
9) is executed with the contents of the flowchart b.

Next, execution of data input (step S9)
Will be described based on the flowchart b in FIG. First, in step D11 in FIG. 10, the administrator inputs an administrator code, ID, and password. Then, it is determined whether or not it is an administrator code (step D12).

That is, at the time of member registration, in addition to the logon code as a member, a code for a management department that performs registration processing of company information as a wholesaler is registered, and this code is determined in step D12. . Then, it is confirmed by the company master M1 and the password master M2, and if they do not match, an error of the logon input is displayed (step D13) to urge the input to be corrected.

Here, since it is the manager code, the process proceeds to step D14. Next, the management menu displayed on the terminal screen is selected (step D14), and the following settings are made. If the company information registration process is performed (YE in step D15)
S), the public company is selected and set on the wholesaler company information display screen shown in FIG. 11 (step D16). Referring to FIG. Then, the retailer code and name of the supermarket that permitted the information disclosure to the company (wholesaler) and the disclosure period are displayed, and the delivery destination company of the company's products is selected from these.

Next, 2. Now, for the display method of the registered contents of the supermarket, you can choose whether to display according to the type of your company's product for each supplier or to display according to the type of customer for each company's product Do. Further, in the next screen, 3. Then, 1. Register and confirm the merchandise information content and the company's own merchandise information selected in the supermarket. More specifically, the correspondence between the displayed product name or product code of the supermarket and the code or product name used by the company is registered to facilitate the use of information described later. These data are
The information is stored in the product master 62 and the supplier master 63 via the information management means 64 of the POS server 6. In addition, 3. In the display column of, the release period of each product presented by the supermarket and the fee for using the information are displayed.

As described above, the data set by the information permission / prohibition division setting means 32 is stored in the information management means 6 of the POS server 6.
4 and stored as an information permission prohibition division management table 65, and data specifying a necessary correspondence such as a product code and a business partner code are stored in the product master 62 and the business partner master 63 as appropriate.

Next, the operation of the request information type input means 40 (FIG. 2) when a supermarket requests an analysis result based on POS information will be described. First, a case will be described in which A supermarket, which is a retailer, analyzes only the company.
First, data analysis is selected in step S6 of FIG. Next, a selection is made between retail analysis and wholesale analysis (step S10). Here, in order to perform the analysis of the retail (including other companies), the analysis of the retail (Step S11) is executed according to the content of the flowchart c.

Next, a retail analysis is executed (step S1).
The content of 1) will be described based on the flowchart c of FIG. First, the analysis selects whether or not it is only other retailers (step S21). Here, the result is No because the analysis is only for the in-house retail. Then, the in-house retail analysis process (step S22) is executed with the contents of the flowchart e.

Next, the in-house retail analysis process (step S)
The contents of 22) will be described based on the flowchart e of FIG. First, a search condition is specified (step S3
1). The conditions specified here include, for example, analysis start date: FROM, analysis end date: TO, analysis target classification level (for example, large classification, OR, medium classification A, OR, medium classification B, OR, small classification), analysis. The number of target best / worst display ranks (for example, the best 100th place, the worst 50th place, etc.) can be considered. It should be noted that the conditions to be specified can be variously specified, such as specifying all of the conditions shown here or specifying an arbitrary number of conditions. In addition, the same can be said for the conditions specified below, and the description thereof will be omitted as appropriate.

Next, an item is designated (step S3).
2). As a method to specify here, the analysis item master M
From 9, a condition that the company code becomes the company code is extracted as a condition. Then, an analysis item code is displayed and an item to be analyzed is specified. This item refers to an item shown under “standard sales amount” shown in the daily single item table M5.

Next, the product master M4, the daily single item table M5, and the public large class master M12, the public class A master M13, the public class B master M14, and the public small class master M15, Using the master corresponding to the analysis target classification level designated in step S31,
Extract data. As an extraction method, a company code is extracted as a company code from each master and table, data of a sales date corresponding to an analysis period is extracted, and designated item data in a designated classification is extracted.

Now, in-house analysis processing (step S22)
Ends. Referring again to FIG. 12, it is determined whether the analysis is only for the company (step S23). Here, since the result is Yes, the analysis screen is displayed (step S24). FIG. 21 shows an example of the display screen at this time. First, FIG.
As shown in (a), data for each item of the best product in the designated analysis period and classification (here, a confectionery is taken as an example) is displayed. Then, when the user clicks, for example, a field of 55555504 product J on this display screen, data for each item of each store of the company is displayed in FIG.
The screen is displayed as shown in FIG.

In the case of in-house analysis, as another method, as shown in FIG. 27, a method of preparing an analysis software menu display screen in advance and designating a required analysis menu can be considered.

Next, a case where the supermarket A performs analysis of other retailers (supermarket B) or a comparative analysis of its own / other retailers will be described. First, returning to the flowchart c of FIG. 12, the analysis is only for other retailers (Yes in step S21).
Or the analysis is not just for in-house retail (step S
23) is selected. Then, step S25
Proceed to. Then, the other retail analysis processing (step S25)
Is executed with the contents of the flowchart f.

Next, another retail analysis processing (step S2)
The content of 5) will be described based on the flowchart f of FIG. First, a list of other retailers that can be made public is displayed (step S41, an example of a display screen is shown in FIG. 28 at 1). Here, for example, other retailers who may open their company to the company using their company code as a key are listed. Next, from among the other retailers, another retailer whose analysis is desired (hereinafter referred to as “publisher other retailer”) is selected (step S42).

Next, a search condition is designated (step S4).
3, 2, 3 and 4 in FIG. 28 show examples of display screens. ). Conditions specified here include, for example, analysis start date: FRO
M, analysis end date: TO, analysis target classification level (for example, major classification, OR, intermediate classification A, OR, intermediate classification B, OR,
Small classification), the number of analysis target best / worst display ranks (for example, the best 100 rank, the worst 50 rank, etc.) can be considered.

Next, the publishing company master M6 determines whether or not the designated condition is within the publishing range of the publishing source and other retailers (step S44). Next, when it is determined that the search condition is out of the range, the search condition is specified again (step S4).
3). If it is determined that it is within the range, the item is designated from the analysis item table for publication M7 and the analysis item master M9 (step S45). As a method of specifying here, the company code is extracted from the analysis item master M9 on condition that the company code is a company code of a publisher and other retailers.
Then, an analysis item code is displayed and an item to be analyzed is specified.

Next, the commodity master M4, the daily single item table M5, and the public large classification master M12, the public classified A master M13, the public classified B master M14, and the public small classified master M15, Using the master corresponding to the analysis target classification level specified in the previous step S43,
Extract data. As an extraction method, a company code is extracted from each master and table as a company code of a publisher and other retailers, data of a sales date corresponding to an analysis period is extracted, and designated item data in a designated classification is extracted.

Next, a selection is made as to whether or not to add another retail analysis other than the one selected above (step S47).
If another retail analysis is desired to be additionally performed, the display returns to the display of the publisher other retail list (step S41), and the above-described flow is performed again. If there is no other retailer who wants to analyze, the process returns to FIG.
The display processing of the analysis screen (step S26) is executed according to the contents of the flowchart g.

Next, the display processing of the analysis screen (step S2)
6) will be described based on the flowchart g in FIG.
First, from step S21 (analysis of other retailers only)
It is distinguished from step S23 (analysis of in-house / other retail) (step S51). Next, in the case of analysis of other retailers only (step S21), best / worst display of other retailers is performed (step S52). FIG. 22 shows an example of the display screen at this time.

First, as shown in FIG. 22A, data for each item of the best merchandise in the classification of the designated period of the other retail (B supermarket) is displayed. Then, whether or not to perform store analysis of other retailers (step S5)
Judge in 3). And in the case of Yes, for example, 5
Click the 555504 Commodity J column. Then, for this product, data for each item of each store of another retailer is displayed on the screen as shown in FIG. 22B from the information of the store master M3. FIG. 22 shows a screen display in the case where there is one other retailer. However, the present invention is not limited to this. For example, a display may be made to compare a plurality of other retailers, or a display screen may be displayed for each other retailer. Needless to say, various display methods can be considered.

In addition, the company / other retail analysis (step S2)
In the case of 3), the best / worst display of the company and the other retailers is performed (step S55), together with the analysis processing contents of the company's retail analyzed in step S22.
FIG. 23 shows an example of the display screen at this time. The data for each item of the best merchandise in the classification of the designated period of the company (A supermarket) / other retail (B supermarket) is displayed. Here, an example is shown in which one company is displayed as other retailers. However, the present invention is not limited to this, and when other retailers of multiple retailers are selected under the above conditions, multiple other retailers are displayed as appropriate. Will be done.

Up to this point, an example of retail analysis has been described.
Hereinafter, wholesale analysis, that is, the case of step S12 in FIG. 5 will be described based on the flowchart d in FIG.

First, in the execution of the wholesale analysis (step S12), a distinction is made between step S8 and step S10. This is from analysis by wholesale (step S8),
The analysis is based on the retail analysis (step S10). As a method of distinction, it can be easily determined whether the company code is retail or wholesale. First, a description will be given of the case of analysis of own wholesale by wholesalers.

In the case of analysis of own wholesale by wholesale, wholesale destination analysis processing (step S62) is performed according to the contents of the flowchart h. Next, wholesale destination analysis processing (step S6)
2) will be described based on the flowchart h in FIG.
First, the wholesaler who is going to perform the analysis (hereinafter referred to as own wholesaler)
Is displayed (step S7)
1). Next, a retailer to be analyzed is selected from the list (step S72).

Next, search conditions are specified (step S7).
3). The conditions specified here include, for example, analysis start date: FROM, analysis end date: TO, analysis target classification level (here, only small classification can be selected because wholesale is selected), analysis target best / worst display rank number (For example, the best 100th place, the worst 50th place, etc.) are conceivable.

Next, whether or not the designated condition is within the disclosure range of the publisher retailer is determined by the wholesaler for disclosure master M8 (step S74). Next, when it is determined that the search condition is out of the range, the search condition is specified again (step S73).
If it is determined that it is within the range, the item is designated from the analysis item table for publication M7 and the analysis item master M9 (step S75). As a method to specify here,
The company code is extracted from the analysis item master M9 on condition that the company code is a public retailer company code. Then, an analysis item code is displayed and an item to be analyzed is specified.

Next, data is extracted using the product master M4, the daily single item table M5, and the public sub-classification master M15. As an extraction method, a wholesale code is extracted from each master and table as a key, data of a sales date corresponding to an analysis period is extracted, and designated item data in a designated classification is extracted.

Next, it is selected whether or not to add an analysis of a retail other than the content selected above (step S7).
8). If additional retail analysis is to be performed, the display returns to the public retail list display (step S71), and the flow described above is performed again. If there is no other retailer that the user wants to analyze, the process returns to FIG. 16 to determine whether it is the next single retailer or a plurality of retailers (step S63).

If it is determined that the retail is a single retailer,
The display processing of the analysis screen (step S65) is executed according to the contents of the flowchart i. Next, the display processing of the analysis screen (step S65) will be described based on the flowchart i of FIG. First, the destination retail data is displayed. In the example of the display screen at this time, as shown in FIG. 24A, the data of the merchandise in the designated period of the retail (A supermarket), which is the delivery destination of the wholesaler, is displayed. Then, whether or not to perform a retail store analysis (step S82)
To judge. Then, in the case of Yes, for example, from the information of the store master M3, data for each product of each retail store is displayed on the screen as shown in FIG. 24B (step S83).

Next, it is determined whether or not analysis by date is to be performed (step S84). Then, in the case of Yes, for example, data for each date is displayed as shown in FIG. 24C (step S85). If it is determined that there are multiple retailers, an analysis screen is displayed. (Step S66).
FIG. 25 shows an example of the display screen in this case. FIG. 25 (a)
As shown in FIG. 7, retail data is shown for each product code of own wholesale. Then, when the data for each retail store is provided, the data for each store is displayed as shown in FIG.

Next, a case where a wholesale analysis is performed by a retailer will be described. First, in step S61 of the flowchart d of FIG. 16, it is distinguished from step S10.
As a method of distinction, it can be easily performed whether the company code is retail or wholesale.

Next, the wholesale analysis process (step S67) is executed according to the contents of the flowchart j. Next, the contents of the wholesale analysis process (step S67) will be described based on the flowchart j of FIG. First, a list of wholesalers that the destination retailer may disclose is displayed (step S).
91). Next, a destination retailer for the wholesale to be analyzed is selected from the list (step S92). Next, a list of available analysis products is displayed (step S93). Next, products that can be analyzed are displayed and selected from these products (step S94). Here, a plurality of products can be selected.

Next, a search condition is designated (step S9).
5). The conditions specified here may be, for example, analysis start date: FROM, analysis end date: TO, and the like.
Next, whether or not the designated condition is within the open range of the open retail is determined by the open wholesale master M8 (step S9).
6). Next, if it is determined that the value is out of the range,
A search condition is specified (step S95). If it is determined that it is within the range, the item is designated from the analysis item table for publication M7 and the analysis item master M9 (step S97).

As a method of designation here, a condition that the company code is a publisher retail code is extracted from the analysis item master M9 as a condition. Then, an analysis item code is displayed and an item to be analyzed is specified.

Next, a product master M4, a daily single item table M5, a wholesale product master M10, and a delivered product master M by wholesale.
11 to extract data. As the extraction method,
Extract the wholesale code from each master and table as a key,
The data of the sales date corresponding to the analysis period is extracted, and the specified item data in the specified classification is extracted (step S).
98).

Next, a selection is made as to whether or not to add a retail analysis other than the one selected above (step S99).
If additional retail analysis is to be performed, the display returns to the public retail list display (step S91), and the above-described flow is performed again. If there is no other retailer that the user wants to analyze, the process returns to the display method process (step S68) in FIG. 16 and the description will be given based on the flowchart k shown in FIG.

First, the number of each retailer for each product of the wholesaler (here, Y store) is displayed as shown in FIG. 26A (step S100). Next, it is determined whether or not to perform an analysis by retail store (step S101). If it is determined that the analysis for each store is to be performed, the information of the destination retailer is obtained by the store master M3, and the information is obtained by the store master M3 in FIG.
The screen is displayed as shown in (b) (step S10
2).

As described above, valuable management information such as sales trends of other companies in the same industry can be quickly obtained by simple operations.
This translates into a greater contribution to corporate activities. In particular, since the use of the Internet makes it possible to obtain information on companies in remote areas just as easily as others, it is also possible to perform useful analysis over a wide range, such as, for example, product sales trends for each region.

The analysis of the POS information of the company has conventionally been
Each supermarket company performed its own using its own computer equipment human resources. By introducing the information collection and provision system according to the present invention, it is possible to share and analyze data of multiple companies with the same system Therefore, as a whole, reduction of computer investment cost, labor saving and reduction of operation and maintenance cost are realized, and each company can obtain the analysis result of POS information at low cost without excessive investment.

Further, in the second embodiment, an example is shown in which only the best product (top 100) is limited to the permission information as the permission information. However, the present invention is not limited to this. An example is also conceivable that is limited to commodities up to 100th. Furthermore, it goes without saying that the permission information may be limited to the best (top 100) / worst (bottom 100) products.

Further, in the second embodiment, an example has been shown in which permission / prohibition information is set for all of the own company. However, the present invention is not limited to this, and the own company has a plurality of stores. In such a case, more detailed settings may be made in a master table or the like so as to classify detailed disclosure and non-disclosure so that the disclosure and non-disclosure can be separately set for each store.

Further, in the second embodiment, the example of displaying the company name of the own company (for example, B supermarket) has been described. However, the present invention is not limited to this, and the name of the company group to which the company belongs (for example, East Japan Supermarket Association)
May be displayed and the company name of the own company may not be displayed. In this case, it goes without saying that items corresponding to the master table or the like are appropriately added to the master table or the like so that a company group name or the like can be set.

In the above description, supermarkets and wholesalers delivering goods to the supermarkets have been described as examples of members of the present system. However, the present invention is not limited to these types of business. In addition, the information data and the analysis data described on each display screen and the like are merely examples, and it goes without saying that other types of information data and analysis data can be applied.

[0090]

As described above, the information collecting and providing system according to the first aspect of the present invention collects and accumulates information from each of a plurality of members, and transmits the accumulated information in response to a request from the member. A system for providing members with information collected from the member by dividing the information into permission information that permits provision to other members and prohibition information that prohibits provision to other members according to the setting of the member. The offer to members is
Since it is done within the range of the information from the relevant member and the permission information from other members, it is possible to collect information efficiently, and the confidentiality intended by each member is ensured, secure and useful Information provision is realized.

The information collecting and providing system according to the second aspect of the present invention includes an accumulating means for accumulating information from members, and connects terminal means of each member and the accumulating means by transmission means, Since the collection of information from and the provision of information to members are performed via the transmission means, the collection and provision of information can be quickly, uniformly, and economically processed.

The information collecting and providing system according to a third aspect of the present invention includes a layout editing unit for restoring the information stored in each member's individual layout to a predetermined common layout. Since the information is accumulated in the common layout, the processing of information from each member can be performed more efficiently and smoothly.

In the information collection and provision system according to the fourth aspect of the present invention, since the dealer company is a member and the POS information created by the dealer company is the information to be collected and provided, it is created every day. An enormous amount of POS information is efficiently processed and used effectively.

In the information collection and provision system according to the fifth aspect of the present invention, the permission information and the prohibition information are classified according to the type of the layout item storing the POS information. It is possible to classify permission / prohibition for each item.

In the information collection and provision system according to the sixth aspect of the present invention, the permission information and the prohibition information are classified according to the type of the product set by the member. Allowed / prohibited classification is possible.

[0096] The information collection and provision system according to a seventh aspect of the present invention provides the information relating to a product having a sales performance rank higher than a predetermined rank during a predetermined period as permission information, and the information relating to a product having a rank lower than the predetermined rank. Is prohibited information, information permission / prohibition of the product group can be classified in consideration of the sales performance rank indicating the business performance.

[0097] The information collecting and providing system according to claim 8 of the present invention provides information relating to commodities having a sales performance rank lower than a predetermined rank during a predetermined period as permission information, and information relating to a higher rank product than the predetermined rank. Is prohibited information,
Information permission / prohibition can be classified for a product group in consideration of the sales performance ranking indicating business performance.

[0098] In the information collection and provision system according to the ninth aspect of the present invention, the sales performance rank in the predetermined period is higher than the predetermined first rank, and the predetermined second rank is lower than the first rank. The information related to the products below the first rank is the permission information, and the information related to the products lower than the first rank and higher than the second rank is the prohibition information. It becomes possible to classify information permission / prohibition for the group of products.

Further, in the information collecting and providing system according to the tenth aspect of the present invention, a menu for selecting permission / prohibition of information is displayed on the terminal means of the member, and based on the display screen, the member is permitted to permit the information. The provision of the information permission prohibition section setting means for urging the user to set the information permission prohibition section is facilitated by the member.

Further, the information collecting and providing system according to the eleventh aspect of the present invention includes the information permission / prohibition division setting means capable of further discriminating other members and setting division of permission / prohibition of information. It is possible to finely classify information permission / prohibition in consideration of the competing relationship between companies and the like.

Further, in the information collection and provision system according to the twelfth aspect of the present invention, the member (1) displays his / her own company name, (2) his / her company name does not display but his / her company belongs. Allows selection of either displaying the affiliate group name or (3) not displaying the company name.
The prohibition category is set for members with the company name or company group name displayed in (1) or (2) above, and information provision to members who do not display the company name in (3) is prohibited. The provision of the permission / prohibition division setting means makes it possible to classify information permission / prohibition that is more suitable for the current business environment.

An information collection and provision system according to a thirteenth aspect of the present invention is capable of setting a period as permission information, and changing the permission information to prohibition information after the period elapses. Since the means is provided, it is possible to classify information permission / prohibition in consideration of changes in the business state.

According to a fourteenth aspect of the present invention, an information collection and provision system according to the tenth to thirteenth aspects of the invention aggregates setting information from the information permission prohibition division setting means for all members, and Information management means for specifying the permission / prohibition category of information on the common layout for each member, the type of information to be provided is displayed on the terminal means of the member, and information to request the member to obtain based on this display screen Request information type input means for prompting input of type setting;
And providing information for determining whether or not the request information type can be read from the request information type input means based on the permission / prohibition category of the information management means, reading the readable information from the accumulation means, and sending it to the terminal means of the member. Providing a processing means, it is possible to realize an information collection and provision system that can securely comply with the information permission / prohibition categories set by each member and can provide the information requested by each member as efficiently as possible. I do.

The information collection and provision system according to the fifteenth aspect of the present invention, when providing information on a product to a plurality of wholesalers that supply the product to a dealer company as a member, provides the information on the product supplier Since the distribution is permitted only to a wholesaler, the wholesaler can also obtain useful information for himself without affecting other dealers.

An information collection and provision system according to a sixteenth aspect of the present invention is intended to provide information related to a product to a plurality of wholesalers who supply the product to a sales company as a member. If different wholesalers supply products of the same type to a plurality of stores belonging to the dealership company, the information on the stores should be limited to the wholesalers that are the product suppliers to the stores. Therefore, the wholesaler can also obtain useful information for himself without affecting other dealers.

[Brief description of the drawings]

FIG. 1 is a diagram showing an overall configuration of an information collecting and providing system according to a first embodiment of the present invention.

FIG. 2 is a block diagram showing an information collecting and providing system according to a second embodiment of the present invention.

FIG. 3 is a diagram showing details of a master shown in FIG. 2;

FIG. 4 is a diagram showing details of a master shown in FIG. 2;

FIG. 5 is a flowchart for explaining a first operation in the member terminal.

FIG. 6 is a flowchart illustrating an operation performed by an administrator of a supermarket company.

FIG. 7 is a diagram showing a terminal screen when an administrator of a supermarket trader sets an information permission prohibition section.

FIG. 8 is a diagram showing a terminal screen following FIG. 7;

FIG. 9 is a diagram showing a terminal screen when setting an information permission prohibition category for a wholesaler.

FIG. 10 is a flowchart illustrating an operation performed by a manager of a wholesaler.

FIG. 11 is a diagram showing a terminal screen when a wholesaler's manager performs company information registration processing.

FIG. 12 is a flowchart for explaining the operation of the supermarket in the company analysis.

FIG. 13 is a flowchart for explaining an operation in a company analysis by a supermarket company.

FIG. 14 is a flowchart for explaining an operation in another retail analysis of a supermarket.

FIG. 15 is a flowchart for explaining an operation in a company analysis by a supermarket company.

FIG. 16 is a flowchart for explaining operations in the wholesale analysis.

FIG. 17 is a flowchart for explaining operations in the wholesaler's own wholesaler analysis.

FIG. 18 is a flowchart for explaining an operation in retail wholesale analysis.

FIG. 19 is a flowchart illustrating an operation in wholesale analysis of retail.

FIG. 20 is a flowchart for explaining a method of displaying a wholesale analysis result.

FIG. 21 is a diagram showing a display screen of a supermarket company's in-house analysis result.

FIG. 22 is a diagram showing a display screen of another retail analysis result of a supermarket.

FIG. 23 is a view showing a display screen of a supermarket company's own / other retail analysis result.

FIG. 24 is a diagram showing a display screen of a single retail analysis result of a wholesaler's own wholesaler.

FIG. 25 is a diagram showing a display screen of a result of analysis of a plurality of retails of own wholesale by wholesale.

FIG. 26 is a diagram showing a display screen of an analysis result of wholesale retailing by retail.

FIG. 27 is a diagram showing a terminal screen when a supermarket trader inputs a request information type regarding data in the company.

FIG. 28 is a diagram showing a terminal screen when a supermarket trader inputs a request information type regarding inter-company comparison.

[Explanation of symbols]

1 A super headquarters, 2 B super headquarters, 3 A wholesaler, 4 B wholesaler, 5 Internet, 6 PO
S server, 11-13 A supermarket, 21, 22
2, 30 information input means, 31 layout editing means,
32 information permission prohibition division setting means, 40 request information type input means, 41 information output means, 60 accumulating means, 61
Information database, 62 product master, 63 supplier master, 64 information management means, 65 information permission prohibition division management table, 66 information provision processing means.

Claims (16)

[Claims] 1. A system for collecting and collecting information from each of a plurality of members and providing the collected information to the member in response to a request from the member. Depending on the setting of the member, it is divided into permission information that permits provision to other members and prohibited information that is prohibited, and the provision of the collected information to the member is performed by the information from the member and the permission from the other members. An information collection and provision system characterized in that it is performed within the range of information. 2. A collecting means for collecting information from members, wherein terminal means of each member and said collecting means are connected by transmission means to collect information from said members and to provide information to members. 2. The information collecting and providing system according to claim 1, wherein the information is provided through the transmission unit. 3. A layout editing means for storing information stored in a member-specific layout of each member in a predetermined common layout, wherein the collecting means collects information in the common layout. Claim 2
Information collection and provision system described. 4. The information collection and provision system according to claim 1, wherein the store company is a member, and POS information created by the store company is used as information to be collected and provided. . 5. The information collection and provision system according to claim 4, wherein the permission information and the prohibition information are classified according to types of layout items storing the POS information. 6. The information collection and provision system according to claim 4, wherein the permission information and the prohibition information are classified according to the type of the product set by the member. 7. The information according to claim 6, wherein information relating to a product whose sales performance rank is higher than the predetermined rank in a predetermined period is set as permission information, and information relating to a product having a sales rank lower than the predetermined rank is set as prohibition information. Information collection and provision system. 8. The apparatus according to claim 6, wherein information relating to a product whose sales performance rank is lower than a predetermined rank during a predetermined period is set as permission information, and information regarding a product higher than the predetermined rank is set as prohibition information. Information collection and provision system. 9. A system according to claim 9, wherein said sales information ranking in a predetermined period is higher than a predetermined first rank, and said information relating to a product lower than said second rank is lower than said first rank. 7. The information collection and provision system according to claim 6, wherein information related to a product that is lower than the first rank and higher than the second rank is set as prohibition information. 10. A menu for selecting permission / prohibition of information is displayed on the terminal means of the member, and information permission / prohibition division setting means for prompting the member to set the division of permission / prohibition of information on the display screen is provided. 6. The device according to claim 5, wherein
10. The information collection and provision system according to any one of claims 9 to 9. 11. The information collection and provision system according to claim 10, further comprising an information permission / prohibition division setting means capable of setting a permission / prohibition division of information by further distinguishing other members. 12. A member (1) displays his / her company name, (2) displays his / her company name but does not display his / her company name, and (3) displays his / her company name. No, can be selected, and the setting of information permission / prohibition is set for members of the company name or company affiliated group name displayed in (1) or (2) above. 12. The information collection and provision system according to claim 11, further comprising an information permission prohibition category setting unit that prohibits information provision to members who do not display their names. 13. A period for setting permission information can be set,
13. The information collection and provision system according to claim 10, further comprising information permission / prohibition division setting means for changing the permission information to prohibition information after the elapse of the period. 14. The setting information from the information permission / prohibition division setting means according to claim 10 is aggregated for all members, and the permission / prohibition division of information on a common layout in the accumulation means is set for each member. The type of information to be provided is displayed on the information management means and member terminal means specified in
Request information type input means for prompting the member to input the information type requested to be obtained on the basis of this display screen, and whether or not the readability of the request information type from the request information type input means is permitted / rejected by the information management means. 10. The information collection device according to claim 4, further comprising an information provision processing unit that reads out information that is readable and readable from the accumulation unit based on the prohibited section and sends the information to the terminal unit of the member. Delivery system. 15. When providing information on a product to a plurality of wholesalers that supply the product to a member dealership company, provide the information only to the wholesaler that is the product supplier. 15. The method according to claim 4, wherein:
Information collection and provision system according to any of the above. 16. A case in which information related to a product is provided to a plurality of wholesalers who supply products to a member dealer company, and different wholesalers belong to a plurality of stores belonging to the same dealer company. 15. The product according to claim 4, wherein, when supplying goods of the same type, provision of the information relating to the store is permitted only to a wholesaler who is a commodity supplier to the store. Information collection and provision system described in.