JP2006350536A - Merchandise sales data processor - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To easily facilitate countermeasures even when it is necessary to report the sales circumstances of a store at any arbitrary place other than a store which is not connected through any exclusive line. <P>SOLUTION: A two-dimensional code is prepared from the data of a specific item among item-categorized total data where the sales-input sales data of each merchandise are totaled for each item and an address on a network at sales report destination. Then, a two-dimensional code 3 is printed on a receipt sheet, and issued as a sales report 2. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a merchandise sales data processing apparatus such as an electronic cash register for performing money registration and an electronic fee scale that calculates a fee by measuring the weight of a product such as meat and prepared food.

  For example, in a conventional electronic cash register, in the registration mode, when merchandise sales data for sales is input, the merchandise sales data is tabulated by item. Items include items by sales such as total sales and net sales, items by transaction such as cash transactions, credit transactions and credit transactions, items by product category such as meat, fish, vegetables, beverages and alcoholic beverages, etc. It is. In the checkout mode, the data aggregated by item is collectively edited into a report format. Then, for example, a receipt printer is used to print on a receipt sheet and issue a settlement report.

  Therefore, store managers such as store managers manage the daily sales situation and the like by executing a checkout mode and obtaining a checkout report each time a day's business ends.

In a conventional merchandise sales data processing device having such a settlement report issuing function, a settlement report is created by creating a two-dimensional code that aggregates the aggregated data for each item and printing this two-dimensional code on the settlement report. A technique for shortening the recording is already known (see, for example, Patent Document 1).
JP 09-153186 A

  As described above, the store can manage daily sales status and the like by obtaining a settlement report. Also, in stores where the headquarters controls multiple stores, such as chain stores, each store is connected to a computer installed at the headquarters via a dedicated line. By transmitting settlement report data from the computer to the head office computer, the head office can centrally manage the sales situation of each store.

  However, for example, in a store where the store manager and the store manager are different people and the store manager must report the sales situation etc. to the store manager who lives in a place away from the store every day, the store and store manager In many cases, the resident's residence is not connected by a dedicated line, so it has been necessary to deal with it by reporting the contents of the settlement report using communication means such as telephone, facsimile and the Internet.

  However, when using the telephone, there is a problem in that it may not be transmitted accurately because it is reported verbally while viewing the contents of the settlement report. Also, when using a facsimile, the payment report text printed on the receipt paper is too small to be crushed as it is, making it difficult to read it. It was. In addition, when using the Internet, everyone has the same trouble in that it has to be troublesome to input the contents to be reported to a personal computer or a mobile phone.

  The present invention has been made based on such circumstances, and the purpose of the present invention is that even if it is necessary to report the sales situation of a store to any place other than a store not connected by a dedicated line. It is an object of the present invention to provide a product sales data processing apparatus that can be easily handled and can reduce the burden on the reporter.

  In recent years, electronic communication devices such as mobile phones that are equipped with a two-dimensional code reader function are commercially available. When this type of electronic communication device reads a two-dimensional code in which a network address such as a URL (Uniform Resource Name) or an e-mail address is encoded, it accesses a server on the network specified by the address, It is possible to browse home pages and send e-mails.

  A two-dimensional code is a code that has information in two directions, horizontal and vertical, by arranging white and black cells or bars in a rectangular planar data area. Data such as kana, hiragana and symbols are encoded.

  Accordingly, the present invention provides a product sales data processing apparatus that aggregates sales data of each product that has been input for sales by item, and outputs the item-by-item total data in a report format. Two-dimensional code creating means for creating a two-dimensional code based on a report destination network address and two-dimensional code output means for outputting the two-dimensional code created by the two-dimensional code creating means are provided.

  By taking such a measure, a two-dimensional code including the data of a specific item and the sales report destination network address in the total data by item is printed out on a recording paper, for example, or displayed on a display. The Therefore, when this two-dimensional code is read using the function of a two-dimensional code reader of an electronic communication device such as a mobile phone, the electronic communication device is a server on the network designated by an address in the two-dimensional code, For example, it becomes possible to access a mail server specified by an e-mail address. The specific item data in the two-dimensional code can be transferred to the server.

  Therefore, according to the present invention, even if it becomes necessary to report the sales situation of a store to any place other than a store that is not connected by a dedicated line, product sales data that can be easily dealt with and can reduce the burden on the reporter A processing device can be provided.

The best mode for carrying out the present invention will be described below with reference to the drawings.
This embodiment is a case where the sales situation of a store is reported to an arbitrary place other than a store not connected by a dedicated line by using an electronic mail system using the Internet. This is a case where the present invention is applied to a single electronic cash register for registration.

First, an outline of the present embodiment will be described with reference to FIG.
As shown in the figure, in the present embodiment, a two-dimensional code 3 is printed on a sales report 2 that is printed and issued from the electronic cash register 1. It is assumed that the two-dimensional code 3 is encoded with an address on the network that designates the mail server 4 that is the sales report destination, that is, an e-mail address, together with the total data of the items that require the sales report.

  Thus, when the mobile phone 5 having the function of a 2D code reader reads the 2D code 3 of the sales report 2, the mobile phone 5 is designated by the e-mail address in the 2D code 3. The mail server 4 on the Internet 6 can be accessed via the mobile base station 7. When the line with the mail server 4 is connected, the specific item total data in the two-dimensional code 3 is edited into an e-mail format and transmitted to the mail server 4.

  Therefore, by reading the e-mail transmitted to the mail server 4 using a personal computer or a mobile phone equipped with mail software, even if it is in any place other than the store that is not connected by a dedicated line, Aggregated data for specific items can be confirmed.

Next, the configuration of the electronic cash register 1 according to the present invention will be described in detail with reference to FIGS.
FIG. 2 is a block diagram showing a main configuration of the electronic cash register 1. The electronic cash register 1 includes a CPU (Central Processing Unit) 11 as a control unit body. The CPU 11 is connected to a ROM (Read Only Memory) 12 and a RAM (Random Access Memory) 13 constituting a main storage unit via a bus line such as an address bus and a data bus, and a clock for measuring the current date and time. The controller 14, the I / O port 15 for inputting and outputting signals, and the keyboard 20, the operator display 21, the customer display 22, and the controllers 16, 17, 18 and 19 of the printer 23 are connected.

  Connected to the I / O port 15 are a mode switch 24 for switching various business modes such as “registration”, “inspection”, “settlement”, “setting”, and a drawer 25 for accommodating cash and the like. Yes. Incidentally, “registration” is a business mode in which the sales data of each product for which sales have been input are tabulated by item. Items include items by sales such as total sales and net sales, items by transaction such as cash transactions, credit transactions and credit transactions, items by product category such as meat, fish, vegetables, beverages and alcoholic beverages, etc. It is. “Inspection” is a business mode in which data aggregated by item is edited into a report format and displayed or printed out as an inspection report. “Checkout” is a mode of business in which the total data for each item is cleared after the checkout report is output in the same manner as the inspection report. “Setting” is a job mode in which data necessary for executing various jobs is set in the memory in advance.

  The keyboard 20 has various function keys such as a product classification key, a subtotal key, a current total key, a total key, a credit key, a cancel key, a discount key, in addition to a numeric key for entering numerical data. This is only for the electronic cash register.

  The printer 23 prints detailed transaction data on receipt paper and journal paper. The printed receipt paper is issued as a receipt from the receipt issuing port for each business transaction, and the journal paper is wound up inside the apparatus. It has become.

  The RAM 13 is formed with an item-by-item total memory for totaling product sales data by item. Items include items by sales such as total sales, net sales, items by transaction such as cash transactions, credit transactions, credit transactions, items by product category such as meat, fish, vegetables, beverages, alcoholic beverages, Items by amount, such as tax amount, deposit amount, discount amount, discount amount.

  In the electronic cash register 1 having such a configuration, when the “registration” mode is selected by the mode switch 16, a predetermined registration screen is displayed on the operator display 21 and the customer display 22. When product sales data (product classification code, sales points, unit price, etc.) of a commercial transaction that is sold by key operation of the keyboard 20 is input, the product category name, price (sales point × unit price), etc. are displayed on the registration screen. . Next, when a closing key for declaring the closing of sales of the commercial transaction (current total key, multiplying key, credit key, etc.) is input, the total amount of the commercial transaction is calculated and displayed on the registration screen. In addition, each item sales data input by sales in this commercial transaction is aggregated by item on the item-by-item aggregation memory.

  On the other hand, when the “settlement” mode is selected by the mode switch 16, a settlement menu screen is displayed on the operator display 21. Here, when the operator selects, for example, a settlement report output menu, data aggregated by item in the item-by-item aggregation memory is edited into report format print data. Then, it is supplied to the printer 23 and printed out on the receipt paper as a settlement report. Thereafter, when the end of the settlement mode is declared, the data in the item-by-item total memory is cleared.

By the way, in this embodiment, the electronic cash register 1 has a function of issuing a sales report 2 on which a two-dimensional code 3 is printed. That is, in order to realize this function, the electronic cash register 1 forms a store name setting memory 31, a mail address setting table 32, and a report item selection table 33 in the RAM 13, as shown in FIG.
In the store name setting memory 31, store name data of a store where the electronic cash register 1 is operating is set.

  In the mail address setting table 32, a name of a destination registered as a sales report destination and an e-mail address owned by the destination are set. In the mail address setting table 32, a plurality of destination names and e-mail addresses can be set in pairs. The mail address setting table 32 is added with a selection flag for identifying whether or not the destination is selected for each destination name, and the destination selection flag set first as the default is “ It is set to “1” (selected state), and the selection flags of other destinations are reset to “0” (non-selected state).

  In the report item selection table 33, a plurality of names of items registered as sales report items are set. Incidentally, the item registered as the sales report item is an arbitrary item among the items for which data is totaled in the item-based total memory. The report item selection table 33 includes, for each item name, total data of the item and a selection flag for identifying whether or not the item is in a selected state. Cleared to “0”, each selection flag corresponding to the first set item name is set to “1” (selected state), and other destination selection flags are set to “0” (non-selected state) ) Has been reset.

  Accordingly, when the operator selects the sales report work menu on the checkout menu screen with the “checkout” mode selected by the mode switch 16, the program is configured such that the CPU 11 executes the processing shown in the flowchart of FIG. 4. ing.

  That is, the CPU 11 starts this process when detecting that the sales report work menu is selected, and displays the sales report item selection screen 40 on the operator display 21 as ST (step) 1.

An example of the sales report item selection screen 40 is shown in FIG. As shown in the figure, the sales report item selection screen 40 displays the item names set in the report item selection table 33 in numerical order. The number of the item name for which the selection flag is set to “1” is a circled number. As operation guidance, the operation procedure for selecting an item (number + subtotal), the operation procedure for canceling the selection (number + cancellation), and the operation procedure for declaring the end of selection (current total) are displayed. ing.
Note that the method of distinguishing the item for which the selection flag is set to “1” from other items is not limited to the method of using a circled number, and may be distinguished by, for example, the number or the color of the item name.

  The CPU 11 waits for an item selection operation, a selection cancellation operation, or a selection end declaration operation to be performed. Here, when the number corresponding to any item name is entered with the numeric keys of the keyboard 20, and then the subtotal key is confirmed to be operated, the CPU 11 determines that the item selection operation has been performed as ST2. To do. In ST3, the selection flag of the report item selection table 33 corresponding to the selected item name is set to “1”. The number of the item name displayed on the sales report item selection screen 40 is a circled number. After that, it waits for an item selection operation to be performed again, a selection cancellation operation to be performed, or a selection end declaration operation to be performed.

  On the other hand, when it is confirmed that the number corresponding to any of the item names is entered with the numeric keys of the keyboard 20 and the cancel key is subsequently operated, the CPU 11 determines that the selection cancel operation has been performed as ST4. . In ST5, the selection flag of the report item selection table 33 corresponding to the item name whose selection is canceled is set to “0”. The number of the item name displayed on the sales report item selection screen 40 is a normal number not circled. After that, it waits for an item selection operation to be performed again, a selection cancellation operation to be performed, or a selection end declaration operation to be performed.

  On the other hand, when it is confirmed that the current key on the keyboard 20 has been operated, the CPU 11 determines that a selection end declaration operation has been performed in ST6. In ST7, the screen of the operator display 21 is switched from the sales report item selection screen 40 to the destination selection screen 50.

An example of the destination selection screen 50 is shown in FIG. As shown in the figure, the destination selection screen 50 displays each destination name set in the mail address setting table 32 in numerical order. The number of the destination name for which the selection flag is set to “1” is a circled number. As operation guidance, an operation procedure (number + subtotal) for selecting a destination and an operation procedure (current total) for declaring the end of selection are displayed.
Note that the method of distinguishing a destination whose selection flag is set to “1” and other destinations is not limited to the method of using a circled number, and may be distinguished by, for example, the number or the color of the destination name.

  The CPU 11 waits for a destination selection operation or a selection end declaration operation. Here, when it is confirmed that a number corresponding to one of the destination names is entered using the numeric keys of the keyboard 20 and the subtotal key is operated, the CPU 11 determines that the destination selection operation has been performed in ST8. To do. In ST9, the selection flag of the mail address setting table 32 corresponding to the selected destination name is set to “1”, and the selection flag of the mail address setting table 33 corresponding to the other destination name is reset to “0”. To do. Further, among the destination names displayed on the destination selection screen 50, the number of the destination name whose selection flag is set to “1” is set as a circle number, and the numbers of other destination names are set as normal numbers. Thereafter, it waits for the destination selection operation to be performed again or the selection end declaration operation to be performed.

  On the other hand, when confirming that the current key on the keyboard 20 has been operated, the CPU 11 determines that a selection end declaration operation has been performed in ST10. Then, as ST11, sales report report creation processing specifically shown in FIG. 5 is executed.

  That is, the CPU 11 refers to the report item selection table 33 and determines whether there is an item selected as a sales report item. Here, if the selection flag corresponding to each item name has been reset to “0”, there is no selection item, so this processing is terminated. That is, no sales report is output.

  On the other hand, when the selection flag corresponding to at least one item name is set to “1”, the sales summary item of the item name corresponding to this selection flag is selected as the item for sales report. Therefore, the CPU 11 reads the total data of the selection item from the total memory for each item, and sets it in the data area corresponding to the corresponding item name in the report item selection table 33. When a plurality of items are selected, the respective aggregated data is read and set in the report item selection table 33.

  Next, the CPU 11 refers to the mail address setting table 32 and acquires the mail address of the destination whose selection flag is set to “1”. Further, the store name data set in the store name setting memory 31 and the current date data timed by the clock unit 14 are also acquired. A character string code is created in the order of store name, date, e-mail address, selected item name, and aggregated data of the item, and this character string code is converted into a two-dimensional code using a commercially available two-dimensional code conversion software. Convert (two-dimensional code creation means).

  Thereafter, the CPU 11 edits the print data such as the date, the title “sales report”, the selected item name, and the total data of the item, and outputs it to the printer 23 for printing on the receipt paper. If the printing data of the two-dimensional code is edited and output to the printer 23 and printed on the receipt paper (two-dimensional code output means), the receipt paper is cut and issued as a sales report 2. ing.

  The electronic cash register 1 configured as described above is used as a cash register for a store where it is necessary to report the sales status of the store to an arbitrary place other than a store not connected through a dedicated line. Then, using this electronic cash register 1, sales data of each product sold at the store is registered. The sales data of each registered product includes items by sales such as total sales and net sales, items by transaction such as cash transactions, credit transactions, and margin transactions, meat, fish, vegetables, beverages, and alcoholic beverages. The items are classified into items such as by product category.

  Now, for example, the store manager of the store, when the business day ends, switches the mode switch 24 and selects the “settlement” mode. Then, the sales report business menu is selected from the checkout menu. Then, the sales report item selection screen 40 is displayed on the operator display 21. If the data shown in FIG. 3 is set in the report item selection table 33, the sales report item selection screen 40 having the contents shown in FIG. 6 is displayed.

  Here, when reporting only the total sales to an arbitrary place other than the store, the store manager presses the current total key. For example, when reporting the total sales and the number of customers, the store manager sets “2”, operates the subtotal key, and then presses the current total key. Further, when reporting the number of customers and the total tax, the store manager sets “2” and presses the subtotal key, “3” sets and presses the subtotal key, and “1”. After performing the operation of pressing the cancel key, the current key is operated.

  When any operation is performed, the screen of the operator display 21 is switched to the destination selection screen 50. If the data shown in FIG. 3 is set in the mail address setting table 32, the destination selection screen 50 having the contents shown in FIG. 7 is displayed.

  Here, when making a sales report to the headquarters, the store manager presses the current total key. For example, when a sales report is made to a personal computer at the president's home, the store manager sets “2”, operates the subtotal key, and then presses the current total key. Further, when reporting sales to the president's mobile phone, the store manager enters “3”, presses the subtotal key, and then operates the current total key.

  When either operation is performed, the sales report output process is executed. For example, if total sales is selected as the sales report item and the president's home is selected as the destination, the store name, today's date, the e-mail address of the personal computer at the president's home, and tabulation A two-dimensional code 3 is created from each data of the item name “total sales” and its total amount. The two-dimensional code 3 is printed on receipt paper by the printer 23 and issued as a sales report 2.

  Therefore, the store manager reads the two-dimensional code 3 of the sales report 2 with the mobile phone 5 having the function of a two-dimensional code reader. Then, the mobile phone 5 can access the mail server 4 on the Internet 6 specified by the electronic mail address in the two-dimensional code 3 via the mobile base station 7. When the line with the mail server 4 is connected, the aggregated data of the store name, date, and item “total sales” in the two-dimensional code 3 is edited into an e-mail format and transmitted to the mail server 4. Is done.

  Therefore, the president who owns the e-mail address reads out the e-mail transmitted to the e-mail server 4 using a personal computer equipped with e-mail software. Even if you are in any place, you can check the total daily sales data of the store.

  As described above, according to the present embodiment, for example, a store manager may need to report the sales situation of a store to any location other than a store that is not connected through a dedicated line, such as the president's home. By simply performing a simple operation of reading the two-dimensional code 3 printed on the sales report 2, it is possible to reliably report the accurate total data, so that the settlement report can be made using communication means such as telephone, facsimile and the Internet. Compared to the previous case where the contents of the report were reported, the burden on the reporter can be greatly reduced.

  Further, in the present embodiment, the sales report 2 is printed on the receipt paper and issued by using the printer 23 in the same manner as the settlement report. Therefore, a special mechanism for obtaining the sales report 2 is not required, and there is an advantage that the current electronic cash register 1 mechanism can easily cope with it.

  Further, in the present embodiment, the operator selects at least one item from the items set in the report item selection table 33 on the sales report item selection screen 40, so that the total data of all the selected items is obtained. A two-dimensional code 3 including it is created and printed on the sales report 2. Therefore, since the items for reporting the sales situation can be easily selected, there is also an effect that only information of necessary items can be accurately reported when necessary.

  The present invention is not limited to the above-described embodiment as it is, and can be embodied by modifying the constituent elements without departing from the scope of the invention in the implementation stage.

  For example, in the above-described embodiment, the case where the two-dimensional code 3 is printed on a receipt sheet and issued as the sales report 2 is output so that the two-dimensional code 3 can be read by the two-dimensional code reader. Even in a simple electronic cash register 1 not equipped with a printer 23 for printing, as shown in FIG. 8, the sales report 2 is printed on a portable printer 27 connected by wire or wirelessly via a communication interface 26. By transmitting and outputting the data, the sales report 2 with the two-dimensional code 3 printed thereon can be obtained. In FIG. 8, parts that are the same as those in FIG.

  In addition, since the two-dimensional code reader equipped in the mobile phone or the like can also read the two-dimensional code displayed on the screen, the two-dimensional code 3 created by the two-dimensional code creating means is displayed on the operator display 21, for example. May be displayed and output of the sales report 2 may be omitted.

  In the above embodiment, the sales report item is selected first as the processing procedure of the sales report work, and the destination is selected later. However, the selection order may be reversed. Further, although the number of destinations is limited to one, a plurality of destinations may be selected at the same time so that two-dimensional coding can be performed.

  Further, the present invention is not limited to the electronic cash register 1, but can be applied to general merchandise sales data processing devices such as a POS terminal and an electronic fee scale having a function of totaling merchandise sales data by item.

  In addition, various inventions can be formed by appropriately combining a plurality of constituent elements disclosed in the embodiment. For example, some components may be deleted from all the components shown in the embodiment. Furthermore, the constituent elements over different embodiments may be combined.

The schematic diagram used for outline | summary description of one embodiment which concerns on this invention. The block diagram which shows the principal part structure of the electronic cash register in the embodiment. The schematic diagram which shows the main memory areas formed in RAM of the same electronic cash register. The flowchart which shows the principal process procedure of the sales report business process which CPU of the same electronic cash register performs. The flowchart which shows the specific procedure of the sales report report output process in FIG. The top view which shows an example of a sales report item selection screen. The top view which shows an example of a destination selection screen. The block diagram which shows the principal part structure of the electronic cash register in other embodiment.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... Electronic cash register, 2 ... Sales report, 3 ... Two-dimensional code, 5 ... Mail server, 5 ... Mobile phone, 6 ... Internet, 7 ... Mobile base station, 11 ... CPU, 14 ... Clock part, 20 ... Keyboard, 21 ... operator display, 22 ... customer display, 23 ... printer, 31 ... store name memory, 32 ... mail address setting table, 33 ... report item selection table.

Claims (6)

In the product sales data processing device that aggregates the sales data of each product entered for sales by item and outputs this aggregated data by item in a report format,
A two-dimensional code creating means for creating a two-dimensional code from the aggregated data of a specific item among the aggregated data by item and an address on a network indicating a sales report destination;
Two-dimensional code output means for outputting the two-dimensional code created by the two-dimensional code creating means;
A product sales data processing apparatus characterized by comprising:   2. The merchandise sales data processing apparatus according to claim 1, wherein the two-dimensional code output means outputs the total data classified by item by the same means as that for outputting the report data in a report format.   2. The merchandise sales data processing apparatus according to claim 1, wherein the two-dimensional code output means is means for printing out on a recording sheet by a printer mounted on the apparatus.   2. The commodity sales data processing apparatus according to claim 1, wherein the two-dimensional code output means is means for transmitting and outputting to a printer connected to the apparatus by communication means. Provide item selection means to select items for sales report,
The two-dimensional code creating means creates a two-dimensional code from the aggregated data of the items selected by the item selecting means in the item-by-item aggregated data and a network address indicating a sales report destination. The merchandise sales data processing apparatus according to claim 1. An address selection means for selecting an address on the network indicating the sales report destination is provided.
2. The two-dimensional code creation means creates a two-dimensional code from data of a specific item in the total data by item and an address on the network selected by the address selection means. Product sales data processing device.

Images