JP2001209863A - Store management device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To grasp a relation between the position of a commodity in a selling place and the position of a cash register where a customer purchasing the commodity pays a price for it. SOLUTION: Single commodity sales data on each commodity collected from a terminal for registering the sales of each commodity is totaled by each terminal registering the sales of each commodity. Positional information at the selling place where each terminal for registering the sales of each commodity is placed is stored and positional information at the selling place where the commodity is sold is stored for each commodity. When the commodity the sales of which is to be analyzed is selected, each-terminal sales total data of the commodity is obtained and the sales position of the commodity in the selling place and the installing position of the terminal for registering the sales of the commodity in the selling place are obtained. Then, these pieces of obtained information are visualized and outputted.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a POS (Point Of
Sales: point-of-sale information management) The present invention relates to a store management apparatus that collects and aggregates sales data of products registered for sale at a product sales registration terminal such as a terminal, and outputs information necessary for store management.

[0002]

2. Description of the Related Art As a conventional store management device of this kind,
The sales data for each product registered for sale at the product sales registration terminal is collected and tabulated for each time zone in which sales were made, and the relationship between products and time zones, that is, the time zone when sales are high and the time when sales are low for each product And the sales data of each product collected from multiple product sales registration terminals are aggregated for each terminal, and the relationship between each product sales registration terminal and the product, that is, the product sales registration There have been known ones that enable analysis of a product with a high registration frequency and a product with a low sales registration frequency for each terminal.

[0003]

However, the relationship between the position of a product in a sales floor and the position of a cash register at which a customer who purchases the product pays out the price, that is, a cash register most used by a customer who purchases the product, is used. Conventionally, there has not been a store management device capable of analyzing the location of the least-used cash register and the like, and the like. Being able to analyze this information will help you determine where to place your products for better sales,
Information useful for store management, such as where to install a cash register to increase operating efficiency, can be obtained.

Accordingly, an object of the present invention is to provide a store management device capable of obtaining information useful for store management as described above.

[0005]

The invention described in claim 1 of the present application collects and aggregates single item sales data of each product registered for sale from a plurality of merchandise sales registration terminals and collects information necessary for store management. A store management device that outputs a single item sales terminal for each product, which collects single item sales data of each product collected from each product sales registration terminal for each product sales registration terminal registered for each product; Terminal position information storage means for storing position information at the sales floor where the terminal is located for each registration terminal, and product position information storage for storing position information at the sales floor where the product is sold for each product Means is provided, and a product selection means for selecting a product to be analyzed for sales is provided. Then, when a product to be analyzed for sales is selected by the product selection means, the terminal-based sales total data of the product is obtained from the totaling result by the single-item sales terminal totaling means, and the sales position of the product in the sales floor and The installation position of the product sales registration terminal in which the product is registered for sale is obtained from the storage information of the product position information storage means and the terminal position information storage means, and the obtained information is visualized and output. is there.

[0006]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below with reference to the drawings. In FIG. 1, reference numeral 1 denotes a store management device of the present invention, and the store management device 1 is installed in, for example, a store management office. And LAN
A plurality of file processors 3 are connected via a (Local Area Network) 2 so that data communication with each of the file processors 3 can be performed.

Each of the file processors 3 is installed, for example, on each floor of a store. Then, a closed loop is formed by the POS terminal 4 and the communication line 5 placed at each sales floor on the same floor, and data can be collected from each POS terminal 4 and data can be distributed to each POS terminal 4. It has become.

The store management device 1 is provided with a single item master file 6, a sales floor master file 7, a terminal master file 8, and a single item sales totalization file 9, in particular. As shown in FIG. 2, the single item master file 6 corresponds to a single item code set for each product, and specifies a sales floor where the product is sold, along with the name and unit price of the product. A code and sales position information for specifying a product display location in the counter are set and stored in advance, and constitute a product position information storage unit.

As shown in FIG. 3, the sales floor master file 7 includes, for each sales floor code set for each sales floor, the sales floor name, the floor number where the sales floor is located, the passage in the sales floor, and the like. The image information indicating the sales floor layout such as the position of the display shelf is set and stored in advance.

The terminal master file 8 is shown in FIG.
As shown in FIG. 7, corresponding to the terminal number set for each POS terminal 4, the sales floor code of the sales floor where the POS terminal 4 is installed, and the installation position information for specifying the terminal installation location in the sales floor Are set and stored, and constitute a terminal location information storage unit.

As shown in FIG. 6, the single item sales totalizing file 9 collects and stores the single item sales data of the sales amount, the number of sales points, and the number of customers daily by using the single item code and the terminal number as keys.

That is, each POS terminal 4 creates single item sales data in the format shown in FIG. 5 for each product sold and registered at the POS terminal 4 and transmits it to the file processor 3 via the communication line 5. In FIG. 5, the item “TMNo” is the terminal number of the POS terminal 4 where the product is sold and registered, the item “transaction date and time” is the date and time when the product is registered for sale,
The item "single item code" is the single item code of the product, the item "sales amount" is the price for the sales volume of the product,
The item “sales points” is the sales quantity of the product.

On the other hand, each file processor 3 accumulates and stores the single item sales data sent from each POS terminal 4 connected to the line. Then, in response to a collection command transmitted from the store management device 1 via the LAN 2, the single item sales data stored and transmitted to the store management device 1 via the LAN 2.

The store management device 1 searches for the single item sales totalization file 9 whose transaction date matches the date, using the terminal number and the single item code as keys, for each single item sales data collected from each file processor 3. If a file record that matches the search key is detected, the sales amount and sales points of the single item sales data are added to the sales amount and sales points of the record, and the number of customers is incremented by one. On the other hand, if a file record that matches the search key is not detected, the sales amount, the number of sales points, and the number of customers of the single item sales data are added to the single item sales totalization file 9 together with the search key. As a result, in the single item sales totalization file 9, single item sales data of the sales amount, the number of sales points, and the number of customers are totaled using the single item code and the terminal number as keys. Here, the store management device 1
Constitutes a single-unit sales terminal-by-unit totalizing unit that uses the single-unit sales totalization file 9 to total single-unit sales data of each product collected from each POS terminal 4 for each POS terminal registered for sale for each product.

FIG. 7 is a block diagram showing a main part of a hardware configuration of the store management device 1. As shown in FIG. In FIG.
1 is a CPU that controls the entire operation as the store management device 1
(Central Processing Unit).
ROM (Read Only Memory) 13 and RAM via bus lines 12 such as an address bus and a data bus.
(Random Access Memory) 14, a clock circuit 15 for measuring the current date and time, and an FDD (Floppy Disk Drive).
e) FDD controller 17 for controlling driving of device 16
An HDD controller 19 for controlling the driving of an HDD (Hard Disc Drive) device 18 for storing and maintaining the single item master file 6, the sales floor master file 7, the terminal master file 8, the single item sales totalization file 9, and the like;
A LAN communication controller 20 for controlling data communication of a predetermined protocol via N2 is connected to various input / output device interfaces such as a keyboard interface 21, a display interface 22, a printer interface 23, and a mouse interface 24.

The keyboard interface 21 has character keys, numeric keys, function keys, registration keys,
Connect a keyboard 25 provided with cursor keys and the like,
A display 26 such as a CRT display capable of displaying images is connected to the display interface 22, a printer 27 such as a laser printer is connected to the printer interface 23, and a mouse 28 is connected to the mouse interface 24. Is composed.

The store management device 1 having such a hardware configuration.
, In particular, is configured to execute the processing of the single item sales analysis work shown in the flowchart of FIG. That is, when the execution of the single item sales analysis job is instructed by the input of the mouse 28 in a state where the job selection screen is displayed on the display 26, the CPU 11 starts the process shown in the flowchart of FIG.

First, as ST (step) 1, the process waits for a designated input of a total period of single item sales data to be subjected to sales analysis. Here, the period [yyyy / mm / dd-day to yyyy / mm / dd]
Is input from the HDD 18 as ST2.

Next, as ST3, the process waits until a product to be analyzed for sales is selected. Here, when the single item code of the item is input by the key operation of the keyboard 25, it is determined that the item for which the single item code is set is selected as the item to be analyzed for sales. Then, a single item master record such as a single item name, a unit price, a sales floor code, and sales position information of the selected item is acquired from the single item master file 6 as ST4. Further, from the data of the single item sales totalization file 9 in the analysis period read from the HDD device 8 in the processing of ST2, the sales amount, the number of sales points, and the number of customers of the selected product are extracted and totalized by the terminal number. Here, the keyboard 25 constitutes a product selection unit.

Next, the CPU 11 determines the terminal number obtained by summing up the sales data of the product selected as ST5, that is, all POs for which the product has been sold and registered within the analysis period.
The terminal code corresponding to the terminal number of the S terminal 4 and the terminal master information of the installation position information are read from the terminal master file 8 and acquired. Also, as ST6, the sales floor name, floor number and sales floor layout information corresponding to the sales floor code of the sales floor where the POS terminal 4 of the same terminal number is installed are read and acquired from the sales floor master file 7.

Here, if it is confirmed in ST7 that there is only one type of floor number acquired from the sales floor master file 7, then in ST8, the terminal number is obtained from the POS terminal sales total data of the selected commodities obtained in the processing in ST4. A separate sales list 31 is created, the sales floor layout information acquired from the sales floor master file 7 in the processing of ST6, and the terminal master file 8 in the processing of ST5.
Location information of the POS terminal obtained from
The sales floor layout graphic 32 is created based on the sales position information of the selected product acquired from the single item master file 6 in the process 4. Then, as shown in FIG. 9, the single item sales analysis image 30 displaying the terminal-by-terminal sales list 31 and the sales floor layout graphic 32 is edited and displayed on the display 26 (product sales analysis processing means).

Here, the single item sales analysis image 30 includes:
A period change button 33, a product change button 34, and an end button 35 are displayed. Then, the CPU 11 waits for input of any button in ST9. When the period change button 33 is input by the input of the mouse 28, the process returns to ST1 and waits for the designation input of the total period of the single item sales data to be analyzed. Similarly, if the product change button 34 is input, the process returns to ST3 and waits for the selection of a product to be analyzed for sales. When the end button 35 is input, the display on the display 26 is cleared in ST10, and the processing as the single item sales analysis operation is ended.

As described above, in the store management apparatus 1 of the present embodiment, when executing the single item sales analysis work, when the period for performing the sales analysis and the product are specified and input, the single item sales data within the specified period of the product is obtained. PO registered for sale
The data is tabulated for each S terminal and displayed as a terminal-specific sales list 31 on the single item sales analysis screen 30 of the display 26. A sales floor layout graphic 32 indicating the sales position of the product and the installation position of the POS terminal where the product is registered for sale is also displayed on the single item sales analysis screen 30.

Therefore, the operator can easily analyze, from the single item sales analysis screen 30, where the cashier most frequently used by the customer purchasing the merchandise and which cashier is least used are.

For example, a single item sales analysis screen 30 shown in FIG.
Is displayed, the product with the single item name "AAA" is analyzed in the analysis period "yyyy mm / dd-yyyy mm / dd"
On the day, the POS terminal with the terminal number [001] has a sales of 1,500 yen, the POS terminal with the terminal number [002] has the sales of 5,100 yen, and the POS terminal with the terminal number [003] has the sales of 2,000 yen. Yes, terminal number [004]
It can be known from the terminal-by-terminal sales list 31 that the POS terminal sold 400 yen. Also,
The cashier in which the POS terminal with the terminal number [002] used most by the customer who purchases the product with the single item name "AAA" is located above (north side) the sales position of the product with the sales floor name "AA counter". A cash register, which is used less frequently in the counter, has a POS of terminal number [003] located on the left side (west side) of the selling position of the product.
The cashier where the terminal is installed can be easily grasped from the sales floor layout graphic 32. The sales floor layout figure 32 also indicates that the product is registered for sale at a sales floor with a sales floor name [BB sales floor] which is another sales floor.

As a result, it is possible to easily obtain information useful for store management from such information as to where the product should be placed for better sales and where to install a cash register to increase the operating efficiency. it can.

In the single-item sales analysis process of FIG. 8 in the embodiment, a print button is displayed on the single-item sales analysis screen 30 displayed on the display 26 in the process of ST8, and the print button is set in ST9. The program may be configured so that, when input by the mouse 28, the contents of the single item sales analysis screen 30 are printed out on the recording paper by the printer 27.

[0028]

As described above in detail, according to the first aspect of the present invention, the relationship between the position of a commodity in a sales floor and the position of a cash register at which a customer who purchases the commodity pays out the price can be easily established. A store management device that can obtain information useful for store management, such as where to place products and sales are better, and where to install cash registers to increase operating efficiency. Can be provided.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a store system configuration of an embodiment using a store management device of the present invention.

FIG. 2 is a configuration diagram of a single item master file included in the store management device in the embodiment.

FIG. 3 is a file configuration diagram of a sales floor master file included in the store management device in the embodiment.

FIG. 4 is a file configuration diagram of a terminal master file included in the store management device in the embodiment.

FIG. 5 is a view showing a layout of single item sales data transmitted from the POS terminal in the embodiment.

FIG. 6 is a file configuration diagram of a single item sales totalization file included in the store management device in the embodiment.

FIG. 7 is an exemplary block diagram showing a hardware configuration of the store management device according to the embodiment;

FIG. 8 shows a CPU of the store management device in the embodiment.
4 is a flowchart showing a processing procedure of a single item sales analysis job executed by the company.

FIG. 9 is a diagram showing an example of a single item sales analysis screen displayed and output on a display device of the store management device in the embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Store management apparatus 4 ... POS terminal 6 ... Single item master file 7 ... Sales floor master file 8 ... Terminal master file 9 ... Single item sales totalization file 11 ... CPU 26 ... Display 30 ... Single item sales analysis screen 31 ... Terminal sales list 32 ... sales floor layout figure

Continued on the front page F-term (reference) 3E042 CD02 CD10 CE06 5B049 BB11 DD01 EE02 GG01 GG02 GG09 5E501 AA01 AB30 AC07 AC35 BA03 CA03 CB09 EA05 EA10 FA14 FA23 FA44 FA46 9A001 BB02 BB03 BB04 CC08 FF03 JJ59 KK

Claims (1)

[Claims] Claims: 1. A store management device for collecting and summing up single item sales data of each product registered for sale from a plurality of product sales registration terminals and outputting information necessary for store management. Aggregation means for individual product sales terminals that aggregates the individual product sales data for each product collected from the terminal for each product sales registration terminal that has been registered for sale for each product, and the sales floor where the terminal is located for each product sales registration terminal Terminal position information storage means for storing the position information at the store, product position information storage means for storing the position information at the sales floor where the product is sold for each product, and product selection for selecting the product to be analyzed for sales Means, when a product for which sales analysis is performed is selected by the product selection means, the terminal-based sales summary data of the product is obtained from the result of aggregation by the single-item sales terminal-based summary means,
The sales position in the sales floor of the product and the installation position in the sales floor of the product sales registration terminal that has registered and sold the product are obtained from the storage information by the product position information storage means and the terminal position information storage means, and the obtained information is obtained. And a merchandise sales analysis processing means for visualizing and outputting.