JP2017079075A - Point management system and commodity selling data processing device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a point management system and a commodity selling data processing device for analyzing breakdown of a point(s) which is applied following to purchasing of a commodity, and using a result of the point analysis to a commodity selling promotion.SOLUTION: A device comprises: a first storage part for associating commodity information which identifies a commodity about which transaction was performed, a unit price of the commodity, a transaction number of the commodity and a purchase point which was applied to transaction of the commodity, and storing them, for single transaction, based on transaction data acquired from a selling data processing device; a totalling part for totalling a purchase point for every commodity based on the commodity information, about each transaction which was performed in a prescribed period; and a second storage part for associating the totalled purchase point for every commodity, at least corresponding commodity information, and the transaction number and storing them.SELECTED DRAWING: None

Description

  Embodiments described herein relate generally to a point management system and a merchandise sales data processing apparatus that can total points given according to purchased merchandise by predetermined items.

  Currently, merchandise sales data processing apparatuses that give points according to the price of purchased merchandise are widely known.

  This type of merchandise sales data processing apparatus executes a process of giving points according to the price of merchandise purchased as part of service to a customer. The customer can receive a discount service according to the number of points by using the points at the next product purchase.

JP 2001-76256 A

  Therefore, the perception that the points given with product purchases are the same value as the discount amount has permeated to customers, and the amount of points given at the time of product purchases has a considerable impact on product sales. It is thought to affect.

  Under such circumstances, it is desired to analyze the breakdown of points given with the purchase of a product and use the result of this point analysis for sales promotion of the product.

  In order to solve the above-described problem, the point management system of the present embodiment includes an input unit that inputs product identification data, a point return rate storage unit that stores a predetermined point return rate for each product, and the input At least a transaction is performed with point calculation means for calculating purchase points of the product using the unit price of the product identified by the identification data input by the means and the point return rate corresponding to the identified product A first storage unit that stores the product information for identifying the product, the unit price of the product, the number of transactions of the product, and the calculated purchase points corresponding to the product, and transactions performed in a predetermined period Associates the aggregation section that aggregates purchase points for each product, the aggregated purchase points for each product, at least the corresponding product information, and the number of sales points And a second storage unit for storing.

The block diagram which shows the principal part structure of the POS terminal of this embodiment. The figure which shows the data structure of RAM of the POS terminal of this embodiment. The block diagram which shows the principal part structure of the store computer of this embodiment. The figure which shows the data which the goods master file of this embodiment memorize | stores. The figure which shows the data which the payment classification master file of this embodiment of this embodiment memorize | stores. The figure which shows the data structure which the point master file of this embodiment memorize | stores. The flowchart which shows the flow of the process regarding the commercial transaction with 1 customer which CPU of the POS terminal of this embodiment performs. The flowchart which shows the flow of the process regarding the goods registration process which CPU of the POS terminal of this embodiment performs. The figure which shows the commercial transaction data which RAM of the POS terminal of this embodiment memorize | stores. The flowchart which shows the flow of the process regarding the total process which the store computer of this embodiment performs. The figure which shows the data structure which the point master file of this embodiment memorize | stores.

  Hereinafter, a point management system according to an embodiment of the present invention will be described in detail with reference to the accompanying drawings.

  FIG. 1 is a block diagram showing the overall configuration of the point management system 1. The point management system 1 includes a POS (Point-Of-Sales) terminal 10 which is a plurality of merchandise sales data processing apparatuses, and a store computer 20 connected to the POS terminal 10 through a network so that data can be transmitted and received.

  In FIG. 1, a POS terminal 10 has a CPU (Central Processing Unit) 101 mounted as a control unit body. The CPU 101 is connected to a ROM (Read Only Memory) 102 and a RAM (Random Access Memory) 103 via a bus line 105 such as an address bus and a data bus, a clock unit 104 that measures the current date and time, An interface unit 106 with the input / output devices 107 to 112 and a communication controller 107 for controlling data communication with the store computer 20 are connected.

  The input / output devices are described below. The printer 107 issues a receipt on which transaction details data such as the product name, price, and total amount of goods sold in one transaction are printed under the control of the CPU 11.

  The keyboard 108 has “00” and “0” to “9” numeric keys for numeric data, and the numeric data placed by the numeric keys is a PLU (Price Look Up) code. PLU key for instructing, x key for instructing that the numerical data is a multiplier, a discount key for instructing that the numerical data is a discount rate, a discount key for instructing that the numerical data is a discount amount, numerical data Clear key for commanding clearing, etc., subtotal key for commanding subtotal output of transactions, deposit / current total key for commanding cash closing of transactions, exclusion key for declaring sales products to be excluded from point calculation, etc. Have.

  The scanner 109 reads a barcode attached to each product. Each product has a barcode indicating a product code unique to the product. Here, the scanner 109 functions as an input unit for product identification data. The product code can also be input as a PLU code using the numeric keys and the PLU key of the keyboard 108.

  The card reader 110 reads card data including the customer code recorded on the point card.

  The display 111 displays, for the operator of the POS terminal 10, the product name, price, total amount, etc. of the product sold as one transaction. Moreover, the display 112 for customers displays the same information as the display 111 with respect to the customer of this 1 transaction.

  The POS terminal 10 has a RAM 103. FIG. 2 shows a storage area of the RAM 103, and a product registration information buffer 1031, a product registration information number counter 1032, and a card flag area 1033 are formed in the RAM 103.

  The merchandise registration information buffer 1031 is a merchandise registration information record composed of a department code, a merchandise code, a merchandise name (product name), a unit price, a point return rate, a sales score, a sales price, and a purchase point for each merchandise sold in one transaction. Accumulate. The product registration information number counter 1032 counts the number N of transactions accumulated in the product registration information buffer 1031. The card flag area 1033 is for identifying whether or not the transaction is with the customer who presented the point card. When the transaction is with the customer who presented the card, the card flag CF is set to “1”. The RAM 103 also has a print buffer (not shown) for printing receipts.

  FIG. 3 is a block diagram showing the overall configuration of the store computer 20. The store computer 20 is equipped with a CPU 201. A ROM 202, a RAM 203, a timer 204, a printer 207, a keyboard 208, a display 209, an HDD (Hard Disk Drive) 210 and the like are connected to the CPU 201 via a bus line 205.

  The HDD 210 includes a product master file 2101, a customer master file 2102, a payment type master file 2103, a sales file 2104, and a point master file 2105, in addition to various programs for operating the CPU 210.

  FIG. 4 is a diagram showing the product master file 2101 of the store computer 20. The product master file 2101 includes a unique product code that is product identification data set for each product, a department code, a product name (product name), a unit price that is the price per product, and points for the product price. The return rate (%), that is, the point return rate (%) for each product is stored in association with each other.

The customer master file 2102 includes a unique customer code, which is customer identification data set for each customer to identify each customer registered as a member, sales result data such as the customer's name, score, amount, etc. Are stored in association with each other.

  FIG. 5 is a diagram showing the payment type master file 2103 of the store computer 20. In the payment type master file 2103, point magnifications are determined corresponding to “cash”, “electronic money”, and “credit”, which are closing means for one transaction. For example, when one transaction is closed by payment with “cash”, this point multiple is defined as the points awarded in this one transaction are multiplied by the multiple corresponding to the payment type “cash”. ing. For example, since the payment type “cash” is set to “1” in the payment type master file of FIG. 5, the point finally given to each product is calculated from the unit price and the return rate of one product. Points multiplied by 1 are awarded. Similarly, when one transaction is closed by “electronic money”, the points awarded are 1.5 times, and when one transaction is closed by “credit card”, doubled points are awarded.

  The sales file 2104 is a file that receives sales data (including point information) of one transaction transmitted from the POS terminal 10 and sequentially accumulates it.

  The point master file 2105 collects and stores point information stored in the customer identification data 2102 or the sales file 2104. FIG. 6 is a view showing the data structure of the point master file 2105. As shown in FIG. The point master file 2105 stores department codes, product names, sales points, sales amounts, product-specific cumulative points, and department-specific cumulative points in association with each other. The product name and the product-specific cumulative points are stored in association with each other, and similarly, the department code and the department-specific cumulative points are stored in association with each other.

  Next, the sales processing operation of the point management system 1 constituted by the POS terminal 10 and the store computer 20 will be described.

  FIG. 7 is a flowchart showing processing executed by the CPU 101 of the POS terminal 10 relating to a commercial transaction with one customer.

  The CPU 101 checks the card flag area 1033 (Act 701). Initially, since the card flag area 1033 is set to “0” (Y in Act 701), the process proceeds to Act 702, and the CPU 101 determines whether or not the card is registered.

  If it is detected in Act 702 that the card data of the point card is read via the card reader 110, the CPU 101 determines that the card is registered (Y in Act 702). The CPU 101 writes the card data in the RAM 103 (Act 703), and sets the card flag area 1033 to “1” (Act 704). A customer code is acquired from the card data written in the card flag area 1033, and an inquiry is made to the store computer 20 via the communication controller 107 using this customer code. Thereafter, the CPU 101 proceeds to the process of Act 705.

  If the card data of the point card has not been read in Act 702 and it is determined that there is no card registration (N in Act 702), the CPU 101 proceeds to the processing of Act 705 without performing the processing of Act 703 and Act 704.

  If the card flag area 1033 is set to “1” in Act 701, the card data is saved and the transaction is with the point member who presented the point card, so the CPU 101 skips the processing of Act 702 to Act 704. Then, the process proceeds to Act 705.

  Next, in Act 705, the CPU 101 waits for product registration. Here, when a product code is input via the product code input means of the keyboard 108 or the scanner 109, the CPU 101 determines that there is product registration (Y in Act 705). Next, the processing proceeds to Act 706 product registration processing.

  A product registration process executed by the CPU 101 in Act 706 will be described with reference to FIG. In Act 705, the CPU 101 makes an inquiry to the store computer 20 via the communication controller 107 with the input product code, and the product name and unit price set in the product master file 2101 corresponding to the input product code. The product information such as the point return rate set for each product is read (Act 7071).

  Next, since the CPU 101 calculates purchase points using the point return rate for each product, the CPU 101 acquires the point return rate in the product information read from the product master file 2101 (Act 7072).

  Next, the CPU 101 calculates a purchase point P (after the decimal point) from the unit price A (yen) and the point conversion rate B (%) of the product corresponding to the product code input from the scanner 109 or the keyboard 108 by the following equation (1). Is cut off) (Act7073).

      P = (A × B) / 100 (1) Then, the calculated purchase point P is associated with the department code, product code, product name, unit price, and point return rate in the product registration information buffer 1031 of the RAM 103. Store (Act 7074). Thereafter, the process proceeds to At707.

  In Act 707, it is determined whether or not two or more items are registered (Act 707). When the product code is input and the product registration is present (Y in Act 707), the product registration process in Act 706 is executed again. If there is no product registration (N in Act 707), the CPU 101 determines whether registration is closed (Act 708). When the deposit / cash key on the keyboard 108 is operated, the CPU 101 determines that registration has been closed (Y in Act 708). On the other hand, when the deposit / cash key 48 is not operated and it is determined that the registration is not closed (N in Act 708), the CPU 101 returns to the product registration determination process in Act 707.

  Next, when a closing key such as a deposit / cash total key is operated in Act 708, the CPU 101 next determines the type of payment for which payment was made (Act 709). Then, the CPU 101 makes an inquiry to the store computer 20 via the communication controller 107 with the payment type for which payment has been made. Then, the magnification data corresponding to the payment type stored in the payment type master file 2103 is acquired, and the purchase points of the respective products calculated previously are multiplied by the magnification stored in correspondence with the payment type. (Act 710).

  Next, the CPU 101 stores the purchase points multiplied in Act 710 again in the product registration information buffer 1031 of the RAM 103 (Act 711).

  In Act 712, the CPU 101 executes a registration closing process. Next, the CPU 101 creates receipt data using the sales points, sales amounts, etc. of all the product registration information records stored in the product registration information buffer 1031 (Act 713), and controls the drive of the printer 107, The batch print of the print data saved in the print buffer of the RAM 103 is performed on the receipt paper, and a receipt is issued (Act 714).

  Next, the CPU 101 transfers the sales data (name of each product, number of sales, sales price, points, etc.) of the current transaction stored in the product registration information buffer 1031 to the store computer 20 (Act 715). ), The information processing related to the commercial transaction with the one customer is terminated.

  Note that the store computer 20 acquires the data area of the points, amounts, and points of each product of the current transaction from the data transferred from the POS terminal 10. Then, as shown in FIG. 9, the points, amounts, points, etc. of each product transmitted from the POS terminal 10 for each transaction are sequentially stored in the sales file 2104.

  Next, the point totaling process executed by the CPU 201 of the store computer 20 will be described with reference to FIG.

  The CPU 201 of the store computer 20 retrieves all transaction data in which the date to be counted is stored from the sales file 2104 in which the sales data transmitted from each POS terminal 10 is accumulated (Act 1001).

  The CPU 201 extracts the sales points, sales amounts, and purchase points of the products associated with the same product code included in each transaction data from all the transaction data associated with the dates to be counted (Act 1002). Then, the sales points, sales amounts, and purchase points corresponding to the extracted same product code are added together. The number of sales points, the sales price, and the purchase points corresponding to the combined product code are stored for each product in a predetermined data area of the point master file 2105 (FIG. 6) (Act 1003).

  Next, the CPU 201 determines whether or not sales points, sales amounts, and purchase points have been extracted for all product codes included in all transaction data associated with dates to be counted (Act 1004). ). If it is determined that all product codes have not been aggregated (N in Act 1004), the process returns to Act 1002 again, and the sales points, sales amounts, and purchase points corresponding to the product codes that have not yet been aggregated are extracted. The various sales information extracted is stored in the point master file 2105 (Act 1004, 1005).

  When the CPU 201 determines that various sales information has been extracted and stored for all product codes in Act 1004 (Y in Act 1004), the purchase points of the product codes associated with the same department code are added up. Then, purchase points for each department are calculated (Act 1005). The points calculated in Act 1005 are stored in the point master file 2105 (Act 1006).

  Then, the CPU 201 proceeds to Act 1007 and determines whether or not all department codes have been collected (Act 1007). If it is determined that tabulation has not been performed (N in Act 1007), the processing returns to Act 1005 again, and various sales information is extracted for the department code for which tabulation has not been performed, and points are calculated and stored. If it is determined in Act 1007 that all department codes have been aggregated (Y in Act 1007), the aggregation process is completed.

  In the point management system of this embodiment configured as described above, the data shown in FIGS. 4 and 5 are set in the product master file 2101 and the payment type master file 2103, respectively, and the commercial transaction shown in FIGS. The operation of the case will be described. And the effect | action of the total process performed in the store computer 20 is demonstrated using FIG.

  When the store clerk causes the card reader 110 to read the card data of the card presented by the customer, the card flag area of the RAM is set to “1”. Next, the store clerk inputs the product code and the sales number of the product purchased by the customer using the keyboard 108 and the scanner 109 of the POS terminal 10. Here, taking transaction 1 in FIG. 9 as an example, 2 items of product A, 5 items of product B, 1 item of product C, 4 items of product D, 3 points of product E, and 1 item of product F in one transaction Suppose that it was purchased.

  In this case, in the product registration information buffer 1031, as shown in FIG. 9, the product code (1), the product name (product A), the unit price (100 yen), the return rate (10%), the number of sales points (2 points), The sales amount (200 yen) and the product information record of the product-specific points (20) that are purchase points are stored. Similarly, for the products B, C, D, E, and F, the product information record of the product code, the product name, the unit price, the return rate, the number of sales, the sales price, and the point by product that is the purchase point corresponds to each type of information. Is remembered.

  As a result, sales data for one transaction is stored in the product information registration buffer 1031.

  Next, in the case of cash payment, the store clerk enters the deposit amount and operates the deposit / cash key on the keyboard 108, and according to the type of payment by “cash” set in the payment type master file 2104. The points stored in the product information registration buffer 1031 are multiplied by a magnification (in this case, 1 time). Then, the multiple points are finally stored in the product information registration buffer 1031. The transaction data stored in the merchandise information registration buffer 1031 is transmitted to the store computer 20 via the communication interface.

  Thereafter, when a new commercial transaction is performed, transaction data is sequentially stored in the commodity information registration buffer 1031 of the RAM 103 as the transaction 2 and is sequentially transmitted to the store computer 20 via the communication interface.

  The store computer 20 sequentially stores the transaction data transmitted from the POS terminal 10 in the sales file 2104. Then, for example, when a predetermined time comes after the end of the day's work, a search is executed to total the transaction data for that day stored in the sales file 2104. Then, all transaction data for the day is searched, and the purchase points generated in one day are executed for each product code from the entire transaction data. In this case, various pieces of information such as purchase points are extracted for each product code generated for each transaction, and the purchase points are added together for the same product extracted for each transaction. As a result, the point of one product generated in one day is calculated. For example, for product A, 20 points are generated in transaction 1 and 80 points are generated in transaction 2. The purchase of product A is the sum of these points generated in transaction 1 and transaction 2. Calculate as points.

    The store computer 20 executes point calculation processing for each product for all products. Thereafter, a purchase point calculation process is executed for each department.

  The purchase point calculation process of each department is calculated using the purchase points and the product code for each product calculated previously. That is, the product code belonging to the same department code is extracted with reference to the department code associated with the product code. Then, the purchase points of all the products belonging to the same department code are calculated by adding the purchase points stored in association with the extracted product codes.

  An example of the tabulated data tabulated as described above is the point master file 2105 in FIG. In the point master file 2105 of FIG. 11, the accumulated point “230” points associated with the product A associated with the department 1, the accumulated point “200” points associated with the product B, and associated with the product C. Accumulated points “250” are stored, respectively, and the accumulated points “680” of department 1 are stored in association with department 1 as purchase points of department 1 to which products A, B, and C belong. Similarly, the sales score “12 points”, the sales amount “2300 yen”, and the points “72” points generated by the sales of the product D are respectively tabulated and stored in association with the product D. Further, the sales score “12 points”, the sales amount “12,000 yen”, and the points “240” points generated by the sales of the product E are totaled and stored in association with the product E. Then, as a purchase point of the department 2 to which the products D and E belong, a point “312” points obtained by adding the points of the products D and E are stored in association with the department 2. Similarly, in other products and departments, product names and department names are stored in association with points.

  As described above, according to the present embodiment, the purchase points of the products generated for each product are accumulated and aggregated. Therefore, by comparing the purchase points for each product, which product is promoted by the purchase point. You can check if you are contributing.

  Further, not only the purchase points for each product are aggregated, but also the purchase points for each department based on the aggregated purchase points for each product, it is possible to grasp the purchase points between departments. This makes it possible to confirm which department contributes to sales promotion by giving purchase points.

  Although the embodiment of the present invention has been described, this embodiment is presented as an example and is not intended to limit the scope of the invention. The novel embodiment can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the scope of the invention. This embodiment is included in the scope and gist of the invention, and is also included in the invention described in the claims and the equivalent scope thereof.

  For example, the above-described totaling process does not necessarily have to be executed by the store computer 20. For example, the totaling process is executed by the CPU 101 of the POS terminal 10 based on sales data stored in the RAM 103 of the POS terminal 10. It may be.

    For example, in this embodiment, the store computer 20 side totals the purchase points for each product, and totals the purchase points for products belonging to the same department for each department, and calculates the purchase points for each product and the purchase points for each department. However, the purchase point of each product and the purchase point of each department may be calculated on the POS terminal 10 side.

    Further, the timing of aggregation is not necessarily performed on a daily basis, and for example, the point aggregation may be executed on a monthly basis.

10 POS terminal 101 CPU
102 ROM
103 RAM
1031 Product information registration buffer 1032 Product registration information number buffer 1033 Card flag area 20 Store computer 2101 Product master file 2102 Customer master file 2103 Payment type master file 2104 Sales file 2105 Point master file

Claims (3)

Input means for inputting product identification data;
A point return rate storage unit that stores a predetermined point return rate for each product;
Point calculation means for calculating purchase points of the product using a unit price of the product identified by the identification data input by the input means and a point return rate corresponding to the identified product;
A first storage unit that stores at least product information that identifies a product for which a transaction has been performed, a unit price of the product, the number of transactions of the product, and a calculated purchase point corresponding to the product;
For transactions conducted during a given period, a counting unit that counts the purchase points for each product,
A second storage unit that stores the collected purchase points for each product in association with at least the corresponding product information and the number of sales points;
A point management system characterized by comprising: The first storage unit stores the department information for identifying the group to which the product belongs in association with the product information, the unit price, the number of transactions, and the calculated purchase points for each product.
The tabulation unit tabulates the purchase points for each of the department information for the transactions performed during the predetermined period, and the department information, product information related to the department information, unit price, number of transactions, purchase points for each product 2. The point management system according to claim 1, wherein the total purchase points for each department are associated and stored in the second storage unit. For each transaction, product information that identifies the product for which the transaction was made, unit price of the product, the number of transactions for the product, department information that identifies the group to which the product belongs, and purchase points granted for the transaction of the product A first storage unit for storing
For a transaction performed in a predetermined period, based on the product information and the department information, a totaling unit that totals purchase points by product and purchase points by department;
At least the department information, the product information related to the department information, the unit price, the number of transactions, the purchase points by product and the purchase points by department so that the purchase points by product and purchase points by department can be viewed simultaneously. A second storage unit that stores
A point management system characterized by comprising:

Images