JP5921499B2 - Sales analysis apparatus and program - Google Patents

Description

The present invention relates to a sales analysis apparatus and program for analyzing sales of a predetermined store based on sales data collected from each store.

Conventionally, in an electronic cash register (ECR) as a store terminal for registering sales data of products purchased by a customer, for example, a journal report on which sales results for one day are printed at the end of a day's business. In addition to the sales data file by product and the sales data file by time zone in addition to the sales data file by product, the sales status by time zone is displayed together with the sales status by product. It can be printed out and is an effective document for sales strategy.
Each store has characteristics in which the best-selling products and customer segments are greatly different depending on the type of business, region, and handling products, and sales promotion measures are taken in consideration of such characteristics. In this case, if it is possible to properly grasp the sales status of other stores in the same industry, it will be advantageous in terms of competition with other stores in the same industry. For this reason, I could not know the sales situation of other stores in my neighborhood.

JP 2000-48103 A

  By the way, in recent years, consumer trends have been changing rapidly due to diversification of values, centralization, etc., and it is said that it is extremely difficult to accurately grasp consumer trends. . In such a time of rapid change, it is not possible to take appropriate measures only by sales promotion measures that are conscious of competition with other stores in the same industry. In other words, rather than competition between stores in the region, it has begun to shift to competition between regions such as shopping streets and shopping centers, and the fact that the ability to attract customers to the region will increase as it is, each store in the region as it is Will bring prosperity.

An object of the present invention is to make it possible to immediately know whether or not a product sold at a store is appropriate.

Claim 1 is a sales analysis apparatus that performs sales analysis of a given store based on the collected sales data from each store, on the basis of the respective commodity sales data collected from each store, good selling go selling items Extracting means for extracting the best selling products extracted by the extracting means with the products sold at the predetermined store, and determining means for discriminating among the best selling products that the predetermined store does not handle; if there is commodity predetermined store does not address, characterized by comprising output means for outputting information of the selling goods not covered that, the.

According to this invention, it is possible to immediately know whether or not a product sold at a store is appropriate.

It is the block diagram which showed the sales analysis agency system which collects and analyzes the sales data of each store. (A) is a diagram showing various databases 4 provided on the service surrogate server 1 side, and (B) is a diagram showing various log files provided on the store terminal 2 side. (A) is the figure which showed the structure of the sales database 4-1 according to time zone according to a store, (B) is the figure which showed the structure of the sales database 4-2 according to goods according to a store, (C) is classified according to a store It is the figure which showed the structure of the sales database 4-3 according to transaction. (A) is the figure which showed the structure of the marketable goods database 4-5 according to area, (B) is the figure which showed the structure of the database 4-6 according to area. The sales log file 2-1 and the transaction log file 2-2 provided on each store terminal 2 side are shown, (A) is the sales log file 2-1, and (B) is the transaction log file 2-2. It is the figure which showed the structure. 2 is a block diagram showing an overall configuration of a service surrogate server 1. FIG. It is the block diagram which showed the whole structure of each shop terminal. It is the flowchart which showed the outline | summary of the whole operation | movement by each shop terminal 2 side. It is the flowchart which showed the sales data registration process performed in each shop terminal 2 side. It is the flowchart which showed the outline | summary of the whole operation | movement by the service surrogate server 1 side. It is the flowchart which showed the other sales analysis processing.

Hereinafter, an embodiment of the present invention will be described with reference to FIGS.
FIG. 1 is a block diagram showing a sales analysis agency system that collects and analyzes sales data of each store. This sales analysis agency system performs data communication with each store side via a wide area communication network. A server (service agency server) 1 on the service provider side that performs this agency service and each store side This is a wide area communication system in which an installed store terminal 2 is connected to a network via a wide area communication network (Internet) 3. A database 4 is provided in the server 1 on the service provider side.

  The service agency server 1 on the service provider side has a server function for managing and controlling the database 4 and a mail server function for controlling and managing e-mails, as well as a Web server function. I try to control it. The store terminal 2 includes, for example, an electronic cash register (ECR) or ECR as a sales data processing device and a personal computer connected thereto, and has a browser function. In this embodiment, for example, the digitized (packetized) data is transmitted and received between the service surrogate server 1 and the store terminal 2 by the HTTP protocol using the TCP / IP communication protocol. In addition, data processing is performed in cooperation with each other while recognizing necessary processing contents from data including encoded control information.

  In this embodiment, membership registration is performed via the Internet 3 in order to conclude a use contract for using a sales analysis proxy service between the service provider and each store. When registering as a member, identification information and attribute information unique to the store include the store name, address, e-mail address, telephone number, etc., as well as the business type of the store (store classification), the name of the area to which the store belongs, etc. On the service surrogate server 1 side, the store-specific identification information and attribute information presented from each store are registered in the database 4. The area name is not fixed, and the contents instructed by the registered member user are registered as they are. That is, in addition to a shopping street and a downtown area, the area ranges such as around Shinjuku Station and the western part of Tokyo are arbitrary.

  When the member store side transmits the sales data of the day via the Internet 3 periodically to the service agent server 1 side, for example, every day, the service agent server 1 stores the store on the basis of the sales data of each store. In addition to performing sales analysis on a unit basis, sales analysis is performed for each region, and a report message as a result of the analysis is distributed to each store. In other words, the service surrogate server 1 collects sales data transmitted from each store side, performs time-based aggregation, product-specific aggregation, and transaction-specific aggregation processing, and reports to that store, or within the same region Sales analysis such as analyzing the most popular products or analyzing products that are not handled in the store among the popular products and reporting to the store. This agency service for sales analysis is performed for a fee, and the service agency server 1 performs a billing procedure for charging the agency store for the agency fee. In this case, the collection of the usage fee is settled by automatic withdrawal from the account of the registered member user's financial institution or credit payment.

FIG. 2A is a diagram showing various databases 4 provided on the service surrogate server 1 side. The service surrogate server 1 side includes a sales database 4-1 for each store and a product for each store. A sales database 4-2, a sales database 4-3 for each transaction, a hot selling product database 4-4 for each region, and a database 4-5 for each region are provided.
FIG. 2B is a diagram showing various log files provided on the store terminal 2 side. A sales log file 2-1 and a transaction log file 2-2 are provided on the store terminal 2 side. Yes.

  FIG. 3A is a diagram showing the configuration of the store-specific sales database 4-1. The sales database for each time zone by store 4-1 stores and manages the sales data for one day corresponding to each store, classified and sorted by time zone. Each item of “Amount”. In this case, the service surrogate server 1 collects sales data for one day sent from each store terminal 2 at the end of the day, etc., and totals the sales data for each predetermined time zone, “Total number of sales” and “sales amount”, which are the results of counting by time zone, are set in the sales database 4-1 by time zone by store.

  FIG. 3B is a diagram showing the configuration of the store-by-store product-by-store sales database 4-2. The store-by-product sales database 4-2 stores and manages sales data for one day corresponding to each store, classified and sorted by product, and includes “product code”, “unit price”, “number of sales”, Each item includes “total sales amount”, “inventory”, and “profit”. In this case, the service surrogate server 1 collects sales data for one day transmitted from each store terminal 2 at the end of the day, etc., and totals the sales data for each product. “Number of units sold”, “Total amount of sales”, “Inventory”, and “Profit” are set in the sales database 4-2 by product for each store.

  FIG. 3C is a diagram showing the configuration of the store-by-store sales database 4-3. The sales database for each transaction 4-3 stores and manages the sales data for one day corresponding to each store, classified and classified by transaction, and stores each item of “transaction type” and “total sales amount”. Have. In this case, the service surrogate server 1 collects sales data for one day sent from each store terminal 2 at the end of the day, etc., and totals the sales data for each transaction such as cash sale, credit, The “total sales amount”, which is the result of counting by transaction, is set in the sales database 4-3 by transaction for each store.

  FIG. 4A is a diagram showing the configuration of the regional best-selling product database 4-5. The best-selling product database 4-5 by region stores and manages the best-selling products analyzed for each region and each product category. For example, for each product category (product category) such as food, clothing, etc. Each item includes “Section”, “Product Code”, and “Number of Sales”. In this case, the service surrogate server 1 collects sales data for one day that is transmitted from each store terminal 2 at the end of the business day, sums up the data by region, and sums up the product by region. Compare the sales volume as a result, extract a product with a large sales volume, use it as a hot selling product, and set the “region classification”, “product code”, and “sales volume” as the hot selling product database 4 by region. Set to -5.

  FIG. 4B is a diagram showing the configuration of the regional product-by-product database 4-6. The product-by-region database 4-6 stores and manages the number of sales of products analyzed for each region by product, and corresponds to the number of sales by product corresponding to each region, that is, “regional division”. Each item includes “product code” and “number of units sold”. In this case, the service surrogate server 1 collects sales data for one day that is transmitted from each store terminal 2 at the end of the business day, sums up the data by region, and sums up the product by region. The result “sales number” is set in the product-by-region database 4-6.

  FIG. 5 shows a sales log file 2-1 and a transaction log file 2-2 provided on each store terminal 2 side. (A) is a sales log file 2-1 and (B) is a transaction log file. It is the figure which showed the structure of 2-2. In the sales log file 2-1, each time product registration is performed, product registration history information for one record is sequentially written, and the content is transmitted to the service surrogate server 1 once a day. The data for one record constituting the sales log file 2-1 includes “sales date, time”, “store ID”, “product code”, “character (product name)”, “sales amount / number”. , “Stock” and “region ID”. “Store ID” is store identification information assigned from the service surrogate server 1 at the time of member registration. The data for one record that constitutes the transaction log file 2-2 has items of “sales date, time”, “store ID”, “transaction type”, “total sales”, and “tax”. doing.

  FIG. 6 is a block diagram showing the overall configuration of the service surrogate server 1. The CPU 101 is a central processing unit that controls the overall operation of the service surrogate server 1 in accordance with the operating system and various application software in the storage device 102. The storage device 102 stores an operating system, various application software, a database, and the like, and has a recording medium 103 configured by a magnetic, optical, semiconductor memory, and the like and a drive system thereof. The recording medium 103 is a fixed medium such as a hard disk or a portable medium such as a detachable CD-ROM, floppy disk, RAM card, or magnetic card. Further, the program and data in the recording medium 103 are loaded into the RAM (for example, static RAM) 104 under the control of the CPU 1 as necessary, and the data in the RAM 104 is saved in the recording medium 103. Furthermore, the recording medium may be provided on the side of an external device such as a server, and the CPU 101 can directly access and use the program / data in the recording medium via the transmission control unit 105.

  In addition, the CPU 101 can capture a part or all of the data stored in the recording medium 103 from another device via the transmission control unit 105, and can perform new registration or additional registration in the recording medium 103. Further, the program / data may be stored and managed on the external device side such as a server, and the CPU 101 can directly access and use the program / data on the external device side via the transmission control unit 105. . On the other hand, a transmission control unit 105, an input unit 106, a display unit 107, and a printing unit 108, which are input / output peripheral devices, are connected to the CPU 101 via a bus line, and the CPU 101 performs these operations according to an input / output program. Control.

  FIG. 7 is a block diagram showing the overall configuration of each store terminal 2. The components of the store terminal 2 are basically the same as the components of the service surrogate server 1 described above, and the CPU 201, the storage device 202, the recording medium 203, the RAM 204, the transmission control unit 205, the input unit 206, and the display unit 207. In addition to the printing unit 208, the drawer 209 is included. The input unit 206 is provided with a mode changeover switch in addition to a numeric keypad, a product-specific key, a department key, and a closing key. This mode change switch designates various modes such as “registration”, “inspection”, “settlement”, “setting”, and when “registration” mode is designated, the CPU 201 displays the input sales data. Registration is made in a sales total file for each product (not shown), and the registration contents are printed on a receipt. Then, at the end of registration of one transaction, a closing process is executed and a receipt is issued. At that time, the advertisement data is printed on the receipt. The store terminal 2 has a built-in line connection function such as a modem, but an external modem may be used.

  Next, the operation of the sales analysis agency system in this embodiment will be described with reference to the flowcharts shown in FIGS. Here, each function described in these flowcharts is stored in the recording medium 103 (203) in the form of a readable program code, and the CPU 101 (201) sequentially executes operations according to the program code. To do. Further, the CPU 101 (201) can sequentially execute the operation according to the above-described program code transmitted via the transmission medium. This also applies to other embodiments described later, and it is also possible to execute operations peculiar to this embodiment using programs / data supplied externally via a transmission medium in addition to a recording medium.

  FIG. 8 is a flowchart showing an overview of the overall operation on the store terminal 2 side. First, in the input waiting state (step A1), the store terminal 2 performs processing for analyzing the input instruction content when detecting any input (steps A2 and A4). If an input instruction for registering sales data is detected (step A2), sales data registration processing is performed according to this input instruction (step A3).

  FIG. 9 is a flowchart showing the sales data registration process. First, the ECR terminal apparatus 3 determines whether the instruction content is a sales input (step B1) or a closing input instructed at the end of registration for one transaction (step B4). Here, if it is a sales input (step B1), the sales are registered based on the input sales data for each product, and the input sales data for each product is printed out on a receipt / journal or displayed. Data registration processing is performed (step B2). Then, corresponding to the registered product, “Date”, “Time”, “Store ID”, “Product Code”, “Character”, “Price”, “Number”, “Gross Profit”, “Inventory”, “Region ID” is stored in the sales log file 2-1 (step B3). In the case of a closing input (step B4), a normal closing process is performed to print the total amount, change, etc. on the receipt paper (step B5). Then, “sales date, time”, “store ID”, “transaction type”, “total sales”, and “tax” are stored in the transaction log file 2-2 (step B6).

  On the other hand, when a transmission instruction for various log files is input in step A4 in FIG. 8, the contents of the sales log file 2-1 and the transaction log file 2-2 are called and transmitted to the service surrogate server 1 (step A5). Here, on the service surrogate server 1 side, analysis processing of sales data, which will be described later, is performed based on the contents of each log file, and the analysis result is transmitted to the requesting store terminal 2. When the store terminal 2 receives the analysis result transmitted from the service surrogate server 1 side (step A6), the store terminal 2 displays and prints it (step A7).

  FIG. 10 is a flowchart showing an overview of the overall operation on the service surrogate server 1 side. First, it is determined whether or not data is exchanged with the store terminal 2 (step C1). When data is exchanged with the store side, the sales log file 2-1 and the transaction log file 2 are sent from the store terminal 2. -2 is transmitted (step C2). When the sales log file 2-1 and the transaction log file 2-2 are transmitted from the store terminal 2, each received log file is collected and based on the contents of each store according to time zone In addition to creating a sales database 4-1, a sales database by product 4-2 by store, and a sales database 4-3 by transaction by store, the sales by region based on the sales log file 2-1 sent from the store side The contents of the corresponding region in the product database 4-4 and the region-specific product database 4-5 are updated (step C3). Then, other sales analysis processing is executed (step C4).

  FIG. 11 is a flowchart showing the other sales analysis process described above. In this case, the sales analysis processing includes the sales database 4-1 by store, the sales database 4-2 by store, the sales database 4-2 by store, the transaction database 4-3 by store, and the sales by region. This is done by referring to the product database 4-4 and the region-specific product database 4-5. The service surrogate server 1 refers to the contents of the store-specific sales database 4-1 and compares the store sales data for each time zone to determine the best-selling time zone (step) D1) The message data that prompts the user to perform the time service in the best selling time zone is created (step D2). Next, referring to the contents of the store-by-product sales database 4-2, by comparing the store-by-product sales data, 10 products that are sold are extracted as the best-selling products (step D3). Message data including “product name” and “product code” of the best-selling product is created (step D4).

  Furthermore, by referring to the contents of the store-by-product sales database 4-2 and comparing the store-by-product sales data, 10 products with poor sales are extracted as dead products (step D5). Then, referring to the contents of the regional hot selling product database 4-4, 10 hot selling products are extracted from the product group belonging to the same store category in the same region (step D6). The sales database 4-2 by store is searched based on the hot selling products extracted in this manner, and it is determined whether or not the store has already sold hot selling products (10 items) (step D7). If there is, the “product name” and “product code” of the product are temporarily stored (step D8), and the score of the product being handled is obtained (step D9).

  Next, referring to the contents of the regional best-selling product database 4-4, regardless of the same region, the best-selling product of a different industry is discriminated (step D10), and the “product name”, “product” of the product is determined. "Code" is temporarily stored (step D11). Then, the contents of the temporary storage, that is, the products that are not handled among the best-selling products belonging to the same store category in the same region, the top-selling products of different industries regardless of the same region, and the deadly products are exchanged. The message data recommending the power is created (step D12). Then, a billing procedure for billing for the sales analysis agent is performed (step D13).

  Read sales data by time, transaction, and product corresponding to the store from the sales database 4-1 by store, sales database 4-2 by store, and sales database 4-3 by transaction To the requesting store terminal 2 (step D14). And various messages created as described above, that is, a message urging that the time service should be performed during the best-selling time in the store, a message of the best-selling product in the store, and a message recommending replacement of the product The request is transmitted to the requesting store terminal 2 (step D15). Thereafter, each transmitted data is cleared (step D16).

  As described above, in this embodiment, the service surrogate server 1 collects sales data of each store transmitted from each store terminal 2 via the Internet 3, and collects the sales data of each store and one target store. Is compared with the sales data transmitted from the store terminal, and based on the compared result, it is determined whether or not the product sold at the target store is appropriate, and a message indicating the determined determination result is displayed. Since the information is transmitted to the store terminal 2 of the target store, it can be determined whether or not the product sold in the store is appropriate, and the determined determination result can be reported to the store.

  In addition, the sales analysis processing performed on the service surrogate server 1 side calculates a sales total for each aggregation type of sales data by time zone, product, etc., and generates a report that analyzes the total sales for each aggregation type. Create or give advice on sales strategy according to the analysis result, that is, find a dead product, advise the best selling product instead of this dead product, aggregate sales data by time zone, and sell In search of the time zone, you can advise the best selling time zone. In this case, when advising a hot selling product as a substitute for a dead product, it is possible to advise a hot selling product in consideration of the regional characteristics to which the store belongs. As a result, the store side can know the analysis results of other stores in the same region in addition to the sales analysis results of its own store, which can be used as effective materials for improving sales, It becomes possible to improve sales accurately.

  In the above-described embodiment, as the sales analysis processing at the store unit, the product-based aggregation, the time zone-based aggregation, and the transaction-based aggregation are performed. You may make it perform the total according to genre. That is, the content of sales analysis is arbitrary, and any kind of sales analysis may be performed. The same applies to sales analysis of other stores in the same region and sales analysis of other regions. In addition, the sales analysis may be performed by collecting sales data of the store at a time arbitrarily designated by the registered member user, not limited to the case where the sales analysis is periodically performed. That is, sales analysis may be performed according to the request of the registered member user, and the analysis result may be transmitted as a report message.

  In the embodiment described above, as a sales analysis process for each region, a hot selling product in the same-sector store or a different industry store in the region is identified and a report message is created. Among them, it is possible to identify a hot selling product in the same store category in a designated area arbitrarily designated by a registered member user and create a report message thereof. For example, in order to investigate a consumption trend of a shopping street or a busy shopping street that is in a competitive relationship, a shopping street or a busy shopping street that is in a competitive relationship may be designated and the analysis result may be obtained.

  Further, only the sales analysis arbitrarily designated by the registered member user from various sales analysis menus prepared in advance may be performed. In other words, in addition to product-based totals, time-based totals, and transaction-based totals, you may select and specify the desired sales analysis from among weekly, monthly, and period-by-unit aggregation processes, and product-genre aggregation. Good. In addition, when billing an agency fee for sales analysis to each member store, the amount charged to the store may differ depending on what kind of sales analysis the registered member user requested. . That is, a billing method according to the type of sales analysis, the number of analyzes, and the amount of data to be analyzed may be adopted.

  Further, on the service provider side, sales analysis may be executed in accordance with the purchaser's age condition, sex condition, etc. in addition to the district condition. That is, sales analysis may be performed in consideration of the purchaser's age, sex, and the like. In this case, the store side inputs the district conditions to be analyzed, the purchaser's age conditions, gender conditions, etc. from the store side to the service provider side, and the service provider side executes the sales analysis according to the input conditions. May be instructed. Furthermore, when performing sales analysis according to district conditions, purchaser's age conditions, and sex conditions, relaxation of the conditions may be instructed from the store side.

  On the other hand, the computer provided in the service surrogate server 1 collects the sales data of each store transmitted from the store terminal 2, and the collected sales data of each store and the sales data transmitted from the store terminal of one target store And a message indicating the discrimination result discriminated by the discriminating means, discriminating means for discriminating whether or not the product sold at the target store is appropriate based on the comparison result compared by the comparing means May be provided as a transmission means for transmitting the information to the store terminal 2 of the target store.

1 Service Proxy Server 2 Store Terminal 3 Internet 2-1 Sales Log File 2-2 Transaction Log File 4-1 Sales Database by Store by Time Zone 4-2 Sales Database by Product by Store 4-3 Sales Database by Transaction by Store 4 -4 Best-selling product database by region 4-5 Database by product by region 101, 201 CPU
102, 202 Storage device 103, 203 Recording medium 105, 205 Transmission control unit 106, 206 Input unit 107, 207 Display unit

Claims (8)

A sales analysis device that performs sales analysis of a predetermined store based on sales data collected from each store,
On the basis of the each commodity sales data collected from each store, an extraction means for extracting a good selling items of selling to go,
A discriminating means for comparing the hot selling product extracted by the extracting means with a product sold at the predetermined store, and discriminating a product not handled by the predetermined store among the hot selling products,
If the goods which the predetermined store does not address, and output means for outputting information of the selling goods not covered that,
A sales analysis apparatus characterized by comprising: The extraction means, from among the items at the predetermined store the same store segment, extracting the selling items,
The sales analysis apparatus according to claim 1. The extraction means extracts the hot selling product from products in a store in the same area as the predetermined store.
The sales analysis apparatus according to claim 1 or 2, characterized by the above. Based on the commodity sales data in said predetermined shops, and the second extracting means for extracting the cover in predetermined store second selling goods among goods, or the sale will go bad death muscle products,
Further comprising
Said output means further outputs said extracted by the second extracting means second sale is muscle product information or information of the dead muscle products,
The sales analysis device according to any one of claims 1 to 3, wherein It said output means outputs information urging to replace the said selling products and the dead muscle products,
The sales analysis apparatus according to claim 4, wherein: A third extracting means for extracting the third best-selling product from a store in a different business category that is not related to the same area in each of the stores;
Further comprising
The output means further outputs information on the third best-selling product extracted by the third extraction means;
The sales analysis device according to any one of claims 1 to 5, wherein Said output means outputs to the store terminal of the predetermined store,
Sales Analysis device according to any one of claims 1-6, characterized and this. A program for controlling a computer of sales analysis apparatus that performs sales analysis of a given store based on the sales data collected from each store,
The computer,
Extraction means that on the basis of the sales data of each product was collected from each store, to extract a good selling items of selling to go,
A discriminating means for comparing the hot selling product extracted by the extracting means with a product sold at the predetermined store and discriminating among the hot selling products a product not handled by the predetermined store;
Wherein if the predetermined store not covered product, output means for outputting information of the selling goods not covered that,
A computer-readable program designed to function as a computer.

Images