JP2007183815A - Merchandise sale management device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enable anyone to easily know merchandise suitable for bundle sale and its time zone. <P>SOLUTION: This merchandise sale management device is provided with a bundle sale analyzing table in which time zone-categorized mass purchase frequency data are stored so as to be associated with the identification code of each merchandise. Transaction sale data are analyzed, and the identification code of merchandise bought and sold collectively by predetermined number or more and the data at its buying and selling time are acquired. Then, bulk buying frequency data in the time zone to which the buying and selling time corresponding to the identification code of the merchandise bought and sold collectively by the predetermined number or more of the mass selling analyzing table is belonging is increased based on the acquired data. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a product sales management apparatus that collects and manages transaction sales data including identification codes and sales points of each product sold and sold in a commercial transaction.

For example, one type of discount service implemented in a retail store such as a supermarket is a collective discount service (hereinafter simply referred to as “collective sale”) that discounts when a plurality of products are purchased together. As a merchandise sales data processing system capable of executing this batch selling process, conventionally, a POS (Point Of Sales) terminal refers to a merchandise master table when registering a merchandise and whether the merchandise is a merchandise to be sold. If it is determined that the collective selling condition is satisfied by referring to the collective selling plan table with reference to the collective selling plan table, it is known that the collective selling process is performed (for example, , See Patent Document 1).
JP 2000-339548 A

  However, in the past, sales managers, such as store managers, decided which products should be targeted for bulk selling, and at what time they should be sold collectively. Relying on the experience of the actual situation was a burden on sales managers. In addition, there are cases where the sales promotion effect is insufficient due to the fact that there is no result even if the collective selling is carried out.

  The present invention has been made based on such circumstances, and the purpose of the present invention is to make it easy for anyone to know products and their time zones suitable for collective selling, and efficiently perform collective selling. Therefore, the present invention intends to provide a merchandise sales management device that can promote sales.

  The present invention is a merchandise sales management apparatus that collects and manages transaction sales data including identification codes and sales points of each product sold and sold in a commercial transaction. The sales data analysis means for storing the data, the sales data analysis means for analyzing the transaction sales data and acquiring the identification codes of the products sold and sold together by a predetermined number and the data of the trading time, and the sales data analysis means And a collective purchase processing means for increasing the collective purchase count data in the time zone to which the trade time corresponds to the identification codes of the products sold and sold in a collective manner in the collective sale analysis table based on the acquired data.

  According to the present invention in which such measures are taken, anyone can easily know a product suitable for collective selling and its time zone, and can sell the product efficiently by promoting collective selling. A management device 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 product code, sales points, sales amount, etc., which is an identification code of each product purchased by one customer, and settlement processing data with that customer, etc. Yes. The POS server 3 abbreviates the sales transaction data generated at each POS terminal 10, that is, transaction sales data including the identification code and the sales score of each product sold and sold in the commercial transaction, and the date and time when the sales transaction occurred. Collected via the communication line 9 in real time. Based on the collected sales transaction data, total sales, sales by product, 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 collective sale plan table 42, a collective sale setting table 43, a collective sale analysis table 44, 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 in correspondence with product codes that are identification codes of the products. In the data item, the product name is name data for specifying the product identified by the corresponding product code. The product category is code data that specifies a product category into which the product identified by the corresponding product code is classified. The unit price is the price per item of the product identified 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 identified 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 collective sale plan table 42 is arranged in the order of a series of plan numbers that specify the collective sale plan, the product code that is the target of the collective sale, the number of established collective sales (hereinafter referred to as “summary number”). ), A data table for storing each selling price condition data of the selling price at the time when the group selling is established (hereinafter referred to as “summary price”), the start time and the ending time of the group selling time zone. By setting the collective selling condition data in the collective selling plan table 42, the corresponding products are collectively sold.

  As shown in FIG. 6, the collective 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 collective selling analysis table 44 corresponds to a series of management numbers, the product code and product name of the product selected as a collective selling candidate in each product, the reference value, and the analysis. It is a data table which memorize | stores each value of the number of purchasers according to time slot | zone data T1-Tn, score accumulation, and an average score. In the data item, the reference value is a numerical value that is considered appropriate as a collective quantity when the products identified by the corresponding product codes are sold together. Among the information of each data item, the product code, the product name, and the reference value are 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.

  By the way, products such as milk, lunch boxes, rice balls, etc. that are sold by the expiration date, such as daily foods, canned food, drinking water, etc. It is desirable to select in advance as a collective selling 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 transaction 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 out of the analysis period, the sales transaction analysis process ends at that point.

  On the other hand, when the date of the sales transaction is within the analysis period, the CPU 31 analyzes the received sales transaction data (ST3 to ST9: sales data analysis means). That is, when single item sales data consisting of a product code, the number of sales points, and the sales amount is acquired from the sales transaction data (ST3), the collective selling analysis table 44 is searched with the product code (ST4), and the collective selling analysis table 44 is searched. It is determined whether or not the product code is set (ST5).

  Here, when the product code in the single item sales data is set in the collective selling analysis table 44, since the single item sales data is the sales data of the product selected as the collective selling candidate, the CPU 31 performs the single item sales data. The sales score is acquired from (ST6). Further, the reference value set corresponding to the product code is acquired from the collective selling analysis table 44 (ST7). Then, the sales score is compared with the reference value (ST8). As a result, if the sales score is equal to or greater than the reference value, it is determined whether the time when the sales transaction occurred corresponds to any of the analysis time zones T1 to Tn set in the collective selling setting table 43. Then, this time zone is set as a sales time zone Tx (ST9 :).

  Next, the CPU 31 increases the number-of-purchasers data of the sales time zone Tx corresponding to the product code in the collective selling analysis table 44 by “1”. In addition, the sales score of the single item sales data is added to the accumulated point data. Further, the score total data is divided by the hero count data into the term, the average score is calculated, and the average score data is updated (ST10: bulk purchase processing means).

Thereafter, the CPU 31 acquires the next single item sales data from the received sales transaction data (ST3), and repeatedly executes the above processing (ST4 to ST10).
If the product code in the single item sales data is not set in the collective selling analysis table 44 in the process of ST5, and if the sales score is less than the reference value in the process of ST8, ST3 Return to the process.

  In this way, the processing of ST3 to ST10 is sequentially executed for each piece of sales data included in the received sales transaction data, and when the analysis of the sales transaction data is completed (ST11), this processing is ended.

  The CPU 31 of the POS server 3 executes the collective selling analysis process shown in the flowchart of FIG. 9 when an execution command for the collective selling analysis process is input from the client terminal 5 connected via the communication network 4. First, the CPU 31 sets each data of the batch purchase threshold value S and the bulk sale discount rate K added to the execution command from the client terminal 5 in the RAM 33 (ST21: threshold setting means, discount). Rate setting means).

  Next, the read counter P formed in the RAM 33 is once reset to “0” (ST22), and then the read counter P is incremented by 1 (ST23). Then, the record (product code, product name, reference value, number of purchasers / cumulative score by time zone T1 to Tn and average score) of the record number P (P is the value of the reading counter) is read from the summary selling analysis table 44. (ST24).

If the record with the record number P can be read from the collective selling analysis table 44 (YES in ST25), the CPU 31 determines that the number of purchasers from the Pth record is equal to or greater than the threshold value S. Presence / absence is determined (ST26: collective selling time zone detecting means). As a result, when even one corresponding time zone Ts exists (YES in ST27), the CPU 31 searches the product master table 41 with the product code of the Pth record and acquires unit price data. Further, the reference value is acquired from the Pth record as the number of successful sales (ST28). Thereafter, a collective price, which is a discounted sales price when the products specified by the product code of the P-th record are purchased together as a group, is calculated (ST29: collective price calculation means).
Summary price = (unit price x number of units sold together) x (1-discount rate K) (1)
Then, for each time zone Ts in which the number of purchasers is equal to or greater than the threshold value S, the CPU 31 stores the product code of the Pth record, the number of items sold together (reference value), the calculated summary price, and the corresponding time zone Ts. A summary plan record is generated based on the start time and end time, and is added to the summary plan table 42 (ST30: summary sale plan setting means).

  When 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 processes in ST28 to ST30.

  Thereafter, the reading counter P is further incremented by 1 (ST23). If the record with the record number P can be read from the collective 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 collective selling analysis table 44. If the record with the record number P cannot be read from the collective selling analysis table 44 (NO in ST25), the CPU 31 transmits the data of the collective selling analysis table 44 and the collective planning table 42 to the communication network 4. Is transmitted to the client terminal 5 (ST31), and the collective selling analysis process is terminated.

  Incidentally, in the client terminal 5, the data of the collective selling analysis table 44 and the data of the collective planning table 42 received from the POS server 3 can be printed or displayed respectively.

  Further, the CPU 31 of the POS server 3 executes a collective selling determination process shown in the flowchart of FIG. 10 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 counted by the clock unit 35 (ST41), the CPU 31 searches the collective selling plan table 42 (ST42). Then, it is determined whether or not there is a collective selling plan record whose start time coincides with the current time (ST43). As a result, when a collective selling plan record whose start time coincides with the current time is detected, since the record is a record in which the collective selling condition data of the product to be sold collectively is set from the current time, the CPU 31 The collective selling display information to be displayed on the display unit of the electronic shelf label device 6 corresponding to the product identified by the product code of the record is edited (ST44). Then, this collective selling display information is transmitted to the shelf label management server 2 via the network controller 37 (ST45). If a plurality of group sales plan records whose start times coincide with the current time are detected, the processes of ST44 and ST45 are executed for each record.

  Incidentally, the collective sale display information includes a product code, a collective quantity, and a collective price. In addition, the total discount amount calculated by subtracting the summary price from the price obtained by multiplying the unit price of the product by the summary number, or per one piece calculated by dividing the total discount amount by the summary number It may include at least one of a price and a discount amount per unit calculated by subtracting the price per unit from the unit price of the product.

  The shelf label management server 2 that has received the collective selling display information, as shown in FIG. 11, with respect to the electronic shelf label device 6 in which the product name, price, etc. of the product identified by the product code are displayed. Collective selling display information such as the collective quantity and the collective price is displayed. The electronic shelf label apparatus 6 shown in the figure includes a message display unit 63 in addition to the price display unit 61 and the product name display unit 62. The message display unit 63 includes a summary number edited as summary sale display information, The summary price (total price), total discount amount, price per piece, and discount amount per piece are displayed.

  Next, the CPU 31 determines whether or not there is a collective sales plan record whose end time matches the current time (ST46). As a result, if a collective selling plan record whose end time coincides with the current time is detected, the record is a record in which the collective selling condition data of a product that is excluded from the collective selling target at the current time is set. A command for instructing the electronic shelf label device 6 corresponding to the product identified by the product code of the record to clear the collective selling display information is transmitted to the shelf label management server 2 via the network controller 37 (ST47). . When a plurality of group sales plan records whose end times coincide with the current time are detected, the processing of ST47 is executed for each record. Thus, the current collective selling determination process is completed.

  In the shelf label management server 2 that has received the command for clearing the collective selling display information, the collective selling 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, when it is within the preset analysis period, the collective selling analysis table 44 is used for each product selected as a collective selling candidate. The number of business transactions (number of purchasers) that have been successful in purchasing a number of items greater than or equal to the value is tabulated. In addition, the total number of points purchased together (the total number of points) is calculated. Further, by dividing the total number of points by the number of purchasers, the average number of bulk purchases for each product is calculated and stored on the bulk selling analysis table 44.

  Therefore, the sales manager such as the store manager operates the client terminal 5 in the first opening operation after the end date of the analysis period, for example, and inputs an arbitrary collective purchase count threshold value S and collective sale discount rate K, An execution command for the collective selling analysis process is sent to the POS server 3. Thereby, in the POS server 3, the data of the collective selling 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 product selected as a collective selling candidate.

  Here, for a product 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 collective selling. In addition, the number of units sold together and the group price discounted at the discount rate K are automatically determined. These collective selling condition data are set in the collective selling plan table 42. As a result, the corresponding product is processed as a batch sale product during the time period Ts.

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

  As described above, according to the present embodiment, anyone can easily know a product suitable for collective selling and its time zone. Therefore, the burden on the store manager can be reduced. Moreover, since the collective selling is efficiently performed so as to accompany the sales results, there is 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 transaction analysis processing is not limited to the reception of sales transaction data. For example, each sales transaction data received from each POS terminal 10 is temporarily stored in a buffer on the RAM 33, for example, every business day. Sales transaction analysis processing may be executed by sequentially reading sales transaction data from the buffer after closing.

  In the above-described embodiment, the reference value is set for each item of the group selling candidate in the group selling analysis table 44. However, the reference value may be a constant value common to each item. In the above-described embodiment, the reference value is set as the collective selling condition data which is the collective selling condition data of the products having the time zone in which the number of purchasers is equal to or greater than the threshold value S. The average score in the time zone is summarized. It is good also as a sale establishment number. In addition, this average score may be set in the sales analysis table 44 as a next reference value.

  In the above-described embodiment, when the client terminal 5 is operated to send the execution command for the stop selling analysis process to the POS server 3, the threshold S for the number of batch purchases and the discount rate K for the bulk sale are respectively set to the client terminal. In this example, the threshold value S and the discount rate K may be set in the HDD device 34 of the POS terminal 3 in advance. In this way, for example, in the first store opening operation after the end date of the analysis period, it is possible to automatically configure the collective selling analysis process.

  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 collective sale plan table in FIG. The schematic diagram which shows the data structure of the collective selling setting table in FIG. The schematic diagram which shows the data structure of the collective selling analysis table in FIG. The flowchart which shows the principal part procedure of the sales transaction analysis process which CPU of the POS server performs. The flowchart which shows the principal part procedure of the collective selling analysis process which CPU of the same POS server performs. The flowchart which shows the principal part procedure of the collective selling 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 ... collective sale planning table, 43 ... collective sale setting table, 44 ... Summary sale analysis table.

Claims (4)

In a product sales management device that collects and manages transaction sales data including identification codes and sales points of each product sold and sold in commercial transactions,
A collective selling analysis table that stores the number of times of collective purchases for each time zone corresponding to each product identification code,
Sales data analysis means for analyzing the transaction sales data and acquiring the identification code of the goods sold and sold together by a predetermined number and the data of the trading time;
Bulk purchase processing for increasing the number of times of bulk purchases in the time zone to which the trading time belongs to the identification code of the products sold and sold together in the batch sales analysis table based on the data acquired by the sales data analysis means Means,
A product sales management device comprising: A threshold setting means for setting a threshold for the number of purchases;
The collective selling analysis table is searched, and the collective selling time zone detecting means for detecting a time zone in which the collective purchase count data is greater than or equal to the threshold set by the threshold setting means for each product,
The product sales management apparatus according to claim 1, further comprising: A discount rate setting means for setting a discount rate for mass selling;
Based on the unit price of the product for which the time period for which the collective purchase count data is greater than or equal to the threshold value by the collective selling time zone detecting means, the number of items for which collective sales have been established, and the discount rate set by the discount rate setting means, A summary price calculation means for calculating a discounted selling price when the batch sale is made in batches;
The product sales management apparatus according to claim 2, further comprising: A collective selling plan table for storing each item of the identification code of the collectable sale target product, the number of established collectable sales, the selling price when the collective sale is established, and the collective selling time zone;
The identification code of the product in which the time period when the collective purchase frequency data is greater than or equal to the threshold value is detected by the collective selling time zone detecting means, the number of collective sale establishment, the discount sales price calculated by the collective price calculating means, and the collective purchase Collective selling plan setting means for setting each data in a time zone in which the number of times data is equal to or greater than a threshold value in the batch selling plan table;
The product sales management device according to claim 3, further comprising:

Images