JPH11250132A - Store sales management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To obtain a sales analytical result compared with other stores in each store. SOLUTION: At the time of inputting an analytical period in sales analysis operation, each POS terminal 2 transmits sales analysis request data including the analytical period and the identification(ID) code of its store to a store sales management device 1. At the time of receiving the sales analysis request data, the device 1 identifies the requesting source store based on the store ID code and acquires store sales data corresponding to the analytical period out of the data of the requesting source store from a data base 4. The device 1 acquires also the store sales data corresponding to the same analytical period out of the data of other stores from the data base 4. The device 1 executes prescribed sales analytical processing based on respective store sales data and transmits sales analytical result data to the POS terminal of the requesting source store. At the time of receiving the sales analytical result data, each POS terminal 2 outputs a sales analytical result based on the received data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a store sales management system used in a distribution business in which sales of a plurality of stores such as shopping centers and chain stores are centrally managed by a headquarters (developer).

[0002]

2. Description of the Related Art For example, in a shopping center, each store that enters and operates as a tenant in the center bears expenses such as a parking fee for the center and a utility fee for a shared place. Allocated based on store floor space and sales performance. For this reason, the headquarters (developer) managing the entire shopping center had to accurately grasp the sales performance of each tenant store. Therefore, conventionally, a computer-based store sales management device installed in the headquarters and a POS terminal installed in each tenant store are connected by a communication line. Each POS terminal is provided with a means for totalizing store sales data based on sales data of each product registered for sale and transmitting the data via a communication line.
Means is provided for receiving store sales data transmitted from each POS terminal via a communication line, storing and managing the data for each store, and creating a database. With such a configuration, the headquarters easily grasped the sales performance of each tenant store by analyzing the contents of the database in a timely manner.

[0003]

However, conventionally,
Since the sales data of each store could only be obtained collectively with the store sales management device installed at the headquarters, each store checked the sales status of other stores from reports on sales analysis results distributed from the headquarters in a timely manner Then, the analysis was performed such as comparing with the sales situation of own store. For this reason, it is difficult for each store to check and analyze the sales status of other stores in real time when it is desired to analyze sales with other stores.

The present invention has been made in view of such circumstances, and an object of the present invention is to provide a store sales management system in which each store can obtain a sales analysis result with another store when necessary. What you want to do.

[0005]

According to a first aspect of the present invention, a plurality of POS terminals installed in a plurality of stores are connected to a store sales management device via a communication line,
Each POS terminal outputs the sales data of each product registered for sale via the input unit from the output unit, sums up the store sales data based on the sales data, and transmits the data to the store sales management device via the communication line. A store sales management system having means for receiving store sales data transmitted from each POS terminal via a communication line, storing and managing each store, and creating a database; Each POS terminal is provided with a means for selecting a sales analysis operation. Each of the POS terminals waits for the input of the analysis period when the sales analysis operation is selected, and when the analysis period is input via the input unit, identifies the analysis period and the store where the POS terminal is installed. The sales analysis request data incorporating the code is transmitted to the store sales management device via the communication line. When the store sales management device receives the sales analysis request data from any of the POS terminals via the communication line, the store sales management device identifies the store of the request source with the store identification code in the received data, and uses the data of the store of the request source as the data. In addition, store sales data corresponding to the analysis period in the received data is obtained from the database, and store sales data corresponding to the same analysis period is obtained from the database using data of other stores. And
A predetermined sales analysis process is performed based on each store sales data acquired from the database, and data indicating the sales analysis result is transmitted to the POS terminal of the requesting store via the communication line. Each POS terminal receives the sales analysis result data from the store sales management device via the communication line, and outputs the sales analysis result from the output unit based on the received data.

[0006] The invention described in claim 2 of the present application is the above-described claim 1.
In the described invention, each POS terminal waits for input of an analysis item together with an analysis period when a sales analysis operation is selected. When the analysis item is input together with the analysis period via the input unit, the sales analysis request data incorporating the analysis item, the analysis period, and the identification code of the store where the POS terminal is installed is transmitted via a communication line. To the store sales management device. In addition, the store sales management device can use any of the P
When the sales analysis request data is received from the OS terminal,
The requester store is identified by the store identification code in the received data, and the store sales data corresponding to the analysis period in the requester store and the received data is obtained from the database while the other store data is obtained. The store sales data corresponding to the same analysis period is acquired from the database. Then, based on each store sales data acquired from this database, the sales analysis process specified by the analysis item in the received data is performed, and the data indicating the sales analysis result is transmitted via the communication line to the POS terminal of the requesting store. To be sent to.

[0007]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment in which a store sales management system of the present invention is applied to a shopping center will be described below with reference to the drawings. FIG. 1 is an overall view of a store sales management system according to the present embodiment. The store sales management system includes a computer-based store sales management device 1 installed in a headquarters (developer) SC of a shopping center, and stores S11, S12,...
A plurality of POS terminals 2 installed in S1m, S21, S22,..., S2n are connected to a local area network (LAN).
work), each POS terminal 2 aggregates store sales data based on sales data of each registered product, and stores the data via the communication line 3. The store sales management device 1 has means for transmitting to the store sales management device 1.
Has a means for receiving the store sales data transmitted from the company via the communication line 3, storing and managing the data for each store, and creating the database 4.

FIG. 2 is a block diagram showing the configuration of the main part of the POS terminal 2. Each of the tenant stores S11 to S1m, S
The POS terminals 2 of 21 to S2n have the same configuration. As shown in the figure, the POS terminal 2 has a CPU (Central Processing Unit) 11 as a control unit main body. Further, a ROM (Read Only Memoly) 12 in which fixed data such as program data is stored in advance, a RAM in which a storage unit for registering merchandise sales data and the like are formed.
(Random Access Memoly) 13, a clock unit 14 for measuring the date and time, and the store sales management device 1 via the communication line 3.
A communication controller 15 for controlling the transmission and reception of data to and from the I / O port 18 for receiving a signal from the mode switch 16 and transmitting an opening drive signal to the drawer 17 in accordance with a command from the CPU 11;
c Drive) HDD controller 20 for controlling reading and writing of data to and from device 19, key for product sales registration and 1
A keyboard controller 22 which controls a keyboard 21 having various keys such as a transaction registration closing key and takes in a key signal of a pressed key, a front display 23 for an operator
And a display controller 25 for controlling the data display of the customer display 24, a printer controller 27 for controlling the printing operation of the printer 26 for receipt printing, and the like. Then, the CPU 11, the ROM 12, the RAM 1
3, the clock unit 14, the communication controller 15, the I / O port 18, the HDD controller 20, the keyboard controller 22, the display controller 25, and the printer controller 27 are connected by bus lines 28 such as an address bus and a data bus. The control circuit of the terminal 2 is constituted.

[0009] The mode switch 16 is provided with "registration",
A switch for selecting various operations such as "payment" and "setting" and instructing the CPU 11 to execute the operations is turned by a key. By the way, "registration" means that the sales data such as the number of sales and the sales amount of the product registered by the product sales registration key of the keyboard 21 functioning as an input unit are registered in the storage unit of the RAM 13, and the registration of the product is performed. The sales data is displayed on the front display 23 and the customer display 24 functioning as an output unit. When the end of sales registration of one transaction is declared by the registration closing key of the keyboard 21, the 1
Front display 2 shows the total price of all products registered for sale in the transaction
3 and a display for the customer 24, and a printer 26 is operated to print and issue a receipt. “Settlement” means that the sales data of each product registered in the storage unit after the store is closed for one day is totaled and transmitted as one-day store sales data to the store sales management device 1 via the communication line 3. This is a business mode in which the storage unit is cleared after the operation. “Setting” is a business mode in which data necessary for executing various business is set in the RAM 13 in advance. In particular, in the “setting” business mode, each P
Tenant code setting area 13a and terminal number setting area 13 formed in RAM 13 of OS terminal 2
b, the tenant code identifying the tenant store where the POS terminal 2 is installed, and the PO
A unique terminal number serving as a communication address of the S terminal 2 is set in advance.

FIG. 3 is a block diagram showing a configuration of a main part of the store sales management apparatus 1, and a CPU 31 is mounted as a control unit main body as shown in FIG. In addition to the main storage devices of the ROM 32 and the RAM 33, a clock unit 34 for measuring the date and time, a communication controller 35 for controlling transmission and reception of data to and from each of the POS terminals 2 via the communication line 3, and an HDD device 36 HDD controller 37 that controls reading and writing of data to and from FDD (Floppy Dis
k Drive) An FDD controller 39 for controlling reading and writing of data from and to a device 38, a keyboard controller 41 for controlling a keyboard 40 such as a full keyboard and taking in a key signal of a pressed key, and a data display on a display device 42 such as a CRT display. A display controller 43 and the like for controlling are mounted. And the CPU 31
And a ROM 32, a RAM 33, a clock unit 34, a communication controller 35, an HDD controller 37, an FDD controller 39, a keyboard controller 41, and a display controller 43, which are connected by bus lines 44 such as an address bus and a data bus. The control circuit of the device 1 is configured.

In the store sales management device 1 having such a configuration, the database 4 is created on a disk of the HDD device 36. FIG. 4 shows the main tables constituting the database 4, and the tenant table 51
Store name (tenant name) corresponding to the tenant code, which is the identification code of each tenant store S11-S1m, S21-S2n, an industry code specifying the business type of the store, and the floor of the shopping center where the store is opened Is stored. The business type table 52 stores names (such as restaurants, grocery stores, clothing stores, and mass merchandise stores) that specify the business type according to the business type code that classifies the business type of each tenant store S11 to S1m and S21 to S2n. is there. The floor table 53 stores names (for example, the first floor of the South Building, the second floor of the South Building, the first floor of the North Building, the second floor of the North Building, etc.) for specifying the floor for each floor code for distinguishing the floor of the shopping center. The daily sales table 54 is based on the store sales data for one day transmitted from each POS terminal 2 and stores the tenant stores S11 to S1m and S21 to each date (YYYYMMDD).
The daily sales amount and the number of customers in S2n are totaled for each store and stored corresponding to the tenant code of the store. The daily sales table 54 stores, for example, daily store sales data for the past year.

In the store sales management system according to the present embodiment, each POS terminal 2 is suitable for comparing the daily sales status of the own store with the other stores opened in the shopping center. “Daily analysis between tenants” and “Daily analysis within floor” suitable for comparing the daily sales status of other stores that are opening on the same floor as your own store, "Daily analysis within the same industry" suitable for comparing the daily sales status with the same other store and "Tenant intermonthly month" suitable for comparing the monthly sales status between the own store and other stores It is possible to selectively execute sales analysis work covering four items of “total analysis”.

Specifically, each POS terminal 2 is provided with the mode switch 1 as a means for selecting a sales analysis operation.
6 is provided with a key position of “sales analysis work”. And
When the execution key of the keyboard 21 is pressed after the key position of the mode switch 16 is set to "sales analysis work", the CPU 11 determines that the sales analysis work has been selected, and executes the processing shown in the flowchart of FIG. The program of each POS terminal 2 is configured to be executed.

That is, the CPU 1 of each POS terminal 2
When detecting an input of the execution key in a state where “sales analysis work” is selected by the mode switch 16, first, S
Front display 23 for operator as T (step) 1
10, a sales analysis item menu screen 61 showing a list of the various sales analysis items described above is displayed, and the number N of the analysis item to be executed and the target date YYYYMMDD of the analysis period (" In the case of "tenant monthly sales analysis", wait for the target year and month (YYYYMM) to be input. In this state,
When the input of the end key for instructing the end of the job is detected in ST2, the job process is ended.

In ST3, the number N of the analysis item to be executed by operating the numeric keypad of the keyboard 21 and the target date YYYYMMDD of the analysis period are input. In this case, as ST5, as shown in FIG. 5, the number N of the key-input analysis item and the target date YYYYMMDD of the analysis period are set.
And a transmission message incorporating the sales analysis request data including the tenant code NNNNNN and the terminal number NNN respectively set in the setting areas 13a and 13b of the RAM 13, and transmits the transmission message via the communication line 3. This is transmitted to the store sales management device 1 of the headquarters SC.

After that, the CPU 11 waits for a response from the store sales management device 1 as ST6. At this time, CP
U11 measures the standby time by a built-in timer,
In ST7, if a response cannot be received from the store sales management device 1 even after waiting for a certain period of time when the timer times out, a failure occurs in communication between the POS terminal 2 and the store sales management device 1. Therefore, this operation is reported as an error and the processing is terminated.

On the other hand, if a response message from the store sales management device 1 is received within a certain time when the timer times out, the response message is sent to the normal response in which the sales analysis result data is incorporated in ST8. It is determined whether the message is a message or an abnormal response message not including the sales analysis result data. Then, in the case of an abnormal response message, analysis was impossible, so this task is reported as an error and the processing is terminated. If the response message from the store sales management device 1 is a normal response message, a screen showing the sales analysis result of the sales analysis item selected from the sales analysis result data incorporated in the normal response message in ST9. Is edited and displayed on the front display 23 for the operator.

Next, a key input from the keyboard 21 is awaited. Here, when the input of the print key for instructing the printing of the sales analysis result is detected in ST10, the process proceeds to ST11.
Then, the print data of the sales analysis result is edited from the sales analysis result data incorporated in the normal response message, and the printer 26 prints out the print data on receipt paper. After that, it waits for the next key input. If the input of the save key for instructing the storage of the sales analysis result is detected in ST12, the sales analysis result data incorporated in the normal response message is written to the hard disk of the HDD device 19 and stored in ST13. After that, it waits for the next key input. When detecting the input of the end key for instructing the end of the processing of the selected sales analysis item in ST14, the process returns to ST1 to display the sales analysis item menu screen 61 on the front display 23 for the operator again. Has become.

On the other hand, each time the store sales management device 1 receives the message of the sales analysis request data transmitted from each POS terminal 2 via the communication line 3, the CPU 31 executes the processing shown in the flowchart of FIG. Configure the program to execute. That is, when the CPU 31 detects that a message has been received under the control of the communication controller 35, the CPU 31 shown in FIG.
The processing shown in the flowchart of FIG. 4 is started, and it is confirmed that the received message is the message of the sales analysis request data transmitted from the POS terminal 2 as ST1, and then the sales incorporated in the received message is confirmed. The analysis item number N of the analysis request data is checked.

Here, when the analysis item number N is the number [1] of the sales analysis item “daily analysis between tenants” (YES in ST2), the date of analysis of the sales analysis request data is analyzed. Find out. Then, when the analysis period target date is within the period of the daily store sales data stored and managed in the daily sales table 54, the inter-tenant daily total analysis process [see FIG. 8 (a)] ].
When the analysis item number N is the number [2] of the sales analysis item “daily analysis within floor” (YES in ST3),
Alternatively, also in the case where the sales analysis item is the number [3] of the “intra-industry daily total analysis” (YES in ST4), the analysis period target date of the sales analysis request data is checked. Then, when the analysis period target date is within the period of the daily store sales data stored and managed in the daily sales table 54, the in-floor daily total analysis process described below [FIG.
(B)] or a daily total analysis within the same industry [Fig.
(See (a)]. When the analysis item number N is the number [4] of the sales analysis item “monthly analysis between tenants” (YES in ST5), the analysis target year and month of the sales analysis request data are checked. Then, when the analysis period target year and month are within the period of the daily store sales data stored and managed in the daily sales table 54, a tenant monthly total analysis process described later [see FIG. 9 (b)]. Execute

Thus, the CPU 31 executes the sales analysis process specified by the analysis item number N of the sales analysis request data incorporated in the message received from the POS terminal 2;
When the normal response message incorporating the sales analysis result data is created, the normal response message is transmitted to the POS terminal 2 identified by the request terminal number NNN of the sales analysis request data via the communication line 3 in ST6. Then, the current message receiving process ends.

When the analysis period of the sales analysis request data is the target date or the target date is out of the period, and the analysis item number N is other than [1], [2], [3], [4]. If so, an abnormal response message is created because sales analysis processing is not possible. Then, the abnormal response message is stored in the POS identified by the request terminal number NNN of the sales analysis request data.
The message is transmitted to the terminal 2 via the communication line 3, and the current message receiving process ends.

The flowchart of FIG. 8A shows the procedure of the inter-tenant daily analysis process. That is, when the CPU 31 of the store sales management apparatus 1 starts the inter-tenant daily total analysis processing based on the sales analysis request data received from the POS terminal 2, first, as ST1, the daily sales table 54 is searched and the sales analysis request data is retrieved. The store sales data (tenant code, sales amount, number of customers) of the date data that matches the analysis period target date is read. Then, as ST2, the tenant table 51 is searched, and the tenant name corresponding to each tenant code of each store sales data read from the daily sales table 54 is read. In step ST3, the total sales amount of each store sales data read from the daily sales table 54 is added to calculate the total sales amount of the shopping center in the analysis period. Next, S
At T4, the total sales amount is apportioned by the sales amount of each store sales data, and the sales composition ratio for the analysis period target date is calculated for each of the tenant stores S11 to S1m and S21 to S2n. Then, as ST5, the tenant stores S11 to S1m and S21 to S2n are ranked in descending order of the sales composition ratio. Thereafter, if the sales amount, the number of customers, the rank, and the sales composition ratio of the tenant store identified by the request tenant code NNNNNN of the sales analysis request data, that is, the so-called request source store, are extracted in ST6, FIG. A normal response message incorporating the sales analysis processing result data in the format shown in FIG.

In the format of the sales analysis processing result data shown in FIG. 12A, the analysis item and the target date are the same as the corresponding sales analysis request data. The store sales amount, composition ratio, rank and number of customers are ST
6 is the data of the request source store extracted in the processing of No. 6. Also,
The tenant name, composition ratio, sales amount, and number of customers from the first to nth (n ≧ 2) ranks are the data of each store read from the daily sales table 54 in the processing of ST1 and ranked in the processing of ST5. The tenant code is replaced with the tenant name read in ST2.

FIG. 8B is a flow chart showing the procedure of the in-floor daily total analysis process. That is, when the CPU 31 of the store sales management device 1 starts the in-floor daily total analysis processing based on the sales analysis request data received from the POS terminal 2, first, the ST 31 searches the tenant table 51 as ST1 and requests the sales analysis request data. Tenant code N
The floor code corresponding to NNNN is read. Next, ST
The floor table 53 is searched as 2 and the floor name corresponding to the floor code read in the process of ST1 is read.
In addition, the tenant table 51 is searched as ST3,
A tenant code in which the same floor code as the floor code read in ST1 is set is searched for. Then, if all the corresponding tenant codes are acquired, the tenant store identified by the acquired tenant code is a store on the same floor as the request source store. Therefore, each tenant code acquired in the processing of ST3 from the tenant table 51 as ST4. Read the tenant name corresponding to.

Next, as ST5, the daily sales table 54
And reads the store sales data (tenant code, sales amount, number of customers) of date data that matches the analysis period target date of the sales analysis request data. Next, among the store sales data read from the daily sales table 54 in ST6, the store sales data of the request tenant code NNNNNN of the sales analysis request data, that is, the store sales of the request source store on the target date of the analysis period. The data and the store sales data of each tenant code acquired in the process of ST3, that is, the store sales data of the other store opening on the same floor as the requesting store at the analysis period target date are extracted. Then, as ST7, the tenant stores are ranked in descending order of the sales amount of each store sales data extracted in the process of ST6. Thereafter, if the sales amount, the rank, and the number of customers of the requesting store are extracted in ST8, a normal response message incorporating the sales analysis processing result data in the format shown in FIG. Has become.

In the format of the sales analysis processing result data shown in FIG. 12B, the analysis item and the target date are the same as the corresponding sales analysis request data. The floor (business) name is the floor name read from the floor table 53 in the process of ST2. The sales amount of the own store, the rank, and the number of customers are data of the request source store extracted in the process of ST8. Also, n (n ≧ n)
2) The tenant name, sales amount and the number of customers up to
The tenant code is replaced with the tenant name read in ST4.

FIG. 9 (a) is a flowchart showing the procedure of the daily total analysis within the same industry. That is, when the CPU 31 of the store sales management device 1 starts the intra-industry daily total analysis process based on the sales analysis request data received from the POS terminal 2, first, as ST1, the tenant table 51 is searched and the sales analysis request data The business type code corresponding to the requested tenant code NNNNN is read. Next, S
The business type table 52 is searched as T2, and the business name corresponding to the business type code read in the process of ST1 is read. In addition, the tenant table 51 is searched as ST3,
A tenant code in which the same business code as the business code read in the process of T1 is set is searched. Then, if all the corresponding tenant codes are acquired, the tenant store identified by the acquired tenant code is the same store as the request source store, so that each tenant acquired in the processing of ST3 from the tenant table 51 as ST4. Read the tenant name corresponding to the code.

Next, the daily sales table 54 is set as ST5.
And reads the store sales data (tenant code, sales amount, number of customers) of date data that matches the analysis period target date of the sales analysis request data. Next, among the store sales data read from the daily sales table 54 in ST6, the store sales data of the request tenant code NNNNNN of the sales analysis request data, that is, the store sales of the request source store on the target date of the analysis period. The data and the store sales data of each tenant code acquired in the process of ST3, that is, the store sales data of the other store having the same business type as the request source store on the date of the analysis period are extracted. And
In ST7, the tenant stores are ranked in descending order of the sales amount of each store sales data extracted in the process of ST6. Thereafter, if the sales amount, the rank, and the number of customers of the requesting store are extracted in ST8, the process proceeds to ST9 in FIG.
A normal response message incorporating the sales analysis processing result data in the format shown in FIG. 2B is created.

In the format of the sales analysis processing result data shown in FIG. 12B, the analysis item and the target date are the same as the corresponding sales analysis request data. The floor (business) name is the business name read from the business table 52 in the process of ST2. The sales amount of the own store, the rank, and the number of customers are data of the request source store extracted in the process of ST8. The tenant name, sales amount, and number of customers from the first to nth (n ≧ 2) ranks are data of each store extracted in the processing of ST6 and ranked in the processing of ST7, and the tenant code is read in ST4. Has been replaced with the tenant name.

The flowchart of FIG. 9B shows the procedure of the inter-tenant monthly total analysis processing. That is, when the CPU 31 of the store sales management device 1 starts the tenant inter-monthly total analysis processing based on the sales analysis request data received from the POS terminal 2, first, the ST 31 searches the daily sales table 54 as ST1, and executes the sales analysis request data. The respective store sales data (tenant code, sales amount, number of customers) of the date data corresponding to the respective dates of the analysis period target year and month are read. Then, as ST2, the tenant table 51 is searched, and the tenant name corresponding to each tenant code of each store sales data read from the daily sales table 54 is read. In step ST3, the sales amount of each store sales data read from the daily sales table 54 is added up for each tenant code to calculate the monthly sales amount in the target year and month for each of the tenant stores S11 to S1m and S21 to S2n. Next, as ST4, the tenant stores S11 to S1m and S10 are arranged in descending order of the monthly sales amount calculated for each of the tenant stores S11 to S1m and S21 to S2n.
21 to S2n are ranked. Thereafter, as ST5, the request tenant code NNNNN of the sales analysis request data is obtained.
If the monthly sales amount and the ranking of the tenant store identified by the above, that is, the so-called request source store, are extracted, the process proceeds to ST6 in FIG.
A normal response message incorporating the sales analysis processing result data in the format shown in FIG. 2D is created.

In the format of the sales analysis processing result data shown in FIG. 12D, the analysis item and the target year and month are the same as the corresponding sales analysis request data. The own store monthly sales amount and rank are the data of the request source store extracted in the process of ST5. The tenant names and the monthly sales amounts from the first to nth (n ≧ 2) ranks are data of each store calculated for each store in the process of ST3 and ranked in the process of ST4, and the tenant code is ST.
Replaced with the tenant name read in process 2.

As described above, in the store sales management system of the present embodiment, each of the tenant stores S11 to S1m, S21 to
Each tenant store S11-S based on the sales data of each product registered at the POS terminal 2 of S2n.
The daily sales data of 1m and S21 to S2n are tabulated for each store, and are stored and managed on a daily basis in the daily sales table 54 of the store sales management device 1.

In this state, each of the tenant stores S11 to S1m,
In S21 to S2n, the POS installed in the own store
Using Terminal 2, select four sales analysis tasks: daily analysis between tenants, daily analysis within floor, daily analysis within the same industry, and monthly analysis between tenants. Can be performed.

For example, when comparing the sales situation of the previous day with that of the own store and another store opened in the shopping center, first, the key position of the mode switch 16 of the POS terminal 2 is set to “sales analysis work”. After the adjustment, the execution key is pressed, and the sales analysis item menu screen 61 is displayed on the front display 23 for the operator. Next, if the analysis item number [1] of the sales analysis item "inter-tenant daily sales analysis" and the date [yyyy-mm-dd] of the previous day, which is the analysis period, are entered by key, the execution key is pressed again. . Then, the analysis item number [1] and the analysis period [yyyy-mm-
dd] and setting areas 13a and 13b of the RAM 13 in advance.
The sales analysis request data incorporating the tenant code NNNNN of the request source store set in the POS terminal 2 and the terminal number NNN of the POS terminal 2 is created, and the communication line 3
Is transmitted to the store sales management device 1 via the.

Thus, in the store sales management device 1, the above-described inter-tenant daily total analysis processing is performed. That is, from the daily sales table 54, the tenant stores S11 to S11 of the previous day [yyyy-mm-dd] corresponding to the analysis period
1m, the sales data of S21 to S2n are read, and the sales composition ratio is calculated for each store. The tenant stores S11 to S1m and S21 to S2n are ranked in descending order of the sales composition ratio, and the inter-tenant daily total analysis result including the ranked result is returned to the POS terminal 2 of the request source store. You.

Thus, the front display 23 of the POS terminal 2 displays the screen 62 showing the inter-tenant daily total analysis result as shown in FIG. 13 (a). By checking 62, it is possible to compare the sales situation of the previous day between the own store and another store that is opening at the shopping center. In this case, the store “Tenant G” has a sales composition ratio of 8.5 the day before.
%, Which is the third place overall, and that tenant A has 10.1% as the first place in the sales composition on the previous day.

Next, when comparing the sales situation of the previous day with other stores that are opening on the same floor as the own store, the sales analysis item menu screen 61 is displayed on the front display 23 in the same manner as described above. After that, the analysis item number [2] of the sales analysis item “daily sales analysis on the floor” and the date [yyyy-mm-dd] of the previous day, which is the analysis period, are keyed in, and the execution key is pressed. Then, sales analysis request data incorporating the analysis item number [2], the analysis period [yyyy-mm-dd], the tenant code NNNNNN of the requesting store and the terminal number NNN of the POS terminal 2 is created, and the communication line 3 is established. Is transmitted to the store sales management device 1 via the Internet.

Thus, the in-floor daily total analysis process described above is performed in the store sales management device 1. That is, the tenant store for which the same floor code as the request source store is set is searched from the tenant table 51, and the tenant store of the previous day [yyyy-mm-dd] corresponding to the analysis period is searched from the daily sales table 54. S11 ~
The sales data of S1m and S21 to S2n are read out, and the sales data of the requesting store and the sales data of another tenant store having the same floor code as the requesting store are selected from the sales data. Then, the tenant stores are ranked in descending order of the sales amount among the tenant stores for which the sales data is selected. The daily total analysis result on the floor including the ranked results is used as the POS of the request source store. Responds to Terminal 2.

Thus, the front display 23 of the POS terminal 2 displays the screen 63 indicating the result of the daily total analysis in the floor as shown in FIG. By checking 63, it is possible to compare the sales situation of the previous day with other stores that are opening on the same floor as the own store. In this case, the store “Tenant G” has the second highest sales rank in the floor “South Building 1F” the previous day, and the first sales rank in the same floor is Tenant A. It is possible to know that the rank is the tenant store C, and the like.

Next, in order to compare the sales situation of the previous day with that of the same store and another store of the same business type, after displaying the sales analysis item menu screen 61 on the front display 23 in the same manner as described above, The analysis item number [3] of the sales analysis item “Daily sales analysis within the same industry” and the date [yyy] of the previous day which is the analysis period
y-mm-dd], and then press the execution key. Then, sales analysis request data incorporating the analysis item number [3], the analysis period [yyyy-mm-dd], the tenant code NNNNN of the requesting store and the terminal number NNN of the POS terminal 2 is created, and the communication line 3 is established. Is transmitted to the store sales management device 1 via the Internet.

As a result, in the store sales management device 1, the above-mentioned daily total analysis process in the same business category is performed. That is, the tenant store having the same industry code as the request source store is searched from the tenant table 51, and the previous day [yyyy] corresponding to the analysis period is searched from the daily sales table 54.
-Mm-dd] tenant stores S11 to S1m, S21 to S
The sales data of 2n is read out, and the sales data of the requesting store and the sales data of another tenant store having the same business type as the requesting store are selected from the sales data. Then, among the tenant stores for which the sales data is selected, the tenant stores are ranked in descending order of the sales amount, and a daily total analysis result within the same industry including the ranked results is obtained for the requesting store. Responds to POS terminal 2.

Thus, on the front display 23 of the POS terminal 2, a screen 64 showing the daily total analysis result within the same industry as shown in FIG. 14A is displayed. By checking the screen 63, it is possible to compare the sales situation of the previous day with other stores having the same business type as the own store. In this case, the store “Tenant G” has the second highest sales rank in the “restaurant” industry the previous day, and the first sales rank in the same business category is tenant E, and the third rank. Is a tenant store C.

Next, in order to compare the sales situation between the own store and the other store during the last month, the sales analysis item menu screen 61 is displayed on the front display 23 in the same manner as described above. The analysis item number [4] of the analysis item “tenant inter-month total sales analysis” and the last month [yyyy-
mm], and then press the execution key. Then, the analysis item number [4] and the analysis period [yyy-
mm], sales analysis request data incorporating the tenant code NNNNN of the requesting store and the terminal number NNN of the POS terminal 2 is created, and transmitted to the store sales management device 1 via the communication line 3.

Thus, in the store sales management apparatus 1, the above-described inter-tenant monthly total analysis processing is performed. That is, the daily sales data of the tenant stores S11 to S1m and S21 to S2n for the last month corresponding to the analysis period is read from the daily sales table 54, and the daily sales amounts are added up for each store, and the monthly sales are calculated. The amount is calculated. Then, each tenant store S11 to S1m, S21 to S
2n ranking is performed, and the inter-tenant monthly total analysis result including the ranked result is returned to the POS terminal 2 of the requesting store.

Thus, since the front display 23 of the POS terminal 2 displays the screen 65 showing the results of the inter-tenant monthly total analysis as shown in FIG. 14B, the operator of the requesting store checks the screen 65 By confirming the number 65, it is possible to compare the sales situation of the own store and the other stores opening at the shopping center during the last month.
In this case, the store “Tenant G” has a sales amount of 6,234,152 yen for the first month last month, which is the second place overall, and the first place sales for the last month is 7,399, 6
You can know that it is tenant A for 11 yen.

Next, when the operator wants to obtain the inter-tenant monthly total analysis result displayed on the front display 23 as a print record, he presses the print key while the screen 65 is displayed. Then, data indicating the inter-tenant monthly total analysis result is printed on the receipt paper by the printer 26, and a report 66 of the inter-tenant monthly total analysis result as shown in FIG. 11 is issued. If the operator wants to save the inter-tenant monthly total analysis result, the operator presses the save key. Then, data indicating the result of the inter-tenant monthly total analysis is written and stored on the disk of the HDD device 19.

As described above, for example, by introducing the store sales management system according to the present embodiment in a shopping center, each tenant store in the center can obtain the sales status of other tenant stores in real time from the store whenever necessary. Can be confirmed and analyzed. Therefore, each tenant store can always accurately grasp the sales situation, and the operation for grasping it is easy, so the person in charge of the tenant store compared with the conventional one that grasped the sales situation based on the report distributed from the headquarters Work load can be reduced. In addition, since the head office does not need to create a report of the sales analysis result and distribute it to each tenant store,
It is effective.

The present invention is not limited to the above embodiment. For example, in the above-described embodiment, the analysis period is input in units of one day or one month. However, for example, the start date and the end date of the analysis period are input in the POS terminal 22, and the sales analysis in the period is performed by the store. Sales management device 1
May be performed.

It goes without saying that the sales analysis items are not limited to the above-mentioned four items, and the output format of the analysis results is, of course, not limited to the above-described embodiment.

[0051]

As described in detail above, according to the store sales management system of the present invention, it is possible to check and analyze the sales situation of another store in real time from the own store whenever necessary. In addition, it is possible to obtain excellent effects such as always being able to accurately grasp the sales situation at each store, and since the operation for grasping is easy, the work load on the person in charge can be reduced.

[Brief description of the drawings]

FIG. 1 is an overall view of an embodiment to which a store sales management system according to the present invention is applied.

FIG. 2 is an exemplary block diagram showing a main part configuration of the POS terminal according to the embodiment;

FIG. 3 is an exemplary block diagram showing a main configuration of the store sales management device according to the embodiment;

FIG. 4 is an exemplary view showing main tables of a database created by the store sales management device according to the embodiment;

FIG. 5 is a diagram showing a format of sales analysis request data transmitted from the POS terminal to the store sales management device in the embodiment.

FIG. 6 shows C of the POS terminal according to the embodiment.
The flowchart which shows the processing procedure of the sales analysis business which PU performs.

FIG. 7 shows C of the store sales management device according to the embodiment.
5 is a flowchart showing a main part of a message reception process executed by a PU.

8 is a flowchart specifically showing each procedure of a daily total analysis process between tenants and a daily total analysis process within a floor in FIG. 7;

FIG. 9 is a flowchart specifically showing each procedure of daily total analysis within the same business type and monthly total analysis between tenants in FIG. 7;

FIG. 10 is a view showing an example of a sales analysis item menu screen displayed on the display unit of the POS terminal in the embodiment.

FIG. 11 is a view showing an example of a sales analysis result report printed and issued from a POS terminal in the embodiment.

FIG. 12 is a diagram showing a format of sales analysis result data transmitted from the store sales management device to the POS terminal in the embodiment.

FIG. 13 is a diagram showing an example of a daily total analysis result screen between tenants and a daily total analysis result screen within a floor displayed on the display unit of the POS terminal in the embodiment.

FIG. 14 is an exemplary diagram of an intra-industry daily total analysis result screen and an inter-tenant monthly total analysis result screen displayed on the display unit of the POS terminal in the embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Store sales management apparatus 2 ... POS terminal 3 ... Communication line 4 ... Database 51 ... Tenant table 52 ... Industry table 53 ... Floor table 54 ... Daily sales table

Claims (2)

[Claims] 1. A plurality of POS terminals respectively installed in a plurality of stores are connected to a store sales management device via a communication line, and each of the POS terminals stores sales data of each product registered for sale via an input unit. Output from the output unit, and has means for totalizing store sales data based on the sales data and transmitting the totalized data to the store sales management device via the communication line. The store sales management device
In a store sales management system having means for receiving store sales data transmitted from the OS terminal via the communication line, storing and managing the stores for each store, and creating a database, each of the POS terminals selects a sales analysis operation. When a sales analysis operation is selected by this means, an input of an analysis period is awaited. When an analysis period is input via the input unit, the analysis period and the POS terminal are installed. The sales analysis request data incorporating the store identification code is transmitted to the store sales management device via the communication line, and the sales analysis result data is received from the store sales management device via the communication line accordingly. Then, a sales analysis result is output from the output unit based on the received data, and the store sales management device is connected via the communication line. When the sales analysis request data is received from one of the POS terminals, the request source store is identified by the store identification code in the received data, and the request source store data corresponds to the analysis period in the received data. The store sales data is obtained from the database and the store sales data corresponding to the same analysis period is obtained from the database with the other store data, and a predetermined sales analysis process is performed based on each store sales data obtained from the database. And transmitting the data indicating the sales analysis result to the POS terminal of the requesting store via the communication line. 2. A plurality of POS terminals respectively installed in a plurality of stores are connected to a store sales management device by a communication line, and each of the POS terminals has sales data of each product registered for sale via an input unit. Output from the output unit, and has means for totalizing store sales data based on the sales data and transmitting the totalized data to the store sales management device via the communication line. The store sales management device
In a store sales management system having means for receiving store sales data transmitted from the OS terminal via the communication line, storing and managing the stores for each store, and creating a database, each of the POS terminals selects a sales analysis operation. When a sales analysis operation is selected by this means, input of an analysis item and an analysis period is waited for, and when an analysis item and an analysis period are input through the input unit, the analysis item and the analysis period are input. And transmitting the sales analysis request data incorporating the identification code of the store in which the POS terminal is installed to the store sales management device via the communication line. When the sales analysis result data is received via the PC, the sales analysis result is output from the output unit based on the received data, and the store sales When the sales device receives the sales analysis request data from any of the POS terminals via the communication line, the management device identifies the requesting store with the store identification code in the received data, and uses the data of the requesting store as data. And the store sales data corresponding to the analysis period in the received data is obtained from the database, and the store sales data corresponding to the same analysis period is obtained from the database with the data of other stores, and each store sales data obtained from the database is obtained. The sales analysis processing specified by the analysis item in the received data is performed based on the data, and the data indicating the sales analysis result is transmitted to the POS of the request source store via the communication line.
Store sales management system characterized by sending to the terminal.