CN113793081A - Storage monitoring method and device, computer readable medium and electronic equipment - Google Patents

Storage monitoring method and device, computer readable medium and electronic equipment Download PDF

Info

Publication number
CN113793081A
CN113793081A CN202010598290.XA CN202010598290A CN113793081A CN 113793081 A CN113793081 A CN 113793081A CN 202010598290 A CN202010598290 A CN 202010598290A CN 113793081 A CN113793081 A CN 113793081A
Authority
CN
China
Prior art keywords
inventory
goods
replenished
demand information
threshold
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010598290.XA
Other languages
Chinese (zh)
Inventor
夏令
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Jingdong Century Trading Co Ltd
Beijing Wodong Tianjun Information Technology Co Ltd
Original Assignee
Beijing Jingdong Century Trading Co Ltd
Beijing Wodong Tianjun Information Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Jingdong Century Trading Co Ltd, Beijing Wodong Tianjun Information Technology Co Ltd filed Critical Beijing Jingdong Century Trading Co Ltd
Priority to CN202010598290.XA priority Critical patent/CN113793081A/en
Publication of CN113793081A publication Critical patent/CN113793081A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials

Abstract

The present disclosure provides a warehouse monitoring method, a warehouse monitoring device, a computer readable medium and an electronic device; relates to the technical field of computer application. The warehousing monitoring method comprises the following steps: acquiring purchasing demand information, and acquiring attribute information of goods to be replenished according to the purchasing demand information; capturing supply detail data corresponding to the goods to be replenished and an inventory threshold value of the goods to be replenished according to the attribute information of the goods to be replenished; and calculating the predicted inventory of the goods to be replenished by combining the supply detail data and the purchasing demand information so as to monitor the goods to be replenished for replenishing according to the predicted inventory and the inventory threshold. The warehousing monitoring method can overcome the problem of high inventory of articles to a certain extent, and further improves the accuracy of warehousing monitoring.

Description

Storage monitoring method and device, computer readable medium and electronic equipment
Technical Field
The present disclosure relates to the field of computer application technologies, and in particular, to a warehousing monitoring method, a warehousing monitoring device, a computer-readable medium, and an electronic device.
Background
Because the high inventory needs manpower for withdrawal processing and has higher cost, the high inventory is a crucial problem for both the traditional supermarket and the large supermarket under new retail sales. The traditional supermarket mainly depends on manual statistics, and the high-stock processing is carried out by checking and manually controlling the purchase of articles; the large supermarket under the new retail sale adopts daily stock daily reports for analysis, and relevant returning and supplying processing is guided, so that high stock is controlled. However, in a new retail supermarket which adopts automatic replenishment due to low efficiency of manual control, the average sales amount of 7 days or 28 days is generally used as a judgment value, and the problem of high inventory of partial articles still exists.
It is to be noted that the information disclosed in the above background section is only for enhancement of understanding of the background of the present disclosure, and thus may include information that does not constitute prior art known to those of ordinary skill in the art.
Disclosure of Invention
The present disclosure is directed to a warehouse monitoring method, a warehouse monitoring device, a computer readable medium and an electronic device, so as to overcome the problem of high inventory of articles to a certain extent and improve the accuracy of warehouse monitoring.
Additional features and advantages of the disclosure will be set forth in the detailed description which follows, or in part will be obvious from the description, or may be learned by practice of the disclosure.
According to a first aspect of the present disclosure, there is provided a warehouse monitoring method, including:
acquiring purchasing demand information, and acquiring attribute information of goods to be replenished according to the purchasing demand information;
capturing supply detail data corresponding to the goods to be replenished and an inventory threshold value of the goods to be replenished according to the attribute information of the goods to be replenished;
and calculating the predicted inventory of the goods to be replenished by combining the supply detail data and the purchasing demand information so as to monitor the goods to be replenished for replenishing according to the predicted inventory and the inventory threshold.
In an exemplary embodiment of the present disclosure, the calculating the estimated inventory of the item to be restocked in combination with the supply detail data and the procurement demand information includes:
determining a calculation algorithm of the expected inventory according to the type of the inventory threshold;
and calculating the predicted inventory of the goods to be replenished according to the calculation algorithm by combining the supply detail data and the purchasing demand information.
In an exemplary embodiment of the present disclosure, the calculating the estimated inventory of the item to be restocked in combination with the supply detail data and the procurement demand information includes:
extracting the current ordering quantity of the goods to be replenished from the purchasing demand information;
extracting the full display quantity and the available stock quantity of the goods to be restocked from the supply detail data;
calculating the projected inventory based on the current order quantity, the full array quantity, and the available inventory quantity.
In an exemplary embodiment of the present disclosure, said calculating said projected inventory from said current order quantity, said full array quantity, and said available inventory quantity comprises:
if the full display quantity is greater than the available inventory quantity, then the sum of the full display quantity and the current order quantity is calculated as the forecasted inventory.
In an exemplary embodiment of the present disclosure, the calculating the estimated inventory of the item to be restocked in combination with the supply detail data and the procurement demand information includes:
extracting the available inventory quantity of the goods to be supplemented from the supply detail data, and calculating the average sales volume of the goods to be supplemented;
extracting the current ordering quantity of the goods to be replenished from the purchasing demand information;
calculating a consumption rate of the item to be restocked as the projected inventory based on the current order quantity, the available inventory quantity, and the average sales amount.
In an exemplary embodiment of the present disclosure, the monitoring the item to be restocked for restocking according to the forecasted inventory and the inventory threshold includes:
if the estimated inventory is less than or equal to the inventory threshold, triggering a first replenishment process to replenish the goods to be replenished;
and if the estimated inventory is larger than the inventory threshold, triggering a second replenishment process so as to replenish the goods to be replenished.
In an exemplary embodiment of the present disclosure, the monitoring the item to be restocked for restocking according to the forecasted inventory and the inventory threshold includes:
displaying purchasing demand information corresponding to the goods to be supplemented in an interactive interface;
and if the estimated inventory is larger than the inventory threshold, differentially displaying the purchasing demand information corresponding to the goods to be supplemented in the interactive interface.
According to a second aspect of the present disclosure, there is provided a stock monitoring device, comprising a demand acquisition module, an inventory determination module, and a replenishment monitoring module, wherein:
the demand acquisition module is used for acquiring purchasing demand information and acquiring attribute information of goods to be replenished according to the purchasing demand information;
the inventory determining module is used for grabbing supply detail data corresponding to the goods to be replenished and an inventory threshold value of the goods to be replenished according to the attribute information of the goods to be replenished;
and the replenishment monitoring module is used for calculating the predicted inventory of the goods to be replenished by combining the supply detail data and the purchasing demand information so as to monitor the goods to be replenished for replenishment according to the predicted inventory and the inventory threshold.
In an exemplary embodiment of the present disclosure, the inventory determination module 620 may include a threshold type determination unit, and an inventory forecasting unit, wherein:
and the threshold type determining unit is used for determining a calculation algorithm of the expected inventory according to the type of the inventory threshold.
And the inventory prediction unit is used for calculating the predicted inventory of the goods to be replenished by combining the supply detail data and the purchasing demand information according to the calculation algorithm.
In an exemplary embodiment of the present disclosure, the inventory determination module 620 may include a following order quantity acquisition unit, a full display quantity acquisition unit, and a quantity calculation unit, wherein:
and the order quantity obtaining unit is used for extracting the current order quantity of the goods to be supplemented from the purchasing demand information.
And the full display quantity acquisition unit is used for extracting the full display quantity of the goods to be restocked and the available inventory quantity from the supply detail data.
A quantity calculation unit for calculating the projected inventory based on the current order quantity, the full array quantity, and the available inventory quantity.
In an exemplary embodiment of the present disclosure, the quantity calculation unit may be configured to determine that if the full array quantity is greater than the available inventory quantity, a sum of the full array quantity and the current order quantity is calculated as the forecasted inventory.
In an exemplary embodiment of the present disclosure, the inventory determination module 620 may specifically include a sales amount calculation unit, a next order number determination unit, and a consumption rate calculation unit, wherein:
and the sales calculation unit is used for extracting the available inventory quantity of the goods to be supplemented from the supply detail data and calculating the average sales of the goods to be supplemented.
And the quantity extraction unit is used for extracting the current ordering quantity of the goods to be replenished from the purchasing demand information.
A consumption rate calculation unit for calculating a consumption rate of the item to be restocked as the estimated inventory based on the current order quantity, the available inventory quantity, and the average sales amount.
In an exemplary embodiment of the present disclosure, the replenishment monitoring module 630 may include a first replenishment unit and a second replenishment unit, wherein:
the first replenishment unit is used for triggering a first replenishment process to replenish the goods to be replenished if the estimated inventory is less than or equal to the inventory threshold.
And the second replenishment unit is used for triggering a second replenishment process to replenish the goods to be replenished if the estimated inventory is greater than the inventory threshold.
In an exemplary embodiment of the present disclosure, the restocking monitoring module 630 may include an interactive interface unit and a difference display unit, wherein:
and the interactive interface unit is used for displaying the purchasing demand information corresponding to the goods to be supplemented in the interactive interface.
And the distinguishing display unit is used for distinguishing and displaying the purchasing demand information corresponding to the goods to be supplemented in the interactive interface if the estimated inventory is greater than the inventory threshold.
According to a third aspect of the present disclosure, there is provided an electronic device comprising: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to perform the method of any one of the above via execution of the executable instructions.
According to a fourth aspect of the present disclosure, there is provided a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the method of any one of the above.
Exemplary embodiments of the present disclosure may have some or all of the following benefits:
in the warehouse monitoring method provided by an example embodiment of the present disclosure, on one hand, supply detail data of an article to be replenished is captured through attribute information of the article to be replenished, the supply demand of the article can be more comprehensively monitored through the supply detail data, the predicted inventory of the article can be accurately predicted, and the article replenishment can be accurately controlled; on the other hand, the problem of high stock of the articles can be avoided by replenishing the articles according to the stock threshold and the expected stock; on the other hand, the goods replenishment can be automatically triggered through the inventory threshold value, the labor cost is reduced, and the monitoring efficiency can be improved.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure. It is to be understood that the drawings in the following description are merely exemplary of the disclosure, and that other drawings may be derived from those drawings by one of ordinary skill in the art without the exercise of inventive faculty.
FIG. 1 schematically illustrates a system architecture diagram for implementing a warehouse monitoring method according to one embodiment of the present disclosure;
FIG. 2 schematically illustrates a flow diagram of a warehouse monitoring method according to one embodiment of the present disclosure;
FIG. 3 schematically illustrates a flow diagram of a warehouse monitoring method according to another embodiment of the present disclosure;
FIG. 4 schematically illustrates a flow diagram of a warehouse monitoring method according to another embodiment of the present disclosure;
FIG. 5 schematically illustrates a flow diagram of a warehouse monitoring method according to another embodiment of the present disclosure;
FIG. 6 schematically illustrates a block diagram of a bin monitoring device according to one embodiment of the present disclosure;
FIG. 7 illustrates a schematic structural diagram of a computer system suitable for use with the electronic device to implement embodiments of the present disclosure.
Detailed Description
Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many different forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided to give a thorough understanding of embodiments of the disclosure. One skilled in the relevant art will recognize, however, that the subject matter of the present disclosure can be practiced without one or more of the specific details, or with other methods, components, devices, steps, and the like. In other instances, well-known technical solutions have not been shown or described in detail to avoid obscuring aspects of the present disclosure.
Furthermore, the drawings are merely schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and thus their repetitive description will be omitted. Some of the block diagrams shown in the figures are functional entities and do not necessarily correspond to physically or logically separate entities. These functional entities may be implemented in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and/or processor devices and/or microcontroller devices.
The technical solution of the embodiment of the present disclosure is explained in detail below:
first, a system architecture for implementing the warehouse monitoring method is provided in an exemplary embodiment of the present disclosure. Referring to fig. 1, the system architecture 100 may include terminal devices 101, 102, 103, a network 104, and a server 105. The network 104 serves as a medium for providing communication links between the terminal devices 101, 102, 103 and the server 105. Network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few.
The user may use the terminal devices 101, 102, 103 to interact with the server 105 via the network 104 to receive or send request instructions or the like. The terminal devices 101, 102, 103 may have various communication client applications installed thereon, such as a shopping application, a web browser application, a search application, an instant messaging tool, a mailbox client, social platform software, and the like.
The terminal devices 101, 102, 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.
The server 105 may be a server providing various services, such as a background management server (for example only) providing support for shopping-like websites browsed by users using the terminal devices 101, 102, 103. The backend management server may analyze and perform other processing on the received data such as the product information query request, and feed back a processing result (for example, target push information, product information — just an example) to the terminal device.
It should be noted that the warehouse monitoring method provided by the embodiment of the present disclosure is generally executed by the server 105, and accordingly, the warehouse monitoring device is generally disposed in the server 105. However, it can be understood by those skilled in the art that the warehouse monitoring method of the present disclosure may also be executed by the terminal device 101, and accordingly, the warehouse monitoring device may be disposed in the terminal device 101, which is not particularly limited in this embodiment.
Based on the above system architecture, the present exemplary embodiment provides a storage monitoring method. Referring to fig. 2, the warehouse monitoring method may include steps S210, S220, and S230, wherein:
step S210: acquiring purchasing demand information, and acquiring attribute information of the goods to be replenished according to the purchasing demand information.
Step S220: and capturing supply detail data corresponding to the goods to be replenished and an inventory threshold value of the goods to be replenished according to the attribute information of the goods to be replenished.
Step S230: and calculating the predicted inventory of the goods to be replenished by combining the supply detail data and the purchasing demand information so as to monitor the goods to be replenished for replenishing according to the predicted inventory and the inventory threshold.
In the warehouse monitoring method provided by an example embodiment of the present disclosure, on one hand, supply detail data of an article to be replenished is captured through attribute information of the article to be replenished, the supply demand of the article can be more comprehensively monitored through the supply detail data, the predicted inventory of the article can be accurately predicted, and the article replenishment can be accurately controlled; on the other hand, the problem of high stock of the articles can be avoided by replenishing the articles according to the stock threshold and the expected stock; on the other hand, the goods replenishment can be automatically triggered through the inventory threshold value, the labor cost is reduced, and the monitoring efficiency can be improved.
The above steps of the present exemplary embodiment will be described in more detail below.
In step S210, purchasing requirement information is acquired, and attribute information of the item to be replenished is acquired according to the purchasing requirement information.
The purchasing requirement information refers to a replenishing requirement of an item to be replenished, and specifically may include identification information of the item to be replenished, such as sku (Stock keeping Unit), a name, etc., a quantity of the item to be replenished requiring ordering and replenishing, a current remaining quantity, etc., and may further include other information, such as a quantity of the item to be replenished on the way of purchasing, store information for submitting the purchasing requirement information, etc., which is not particularly limited in this embodiment. The attribute information of the item to be replenished may include a name, a category, and the like of the item to be replenished, and may further include a specification, a manufacturer, and the like of the item to be replenished, which is not particularly limited in this embodiment.
In this embodiment, after the purchase demand information is acquired, the attribute information of the item to be replenished can be directly extracted from the purchase demand information. For example, the procurement demand information may be a table, and each field value in the table is extracted, so as to filter the attribute information of the item to be replenished from the field values. Or, the identification information of the goods to be replenished can be obtained from the purchasing demand information, and then the complete attribute information of the goods to be replenished is further obtained from the data platform according to the identification information. For example, the extracted identification information of the item to be restocked is sku of the item, and then the sku is used to query a database, so that complete attribute information is obtained.
In step S220, the supply detail data corresponding to the item to be replenished and the inventory threshold of the item to be replenished are captured according to the attribute information of the item to be replenished.
The supply detail data is data related to the item to be replenished, and may specifically include historical sales details, historical replenishment details, and the like of the item to be replenished, and may further include information related to a warehouse that needs replenishment, for example, the number of display items to be replenished, the size of stock, and the like, and the embodiment is not limited thereto. And, the inventory threshold of the item to be replenished can also be determined by the attribute information of the item to be replenished or the supply detail data. For example, the category of the goods to be replenished can be determined through the attribute information of the goods to be replenished, then whether the inventory threshold is set according to the judgment category or not is judged, and if the inventory threshold is set, the preset inventory threshold is obtained. The inventory threshold is an upper inventory limit of the articles to be restocked, and different stores or warehouses can set an upper inventory limit for each category of articles according to actual conditions. For example, if each level of category has a threshold set, then the threshold of the fourth level category may be preferentially extracted as the inventory threshold, and if no threshold is set in the fourth level category, the threshold of the third level category may be extracted. The threshold value can be adjusted in real time according to actual conditions, and if a plurality of set threshold values are extracted, the latest set threshold value can be preferentially used as the inventory threshold value.
Next, in step S230, a forecasted inventory of the item to be restocked is calculated by combining the supply detail data and the procurement demand information, so as to monitor the item to be restocked for restocking according to the forecasted inventory and the inventory threshold.
In this embodiment, the inventory after replenishment of the item to be replenished can be predicted by the acquired supply detail data and the acquired purchase demand information, so that the predicted inventory of the item to be replenished is obtained. And determining whether the goods to be supplemented need to be triggered to be supplemented or triggering and submitting purchasing demand information corresponding to the goods to be supplemented by comparing the expected inventory with an inventory threshold. Optionally, according to the type to which the obtained inventory threshold belongs, the manner of calculating the expected inventory may be determined. First, a type to which an inventory threshold value obtained from attribute information or supply detail data of an item to be replenished belongs is determined. For example, the inventory threshold may be classified according to the authority of the administrator who sets the inventory threshold, so as to obtain the type corresponding to the inventory threshold, for example, the primary authority, the secondary authority, and the like; the type of inventory threshold may also be determined based on the category of the item, such as a fourth category, a third category, etc.; further, the types of inventory thresholds may also include other types, such as a quantity inventory threshold, an inventory turnaround threshold, and so forth. Where the inventory turnaround threshold may refer to the turnaround rate of the item, such as an average sales volume of 7 days, etc. And then, acquiring a calculation algorithm of the expected inventory according to the type of the inventory threshold value of the goods to be replenished, and calculating the expected inventory according to the rule of the calculation algorithm.
In an exemplary embodiment, the method of calculating the expected inventory may include the following steps S310 to S330, as shown in fig. 3.
In step S310, the current order placing quantity of the item to be restocked is extracted from the purchasing requirement information. And obtaining each dimension field in the purchase demand information, and obtaining the field value of each dimension field, so that the current ordering quantity can be obtained. The current order placement quantity may include the quantity of items already in the way for the purchase, or may include the quantity that did not begin the purchase.
In step S320, the full display quantity of the item to be restocked and the available stock quantity are extracted from the supply specification data. The full display data may indicate the maximum number of the goods to be replenished in the warehouse or the store, and the available inventory number is the current remaining storage number. The store or warehouse with the need for the goods to be replenished can be extracted from the purchasing need information, so that the related data of the store or warehouse can be captured, and therefore, the supply detail data can comprise the related data of the store or warehouse. The field values of the respective fields are obtained for the respective fields included in the supply specification data, so that the available stock quantity and the full display quantity of the item to be restocked can be determined.
In step S330, the projected inventory is calculated based on the current order quantity, the full array quantity, and the available inventory quantity. Illustratively, the sum of the largest quantity plus the current order quantity may be selected as the projected inventory from between the full display quantity and the available inventory quantity. Through comparison between the estimated inventory and the inventory threshold value, the estimated inventory obtained through calculation in the mode is the maximum inventory of the goods to be replenished, so that if the estimated inventory is smaller than the inventory threshold value, the corresponding purchasing demand information can be sent to an auditing end for auditing, and then the goods to be replenished are replenished. If the estimated inventory is larger than the inventory threshold value, a key prompt can be made at the auditing end, so that the risk that the auditor possibly causes high inventory is high.
In an exemplary embodiment, the method of calculating the expected inventory may further include the following steps S410 to S430, as shown in fig. 4.
In step S410, the available inventory quantity of the item to be replenished is extracted from the supply detail data, and the average sales volume of the item to be replenished is calculated. Illustratively, a plurality of fields can be extracted from the supply detail data, so as to obtain the available stock quantity and the historical sales detail of the goods to be replenished; the historical sales detail may then be used to calculate an average sales over a period of time for the item to be restocked, such as an average sales of 7 days, 28 days, etc.
In step S420, the current order placing quantity of the item to be restocked is extracted from the purchasing requirement information. The current order quantity may include the quantity of items already in the way, e.g., in transit, of the purchase and not starting the purchase, as in step S310.
In step S430, a consumption rate of the item to be restocked is calculated as the estimated inventory based on the current order placing quantity, the available inventory quantity, and the average sales amount. Illustratively, the consumption rate may be calculated by (number of available inventory + current order quantity)/average sales.
For example, the type of the inventory threshold may be determined first, and if the type of the inventory threshold is the inventory quantity, the algorithm shown in fig. 3 may be used to calculate the forecasted inventory, and if the type of the inventory threshold is the inventory turnover, the algorithm shown in fig. 4 may be used to calculate the forecasted inventory. In other embodiments of the present disclosure, the inventory threshold may include other types, and the calculation manner of the expected inventory may also include other manners, for example, the type of the inventory threshold may be a fourth-level category, and then the sum of the full display quantity of the items to be restocked and the current order placing quantity may be obtained as the inventory threshold, and so on, which all belong to the protection scope of the present disclosure.
Because different purchasing demands have different risks for high inventory, after the expected inventory is obtained, the risk level of the purchasing demands can be determined by comparing the expected inventory with the inventory threshold, different replenishment processes can be triggered according to different risk levels, and the articles to be replenished are automatically replenished. Illustratively, a first replenishment flow may be triggered if the projected inventory is less than or equal to the inventory threshold, and a second replenishment flow may be triggered if the projected inventory is greater than the inventory threshold. Since the high inventory risk corresponding to the estimated inventory being less than or equal to the inventory threshold is small, and the high inventory risk corresponding to the estimated inventory being greater than the inventory threshold is large, the first replenishment process may be a simple process, and the second replenishment process may be a more strict process with a high focus. For example, the first purchasing process may be to send the purchasing demand information to the auditing end and the purchasing end, prompt the auditing end to replenish the goods, and directly perform purchasing after the purchasing end receives the purchasing demand information, thereby completing replenishing of the goods to be replenished; the second purchasing process can be that the purchasing demand information is firstly sent to the auditing end for manual auditing, if the auditing end passes the auditing, the auditing end sends the information to the purchasing end, the goods needing to be supplemented are supplemented, and if the auditing end fails, the goods needing to be supplemented are not supplemented. In the embodiment, the goods are supplemented through different replenishment processes corresponding to different high inventory risks, so that the high inventory risks can be accurately identified, the high inventory risks are controlled, and the accuracy of inventory monitoring is improved.
In an exemplary embodiment, an interactive interface may also be provided, and the interactive interface may be used to display the purchasing demand information of the item to be restocked. When the estimated inventory is obtained through calculation, the estimated inventory can be compared with an inventory threshold, if the estimated inventory is larger than the inventory threshold, the risk of high inventory is high, and therefore purchasing demand information with the estimated inventory larger than the inventory threshold can be displayed in a distinguishing mode in the interactive interface to prompt auditors to pay attention to the purchasing demand information. For example, procurement requirements or the like for which inventory is expected to be greater than an inventory threshold may be displayed by a color-differentiated display. In addition, other information can be displayed in the interactive interface to assist the auditor in auditing, for example, 7 balance average sales amount, 15 balance average sales amount and the like of the goods to be replenished can be displayed.
Fig. 5 shows an exemplary application scenario of the present embodiment. As shown in fig. 5, in step S501, the purchasing demand information sent by the warehouse side is received; in step S502, the item sku in the purchase demand information is acquired; in step S503, obtaining supply specification data from the item sku; acquiring the full display quantity, the available inventory quantity, the current order placing quantity and the average sales quantity corresponding to the sku from the supply detail data; in step S504, it is determined whether the supply specification data includes an inventory threshold M; if the inventory threshold is included, step S505 may be performed, and if the inventory threshold M is not included, step S507 may be performed. In step S505, the type of the inventory threshold is further determined; if the inventory threshold type is a first type, executing step S506, and if the inventory threshold type is a second type, executing step S507; in step S506, calculating a consumption rate X of the sku, and if X < ═ M, triggering a first replenishment process, and if X > M, triggering a second replenishment process; wherein the consumption rate is [ max (full display quantity, available stock quantity) + current order quantity ]/average sales; in step S507, calculating a total Y of the sku numbers, triggering a first replenishment process if Y < ═ M, and triggering a second replenishment process if Y > M; in step S507, the purchasing requirement information is sent to the second replenishment process. In the embodiment, the high warehousing risk of the goods to be supplemented is controlled through different replenishment processes, so that the warehousing of the goods to be supplemented is accurately controlled.
It should be noted that steps S501 to S508 in fig. 5 are described in the above specific embodiments, and are not described again here.
Further, in this exemplary embodiment, a warehouse monitoring device is further provided, which is configured to execute the warehouse monitoring method of the present disclosure. The device can be applied to a server or terminal equipment.
Referring to fig. 6, the warehouse monitoring device 600 may include: a demand acquisition module 610, an inventory determination module 620, and a replenishment monitoring module 630, wherein:
the demand obtaining module 610 is configured to obtain purchase demand information, and obtain attribute information of the item to be replenished according to the purchase demand information.
The inventory determining module 620 is configured to capture supply detail data corresponding to the item to be replenished and an inventory threshold of the item to be replenished according to the attribute information of the item to be replenished.
The replenishment monitoring module 630 is configured to calculate a predicted inventory of the item to be replenished in combination with the supply detail data and the procurement demand information, so as to monitor the item to be replenished for replenishment according to the predicted inventory and the inventory threshold.
In an exemplary embodiment of the present disclosure, the inventory determination module 620 may include a threshold type determination unit, and an inventory forecasting unit, wherein:
and the threshold type determining unit is used for determining a calculation algorithm of the expected inventory according to the type of the inventory threshold.
And the inventory prediction unit is used for calculating the predicted inventory of the goods to be replenished by combining the supply detail data and the purchasing demand information according to the calculation algorithm.
In an exemplary embodiment of the present disclosure, the inventory determination module 620 may include a following order quantity acquisition unit, a full display quantity acquisition unit, and a quantity calculation unit, wherein:
and the order quantity obtaining unit is used for extracting the current order quantity of the goods to be supplemented from the purchasing demand information.
And the full display quantity acquisition unit is used for extracting the full display quantity of the goods to be restocked and the available inventory quantity from the supply detail data.
A quantity calculation unit for calculating the projected inventory based on the current order quantity, the full array quantity, and the available inventory quantity.
In an exemplary embodiment of the present disclosure, the quantity calculation unit may be configured to determine that if the full array quantity is greater than the available inventory quantity, a sum of the full array quantity and the current order quantity is calculated as the forecasted inventory.
In an exemplary embodiment of the present disclosure, the inventory determination module 620 may specifically include a sales amount calculation unit, a next order number determination unit, and a consumption rate calculation unit, wherein:
and the sales calculation unit is used for extracting the available inventory quantity of the goods to be supplemented from the supply detail data and calculating the average sales of the goods to be supplemented.
And the quantity extraction unit is used for extracting the current ordering quantity of the goods to be replenished from the purchasing demand information.
A consumption rate calculation unit for calculating a consumption rate of the item to be restocked as the estimated inventory based on the current order quantity, the available inventory quantity, and the average sales amount.
In an exemplary embodiment of the present disclosure, the replenishment monitoring module 630 may include a first replenishment unit and a second replenishment unit, wherein:
the first replenishment unit is used for triggering a first replenishment process to replenish the goods to be replenished if the estimated inventory is less than or equal to the inventory threshold.
And the second replenishment unit is used for triggering a second replenishment process to replenish the goods to be replenished if the estimated inventory is greater than the inventory threshold.
In an exemplary embodiment of the present disclosure, the restocking monitoring module 630 may include an interactive interface unit and a difference display unit, wherein:
and the interactive interface unit is used for displaying the purchasing demand information corresponding to the goods to be supplemented in the interactive interface.
And the distinguishing display unit is used for distinguishing and displaying the purchasing demand information corresponding to the goods to be supplemented in the interactive interface if the estimated inventory is greater than the inventory threshold.
As each functional module of the warehouse monitoring device in the exemplary embodiment of the present disclosure corresponds to the step of the exemplary embodiment of the warehouse monitoring method, please refer to the embodiment of the warehouse monitoring method in the present disclosure for details that are not disclosed in the embodiment of the apparatus of the present disclosure.
FIG. 7 illustrates a schematic structural diagram of a computer system suitable for use with the electronic device to implement embodiments of the present disclosure.
It should be noted that the computer system 700 of the electronic device shown in fig. 7 is only an example, and should not bring any limitation to the functions and the scope of the application of the embodiments of the present disclosure.
As shown in fig. 7, the computer system 700 includes a Central Processing Unit (CPU)701, which can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)702 or a program loaded from a storage section 708 into a Random Access Memory (RAM) 703. In the RAM 703, various programs and data necessary for system operation are also stored. The CPU 701, the ROM 702, and the RAM 703 are connected to each other via a bus 704. An input/output (I/O) interface 705 is also connected to bus 704.
The following components are connected to the I/O interface 705: an input portion 706 including a keyboard, a mouse, and the like; an output section 707 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage section 708 including a hard disk and the like; and a communication section 709 including a network interface card such as a LAN card, a modem, or the like. The communication section 709 performs communication processing via a network such as the internet. A drive 710 is also connected to the I/O interface 705 as needed. A removable medium 711 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 710 as necessary, so that a computer program read out therefrom is mounted into the storage section 707 as necessary.
In particular, the processes described below with reference to the flowcharts may be implemented as computer software programs, according to embodiments of the present disclosure. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program can be downloaded and installed from a network through the communication section 709, and/or installed from the removable medium 711. The computer program, when executed by a Central Processing Unit (CPU)701, performs various functions defined in the methods and apparatus of the present application.
It should be noted that the computer readable media shown in the present disclosure may be computer readable signal media or computer readable storage media or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In contrast, in the present disclosure, a computer-readable signal medium may include a propagated data signal with computer-readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present disclosure may be implemented by software, or may be implemented by hardware, and the described units may also be disposed in a processor. Wherein the names of the elements do not in some way constitute a limitation on the elements themselves.
As another aspect, the present application also provides a computer-readable medium, which may be contained in the electronic device described in the above embodiments; or may exist separately without being assembled into the electronic device. The computer readable medium carries one or more programs which, when executed by an electronic device, cause the electronic device to implement the method as described in the embodiments below. For example, the electronic device may implement the steps shown in fig. 1 and 2, and so on.
It should be noted that although in the above detailed description several modules or units of the device for action execution are mentioned, such a division is not mandatory. Indeed, the features and functionality of two or more modules or units described above may be embodied in one module or unit, according to embodiments of the present disclosure. Conversely, the features and functions of one module or unit described above may be further divided into embodiments by a plurality of modules or units.
Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.
It will be understood that the present disclosure is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims (10)

1. A method for monitoring a storage, comprising:
acquiring purchasing demand information, and acquiring attribute information of goods to be replenished according to the purchasing demand information;
capturing supply detail data corresponding to the goods to be replenished and an inventory threshold value of the goods to be replenished according to the attribute information of the goods to be replenished;
and calculating the predicted inventory of the goods to be replenished by combining the supply detail data and the purchasing demand information so as to monitor the goods to be replenished for replenishing according to the predicted inventory and the inventory threshold.
2. The method of claim 1, wherein said calculating a projected inventory of said item to be restocked in conjunction with said supply detail data and said procurement requirements information comprises:
determining a calculation algorithm of the expected inventory according to the type of the inventory threshold;
and calculating the predicted inventory of the goods to be replenished according to the calculation algorithm by combining the supply detail data and the purchasing demand information.
3. The method of claim 1, wherein said calculating a projected inventory of said item to be restocked in conjunction with said supply detail data and said procurement requirements information comprises:
extracting the current ordering quantity of the goods to be replenished from the purchasing demand information;
extracting the full display quantity and the available stock quantity of the goods to be restocked from the supply detail data;
calculating the projected inventory based on the current order quantity, the full array quantity, and the available inventory quantity.
4. The method of claim 3, wherein said calculating said projected inventory from said current order quantity, said full array quantity, and said available inventory quantity comprises:
if the full display quantity is greater than the available inventory quantity, then the sum of the full display quantity and the current order quantity is calculated as the forecasted inventory.
5. The method of claim 1, wherein said calculating a projected inventory of said item to be restocked in conjunction with said supply detail data and said procurement requirements information comprises:
extracting the available inventory quantity of the goods to be supplemented from the supply detail data, and calculating the average sales volume of the goods to be supplemented;
extracting the current ordering quantity of the goods to be replenished from the purchasing demand information;
calculating a consumption rate of the item to be restocked as the projected inventory based on the current order quantity, the available inventory quantity, and the average sales amount.
6. The method of claim 1, wherein monitoring the item to be restocked for restocking based on the projected inventory and the inventory threshold comprises:
if the estimated inventory is less than or equal to the inventory threshold, triggering a first replenishment process to replenish the goods to be replenished;
and if the estimated inventory is larger than the inventory threshold, triggering a second replenishment process so as to replenish the goods to be replenished.
7. The method of claim 6, wherein said monitoring the item to be restocked for restocking based on the projected inventory and the inventory threshold comprises:
displaying purchasing demand information corresponding to the goods to be supplemented in an interactive interface;
and if the estimated inventory is larger than the inventory threshold, differentially displaying the purchasing demand information corresponding to the goods to be supplemented in the interactive interface.
8. A storage monitoring device, comprising:
the demand acquisition module is used for acquiring purchasing demand information and acquiring attribute information of goods to be replenished according to the purchasing demand information;
the inventory determining module is used for grabbing supply detail data corresponding to the goods to be replenished and an inventory threshold value of the goods to be replenished according to the attribute information of the goods to be replenished;
and the replenishment monitoring module is used for calculating the predicted inventory of the goods to be replenished by combining the supply detail data and the purchasing demand information so as to monitor the goods to be replenished for replenishment according to the predicted inventory and the inventory threshold.
9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the method of any one of claims 1 to 7.
10. An electronic device, comprising:
a processor; and
a memory for storing executable instructions of the processor;
wherein the processor is configured to perform the method of any of claims 1-7 via execution of the executable instructions.
CN202010598290.XA 2020-06-28 2020-06-28 Storage monitoring method and device, computer readable medium and electronic equipment Pending CN113793081A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010598290.XA CN113793081A (en) 2020-06-28 2020-06-28 Storage monitoring method and device, computer readable medium and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010598290.XA CN113793081A (en) 2020-06-28 2020-06-28 Storage monitoring method and device, computer readable medium and electronic equipment

Publications (1)

Publication Number Publication Date
CN113793081A true CN113793081A (en) 2021-12-14

Family

ID=79181202

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010598290.XA Pending CN113793081A (en) 2020-06-28 2020-06-28 Storage monitoring method and device, computer readable medium and electronic equipment

Country Status (1)

Country Link
CN (1) CN113793081A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114943483A (en) * 2022-06-27 2022-08-26 广州市尚为供应链科技有限公司 Intelligent management system for logistics supply chain
CN114997970A (en) * 2022-07-19 2022-09-02 国网浙江省电力有限公司 Purchasing plan management and control method based on cloud platform and ERP system
CN117557204A (en) * 2024-01-12 2024-02-13 北京帮邦通达医疗器械有限公司 Purchasing business management method and device based on ERP, electronic equipment and medium

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114943483A (en) * 2022-06-27 2022-08-26 广州市尚为供应链科技有限公司 Intelligent management system for logistics supply chain
CN114943483B (en) * 2022-06-27 2023-02-03 广州市尚为供应链科技有限公司 Intelligent management system for logistics supply chain
CN114997970A (en) * 2022-07-19 2022-09-02 国网浙江省电力有限公司 Purchasing plan management and control method based on cloud platform and ERP system
CN117557204A (en) * 2024-01-12 2024-02-13 北京帮邦通达医疗器械有限公司 Purchasing business management method and device based on ERP, electronic equipment and medium

Similar Documents

Publication Publication Date Title
CN106980955B (en) Method and apparatus for outputting information
US11367044B2 (en) Method and apparatus for outputting storage position information
CN110751497A (en) Commodity replenishment method and device
CN113793081A (en) Storage monitoring method and device, computer readable medium and electronic equipment
CN106897905B (en) Method and device for pushing information and electronic equipment
CN107845016B (en) Information output method and device
CN109544076B (en) Method and apparatus for generating information
CN110348921B (en) Method and device for selecting store articles
JP2022547230A (en) Method, device, electronic device and storage medium for determining storage location
CN110874751A (en) Supermarket replenishment method and system
CN113095893A (en) Method and device for determining sales of articles
CN110929136A (en) Personalized recommendation method and device
CN112488602A (en) Replenishment method, device and system
CN108595448A (en) Information-pushing method and device
CN112784212B (en) Inventory optimization method and device
CN111612385B (en) Method and device for clustering articles to be distributed
CN110838019A (en) Method and device for determining trial supply distribution crowd
CN114663015A (en) Replenishment method and device
CN111753614A (en) Commodity shelf monitoring method and device
CN111746992B (en) AGV-based automatic warehouse goods storage position determination method and device
CN110826948B (en) Warehouse selecting method and device
CN113762863A (en) Inventory management method and device
CN113762675A (en) Information generation method, device, server, system and storage medium
CN112418898A (en) Article demand data analysis method and device based on multi-time window fusion
CN112989175A (en) Article pushing method, device, equipment and medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination