JP2001126142A - Device for managing merchandise file - Google Patents

Abstract

PROBLEM TO BE SOLVED: To additionally register the merchandise information on new merchandise in a merchandise file by using the merchandise information on existing merchandise registered in the merchandise file even though the existing merchandise that is similar to the new merchandise does not exist at hand. SOLUTION: When input devices 51 and 52 selectively input the information on a retrieval condition item among merchandise information items, a file retrieving part 56 retrieves the merchandise file 4, extracts the merchandise information satisfying the conditions and outputs a list to a display device 53. When the devices 51 and 52 select any piece of information among the merchandise information outputted as the list, a main controlling part 58 stores the merchandise information in a merchandise record memory 59. When the devices 51 and 52 selectively correct the information stored in the memory 59 in each item, a file reading/writing processing part 57 performs additional registration in the file 4.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a merchandise file management apparatus for efficiently managing a merchandise file for setting and storing information of each merchandise necessary for order management and sales management of merchandise.

[0002]

2. Description of the Related Art For example, in a mass retailer such as a supermarket, a POS (Point Of Sales: Point of Sale) system is constructed in each store, and a computer system mainly comprising a host computer is established in a headquarters which supervises each store. Build an ISDN (Integrated)
Services Digital Network: A network is formed by connecting via a comprehensive service digital network. The computer system at the headquarters is required for order management and sales management of the product code, class code, original unit price, unit price, manufacturer name, product name, standard name, supplier code, etc. for each product handled at each store. By providing a product master file in which information of various items is set and stored, orders from each store, sales of each store, and the like can be centrally managed by the headquarters.

[0003] In a mass merchandising store in which this kind of distribution information system is constructed, every time a product newly handled in the store, a so-called new product, is generated, information on various items necessary for order management and sales management of the merchandise is collected. It was necessary to additionally register in the product master file. In this case, the product code is unique information that differs for each product, but the other items often coincide with similar products.

[0004] Therefore, as a conventional function of adding information of a new product to the product master file due to the occurrence of a new product, the product information of the existing product is specified by specifying the existing product similar to the new product. There was a copy function that once copied as product information, and then corrected only the information of the items that did not match, and then additionally registered in the product master file. By utilizing this copy function, the input of information on the matching items can be omitted, so that the information addition of a new product can be processed without burden.

[0005]

However, in general, the product code is a string of tens of digits and more than tens of thousands of products are handled at mass merchandisers. However, it is impossible to remember the product code of an existing product. Furthermore, many products have their product code printed along with the barcode,
If you look at it, you can recognize it and you don't have to remember it. Nevertheless, the conventional copy function had to specify and input the product code of an existing product similar to a new product, so it was difficult to input the product code if the existing product was not at hand. . For this reason, the copy function can be used in stores that sell existing products, but cannot be used in headquarters where existing products are not at hand.

The present invention has been made in view of such circumstances, and an object of the present invention is to provide a product information of an existing product registered in a product file even if an existing product similar to a new product is not at hand. It is an object of the present invention to provide a product file management device capable of additionally registering product information of a new product in a product file by using a product.

[0007]

The invention described in claim 1 of the present application is necessary for order management, sales management, etc. of a product name, a manufacturer name, a supplier name, etc., corresponding to a product code assigned to each product. In a product file management device configured to store and store product information of various types of items, a product information storage unit that stores information for each type of product information, and information stored in the product information storage unit for each item. Information correction means for selectively correcting the information stored in the product information storage unit, and a product information adding means for additionally registering the information stored in the product information storage in the product file, and an item serving as a search condition of the product file from various items constituting the product information Search condition input means for selectively inputting the information of the search condition, and a file for searching the product file with the information of the search condition items input by the search condition input means and extracting the product information satisfying the condition. File search means, a search list output means for outputting a list of product information extracted from the product file by the file search means, and one of the product information output from the search list output means. The apparatus includes a search information selection unit and a product information copy unit that stores the product information selected by the search information selection unit in a product information storage unit. According to the first aspect of the present invention, when the product information of the new product is additionally registered in the product file, first, the search condition input means recognizes the new product from various items constituting the product information. Selectively input information on items to be obtained that are suitable for the search condition. Then, the product file is searched by the information of the search condition item input by the search condition input means, the product information of the existing product satisfying the condition is extracted, and a list of the product information extracted from the product file is output. Is done. Therefore, any one information is selected from the product information of the existing products output in the list by the search information selecting means. Then, since the selected product information is stored in the product information storage unit, the product information of the existing product stored in the product information storage unit is
Only items that do not match the new product are selectively modified for each item. By doing so, the product information of the new product can be efficiently registered additionally in the product file using the product information of the existing product.

[0008] The invention described in claim 2 of the present application is the above-described claim 1.
In the invention described above, the product information copying means is means for storing information of various items other than the product code in the product information selected by the search information selecting means in the product information storage unit. By taking such measures,
When any one of the product information of the existing products displayed in the list by the search information selection means is selected, information of various items other than the product code in the selected product information is stored in the product information storage unit. You. Therefore, with respect to the product information of the existing product stored in the product information storage unit, only the items that do not match the new product are selectively corrected for each item. In this case, the product code is unique for each product, and must always be modified when using the product information of an existing product. Can be entered as it is, and there is no correction mistake.

[0009]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below with reference to the drawings. In this embodiment, the present invention is applied to a merchandise master file management device provided in a headquarters system of a distribution information system for a mass retailer.

FIG. 1 is an overall view of a distribution information system according to the present embodiment. The distribution information system is constructed at a head office computer system 1 mainly composed of a host computer and the like, and at each store. PO
The S system 2 is connected to a communication network 3 such as ISDN. And headquarters computer system 1
A product master file 4 to be managed by the present invention;
A product master management unit 5 functioning as a product file management device is mounted.

The merchandise master file 4 stores information on various items necessary for order management and sales management of each merchandise handled at each store in merchandise units. As shown in FIG. Code, class code, department code, tax classification, original unit price, sales unit price, manufacturer code, manufacturer name (kana), manufacturer name (kanji), product name (kana),
Various item information such as product name (kanji), standard name (kana), standard name (kanji), supplier code, supplier name, number of pieces, number of cases, number of flights, and handling period are stored as one record. ing.

FIG. 3 is a block diagram functionally showing the structure of the product master management unit 5.
Has a keyboard 51 and a mouse 52 as input devices. Further, a display device 53 such as a CRT display (Cathode Ray Tube) is provided as an output device. Further, an input processing unit 54 for processing input information from the keyboard 51 and the mouse 52, a display control unit 55 for controlling display of data on the display device 53, and a file search unit for searching data in the product master file 4. 56, the product master file 4
A file writing / reading processing unit 57 for writing data on a record basis and reading data from the product master file 4 on a record basis. These are provided with a CPU (Central Processing Unit) and a ROM (Read).
The function as the product master management unit 5 is realized by controlling the main control unit 58 mainly using Only Memory), RAM (Random Access Memory) and the like.

The memory (RAM) of the main control unit 58 has a product record memory 59 as an area for storing information per product (called a product record) stored in the product master file 4 for each item. Is formed. Here, the product record memory 59 constitutes a product information storage unit.

When the main control unit 58 of the product master management unit 5 is instructed to execute the product master file management operation by inputting from the keyboard 51 or the mouse 52, the process shown in the flowchart of FIG. 4 is started. It is something to do.

That is, the main control unit 58 first clears the area for each item of the product record memory 59 as ST (step) 1. Next, input of a product code is received as ST2. Then, when a product code is input by a key operation of the keyboard 51, the input product code is stored in the product code area of the product record memory 59 as ST4.

Next, in step ST4, the file search unit 56 is operated using the input product code as a search key to check whether or not the input product code is registered in the product master file 4. As a result, when the input product code is registered in the product master file 4, the process shifts to a process in a correction mode for correcting the item information of the product record in which the product code is set.

On the other hand, if the input product code is a new code not registered in the product master file 4,
Since this is a new mode in which a product record of a new product is additionally registered in the product master file, a new input screen 6 as shown in FIG. The new input screen 6 forms an input area for each of various items constituting a product record, and also includes a confirm button 61, a stop button 62, a previous copy button 63, and a search copy button 64. The input product code as a new code is displayed in the area.

In this state, the main control unit 58 inputs product information other than the product code,
Alternatively, it waits until the search copy button 64 is turned on. Then, at ST6, when an input area other than the product code is selected by the mouse 52 and product information is input to the input area by the keyboard 51, ST1 is performed.
Proceeding to No. 4, the input product information is stored in the corresponding item area of the product record memory 59. At this time, if another product information has been written in the area, it is overwritten.

On the other hand, if the previous copy button 63 is turned on by the mouse 52 in ST7,
At T9, it is determined whether or not there is a product record that was additionally registered immediately before in the product master file 4. Only when there is a product record that has been additionally registered immediately before,
At T10, the file write / read processing unit 57 is operated to read the immediately preceding registration record from the product master file 4 and copy (copy) information of various items other than the product code to the product record memory 59. ST11
The product information (information other than the input product code and the product code of the product record registered immediately before) stored for each item on the product record memory 59 is displayed in the corresponding item input area of the new input screen 6. Thereafter, in ST13, similarly to ST6, an input area other than the product code is selected, and when the product information is input in the input area, the process proceeds to ST14, and the input product information is stored in the product record memory 5 (ST13).
9 is overwritten and stored in the corresponding item area.

On the other hand, when the search copy button 64 is turned on by the mouse 52 in ST8, ST12 is executed.
The search copy process specifically shown in FIG. 5 is executed.
First, in ST21, the screen of the display device 53 is switched from the new input screen 6 to the search input screen 7 as shown in FIG. The search input screen 7 includes three items “product name”, “manufacturer name”, and “standard name” which are search conditions of the product master file 4 among various items constituting the product record.
Areas 71, 72, 73 for inputting information of
A condition area 74 for displaying an input product code and a result area 75 for displaying a list of product records extracted as satisfying the search condition are formed, and a search button 76, a clear button 77, a select button 78, and a cancel button 79 is formed.

In this state, the main control unit 58 determines whether a search condition is input, or clear button 77 or search button 76.
Waits for to be turned on. If one of the search condition areas is selected by the mouse 52 in ST22, and the product information is input to the condition area by the keyboard 51, the input product information is replaced with the search information of the corresponding search condition in ST23. As built-in RAM
It is temporarily stored on the top (search condition input means). After that, it waits until a search condition is input again or the clear button 77 or the search button 76 is turned on.

On the other hand, when the clear button 77 is turned on by the mouse 52 in ST24, the search information temporarily stored in the built-in RAM is cleared. The display of the search condition areas 71, 72, 73 is also cleared. After that, it waits until a search condition is input again or the clear button 77 or the search button 76 is turned on.

On the other hand, when the search button 76 is turned on by the mouse 52 in ST26, it is determined in ST27 whether search information is stored in the built-in RAM. If the search information is stored, the file search unit 56 is operated using the search information as a search key in ST28, and all the product information of the same item as the search information from the product master file 4 includes the search information. Extract the product record of. At this time, if two or more items of information are stored as search conditions, a product record including all the information of the search conditions is extracted (file search means). Then, the product code, manufacturer name, standard name, etc. of the extracted product record are stored in the result area 7.
5 (search list output means).

Thereafter, it waits until the select button 78 or the cancel button 79 is turned on. And S
Any one of the information of the product records listed in the result area 75 by the mouse 52 as T29
Select button 7 after information of one product record is selected
8 is turned on (search information selecting means), S
As T31, the information of various items other than the product code of the selected product record is copied (copied) to the product record memory 59 (search information copying means).

Thereafter, if the screen of the display device 53 is returned to the new input screen 6 in ST32, the process proceeds to ST33.
The product information (information other than the input product code and the product code of the product record selected from the search result) stored for each item on the product record memory 59 is displayed in the corresponding item input area, and the search copy process is terminated. .

If the search information is not stored in the built-in RAM in ST27, or if the cancel button 79 is turned on by a mouse in ST30, the process proceeds to ST32, where the screen of the display device 53 is newly displayed. Return to the input screen 6. Then, the product record memory 59
Product information stored for each item above (input product code only)
Is displayed in the corresponding item input area, the search copy process ends.

When the search copy process is completed, the main control unit 58 proceeds to ST13 in FIG. 4 and waits for input of product information other than the product code. Then, when an input area other than the product code is selected by the mouse 52 and the product information is input to the input area by the keyboard 51, the process proceeds to ST14, and the input product information is overwritten and stored in the corresponding item area of the product record memory 59. (Information correction means).

Thereafter, the process waits until product information other than the product code is input again, or the enter button 61 or the stop button 62 is turned on. When an input area other than the product code is selected by the mouse 52 and product information is input to the input area by the keyboard 51, the input product information is overwritten on the corresponding item area of the product record memory 59 in the same manner as described above. Store.

On the other hand, when the confirm button 61 is turned on by the mouse 52 in ST15, the file write / read control unit 57 is operated to store the product record stored in the product record memory 59 in the product master file. (Product information adding means), and the current process is terminated.

On the other hand, if the cancel button 62 is turned on by the mouse 52 in ST16, the process ends this time without additionally registering a product record in the product record memory 59.

In a mass merchandising store employing the distribution information system of this embodiment configured as described above, the person in charge of managing the product master file at the headquarters installs the headquarters system 1 every time a new product handled at the store occurs. The functioning of the product master management unit 5 is performed. Specifically, first, the keyboard 51 or the mouse 52 is operated to instruct the execution of the product master file management task. Next, the user operates the keyboard 51 to input the product code of the new product. Then,
The new input screen 6 is displayed on the display device 53, and the product code of the new product is displayed in the product code input area on the screen 6.

Here, the person in charge determines whether there is an existing product whose product information is similar to the new product. If there is an existing product, the user operates the mouse 52 to turn on the immediately preceding copy button 63. Then, the display device 5
Since the screen 3 is switched to the search input screen 7, a condition item whose information matches with both the new product and the existing product is selected from among the three search condition items of the product name, the manufacturer name, and the standard name, and the keyboard 51 is selected. By operating the mouse 52, the corresponding information is input to the corresponding search condition area.

After inputting the information on the search condition items, the mouse 52 is operated to turn on the immediately preceding copy button 63.
Then, the product master file 4 is searched with the input search condition item information, and all the product records whose product information of the same item as the search information matches the search information are extracted. Then, the product code, maker name, standard name and the like of the extracted product record are listed in the result area 75.

Therefore, the person in charge selects one of the product records closest to the product information of the new product from the product records listed in the result area 75 with the mouse 52, and then selects the product record by operating the mouse 52. The button 78 is turned on. Then, the product information of the selected existing product except the product code is stored in the product record memory 59, and the screen of the display device 53 returns to the new input screen 6.

Thus, on the new input screen 6, product information other than the product code of the existing product similar to the new product is displayed for each item together with the product code of the new product. Then, the person in charge selects only information of items different from the existing product in the product information of the new product with the mouse 52 and corrects the information of the new product by operating the keys of the keyboard 51. When the correction is completed, the mouse 52 is operated to turn on the confirmation button 61. By the above operation,
A product record including product information of a new product is additionally registered in the product master file 4.

For example, if the product name of a new product is “Japanese dressing with non-oil” and “Non-oil” is used as a part of the name of an existing product whose product information is similar to that of the new product, the search is performed. A product name is specified as a condition, and information “non-oil” is input. By doing so, all the product records including “non-oil” in the product name are extracted from each product record registered in the product master file 4, and are listed in the result area 75.
Therefore, when a record of the corresponding existing product is selected from the product records listed in the result area 75,
The product information excluding the product code in the product record is copied as the product information in the corresponding item of the new product.

As described above, according to the present embodiment, instead of specifying the product code of an existing product, the product name of the existing product or a part of the manufacturer's name is entered and the product code already registered in the product master file 4 is input. The product record of the existing product can be obtained, and the information of the obtained product record can be copied as new product information. Therefore, even if there is no existing product at hand, the product of the existing product registered in the product master file 4 can be obtained. Product information of a new product can be additionally registered in the product master file 4 using the information.

Further, when copying the product information of the existing product, the product code is copied without the product code, so that the product code unique to each product is not wastefully copied, and the product information is efficiently used. is there.

The present invention is not limited to the application to the headquarters computer system 1, but can also be applied to the store POS system 2 having the product file downloaded from the headquarters through the communication network 3.

In the embodiment, when a plurality of search condition items are specified, the product record including the search information is extracted in all the search condition items.
A product record including search information may be extracted using one search condition item. In addition, it goes without saying that various modifications can be made without departing from the spirit of the present invention.

[0041]

As described above in detail, according to the first aspect of the present invention, even if an existing product similar to a new product is not at hand, the product information of the existing product registered in the product file is used. A product file management apparatus capable of additionally registering product information of a new product in a product file. According to the invention described in claim 2 of the present application, a product file in which product information of a new product can be additionally registered in a product file more efficiently by using product information of the existing product registered in the product file. A management device can be provided.

[Brief description of the drawings]

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

FIG. 2 is a diagram showing a configuration of a product record stored in a product master file according to the embodiment.

FIG. 3 is a functional block diagram of a product master management unit according to the embodiment;

FIG. 4 is a flowchart showing a main part of a new mode process executed by a main control unit of the product master management unit.

FIG. 5 is a flowchart specifically showing search copy processing in FIG. 4;

FIG. 6 is an exemplary diagram of a new input screen displayed in the embodiment.

FIG. 7 is an exemplary diagram of a search input screen displayed in the embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 ... Headquarter computer system 4 ... Product master file 5 ... Product master management unit 51 ... Keyboard 52 ... Mouse 53 ... Display device 56 ... File search unit 58 ... Main control unit 59 ... Product record memory

Claims (2)

[Claims] 1. A product which sets and stores product information of various items necessary for order management, sales management and the like of a product name, a manufacturer name, a supplier name, etc., corresponding to a product code assigned to each product. In the file management device, a product information storage unit that stores information for each of various items constituting the product information; an information correction unit that selectively corrects the information stored in the product information storage unit for each item; Product information adding means for additionally registering the information stored in the product information storage unit in the product file; and selectively inputting information on an item serving as a search condition of the product file from various items constituting the product information Search condition input means; and file search means for searching the product file with information on search condition items input by the search condition input means and extracting product information satisfying the condition. A search list output unit that outputs a list of product information extracted from the product file by the file search unit; and a search information selection unit that selects any one of the product information output from the list by the search list output unit. And a merchandise information copying means for storing the merchandise information selected by the search information selecting means in the merchandise information storage unit. 2. The merchandise information copying means is means for storing, in the merchandise information storage unit, information on various items of the merchandise information selected by the search information selecting means, excluding a merchandise code. Item 1. The product file management device according to Item 1.