JP4727539B2 - Sales information management system - Google Patents

Description

  The present invention relates to a sales information management system for managing sales information of a store, and in particular, a store server connected to a plurality of POS terminals and totaling sales data of POS terminals, and sales result data based on sales data for each POS terminal. The present invention relates to a sales information management system comprising a sales management server that includes a performance database that stores information, stores sales data connected to a plurality of store servers, receives sales data from each store server, and updates the performance database.

  Conventionally, there are the following sales information management systems as described above. In this sales information management system, a store server is arranged in each store of a plurality of stores, and a plurality of POS terminals are connected to the store server. The headquarters managing a plurality of stores is provided with a headquarters server as an upper server, and a plurality of storeservers disposed at the plurality of stores are connected to the headquarters server.

  The POS terminal transmits sales data to the store server, and the store server aggregates the sales data of each POS terminal and transmits it to the headquarter server in real time.

  Then, the headquarter server updates the performance database based on the sales data. In the result database, for example, the result data is accumulated for each POS terminal, for each store, for each day, for each week, for each month, and for each year.

  There exists a thing of patent document 1 as such a sales information management system. Patent Document 1 uses a client server system and includes one or more store computers arranged in each store and a center computer arranged in the center and connected to each store computer via a network. The center computer is provided with means for sequentially accessing each store computer and collecting the in-store update data recorded in the store computer and means for recording the collected in-store update data Thus, a technique is disclosed in which in-store update data read by each store computer is collected and recorded in the center computer at predetermined time intervals.

JP 2002-49792 A

  By the way, in the above-described conventional sales information management system, the headquarters (center) cannot know whether the received data is the final confirmed data of the store. That is, the headquarters performs finalization processing based on sales data at the time when finalization processing is performed at the headquarters for store sales and creates finalization data. For this reason, when sales occur at a store thereafter, a situation occurs in which the sales at this store are not reflected in the finalized data.

  In such a case, even if sales are not finalized at the store, the headquarters will process the sales data up to that point as finalized data. As a result, the system user is not able to refer to the correct confirmed data.

  Therefore, an object of the present invention is to provide a sales information management system capable of reliably updating a database on the headquarters side based on final confirmed data of a store.

Since the present invention is to solve the above problems, and the shop server receives the sales data of the connected the POS terminal P OS terminal, along with being connected to the store server receives the sales data from the shop server, the POS terminal the sales record data according to another sales data have, and sales management server to update on the basis of the sales data to the received, the sales data from the POS terminal in real time to the sales management server via the store server in the sales information management system for delivering, the shop server, when the POS terminal has sales determination processing, a flag indicating that the POS terminal has the sales determination processing, the sales data received from the POS terminal Sales confirmation data including a sales confirmation value indicating the sales that have been subjected to the sales confirmation processing based on the sales management server A data transmission unit for transmitting the sales management server, the flag sales confirmation data comprises showed that it has the sales determination processing, and the show received sales data and sales check value the sales confirmation data comprises if the total value of sales and matches, characterized in that it comprises the update section to update the actual sales data.

  According to the present invention, since the performance database is updated from the store server based on the confirmed data in the sales management server, the performance database is not updated based on the unconfirmed data, and the performance database is always confirmed. Correct sales confirmation data can be accumulated.

  Hereinafter, an embodiment of the present invention will be described with reference to FIGS. In the present embodiment, the sales information management system includes a headquarter server 300 that is a sales management server of the headquarters, a store server 200 of a store that is connected to the headquarters server 300 through a fixed connection line such as a dedicated line, and the store server 200. It is a store system provided with the POS (sales time management) terminal 100 connected to the.

  FIG. 1 is a schematic diagram showing the overall configuration of the sales information management system according to the present embodiment.

  As shown in FIG. 1, the sales information management system according to the present embodiment includes a headquarter server 300 installed in the headquarters, a store server 200 installed in a plurality of stores, and a plurality of stores connected to each store server 200. And a POS terminal 100.

  And the form which communicates using the fixed connection line 400 between the headquarters server 300 and the shop server 200 is taken. The fixed connection form may be either a physical fixed connection form or a logical fixed connection form. As a physical fixed connection form, for example, a dedicated line or the like is applied. As a logical fixed connection form, for example, a PVC (Permanent Virtual Circuit) of a packet switching network is applied.

  That is, the communication mode between the headquarter server 300 and the store server 200 installed in each store is a communication mode that is isolated from other users' communication and can use the communication line exclusively or exclusively. I just need it. Note that the store server 200 and each terminal 100 adopts a form in which communication is performed using the LAN 500.

  FIG. 2 is a block diagram showing a system configuration of the POS terminal 100 shown in FIG. As shown in FIG. 2, the POS terminal 100 includes a drawer 101, a display 102, a keyboard 103, a receipt printer 104, and a barcode scanner 105. The POS terminal 100 includes a microcomputer MC on a main board (not shown). MC drives and controls each part. The microcomputer MC is configured by connecting a ROM 120 and a RAM 130 via a bus line SB1 to a CPU 110 that centrally controls each unit. Since the RAM 130 is a volatile memory, it is backed up by a battery BT that is a backup power source. The ROM 120 stores fixed data such as a control program in advance.

  In this embodiment, the ROM 120 stores a processing program 121 for executing transmission processing of temporary sales data and final sales data. Further, sales data is stored in the RAM 130, and setting data is also stored in the RAM 130.

  The microcomputer MC configured as described above is connected to the drawer 101 via the drawer control unit 140, the display 102 via the display control unit 150, and the keyboard 103 via the keyboard input control unit 160. The receipt printer 104 is connected via the printer controller 170, and the barcode scanner 105 is connected via the barcode scanner controller 180.

  Furthermore, a communication I / F 190 is provided on the main board for communicating with host devices such as the store server 200 and the headquarter server 300 via the bus line SB1.

  The POS terminal 100 performs the following processing by the processing of the CPU 110. That is, when the POS terminal 100 is opened, it transmits “store code”, “POS code”, and “sales date” to the store server 200 as the opening information. The POS terminal 100 transmits sales data to the store server 200 in real time after the opening of the station. Furthermore, the POS terminal 100 transmits the sales confirmation information to the store server 200 when the closing process for one day is performed by the input from the keyboard 103. This sales confirmation information is made up of “store code”, “POS code”, and “sales date”, as with the opening information.

  Next, the store server 200 will be described. FIG. 3 is a block diagram showing a system configuration of the store server 200 shown in FIG. 1, and FIG. 4 is a schematic diagram showing a configuration of POS confirmation information data created by the store server.

  The store server 200 generates PLU (price search) responses while controlling the POS terminal 100, collection and aggregation of sales information, issuance of flash reports for grasping sales trends, product inventory data, order data, etc. This is a store computer for realizing a store management system such as collecting and processing information to be processed and exchanging information with the headquarters.

  As shown in FIG. 3, the store server 200 includes a control unit 210, a memory unit 220 connected to the control unit 210 via the system bus SB2, a storage device 230, a display unit 240, and an operation unit 250. , A printing unit 260, a first communication unit 270, a second communication unit 280, and a storage medium reading / writing unit 290.

  Here, the control unit 210 implements a CPU that centrally controls each unit, and controls various processes in the store server 200. The memory unit 220 is a work memory, and in addition to temporarily storing data during work, an area for temporarily storing data received by the first communication unit 270 and the second communication unit 280 is formed.

  That is, the memory unit 220 stores a temporary data storage unit 221 that stores the daily sales temporary data 201 for each POS terminal and a POS daily result file 203 created from the daily sales temporary data 201. A storage unit 222; a confirmation data storage unit 223 that stores the POS-specific determination data 202 from the POS terminal 100; and a confirmation information file storage unit 224 that stores the POS-specific determination information file 204 created from the POS-specific determination data 202. It is formed (see FIG. 6).

  The storage device 230 is realized by a hard disk or the like, and stores and holds various processing programs and setting information in the store server 200. In particular, in the present embodiment, the storage device 230 stores a processing program 231 that executes a sales confirmation information transmission processing procedure (see FIGS. 6 and 7) as a data transmission unit to be described later. The display unit 240 is a display or the like, and is a user interface unit that displays various types of information. The operation unit 250 is a keyboard, a mouse, or the like, and is a user interface unit that inputs various user instruction information. The first communication unit 270 is an interface unit that communicates with the headquarter server 300 installed in the headquarters using a fixed connection line 400 such as a dedicated line. The second communication unit 280 is an interface unit that communicates with the POS terminal 100 connected to the store server 200 via a local line such as a LAN. The printing unit 260 is a printer that prints character information or the like on paper. The storage medium reading / writing unit 290 is a flexible disk drive or a CD drive that performs reading or writing on a storage medium such as a flexible disk or a CD.

  With such a configuration, the store server 200 creates the POS-specific determination data 202 for each POS terminal 100 as described above by the processing of the control unit 210. As shown in FIG. 4 as POS-specific determination data 600, the POS-specific determination data 202 includes, as items, a store code 601, a POS code 602, a sales date 603, a data type 604, a sales confirmation value 605, and a determination flag 606. Prepare.

  The store server 200 creates the POS-specific confirmation data 202 based on the opening information transmitted by the POS terminal 100 when the station is opened. When the POS terminal 100 is opened, the store server 200 inputs values for “store code”, “POS code”, and “sales date” transmitted when the POS terminal 100 is opened, and “0” as a sales confirmation value. ”,“ 0 ”is set as the confirmation flag and transmitted to the headquarter server 300.

  In addition, the store server 200 sends sales data from the POS terminal 100 to the department server 300 in real time after the opening of the station.

  Further, the store server 200 receives the sales confirmation information transmitted based on the settlement process when the POS terminal is closed, and creates the POS-specific confirmation data 202. The POS-specific confirmation data 202 is created for each POS terminal, and the total daily sales amount of the POS terminal 100 is created based on the sales information. The store server 200 calculates the determined sales amount of the POS terminal 100 based on the sales data received in real time, sets the value to “recognition of each sales”, and sets the settlement flag to “1” Is set and transmitted to the headquarter server 300 as the POS-specific confirmation data 202. Thereby, the headquarters server 300 can recognize which POS terminal of which store is in an unsettled state.

  Next, the headquarter server 300 will be described. FIG. 5 is a block diagram showing a system configuration of the headquarter server 300 shown in FIG. The headquarter server 300 constructs a record database 332 that receives and manages the sales data sent from the store server 200 of the store.

  As shown in FIG. 5, the headquarter server 300 includes a control unit 310, a memory unit 320 connected to the control unit 310 via the system bus SB3, a storage device 330, a display unit 340, an operation unit 350, A storage medium reading / writing unit 360, a communication unit 370, a communication unit 370, and a printing unit 380 are provided.

  Here, the control unit 310 is mounted with a CPU that centrally controls each unit, and controls various processes in the headquarter server 300. The memory unit 320 is a work memory, and has an area for temporarily storing working data and temporarily storing data received by the communication unit 370.

  That is, in the memory unit 320, a result file storage unit 321 for storing a POS daily result file 301 received from the store server 200 for each POS terminal, and a POS daily result extracted from the POS daily result file 301 Temporary data storage unit 322 for storing temporary data 303, confirmation information file storage unit 323 for storing confirmation information file 302 for each POS received from store server 200, and confirmation data 304 for each POS extracted from confirmation information file 302 for each POS Are defined data storage unit 324 (see FIG. 6).

  The storage device 330 is realized by a hard disk or the like, and stores and holds various processing programs and setting information in the headquarter server 300. In particular, in the present embodiment, the storage device 330 stores a processing program 331 for executing processing (see FIGS. 6 and 8) as a database updating unit described later, and stores a performance database 332 described later. . In the results database 332, sales results for each period are stored for each POS and each store total. In this example, the results database 332 includes the POS daily results, store total daily results, POS weekly results, store total weekly results, POS monthly results, store total monthly results, POS annual results, and store totals. Data on annual performance is stored (see FIG. 6). The performance database 332 can be provided in the storage device 330, or can be formed on other hardware connected to the headquarter server 300.

  The display unit 340 is a display or the like, and is a user interface unit that displays various types of information. The operation unit 350 is a keyboard, a mouse, or the like, and is a user interface unit that inputs various user instruction information. The storage medium reading / writing unit 360 is a flexible disk drive or a CD drive that performs reading or writing on a storage medium such as a flexible disk or a CD. The communication unit 370 is an interface unit that communicates with the store server 200 installed in the store using a fixed connection line 400 such as a dedicated line. The printing unit 390 is a printer that prints character information or the like on paper or the like.

  With such a configuration, the headquarter server 300 updates the 1-result database 332 based on the POS-specific determination data 600 for each POS terminal 100 that has been subjected to the settlement process, by the processing of the control unit 310. The result database 332 is updated by confirming that the confirmation flag 606 in the POS-specific confirmation data 600 is “1”, that is, that the update target POS terminal has executed the tightening process.

  That is, the headquarter server 300 rewrites the POS-specific confirmation data of the POS terminal 100 connected to the store server 200 when the store server 200 is opened. As a result, the sales confirmation value of the POS-specific confirmation data of each POS terminal 100 is “0”, and the confirmation flag is “0”.

  When the POS-specific confirmation data associated with the settlement process at the closing of each POS terminal 100 is received from the store server 200, the POS-specific confirmation data for each POS terminal 100 is rewritten. As a result, the sales data is set in the sales confirmation value of the POS-specific confirmation data of the POS terminal 100 that has been settled, and the confirmation flag is set to “1”.

  And the update of the performance database 332 in the headquarters server 300 is managed per store. For example, when there are a plurality of POS terminals in the same store and there are unsettled POS terminals in the store, the store is not subject to update.

  Next, the operation of the sales information management system according to this example will be described with reference to FIGS.

  6 is a schematic diagram showing the operating state of the sales information management system according to the embodiment, FIG. 7 is a flowchart showing the operating state of the store server, and FIG. 8 is a flowchart showing the operating state of the headquarter server.

  Each POS terminal 100 transmits opening information to the store server 200 at the time of opening. Each POS terminal 100 sends sales data to the store server 200 in real time as shown in FIG. Further, the POS terminal 100 stores the sales data as daily sales temporary data 201 in the temporary data storage unit 221 for each POS day. Then, based on the predetermined data extracted from the daily sales temporary data 201, a POS daily performance file 203 is created in the performance file storage unit 222, and the POS daily performance file 203 is created by, for example, FTP (File Transfer Protocol). Send to store server 200.

  Further, when the business ends and the closing process is performed at the POS terminal 100, each POS terminal 100 sends the sales confirmation information to the store server 200.

  The store server 200 creates POS-specific determination data 202 (POS-specific determination data 600 in FIG. 4) based on the sales determination information from each POS terminal 100 and the sales data from the POS terminal 100, and stores it in the determination data storage unit 223. Store. Then, based on the predetermined data extracted from the POS-specific determination data 202, the POS-specific determination information file 204 is stored in the determination information file storage unit 224. This POS-specific confirmation information file 204 is created for each POS terminal. Thereafter, at a predetermined time, the POS-specific confirmation information file 204 is sent to the headquarter server 300 by FTP, for example.

  The sending process of the POS-specific confirmation information file 204 is performed for each POS terminal. Accordingly, in the POS-specific confirmation information file 204 to be transmitted, the POS-specific confirmation information file 204 (confirmation flag “1”) of the POS terminal 100 that has been subjected to the tightening process, and the 204 of the POS terminal 100 that has not been subjected to the tightening process. (Confirmation flag “0”) are mixed.

  That is, in the store server 200, the control unit 210 operates as a data transmission unit by executing the processing program 231 stored in the storage device 230, and executes the following operations. As shown in FIG. 7, when the opening information is received from the POS terminal 100, the POS-specific determination data 202 is generated, and the POS-specific determination data 202 is generated (steps S1 and S2). Then, the POS-specific confirmation information file 204 is created (step S3) and sent to the headquarter server 300 (step S4).

  Further, until the sales confirmation information is received from the POS terminal 100, that is, during the sales of the store, the sales data is received from each POS terminal 100, and the daily sales temporary data 201 is periodically generated. Temporary data results are extracted from the data 201 (steps S5 and S6). Then, the POS daily result file 203 is created (step S7) and sent to the head office server 300 (step S8).

  When the store server 200 receives the sales confirmation report from the POS terminal 100, the store server 200 creates the POS-specific determination data 202 and extracts the determination data from the POS-specific determination data 202 (steps S9 and S10). Then, the POS-specific confirmation information file 204 is created (step S11) and sent to the headquarter server 300 (step S12).

  As shown in FIG. 6, when the headquarter server 300 receives the POS daily performance file 203 from the store server 200, the headquarter server 300 stores it in the confirmed information file storage unit 323 as the POS daily performance file 301. Based on the record file 301, the POS daily temporary data 303 in the temporary data storage unit 322 is updated.

  Upon receiving the POS-specific confirmation information file 204, the headquarter server 300 stores the POS-specific determination information file 302 in the determination information file storage 323 and updates the POS-specific determination data 304 in the determination data storage 324. The POS-specific determination data 304 has the same data structure as the POS-specific determination data 202 in the store server 200. As shown in FIG. 4 as POS-specific determination data 600, the items include a store code 601 and a POS code 602. , Sales date 603, data type 604, sales confirmation value 605, and confirmation flag 606.

  In the confirmation data 304 by POS, the confirmation flag 606 is updated to “0” when the station is opened, and is updated to “1” when the store settlement is performed and the data is confirmed. The headquarter server 300 confirms that the confirmation flag 606 is “1” and updates the record data in the record database 332.

  That is, in the headquarter server 300, the control unit 310 operates as a database update unit by executing the processing program 331 stored in the storage device 330, and executes the following operations. This database is updated for each store. As shown in FIG. 8, first, the POS-specific confirmed data 304 for the first store is read from the confirmed data storage unit 324 according to a predetermined order (step S21). Then, in the POS-specific confirmation data 304, it is determined whether the confirmation flag 606 is “1”, that is, whether it is confirmed (step S22). When the confirmation flag 606 is “0”, the next store is searched (step S25), and when the confirmation flag 606 is “1”, the sales confirmation value 605 of the POS-specific confirmation data 304 is the POS daily temporary. It is determined whether the total value of the data 303 is the same. This determination is made in order to detect a case where the settlement is exceptionally completed but the computation is not completed. If the two values do not match, the next store is searched (step S25), and if the two values match, the results database 332 is updated. The update is performed for the POS terminal, date, and data type of the corresponding store.

  Then, the next store is searched (step S25). If there is the POS-specific determination data 304 for the next store, the above-described processing (steps S22 to S25) is executed, and the POS-specific determination data 304 for the next store is obtained. If not, the process ends.

  Through a series of processes, the update of the record database 332 for all the stores whose sales are fixed is completed.

  Through the series of processes, the record database 332 of the headquarter server 300 is updated based on the sales confirmation information based on the sales confirmation process of the POS terminal 100.

  As described above, according to the sales information management system according to the present embodiment, the results database on the headquarters side is updated based only on the final confirmed data of the stores whose settlement has been confirmed by the confirmation flag. Therefore, the actual result database is not updated based on the unconfirmed sales data, and the data in the actual result database can be surely settled.

It is a schematic diagram which shows the whole structure of the sales information management system which concerns on this Embodiment. It is a block diagram which shows the system configuration | structure of the POS terminal shown in FIG. It is a block diagram which shows the system configuration | structure of the shop server shown in FIG. It is a schematic diagram which shows the structure of the determination information data classified by POS. It is a block diagram which shows the system configuration | structure of the headquarters server shown in FIG. It is a schematic diagram which shows the operating state of the sales information management system which concerns on embodiment. It is a flowchart which shows the operating state of a shop server. It is a flowchart which shows the operating state of a headquarters server.

Explanation of symbols

  100 POS terminal, 200 store server, 202 POS specific data (confirmed data), 300 headquarters server (sales management server), 304 POS specific data (confirmed data), 332 results database

Claims (4)

And the shop server is connected to the P OS terminal receives the sales data of the POS terminal, with is connected to the store server receives the sales data from the shop server, the sales record data based on the POS terminal-specific sales data, anda sales management server to update on the basis of the sales data to the received, in the sales information management system for delivering real-time to the sales management server sales data from the POS terminal via the shop server,
The store server, when the POS terminal has sales determination processing, a flag indicating that the POS terminal has the sales determination processing and the sales determination processing based on the sales data received from the POS terminal A data transmission unit for sending sales confirmation data including a sales confirmation value indicating sales to the sales management server;
The sales management server indicates that the flag included in the sales confirmation data indicates that the sales confirmation processing has been performed, and the sales confirmation value included in the sales confirmation data matches the total value of sales indicated by the received sales data. If the sales information management system characterized in that it comprises the update section to update the actual sales data. It said sales management server is sales information according to claim 1, comprising: a sales temporary data storage for storing Uede chromatography data selling said received, the confirmation data storage unit for storing the sales confirmation data Management system. The sales management server includes a performance database storing the sales performance data,
The sales information management system according to claim 1 , wherein the update unit updates the sales performance data stored in the performance database . The update unit updates the sales performance data for each store where the POS terminal is installed, and the sales confirmation value included in the sales confirmation data does not match the total sales value indicated by the received sales data. 4. The sales information management system according to claim 1 , wherein the sales result data of other stores is updated .

Images