JPH10228510A - Merchandise information confirmation system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the working capacity of merchandise information confirmation function. SOLUTION: This system has a merchandise registration supporting device 1 which is provided with various data files about merchandise information and a portable terminal 6 that is provided with an outputting part which confirms merchandise information. Here, the device 1 extracts merchandise information that needs confirmation by the terminal 6 among various data files, creates a merchandise information confirming file 5 and sends it to the terminal 6. The terminal 6 reads information about a merchandise from the file 5 and outputs it when the code of the merchandise is inputted.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a merchandise information confirmation system used by a store clerk to confirm information on commodities displayed on a sales floor.

[0002]

[Prior Art] At mass retailers such as supermarkets,
One of the sales clerk's duties is to check the information on displayed products. This task is to check whether each product is displayed at the correct place, whether the price and name of the shelf label are displayed, and the like. For example, in the case of fresh food, the price may be reduced when the store is about to close to prevent unsell. Further, a time service for lowering the price of a specific product for a certain period of time in order to enhance the sales promotion effect may be provided. In such a case, it is necessary for a salesperson in charge of the sales floor to perform a product information confirmation operation in a timely manner to check whether the price of the shelf label matches the actual price.

Conventionally, therefore, a product registration support device, which is provided with various data files relating to product information and supports product sales data registration work at each point-of-sale (POS) terminal, a so-called store computer, stores products in each data file. A form in which the information is recorded is printed out, and the information of the form is checked at the counter by comparing the contents of the form with the state of the product display shelf.

[0004]

However, the conventional product information confirmation business searches for information on a product that needs to be confirmed from information on many products recorded in a form,
Further, a very complicated and time-consuming operation of finding and collating information on items necessary for confirmation from among various items related to the product has been required. SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to provide a product information confirmation system capable of improving the work efficiency of a product information confirmation business.

[0005]

SUMMARY OF THE INVENTION The present invention relates to a merchandise information confirmation system comprising a merchandise registration support device provided with various data files relating to merchandise information and a portable terminal provided with an output unit for checking the merchandise information. The product registration support device includes a file creation unit that extracts product information of items that need to be confirmed by the mobile terminal from various data files and creates a product information confirmation file, and a product information confirmation file. And a file transmission unit for transmitting to the mobile terminal. The portable terminal has a file storage unit for storing a product information confirmation file received from the product registration support device, a code input unit for inputting a product code for checking product information, and a product code input by the code input unit. Then, a confirmation control means for reading out information on the commodity from the commodity information confirmation file and outputting it from the output section is provided.

[0006]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below with reference to the drawings. In FIG. 1, reference numeral 1 denotes a store computer on which a database 2 for storing various data files relating to product information is mounted. The store computer 1 has a LAN (local area
The POS terminal 4 supports a sales data registration operation for each product performed by a plurality of POS terminals 4 connected via a communication line 3 such as a network, and functions as a product registration support device.

By the way, as shown in FIG. 2, the database 2 stores information on commodity prices such as a base selling price, a current selling price, a selling price, a closing selling price, and a cost for each product code for specifying each product. Product price master file 2A, a product name master file 2B storing information on product names such as a product unique name, a receipt / journal printing name, a POS terminal display name for each product code, and a product of each product. A merchandise shelf master file 2C that stores information on merchandise display shelves, such as a sales floor number of a sales floor where the merchandise is displayed by code, a shelf number of a display shelf, and a label name of a shelf label, and a merchandise code of each merchandise. JAN code equivalent to bar code, department code indicating classification, class code, etc. And stores such memorized code conversion master file 2D and the information.

The store computer 1 also stores various data files 2A, 2B,
File creation means for extracting the product information of items necessary for the product information confirmation work from 2C, 2D, etc. and creating a text file 5 for product information confirmation, and carrying the text file 5 for product information confirmation File transmitting means for transmitting to the terminal 6.

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. The CPU 11 is provided with a ROM 13 and a RAM 14 forming a main storage unit, a clock unit 15 for measuring the current date and time, and a floppy disk forming an auxiliary storage unit via bus lines 12 such as an address bus and a data bus. FDD (floppy disk drive) 16 for accessing disk and hard disk respectively
And a controller 18 and 19 of a hard disk drive (HDD) 17, a communication controller 20 for controlling data communication with each POS terminal 2 connected by the communication line 3, an interface 21 with the portable terminal 6, A control circuit is formed by connecting I / O ports 25, 26 and 27 for connecting various input / output devices such as an input device 22 such as a keyboard and a mouse, a printer 23 and a display device 24, respectively. The various data files 2A, 2B, 2C, 2D of the database 2 are formed, for example, on a hard disk.

The portable terminal 6 is used by a store clerk in charge of a store to carry the product and check the necessary information on the displayed product by entering the code of the displayed product. File storage means for storing the received text file 5 for checking product information, code input means for inputting a code of the product for which the product information is to be checked, A confirmation control means for reading information from the text file 5 and outputting the information from the output unit.

FIG. 4 is a block diagram showing the configuration of the main part of the portable terminal 6. A CPU 61 as a main control unit, a ROM 62 storing programs and the like, a RAM 63 as the file storage means, and an interface 64 with the store computer 1. , A controller 65C for the scanner 65 for reading bar codes, a keyboard controller 66C for controlling the keyboard 66, a display controller 67C for controlling the display 67, and the like.

The CPU 61, ROM 62, RAM 6
3, interface 64 and each controller 65C, 6
6C and 67C are connected by a bus line 68. The scanner 65 and the keyboard 66 function as the code input unit, and the display 67 functions as the output unit.

Thus, the store computer 1
As a component of the file creation unit and the file transmission unit, a program is configured so that the CPU 11 executes the processing shown in the flowchart of FIG. This program is started when a command to start a product information confirmation operation is input from the input device 22.

That is, when starting this process, the CPU 11 resets the built-in counter n to [0] as ST (step) 1. Next, after counting up the counter n by +1 in ST2, it is determined in ST3 whether the count value has exceeded the total number of product records in the product price master file 2A. If not, the commodity price master file 2A is set as ST4.
The nth product record is read from. In step ST5, the other master files 2B, 2C, and 2D are searched using the product code of the n-th product record as a search key, and the records of the same product code are read. Thereafter, as ST6, each master file 2A, 2B, 2
From the records read from C and 2D, the portable terminal 6 extracts merchandise information of items that need to be confirmed, creates merchandise information text, and stores it in the RAM 63.

Thereafter, returning to ST2, the counter n is incremented by +1.
Just count up. In this way, the processes in ST4 to ST6 are sequentially repeated until the counter n exceeds the total number of product records in the product price master file 2A, and the product information text of each product is created and stored in the RAM 63. Then, if it is confirmed in ST3 that the counter n has exceeded the total number of product records, the product information text of each product stored in the RAM 63 is filed in ST7, and the text file 5 for product information confirmation is edited. When the text file 5 is transmitted to the portable terminal 6 connected via the interface 21 and loaded into the RAM 63, the process ends.

On the other hand, the portable terminal 6 constitutes a program for constituting the confirmation control means so that the CPU 61 executes the processing shown in the flowchart of FIG.
That is, the scanner 65 and the keyboard 6 are set as ST1.
When a product code or a JAN code of one product is input by 6, the text file 5 for checking product information stored in the RAM 63 is searched as ST 2. And
If the product information text including the input product code or the JAN code is detected in ST3, the content of the product information text is displayed on the display 67. On the other hand, if the corresponding product information text cannot be detected from the text file 5, an error message is displayed on the display device 57.

In this embodiment configured as described above, when the salesperson in charge of the sales floor performs the information confirmation operation of the displayed product, first, the interface 64 of the portable terminal 6 and the interface 21 of the store controller 1 are connected by a signal cable. Connecting. Next, the input device 2 of the store controller 1
2 is operated to input a command to start a product information confirmation operation.

Then, from among the various data files 2A, 2B, 2C, 2D... On the database 2, the product information of the items necessary for the product information confirmation work is extracted, and the text file 5 for the product information confirmation is obtained. Created. For example, as shown in FIG. 7, a product code, a current price, a selling price, and a closing price are extracted from one record 2Ar of the product price master file 2A. Also, one record 2 of the same product code in the product name master file 2B
The product name is extracted from Br, and the product shelf master file 2
A sales floor number and a shelf number are extracted from one record 2Cr of the same product code of C, and a JAN code is extracted from one record 2Dr of the same product code in the code conversion master file 2D. Then, the product information of each item is combined to create the product information text 5r of one product.

When the text file 5 is created by filing each product information text 5r, the text file 5 is transmitted to the portable terminal 6 connected to the interface, and is loaded into the RAM 63 of the portable terminal 6. The clerk goes to the sales floor with the portable terminal 6 loaded with the text file 5. Then, the user inputs the product code or the JAN code of the product requiring information confirmation from the scanner 65 or the keyboard 66. Then, the display 67 displays information on the product such as a product name, a sales floor number, a shelf number, a current selling price, a selling price, and a closing selling price. Thus, the clerk illuminates the display contents of the display 67 with, for example, whether or not the place where the product is displayed (sales floor, shelf) is correct, or whether or not the name of the shelf label or the current price is correct. It can be easily confirmed by matching.

As described above, according to the present embodiment, the portable terminal 6 loaded with the text file 5 for confirming the product information
By simply entering the code of the product for which information confirmation is required, the information required for the product information confirmation work of the product is displayed and output on the display device 57, and can be compared with the actual product state. The work efficiency of the product information confirmation work can be greatly improved as compared with the related art using the information.

The present invention is not limited to the above embodiment. For example, in the above-described embodiment, the commodity price master file 2A, the commodity name master file 2B, the commodity shelf master file 2C, and the code conversion master file 2D are used as various data files relating to the commodity information.
The necessary items are extracted from each of the two files to create the product information text file 5, but the data of the product information text file 5 is created using the data of the other data files.
May be created.

Further, in the above embodiment, the display is shown as the output means of the product information text, but the content of the product information text may be output by printing or voice output. In addition, it goes without saying that various modifications can be made without departing from the spirit of the present invention.

[0023]

As described in detail above, according to the present invention,
A product information confirmation system that can improve the work efficiency of the product information confirmation operation can be provided.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram according to an embodiment of the present invention.

FIG. 2 is an exemplary view showing a data file provided in the database according to the embodiment;

FIG. 3 is an exemplary block diagram showing a configuration of a main part of the store computer according to the embodiment;

FIG. 4 is an exemplary block diagram showing a main part configuration of the mobile terminal according to the embodiment;

FIG. 5 is a flowchart of main processing executed by the CPU of the store computer in the embodiment.

FIG. 6 is a flowchart of main processing executed by the CPU of the mobile terminal according to the embodiment;

FIG. 7 is a diagram showing a data flow of creating a product information confirmation file in the embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Store computer 2 ... Database 5 ... Text file for product information confirmation 6 ... Mobile terminal 2A ... Product price master file 2B ... Product name master file 2C ... Product shelf master file 2D ... Code conversion master file

Claims (1)

[Claims] 1. A product registration support device including various data files related to product information, and a portable terminal including an output unit for checking product information, wherein the product registration support device includes A file creation unit that extracts a product information of an item that needs to be confirmed by the mobile terminal and creates a product information confirmation file, and a file transmission unit that transmits the product information confirmation file to the mobile terminal. File storage means for storing a product information confirmation file received from the product registration support device,
Code input means for inputting a product code for checking product information, and confirmation control for reading information about the product from the product information confirmation file and outputting from the output unit when the code of the product is input by the code input means. Means for confirming product information, comprising: