JP2006178561A - Housekeeping book registration supporting system and method for inputting purchase data - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To reduce the labor and time for inputting data to a housekeeping book in simple system configurations. <P>SOLUTION: This housekeeping book registration supporting system is provided with information processing terminal equipment 1 of a merchandise purchaser, and a merchandise sales data processing system 2. The merchandise sales data processing system 2 is provided with a two-dimensional bar code generation means 25 for converting purchase data containing the name of merchandise purchased by a purchaser and the price of purchase into a bar code and a printing means 26 for issuing a receipt 3 on which the text and bar code of the purchase data are printed. The information processing terminal equipment 1 is provided with a camera 11 for reading the bar code printed on the receipt 3, a two-dimensional bar code analyzing part 12 for extracting the purchase data from the read bar code information, and for outputting the purchase data in a text format and a housekeeping book database 14 in which the purchase data in the text format are stored so as to be referred to by this housekeeping book registration system. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a household account registration system that supports registration in a household account book database, and more particularly to a household account book support system that simplifies the input of product information.

Conventionally, many household account books that are written by hand, personal information terminal devices and household account book software for personal computers have been commercialized and sold. However, these household accounts require a long time to input purchased product information, and simplification of input is desired. In order to simplify the input of merchandise information, a system that provides merchandise purchase information via a network, such as the systems described in Patent Documents 1 and 2, is known. And it is expected that the labor of registering a household account will be reduced by taking in the product purchase information provided on the customer side.
JP 2002-24679 A JP 2004-227364 A

  In the conventional system, the purchaser needs to access a server that manages product information via the Internet or the like in order to obtain purchased product information. Another problem is that other users can impersonate and take out product purchase information, and the store side can freely view purchaser's purchase history information and cannot protect the purchaser's privacy. Furthermore, the store side must always manage product information and construct a server that can access the Internet, making it difficult to construct a household account book support system.

  Therefore, an object of the present invention is to reduce the labor of inputting data into a household account book with a simple system configuration.

  A household account book registration support system according to an embodiment of the present invention is a household account book registration support system including a product sales management device and a purchaser terminal device, wherein the product sales management device is a name of a product purchased by a purchaser. And means for converting the purchase data including the purchase price into a barcode, and means for issuing a receipt printed with the text of the purchase data and the barcode generated by the barcode conversion means. The purchaser terminal device reads a barcode printed on the receipt, extracts the purchase data from the read information, and outputs the purchase data in a text format, and the barcode reader outputs Means for storing the purchase data in the text format in a state that can be referred to by the household account book system.

  In a preferred embodiment, the barcode converting means of the merchandise sales management apparatus divides the purchase data into a plurality of groups, and generates a barcode for each of the divided groups. The receipt issuing means may print a plurality of barcodes generated by the barcode converting means on the receipt.

  In a preferred embodiment, the purchaser terminal device may further include purchase data determination means. The bar code generating means generates each bar code so that each bar code includes identification information of each group. The bar code reader extracts purchase data and group identification information included in the read bar code information. The storage means stores the purchase data in the text format and the extracted identification information in association with each other. And the said purchase data determination means can exclude the duplicate input of purchase data based on the identification information which the said barcode reader extracted with reference to the said memory | storage means.

  A merchandise sales management apparatus according to an embodiment of the present invention is generated by means for bar code purchase data including a merchandise name and a purchase price purchased by a purchaser, and text of the purchase data and the bar code means. Means for issuing a receipt on which a barcode is printed.

  According to an embodiment of the present invention, a purchaser terminal device includes a bar code generated from a purchase data text including a product name and a purchase price purchased by a purchaser, and a receipt printed with a bar code generated based on the purchase data. The bar code reader that extracts the purchase data from the read bar code information and outputs the purchase data in text format, and the household account book system refers to the text format purchase data output by the bar code reader Means for storing in a possible state.

  In a preferred embodiment, the bar code reader includes an imaging unit that captures the bar code, and a data extraction unit that extracts the purchase data based on the image data of the bar code and outputs the purchase data in a text format. And may be provided.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a diagram showing the configuration of the household account book registration support system according to the first embodiment of the present invention. This system includes an information terminal device 1 which is a terminal device used by a purchaser, and a merchandise sales data processing system 2 installed in a store or the like. In this system, the merchandise sales data processing system 2 issues a receipt 3 on which a barcode indicating the name of the merchandise purchased by the purchaser and the purchase price is printed. Then, the bar code printed on the receipt 3 is read by the information terminal device 1 and converted into text data of the purchased product name and purchase price. By importing this text data into the household account book system, the purchaser can save the trouble of inputting the purchased product name and price.

  The product sales data processing system 2 includes an input unit 21, a product code conversion unit 22, a product code database 23, a product list generation unit 24, a two-dimensional barcode generation unit 25, a clock function 28, and a print screen generation. Means 26, printing means 27, and clock function 28 are provided. The merchandise sales data processing system 2 may be a single device, or, as shown in FIG. 2, a plurality of data processing terminal devices 6 and a merchandise information server 5 are connected via a network 4, and each function It is good also as the system which has shared.

  For example, the input means 21 reads a barcode attached to a product and detects information such as a product code included in the barcode, or a salesperson directly inputs the code, Is a touch panel or a key for selecting an item, and is a means for inputting a product code of a product purchased by the purchaser.

  The product code conversion unit 22 acquires the product name and the product price registered in the product code database 23 using the product code input from the input unit 21.

  An example of data stored in the product code database 23 is shown in FIG. As shown in the drawing, at least the product name 32 and the price 33 associated with each product code 31 are registered in the product code database 23. For example, the product name of the product code “4901201013491” is “cucumber”, and the unit price is “25” yen. When the product code conversion means 22 sends the product code “4901201013491” to the product code database 23, the product name “cucumber” and the unit price “25” are obtained as a response. In addition to the data shown in FIG. 3, the product code database 23 may record data such as the stock status of the product and summary information.

  The product list generation unit 24 collects the product name and unit price information obtained from the product code conversion unit 22 for each customer, and creates a list of products to be purchased. An example of the product list data generated here is shown in FIG. The product list data 41 generated here is text data, and is composed of each product name, unit price, and quantity purchased. In the product list data of FIG. 4, in order to distinguish individual data, the product name, unit price, and number of purchased items are separated by commas, and a line feed is inserted between products.

  The two-dimensional barcode generating unit 25 generates a two-dimensional barcode including the product list data 41 based on the product list data 41 created by the product list generating unit 24.

  The print screen generation unit 26 acquires the date and time from the product list data 41 generated by the product list generation unit 24, the two-dimensional barcode generated by the two-dimensional barcode generation unit 25, and the clock function 28. Arrange in a predetermined layout. At this time, information related to the store such as the store name registered in advance in the merchandise sales data processing system 2, a message to the purchaser, a receipt number for managing the receipt, and the like may be laid out at the same time.

  The printing unit 27 prints the printing screen created by the printing screen generation unit as the receipt 3. An example of the printed receipt 3 is shown in FIG. On the receipt 3, a store name 51, a product purchase date and time 52, a purchased product name and price 53, and a two-dimensional barcode 30 are printed. In other words, the purchaser receives a receipt printed with a two-dimensional barcode 30 of the purchased product information together with the name of the purchased product, the unit price, and the total list of the products described in the normal receipt.

  Next, the information terminal device 1 will be described with reference to FIG. 1 again. The information terminal device 1 may be a portable information terminal device such as a mobile phone or a PDA (Personal Data Assistant) in addition to a desktop personal computer. The information terminal device 1 includes a camera 11, a two-dimensional barcode analysis unit 12, a household account book management unit 13, a household account book database 14, and a screen display function 15.

  In this embodiment, the camera 11 and the two-dimensional barcode analysis unit 12 form a two-dimensional barcode reader. That is, the purchaser photographs the two-dimensional barcode printed on the receipt 3 with the camera 11 of the information terminal device 1. The two-dimensional barcode analysis unit 12 performs predetermined image processing on the image captured by the camera 11 and cuts out a two-dimensional barcode. Further, the two-dimensional barcode analysis unit 12 extracts purchase data from the two-dimensional barcode cut out by a predetermined analysis, and outputs this as text data. The text-format purchase data output here is the same as the product list data 41 shown in FIG.

  The household account book management means 13 takes out the product name, unit price, and quantity of each product from the text-format purchase data output from the two-dimensional barcode analysis unit 12 and records them in the household account book database 14.

  The household account book database 14 is a database that stores information about purchased products, and a household account book system (not shown) can read the information stored therein. As will be described later, since the purchase data of the product can be easily taken into the household account book database 14, in the present embodiment, it is possible to reduce the time and effort for the purchaser to input data.

  Here, FIG. 6 shows an example of a data array of purchase data stored in the household account book database 14. The stored purchase data includes the product name 61 of the first product, the comma 62, the unit price 63 of the first product, the comma 62, the number of first products 64, the line feed 65, and the product name 66 of the second product. It is the composition. Therefore, when the household account book management means 13 reads purchase data from the household account book database 14, it detects a comma 62 and a line break 65 to extract a data break. The household account book management means 13 calculates the total amount and the like based on the purchase data registered in the household account book database 14 and displays it on the screen display function 15 together with the purchased product name. Thereby, the purchaser can grasp the name and balance status of the purchased product.

  As described above, according to the present invention, the purchaser can register the purchased product information in the household account book without performing key input or the like, and the input efficiency is greatly improved. Further, since the purchase data of the product is included in the barcode printed on the receipt, the purchase data can be taken into the purchaser's terminal device without being connected to a server or the like.

  Next, a second embodiment of the present invention will be described. FIG. 7 is a diagram illustrating a configuration of a household account book registration support system according to the second embodiment. In this embodiment, as in the first embodiment, the information terminal device 1 and the product sales data processing system 2 are provided, and the product sales data processing system 20 displays the product name and purchase price purchased by the purchaser. The receipt 3 on which the barcode shown is printed. In addition, about the structure same as 1st Embodiment, the same code | symbol may be attached | subjected and description may be abbreviate | omitted.

  The product sales data processing system 20 according to the present embodiment includes an input unit 21, a product code conversion unit 22, a product code database 23, and a product count unit 201 that counts the number of product names obtained by the product code conversion unit. , An ID generation unit 202 that generates an ID of a two-dimensional barcode, a product list generation unit 203 that can generate a plurality of product lists, a two-dimensional barcode generation unit 25, a print screen generation unit 26, and a print Means 27 and a clock function 28 are provided.

  The product name count unit 201 counts the number of product names output from the product code conversion unit 22. When the number of product names reaches a preset number, the ID generation unit 202 is instructed to create an ID. When all the product names have been counted, the created ID number is sent to the product list generation means 203.

  The product list generation unit 203 generates list data of all products to be purchased, and also generates product list data for each product related to the ID sent from the ID generation unit 202. That is, when the number of products purchased by the purchaser is larger than a predetermined number, the purchase data is divided into a plurality of groups, and list data of purchased products is generated for each group. Here, an example of the product list data 90 for each group is shown in FIG. The head of the list data 90 includes the total number of groups 90a (here “3”) and the group ID 90b (here “2”) of this list.

  FIG. 9 is a diagram illustrating an example of a data format when the commodity list data in the present embodiment is stored in the household account book database 14. The first ID number 91 and ID 92 correspond to the entire group number 90a and ID 90b in FIG. 8, respectively.

  The product list data 90 generated by the product list generation unit 203 is sent to the two-dimensional barcode generation unit 25 for each group, and a two-dimensional barcode is generated for each group. The group-specific two-dimensional barcode generated here includes purchase data included in the group and an ID that is identification information of the group.

  The print screen generating unit 26 receives the list data of all products and the created two-dimensional barcode for each group from the product list generating unit 203, and generates a print screen.

  Then, the printing unit 27 prints the receipt 80 including the two-dimensional barcodes 81 to 83 for each group as shown in FIG. The purchaser who receives this receipt 80 reads all the two-dimensional barcodes 81 to 83 using the information terminal device 1 and registers them in the household account book database 14.

  The processing procedure of the household account book management means 13 in the information terminal device 1 at this time will be described with reference to the flowchart shown in FIG. In the present embodiment, the household account book management means 13 has a counter for counting the number of processed groups in order to perform management for reading all the plurality of barcodes.

  First, the information terminal device 1 starts the household account book management means 13 (S101). At this time, the processed group number counter is initialized. Then, in accordance with the purchaser's operation, one of the two-dimensional barcodes 81 to 83 printed on the receipt 80 is photographed by the camera 11 (S102). The two-dimensional barcode analysis unit 12 extracts group identification information and purchase data included in the two-dimensional barcode photographed in step S102 and converts it into text data (S103). Here, the total number of groups and the ID of this group are extracted from the purchase data in the text format (S104). Then, the household account book database 14 is referenced to check whether the photographed two-dimensional barcode has been read and registered in the household account book database 14 using the ID as a key (S105).

  Here, if it has been read (S105: YES), a read message is displayed on the display screen (S106). When the purchaser confirms the message, the read data is discarded, and the screen returns to the two-dimensional barcode photographing screen in step S102 (S107).

  If the photographed two-dimensional barcode has not been read (S105: NO), the group ID, product name, unit price, and number included in the text data are registered in the household account book database 14 (S108). Since the processing relating to the two-dimensional barcode read at this point is completed, the processed group number counter is incremented (S109).

  Next, the total number of groups included in the purchase data processed here is compared with the number of processed groups (S110). That is, if the processed group number counter matches the number of all groups, all groups have been read (S110: YES), so the processed group number counter is cleared and reading of this receipt is terminated (S111). On the other hand, if all groups have not been read (S1110: NO), the process returns to step S102.

  As described above, according to the present invention, it is possible to receive a plurality of two-dimensional barcodes set at the store side and of an easy-to-read size, and do not register a plurality of two-dimensional barcodes redundantly. Therefore, it becomes easier to input to the household account book.

  In addition, as shown in FIG. 12, the store name and the product purchase date and time are converted into a two-dimensional bar code, which makes it easier to input to the household account book.

  Next, the information terminal device 1 in the first and second embodiments may be configured to be distributed among a plurality of devices as shown in FIG. 13, for example. That is, in the example of FIG. 13, the functions of the information terminal device 1 are configured to be distributed between the portable information terminal device 10 and the information terminal device 71 such as a desktop personal computer. In addition, about the structure same as 1st Embodiment, the same code | symbol may be attached | subjected and description may be abbreviate | omitted.

  The portable information terminal device 10 includes a camera 11, a two-dimensional barcode analysis unit 12, a communication unit 75 that can communicate locally, a product information storage unit 76, and a removable memory 77. The information terminal device 71 includes a communication unit 72, a household account book database 73, and a household account book management unit 74.

  The portable information terminal device 10 stores the text data that is the analysis result of the two-dimensional barcode analysis unit 12 in the product information storage unit 76 or the memory 77 attached to the portable information terminal device 10. Thereafter, when the communication means 75 with the portable information terminal device 1 and the communication means 72 of the information terminal device 71 are communicable, for example, when a purchaser holding the portable information terminal device 10 returns home from the outside, The text data stored in the memory 77 of the information terminal device 1 is transmitted to the information terminal device 71.

  Here, the communication means may be a wireless communication means such as infrared rays or Bluetooth, or may be a wired connection means that communicates by connecting a cable such as USB. In the information terminal device 71 that has received the text data, the text data received by the household account book management means 74 is analyzed, classified into product names, unit prices, etc. by product and registered in the household account book database 73.

  According to the present embodiment, the purchased product information can be easily taken into the household account book system without the user performing key input. Furthermore, in this embodiment, since it is not necessary to arrange a household account book management means and a database in a portable information terminal device, an information terminal device having a small memory capacity such as a general cellular phone can be used.

  The above-described embodiments of the present invention are examples for explaining the present invention, and are not intended to limit the scope of the present invention only to those embodiments. Those skilled in the art can implement the present invention in various other modes without departing from the gist of the present invention.

  For example, although a two-dimensional barcode is used in the above embodiment, a one-dimensional barcode may be used instead of this, and a mechanically readable image may be used in addition to the barcode.

It is a figure which shows an example of a function structure of the household account book registration assistance system which concerns on the 1st Embodiment of this invention. It is a figure which shows the example of the other structure of the merchandise sales data processing system of 1st Embodiment. It is an example of the goods code database of 1st Embodiment. It is an example of goods list data of a 1st embodiment. It is an example of the receipt of 1st Embodiment. It is an example of a goods list data structure of 1st Embodiment. It is a figure which shows an example of a function structure of the household account book registration assistance system which concerns on the 2nd Embodiment of this invention. It is an example of goods list data of a 2nd embodiment. It is an example of a goods list data structure of 2nd Embodiment. It is an example of the receipt of 2nd Embodiment. It is a figure which shows an example of the processing flow of 2nd Embodiment. It is an example of the receipt of 2nd Embodiment. It is a figure which shows the other structural example of an information terminal device.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Information terminal device 2 Merchandise sales data processing system 3 Receipt 11 Camera 12 Two-dimensional barcode analysis part 13, 74 Household book management means 14, 73 Household book database 21 Input means 22 Product code conversion means 23 Product code database 24 Two-dimensional bar Code generating means 25 Printing means 54 Two-dimensional bar code 72, 75 Communication means 76 Product information storage means 77 Memory

Claims (6)

A household account book registration support system comprising a product sales management device and a purchaser terminal device,
The merchandise sales management device includes:
Means for bar code purchase data including the product name and purchase price purchased by the purchaser;
Means for issuing a receipt printed with the text of the purchase data and the barcode generated by the barcode encoding means;
The purchaser terminal device
A barcode reader that reads the barcode printed on the receipt, extracts the purchase data from the read barcode information, and outputs the purchase data in text format;
A household account book registration support system comprising: means for storing the purchase data in text format output by the bar code reader in a state that can be referred to by the household account book system. The barcode encoding means divides the purchase data into a plurality of groups, generates a barcode for each of the divided groups,
2. The household account book registration support system according to claim 1, wherein the receipt issuing means prints a plurality of barcodes generated by the barcode converting means on the receipt. The purchaser terminal device further includes purchase data determination means,
The bar code generating means generates each bar code so that each bar code includes identification information of each group,
The barcode reader extracts purchase data and identification information of the group included in the read barcode information,
The storage means stores the text-format purchase data and the extracted identification information in association with each other,
3. The household account book according to claim 1, wherein the purchase data determination unit refers to the storage unit and eliminates duplicate input of purchase data based on the identification information extracted by the bar code reader. Registration support system. The bar code is read from a receipt printed with a text of purchase data including a product name and purchase price purchased by the purchaser and a bar code generated based on the purchase data, and the purchase data is read from the read bar code information. A barcode reader for extracting the purchase data in text format, and
A purchaser terminal device comprising: means for storing the purchase data in text format output by the bar code reader in a state in which the household account book system can refer to the purchase data. The barcode reader is
Photographing means for photographing the barcode;
5. The purchaser terminal device according to claim 4, further comprising: data extraction means for extracting the purchase data based on the image data of the barcode and outputting the purchase data in a text format. Reading the barcode from a receipt printed with a text of purchase data including a product name and purchase price purchased by the purchaser and a barcode generated based on the purchase data;
Extracting the purchase data from the read barcode information and outputting the purchase data in text format;
Storing the output purchase data in the text format in a storage means in a state where the household account book system can use the purchase data.

Images