JP3927749B2 - Product sales data processing device - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a merchandise sales data processing apparatus formed so that merchandise registration is possible using acquired merchandise data while acquiring merchandise data corresponding to a merchandise code input with reference to a merchandise file.
[0002]
[Prior art]
For example, an electronic cash register type merchandise sales data processing apparatus has a merchandise registration function, an accounting process function, and the like.
[0003]
In the product registration function, when an operator inputs a product code using a data input means (scanner, keyboard, etc.), the control unit refers to the product file and stores product data (product name, unit price, etc.) corresponding to the input product code. Sales data including the number acquired and keyed as necessary is stored (product registration) in the sales file.
[0004]
When the product registration is completed for all of the products purchased by the customer, the closing operation as one transaction end declaration is performed using the closing key on the keyboard. If necessary, credit card data is read and input by a card reader, and in the case of cash settlement, the deposit amount is keyed.
[0005]
Thus, the control unit performs accounting processing including calculation of the total amount, change amount, and the like. Transaction data including accounting data relating to this is displayed on a display, printed on receipt paper, and later issued as a receipt. The drawer is automatically opened. Thereafter, the receipt is handed over to the customer along with the change. The customer will be checked out.
[0006]
By the way, many stores have introduced services that sell to members (regular customers) at a discounted price. This is in order to retain customers and increase sales by so-called differentiation.
[0007]
This discount stores the customer rank and discount rate in correspondence, calculates the discount amount by multiplying the total amount by the discount rate corresponding to the customer rank of the customer (member), and calculates the calculated discount amount from the total amount. It is executed by subtracting.
[0008]
However, with this discount method, if the customer rank is the same for products with different ratios between cost and selling price (products with different profit margins), the discount amount (discount rate) is treated as constant (same). It is pointed out that the unit price cannot be accurately reflected in the discount amount.
[0009]
Therefore, for example, as shown in FIG. 6, the unit price for each product (“product code”, “product name”) is set and stored in the product file 13 MFP in correspondence with each of a plurality of customer ranks (rank codes), and product registration is performed. At the time, the customer file (not shown) is referred to, the rank code (for example, “3”) corresponding to the customer (member number... Member code) is read and the product file 13 MFP is referred to for the product (for example, the product name). ... Service unit price ("3") corresponding to the rank code ("3") from a plurality of unit prices (for example, "50", "40", "30", "20", "10" yen) “30” yen).
[0010]
The service unit price (for example, “30”) in FIG. 6 is a discounted unit price and is configured to be directly searchable. However, the discount amount is obtained by multiplying the unit price by the discount rate for each rank code. A discount process for each product and each customer rank may be executed by a method of calculating a service unit price by subtracting the discount amount from the unit price.
[0011]
[Problems to be solved by the invention]
However, as the types of sales target products tend to increase, the number of target products for which discount processing is performed for each product and for each customer rank is increased, and further subdivision of customer rank is promoted, as shown in FIG. Product file 13 The memory capacity of the MFP has greatly increased, and search speed reduction, device enlargement, and maintenance difficulty have become apparent.
[0012]
An object of the present invention is to provide a merchandise sales data processing apparatus capable of quickly and accurately performing discount sales differentiated for each merchandise and for each customer rank.
[0013]
[Means for Solving the Problems]
The invention of claim 1 is a product sales data processing apparatus formed so as to be able to register products using acquired product data while acquiring product data corresponding to a product code input with reference to a product file. A selling price table capable of setting and storing a selling price code for each product and a customer file capable of setting and storing a rank code for each customer, and setting and storing a selling price rate determined from the selling price code and the rank code; and the product file A selling price code reading means capable of reading a selling price code corresponding to a product code inputted by reference, a rank code reading means capable of reading a rank code corresponding to a customer code inputted by referring to a customer file, and a selling price The selling price that can extract the selling price corresponding to the reading selling price code and the reading rank code with reference to the table Instead of the unit price included in the acquired product data, the service unit price calculating unit capable of calculating the service unit price of the product for the customer by multiplying the unit price included in the acquired product data and the extracted selling price rate. Using the service unit price calculated by the service unit price calculation means, the product registration can be executed, and the customer code input at the time of customer registration can be saved in the first work area and the input can be performed while referring to the customer file. Product name and unit price corresponding to the product code which is formed so that the customer name and rank code corresponding to the customer code can be transferred to the second work area and the third work area and is referred to the product file when registering the product. And sales price can be transferred to work area 4, work area 6, and work area 6. Wherein a sales price rate extracting unit while referring to the third work area value and the sale price rates extractable in products formed sales data processing apparatus corresponding to the value of the sixth work area the selling price table.
[0022]
In this invention, the sales price code reading means reads the sales price code corresponding to the product code input with reference to the product file. The rank code reading means reads a rank code corresponding to the customer code input with reference to the customer file. Then, the selling price extraction means extracts the selling price rate corresponding to the reading selling price code and the reading rank code with reference to the selling price table.
[0023]
Thereafter, the service unit price calculation means calculates the service unit price of the product for the customer by multiplying the unit price included in the acquired product data by the extracted selling price rate. Thus, the product registration can be executed using the service unit price calculated by the service unit price calculation means instead of the unit price included in the acquired product data.
[0024]
Therefore, in addition to being able to achieve the same operational effects as in the case of the inventions of claims 1 and 2, the service unit price can be calculated fully automatically only by inputting the same product code as in the case of normal product registration. Product registration is possible and handling is easy.
[0025]
Further , the customer code input at the time of customer registration can be saved in the first work area, and the customer name and rank code corresponding to the input customer code are transferred to the second work area and the third work area while referring to the customer file. The product name, the unit price, and the selling price code corresponding to the product code input while referring to the product file at the time of product registration can be transferred to the fourth work area, the fifth work area, and the sixth work area. The product sales data processing device is formed so that the selling price extraction means can extract the selling price corresponding to the value of the third work area and the value of the sixth work area while referring to the selling price table.
[0026]
Further, at the time of customer registration, the input customer code is saved in the first work area, and the customer name and rank code corresponding to the input customer code are referred to in the second work area and the third work area while referring to the customer file. Each is forwarded. In addition, when registering a product, the product name, unit price, and selling price code corresponding to the product code input with reference to the product file are transferred to the fourth work area, the fifth work area, and the sixth work area, respectively.
[0027]
Then, the selling price extraction means extracts selling prices corresponding to the value of the third work area (rank code) and the value of the sixth work area (selling price code) while referring to the selling price table. Hereinafter, the service unit price is calculated using the extracted selling price rate.
[0028]
Therefore, the process can be further simplified and speeded up.
[0029]
Furthermore, the invention of claim 2 is a merchandise sales data processing apparatus in which the customer code saved in the first work area and the customer name transferred and stored in the second work area are printed on a receipt. is there.
[0030]
In this invention, since the customer code saved in the first work area and the customer name transferred and stored in the second work area are printed on the receipt, the same effect as in the case of the invention of claim 1 can be obtained. In addition to being able to do so, it can further enhance customer satisfaction.
[0031]
Further, the invention of claim 3 is the same as the customer code saved in the first work area of the customer file with the number of sales and the sales amount relating to the one transaction when the declaration of the end of one transaction is made. This is a merchandise sales data processing device formed so as to be accumulatively stored in correspondence with a customer code.
[0032]
In such an invention, when one transaction end declaration is made, the number of sales points and the sales amount related to the one transaction are made to correspond to the same customer code as the customer code saved in the first work area of the customer file. Cumulatively stored.
[0033]
Therefore, in addition to the same operational effects as those of the inventions of claims 1 and 2 , customer management using the customer file can be performed accurately.
[0034]
DETAILED DESCRIPTION OF THE INVENTION
Embodiments of the present invention will be described below with reference to the drawings.
[0035]
As shown in FIG. 1, the present product sales data processing apparatus has an electronic cash register 10 as a basic structure, a product file 13MF shown in FIG. 3 can set and store a sales price code for each product, and a customer file 13CF is stored for each customer. The rank code can be set and stored, the selling price table 13PT, the selling price reading means (11, 12), the ranking code reading means (11, 12), the selling price extraction means (11, 12), and the service unit price. The calculation unit (11, 12) is provided, and is calculated by the service unit price calculation unit (11, 12) instead of the unit price included in the product data obtained by referring to the product file 13MF and corresponding to the product code. It is formed so that product registration can be executed using the service unit price.
[0036]
In FIG. 1, an electronic cash register 10 includes a CPU 11, a ROM 12, a RAM 13, a keyboard 14 (keyboard controller 14C), a card reader 15 (card reader controller), a display 16 (display controller 16C / display buffer register 16R), a printer 17 ( The printer controller 17C, the print editing buffer register 17R), a scanner (not shown), the automatic opening type drawer 19 shown in FIG. The external appearance is as shown in FIG. 2, and 10B is a cash register body.
[0037]
The RAM 13 is provided with an integrated file 13F in which a product file (PLU area) 13MF, a customer file (customer area) 13CF, and a selling price table (matrix) 13PT shown in FIG.
[0038]
The product file 13MF includes a product code column, a product name column, a unit price column, a sales price code column, a sales point column, and a sales amount column, and the customer file 13CF has a customer code column, a customer name column, a unit price column, and a rank code. Column, sales point column and sales amount column are provided.
[0039]
In the selling price table 13PT, the vertical axis direction is a rank code (for example, ranks 1, 2, 3,...) And the horizontal axis direction is a selling price code (for example, selling prices 1, 2, 3,...). The selling price rate [100 (%)] determined by the rank code (for example, rank 1) and the selling price code (for example, selling price 3) can be extracted. A first work area WK1 to a sixth work area WK6 are provided on the upper side of the selling price table 13PT.
[0040]
Here, a setting mode is selected by key operation on the keyboard 14 (YES in ST10 in FIG. 4, YES in ST20), and PLU (product data) setting is performed (YES in ST21). That is, in the product file 13MF shown in FIG. 3, a product code (for example, “123456”), a product name (for example, “AAA”), a unit price (for example, “50 yen”), a sales code (for example, “sale price 2”). ) Is stored (ST211).
[0041]
Similarly, customer settings are made (YES in ST22). That is, a product code, a customer name, and a rank code (for example, “rank 2”) are set and stored in the customer file 13CF shown in FIG. 3 (ST221).
[0042]
Registration mode is selected (YES in ST30 in FIG. 4), and before product registration, customer registration (YES in ST301 in FIG. 5), PLU registration (YES in ST302), and closing registration (YES in ST303) are performed.
[0043]
In the customer registration, the customer code (member code) entered by referring to the customer file (customer area) 13CF (ST3011) is registered (saved) in the first work area WK1 (ST3012). The customer name and rank code (“rank 2”) corresponding to the customer code are transferred to second work area WK2 and third work area WK3 (ST3013). At this time, the customer code and the customer name are printed on the receipt head by the printer 17.
[0044]
The product (PLU) registration refers to the product name (“AAA”), unit price (“” corresponding to the product code (for example, “123456”) read and input by the scanner while referring to the product file (PLU area) 13MF (ST3021). 50 yen ") and the selling price code (" selling price 2 ") are transferred to the fourth work area WK4, the fifth work area WK5 and the sixth work area WK6, respectively (ST3022).
[0045]
That is, the selling price code reading means (CPU 11, ROM 12) reads the selling price code (“sales price 2”) corresponding to the merchandise code (“123456”) input with reference to the merchandise file 13MF.
[0046]
Further, the rank code reading means (CPU 11, ROM 12) reads the rank code (“rank 2”) corresponding to the customer code input with reference to the customer file 13CF.
[0047]
The selling price extraction means (CPU 11, ROM 12) refers to the selling price table 13PT capable of setting and storing the selling price rate (for example, “90”) determined from the selling price code (“sales price 2”) and the rank code (“rank 2”). Thus, the selling price rate (“90”) corresponding to the reading selling price code (“selling price 2”) and the reading rank code (“rank 2”) can be extracted (ST3023).
[0048]
In this embodiment, the selling price rate (“90”) is a matrix in which the third work area WK3 (rank code... “Rank 2”) and the sixth work area WK6 (sell price code... Selling price 2) shown in FIG. ) Can be extracted.
[0049]
The service unit price calculation means (CPU 11, ROM 12) extracts the unit price (the fifth work area WK5... "50 yen") included in the product data (product name, unit price) acquired as corresponding to the input product code. By multiplying the selling price rate [“90” (%)], the service unit price (45 yen = 50 × 0.9) of the product (for example, “AAA”) for the customer is calculated (ST3024).
[0050]
Then, the control unit (CPU 11, ROM 12) uses the service unit price (45 yen) calculated by the service unit price calculation means (11, 12) instead of the unit price (50 yen) included in the acquired product data to register the product ( Memory processing) is executed (ST3024). This unit price is displayed on the display 16 and printed on receipt paper by the printer 17.
[0051]
When closing registration (YES in ST303) is requested, the cumulative storage control means (CPU 11, ROM 12) causes the sales point column and the sales amount of the customer file (customer area) 13CF corresponding to the first work area WK1 (customer code). In the column, the sales score and sales amount of the transaction are respectively added (accumulated storage) (ST3031).
[0052]
Further, the store visit count control means (CPU 11, ROM 12) adds the store visit count to a counter memory (not shown) (N = N + 1) (ST3032).
[0053]
Thus, in the embodiment of such a configuration, the selling price code (for example, “selling price 2”) corresponding to the input product code and the matrix (13PT) of the configuration capable of extracting the selling price rate from the selling price code and the rank code are referred to. The selling price rate (“90”%) of the product is extracted from the rank code (for example, “rank 2”) corresponding to the input customer code (ST3023 in FIG. 5).
[0054]
Then, using the unit price (“50” yen) included in the product data acquired as corresponding to the product code and the selling price (“90”... “0.9”) extracted with reference to the matrix. Calculate the service unit price (“45” yen) and execute product registration (ST3024) using the service unit price (“45” yen) calculated instead of the unit price (“50” yen) included in the acquired product data To do.
[0055]
Accordingly, it is possible to quickly and accurately carry out discount sales differentiated for each product and each customer rank while eliminating slowing down of the search, enlargement of the apparatus and difficulty of maintenance, and wide applicability to store conditions.
[0056]
The selling price rate is not limited to a value (%) calculated by multiplying the acquisition unit price (“50” yen) by the discounted unit price [service unit price (“45” yen)], but the acquisition unit price (“50”). The discounted amount (“5” yen) may be calculated (“10”%) by multiplying by “yen), or the discount amount itself (“ 5 ”yen) may be used. As a result, it is only necessary to obtain a discount amount (“5” yen) and / or a discounted selling price (“45” yen) for each product and for each customer rank.
[0057]
Further, by simply setting and changing the selling price rate determined from the selling price code and the rank code stored in the selling price table 13PT, the selling price code and the rank for each customer set and stored in the customer file 13CF are set for each product stored in the product file 13MF. Even if the code is left as it is, it is possible to change the service unit price for each product and each customer rank.
[0058]
The selling price code reading means (11, 12) reads the selling price code corresponding to the input product code with reference to the product file 13MF. The rank code reader (11, 12) stage reads the rank code corresponding to the input customer code with reference to the customer file 13CF. Then, the selling price rate extraction means (11, 12) refers to the selling price table 13PT and extracts the selling price rate corresponding to the reading selling price code and the reading rank code. Thereafter, the service unit price calculation means (11, 12) multiplies the unit price included in the acquired product data by the extracted selling price rate to calculate the service unit price of the product for the customer.
[0059]
Thus, the product registration can be executed using the service unit price calculated by the service unit price calculation means instead of the unit price included in the acquired product data. In addition, since the service unit price can be calculated and the product can be registered automatically by simply inputting the same product code as in the case of normal product registration, handling is easy.
[0060]
Further, at the time of customer registration, the input customer code is saved in the first work area WK1, and the customer name and rank code corresponding to the input customer code are referred to the second work area WK2 and the third work area WK3 while referring to the customer file 13CF. (ST3013 in FIG. 5). When registering the product, the product name, unit price and selling price code corresponding to the input product code are transferred to the fourth work area WK4, the fifth work area WK5 and the sixth work area WK6 while referring to the product file 13MF (ST3022). Is done.
[0061]
Then, the selling price extraction means (11, 12) extracts the selling price corresponding to the value of the third work area WK3 (rank code) and the value of the sixth work area WK6 (selling price code) while referring to the selling price table 13PT. (ST3023). Thereafter, a service unit price is calculated using the extracted selling price rate (ST3024). Therefore, the process can be simplified and speeded up.
[0062]
Furthermore, since the customer code saved in the first work area WK1 and the customer name transferred and stored in the second work area WK2 are formed so as to be printed on a receipt by the printer 17, customer satisfaction can be promoted.
[0063]
Furthermore, when one transaction end declaration is made, the number of sales and the sales amount related to the one transaction correspond to the same customer code as the customer code saved in the first work area WK1 of the customer file 13CF. Cumulatively stored. Therefore, customer management using the customer file 13CF can be performed accurately.
[0064]
In the above embodiment, the case where the integrated file 13F (product file 13MF, customer file 13CF, selling price table 13PT) and the like are provided in each electronic cash register 10 has been described. However, each electronic cash register 10 and a data communication line (for example, In a merchandise sales data processing apparatus (system) connected to a local area network (LAN) and configured as a host machine (for example, a store controller or a file processor) that can collectively manage each electronic cash register 10, an integrated file 13F (commodity file 13MF, customer The file 13CF, the selling price table 13PT), etc. may be provided on the host machine side and formed so as to be shared by each electronic cash register 10. The present invention is applied also in this case.
[0065]
【The invention's effect】
According to the present invention, product file is set storable and customer file the sales price codes for each product are set storable form a rank code for each customer, and selling price table, a sales price code reading means, rank codes A reading unit, a selling price extraction unit, and a service unit price calculation unit are provided, and product registration can be executed using the service unit price calculated by the service unit price calculation unit instead of the unit price included in the acquired product data. Since it is a merchandise sales data processing apparatus, in addition to being able to achieve the same effects as those of the inventions of claims 1 and 2, in addition, in the case of normal merchandise registration, it is fully automatic simply by entering the same merchandise code. Service unit price can be calculated and products can be registered, and handling is easy.
[0068]
Further , the customer name and rank code corresponding to the input customer code can be transferred to the second work area and the third work area while saving the input customer code in the first work area at the time of customer registration and referring to the customer file. The product name, unit price, and selling price code corresponding to the input product code can be transferred to the fourth work area, the fifth work area, and the sixth work area while referring to the product file at the time of product registration, and the selling price extraction means is the selling price table. Since the selling price rate corresponding to the value of the third work area and the value of the sixth work area can be extracted while referring to the above, the same effect as in the case of the invention of claim 3 can be obtained. In addition, the processing can be simplified and speeded up.
[0069]
Further, according to the invention of claim 2 , since the customer code saved in the first work area and the customer name transferred and stored in the second work area are printed on the receipt, the same as in the case of the invention of claim 1. In addition to being able to achieve a positive effect, it can further enhance customer satisfaction.
[0070]
Furthermore, according to the invention of claim 3 , when a transaction end declaration is made, the sales score and the sales amount related to the transaction are the same as the customer code saved in the first work area of the customer file. Since it can be accumulated and stored in correspondence with the customer code, the same effects as those of the inventions of claims 4 and 5 can be obtained, and further customer management using the customer file can be performed accurately. Can be done.
[Brief description of the drawings]
FIG. 1 is a block diagram showing an embodiment of the present invention.
FIG. 2 is an external perspective view of the same.
FIG. 3 is a diagram for explaining a product file, a customer file, a selling price table, and the like.
FIG. 4 is a flowchart for explaining the setting operation in the same manner.
FIG. 5 is a flowchart for explaining a registration operation in the same manner.
FIG. 6 is a diagram for explaining a conventional product file.
[Explanation of symbols]
10 Electronic cash register (product sales data processing device)
11 CPU (sales price code reading means, rank code reading means, selling price extraction means, service unit price calculation means)
12 ROM (sales price code reading means, rank code reading means, selling price extraction means, service unit price calculation means)
13 RAM
13F Integrated file 13MF Product file 13CF Customer file 13PT Price table (matrix)
WK1 to WK6 1st work area to 6th work area 14 Keyboard 16 Display 17 Printer

Claims (3)

In the product sales data processing apparatus configured to be able to register a product using the acquired product data while acquiring the product data corresponding to the product code input with reference to the product file, the product file is a sales price code for each product. And a customer file is formed so that a rank code for each customer can be set and stored, and a selling price table in which a selling price determined from the selling price code and the rank code can be set and stored, and a product input with reference to the product file The selling price code reading means capable of reading the selling price code corresponding to the code, the rank code reading means capable of reading the rank code corresponding to the customer code inputted by referring to the customer file, and the reading selling price referring to the selling price table A selling price extraction means capable of extracting a selling price rate corresponding to a code and a reading rank code; A service unit price calculating means capable of calculating a service unit price of the product for the customer by multiplying the unit price included in the acquired product data and the extracted selling price rate, and a service unit price calculating means instead of the unit price included in the acquired product data. A customer who is configured to execute the product registration using the calculated service unit price, can save the customer code input at the time of customer registration in the first work area, and corresponds to the input customer code while referring to the customer file The name and rank code are formed so as to be transferred to the second work area and the third work area, and the product name, unit price and selling price code corresponding to the product code inputted while referring to the product file at the time of product registration are the fourth. Transferable to work area, work area 5 and work area 6 and the selling price extraction Means while referring to the third working area values and extractable-formed by being merchandise sales data processing apparatus the selling price rate that corresponds to the value of the sixth work area the selling price table. The merchandise sales data processing apparatus according to claim 1, wherein the customer code saved in the first work area and the customer name transferred and stored in the second work area are printed on a receipt. When one transaction end declaration is made, the sales score and sales amount related to the one transaction can be accumulated and stored in correspondence with the same customer code as the customer code saved in the first work area of the customer file. The merchandise sales data processing apparatus according to claim 1 or 2 , wherein the merchandise sales data processing apparatus is formed.

Images