JP2007188253A - Commodity sales management apparatus - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enable everybody to easily know commodities suitable for combination sales and its time band. <P>SOLUTION: A combination sales analysis table for storing combination purchase frequency data in each time band correspondingly to the combination of respective identification codes of a plurality of different commodities is prepared. By analyzing transaction sales data, whether each of the plurality of commodities specified by respective identification codes which are combined and stored in the combination sales analysis table is a purchased transaction or not is determined. When the transaction is determined to be the one that all of the plurality of commodities specified by respective identification codes are purchased, the combination purchase frequency data at the execution time of the transactions concerned out of the combination purchase frequency data of each time band which are stored in the combination sales analysis table are increased in accordance with the combination of respective identification codes. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a merchandise sales management apparatus that collects and manages transaction sales data including identification codes of all merchandise sold and sold in commercial transactions.

For example, one type of discount service performed at a retail store such as a supermarket is a service (hereinafter, simply referred to as “combination sale”) in which a discount is offered when a plurality of different types of products are purchased in combination. Then, as a product sales data processing system capable of executing this combination selling process, conventionally, when a POS (Point Of Sales) terminal registers a product, it is determined whether the product is a target product for combination selling, It has been known that a combination selling process is performed when it is determined that a combination selling condition is satisfied with reference to a combination selling plan table and a combination selling target product (see, for example, Patent Document 1). .
JP-A-06-195664

  However, in the past, it was determined by the sales manager such as the store manager what products should be combined with which products, and at what time the combination sales should be performed. Relying on experience was the reality, and it was a burden on sales managers. For this reason, even if combination selling is carried out, there are cases where the sales promotion effect is insufficient due to lack of results.

  The present invention has been made based on such circumstances. The purpose of the present invention is to make it easy for anyone to know the combination of products suitable for combination selling and the time zone, and to efficiently perform combination selling. An object of the present invention is to provide a merchandise sales management apparatus capable of promoting sales.

  The present invention relates to a product sales management apparatus that collects and manages transaction sales data including identification codes of all products sold and sold in a commercial transaction, and the number of combined purchases by time zone corresponding to each combination of identification codes of different products. A combination sale analysis table for storing data, and whether or not each of the plurality of products identified by each identification code stored in the combination sale analysis table by analyzing the transaction sales data has been purchased. When it is determined that the sales data analyzing means to be determined and a plurality of products respectively identified by the respective identification codes combined and stored in the combined selling analysis table by the sales data analyzing means are purchased commercial transactions. The combination purchase count data for each time zone stored in the combination selling analysis table corresponding to the combination of each identification code. Is obtained by a combination purchase processing means for increasing the combined number of purchases data time at which the transaction has been performed.

  According to the present invention in which such measures are taken, merchandise sales management that enables anyone to easily know the combination of products suitable for combination selling and the time period thereof, and to promote sales by efficiently performing combination selling. Equipment can be provided.

The best mode for carrying out the present invention will be described below with reference to the drawings.
In this embodiment, the POS server 3 of the store system shown in FIG. 1 is provided with a function as the product sales management apparatus of the present invention.

  The store system shown in FIG. 1 includes a network server 1, a shelf label management server 2, and a POS server 3. The servers 1, 2, and 3 are connected by a communication network 4 such as a LAN (Local Area Network). A client terminal 5 such as a personal computer is connected to the communication network 4. The client terminal 5 is mainly operated by, for example, a sales manager such as a store manager in order to perform store management using data managed by the servers 1, 2, and 3.

  The network server 1 is a computer specialized for data communication with an external system such as a head office system connected by a dedicated line or a public line.

  The shelf label management server 2 is a computer specialized for information management of a plurality of electronic shelf label devices 6 provided in correspondence with each product displayed on the display shelf. The shelf label management server 2 and each electronic shelf label device 6 are connected via a wired or wireless communication line 7. The shelf label management server 2 is provided with a shelf label information file 8. In the shelf label information file 8, corresponding to the shelf label ID for identifying each electronic shelf label device 6, the product name, price, etc. displayed on the display unit of the electronic shelf label device 6 identified by the shelf label ID Product shelf label information is stored. Therefore, the shelf label management server 2 controls information displayed on the display unit of each electronic shelf label device 6 based on the information stored in the shelf label information file 8.

  The POS server 3 is a computer that plays a central role in the POS system, and connects a plurality of POS terminals 10 via a communication line 9. Each POS terminal 10 is an aspect of a merchandise sales data processing apparatus, and registers sales data of merchandise purchased by customers. In addition, the transaction with the customer is settled based on the input price payment data. And, it has a function to generate sales transaction data consisting of single item sales data consisting of the product code, product classification, number of sales points, sales amount, etc. of each product purchased by one customer and settlement processing data with that customer. . The POS server 3 is a transaction sales data including sales transaction data generated by each POS terminal 10, that is, a product code, a product category and a sales score of each product bought and sold in a commercial transaction, and a date and time when the sales transaction was performed. Data is collected via the communication line 9 in substantially real time. Based on the collected sales transaction data, total sales, sales by product code, sales by product category, and the like are managed. Here, the POS server 3 functions as an aspect of the merchandise sales management apparatus according to the present invention.

  FIG. 2 is a block diagram showing a main configuration of the POS server 3. The POS server 3 includes a CPU (Central Processing Unit) 31 that performs information processing and arithmetic processing, a ROM (Read Only Memory) 32 that stores in advance fixed data such as a program for controlling the processing of the CPU 31, an information processing and arithmetic operation. RAM (Random Access Memory) 33 for storing data generated by processing, HDD (Hard Disk Drive) device 34 for storing a large amount of data such as various data tables, clock unit 35 for measuring the current date and time, each POS A POS interface 36 for communicating with the terminal 10, a network controller 37 for communicating with other servers 1, 2 and the client terminal 5 connected via the communication line 4, and the like. The CPU 31, ROM 32, RAM 33, HDD device 34, clock unit 35, POS interface 36, and network controller 37 are connected by a bus line 38 such as an address bus or a data bus.

  As shown in FIG. 3 in particular, the HDD device 34 stores a product master table 41, a combination sale plan table 42, a combination sale setting table 43, a combination sale analysis table 44, a sales analysis table 45, and the like.

  As shown in FIG. 4, the product master table 41 is a data table that stores data such as product names, product categories, unit prices, and shelf label IDs corresponding to product codes that are codes unique to each product. In the data item, the product name is product name data specified by the corresponding product code. The product category is code data that identifies a product category into which the product specified by the corresponding product code is classified. The unit price is a price per item of the product specified by the corresponding product code. The shelf label ID is an ID code for identifying the electronic shelf label device 6 provided on the display shelf on which the product specified by the corresponding product code is displayed. Information of each data item is set in advance by downloading from a head office system or the like connected via the network server 1. Moreover, it can change suitably by the operation input of the client terminal 5. FIG.

  As shown in FIG. 5, the combination sale plan table 42 is a combination of a plurality of types of product categories (in this embodiment, two types) in order of a series of plan numbers for specifying a combination sale plan (product category 1, 1). Commodity category 2), combination sale discounts established when a plurality of products belonging to each of these multiple types of product categories are purchased at the same time, and combination sale condition data for the start time and end time of the combination sale time zone This is a data table to be stored. By setting combination selling condition data in the combined selling plan table 42, a plurality of corresponding types of products are combined and sold.

  As shown in FIG. 6, the combination selling setting table 43 stores analysis period data composed of start date and end date and analysis time zone data T1 to Tn composed of a plurality of different start times and end times. This is a data table. Information of each data item is set in advance by downloading from a head office system or the like connected via the network server 1. Moreover, it can change suitably by the operation input of the client terminal 5. FIG.

  As shown in FIG. 7, the combination sale analysis table 44 is a combination of a plurality of types (two types in the present embodiment) of product categories (product category 1) selected as a combination sale candidate corresponding to a series of management numbers. , Product category 2), a discount for a commercial transaction in which the combination of product categories is established, and the number of purchasers by the analysis time zone data T1 to Tn. Among the information of each data item, the combination of product categories and the discount amount are set in advance by downloading from a headquarters system or the like connected via the network server 1. Moreover, it can change suitably by the operation input of the client terminal 5. FIG.

  As shown in FIG. 8, the sales analysis table 45 is a data table that counts purchase point data for every product category selected as a combination sale candidate.

  Therefore, every time the CPU 31 of the POS server 3 receives the sales transaction data generated by each POS terminal 10 via the POS interface 36, the CPU 31 executes the sales analysis process of the procedure shown in the flowchart of FIG. That is, the CPU 31 obtains the date and time when there was a sales transaction for the product from the received sales transaction data (ST1). Then, it is determined whether or not the date is within the analysis period set in the collective selling setting table 43 (ST2). Here, if the date of the sales transaction is outside the analysis period, the sales analysis process is terminated at that time.

  On the other hand, when the date of the sales transaction is within the analysis period, the CPU 31 initializes the sales analysis table 45 and sets the purchase point data corresponding to each product category to “0” ( ST3) Analyzing the received sales transaction data according to the procedures shown in ST4 to ST14 below, and purchasing all of the plurality of products respectively identified by the product categories stored in combination sales analysis table 44 It is determined whether or not the transaction has been made (sales data analysis means).

  That is, the CPU 31 acquires single item sales data including a product code, a product category, a sales score, a sales amount, and the like from the received sales transaction data (ST4). Next, the sales analysis table 45 is searched by the product category in the single item sales data (ST5). Then, it is determined whether or not the product category is set in the sales analysis table 45 (YES in ST6). Here, if the product category is set in the sales analysis table 45, the product category is set. The sales points in the single item sales data are added to the corresponding purchase point data (ST7). If not set, the process of ST7 is not executed.

  Thereafter, the CPU 31 determines whether or not the next single item sales data exists in the received sales transaction data (ST8). And when it is judged that it exists, each process of said ST3-ST7 is performed again.

  In this way, each time the CPU 31 acquires single item sales data from the received sales transaction data, only when the product category in the data is set in the sales analysis table 45, the CPU 31 stores the purchase score data corresponding to the product category. The process of adding the sales points in the single item sales data is repeatedly executed. If it is confirmed that the next single item sales data does not exist in the received sales transaction data, the CPU 31 proceeds to the processing after ST9.

  That is, the CPU 31 once resets the read counter P formed in the RAM 33 to “0” (ST9), and then increments the read counter P by “1” (ST10). Then, the record (product category 1, product category 2, discount amount, number of purchasers by time period T1 to Tn) of the record number P (P is the value of the reading counter) is read from the combination selling analysis table 44 (ST11).

  Here, if the record with the record number P can be read from the combination selling analysis table 44 (YES in ST12), the CPU 31 searches the sales analysis table 45 to find the product category 1 and the product of the Pth record. It is determined whether or not the purchase point data corresponding to each category 2 is “1” or more (ST13). If at least one of the purchase points data is “0”, the process returns to ST10.

  On the other hand, when the purchase point data corresponding to each of the product category 1 and the product category 2 is “1” or more (YES in ST14), the products belonging to the product category 1 and the products belonging to the product category 2 Since both are commercial transactions that have been purchased, the CPU 31 determines which of the analysis time zones T1 to Tn set in the combined selling setting table 43 corresponds to the transaction time acquired in the processing of ST1. Then, this time zone is set as a sales time zone Tx (ST15). Next, the CPU 31 increases the number-of-purchasers data of the corresponding sales time zone Tx in the P-th record of the combination sale analysis table 44 by “1” (ST16: combination purchase processing means). Thereafter, the CPU 31 returns to the process of ST10.

  That is, the CPU 31 sequentially reads records from the combination selling analysis table 44, and when the purchase point data corresponding to the product category 1 and the product category 2 of the record are both “1” or more, The process of increasing the number of purchasers in the corresponding sales time zone Tx in the record by “1” is repeatedly executed. When the upper air processing is executed for all the records set in the combination selling analysis table 44, the CPU 31 ends the sales analysis processing.

  Further, when the execution command for the combination selling analysis process is input from the client terminal 5 connected via the communication network 4, the CPU 31 of the POS server 3 executes the combination selling analysis process shown in the flowchart of FIG. First, the CPU 31 sets the threshold value S of the number of purchasers added to the execution command from the client terminal 5 in the RAM 33 (ST21: threshold setting means).

  Next, after the read counter P is once reset to “0” (ST22), the read counter P is incremented by 1 (ST23). Then, the record (product category 1, product category 2, discount amount, number of purchasers by time period T1 to Tn) of the record number P (P is the value of the reading counter) is read from the combination selling analysis table 44 (ST24).

  Here, if the record with the record number P can be read from the combination selling analysis table 44 (YES in ST25), the CPU 31 determines that the number of purchasers from the Pth record is in the time zone Ts greater than or equal to the threshold value S. Presence / absence is determined (ST26: combination selling time zone detecting means). As a result, if there is even one corresponding time zone Ts (YES in ST27), the CPU 31 determines the product category 1 and product category 2, the discount amount, and the start time of the relevant time zone Ts of the Pth record. The combination sale plan record is generated based on the end time and added to the combination sale plan table 42 (ST28: combination sale plan setting means).

  If there is no time zone Ts in which the number of purchasers is equal to or greater than the threshold value S in the Pth record (NO in ST27), the CPU 31 does not execute the process in ST28.

  Thereafter, the reading counter P is further incremented by 1 (ST23). If the record with the record number P can be read from the combination selling analysis table 44, the processing after ST26 is executed again.

  In this way, the processing after ST26 is repeatedly executed for all the records set in the combination selling analysis table 44. If the record with the record number P cannot be read from the combination selling analysis table 44 (NO in ST25), the CPU 31 sends the data of the combination selling analysis table 44 to the client terminal 5 via the communication network 4. The transmission is output (ST31).

  Next, the CPU 31 searches the combination sale plan table 42 to determine whether or not there are a plurality of combination sale plan records including the same product category in the same time zone (ST30). If it exists (YES in ST31), the record with the largest discount is left and the other records are deleted from the combination sale plan table 42 (ST32). Thereafter, if the CPU 31 transmits and outputs the data of the combination sale plan table 42 to the client terminal 5 via the communication network 4 (ST33), the combination sale analysis process is terminated.

  Incidentally, the client terminal 5 can print or display the data of the combination sale analysis table 44 and the data of the combination sale plan table 42 received from the POS server 3, respectively.

  Further, the CPU 31 of the POS server 3 executes the combination selling determination process shown in the flowchart of FIG. 11 every time a timer interrupt signal given from the clock unit 35 is input at intervals of 1 minute, for example. That is, if the CPU 31 obtains the current time measured by the clock unit 35 (ST41), the CPU 31 searches the combination selling plan table 42 (ST42). Then, the presence / absence of a combination sale plan record whose start time coincides with the current time is determined (ST43). As a result, when a combination sale plan record whose start time coincides with the current time is detected, since the record is a record in which a combination of product categories to be sold for combination is set from the current time, the CPU 31 The combination sale display information to be displayed on the display unit of the electronic shelf label device 6 corresponding to the products belonging to the product category 1 and the product category 2 is edited (ST44). Then, this combination sale display information is transmitted to the shelf label management server 2 via the network controller 37 (ST45). When a plurality of combination selling plan records whose start times coincide with the current time are detected, the processes of ST44 and ST45 are executed for each record.

  The shelf label management server 2 that has received the combination sale display information, as shown in FIG. 12, with respect to the electronic shelf label device 6 on which the product name, price, etc. of the product identified by the product code are displayed. Combination sale display information indicating a product category, a discount amount, and the like to be combined is displayed. The electronic shelf label apparatus 6 shown in the figure includes a product category display unit 63 and a message display unit 64 in addition to the price display unit 61 and the product name display unit 62, and the product category display unit 63 belongs to the product category display unit 63. The product category (A category in the figure) is displayed. Further, the message display section 64 displays information on other product categories (C category in the figure) for which the combination sale with the product category A is established and the discount (50 yen in the figure).

  Next, the CPU 31 determines whether there is a combination sale plan record whose end time coincides with the current time (ST46). As a result, when a combination sale plan record whose end time coincides with the current time is detected, the record is a record in which combination sale condition data that is excluded from the combination sale target at the current time is set. A command for instructing the electronic shelf label device 6 corresponding to the products belonging to the product category 1 and the product category 2 to clear the combination sale display information is transmitted to the shelf label management server 2 via the network controller 37 (ST47). ). When a plurality of combination sale plan records whose end times coincide with the current time are detected, the process of ST47 is executed for each record. Thus, the current combination selling determination process is completed.

  Incidentally, in the shelf label management server 2 that has received the command to clear the combination sale display information, the combination sale display information displayed on the corresponding electronic shelf label device 6 is deleted.

  In the POS server 3 according to the present embodiment that performs such information processing, within the preset analysis period, the combination sale analysis table 44 is used to select a plurality of product categories selected as combination sale candidates. The number of commercial transactions (the number of purchasers) in which all the products belonging to each item are purchased is tabulated for each combination of product categories.

  Therefore, a sales manager such as a store manager, for example, operates the client terminal 5 in the first opening operation after the end date of the analysis period, inputs an arbitrary combination purchase count threshold value S, and executes the combination selling analysis process. The command is sent to the POS server 3. Thereby, in the POS server 3, the data of the combination sale analysis table 44 totaled within the analysis period is analyzed. Then, a time zone Ts in which the number of purchasers is equal to or greater than the threshold value S is searched for each combination of product categories selected as a combination sale candidate.

  Here, for a combination of product categories having a time zone Ts in which the number of purchasers is equal to or greater than the threshold value S, the time zone Ts is automatically determined as a time zone for combination selling. Then, these product categories, the discounts set in advance corresponding thereto, and the start time and end time of the time zone Ts are set in the collective selling plan table 42. However, when the same product category is subject to combination sale in the same time zone, only the data with the largest discount amount is set in the collective sales plan table 42. Thereby, the combination of the product categories set in the collective selling plan table 42 is processed as a combination sale during the time period Ts.

  For example, during the analysis period, the time zone in which the number of commercial transactions purchased by combining the product belonging to the product category 100 and the product belonging to the product category 200 is greater than the threshold value S is T2, and similarly, the product category 100 It is assumed that the time zone in which the number of commercial transactions purchased by combining the product belonging to the product category and the product belonging to the product category 300 is greater than the threshold value S is also T2. In this case, if the discount amount corresponding to the combination of the product category 100 and the product category 200 is 30 yen, and the discount amount corresponding to the combination of the product category 100 and the product category 300 is 50 yen, the time zone T2 , A 50 yen discount is given to a shopper who purchases a combination of a product belonging to the product category 100 and a product belonging to the product category 300.

  Further, the sales manager operates the client terminal 5 to send an execution command for the combined selling analysis process to the POS terminal 10, whereby the latest data in the combined selling analysis table 44 and the latest data in the combined selling plan table 42 are updated. 5 can be printed or displayed. Therefore, the sales manager can grasp the contents of the combination sale to be executed in the future based on the latest data of the combination sale plan table 42. In addition, the latest data in the combination selling analysis table 44 makes it possible to grasp a time zone suitable for combination selling for each combination of product categories selected as a combination selling candidate.

  As described above, according to the present embodiment, anyone can easily know the combination of product categories suitable for performing combination selling and the time zone. Therefore, the burden on the store manager can be reduced. In addition, since combination sales are performed efficiently so that sales results accompany sales, there is also an effect that sales can be promoted.

  The present invention is not limited to the above-described embodiment as it is, and can be embodied by modifying the constituent elements without departing from the scope of the invention in the implementation stage.

  For example, the execution of sales analysis processing is not limited to when sales transaction data is received. For example, each sales transaction data received from each POS terminal 10 may be temporarily stored in a buffer on the RAM 33. For example, after closing every business day, sales transaction data may be sequentially read from the buffer and a sales analysis process may be executed. .

  In the above embodiment, the discount amount is set for each combination of product categories that are combination sale candidates in the combination sale analysis table 44. However, the discount amount is a constant value common to the combination of each product category. May be. Further, the number of combinations of product categories is not limited to two types, and may be a combination of three or more types.

  In the above embodiment, when the same product category is subject to combination selling in the same time zone, only the data with the largest discount is set in the collective selling plan table 42. May be set in the collective sales plan table 42 so that the same product category is sold in combination in different combinations in the same time zone.

  In the above-described embodiment, when the client terminal 5 is operated to send the combination sale analysis process execution command to the POS server 3, the threshold value S of the number of combination purchases is input from the client terminal 5. The threshold value S may be set in advance in the HDD device 34 of the POS terminal 10 or the like. In this way, for example, in the first store opening business after the end date of the analysis period, it is possible to configure so that the combination selling analysis process is automatically executed.

  Moreover, in the said embodiment, although the identification code of each product was made into the product classification, the product code peculiar to each product is good also as an identification code of each product. By doing so, it becomes possible to deal not only with the combination sale of products belonging to a plurality of product categories but also with the combination sale of single products.

  In addition, various inventions can be formed by appropriately combining a plurality of constituent elements disclosed in the embodiment. For example, some components may be deleted from all the components shown in the embodiment. Furthermore, the constituent elements over different embodiments may be combined.

1 is a schematic diagram of a store system according to an embodiment of the present invention. The block diagram which shows the principal part structure of the POS server which comprises the shop system. The schematic diagram which shows the main data tables which the POS server has. The schematic diagram which shows the data structure of the goods master table in FIG. The schematic diagram which shows the data structure of the combination sale plan table in FIG. The schematic diagram which shows the data structure of the combination sale setting table in FIG. The schematic diagram which shows the data structure of the combination sale analysis table in FIG. The schematic diagram which shows the data structure of the sales analysis table in FIG. The flowchart which shows the principal part procedure of the sales analysis process which CPU of the same POS server performs. The flowchart which shows the principal part procedure of the combination selling analysis process which CPU of the same POS server performs. The flowchart which shows the principal part procedure of the combination sale determination process which CPU of the same POS server performs. The top view which shows the example of a display of the electronic shelf label apparatus in the embodiment.

Explanation of symbols

    2 ... shelf label management server, 3 ... POS server, 6 ... electronic shelf label device, 10 ... POS terminal, 31 ... CPU, 41 ... merchandise master table, 42 ... combination sale planning table, 43 ... combination sale setting table, 44 ... Combination sales analysis table, 45 ... sales analysis table.

Claims (3)

In a product sales management device that collects and manages transaction sales data including identification codes of all products sold and sold in commercial transactions,
A combination sale analysis table that stores combination purchase count data for each time zone corresponding to combinations of different identification codes of a plurality of different products;
Sales data analysis means for analyzing the transaction sales data and determining whether or not each of the plurality of products identified by each identification code stored in combination with the combined sales analysis table is a purchased commercial transaction;
When it is determined by the sales data analysis means that a plurality of products respectively identified by the identification codes stored in combination with the combined selling analysis table are all purchased commercial transactions, a combination of these identification codes A combination purchase processing means for increasing the combination purchase count data at the time when the commercial transaction is performed among the combination purchase count data classified by time period stored in the combination sale analysis table in correspondence with
A product sales management device comprising: A threshold value setting means for setting a threshold value of the combined purchase frequency data;
A combination selling time for searching the combination selling analysis table and detecting a time zone in which the combination purchase count data is equal to or greater than the threshold set by the threshold setting means for each combination of the identification codes of the different products. Belt detection means;
The product sales management apparatus according to claim 1, further comprising: A combination selling plan table for storing each data of identification code of combination selling target product and combination selling time zone;
When the combination selling time zone detecting means detects a combination of each identification code of the plurality of different products having a time zone where the combined purchase frequency data is equal to or greater than a threshold, the identification code and the combination purchase frequency data are equal to or greater than the threshold A combination sale plan setting means for setting the paired time zone in the combination sale plan table,
The product sales management apparatus according to claim 2, further comprising:

Images