JPH07168893A - Maintenance method for commodity master file - Google Patents

Abstract

PURPOSE:To reduce the change input man-hours and to accurately and effectively perform the change of the same price to a specific commodity group by designating a price changing pattern mark to the commodity group to show a price changing rule in regard of a maintenance method applied to a commodity master file in the retail trade where the price information is frequently changed. CONSTITUTION:A commodity master file 12 is shown in a table form at a display part 10, and a price changing pattern input mark 9 is supplied through an input part 11. Then the mark 9 is collated with a price changing pattern table 14 stored in a storage part 18 at a price changing rule decision processing part 16 for decision of a price updating rule. Then the price information of the file 12 is continuously changed by the same price changing rule until a different mark 9 emerges to an array of rows.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a master maintenance work for retail businesses such as supermarkets, which require frequent price information changes, and particularly to a method for maintaining a product master file suitable for reducing input man-hours and improving work efficiency. Regarding

[0002]

2. Description of the Related Art In the conventional price change input method in master maintenance, a product to be price changed is selected,
The input manuscript in which the price after the price change is entered is created for each applicable product, and the update and input process of the amount is performed for each product. Therefore, similar input man-hours are required even when the price is changed by the same price change rule for a specific product group. For example, in the POS system disclosed in Japanese Patent Laid-Open No. 61-240396, the master file data is changed / added by setting the master ECR to the master position and setting mode. Then, by inputting a predetermined numerical value from the keyboard, the change data and additional data for the submit file are stored. Therefore,
By inputting data from the keyboard, the data is sequentially stored in the submit file. Further, by inputting a predetermined numerical value from the keyboard, the data in the file is sequentially read out and the content of the master file is updated. In this way, the data input such as change / addition is easily read and confirmed, and then the content of the master file is updated, whereby the POS system is efficiently operated. Further, in the POS system described in Japanese Patent Application Laid-Open No. 01-281564, two types of bar code number sequences read by a bar code reader when a salesclerk attaches an additional bar code when performing a discount on a product. Is input to the control unit. The control unit identifies the discount processing of the product based on the contents of the used / unused and additional barcode identification code memory of the product master table, and registers the product with the price reduced from the initial price as the selling price. The registered contents are output to the receipt journal printer and displayed on the display. As described above, when the price change information is present in the product having two types of barcodes, the price change process is facilitated by performing the calculation process according to the information in the control unit. In these POS systems, when a price change of a product is input, an update input process is performed for each product by keyboard input or by attaching an additional barcode. It should be noted that the input method for changing the product price in a specific group unit is not described.

[0003]

The above-mentioned prior art does not take into consideration the input man-hours when changing the price of a product in units of a specific group, and the input man-hours for frequent price changes for a specific product group. Was difficult to reduce. An object of the present invention is to provide a maintenance method of a product master file suitable for improving such a problem and reducing the input man-hour when changing the price of a product in a specific group unit. Moreover, it aims at accurately performing the same price change for a specific product group.

[0004]

In order to achieve the above object, a method of maintaining a product master file according to the present invention includes a product master file, a display unit for displaying price information of products registered in the file in a table format, In a system including an input unit for inputting required data from the screen of the display unit and a processing unit, a price change rule for a product and a symbol (price change pattern symbol) corresponding to the rule are registered in advance. Every time the symbol is entered in any line of the price information displayed on the screen of the display unit, the price corresponding to that symbol is changed in the forward direction from that line to the line where other symbols have been entered or the last line. The feature is that the price change process of the product is executed using the rule.

[0005]

In the present invention, the frequently-changed price change pattern is registered in the table of the storage unit in a format in which the input symbol and the price change rule are associated with each other, and the symbol inputted on the display screen of the product master file is registered. The price change pattern indicated by is associated with a specific product group, and the price information of the products included in the associated product group is changed based on the corresponding price change rule. That is, the entered price change pattern symbol is inquired with the price change pattern registered in the storage unit along the line of the line of the product information on the display screen, and the line in which a different price change pattern symbol is already entered is displayed. Until the detection or the inquiry processing reaches the last line, the price change processing is immediately performed by the same price change rule. Therefore, the price change process can be performed within an arbitrary range for the displayed line of product information, and the input time can be shortened. Therefore, in the process of frequently changing the selling prices of many products at once, such as the uniform percentage discount of the product prices of a specific department for special sale, it is possible to reduce the input man-hours of the price change input and accurately change the prices. It is possible.

[0006]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail below with reference to the drawings. FIG. 1 is a configuration diagram of a product file system according to an embodiment of the present invention. In FIG. 1, 9 is a price change pattern input symbol, 10 is a display unit for displaying the price of the contents of the product master file before and after the price change, and 11 is a price change pattern for the row of the price information lines of the products displayed on the display unit. An input unit for designating a symbol, 12 is a product master file, 13 is a current price change pattern table for temporarily storing the price change pattern symbol being applied in the update process and the price change rule, and 14 is the input price change pattern symbol. Is a price change pattern table for determining the price change rule, 15 is a price change pattern input processing unit,
16 is a price change rule determination processing unit, 17 is a price update processing unit, and 18 is a storage unit. This product master file 12
2, as shown in FIG. 2, product classification (for example, large classification,
The product code 18 assigned based on the middle classification and the sub-classification), the basic selling price 19, the modified selling price 20 in which the selling price is changed, and other product attributes 21 be registered. Further, in the price change pattern table 14, as shown in FIG. 3, a price change pattern symbol 22 indicating a change pattern of the selling price 19, and
Price change rule 2 that shows the calculation formula when changing the selling price 19
3 is registered. In addition, in FIG. 3, “*” indicates multiplication,
"/" Indicates division, "-" indicates subtraction, "+" indicates addition, and "X" indicates variables. Further, in the current price change pattern table 13, as shown in FIG. 4, the current price change pattern symbol 24 indicating the price change pattern input symbol 9 input by the operator from the input unit 11 and the price of the price change pattern table 14 are shown. The current price change rule 25 in which the variable of the change rule 23 is fixed is temporarily stored. This registered content is executed immediately, and the previous content is deleted when the next price change rule is input. Further, for example, when the bargain period has passed and the selling price is returned to the original value, "-0%" is input. Note that a plurality of price change rules may be registered / held and may be arbitrarily deleted by an operator's instruction. Further, in FIG. 4, “*” indicates multiplication, “/” indicates division, “−” indicates subtraction, and “+” indicates addition.

Next, the price changing process of the product master file 12 in this embodiment will be described. 5 to FIG.
It is a figure which shows the price change screen in one Example of this invention. 5 to 7, 1 is a part of the screen for inputting the change price displayed on the display unit 2, and 2 is a total price change screen reflecting the input change price. Corresponds to the product master file 12.
Further, 6 to 8 are price change pattern symbols (change symbols "-
30% "," -10% "," -20% "), and the applicable range of the price change rules" 1 "," 2 "," 3 ". In the present embodiment, the input of the price change pattern input symbol 9 on the display screen 1 of FIGS. For example, as shown in FIG.
When "-30%" indicating "price change rule 1" is entered by the operator in the change symbol column at the beginning of the screen 1, "item number 1", price information within the applicable range 6 (in the "change selling price" column Content) is updated immediately. The applicable range of the price change rule is the last line of the screen 2 or the line to which the next price change rule is applied. Specifically, the price change pattern input processing unit 13 acquires the input symbol “−30%” and stores it in the current price change pattern symbol 24 in the current price change pattern table 13. Next, in the price change rule determination processing unit 16, the price change pattern symbol 22 in the price change pattern table 14 is searched with the input symbol as a key, and the price change rule 23 “selling price * (100− X) / 100 ”, the value of the variable included in the rule is confirmed, and the current price change rule 2 in the current price change pattern table 13 is acquired.
The “selling price * (100−30) / 100” is stored in 5.
Next, in the price update processing unit 17, the selling price 19 in the product master file 12 is based on the current price change rule.
The price update processing is performed on the product and the processing result is stored in the changed selling price 20 in the product master file 12. Subsequent to this process, from the first line to the last line of the screen 2 displayed on the display unit 10, the change symbol column is searched in the forward direction and the current price change pattern symbol stored in the current price change pattern table 13 is searched. 24 Price update processing unit 17 until a line in which a symbol different from "-30%" is input is found.
The process of is repeated. At this time, "blank" in the change symbol column, which means that the price change pattern input symbol 9 has not been input, is not judged as a different input symbol.

After this, the operator additionally inputs the price change pattern input symbol 9 ("-10%") in the change symbol column of the Mth line "Item No. M" of the screen 1 from the input unit 11 as shown in FIG.
Shown in. Also in this case, similarly to the above, the price change pattern input processing unit 13 acquires the input symbol “−10%”, and the price change rule determination processing unit 16 uses the input symbol as a key to set the price change rule “selling price *”. (100-X) /
100 ”and acquires the current price change pattern table 13
The "selling price * (100-10) / 100" is stored in. Based on this current price change rule, the price update processing unit 17 updates the changed selling price column of the product master file 12.
Further, the change symbol column is searched in the forward direction from the M-th line on the screen 2, and the price updating process is repeated until a line in which a symbol different from "-10%" is input is found. in this case,
The applicable range 7 of the "price change rule 2" is from the M-th line to the last line. Further, as shown in FIG. 7, when "-20%" is additionally input in the change symbol column of the Lth line as "price change rule 3", the price is updated in the same processing procedure as described above, and the Lth line is updated. From eyes to line M-1 ("Price Change Rule 3"
Change the price of the scope 8). With such price update processing, the POS connected to the product file system
Terminals and the like can easily and surely sell at the changed price even when the price is changed frequently in the short term such as bargain sale.

[0009]

According to the present invention, the following effects can be expected. (1) The input man-hours for product master maintenance can be reduced,
Work efficiency is improved. (2) The same product, such as a special sale product, which requires frequent price changes in a short cycle facilitates price change work and can handle more items.

[Brief description of drawings]

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

FIG. 2 is a diagram showing a structure of a product master file in one embodiment of the present invention.

FIG. 3 is a diagram showing a configuration of a price change pattern table in one embodiment of the present invention.

FIG. 4 is a diagram showing a configuration of a current price change pattern table in the embodiment of the present invention.

FIG. 5 is a diagram showing a price change screen according to an embodiment of the present invention.

FIG. 6 is a diagram showing a price change screen according to an embodiment of the present invention.

FIG. 7 is a diagram showing a price change screen according to an embodiment of the present invention.

[Explanation of symbols]

 10 display unit 11 input unit 12 product master file 13 current price change pattern table 14 price change pattern table 15 price change pattern input processing unit 16 price change rule determination processing unit 17 price update processing unit 18 storage unit

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Katsuyoshi Hara 12 Hitachi Ltd. Information Systems Division, 890 Kashimada, Saiwai-ku, Kawasaki-shi, Kanagawa

Claims (1)

[Claims] 1. A product master file, a display unit for displaying price information of products registered in the file in a tabular form, an input unit for inputting required data on a screen of the display unit,
In a method of changing a product price of a system including a processing unit and a processing unit, a price change rule for a product and a symbol corresponding to the rule are registered in advance, and the symbol is used for any price information displayed on the screen of the display unit. A product master characterized by executing a price change process of a product in the forward direction from that line to the line where another symbol has been input or the last line when the line is input, using the price change rule corresponding to the symbol. How to maintain files.