JP4971894B2 - Product sales data processing device - Google Patents

Description

  The present invention relates to a product sales data processing apparatus that executes product sales data processing based on an input product code.

  In recent years, a marketing method called FSP (Frequent Shoppers Program: utilization of customer-identified purchase trend information) has become widespread in retail and service industries. With this FSP, customer cards such as point cards and service provision cards are issued and the purchase data of individual customers are collected. The customers are selected according to the purchase amount and the frequency of visits. It is a marketing method that aims to maintain and expand high-quality customers by providing the most suitable service to customers and developing efficient sales strategies.

  In this FSP, customer basic information is acquired by issuing customer cards such as point cards and service provision cards, and the purchase history is stored in the database every time the customer uses the store. It is basic in doing. For example, customer service functions such as provision at a preferential price according to the customer stage executed by the customer management server described in Patent Document 1, point promotion, and promotional receipt promotion based on the customer's purchase history are provided in the FSP. An important function is exhibited (see paragraph number 0033 of Patent Document 1).

Japanese Patent Laid-Open No. 2004-326662

  By executing FSP using the customer management system and customer master management method disclosed in Patent Document 1, data useful for various service provisions and sales strategies is accumulated. As a method of developing an efficient sales strategy while using this accumulated data to provide the most suitable service for each customer, it is set as a preferential product that offers products that the store wants to promote at a discounted unit price. However, by selling preferential products at a discounted unit price to excellent customers determined by the FSP, a predetermined product is sold with priority. In this case, a preferential rank that rises every time a product is purchased is set for each customer, and the customer can purchase a preferential product determined for each preferential rank at a discounted unit price. The customer is set to a higher-ranking preferential rank by purchasing a product, and the merit that a preferential product can be purchased at a discounted unit price according to the preferential rank is obtained.

  However, preferential products are set uniformly without distinction for each customer. Therefore, depending on the customer, there are cases where the purchased product that is usually purchased does not match the preferential product that the store wants to sell. In this case, the customer is not motivated to purchase the preferential product, and the customer cannot be expected to purchase the preferential product in a focused manner. On the other hand, if many types are set as preferential products in order to meet the tastes of many customers, the number of types of products whose prices are discounted becomes too large, and the profits that the store can obtain will decrease. End up.

  As an example, for a customer A who usually purchases products centering on cosmetics, setting only cosmetics as a preferential product is sufficient as a sales promotion strategy performed by the store. However, when only cosmetics are set as preferential products, the same preferential rank as customer A is set, and customer B who usually purchases products centered on beer has the same preferential rank as customer A. It is hard to receive. And in order to give customer B the same profit as customer A, beer can be set as a special product, but this will expand the range of products that are special products, and cosmetics that the store wants to do. A sales strategy that focuses on selling ceases to function.

  An object of the present invention is to discount a product unit price in accordance with a product purchase tendency of each customer.

Means for solving the above-described problems in the present invention include a product code input unit for inputting a product code for specifying a product, a customer ID input unit for inputting a customer ID for specifying a customer, and a product code. A product unit price corresponding to the product code input by the product code input unit is obtained by searching a PLU file that stores the product unit price in association with the product code, and includes the input product code and the acquired product unit price. A merchandise sales data process for storing merchandise information in the merchandise information storage section is executed for each transaction, a means for executing a settlement process based on the merchandise information stored in the merchandise information storage section, and a discount associated with the customer ID Search for the first data file storing discount application information indicating whether to apply or not, and apply the discount application information corresponding to the customer ID input by the customer ID input unit. It means for Tokusuru customer classification by searching the second data file for storing customer classification code classified according to the attributes of the customer in association with the customer ID corresponding to the client ID entered by the customer ID input unit When it is determined that the discount application information acquired by the means for executing the customer classification code acquisition process for acquiring the code and the means for acquiring the discount application information corresponding to the customer ID indicates that the discount is applied, Referring to a third data file that stores a discount product code group consisting of one or more product codes to be discounted in association with a customer classification code, the product code input by the product code input unit is the customer If it is determined that it is included in the discount product code group corresponding to the customer classification code acquired by the classification code acquisition process, A merchandise sales data processing apparatus comprising means for performing the discounting process a unit price to get in the merchandise sales data process corresponding to the commodity code, the.

  According to the present invention, when a customer ID specifying a customer is input, a discount product code group corresponding to the customer ID is acquired, and the input product code is included in the acquired discount product code group Since the product unit price of the product corresponding to the product code is discounted, the product unit price can be discounted according to the product purchase tendency of each customer.

  An embodiment of the present invention will be described with reference to FIGS.

  FIG. 1 is a schematic diagram showing an example of checkout performed in the merchandise sales data processing system of the present embodiment.

  The customer goes to the checkout counter where the cashier is waiting along with the item he wants to purchase. The cashier performs merchandise transactions with the customer by registering merchandise that the customer plans to purchase in the POS terminal 101 (merchandise sales data processing device). At this time, the customer presents the receipt RT received at the previous visit to the cashier. On the receipt RT, a barcode SB is printed as a code symbol in which a customer ID for identifying the customer is symbolized. The cashier receives the receipt RT presented by the customer, and reads the barcode SB printed on the receipt RT using the barcode reader 111 as a customer ID input unit. In the merchandise sales data processing system of the present embodiment, the customer ID is stored in the receipt RT. However, as a medium for storing the customer ID, the customer ID is electromagnetically stored in a magnetic tape attached to a plastic card. Alternatively, it may be stored as data in an IC chip or an RFID tag embedded in a plastic card.

  When the customer ID is input by the bar code reader 111 as the customer ID input unit, the POS terminal 101 searches the customer master file 254a and searches for the category code and the preferential rank as the customer classification code corresponding to the input customer ID. To get.

  The category code is a code given to a customer in order to classify the customer based on a predetermined standard based on the customer's past purchase history specified by the customer ID and information about the customer (age, gender, time of visit, etc.) It is. As an example, the customer's past purchase history is stored in the store controller 51 via the network line 61 as merchandise information and money transaction information that the cashier registers in the POS terminal 101 when the customer visits the store and purchases the product. Database. The customer's past purchase history may be transmitted from the store controller 51 to the headquarter server 31 through the wide area network 21 and stored in the headquarter server 31 to form a database. In addition, as an example, the customer-related information is input by the cashier from the POS terminal 101, the store controller 51, or a member registration dedicated terminal (not shown), etc., for the customer's age and gender that the customer applies for when issuing a customer card. Alternatively, when the cashier issues a receipt RT or customer card in which the customer ID is recorded, the cashier determines the customer attribute from the customer appearance and inputs it from the keyboard 104 of the POS terminal 101. Good. The information about the customer input in this way is stored in the store controller 51 or stored in the headquarter server 31. The customer's past purchase history and customer information are all stored in association with a customer ID that identifies the customer. The store controller 51 and the headquarter server 31 that store the information classify the customers using various marketing techniques such as FSP based on the past sales history of the stored customers and information about the customers. As a result of the classification, a category code as a customer classification code is given to the customer ID. As a result, each customer ID is associated with a category defined by the category code.

  The preferential treatment rank indicates the degree of discount of the product unit price applied when the customer purchases the preferential product. Generally, a customer who purchases a lot of merchandise is given a high courtesy rank, and this courtesy rank increases as the customer purchases merchandise. With regard to the method of giving this preferential treatment rank to a customer, various marketing methods such as FSP are used, and the store controller 51 and the head office server 31 are assigned in association with the customer ID.

  The POS terminal 101 obtains a discount product code group corresponding to the category code obtained by searching the category setting file 254b after obtaining the category code and preferential rank corresponding to the input customer ID. The discount product code group includes one or more product codes. One or a plurality of product codes constituting a discount product code group specify a predetermined product provided at a discount price for a group of customers having a predetermined attribute classified by a category code as a preferential product It is. In the following description, the product codes constituting the discount product code group are referred to as “preferential product codes”.

  The cashier uses the bar code reader 111 to input the bar code of the product that the customer brought to the checkout counter. That is, the barcode reader 111 also functions as a product code input unit. When a product code is input by the barcode reader 111, the POS terminal 101 executes product sales data processing including search processing and product information registration processing. The search process is a process of searching for the product unit price file 254c as a PLU file that stores the product unit price in association with the product code, and obtaining the product unit price corresponding to the input product code. The product information registration process is a process of storing product information including the input product code and the acquired product unit price in the RAM 203 (see FIG. 4) as a product information storage unit. The POS terminal 101 executes merchandise sales data processing (see FIG. 8) for each transaction in which a merchandise code is input.

  The product unit price file 254c as a PLU file stores a discount unit price corresponding to a preferential rank for each product code, in addition to storing the product unit price in association with the product code. When the product code included in the product information matches the preferential product code, the POS terminal 101 determines that the product specified by the product code is a preferential product. If the POS terminal 101 determines that the product code matches the preferential product code, the POS terminal 101 executes processing for discounting the product unit price. In the example illustrated in FIG. 1, the POS terminal 101 searches the product unit price file 254c and acquires a discount unit price corresponding to the input product code and the obtained preferential rank, thereby setting a discount unit price. As another example, the discount on the product price may be performed by obtaining a discount amount obtained by multiplying the preferential rank by a predetermined amount and subtracting the discount amount from the product unit price.

  When the POS terminal 101 is designated by the keyboard 104 to indicate that the merchandise information for all the merchandise has been input, the POS terminal 101 performs a settlement process based on the merchandise information stored in the RAM 203 as the merchandise information storage unit. Execute. The POS terminal 101 enables various types of payment such as cash payment and credit card payment in the payment process. As processing subsequent to the settlement processing, the POS terminal 101 prints and issues a receipt RT to the customer. On the issued receipt RT, a barcode SB as a code symbol in which the customer ID is symbolized is printed. When the customer purchases a preferential product, information indicating that the discount has been applied due to the preferential product is also printed on the receipt RT.

  In the example of the transaction illustrated in FIG. 1, a barcode SB indicating that the customer ID is “P” is printed on the receipt RT that the customer presents to the cashier. This customer is given “1” as a category code and “2” as a preferential rank. The category code and the special treatment rank are set for each customer by using, for example, a marketing technique using FSP based on the past product purchase history of each customer and information related to the customer. Further, in the customer master file 254a, the category code = “1” and the preferential rank = “2” are stored in association with the customer ID = “P”. In the category setting file 254b, a discount product code group consisting of “cosmetic lipstick” and “lip balm” is defined in association with category code = “1”. That is, the category setting file 254b indicates that “cosmetic lipstick” and “lip balm” are provided as preferential products to customers who are categorized as category code = “1”. When this customer purchases “cosmetic lipstick” and “beer A”, the cashier uses the barcode reader 111 to input the barcode SB printed on the receipt RT presented by the customer. When “P” is input as the customer ID, the POS terminal 101 acquires “1” as the category code and “2” as the preferential rank from the customer master file 254a. Subsequently, the POS terminal 101 acquires a discount product code group including “cosmetic lipstick” and “lip balm” corresponding to the acquired category code (= “1”) from the category setting file 254b.

  When the product code of “cosmetic lipstick” that the customer plans to purchase is input to the POS terminal 101, the product code of “cosmetic lipstick” matches the acquired preferential product code. Therefore, the POS terminal 101 interprets “cosmetic lipstick” as a preferential product. Therefore, when the POS terminal 101 acquires the product unit price of “cosmetic lipstick” from the product unit price file 254c, it is not the product unit price (150 yen) when the preferential treatment rank is “no preferential treatment”, but the preferential treatment rank is “2”. The discount unit price (90 yen) is acquired, and the sales unit price of “cosmetic lipstick” is set to 90 yen.

  When the product code of “beer A” that the customer plans to purchase is input to the POS terminal 101, the product code of “beer A” does not match the acquired preferential product code. Therefore, the POS terminal 101 interprets “beer A” as a normal product to which no discount is applied. Therefore, when the POS terminal 101 acquires the product unit price of “beer A” from the product unit price file 254c, the POS terminal 101 acquires the product unit price (350 yen) when the preferential treatment rank is “applicable pear”, and the “beer A” The sales unit price of is set to 350 yen.

  The series of checkouts described above is realized by the merchandise sales data processing system of the present embodiment. In the following, the configuration of the POS terminal 101 and the store controller 51 constituting the product sales data processing system 11 and various information processing executed by the product sales data processing system 11 will be described.

  FIG. 2 is a schematic diagram schematically showing the system configuration of the merchandise sales data processing system. The merchandise sales data processing system 11 allows data communication between a plurality of POS terminals 101 as merchandise sales data processing apparatuses installed in a store and a single store controller 51 as a host machine via a network line 61. Connected and built. As an example, the POS terminal 101 is disposed at a cashier counter provided near the exit of a store, and the store controller 51 is disposed in a backyard different from the product sales space of the store. A network line 61 that connects the POS terminal 101 and the store controller 51 so that data communication is possible is a wired LAN or a wireless LAN. The network line 61 is connected to the headquarter server 31 via the wide area network 21 such as the Internet or CAFIS. The store controller 51 arranged in the store's backyard is connected to the headquarter server 31 via the network line 61 and the wide area network 21.

  FIG. 3 is a perspective view showing the POS terminal 101. The POS terminal 101 is placed on the drawer 102 and can control the opening operation of the drawer 103 of the drawer 102. A keyboard 104 and an operator display 105 are arranged on the right side of the upper surface of the POS terminal 101, and a receipt printer 106 is arranged on the left side of the upper surface. The receipt printer 106 prints and issues a receipt RT handed to the customer from the cashier. This receipt RT is issued in post-processing (see FIG. 8) performed at the time of completion of settlement and handed to the customer. A customer display 107 is erected on the rear of the top surface of the POS terminal 101. The operator display 105 and the customer display 107 function as an output unit that performs an information notification function to the operator.

  A touch panel 108 is stacked on the operator display 105. The touch panel 108 functions as an input unit for allowing an operator to input information according to the display content of the operator display 105. In FIG. 3, a groove provided in the vicinity of the right side surface of the POS terminal 101 is a card reading groove 110 for scanning a card in order to read card information by the card reader / writer 109 (see FIG. 4). . A bar code reader 111 is connected to such a POS terminal 101. The barcode reader 111 functions as a product code input unit for reading a barcode as a product code for identifying a product attached to the product, and also displays a customer ID symbolized and printed on the receipt RT. It also functions as a customer ID input unit for input. Further, an RFID reader / writer 111a for communicating with the RFID tag is also connected to the POS terminal 101. In addition to the keyboard 104 and the touch panel 108, various information can be input at the POS terminal 101 by the card reader / writer 109, the barcode reader 111, and the RFID reader / writer 111a. For example, when the customer ID is electromagnetically stored on a magnetic tape attached to a plastic card medium, the card reader / writer 109 functions as a customer ID input unit for inputting the customer ID. When the customer ID is stored as data in an RFID tag embedded in a plastic card medium, the RFID reader / writer 111a functions as a customer ID input unit. Further, although not shown, when the customer ID is stored as data in an IC chip embedded in a plastic card medium, the IC card reader / writer is connected to the POS terminal 101, and this IC card reader / writer is connected to the customer ID. It is also possible to function as an input unit.

  The POS terminal 101 also incorporates a communication interface 112 (see FIG. 4) for executing data communication with an external device via the network line 61.

  FIG. 4 is a block diagram showing a hardware configuration of the POS terminal 101. The POS terminal 101 includes a CPU 201 that executes various arithmetic processes and controls each unit. The CPU 201 is bus-connected to a ROM 202 that stores fixed data in a fixed manner, a RAM 203 that stores variable data in a rewritable manner and is used as a work area, an HDD 204, and a CD-ROM drive 205. The CPU 201, the ROM 202, and the RAM 203 constitute a microcomputer 206 as an information processing unit that executes information processing.

  The HDD 204 is installed with an operating system 251, a computer program 252 for product sales data processing for executing product sales data processing, a product data file 253, and the like. The product data file 253 includes various files such as a customer master file 254a, a category setting file 254b, and a product unit price file 254c. The customer master file 254a functions as a first data file, a third data file, and a fourth data file. The category setting file 254b functions as a second data file. The product unit price file 254c functions as a single data file. The customer master file 254a, the category setting file 254b, and the product unit price file 254c may be stored in the HDD 204 of the POS terminal 101 as shown in FIG. 4, for example, or as another example, the POS terminal 101. The CPU 201 may download the data from the store controller 51 or the headquarter server 31 and store it in the RAM 203 or the HDD 204 at the time of activation of the POS terminal 101 that is waiting for data reception. The data received by the POS terminal 101 may be stored in the RAM 203, the HDD 204, or the like. Further, without storing these files in the HDD 204, the data may be acquired by accessing the store controller 51 or the headquarter server 31 at the timing when the CPU 201 acquires the data. That is, the customer master file 254a, the category setting file 254b, and the product unit price file 254c may be stored in a location where the CPU 201 of the POS terminal 101 can access data.

  The drawer 102, keyboard 104, operator display 105, receipt printer 106, customer display 107, touch panel 108, card reader / writer 109, bar code reader 111, RFID reader / writer 111a, and communication interface 112 are all various. Are connected to the CPU 201 via the input / output circuit (all not shown), and the operation is controlled by the CPU 201.

  The operating system 251, computer program 252, and product data file 253 installed in the HDD 204 are recorded on the CD-ROM 205a as an example, read by the CD-ROM drive 205, and installed in the HDD 204. On the other hand, if the magnetic disk drive is connected to the CPU 201, the computer program 252 stored in the magnetic disk can be installed in the HDD 204, and if another type of optical media drive is connected to the CPU 201, The computer program 252 and the like stored in the optical media can be installed in the HDD 204. The same applies to USB memories, flash disks, and the like. Alternatively, if the communication interface 112 is connected to the CPU 201, for example, a computer program 252 downloaded from a higher-level machine such as the store controller 51 can be installed in the HDD 204.

  The operating system 251, the computer program 252, and the product data file 253 installed in the HDD 204 are used by being copied to the RAM 203 in whole or in part when the POS terminal 101 is activated. The CPU 201 executes processing according to the computer program 252 copied to the RAM 203. As another example, the product data file 253 is not installed in the HDD 204 but is stored and stored in a storage device (not shown) managed by the store controller 51, and the POS terminal 101 is connected via the network line 61. It may be constructed to obtain necessary data.

  Next, the store controller 51 will be described. As shown in FIG. 2, the store controller 51 has the form of a general server computer, and is configured by connecting a display 53, a keyboard 54, and a pointing device 55 to a tower-type controller 52. ing. The store controller 51 includes an HDD and a CD-ROM drive (both not shown) as storage devices. A CD-ROM tray 56 for mounting a CD-ROM is provided in the middle of the front of the controller 52. An operating system and a computer program for merchandise sales data processing are installed in an HDD (not shown). As an example, these operating system and computer program for merchandise sales data processing are stored and stored in a recording medium such as a CD-ROM, read by a CD-ROM drive, and installed in the HDD. As another example, an operating system, a computer program for processing product sales data, etc. may be downloaded from an external device via a network server (not shown) connected to the network line 61 and installed in the HDD.

  The store controller 51 includes a CPU as an information processing unit that executes various arithmetic processes and controls each unit. Various data stored in an HDD (not shown) is processed by this CPU. In order to speed up various processes executed by the CPU, all or a part of the operating system and product sales data processing program installed in the HDD are connected to the CPU via the bus line when the store controller 51 is started. Copied to the current RAM.

  FIG. 5 is a schematic diagram showing the data structure of the customer master file 254a. In the customer master file 254a, preferential ranks, preferential treatment applications, and category codes as customer classification codes are stored in association with customer IDs.

  The customer ID is given to each customer. As an example, the customer ID is generated when a customer purchases a product at a store, and is printed in the form of a barcode SB on a receipt RT printed and issued at the end of the checkout of the product, and is possessed by the customer. Then, when the customer visits the store next time, the receipt RT received last time is presented to the cashier, and the cashier reads the barcode SB printed on the presented receipt RT by using the barcode reader 111, whereby the customer The ID can be used continuously to identify the customer. As another example, the customer ID is given to the customer when the customer offers the store to create a membership card. In this case, the card medium in which the customer ID is recorded in the recording unit is generally handed over to the customer. As described above, a magnetic tape, an IC chip, an RFID tag, or the like can be used as the recording unit.

  The preferential treatment rank is an index indicating the degree of discount applied to the preferential product when the customer purchases the preferential product. As an example, the preferential rank is determined by a marketing technique such as FSP. More specifically, the preferential rank is analyzed by a marketing method such as FSP in the store controller 51 or the headquarter server 31 that accumulates the product information and money transaction information input to the POS terminal 101 as described above, and is analyzed for each customer. It is set in association with the ID. Generally, the customer rank increases as the customer purchases more products.

  Preferential treatment application serves as discount application information indicating whether or not to apply a discount for a special treatment product. More specifically, in the preferential treatment application, one of “1: application ant” and “0: application pear” is defined in association with the customer ID. When “1: application ant” is defined as the preferential treatment application, the POS terminal interprets that the customer specified by the customer ID adopts the discount unit price as the sales unit price when trying to purchase the preferential product. In addition, when “0: No applicable” is defined as the special treatment application, the POS terminal uses the normal price instead of the discount unit price when the customer specified by the customer ID attempts to purchase the special treatment product. Interpreted as hiring.

  The category code specifies a discount product code group composed of one or more product codes. For example, the category code is obtained by using a marketing technique such as FSP in the store controller 51 or the head office server 31 that accumulates customer purchase history and customer information transmitted from a terminal such as the POS terminal 101 as described above. It is set in association with the customer ID as a result of analysis of the customer's product preference, customer's gender, age group, visiting time zone, and the like. Hereinafter, the category code will be described in more detail.

  FIG. 6 is a schematic diagram showing the data structure of the category setting file 254b. The category setting file 254b stores a discount product code group composed of one or more product codes in association with the category codes described above with reference to FIG. As an example, as shown in FIG. 6, the category setting file 254b stores a category code “1” and a discount product code group composed of product codes that specify “cosmetic lipstick” in association with each other. . Similarly, as shown in FIG. 6, the category setting file 254b associates a category code “2” with a discount product code group composed of product codes that specify “cosmetic lipstick” and “soap”. I remember it.

  For example, the discount product code group is determined by a marketing technique such as FSP. For example, if the correspondence between customer-related attributes and product sales trends is analyzed on the basis of data on customer purchase history stored in the headquarters server 31 installed in the store headquarters, the store headquarters Based on the analysis result, a category code is assigned to a group of customers having a predetermined attribute, and a discount product code group corresponding to the category code is set. As a more specific example, data analysis in data mining shows that customers with the attributes of “late teens” and “female” tend to purchase a lot of cosmetic-related products. When the headquarters conducts a sales strategy to sell cosmetics related products of a given brand to customers who are “late teens” and “women”, for customers with the attributes “late teens” and “female” “2” is assigned as the category code, and a discount product code group including “cosmetic lipstick” and “soap” is defined in association with the category code “2” in the category setting file 254b.

  FIG. 7 is a schematic diagram showing the data structure of the product unit price file 254c. The product unit price file 254c stores a product name and a product unit price in association with the product code. Further, the product unit price file 254c stores a discount unit price as a result of discounting according to the preferential rank in association with the product code. In the example shown in FIG. 7, the product unit price file 254c stores the product unit price “150 yen” in association with the product code indicating “cosmetic lipstick”, and further, the discount unit price “1” when the preferential rank is “1”. 100 yen ”, and a discount unit price“ 90 yen ”when the preferential rank is“ 2 ”are stored.

  In the merchandise sales data processing system constructed as described above, the CPU 201 as the information processing unit included in the POS terminal 101 executes various types of information processing. The merchandise transaction with the customer using the POS terminal 101 performed by the cashier is realized by the checkout process executed by the CPU 201 of the POS terminal 101. In addition, various information regarding discount application for each customer is acquired by the customer information acquisition process and the group acquisition process executed by the CPU 201 of the POS terminal 101. Further, the sale of products at a discount unit price suitable for each customer is realized by the discount unit price setting process executed by the CPU 201 of the POS terminal 101.

  FIG. 8 is a flowchart showing the flow of checkout processing executed by the CPU 201 of the POS terminal 101. The CPU 201 of the POS terminal 101 is on standby for determining whether or not a product code has been input while the POS terminal 101 is activated (step S11). The product code is input by reading the bar code by the bar code reader 111 or by an input operation on the keyboard 104 or the touch panel 108 in accordance with the display on the operator display 105.

  When the CPU 201 of the POS terminal 101 determines the input of the product code (Y in step S11), the CPU 201 executes a search process (step S12). The search process is a process of searching for the product unit price file 254c and acquiring a product unit price corresponding to the input product code. The CPU 201 of the POS terminal 101 temporarily stores the acquired product unit price in the RAM 203.

  CPU201 of POS terminal 101 performs merchandise information registration processing following search processing (Step S13). The product information registration process is a process of storing product information including the input product code and the product unit price corresponding to the product code in the RAM 203.

  The CPU 201 of the POS terminal 101 receives a payment designation input from the keyboard 104 or the touch panel 108 for a series of product sales data processing from the product code input waiting (step S11) to the product information registration processing (step S13). (N in step S14). When the CPU 201 of the POS terminal 101 determines that payment is specified (Y in step S14), the checkout process for one customer is executed in the order of the payment process (step S15) and the post-process (step S16) described above. Exit. Post-processing is processing for transmitting information related to checkout such as merchandise information stored in the RAM 203 and money transaction information with a customer performed in the settlement processing to the store controller 51 as a host device. The post-processing includes processing for printing and issuing a receipt RT to be handed over to the customer from the receipt printer 106. When printing the receipt RT, the CPU 201 of the POS terminal 101 displays a bar code SB symbolized with the customer ID, and a round mark YM (see FIG. 13) as information indicating that the discount has been applied to the preferential product. Print including. Details of the receipt RT will be described later with reference to FIG.

  FIG. 9 is a flowchart showing a flow of customer information acquisition processing executed by the CPU 201 of the POS terminal 101. The CPU 201 of the POS terminal 101 waits for input of a customer ID from the start of execution of the checkout process until the completion of the settlement process (step S21). As an example, the customer ID is input by reading a barcode printed on the receipt RT by the barcode reader 111.

  When the customer ID is input (Y in step S21), the CPU 201 of the POS terminal 101 searches the customer master file 254a described above, and acquires the special treatment rank, special treatment application, and category code corresponding to the inputted customer ID. A customer classification code acquisition process is executed (step S22).

  If the CPU 201 of the POS terminal 101 determines that the obtained preferential application is “0: no application” (N in step S23), the customer information acquisition process is terminated. On the other hand, if the CPU 201 of the POS terminal 101 determines that the obtained preferential treatment application is “1: application ant” (Y in step S23), the CPU 201 searches the category setting file 254b described above and obtains it. A group acquisition process for acquiring a discount product code group corresponding to the category code and storing it in the RAM 203 is executed (step S24), and the customer information acquisition process is terminated.

  Thus, the customer information acquisition process includes a customer classification code acquisition process and a group acquisition process, and is a process of acquiring which products are set as preferential products for the input customer ID. In the present embodiment, in step S23, when there is no preferential treatment application, the customer classification code acquisition process shown in step S24 is not executed. When there is no preferential treatment application, the process for searching the category setting file 254b is not executed, so that the entire process can be speeded up. In the present embodiment, two files, a customer master file 254a and a category setting file 254b, which are normalized using a category code, are prepared for defining the correspondence between customer IDs and preferential products. Yes. For this reason, when changing the merchandise sales strategy for a customer category classified by a certain attribute, only the contents of the category setting file 254b need be changed.

  When the CPU 201 of the POS terminal 101 executes the customer information acquisition process and acquires the preferential rank, preferential application and discount product code group corresponding to the customer ID, the product code input by the barcode reader 111 matches the preferential product code. If they match, the product unit price of the product specified by the product code is discounted according to the preferential rank.

  The processing in which the CPU 201 of the POS terminal 101 discounts the product unit price of the preferential product is classified into two types according to the timing at which the processing is performed. One is a preferential product that is set for the customer by entering the customer ID before entering the product code, such as by handing over the receipt RT received at the previous visit to the cashier at the same time the customer delivers the product to the cashier. Is specified. For the sake of explanation, this is the first discount unit price setting process. The other was that after the product code was entered, the customer ID was entered, and it was later found that the product specified by the entered product code was a preferential product set for that customer. Is the case. For the sake of explanation, this is a second discount unit price setting process.

  FIG. 10 is a flowchart showing a flow of processing (first discount unit setting processing) for setting a discount unit price executed by the CPU 201 of the POS terminal 101 when the customer ID is input before the product code is input. . The CPU 201 of the POS terminal 101 executes the checkout process shown in FIG. 8 when the customer ID is input and the customer information acquisition process is executed and the discount product code group corresponding to the input customer ID is acquired. At this time, instead of the search process (step S12), the first discount unit price setting process shown in FIG. 10 is executed.

  When the preferential treatment corresponding to the input customer ID is “0: no application” (N in Step S31), the CPU 201 of the POS terminal 101 performs a product unit price in the same manner as the search process (Step S12) described above. The product unit price corresponding to the product code input from the file 254c is acquired (step S32), and the first discount unit price setting process is terminated.

  On the other hand, if the preferential treatment corresponding to the input customer ID is “1: application ant” (Y in step S31), the CPU 201 of the POS terminal 101 determines the product specified by the input product code. It is determined whether or not is a preferential product (step S33). As a result of the determination in step S33, if the product specified by the product code is not a preferential product (N in step S33), the CPU 201 of the POS terminal 101 performs the first discount unit price after executing the processing in step S32 described above. The setting process ends. On the other hand, when the product specified by the product code is a preferential product as a result of the determination in step S33 (Y in step S33), the CPU 201 of the POS terminal 101 searches the product unit price file 254c and inputs it. The discount unit price specified by the obtained product code and the acquired preferential treatment rank is acquired (step S34), and the first discount unit price setting process is terminated. In this case, in the product information registration process (step S13 in FIG. 8), the CPU 201 of the POS terminal 101 stores product information including the product code and the discount unit price in the RAM 203.

  FIG. 11 is a flowchart showing a flow of processing (second discount unit price setting process) for setting a discount unit price executed by the CPU 201 of the POS terminal 101 when the customer ID is input after the product code is input. When the customer ID is input after the product code is input and the product information including the product code and the product unit price is stored in the RAM 203, the CPU 201 of the POS terminal 101 executes the second discount unit price setting process shown in FIG. .

  When the obtained special treatment application is “0: No application” (N in step S41), the CPU 201 of the POS terminal 101 ends the second discount unit price setting process without performing anything. On the other hand, the CPU 201 of the POS terminal 101 specifies the product code for all the product information stored in the RAM 203 when the obtained preferential treatment is “1: application ant” (Y in step S41). It is checked whether the product to be sold is a preferential product (steps S42-1, S42-2). In this check, the CPU 201 of the POS terminal 101 does not discount the product price unless the product specified by the product code stored in the RAM 203 is a preferential product (N in step S43). On the other hand, if the product is a preferential product (Y in step S43), the CPU 201 of the POS terminal 101 searches the product unit price file 254c for the product code input and the discount unit price specified by the acquired preferential rank. The product unit price of the product information acquired and stored in the RAM 203 is changed to a discount unit price (step S44). When the processing loop surrounded by steps S42-1 and S42-2 is exited after such processing is performed, the CPU 201 of the POS terminal 101 ends the second discount unit price setting processing.

  The product unit price of the product that is the preferential product among the product information stored in the RAM 203 is changed to the discount unit price by the second discount unit price setting process, and is used to calculate the settlement amount in the settlement process (step S15 in FIG. 8). It is done.

  FIGS. 12A to 12E are schematic diagrams showing application examples of discounts to preferential products performed when a customer purchases a product. In the application example described below, the HDD 204 stores the customer master file 254a storing the data shown in FIG. 5, the category setting file 254b storing the data shown in FIG. 6, and the data shown in FIG. Assume that the product unit price file 254c being stored is stored.

  Here, consider a case where a customer whose customer ID is “A” purchases two products, cosmetic lipstick and beer A (FIG. 12A). The CPU 201 of the POS terminal 101 searches the customer master file 254a and sets “2” as the special treatment rank corresponding to the customer ID = “A”, “1: application ant” as the special treatment application, and “1” as the category code. Get each. Then, the CPU 201 of the POS terminal 101 searches the category setting file 254b and acquires a preferential product code for specifying “cosmetic lipstick” as a discount product code group corresponding to category code = “1”. In other words, among the products that the customer ID “A” intends to purchase, “cosmetic lipstick” matches the preferential product code included in the discount product code group, and the discount is applied. Therefore, the CPU 201 of the POS terminal 101 searches the product unit price file 254c, acquires a discount unit price when the preferential rank is “2” from the data record in which the product code indicates “cosmetic lipstick”, and sells the cosmetic lipstick. The unit price is set to “90 yen”. Similarly, the CPU 201 of the POS terminal 101 searches the product unit price file 254c, obtains a normal product unit price that does not have special treatment application from the data record in which the product code indicates “beer A”, and sets the sales unit price of beer A to “ 350 yen ".

  Hereinafter, in the case where customers with customer IDs “B”, “C”, and “D” purchase cosmetic lipstick and beer A, respectively, data set in the customer master file 254a and the category setting file 254b is the same. Based on the above, sales of cosmetic lipstick and beer A are determined. For the customer whose customer ID is “E”, since the preferential treatment application is set to “0: no application” in the customer master file 254a, a discount is given when the customer purchases cosmetic lipstick and beer A. Is not applied, and the unit sales prices of cosmetic lipstick and beer A are set to “150 yen” and “350 yen”, respectively.

  FIG. 13 is a schematic diagram showing an example of a receipt RT printed and issued from the receipt printer 106 in post-processing.

  The CPU 201 of the POS terminal 101 prints and issues a receipt RT when performing post-processing (step S16) in the check-out process shown in FIG. FIG. 13 shows a receipt RT printed and issued when a customer whose customer ID is “A” described above based on FIG. 12A purchases a product and executes a product transaction with the cashier.

  The receipt RT is printed and issued in horizontal writing. The items described in the receipt RT are, in order from the top, receipt information INFO, transaction information INFO2, message MG, and barcode SB.

  The receipt information INFO is arranged at the top of the receipt RT, and includes a store name, a receipt issue date and the like.

  The transaction information INFO2 is composed of product information related to products purchased by the customer, money transaction information, and the like. Each line constituting the transaction information INFO2 includes, for example, product information, total amount information, deposit amount information, change amount information, and the like. Here, if the product information is discounted, the product unit price included in the product information is overwritten with a strike-through line, and the discount unit price after applying the discount is printed on the line below it. A circle mark YM indicating that is applied.

  In the message MG, a message from the store to the customer is described, and in particular, a product set as a preferential product when the customer visits the store next time is described. This is because the CPU 201 of the POS terminal 101 searches the customer master file 254a and the category setting file 254b to acquire a discount product code group corresponding to the customer ID, and lists the preferential product codes included in the acquired discount product code group. Is realized. An example of the wording indicated in the message MG is “The next time the customer brings this receipt / I will provide you with a cosmetic lipstick ¥ 80 /.”

  The barcode SB is arranged at the lowermost part and on the right side of the receipt RT. This bar code SB is a customer ID symbolized and can be read by a bar code reader 111 as a product code input unit. It is also possible to use a two-dimensional code such as a QR code instead of the barcode SB.

  In the present embodiment, the CPU 201 executes the group acquisition process (step S24 in FIG. 9) and stores the discount product code group corresponding to the category code in the RAM 203. However, as another embodiment, the CPU 201 When the discount unit price setting process is executed without performing the group acquisition process, the discount product code group corresponding to the customer category code and the barcode reader 111 as the product code input unit are input with reference to the category setting file 254b. The product code may be compared.

It is a schematic diagram which shows an example of the checkout performed in a merchandise sales data processing system. It is a schematic diagram which shows roughly the system configuration | structure of a merchandise sales data processing system. It is a perspective view which shows a POS terminal. It is a block diagram which shows the hardware constitutions of a POS terminal. It is a schematic diagram which shows the data structure of a customer master file. It is a schematic diagram which shows the data structure of a category setting file. It is a schematic diagram which shows the data structure of a goods unit price file. It is a flowchart which shows the flow of the checkout process which CPU of a POS terminal performs. It is a flowchart which shows the flow of the customer information acquisition process which CPU of a POS terminal performs. It is a flowchart which shows the flow of the process (1st discount unit price setting process) which sets the discount unit price which CPU of a POS terminal performs when customer ID is input before a product code is input. It is a flowchart which shows the flow of the process (2nd discount unit price setting process) which sets the discount unit price which CPU of a POS terminal performs when customer ID is input after a product code is input. It is a schematic diagram which shows the example of application of the discount to the special treatment goods performed when a customer purchases goods. FIG. 10 is a schematic diagram illustrating an example of a receipt RT printed and issued from a receipt printer in post-processing.

Explanation of symbols

  101 ... POS terminal (product sales data processing device), 104 ... keyboard (product code input unit), 106 ... receipt printer, 108 ... touch panel (product code input unit), 111 ... bar code reader (product code input unit, customer ID) Input unit, scanner) 111a ... RFID reader / writer (customer ID input unit), 203 ... RAM (product information storage unit), 254a ... Customer master file (first data file, third data file, fourth data) File), 254b ... Category setting file (second data file), 254c ... Product unit price file (PLU file), SB ... Bar code (customer ID, code symbol)

Claims (4)

A product code input section for entering a product code for identifying a product;
A customer ID input unit for inputting a customer ID for identifying a customer;
A product unit price corresponding to the product code input by the product code input unit is retrieved by searching a PLU file that stores the product unit price in association with the product code, the input product code, the acquired product unit price, Means for executing the merchandise sales data processing for storing the merchandise information in the merchandise information storage section for each transaction, and executing the settlement processing based on the merchandise information stored in the merchandise information storage section,
A first data file storing discount application information indicating whether to apply a discount in association with a customer ID is searched to obtain discount application information corresponding to the customer ID input by the customer ID input unit. Means,
A second data file storing a customer classification code for classifying the customer according to the attribute in association with the customer ID is searched to obtain a customer classification code corresponding to the customer ID input by the customer ID input unit. Means for executing customer classification code acquisition processing;
One or two or more discount targets associated with the customer classification code when it is determined that the discount application information acquired by the means for acquiring the discount application information corresponding to the customer ID indicates that the discount is to be applied A discount product corresponding to the customer classification code acquired by the customer classification code acquisition process with reference to a third data file that stores a discount product code group consisting of the product codes of the product code input by the product code input unit Means for executing a process of discounting the product unit price acquired in the product sales data processing corresponding to the input product code when it is determined that the product is included in the code group;
A product sales data processing apparatus comprising: In the PLU file, a discount price is stored in association with a preferential rank for each product code,
Search for a fourth data file storing a preferential treatment rank in association with a customer ID, and execute a process of obtaining a preferential treatment rank corresponding to the customer ID input by the customer ID input unit,
In the process of discounting the product unit price, the PLU file is searched to obtain a discount price corresponding to the input product code and the acquired preferential rank.
The merchandise sales data processing apparatus according to claim 1. A receipt printer that performs printing,
If it is determined that the product code input by the product code input unit is included in the discount product code group corresponding to the acquired customer classification code, the fact that a discount is applied is printed on the receipt printer. Execute the process to
The merchandise sales data processing apparatus according to claim 1 or 2. Executing a process of causing the receipt printer to print print data including a code symbol obtained by symbolizing the customer ID;
The customer ID input unit is a scanner that reads a code symbol printed by the receipt printer.
The merchandise sales data processing apparatus according to claim 3 .

Images