JP2016045785A - Sales information registration processing device and sales information registration processing program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a sales information registration processing device and sales information registration processing program that can output warning when interactive products are looked for taking already purchased products into consideration, and there are products causing interaction.SOLUTION: A sales information registration processing device comprises: a display device that displays information; a product master that stores information related to a product for each product; a transaction file that stores a content of one transaction; and a control unit that reads a contraindication product ID from a medicine database in which the contraindication product ID serving as a product ID of a contraindication product causing interaction is stored for each product on the basis of the product ID of a registered product, and outputs to a display device warning to the effect that the product causing the interaction has been already purchased when the contraindication product ID is included in a purchase history read from a history database having the purchase history for member ID stored.SELECTED DRAWING: Figure 9

Description

  Embodiments described herein relate generally to a sales information registration processing apparatus and a sales information registration processing program.

  Some medicines and health foods interact with other medicines and specific foods to reduce or enhance the effect of the medicine. Alternatively, there are combinations that cause health damage when taken at the same time.

  In this regard, there has been proposed a sales information registration processing device that outputs a warning when there is a product that causes an interaction among products purchased by a customer at the same time.

  However, when products that interact with each other at different timings are purchased, the sales information registration processing device cannot output a warning.

JP 2003-233673 A

  Accordingly, there is a need for a sales information registration processing apparatus and a sales information registration processing program that can search for a product that interacts in consideration of a product that has already been purchased and can output a warning when there is a product that causes an interaction.

  In order to solve the above problems, an embodiment of the present invention includes a display device that displays information, a product master that stores information about a product for each product, a transaction file that stores the contents of one transaction, and a registration A history of reading a contraindicated product ID from a drug database storing a contraindicated product ID that is a product ID of a contraindicated product that causes an interaction for each product ID based on the product ID of the product, and storing a purchase history for each member ID A sales information registration processing device is provided that includes a control unit that displays, on a display device, a warning that a product that causes interaction is purchased when the purchase history read from the database includes a contraindicated product ID.

It is a block diagram which shows the structure of the sales information registration processing system containing a sales information registration processing apparatus. It is a block diagram which shows the structure of a sales information registration processing apparatus. It is a block diagram which shows the structure of a log | history server. It is a block diagram which shows the structure of a chemical | medical agent server. It is a figure which shows the data structure of a goods master. It is a figure which shows the data structure of a transaction file. It is a figure which shows the data structure of a history database. It is a figure which shows the data structure of a chemical | medical agent database. It is a flowchart which shows operation | movement of a sales information registration processing system. It is a figure which shows the example of an interaction chemical | medical agent notification screen.

  Hereinafter, an embodiment of a sales information registration processing device and a sales information registration processing program will be described in detail with reference to the drawings.

  FIG. 1 is a block diagram showing a configuration of a sales information registration processing system including a sales information registration processing device. As shown in FIG. 1, the sales information registration processing system includes a POS (point of sales) terminal 10 (hereinafter, the sales information registration processing device is referred to as a POS terminal 10), a history server 20, and a medicine server 30. Prepare. The sales information registration processing system is used in merchandise stores such as supermarkets.

  The POS terminal 10 is connected to the history server 20 and the medicine server 30 via the public communication line network 1 such as the Internet.

  FIG. 2 is a block diagram showing the configuration of the POS terminal 10. As illustrated in FIG. 2, the POS terminal 10 includes a POS control unit 101, a POS storage unit 102, a POS input / output unit 103, and a POS communication unit 104. The POS terminal 10 can be configured using a computer.

  The POS control unit 101 includes a CPU (central processing unit) that is an arithmetic device.

  The POS storage unit 102 includes a storage device such as a memory and a hard disk drive. The POS storage unit 102 stores a product master 102A and a transaction file 102B.

  The POS storage unit 102 stores a sales information registration processing program, and the POS control unit 101 sequentially reads and executes the sales information registration processing program from the POS storage unit 102.

  The product master 102A stores product information including a product name and a unit price for each product ID uniquely assigned to a product.

  The transaction file 102B stores the sales information received from the order server 50 for each transaction.

  The POS input / output unit 103 includes an operator display and a display device such as a customer display for presenting information to a customer, and an input / output device such as a keyboard, a mouse, a card reader, and a wireless tag reader / writer. The POS terminal 10 may include a printer that prints a receipt.

  The POS communication unit 104 connects to the public communication line network 1 and performs communication.

  FIG. 3 is a block diagram showing the configuration of the history server 20. As illustrated in FIG. 3, the history server 20 includes a history server control unit 201, a history server storage unit 202, a history server input / output unit 203, and a history server communication unit 204. The history server 20 can be configured using a computer such as a so-called server.

  The history server control unit 201 includes a CPU that is an arithmetic device.

  The history server storage unit 202 includes a storage device such as a memory and a hard disk drive. The history server storage unit 202 stores a history database (hereinafter, the database is referred to as D / B) 202A.

  The history server storage unit 202 stores a sales information registration processing program, and the history server control unit 201 sequentially reads and executes the sales information registration processing program from the history server storage unit 202.

  The history D / B 202A stores purchase history information for each member ID uniquely assigned to a customer.

  The history server input / output unit 203 includes input / output devices such as a display, a keyboard, and a mouse.

  The history server communication unit 204 connects to the public communication line network 1 and performs communication.

  FIG. 4 is a block diagram showing a configuration of the medicine server 30. As shown in FIG. 4, the medicine server 30 includes a medicine server control unit 301, a medicine server storage unit 302, a medicine server input / output unit 303, and a medicine server communication unit 304. The medicine server 30 can be configured using a computer such as a so-called server.

  The medicine server control unit 301 includes a CPU that is an arithmetic device.

  The medicine server storage unit 302 includes a storage device such as a memory and a hard disk drive. The medicine server storage unit 302 stores the medicine D / B 302A.

  The medicine server storage unit 302 stores a sales information registration processing program, and the medicine server control unit 301 sequentially reads and executes the sales information registration processing program from the medicine server storage unit 302.

  The medicine D / B 302A stores interaction information that is information on a product that causes an interaction for each product ID that is uniquely assigned to the product.

  The medicine server input / output unit 303 includes input / output devices such as a display, a keyboard, and a mouse.

  The medicine server communication unit 304 is connected to the public communication network 1 to perform communication.

  FIG. 5 is a diagram illustrating a data configuration of the product master 102A. As illustrated in FIG. 5, the product master 102 </ b> A includes a “product ID” that is an identifier uniquely assigned to a product, a “department” that indicates a handling department, a “product name” that indicates the name of the product, and 1 of the product. The “unit price” indicating the price per unit quantity is stored.

  In the example of each data, the product ID is “20123”, the department is “02”, the product name is “product A”, and the unit price is “1200”.

  FIG. 6 shows the data structure of the transaction file 102B. As shown in FIG. 6, the transaction file 102 </ b> B includes “slip No.”, “product ID”, “department”, “product name”, “unit price”, and sales that are uniquely assigned to one transaction. The “quantity” indicating the standing quantity and the “purchase date” indicating the date on which the customer purchased the product are stored.

  An example of each data is a slip No. Is “102”, the product ID is “20123”, the department is “02”, the product name is “medicine A”, the unit price is “1200”, the quantity is “1”, and the purchase date is “20140825”.

  FIG. 7 is a diagram illustrating a data configuration of the history D / B 202A. As shown in FIG. 7, the history D / B 202A includes “member ID”, “product ID”, “purchase date”, “department”, “product name”, and “quantity” that are uniquely assigned to the customer. And store.

  In the example of each data, the member ID is “0801”, the product ID is “20123”, the purchase date is “20140825”, the department is “02”, the product name is “medicine A”, and the quantity is “1”.

  FIG. 8 is a diagram illustrating a data configuration of the medicine D / B 302A. As shown in FIG. 8, the drug D / B 302A has “interindication product ID” that is a product ID of an interactive product for each “product ID”, “department”, and “product name”. A “incompatible product name” which is the name of a certain product and an “interaction” indicating the content of the interaction are stored.

  Examples of each data are as follows: product ID “20123”, department “02”, product name “drug A”, contraindication product ID “1157”, contraindication product name “product B”, interaction “medicine reduction” Is.

  FIG. 9 is a flowchart showing the operation of the sales information registration processing system. As shown in FIG. 9, in step 901, the POS control unit 101 reads a member ID from a member card possessed by a customer via a card reader of the POS input / output unit 103.

  In step 902, the POS control unit 101 registers a product purchased by the customer.

  In step 903, the POS control unit 101 determines whether the subtotal key of the POS input / output unit 103 has been pressed. If the POS input / output unit 103 determines that the subtotal key has been pressed (Y in Step 903), the process proceeds to Step 904. If it is determined that the subtotal key has not been pressed (N in Step 904), the process returns to Step 902.

  In step 904, the POS control unit 101 calculates a subtotal.

  In step 905, the POS control unit 101 transmits a purchase history request for requesting transmission of the purchase history of the member to the history server 20 together with the member ID.

  In step 906, the history server control unit 201 searches the history D / B 202A based on the received member ID, reads the purchase history for a predetermined period, and transmits it to the POS terminal 10.

  In step 907, the POS control unit 101 sends a medicine information request for sending medicine information, which is information related to the interaction of the product, to the medicine server 30 together with the product ID included in the received purchase history.

  In step 908, the medicine server control unit 301 searches the medicine D / B 302A based on the received product ID, reads out medicine information, and transmits it to the POS terminal 10.

  In step 909, the POS control unit 101 searches the medicine information received from the medicine server 30 based on the product ID of the registered product. When there is a corresponding product, the POS control unit 101 reads the contraindicated product ID of the product from the medicine information. The POS control unit 101 searches the received purchase history based on the read contraindicated product ID and determines whether there is a corresponding product ID. The POS control unit 101 proceeds to step 910 if the product ID corresponding to the contraindicated product ID is in the purchase history (Y in step 909), and proceeds to step 911 if there is no product ID (N in step 909).

  In step 910, the POS control unit 101 pops up and outputs an interactive medicine notification screen 1001 that outputs information on contraindicated products on a display that is a display device of the POS input / output unit 103. At this time, the same content may be displayed on a customer display that presents information to the customer.

  In step 911, when the transaction is confirmed, the POS control unit 101 transmits the contents of the transaction as a purchase history to the history server 20 together with the member ID, calculates change from the deposit, and ends one transaction. The history server control unit 201 stores the received purchase history in the history D / B 202A.

  FIG. 10 is a diagram showing an example of the interactive medicine notification screen 1001. As shown in FIG. 10, the interactive medicine notification screen 1001 includes a caution column 1002 that alerts the operator that there is a product that has an interaction, and a detail column 1003 that outputs a detailed description of the product that causes the interaction. And an OK button 1004 for closing the interactive medicine notification screen 1001.

  The POS control unit 101 may print and output the same contents as those in the detail column on the receipt.

  Note that the POS control unit 101 may input data related to products such as medicines purchased at other stores from a portable information terminal such as a smartphone owned by the customer, and transmit the data to the history server 20 as a purchase history. The history server control unit 201 that has received the purchase history can also store the received purchase history in the history D / B 202A.

  As described above, the sales information registration processing device according to the present embodiment is information on products that interact with each other based on the purchase history read from the history D / B 202A and the drug information read from the drug D / B 302A. Is displayed on the POS input / output unit 103.

  Accordingly, there is an effect that a product having an interaction can be found in consideration of a product that has already been purchased, and a warning can be output when there is a product that causes an interaction.

  Although several embodiments have been described, these embodiments have been presented by way of example and are not intended to limit the scope of the invention. These embodiments can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the spirit of the invention. These embodiments and their modifications are included in the scope and gist of the invention, and are also included in the invention described in the claims and the equivalents thereof.

10: POS terminal 20: History server 30: Drug server 102A: Product master 102B: Transaction file 202A: History database 302A: Drug database

Claims (6)

A display device for displaying information;
A product master that stores information about products for each product;
A transaction file that stores the contents of one transaction;
Based on the product ID of the registered product, the contraindicated product ID is read from the drug database storing the contraindicated product ID that is the product ID of the contraindicated product that causes an interaction for each product ID, and the purchase history is recorded for each member ID. When the purchase history read from the history database to be stored has the contraindicated product ID, a control unit that displays a warning on the display device that a product that causes interaction is purchased;
A sales information registration processing apparatus. The controller is
The sales information registration processing device according to claim 1, wherein the warning is displayed on an operator display of the display device and is also displayed on a customer display that presents information to a customer. The controller is
The sales information registration processing device according to claim 1, wherein the warning is displayed on an operator display of the display device and printed on a receipt by a printer. A display device for displaying information;
A product master that stores information about products for each product;
A transaction file that stores the contents of one transaction;
A computer comprising
A contraindicated product reading means for reading out the contraindicated product ID from a drug database storing a contraindicated product ID that is a product ID of the contraindicated product that causes an interaction for each product ID based on the product ID of the registered product;
A warning output means for displaying on the display device a warning that a product that causes interaction is purchased when the purchase history read from a history database storing a purchase history for each member ID includes the contraindicated product ID; ,
Sales information registration processing program to function as The computer,
5. The sales information registration processing program according to claim 4, wherein the warning information is displayed on an operator display of the display device and further functions as a customer warning display means for displaying the warning on a customer display for presenting information to a customer. The computer,
The sales information registration processing program according to claim 4, wherein the warning information is displayed on an operator display of the display device and further functions as warning print output means for printing on a receipt by a printer.

Images