JP2007233518A - Server device and control program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To improve the sales management standard of perishable foods and highly perishable merchandise in a food supermarket. <P>SOLUTION: This server device is provided with a communication interface (101a) for receiving production data to be transmitted from a measuring and pricing unit (102), and for receiving sales data to be transmitted from a POS terminal (103); a data preparation part (101b) for preparing data showing sales floor display status based on the received production data and sales data; and a storage part (101c) for storing the data showing the prepared sales floor display status so that the data can be displayed on a display or printed by a printer. The data preparation part (101b) calculates a freshness value showing the freshness of the merchandise group or the sales floor as data showing the sales floor display status based on the time elapsed from when each merchandise is produced. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a server apparatus that manages the display status, production quantity, production period, discount period, and disposal period of merchandise sold at a store, and a control program therefor.

  2. Description of the Related Art Conventionally, there is known a technique for identifying individual products sold at a store as individuals, managing the products, and analyzing sales. For example, Japanese Unexamined Patent Application Publication No. 2004-110964 discloses the following product sales system. That is, a barcode including an individual identifier for identifying each product as an individual in the product pricing device is attached to each product, and the product code, product name, etc. of each product are stored in the product database in association with the individual identifier. To do. When the POS register reads the barcode attached to the product, the POS register makes an inquiry to the store computer based on the individual identifier included in the barcode. The store computer searches the product database, returns the product name, price, etc. to the POS register, and stores the date of sale etc. in the product database.

  Japanese Patent Application Laid-Open No. 7-325872 discloses a simple method based on a provisional freshness management standard in which freshness standard information for each product indicated by an elapsed period from the date of manufacture is stored in advance and indicated by a date based on the arrival date. An inventory freshness management device that performs management in a freshness management mode is disclosed. This inventory freshness management device issues a warning when inventory exceeding the provisional freshness management standard occurs, registers the date of manufacture when there is a warning, and switches to management in the strict freshness management mode.

Further, Japanese Patent Laid-Open No. 5-158955 discloses a merchandise management apparatus that performs asset management and inventory management of merchandise (food) whose merchandise value changes depending on the manufacturing date and time. This merchandise management apparatus inputs initial information related to merchandise such as a merchandise code and manufacturing date in a batch by the information input means, and sequentially updates the initial information and time limit information indicating the passage of time by the information updating means. Based on the updated initial information and deadline information, the deadline management means calculates the current value for each inventory item. Further, the external device control means prompts the external device to move the inventory product whose value has been lost, and the asset information including the quantity information of the moved product is managed by the asset management means.
Japanese Patent Application Laid-Open No. 2004-110964 JP-A-7-325872 JP-A-5-158955

  In general, food supermarkets are considered to be a business area with growth potential, but the reality is that competition is intensifying, as can be seen in large-scale store openings and mergers between companies. is there. Since supermarkets are considered to be community-based businesses, it is essential to strengthen competitiveness at each store. In particular, the most important point for obtaining customer support is thought to be differentiation from other companies by improving sales management technology for fresh foods and high-freshness products.

  This invention is made in view of such a situation, and it aims at providing the server apparatus which can improve the sales management level of the fresh food and high freshness goods in a food supermarket, and its control program. .

  (1) In order to achieve the above object, the present invention takes the following measures. That is, the server device according to the present invention is a server device that manages the display status, the production quantity, the production time, the discount time, and the disposal time of the products sold in the store, and is in the area where the products are produced. Product data output from the weighing pricer when the provided weighing pricer affixed the identification label to the product was input, while the product displayed on the sales floor and with the identification label affixed was sold An input / output interface for inputting sales data output from the POS terminal when the POS terminal recognizes the data, and a data creation unit for creating data indicating sales floor display status based on the input production data and sales data; A storage unit that stores the data indicating the created sales floor display state in a state where the data can be displayed on a display or can be printed by a printer. Data creation unit, on the basis of the time elapsed from the time at which each product was produced, the freshness value indicating the freshness of the product group or department, is characterized by calculating the data indicating the sales floor display status.

  In this way, based on the elapsed time from the time each product was produced, the freshness value indicating the freshness of the product group or sales floor is calculated as data indicating the sales floor display status and can be displayed on a display or printed by a printer. Therefore, the state of freshness of the product group or the sales floor can be made visible (visualization) by printing on a display or printer at the work site. As a result, the management level of fresh foods and high freshness products can be improved. In addition, when inputting the production data output from the weighing pricer and the sales data output from the POS terminal to the input / output interface, the weighing pricer and the POS terminal are connected to the input / output interface via a communication network, The production data and sales data may be transmitted and received online, and the production data output from the weighing pricer is recorded on an IC tag attached to the product without using a communication network, and the product is stored in the store. The production data may be read from the IC tag when is received.

  (2) The server device according to the present invention is a server device that manages the display status, production quantity, production time, discount time, and disposal time of products sold at a store, The product that is displayed on the sales floor and has the identification label attached is sold while the weighing price provided in the area to which the product is attached inputs the production data output from the measurement price applier when the identification label is attached to the product. Input / output interface for inputting the sales data output from the POS terminal when the POS terminal recognizes that it has been performed, and data for creating data indicating the sales floor display status based on the input production data and sales data A creation unit; and a storage unit that stores data indicating the created sales floor display status in a state that can be displayed on a display or can be printed by a printer, and When the number of items displayed on the sales floor falls below a predetermined minimum number of displays, the data creation unit falls below the minimum number of displays from the average number of sales during a time period that does not fall below the minimum number of displays. At least one of the opportunity loss number, which is the difference in the actual number of sales in the time zone, or the opportunity loss amount, which is the average sales price obtained by dividing the sales price by the number of sales, multiplied by the number of opportunity losses, It is calculated as data indicating the sales floor display status.

  In this way, when the number of items displayed on the sales floor is below the predetermined minimum number of displays, the actual number of items sold in the time period that is below the minimum number of displays from the average number of sales in the time period that is not below the minimum number of displays. At least one of the opportunity loss number, which is the difference in the number of sales, or the average sales amount obtained by dividing the sales amount by the number of sales, multiplied by the number of opportunity losses, Since it is calculated as data to be displayed and stored in a state where it can be displayed on a display or printable on a printer, it is possible to visually check the display status of a product group or sales floor by printing on a display or printer at the work site. It can be made ready (visualization). As a result, it is possible to avoid out-of-stock of products that the store wants to sell or sell, and improve sales. Thereby, the management level of a merchandise group and a sales floor can be improved. In addition, when inputting the production data output from the weighing pricer and the sales data output from the POS terminal to the input / output interface, the weighing pricer and the POS terminal are connected to the input / output interface via a communication network, The production data and sales data may be transmitted and received online, and the production data output from the weighing pricer is recorded on an IC tag attached to the product without using a communication network, and the product is stored in the store. The production data may be read from the IC tag when is received.

  (3) The server device according to the present invention is a server device that manages the display status, production quantity, production period, discount period, and disposal period of merchandise sold at a store. The product that is displayed on the sales floor and has the identification label attached is sold while the weighing price provided in the area to which the product is attached inputs the production data output from the measurement price applier when the identification label is attached to the product. Input / output interface for inputting the sales data output from the POS terminal when the POS terminal recognizes that it has been performed, and data for creating data indicating the sales floor display status based on the input production data and sales data A creation unit; and a storage unit that stores data indicating the created sales floor display status in a state that can be displayed on a display or can be printed by a printer, and The data creation unit registers, as a parameter, a discount rate for the discount work time for each sales period of the product based on a predetermined store discount rule, and before and after the discount of the product displayed on the sales floor A discount work amount is calculated as data indicating the sales floor display status from the after-sale price and the number of products.

  In this way, based on a predetermined store discount rule, register the discount rate for the discount work time for each sales period of the product as a parameter, before and after the discount of the product displayed on the sales floor The discount work amount is calculated from the selling price and the number of products as data indicating the sales floor display status, and is stored in a state that can be displayed on a display or printable on a printer. By this, it is possible to make it possible to visually see how much the discounting work is in the product group or the sales floor as a numerical value (visualization). Thereby, the management level of a merchandise group and a sales floor can be improved. In addition, when inputting the production data output from the weighing pricer and the sales data output from the POS terminal to the input / output interface, the weighing pricer and the POS terminal are connected to the input / output interface via a communication network, The production data and sales data may be transmitted and received online, and the production data output from the weighing pricer is recorded on an IC tag attached to the product without using a communication network, and the product is stored in the store. The production data may be read from the IC tag when is received.

  (4) Further, in the server device according to the present invention, the production data includes location data for specifying a location to be displayed in a store, and the data creation unit is configured to execute the display according to the display location. It is characterized by creating data indicating sales floor display status.

  As described above, the production data includes the location data for specifying the location to be displayed in the store, and the data indicating the sales floor display status is created according to the display location. When displayed at a place, the display status and sales status for each sales floor become visible and can be easily grasped.

  (5) Further, in the server device according to the present invention, the data creation unit creates the data indicating the sales floor display status so that the data can be displayed as a numerical value or a graph.

  Thus, since the data indicating the sales floor display status, for example, the freshness value, the number of opportunity losses, the opportunity loss amount, or the discount work amount can be displayed as a numerical value or a graph, it is displayed on a display or printed by a printer. By this, it becomes possible to grasp easily with eyes.

  (6) Moreover, the control program according to the present invention is a control program for a server device that manages the display status, production quantity, production time, discount time, and disposal time of goods sold in a store, In the input / output interface, when the weighing price provided in the product production area affixes the identification label to the product, the process of inputting the production data output from the weighing pricer, and in the input / output interface, Based on the process of inputting the sales data output from the POS terminal when the POS terminal recognizes that the product displayed on the sales floor and having the identification label attached is sold, and the input production data and sales data In the data creation unit, based on the elapsed time from the time each product was produced, the freshness value indicating the freshness of the product group or sales floor Processing for calculating as a part of the data indicating the sales floor display status, and processing for storing in the storage unit the data indicating the generated sales floor display status in a state that can be displayed on a display or printable on a printer. A series of processes are converted into commands that can be read and executed by a computer.

  In this way, based on the elapsed time from the time each product was produced, the freshness value indicating the freshness of the product group or sales floor is calculated as data indicating the sales floor display status and can be displayed on a display or printed by a printer. Therefore, the state of freshness of the product group or the sales floor can be made visible (visualization) by printing on a display or printer at the work site. As a result, the management level of fresh foods and high freshness products can be improved. In addition, when inputting the production data output from the weighing pricer and the sales data output from the POS terminal to the input / output interface, the weighing pricer and the POS terminal are connected to the input / output interface via a communication network, The production data and sales data may be transmitted and received online, and the production data output from the weighing pricer is recorded on an IC tag attached to the product without using a communication network, and the product is stored in the store. The production data may be read from the IC tag when is received.

  (7) A control program according to the present invention is a control program for a server device that manages the display status, production quantity, production period, discount period, and disposal period of goods sold in a store, In the input / output interface, when the weighing price provided in the product production area affixes the identification label to the product, the process of inputting the production data output from the weighing pricer, and in the input / output interface, Based on the process of inputting the sales data output from the POS terminal when the POS terminal recognizes that the product displayed on the sales floor and having the identification label attached is sold, and the input production data and sales data In the data creation unit, if the number of items displayed on the sales floor falls below a predetermined minimum number, the minimum number is displayed. To the average sales amount obtained by dividing the sales amount by the number of sales, or the opportunity loss number that is the difference between the actual sales number in the time zone that is below the minimum number of displays from the average number of sales in the time period that is not Processing for calculating at least one of the opportunity loss amounts, which is an amount multiplied by the number of opportunity losses, as a part of the data indicating the sales floor display status, and the storage section displaying data indicating the created sales floor display status A series of processes including a process of storing in a state that can be displayed or printed by a printer is converted into a command that can be read and executed by a computer.

  In this way, when the number of items displayed on the sales floor falls below the predetermined minimum number of displays, the actual sales in the time period when the average number of sales in the time period not falling below the minimum number of displays is below the minimum number of displays At least one of the opportunity loss number, which is the difference in the number of sales, or the average sales amount obtained by dividing the sales amount by the number of sales, multiplied by the number of opportunity losses, Since it is calculated as data to be displayed and stored in a state where it can be displayed on a display or printable on a printer, it is possible to visually check the display status of a product group or sales floor by printing on a display or printer at the work site. It can be made ready (visualization). As a result, it is possible to avoid out-of-stock of products that the store wants to sell or sell, and improve sales. Thereby, the management level of a merchandise group and a sales floor can be improved. In addition, when inputting the production data output from the weighing pricer and the sales data output from the POS terminal to the input / output interface, the weighing pricer and the POS terminal are connected to the input / output interface via a communication network, The production data and sales data may be transmitted and received online, and the production data output from the weighing pricer is recorded on an IC tag attached to the product without using a communication network, and the product is stored in the store. The production data may be read from the IC tag when is received.

  (8) Further, the control program according to the present invention is a control program for a server device that manages the display status, production quantity, production time, discount time, and disposal time of products sold in a store, In the input / output interface, when the weighing price provided in the product production area affixes the identification label to the product, the process of inputting the production data output from the weighing pricer, and in the input / output interface, Based on the process of inputting the sales data output from the POS terminal when the POS terminal recognizes that the product displayed on the sales floor and having the identification label attached is sold, and the input production data and sales data In the data creation unit, the discount rate with respect to the work time for each sales period of the product is parameterized based on a predetermined store discount rule. In the storage unit, a process for calculating the discount work amount as data indicating the sales floor display status from the sales price and the number of products before and after the discount of the products displayed on the sales floor A series of processes including storing the created sales floor display data in a state where it can be displayed on a display or printable by a printer, has been converted into a command that can be read and executed by a computer. .

  In this way, based on a predetermined store discount rule, register the discount rate for the discount work time for each sales period of the product as a parameter, before and after the discount of the product displayed on the sales floor The discount work amount is calculated from the selling price and the number of products as data indicating the sales floor display status, and is stored in a state that can be displayed on a display or printable on a printer. By this, it is possible to make it possible to visually see how much the discounting work is in the product group or the sales floor as a numerical value (visualization). Thereby, the management level of a merchandise group and a sales floor can be improved. In addition, when inputting the production data output from the weighing pricer and the sales data output from the POS terminal to the input / output interface, the weighing pricer and the POS terminal are connected to the input / output interface via a communication network, The production data and sales data may be transmitted and received online, and the production data output from the weighing pricer is recorded on an IC tag attached to the product without using a communication network, and the product is stored in the store. The production data may be read from the IC tag when is received.

  (9) Further, in the control program according to the present invention, the production data includes location data for specifying a location to be displayed in a store, and the data creation unit determines the sales floor according to the display location. It includes a process for creating data indicating the display status.

  As described above, the production data includes the location data for specifying the location to be displayed in the store, and the data indicating the sales floor display status is created according to the display location. When displayed at a place, the display status and sales status for each sales floor become visible and can be easily grasped.

  According to the present invention, since the display status and sales status of the sales floor can be made visible (visualization), product freshness management, opportunity loss reduction, discount and disposal loss reduction, work The accuracy can be improved. In addition, it is possible to grasp a work omission and an operation error of a person in charge at the site. In addition, since it is possible to avoid the out of stock of products that the store wants to sell or sell, it is possible to improve sales. Furthermore, since it is possible to reduce unsold items for products other than products to be sold, it is possible to reduce disposal loss.

  Next, embodiments of the present invention will be specifically described with reference to the drawings. FIG. 1 is a block diagram showing a schematic configuration of a product management system according to the present embodiment. The merchandise management system 100 manages the display status, production quantity, production period, discount period, and disposal period of merchandise sold at a store in the fresh individual management server 101. The fresh individual management server 101 includes an input / output interface 101a, a data creation unit 101b, and a storage unit 101c. The input / output interface 101a outputs and inputs data. For example, the production data output from the weighing price device 102 and the sales data output from the POS terminal 103 are input. The data creation unit 101b creates data indicating the sales floor display status based on the production data and sales data input by the input / output interface 101a. The storage unit 101c stores data indicating the sales floor display status created by the data creation unit 101b in a state where it can be displayed on a display or can be printed by a printer.

  The weighing / pricing device 102 is provided in an area for producing a product, attaches an identification label (individual identification label) to the product, and outputs production data to the fresh individual management server 101. Further, the POS terminal 103 surrounded by a dotted line in FIG. 1 includes a POS cash register 103a and a POS server 103b, and recognizes that a product displayed on the sales floor has been sold by reading the identification label. Then, when the POS terminal 103 recognizes the identification label, the sales data is output to the fresh individual management server 101. The kitchen printer 104 prints the instructed data, for example, data stored in the storage unit 101c of the fresh individual management server 101 on a paper medium, and the client PC 105 is stored in the storage unit 101c of the fresh individual management server 101. The data is displayed on the screen, and the data of the weighing price device 102 and the kitchen printer 104 is managed. The above constituent elements are connected by a LAN 106 and can exchange data with each other.

  In FIG. 1, a portion surrounded by a dotted line A is set for each department such as a beet department, a livestock department, a fishery department, and an agricultural department in the supermarket.

  FIG. 2 is a diagram illustrating a data flow of the product management system according to the present embodiment. For example, in the case of the livestock sector, the weighing pricer 102 measures the price by weighing the cut and packed steak meat. At this time, for example, a two-level bar code 200 that functions as an individual identification label is affixed to the steak meat pack, and the packed product 201 is completed. On the other hand, the weighing price device 102 outputs the production data D1 indicating the contents of the weighing value weighed as described above, the price at which the price was given, the date of manufacture, the product name, etc. to the fresh individual management server 101 ( Step S1). The fresh individual management server 101 may input the production data D1 every 15 minutes, for example.

  In the fresh individual management server 101, the production data is updated with the latest production data D1 input from the weighing price assigner 102 (step S2), and stored in the fresh individual database group as the storage unit 101c.

  On the other hand, when the POS cash register 103a and the POS server 103b recognize that the packed product 201 is sold, the POS server 103b sells information indicating the product name, date of sale, measurement value, price, and the like of the packed product 201. The data D2 is output to the fresh individual management server 101 (step S3). The fresh individual management server 101 may input the sales data D2 every 15 minutes, for example.

  The fresh individual management server 101 updates the sales data with the latest sales data D2 input from the POS server 103b (step S4), and stores it in the fresh individual database group as the storage unit 101c.

  Next, the fresh individual management server 101 displays the freshness status of the merchandise displayed on the sales floor (step S5). Here, in the merchandise management system according to the present embodiment, the concept of freshness is defined as follows. That is, the elapsed time from the time produced by the weighing price device 102 to the present time is expressed using a numerical value called a freshness value (Fr value). That is, the freshness value indicates the freshness of the product. This makes it possible to clearly display the freshness that decreases with the passage of time using a numerical value called a freshness value. Thereby, the freshness of each product is clearly grasped.

  (A) The freshness of each product is visualized as the numerical value called the freshness value (Fr value) from the time when the product is produced by the weighing price unit 102 to the current time for each product.

(B) A plurality of displayed products are regarded as a product group, and the freshness of the product group unit is visualized as a freshness value. The freshness of the product group can be expressed by Equation (1).

(C) A plurality of displayed products are regarded as a sales floor (department), and the freshness of the sales floor is visualized as a freshness value. The products sold in the department include products having a plurality of sales deadlines (for example, the sales deadline is the same day, 2 days, 3 days, etc.), and it is necessary to manage the freshness according to the sales deadlines. The freshness value is used for this purpose. The freshness of the sales floor can be expressed by Equation (2).

  FIG. 3 is a diagram showing the production time, sales time, and freshness value of each product. At 10 o'clock, five products were produced as the first product group. Of the first product group, the first one was sold at 11:30 and the next one was sold before 13:00. And the next one was sold after 15:00. Two are unsold at 18:00. At 14:00, five products were produced as the second product group. Of the second product group, the first one is sold at 15:30, the next one is at 16:30, the next one is before 17:00, the next one is sold after 17:00 It was done. And one item remains unsold at 18:00.

  Since two products that are unsold in the first product group have passed 9 hours from the production time, the freshness value of each product is 9 Fr. In addition, since one product that has not been sold in the second product group has passed 4 hours from the production time, the freshness value of the product is 4 Fr.

Next, the freshness value as the product group is calculated according to the above formula (1).
(9 + 9 + 4) Fr / 3 = 7.3Fr
Can be obtained as Then, this Fr value is displayed on the client PC 105. Thereby, the person in charge can clearly and easily grasp the freshness of each product, product group, and sales floor.

  In FIG. 2, the display freshness status graph 202 is displayed on the client PC 105 by the display freshness status display in step S5. The display freshness status graph 202 is displayed, for example, as shown in FIG. On the left side of FIG. 4, a transition graph of freshness values at the time of completion of sales floors by day and by sales period is shown. In addition, on the right side of FIG. 4, a transition graph of freshness values in each time zone for each sales period on the day is shown. Here, for example, a transition graph in which the sales period is 3 days, a transition graph in which the sales period is 2 days, and a transition graph in which the sales period is only the current day are shown. Thereby, the transition of the freshness value is clearly shown to the person in charge.

  Next, the fresh individual management server 101 performs various analysis processing steps S6 and various instruction processing steps S7 shown in FIG. First, opportunity loss will be described. Conventionally, it has been determined that there has been a missed sale (opportunity loss) because there are no products on the sales floor or shelves in the store. With this judgment method, it was not possible to grasp how much sales were missed and the amount of money. In the present embodiment, a table and a graph display what kind of merchandise has been sold and how much sales have been missed.

  The number of opportunity losses is defined as follows: In other words, if the number of items displayed on the sales floor falls below the predetermined minimum number of displays, actual sales during the time period when the average number of sales during the time period not falling below the minimum number of displays is below the minimum number of displays The difference in number is the number of opportunity losses.

When the opportunity loss is represented in a table, the number of opportunity losses is calculated by the following equation (3).
(Number of lost opportunities) = (Average number of sales) x (Number of hours below the minimum number of displays)-(Number of sales in the time zone below the minimum number of displays) (3)

  The opportunity loss amount is defined as follows. That is, an amount obtained by multiplying the average sales amount by the number of opportunity losses is defined as an opportunity loss amount.

When the opportunity loss amount is expressed in a table, the opportunity loss amount is calculated by the following equation (4).
(Opportunity loss amount) = (Average sales amount) × (Number of opportunity loss) (4)

Here, the average number of sales is calculated by the following equation (5).
(Average number of sales) = (Number of sales during the time period when the number of product display is the minimum number or more) ÷ (Number of hours during the time when the number of the product display is the minimum number or more) (5)

The average sales amount is calculated by the following formula (6).
(Average sales amount) = (Sales amount) ÷ (Number of sales) (6)

When the opportunity loss is represented by a graph, the number of opportunity losses is calculated and displayed by the following formula (7) for each time when the number of merchandise display falls below the minimum number of displays.
(Average number of sales)-(Number of sales) (7)

The average number of sales is calculated and displayed by the following formula (8).
(Number of sales in the time zone when the number of product display is more than the minimum number of display) ÷ (Number of hours in the time zone where the number of product display is more than the minimum number of display) (8)

  For example, as shown in FIG. 5, the average number of sales and the minimum number of displays are indicated by dotted lines parallel to the horizontal axis. In addition, since the number of items displayed is below the minimum number at 13:00, 14:00, 19:00, and 20:00, the number of opportunity losses is indicated by a white bar graph so as to be stacked on the bar graph of the number of sales. This graph is displayed as the opportunity loss analysis 203 in the client PC 105 in FIG.

  In addition, the fresh individual management server 101 performs a production / preparation instruction 204 to the client PC 105 as various instruction processes (step S7) based on the number of opportunity losses and the opportunity loss amount analyzed in this way. Since the production / preparation instruction 204 is displayed on the display of the client PC 105, the person in charge can quickly perform production and preparation.

  In this way, when the number of items displayed on the sales floor is less than the predetermined minimum number of items, the fresh individual management server 101 determines the minimum number of items from the average number of items sold during the time period that is not less than the minimum number of items. At least the opportunity loss number, which is the difference in the actual number of sales in the time period below, or the opportunity loss amount that is the average sales amount obtained by dividing the sales amount by the number of sales multiplied by the number of opportunity losses One of them is calculated as data indicating the sales floor display status and displayed on the display of the client PC 105, so that the display status of the product group or sales floor can be made visible (visualization). As a result, it is possible to avoid out-of-stock of products that the store wants to sell or sell, and improve sales. Thereby, the management level of a merchandise group and a sales floor can be improved.

  Next, the discount loss analysis 205 and the discount instruction screen 206 will be described in various analysis processing steps S6 and various instruction processing steps S7 shown in FIG. The fresh individual management server 101 according to the present embodiment registers a discount rate with respect to a discount work time for each sales period of a product as a parameter based on a predetermined store or company discount rule, and is displayed on the sales floor. The amount of discount work is calculated as data indicating the sales floor display status from the sales price and the number of products before and after the discount of the merchandise being sold.

  Here, in this embodiment, a numerical value called a discount work amount is used. This discount work amount is a numerical value that includes the number of target products, their sales amount, and the discount amount based on individual discounted products based on discount rules predetermined by the store or company. is there. Also, if the product once discounted is unsold and offers a further discount (for example, a 30% discount sticker on a 20% discount seal), the discount amount is The difference is calculated and displayed. In other words, it expresses numerically how much discount work will be discounted.

  FIG. 6 is a diagram showing an example of the discount instruction screen 206 displayed on the display of the client PC 105 shown in FIG. The upper side of FIG. 6 shows a state in which an instruction for discounting is given because it is 18:30. An instruction screen is displayed at the discount work time based on a discount rule determined in advance at the store or company, and further red to call attention. Information on discount work is displayed on the lower side of FIG. For example, as the displayed product information, the number of products of the displayed product, the initial set selling price of the displayed product, and the like are displayed. Further, as discount work information, the number of products to be discounted according to the discount rule ("discounted pack number" in FIG. 6), the discount amount to be discounted according to the discount rule, the display price after discount, and the like Is displayed. In addition, as a discount rate, a value obtained by calculating (discount amount to be discounted this time) / (initially set selling price of displayed product) is displayed.

  Conventionally, only the discount amount and the value argument amount at the time of sale could be grasped. Therefore, it was impossible to grasp how much discount work (amount and quantity) was performed. According to the merchandise management system according to the present embodiment, it is possible to grasp the discount work and the discount work efficiency from the discount data at the point of sale.

As the discount loss analysis 205 in the various analysis processes S6 in FIG. 2, the discount work accuracy can be analyzed as shown in FIG. It is possible to display and grasp whether the discount work is being performed according to a discount rule determined in advance at the store or company. As shown in FIG.
(1) I gave a discount instruction but did not give a discount.
(2) The discount rate was too small for the discount instruction.
(3) Discounted at the same discount rate as the discount instruction.
(4) The discount rate was too large for the discount instruction.
(5) Since it is displayed in a list that the price has been discounted without any discount instruction, it is possible to easily grasp the work accuracy.

  FIG. 8 is a diagram illustrating a state in which different sales floor codes are attached when the same product is displayed in a plurality of sales floors. Conventionally, when a certain product A is displayed at two locations of the sales floor 01 and the sales floor 02, it has not been known to grasp which sales floor the product displayed is sold. In this embodiment, when weighing / packaging (production) is performed by the weighing price device 102, a sales floor code indicating which sales floor the product is displayed is attached.

  As described above, the production data output from the weighing price device 102 to the freshness management server 101 includes location data for specifying the place to be displayed in the store. Data indicating the sales floor display status is created according to the situation. Thereby, when the same product is displayed in a plurality of places, the display status and the sales status for each sales floor become visible, and can be easily grasped.

  In addition, the merchandise management system 100 shown in FIG. 2 has functions of a discard loss analysis 207 and a discard instruction screen 208 as various analysis processes (step S6) and various instruction processes (step S7). As a result, it is possible to specifically instruct the disposal of the product whose sales deadline expires. It is also possible to confirm the status of disposal work.

  Further, error label registration (step S8) can be performed from the error label input screen 209 of the client PC 105. Furthermore, parameter registration (step S9) can be performed from the parameter input screen 211 of the client PC 105.

  Further, the data stored in the fresh individual database group 103c by the fresh individual management server 101 can be extracted as output data (step S10), and the output data D3 is output by the output process (step S11). Can be output to an external device.

  (Application examples)

  FIG. 9 is a diagram showing a data flow between the main store and the child store. In the field of fresh foods, in order to improve production efficiency at each store, we have adopted a method in which some products are produced in batches at the main store and delivered to each store (child store). There are companies. In order to correspond to such a method, the present invention can also adopt a configuration as shown in FIG. That is, the fresh individual management server 101 installed in the child store is connected to the weighing price device 901 in the mother store 900 via the communication network 902, and the production data D4 is output from the weighing price device 901 to the fresh individual management server 101. It is. The fresh individual management server 101 performs the input process of the production data D4 (step S90), and updates the production data with the latest production data D4 (step S91). The updated production data D4 is stored in the fresh individual database group 103c.

  On the other hand, in the main store 900, when the weighing pricer 901 packs and prices the product, the location code of the weighing pricer is used as the store number, the production data D4 is distributed, and the perishable individual of the corresponding child store is assigned. Output to the management server 101. The packed product 903 produced by the weighing pricer 901 is delivered to the child store by the truck 904. The fresh individual management server 101 performs inspection processing upon receipt of goods (step S92), updates inspection data with the latest inspection data D5 (step S93), and stores the updated inspection data D5 in the fresh individual database group 103c.

  It should be noted that the sales outlet display status of the child store may be analyzed or displayed on the terminal device of the main store. Further, an order-less system can be constructed by making it possible to check the product display status at the child store at the main store. On the other hand, at the child store, it is only necessary to focus on selling out the delivered product, which greatly reduces the work load.

  On the other hand, this invention can also take the structure which replaced said main store with the process center. At this time, in order to send data from the process center to the fresh individual management server of the store, both may be connected via a communication network as in the case of the main store child store. Further, without using a communication network, an IC tag may be attached to a product and production data may be transferred to a fresh individual management server.

  As described above, according to the product management system according to the present embodiment, the display status and sales status of the sales floor can be made visible (visualization). Reduction, discount and disposal loss, and improvement of work accuracy. In addition, it is possible to grasp a work omission and an operation error of a person in charge at the site. In addition, since it is possible to avoid the out of stock of products that the store wants to sell or sell, it is possible to improve sales. Furthermore, since it is possible to reduce unsold items for products other than products to be sold, it is possible to reduce disposal loss.

  The characteristic operations of the present invention as described above are performed by executing a control program. In other words, this control program is a control program for a server device that manages the display status, production quantity, production time, discount time, and disposal time of goods sold in a store. A process for inputting production data output from the weighing price device 102 when the weighing price device 102 provided in the product production area affixes an identification label to the product, Based on the process of inputting sales data output from the POS terminal 103 when the POS terminal 103 recognizes that the product displayed and affixed with the identification label is sold, and the input production data and sales data In the data creation unit 101b, based on the elapsed time from the time each product is produced, Processing for calculating a freshness value indicating the freshness of a group or a sales floor as a part of data indicating the sales floor display status, and display of the data indicating the created sales floor display status in the storage unit 101c or a printer And a process of storing in a printable state with a computer that is converted into a command that can be read and executed by a computer. Thereby, it can be made into the state which can see the condition of the freshness of a goods group or a sales floor visually (visualization).

  The control program according to the present invention is a control program for a server device that manages the display status, production quantity, production period, discount period, and disposal period of goods sold in a store, and includes an input / output interface. In 101a, in the input / output interface 101a, a process for inputting production data output from the weighing price device 102 when the weighing price device 102 provided in the product production area affixes an identification label to the product; , A process of inputting sales data output from the POS terminal 103 when the POS terminal 103 recognizes that a product displayed on the sales floor and having the identification label attached thereto is sold, and the input production data and sales Based on the data, the data creation unit 101b sets a predetermined number of products to be displayed on the sales floor. If the number is less than the number of displays, the number of opportunity losses, which is the difference between the average number of sales in the time zone that is not below the minimum number of displays and the actual number of sales in the time zone that is below the minimum number of displays, or the minimum number of displays At least one of the opportunity loss amounts, which is the difference between the actual sales amount in the time period that is below the minimum number of displays from the average sales amount in the time period that is not less than, is calculated as part of the data indicating the sales floor display status A computer can read and execute a series of processes including a process and a process of storing data indicating the created sales floor display state in a state that can be displayed on a display or printable in a printer in the storage unit 101c It is characterized by being commanded. Thereby, it can be set in the state which can see the display condition of a goods group or a sales floor visually (visualization). As a result, it is possible to avoid out-of-stock of products that the store wants to sell or sell, and improve sales. Thereby, the management level of a merchandise group and a sales floor can be improved.

  The control program according to the present invention is a control program for a server device that manages the display status, production quantity, production period, discount period, and disposal period of goods sold in a store, and includes an input / output interface. In 101a, in the input / output interface 101a, a process for inputting production data output from the weighing price device 102 when the weighing price device 102 provided in the product production area affixes an identification label to the product; , A process of inputting sales data output from the POS terminal 103 when the POS terminal 103 recognizes that a product displayed on the sales floor and having the identification label attached thereto is sold, and the input production data and sales Based on the data, in the data creation unit 101b, based on a predetermined store discount rule, Register the discount rate for the work hours for each sales period as a parameter, and calculate the discount work amount as the data indicating the sales floor display status from the sales price and the number of products before and after the discount of the products displayed on the sales floor The computer reads and executes a series of processes including a process of storing and a process of storing data indicating the created sales floor display state in a state that can be displayed on a display or printable in a printer in the storage unit 101c It is characterized by being commanded as possible. Thereby, it can be made into the state which can see visually how much the discount work in a goods group or a sales floor is a numerical value (visualization).

  Further, in the control program according to the present invention, the production data includes place data for specifying a place to be displayed in a store, and the data creation unit displays the sales floor display status according to the display place. It includes a process of creating data to be shown. Thereby, when the same product is displayed in a plurality of places, the display status and the sales status for each sales floor become visible, and can be easily grasped.

  This control program can be obtained in a state where it is recorded on a recording medium such as a CD-ROM or DVD. In addition, such a program is transmitted by a computer as a transmission device via a transmission medium such as a communication network including a public telephone line, a dedicated telephone line, a cable TV line, a wireless communication line and the like that constitute a network. It can also be obtained by receiving the received signal. This signal is a computer data signal embodied in a predetermined carrier wave including a program. At the time of this transmission, it is only necessary to transmit at least a part of the program in the transmission medium. That is, it is not necessary for all data constituting the program to exist on the transmission medium at a time. Further, the transmission method for transmitting a program from the computer includes a case where data constituting the program is transmitted continuously and a case where it is transmitted intermittently.

It is a block diagram which shows schematic structure of the merchandise management system which concerns on this embodiment. It is a figure which shows the data flow of the merchandise management system which concerns on this embodiment. It is a figure which shows the production time of each goods, sales time, and a freshness value. It is a figure which shows the example of a screen display of freshness information. It is a figure which shows the example of a screen display of the number of opportunity losses. It is a figure which shows the example of a screen display of a discount instruction | indication. It is a figure which shows the example of a screen display for confirming discount work precision. It is a figure which shows a mode that a different sales floor code is attached | subjected when displaying the same goods in several sales floors. It is a figure which shows the flow of the data between main store child stores.

Explanation of symbols

DESCRIPTION OF SYMBOLS 100 Commodity management system 101 Fresh individual management server 101a Input / output interface 101b Data creation part 101c Storage part 102 Weighing price device 103 POS terminal 103a POS cash register 103b POS server 104 Kitchen printer 105 Client PC
106 LAN
200 Two-level barcode 201 Packed product 900 Main store 901 Weighing price 902 Communication network 903 Packed product

Claims (9)

A server device that manages the display status, production quantity, production period, discount period, and disposal period of products sold at a store,
When the weighing price provided in the product production area affixes an identification label to the product, the production data output from the weighing pricer is input, while being displayed on the sales floor and the identification label is affixed. An input / output interface for inputting sales data output from the POS terminal when the POS terminal recognizes that the product has been sold;
Based on the input production data and sales data, a data creation unit that creates data indicating the sales floor display status;
A storage unit that stores the data indicating the created sales floor display state in a state that can be displayed on a display or printable by a printer;
The data creation unit calculates a freshness value indicating freshness of a product group or a sales floor as data indicating the sales floor display status based on an elapsed time from the time each product is produced. . A server device that manages the display status, production quantity, production period, discount period, and disposal period of products sold at a store,
When the weighing price provided in the product production area affixes an identification label to the product, the production data output from the weighing pricer is input, while being displayed on the sales floor and the identification label is affixed. An input / output interface for inputting sales data output from the POS terminal when the POS terminal recognizes that the product has been sold;
Based on the input production data and sales data, a data creation unit that creates data indicating the sales floor display status;
A storage unit that stores the data indicating the created sales floor display state in a state that can be displayed on a display or printable by a printer;
The data creation unit, when the number of items displayed on the sales floor is less than a predetermined minimum number of displays,
The number of lost opportunities, which is the difference between the average number of sales during the time period not below the minimum number of displays and the actual number of sales during the time period below the minimum number of displays, or
A server device characterized in that at least one of opportunity loss amounts, which is an amount obtained by dividing the amount of sales by the number of sales and the average sales amount multiplied by the number of opportunity losses, is calculated as data indicating the sales floor display status . A server device that manages the display status, production quantity, production period, discount period, and disposal period of products sold at a store,
When the weighing price provided in the product production area affixes an identification label to the product, the production data output from the weighing pricer is input, while being displayed on the sales floor and the identification label is affixed. An input / output interface for inputting sales data output from the POS terminal when the POS terminal recognizes that the product has been sold;
Based on the input production data and sales data, a data creation unit that creates data indicating the sales floor display status;
A storage unit that stores the data indicating the created sales floor display state in a state that can be displayed on a display or printable by a printer;
The data creation unit registers, as a parameter, a discount rate with respect to a discount work time for each sales period of a product based on a predetermined store discount rule, before and after the discount of the product displayed on the sales floor A server device characterized in that a discount work amount is calculated as data indicating the sales floor display status from the sales price after sale and the number of products.   The production data includes location data for specifying a location to be displayed in a store, and the data creation unit creates data indicating the sales floor display status according to the display location. The server device according to any one of claims 1 to 3.   The server device according to any one of claims 1 to 4, wherein the data creation unit creates data indicating a sales floor display status so that the data can be displayed as a numerical value or a graph. A server device control program that manages the display status, production quantity, production period, discount period, and disposal period of products sold in stores,
In the input / output interface, a process for inputting production data output from the weighing pricer when the weighing pricer provided in the area for producing the product affixes an identification label to the product;
In the input / output interface, a process for inputting sales data output from the POS terminal when the POS terminal recognizes that the product displayed on the sales floor and attached with the identification label is sold;
Based on the input production data and sales data, the data creation unit indicates a freshness value indicating the freshness of a product group or a sales floor based on an elapsed time from the time each product is produced, and indicates the sales floor display status. Processing to calculate as part of the data,
In the storage unit, a series of processes including the process of storing the data indicating the created sales floor display state in a state that can be displayed on a display or printable by a printer is converted into a command that can be read and executed by a computer. A control program characterized by that. A server device control program that manages the display status, production quantity, production period, discount period, and disposal period of products sold in stores,
In the input / output interface, a process for inputting production data output from the weighing pricer when the weighing pricer provided in the area for producing the product affixes an identification label to the product;
In the input / output interface, a process for inputting sales data output from the POS terminal when the POS terminal recognizes that the product displayed on the sales floor and attached with the identification label is sold;
Based on the input production data and sales data, in the data creation unit, when the number of products displayed on the sales floor is less than a predetermined minimum number of displays, a time zone that is not less than the minimum number of displays The number of opportunity losses, which is the difference between the actual number of sales in the time period below the minimum number of displays from the average number of sales, or the average sales amount obtained by dividing the sales amount by the number of sales multiplied by the number of opportunity losses A process of calculating at least one of opportunity loss amounts that are amounts as part of data indicating the sales floor display status;
In the storage unit, a series of processes including the process of storing the data indicating the created sales floor display state in a state that can be displayed on a display or printable by a printer is converted into a command that can be read and executed by a computer. A control program characterized by that. A server device control program that manages the display status, production quantity, production period, discount period, and disposal period of products sold in stores,
In the input / output interface, a process for inputting production data output from the weighing pricer when the weighing pricer provided in the area for producing the product affixes an identification label to the product;
In the input / output interface, a process for inputting sales data output from the POS terminal when the POS terminal recognizes that the product displayed on the sales floor and attached with the identification label is sold;
Based on the input production data and sales data, the data creation unit registers as a parameter a discount rate for the work hours for each sales period of the product based on a predetermined store discount rule, and displays it on the sales floor. Processing to calculate the discount work amount as data indicating the sales floor display status from the sales price and the number of products before and after discount of the product being discounted;
In the storage unit, a series of processes including the process of storing the data indicating the created sales floor display state in a state that can be displayed on a display or printable by a printer is converted into a command that can be read and executed by a computer. A control program characterized by that.   The production data includes place data for specifying a place to be displayed in the store, and includes a process of creating data indicating the sales floor display status according to the display place in the data creation unit. The control program according to any one of claims 6 to 8, wherein the control program is characterized in that:

Images