JP5457411B2 - Master data update device and program - Google Patents

Description

  Embodiments described herein relate generally to a master data update device and a program.

  In stores such as convenience stores and supermarkets, a store server having a master data file storing product data of products handled in the store as master data, and product sales data processing based on the master data distributed from the store server A POS system including a POS (Point Of Sales) terminal to be executed is provided.

  In general, while new products are introduced one after another in a store, there are many products that are discontinued, and the products to be sold are frequently replaced. Therefore, at each store, it is necessary to update the master data of the store server in correspondence with the product to be sold, and also update the master data of the POS terminal.

  The master data of the POS terminal is updated by update data distributed from the store server to each POS terminal. This update data includes PLU (Price Look Up) data, a product name, a unit price, etc. for each product for a product to be sold in the store.

  By the way, the update data distributed from the store server to each POS terminal may not be distributed to some or all of the POS terminals due to the influence of a power failure or the like.

  When update data is not distributed to some or all of the POS terminals in this way, the operator distributes necessary product masters and parameters to each POS terminal and performs recovery. ing.

  However, conventionally, the operator has to perform a check operation for checking whether or not data has been undelivered for each POS terminal and a recovery operation for a POS terminal to which data has not been distributed, which is troublesome. It has become.

The master data update device according to the embodiment includes an update data distribution unit that distributes update data of the master data to a product sales data processing device that executes product sales data processing using the master data, and the distributed update data. If there is the product sales data processing device that is not updated, a redistribution reservation means for reserving the redistribution of the update data to the product sales data processing device in the reservation table, and the device at the time of activation of the product sales data processing device If there is a sign-on signal input when connecting to the product, and there is a reservation for redistribution of the update data in the reservation table for the product sales data processing apparatus that has output the sign-on signal, the product sales data Update data redistribution means for distributing the update data to a processing device.

The program of the embodiment includes an update data distribution unit that distributes update data of the master data to a product sales data processing apparatus that executes product sales data processing using master data, and the distributed update data. If there is the product sales data processing device that is not updated, a redistribution reservation means for reserving the redistribution of the update data to the product sales data processing device in the reservation table, and the device at the time of activation of the product sales data processing device If there is a sign-on signal input when connecting to the product, and there is a reservation for redistribution of the update data in the reservation table for the product sales data processing apparatus that has output the sign-on signal, the product sales data Update data redistribution means for distributing the update data to a processing device.

FIG. 1 is an overall configuration diagram showing a POS system in the present embodiment. FIG. 2 is a block diagram illustrating a configuration of the store server. FIG. 3 is a functional block diagram showing a functional configuration of the CPU of the store server. FIG. 4 is a schematic diagram illustrating a data configuration of the update result table. FIG. 5 is a schematic diagram showing the data structure of the reservation table. FIG. 6 is a flowchart showing a procedure for updating master data.

  This embodiment will be described with reference to the drawings. FIG. 1 is an overall configuration diagram showing a POS system 100 in the present embodiment. As shown in FIG. 1, the POS system 100 is formed by connecting a store 10 and a headquarter 20 via a line 30. A store server 200 that is a master data updating device is disposed in the store 10, and a plurality of POS terminals 300 are connected to the store server 200 via a LAN (Local Area Network) line 310. Further, the headquarter 20 is provided with a host server 400 that sends update data of master data stored in the master data file 220 (see FIG. 2) to the store server 200 via the line 30.

  FIG. 2 is a block diagram illustrating a hardware configuration of the store server 200. The store server 200 includes a keyboard 213 and a mouse 214 that is a pointing device. In addition, an LCD (Liquid Crystal Display) 212 is provided as a user interface having an information notification function for the user.

  The store server 200 includes a microcomputer 201 that drives and controls each unit. A microcomputer 201 includes a CPU (Central Processing Unit) 202 that centrally controls each unit, a ROM (Read Only Memory) 203 that stores in advance fixed data such as a control program via a bus line 205, and various data. Is rewritable and is connected to a RAM (Random Access Memory) 204 that functions as a work area or the like. Therefore, the microcomputer 201 constitutes an information processing unit that executes information processing.

  A display controller 206, a keyboard controller 207, a pointing device controller 208, an HDD (Hard Disk Drive) 209, a first communication interface 210, and a second communication interface 211 are connected to the microcomputer 201 via a bus line 205. Has been.

  The display controller 206 drives and controls the LCD 212 based on the image data, and causes the LCD 212 to display an image corresponding to the image data. The keyboard controller 207 takes in an input signal from the keyboard 213 into the microcomputer 201. The pointing device controller 208 captures an input signal from the mouse 214 that is a pointing device into the microcomputer 201. The first communication interface 210 enables data communication with another device, that is, the POS terminal 300 via the LAN line 310. The second communication interface 211 is connected to the line 30. That is, data communication with the host server 400 is enabled via the line 30.

  The HDD 209 stores a master data file 220 that stores product data of products handled in the store as master data. The master data file 220 stores, as master data, product data for products to be sold at the store 10, and item data includes PLU (Price (Price) for products to be sold at the store 10) as item data. Lookup) data, product name, unit price, major category, middle category, minor category product data, maintenance date and time, tax classification, etc. are stored. The master data file 220 is updated, for example, at the timing of data transmission to the host server 400 at the time of payment. The HDD 209 also stores various programs 221.

  Store server 200 has installed in HDD 209 a program for realizing a function as a master data update device. When this program is activated, the CPU 202 functions as an update data distribution unit 261, a redistribution reservation unit 262, and an update data redistribution unit 263 as shown in FIG. 3, and controls each unit according to the procedure shown in the flowchart described later.

  The update data distribution unit 261 distributes the update data of the master data to the POS terminal 300 that executes merchandise sales data processing using the master data of the master data file 220.

  When there is a POS terminal 300 whose distributed update data is not updated, the redistribution reservation unit 262 reserves redistribution of update data to the POS terminal 300.

  The update data redistribution unit 263 receives a predetermined signal from the POS terminal 300 (for example, a sign-on signal when connecting to the store server 200 when the POS terminal 300 is activated), and outputs the predetermined signal. When there is a reservation for redistribution of update data for the POS terminal 300, the update data is distributed to the POS terminal 300.

  Further, when the program for realizing the function as the master data update device is activated, the CPU 202 updates the update result table 251 for storing the update result of the update data for the POS terminal 300, and the POS that has failed to update the update data. A reservation table 252 that reserves retransmission of update data for the terminal 300 is formed in the HDD 209.

  FIG. 4 is a schematic diagram illustrating a data configuration of the update result table 251. As shown in FIG. 4, the update result table 251 stores a parameter indicating an update date, a parameter indicating an updated registration number of the POS terminal 300, a parameter indicating a reception / update category, an update result parameter indicating an update result, and the like. . As shown in FIG. 4, in the update result table 251, the update result parameter flag for each POS terminal 300 is set to “0” if normal, and “1” if abnormal.

  FIG. 5 is a schematic diagram showing the data structure of the reservation table 252. As shown in FIG. 5, the reservation table 252 stores a parameter indicating an update date, a parameter indicating a registration number of the POS terminal 300 to be updated, a parameter indicating a reservation acceptance flag, a parameter indicating an execution category, and the like. As shown in FIG. 5, various parameters for the POS terminal 300 whose update result parameter is “1” in the update result table 251 are registered in the reservation table 252.

  In the POS system 100 in the present embodiment, the master data file 220 for the POS terminal 300 is updated by the following procedure. FIG. 6 is a flowchart showing a procedure for updating master data for the POS terminal 300.

  If the CPU 202 of the store server 200 determines that the predetermined timing has been reached (Yes in step S1), it receives the update data from the host server 400 and temporarily stores it in the RAM 204 or the like (step S2). Then, the master data file 220 is updated (step S3). The timing of receiving update data from the host server 400 is, for example, the timing of data transmission to the host server 400 at the time of payment.

  Next, the CPU 202 (update data distribution means 261) of the store server 200 distributes the update data received from the host server 400 to each POS terminal 300 (step S4).

  After distributing update data to the POS terminal 300, the CPU 202 of the store server 200 waits for acquisition of a data update result from the POS terminal 300 (step S5).

  When the acquired data update result is OK (Yes in step S6), the CPU 202 of the store server 200 determines that the update result is normal, and flags the update result parameter for the POS terminal 300 in the update result table 251. Is set to “0” (step S7).

  On the other hand, if the acquired data update result is NG or no response (No in step S6), the CPU 202 of the store server 200 determines that the update result is abnormal and stores the update result table 251 for the POS terminal 300. The flag of the update result parameter is set to “1” (step S8).

  The CPU 202 of the store server 200 repeats the processing from step S5 to step S8 until it is determined that the update confirmation has been completed for all the POS terminals 300 (Yes in step S9).

  If the CPU 202 of the store server 200 determines that the update confirmation has been completed for all the POS terminals 300 (Yes in step S9), is there any update result parameter flag set to “1” in the update result table 251? It is determined whether or not (step S10).

  The CPU 202 (redistribution reservation means 262) of the store server 200 determines that the update result parameter flag is “1” in the update result table 251 (Yes in step S10), the update result table 251 The POS terminal 300 whose update result parameter flag is “1” is registered in the reservation table 252 (step S11).

  Further, when the CPU 202 of the store server 200 receives a sign-on signal (employee number or the like) at the time of connection to the store server 200 at the time of activation from each POS terminal 300 (Yes in step S12), new data is stored in the reservation table 252. It is determined whether or not there is (step S13). The CPU 202 of the store server 200 determines that there is new data in the reservation table 252 when the reservation acceptance parameter flag of the new data registered in the reservation table 252 is “0”.

  If the CPU 202 (update data redistribution means 263) of the store server 200 determines that there is new data in the reservation table 252 (Yes in step S13), the flag of the reservation acceptance parameter for new data registered in the reservation table 252 is displayed. The data is updated to “1” (step S14), and the update data received from the host server 400 is distributed to the POS terminal 300 registered in the reservation table 252 (step S15), and the data update result from the POS terminal 300 is updated. (Step S16).

  If the acquired data update result is OK (Yes in step S17), the CPU 202 of the store server 200 determines that the update result is normal, and flags the update result parameter for the POS terminal 300 in the update result table 251. Is updated to "0" (step S18).

  On the other hand, if the acquired data update result is NG or no response (No in step S17), the CPU 202 of the store server 200 determines that the update result is abnormal as in the previous time, and the POS terminal in the update result table 251 The update result parameter flag for 300 is kept “1”.

  The CPU 202 of the store server 200 repeats the processing from step S16 to step S18 until it is determined that the update confirmation has been completed for all the POS terminals 300 registered in the reservation table 252 (Yes in step S19).

  When the CPU 202 of the store server 200 determines that redistribution of all new data registered in the reservation table 252 has been completed (Yes in step S19), the flag of the update result parameter in the update result table 251 is “1”. It is determined whether or not there is any item (step S10).

  When there is an update result parameter flag that is “1” in the update result table 251 (Yes in step S10), the CPU 202 of the store server 200 sets the update result parameter flag in the update result table 251 to “ The POS terminal 300 that is 1 ″ is registered in the reservation table 252 (step S11).

  As described above, according to the store server 200 that is the master data update device of the present embodiment, the update data of the master data is distributed to the POS terminal 300 that executes the merchandise sales data processing using the master data. If there is a POS terminal 300 in which the updated data is not updated, re-distribution of update data to the POS terminal 300 is reserved, and a predetermined signal from the POS terminal 300 (for example, to the store server 200 when the POS terminal 300 is activated) When there is an input of a sign-on signal at the time of connection and there is a reservation for redistribution of update data for the POS terminal 300 that has output the predetermined signal, the update data is distributed to the POS terminal 300. Accordingly, when the update data distributed from the store server 200 to each POS terminal 300 is not distributed to some or all of the POS terminals 300 due to the influence of a power failure or the like, no special operation is performed. In addition, recovery by automatic delivery from the store server 200 can be performed. Further, by using a sign-on signal when connecting to the store server 200 when the POS terminal 300 is activated, recovery that does not depend on the operator can be performed even before opening the store.

  A program executed by the store server 200 which is the master data updating apparatus of the present embodiment is a file in an installable format or an executable format, and is a CD-ROM, flexible disk (FD), CD-R, DVD (Digital Versatile). The program is recorded on a computer-readable recording medium such as a disk.

  Further, the program executed by the store server 200 which is the master data updating device of the present embodiment is stored on a computer connected to a network such as the Internet and provided by being downloaded via the network. Also good. Moreover, you may comprise so that the program run with the shop server 200 which is a master data update apparatus of this embodiment may be provided or distributed via networks, such as the internet.

  Further, the program of this embodiment may be configured to be provided by being incorporated in advance in a ROM or the like.

  The program executed by the store server 200, which is the master data update device of the present embodiment, has a module configuration including the above-described units (update data distribution unit 261, redistribution reservation unit 262, update data redistribution unit 263). As the actual hardware, the CPU (processor) reads the program from the storage medium and executes it to load the above-described units onto the main storage device. The update data distribution unit 261, the re-distribution reservation unit 262, and the update Data redistribution means 263 is generated on the main storage device.

  Although several embodiments of the present invention have been described, these embodiments are presented by way of example and are not intended to limit the scope of the invention. These novel embodiments can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the scope of the invention. These embodiments and modifications thereof are included in the scope and gist of the invention, and are included in the invention described in the claims and the equivalents thereof.

200 Master Data Update Device 201 Computer 261 Update Data Distribution Unit 262 Redistribution Reservation Unit 263 Update Data Redistribution Unit

JP 2000-76550 A

Claims (4)

Update data distribution means for distributing update data of the master data to a merchandise sales data processing apparatus that executes merchandise sales data processing using the master data;
Redistribution reservation means for reserving redistribution of the update data to the product sales data processing device in the reservation table when there is the product sales data processing device in which the distributed update data is not updated;
The merchandise sales data processing apparatus has an input sign-on signal when the connection to the device at the time of startup, reservation of redelivery of the update data about the merchandise sales data processing apparatus outputs the sign-on signal is the An update data redistribution unit that distributes the update data to the product sales data processing device when it is in the reservation table ;
A master data update device. When there is the product sales data processing device in which the update data distributed by the update data redistribution unit is not updated, the redistribution reservation unit re-distributes the update data to the product sales data processing device in the reservation table. Book again,
The master data update device according to claim 1. On the computer,
Update data distribution means for distributing update data of the master data to a merchandise sales data processing apparatus that executes merchandise sales data processing using the master data;
Redistribution reservation means for reserving redistribution of the update data to the product sales data processing device in the reservation table when there is the product sales data processing device in which the distributed update data is not updated;
The merchandise sales data processing apparatus has an input sign-on signal when the connection to the device at the time of startup, reservation of redelivery of the update data about the merchandise sales data processing apparatus outputs the sign-on signal is the An update data redistribution unit that distributes the update data to the product sales data processing device when it is in the reservation table ;
A program that executes When there is the product sales data processing device in which the update data distributed by the update data redistribution unit is not updated, the redistribution reservation unit re-distributes the update data to the product sales data processing device in the reservation table. Book again,
The program according to claim 3 .

Images