JP2021196985A - Expired stock information provision method, system and program - Google Patents

Abstract

To provide a technique that is able to find an expired commodity without checking the expiration dates of the entire stock.SOLUTION: An expired stock information provision method includes: (a) receiving inventory data D1 including: a commodity code for identifying a commodity, attached to a stock commodity at the time of inventory; and the number of stocks, counted at the time of the inventory; (b) acquiring an arrival history data D2 including; a commodity code for identifying a commodity that has arrived; an arrival date and the number of commodities that have arrived; (c) obtaining a commodity expiration date data D3 for calculating an expiration date from the arrival date; (d) determining whether there is an expired stock among stock commodities, based on the inventory data D1, the arrival history data D2 and the commodity expiration date data D3; and (e) providing information about an expired commodity when a determination is made that there is an expired commodity among the stock commodities.SELECTED DRAWING: Figure 4

Description

This disclosure relates to expired inventory information provision methods, systems and programs.

Currently, the POS (Point of Sales) system is widespread in many retailers' stores such as convenience stores, and the sales data of collected products are used in various ways as in the system described in Patent Document 1. There is.

For most of the products handled at convenience stores, the expiration date such as the expiration date is managed in the system for each actual product in cooperation with the manufacturer. When the expiration date is managed for each actual product in this way, the system can determine whether the product has expired by scanning the product code at the cash register at the time of sale, and prevents the sale of the expired product. Things are being done.

Japanese Patent No. 6275078

On the other hand, in most retailers (for example, supermarkets, drug stores, etc.) other than convenience stores, the deadline for each actual product is not managed as in convenience stores. Therefore, as much effort as possible is made by manual check so as not to sell expired products, but a great deal of labor is required and it cannot be said that it is sufficient due to labor shortage.

Although it is not an expiration check work, inventory is carried out regularly in order to accurately grasp the number of stocks. For example, assuming that the number of stocks is about 100,000, it takes about 80 man-hours to count the number of stocks of 100,000. 80 man hours is 8 hours for 10 people, and it is completed overnight. Here, it is considered preferable to carry out the expiration date check at the time of counting the inventory, but the expiration date check takes time. According to the experiments of the inventors, it was found that when the deadline check is performed together with the counting of the number of inventories, it takes more than five times as long as the normal inventory in which only the counting is performed. In this way, it is difficult to carry out the deadline check at the time of inventory from the viewpoint of cost and time. Therefore, at present, there is no effective means for checking the deadline of inventories without spending a lot of money and time.

The present disclosure provides a technique that makes it possible to find expired products without checking the expiration date of all inventories.

The method for providing expired inventory information in the present disclosure is a method executed by one or more processors, and (a) a product code for identifying a product attached to a product in stock at the time of inventory and inventory counted at the time of inventory. A step of accepting inventory data including the number, (b) a step of acquiring the arrival history data including the product code for identifying the arrival product, the arrival date and the number of arrivals, and (c) calculating the deadline from the arrival date. A step of acquiring product expiration date data for the product, (d) a step of determining whether or not an expired product exists in the inventory product based on the inventory data, the arrival history data, and the product expiration data, and (e). ) Includes a step of providing information about the expired merchandise when it is determined that the in-stock merchandise has an expired merchandise.

A block diagram showing an inventory information providing system. A flow chart showing the processing that the system performs to provide inventory information. The figure which shows the relationship between the manufacturing date of product A, the arrival limit, the best-by-date, and other various deadlines. Explanatory drawing about calculation of first and second oldest arrival date, oldest estimated deadline. The figure which shows the 1st example of the deadline information confirmation screen of an inventory product. The figure which shows the 2nd example of the deadline information confirmation screen of the stock product. The figure which shows the 3rd example of the deadline information confirmation screen of the stock product.

The expired inventory information providing system 1 of the present embodiment will be described with reference to the drawings. In this embodiment, a system used in a retail store such as a supermarket that handles inventory products having a best-by date will be described with an example.

As shown in FIG. 1, the inventory information providing system 1 determines whether or not an expired product exists using the data counted at the time of inventory, and provides the determination result. The inventory information providing system 1 includes an inventory data receiving unit 10, an arrival history data acquisition unit 11, a product expiration data acquisition unit 12, an expiration determination unit 13, and an expired product information providing unit 14. Each of these parts 10 to 14 is realized in cooperation with software and hardware resources by executing the process shown in FIG. 2 by one or a plurality of processors 1a.

The inventory data receiving unit 10 shown in FIG. 1 receives inventory data D1 from a user or another system. The inventory data D1 includes a product code for identifying a product attached to an inventory product at the time of inventory and the number of stocks measured at the time of inventory. As in the present embodiment, the inventory data D1 may include shelf position information indicating the shelf position of the inventory product. The product code, inventory quantity, and shelf position information can be obtained by executing inventory, for example, acquisition from an inventory support system. In the example of FIG. 1, the inventory data D1 indicates that the number of inventories of the product whose product code is “product A” is 30 and exists at the “shelf position 1”. The JAN code is often used as the product code, but the product code is not limited to this, and various identification information can be used.

The arrival history data acquisition unit 11 shown in FIG. 1 acquires the arrival history data D2. The arrival history data D2 includes the product code for identifying the arrival product, the arrival date, and the number of arrivals. In the example of FIG. 1, in the arrival history data D2, 10 pieces are received on March 1st, 10 pieces are received on February 1st, and 10 pieces are received on January 1st for the product whose product code is "Product A". It shows that 10 pieces were received on December 1st of the previous year, and 10 pieces were received on November 1st of the previous year. The arrival history data acquisition unit 11 may receive the arrival history data D2 from the user in CSV format data, or may receive the arrival history data D2 from another system.

The product expiration date data acquisition unit 12 shown in FIG. 1 acquires the product expiration date data D3. The product deadline data D3 is data for calculating the deadline from the arrival date. In this embodiment, four deadlines are used: the best-by date, the removal deadline for removing from the sales floor, the discount start deadline for discount processing, and the return deadline, but if at least one deadline is used, the types of deadlines can be changed in various ways. It is possible.

The deadline may include at least one of an expiration date, a best-by date, a deadline for removal from the sales floor, and a deadline for starting discounts. The expiration date and expiration date are determined by the manufacturer. The removal deadline and the discount start deadline are determined by the retail store using this system 1. The return deadline is set by a contract between the retailer using this system 1 and the manufacturer.

The product expiration date data D3 may be data that directly represents the number of days from the arrival date to various expiration dates, but in the present embodiment, as shown in FIG. 3, half of the number of days T1 from the manufacturing date to the expiration date (or expiration date). Assuming that the time point is the arrival deadline, and that the product is always received by the arrival deadline, the number of days T2 from the arrival deadline to the expiration date (or consumption deadline) is used to calculate various deadlines. For example, as shown in FIG. 3, the number of days T1 from the manufacturing date to the expiration date of the product A is 180 days, and the number of days T2 from the arrival deadline to the expiration date is 180/2 = 90 days. In this embodiment, the arrival deadline is set as a half rule, and the number of days from the arrival deadline to the expiration date is multiplied by 1/2, but the calculation is not limited to this. For example, the arrival deadline may be set as a so-called one-third rule and calculated by multiplying by two-thirds.
The number of days T3 from the refund deadline to the expiration date that can be returned is set to 30 days.
The number of days T4 from the removal deadline to the best-by date to be removed from the sales floor is set to 36 days.
The number of days T5 from the discount start deadline to the best-by date is set to 54 days.
The types and number of days of these deadlines are examples and can be changed as appropriate.

The expiration date determination unit 13 shown in FIG. 1 determines whether or not an expired product exists in the inventory product based on the inventory data D1, the arrival history data D2, and the product expiration data D3. Although various determination algorithms can be considered, the following algorithm is used in this embodiment. The expiration date determination unit 13 of the present embodiment includes a first oldest arrival date specifying unit 13a, an oldest estimated deadline calculation unit 13b, and a determination unit 13c in order to realize the algorithm described below. Although not particularly limited, it is preferable that the expiration date determination unit 13 further includes a second oldest arrival date specifying unit 13d.

The first oldest arrival date specifying unit 13a shown in FIG. 1 specifies the first oldest arrival date corresponding to the inventory quantity of the inventory data D1. The first oldest arrival date is the arrival date corresponding to the inventory quantity when the inventory quantity (30 pieces) of the inventory data D1 is associated with the arrival quantity of the arrival history data D2 in the order of the new arrival date. It means the oldest arrival date. The inventory data D1 and the arrival history data D2 shown in FIG. 1 will be described as an example with reference to FIG. As shown in FIG. 4, the inventory date and time was March 10, and the number of commodities A in stock was 30. Then, when the number of stocks (30 pieces) is associated with the number of stocks in the order of new arrival date, the number of stocks (30 pieces) is 10 pieces on March 1st and the arrival date is February 1st. It corresponds to the number of arrivals of 10 pieces per day and the number of arrivals of 10 pieces on January 1st. January 1, which is the oldest arrival date of one or more arrival dates (March 1, February 1, January 1), is the first and oldest arrival date.

The second oldest arrival date specifying unit 13d is a process for adding a safety margin even when an act of ignoring the first-in first-out method by some purchasers is performed. The second oldest arrival date specifying unit 13d shown in FIG. 1 is a second unit in which at least one past arrival is added to the first oldest arrival date specified by the first oldest arrival date specifying unit 13a. Identify the oldest arrival date. In the example of FIG. 4, the first oldest arrival date is January 1, and the second oldest arrival date (November 1 of the previous year) including two more past arrivals than January 1). To identify. In the embodiment shown in FIG. 4, two past arrivals are added, but at least one past arrival may be added. Further, it is preferable to add the past arrivals at least twice as in the present embodiment. The upper limit can be set according to the number of arrivals, but it is preferably 5 times or less at most. This is because if there are too many products, the number of products that are judged to be expired will increase.

As shown in FIG. 1, in the configuration in which the second oldest arrival date specifying unit 13d is implemented, the oldest estimated deadline calculation unit 13b is the second oldest specified by the second oldest arrival date specifying unit 13d. The oldest estimated deadline for in-stock items is calculated based on the arrival date (November 1 of the previous year). The oldest estimated deadline is a plurality of estimated deadlines (May 3, May 1, March 31, February 29, January 30) estimated by the arrival history data D2 and the product deadline data D3. Of these, the oldest deadline (January 30). Here, as the oldest estimated deadline, the best-by date is exemplified, and the expiration date is not limited to this, and any deadline such as a discount start deadline and a removal deadline can be adopted.

In the configuration in which the second oldest arrival date specifying unit 13d is not implemented, the oldest estimated deadline calculation unit 13b is based on the first oldest arrival date specified by the first oldest arrival date specifying unit 13a. Calculate the oldest estimated deadline for in-stock items. The oldest estimated expiration date corresponding to the first oldest arrival date (January 1) is March 31st.

The expiration determination unit 13c shown in FIG. 1 determines that the inventory product has expired inventory when the oldest estimated expiration date is earlier than the comparison reference time. The comparison reference date is preferably set to the date on which the inventory is executed (March 10 in the example of FIG. 4), but can be set as appropriate. In the example shown in FIG. 4, since the oldest estimated deadline (January 30) is earlier than the comparison reference time (March 10), the expiration determination unit 13c determines that the expired product exists in the product A. ..

The product information providing unit 14 shown in FIG. 1 provides information on an expired product when the expiration determination unit 13 determines that an expired product exists in the inventory product. The information about the expired product is information for identifying the expired product so that the person who sees it can go to the shelf on which the actual product is placed and find the corresponding product. For example, a product name, a manufacturer name, an external photograph, a product code, and the like can be mentioned. It is conceivable to access an existing database to obtain this information.

Although not particularly limited, in the present embodiment, the inventory data D1 includes the shelf position information indicating the shelf position of the inventory product, and the product information providing unit 14 also provides the shelf position information corresponding to the expired product. do. This is because it is possible to know at which position in the store the in-stock items are located by looking at the shelf position information.

To find the actual inventory product based on the information about the expired product provided by the product information providing unit 14, and to find the expiration date in the situation where you do not know where the expiration date is attached to the actual inventory product, search for the product. It is necessary to check from all angles, which is troublesome. Therefore, although not particularly limited, as in the present embodiment, there is a deadline print data acquisition unit 15 for acquiring deadline print data regarding the deadline print position in the inventory product, and the product information providing unit 14 corresponds to the expired product. Information regarding the print position of the deadline may be provided. The deadline print data has information on the presence / absence of a deadline and the print position of the deadline for each product handled by the store. The deadline print data of the present embodiment is associated with an external photograph of the six sides of the appearance of the product on which the deadline is printed, a product code, and the presence or absence of the deadline.

The user can know the information presumed to be an expired product by the product information providing unit 14, but by looking at the expiration date of the actual product, it is determined in the mind whether or not the product has expired without making a calculation error. This is complicated because it takes time to confirm each item.

Therefore, although not particularly limited, as shown in FIG. 1, it is preferable that the inventory information providing system 1 has an actual deadline / inventory receiving unit 16 and a deadline information providing unit 17.

The actual deadline / inventory receiving unit 16 provides the deadline information confirmation screen for the in-stock product shown in FIG. 5, and receives the actual deadline and the actual inventory quantity of the product A determined to be the expired product. In FIG. 5, the parts that can be input or changed by the user are shown by squares. When the product information providing unit 14 has an expired product, the result of confirming the actual expiration date and the actual quantity of the product A actually on the shelf for the stock product (product A) is input to the screen shown in FIG. The inventory receiving unit 16 receives the contents input on the screen shown in FIG. The deadline information providing unit 17 provides information on the deadline including whether or not it has expired for each actual deadline received by the actual deadline / inventory receiving unit 16.

FIG. 5 is a first example in which an inventory product is confirmed and the actual expiration date and the actual inventory quantity are input. As shown in FIG. 5, when it is input that the number of stocks whose actual expiration date is May 20 is 10 and the actual expiration date is May 10 is 8 pieces, the taste is tasted. Since there are 71 days until the deadline and none of them have reached the deadline, the fact that nothing is displayed in the deadline information indicates that the deadline has not expired. Further, when it is input that the number of stocks whose actual expiration date is May 1st is 7 and the actual expiration date is April 20th and the number of stocks is 5, the discount start deadline (all). Since it has passed 54 days ago), it is assumed that the "discount start deadline" has passed, and the deadline information indicates that the discount has been made.

FIG. 6 is a second example corresponding to FIG. When the actual expiration date is entered on May 20th and May 10th, nothing is displayed in the expiration date information, which is the same as in the example of FIG. If it is entered that the actual expiration date is May 1st, the number of stocks is 7, and the actual expiration date is April 20th, the number of stocks is 3, the discount start deadline (54 days before) is entered. ) Has passed, so it is assumed that the "discount start deadline" has passed, and the deadline information indicates that the discount has been made. Furthermore, if it is entered that the actual expiration date is April 14th and the number of stocks is 2, the removal deadline (36 days ago) has passed, but the return deadline (30 days ago) has not arrived. Indicates that it should be removed and that it can be returned.

FIG. 7 is a third example corresponding to FIGS. 5 and 6. When the actual expiration date is entered on May 20th and May 10th, nothing is displayed in the expiration date information, which is the same as in the example of FIG. When the actual expiration date is entered on May 1st and April 20th, displaying that the expiration date is a discount is the same as in the example of FIG. When it is entered that the actual expiration date is April 14, it is the same as the example of FIG. 6 to indicate that it should be removed and that it can be returned. If you enter one item in stock for which the actual expiration date is March 5, the expiration date will be displayed as information regarding the expiration date that the item should be removed and that it cannot be returned.

<Application to drug stores>
The above description is based on the premise that the drug is used in a retail store such as a supermarket, but this system 1 can be applied to a drug store that handles drugs whose expiration date is set on an annual basis. Unlike food, medicines can be returned to the manufacturer for refund after the expiration date. Therefore, although not particularly limited, it is preferable to provide a refund data acquisition unit 18 and an amount providing unit 19 as shown in FIG. 1 in consideration of refundability.

The refund data acquisition unit 18 shown in FIG. 1 acquires refund data for calculating the refund amount per unit quantity of the inventories obtained by returning the expired products. The refund data indicates, for example, the refund amount per product A. The value based on the manufacturer's suggested retail price and the purchase amount can be mentioned.

The amount providing unit 19 shown in FIG. 1 is at least one of the total refund amount of all products or the total refund amount multiplied by a predetermined coefficient based on the actual inventory and the refund amount of the inventory products whose actual expiration date has expired. Provide one or the other. In this embodiment, both the total refund amount of all products and the total refund amount multiplied by a predetermined coefficient are provided. The predetermined coefficient is a number exceeding 0.0 and less than 1.0, and for example, 0.1 or the like can be considered, but it is appropriately set according to the contract. The total refund amount multiplied by a predetermined coefficient may be used as a license fee for using this system.

<How to provide expired inventory information>
A method executed by the inventory information providing system 1 will be described with reference to FIG. 2.

In step ST1 shown in FIG. 2, the inventory data receiving unit 10 receives the inventory data D1 including the product code for identifying the product attached to the inventory product at the time of inventory and the number of stocks counted at the time of inventory. In the next step ST2, the arrival history data acquisition unit 11 acquires the arrival history data D2 including the product code for identifying the arrival product, the arrival date, and the number of arrivals. In the next step ST3, the product deadline data acquisition unit 12 acquires the product deadline data D3 for calculating the deadline from the arrival date. The steps ST1 to 3 are in no particular order.

By executing steps ST4 to 7, the expiration date determination unit 13 determines whether or not an expired product exists in the inventory product based on the inventory data D1, the arrival history data D2, and the product expiration data D3. Specifically, in step ST4, the first oldest arrival date specifying unit 13a associates the inventory quantity of the inventory data D1 with the arrival quantity of the arrival history data D2 in the order of the new arrival date, and the inventory quantity. Identify the first and oldest arrival date corresponding to. In the next step ST5, the second oldest arrival date specifying unit 13d specifies the second oldest arrival date in which at least one past arrival date is added to the specified first oldest arrival date. .. In the next step ST6, the oldest estimated deadline calculation unit 13b calculates the oldest estimated deadline of the inventory product based on the second oldest arrival date. In the next step ST7, if the oldest estimated deadline is earlier than the comparison reference time, the determination unit 13c determines that there is an expired product in the inventory product. If the oldest estimated deadline is after the comparison reference time, it is determined that there is no expired product in the inventory product.

In the next step ST8, the product information providing unit 14 provides information on the expired product when the expiration determination unit 13 determines that the expired product exists in the inventory product. At the same time, shelves position information is provided.

In the next step ST9, the inventory receiving unit 16 receives the actual expiration date and the actual inventory quantity of the expired products. In the next step ST10, the deadline information providing unit 17 provides information on the deadline including whether or not it has expired for each actual deadline received.

Although not particularly limited and not shown in FIG. 2, in the next step, the amount providing unit 19 determines the total refund amount of all the products or the refund amount based on the actual inventory and the refund amount of the stock products whose actual expiration date has expired. At least one of the total refund amount multiplied by a predetermined count may be provided.

As described above, the expired inventory information providing method of the present embodiment is a method executed by one or a plurality of processors, and (a) a product code for identifying a product attached to a product in stock at the time of inventory. And the step of accepting the inventory data D1 including the number of stocks counted at the time of inventory, (b) the step of acquiring the product code for identifying the arrival product, the arrival date and the arrival history data D2 including the number of arrivals, and (c). Based on the step of acquiring the product deadline data D3 for calculating the deadline from the arrival date, and (d) inventory data D1, arrival history data D2, and product deadline data D3, whether or not there is an expired product in the stock product. It includes a determination step and (e) a step of providing information about the expired product when it is determined that the expired product exists in the stock product.

The expired inventory information providing system 1 of the present embodiment includes an inventory data receiving unit 10 that receives inventory data D1 including a product code for identifying a product attached to an inventory product at the time of inventory and the number of stocks counted at the time of inventory. , The product code for identifying the arrival product, the arrival history data acquisition unit 11 for acquiring the arrival history data D2 including the arrival date and the number of arrivals, and the product for acquiring the product deadline data D3 for calculating the deadline from the arrival date. Based on the deadline data acquisition unit 12, the inventory data D1, the arrival history data D2, and the product deadline data D3, the expiration date determination unit 13 that determines whether or not the stock product has an expired product, and the stock product has an expired product. A product information providing unit 14 that provides information on expired products when it is determined to be so provided.

According to this method or system 1, only by inputting the product code of the stocked product at the time of inventory and the counted number of stocks into the system 1, information on the expired product is provided when the expired product exists, so that the information about the expired product is provided at the time of inventory. It is possible to know the existence of expired products without spending a lot of labor to check the expiration dates of in-stock products one by one. It is only necessary to check the expiration date of the expired products provided by the system without checking the expiration date of all the inventory, and it is possible to significantly reduce the checking effort. As a result, it is possible to avoid selling expired products.

Although not particularly limited, in the method as in the present embodiment, (d1) the inventory quantity of the inventory data D1 is associated with the arrival quantity of the arrival history data D2 in the order of the new arrival date, and the inventory quantity is dealt with. The step of specifying the first oldest arrival date to be performed, (d2) the step of calculating the oldest estimated deadline of the inventory product based on the specified first oldest arrival date, and (d3) the oldest estimated deadline are comparison criteria. If it is older than the time, it is preferable to include a step of determining that an expired product exists in the inventory product.

According to this method, assuming that the products are sold in the order of first-in, first-out, the oldest estimated deadline of the stock products is specified. Therefore, it is possible to determine the presence or absence of the expired stock by an algorithm suitable for the retail sales situation.

Although not particularly limited, as in the present embodiment, the method specifies (d4) the second oldest arrival date in which at least one past arrival date is added to the specified first oldest arrival date. In (d2), it is preferable to calculate the oldest estimated deadline of the stocked goods based on the second oldest arrival date specified in (d4).

Older products are placed in front of the shelves, but buyers may bother to reach out to the back of the shelves to purchase new products from the back of the shelves. According to this method, even if some purchasers ignore the first-in first-out method, it is possible to determine the presence or absence of expired inventory by adding a safety margin, and it is possible to improve the determination accuracy. Become.

Although not particularly limited, as in the present embodiment, the deadline preferably includes at least one of a consumption deadline, a best-by date, a deadline for removal from the sales floor, and a deadline for starting a discount. It is preferable for promoting the proper operation of the retail industry.

Although not particularly limited, as in the present embodiment, the inventory data D1 preferably includes the shelf position information indicating the shelf position of the inventory product, and in (e), it is preferable to provide the shelf position information corresponding to the expired product.

In relation to the information about the expired product, the shelf position information corresponding to the expired product is also provided, so if you look at the shelf position information, you can immediately know the location of the stock product judged to be the expired product, so the actual inventory product It becomes possible to easily carry out the deadline check.

Although not particularly limited, as in the present embodiment, the method includes (f) a step of acquiring a deadline print data acquisition unit 15 regarding a deadline print position in an inventory product, and (e) a deadline corresponding to the expired product. It is preferable to provide information on the print position of.

According to this configuration, since information on the expired product is provided, it is possible to easily carry out the actual expiration check of the inventory product determined to be the expired product.

Although not particularly limited, as in the present embodiment, the method is a step of accepting an actual deadline for a product determined to be an expired product after the provision in (g) and (e), and (h) for each accepted actual deadline. It is preferable to include a step of providing information on the deadline, including whether or not it has expired.

According to this configuration, it is only necessary to confirm the inventory products judged to be expired products, enter the actual expiration date and the actual inventory quantity, and information including whether or not the products have expired is provided for each actual expiration date. You do not have to do mental arithmetic to determine whether the deadline has expired by looking at the actual deadline, for example, return it to the shelf because it is not expired, remove it from the shelf, return it to the manufacturer, attach a discount sticker, etc. You can easily understand what to do next.

Although not particularly limited, as in the present embodiment, the method is a step of accepting the actual expiration date and the actual inventory quantity of the expired product after the provision in (g) and (e), and (i) the inventory obtained by returning the product. Based on the steps to obtain refund data for calculating the refund amount per unit quantity of the product, and (j) the actual inventory and refund amount of the inventories whose actual expiration date has expired, the total refund amount of all products, or , A step of providing at least one of the total refund amount multiplied by a predetermined count, and preferably included.

According to this configuration, the total refund amount obtained by the return or the total amount multiplied by a predetermined coefficient is provided, so that the store receives the total refund amount from the manufacturer that should not have been obtained without being found. As a condition for this, it is possible to provide a system that is indispensable for a new business and receives the total amount multiplied by a predetermined coefficient as royalties for using this system.

The inventory information providing system 1 of the present embodiment includes one or a plurality of processors that execute the above method.

The program of this embodiment is a program that causes one or more processors to execute the above method. Further, the non-temporary recording medium readable by the computer of the present embodiment stores the above program.

Although the embodiments of the present disclosure have been described above with reference to the drawings, it should be considered that the specific configuration is not limited to these embodiments. The scope of the present disclosure is set forth not only by the description of the embodiment described above but also by the scope of claims, and further includes all modifications within the meaning and scope equivalent to the scope of claims.

For example, the execution order of each process such as operation, procedure, step, and step in the device, system, program, and method shown in the claims, specification, and drawings may be the output of the previous process. It can be realized in any order unless it is used in processing. Even if the scope of claims, the specification, and the flow in the drawings are explained using "first", "next", etc. for convenience, it does not mean that it is essential to execute in this order. ..

Although each part 10 to 19 shown in FIG. 1 is realized by executing a predetermined program by one or a plurality of processors, each part may be configured by a dedicated memory or a dedicated circuit. In the system 1 of the above embodiment, each unit 10 to 19 may be distributed and implemented by a plurality of computers or a cloud.

It is possible to adopt the structure adopted in each of the above embodiments in any other embodiment. The specific configuration of each part is not limited to the above-described embodiment, and various modifications can be made without departing from the gist of the present disclosure.

1 Inventory information provision system 10 Inventory data reception unit 11 Arrival history data acquisition unit 12 Product deadline data acquisition unit 13 Expiration judgment unit 13a 1st oldest arrival date identification unit 13b Oldest estimated deadline calculation unit 13c Judgment unit 13d 2nd oldest Arrival date identification department 14 Product information provision department 15 Deadline print data acquisition department 16 Actual deadline / inventory reception department 17 Deadline information provision department 18 Refund data acquisition department 19 Amount provision department

Claims (10)

A method executed by one or more processors.
(A) A step of accepting inventory data including a product code for identifying a product attached to an inventory product at the time of inventory and the number of stocks counted at the time of inventory.
(B) A step of acquiring arrival history data including a product code for identifying an arrival product, an arrival date, and the number of arrivals, and
(C) A step of acquiring product deadline data for calculating the deadline from the arrival date, and
(D) A step of determining whether or not an expired product exists in the inventory product based on the inventory data, the arrival history data, and the product expiration date data.
(E) A step of providing information on an expired product when it is determined that an expired product exists in the inventory product.
How to provide expired inventory information, including. The method is
(D1) A step of associating the inventory quantity of the inventory data with the arrival quantity of the arrival history data in the order of new arrival date, and specifying the first oldest arrival date corresponding to the inventory quantity. When,
(D2) A step of calculating the oldest estimated deadline of the inventory product based on the specified first oldest arrival date, and
(D3) When the oldest estimated deadline is earlier than the comparison reference time, a step of determining that an expired product exists in the inventory product, and
The method according to claim 1. The method comprises (d4) identifying a second oldest arrival date, taking into account at least one past arrival date, further than the specified first earliest arrival date.
In the above (d2), the oldest estimated deadline of the inventory product is calculated based on the second oldest arrival date specified in the above (d4).
The method according to claim 2. The method according to any one of claims 1 to 3, wherein the deadline includes at least one of an expiration date, a best-by date, a deadline for removal from the sales floor, and a deadline for starting a discount. The inventory data includes shelf position information representing the shelf position of the inventory product, and includes the shelf position information.
The method according to claim 1 to 4, wherein the shelf position information corresponding to the expired product is provided in the (e). The method includes (f) acquiring deadline print data relating to a deadline print position in the inventory product.
The method according to any one of claims 1 to 5, wherein in the above (e), information regarding the printing position of the deadline corresponding to the expired product is provided. The method is
(G) After the provision in (e), the step of accepting the actual expiration date of the product determined to be the expired product, and
(H) For each of the actual deadlines received, a step of providing information on the deadline including whether or not it has expired, and
The method according to any one of claims 1 to 6. The method is
(G) After the provision in (e), the step of accepting the actual expiration date and the actual inventory quantity of the expired product, and
(I) Steps to obtain refund data for calculating the refund amount per unit quantity of inventories obtained by returns, and
(J) At least one of the total refund amount of all products or the total refund amount multiplied by a predetermined count based on the actual inventory of the inventory products whose actual expiration date has expired and the refund amount. And the steps to provide
The method according to any one of claims 1 to 7. An expired inventory information providing system comprising one or more processors that perform the method according to any one of claims 1-8. A program that causes one or more processors to perform the method according to any one of claims 1-8.

Images