JP5789112B2 - Information management system and information management program - Google Patents

Description

  The present invention relates to an information management system and an information management program for collecting POS information and displaying the results.

  Conventionally, as means for totaling POS information such as sales information, an acquisition unit for acquiring POS information, a storage device for storing the acquired POS information, a totaling unit for totaling the acquired or stored POS information, An information management system including a display unit that displays a result of counting by the counting unit is known (for example, see Patent Document 1).

JP 2008-71186 A

The information management system of the above document can make a sales plan and a purchase plan at a subsequent store with high accuracy by confirming the sales status of the specific product from the result of counting the POS information.
However, the information management system of the same document has only a normal counting means as a counting means, and the normal counting means counts POS information of business hours (normal period) for one day at a store. A short-term management plan such as a sales plan or a purchase plan at the next day's store is made immediately after the store is closed, and there is little time before opening the next day.

  In other words, it is possible to formulate a medium- to long-term management plan at a store using POS information for the business period for one day, but it is convenient for planning a short-term management plan at a store. bad.

  The present invention makes it easy to formulate a medium- to long-term management plan such as the next week or the next month at a store based on the result of counting POS information, and develops a short-term management plan such as the next day at a store. It is an object of the present invention to provide an information management server and an information management program that are easy to do.

  An information management system of the present invention includes an acquisition unit that acquires POS information, a storage device that stores the acquired POS information, a totaling unit that totals the acquired or stored POS information, and a totaling result obtained by the totaling unit. An information management system comprising a display means for displaying, comprising at least two of a normal counting means and a short-term counting means as counting means, wherein the normal counting means is a normal counting period that is a predetermined period. The POS information is aggregated, and the short-term aggregation means is characterized in that the POS information is aggregated for a predetermined short-term aggregation period so as to be shorter than the normal aggregation period and shorter than one day.

  With the above configuration, it is easy to formulate a medium- to long-term management plan at a sales store by collecting POS information for a normal aggregation period via a normal aggregation means, and a short-term aggregation means By collecting the POS information in the short-term aggregation period via the network, it becomes easy to formulate a short-term management plan such as the next day at the sales store. In particular, the sales situation during the business hours of the store on the day is monitored in real time based on the results of the short-term aggregation means, so that the next day's purchases and sales can be planned with sufficient time. It becomes possible.

  Periodic aggregation target products selected from among the products to be sold are stored in advance in the storage device, and the short-term aggregation means calculates the POS information regarding the periodic aggregation target products stored in the storage device for each short-term aggregation period. Alternatively, it may be configured to perform automatically.

  You may be set as the structure which provided the periodical aggregation setting means to set the periodical aggregation object goods memorize | stored beforehand in a memory | storage device.

  It may be configured such that the periodic aggregation target products are selected in SKU units.

  In addition to selecting products subject to temporary aggregation from products other than those subject to periodic aggregation, provision of temporary aggregation setting means for selecting one or a plurality of time periods subject to aggregation for each short-term aggregation period and setting it as a temporary aggregation target period is provided. The means may be configured to aggregate the POS information related to the selected temporary aggregation target product for the selected temporary aggregation target period.

  The configuration may be such that the temporary aggregation target product is selected in SKU units.

  The normal period may be set to the business hours per day in the store, and the short-term aggregation period may be set to 1 hour.

  Further, the information program of the present invention acquires POS information, stores the acquired POS information in a storage device, displays a totaling process for totaling the acquired or stored POS information, and a totaling result by the totaling means. An information management program for executing a display process, which is a totaling process performed by a computer having a storage device as a totaling process, a totaling process for totaling POS information in a normal totaling period that is a predetermined period, and a totaling process This is for executing a short-term aggregation process for totaling POS information in a predetermined short-term aggregation period so as to be shorter than the normal aggregation period and shorter than one day.

  According to the present invention, it is easy to formulate a medium- to long-term management plan at a sales store by collecting the POS information of the normal aggregation period through the normal aggregation means, and through the short-term aggregation means. By collecting the POS information during the short-term aggregation period, it becomes easy to formulate a short-term management plan such as the next day at the sales store. In particular, the sales situation during the business hours of the store on the day is monitored in real time based on the results of the short-term aggregation means, so that the next day's purchases and sales can be planned with sufficient time. It becomes possible.

It is a block diagram of an information management system to which the present invention is applied. (A) is an explanatory diagram of a store data table, (B) is an explanatory diagram of an SKU data table, and (C) is an explanatory diagram of a user data table. (A) is explanatory drawing of a sales data table, (B) is explanatory drawing of a periodic total setting data table. It is explanatory drawing of a normal total data table. (A) is explanatory drawing of a periodic total data table, (B) is explanatory drawing of a temporary total data table. (A) is an explanatory diagram of a periodic aggregation setting screen, and (B) is an explanatory diagram of a temporary aggregation setting screen. It is a flowchart of the short-term totaling process which a short-term totaling means performs. It is a flowchart of the subroutine of a periodic total process. It is explanatory drawing of the total result display screen displayed by a display means. It is a flowchart of a subroutine of temporary aggregation processing. It is a flowchart of the normal total process which a normal total means performs.

Hereinafter, an embodiment of the present invention will be described based on the illustrated example.
FIG. 1 is a block diagram of an information management system to which the present invention is applied. The information management system includes an information management server 1, and the information management server 1 includes one or a plurality of store terminals 4 and one or a plurality of information terminals 6 via networks 2 and 3 including WANs such as the Internet. Is connected.

  The store terminal 4 is provided for each store, and POS (Point of sale) information including product information, sales information, inventory information, etc. acquired from the register facility (not shown) of the store in real time, It is configured to transmit to the information management server 1 side. The POS information includes detailed sales performance information such as “when, which product, how many, and what price was sold”.

  The information terminal 6 acquires various information from the information management server 1 and displays it on the screen. The store terminal 4 may have the function of the information terminal 3, and the information management server 1 itself has the function of the information terminal 6.

  The information management server 1 is realized by installing an information management program to which the present invention is applied in a computer. The information management server 1 includes a POS information acquisition unit (acquisition unit) 7 that acquires the POS information transmitted via the network 2 and an HDD that stores the acquired POS information and other various information. Alternatively, a storage device 8 made of SSD or the like, a totaling unit 9 that totals the POS information stored in the storage device 8, a setting unit 11 that performs detailed setting of totaling performed by the totaling unit 9, and the management server 1 is provided with user authentication means 12 for authenticating a user who directly accesses 1 or a user who accesses via the information terminal 6 with a lock-in ID and a password.

  The totaling unit 9 has two totaling units, a normal totaling unit 13 and a short-term totaling unit 14 as a totaling unit that totals the POS information acquired by the POS information acquisition unit 7 or the POS information stored in the storage device 8. In addition, display means 16 is provided for displaying the result of counting by the two counting means 13 and 14.

  The normal tabulating unit 13 tabulates POS information in a normal tabulation period that is a predetermined period, while the short-term tabulating unit 14 is a short-term that is shorter than the normal tabulation period and shorter than one day. The POS information for the aggregation period is aggregated. Incidentally, in this example, the normal aggregation period is set to the business hours per day at each store, and the short-term aggregation period is set to 1 hour.

  The setting unit 11 selects a target product to be periodically counted for each short-term tabulation period from the products to be sold as a periodic tabulation target product, and stores this in the storage device 8 in advance. have. In addition, the setting unit 11 selects a temporary aggregation target product from among products other than the periodic aggregation target product, and selects one or a plurality of aggregation target times in a short-term aggregation period unit as a temporary aggregation target period. Total setting means 18 is provided.

  The short-term aggregation means 14 described above performs a periodic aggregation process for automatically executing POS information relating to each of the previously selected periodic aggregation target products for each of the short-term aggregation periods, and by the temporary aggregation setting means. When the selection of the temporary aggregation target product and the selection of the temporary aggregation target period are performed, the temporary aggregation is performed for the temporary aggregation target period for the POS information regarding the temporary aggregation target product under a predetermined condition. Process.

  The storage device 8 is constituted by a conventionally known relational database. Specifically, as shown in FIGS. 2 to 5, a store data table 19 storing information on each store, merchandise to be sold, and inventory. A SKU data table 21 storing products stored as SKU, a user data table 22 storing user login IDs and passwords, and a sales data table 23 storing stored information obtained at each store based on POS information The periodic aggregation setting data table 24 that stores information on the periodic aggregation target products selected by the periodic aggregation setting means 17, the normal aggregation data table 26 that stores the information of the aggregation results by the normal aggregation means 13, and the short-term aggregation means 14 Periodic tabulation data table that stores information on tabulation results of products subject to periodic tabulation 27, the temporary summary data table 28 for storing information temporary totalization Shipping the counting result is provided in the acute aggregator 14.

  Incidentally, SKU is an abbreviation of “Stock Keeping Unit” and is called an inventory storage unit. For example, there are four sizes of T-shirts of the same product: S size, M size, L size, and LL size. In this case, it is necessary to manage the stock status of the T-shirt for each size. For this reason, each of the S size, M size, L size, and LL size of the T shirt is 1 SKU.

  2A is an explanatory diagram of the store data table, FIG. 2B is an explanatory diagram of the SKU data table, and FIG. 2C is an explanatory diagram of the user data table. The store data table 19 has, as fields, a “store ID” made up of numbers, a “store name” that stores the name of the store, and an “address” that stores the address of the store 3.

  The SKU data table 21 stores “SKU ID” made up of numbers, “product name” in which the name of the product is stored, and types such as size and color prepared for the product as units for dividing the product into SKUs. Field “SKU identifier” and “price” in which the price of the product at 1 SKU is stored.

  The user data table 22 includes a “user ID” composed of numbers, a “login ID” in which a login ID at the time of user authentication by the user authentication unit 12 is stored, and a “password” in which a password at the time of user authentication is stored. As a field. Incidentally, the user authentication unit 12 permits only the user whose login ID and password stored in the user data table 22 match to perform a totaling operation via the totaling unit 9 or a setting operation via the setting unit 11. (Allow login).

  FIG. 3A is an explanatory diagram of a sales data table, and FIG. 3B is an explanatory diagram of a periodic aggregation setting data table. The sales data table 23 includes a “sales ID” composed of numbers, a “store ID” in which the store ID in the store data table 19 of the store is stored for the purpose of indicating at which store the product is sold, “SKU ID” in which the SKU ID of the sold product in the SKU data table 21 is stored for the purpose of indicating specifically what the sold product is in the stock storage unit (SKU), and the product is sold “Sales time” in which the recorded time is stored as a field. That is, a many-to-one data relationship from the store data table 19 to the sales data table 23 is performed, and a many-to-one data relationship from the SKU data table 21 to the sales data table 23 is performed. ing.

  The periodic aggregation setting data table 24 is a store data table 19 of the store for the purpose of indicating the “periodic aggregation setting ID” consisting of numbers and the store for which the periodic aggregation setting processing is performed by the periodic aggregation setting means 17. The store ID of the store and the SKU ID in the SKU data table 21 of the product are stored for the purpose of indicating which of the regular storage target products is the stock storage unit (SKU). Field “SKU ID” and “type” in which type information indicating whether the product is stored as a sale product or a priority product is stored. That is, a many-to-one data relationship from the store data table 19 to the periodic aggregation setting data table 24 is performed, and a many-to-one data relationship from the SKU data table 21 to the periodic aggregation setting data table 24. Shipment is performed, and the setting of the periodic tabulation process is performed for each store and each stock storage unit.

  FIG. 4 is an explanatory diagram of a normal summary data table. The normal tabulation data table 26 is a store data table 19 of the store 3 for the purpose of indicating the “normal tabulation ID” consisting of numbers and which store 3 the result of the normal tabulation processing by the normal tabulation means 13 relates to. “Store ID” in which the store ID of the product 3 is stored, and the SKU ID in the SKU data table 21 of the product 3 are stored for the purpose of indicating which product the inventory result relates to in inventory storage unit. “SKU ID”, “sales number” that stores the number of sales of the product in this tabulation, “sales amount” that indicates the total sales amount of the product in this tabulation, and the time when this tabulation was performed It has a “total time” indicated by a total period (date) as a field.

  That is, a many-to-one data relationship from the store data table 19 to the normal total data table 26 is performed, and a many-to-one data relationship from the SKU data table 21 to the normal total data table 26 is established. The results of normal tabulation processing are stored and managed in store units and in stock storage units.

  FIG. 5A is an explanatory diagram of the periodic total data table, and FIG. 5B is an explanatory diagram of the temporary total data table. The periodic tabulation data table 27 is stored in the store data table 19 of the store 3 for the purpose of indicating to which store the “periodic tabulation ID” composed of numbers and the result of the periodic tabulation processing by the short-term tabulation means 13 are related. “SKU ID” in which the SKU ID in the SKU data table 21 of the product is stored for the purpose of indicating the “store ID” in which the store ID is stored and which product the aggregated result relates to in stock storage units. ”, The“ number of sales ”that stores the number of sales of the product in this tabulation, the“ sales amount ”that indicates the total sales amount of the product in this tabulation, and the time when this tabulation was performed It has a “counting time” indicated by a unit (one hour unit) as a field.

  That is, a many-to-one data relationship from the store data table 19 to the periodic aggregation data table 27 is performed, and a many-to-one data relationship from the SKU data table 21 to the periodic aggregation data table 27 is established. The results of the periodic tabulation process are stored and managed in store units and in stock storage units.

  The temporary data table 28 is a temporary data ID that is a number, and the user data table 22 of the user for the purpose of indicating which user the temporary data processing instruction by the short-term data collection means 13 is from. “Store ID” stored in the store data table 19 of the store 3 is stored for the purpose of indicating the “user ID” in which the user ID is stored and which store 3 is associated with the result of the temporary aggregation process. ID ”and“ SKU ID ”in which the SKU ID in the SKU data table 21 of the product 3 is stored for the purpose of indicating which product the inventory result is in the stock storage unit, and this product “Number of sales” that stores the number of sales in the aggregation, “Sales amount” that indicates the total sales amount of the product in this aggregation, and the time when this aggregation was performed in units of short-term aggregation period (one hour unit) ) As a field.

  That is, the many-to-one data relationship from the user database 22 to the temporary summary data table 28 is performed, and the many-to-one data relationship from the store data table 19 to the temporary summary data table 28 is performed. There is a many-to-one data relationship from the data table 21 to the temporary aggregation data table 28, and the results of the temporary aggregation processing are stored and managed in store units and in stock storage units.

  FIG. 6A is an explanatory diagram of a periodic aggregation setting screen, and FIG. 6B is an explanatory diagram of a temporary aggregation setting screen. For the information terminal 6 of the user who is permitted to log in by the user authentication unit 12, the periodic aggregation setting unit 17 displays the periodic aggregation setting screen 29, while the temporary aggregation setting unit 18 displays the temporary aggregation setting screen 31. .

  The periodic aggregation setting screen 29 is a homepage screen, and a store name input field 29a for selecting or describing a store name in order to input a store in the “store ID” of the periodic aggregation setting data table 24, The product name input field 29b for describing the product name of the product in the “SKU ID” of the periodic tabulation setting data table 24, the SKU identifier input field 29c for describing any of the SKU identifiers of the product, and the fields 29a and 29b described above. , 29c, an add button 29d for adding the information input to the periodic aggregation setting data table 24, and a delete button 29e for deleting the information input to each of the fields 29a, 29b, 29c from the periodic aggregation setting data table 24. ing.

  When the add button 29d is clicked, the periodic tabulation setting screen 29 obtains a store ID and SKU ID data set corresponding to the information input in the respective fields 29a, 29b, and 29c, and the data set is periodically tabulated. If the data set is not registered in the setting data table 24, the data set is stored in the periodic tabulation setting data table 24. If the data set is already registered, a notification to that effect is given by screen display or audio output.

  When the delete button 29e is clicked, the periodic tabulation setting means 17 obtains a store ID and SKU ID data set corresponding to the information input in the respective fields 29a, 29b, and 29c, and the data set is periodically tabulated. If the data set is registered in the setting data table 24, the data set is deleted from the periodic aggregation setting data table 24. On the other hand, if the data set is not registered, such data is not registered. Notification to that effect is performed by screen display or audio output.

  The temporary aggregation setting screen 31 is a homepage screen, and for a purpose determined by the store that performs the temporary aggregation processing, a store name input field 31a for selecting or describing a store name, and a temporary aggregation target product in an inventory storage unit, For the purpose of setting, the product name input field 31b describing the product name of the product to be aggregated, the SKU identifier input field 31c describing any of the SKU identifiers of the product, and the above-mentioned temporary aggregation target period are input. It has a period input field 31d and a totaling button 31e for executing a temporary totaling process based on the information input in the above fields 31a, 31b, 31c, 31d. By the way, in the period input field 31d, when the opening time is from 10:00 am, the temporary collection target period is input as “10:00 to 13:00” and “12:00 to 16:00”.

  When the aggregation button 31e is clicked, the temporary aggregation setting unit 18 instructs the short-term aggregation unit 14 of the aggregation unit 9 to start the temporary aggregation process at the store. It should be noted that the product name input field 31b may be input with a plurality of product names, and the SKU identifier input field 31c may be input with a plurality of SKU identifiers.

  FIG. 7 is a flowchart of the short-term aggregation process performed by the short-term aggregation means. When the short-term tabulation unit 14 starts the short-term tabulation process, the process proceeds to step S1. In step S1, the above-described periodic tabulation process subroutine is executed. When the subroutine process ends, the process proceeds to step S2. In step S2, the above-described temporary aggregation processing subroutine is executed, and when the subroutine processing ends, the processing returns to step S1. Incidentally, this short-term aggregation process is performed separately for each store.

  FIG. 8 is a flowchart of the subroutine for the periodic tabulation process. When the processing of the sub-routine for the periodic tabulation processing is started, the processing is started from step S11. In step S11, the count by the timer is detected, and it is checked whether or not the count by the timer has passed the short-term counting period (1 hour). If it has elapsed, the process proceeds to step S12. The processing of this subroutine is terminated.

  In step S12, the setting value at the target store is read from the periodic tabulation setting data table 24, and the process proceeds to step S13. In step S13, it is confirmed whether or not there is a periodic aggregation target product of the selected stock storage unit in the store. If there is a periodic aggregation target product in the store, the process proceeds to step S14, while If there is no periodic aggregation target product, the processing of this subroutine is terminated.

  In step S14, at the time of execution of the current subroutine, it is checked whether there is a periodic aggregation target product that has not yet been aggregated in the store. If there is a periodic aggregation target product that has not yet been aggregated, the process proceeds to step S15. In step S15, one periodic aggregation target product that has not yet been aggregated is specified, and the process proceeds to step S16.

  In step S16, for the specified periodic aggregation target product, the number of sales and total sales in the store are counted (POS information is aggregated) while the timer counts the short-term aggregation period (current short-term aggregation period). The process proceeds to step S17. In step S17, the aggregated result in step S16 is stored in the regular aggregated data table 27 with the number of sales as the number of sales and the total sales amount as the sales amount, and the process returns to step S14.

  In this step S14, when there is no periodic aggregation target product that has not yet been aggregated in the target store, the process proceeds to step S18. In step S18, the display unit 16 displays the total result display screen 32 (see FIG. 9) on the above-described user information terminal 6, and the process proceeds to step S19. In step S19, the timer is set to 0, restart processing for starting counting again is performed, and this subroutine processing is terminated. By such processing, the processing shown in steps S12 to S19 is executed every time the short-term aggregation period elapses.

  FIG. 9 is an explanatory diagram of a totaling result display screen displayed by the display unit. The tabulation result display screen 32 is a homepage screen visualized by WEB or the like, and shows a store name display field 32a indicating which store the tabulation result belongs to, and what product the tabulation result is. A product name display field 32b, an SKU identifier display field 32c indicating which SKU identifier of the product is related to the product, a display period field 32d for displaying a period, and a short period with the period as a horizontal axis A sales quantity change graph display field 32e for displaying a sales quantity change graph with the sales quantity for each aggregation period as a vertical axis, and a sales total quantity change graph with the period as a horizontal axis and the sales total for each short-term aggregation period as a vertical axis. It has a sales total amount change graph display field 32f to be displayed, a return button 32g, and an advance button 32h.

  Here, the period displayed in the display period column 32d is a period from the opening time of the day to which the short-term tabulation period that is the target of the tabulation result belongs to the short-term tabulation period. Thus, the tabulation result display screen 32 The range that can be displayed is after the opening time of the day, and the time width on the horizontal axis of the sales quantity change graph and the sales total change graph is the same as the period displayed in the display period column 32d.

  The return button 32g and the advance button 32h are clicked to switch the store displayed in the store name display field 32a, switch the product displayed in the product name display field 32b, and SKU displayed in the SKU identifier display field 32c. Switch identifiers. When these displays are switched, the display contents of the sales quantity change graph display column 32e and the display contents of the total sales change graph display column 32f are also switched in accordance with the switched contents. By viewing this display content, it becomes possible to flexibly formulate various management plans.

  The sales quantity of the SKU within the period displayed in the display period column 32d (specifically, the period from the opening time of the day to the latest short-term aggregation period) beside the sales unit change graph display column 32e. You may provide the total display column 32i which displays a total.

  FIG. 10 is a flowchart of a subroutine for temporary aggregation processing. When the processing of the temporary aggregation processing subroutine is started, the processing is started from step S21. In step S21, as described above, it is checked whether or not an instruction to start the temporary aggregation processing is issued from the temporary aggregation setting means 18 to the target store as described above. In step S22, if the instruction has not been issued, the processing of this subroutine is terminated.

  In step S22, the information of each input column 31a, 31b, 31c, 31d of the temporary aggregation setting screen 31 is read, and the process proceeds to step S23. In step S23, based on the information input in the input fields 31a, 31b, 31c, and 31d of the temporary aggregation setting screen 31, whether or not the same aggregation has been performed by the short-term aggregation unit 14 before. Is checked with reference to the contents of the periodic tabulation data table 27 and the temporary tabulation data table 28. If the same tabulation has not been performed before, the process proceeds to step S24.

  In step S24, it is detected whether or not the number of SKUs to be aggregated exceeds a predetermined value when performing the current aggregation process. If not, a certain load is instantaneously applied to the computer. Since this is not the case, the process proceeds to step S25.

  In step S25, aggregation is performed via the short-term aggregation means 14 based on information in the input fields 31a, 31b, 31c, 31d on the temporary aggregation setting screen 31, and the process proceeds to step S26. In step S26, the aggregation result in step S25 is stored in the temporary aggregation data table 28, and the process proceeds to step S27.

  In step S27, the totaling result in step S25 is displayed on the totaling result display screen 32 by the display means 16, and the processing of this subroutine is terminated. At this time, the period displayed in the display period column 32d of the aggregation result display screen 32 may be a temporary aggregation target period, or may be the total business hours at the store on the day to which the temporary aggregation target period belongs, or the temporary aggregation target It may be from the opening time of the store on the day to which the period belongs to the current temporary aggregation target period.

  In step S23, based on the information input in the input fields 31a, 31b, 31c, 31d of the temporary aggregation setting screen 31, it is confirmed that the same aggregation has been performed by the short-term aggregation means 14 before. If so, the process proceeds to step S28. In step S28, the aggregation result that has been performed before is read from the temporary aggregation data table 28, the process proceeds to step S27, and the read result is displayed on the aggregation result display screen 32 by the display means 16. In this way, it is possible to prevent the aggregation once performed from being performed again with the same content, thereby reducing the processing. In other words, the previous counting result can be referred again.

  In step S24, when the current counting process is performed, if the number of SKUs to be counted exceeds a predetermined value, the computer may be temporarily subjected to a certain load. Proceed to step S29. In step S29, a notification to that effect is given by screen display or voice, and the processing of this subroutine is terminated without performing aggregation. In this way, by setting an upper limit on the number of SKUs that are subject to aggregation, it is possible to prevent an unintended problem from occurring due to a temporary increase in load.

  In step S24, when the number of SKUs input in the SKU identifier input field 31 of the temporary aggregation setting screen 31 is less than a predetermined value or when the temporary aggregation target period is less than the predetermined period, Proceeding to step S25, when the value is larger than the predetermined value or longer than the predetermined period, the process may proceed to step S29, and this can also suppress a temporary load increase.

  FIG. 11 is a flowchart of the normal counting process performed by the normal counting means. This normal tabulation process is also performed separately for each store. The short-term counting means 13 starts the normal counting process when the one-day closing process at the target store is performed, and proceeds to step S31. In step S31, the totaling process by the normal totaling means 13 is performed using the business hours of the day at the target store as the normal totaling period, and the process proceeds to step S32.

  In step S32, the total result is stored in the normal total data table 26, and the process proceeds to step S33. In step S33, the total result is displayed on the total result display screen 32 by the display means 16, and the process is terminated. At this time, the period displayed in the display period column 32d of the aggregation result display screen 32 may be the week or month to which the normal aggregation period belongs.

  According to this information management system configured as described above, a product (SKU) that is periodically aggregated during a short-term aggregation period is set as a periodic aggregation target product (target SKU), and this is limited to a computer. It is easy to read small changes such as the sales situation in the store without applying an extra load.

  Note that this information management server may be provided with a statistical unit that statistically processes the aggregation results of the short-term aggregation unit 14 and the long-term aggregation unit 13 and sends various instructions to the store terminal 4 of each store. This makes it easy to automatically show each store a short-term vision and a medium- to long-term vision.

1 Information management server 2 Network (Internet, WAN)
3 Network (Internet, WAN)
4 store terminal 6 information terminal 7 POS information acquisition means (acquisition means)
8 Storage Device 9 Totaling Unit 11 Setting Unit 12 User Authentication Unit 13 Normal Totaling Unit (Totaling Unit)
14 Short-term counting means (counting means)
16 Display means 17 Periodic aggregation setting means 18 Temporary aggregation setting means 19 Store data table 21 SKU data table 22 User data table 23 Sales data table 24 Regular aggregation setting data table 26 Normal aggregation data table 27 Periodic aggregation data table 28 Temporary aggregation data table 29 Periodic tally setting screen (homepage screen)
29a Store name input field 29b Product name input field 29c SKU identifier input field 29d Add button 29e Delete button 31 Temporary tabulation setting screen (homepage screen)
31a Store name input field 31b Product name input field 31c SKU identifier input field 31d Period input field 31e Count button 32 Count result display screen (homepage screen)
32a Store name display field 32b Product name display field 32c SKU identifier display field 32d Display period field 32e Sales volume change graph display field 32f Total sales change graph display field 32g Return button 32h Advance button

Claims (14)

An acquisition unit that acquires POS information, a storage device that stores the acquired POS information, a totaling unit that totals the acquired or stored POS information, and a display unit that displays a totaling result by the totaling unit An information management system,
The counting means includes
A normal aggregation means for performing aggregation of POS information normally counting period is a predetermined period specified Me pre,
The aggregate of the POS information in short-term counting period of predetermined to be shorter than short and day than normal aggregation period and a row Cormorant short aggregator,
The storage device stores periodic aggregation target products selected from among the products to be sold,
The short-term counting means is:
Periodic aggregation means for automatically executing aggregation of POS information related to the periodic aggregation target product for each short-term aggregation period;
Temporary aggregation means for performing aggregation of POS information related to the temporary aggregation target product for the temporary aggregation target period under a predetermined condition when selection of the temporary aggregation target product and selection of the temporary aggregation target period are performed Have
The temporary aggregation means performs aggregation when the selection and the selection are performed, and the short-term aggregation means determines that the same aggregation has not been performed before . The periodic tabulation unit and the temporary tabulation unit each store a tabulation result in a predetermined data table,
The temporary aggregation means makes the determination with reference to the predetermined data table, and when it is determined that the short-term aggregation means has previously performed the same aggregation, the aggregation result at that time is used as the data Read from the table,
The information management system according to claim 1 , wherein the display unit displays the aggregation result read by the temporary aggregation unit . Regular aggregate Shipping claim 1 or claim 2 Information management system according provided regular aggregate setting means for setting to previously stored in the storage device. The temporary aggregation means performs the aggregation when the number of aggregation objects does not exceed a predetermined value, and informs the user when the number of aggregation objects exceeds a predetermined value. information management system according to any one of claims 1 to 3 which does not perform the aggregation and. In addition to selecting products subject to temporary aggregation from products other than those subject to periodic aggregation, a temporary aggregation setting means is provided to select one or more time periods for aggregation for each short-term aggregation period and set it as the temporary aggregation target period.
The temporary totalization means, said selected a temporary aggregate aggregation Shipping POS information on, the information management system according to any one of claims 1 to 4 performed on said selected temporary totalization period . The information management system according to any one of claims 1 to 5, wherein the periodic aggregation target product and the temporary aggregation target product are selected in SKU units. The information management system according to any one of claims 1 to 6, wherein the normal period is set to business hours per day at a store and the short-term aggregation period is set to 1 hour. An information management program for acquiring POS information, storing the acquired POS information in a storage device, and executing a totaling process for totaling the acquired or stored POS information and a display process for displaying a totaling result by the totaling means Because
In a computer with a storage device,
As the aggregation process,
Usually a row Cormorant normal aggregation process aggregations for POS information counting period is a predetermined period specified Me pre,
Normal aggregation POS information short counting period of predetermined to be shorter than short and day than the total period to execute a row Cormorant short-term aggregation process,
The storage device stores periodic aggregation target products selected from among the products to be sold,
In the short-term aggregation process,
Periodic aggregation processing for automatically executing the aggregation of POS information related to the periodic aggregation target product for each short-term aggregation period;
Temporary tabulation processing for totaling POS information related to the temporary tabulation target product for the temporary tabulation target period under a predetermined condition when selection of the temporary tabulation target product and selection of the temporary tabulation target period are performed. And execute
In the temporary aggregation process, an information management program for executing a process of performing aggregation when it is determined that the short-term aggregation process has not previously performed the same aggregation when the selection and the selection are performed . In each of the periodic aggregation process and the temporary aggregation process, the aggregation result is stored in a predetermined data table,
In the temporary aggregation process, the determination is made with reference to the predetermined data table, and when it is determined that the same aggregation has been performed before in the short-term aggregation process, the aggregation result at that time is Read from the data table,
9. The information management program according to claim 8 , wherein in the display process, a process for displaying a totaling result read in the temporary totaling process is executed. The information management program according to claim 8 or 9, for executing a periodic aggregation setting process for setting a periodic aggregation target product to be stored in advance in a storage device. In the temporary aggregation process, the aggregation is performed when the number of aggregation objects does not exceed a predetermined value, and when the number of aggregation objects exceeds a predetermined value, the user is notified of that. The information management program according to any one of claims 8 to 10 , for executing a process that does not perform the aggregation . In addition to selecting products that are temporarily aggregated from products other than those that are subject to periodic aggregation, you can select one or more aggregation target hours for each short-term aggregation period and execute the temporary aggregation setting process for the temporary aggregation target period.
Any said at an extraordinary aggregation process, the aggregation POS information regarding temporary totalization Shipping which is said selected among claims 8 to execute the processing to be performed on said selected temporary totalization period of Claim 11 Information management program described in Crab. The information management program according to any one of claims 8 to 12, for executing a process of selecting a regular aggregation target product and a temporary aggregation target product in SKU units. The information according to any one of claims 8 to 13, wherein the normal period is set to a business hour per day at a store and the short-term aggregation period is set to 1 hour. Management program.

Images