Warning method, system and equipment based on commodity expiration date and storage medium

Abstract

The invention discloses an alarm method, system and device based on a commodity expiration date and a storage medium, and the method comprises the steps: obtaining a warehousing table, an end-of-period inventory table and an in-warehouse table from different systems, sorting the warehousing table, associating the end-of-period inventory table with the warehousing table, carrying out the warehousing amount distribution of each piece of commodity information in the warehousing table, obtaining a warehouse-in distribution table, sorting the warehouse-in distribution table and the warehouse-in table, and carrying out commodity quantity distribution on each piece of commodity information in the warehouse-in distribution sorting table to obtain the warehouse age and the remaining shelf life of each piece of commodity information in the warehouse age to-be-calculated table and the statistical table; and giving an alarm for the commodities of which the storage age is greater than the preset storage age or the remaining shelf life is less than the preset shelf life. Therefore, the three tables are from different systems, and after the three tables are fused and subjected to deep analysis, the super-storage-age and the immediate commodities can be analyzed and obtained from the storage-age to-be-calculated table, so that the super-storage-age and the immediate commodities are subjected to efficient early warning, and the super-storage-age / immediate commodities can be processed in time.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and more specifically, to an alarm method, system, device and storage medium based on the expiration date of a product. Background Art

[0002] Driven by the wave of globalization, the company's overseas business has shown a rapid expansion trend. While this development has brought new opportunities to the company, it has also brought many difficult problems to international warehouse management. Among them, the backlog of over-aged goods and the problem of goods approaching or expired are particularly prominent. These problems not only occupy a large amount of warehouse space and increase warehouse rental costs, but may also cause the goods to be unable to be sold due to expiration, resulting in direct economic losses.

[0003] At present, the company has multiple information systems for business management. The warehouse management team uses system X to accurately input inventory information of goods in stock, and record the date of entry and expiration date of each item in detail. In terms of overseas market orders, online system Y has achieved detailed records at the market order level, covering order details in various markets.

[0004] However, when dealing with the core issue of warehouse commodity management, the existing system, although system X can record commodity information, only allows refined management at the warehouse and commodity level, and cannot go deep into the market or even the market order level, making it difficult to determine which market the overstocked and near-expiry commodities belong to. At the same time, due to the complexity of the interactive data between system X and system Y, business personnel need to export relevant data from various systems for integrated analysis. However, the data is large in scale and the calculations are complex, making it difficult for business personnel to conduct in-depth analysis, let alone standardize the analysis process, resulting in a lack of ability to hold market managers accountable and clear out overstocked and near-expiry commodities, making it difficult to effectively solve the backlog problem in international warehouses.

[0005] How to efficiently analyze and issue early warnings on the data of over-age commodities in multiple systems, and to handle over-age commodities in a timely manner, is an issue that requires attention. Summary of the invention

[0006] In view of the above problems, the present application provides an alarm method, system, device and storage medium based on the expiration date of goods, so as to efficiently analyze and warn the data of over-age goods in multiple systems and handle the over-age goods in time.

[0007] In order to achieve the above objectives, the specific plan is proposed as follows:

[0008] An alarm method based on commodity expiration date, comprising:

[0009] Obtaining a stock-in table from the first system, a period-end inventory table from the second system, and an in-warehouse table from the third system, wherein the stock-in table, the period-end inventory table, and the in-warehouse table all contain a number of commodity information;

[0010] Sorting the storage entry table, and associating the period-end inventory table with the storage entry table, so as to allocate the storage quantity to each commodity information in the storage entry table, and obtaining a storage allocation table;

[0011] The warehouse allocation table and the warehouse table are sorted, and the commodity quantity is allocated to each commodity information in the warehouse allocation sorting table according to the commodity quantity dimension in the warehouse table to obtain the warehouse age to be calculated table;

[0012] The inventory age and remaining shelf life of each commodity information are counted in the inventory age to be calculated table, and an alarm is issued for commodity information whose inventory age is greater than a preset inventory age or whose remaining shelf life is less than a preset period.

[0013] Optionally, each piece of commodity information in the entry table includes a market order dimension, a commodity dimension, a warehouse ID dimension, and an entry date dimension, and each piece of information in the period-end inventory table includes an available inventory dimension;

[0014] The storage entry table is sorted, and the end-of-period inventory table is associated with the storage entry table, so as to allocate the storage quantity to each commodity information in the storage entry table, and obtain a storage entry allocation table, including:

[0015] Sort each item of product information in the warehousing table according to the market order dimension, product dimension, warehouse ID dimension and warehousing date dimension;

[0016] The end-of-period inventory table is associated with the incoming inventory table to allocate the total available inventory of each market order of each commodity in the end-of-period inventory table to each commodity information of the market order of the commodity in the incoming inventory table, and perform limit value processing to obtain an incoming inventory allocation table.

[0017] Optionally, each piece of commodity information in the warehousing table includes a warehousing quantity dimension;

[0018] The limit value processing method includes:

[0019] When allocating the inventory quantity to each commodity information in the inventory table, if the commodity information corresponding to the target market order cannot be obtained, creating new commodity information of the target market order with a preset initialization date;

[0020] If the available inventory corresponding to the target market order in the end-of-period inventory table is less than the incoming quantity corresponding to the target market order in the incoming table, the difference between the incoming quantity and the available inventory is used as the value of the incoming quantity dimension of the newly created product information, and the incoming date of the newly created product information is adjusted to the day before the earliest incoming date in the target market order.

[0021] Optionally, the in-warehouse table includes a warehouse dimension, a commodity dimension, an expiration date dimension, a commodity quantity dimension, and a warehousing date dimension;

[0022] The warehouse allocation table and the warehouse table are sorted, and the commodity quantity is allocated to each commodity information in the warehouse allocation sorting table according to the commodity quantity dimension in the warehouse table, so as to obtain the warehouse age to be calculated table, including:

[0023] Sorting the warehousing allocation table according to the commodity warehousing date dimension and the market order dimension to obtain the warehousing allocation sorting table;

[0024] Sorting the in-warehouse table according to the warehouse dimension, the commodity dimension, the expiration date dimension, and the warehousing date dimension to obtain an in-warehouse sorting table;

[0025] Based on the commodity expiration date dimension and the warehousing date dimension, the commodity quantity dimension in the in-warehouse sorting table is used to allocate the commodity quantity for each commodity information in the warehousing allocation sorting table to obtain the inventory age to be calculated table.

[0026] Optionally, the inventory age to be calculated table includes a statistical date dimension;

[0027] The inventory age and remaining shelf life of each product information are counted in the inventory age to be calculated table, including:

[0028] In the inventory age calculation table, the expiration date of each product information is subtracted from the statistical date of the product information to obtain the remaining shelf life of the product information;

[0029] In the inventory age to be calculated table, the inventory age of the commodity information is obtained by subtracting the inventory entry date of the commodity information from the statistical date of the commodity information.

[0030] Optionally, the method further includes:

[0031] According to the inventory age of each piece of commodity information in the inventory age to be calculated table, the inventory age of the commodity information is layered according to the preset number of months;

[0032] According to the remaining shelf life of each piece of commodity information in the inventory age to be calculated table, the remaining shelf life of the commodity information is layered according to the preset number of months.

[0033] An alarm system based on commodity expiration date, comprising:

[0034] A table acquisition unit is used to acquire a warehouse entry table from the first system, a period-end inventory table from the second system, and an in-warehouse table from the third system, wherein the warehouse entry table, the period-end inventory table, and the in-warehouse table each contain a plurality of commodity information;

[0035] A storage allocation table construction unit is used to sort the storage table and associate the end-of-period inventory table with the storage table, so as to allocate the storage quantity to each commodity information in the storage table to obtain the storage allocation table;

[0036] The storage age to be calculated table construction unit is used to sort the storage allocation table and the in-warehouse table, and allocate the commodity quantity to each commodity information in the storage allocation sorting table according to the commodity quantity dimension in the in-warehouse table, so as to obtain the storage age to be calculated table;

[0037] The alarm unit is used to count the storage age and remaining shelf life of each commodity information in the storage age to be calculated table, and to issue an alarm for commodity information whose storage age is greater than a preset storage age or whose remaining shelf life is less than a preset period.

[0038] Optionally, each piece of commodity information in the entry table includes a market order dimension, a commodity dimension, a warehouse ID dimension, and an entry date dimension, and each piece of information in the period-end inventory table includes an available inventory dimension;

[0039] The storage allocation table construction unit includes:

[0040] The storage entry table sorting unit is used to sort each item of product information in the storage entry table according to the market order dimension, product dimension, warehouse ID dimension and storage date dimension;

[0041] The incoming quantity allocation unit is used to associate the end-of-period inventory table with the incoming table, so as to allocate the total available inventory of each market order of each commodity in the end-of-period inventory table to each commodity information of the market order of the commodity in the incoming table, and perform limit value processing to obtain the incoming quantity allocation table.

[0042] Optionally, each piece of commodity information in the warehousing table includes a warehousing quantity dimension;

[0043] The system also includes:

[0044] The first limit value processing unit is used to create new commodity information of the target market order with a preset initialization date when allocating the inventory quantity to each commodity information in the inventory table if the commodity information corresponding to the target market order cannot be obtained;

[0045] The second limit value processing unit is used to use the difference between the incoming quantity and the available inventory as the value of the incoming quantity dimension of the newly created product information if the available inventory corresponding to the target market order in the end-of-period inventory table is less than the incoming quantity corresponding to the target market order in the incoming table, and adjust the incoming date of the newly created product information to the day before the earliest incoming date in the target market order.

[0046] Optionally, the in-warehouse table includes a warehouse dimension, a commodity dimension, an expiration date dimension, a commodity quantity dimension, and a warehousing date dimension;

[0047] The storage age to be calculated table construction unit includes:

[0048] The storage allocation table sorting unit is used to sort the storage allocation table according to the commodity storage date dimension and the market order dimension to obtain the storage allocation sorting table;

[0049] An in-warehouse table sorting unit is used to sort the in-warehouse table according to the warehouse dimension, the commodity dimension, the expiration date dimension and the warehousing date dimension to obtain an in-warehouse sorting table;

[0050] The commodity quantity allocation unit is used to allocate the commodity quantity to each commodity information in the warehousing allocation sorting table based on the commodity expiration date dimension and the warehousing date dimension through the commodity quantity dimension in the warehouse sorting table to obtain the inventory age to be calculated table.

[0051] Optionally, the inventory age to be calculated table includes a statistical date dimension;

[0052] The alarm unit comprises:

[0053] A remaining shelf life calculation unit is used to obtain the remaining shelf life of each piece of product information by subtracting the statistical date of the product information from the expiration date of the product information in the inventory age to be calculated table;

[0054] The inventory age calculation unit is used to subtract the inventory entry date of the commodity information from the statistical date of the commodity information in the inventory age to be calculated table to obtain the inventory age of the commodity information, and to issue an alarm for commodity information whose inventory age is greater than a preset inventory age or whose remaining shelf life is less than a preset period.

[0055] Optionally, the system further includes:

[0056] A stock age stratification unit, for stratifying the stock age of each piece of commodity information in the stock age to be calculated table according to the number of preset months;

[0057] The remaining shelf life stratification unit is used to stratify the remaining shelf life of each commodity information in the inventory age to be calculated table according to the remaining shelf life of the commodity information according to the preset number of months.

[0058] An alarm device based on commodity expiration date, comprising a memory and a processor;

[0059] The memory is used to store programs;

[0060] The processor is used to execute the program to implement the various steps of the alarm method based on the expiration date of the commodity as described above.

[0061] A storage medium having a computer program stored thereon, characterized in that when the computer program is executed by a processor, each step of the alarm method based on the expiration date of a product as described above is implemented.

[0062] By means of the above technical scheme, the present application obtains the warehouse entry table, the end-of-period inventory table and the in-warehouse table from different systems, wherein each of the three tables contains a number of commodity information, further, sorts the warehouse entry table, and associates the end-of-period inventory table with the warehouse entry table, so as to allocate the warehouse entry quantity to each commodity information in the warehouse entry table, and obtains the warehouse entry allocation table, sorts the warehouse entry allocation table and the in-warehouse table, and allocates the commodity quantity to each commodity information in the warehouse entry allocation sorting table through the commodity quantity dimension in the warehouse table, and obtains the warehouse age to be calculated table, in which the warehouse age and the remaining shelf life of each commodity information are counted, and an alarm is issued for commodity information whose warehouse age is greater than the preset warehouse age or whose remaining shelf life is less than the preset period. It can be seen that the warehouse entry table, the end-of-period inventory table and the in-warehouse table are derived from different systems. After the three tables are integrated for in-depth analysis, it is possible to analyze the over-warehouse age and near-expiry commodities from the warehouse age to be calculated table, thereby providing an efficient early warning for over-warehouse age and near-expiry commodities, so that over-warehouse age / near-expiry commodities can be processed in a timely manner. BRIEF DESCRIPTION OF THE DRAWINGS

[0063] Various other advantages and benefits will become apparent to those of ordinary skill in the art by reading the detailed description of the preferred embodiments below. The accompanying drawings are only for the purpose of illustrating the preferred embodiments and are not to be considered as limiting the present application. Also, the same reference symbols are used throughout the accompanying drawings to represent the same components. In the accompanying drawings:

[0064] Figure 1 A schematic diagram of a process for implementing an alarm based on the expiration date of a product provided in an embodiment of the present application;

[0065] Figure 2 A schematic diagram of a system structure for implementing an alarm based on the expiration date of a product provided in an embodiment of the present application;

[0066] Figure 3A schematic diagram of the structure of a device for implementing an alarm based on the expiration date of a product provided in an embodiment of the present application. DETAILED DESCRIPTION

[0067] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0068] The solution of the present application can be implemented based on a terminal with data processing capabilities, which can be a data middle-end system. The data middle-end system can obtain table data from multiple systems and aggregate and process data across systems.

[0069] Next, combine Figure 1 The product expiration date-based warning method of the present application may include the following steps:

[0070] Step S110: Obtain the inventory entry table from the first system, the end-of-period inventory table from the second system, and the in-warehouse table from the third system.

[0071] Among them, the warehouse entry table, the end-of-period inventory table and the in-warehouse table all contain several pieces of commodity information.

[0072] It is understandable that in order to simplify the amount of calculation, the basic forms of the inventory table, the end-of-period inventory table and the warehouse table are acquired by the data middle-end system and rolled over daily to record the statistical date column.

[0073] The warehouse table can specifically include product dimensions (SKU), warehouse dimensions, storage date dimensions, expiration date dimensions, product quantity dimensions, and statistical date dimensions. The warehouse table is used to record the actual storage information of the current inventory of the warehouse. An example is shown in Table X1:

[0074]

[0075] The incoming inventory table can include the market order dimension, SKU dimension, warehouse dimension, incoming inventory date dimension, incoming inventory quantity dimension, and statistical date dimension. The incoming inventory table is used to record the incoming inventory information of each market order, which may include the situation of splitting multiple incoming inventory. The example is shown in the following table Y1:

[0076]

[0077] The ending inventory table can include the market order dimension, SKU dimension, warehouse dimension, available inventory dimension and statistical date dimension. The ending inventory table is used to record the available inventory quantity at the end of the market period, as shown in the following table Y2:

[0078]

[0079] Step S120: sort the storage entry table, and associate the period-end inventory table with the storage entry table, so as to allocate the storage quantity to each commodity information in the storage entry table, and obtain the storage entry allocation table.

[0080] It can be understood that the ending inventory table is the statistical result of a point in time. The first-in-first-out principle is maintained, so that the last goods in stock are affected by the latest goods entering the warehouse, thereby splitting the resulting inventory quantity of market orders by entry time and quantity. Specifically, the day can be used as the statistical dimension, so as to use the available inventory in the ending inventory table to allocate each product information in the entry table.

[0081] Among them, the allocation process can be developed and implemented based on the data middle-end system computing engine Spark.

[0082] Specifically, the inventory allocation table may include a market order dimension, a SKU dimension, a warehouse dimension, an inventory date dimension, an inventory quantity dimension, and a statistical date dimension.

[0083] Step S130: sort the incoming allocation table and the in-warehouse table, and allocate the commodity quantity to each commodity information in the incoming allocation sorting table according to the commodity quantity dimension in the warehouse table, to obtain the inventory age to be calculated table.

[0084] It is understandable that the detailed splitting process of the ending inventory quantity based on the granularity of market order + warehouse + SKU is realized in step S120 based on FIFO, but these are only the entry date and quantity of the logical layer recorded in the business system. In order to achieve the calibration of the physical layer, the warehouse inventory table at the commodity granularity can be refined to each entry batch of the market order based on the FIFO processing result, so as to finally determine the market order to which the ownership of each batch of goods belongs, so as to obtain the inventory age to be calculated table.

[0085] Specifically, the inventory age to be calculated table may include a warehouse dimension, a market order dimension, a SKU dimension, an expiration date dimension, a warehousing date dimension, a commodity quantity dimension, and a statistical date dimension.

[0086] Step S140: Count the inventory age and remaining shelf life of each product information in the inventory age to be calculated table, and issue an alarm for product information whose inventory age is greater than a preset inventory age or whose remaining shelf life is less than a preset period.

[0087] Furthermore, the calculated inventory age and remaining shelf life of each product information can be added as columns to the inventory age to be calculated table to obtain the product shelf life calculation table. Therefore, the product shelf life calculation table can include warehouse dimension, market order dimension, SKU dimension, expiration date dimension, warehousing date dimension, product quantity dimension, statistical date dimension, remaining shelf life dimension and inventory age dimension.

[0088] The alarm method based on the expiration date of goods provided in this embodiment obtains the warehouse entry table, the end-of-period inventory table and the warehouse table from different systems, wherein each of the three tables contains several pieces of commodity information, further, sorts the warehouse entry table, and associates the end-of-period inventory table with the warehouse entry table, so as to allocate the warehouse entry quantity to each piece of commodity information in the warehouse entry table, and obtain the warehouse entry allocation table, sorts the warehouse entry allocation table and the warehouse table, and allocates the commodity quantity to each piece of commodity information in the warehouse entry allocation sorting table through the commodity quantity dimension in the warehouse table, and obtains the warehouse age to be calculated table, in which the warehouse age and the remaining shelf life of each piece of commodity information are counted, and an alarm is issued for commodity information whose warehouse age is greater than the preset warehouse age or whose remaining shelf life is less than the preset period. It can be seen that the warehouse entry table, the end-of-period inventory table and the warehouse table are derived from different systems. After the three tables are integrated for in-depth analysis, it is possible to analyze the over-warehouse age and near-expiry commodities from the warehouse age to be calculated table, thereby effectively warning the over-warehouse age and near-expiry commodities, so that the over-warehouse age / near-expiry commodities can be processed in time.

[0089] In some embodiments of the present application, the above step S120, sorting the storage-in table, and associating the end-of-period inventory table with the storage-in table, so as to allocate the storage quantity of each commodity information in the storage-in table to obtain the storage-in allocation table is introduced. The process may include:

[0090] S1. Sort each product information in the warehousing table according to the market order dimension, product dimension, warehouse ID dimension and warehousing date dimension.

[0091] For example, group the incoming table X1 by market order + SKU + warehouse, and sort it in descending order according to the incoming date to get the following table:

[0092]

[0093] S2. Associating the period-end inventory table with the inventory-in table, so as to allocate the total available inventory of each market order of each commodity in the period-end inventory table to each commodity information of the market order of the commodity in the inventory-in table, and perform limit value processing to obtain the inventory-in allocation table.

[0094] Specifically, the available inventory dimension in the period-end inventory table represents the total available inventory of various market orders, and the total available inventory of each market order can be allocated to all commodity information of the market order in the incoming inventory table.

[0095] It is understandable that the quantity of goods entering the warehouse corresponding to the market order in the warehouse entry table may be different from the available inventory in the ending inventory table, in which case limit value processing is required.

[0096] The process of the limit value processing method may include:

[0097] S21. When allocating the inventory quantity to each commodity information in the inventory table, if the commodity information corresponding to the target market order cannot be obtained, new commodity information of the target market order is created with a preset initialization date.

[0098] S22. If the available inventory corresponding to the target market order in the period-end inventory table is less than the incoming quantity corresponding to the target market order in the incoming table, the difference between the incoming quantity and the available inventory is used as the value of the incoming quantity dimension of the newly created product information, and the incoming date of the newly created product information is adjusted to the day before the earliest incoming date in the target market order.

[0099] For example, the inventory allocation table R1:

[0100]

[0101] Since the available inventory of market order US01 in the ending inventory table Y2 is 1000, and the total inventory quantity of the four market orders US01 in the inventory table Y1 is 800, it is necessary to create a new product information with market order US01. The difference of 200 is used as the inventory quantity of the new product information, and the inventory date of the new product information is adjusted to 2024 / 4 / 19, the day before the earliest inventory date of market order US01, 2024 / 4 / 20.

[0102] In some embodiments of the present application, the process of sorting the warehouse allocation table and the warehouse table in step S130, allocating the commodity quantity to each commodity information in the warehouse allocation sorting table according to the commodity quantity dimension in the warehouse table, and obtaining the warehouse age to be calculated table is introduced. The process may include:

[0103] S1. Sort the inventory allocation table according to the commodity inventory date dimension and the market order dimension to obtain the inventory allocation sorting table.

[0104] Specifically, you can group by warehouse and product granularity, and sort in ascending order according to the warehousing date. After the warehousing allocation table, the warehousing allocation sorting table obtained adds a sorting dimension, specifically:

[0105]

[0106] S2. Sort the in-warehouse table according to the warehouse dimension, product dimension, expiration date dimension, and warehousing date dimension to obtain an in-warehouse sorting table.

[0107] Specifically, we can group by warehouse + SKU, and sort the warehouse table X1 in ascending order of expiration date and descending order of entry date to obtain the warehouse sorting table, which is:

[0108]

[0109] S3. Based on the commodity expiration date dimension and the warehousing date dimension, the commodity quantity dimension in the warehouse sorting table is used to allocate the commodity quantity to each commodity information in the warehousing allocation sorting table to obtain the inventory age to be calculated table.

[0110] Specifically, the expiration date and warehousing date of the goods can be allocated according to the sorting results, wherein the allocation process is developed and implemented based on the Spark computing engine of the data middle platform system.

[0111] Based on the commodity expiration date dimension and the warehousing date dimension, the commodity quantity dimension in the warehouse sorting table is used to allocate the commodity quantity to each commodity information in the warehousing allocation sorting table, and the resulting inventory age calculation table is as follows:

[0112]

[0113] In some embodiments of the present application, the process of counting the storage age and remaining shelf life of each commodity information in the storage age to be calculated table mentioned in the above embodiment is introduced, and the process may include:

[0114] S1. In the inventory age calculation table, subtract the statistical date of each product information from the expiration date of the product information to obtain the remaining shelf life of the product information.

[0115] S2. In the inventory age to be calculated table, the inventory age of the product information is obtained by subtracting the inventory entry date of the product information from the statistical date of the product information.

[0116] Furthermore, in order to make the product information data more intuitive and more convenient for the person in charge to clean up the over-age and near-expiry products, the remaining shelf life and storage age can be stratified.

[0117] Specifically, the age of each piece of commodity information in the inventory age to be calculated table can be stratified according to the preset number of months, and the remaining shelf life of each piece of commodity information in the inventory age to be calculated table can be stratified according to the preset number of months.

[0118] Among them, it can be displayed in 6 segments. If it is stratified by month, it has [0,3), [3,6), [6,9), [9,12), [12,18), [18,+∞); if it is stratified by day, it has 0-89, 90-179, 180-269, 270-359, 360-539, 540+.

[0119] After further stratification of the remaining shelf life and storage age, the validity period and storage age analysis report can be obtained, specifically:

[0120]

[0121] It is understandable that the data middle-office system generates product expiration and inventory age analysis reports by integrating product information data tables from multiple systems, and collects and processes data automatically and regularly. The solution is efficient and accurate, which can effectively help companies reduce costs and increase efficiency while ensuring the accuracy and completeness of report data. It actually solves the problems of high cost of manual processing, high computational complexity of large data volumes, difficulty in in-depth analysis, and proneness to data errors.

[0122] The following describes a system for implementing an alarm based on the expiration date of a product provided in an embodiment of the present application. The system for implementing an alarm based on the expiration date of a product described below and the method for implementing an alarm based on the expiration date of a product described above can be referenced to each other.

[0123] See also Figure 2 , Figure 2 A schematic diagram of the structure of a system for implementing an alarm based on the expiration date of a product disclosed in an embodiment of the present application.

[0124] like Figure 2 As shown, the system may include:

[0125] Table acquisition unit 11, used to acquire a warehouse entry table from the first system, a period-end inventory table from the second system, and an in-warehouse table from the third system, wherein the warehouse entry table, the period-end inventory table, and the in-warehouse table each contain a plurality of commodity information;

[0126] The storage allocation table construction unit 12 is used to sort the storage table and associate the end-of-period inventory table with the storage table to allocate the storage quantity to each commodity information in the storage table to obtain the storage allocation table;

[0127] The storage age to be calculated table construction unit 13 is used to sort the storage allocation table and the in-warehouse table, and allocate the commodity quantity to each commodity information in the storage allocation sorting table according to the commodity quantity dimension in the in-warehouse table, so as to obtain the storage age to be calculated table;

[0128] The alarm unit 14 is used to count the storage age and remaining shelf life of each commodity information in the storage age to be calculated table, and to issue an alarm for commodity information whose storage age is greater than a preset storage age or whose remaining shelf life is less than a preset period.

[0129] Optionally, each piece of commodity information in the entry table includes a market order dimension, a commodity dimension, a warehouse ID dimension, and an entry date dimension, and each piece of information in the period-end inventory table includes an available inventory dimension;

[0130] The storage allocation table construction unit includes:

[0131] The storage entry table sorting unit is used to sort each item of product information in the storage entry table according to the market order dimension, product dimension, warehouse ID dimension and storage date dimension;

[0132] The incoming quantity allocation unit is used to associate the end-of-period inventory table with the incoming table, so as to allocate the total available inventory of each market order of each commodity in the end-of-period inventory table to each commodity information of the market order of the commodity in the incoming table, and perform limit value processing to obtain the incoming quantity allocation table.

[0133] Optionally, each piece of commodity information in the warehousing table includes a warehousing quantity dimension;

[0134] The system also includes:

[0135] The first limit value processing unit is used to create new commodity information of the target market order with a preset initialization date when allocating the inventory quantity to each commodity information in the inventory table if the commodity information corresponding to the target market order cannot be obtained;

[0136] The second limit value processing unit is used to use the difference between the incoming quantity and the available inventory as the value of the incoming quantity dimension of the newly created product information if the available inventory corresponding to the target market order in the end-of-period inventory table is less than the incoming quantity corresponding to the target market order in the incoming table, and adjust the incoming date of the newly created product information to the day before the earliest incoming date in the target market order.

[0137] Optionally, the in-warehouse table includes a warehouse dimension, a commodity dimension, an expiration date dimension, a commodity quantity dimension, and a warehousing date dimension;

[0138] The storage age to be calculated table construction unit includes:

[0139] The storage allocation table sorting unit is used to sort the storage allocation table according to the commodity storage date dimension and the market order dimension to obtain the storage allocation sorting table;

[0140] An in-warehouse table sorting unit is used to sort the in-warehouse table according to the warehouse dimension, the commodity dimension, the expiration date dimension and the warehousing date dimension to obtain an in-warehouse sorting table;

[0141] The commodity quantity allocation unit is used to allocate the commodity quantity to each commodity information in the warehousing allocation sorting table based on the commodity expiration date dimension and the warehousing date dimension through the commodity quantity dimension in the warehouse sorting table to obtain the inventory age to be calculated table.

[0142] Optionally, the inventory age to be calculated table includes a statistical date dimension;

[0143] The alarm unit comprises:

[0144] A remaining shelf life calculation unit is used to obtain the remaining shelf life of each piece of product information by subtracting the statistical date of the product information from the expiration date of the product information in the inventory age to be calculated table;

[0145] The inventory age calculation unit is used to subtract the inventory entry date of the commodity information from the statistical date of the commodity information in the inventory age to be calculated table to obtain the inventory age of the commodity information, and to issue an alarm for commodity information whose inventory age is greater than a preset inventory age or whose remaining shelf life is less than a preset period.

[0146] Optionally, the system further includes:

[0147] A stock age stratification unit, for stratifying the stock age of each piece of commodity information in the stock age to be calculated table according to the number of preset months;

[0148] The remaining shelf life stratification unit is used to stratify the remaining shelf life of each commodity information in the inventory age to be calculated table according to the remaining shelf life of the commodity information according to the preset number of months.

[0149] The alarm method based on the commodity validity period provided in the embodiment of the present application can be applied to alarm devices based on the commodity validity period, such as terminals: mobile phones, computers, etc. Optionally, Figure 3 The hardware structure diagram of the alarm device based on the expiration date of the commodity is shown in FIG. Figure 3 ,The hardware structure of the alarm device based on the commodity expiration date may include: at least one processor 1, at least one communication interface 2, at least one memory 3 and at least one communication bus 4;

[0150] In the embodiment of the present application, the number of the processor 1, the communication interface 2, the memory 3, and the communication bus 4 is at least one, and the processor 1, the communication interface 2, and the memory 3 communicate with each other through the communication bus 4;

[0151] The processor 1 may be a central processing unit CPU, or an application-specific integrated circuit ASIC (Application Specific Integrated Circuit), or one or more integrated circuits configured to implement the embodiments of the present invention, etc.;

[0152] The memory 3 may include a high-speed RAM memory, and may also include a non-volatile memory, such as at least one disk memory;

[0153] The memory stores a program, and the processor can call the program stored in the memory, wherein the program is used to:

[0154] Obtaining a stock-in table from the first system, a period-end inventory table from the second system, and an in-warehouse table from the third system, wherein the stock-in table, the period-end inventory table, and the in-warehouse table all contain a number of commodity information;

[0155] Sorting the storage entry table, and associating the period-end inventory table with the storage entry table, so as to allocate the storage quantity to each commodity information in the storage entry table, and obtaining a storage allocation table;

[0156] The warehouse allocation table and the warehouse table are sorted, and the commodity quantity is allocated to each commodity information in the warehouse allocation sorting table according to the commodity quantity dimension in the warehouse table to obtain the warehouse age to be calculated table;

[0157] The inventory age and remaining shelf life of each commodity information are counted in the inventory age to be calculated table, and an alarm is issued for commodity information whose inventory age is greater than a preset inventory age or whose remaining shelf life is less than a preset period.

[0158] Optionally, the detailed functions and extended functions of the program may refer to the above description.

[0159] The embodiment of the present application further provides a storage medium, which may store a program suitable for execution by a processor, wherein the program is used to:

[0160] Obtaining a stock-in table from the first system, a period-end inventory table from the second system, and an in-warehouse table from the third system, wherein the stock-in table, the period-end inventory table, and the in-warehouse table all contain a number of commodity information;

[0161] Sorting the storage entry table, and associating the period-end inventory table with the storage entry table, so as to allocate the storage quantity to each commodity information in the storage entry table, and obtaining a storage allocation table;

[0162] The warehouse allocation table and the warehouse table are sorted, and the commodity quantity is allocated to each commodity information in the warehouse allocation sorting table according to the commodity quantity dimension in the warehouse table to obtain the warehouse age to be calculated table;

[0163] The inventory age and remaining shelf life of each commodity information are counted in the inventory age to be calculated table, and an alarm is issued for commodity information whose inventory age is greater than a preset inventory age or whose remaining shelf life is less than a preset period.

[0164] Optionally, the detailed functions and extended functions of the program may refer to the above description.

[0165] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

[0166] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The various embodiments can be combined as needed, and the same or similar parts can refer to each other.

[0167] The above description of the disclosed embodiments enables those skilled in the art to implement or use the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. An alarm method based on commodity expiration date, characterized in that: include: Obtaining a stock-in table from the first system, a period-end inventory table from the second system, and an in-warehouse table from the third system, wherein the stock-in table, the period-end inventory table, and the in-warehouse table all contain a number of commodity information; Sorting the storage entry table, and associating the period-end inventory table with the storage entry table, so as to allocate the storage quantity to each commodity information in the storage entry table, and obtaining a storage allocation table; The warehouse allocation table and the warehouse table are sorted, and the commodity quantity is allocated to each commodity information in the warehouse allocation sorting table according to the commodity quantity dimension in the warehouse table to obtain the warehouse age to be calculated table; The inventory age and remaining shelf life of each commodity information are counted in the inventory age to be calculated table, and an alarm is issued for commodity information whose inventory age is greater than a preset inventory age or whose remaining shelf life is less than a preset period.

2. The method according to claim 1, characterized in that Each piece of commodity information in the entry table includes a market order dimension, a commodity dimension, a warehouse ID dimension, and an entry date dimension, and each piece of information in the end-of-period inventory table includes an available inventory dimension; The storage entry table is sorted, and the end-of-period inventory table is associated with the storage entry table, so as to allocate the storage quantity to each commodity information in the storage entry table, and obtain a storage entry allocation table, including: Sort each item of product information in the warehousing table according to the market order dimension, product dimension, warehouse ID dimension and warehousing date dimension; The end-of-period inventory table is associated with the incoming inventory table to allocate the total available inventory of each market order of each commodity in the end-of-period inventory table to each commodity information of the market order of the commodity in the incoming inventory table, and perform limit value processing to obtain an incoming inventory allocation table.

3. The method according to claim 2, characterized in that Each commodity information in the entry table includes an entry quantity dimension; The limit value processing method includes: When allocating the inventory quantity to each commodity information in the inventory table, if the commodity information corresponding to the target market order cannot be obtained, creating new commodity information of the target market order with a preset initialization date; If the available inventory corresponding to the target market order in the end-of-period inventory table is less than the incoming quantity corresponding to the target market order in the incoming table, the difference between the incoming quantity and the available inventory is used as the value of the incoming quantity dimension of the newly created product information, and the incoming date of the newly created product information is adjusted to the day before the earliest incoming date in the target market order.

4. The method according to claim 1, characterized in that: The in-warehouse table includes warehouse dimension, commodity dimension, expiration date dimension, commodity quantity dimension and warehousing date dimension; The warehouse allocation table and the warehouse table are sorted, and the commodity quantity is allocated to each commodity information in the warehouse allocation sorting table according to the commodity quantity dimension in the warehouse table, so as to obtain the warehouse age to be calculated table, including: Sorting the warehousing allocation table according to the commodity warehousing date dimension and the market order dimension to obtain the warehousing allocation sorting table; Sorting the in-warehouse table according to the warehouse dimension, the commodity dimension, the expiration date dimension, and the warehousing date dimension to obtain an in-warehouse sorting table; Based on the commodity expiration date dimension and the warehousing date dimension, the commodity quantity dimension in the in-warehouse sorting table is used to allocate the commodity quantity for each commodity information in the warehousing allocation sorting table to obtain the inventory age to be calculated table.

5. The method according to claim 4, characterized in that The inventory age to be calculated table includes a statistical date dimension; The inventory age and remaining shelf life of each product information are counted in the inventory age to be calculated table, including: In the inventory age calculation table, the expiration date of each product information is subtracted from the statistical date of the product information to obtain the remaining shelf life of the product information; In the inventory age to be calculated table, the inventory age of the commodity information is obtained by subtracting the inventory entry date of the commodity information from the statistical date of the commodity information.

6. The method according to claim 5, characterized in that Also includes: According to the inventory age of each piece of commodity information in the inventory age to be calculated table, the inventory age of the commodity information is layered according to the preset number of months; According to the remaining shelf life of each piece of commodity information in the inventory age to be calculated table, the remaining shelf life of the commodity information is layered according to the preset number of months.

7. An alarm system based on commodity expiration date, characterized in that: include: A table acquisition unit is used to acquire a warehouse entry table from the first system, a period-end inventory table from the second system, and an in-warehouse table from the third system, wherein the warehouse entry table, the period-end inventory table, and the in-warehouse table each contain a plurality of commodity information; A storage allocation table construction unit is used to sort the storage table and associate the end-of-period inventory table with the storage table, so as to allocate the storage quantity to each commodity information in the storage table to obtain the storage allocation table; The storage age to be calculated table construction unit is used to sort the storage allocation table and the in-warehouse table, and allocate the commodity quantity to each commodity information in the storage allocation sorting table according to the commodity quantity dimension in the in-warehouse table, so as to obtain the storage age to be calculated table; The alarm unit is used to count the storage age and remaining shelf life of each commodity information in the storage age to be calculated table, and to issue an alarm for commodity information whose storage age is greater than a preset storage age or whose remaining shelf life is less than a preset period.

8. The system according to claim 7, characterized in that Each piece of commodity information in the entry table includes a market order dimension, a commodity dimension, a warehouse ID dimension, and an entry date dimension, and each piece of information in the end-of-period inventory table includes an available inventory dimension; The storage allocation table construction unit includes: The storage entry table sorting unit is used to sort each item of product information in the storage entry table according to the market order dimension, product dimension, warehouse ID dimension and storage date dimension; The incoming quantity allocation unit is used to associate the end-of-period inventory table with the incoming table, so as to allocate the total available inventory of each market order of each commodity in the end-of-period inventory table to each commodity information of the market order of the commodity in the incoming table, and perform limit value processing to obtain the incoming quantity allocation table.

9. An alarm device based on the expiration date of a commodity, characterized in that: including memory and processor; The memory is used to store programs; The processor is used to execute the program to implement the various steps of the warning method based on the product expiration date as described in any one of claims 1-6.

10. A storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, each step of the warning method based on the product expiration date as described in any one of claims 1 to 6 is implemented.

Images