JP2006201945A - Data processing system in selling price change work - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data processing system that can reliably carry out all work without leaving unworked commodities in the selling price change work of commodities handled in a store. <P>SOLUTION: The system includes: a storage means for associating and storing a display place identifier attached to a display place, a price card identifier associated with each commodity, a commodity selling price and a commodity code; a work notification means for notifying the start and end of the work; a warning means for monitoring and warning work progress; a change indicating means for indicating a change of commodity information; a price card creation means for creating a price card by receiving a work end notification and acquiring the commodity information; and a decision indicating means for performing work progress decision and instructions based on the decision results by receiving the work end notification. In the work notification means, a work start notification is executed by the instructions of the administrator terminal used by an administrator. The administrator terminal receives the notification of the fact that the work is started from a worker terminal used by a worker. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a data processing system used when changing the selling price of a product in a retail store such as a supermarket or a convenience store.

  In retail stores such as supermarkets and convenience stores, it may be necessary to change the selling price of a product, and a selling price changing system for improving workability required for changing the selling price is known.

For example, a salesperson in charge inputs data necessary for changing the selling price into a portable price tag issuing machine and issues a price tag with the changed price. Thereafter, the data input to the portable price tag issuing machine is transmitted to the computer terminal, and the product information stored in the product file of the database is updated. Therefore, it is possible to issue a price tag after changing the selling price simply by inputting data necessary for changing the selling price to the portable price tag issuing machine, and it is possible to change the product information in the product file, which is necessary for changing the selling price. A merchandise selling price changing system that can improve workability and shorten the time required for selling price changing work is disclosed (see Patent Document 1).
Japanese Patent Laid-Open No. 11-73468

  However, in the conventional merchandise selling price changing system, the selling price changing operation is left to the staff in the field, and it is unclear whether the selling price changing operation has been performed reliably because no work instruction has been given by the administrator. In addition, it is unclear whether the price tag change work and the price change work have been performed for all products for which there is no specified display place and there is a change in the sales price in a predetermined display place. There was a problem that occurred and sold at the wrong price.

  It is an object of the present invention to make sure that all selling price change work is performed without leaving unfinished goods when changing the selling price of products handled in a store, and it is possible to avoid sales mistakes and customer complaints due to omission of selling price changes. To provide a data processing system.

  In order to solve the above-mentioned problem, the invention according to claim 1 is a data processing system for executing a selling price change operation for a product, a display location identifier assigned to a display location, and a price tag identifier associated with each product. Stored in the storage means, storage means for storing the product price and the product code in association with each other, work notification means for notifying the start and end of work, warning means for monitoring and warning the work progress status, and the storage means. A change instructing unit for instructing to change the product information, a work end notification, a price tag creating unit for creating a price tag by acquiring the product information stored in the storage unit, and a work end notification A determination instructing unit for instructing a progress status and instructing according to the determination result, wherein in the operation notification unit, the operation start notification is executed by an instruction from an administrator terminal used by the administrator Is the administrator terminal is characterized by receiving from the operator terminal used by an operator a notice that the work is started.

  According to a second aspect of the present invention, in the data processing system according to the first aspect, the warning means issues a warning notification to the manager terminal and the worker terminal as long as unworked goods exist. It is characterized by that.

  The invention according to claim 3 is the data processing system according to claim 1 or 2, wherein the display place identifier stored in the storage means is attached to each display place and stored in the display place. It is characterized by including product information.

  According to a fourth aspect of the present invention, in the data processing system according to any one of the first to third aspects, the price tag identifier stored in the storage means is the product information and display location information associated with each other. It is characterized by including.

  According to a fifth aspect of the present invention, in the data processing system according to any one of the first to fourth aspects, the change instruction unit acquires the commodity information by inputting the commodity code, and the commodity It is characterized in that a selling price change instruction is given by designating a selling price after change for information.

  According to a sixth aspect of the present invention, in the data processing system according to any one of the first to fifth aspects, the change instruction unit acquires the commodity information by inputting the commodity code, and the commodity For the information, the display location change instruction is performed by designating the display location identifier.

  According to a seventh aspect of the present invention, in the data processing system according to any one of the first to sixth aspects, the change instructing means is configured to execute the selling price change instruction in parallel with the display location change instruction and the price tag change operation. It is characterized by that.

  According to an eighth aspect of the present invention, in the data processing system according to any one of the first to seventh aspects, the determination instructing unit is configured to perform registration based on a determination result obtained by the work completion determination and the post-change selling price determination. And selling price change instruction and sales start instruction to the manager.

  According to a ninth aspect of the present invention, in the data processing system according to any one of the first to eighth aspects, the price tag creating means includes the product name and the changed selling price of the product information stored in the storage means. And a price tag is created by combining with the price tag identifier.

  According to the present invention, when changing the selling price of a product handled in a store, it is possible to reliably perform all selling price changing work without leaving an unfinished product. It is possible to avoid claims.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

  In the data processing system of the following embodiments, the data processing system will be described mainly assuming that the selling price changing operation is performed in the same store. However, the present invention is not limited to this and includes other stores. Also good. By attaching a store identifier to each store, it is possible to target a plurality of stores.

  First, the configuration in the embodiment of the present invention will be described. In FIG. 1, the structure of the data processing system 100 of the whole store which concerns on embodiment is shown. As shown in FIG. 1, the store-wide data processing system 100 includes a manager terminal 10, a worker terminal 20, a cash register 30, a server 40, and a printer 50, and each device constituting the data processing system 100 includes Connected by communication network N. In the sales floor, an administrator terminal 10, an operator terminal 20, and a cash register 30 are installed. A server 40 and a printer 50 are installed in the backyard. Note that the numbers of the administrator terminal 10, the worker terminal 20, the cash register 30, and the printer 50 connected to one server 40 via the communication network N are not particularly limited. Further, the administrator terminal 10 and the server 40 may be configured by a single PC (Personal Computer) or the like.

  Here, the communication network N is, for example, a network such as a public line, a telephone line, an ISDN line, a wireless communication line, a dedicated machine, or a CATV line. The communication network N preferably has a security function accessible only to a specific user from the viewpoint of reliability of information management. Alternatively, the data processing system 100 may be configured to include a proxy server having a firewall function that restricts information passing therethrough.

  In FIG. 1, the administrator issues a work instruction to the worker terminal 20 and the server 40 by using the manager terminal 10 when the selling price is changed. When the manager terminal 10 displays the selling price change work notification on the worker terminal 20, the work is started. During the selling price changing operation, when the administrator inputs the instruction content to the administrator terminal 10, the worker terminal 20 proceeds the operation based on the instruction content. Note that the administrator terminal 10 is not limited to a desktop type, and may be a notebook type or a PDA. Further, the number of managers is not limited to one, and an administrator can be identified by attaching an identifier to each manager. Therefore, a plurality of managers may give instructions.

  When the work instruction content by the administrator is displayed, the worker terminal 20 starts the work by requesting the server 40 for information necessary for the selling price changing work. Further, the worker gives a work start notification, a work end notification, and other work report notifications to the server 40 from the worker terminal 20. The worker terminal 20 may be any portable terminal such as a PDA or a notebook, and is not particularly limited. Furthermore, the number of worker terminals is not limited to one, and the work may be shared by a plurality of workers by confirming the work status among a plurality of worker terminals.

  The cash register 30 is notified of the price after sale price change of the sale price change target product from the server 40. Further, when the selling price change work is completed, a work completion report is notified. When the cash register 30 sells the product after the notification of the price after sale price change notification of the sale price change target product, the cash register 30 sells the product at the new sale price after sale price change.

  The server 40 performs merchandise management of the entire store including merchandise information and merchandise display information. Further, it is a management process for notifying the work instruction or work report of both the manager terminal 10 and the worker terminal 20 at the time of selling price change, and notifying the register 30 and the printer 50 of the work instruction. Further, during the selling price change work, the presence / absence of unfinished products is always monitored, and if there is a product for which work completion designation time is approaching or has already exceeded among unfinished products, the manager terminal 10 and A warning is notified to the worker terminal 20.

  When the selling price is changed, the printer 50 issues a new price tag 70 (described later) based on the product information of the selling price change target product. Although the printer 50 is configured as a separate body, it may be configured to accompany the operator terminal 20.

  FIG. 2 shows an example of the price tag 70 issued by the printer 50. As shown in FIG. 2, the price tag 70 includes a product name 71, a product selling price 72, and a price tag identifier (hereinafter referred to as a price tag ID 73). In the price tag ID 73, information such as the product name 71, the product selling price 72, and the display place identifier (described later) of the associated product is stored. When the selling price is changed, the printer 50 issues a new price tag with a new price tag ID 73 storing the product name 71, the new product selling price 72, and the updated product information.

  FIG. 3A illustrates an example of a schematic configuration diagram of the display shelf 60 installed in the sales floor. As shown in FIG. 3A, a display shelf 60 is installed in the sales floor, and products are stored in the display shelf 60 for each classification.

  FIG. 3B is an enlarged view showing an example of the display place 61 for storing products. As shown in FIG. 3B, the display place 61 has a display place identifier (hereinafter referred to as a sales place ID 62) for identifying a product. The sales floor ID 62 stores the display location of the product and product information, and the price tag 70 associated with the sales floor ID 62 is attached to each display location 61. The worker performs product management based on the information stored in the sales floor ID 62, and also stores the information stored in the sales floor ID 62 and the information stored in the price tag ID 73 of the price tag 70 attached to the display place 61 when the selling price is changed. Based on this, the selling price is changed. Accordingly, the product data stored in the sales floor ID 62 and the price tag ID 73 is updated each time the product stored in the display place 61 is changed or the selling price of the stored product is changed. , The latest product data is always stored.

  Further, when the selling price is changed, the sales floor ID 62 is acquired from the product information stored in the price tag ID 73. Based on the acquired sales floor ID 62, the display place 61 is specified. Then, the worker performs an operation of pasting the old price tag 70 attached to the specified display place 61 to the new price tag 70.

  In addition, in this embodiment, although the display place 61 was set as the structure provided in the same store, it is good also as a structure including not only the same store but another store.

  FIG. 4 shows a main part configuration of the server 40. As shown in FIG. 4, the server 40 includes a CPU (Central Processing Unit) 41, a RAM (Random Access Memory) 42, a ROM (Read Only Memory) 43, an HDD (hard disk) 44, and a communication interface 45.

  The CPU 41 controls the operation of each unit constituting the server 40 according to various programs stored in the HDD 44. For example, when the CPU 41 receives any instruction regarding the selling price changing work transmitted from the administrator terminal 10 via the communication interface 45, the CPU 41 performs control for requesting the instruction to the worker terminal (see FIG. 9). .

  The RAM 42 develops various programs executed by the CPU 41 in the program storage area. The RAM 42 temporarily stores data such as processing results generated when various programs are executed in the work area. For example, the RAM 42 temporarily stores new information on product data generated in accordance with the selling price changing operation.

  The ROM 43 stores, among various programs executed by the CPU 41, programs that do not need to be rewritten and programs that should not be rewritten. For example, a program relating to an unworked warning process that is always executed by the CPU 41 is stored (see FIG. 11).

  The communication interface 45 mediates exchange of data and instructions transmitted / received between the manager terminal 10 and the worker terminal 20.

  The HDD 44 includes DB (database) storage means 44a. The DB storage unit 44a stores data such as product information, sales floor conditions, and sales trends. In the DB storage unit 44a, the latest product data is always stored in association with the price tag ID 73 and the sales floor ID 62. The server 40 controls updating and reading of product data stored in the DB storage unit 44a.

  5A, 5B, 5C, and 5D show tables for managing merchandise stored in the DB storage unit 44a of the HDD 44. FIG. As shown in FIG. 5, a product table 46 and a shelf allocation table 47 are stored as master tables, and a selling price change work table 48 and a display change work instruction table 49 are stored as work tables.

  New product information is always stored in the product table 46 and the shelf allocation table 47 as master tables. Therefore, the merchandise information is always updated when the selling price is changed.

  The merchandise table 46 stores a merchandise code for identifying each merchandise, a merchandise name 71, and a merchandise selling price 72, and manages merchandise information being sold in the store. In the shelf allocation table 47, a product code, a sales floor ID 62, a price tag ID 73, the number of displays, and the number of unsold items are stored, and the display location 61 of each product and the number of products displayed in the display location 61 are managed.

  The unsold number of the shelf allocation table 47 is determined by the input device 26 of the worker terminal 20 after the number of unsold items stored in the display place 61 is directly counted by the operator after, for example, the end of business. Entered. As a result, the number of unsold items can be grasped for each display place 61, and the number of items stored in each display place 61 and the sales trend can be confirmed. Further, the sales ratio for each sales floor is obtained from the number of displays and the number of remaining sales that have been input. Therefore, not only can the number of sales of the entire store be grasped, but also the number of sales for each display place 61 can be grasped, so that it is possible to construct a sales floor that promotes sales improvement based on the sales trend for each display place. .

  In the selling price change work table 48 and the display change work instruction table 49 as work tables, the contents of work instructions transmitted by the administrator terminal 10 at the time of selling price change are displayed, and the worker is displayed on the operator terminal 20. You are notified of the work to be done.

  In the selling price change work instruction table 48, the product code of the product whose selling price is to be changed, the new selling price 72 after selling price change, and the sales floor ID 62 for confirming the current display location 61 of the selling price change target product are displayed. . In the display change work instruction table 49, the product code of the product whose sale price is to be changed, the display location 61 after the sale price change of the product is designated, the sales floor ID 62, and the planned number of products to be displayed at the designated display location 61 Is displayed. In addition, a completion instruction time for completing the work designated by the administrator is displayed on both sides, and a work progress status is displayed on the flag.

  6 and 7 show the main configuration of the manager terminal 10 and the worker terminal 20. As shown in FIGS. 6 and 7, the administrator terminal 10 and the worker terminal 20 include CPUs (Central Processing Units) 11 and 21, RAMs (Random Access Memory) 12 and 22, ROMs (Read Only Memory) 13 and 23. , CRT (Cathode Ray Tube) 14, 24, communication interfaces 15, 25, input devices 16, 26, bar code input devices 17, 27, and buzzers 18, 28.

  6 and 7, the CPUs 11 and 21 control the operation of each unit constituting the manager terminal 10 and the worker terminal 20 in accordance with various programs stored in the DB storage unit 44 a of the server 40.

  The RAMs 12 and 22 develop various programs executed by the CPUs 11 and 21 in a program storage area. The RAM temporarily stores data such as processing results generated when various programs are executed in the work area.

  ROM13, 23 memorize | stores the program which must not be rewritten among the various programs run by CPU11, 21, and the program which must not be rewritten.

  The CRTs 14 and 24 convert the signal transmitted by the server 40 into light, and display it on the screens (not shown) of the manager terminal 10 and the worker terminal 20 as images visible to the manager and the worker.

  The communication interface 15 mediates exchange of product data, work instruction contents, work reports, and the like to the server 40 and the worker terminal 20.

  The communication interface 25 mediates exchange of product data, work instruction contents, work reports, and the like to the server 40 and the manager terminal 10.

  The input devices 16 and 26 include cursor keys, numeric input keys, and various function keys, and output operation signals corresponding to key pressing operations to the CPUs 11 and 21.

  The bar code input devices 17 and 27 include a cursor key, a numeric input key, and various function keys, and output an operation signal corresponding to the pressing operation to the CPUs 11 and 21 by inputting the price tag ID 73 and the sales floor ID 62. The bar code input devices 17 and 27 may be provided with a handy bar code scanner.

  The buzzers 18 and 28 sound a confirmation sound in conjunction with the display on the screens of the manager terminal 10 and the worker terminal 20 when a work instruction by the manager and a work report by the worker are notified.

  Next, the operation in the embodiment of the present invention will be described.

  First, the overall processing executed in the embodiment of the present invention will be described with reference to the flowchart of FIG.

  First, when a work instruction is issued by the administrator (step S1), the work instruction content from the administrator is notified to the worker terminal 20, and the work is started by the worker. The worker notifies the manager of reports such as work start, progress status and work end (step S2). Accordingly, the work is started by an instruction from the manager, and the work is finished by the report of the worker.

  Next, with reference to the flowchart of FIG. 9, the process performed by the administrator's work instruction will be described.

  First, the selling price changing operation is started by the manager entering the product code of the selling price change target product through the input device 16 or the barcode input device 17 (step K1).

  In step K1, when the product code of the sale price change target product is input, the product data associated with the product code is stored from the product table 46 and the shelf allocation table 47 stored in the DB storage unit 44a of the server 40. Obtained (step K2).

  In step K2, when the product data of the sales price change target product is acquired, the product data is displayed on the screen of the manager terminal 10 (step K3).

  In step K3, when the product data is displayed on the screen of the administrator terminal 10, the product data is confirmed by the administrator, and a work instruction for selling price change and display change for the product is displayed on the administrator terminal 10. Input is made by the input device 16 (step K4).

  In step K4, when the work price change and display change instruction for the product, that is, the designation of the price after sale price change and the designation of the display location are input by the input device 16 of the manager terminal 10, the DB of the server 40 The work instruction content is registered in the selling price change work instruction table 48 and the display change instruction table 49 stored in the storage means 44a (step K5).

  In step K5, when the work instruction content for the product is registered in the selling price change work instruction table 48 and the display change instruction table 49, the work completion instruction time of the unfinished product is approaching or the work completion instruction time is already set. It is determined whether or not the work state monitoring process for monitoring the presence or absence of the exceeding product is activated (step K6).

  In step K6, when it is determined that the work state monitoring process is activated (step K6; YES), the work terminal 20 is notified of an instruction to start selling price change work for the product (step K8).

  If it is determined in step K6 that the work state monitoring process has not been started (step K6; NO), the work state monitoring process is started in parallel with the selling price change work start notification (step K8) for the work terminal 20. (Step K7).

  In step K8, when the selling price change work instruction for the product is notified to the worker terminal 20, it is determined in step K9 whether the selling price change work and the display change work for the selling price change target product are all completed. If not, the process returns to step K1, and the processes of steps K1 to K8 are repeated for the other selling price change target products. In step K9, when all the selling price changing work and display changing work for the selling price change target product are finished, the work instruction notification by the manager is finished.

  Next, with reference to the flowchart of FIG. 10, the process performed according to an operator's instruction will be described.

  After the selling price change work start instruction is notified from the administrator terminal 10 to the worker terminal 20, when the worker requests the work instruction content from the server 40, the server 40 displays the selling price on the screen of the worker terminal 20. The work instruction contents registered in the change work instruction table 48 and the display change work instruction table 49 are displayed (step T1).

  In step T1, when the work instruction contents registered in the selling price change work instruction table 48 and the display change work instruction table 49 are displayed on the screen of the worker terminal 20, the display location of the product instructed to start work. In order to confirm 61, the sales floor ID 62 of the product is input by the input device 26 or the barcode input device 27 of the operator terminal 20 (step T2).

  In step T2, when the sales floor ID 62 of the product is input by the input device 26 or the barcode input device 27 of the worker terminal 20, the work is started based on the content of the work instruction. Along with the start of work, work start is displayed in the flags of the selling price change work instruction table 48 and the display change work instruction table 49 displayed on the screen of the worker terminal 20 (step T3). With this flag, the administrator confirms that work has been started on the product.

  In step T3, when the work start is displayed in the flags of the selling price change work instruction table 48 and the display change work instruction table 49 displayed on the screen of the worker terminal 20, the new price tag 70 is displayed to the printer 50. A creation instruction is notified (step T4).

  In step T4, when the printer 50 is instructed to create a new price tag 70 (step T4), the new price tag 70 is issued based on the product information instructed by the administrator (see FIG. 13). When the new price tag is issued, a sales price change work end report for the product is input by the input device 26 of the worker terminal 20 (step T5).

  In step T5, when the sales price change work end report for the product is input by the input device 26 of the worker terminal 20, the server 40 is instructed to start the notification determination process for the manager terminal 10 and the cash register 30. (Step T6). The server 40 performs a determination process for notification to the manager when the selling price change operation is completed and notification to the cash register 30 when the new selling price registration is completed (see FIG. 12).

  In step T6, the notification determination process for the manager terminal 10 and the cash register 30 is instructed to start, and the manager terminal 10 and the cash register 30 are notified of completion of the selling price change work and the display change work for the product. Then, the completed work on the product is deleted from the selling price change work instruction table 48 and the display change work instruction table 49 displayed on the screen of the operator terminal 20, and the product table 46 and the shelf allocation table 47 are displayed. The work result of the product is reflected in the stored conventional product data, and the product data is updated to the latest data (step T7).

  In step T7, when the sales price change work result is reflected in the product table 46 and the shelf allocation table 47 and the product data of the product is updated, it is determined whether the work has been completed for all the products whose price is to be changed. (Step T8).

  In step T8, when it is determined that there are unfinished selling price change target products (step T8; NO), the process returns to step T1, and the processes of T1 to T8 are repeated again.

  In step T8, when it is determined that all the operations for the sale price change target product have been completed (step T8; YES), the processing executed according to the operator's instruction is completed.

  Next, the work state monitoring process executed by the server 40 will be described with reference to the flowchart of FIG.

  First, when the selling price change work is started, whether there is a record in the selling price change work instruction table 48 and the display change work instruction table 49 whose work completion instruction time is approaching or has already exceeded the work completion instruction time. It is determined whether or not (step W1).

  If it is determined in step W1 that there are records in the selling price change work instruction table 48 and the display change work instruction table 49 that have a work completion instruction time approaching or have already exceeded the work completion instruction time (step W1; YES), it is determined whether or not the selling price change operation for the product corresponding to the record has been started (step W2).

  When it is determined in step W1 that there is no record in the selling price change work instruction table 48 and the display change work instruction table 49 that has a work completion instruction time approaching or has already exceeded the work completion time (step W1) NO), the warning notification to the administrator and the worker is not performed, and the process returns to the determination process in step W1.

  If it is determined in step W2 that the selling price change operation for the product corresponding to the record has not been started (step W2; NO), it is determined whether or not the warning for the same record is new (step W3). ).

  In step W3, when it is determined that the warning for the same record is new (step W3; YES), the warning is notified to the administrator and the worker (step W5).

  If it is determined in step W3 that the warning for the same record is not new (step W3; NO), it is determined whether or not a fixed time has passed since the previous warning for the same record (step W4).

  In step W4, when it is determined that a certain time has elapsed since the previous warning for the same record (step W4; YES), it can be determined that work has not been performed even though the warning has been given once. A warning is again notified to the worker (step W5).

  In step W4, if it is determined that a certain time has not elapsed since the previous warning for the same record (step W4; NO), it is possible to determine that the warning has just been issued, so the warning to the administrator and the operator Is not notified, the process returns to step W1, and the processes of steps W1 to W4 are executed again.

  If it is determined in step W2 that the selling price change operation for the same record has been started (step W2; YES), the selling price change work instruction table 48 and the display change work instruction table 49 exceed the work completion instruction time. It is determined whether or not there is a record that exists (step W6).

  In step W6, when it is determined that there is a record exceeding the work completion instruction time in the selling price change work instruction table 48 and the display change work instruction table 49 (step W6; YES), a warning for the same record is issued. Then, it is determined whether or not it is new (step W7).

  If it is determined in step W7 that the warning for the same record is new (step W7; YES), the work has started, but it can be determined that the completion specified time has already been exceeded. A warning is sent to the person (step W9).

  If it is determined in step W7 that the warning for the same record is not new (step W7; NO), it is determined whether or not a fixed time has elapsed after the previous warning for the same record (step W8).

  In step W8, if it is determined that a certain time has passed since the previous warning for the same record (step W8; YES), it can be determined that the work has not been completed even though the warning has been given once. A warning is notified again (step W9).

  In step W8, when it is determined that a certain time has not elapsed since the previous warning for the same record (step W8; NO), the warning for the administrator and the worker is not notified, and the processes of steps W1 to W8 are performed again. Is executed.

  If it is determined in step W6 that there is no record exceeding the work completion instruction time in the selling price change work instruction table 48 and the display change work instruction table 49 (step W6; NO), the selling price change work instruction table Whether or not 48 and the display change instruction table 49 are empty is determined (step W10).

  If it is determined in step W10 that the selling price change work instruction table 48 and the display change work instruction table 49 are empty (step W10; YES), the work monitoring process executed by the server 40 is terminated.

  In step W10, when it is determined that the selling price change work instruction table 48 and the display change work instruction table 49 are not empty (step 10; NO), the process returns to step W1 and the processes of steps W1 to W10 are repeated again.

  As described above, as long as unfinished goods exist in the data table, it is possible to prevent omission of work by notifying the administrator terminal 10 and the worker terminal 20 of a warning instruction, and the work accuracy can be prevented. Can be improved. Further, by notifying the warning about the work completion instruction time together with the presence or absence of unfinished products, the work can be performed quickly.

  Next, the notification determination process executed in the server 40 will be described with reference to the flowchart of FIG.

  When the worker inputs a work end notification from the input device 26 of the worker terminal 20, it is determined whether or not there is a product for which work has been completed in the product table 46 (step N1).

  If it is determined in step N1 that there is no product for which work has been completed in the product table 46 (step N1; NO), the product displayed in the selling price change instruction table 48 and the display change work instruction table 49 is a new product. Therefore, the cash register 30 is notified that the product information of the product has been registered (step N2), and the manager is notified that sales of the product are to be started (step N2). N3).

  In step N3, when the manager is notified that sales of the product are to be started, the display change work instruction table 49 is referred to and it is determined whether or not all the display change work has been completed (step N10). ). For new products, the selling price is not changed, but it is necessary to register the display place 61, and the product may be distributed in a plurality of display places 61, so this determination is necessary. It is.

  If it is determined in step N1 that there is a product for which work has been completed in the product table 46 (step N1; YES), it can be determined that the product is already on sale, so that it is displayed in the selling price change instruction table. The new selling price 72 is compared with the conventional selling price 72 stored in the product table 46 to determine whether the new selling price is cheaper (step N4).

  If it is determined in step N4 that the new selling price is lower for the product (step N4; YES), the selling price of the product is promptly changed with respect to the cash register 30 because the product is a price reduction target product. (Step N5).

  If it is determined in step N4 that the new selling price is not cheaper for the product (step N4; NO), the selling price change work instruction table 48 is referred to for any display place 61 because the product is a price-up target product. It is determined whether or not all the selling price change work for the merchandise displayed in (1) has been completed (step N6). In other words, this determination is necessary because the merchandise is not necessarily stored only in one certain display place 61 but may be distributed and stored in various display places 61.

  In step N6, when it is determined that the selling price change work for the product displayed in every display place 61 is completed (step N6; YES), the new price of the product for which the work has been completed is changed from the conventional selling price. It is determined whether the higher one is higher (step N7).

  In step N7, when it is determined that the new selling price is higher than the conventional selling price for the product for which the work has been completed (step N7; YES), since the product is a price increase target product, In addition to notifying the selling price change (step N8), the manager is notified that all the selling price changing operations for products whose new selling price is higher than the conventional selling price have been completed (step N9). That is, when selling price is changed during business hours, if the selling price 72 displayed by the cash register 30 is higher than the past selling price 72, a complaint may occur. After all the selling price change operations are completed, the cash register 30 is notified of the selling price change.

  In step N7, when it is determined that the new selling price is not higher than the conventional selling price for the product for which the work has been completed (step N7; NO), the product is a target product for price reduction, and the selling price change notification to the cash register 30 is Since it has already been completed (step N5), the manager is notified that the selling price change work for the product stored in any display place 61 has been completed (step N9), and the display change work instruction With reference to the table 49, it is determined whether or not the display change work has been completed for the selling price change work target product (step 10).

  In step N6, when it is determined that the price change operation for the product displayed in every display place 61 is not completed (step N6; NO), it is not necessary to notify the manager and the cash register 30. With reference to the display change work instruction table 49, it is determined whether or not all of the display change work has been completed for the product that is the selling price change work target (step N10).

  In step N10, when it is determined that the display change work has been completed for the product whose sales price is to be changed (step N10; YES), the administrator is notified that the display change work has been completed for the product. (Step N11), the notification process executed in the server 40 ends.

  If it is determined in step N10 that the display change work has not been completed for the product (step N10; NO), all the work related to the selling price change has not been completed, so notification to the manager and the cash register No processing is performed.

  Next, a process for issuing a new price tag 70 will be described with reference to the flowchart of FIG.

  First, when the product code of the sale price change target product is input by the input device 26 of the operator terminal 20 (step P1), the product name 71 is acquired from the product table 46 stored in the DB storage unit 44a of the server 40. Then, the new product selling price 72 is acquired from the selling price change instruction table 48 (step P2).

Next, an unused branch number is obtained from the shelf allocation table 47 stored in the DB storage means 44a of the server 40, and a price tag ID 73 is generated from the combination of the product code and the branch number (step P3).
The product name 71 and the new product selling price 72 of the selling price change target product are acquired by the processing of Step P2 and Step P3, and when the price tag ID 73 is generated, it is printed as one price tag 70 by the printer 50 (Step P4). .

  The price tag ID 73 is a combination of a product code and a branch number, but other configurations may be used as long as the ID is unique. Further, although the price tag ID 73 and the sales floor ID 62 are configured to use IDs as identifiers, the present invention is not limited thereto, and a configuration using a non-contact IC card may be employed.

  As described above, according to the data processing system 100 of the present embodiment, the administrator can grasp that the work has been started reliably by performing the work start and work content instructions, and can monitor the work state. By notifying, it is possible to prevent omissions in sales price change work and to avoid sales mistakes that have occurred due to the presence of unfinished goods.

  In addition, since the price tag changing work accompanying the selling price changing work can be performed in parallel, not only the speed of the work is improved, but also the place where the price tag changing work is completed by attaching an ID to the display place and the price tag. Since the location that has not been completed can be clearly grasped, the price tag change operation can be performed reliably, and the sales price after the change can be reliably reflected in the sales process.

  Furthermore, it is possible to avoid customer complaints due to an error in the selling price attached to the price tag and the selling price displayed on the cash register by shifting the timing of the price change notification to the cash register depending on the product to be raised and the price to be lowered. .

It is a figure which shows the structure of the management system which concerns on this embodiment. It is an example of the price tag issued by the printer. It is an example of the display shelf and display place installed in a sales floor. It is a block diagram which shows the principal part structure of the server which comprises the management system of FIG. It is an example of the table for merchandise management. It is a block diagram which shows the principal part structure of the terminal for managers which comprises the management system of FIG. It is a block diagram which shows the principal part structure of the terminal for workers which comprises the management system of FIG. It is a flowchart which shows the whole process performed in the management system of this embodiment. In this embodiment, it is a flowchart which shows the process performed by the management instruction | indication of an administrator. In this embodiment, it is a flowchart which shows the process performed by a worker's work instruction | indication. It is a flowchart which shows the monitoring process performed during work in this embodiment. In this embodiment, it is a flowchart which shows the notification determination process performed in a server, when the work completion notification is received from the operator. It is a flowchart which shows a new price tag issue process in this embodiment.

Explanation of symbols

10 terminal 20 for managers terminal 30 for workers 30 cash register 40 server 11, 21, 41 CPU
12, 22, 42 RAM
13, 23, 43 ROM
14, 24 CRT
16, 26 Input device 17, 27 Barcode input device 18, 28 Buzzer 15, 25, 45 Communication interface 44 HDD (hard disk)
44a DB (database) storage means 46 commodity table 47 shelf allocation table 48 selling price change instruction table 49 display change instruction table 50 printer 60 display shelf 61 display place 62 sales floor ID
70 Price tag 71 Product name 72 Product price 73 Price tag ID
100 Data processing system

Claims (9)

In the data processing system that executes the product price change work,
Storage means for storing a display place identifier attached to a display place, a price tag identifier associated with each product, a product selling price, and a product code in association with each other;
Work notification means for notifying the start and end of work;
Warning means to monitor and warn work progress;
Change instruction means for instructing change of the product information stored in the storage means;
A price tag creating means for receiving a work end notification and creating a price tag by acquiring the product information stored in the storage means;
Receiving the work end notification, the work progress status determination, and a determination instruction means for giving an instruction according to the determination result,
In the work notification means, the work start notification is executed in accordance with an instruction of an administrator terminal used by an administrator, and the administrator terminal is notified from the worker terminal used by the worker that the work is started. A data processing system characterized by receiving.   2. The data processing system according to claim 1, wherein the warning unit performs a warning notification as long as there is an unfinished product for the manager terminal and the worker terminal.   The data processing system according to claim 1 or 2, wherein the display place identifier stored in the storage unit is attached to each display place and includes product information of a product stored in the display place.   4. The data processing system according to claim 1, wherein the price tag identifier stored in the storage unit includes the product information and display location information associated with each other. 5.   The said change instruction means acquires the said merchandise information by inputting the said merchandise code, and performs the selling price change instruction | indication by designating the selling price after a change with respect to the said merchandise information. 5. The data processing system according to any one of 4.   The change instruction means acquires the product information by inputting the product code, and performs the display location change instruction by designating the display location identifier for the product information. Item 6. The data processing system according to any one of Items 1 to 5.   The data processing system according to any one of claims 1 to 6, wherein the change instruction unit performs the selling price change instruction in parallel with the display place change instruction and the price tag change operation.   8. The determination instruction unit according to any one of claims 1 to 7, wherein the determination instruction means issues a selling price change instruction and a sales start instruction to a cashier and an administrator based on a determination result obtained by a work completion determination and the post-change selling price determination. The data processing system according to one item.   9. The price tag creating unit creates a price tag by acquiring a product name and a changed selling price from among the product information stored in the storage unit, and combining the price tag identifier with the price tag identifier. A data processing system according to claim 1.

Images