JPH0737164A - Commodity sales data processor - Google Patents

Abstract

PURPOSE:To surely and automatically provide hit commodity information of an pertinent customer class by generating a hit commodity list classified by customer class and outputting the hit commodity list of the customer class designated at the time of registering a commodity to the customer concerned. CONSTITUTION:A hit commodity adjustment job is executed after closing a store every day so that the hit commodities in order of good sale from the first to the 20th for every customer class in a latest fixed period which is normally designated by designation period data D are decided and the hit commodity lists by customer class are respectively stored in the hit commodity lidt table 45 of a same job class. In the meantime, a cashier judges the customer class by the sex and estimated age of the customer whenever the customer completes registering the purchased commodity while the store is open and operates a concerned customer class key. Then, data being best data from the first to the n-th which are set in a best data area 46 is picked-up from the hit commodity list table 45 of the desingation-inputted customer class and printed on a receipt which is issued to the customer as the hit commodity list.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a commodity sales data processing device having a receipt issuing function such as an electronic cash register and a POS (point of sale information management) terminal.

[0002]

2. Description of the Related Art Recently, at stores such as convenience stores and supermarkets, customers are classified according to sex, age, occupation, etc., and sales and selling products, so-called hit products, are examined by customer class, and these data are used to develop new products. In many cases, it is useful for business such as product ordering.

Therefore, conventionally, as a merchandise sales data processing device such as an electronic cash register or a POS terminal suitable for managing such a customer class, a customer class key is provided on a keyboard, and the customer class is designated and input by the customer class key at the time of registration of a product for sale. Then, in some cases, the registered merchandise sales data is aggregated in the storage unit for each customer segment.

Since the product sales data collected by the customer group in the storage unit can be output as a report by settlement or inspection work, the sales and hit products by customer group can be easily grasped from the contents of the report, which is convenient.

[0005]

By the way, among the stores that manage customers, by providing each customer with information on hit products by customer class, the customer's willingness to purchase is increased and sales are promoted. There is a store trying to figure out. In such stores, the information on hit products by customer segment obtained by the report is printed on the advertising scatter and distributed to customers, and it is posted in the store. I was informed of the information.

However, in the method as described above, 1
Since information on hit products of all customer groups will be provided to other customers, the amount of information must be enormous, and customers must pick up hit products that match themselves from the enormous amount of information. Therefore, it cannot be said that the information that is meaningful to the customer is certainly provided.

[0007] Further, since it takes time and labor for the shop side to create a distribution for advertisement from the contents of the report, it is an inefficient means of sales promotion.

Therefore, the present invention can reliably and automatically provide the hit product information of the corresponding customer segment to each customer, and can efficiently increase the customer's willingness to purchase and promote the sales. It is intended to provide a product sales data processing device.

[0009]

According to the present invention, when a product purchased by one customer is registered by the product registration unit, the sales data of the registered product is totaled in the storage unit, and subsequently registered by the registration closing unit. When the end is declared, in the product sales data processing device that issues a receipt that prints the sales data of the product purchased by the customer and the total data, the data that is the index of the hit product within a certain period according to the customer class Customer-classified data totaling means for each customer, hit product list creating means for creating a hit product list for each customer group based on the hit product index tabulated data obtained for each customer class by this totaling means, and registration of purchased products by the product registration means The customer class designating means for designating and inputting the customer class of the customer who has been performed and the hit product list of the customer class designated by this customer class designating means Is that a hit list output means that.

[0010]

According to the present invention having such a configuration, the data for indexing hit products within a certain period for each customer is collected for each product by the customer layer data collecting means. In addition, the hit product list creating means creates a hit product list for each customer group from the hit product index aggregate data for each customer group.

When the commodity registration means registers the commodity purchased by one customer and the customer demographic designation means designates and inputs the customer demographic of the customer, the hit commodity list of the designated customer demographic is output by the output means. Output by.

Therefore, the customer can easily know from the output hit product list what the hit product is popular with his / her customer base.

[0013]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment in which the present invention is applied to a single electronic cash register will be described below with reference to the drawings. In this embodiment, the amount of sales of each product is used as the index data of the hit product.

FIG. 1 is a perspective view showing the external appearance of an electronic cash register according to this embodiment. This electronic cash register is provided with a keyboard 2 and an operator display 3 on the front of a main body 1, and a customer display 4 on the back of the main body 1. Further, a drawer 5 is provided on the lower side of the main body 1, and a change fund, a deposit from a customer, etc. are accommodated in the drawer 5.

Further, this electronic cash register is
A printer (not shown) for printing data on receipt paper and journal paper is built in. The receipt paper on which data is printed by this printer is issued from the receipt issuing port 6 formed on the front surface of the main body, and the journal paper is wound inside.

Further, in this electronic cash register, a hand scanner 7 for optically reading a bar code is connected via a signal cable 8. A product code set in advance for each product is printed and attached to each product, and the product to be sold can be registered by reading the bar code with the hand scanner 7.

The keyboard 2 includes a preset keyboard 2a provided with a plurality of preset keys for presetting product codes of a plurality of products, and "00", "0" to "9" as shown in FIG. Numeric key K1,
"X" multiplication key K2, "C" clear key K3, "subtotal" subtotal key K4, "male adult", "male youth", "male child", "female adult", "female youth", " It is composed of a function keyboard 2b on which various keys such as a customer layer key K5 for "woman and child" are arranged.

Usually, each preset key of the preset keyboard 2a is preset with a product code of a product without a product code bar code.
By operating and inputting this preset key, the corresponding sale item can be registered. Here, preset keyboard 2a
The hand scanner 7 constitutes a product registration means.

The customer base key K5 is a customer base (in this embodiment, there are six types of "male adult", "male youth", "male child", "female adult", "female youth", "female child". Function as a customer class specifying means for specifying and inputting (classify). Also,
This customer segment key K5 also serves as a closing key for declaring the end of registration for one customer. That is, the cashier registers the sales of a product purchased by one customer by operating the preset keyboard 2a and the hand scanner 7, and when the registration is completed, the customer class key k5 of the customer class applicable to the customer is pressed to declare the registration completion. Here, the customer layer key K5 also functions as a registration closing means.

On the function keyboard 2b side, there is provided a mode switch 9 for selecting various business modes such as "registration", "inspection", "payment", and "setting". Incidentally, "registration" is a task of accumulating the sales data of each product registered by the product registration means in the storage section, and "inspection" is a task of outputting a report of the content of the storage section registered by "registration". , "Payment" is "Inspection"
Similarly to the above, after outputting a report, the operation of clearing the contents of the storage unit, and the "setting" is the operation of previously setting in the storage unit the data necessary for executing various operations such as "registration".

FIG. 3 is a block diagram showing a schematic configuration of a control unit in this electronic cash register.
That is, the electronic cash register includes a CPU (central processing unit) 11 as a control unit main body, and a ROM (read-out) for preliminarily storing fixed data such as program data as a main storage unit controlled by the CPU 11. RA with a memory (only memory) 12 and a work buffer for temporarily storing data
An M (random access memory) 13 is provided.
The RAM 13 is backed up by the battery 13a.

Further, this electronic cash register is
A clock circuit 14 for timing the date and time, a keyboard controller 15 for taking in key signals from the keyboard 2, a display controller 16 for controlling the screen display of the operator display 3 and customer display 4, and a receipt by the printer 17 described above. A printer controller 18 for controlling printing and journal printing, a scanner controller 19 for taking in bar code data from the hand scanner 7, a signal input section from the mode switch 9 and a drawer opening device 5a for opening the drawer 5. An I / O port 20 that functions as a drive signal output unit is provided.

The CPU 11, ROM 12, RAM 1
3, clock circuit 14, each controller 15, 16, 18,
The bus line 21 connects the I / O port 19 and the I / O port 20.

In addition to the work buffer, the RAM 13 stores a single item registration file 41 as a storage unit for accumulating product sales data as shown in FIG. 4 and a total amount of products purchased by a customer. Totaling device 42, customer stratified same day sales total file 43, customer stratified hit product total table 44, customer stratified hit product list table 45,
Various memory areas such as a best data area 46 and a designated period data area 47 are formed.

As shown in FIG. 5, the single item registration file 41 stores product data such as a product code, a product name, a unit price, and a status of each product in advance, and a total score area for accumulating sales points for each product code. And a total amount area for accumulating the sales amount.

The day-to-day sales total file 43 for each customer segment is
To count the number of sales of all products sold on the same day by product by customer segment of "male adult", "male youth", "male child", "female adult", "female youth", "female child" 6, the product code area and the sales quantity area are formed corresponding to one customer layer as shown in FIG.

The hit product tabulation table 44 for each customer segment
Is a table for totaling the number of products sold by product for all products sold within a preset period,
As shown in FIG. 7, for one customer segment, the area for storing daily sales volume daily total data from 1 day to 30 days before the current day corresponding to the product code of each product, and the total data are stored. And an area for doing so are formed.

Hit product list table 45 for each customer segment
8 is a table for storing information on hot-selling products with a large number of sales among all products sold within a preset period, so-called hit products, for each customer segment, and FIG. As shown in, the product code and the product name are stored corresponding to the hit ranking. In this embodiment, the data (product code and product name) of each product whose hit rank is from 1st to 20th is stored.

The best data area 46 specifies the best data n (1 ≦ n20) of the hit product list up to which the hit product list stored in the customer-specific hit product list table 45 is provided. ) Is stored in advance.

In the designated period data area 47, the hit product list is created by aggregating, for each product, the data up to how many days ago of the product-by-product sales unit daily total data stored in the customer segment hit product totaling table 44. This is an area in which period designation data D (1 ≦ D ≦ 30) for designating whether or not to perform is previously stored.

In the electronic cash register, when the "register" mode is selected by the mode switch 9 and the product code is input from the hand scanner 7 or the preset keyboard 2a, the CPU 1
1 is programmed to handle merchandise registration as follows.

That is, when the product registration file 41 is searched and the product data corresponding to the input product code is read out, the unit price in the data is entered with the sales point (the multiplier is entered by the numerical key K1 and the multiplication key K2). If so, the sales amount is calculated by multiplying by the multiplier, and if not input, by "1").

Then, the number of sales and the amount of sales are added to the sales number area and the sales amount area corresponding to the input product code of the single item registration file 41. Further, the sales amount is added to the totalizer 42. Further, the input product code and the sales quantity data are paired and stored in the work buffer of the RAM 13. The work buffer and the totalizer 42
Is cleared to "0" by the first product registration of one customer.

Thereafter, the sales amount is displayed on the operator display 3 and the customer display 4 together with the product name and the like, and the printer 17 prints out the receipt paper and the journal paper to complete the registration process of one product. .

Further, when the customer layer key K5 is operated and the customer layer of the customer is designated and declared at the same time as the registration end is declared after the product registration, the CPU 11 executes the processing shown in the flowchart of FIG. 9 (a). Is programmed to

That is, first, the total amount of money in the totalizer 42,
The printer 17 prints on the receipt paper and the journal paper the closing amount data such as the deposit amount entered by the input key K1 and the change amount obtained by subtracting the total amount from the deposit amount.

Next, referring to the hit product list table 45 of the designated and input customer segment, the product data (product code and product name) up to the nth best data set in the best data area 46 is read. Then, the printer 17 prints the order, the product name, etc. on the receipt paper (hit product list output means).

Next, the printed receipt sheet is discharged from the receipt issuing port 6 to issue a receipt, and I
A drive signal is sent from the / O port 20 to the drawer opening device 5a to automatically open the drawer 5.

After that, the number of products sold by the product registered this time stored in the work buffer is additionally registered in the same day sales total file 43 of the designated customer. In this case, if the same day sales total file 43 already has sales quantity data with matching product codes, the sales quantity of the corresponding product is added to that data. Set the number.

Further, this electronic cash register is
When the "settlement" mode is selected by the mode switch 9 and the hit product settlement task is selected by the operation input of the function keyboard 2b, it is programmed to execute the processing shown in the flowchart of FIG. 9B. ing.

That is, first, the oldest sales volume daily total data, that is, the sales volume daily total data of the area 30 days ago (days = −30) is all deleted from the hit product totaling table 44 provided for each customer segment. Next, the area 1 day before (the number of days = -1) of the table 44 for counting hit products by customer segment
To 29 days ago area (number of days = -29), the sales daily total data is moved to the area of the previous day.

Next, the sales quantity data for each product stored in the same day sales total file 43 of the same customer class is registered in the area one day before in the hit product total table 44 for each customer class which has become an empty area due to the data movement. . In this case, since the product code and the sales quantity data are paired and stored in the current day sales totalizing file 43, the hit product totaling table 44 of the same customer group is stored for each pair of data.
Is registered, and the corresponding sales volume data is registered in the area one day ago where the product codes match.

In this way, if the sales quantity data for each product stored in the same day sales total file 43 for the same customer is registered in the area for one day before in the hit product totaling table 44 for all the customers, if the sales date for each customer is reached. All the data in the sales totalization file 43 are cleared.

Then, for each hit product tabulation table 44 for each customer segment, the data from the area one day before to the area (number of days = -D) corresponding to the specified period data D of the specified period data area 47 is classified by product. The data is totaled and the total data is stored in the corresponding total areas (customer stratum-based data aggregation means).

Next, the total area is searched for each hit product tabulation table 44 for each customer class, and the product codes from the 1st place to the 20th place are extracted in descending order of the total data. When the total data are the same, the one closer to the head data in the table 44 is ranked higher.

In this way, if the product codes from the 1st place to the 20th place are extracted for each customer segment, the product name data corresponding to those product codes are read from the single-item registration file 41 and hits from the 1st place to the 20th place according to the customer segment. A product list (hit rank, product code, product name) is created and stored in the hit product list table 45 of the same customer segment (hit product list creating means).

This is the end of the hit product settlement business.

In this embodiment having such a configuration, by performing the hit product settlement operation in the settlement operation performed after the store is closed every day, the number of days area (-1 for each customer group hit product totaling table 44) ~ -30)
In addition, daily sales data by product type by customer segment is stored for the latest 30 days from the current day to 29 days before.

Further, when "10" is set as the designated period data D, the number of days "-1" to "-10" is set for each hit product tabulation table 44 for each customer segment.
The product-by-product sales unit daily total data for the latest 10 days from the current day to the 9th day stored in each area are totaled. Then, for each customer segment, the products from the 1st to 20th are determined in descending order of the total sales volume data by product, and the hit product list for each customer segment is created based on the data of the product, and the hits of the same customer segment are created. Product list table 45
Memorized in.

Therefore, by executing the hit product settlement operation after the store is closed every day, the data D for the designated period is always maintained.
The hit products from the 1st place to the 20th place are determined in descending order of the number of sales for each customer segment in the latest fixed period specified by, and the hit product list for each customer segment is stored in the hit product list table 45 of the same customer segment. Will be.

On the other hand, while the store is open, the cashier determines the customer class based on the sex and the estimated age of the customer each time the customer finishes registering the product to be purchased, and operates the corresponding customer class key K5.

Then, from the hit product list table 45 of the designated and input customer segment, the best data area 46 is selected.
The data up to the nth best data set in the above are extracted and printed as a hit product list on the receipt issued to the customer.

FIG. 10 shows an example of issuing the receipt 50 when "3" is set as the best data n. As shown in the figure, the receipt 50 is followed by detailed data 51 such as item name and price of a product purchased by one customer and closing data 52 such as total amount, deposit amount, change amount, and the like, followed by a customer group ( (In this case, "young man")
The current best-selling top 3 product names are hit product list 5
Printed as 3.

Therefore, the customer who receives the receipt 50 can surely know from the hit product list 53 what the hit product is currently popular with his / her customer base. Such hit product information is meaningful information for increasing the customer's willingness to purchase, and can be expected to promote sales.

Moreover, the store side only has to execute the hit product settlement operation at the time of settlement, and it is a conventional practice to input the customer segment of the customer, which requires extra effort. Since it is possible to provide a hit merchandise list of customers corresponding to the customer without the need, it is possible to efficiently promote sales.

Further, since the best data area 46 is provided and the hit product list up to the best data n places set in this area 46 can be printed on the receipt, it is easy to hit by changing the setting of the best data n. The range of the product list can be expanded or reduced.

Similarly, the designated period data area 47 is provided, and the daily sales volume daily data for each product up to the designated period data D set in this area 46 is totaled to create a hit product list for each customer group. Specified period data D
A desired aggregation period can be set only by changing the setting of.

The present invention is not limited to the above embodiment. For example, although the present invention is applied to a single electronic cash register in the above-mentioned embodiment, it goes without saying that the same structure as this embodiment can be applied to the POS terminal. In addition, a POS controller that centrally manages a plurality of POS terminals is provided with a hit product tabulation table 44 by customer segment and a hit product list table 45 by customer segment, and the daily sales data of the products registered for sale at each POS terminal is provided. May be aggregated to create a hit product list for each customer segment.

Further, in the above-mentioned embodiment, as a method of determining the ranking among products for which the sales total data is the same when creating the hit product list, the one closer to the head data of the table 44 is ranked higher, but it is not limited to this. For example, a method in which weighting is performed for each product in consideration of differences in product classifications, past sales results, and the like, and a product having a higher degree of importance is considered as a higher rank may be considered.

Further, although the hit product list is printed out in the above embodiment, it may be displayed on the displays 3 and 4 to inform the customer. Further, if the electronic cash register is equipped with a voice synthesizer, it is possible to make a notification by voice output.

Further, in the above embodiment, the number of sales of each product is used as the index of the hit product, but the present invention is not limited to this. For example, the amount of sales is used as the index of the hit product. May be

Besides, it is needless to say that various modifications can be made without departing from the scope of the present invention.

[0063]

As described above in detail, according to the present invention, data serving as an index of hit products within a certain period of time is aggregated for each customer, and the hit product index aggregate data obtained by each customer is obtained. By creating a hit product list for each customer class and outputting the hit product list of the customer class specified at the time of product registration to the corresponding customers,
It is possible to provide a product sales data processing device capable of reliably and automatically providing hit product information of the corresponding customer segment to each customer, and efficiently increasing the customer's willingness to purchase and promoting sales. .

[Brief description of drawings]

FIG. 1 is an external perspective view of an electronic cash register that is an embodiment of the present invention.

FIG. 2 is a plan view of a function keyboard according to the embodiment.

FIG. 3 is a block diagram showing a main part control unit in the embodiment.

FIG. 4 is a schematic diagram showing a main memory area configuration of a RAM in the embodiment.

5 is a schematic diagram showing the configuration of a single item registration file in FIG.

FIG. 6 is a schematic diagram showing the structure of the same day sales total file for each customer in FIG.

FIG. 7 is a schematic diagram showing the configuration of a hit product tabulation by customer segment in FIG.

FIG. 8 is a schematic diagram showing a configuration of a hit product list table for each customer group in FIG.

FIG. 9 is a flowchart showing main program processing executed by the CPU in the embodiment.

FIG. 10 is a plan view showing an example of a receipt printed and issued in the embodiment.

[Explanation of symbols]

 2a ... Preset keyboard (product registration means) 7 ... Hand scanner (product registration means) K5 ... Customer layer key (customer layer designation means, registration closing means) 11 ... CPU 17 ... Printer 43 ... Customer group sales total file 44 ... Customer group hit product Aggregation table 45 ... Hit product list table by customer segment

Claims (1)

[Claims] 1. When a product registered by one customer is registered by the product registration means, the sales data of the registered products are totaled in the storage unit, and when the registration closing means declares the end of registration, In a product sales data processing device that issues sales data that prints the sales data of the products purchased by customers and their total data, collects data that is an index of hit products within a certain period by customer segment Means, a hit product list creating means for creating a hit product list for each customer class based on hit product index tabulation data obtained by the customer class by this collecting means, and a customer class of customers who have registered the purchased products by the product registering means. Customer class designating means for designating and inputting, and hit products for outputting the hit product list of the customer class designated by this customer class designating means Merchandise sales data processing apparatus characterized by comprising a strike output means.