JPH08320970A - Commodity sales registering data processing system - Google Patents

Abstract

PURPOSE: To surely deal with a change in a selling price by transmitting read selling price data to an inquiring commodity sales registering terminal at the time of confirming no storage of a sort code, and at the time of confirming that the code has been stored, changing the read selling price data and then transmitting the changed contents to the terminal. CONSTITUTION: When a sort code inquiry message is received (ST1), a commodity master file is retrieved as an inquired code in the message, selling price data are read out from the file and a maker code in the message is extracted (ST3). Whether the maker code has been stored in a selling price changing file or not is retrieved (ST4). When the code has not been stored, the selling price data read out from the commodity master file are transmitted to an inquiring commodity sales registering terminal (ST5). When the code has been stored, the selling price data are changed based upon the selling price information of each change section corresponding to the sort code and the changed contents are transmitted to the terminal (ST to ST8).

Description

Detailed Description of the Invention

[0001]

The present invention relates to a supermarket,
The present invention relates to a product sales registration data processing system used by a retail store such as a department store, a so-called POS (Point of Sales) system.

[0002]

2. Description of the Related Art An outline of a conventional general POS system is shown in FIG. This system comprises a plurality of product sales registration terminals 2 each equipped with a bar code scanner 1 for optically reading a bar code, and a department code, name, selling price, etc. for each product code set for each product. And a file control unit 4 having a product master file 3 in which the product data is stored in advance by a first communication line 5, and a host computer 6 is connected to the file control unit 4 by a second communication line 7. Is built by.
And, for each product sold at stores that introduce this POS system, JAN (Japanese Article Number)
A product code called a code is printed in the form of a bar code, and when the bar code printed on the product sold by the bar code scanner 1 is read, the product sales registration terminal 2
Creates an inquiry message having the data structure shown in FIG. 7A and sends it to the file control unit 4 via the communication line 5.
Here, in FIG. 7A, 71 is a destination address, and the communication address FPID of the file control unit 4 is set. Reference numeral 72 is a transmission source address in which a communication address TMID unique to the product sale registration terminal 2 is set. Reference numeral 73 is a message classification in which a classification code indicating an inquiry message is set. 74 is an inquiry code,
A JAN code obtained by converting the barcode read by the barcode scanner 1 is set.

On the other hand, the file control unit 4 which has received the inquiry message reads out the product data such as the department, name and selling price corresponding to the JAN code 74 in the message from the product master file 3. Then, if the product data is incorporated in the response message having the data structure shown in FIG. 7B, this response message is transmitted to the inquired product sales registration terminal 2 via the communication line 5. . Here, FIG.
In (b), reference numeral 75 is a destination address, and the communication address TMID of the commodity sales registration terminal 2 which is the source address 62 in the inquiry message is set. A source address 76 is set with the communication address FPID of the file control unit 4. Reference numeral 77 is a message classification, in which a classification code indicating a response message is set. Reference numeral 78 is a response code in which the JAN code in the inquiry message is set. 79a to 79c are product data read from the product master file.

In the commodity sales registration terminal 2 which has received the response message, the selling price data 79c in the message is received.
When the sales amount is calculated by multiplying by the sales amount of the sale product, the sales amount and the sales amount are registered in the internal storage unit together with the JAN code 78 and the department code 79a in the message. Further, the number of sales, the amount of sales, and the like are displayed on a display together with the name data 79b in the message, and printed out on a receipt paper or the like by a printer.

Each product sales data registered in the internal storage unit of each product sales registration terminal 2 is collected by the file control unit 4 at appropriate times via the communication line 5 and classified by JAN code or department code. It is totaled. The data collected by the file controller 4 is collected by the host computer 6 via the communication line 7, processed into report data necessary for sales analysis of the store, and output.

The host computer 6 can also maintain the product master file 3. Therefore, in the past, for example, in the case of discounting the selling price of a part of the product by a special sale, the host computer 6 is operated to sell the selling price data corresponding to each product code of the discounted product after the discounting. I was dealing with it by updating to.

However, when there are many types of products whose selling prices are to be changed, such as a uniform 5% discount on all products of a specific manufacturer (manufacturer of products), the product master file 3
The load required for maintenance is heavy, and it has to spend a long time. Also, in the case of discounting for a limited time like a special sale, the selling price data of each product to be changed is updated to the discounted selling price data before the special sale period, and after the special sale period, the original price is restored. You have to revert to selling price data. Therefore, in the case where there are many types of products whose sales prices are to be changed or when the selling prices are to be restored in a short period of time, the selling price data in the product master file 3 should not be changed, and the product master should not be changed. Sales registration processing is performed using the normal selling price data set in the file 3, and thereafter, a so-called cashier who operates the product sales registration terminal 2 manually deals with discounting processing of each product. Didn't get

[0008]

As described above, in the conventional merchandise sales registration data processing system of this type, there are many kinds of merchandise whose selling prices are to be changed, and the selling price data must be restored in a short period of time. Therefore, if it is difficult to update each selling price data in the product master file 3 in terms of efficiency, the product selling registration terminal 2 registers the sales with the normal selling price data set in the product master file 3. A so-called cashier who processes the product and then operates the product sales registration terminal 2 manually carries out the discount processing of each product, and the cashier's burden is heavy and there is a risk of forgetting to perform the discount processing. There was also.

The present invention has been made in view of the above circumstances, and an object of the present invention is to provide a product whose selling price is to be changed without changing each selling price data set in the product master file. The changed selling price data can be returned to the product sales registration terminal inquired from the file control unit, even if there are many types of products for which the selling price is changed or the selling price data is restored in a short period of time. Even if it does not happen, the present invention intends to provide a product sales registration data processing system that can promptly and surely deal with a price change with a very small burden.

[0010]

According to the present invention, there is provided a file control unit having a product master file in which at least selling price data for each product code set for each product is stored in advance, and the file control unit communicates with the file control unit. When connected with a line and inputting the product code of the sale product through the input means, the input product code is sent to the file control unit to inquire about the selling price data, and the selling price data corresponding to the input product code is sent from the file control unit When a response is received, in the product sales registration data processing system including a plurality of product sales registration terminals that register and process the sales data of the sales product based on the selling price data, the file control unit classifies the products by a classification code. The selling price change in which the selling price change information for collectively changing the selling prices of the products belonging to the classification code is stored in association with each other An information storage unit, a selling price data reading unit for reading the selling price data corresponding to the input product code from the product master file in response to an inquiry about the selling price data corresponding to the input product code from the product sales registration terminal, and the product In response to the inquiry about the selling price data corresponding to the input product code from the sales registration terminal, the classification code judging device for judging the classification code to which the product of the input product code belongs and the classification code judged by this judging device are displayed. A storage unit searching means for checking whether the selling price change information is stored by the storing price change information storing means, and a commodity sales registration terminal inquired about the selling price data read by the selling price data reading means when it is confirmed by the searching means that the classification code is not stored. It is confirmed by the first selling price data response means to be sent to And second selling price data response means for transmitting the selling price data read by the selling price data reading means with the selling price change information corresponding to the classification code and then transmitting the data to the inquired product sale registration terminal. is there.

[0011]

According to the present invention having such a configuration, when the product code of the product to be sold is input through the input means in the product sales registration terminal, the input product code is transmitted to the file control unit to sell the product. The data is queried. As a result, the file controller reads the selling price data corresponding to the input product code from the product master file. Further, the classification code to which the product of this input product code belongs is determined. Then, it is checked whether or not the determined classification code is stored in the selling price change information storage means. As a result, if it is confirmed that the classification code is not stored, the selling price data read from the product master file is transmitted to the inquired product sales registration terminal. On the other hand, if it is confirmed that the classification code is stored,
It is transmitted after the selling price data read from the product master file is changed with the selling price change information corresponding to the classification code. Therefore, by storing the classification code to which the selling price change target product belongs and the selling price change information by the selling price change information storage means of the file control unit, in response to the selling price data inquiry of each product belonging to this classification code, all the product master files The selling price data obtained by changing the selling price data set in advance based on the selling price change information corresponding to the classification code is returned.

[0012]

DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment in which the present invention is applied to the POS system shown in FIG. 6 will be described below with reference to the drawings. In this embodiment, a JAN code as a product code is printed on each sale product in the form of a barcode, and the JAN code is used as a barcode to register the customer purchase product at each product sale registration terminal 2. The scanning is performed by the scanner 1.

By the way, the JAN code is composed of 13-digit numbers, and as shown in FIG. 1, shows the country code (49 or 45 for Japan) that divides the country in the left two digits, and the product code with the following five digits. The product maker code for classifying the manufacturer (sale source) is shown, and the product item code for classifying individual products is shown by the following five digits. The last one digit is a check digit obtained by calculating a number corresponding to a country code, a product maker code, and a product item code based on a fixed calculation formula.

FIG. 2 is a block diagram showing a main configuration of the file control unit 4 of the POS system. The file control unit 4 serves as a control unit main body and has a central processing unit (CPU).
singUnit) 41 is installed. In addition, the CPU4
ROM (Re
ad Only Memory) 42, RAM (Random Access Memory) 43 in which the product master file 3 and the like are formed, HDD
The HDD controller 45 that controls writing and reading of data to and from the (Hard Disk Drive) 44, and the transmission and reception of data that is performed between each commodity sales registration terminal 2 connected via the first communication line 5 are controlled. A first communication interface 46, a second communication interface 47 for controlling data transmission / reception to / from the host computer 6 connected via the second communication line 7, and the like are mounted, and the CPU 41 and , ROM42, RAM43, H
The DD controller 45 and the first and second communication interfaces 46 and 47 are electrically connected by a bus line 48 such as an address bus and a data bus.

FIG. 3 is an area configuration diagram of the product master file 3 formed in the RAM 43. That is, in the product master file 3, product data such as a department code, a name, and a selling price of the product is preset corresponding to each JAN code of each product. It also has an area for accumulating the number of sales and the amount of sales of each product for each JAN code. The product master file 3 can be maintained by the host computer 6. The selling price data set in the product master file 3 is a normal selling unit price of the corresponding product.

In this embodiment, the RAM 3 is particularly used.
Further, a selling price change file 49 having an area structure shown in FIG. 4 is formed as a selling price change information storage means. The selling price change file 49 stores the amount of change data and the change classification data as selling price change information corresponding to the manufacturer code incorporated in the JAN code, and the change classification data indicates the type of the changed price data. There is. By the way, change classification data = 1 indicates that the change amount data is a discount rate, change classification data = 2 indicates that the change amount data is a discount amount, and change classification data = 3 indicates that the change amount data is the uniform selling price. Is shown. Here, the host computer 6 adds, deletes, and corrects data (manufacturer code, change amount, change classification) to the selling price change file 49 at appropriate times.

When the CPU 41 receives the inquiry message having the data structure shown in FIG. 7A from any of the commodity sales registration terminals 2 via the first communication interface 46, the CPU 41 of FIG. It is controlled by a program in the ROM 42 so as to execute the processing shown in the flowchart. That is, when the CPU 41 confirms that the inquiry message of the JAN code is received in ST (step) 1, the RAM 43 uses the JAN code set as the inquiry code 74 in the message as a search key in ST2.
The product master file 3 above is searched, and product data such as the department code, name, and normal selling price corresponding to the relevant JAN code is read (selling price data reading means).

Next, in ST3, a maker code having numerical values from the third digit to the seventh digit from the left of the JAN code in the message is extracted (classification code determining means). Thereafter, in ST4, it is checked whether or not this maker code is stored in the selling price change file 49 (storage unit searching means). Accordingly, when the same manufacturer code is not stored in the selling price change file 49, the normal selling price in the product data read from the product master file 3 is set as the response selling price in ST5. Then, if a response message having the data structure shown in FIG. 7B including the response selling price is created, the product sales registration terminal inquired of via the first communication interface 46 for the response message. 2 (first selling price data response means).

On the other hand, when the manufacturer code extracted from the JAN code is stored in the selling price change file 49, each data of the changed amount and the changed classification corresponding to the corresponding manufacturer code in the selling price change file 49 is read. put out.
If the change classification data is "1", the change amount data indicates the discount rate. Therefore, in ST6, the discount calculation is performed using the change amount data as the discount rate from the normal selling price in the product data read from the product master file 3. And the calculated result is used as the response selling price. Also, the change classification data is "2"
If so, the change amount data indicates the discount amount, so ST7
As a result, a discount calculation for discounting the changed price data from the normal selling price in the product data read from the product master file 3 is performed, and the calculation result is used as the response selling price. Further, if the change classification data is "3", the change amount data indicates a uniform selling price, and therefore, in ST8, the change amount data is used as the response selling price. In addition, the change classification data is "1", "2",
In cases other than "3", the normal selling price in the product data read from the product master file 3 is used as the response selling price. Then, if a response message having the data structure shown in FIG. 7B including the response selling price is created, the product sales registration terminal inquired of via the first communication interface 46 for the response message. 2 (second selling price data response means). This completes the JAN code inquiry message reception process.

In the POS system of this embodiment configured as described above, when the JAN code printed on the customer purchase product is read by the bar code scanner 1 connected to the product sale registration terminal 2, the product sale registration is performed. An inquiry message including this JAN code is created in the terminal 2 for use, and this inquiry message is transmitted to the file control unit 4.
Then, the file control unit 4 searches the product master file 3 for the JAN code in the inquiry message, and reads the product data such as the department, name, and normal selling price corresponding to this JAN code. Further, the manufacturer code is extracted from this JAN code, and the selling price change file 49 is searched with this manufacturer code. If this maker code is not stored in the selling price change file 49, the product of the manufacturer specified by the corresponding maker code is not the selling price change target, so the normal selling price of the product data read from the product master file 3 is set. A response message having a response selling price is created and transmitted to the inquired product sales registration terminal 2. As a result, the product sales registration terminal 2
In (1), the product sales data is registered based on the sales price data in the response message, that is, the normal selling price of the corresponding product.

On the other hand, when the manufacturer code extracted from the JAN code is stored in the selling price change file 49, since the product of the manufacturer specified by the corresponding manufacturer code is the selling price change target, the selling price change file 49 is displayed.
The sale price change information (change amount, change category) corresponding to the manufacturer code is read from. Then, the normal selling price of the product data read from the product master file 3 is changed based on this selling price change information, a response message is created with the changed selling price data as the response selling price, and the inquired product is produced. It is transmitted to the terminal 2 for sales registration. As a result, in the product sale registration terminal 2, the product sale data is registered based on the sale price data in the response message, that is, the sale price data obtained by changing the normal sale price of the relevant product with the sale price change information of the relevant manufacturer code. .

For example, in the selling price change file 49, the changed amount data "1" corresponding to the manufacturer code "12345"
0 ”and change classification data“ 1 ”are stored, and the manufacturer code“ 1234 ”is now stored in the product sales registration terminal 2.
When the JAN code printed on the manufacturer's product indicated by "5" is read, the normal selling price of this product, for example, 100
An amount of 900 yen, which is a 10% discount on 0 yen, is transmitted as a response selling price from the file control unit 4 to the product sales registration terminal 2, and the sales data of this product is registered.

Further, in the selling price change file 49, the changed amount data "10" is associated with the manufacturer code "23456".
“0” and change classification data “2” are stored. Now, in the product sales registration terminal 2, the manufacturer code “2345” is stored.
When the JAN code printed on the manufacturer's product indicated by "6" is read, the normal selling price of this product, for example, 500
A 400 yen discount of 100 yen to the yen is transmitted as a response selling price from the file control unit 4 to the product sales registration terminal 2, and the sales data of this product is registered.

Further, in the selling price change file 49, the changed amount data "20" is associated with the manufacturer code "34567".
0 ”and change classification data“ 3 ”are stored, and the manufacturer code“ 3456 ”is now stored in the product sales registration terminal 2.
When the JAN code printed on the manufacturer's product indicated by "7" is read, the normal selling price of this product, for example, 300
A uniform selling price of 200 yen for the yen is transmitted from the file control unit 4 to the product sales registration terminal 2 as a response selling price of the corresponding product, and the sales data of this product is registered.

In this way, of all the products sold in the store,
When collectively changing the selling prices such as discounts and discounts for products of a specific manufacturer, the manufacturer code indicating the corresponding manufacturer is displayed in the selling price change file 49 formed in the RAM 43 of the file control unit 4 using the host computer 6. It can be dealt with simply by setting the predetermined selling price change information. To cancel the selling price change, the host computer 6 may be used to delete the maker code data indicating the corresponding manufacturer on the selling price change file 49, or to change the change classification to other than 1 to 3.

Therefore, when carrying out a service of discounting all the products of a specific manufacturer, there are many kinds of products whose selling prices are to be changed, but according to this embodiment, the corresponding manufacturer code and the selling prices are changed. Information and selling price change file 49
Since it is not necessary to individually change the data of the selling price change target product in the product master file 3, it is possible to promptly deal with the selling price change with a very small burden. Further, even when the selling price data is returned to the normal selling price in a short period of time, the corresponding maker code and selling price change information are put in the selling price change file 49.
It is only necessary to delete it from the above, and in this respect also there is an advantage that it can be dealt with promptly with a very small burden.

Since the manufacturer code included in the JAN code is extracted as a means for determining the manufacturer code of the manufacturer of the product, a new code is added to the product master file 3 in order to group a plurality of product codes by manufacturer. It is not necessary to set to. Therefore, there is an effect that the capacity of the product master file 3 can be reduced.

Further, in each commodity sales registration terminal 2, regardless of whether or not the selling price has been changed, the selling price data in the message in which the file control unit 4 responds to the inquiry about the selling price data as in the conventional case. Since the merchandise sales data is registered based on the above, it is possible to process the merchandise without considering whether the selling price is changed or not. Therefore, the selling price can be surely changed without increasing the burden on the cashier.

Although the selling price is collectively changed according to the manufacturers of the products in the above embodiment, the present invention can be applied to the case where the selling prices of all the products belonging to a specific department code are collectively changed. That is, the selling price change file 49
The selling price change information is stored in correspondence with the department code corresponding to, and the selling price change file 49 is searched with the department code in the product data corresponding to the relevant JAN code read from the product master file 3 in response to the inquiry of the JAN code. Then, it is configured to determine whether to change the selling price. By doing so, it is possible to collectively change the selling prices of the products belonging to a specific department without modifying the data of the product master file 3 at all. In the above-mentioned embodiment, there are three types of change categories, but the invention is not limited to this, and additional rates, additional amounts, etc. may be added. Further, the selling price change file 49 may be searched with a code that is a combination of the country code and the manufacturer code in the JAN code, and the presence or absence of the selling price change information may be determined. You may do it.
In addition, it goes without saying that various modifications can be made without departing from the spirit of the present invention.

[0030]

As described above in detail, according to the present invention, it is possible to inquire from the file control unit of the changed selling price data for the product whose selling price is changed without changing the selling price data on the product master file. It is possible to respond to the existing product sales registration terminal, and even if there are many types of products whose selling prices are to be changed or the selling price data has to be restored in a short period of time, surely quickly and with a very small burden It is possible to provide a merchandise sales registration data processing system capable of coping with a change in selling price.

[Brief description of drawings]

FIG. 1 is a diagram showing a format of a JAN code used in an embodiment of the present invention.

FIG. 2 is a block diagram of a main part of a file control unit in the embodiment.

FIG. 3 is an area configuration diagram of a product master file formed in a RAM of the file control unit.

FIG. 4 is an area configuration diagram of a selling price change file formed in a RAM of the file control unit.

FIG. 5 is a JAN executed by the CPU of the file control unit.
The flowchart which shows a code inquiry message reception process.

FIG. 6 is a diagram showing an outline of a general POS system.

7 is a diagram showing a format of a message sent and received in the POS system shown in FIG.

[Explanation of symbols]

 1 ... Bar code scanner 2 ... Product sales registration terminal 3 ... Product master file 4 ... File control unit 41 ... CPU 49 ... Selling price change file

Claims (1)

[Claims] 1. A file control unit having a product master file in which at least selling price data of the product is stored in advance for each product code set for each product, and a communication line is connected to the file control unit and an input means is provided. When the product code of the sold product is input via the above, the input product code is transmitted to the file control unit to inquire about the selling price data, and when the response of the selling price data corresponding to the input product code is received from the file control unit, the selling price is received. In a product sales registration data processing system including a plurality of product sales registration terminals for registering sales data of the sales products based on data, the file control unit includes a classification code for classifying each product and the classification code. Selling price change information for storing the selling price change information for collectively changing the selling prices of products belonging to And a selling price data reading means for reading selling price data corresponding to the input product code from the product master file in response to an inquiry about selling price data corresponding to the input product code from the product sales registration terminal. Classification code determining means for determining the classification code to which the product of the input product code belongs in response to an inquiry about the selling price data corresponding to the input product code from the product sales registration terminal, and the classification determined by this determining means. A storage unit searching means for checking whether the code is stored in the selling price change information storing means, and a product for which an inquiry about the selling price data read by the selling price data reading means is made when it is confirmed by the searching means that the classification code is not stored. The first selling price data responding means to be transmitted to the sales registration terminal, and the classification code by the searching means. Second selling price data response means for transmitting the selling price data read by the selling price data reading means with the selling price change information corresponding to the classification code and then transmitting to the inquired commodity sales registration terminal. A product sales registration data processing system comprising: