JP2002074516A - Apparatus for managing past purchase result and its program recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To perform a customer service based on gross margin results and to provide a proper customer service to real regular customers according to the degree of the profit contribution of a store side. SOLUTION: This device is provided with a file of gross margin results by customers and by merchandise for storing and managing a cumulative gross margin amount of each different customer and of each different merchandise. When sales by merchandise data about merchandise purchase by a customer are inputted at the time when accounting is performed, a CPU 1 searches the file of the gross margin results by customers and by merchandise on the basis of an inputted merchandise code and performs a scrupulous discount service that discounts the selling unit cost of each merchandise on the basis of a cumulative gross margin amount by customers and by merchandise.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a purchase record management apparatus for performing customer service according to a purchase record of each customer and a program recording medium thereof.

[0002]

2. Description of the Related Art Conventionally, many retail stores issue a member card to each customer as a part of customer service, and provide a service according to the purchase result of the customer based on the member card presented by the customer. To do. That is, in a sales data processing device such as an electronic cash register (ECR) or a POS (point of sales) terminal, the purchase results (sales results) up to that point are stored and managed for each customer, and presented to the customer at the time of accounting. A purchase result of the customer is acquired based on the customer information read from the member card, and a service point is added based on the purchase result for each customer, and a discount service is performed based on the total number of points. In this case, the purchase result for each customer is the purchase amount, and if the purchase amount up to that time is large, the customer is regarded as a superior customer and a high discount service is provided.

[0003]

However, in the retail store, even if the purchase amount, which is the purchase result, is large, it is not always the case that the retailer is good at such a case. Could not provide discount service. That is, the gross profit of the product differs for each product, and the profit of the retail store is finally determined by the gross profit amount. For example, a customer who purchases a product with a gross profit rate of 10% for 1.2 million yen Conventionally, between "A" and a customer "B" who purchased a product with a gross margin of 30% for 500,000 yen, conventionally, a customer "A" who purchased 1.2 million yen purchased 500,000 yen. Although the customer can receive a higher discount service than the customer “B”, the gross profit amount is 120,000 yen for the customer “A” and the customer “B” is It is 150,000 yen, and it can be said that the customer "B" should be a superior customer. As described above, in the related art, since the discount service is provided based on the purchase price, the result is that the customer who should be a good customer is not given preferential treatment, and the appropriate service may not be provided. An object of the present invention is to calculate customer-specific gross profit results based on purchase results for each customer, thereby enabling customer service based on the gross profit results, and the original superiority in light of the store's profit contribution. The goal is to be able to provide appropriate customer service to the customer.

[0004] The means of the present invention are as follows. A first aspect of the present invention is a purchase result management apparatus that performs customer service according to the purchase result of each customer, wherein the gross profit result calculation means calculates the gross profit result of each customer according to the purchase result of each customer. And service providing means for providing customer service to the customer based on the gross profit result for each customer calculated by the gross profit result calculating means. Another object of the present invention is to provide a recording medium on which a program code for causing a computer to execute each of the above-described functions is recorded. Therefore, in the invention described in claim 1, by calculating the gross profit record for each customer based on the purchase record for each customer, customer service based on the gross profit record becomes possible, and the degree of profit contribution on the store side is reduced. Appropriate customer service can be provided to illuminated original customers.

[0005] The present invention may be as follows. (1) A gross profit record storage means for storing and managing the gross profit record for each customer is provided, and when performing a product registration process for a product purchased by the customer, the gross profit record calculation means sets the gross profit record of the product. The amount is accumulated as the gross profit record of the customer in the gross profit record for each customer in the gross profit record storage means, and the service providing means stores the total gross profit amount for each customer stored in the gross profit record storage means. Perform customer service for the customer based on the customer service. (2) The gross profit record storage means stores and manages the gross profit record for each customer and each product, and when performing the product registration process on the product purchased by the customer, the gross profit record calculation means,
The gross profit amount of the product is accumulated as the gross profit record for each product and the gross profit record for each customer in the gross profit record storage means, and the service providing means stores the customer stored in the gross profit record storage means. The customer service is provided to the customer for each product based on the total gross profit amount for each product. (3) The service processing means obtains a discount rate for each customer or product, and discounts the selling price of the purchased product at the discount rate. (4) The service processing means issues a service ticket for a service ticket amount or a service ticket point for each customer.

[0006]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS (First Embodiment) A first embodiment of the present invention will be described below with reference to FIGS. FIG.
FIG. 1 is a block diagram showing an overall configuration of a sales data processing device such as an electronic cash register (ECR) or a POS (point of sales) terminal in this embodiment. This sales data processing device performs registration processing for each product based on the input sales data for each product when the sales data for each product relating to the product purchased by the customer is input at the time of accounting, and registers one transaction. In addition to the normal registration function of issuing a receipt at the time of termination, in particular, in the sales data processing apparatus of this embodiment, the gross profit result for each customer is calculated in accordance with the purchase result for each customer, and the calculated gross profit for each customer is calculated. By providing a discount service that discounts the price (sales unit price) for each product as a predetermined customer service to customers based on profit performance, it is possible to provide appropriate services to original customers in light of the profit contribution degree of the store side It is intended to provide an excellent customer service. Here, the customer-specific gross profit result is the cumulative value of the gross profit amount accumulated for each customer and each product (cumulative gross profit amount for each customer-specific product). In addition,
Before describing the features of this embodiment in detail, the hardware configuration of this embodiment will be described below.

[0007] The CPU 1 is a central processing unit that controls the overall operation of the sales data processing device according to the operating system and various application software in the storage device 2. The storage device 2 stores a database, character fonts, and the like in addition to an operating system and various application software, and has a recording medium 3 composed of a magnetic, optical, semiconductor memory, and the like, and a drive system therefor. The recording medium 3 is a fixed medium such as a hard disk or a CD-R that can be detachably mounted.
It is a portable medium such as an OM, a floppy desk, a RAM card, and a magnetic card. The programs and data in the recording medium 3 are loaded into a RAM (for example, a static RAM) 4 under the control of the CPU 1 as needed, or the data in the RAM 4 is saved in the recording medium 3.
Furthermore, the recording medium may be provided on the side of an external device such as a server, and the CPU 1 can directly access and use the program / data in the recording medium via a transmission medium.

The CPU 1 can also take in some or all of the data stored in the recording medium 3 from another device via a transmission medium, and newly or additionally register the data in the recording medium 3. That is, the transmission control unit 5 receives a program / data transmitted from another device constituting the computer communication system via a wired transmission line such as a communication line or a cable or a wireless transmission line such as radio waves, microwaves or infrared rays. And can be installed in the recording medium 3. Further, the program / data may be stored and managed on the external device side such as a server, and the CPU 1 may directly access and use the program / data on the external device side via a transmission medium.

On the other hand, a transmission control unit 5, an input unit 6, a display unit 7, a card reader 8, a bar code reader 9, and a printing unit 10, which are input / output peripheral devices, are connected to the CPU 1 via a bus line. The CPU 1 controls these operations according to an input / output program. The input unit 6 is an operation unit that forms a keyboard and a pointing device. Although not shown, in addition to a numeric keypad for inputting sales data for each product and a registration key for each product, various types such as “registration”, “inspection”, and “payment” are provided. A mode changeover switch for changing the mode is provided. The display unit 7 is a liquid crystal, a CRT, a plasma display device, or the like that performs full-color display. The card reader 8 reads customer information from a member card previously issued to the customer as part of the customer service, and the barcode reader 9 reads barcode information added to the product. What you read.
The printing unit 10 is a non-impact printer such as a thermal transfer or ink jet printer or a dot impact printer, and performs receipt printing and journal printing.

FIG. 2 is a diagram showing various files and the like provided in the sales data processing apparatus. This sales data processing device includes a sales total file 11 for each product, a product master file 12, a gross profit record file 1 for each product, and a customer.
3. A discount rate table 14 for gross profit per product is provided. The product-specific sales total file 11 constitutes a normal product-specific totalizer, and when product-specific sales data relating to a product purchased by a customer at the time of accounting is input, the input product-specific sales data is used. It is registered in the sales total file 11. That is, this product-specific sales total file 11
Are configured to have items such as “product code”, “sales quantity”, and “sales amount”. Based on the input sales data for each product, the “sales quantity”, “sales” "Amount" is updated.

The merchandise master file 12 stores and manages each merchandise information. Each merchandise record constituting the merchandise master file 12 includes, as shown in FIG.
The configuration includes items such as “cost” and “sales unit price”. Here, the CPU 1 calculates the gross profit rate for each product based on “cost” and “sales unit price”. As shown in FIG. 4, each record constituting the customer-specific product-specific gross profit record file 13 includes items of “customer code”, “product code”, and “cumulative gross profit amount”. Are sorted by customer. The “cumulative gross profit amount” for each product is a value obtained by accumulating the gross profit amount for each product as the past purchase results of the products purchased by the customer. Each time the product registration process is performed, the “total gross profit amount” is calculated. Is updated.

The gross profit-specific discount rate table 14 for each product is
In order to perform appropriate customer service according to the above-mentioned “cumulative gross profit amount” for each product, the reference determination value is fixedly stored in advance, and as shown in FIG. , "The reference cumulative gross profit amount", and the "discount rate" are stored. The “reference cumulative gross profit amount” is a reference judgment value to be compared with the “cumulative gross profit amount” of each product in the customer-specific product gross profit record file 13, and the “accumulated gross profit amount” of each product is the reference judgment value. At the corresponding "discount rate"
The customer service for discounting the selling price of the product is performed.

In this case, in the illustrated example, "5000", "10000", "200"
00 ”$, and“ 10% ”,“ 20% ”,“ 30% ”as the corresponding“ discount rate ”.
‥‥ is set, 0% discount if the accumulated gross profit amount is less than 5,000 yen, 10% discount if it is 5,000 yen or more and less than 10,000 yen, 20 if it is 10,000 yen or more and less than 20,000 yen It is defined to be% discount. The method of determining the “discount rate” according to the “base cumulative gross profit amount” is not limited to the above example,
Optional, for example, if the cumulative gross profit amount is less than 5,000 yen, the discount rate is 10%;
0% discount, 30% discount if 10,000 yen or more and less than 20,000 yen.

Next, the operation of the sales data processing apparatus according to the first embodiment will be described with reference to the flowchart shown in FIG. Here, a program for realizing each function described in this flowchart is stored in the recording medium 3 in the form of a readable program code, and the CPU 1 sequentially executes operations according to the program code. . Further, the CPU 1 can also sequentially execute operations according to the above-described program code transmitted via the transmission medium. The same applies to other embodiments described later, and an operation specific to this embodiment can be executed using a program / data externally supplied via a transmission medium in addition to a recording medium.

FIG. 6 is a flowchart showing a merchandise item registration process executed in the registration mode in which the mode changeover switch is switched to the "registration" position. First, at the time of accounting, upon receiving a member card presented by a customer, the operator causes the card reader 8 to read customer information from the member card (step A1). In addition, after the merchandise code information is read by scanning the merchandise purchased by the customer with the barcode reader 9 (step A2), the “sales quantity” of the merchandise is input by key (step A).
3).

In this state, the CPU 1 searches the product master file 12 based on the product code read by the bar code reader 9, and acquires "cost" and "sales unit price" of the product (step A4), The “gross profit rate” of the product is calculated based on the “cost” and “sales unit price” (step A5). In this case, "cost"
The gross margin is calculated according to the formula of “/ sales unit price” × 100. Next, the “gross profit amount” of the product is calculated based on the “sales volume”, “sales unit price”, and “gross margin rate”. At this time, “sales volume” × “sales unit price” ×
The “gross profit amount” for each product is calculated in accordance with the formula for “gross profit rate”, and the calculation result is added to the gross profit actual file 13 for each customer (step A6). In this case, based on the customer information (customer court) read by the card reader 8 and the product code read by the barcode reader 9, the customer-specific gross profit record file 13 is searched, and “ Cumulative gross profit amount ''
Then, the "cumulative gross profit amount" is updated by adding the calculated "gross profit amount" to this time.

Next, based on the “cumulative gross profit amount” updated as described above, the corresponding “discount rate” is acquired from the discount rate table 14 for each product-specific gross profit (step A).
7). That is, the product-based gross profit actual discount rate table 14 is searched based on the “product code” of the “cumulative gross profit amount” updated as described above, and the “base cumulative gross profit amount” is retrieved from the corresponding record. ”, And by comparing the“ cumulative gross profit amount ”with each“ base cumulative gross profit amount ”, the“ discount rate ”corresponding to the range indicated by each of the reference judgment values is classified by product. Gross profit actual discount rate table 14
Read from

For example, gross profit record file 1 for each customer and product
In 3, the customer with the customer code "000001"
For the product code "00001: Men's trainer", the accumulated gross profit is "9000 yen", and for the product code "00002: Women's trainer", the accumulated gross profit In the case where there is a record of “2000 yen”, when searching the discount rate table 14 for the gross profit record by product based on the product code “00001: trainer for men”, the reference cumulative gross profit amount is “5000”.
The discount rate is “10%”, and the discount rate is “0%” since the reference cumulative gross profit amount corresponding to the women trainer is “20,000 yen”.

The sales price of the product is discounted based on the "discount rate" to calculate a "sales amount" according to the "sales quantity" (step A8). )), And according to the “sales quantity” and “sales amount”, the total sales file 1 for each product
In addition to updating the “number of sales” and “sales amount” in No. 1, a process of registering “product code”, “discount rate”, “sales amount”, and “sales amount” in a journal memory (not shown) or the like. (Step A9). Then, it is checked whether or not the end of the registration for one transaction has been instructed (step A10), and thereafter, the above-described product registration processing is repeated until the end of the registration for one transaction is instructed (steps A2A to A10). When the registration for one transaction is completed, the closing process is executed,
A tax is calculated on the total sales for one transaction, a change is calculated, and a receipt is issued (step A1).
1).

As described above, in the first embodiment, when sales data for each product relating to a product purchased by a customer at the time of accounting is input, the gross profit performance for each customer according to the purchase performance for each customer is calculated. In addition to the calculation, the predetermined customer service is provided to the customer based on the calculated gross profit result for each customer, so that it is possible to perform a discount service based on the gross profit result. Appropriate customer service can be provided to original customers in view of the degree of profit contribution. In this case, since the gross profit record file 13 for each customer is provided and the accumulated gross profit amount is stored and managed for each product for each customer, customer service for each product is performed based on the accumulated gross profit amount for each product for each customer. It becomes possible. That is, a detailed discount service that discounts the price (sales unit price) for each product becomes possible.

(Second Embodiment) Hereinafter, a second embodiment of the present invention will be described with reference to FIGS. In the first embodiment, the discount service for discounting the sales unit price for each product based on the cumulative gross profit amount for each product is shown. However, the second embodiment is directed to the cumulative gross profit for each product. A coupon is issued by obtaining a service ticket amount (coupon amount) for each product based on the amount. Here, basically the same components in both embodiments are denoted by the same reference numerals, and the description thereof will be omitted. In addition, the following mainly describes the features of the second embodiment.

FIG. 7 is a diagram showing a configuration of a product-specific gross profit actual coupon ticket table 15 which replaces the product-specific gross profit actual discount rate table 14 of the above-described first embodiment. The product-specific gross profit actual coupon ticket table 15 is configured to store “product code”, “base cumulative gross profit amount”, and “coupon voucher amount” for each product. That is, the “reference cumulative gross profit amount” is a reference determination value to be compared with the product-specific “cumulative gross profit amount” in the customer-specific product gross profit result file 13 as in the first embodiment described above. When the “cumulative gross profit amount” for each product reaches the reference determination value, the corresponding “coupon ticket amount” is read and a coupon is issued.

FIG. 8 is a flowchart showing the merchandise registration processing corresponding to FIG. 6 described above. Since it is basically the same as the first embodiment, the following description focuses on the features of the second embodiment. Will be described. First, the customer information is read from the member card (step B1), and after reading the product code information (step B2), the "sales quantity" of the product is input by key (step B3). In this state, the CPU 1 searches the product master file 12 based on the product code, obtains “cost” and “sales unit price” corresponding to the product, calculates “gross profit rate” (steps B4 and B5). ), The “gross profit amount” of the product is calculated based on the “sales quantity”, “sales unit price”, and “gross profit rate”, and the calculation result is added to the customer-specific product-specific gross profit performance file 13 (step B6). ).

Next, based on the "cumulative gross profit amount" updated as described above, the corresponding "coupon voucher amount" is acquired from the coupon voucher table 15 for each product-specific gross profit result (step B7). That is, based on the "product code" of the "cumulative gross profit amount" updated as described above, the coupon ticket table 15 for each product-specific gross profit is searched, and the "base cumulative gross profit amount" is retrieved from the corresponding record. ”Respectively, this“ cumulative gross profit amount ”and each“ base cumulative gross profit amount ”
Then, the “coupon amount” corresponding to the range indicated by each of the reference determination values is read.
Then, a process of accumulating the “coupon ticket amount” to the customer-specific coupon amount is performed (step B8).

Next, the "sales amount" is added to a subtotal memory (not shown), the contents of the product-specific sales total file 11 are updated according to the "sales quantity" and "sales amount", and the journal memory is added. A process of registering “product code”, “discount rate”, “coupon amount”, and “sales quantity” in (not shown) or the like is performed (step B9). Then, it is checked whether the registration end of one transaction has been instructed (step B10),
The above-described commodity registration processing is repeated until the end of the registration for one transaction is instructed (steps B2 to B10). When the registration for one transaction is completed, a closing process is executed, a receipt is issued, and a receipt is issued (step B11).
A coupon is issued in accordance with the customer-specific coupon amount (step B12).

As described above, in the second embodiment, the coupon is issued by obtaining the coupon amount for each product based on the cumulative gross profit amount for each product.
As in the first embodiment described above, a service based on the gross profit record becomes possible, and an appropriate coupon amount can be obtained for the original customer in view of the profit contribution degree of the store.

In the first embodiment described above,
Although the sale unit price is reduced based on the discount rate for each product in accordance with the cumulative gross profit amount for each customer, each product may be discounted not only for each product but also for each product category. Further, the cumulative gross profit amount for each customer may be used as the cumulative gross profit amount for all products without using the product unit or the product classification unit, and in this case,
The total amount of the current transaction may be reduced according to the cumulative gross profit amount of the customer. Further, in each of the above-described embodiments, the sales data processing device is provided with the customer-specific gross profit record file 13 so as to centrally manage the gross profit record of each customer. The gross profit record may be stored in the storage unit, and the gross profit record for each customer may be read by a card reader for each transaction, and the current purchase record may be added to the read gross profit record and written in the member card.

In each of the above-described embodiments, the product master file 12 is searched based on the product code.
Although the “gross profit rate” is calculated based on the “cost” and “sales unit price” corresponding to the product, the “gross profit rate” may be stored in the product master file 12. Also,
The “gross profit amount” for each product is calculated according to the formula of “sales quantity” × “sales unit price” × “gross profit rate”.
The “gross profit amount” may be stored in the product master file 12.

In the second embodiment described above,
Although the coupon amount is determined for each customer, the coupon point may be determined. Further, the service ticket may be a magnetic card or a memory card. In this case, the service amount or service point may be written on the magnetic card or the memory card, or the member card may be a service ticket. . In addition, as a customer service, a prize may be provided or an invitation ticket or the like may be provided according to the gross profit amount. The sales data processing device is not limited to an electronic cash register or a POS terminal, but may be, for example, a vending machine.

[0030]

According to the present invention, the gross profit record for each customer is calculated based on the purchase record for each customer, so that customer service based on the gross profit record becomes possible.
For the original customer in light of the store's profit contribution,
We can provide appropriate customer service.

[Brief description of the drawings]

FIG. 1 is a block diagram showing the overall configuration of a sales data processing device such as an electronic cash register or a POS terminal.

FIG. 2 is a diagram showing various files and the like provided in the sales data processing device.

FIG. 3 is a diagram showing a configuration of a product master file 12.

FIG. 4 is a diagram showing the configuration of a customer-specific product-specific gross profit record file 13;

FIG. 5 is a diagram showing a configuration of a discount rate table 14 by gross profit by product.

FIG. 6 is a flowchart showing a product registration process.

FIG. 7 is a diagram showing a configuration of a coupon ticket table 15 according to gross profit results according to the second embodiment.

FIG. 8 is a flowchart showing a product registration process according to the second embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 CPU 2 Storage device 3 Recording medium 5 Transmission control unit 6 Input unit 7 Display unit 8 Card reader 9 Barcode reader 10 Printing unit 11 Total sales file by product 12 Product master file 13 Product gross profit file by customer 14 Product by product Discount rate table by gross profit 15 Coupon table by gross profit by product

Claims (6)

[Claims] 1. A purchase result management device for performing customer service according to a purchase result for each customer, comprising: a gross profit result calculation means for calculating a gross profit result for each customer according to a purchase result for each customer; And a service providing means for providing customer service to the customer based on the gross profit result for each customer calculated by the profit result calculating means. 2. A gross profit record storing means for storing and managing a gross profit record for each customer, and when performing a product registration process for a product purchased by the customer, the gross profit record calculating means comprises: The gross profit amount is accumulated as the gross profit record of the customer in the gross profit record for each customer in the gross profit record storage means, and the service providing means is a gross profit record for each customer stored in the gross profit record storage means. 2. The purchase result management device according to claim 1, wherein customer service is provided to the customer based on the amount. 3. The gross profit record storage means stores and manages the gross profit record for each customer and each product, and when performing a product registration process for a product purchased by a customer, the gross profit result calculation means is used for the gross profit record calculation means. The gross profit amount of the product is accumulated as a gross profit record for each product in the gross profit record for each customer in the gross profit record storage means, and the service providing means stores the gross profit amount for each customer stored in the gross profit record storage means. 3. The purchase record management apparatus according to claim 2, wherein customer service is provided for each customer based on the total gross profit amount for each product. 4. The service providing means according to claim 1, wherein a discount rate is obtained for each customer or product, and the selling price of the purchased product is discounted at the discount rate. Purchase performance management device. 5. The purchase record management apparatus according to claim 1, wherein said service processing means issues a service ticket for a service ticket amount or a service ticket point for each customer. . 6. A recording medium having a program code readable by a computer, the program code being readable by a computer for calculating a gross profit record for each customer according to a purchase record for each customer. A computer-readable program code for causing a customer to perform customer service based on customer-based gross profit performance.