JPH10228588A - Merchandise price management device and merchandise price changing method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To allow the person in charge of a selling area to change a price of a corresponding merchandise in a merchandise price file by using the merchandise code of price change object merchandise which is inputted to a data input device in a selling area and a price after change as they are. SOLUTION: A data reading means 6 which reads input data from a portable data input device 5 that is provided with a means which inputs a merchandise code that specifies merchandise and a price of the merchandise after change is provided. When the means 6 reads a merchandise code and price data after change, a merchandise price file 4 is retrieved and the price of merchandise that is specified by the merchandise code is changed to the price after change.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a commodity price management device having a commodity price file for storing prices of commodities and a method of changing the commodity price of the commodity price file.

[0002]

2. Description of the Related Art For example, in a mass retailer such as a supermarket, a store computer having a product master file storing product information including a price of the product corresponding to a product code specifying each product via a communication line. Point-of-sale information management system so-called P which connects a plurality of cash registers for registering sales data of each product
We are building an OS system. By using this POS system, when a customer purchase product is registered in each cash register, the sales data of the product is calculated based on the price of the product in the product master file and sales registration processing is performed. There is an advantage that even if a customer purchase product is registered with a cash register, sales data of the product can be registered for sales at the same price.

[0003] In a large-scale supermarket that handles a variety of products such as food, clothing, and daily necessities,
If you need to change the price of a product due to special sale,
A salesperson in each department, such as a foodstuff department, a clothing department, and a daily necessities department, actually goes around the sales floor to select a product to be price-changed, and the product name, product code, and changed price of the product. Create a price change list with the information and give it to the store computer operator. When the operator receives the price change list from the sales person in charge of each section, the operator selects a price change operation using the store computer, and inputs the product code entered in the price change list and the changed price from a keyboard or the like. By doing so, the price of each commodity for price change in the commodity master file is updated to the price after the change, and thereafter, the commodity sales data of the commodity for price change is calculated at the changed price.

[0004]

As described above, in the conventional store computer having the product master file, the product code of the product whose price is to be changed and the price after the change are actually input from an input device such as a keyboard. Since the price of the target product for price change in the product master file was changed by this, for example, in a large-scale supermarket, each sales floor clerk creates a list of target products for price change, and the operator of the store computer It was necessary to enter the product code of the price-change target product and the price after the change while looking at the list.

For this reason, the price is not correctly changed by not only a mistake in filling in the list by the salesperson but also a mistake in input by the store computer operator.
Human error was easy to occur.

Accordingly, the present invention provides a product which can change the price of a corresponding product in a product price file by using the product code of the product whose price is to be changed and the changed price entered by the sales floor clerk in the data input device at the sales floor. It is intended to provide a price management device. Another object of the present invention is to provide a method of changing the price of a product, which can reduce the work load required for the price change operation of the price change target product in the product price file of the product price management device and reduce human error.

[0007]

According to a first aspect of the present invention, there is provided a merchandise price management apparatus having a merchandise price file storing a price of each merchandise, wherein a merchandise code for specifying the merchandise and a changed price of the merchandise are provided. Data reading means for reading input data from a portable data input device provided with means for inputting a product code and a price data after a change from the data input device by the data reading device. Price changing means for changing the price of the product specified by the product code to the post-change price.

[0008] The invention described in claim 2 of the present application is the above-described claim 1.
When the data reading means of the invention described above reads data of the commodity code and the changed price from the data input device by the data reading means, it searches the commodity price file and finds the price of the commodity specified by the commodity code and the changed price. Change determining means for determining the validity of the price change from the price change means for determining the validity of the price change from the price change means for changing the price of the corresponding product in the product price file to the changed price when the change determination means determines that the price change is valid; Error output means for outputting an error when the means determines that the price change is invalid.

According to the third aspect of the present invention, there is provided a data reading apparatus for reading input data from a portable data input device having means for inputting a product code for specifying a product, a changed price of the product and a price change date. Means for checking a commodity code, a changed price and a price change date from a data input device by the data reading means, and checking whether or not the price change date is today; and changing the price by the date check means. First price change means for searching the product price file when the date is confirmed to be today and changing the price of the product specified by the product code to the changed price;
When the date change means confirms that the price change date is the next day or later, the price change data storage means for storing the product code, the changed price and the data of the price change date, and the data stored in the price change data storage means. And a second price change means for selecting data of a price change date from today, searching a product price file, and changing the price of the product specified by the product code of the data to the changed price of the data. Things.

[0010] The invention according to claim 4 of the present application is a method for changing a product price of a product price file in which a price of each product possessed by the product price management device is stored. Data reading means for reading input data from a portable data input device having means for inputting the changed price of the product is provided, and the product code of the product whose price is to be changed and the changed price are input by the data input device. Then, by reading the data input to the data input device by the data reading means, the price of the price-change target product in the product price file is changed to the changed price. The invention according to claim 5 of the present application is the invention according to claim 4, wherein a plurality of data input devices are provided.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below with reference to the drawings. In this embodiment, a case where the commodity price management device of the present invention is applied to the store computer 1 of the POS system shown in FIG. 1 will be described. In FIG. 1, reference numeral 1 denotes a store computer that manages data necessary for store operation such as sales, inventory, and ordering of goods, and a plurality of moneys for registering sales data of each product in the store computer 1. A registration machine, a so-called POS terminal 2, is connected by a communication line 3, respectively.
We are building a POS system.

As shown in FIG. 2, the store computer 1 stores, as a commodity price file for storing the price of each commodity, a classification code, a commodity name, and a price of the commodity corresponding to the commodity code for specifying each commodity. And a product master file 4 in which product information such as tax type status is set and stored. In addition, the store computer 1 is provided with a plurality of portable data input devices provided with means for inputting data such as a product code of a price-change target product, a price after the change, and a date of the price change, that is, data for reading input data from a so-called handy terminal 5. As a reading means, a handy terminal reader 6 for exchanging data with the handy terminal 5 by optical communication is connected directly or via a personal computer or the like.

FIG. 3 is a block diagram showing a control circuit configuration of the store computer 1, in which a CPU 11 serves as a main control unit.
It has. A ROM 13 and a RAM 14 forming a main storage unit and a floppy disk drive FDD for accessing a floppy disk and a hard disk forming an auxiliary storage unit are provided to the CPU 11 via bus lines 12 such as an address bus and a data bus.
And each PO connected to each controller 16 and 17 of the hard disk drive HDD by the communication line 3.
Communication controller 18 for controlling data communication with S terminal
An interface 19A for connecting various input / output devices such as a keyboard, a mouse and other input devices 7, a printer 8 and a display device 9 in addition to the handy terminal 6;
19B, 19C and 19D are connected to form a control circuit. The product master file 4 is stored in, for example, a hard disk, developed on the RAM 14, and read and written.

FIG. 4 is a block diagram showing the configuration of the main part of the handy terminal 5, which has a CPU 51 as a main control unit. The CPU 51 is provided with a ROM 53 and a RAM 54 via a bus line 52 such as an address bus and a data bus, a transmission / reception circuit 55C for operating an optical communication unit 55, a scanner 56, a keyboard 57 and a display 5
Controllers 56C, 57C, 5 for controlling
8C.

The scanner 56 optically reads a bar code. Each product is provided with a bar code of the product code. As shown in FIG. 5, the keyboard 57 includes a numeric keypad K1 for entering numerical data,
Various keys are provided for inputting data relating to a price change target product such as a clear key K2, an amount key K3, a date key K4, a registration key K5, and a transmission key K6. The display 58 displays input data from the scanner 56 and the keyboard 57, operation guidance, and the like.

The CPU 5 of each handy terminal 5
1 executes the process shown in the flowchart of FIG.
The program in M53 is constituted. That is, when the power is turned on, first, as ST (step) 1, the input of the classification code to which the price-change target product belongs, the registration date, and the person in charge code is accepted. Then, data of the number of digits corresponding to the classification code is set by the ten key K1, and the registration key K
If 5 is pressed, the numerical data is set to R as the classification code.
The data is stored in the AM 54, and then the data of the number of digits corresponding to the registration date (year, month, day) is entered by the numeric keypad K1, and if the registration key K5 is pressed, the entry data is set to R as the registration date.
The data is stored in the AM 54, and then the data of the number of digits corresponding to the person in charge code is entered by the numeric keypad K1.
Store it in M54.

Next, at step ST2, a guidance requesting the input of the product code of the product whose price is to be changed is displayed on the display device 58. Here, when the barcode indicating the product code is scanned by the scanner 56 in ST3, the barcode is analyzed to obtain the product code, and the RA is read.
Store it in M54. Next, at step ST4, the display 58 displays guidance for requesting input of the changed price of the price-change target product. Here, the numeric key K1 is set as ST5.
When the data is entered and the amount key K3 is pressed, the entered data is stored in the RAM 54 as the changed price.

If the changed price has been entered in ST5, then the display 58 displays ST3 and ST5 as ST6.
To display the entered product code and changed price. Here, as ST7, a numeral of the number of digits corresponding to the date (year, month, day) is performed by the numeral key K1, followed by the date key K.
If 4 is pressed, the numerical data is stored in the RAM 54 as the price change date.

Regardless of whether or not the price change date has been input in ST7, if the input of the registration key K6 is detected in ST9, it is determined in ST7 whether or not the price change date has been input in ST7. . If not entered, the registration date entered in ST1 is stored in the RAM 54 as the price change date in ST11.

Thereafter, if the price change data table M1 shown in FIG. 7 is created on the RAM 54 based on the commodity code, the changed price and the price change date stored in the RAM 54 in ST12, the process returns to ST2 and the display 58 Displays a guidance requesting entry of the product code of the next price change target product. Note that the registration key K5 in ST9
Before detecting the input of the clear key K2 as ST13.
Is detected, the merchandise code, the changed price and the data of the price change date stored in the RAM 54 are cleared, and the process returns to ST2.

If the input of the transmission key K6 is detected in ST14 before the commodity code is scanned in ST3, it is determined whether or not the price change data table M1 has been created in the RAM 54 in ST15. I do. If not created, the process ends.

On the other hand, if the price change data table M1 is created in ST15, price change data including the product code of the product to be changed, the changed price, and the price change date is registered. Therefore, as ST16, the data of the price change data table M1 is transmitted by optical communication via the optical communication unit 55. And after transmission,
This processing ends.

FIG. 8 is a format showing transmission data of the price change data table M1, and this transmission data is composed of a body part BD composed of the data of the price change data table M1 and a header part HD. Header part HD
Is a data section for specifying the transmission data of the price change data table M1, a store code preset in the ROM 53 and the ID number of the handy terminal 5, a classification code input in ST2, a registration date, and a charge And the number of data in the price change data table M1.

The price change data table M
The CPU 11 of the store computer 1 that has received the transmission data 1 via the handy terminal reader 6 acquires the price change data table M1 from the data. Then, for each price change data (product code, price after change, price change date) in the price change data table M1, price change reception processing shown in the flowchart of FIG. 9 is executed. That is, it is determined whether or not the price change date of the price change data coincides with today's date measured by the clock unit 15 (ST1). If the price change date does not match today's date, S
As T2, it is determined whether the price change date is after the next day or before the previous day. Then, if it is after the next day, the price change data is stored and held in the RAM 14 as ST3 (price change data storage means).

If the price change date coincides with today's date in ST1, the product master file 4 is searched with the product code of the price change data in ST4. Then, if it is confirmed in ST5 that the product code is set in the product master file 4, the price data corresponding to the product code is read from the product master file 4 as the pre-change price in ST6. And ST7
By calculating the price change rate x (%) by dividing the price after the change of the price change data by the price before the change,
In step ST8, it is determined whether or not the price change rate x is within a preset price change allowable range (for example, 50% to 200%) (change determination unit).

As a result, when it is confirmed that the price is within the allowable range, the price change is valid, so that the price data corresponding to the corresponding product code in the product master file 4 is rewritten to the changed price in ST9 (first price change). means). Thereafter, in ST10, the name of the price-changed product, the price before change, and the price after change are printed on recording paper by the printer 8, respectively.

When it is confirmed in ST2 that the price change date is before the previous day, the price change data is printed on recording paper by the printer 8 as error data of the price change date error. If the product code of the price change data is not set in the product master file 4 in ST5, the printer 8 prints the price change data as error data of the product code error on the recording paper.
Further, if the price change rate x deviates from the allowable range in ST8, the price change data is printed on the recording paper by the printer 8 as error data of the post-change price error.

The CPU 11 of the store computer 1
Executes the price change search process shown in FIG. 10 as one of the pre-opening operations performed before the opening of the day, for example. First, it is determined whether or not price change data is stored in the RAM 14 in ST21. If it is stored, the processing after ST22 is sequentially performed on the price change data.

That is, as ST22, price change data whose price change date matches today's date measured by the clock unit 15 is selected. Then, for the selected price change data, the same process of ST23 to ST30 as the process of ST4 to ST11 of the price change reception process shown in FIG. 9 is executed.

That is, in step ST23, the commodity master file 4 is searched for the commodity code of the price change data,
If it is confirmed at T24 that the product code is set in the product master file 4, the price data corresponding to the product code is read from the product master file 4 as the pre-change price at ST25. And ST26
Then, the price change rate x (%) is calculated, and it is determined whether or not the price change rate x is within an allowable range as ST27. As a result, if it is within the allowable range, the price data corresponding to the corresponding product code in the product master file 4 is rewritten to the changed price in ST28 (second price changing means). Thereafter, in ST29, the name of the price-changed product, the price before the change, and the price after the change are printed on the recording paper by the printer 8 respectively. If the product code of the price change data is not set in the product master file 4 in ST24, the printer 8 prints the price change data on the recording paper as error data of the product code error. If the price change rate x deviates from the allowable range in ST27, the printer 8 prints the price change data as error data of the post-change price error on recording paper.

In the present embodiment configured as above, the scanner 56 and the keyboard 57 of the handy terminal 5 are operated to input the commodity code of the commodity whose price is to be changed, the price after the change and the date of the price change. Then, the RAM 54 of the handy terminal 5 is used according to the input data.
, A price change data table M1 is created.

Next, the handy terminal 5 is set on the handy terminal reader 6 of the store computer 1, and the transmission key K6 of the handy terminal 5 is pressed. Then, the price change data table M1 is read into the store computer 1. As a result, for the price change target product of the price change data whose price change date is today, the price of the corresponding product in the product master file 4 is automatically changed to the changed price. In addition, for a product whose price is to be changed in the price change data whose price change date is the next day or later, the price of the corresponding product in the product master file 4 is automatically changed to the changed price when the price change date is reached. .

For example, when the POS system according to the present embodiment is applied to a large-scale supermarket handling various kinds of commodities such as food, clothing, daily necessities, etc., dedicated handy terminals 5 are prepared for each sales floor. Keep it. Then, when it becomes necessary to change the price of the product due to a bargain sale or the like, the person in charge of price change at each store goes around the store with the handy terminal 5 and selects the product for which the price is to be changed. Scan the product code and key in the changed price and the date of price change. If the price change date is today, the input of the price change date can be omitted.

In this way, when the person in charge of changing the price at each sales floor has finished inputting the price change data of the price-changed product at his / her sales floor into the handy terminal 5, he or she hands the handy terminal 5 to the operator of the store computer 1. The operator causes the handy terminal reader 6 to sequentially read the price change data of the price change target product input to the handy terminal 5 of each sales floor, thereby changing the price of the price change target product in the product master file 4. Change to price.

As described above, according to the present embodiment, the sales person in charge in the product master file 4 uses the product code of the product whose price is to be changed and the price after the change input to the handy terminal 5 at the sales floor. You can change the price of the product. Therefore, it is not necessary for the sales floor manager to create the list of the price-change target products, and it is not necessary for the operator of the store computer 1 to input the product code of the price-change target product or the changed price while viewing the list. Can be. As a result, the business efficiency required for the price change is greatly improved, and the inconvenience of the price not being correctly changed due to human error can be prevented as much as possible.

In the above-described embodiment, the optical communication is used as means for reading the data of the handy terminal 5 by the handy terminal reading device 6. By using the device 6 as a wireless device and installing an antenna of this wireless device in the sales floor, the salesperson can transmit the price change data input to the handy terminal 5 to the store computer 1 by wireless communication while staying in the sales floor. You may.

[0037]

As described above in detail, according to the commodity price management apparatus of the present invention, the commodity code of the commodity whose price is to be changed and the changed price inputted by the salesperson in the data input device at the sales floor are determined. The effect that the price of the corresponding product in the product price file can be changed by using the product as it is. Further, according to the product price changing method of the present invention, it is possible to reduce the work load required for the price changing operation of the product whose price is to be changed in the product price file of the product price management device and to reduce human error.

[Brief description of the drawings]

FIG. 1 is an overall view of a POS system according to an embodiment of the present invention.

FIG. 2 is a configuration diagram of a product master file shown in FIG. 1;

FIG. 3 is a block diagram of the store computer shown in FIG. 1;

FIG. 4 is a block diagram of the handy terminal shown in FIG. 1;

FIG. 5 is an exemplary view showing a keyboard of the handy terminal.

FIG. 6 is a flowchart showing processing executed by the CPU of the handy terminal.

FIG. 7 is a view showing a price change data table formed in a RAM of the handy terminal.

FIG. 8 is a view showing a format of price change data transmitted from the handy terminal to the store computer.

FIG. 9 is a flowchart showing a price change receiving process executed by the CPU of the store computer.

FIG. 10 is a flowchart showing a price change search process executed by the CPU of the store computer.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Store computer (commodity price management device) 2 ... POS terminal 4 ... Commodity master file (commodity price file) 5 ... Handy terminal (portable data input device) 6 ... Handy terminal reader M1 ... Price change data table

Claims (5)

[Claims] 1. A portable data input device having means for inputting a product code specifying a product and a post-change price of the product in a product price management device having a product price file for storing a price of each product. Data reading means for reading input data from the device; and when the data reading means reads the product code and the changed price data from the data input device, the product price file is searched for the product specified by the product code. A price changing means for changing the price to the changed price; 2. A portable data input device having means for inputting a product code specifying a product and a changed price of the product in a product price management device having a product price file for storing a price of each product. Data reading means for reading input data from the device; and when the data reading means reads the product code and the changed price data from the data input device, the product price file is searched for the product specified by the product code. Change determination means for determining the validity of the price change from the price and the price after the change, and when the change determination means determines that the price change is valid, the price of the product in the product price file is changed to the price after the change. A price change unit to be changed; and an error output unit that outputs an error when the change determination unit determines that the price change is invalid. Commodity price management device which is characterized in that Bei was. 3. A product price management device having a product price file storing the price of each product, comprising: a mobile phone provided with a means for inputting a product code specifying a product, a post-change price of the product and a price change date. Data reading means for reading input data from a data input device of a type; and reading the data of the commodity code, the changed price, and the date of the price change from the data input device by the data reading means to determine whether the price change date is today. Date checking means for checking; and confirming that the date of the price change is today by the date checking means. Searching the product price file and changing the price of the product specified by the product code to the post-change price. (1) the price change means and the date check means confirm that the price change date is the next day or later; A price change data storage means for storing data on the price change date; and data from the data stored by the price change data storage means that today selects the data on the price change date, searches the product price file and searches for the product of the data. A second price changing means for changing the price of the product specified by the code to the changed price of the data; 4. A method for changing a product price of a product price file in which a price of each product stored in a product price management device is stored, wherein a product code specifying a product and a changed price of the product are stored in the product price management device. Data reading means for reading input data from a portable data input device having means for inputting the data, and inputting a product code of a price change target product and a changed price by the data input device; A method of changing the price of the commodity for which the price is to be changed in the commodity price file to the changed price by causing the data inputted by the apparatus to be read by the data reading means. . 5. The method according to claim 4, wherein a plurality of portable data input devices are provided.