JP3848461B2 - Store management system - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a communication network using a dedicated line or a public line for a store management apparatus installed in each chain-expanded store such as a supermarket and a convenience store, and a headquarter management apparatus installed in a headquarter that controls each store. It relates to a store management system connected to.
[0002]
[Prior art]
Generally, in retail stores such as supermarkets and convenience stores that are chained in various locations, a headquarters management device consisting of a host computer is installed at the headquarters that controls each chain store, and a store management device consisting of a store computer for each chain store. The head office management device and each store management device are connected to a communication network using a dedicated line or a public line. The head office management device is equipped with a single product information master file that stores single product information such as single product codes, product names, and unit prices of various products that are commonly sold at each store, while each store management device is sold at that store. A single product information local file that stores single product information for each product is installed, and correction (addition, deletion, or change) of single product information stored in the single product information local file of each store management device is performed remotely from the head office management device. A store management system was constructed.
[0003]
Therefore, in a retail store that has built this kind of store management system, when a new chain store is opened, a store management device that does not have a single product local file is installed in the non-operating store to establish a communication network. Connecting. Then, by accessing the headquarters management device via this communication network and receiving the download of the single item information stored in the single item information master file, the single item information local file is created in the store management device of the non-operating store.
[0004]
By the way, there is a region-limited product that is sold only in a certain region, and this region-limited product is not managed by the headquarters. For this reason, every time a limited-area product is sold, each chain store in operation operates a personal computer or the like to add the single item information of the limited-region product to the single item information local file of the store management device. In addition, in non-operating stores that are newly opened, pick up all regional limited products that are not registered in the single item information master file of the headquarters management device among the products to be sold, and the single item information of these regional limited items is the same as above In addition, it was added to the single item information local file of the store management device to prepare for the opening of the store.
[0005]
[Problems to be solved by the invention]
As described above, in the retail store where the product management system as described above is constructed, when creating a single product information local file in the store management device of a non-operating store to be newly opened, the single product information master file downloaded from the headquarters It was necessary for the store to add single item information of products such as limited products that are not managed by the headquarters to the single item information. Therefore, troublesome and time-consuming work such as picking up products that are not managed by the headquarters or inputting single item information of this product is required during the preparation period before opening the store. It was easy to make mistakes.
[0006]
The present invention has been made based on such circumstances, and its purpose is to simplify the work necessary to create a single product information local file in a store management device of a non-operating store to be newly opened. The store management system which can prevent mistakes, such as omission of a product pick-up and an incorrect input, is aimed at.
[0007]
[Means for Solving the Problems]
The invention according to claim 1 of the present application is a headquarters management apparatus having a single product information master file that stores single product information such as single product codes and unit prices of various products that are installed in the headquarters that govern each store and are commonly sold in each store. In a store management system in which each store is connected to a plurality of store management devices capable of mounting a single item information local file storing individual item information of various products that are installed in each store and sold in that store. Store-specific single product information that is not stored in the single-item information master file among the single-item information of various products stored in the single-item information local file that the self-item information local file has in the store management device that has the single-item information local file installed in the management device Store-specific single item information extraction means to be extracted, and store-specific single item information extracted from the single item information local file by this extraction means Stores that are equipped with single-item information and a single-item information local file that are downloaded from the headquarters management device via a communication line to a store management device that is not equipped with a single-item information local file. A single product information local file creating means for creating and storing its own single product information local file with the store-specific single product information output from the management device is provided.
The invention according to claim 2 of the present invention is the invention according to claim 1, wherein the store-specific single item information extracting means is corrected by a command from the headquarters management device for each single item information of various products stored in the single item information local file. The means for identifying whether or not the information is single item information and the means for extracting the single item information other than the single item information corrected by the command from the head office management device as the single item information unique to the store.
The invention described in claim 3 of the present application is the store management apparatus in which the single item information local file is already installed in the invention described in claim 1, and the operation of the store is started for each item for which the single item information is stored in the single item information local file. A date storage unit that stores a date with an initial date, and a correction date each time the single item information of the corresponding product is corrected or the corresponding product is sold. Alternatively, there is provided date update means for updating to the sales date, and single product information deletion means for deleting single product information of products whose elapsed time from the date stored by the date storage means has passed a preset period from the single product information local file. Is.
The invention described in claim 4 of the present application is the store management apparatus in which the single item information local file is not installed in the invention described in claim 1, and the store management device in which the single item information local file is already installed. A means for requesting single item information is provided, and the store management apparatus that has already received the single item information local file that has received this request causes the store-specific single item information extraction means and the store-specific single item information output means to function. .
The invention according to claim 5 of the present invention is the invention according to claim 1, wherein the store management apparatus having the single item information local file is provided with a medium recording means for recording information on a portable recording medium, When the information output means transmits and outputs the store-specific single product information extracted from the single product information local file by the store-specific single product information extraction means to the store management device not equipped with the single product information local file via a communication line, and a transmission error occurs. The single item information unique to the store is written into a portable recording medium by the medium recording means.
The invention according to claim 6 of the present application is the invention according to claim 1, wherein the headquarters management device is provided with an area code for identifying a store opening area for each store and a form code for identifying a product form of the store. When the set store information file and the region code and form code of the store to be newly opened are input, the store information file is searched for an operating store in which the same area code and form code as the input code are set. An operating store search means is provided. Then, the single item information local file creation means included in the store management device that is not equipped with the single item information local file is the single item information downloaded from the headquarters management device via the communication line and the active store detected by the active store search means. It is a means for creating and storing its own single product information local file with the store-specific single product information output from the store management device.
The invention according to claim 7 of the present application is the regional information file in which the regional code of the area adjacent to the store opening area is stored in the head office management device according to the area code for identifying the store opening area of each store. When the store information file is searched by the operating store search means, the region information file is searched when the operating store having the same area code and form code as the area code and form code of the new store opening cannot be detected. Store information file for the adjacent area code acquisition means for acquiring the adjacent area code corresponding to the area code of the new store opening, and the operating store in which the adjacent area code acquired by this code acquisition means and the form code of the new store opening are set And an adjacent operation store search means for searching from the above.
[0008]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
First, a first embodiment corresponding to each invention of claims 1 to 5 of the present application will be described with reference to FIGS.
In the first embodiment, as shown in FIG. 2, a plurality of chain stores a1,..., An belonging to the first region A and a plurality of chain stores b1,. , Bn will be described in the case where the present invention is applied to a store management system constructed in a retail store that controls the headquarters C.
[0009]
Such a store management system has a headquarters management apparatus 1 composed of a host computer or the like installed in the headquarters C, and a store management apparatus 2 composed of a store computer or the like installed in each chain store a1 to an, b1 to bn. The apparatus 1 and each store management apparatus 2 are constructed by commonly connecting to a WAN (Wide Area Network) 3 which is a dedicated wide area communication network.
[0010]
In such a store management system, the head office management device 1 is equipped with a single product information master file 4 that stores single product information such as single product codes, product names, and unit prices of various products that are commonly sold in each store.
On the other hand, each store management device 2 connects a plurality of POS (Point Of Sales) terminals 5 installed in each store via a LAN (Local Area Network) 6 which is a narrow area communication network. In addition, a single product information local file 7 for storing single product information of various products sold in the store is installed. Based on the single item information of the various products stored in the single item information local file 7, the single item registration of the sales item is performed at each POS terminal 5.
In addition, each store management device 2 can operate the personal computer 8 connected to the LAN 6 to correct (file maintenance) such as addition, deletion, and change of single item information to the single item information local file 7. .
[0011]
FIG. 3 is a block diagram showing a main part of hardware constituting the store management apparatus 2. That is, the store management apparatus 2 temporarily stores a CPU (Central Processing Unit) 21 that constitutes a control unit main body, a ROM (Read Only Memoly) 22 that stores fixed data such as programs, received data, arithmetic processing data, and the like. A RAM (Random Access Memoly) 23 that forms a memory area for storing, a clock unit 24 that measures the current date and time, and a file storage unit 25a such as a hard disk that stores various data files such as a single product information local file 5 A file control unit 25 for writing and reading data, a WAN control unit 26 for controlling data communication performed via the WAN 3, a LAN control unit 27 for controlling data communication performed via the LAN 6, and an external attachment / detachment Write data to a floppy disk, which is a portable recording medium that can be inserted freely. FDD as a medium recording means for fine reading and a like (Floppy Disk Drive) device 28. The CPU 21, ROM 22, RAM 23, clock unit 24, file control unit 25, WAN control unit 26, LAN control unit 27, and FDD device 28 are connected by a bus line 29 such as an address bus and a data bus. Various functions as the store management device 2 are realized by controlling each unit by the CPU 21.
[0012]
Here, the main functional configurations related to the present invention of the store management device 2 and the headquarter management device 1 will be described with reference to the functional block diagram shown in FIG. 1 and the flowcharts shown in FIGS. In FIG. 1, reference numeral 2X indicates a store management device of the operating store a1 in which the single item information local file 5 is already installed, and reference numeral 2Y indicates that the single item information local file is not mounted in the same area A as the operating store a1. The store management apparatus of the operation store an is shown.
As shown in the figure, the head office management device 1 corrects (adds, deletes, changes) the single item information stored in the single item information master file 4 and also stores the single item information local file for the store management device 2X of the operating store a1. 7 includes file correction requesting means 11 for requesting correction of the same single item information stored in 7.
[0013]
On the other hand, the store management device 2X of the operation store a1 among the store management devices 2 has, as its specific functions, file correction means 91, single item sales update means 92, surplus record deletion means 93, store-specific single item information extraction means 94, and store-specific information. Single item information output means 96 is provided.
In addition, the store management device 2Y of the non-operating store an among the store management devices 2 has a store-specific single item information request unit 97 and a single item information local file creation unit 98 as specific functions.
[0014]
The file correction means 91 is stored in the single product information local file 7 based on the correction request data provided via the WAN 3 by the file correction request means 11 of the head office management apparatus 1 or the correction request data provided from the personal computer 8 via the LAN 6. This is a means for correcting (adding, deleting, changing) the stored single item information, and is activated when correction request data is received via the WAN control unit 26 or the LAN control unit 28.
That is, as shown in FIG. 5, when the correction request data is received, the CPU 21 first corrects the single item information stored in the single item information local file 7 based on the correction request data. For example, if the correction request data is data requesting addition of single product information of a new product, a record including single product information such as a single product code, a single product name, and a unit price of the new product is added to the single product information local file 7. Further, if the correction request data is data requesting the change of the unit price of the selling item, the unit price of the single item information record corresponding to the selling item on the single item information local file 7 is changed to the selling price. Further, if the correction request data is data requesting deletion of single item information of the sales canceled product, the single item information record of the sales canceled product is deleted from the single item information local file 7.
[0015]
Here, the single item information record stored in the single item information local file 7 is, as shown in FIG. 4, the single item information obtained by correcting the single item information such as the single item code, the single item name, and the unit price by a command from the head office management device 1. Management classification data d1 for identifying whether the information is a single item information that has been corrected by a command from the personal computer 8 connected to the LAN, correction date data d2 that is the latest date of correction, LAN The sales generation date data d3 which is the latest date registered for sale in the connected POS terminal 5 is added.
[0016]
Therefore, after correcting the single item information record, the CPU 11 determines whether the correction request source is the head office management device 1 or the personal computer 8 connected via the LAN when the correction content is addition or change. In the case of the head office management apparatus 1, the management classification data d1 of the corrected single item information record is set to data = 1 indicating [head office], and in the case of the personal computer 8, the management classification data d1 is set to data indicating [store] = 0. And The initial data of the management classification data d1 is “0”. Thereafter, the correction date data d2 of the corrected single item information record is updated to the current date read from the clock unit 24. The initial data of the correction date data d2 is the operation start date of the store a1, that is, the so-called opening date.
[0017]
The single item sales update unit 92 is a unit for collecting and managing the sales data of each product registered for sale at each POS terminal 5, and the single item code and the number of items for sale registered at the POS terminal 5 connected via LAN. , It is activated when single-unit sales data including sales amount is received via the LAN control unit 28.
That is, as shown in FIG. 6, when receiving the single item sales data, the CPU 21 first registers and registers the single item sales data in a sales totaling file (not shown). Next, the single product information file 7 is searched with the single product code in the single product sales data, the single product information record of the same single product code is detected, and the sales occurrence date data of this single product information record is updated to the current date read from the clock unit 24. To do. The initial data of the sales occurrence date data d2 is the operation start date of the store a1, that is, the so-called opening date.
[0018]
The surplus record deleting unit 93 is a unit that deletes a single item information record of a product that has not been handled for a certain period of time from the single item information local file 7 and is activated when the date counted by the clock unit 24 is updated.
That is, as shown in FIG. 7, when detecting that the date has been updated, the CPU 21 first initializes the record read counter n to “0”. Next, when the counter n is incremented by 1, the n-th single product information record is read from the single product information local file 7. Then, the elapsed days D1 and D2 from the correction date data d2 and the sales occurrence date data d3 of the single product information record to the current date counted by the clock unit 24 are calculated, respectively. It is determined whether a set number of days H (for example, H = 30 days) has elapsed. When both the elapsed days D1 and D2 have exceeded the set number of days H, the n-th single item information record is deleted from the single item information local file 7. On the other hand, when at least one of the elapsed days has not reached the set number of days H, the n-th single item information record is not deleted.
[0019]
Next, when the record reading counter n is incremented by 1 again and the n-th single item information record is read from the single item information local file 7, the same processing as described above is performed.
Thus, each time the single product information record is read sequentially from the single product information local file 7, the number of days that have elapsed from the modification date data d2 and the sales generation date data d3 of the single product information record to the current date counted by the clock unit 24. D1 and D2 are calculated, and the process of deleting the single item information record from the single item information local file 7 is repeated only when both the elapsed days D1 and D2 have exceeded the set number of days H. When the above processing is completed for all the records in the single product information local file 7, the single product information records remaining in the single product information local file 7 are rearranged in the ascending order of the single product codes, for example.
[0020]
The store-specific single item information extracting unit 94 extracts unit-specific single item information that is not stored in the single item information master file 4 of the headquarters management device 1 from the single item information of various products stored in the single item information local file 7. It is activated when a request command for store-specific single item information is received from the store management device 2Y of the non-operating store an in the same area A via the WAN control unit 26.
That is, as shown in FIG. 8, when receiving a request command for store-specific single item information, the CPU 21 confirms that the request command is from a non-operating store an in the same area A, and then the store-specific single item information request source. The communication address on the WAN 3 assigned to the store management apparatus 2Y is temporarily stored in the RAM 23. Also, the record read counter n is initialized to “0”. Next, when the counter n is incremented by 1, the n-th single product information record is read from the single product information local file 7. Then, it is determined whether the management classification data d1 of this single item information record is “0” or “1”. If it is “0”, the single item information of this single item information record is extracted as it is single item information unique to the store which is not stored in the single item information master file 4 of the head office, and is stored in the RAM 23. On the other hand, when the management classification data d1 is “1”, it is not extracted because it is single-item information common to each store stored in the single-item information master file 4.
[0021]
Next, when the record reading counter n is incremented by 1 again and the n-th single item information record is read from the single item information local file 7, the same processing as described above is performed.
In this way, each time the single item information record is read sequentially from the single item information local file 7, the management classification data d1 of the single item information record is checked, and if the data “0” indicating [store], the single item information of the single item information record is obtained. Extracted and stored in the RAM 23. When the above processing is completed for all the records in the single item information local file 7, a store-specific single item information file 95 is created from all the single item information extracted in the RAM 23. When the store-specific single product information file 95 is stored in the file storage unit 25a, the store-specific single product information output means 96 is activated.
Note that when a request command for store-specific single item information is received from a store management device of an unoperated store in another area B, only an error response is performed under the control of the WAN control unit 26.
[0022]
The store-specific single item information output unit 96 is a unit that outputs the store-specific single item information extracted from the single-item information local file 7 by the store-specific single item information extraction unit 94, and an activation command generated by the execution of the store-specific single item information extraction unit 94 It starts by.
That is, as shown in FIG. 9, when the CPU 21 receives an activation command, it first initializes a retry counter r to “0”. Next, the communication address on the WAN 3 assigned to the store management device 2Y of the store-specific single item information request source stored in the RAM 23 in the store-specific single item information extracting means 94 is read, and the WAN control unit 26 is controlled to perform this communication. The store management device 2Y designated by the address is called. When the line with the store management device 2Y is connected, the store-specific single item information extraction unit 94 transmits the store-specific single item information file 95 stored in the file storage unit 25a. If the store-specific single product information file 95 can be normally transmitted to the line-connected store management device 2Y, the store-specific single product information file 95 is deleted from the file storage unit 25a.
[0023]
If the line is not connected even if the store management device 2Y that is the store-specific single product information request source is called or an error occurs during the transmission of the store-specific single product information file 95, the retry counter r is set to the specified value R. Retry until it reaches. When the retry counter r reaches the specified value R, after confirming that a floppy disk is inserted in the FDD device 27, store-specific single product information file 95 stored in the file storage unit 25a is stored in the floppy disk. Record. Thereafter, the store-specific single product information file 95 is deleted from the file storage unit 25a.
[0024]
The store-specific single item information requesting means 97 is a means for transmitting a request command for store-specific single item information to the store management device 2X of the operating store a1 connected by the WAN 3, and the single item information master file 4 from the headquarter management device 1 After the download of the various single item information stored and managed is completed, the store-specific single item information requesting means 97 together with the communication address on the WAN 3 assigned to the store management device 2X of the operation store a1 from the personal computer 8 connected via the LAN. When a start command is input via the LAN control unit 28, it starts.
That is, as shown in FIG. 10, when the start command of the store-specific single item information requesting means 97 is input, the CPU 21 downloads various single item information stored and managed in the single item information master file 4 from the head office management device 1. After confirming completion, the retry counter r is initialized to “0”. Next, the WAN control unit 26 is controlled to call the store management device 2X designated by the communication address on the WAN 3 input from the personal computer 8. When the line with the store management apparatus 2X is connected, a predetermined store-specific single item information request command is transmitted. Thereafter, the single product information local file creation means 98 is activated.
If the line is not connected even if the store management apparatus 2X is called, the retry is performed until the retry counter r reaches the specified value R.
[0025]
The single item information local file creation unit 98 is a unit that newly creates the single item information local file 7 ′ in the file storage unit 25 a, and is activated by an activation command generated by the execution of the store-specific single item information request unit 97.
That is, as shown in FIG. 11, when receiving the activation command, the CPU 21 waits for the store-specific single item information file 95 to be sent from the store management device 2X of the operating store a1 that is the request destination of the store-specific single item information. . When the store-specific single item information file 95 is received via the WAN control unit 26 within a predetermined time, the single item of the store-specific single item information file 95 is added to the various single item information of the product information master file 4 downloaded from the head office management device 1. A single product information local file 7 'is created by adding information.
[0026]
In this case, if there is single product information in which the single product code overlaps with the single product information of the product information master file 4 downloaded from the head office management device 1 in the store-specific single product information file 95, one of the single product information is selected. To do. As this selection method, there are a method of automatically selecting single item information of a file on the preset side, single item information of the product information master file 4 and single item information of the same single item code of the store-specific single item information file 95. A method of outputting to the personal computer 8 and allowing the operator to select it is conceivable.
If the single product information local file 7 ′ is created in this way, it is stored in the file storage unit 25.
[0027]
The single item information local file creation means 98 can also be activated by inputting a start command from the personal computer 8 connected via the LAN. In this case, the single item information local file is obtained by adding the single item information of the store-specific single item information file 95 read from the floppy disk by the FDD device 28 to the various single item information of the item information master file 4 downloaded from the head office management device 1. 7 'can be created.
[0028]
As described above, in the store management system according to the first embodiment, the store management apparatus 2Y that is installed in a non-operating store that opens a new store and does not have a single product information local file installed therein, The single item information local file creation means 98 operates. Thereby, the request | requirement of store specific single item information is performed with respect to the store management apparatus 2X of the store in the same area which is already operate | moving. Then, when the store-specific single item information is taken in from the store management device 2X of the operating store, the store-specific single item information is added to the various single item information of the single item information master file 4 received from the head office management device 1 via the WAN 3. The single product information local file 7 'is automatically created. At this time, the correction date data d2 and the sales generation date data d3 added to the various single item information in the single item information local file 7 ′ become the opening date of the same store.
[0029]
On the other hand, in the store management apparatus 2X installed in a store that is already in operation and equipped with the single item information local file 7, the file correction unit 91, the single item sales update unit 92, and the surplus record deletion unit 93 operate. As a result, the single item information in the single item information local file 7 is corrected by a command from the headquarters management device 1 for products managed by the headquarters, and the personal computer 8 in the store for regional limited products that are not managed by the headquarters. It is corrected by the command from At this time, the single item information that has been corrected stores management classification data d1 that identifies whether the correction has been made by a command from the head office management device 1 or a command from the personal computer 8. The latest date data d2 that has been corrected is also stored.
In addition, among the single item information of the single item information local file 7, the latest date data d2 at which the sale occurred is stored in the single item information of the item registered for sale by the POS terminal 5 in the same store.
[0030]
Thus, of the single product information stored and managed in the single product information local file 7, the single product information in which the elapsed days D1 and D2 from the correction date data d2 and the sales generation date data d3 both exceed the set number of days H is the same. It is regarded as a product that is not handled at the store, and is automatically deleted from the single product information local file 7.
[0031]
Further, in the store management device 2X of the operating store, when a request command for store-specific single item information is received from the store management device 2Y of the non-operating store in the same region, the store-specific single item information extraction unit 94 and the store-specific single item information output unit 96 is activated. As a result, from the single item information stored and managed in the single item information local file 7, single item information whose management classification data d1 is not [Headquarters], that is, single item information such as regional limited products not managed by the headquarters is extracted. , Stored in the store-specific single product information file 95, and transmitted to the store management device 2Y of the non-operating store that is the request source. As a result, as described above, the store management device 2Y of the non-operating store automatically creates the single product information local file 7 ′ including the store-specific single product information.
[0032]
As described above, according to this embodiment, when opening a new store, it is troublesome and time-consuming, such as an operation of picking up a region-limited product that is not managed by the headquarters or an operation of inputting single item information of this product. Since the single item information local file 7 'including the store-specific single item information such as the region-limited product can be created in the store management device 2 of the newly opened store without performing the work, the labor required for preparation until opening the store is greatly increased. This can reduce the opening preparation period and work load reduction for the person in charge of opening the shop.
[0033]
When opening a new store, the person in charge of opening a store first connects the store management device 2Y of the non-operating store that does not have the single item information local file to the WAN 3. Next, the central management apparatus 1 is requested to download the file data of the single product information master file 4 via the WAN 3. Thus, when the download of the single item information master file 4 is completed, a request to transmit store-specific single item information is made to the store management device 2X of the operating store in which the single item information local file 7 is already installed via the WAN 3. By performing the above operations, the single item information local file 7 ′ is created in the store management device 2Y of the non-operating store. Therefore, the person in charge of opening the store only needs to work in the non-operating store, and it is not necessary to go to the operating store and acquire the store-specific product information, which is efficient.
[0034]
Further, the communication between the store management device 2Y of the non-operating store not equipped with the single product information local file and the store management device 2X of the active store equipped with the single product information local file 7 causes a failure and the store-specific product information file. Even if a situation occurs in which 95 cannot be transmitted and output to the store management device 2Y of the non-operating store, the store-specific product information file 95 is written on the floppy disk in the store management device 2X of the active store. On the other hand, the store management device 2Y of the non-operating store can create a single product information local file 7 'using the store-specific product information file 95 recorded on the floppy disk. Therefore, even if a communication failure as described above occurs, the creation of the single item information local file 7 ′ will not be hindered.
[0035]
In addition, among the single item information stored in the single item information local file 7, the single item information without sales and correction for a certain period is automatically deleted as single item information of a product that is not handled. Accordingly, after a certain period of time has elapsed since the opening of the store, the single item information of products that are not handled is automatically deleted from the single item information local file 7, so the single item information that is not handled is deleted when the single item information local file 7 'is created. Thus, the store management apparatus 2 equipped with the efficient single item information local file 7 storing only the necessary single item information can be obtained without performing the operation.
[0036]
By the way, in the first embodiment, if the store opening preparation person newly selects a suitable one store a1 from the operating stores in the same area in the non-operating store an newly opened, the personal computer 8 To input the communication address on the WAN 3 assigned to the store management device 2X of the operating store a1. By doing so, the store-specific single item information requesting means 97 functions in the store management device 2Y of the non-operating store an, and accordingly the store-specific single item information extracting unit 94 and the store-specific single item information are stored in the store management device 2X of the active store a1. The output means 96 functions to transmit the store-specific single item information file 95 to the store management device 2Y of the non-operating store an, and the single item information local file 7 ′ is created in the store management device 2Y of the non-operating store an. Therefore, the person in charge of opening a store is required to select one store a1 having a similar product form from the operating stores in the same region in the non-operating store an that opens a new store.
Then, next, the second embodiment corresponding to the inventions of claims 6 and 7 of the present application in which the operation of selecting an appropriate one of the operating stores is simplified will be described with reference to FIGS. To do. As in the first embodiment, the second embodiment also applies the present invention to the store management system shown in FIG. 2 (however, the area is not limited to two areas A and B). The same parts are denoted by the same reference numerals and the description thereof is omitted.
[0037]
FIG. 12 is a block diagram showing main functional configurations of the store management device 2 and the headquarter management device 1 in the second embodiment. As can be seen from the figure, the second embodiment is different from the first embodiment in that the head office management device 1 is provided with a store information file 12, a regional information file 13, and a nearby store selection means 14. And a part of the store-specific single product information requesting means 97 ′ possessed by the store management device 2Y of the non-operating store an and the store-specific single product information extracting means 94 ′ possessed by the store management device 2X of the active store a1. This is a correction.
[0038]
As shown in FIG. 13, the store information file 12 corresponds to the unique store codes assigned to the chain stores a1 to an, b1 to bn,. It is a file in which a region code for identifying a region where a store is open, a form code for identifying a product form of the store, a communication address on the WAN 3, and an operation start date (opening date) are set.
As shown in FIG. 14, the area information file 13 includes the number of areas adjacent to the present area and the adjacent areas together with the area names for each area code for classifying the store opening areas of the chain stores a1 to an and b1 to bn. It is a file with each code set.
[0039]
The adjacent store selecting means 14 is a means for automatically selecting an operating store close to a non-operating store an newly opened, and a message format shown in FIG. 15A from the store management device 2Y of the non-operating store an. It starts when it receives a nearby store search request message. That is, as shown in FIG. 16, the control unit (CPU) of the headquarters management device 1 first receives a nearby store search request message, and first acquires a store code of a newly opened store included in the message. Next, the store information file 12 is searched using the store code as a search key, and it is determined whether or not store information such as a region code and a form code is set corresponding to the corresponding store code. If set, the setting information is read, and the area code and the form code are temporarily stored in the storage unit (RAM).
[0040]
Next, the store information file 12 is searched again using the stored area code and form code as a search key, and the presence / absence of an operating shop in which the area code and form code are the same and the operation start date has already passed is determined. Determine (operating store search means).
[0041]
Here, when there is only one corresponding operating store, that operating store is determined as a nearby store, and the communication address corresponding to the store code of the operating store is read from the store information file 12. And as shown in FIG.15 (b), the proximity store information response message containing the store code and communication address of the operation store is produced, and the store management of the newly opened store which is the proximity store search request message transmission source Send to device 2Y.
Further, when there are a plurality of operating stores having the same area code and the same form code and the operation start date has already passed, one store is selected as the neighboring store from the plurality of operating stores. As a selection means in this case, for example, a means for automatically selecting an operation store having the longest elapsed time from the operation start date as an adjacent store can be considered. Further, the detailed information of the plurality of operating stores may be displayed on the display of the headquarters management apparatus 1, and the person in charge at the headquarters may manually select any one store as a nearby store. In this way, when one of the operating stores is selected as the adjacent store, the adjacent store information response message including the store code and the communication address of the operating store is created as described above, and the adjacent store search request message is transmitted. It transmits to the store management apparatus 2Y of the new store opening which is a sentence transmission source.
[0042]
On the other hand, if there is no working store where the region code and the form code are the same and the operation start date has already passed, the region information table 13 is searched using the region code stored in the storage unit. The adjacent area number Q and each adjacent area code corresponding to the area code are read out and stored in the storage unit (adjacent area code acquisition means). Next, when the counter q is initialized to “1”, the head (q = 1) adjacent area code is selected from the adjacent area codes stored in the storage unit. Then, the store information file 12 is searched again using the selected adjacent area code and the form code previously stored in the storage unit as a search key, and the operation start date has already passed since the adjacent area code and the form code are the same. The presence / absence of an operating store is determined (adjacent operating store search means).
[0043]
Here, when there is only one corresponding operating store, that operating store is determined as a nearby store, and a nearby store information response message including the store code and communication address of the operating store is determined in the same manner as described above. It creates and transmits to the store management apparatus 2Y of the newly opened store which is a proximity store search request message transmission source.
In addition, when there are a plurality of operating stores where the adjacent area code and the form code are the same and the operation start date has already passed, one of the plurality of operating stores is set as a nearby store in the same manner as described above. If selected, a proximity store information response message including the store code and communication address of the operating store is created and transmitted to the store management device 2Y of the newly opened store that is the proximity store search request message transmission source. .
[0044]
On the other hand, when there is no operating store where the adjacent area code and the form code are the same and the operating start date has already passed, the counter a is incremented by +1. If it is confirmed that the counter q = 2 does not exceed the number Q of adjacent areas, the second adjacent area code is selected from the adjacent area codes stored in the storage unit. Thereafter, the store information file 12 is searched in the same manner as described above, and it is determined whether there is an operating store in which the selected adjacent area code and the form code stored in the storage unit are the same and the operation start date has already passed. To do.
[0045]
In this way, it is determined whether or not there is an operating store in which the adjacent region code and the form code are the same and the operation start date has already passed in the order of setting the adjacent region code within the number of adjacent regions Q. If detected, a proximity store information response message including the store code and communication address of the operating store is created and transmitted to the store management device 2Y of the newly opened store that is the proximity store search request message transmission source. .
In addition, if the store code of the newly opened store is not set in the store information file, and the store search file 12 is searched in the order of setting the adjacent region code within the range of the adjacent region number Q, the corresponding operating store can be detected. If not, an error response is transmitted to the store management device 2Y of the newly opened store that is the sender of the nearby store search request message.
[0046]
The store-specific single item information requesting means 97 ′ is a means for transmitting a request command for store-specific single item information to the store management device 2X of the operating store a1 connected by the WAN 3, and the single item information master file 4 from the headquarter management device 1 After the download of various pieces of single item information stored and managed is completed, a start command for store-specific single item information request means is input from the personal computer 8 connected via the LAN via the LAN control unit 28.
That is, as shown in FIG. 17, when the start command of the store-specific single item information requesting unit is input, the CPU 21 completes downloading of various single item information stored and managed in the single item information master file 4 from the head office management device 1. After confirming that this is done, a proximity store search request message including the store code set in the message format shown in FIG. 15A is created. And this proximity store search request message is transmitted to the headquarters management apparatus 1 via WAN3.
[0047]
In response to this, when the nearby store information response message in the message format shown in FIG. 15B is received from the headquarters management apparatus 1, the retry counter r is initialized to “0”. Next, the WAN control unit 26 is controlled to call the store management device 2X designated by the communication address in the nearby store information response message. When the line with the store management apparatus 2X is connected, a predetermined store-specific single item information request command is transmitted. Thereafter, the single product information local file creation means 98 is activated.
If the line is not connected even if the store management apparatus 2X is called, the retry is performed until the retry counter r reaches the specified value R.
[0048]
The store-specific single item information extraction means 94 ′ extracts the single item information unique to the store that is not stored in the single item information master file 4 of the headquarters management device 1 from the single item information of various products stored in the single item information local file 7. It is activated when a request command for store-specific single item information is received from the non-operating store management device 2Y via the WAN control unit 26.
That is, as shown in FIG. 18, when receiving the store-specific single item information request command, the CPU 21 receives the store-specific single item information request source regardless of whether or not the store of the store-specific single item information request source exists in the same area. The communication address on the WAN 3 assigned to the store management apparatus 2Y is temporarily stored in the RAM 23. Also, the record read counter n is initialized to “0”. Next, when the counter n is incremented by 1, the n-th single product information record is read from the single product information local file 7. Then, it is determined whether the management classification data d1 of this single item information record is “0” or “1”. If it is “0”, the single item information of this single item information record is extracted as it is single item information unique to the store which is not stored in the single item information master file 4 of the head office, and is stored in the RAM 23. On the other hand, when the management classification data d1 is “1”, it is not extracted because it is single-item information common to each store stored in the single-item information master file 4.
[0049]
Next, when the record reading counter n is incremented by 1 again and the n-th single item information record is read from the single item information local file 7, the same processing as described above is performed.
In this way, each time the single item information record is read sequentially from the single item information local file 7, the management classification data d1 of the single item information record is checked, and if the data “0” indicating [store], the single item information of the single item information record is obtained. Extracted and stored in the RAM 23. When the above processing is completed for all the records in the single item information local file 7, a store-specific single item information file 95 is created from all the single item information extracted in the RAM 23. When the store-specific single product information file 95 is stored in the file storage unit 25a, the store-specific single product information output means 96 is activated.
[0050]
In the store management system according to the second embodiment having such a configuration, the single item information local file 7 is installed in the store management device 2Y which is installed in the non-operating store an newly opened and does not have the single item information local file. When 'is created, the store management device 2Y activates the store-specific single item information requesting means 97'. Then, the proximity store selecting means 14 operates in the headquarters management apparatus 1, and the operation store 1a having the same or adjacent store opening area and the same store form is selected as the proximity store. And the request | requirement of store specific single item information is performed with respect to the store management apparatus 2X of the selected operation store 1a. Thereby, the single item information local file 7 ′ is created in the non-operating store management device 2Y in the same manner as in the first embodiment.
[0051]
Therefore, according to the second embodiment, since the operation of selecting the operating store of the single item information request destination unique to the store is automated, the burden on the store opening preparation staff can be further reduced, and the product form is different. The effect which can prevent the malfunction which requests | requires the single item information specific to a store to an operation store is produced.
[0052]
The present invention is not limited to the first and second embodiments.
For example, in the first embodiment, as the store-specific single item information extraction unit 94, whether or not the single item information is corrected by a command from the headquarters management device 1 for each single item information of various products stored in the single item information local file 7. In this example, there is shown a case in which single item information other than single item information corrected by a command from the head office management device 1 is extracted as store-specific single item information. 1, the single product information registered in the single product information master file 4 is received and collated with all the single product information in the single product information local file 7, but exists in the single product information local file 7 but is stored in the single product information master file 4. A method of extracting single item information that does not exist is also conceivable.
[0053]
Further, in the first embodiment, both the correction date and the sales occurrence date are managed as the surplus record deleting means 93, and both the dates are deleted from the single product information local file 7 when the set number of days has passed. However, either one of the dates may be managed and deleted from the single product information local file 7 when the set number of days has passed.
[0054]
Further, in the first embodiment, the store-specific single product information requesting means 97 is provided in the store management apparatus 2Y that is not equipped with the single-item information local file, but the store-specific single product information requesting means 97 is provided in the head office management apparatus 1. The person in charge at the headquarters may appropriately select an operating store and instruct the store management device 2X of the store to create the store-specific single product information file 95. Further, the store-specific information requesting unit 97 may be provided in the store management device 2X of the operating store, and the creation of the store-specific single item information file 95 may be instructed at the operating store in the same area as the non-operating store.
[0055]
Similarly, in the second embodiment, the store-specific single item information requesting means 97 ′ is provided in the store management apparatus 2Y that is not equipped with the single-item information local file. 97 ′, the person in charge at the headquarters manually inputs the store code of the non-operating store to activate the adjacent store selecting means 14, and the store management device 2X of the operating store automatically selected from the headquarter management device 1 through the WAN 3 The creation of the store-specific single item information file 95 may be instructed.
[0056]
In addition, a public network such as ISDN (Integrated Services Digital Network) is used as a communication line for connecting the head office management apparatus 1 and each store management apparatus 2 without departing from the scope of the present invention. Of course, various modifications can be made.
[0057]
【The invention's effect】
As described above in detail, according to the invention described in claim 1 of the present application, it is possible to simplify the work necessary for creating a single product information local file in the store management device of a non-operating store to be newly opened. It is possible to provide a store management system that can prevent mistakes such as pickup omission and incorrect input of single item information, and can shorten the store opening preparation period and reduce the work load on the store preparation staff.
According to the invention described in claim 2 of the present application, in addition to having the same effect as the invention described in claim 1 above, in the operating store, the store-specific information is stored from the single item information of various products stored in the single item information local file. Since the single item information is automatically picked up, it is possible to provide a store management system capable of further simplifying the work required to create the single item information local file in the store management device of the non-operating store to be newly opened.
Further, according to the invention described in claim 3 of the present application, the same effect as that of the invention described in claim 1 above can be obtained, but also from a single product information local file created in a store management device of a non-operating store to be newly opened. Since the single item information of unsold products is automatically deleted after a certain period of time, a store management system can be provided that can omit the operation of deleting unnecessary single item information from the single item information local file.
Further, according to the invention described in claim 4 of the present application, in addition to achieving the same effect as that of the invention described in claim 1 above, the person in charge of opening a store is in an inactive store that is newly opened and is not in operation. Since the single item information local file can be created in the store management device of the store, it is possible to provide a store management system that can further reduce the work load of the person in charge of opening the store.
Further, according to the invention described in claim 5 of the present application, in addition to achieving the same effect as that of the invention described in claim 1, communication between the store management device of the non-operating store and the store management device of the active store can be performed. Even if a failure occurs, it is possible to provide a store management system that can reliably create a single item information local file in the store management device of an unoperated store.
[0058]
In addition, according to the invention described in claim 6 of the present application, the same effect as that of the invention described in claim 1 above can be obtained, and the same area in the same area as the store newly opened as the store of the single item information request destination unique to the store Since the operating store of the form is automatically selected and the store-specific single item information is requested to the operating store, it is possible to provide a store management system capable of simplifying the operation of selecting the operating store.
[0059]
Further, according to the invention described in claim 7 of the present application, the same effect as that of the invention described in claim 6 can be obtained, and even if there is no operating store of the same form in the same area as the newly opened shop, the area Since an operating store having the same form is automatically selected in an area adjacent to the store and a request for store-specific single item information is made to the operating store, a store management system capable of reliably generating a single item information local file can be provided.
[Brief description of the drawings]
FIG. 1 is a block diagram for explaining functions unique to the present invention that a store management apparatus and a headquarters management apparatus of a store management system according to a first embodiment of the present invention have.
FIG. 2 is a schematic diagram of a store management system according to the first embodiment.
FIG. 3 is a block diagram showing a hardware configuration of a store management apparatus in the store management system according to the first embodiment.
FIG. 4 is a view showing a record format of a single product information local file which the store management apparatus of the store management system of the first embodiment has.
FIG. 5 is a flowchart that embodies file correction means included in the store management device of the store management system according to the first embodiment;
FIG. 6 is a flowchart that embodies a single item sales update unit included in the store management device of the store management system according to the first embodiment;
FIG. 7 is a flowchart embodying surplus record deletion means included in the store management device of the store management system according to the first embodiment;
FIG. 8 is a flowchart that embodies store-specific information extraction means included in the store management device of the store management system according to the first embodiment;
FIG. 9 is a flowchart that embodies a store-specific single item information output unit included in the store management device of the store management system according to the first embodiment;
FIG. 10 is a flowchart embodying a store-specific single item information requesting unit included in the store management apparatus of the store management system according to the first embodiment.
FIG. 11 is a flowchart embodying a single item information local file creation unit included in the store management apparatus of the store management system according to the first embodiment;
FIG. 12 is a block diagram for explaining functions unique to the present invention that the store management apparatus and the headquarter management apparatus of the store management system according to the second embodiment of the present invention have;
FIG. 13 is a diagram showing a record format of a store information file included in the headquarters management apparatus of the store management system according to the second embodiment;
FIG. 14 is an exemplary view showing a record format of an area information file included in the head office management apparatus of the store management system according to the second embodiment;
FIG. 15 is a view showing a format of main messages transmitted and received between the head office management device and the store management device of the store management system according to the second embodiment;
FIG. 16 is a flowchart that embodies proximity store selection means included in the head office management device of the store management system according to the second embodiment; .
FIG. 17 is a flowchart that embodies store-specific single item information requesting means included in the store management device of the store management system according to the second embodiment;
FIG. 18 is a flowchart that embodies store-specific information extraction means included in the store management device of the store management system according to the second embodiment;
[Explanation of symbols]
1. Headquarter management device
2… Store management device
3 ... WAN
4… Single product information master file
7, 7 '... Local product information local file
12 ... Store information file
13… Regional information file
14 ... Means for selecting nearby stores
91 ... File correction means
92. Single item sales renewal means
93: Surplus record update means
94, 94 '... Store-specific single item information extraction means
95 ... Store-specific single item information file
96 ... Store-specific single item information output means
97, 97 '... Store-specific single item information request means
98 ... Single item information local file creation means

Claims (7)

A head office management device having a single product information master file that stores single product information such as single product codes and unit prices of various products that are installed in the headquarters that govern each store and are commonly sold in each store, and each store installed in each store In a store management system formed by connecting a plurality of store management devices capable of mounting a single item information local file storing the single item information of various products sold at a communication line,
Among the store management devices, the store management device having the single item information local file already installed is unique to the store that is not stored in the single item information master file among the single item information of various products stored in the single item information local file that it has. Store-specific single item information extraction means for extracting the single item information of, and store-specific single item information output means for outputting the store-specific single item information extracted from the single item information local file by this extraction means,
The store management device that is not loaded with the single item information local file is a single item information that is downloaded from the headquarters management device via the communication line and a single item information that is output from the store management device that is loaded with the single item information local file. A store management system comprising a single product information local file creation means for creating and storing a single product information local file with information. The store-specific single item information extracting means is provided with means for identifying whether or not each piece of single item information of various products stored in the single item information local file is single item information corrected by a command from the headquarters management device 2. The store management system according to claim 1, wherein the single item information other than the single item information corrected by a command from the head office management device is extracted by the means as single item information unique to the store. The store management apparatus having the single item information local file mounted therein stores a date storing means for storing a date having the operation start date of the store as an initial value for each product for which single item information is stored in the single item information local file, and this date The date stored by the storage means is updated every time the single item information of the corresponding product is corrected or the sales of the corresponding product are performed. 2. The store management system according to claim 1, further comprising single item information deleting means for deleting single item information of a product whose elapsed period from the date that has passed a preset period from the single item information local file. The store management device that is not equipped with the single item information local file includes means for requesting store-specific single item information via the communication line to the store management device that is already equipped with the single item information local file. The store management system according to claim 1, wherein the store management device having the single item information local file mounted thereon causes the store-specific single item information extraction unit and the store-specific single item information output unit to function. The store management apparatus having the single item information local file mounted thereon has medium recording means for recording information on a portable recording medium, and the store specific single item information output means is connected to the single item information extraction means by the store specific single item information extraction means. The single item information unique to the store extracted from the information local file is transmitted and output via the communication line to the store management device that is not equipped with the single item information local file. The store management apparatus according to claim 1, wherein the store management device is configured to write and output to the portable recording medium. A head office management device having a single product information master file that stores single product information such as single product codes and unit prices of various products that are installed in the headquarters that govern each store and are commonly sold in each store, and each store installed in each store In a store management system formed by connecting a plurality of store management devices capable of mounting a single item information local file storing the single item information of various products sold at a communication line,
The headquarters management device stores a store information file in which a region code for identifying a store opening area of each store and a form code for identifying a product form of the store are set for each store, and a region code and a form of a store to be newly opened An operation store search means for searching an operation store in which the same area code and form code as the input code are set when the code is input from the store information file;
Among the store management devices, the store management device having the single item information local file already installed is unique to the store that is not stored in the single item information master file among the single item information of various products stored in the single item information local file that it has. Store-specific single item information extraction means for extracting the single item information of, and store-specific single item information output means for outputting the store-specific single item information extracted from the single item information local file by this extraction means,
The store management device that is not loaded with the single item information local file includes the single item information downloaded from the headquarters management device via the communication line and the store management device of the operating stores detected by the operating store search means of the headquarters management device. A store management system comprising a single product information local file creation means for creating and storing a single product information local file with store-specific single product information output from the store. The headquarters management device stores a region information file storing a region code of a region adjacent to the store opening region by region code for identifying a store opening region of each store, and a store information file searched by the operating store search means as a result of opening a new store When an operating store having the same area code and form code as the store area code and form code cannot be detected, the area information file is searched to obtain an adjacent area code corresponding to the area code of the new store And an adjacent operating store search unit that searches the store information file for an operating store in which the adjacent region code acquired by the code acquiring unit and the form code of the newly opened store are set. The store management system according to claim 6.

Images