JPH10241056A - Commodity sales data totalizing processor - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce labor required for tabulation by editing the item names of a commodity sales totalizing file and a text file of item-sorted totalization value data and entering application software for tabulation to a loaded computer equipment. SOLUTION: A personal computer installs table calculation software and prints out or displays data inputted from a store computer as a table of commodity sales totalizing data. When an output item and an output destination are specified one by one by key input or the like, the commodity sales data of the specified item are extracted from an experience file (ST2). Then the totalization or the like of extracted commodity sales data is executed and a commodity sales totalization file is prepared in a RAM (ST3). When 'printing' e.g. is specified as an output destination (ST4), printing data developed to a report image are edited from the data of the commodity sales totalization file (ST5).

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to the sale of products registered for sale, such as a store computer or a POS terminal of a POS (Point of Sale Information) system constructed in the distribution industry such as a supermarket and a convenience store. The present invention relates to a merchandise sales data totaling processing device for totalizing data.

[0002]

2. Description of the Related Art FIG. 8 shows an example of a conventional POS system. In this POS system, a plurality of merchandise sales data registration devices, a plurality of merchandise sales data registration devices,
A so-called POS terminal 3 is connected. Also, a personal computer 5 is connected to the store computer 1 via a communication line 4 such as a LAN (local area network) line.

The store computer 1 collects sales data of each product registered for sale at each POS terminal 3 via the communication line 2 and writes and stores the sales data in a performance file 6 formed on a hard disk device or the like. And
For example, when the printing operation of the department code-specific sales report is selected, the sales data of each product accumulated in the performance file 6 is totaled by the department code, and a sales total file for each department code is created. Next, print data of a report image is created from the data of the sales totalization file.
The print data was sent to the printer 7 to print out a sales report for each department code.

[0004] For example, when the operation of creating a section code-based sales list is selected, a sales tabulation file for each section code is created in the same manner as described above, and as shown in FIG. A communication message 9 expressing the file data in the ASCII code format is created. Further, a function of transmitting and outputting the communication message 9 to the personal computer 5 was provided. By the way, this communication message 9
Is composed of a header [BUMON] for identifying the type of message, and sequentially added sales total data (department code, number of sales points, number of customers, sales amount) of each section.

On the other hand, the personal computer 5 is installed with commercially available application software having functions such as table creation, numerical calculation, and graph creation, so-called spreadsheet software 8. When the control unit of the personal computer 5 receives the communication message 9, the control unit of the personal computer 5 obtains the sales summary data of each section from the communication message 9 for each item, and obtains the table from the sales summary data and the data of the preset item name. Under the control of the calculation software 8, tabulation is performed and printed or displayed.

[0006]

As described above, in this kind of conventional POS system, the personal computer 5 on which the spreadsheet software 8 is installed is operated by a user.
Commodity sales data aggregation processing device (store computer 1)
Since it is necessary to analyze the communication message 9 received from the PC to acquire the sales summary data for each item, for example, the digits of the communication message 9 to the number of digits are the department code, It is necessary to define in the personal computer 5 in advance the data necessary for the analysis of the electronic message, such as the number of digits to the sales digit. In addition, it has been troublesome to set item names such as “department code” and “sales points” in the personal computer 5 in advance.

[0007] The present invention has been made in view of such circumstances, and it is an object of the present invention to provide a method for calculating total sales of merchandise using a commercially available application software for tabulation without processing the data in a computer device. The purpose of the present invention is to provide a merchandise sales data totaling processing apparatus capable of creating a list of items and reducing the time and effort required for tabulation.

[0008]

SUMMARY OF THE INVENTION According to the present invention, there is provided a merchandise sales data totaling processor for totalizing sales data of each registered merchandise and creating a merchandise sales totalization file. A means for editing a text file in which the data of another tabulated value is expanded into a tabular image as a character string, and a means for importing the data of the text file into a computer device equipped with application software for tabulating. Things.

In this, the text file is
This is a CSV-format text file in which data items of a character string are separated by commas and the end of one record is separated by a line feed code. The data of the product sales totalization file for editing the text file is data to be printed out by the product sales data totalization processing device.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings. In this embodiment,
This is a case where the present invention is applied to the store computer 1 of the POS system shown in FIG. 8, and the same parts as those in FIG.

FIG. 1 is a block diagram showing the configuration of a main part of a store computer 1 as a merchandise sales data totaling apparatus. The main components of the computer are a CPU (central processing unit) 11 and a ROM (read only memory). 12
And RAM (random access memory) 13,
A clock unit 14 for measuring the date and time, a communication interface 15 for controlling data communication with each POS terminal 3 connected via the communication line 2, and a communication interface 16 for controlling data communication with a personal computer 15 connected via the communication line 4. , FDD (Floppy Disk Driver) 17, FDD Controller 18, HDD
(Hard disk driver) HDD for controlling 19
A controller 20, a printer controller 21 for outputting print data to the printer 7, a display controller 23 for outputting display data to the display 22, a keyboard controller 25 for receiving a key signal corresponding to an operation key from a keyboard 24, etc. I have. And the CPU 1
1, a ROM 12, a RAM 13, a clock section 14, both communication interfaces 15, 16 and respective controllers 18, 2.
0, 21, 23, and 25 are connected by bus lines 26 such as an address bus and a data bus.

The personal computer 5 has spreadsheet software 8 installed therein, and prints or displays a list of merchandise sales total data based on data taken from the store computer 1.

Then, the CPU of the store computer 1
11 collects, via the communication interface 15, the sales data of each product registered for sale at a plurality of POS terminals 3 (product sales data registration devices) connected by the communication line 2, and collects the product sales data. The results are sequentially written and accumulated in the result file 6 formed on the hard disk device 19.

When the output operation of the sales summary report is selected by the key input of the keyboard 24 or the like, the processing shown in the flowchart of FIG. 2 is executed. First,
As ST (Step 1), the process waits until the output items (for each department code, class code, time zone, cashier, etc.) and the output destination (tabulation, printing, display) are designated and input. When one output item and one output destination are designated by key input of the keyboard 24 or the like, ST
As 2, merchandise sales data corresponding to the designated output item is extracted from the performance file 6. Then, the merchandise sales data extracted as ST3 is totaled and sorted, and the RAM 13
Create a product sales summary file above.

FIG. 4 shows an example of the merchandise sales totalization file 30 when "by department code" is specified as an output item. The merchandise sales totalization file 30 includes the first record 31 as “department code”, “sales points”, “sales number”,
The second record 32 is composed of the data of the sales sum of each item of the department code 1, and the third record 33 is the data of each item of the department code 2. Consists of aggregated value data.

Next, the CPU 11 determines the designated output destination as ST4. If "print" is specified as the output destination, the print data developed into a report image in a preset format based on the size of the recording paper from the data of the merchandise sales totalization file in step ST5. Edit. Then, if the print data is sent to the printer 7 in ST6, the current process is terminated.

If "display" is designated as the output destination in ST4, the data in the merchandise sales totalization file is specified in ST7 in a preset format based on the screen size of the display unit 22 in ST7. Edit the display data expanded in the report image. And ST8
If the above display data is sent to the display 22,
This processing ends.

If "table" is specified as the output destination in ST4, the data of the item name and the total value for each item are tabulated from the data of the commodity sales total file in ST9. Edit the text file expanded to the image. Then, if the data of the text file is transmitted to the personal computer 5 connected via the communication line 4 via the communication interface 16 and is taken into the personal computer 5, the current processing is terminated.

FIG. 3 is a flowchart showing a specific example of a process for editing a text file from the data of the commodity sales totalization file. In this example, CSV (Comma Separa) is used to separate character string data items with commas [,] and to separate the end of one record with line feed codes [CR / LF].
This shows a case where a text file of the ted Value) format is edited.

First, the RAM shown in FIG.
13 and the record counter i is reset to [0]. Next, if the record counter i is counted up by [+1] in ST12, the i-th record is acquired from the commodity sales totalization file in ST13.

If the i-th record has been obtained (YES in ST14), the item counter j is reset to [1] in ST15. Next, if the item counter j is counted up by [+1] in ST16, the j-th item data is obtained from the i-th record in ST17.

Here, if the j-th item data has been obtained (YES in ST18), it is determined in ST19 whether the data is a character or a numerical value. In the case of a character such as an item name, ST20 to ST22 are stored in the area i of the buffer 40 in the order of double quotation ["], corresponding character data, and double quotation ["]. On the other hand, in the case of numerical data such as an aggregated value for each item, the numerical value is converted into character data in ST23 to ST24, and the character data is stored in the area i of the buffer 40. After a while, ST25
After the comma [,] is stored in the area i of the buffer 40 and the process returns to ST16, the item counter j is counted up by [+1], and the processes of ST17 to ST24 are repeated.

In this way, each item data existing in the i-th record is stored in the area i of the buffer while being sequentially separated by commas [,]. If it is confirmed in step ST18 that the j-th item data does not exist in the i-th record, a line feed code [CR / LF] is stored in the area i of the buffer 40 in step ST25, and the process returns to step ST12. After counting up by [+1], ST1
Steps 3 to ST25 are repeated.

In this way, the CSV converted character strings of each record of the sales summary data file are sequentially stored in the buffer 40. Then, if it is confirmed in step ST14 that the i-th record does not exist in the sales summary data file, in step ST26, the CSV-converted character strings stored in the areas 1 to (i-1) of the buffer 40 are read. Create a text file.

FIG. 6 shows an example of a text file 50 composed of character strings obtained by converting the product sales totalization file 30 for each department code shown in FIG. 4 into CSV. In the personal computer 5 incorporating the text file 50, character data delimited by commas [,] in the text file 50 is set one by one in a table frame, so that the data is processed as shown in FIG. A list 60 of the section-based merchandise sales total data as shown is created and printed or displayed.

As described above, according to the present embodiment, a list of the merchandise sales total data is created using the commercially available spreadsheet software 8 without processing the data fetched from the store computer 1 in the personal computer 5. Since it is possible, it is not necessary to define the data structure and set the item names for the personal computer 5 in advance. Therefore, a list of desired sales summary data can be created using commercially available spreadsheet software 8 without trouble and without errors.

In the above-described embodiment, the text file of the tabulated image created by the store computer 1 is transmitted to the personal computer 5 via the communication line 4 and is output to the personal computer 5. However, the text file may be recorded on the floppy disk FD, which is a portable recording medium that can be read by a computer device, via the FDD 17 so as to be loaded into the personal computer 5. Further, the merchandise sales data totaling processor does not collect data from the POS terminal 3 connected to the line, but fetches the merchandise sales data written on a portable recording medium such as a floppy disk by an electronic cash register. It may be collected by things. In addition, a portable recording medium for recording the product sales data and the text file may be an IC card or an optical disk other than the floppy disk.

The present invention is not limited to a store computer, but can be applied to a POS terminal. In addition, it goes without saying that various modifications can be made without departing from the spirit of the present invention.

[0029]

As described in detail above, according to the present invention,
A product sales data aggregation processing device that can create a list of product sales aggregation data using application software for commercial table creation without processing data in computer equipment, and can reduce the labor required for creating the above list Can be provided.

[Brief description of the drawings]

FIG. 1 is an exemplary block diagram illustrating a main configuration of a store computer according to an embodiment of the present invention;

FIG. 2 is a flowchart showing a processing procedure of a sales summary report output job executed by a CPU of the store computer.

FIG. 3 is a flowchart specifically showing a text file editing process of a tabular image in FIG. 2;

FIG. 4 is an example diagram of a product sales totalization file created in the processing shown in FIG. 2;

FIG. 5 is a conceptual diagram of a buffer used in the processing shown in FIG. 3;

FIG. 6 is a view showing an example of a text file created in the processing shown in FIG. 3;

FIG. 7 is a diagram showing an example of a commodity sales summary data list output from a personal computer.

FIG. 8 is a schematic diagram of a POS system including the merchandise sales data aggregation processing device of the present invention.

FIG. 9 is a diagram showing a message format of conventional product sales total data.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Store computer (commodity sales data totaling processing device) 3 ... POS terminal (commodity sales data registration device) 5 ... Personal computer 6 ... Result file 7 ... Printer 8 ... Spreadsheet software 30 ... Commodity sales totaling file 40 ... Buffer 50 ... Text file 60 ... Product sales summary data list

Claims (3)

[Claims] 1. A merchandise sales data summarization processing apparatus for summarizing sales data of each registered merchandise and creating a merchandise sales summarization file, comprising: Product sales characterized by comprising means for editing a text file developed into a tabular image in columns and means for importing the data of the text file into a computer device having application software for tabulation. Data aggregation processing device. 2. The merchandise sales data totaling processing device according to claim 1, wherein the text file is a CSV text file in which character string data items are separated by commas and the end of one record is separated by a line feed code. A merchandise sales data tallying processor. 3. The merchandise sales data totaling device according to claim 1, wherein the data of the merchandise sales totalizing file for editing the text file is data to be printed out by the merchandise sales data totaling processing device. Product sales data aggregation processing device.