JP2002109177A - Device, method and system for processing planogram data - Google Patents

Abstract

PROBLEM TO BE SOLVED: To construct a planogram data processor, a planogram data processing method and a planogram data processing system capable of providing a retailer such as a supermarket that performs planogram with low-cost and high quality planogram information. SOLUTION: A server system for analyzing merchandise information such as kinds of merchandise arranged on merchandise shelves of a store, position information showing which position the merchandise is arranged at on the merchandise shelves and sales situation information showing what merchandise is sold well or not, sending the analysis results to the store and charges for analysis fee at the same time, and an information terminal device at a shopfront are connected on-line, and the analysis fee is charged from a prescribed financial institution.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a shelf layout data processing apparatus, a shelf layout data processing method, and a shelf layout data processing method for analyzing information on a shelf layout of merchandise in a retail store such as a supermarket or a convenience store and creating shelf layout information. It relates to a data processing system.

[0002]

2. Description of the Related Art In general, in a retail store such as a supermarket or a convenience store, a key point is how to arrange what kind of goods and how to arrange them on a product shelf in order to create a selling space. How to prepare products in this way depends on season, regionality,
It is necessary to analyze the best selling products of that era, decide the shelf split date, and decide the number of purchases so as not to lose sales.

[0003] In order to analyze seasons, regional characteristics, and top-selling products in that era, the product name is checked with a barcode reader at a store, the price is input to a computer, and sales data is managed at the same time. It is necessary to collect more information using a system (POS system) that manages sales of the entire product, and to have a dedicated person with industry know-how.

[0004]

As described above, in order to determine the shelf layout by the conventional method, it is necessary to assign a dedicated person having a lot of information and know-how of the industry. Retailers such as supermarkets that do
This is a heavy burden, such as the cost of purchasing information from company S.

[0005] In addition, a trader who cannot determine the conventional shelf layout due to such a burden is in a situation where a high quality shelf layout and assortment of goods cannot be performed. In view of the above-mentioned problems, the present invention sends a store's shelving information online to a specialized consultant company (shelf-laying data processing server) to analyze the information, so that a small- to medium-sized dedicated staff can be assigned. An object of the present invention is to construct a shelf allocation data processing system that can provide low-cost and high-quality services to companies that cannot afford to place them.

[0006]

In order to solve the above-mentioned problems, according to the present invention, product information such as the type of a product arranged on a product shelf in a store, and where the product is arranged on the product shelf Analyze the position information and sales status information of what kind of products are sold or not sold, and propose an apparatus and method that can send the analysis result to the store and charge an analysis fee at the same time, Further, a system for connecting the information terminal device at the storefront online and charging an analysis fee from a predetermined financial institution is constructed.

According to the first aspect of the present invention, position information indicating the location of each product on a store shelf, product information on the type of each product, and sales status information on each product are received from the information terminal device of the client. Receiving means, and the position information,
Storage means for storing the product information and the sales status information; information analysis means for analyzing whether each of the products is located at a predetermined shelf position; and an optimal shelf for each of the products based on the analysis result of the information analysis means. A shelf position information creating unit for creating a position, a fee information creating unit for calculating an analysis fee to be charged to a client from the analysis result of the information analyzing unit and creating fee information, and the recommended product arrangement information and the fee information And a transmission means for transmitting the data to the information terminal device.

[0008] With such an apparatus, it is possible to provide low-cost and high-quality shelf allocation product information to retailers. According to a second aspect of the present invention, in the shelf layout data processing apparatus according to the first aspect, the information analysis means analyzes whether the product is a product that sells well around the area of the store.

[0009] As a result, it is possible to provide an analysis result closely related to the area of the shelf split product information. According to a third aspect of the present invention, in the shelf split data processing device according to the first or second aspect, the information analysis means analyzes whether the product is a product that sells well in the month in which the store is split. Features.

[0010] Thus, it is possible to provide an analysis result suitable for the time period for the shelf split product information. According to a fourth aspect of the present invention, in the shelf split data processing apparatus according to any one of the first to third aspects, the information analyzing means is a product suitable for an event where the product is opened around the area of the store. It is characterized by analyzing whether there is.

[0011] As a result, an analysis result suitable for an event held in the area can be obtained for the shelf product information. An invention according to claim 5, wherein a first determining step of determining whether or not the merchandise in the store is on a shelf prominent in the store,
A second determining step of determining whether the product is a product that can be sold when the product is on a prominent shelf; and a third determining step of determining whether the product is at a predetermined shelf position. Is a shelf allocation data processing method.

[0012] By such a method, it is possible to carry out the optimal shelf allocation of the products on the prominent shelves in the store. The invention according to claim 6 is a first determining step of determining whether or not a product in a store is on a shelf where the store is conspicuous, and a step for determining whether the product is inconspicuous in the store when the product is not on a shelf where the product is conspicuous. And a third determining step of determining whether or not the product is a product that can be sold when the product is on a shelf where the product is inconspicuous. This is a data processing method.

[0013] By such a method, it is possible to carry out the optimal shelf allocation of the products on the inconspicuous shelves in the store. The invention according to claim 7, wherein a first determination step of determining whether a product in a store is on a shelf where the store is conspicuous, and where the product is not prominent in the store when the product is not on a shelf where the store is prominent A second determining step of determining whether the device is on the shelf;
A third determining step of determining whether the product is a product that can be sold when the product is not on an inconspicuous shelf; and a fourth determining step of determining whether the product is an unsellable product. Is a shelf allocation data processing method.

According to such a method, it is possible to carry out an optimal shelf allocation of a product which is neither a noticeable shelf nor a noticeable shelf in a store. The invention according to claim 8, wherein input means for inputting position information indicating an arrangement of each product on a store shelf, product information on the type of each product, and sales status information of each product, the position information, Storage means for storing the product information and the sales status information; storage means for storing the position information, the product information and the sales status information; and information for analyzing whether each of the products is at a predetermined shelf position. Characterized by: analyzing means; shelf position information creating means for creating an optimal shelf position of each product from the analysis result of said information analyzing means; and output means for outputting said shelf position information. It is a processing system.

[0015] By constructing such a system, a retailer can obtain high-quality shelf product information. According to a ninth aspect of the present invention, in the shelf layout data processing system according to the eighth aspect, there is provided a charge information creating means for calculating an analysis charge to be charged to a client from the analysis result of the information analyzing means and creating charge information. This is a featured shelf allocation data processing system.

[0016] By constructing such a system, a retailer can obtain low-cost shelf product information.

[0017]

BEST MODE FOR CARRYING OUT THE INVENTION

[0018]

Embodiments of the present invention will be described below with reference to the drawings. <First Embodiment> FIG. 1 is a diagram showing a system configuration in a first embodiment, and FIG. 2 is a diagram for explaining a series of flows of this system. The information terminal device 11 is, for example, a personal computer or the like, and merchandise display information of merchandise shelves on the retailer side (position information on where each merchandise is on the shelf, merchandise information indicating the type of merchandise, and how much each merchandise can be sold) (Sales status information indicating whether or not the product can be sold) (see FIG. 2),
(See FIG. 2). The shelf allocation data processing server 12 analyzes the merchandise display information of the retailer in the consultant company (FIG. 2), and sends optimal shelf position information of the merchandise to the information terminal device 11 of the retailer based on the analysis result. (FIG. 2). Then, the retailer pays a consultant fee to the consultant company (FIG. 2). The public line 13 is, for example, the Internet or the like, and is a line connecting the information terminal device 11 and the shelf allocation data processing server 12.

Next, FIG. 3 shows the shelf allocation data processing server 12.
FIG. The receiving unit 14 is where the product display information of the retail store is received from the information terminal device 11. Next, the information analysis unit 15 analyzes the received product display information to determine an optimum product display position, and includes a product display information DB (database) 16 as shown in FIG. In this product display information DB, position information of “shelf steps”, “position from left”, “number of face faces” and a JAN code indicating the type of product can be stored. There are flags. or,
The information analysis unit 15 has a sales information DB indicating the sales of the product.
And sales information indicating which products have been sold and how much can be accumulated.

The arrangement information creating section 17 is to create the arrangement information of the product from the display position. Charge calculator 1
Reference numeral 8 denotes a step of calculating an analysis fee and creating fee information. The transmission unit 19 is to transmit the created product arrangement information and fee information to the information terminal device 11. still,
If the receiving unit 14 and the transmitting unit 19 are performed manually, data such as a product display information file is
A control unit that receives data recorded on a D (compact disk) or FD (floppy (registered trademark) disk) or the like, inputs data such as a product display information file using an input device such as a keyboard, and processes the input data. It is also possible to receive.

The actual shelf allocation data processing server 12
This is realized by adopting the configuration as shown in FIG. That is, CPU (Central Processing)
Unit) stores various processing programs stored in the storage device, various instructions input from the input device, or various data processed in accordance with the various instructions in the RAM, and stores the input instructions and the input data in the RAM. Accordingly, various processes are executed in accordance with the application programs stored in the RAM, and the processing results are stored in the RAM and displayed on the display device. Then, the CPU saves the processing result stored in the RAM to a storage destination in the storage device that is instructed to be input from the input device. The transmission control unit is a terminal for connecting an external device or the like via a communication line such as a network line. The transmission control unit transmits various processing programs and data stored in the storage device according to instructions from the CPU. To and from external devices via The storage device is
It has a storage medium in which programs, data, and the like are stored in advance, and this storage medium is made up of a magnetic, optical, or semiconductor memory. The storage medium is fixedly provided in the storage device or is detachably mounted. The storage medium includes control programs, main processing programs, and other processing programs, and data processed by the processing programs. And so on. The information terminal device 11 and a PC 291 of a fourth embodiment described later have the same configuration. The retailer's HT, which will be described later, has a configuration in which a bar code reader is provided in this configuration.

Next, a description will be given of a process in which a retailer requests a consultant company to process shelf layout data using shelf layout software and pays a fee for the processing. FIG.
FIG. 4 is a diagram for explaining the concept of the series of flows. First,
The retailer can use HT (Handy Terminal) or the like to display the product information (JAN code), which is the current product display information on the shelf, the shelf where the products are arranged, the position of the shelf from the left, and the number of faces to be arranged (face surface). ).

Next, the merchandise display information is transmitted to the information terminal device 1.
1 is CSV (Comma Separated Val)
ue) File input (FIG. 6). And CS
The merchandise display information file input in the V file is reproduced using shelf allocation software capable of reproducing the shelf allocation, and the reproduction result is converted into a file that can be transmitted / received via a network or the like.

The retailer sends the converted product display information file to the shelf allocation data processing server 12 of the shelf allocation consulting company via the public line 13 by sending an attached file of an outgoing mail or transmitting a file by a browser ( 6). Next, the shelf allocation data processing server 12 receives the product display information file by the receiving unit 14, and reproduces the shelf allocation based on the product display information file by the information analysis unit 15,
It is checked whether the hot selling products are missing, whether the dead hot products (products that can no longer be sold) are on the shelf, and whether the product configuration is suitable for the season, and the like. Create a placement information file. At the same time as creating the arrangement information file, the fee calculating unit 18 calculates the analysis fee and creates fee information (FIG. 6).

Then, the shelf allocation data processing server 12 sends the public line 1 to the information terminal device 11 of the retailer from the transmission unit 19.
Then, the location information file and the fee information are sent via the server 3 (FIG. 6). The retailer who has received the arrangement information file and the fee information pays a prescribed consultant fee through Internet settlement (FIG. 6).

The payment of the consultant fee includes both a manual transfer and an electronic transfer. When the transfer is made electronically to a predetermined financial institution (the same applies to the following examples), the amount paid and the amount of the transfer will be paid. After confirming that the received amounts match, the received amount may be sent to the terminal device on the retailer side via the Internet.

Next, the above operation will be described in detail. It should be noted that if each of the flowcharts described below (similarly for the flowcharts of other embodiments) is supplemented, a program for realizing each function shown in the flowcharts is stored in the form of a program code readable by a CPU. Is stored in This program can also be transmitted in the form of a program code via a transmission medium such as a network line.

First, a description will be given of a process for inputting the JAN code into the HT with the merchandise display information. FIG. 7 shows the H
It is a flowchart about operation | movement of T side. In the following description of all the flowcharts, the description of the numbers in parentheses indicating the steps, for example, (A1) omits (Step A1).

First, it is checked whether the same JAN code exists in the input JAN code and the commodity display information file stored in the HT (step A1). If it cannot be confirmed (A1 is No), the JAN code is stored in an empty area of the commodity display information file (A2), and a screen for inputting a shelf, a position from the left, and the number of face surfaces is displayed (A).
3).

On the other hand, if the same JAN code can be confirmed (A1 is Yes), the setting data is read (A1).
4) Display an input screen (A3). Then, it waits for an input (A5 is No), and if there is an input (A5 is Ye)
s), confirm whether the input data item is specified (A
6). If there is no designation (No in A6), the process returns to the input screen (A5).

On the other hand, if there is a designation (A6 is Yes), it is confirmed whether or not to store data (A7). If the data is to be stored (Yes in A7), the data is stored in the designated item (A8), and the display returns to the input screen (A
5). On the other hand, if there is no data input (A7 is No) and it is confirmed whether it is confirmed (A9). If it is not confirmed (A9 is No), the process returns to the input screen (A5).

On the other hand, if it is determined (A9 is Yes), it is confirmed whether input of all items has been completed (A10). If there are still items left (No in A10), the process returns to the input screen (A5). On the other hand, if there is no input item (A10 is Ye
s), end the process.

Next, transfer of merchandise display information from the HT to the information terminal device 11 in a retail store will be described. FIG.
Is a flowchart of the operation on the HT side at that time. First, the HT issues a connection request to the information terminal device 11 (B1). Next, the permission notice is confirmed (B2),
If there is no permission notification (B2 is No), the process waits until a certain time elapses (B3 is No). If the predetermined time has elapsed (Yes in B3), an error is notified (B3).
4), and notifies the information terminal device 11 of the disconnection of the connection (B
5) Terminate the communication.

On the other hand, if the permission notice is received (B2 is Ye
s), store information is transmitted (B6), and commodity display information is transmitted (B7). The store information and product display information are EO
This is repeated until F (End Of File) appears (B8 is No). When the EOF is confirmed (B
8 is Yes), a notification of disconnection of the connection is sent to the information terminal device 11 (B5), and the communication is terminated.

Next, the information terminal device 11 of the retail store corresponding to the above flow will be described. FIG. 9 is a flowchart illustrating the operation of the information terminal device 11 when the product display information is transferred from the HT to the information terminal device 11. First, it is confirmed whether there is a connection request from the HT (C1). If not (C1 is No), the process ends. On the other hand, if there is a connection request (C1 is Yes), the commodity display information file is initialized (C2), and a connection permission notification is sent to the HT (C3).

Next, it is confirmed whether the transmitted information is merchandise display information (C4). If the product display information (C
4 is Yes) and stored in the product display information file (C
5) Then, the process returns to the step of confirming whether the information is the product display information again (C4). On the other hand, if it is not product display information (C4 is N
o), it is confirmed whether or not the store information has been received (C6). If it is store information (C6 is Yes), store the store information (C7) and return to the point where the product display information is confirmed (C7).
4). The store information includes a store area and area information around the store.

If neither the merchandise display information nor the store information (C6 is No), it is checked whether a connection disconnection notification has been sent from the HT (C8), and if it has been sent (C8 is Ye).
s), end. On the other hand, if not sent (C8 is N
o), return to the point where the product display information is confirmed (C
4).

Next, the operation of transmitting the data of the product display information file from the information terminal device 11 of the retail store to the shelf allocation data processing server 12 will be described. FIG. 10 is a flowchart of the operation of the information terminal device 11 at that time. First, the information terminal device 11 issues a connection request to the shelf allocation data processing server 12 (D1). Next, the permission notice is confirmed (D2). If there is no permission notice (D2 is N
o) Wait until a certain time has elapsed (D3 is No).
When a certain time has elapsed (Yes in D3), an error is notified (D4), and the communication is terminated.

On the other hand, if the permission notice is received (D2 is Ye
s), transmitting the data of the commodity display information file (D
5). At this time, since a display screen as shown in FIG. 11 appears on the setting screen of the information terminal device 11, the file name is input and the transmission button is pressed. The data transmission of the commodity display information file is performed by EOF (End Of Fil).
This is repeated until e) appears (D6 is No). The store code unique to the store, which is given to the store in advance by the consultant company and recorded in the information terminal device 11, is also transferred.

When the EOF is confirmed (D6 is Y
es) Then, the data of the sales information file of the product is
It transmits until OF appears (D7, D8 is No). still,
The sales information file mentioned here stores sales information such as sales amount and quantity for each product (for each PLU code), and the sales information is a file that is updated and recorded for each registration.

On the other hand, if EOF appears (D8 is Ye
s), an EOF notification is sent to the shelf allocation data processing server 12 (D9), the data of the arrangement information file is received, and the data is output (D10). The conventional consultant fee (not shown) is provided with a memory for accumulating the consultant fee transferred from the shelf allocation data processing server 12 of the consultant company. Is subtracted by the amount of money) (D11), and the communication is terminated.

Next, when the data of the product display information file is transferred from the information terminal device 11 of the retail store to the shelf allocation data processing server 12, the shelf allocation data processing server of the consultant company corresponding to the flow of FIG. The operation on the 12 side will be described. FIG. 12 is a flowchart showing the operation of the shelf allocation data processing server 12 at that time.

First, it is confirmed whether there is a connection request from the information terminal device 11 (E1). If not (E1 is No), the process ends. On the other hand, if there is a connection request (E1 is Ye
s), the product display information DB is initialized (E2), and a connection permission notification is sent to the information terminal device 11 (E3).

Next, it is confirmed whether the transmitted information is merchandise display information (E4). If the product display information (E
4 is Yes), stored in the merchandise display information DB (E5), and returns to the step of confirming whether it is the merchandise display information again (E).
4). On the other hand, if it is not product display information (E4 is No),
It is confirmed whether the sales information has been received (E6). If it is sales information (E6 is Yes), the sales information DB (not shown is a DB that adds the amount data transferred from each store by PLU code and accumulates by PLU code) is updated (E7). Then, the process returns to the point where the commodity display information is confirmed (E4).

On the other hand, if neither the product display information nor the sales information (E6 is No), it is checked whether an EOF notification is sent from the information terminal device 11 (E8), and if it is not sent (E8 is No). Then, the process returns to the point where the commodity display information is confirmed (E4). On the other hand, if sent (E8 is Ye
s) The product display information analysis and the notification of the arrangement information file are performed (E9). Then, the consultant fee is calculated as the number of products x
It is determined by the analysis fee (E10), the consultant fee is added so as to correspond to the store code (E11), and the process ends.

Next, details of the merchandise display information analysis and creation and notification of the arrangement information file in E9 of FIG. 12 will be described. FIG. 13 is a flowchart of the operation. First, the shelf No. of the product display information DB 16
Are all set to 1 (F1). Next, it is confirmed whether the shelf No. is the golden zone (F2). FIG. 14 is a diagram showing a golden zone and a dead zone in a retail store. The golden zone is a place relatively close to the entrance and close to a counter having a cash register. In other words, it refers to the location of the shelf that is most prominent in the store. On the other hand, the dead zone is a place that is deeper than the vicinity of the entrance, that is, a place of a shelf that is inconspicuous.

In the case of the golden zone (F2
Is Yes), the merchandise out-of-sale merchandise analysis (F3) and the out-of-sale merchandise shelf position analysis are performed (F4), and 1 is added to the shelf number (F5).
On the other hand, if it is not the golden zone (F2 is No),
This time, it is confirmed whether it is a dead zone (F6). If it is a dead zone (F6 is Yes), a selling item analysis is performed (F7), and if it is not a dead zone (F6 is N
o), analyzing the selling merchandise (F8) and analyzing the dead muscle merchandise (F
9). After completion of any analysis, 1 is added to the shelf No. (F5).

It is confirmed whether all the shelf numbers have been completed (F1).
0), if there is any (No in F10), the process returns to the position where the shelf No. is set to 1 (F1). On the other hand, when all the shelf numbers have been completed (F10: Yes), an email is created using each analysis result as a text sentence (F11). Then, the created mail is added to the mail address corresponding to the store code and transmitted to the information terminal device 11 of the connected retail store (F1).
2).

Next, a description will be given of the merchandise out-of-sale product analysis in F3 of FIG. FIG. 15 is a flowchart of the operation. First, the selling merchandise is analyzed (G1). Here, the 10 best sales items for each store are extracted. The sales vest 10 is a file in which the best selling products are extracted in the sales information file in order and ranked in the order of 1st to 10th. Next, the shelf layout data of the golden zone is fetched from the product display information DB 16 (G2). Then, the first product display information is taken out (G3), and the EOF is confirmed (G4). When all the merchandise display information has been taken out (G4: Yes), an unsold list is created (G5),
finish.

On the other hand, if there is product display information (G4 is N
o), It is confirmed whether the product is the best selling product (G6). If the product has the best 10 sales, (G
6 is Yes), the next product display information is taken out (G7),
It is confirmed whether it is EOF (G4). On the other hand, if the product is not the top 10 in sales (G6 is No), it is written to the unsold list (G8).

Next, a description will be given of the analysis of the position of the shelves outside the selling line at F4 in FIG. FIG. 16 is a flowchart of the operation. First, one record is read from the off-sale list (H1), and it is confirmed whether the record is EOF (H2). When the reading of the last record is completed (H2 is Yes), the process ends.

On the other hand, if there is a record (H2 is No),
A store-by-store shelf allocation determination described later is performed (H3). Here, the position of the shelf is expressed in a point system. Next, it is compared whether the actual product display position is within the range of the point-based shelf position (H4). If the point of the actual product display position is out of the range of the point-based shelf position (H4 is No), that is, if the point of the product display position is higher than the point of the point-based shelf position, the product is displayed in the height change notification list. Name, “change instruction”, and “recommended height” are written out (H5).

On the other hand, when it is within the range (when the point of the merchandise display position is lower than the point of the point-based shelf position) (H4 is Yes), the "change name" is added to the height change notification list.
"Problem" is written out (H6), and the process returns to the process of reading the record. In addition, a recommended height DB as shown in FIG. 17 is provided, the same record as the read record is read from the recommended height DB, the actual product display position is compared with the recommended height, and written to the respective lists. It may be.

Next, a description will be given of the shelf layout determination for each store in (H3) of FIG. FIG. 18 is a flowchart of the operation. First, the point total is calculated from the store information data format and the merchandise display information in FIG. 19 using the shelf allocation sample table in FIG. 20 for each shelf allocation sample unit (J1). Next, it is checked whether or not there is the same point total value (J2). If there is a tie point (Yes in J2), the shelf position at the tie point is read out (J3).

On the other hand, if there is no tie point, the shelf position of that point is read (J4). Here, for example, the calculation of the point total in the case of the store A in FIG. 19 will be described. First, looking at the first data of the merchandise display information at the store A, the store A is located in the office district, and therefore, the "object" in FIG.
Item is 6 points of "Single". Since the office district is the area 1, “area” in FIG. 20 is 7 points of the “area 1”. Finally, the store area of store A is 2
20 m ² , the “store area” in FIG.
３００300 m ² ”. The point is similarly obtained for the next shelf position data. As described above, the shelf position data of the product display information is obtained in a point system in accordance with the location condition of each store. By adding all the applicable points, it is possible to check whether the merchandise is located at an appropriate location in the store based on whether the total point is larger or smaller than the recommended point. Note that the recommended shelf allocation data is to store the positions of the three-tiered shelves and the product positions indicated by black squares in association with each other.

Next, the analysis of the dead muscle product in F9 of FIG. 13 will be described. FIG. 21 is a flowchart of the operation. In this analysis, the sales top 10
Similarly, a list of the worst sales 30 is prepared. Note that the list of the worst sales 30 is a file created by extracting up to the 30th product in order from the product with the worst sales than the sales information file, contrary to the file of the sales best 10.

First, the merchandise information of the sales worst 30 is fetched (K1). Next, the first one record is read from the commodity display information (K2). Next, it is checked whether the record is EOF (K3), and if it is the last record, (K3)
3 is Yes), and the process ends.

On the other hand, if there is still a record (K3 is N
o), confirm whether the record is included in the list of the worst sales 30 (K4). If not (K4
No), the record is written to the dead line product list (K5), and the first record is read (K2).

On the other hand, if it is present (K4 is Yes), the next one record is read from the commodity display information (K6), and the record is read from the beginning (K2). <Example of Second Embodiment>
Next, a second embodiment will be described. In the first embodiment,
Although it is stated that better improvement plans are provided based on the current shelf layout information and the sales situation at the retail store, in the second embodiment, by adding the regional information of the retailer to be sent, the analysis including the regional characteristics is performed by the server. Let the side do it.

FIG. 22 is a diagram showing a system configuration according to the second embodiment. The information terminal device 201 is, for example, a personal computer, and manages merchandise display information (position information, merchandise information, sales status information, and regional information of each merchandise) on a merchandise shelf on the retailer side, and a shelf allocation data processing server. 202. The shelf allocation data processing server 202 is where a consultant company processes merchandise display information of a retailer. Public line 203
Is a line connecting the information terminal device 201 and the shelf allocation data processing server 202.

Next, FIG. 23 shows the shelf allocation data processing server 2
FIG. The receiving unit 204 is where the product display information of the retail store is received from the information terminal device 201. The information analysis unit 205 is about to analyze the received product display information. In the information analysis unit 205,
In addition to the product display information DB and the sales information DB, there is a regional sales DB (database) 206 as shown in FIG. 24, and searches for the best selling products from the top 10 selling products in the region of the retail store, and displays the optimum product display position. Can be requested.

The arrangement information creating section 207 is to create the arrangement information of the product from the analysis result. Charge calculation unit 20
Reference numeral 8 denotes a step of calculating an analysis fee and creating fee information. The transmitting unit 209 is to transmit the created product arrangement information and fee information to the information terminal device 201.

Next, a description will be given of a process in which a retailer requests a consultant company to process shelf layout data and pays a fee for the process. FIG. 25 is a diagram for explaining the concept from the processing of the shelf allocation data to the payment of the fee in the second embodiment.

First, the retailer uses HT (Handy Terminal) or the like to read the product information (JAN code) of the current product display information on the shelf. Further, as other input information, the shelf where the products are arranged, the position from the left of the shelf, and the number of faces to be arranged (face faces) are input. In this input information, regional information such as the Kanto area is also input.

Next, the merchandise display information is transmitted to the information terminal device 2.
01 to CSV (Comma Separated Va)
lu) file (FIG. 25). And
The merchandise display information file input as a CSV file is reproduced using shelf allocation software capable of reproducing the shelf allocation, and the reproduction result is converted into a file that can be transmitted / received via a network or the like.

Then, the retailer sends the converted product display information file to the shelf allocation data processing server 202 of the shelf allocation consulting company via the public line 203 by sending an attached file of an outgoing mail or transmitting a file by a browser ( FIG. 25). Next, the shelf allocation data processing server 20
No. 2, the receiving unit 204 receives the product display information file, and the information analyzing unit 205 uses the product display information file to determine whether there is any missing hot selling product or that no dead selling product (product that can no longer be sold) is on the shelf. And whether the product configuration is suitable for the season.
To create a placement information file. Then, when performing this check, the top selling merchandise based on the district-specific sales DB 206 is analyzed. For example, as shown in FIG. 26, the shelf layout information of the retail stores in the Kanto area is compared with the best 10 product sales in the Kanto area in the regional sales DB 206, and the best 10
The product that has leaked from is picked up and added to the placement information file.

At the same time as creating the arrangement information file, the fee calculating section 208 calculates the analysis fee and creates fee information (FIG. 25). Then, the shelf allocation data processing server 202 sends the arrangement information file from the transmission unit 209 to the information terminal device 201 of the retailer via the public line 203 (FIG. 25).

The retailer who has received the arrangement information file pays a prescribed consultant fee by Internet settlement or the like (FIG. 25). As described above, in the second embodiment, since the information analysis unit 205 is provided with the sales DB 206 for each district, it is possible to provide the retailer with better shelf layout information corresponding to each area. The data in the district-specific sales DB 206 determines the district from the store code transferred from the retail store, and adds and accumulates the price data in the sales information transferred from the retail store to the price data corresponding to the district.

Further, by adding more detailed event information in each region, for example, information on an athletic meet for elementary schools, concerts, fireworks displays, etc. to shelf allocation information from a retail store, on the date of the athletic meet, By providing an event information DB such as increasing the number of products such as rice balls and tea, it becomes possible to propose a sales floor that can sell more.

<Third Embodiment> Next, in a third embodiment, the server side performs analysis for each time period by designating a time period for carrying out a shelf layout at a retail store. FIG.
FIG. 9 is a system configuration diagram in a third embodiment.

The information terminal device 241 is, for example, a personal computer, and manages merchandise display information (position information, merchandise information, sales status information, and implementation time information of each merchandise) on the merchant shelf at the retailer's side. It has a function of transmitting to the split data processing server 242. The shelf allocation data processing server 242 is where a consultant company processes merchandise display information of a retailer. Public line 2
Reference numeral 43 denotes the Internet or the like;
And a line connecting the shelf allocation data processing server 242.

Next, FIG. 28 shows the shelf allocation data processing server 2
FIG. The receiving unit 244 is where the product display information of the retail store is received from the information terminal device 241. The information analysis unit 245 is about to analyze the received product display information. In the information analyzer 245,
In addition to the product display information DB and the sales information DB, there is a monthly sales DB (database) 246 as shown in FIG. 29. It is possible to search and find an optimum product display position. The arrangement information creation unit 247 is to create the arrangement information of the product from the analysis result.

The fee calculating section 248 is to calculate the analysis fee and create fee information. The transmission unit 249 transmits the created product arrangement information and the charge information to the information terminal device 24.
1 to be transmitted. Next, a description will be given of a process in which a retailer requests a consultant company to process shelf layout data and pays a fee for the process.

FIG. 30 is a diagram for explaining the concept from the processing of data on the shelf allocation to the payment of the fee in the third embodiment.
First, the retailer reads the product information (JAN code) of the current product display information on the shelf using an HT (Handy Terminal) or the like. Further, as other input information, the shelf where the products are arranged, the position from the left of the shelf, and the number of faces to be arranged (face faces) are input. This input information includes information on the month in which the retailer performs the shelving, such as August.

Next, the merchandise display information is transmitted to the information terminal device 2.
41 is CSV (Comma Separated Va)
lu) file (FIG. 30). And
The merchandise display information file input as a CSV file is reproduced using shelf allocation software capable of reproducing the shelf allocation, and the reproduction result is converted into a file that can be transmitted / received via a network or the like.

Then, the retailer sends the converted merchandise display information file to the shelf allocation data processing server 242 of the shelf allocation consulting company via the public line 243 by sending an attached file of an outgoing mail or by sending a file from a browser ( FIG. 30). Next, the shelf allocation data processing server 24
2, the receiving unit 244 receives the product display information file, and the information analyzing unit 245 uses the product display information file to find out whether the hot selling product is missing or the dead hot product (product that can no longer be sold) is not on the shelf. And whether the product configuration is suitable for the season, and the like.
To create a placement information file. Then, when performing this check, the top selling merchandise based on the monthly sales DB 246 is analyzed. For example, as shown in FIG. 31, the shelf allocation information of the retail stores in August is stored in the monthly sales DB 246 as the best product sales in August.
Compared with 0, the merchandise leaking from the best 10 is picked up and added to the arrangement information file.

Further, at the same time as creating the arrangement information file, the fee calculating section 248 calculates the analysis fee and creates fee information (FIG. 30). Then, the shelf allocation data processing server 242 sends the arrangement information file from the transmitting unit 249 to the information terminal device 241 of the retailer via the public line 243 (FIG. 30).

The retailer who has received the arrangement information file pays a prescribed consultant fee by Internet settlement or the like (FIG. 30). As described above, in the third embodiment, since the information analysis unit 245 is provided with the monthly sales DB 246, it is possible to perform a detailed analysis for each month when the shelf allocation is performed.
Better information can be provided.

It is also conceivable to provide information for analyzing a form combining the second and third embodiments as shown in FIG. 32, that is, a DB as shown in FIG. Can be <Fourth Embodiment> Next, a fourth embodiment will be described. By collecting information used for analysis of the shelf layout of a consultant company from the general public via the Internet, more optimal product arrangement information can be provided to retailers. In the fourth embodiment, a system will be described in which information from general Internet users is accumulated in this way, and shelf allocation data processing is performed in consideration of the information. Note that the processing of the shelf allocation data between the retail store and the consultant company is performed in the same manner as in the first to third embodiments, and thus the description thereof is omitted.

FIG. 34 is a system configuration diagram in the fourth embodiment. PC (Personal Computer) 291
Is a terminal device of an Internet user who is a third party. The shelf allocation data processing server 292 is a place where a consultant company processes merchandise display information of a retailer. Here, the shelf allocation data processing server 292 will be described as a server that aggregates event information and the like held in each region provided by general Internet users. I do. The public line 293 is the Internet or the like, and is a line connecting the PC 291 and the shelf allocation data processing server 292.

Next, FIG. 35 shows the shelf allocation data processing server 2
92 is a configuration diagram of FIG. The receiving unit 294 receives the P of the general user.
This is where event information is received from C291. The information analysis unit 295 has a regional event information DB (database) 296 as shown in FIG.
Event information from C291 can be stored.
The transmission unit 297 is to transmit a reward mail or the like to the PC 291 to the user who provided the information. For example, when the main mail is displayed at the convenience store A, a mail such as a gift is sent to the user in return.

Next, a description will be given of a process from the provision of information by a general user to the sending of a return mail. FIG. 37 is a view for explaining the concept from information provision to return mail transmission.
First, a general user accesses a homepage of a consultant company and answers a simple questionnaire or the like.
The content of the questionnaire is, for example, "What kind of lunch do you want to bring to the upcoming athletic meet?" Then, such word-of-mouth information is sent from the PC 291 to the shelf allocation data processing server 292 of the consultant company via the public line 293 (FIG. 37). or,
This word-of-mouth information may be sent by e-mail. The word-of-mouth information is stored in the shelf allocation data processing server 29 as shown in FIG.
2 is stored in the area-specific event information DB 296 and is used for analyzing the shelf layout information.

Next, an e-mail with a privilege (coupon) is transmitted from the transmission unit 297 to the PC 291 to the user who has provided the information in return (FIG. 37). Next, the processing operation between the PC 291 of a general user and the shelf allocation data processing server 292 will be described. First, a processing operation performed by the PC 291 will be described with reference to FIG.

First, the PC 291 issues a connection request to the shelf allocation data processing server 292 (M1). Next, it is confirmed whether or not the front page and the questionnaire data have been received (M2). If the front page and the questionnaire data have not been received (M2 is No), and if the predetermined time has not elapsed (M3 is No), a connection request is issued again (M3). M1).

On the other hand, if the predetermined time has elapsed (M3 is Yes), an error notification is sent (M4), and the process ends. or,
When the front page and the questionnaire data are received (M2 is Yes), the received contents are displayed on a display screen or the like (M5). Next, it is checked whether there is data to be input to the questionnaire data (M6). If there is input data (M6 is Yes), the input data is stored as transmission data (M7), and the connection is disconnected. It is confirmed whether the designation has been made (M8).

On the other hand, if there is no input in the questionnaire data (M6 is No), disconnection designation is confirmed (M8). If there is no disconnection designation (No in M8), processing and transmission according to the input are performed (M9), and input to questionnaire data is waited (M6). On the other hand, if disconnection is specified (M8 is Ye
s), the input data for transmission is transmitted (M10), the disconnection is notified (M11), and the process ends.

Next, the operation of the shelf allocation data processing server 292 will be described with reference to FIG. First, it is confirmed whether there is a connection request from the PC 291 (N1). If there is a connection request (Yes in N1), the front page and the questionnaire data are transmitted to PC 291 (N2).
1 is No), and the process ends.

Next, it is confirmed whether or not the transmission input data has been received from the PC 291 (N3). If the input data is present (N3 is Yes), the data of the regional event information DB 296 is rewritten (N4). It waits for the input data for transmission again (N3). On the other hand, if the input data for transmission has not been received (N3 is No) and data has been received from another user (N5 is Yes), processing according to the content of the transmission is performed (N6), and the disconnection request is confirmed. (N7).

On the other hand, if no data is received from other places (N5 is No), a disconnection request from PC 291 is confirmed (N7). If there is a disconnection request (N7 is Yes),
If not completed (N7 is No), reception of transmission input data is confirmed (N3). Next, a description will be given of a process of performing a shelf layout analysis from the regional event information DB 296 based on a questionnaire from a user. FIG. 41 is a flowchart of the operation.

First, the area information and the shelf allocation execution date transmitted from the retail store are read. (P1) Next, the first JAN code is read (P2). It is checked whether the JAN code is the last data (P3), and if it is the last (P3 is Y
es), end. On the other hand, if there is still a JAN code (No in P3), the target information is read from the regional event information DB 296 (P4). This target information can be determined from the event information and the area code in FIG. Next, it is confirmed whether the read JAN code is a recommended product (recommended product) in the regional event information DB 296 (P5). If the read JAN code is not a recommended product (P5 is No), the regional event information DB 296 is determined. (P6).

On the other hand, if it is a recommended product (P5 is Ye
s), the next JAN code is read (P7), and it is confirmed whether the code is the last data (P3). In addition, as shown in FIG. 42, the sales DB 206 by district in the second embodiment.
It is also conceivable to provide the retailer with the most suitable picked-up merchandise and event information as shelf allocation information from the sales vest 10 of the monthly sales DB 246 in the third embodiment and the regional event information DB 296 in the fourth embodiment. From this, the retailer knows that, for example, an athletic meet will be held in a nearby elementary school soon, and can order more rice balls and the like from manufacturers than usual.

The data of the regional event information DB 296 may be collected independently by a consultant company. In this way, by connecting the terminal of the retailer and the server for analyzing the optimal shelf layout information online, it is possible to exchange real-time information with each other.

Further, by considering information provision from general Internet users when analyzing shelf allocation information, it is possible to provide a more accurate analysis result to a retailer. Also, when sending the shelf layout information from a retail store to a consultant company, input the shelf layout information to a shelf layout software that can reproduce the actual shelf layout state with a computer etc., and from this software to a file for data exchange Although it is output and sent to the shelf allocation data processing server 12, it may be sent using a dedicated format file.

[0094]

As described above, according to the present invention, an information terminal device in a store and a database system for analyzing and processing the product information and sales status of the product shelves are connected on-line, thereby requesting a specialist consultant company for shelf layout analysis. A low-cost shelf analysis service can be provided to companies (clients) who cannot afford to do so. In addition, more sophisticated information can be provided to the client by performing analysis by combining databases based on regions, months, events, and the like.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram in a first embodiment.

FIG. 2 is a diagram showing the concept of the first embodiment.

FIG. 3 is a configuration diagram of a shelf allocation data processing server 12.

FIG. 4 is a diagram showing a product display information DB16.

FIG. 5 is a schematic block diagram of an information terminal device 11, an HT on a retailer side, a shelf allocation data processing server 12, and a PC 291.

FIG. 6 is a diagram illustrating the concept from shelf allocation data processing to payment of a fee in the first embodiment.

FIG. 7 is a flowchart of a process when inputting product display information to the HT.

FIG. 8 is a flowchart of an operation in the HT.

FIG. 9 is a flowchart of the operation of the information terminal device 11;

FIG. 10 is a flowchart of the operation of the information terminal device 11;

FIG. 11 is a diagram showing a setting screen in the information terminal device 11;

FIG. 12 is a flowchart illustrating the operation of the shelf allocation data processing server 12.

FIG. 13 is a flowchart for merchandise display information analysis and creation and notification of an arrangement information file.

FIG. 14 is a diagram showing a golden zone and a dead zone in a retail store.

FIG. 15 is a flowchart of an analysis of merchandise out of sales.

FIG. 16 is a flow chart for analyzing the position of a shelf outside the selling position.

FIG. 17 is a diagram showing a recommended height DB.

FIG. 18 is a flowchart of store-by-store shelf allocation determination.

FIG. 19 is a diagram showing a data format of store information.

FIG. 20 is a diagram showing a shelf allocation sample table.

FIG. 21 is a flowchart of dead muscle product analysis.

FIG. 22 is a system configuration diagram in a second embodiment.

FIG. 23 is a configuration diagram of a shelf allocation data processing server 202.

FIG. 24 is a diagram showing a regional sales DB 206;

FIG. 25 is a diagram illustrating the concept from shelf allocation data processing to payment of a fee in the second embodiment.

FIG. 26 is a diagram illustrating an operation in the consultant company of the second embodiment.

FIG. 27 is a system configuration diagram in a third embodiment.

28 is a configuration diagram of a shelf allocation data processing server 242. FIG.

FIG. 29 is a diagram showing a monthly sales DB 246.

FIG. 30 is a diagram illustrating the concept from shelf allocation data processing to payment of a fee in the third embodiment.

FIG. 31 is a diagram for explaining the operation in the consultant company of the third embodiment.

FIG. 32 is a diagram for explaining an operation in a consultant company in consideration of a district sales DB and a monthly sales DB.

FIG. 33 is a diagram showing a district-specific and monthly sales DB;

FIG. 34 is a system configuration diagram in a fourth embodiment.

35 is a configuration diagram of a shelf allocation data processing server 292. FIG.

36 is a diagram showing a regional event information DB 296. FIG.

FIG. 37 is a diagram illustrating a concept from information provision to return mail transmission.

FIG. 38 is a diagram for explaining the operation in the consultant company of the fourth embodiment.

FIG. 39 is a flowchart of the operation of the PC 291.

FIG. 40 is a flowchart of the operation of the shelf allocation data processing server 292.

FIG. 41 is a flowchart of a process of performing a shelf layout analysis from a regional event information DB 296.

FIG. 42 is a diagram for explaining an operation in a consultant company in consideration of a district sales DB and a monthly sales DB in the fourth embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 11 Information processing apparatus 12 Shelf allocation data processing server 13 Public line 14 Receiving part 15 Information analysis part 16 Product display information DB 17 Arrangement information creation part 18 Charge calculation part 19 Transmission part 201 Information processing apparatus 202 Shelf allocation data processing server 203 Public line 204 Reception unit 205 Information analysis unit 206 Regional sales DB 207 Location information creation unit 208 Charge calculation unit 209 Transmission unit 241 Information terminal device 242 Shelf allocation data processing server 243 Public line 244 Reception unit 245 Information analysis unit 246 Monthly sales DB 247 Location Information creation unit 248 Charge calculation unit 249 Transmission unit 291 PC 292 Shelf allocation data processing server 293 Public line 294 Receiving unit 295 Information analysis unit 296 Regional event information DB 297 Transmission unit

Claims (9)

[Claims] 1. location information indicating the location of each product on a store shelf;
A receiving unit that receives, from the information terminal device of the client, product information about the type of each product and sales status information of each product; a storage unit that stores the position information, the product information, and the sales status information; Information analyzing means for analyzing whether each of the products is at a predetermined shelf position; shelf position information creating means for creating an optimal shelf position for each of the products based on the analysis result of the information analyzing means; Fee information creation means for calculating an analysis fee to be charged to the client from the analysis result and creating fee information, and transmission means for transmitting the shelf position information and the fee information to the information terminal device. Shelf allocation data processing device. 2. The shelf allocation data processing device according to claim 1, wherein the information analysis means analyzes whether the product is a product that sells well around the area of the store. 3. The shelf allocation data processing device according to claim 1, wherein the information analysis unit analyzes whether the product is a product that sells well in the month in which the store is arranged. 4. The information analyzing unit according to claim 1, wherein the information analyzing unit analyzes whether the product is a product suitable for an entertainment held around the area of the shop. Shelf allocation data processing device. 5. A first determining step of determining whether a product in a store is on a shelf at which the store stands out, and a second determining step of determining whether the product is a sellable product when the product is on a shelf at which the store stands out. And a third determining step of determining whether the product is at a predetermined shelf position. 6. A first discriminating step of discriminating whether a product in a store is on a shelf in the store, and when the product is not on a shelf in the store, the product is stored on a shelf in the store. A second determining step of determining whether there is a product, and a third determining step of determining whether the product is a product that can be sold when the product is on a shelf where the product is inconspicuous. Method. 7. A first determining step of determining whether a product in a store is on a shelf at the store, and when the product is not on a shelf at the store, the product is placed on a shelf at the store. A second determination step of determining whether the product is available; a third determination step of determining whether the product is a product that can be sold when the product is not on an inconspicuous shelf; and determining whether the product is an unsold product. 4. A shelf allocation data processing method, comprising: a fourth determining step; 8. Position information indicating an arrangement of each product on a store shelf,
Input means for inputting product information about the type of each product and sales status information of each product; storage means for storing the position information, the product information and the sales status information; Information analyzing means for analyzing whether or not a shelf position has been reached; shelf position information creating means for creating an optimal shelf position for each product based on the analysis result of the information analyzing means; and output means for outputting the shelf position information. A shelf layout data processing system, comprising: 9. The shelf allocation data processing system according to claim 8, further comprising fee information creating means for calculating an analysis fee to be charged to a client from the analysis result of said information analyzing means and creating fee information.