Replenishment data processing method and device, electronic equipment and storage medium
By displaying the detailed calculation process of replenishment data in the warehouse management system, the problem of users having difficulty tracing the reasons for abnormal replenishment data is solved, and the visualization and interpretability of replenishment data are realized, thereby improving the accuracy and efficiency of replenishment data.
Patent Information
- Application Number
- CN202511435256.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-10-09
- Publication Date
- 2026-02-24
AI Technical Summary
Existing warehouse management systems (WMS) cannot clearly present the intermediate calculation logic of replenishment data, making it difficult for users to trace the cause of anomalies when they find inaccurate data, resulting in low replenishment efficiency.
By displaying the historical replenishment record query page, showing the replenishment details of out-of-stock products, receiving traceability operations, displaying the replenishment decision information prompt page, and showing the sorting results of the replenishment source and destination warehouse locations and available inventory information, the replenishment data decision-making process is visualized.
It improves the efficiency of tracing the causes of replenishment data anomalies and modifying the data, makes the calculation process of replenishment data interpretable, and improves the accuracy of replenishment data and the overall efficiency of warehouse operations.
Smart Images

Figure CN121563367A_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of warehousing and logistics technology, and in particular to a replenishment data processing method and apparatus, electronic equipment and storage medium. Background Technology
[0002] Replenishment refers to the process of moving goods from the warehouse storage area to the shelves or picking area based on sales data or inventory status. A Warehouse Management System (WMS) typically generates replenishment data reports through complex configuration items and multi-layered nested logic calculations. When generating these reports, various factors need to be considered, such as the amount of goods in transit, recommended source warehouse locations, and calculations for multiple batches. These factors collectively influence the final replenishment data presented to the user.
[0003] The WMS system in related technologies can only present the final replenishment data report, but the intermediate calculation logic of the replenishment data is not visible. This makes it impossible for users to accurately locate the source and decision basis of the replenishment data when they have questions about the replenishment data or believe that the replenishment data is incorrect, resulting in low efficiency for users to trace the cause of the replenishment data anomaly.
[0004] Therefore, how to provide a replenishment data processing method that can clearly present the large-scale and complex replenishment data calculation process to users in order to improve the efficiency of tracing the causes of replenishment data anomalies has become an urgent problem to be solved. Summary of the Invention
[0005] The main objective of this application is to provide a replenishment data processing method, apparatus, electronic device, and storage medium, which aims to clearly present the large-scale and complex replenishment data calculation process to the user, thereby improving the efficiency of tracing the causes of replenishment data anomalies.
[0006] To achieve the above objectives, a first aspect of this application proposes a replenishment data processing method, the method comprising: Display a historical replenishment record query page, and display at least one historical replenishment record on the historical replenishment record query page, with each historical replenishment record corresponding to a stock-out item; In response to the selection of a target historical replenishment record from the at least one historical replenishment record, a replenishment details page is displayed, and replenishment data of the target out-of-stock product corresponding to the target historical replenishment record is displayed on the replenishment details page; The system receives a traceability operation on the replenishment details page to trace the replenishment data, and displays a replenishment decision information prompt page corresponding to the replenishment data. The replenishment decision information prompt page displays multiple first sorting results for replenishment source locations and available inventory information for each replenishment source location. The replenishment decision information prompt page also displays multiple second sorting results for replenishment destination locations and replenishment information for each replenishment destination location. The replenishment information is generated based on the shortage demand information of the target out-of-stock item and the available inventory information. Each first sorting result is obtained by sorting the replenishment source locations based on preset replenishment source location configuration information, and each second sorting result is obtained by sorting the replenishment destination locations based on preset replenishment destination location configuration information.
[0007] To achieve the above objectives, a second aspect of this application provides a replenishment data processing apparatus, the apparatus comprising: The first display unit is used to display a historical replenishment record query page, and to display at least one historical replenishment record on the historical replenishment record query page, each of the historical replenishment records corresponding to a stock-out item; The second display unit is configured to display a replenishment details page in response to the selection trigger of a target historical replenishment record in the at least one historical replenishment record, and to display the replenishment data of the target out-of-stock product corresponding to the target historical replenishment record on the replenishment details page; The third display unit is used to receive the traceability operation of the replenishment data on the replenishment details page and display the replenishment decision information prompt page corresponding to the replenishment data; The fourth display unit is used to display multiple first sorting results of replenishment source warehouse locations and available inventory information of each replenishment source warehouse location on the replenishment decision information prompt page, and to display multiple second sorting results of replenishment destination warehouse locations and replenishment information to be replenished for each replenishment destination warehouse location on the replenishment decision information prompt page. The replenishment information to be replenished is generated based on the shortage demand information of the target out-of-stock product and the available inventory information. Each first sorting result is obtained by sorting the replenishment source warehouse locations based on preset replenishment source warehouse location configuration information, and each second sorting result is obtained by sorting the replenishment destination warehouse locations based on preset replenishment destination warehouse location configuration information.
[0008] To achieve the above objectives, a third aspect of the present application provides an electronic device, the electronic device including a memory and a processor, the memory storing a computer program, and the processor executing the computer program to implement the method described in the first aspect.
[0009] To achieve the above objectives, a fourth aspect of the present application provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the method described in the first aspect.
[0010] The replenishment data processing method, apparatus, electronic device, and storage medium proposed in this application display a historical replenishment record query page, presenting historical replenishment records corresponding to out-of-stock items, receiving traceability operations, and then displaying multiple first sorting results generated based on replenishment source warehouse location configuration information and available inventory information for each warehouse location. It also displays multiple second sorting results generated based on replenishment destination warehouse location configuration information and pending replenishment information for each warehouse location. Thus, the embodiments of this application visualize the replenishment data decision-making process, clearly presenting the large-scale and complex replenishment data calculation process to the user, making the replenishment data calculation process interpretable. Compared to related technologies where users cannot promptly know the specific modifications or quickly find the cause of the anomaly when replenishment data is manually modified or contains errors, this application can improve the efficiency of tracing the cause of replenishment data anomalies or modifications. Attached Figure Description
[0011] Figure 1 This is a flowchart of the replenishment data processing method provided in the embodiments of this application; Figure 2 This is a schematic diagram of a replenishment data query page provided in an embodiment of this application; Figure 3 This is a schematic diagram of a historical replenishment record query page provided in an embodiment of this application; Figure 4A This is a schematic diagram of a replenishment details page provided in an embodiment of this application; Figure 4B This is a schematic diagram of an order details page provided in an embodiment of this application; Figure 5 This is a schematic diagram illustrating the configuration information for setting replenishment source warehouse locations provided in this application; Figure 6 This is a flowchart illustrating the process for determining the target replenishment source location provided in this application; Figures 7A to 7C A schematic diagram illustrating the process of querying source location decision information provided for this application; Figure 8 Another schematic diagram of the replenishment details page provided in the embodiments of this application; Figures 9A to 9B A schematic diagram illustrating the process of querying destination storage location decision information provided in this application; Figure 10 This is a flowchart illustrating the process for determining the target replenishment destination warehouse location provided in this application; Figure 11 This is a schematic diagram of the structure of the replenishment data processing device provided in the embodiments of this application; Figure 12 This is a schematic diagram of the hardware structure of the electronic device provided in the embodiments of this application. Detailed Implementation
[0012] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.
[0013] It should be noted that although functional modules are divided in the device schematic diagram and a logical order is shown in the flowchart, in some cases, the steps shown or described may be performed in a different order than the module division in the device or the order in the flowchart. The terms "first," "second," etc., in the specification, claims, and the aforementioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence.
[0014] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs. The terminology used herein is for the purpose of describing embodiments of this application only and is not intended to limit this application.
[0015] Replenishment refers to the process of moving goods from the warehouse storage area to the shelves or picking area based on sales data or inventory status, and it is a core part of warehousing operations. Currently, Warehouse Management Systems (WMS) typically generate replenishment data reports for goods through complex configuration items and multi-layered nested logical calculations.
[0016] However, warehousing operations vary greatly across industries and scales. Therefore, the replenishment configurations used by each warehouse differ when generating replenishment data reports. Setting up replenishment configurations requires considering complex, nested factors such as the quantity of goods in transit, matching order demand with inventory, recommending source and destination warehouse locations, and calculating various batches. Changes in the calculation logic of each replenishment data step will affect the calculation results of subsequent steps, thus impacting the final replenishment data presented.
[0017] The WMS system in related technologies can only present the final replenishment data report. However, the calculation process involved in generating this report is like a "black box." When users subjectively believe the data in the report is inaccurate (e.g., inaccurate warehouse location recommendations or inaccurate replenishment quantity calculations), they cannot trace the cause of the inaccuracy based on the report, resulting in low efficiency in tracing the reasons for replenishment data anomalies. In this situation, users can only refer to the out-of-stock items identified by the WMS system and replenish based on human experience, leading to low replenishment accuracy. Furthermore, when replenishment data is manually modified, staff reviewing the data later cannot know the specific changes. Order clerks typically need to perform another manual data analysis and then communicate the replenishment request to the warehouse control team via offline work messages, further hindering the tracing of data modifications and ultimately resulting in low replenishment efficiency.
[0018] Based on this, embodiments of this application provide a replenishment data processing method and apparatus, electronic device and storage medium, which aim to clearly present the large-scale and complex replenishment data calculation process to users, thereby improving the efficiency of tracing the causes of replenishment data anomalies.
[0019] The replenishment data processing method, apparatus, electronic device, and storage medium provided in this application are specifically described through the following embodiments. First, the replenishment data processing method in this application embodiment is described.
[0020] The replenishment data processing method provided in this application relates to the field of warehousing and logistics technology. This method can be applied to a terminal, a server, or software running on either a terminal or a server. In some embodiments, the terminal can be a smartphone, tablet, laptop, desktop computer, etc.; the server can be configured as an independent physical server, a server cluster or distributed system composed of multiple physical servers, or a cloud server providing basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms; the software can be an application implementing the replenishment data processing method, but is not limited to the above forms.
[0021] This application can be used in a wide variety of general-purpose or special-purpose computer system environments or configurations. Examples include: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, and distributed computing environments including any of the above systems or devices. This application can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc., that perform specific tasks or implement specific abstract data types. This application can also be practiced in distributed computing environments where tasks are performed by remote processing devices connected via a communication network. In distributed computing environments, program modules can reside in local and remote computer storage media, including storage devices.
[0022] Figure 1 This is an optional flowchart of the replenishment data processing method provided in the embodiments of this application. Figure 1 The method may include, but is not limited to, steps S101 to S104.
[0023] Step S101: Display the historical replenishment record query page, and display at least one historical replenishment record on the historical replenishment record query page; Step S102: In response to the selection of a target historical replenishment record from at least one historical replenishment record, a replenishment details page is displayed, and the replenishment data of the target out-of-stock product corresponding to the target historical replenishment record is displayed on the replenishment details page; Step S103: Receive the traceability operation for tracing the replenishment data on the replenishment details page, and display the replenishment decision information prompt page corresponding to the replenishment data; Step S104: Display multiple first sorting results of replenishment source locations and available inventory information for each replenishment source location on the replenishment decision information prompt page; and display multiple second sorting results of replenishment destination locations and replenishment information for each replenishment destination location on the replenishment decision information prompt page.
[0024] Steps S101 to S104 of this embodiment involve displaying a historical replenishment record query page, presenting the historical replenishment records corresponding to the out-of-stock items, receiving traceability operations, and then displaying multiple first sorting results generated based on the replenishment source warehouse location configuration information and the available inventory information of each warehouse location. Additionally, multiple second sorting results generated based on the replenishment destination warehouse location configuration information and the replenishment information to be replenished for each warehouse location are also displayed. Thus, this embodiment visualizes the replenishment data decision-making process, clearly presenting the large-scale and complex replenishment data calculation process to the user, making the replenishment data calculation process interpretable. Compared to related technologies where users cannot promptly know the specific modifications or quickly find the cause of the anomaly when replenishment data is manually modified or contains errors, this application improves the efficiency of tracing the cause of replenishment data anomalies or modifications.
[0025] In step S101 of some embodiments, before introducing the historical replenishment record query page, the query method of the replenishment data report provided in this application embodiment will be introduced first. Here, the replenishment data report refers to the data generated based on orders received up to the current query time. For example, please refer to... Figure 2 , Figure 2 This is a schematic diagram of a replenishment data query page provided in an embodiment of this application. The replenishment data query page 200 includes an order filtering parameter setting area 210 and a replenishment data report display area 220. The order filtering parameter setting area 210 includes multiple order filtering parameter setting items. These items are used to set filtering parameters for the orders required to generate the replenishment data report. Specifically, they filter all orders received before the current query time to obtain the target orders for generating the replenishment data report. The order filtering parameter items may include parameters such as replenishment quantity calculation rules, order status, owner information, replenishment plan, and product category. For example, by setting the product category to "beauty," beauty orders can be filtered from the received orders.
[0026] Furthermore, a replenishment data report can be generated based on the filtered orders. The replenishment data query page also includes a replenishment data report query control 211. In response to the triggering operation of the replenishment data report query control 211, the replenishment data report is displayed in the replenishment data report display area 220. The replenishment data report includes multiple rows of replenishment data, such as... Figure 2 As shown, it can include replenishment data with serial numbers 1, 2, and 3. Each row of replenishment data corresponds to the replenishment data obtained by summarizing a specific out-of-stock SKU (product) from the filtered orders. For example, if the orders of supplier A are filtered, the replenishment data report can include the replenishment data corresponding to SKU1, SKU2, and SKU3 respectively. Continue to refer to... Figure 2Replenishment data can include suggested replenishment quantity, owner code, product name, out-of-stock status, and replenishment status.
[0027] Furthermore, a snapshot of the corresponding replenishment data calculation record can be generated for each row of replenishment data in the replenishment data report. For example, replenishment data calculation records can be generated for the replenishment data corresponding to SKU1, SKU2, and SKU3 respectively, resulting in three replenishment data calculation records, which can then be displayed. Thus, this embodiment of the application provides a method for querying and tracing the replenishment data calculation process, which will be described in detail below.
[0028] In this embodiment, a historical replenishment record query page can be displayed on a terminal device. This page shows snapshots of historical replenishment data reports aggregated based on out-of-stock items. Specifically, the historical replenishment record query page can present multiple historical replenishment records in a list format. Each record corresponds to a product that became out of stock during the historical replenishment data calculation process, i.e., an out-of-stock product. As described above, a single replenishment data report query operation can retrieve multiple replenishment data records. Each replenishment data record can correspond to a SKU, and corresponding replenishment data calculation records can be generated for each replenishment data record. Multiple queries of the replenishment report for the same product will also present multiple snapshot records. Based on the aforementioned example, corresponding replenishment data calculation records can be generated for the replenishment data of SKU1, SKU2, and SKU3 respectively.
[0029] In addition, each historical replenishment record also includes the corresponding replenishment generation time, so that the object can locate the historical replenishment data calculation process that needs to be traced by the product code (SKU code) and the replenishment generation time. The storage time of historical replenishment records can be determined according to actual needs, such as saving a snapshot of the records generated after each replenishment data calculation performed by the WMS system within the past three months.
[0030] Please refer to Figure 3 , Figure 3 This is a schematic diagram of the historical replenishment record query page provided in this application. For example... Figure 3 As shown, the historical replenishment record query page 300 can include multiple historical replenishment record filter items, such as owner, product code, and replenishment generation time. The terminal can receive settings for the historical replenishment record filter items and then respond accordingly. Figure 3 The query control in the middle triggers an action to display historical replenishment records corresponding to the filter conditions. For example, if the replenishment generation time is set to August 20, 20XX to September 20, 20XX, the terminal will display the historical replenishment records corresponding to that period on the historical replenishment record query page. Figure 3As shown, each historical replenishment record can include information such as serial number, owner code, product name, replenishment generation time, replenishment generator, and operation options (such as viewing) for each historical replenishment record.
[0031] In step S102 of some embodiments, the WMS system can respond to an object's selection operation on any historical replenishment record (i.e., the target historical replenishment record), then jump to the replenishment details page, and display the replenishment data of the target out-of-stock item corresponding to the target historical replenishment record on the replenishment details page. Please continue to refer to... Figure 3 The selection operation for the target historical replenishment record can be performed by... Figure 3 The implementation of the trigger operation of the viewing control corresponding to the target historical replenishment record. The replenishment data includes a snapshot of historical outbound order data aggregated based on the dimension of out-of-stock products. The replenishment data can include all out-of-stock orders for a single out-of-stock product in the target historical replenishment record. Specifically, it can include the number of out-of-stock orders, out-of-stock order attribute information (such as order status and order number), out-of-stock batch, and the total quantity of products to be shipped and the total quantity of out-of-stock products corresponding to all out-of-stock orders. The replenishment data can also include the quantity of out-of-stock products in the demand batch corresponding to each out-of-stock order.
[0032] Please refer to Figure 4A , Figure 4A This is a schematic diagram of the replenishment details page provided in this application. The replenishment details page 400 is used to display the replenishment data of the target out-of-stock product. It may include options to view out-of-stock order details and actual replenishment data. The terminal can respond to the trigger operation of the out-of-stock order details option and display the summary data of out-of-stock order details, such as... Figure 4A As shown, the out-of-stock order details summary data includes summary data of out-of-stock orders under different replenishment quantity calculation rules and replenishment order statuses. The replenishment quantity calculation rules can include out-of-stock quantity and clearance sales. The replenishment order status can include generated shipping order and partial allocation. Generating shipping order indicates a pre-replenishment step performed before inventory allocation for the order. Partial allocation indicates a step performed when out-of-stock items are detected during inventory allocation for the order, followed by replenishment data calculation. Specifically, out-of-stock order data can include order status, product name, out-of-stock order quantity, total quantity to be shipped, total out-of-stock quantity, order batch, and operation options. The operation options can include the order details control 410.
[0033] The terminal can respond to a trigger operation on the order details control 410 and display the corresponding order details page. For example, in response to a trigger operation on the "View Order Details" option corresponding to the second row of out-of-stock order details summary data in the replenishment details page, the corresponding order details page can be displayed. For details, please refer to... Figure 4B , Figure 4BThis is a schematic diagram of the order details page provided in this application. The order details page 411 is used to display the order details of the out-of-stock orders included in each out-of-stock order details. For example, if there are three out-of-stock orders in the out-of-stock order details, the order details page 411 can specifically include the order number, order number, business document number (EPR number), product name, quantity to be shipped, out-of-stock quantity, and batch requirements corresponding to these three out-of-stock orders. Users can trace the specific information of the out-of-stock orders on the order details page. In this way, the order details page provided in this application embodiment displays detailed data of out-of-stock orders, making the process of generating replenishment data traceable and interpretable.
[0034] In step S103 of some embodiments, a traceability operation initiated by an object on the replenishment details page can be received, and then a replenishment decision information prompt page corresponding to the historical replenishment record can be displayed. The traceability operation refers to tracing the calculation process of the currently viewed replenishment data, or it can refer to finding the cause of inaccurate replenishment data, or it can include viewing the specific modifications to the replenishment data. The traceability operation can be triggered by controls or by voice control commands; there are no limitations here. The replenishment decision information prompt page can be a separate page from the replenishment details page or a pop-up page; there are no limitations here. The replenishment decision information prompt page can be used to display the calculation process of the replenishment data, specifically including the suggested replenishment quantity, source warehouse location, and destination warehouse location for each product or each demand batch. The replenishment decision information prompt page can reveal the deep system calculation logic and decision basis of the replenishment data, presenting the replenishment data calculation process within the WMS system to the object in a visual way, realizing the transparency of the replenishment data, making the generation or modification of the replenishment data explainable, thereby increasing the object's trust in the replenishment data.
[0035] In step S104 of some embodiments, multiple first sorting results of replenishment source locations and available inventory information for each replenishment source location can be displayed on the replenishment decision information prompt page. The first sorting results represent the intermediate priority sorting results and the final priority sorting results for each replenishment source location in multiple sequentially executed source location priority sorting stages, and fully record the change process of the priority order of the replenishment source locations. For example, the replenishment decision information prompt page can intuitively display the rise and fall of the priority order corresponding to each replenishment source location through fields such as current priority, previous priority, and change from the previous priority, thereby decomposing a complex, multi-condition replenishment source location decision process into a series of coherent and traceable sorting steps.
[0036] The first ranking result is obtained by sorting the available replenishment source locations based on preset replenishment source location configuration information. This replenishment source location configuration information can represent a priority ranking strategy or a replenishment rule for the source location. Each replenishment source location configuration can correspond to a supplier and can include multiple dimensions of location priority configuration parameters. Each first ranking result can represent the result of prioritizing replenishment source locations based on one dimension of location priority configuration parameters. The replenishment source location configuration information is comprehensively set based on business rules, warehousing operation goals, and warehouse layout. Specifically, it can be set based on batch attribute management requirements of goods, such as first-in-first-out (FIFO) or first-to-expires (FIFO) inventory turnover principles. Furthermore, the replenishment source location configuration information can also be set based on the goal of improving warehouse operation efficiency; for example, to minimize picking paths, shortest path priority configuration information can be set. Moreover, the replenishment source location configuration information can also be set according to the real-time status of the locations; for example, a clearing priority rule can prioritize replenishment source locations that need to be cleared. Available inventory information for replenishment source locations may include available replenishment source locations, the location code corresponding to each replenishment source location, the product batch, and the available inventory quantity.
[0037] The replenishment decision information prompt page can also display multiple second sorting results for replenishment destination warehouse locations and the replenishment information to be replenished for each replenishment destination warehouse location. The multiple second sorting results can be obtained by sorting the replenishment destination warehouse locations based on preset replenishment destination warehouse location configuration information. The replenishment destination warehouse location configuration information can represent a replenishment destination warehouse location priority sorting strategy or a destination warehouse location replenishment rule. Each replenishment destination warehouse location configuration information can correspond to a supplier. The replenishment destination warehouse location configuration information can include warehouse location priority configuration parameters of multiple dimensions. Each second sorting result can represent the result of prioritizing the replenishment destination warehouse locations based on warehouse location priority configuration parameters of one dimension. The replenishment information is generated based on the shortage demand information and available inventory information of the target out-of-stock product. The shortage demand information of the target out-of-stock product can represent the out-of-stock order, the order demand batch contained in the out-of-stock order, and the quantity of products that need to be replenished corresponding to the order demand batch. The shortage demand information can be obtained by matching the quantity of products corresponding to the demand batch contained in the shortage order of the target out-of-stock product with the inventory data corresponding to the demand batch. The available inventory information can include the inventory batch of the product stored in each replenishment source warehouse and its corresponding inventory quantity.
[0038] This application clearly demonstrates to users the WMS system's final recommended replenishment source locations and their corresponding available inventory information, as well as the replenishment destination locations and their corresponding replenishment information. It also fully illustrates the decision-making process for recommending replenishment source and destination locations, enabling users to intuitively understand the matching rationale, capacity status, and priority changes of each candidate replenishment location under corresponding configuration information. This improves the interpretability of replenishment location allocation. When users have questions about the replenishment data provided by the WMS system, they can accurately pinpoint the mismatch between system configuration and actual order demand by following the above steps, thereby effectively adjusting the replenishment data and improving replenishment accuracy and overall warehouse operation efficiency.
[0039] In some embodiments, the replenishment details page includes a source location decision information query control, which receives a traceability operation on the replenishment details page to trace the replenishment data, and displays a replenishment decision information prompt page corresponding to the replenishment data, including the following steps: In response to the triggering operation of the source warehouse location decision information query control, a source warehouse location decision information prompt page is displayed; Correspondingly, the replenishment decision information prompt page displays multiple first-order results for replenishment source locations and the available inventory information for each replenishment source location, including the following steps: The source location decision information prompt page displays multiple first-order results of replenishment source locations and the available inventory information for each replenishment source location.
[0040] As previously described, the traceability operation for replenishment data can be triggered by a control. In this embodiment, the replenishment details page may include a source warehouse location decision information query control. When an object has questions about the replenishment data (e.g., replenishment quantity) provided by the WMS system, it can initiate a traceability request for the replenishment source warehouse location by triggering this control (e.g., clicking the mouse). The terminal can respond to the triggering operation of the source warehouse location decision information query control by displaying a source warehouse location decision information prompt page. This prompt page can be used to display the decision process of the replenishment source warehouse location corresponding to the target historical replenishment record and the available inventory information. The decision process may include multiple first sorting results, and the available inventory information may specifically include the warehouse location code, inventory batch, and available inventory quantity corresponding to each replenishment source warehouse location. Next, the generation process of the first sorting results will be described in detail.
[0041] In some embodiments, the replenishment source location configuration information includes source location range configuration information, inventory batch configuration information, and location search method configuration information. The process of generating the first sorting result includes the following steps: Determine the candidate replenishment source locations for the target out-of-stock goods based on the source location range configuration information; The candidate replenishment source locations are sorted according to the inventory batch configuration information, and the initial source location priority is updated according to the sorting results of the inventory batches to obtain the first round of sorting results; The candidate replenishment source warehouse locations in the first round of sorting results are sorted according to the warehouse location search method configuration information, and the first round of sorting results are updated according to the results after sorting by warehouse location search method to obtain the second round of sorting results; The first sorting result is determined based on the initial source location priority, the first round sorting result, and the second round sorting result, respectively.
[0042] In this embodiment, the replenishment source location configuration information is used to prioritize replenishment source locations that meet the demand for out-of-stock goods. This replenishment source location configuration information is pre-set. As described above, it represents a replenishment source location priority ranking strategy. Multiple replenishment source location priority ranking strategies can be set, and each strategy includes a corresponding priority. Please refer to... Figure 5 , Figure 5 This is a schematic diagram illustrating the configuration information for replenishment source locations provided in this application. The settings page for replenishment source location configuration information allows you to set the priority of the current replenishment source location configuration information, as well as the source location range configuration information, inventory batch configuration information, and location search method configuration information. You can also set the replenishment source location description corresponding to the source location range configuration information, such as the source strategy for warehouse area XXX. The inventory batch configuration information allows you to set batch attributes, the priority of the batch attributes, the matching method, ascending / descending order, and operation options. Operation options can include editing or deleting each inventory batch configuration information. The location search method configuration information allows you to set the location search method, the priority of the location search method, and operation options. The object is in... Figure 5 After setting the replenishment source location configuration information on the page shown, this information can be stored in the database for automatic retrieval later.
[0043] The replenishment source location configuration information includes source location range configuration information. The source location range configuration information is used to define a preliminary replenishment source location screening range from the locations of the entire warehouse or all storage areas. The source location range configuration information can include setting specific warehouses, for example, screening replenishment source locations only from the storage area and not from the picking area. The source location range configuration information can also be used to exclude warehouse locations in certain states, such as locked warehouse locations (restricted exit, restricted entry, sealed or controlled warehouse locations), virtual warehouse locations, and top-package warehouse locations.
[0044] First, candidate replenishment source locations corresponding to the target out-of-stock product can be determined based on the source location range configuration information. For example, the replenishment source locations configured in the source location range configuration information include locations in warehouse area A and warehouse area B. Then, candidate replenishment source locations can be filtered from the locations in warehouse area A and warehouse area B based on the out-of-stock demand information of the target out-of-stock product. Specifically, the corresponding candidate replenishment source locations can be obtained from the location range determined by the source location range configuration information based on the product attribute information of the target out-of-stock product (such as product code and demand batch). Furthermore, an initial source location priority can be set for the obtained candidate replenishment source locations. The initial source location priority can be set randomly. For example, if there are five candidate replenishment source locations, the priorities of the five candidate replenishment source locations can be randomly set to priority 1 to priority 5. Alternatively, the candidate replenishment source locations can be set to the same initial priority. For example, the priority of the above five candidate replenishment source locations can all be set to priority 1. There is no restriction here. This application can narrow the calculation range of replenishment data locations by setting source location range configuration information, thereby improving the processing efficiency of replenishment data.
[0045] Furthermore, the replenishment source location configuration information also includes inventory batch configuration information. This information allows for prioritizing the candidate replenishment source locations and updating the initial source location priority based on the ranking results, thus obtaining the first round of ranking. Specifically, inventory batch configuration information defines inventory turnover strategies, such as first-in, first-out (FIFO) (in ascending order of production date) or first-to-expires (FIFO) (in ascending order of expiration date). Inventory batch configuration information can contain multiple batch attributes, such as production date, expiration date, and quality status (good or defective). The inventory batch configuration information is typically matched with the batch requirements of the corresponding supplier. For example, for cosmetics, the supplier may not want a large number of expired products in the warehouse. Therefore, when ranking candidate replenishment source locations, priority can be set according to the production date from smallest to largest, placing candidate replenishment source locations with earlier production dates in higher priority positions to ensure that cosmetics with near-expired production dates are shipped out first. For example, cosmetic suppliers must ensure that the cosmetics provided to customers are good products that comply with chemical product standards and are within their expiration date. Therefore, they can also set the inventory batch attributes of quality status and expiration date in the inventory batch configuration information.
[0046] Understandably, please refer to [the website / platform] for further information. Figure 5The inventory batch configuration information can include multiple batch attributes, each with a corresponding priority. For example, quality status might be priority 1, production date priority 2, and so on. Furthermore, different batch attributes can be configured with corresponding matching methods, including exact matching and fuzzy matching. For instance, the quality status batch attribute can be set to exact matching, meaning it can only be either good or defective. The production date can be set to fuzzy matching; for example, to filter candidate replenishment source locations whose production date is after May 20XX, the candidate replenishment source locations can be sorted from smallest to largest production date. Thus, after configuring the inventory batch information in this way, candidate replenishment source locations can be sorted according to the priority of the batch attributes. After each round of sorting, the initial source location priority of the candidate replenishment source locations is updated. After all batch attributes are sorted, the first round of sorting results corresponding to the inventory batch configuration information is obtained and stored. Understandably, it is also possible to record the degree of change in priority of each candidate replenishment source location after sorting by inventory batch configuration information compared to the initial source location priority. For example, if the initial source location priority is priority 1 and the priority after sorting by inventory batch configuration information is priority 3, then the location priority has decreased by two priorities compared to the initial source location priority.
[0047] The replenishment source location configuration information also includes location search method configuration information. This information can be used to filter out the location that best improves warehousing efficiency from multiple candidate replenishment source locations that meet basic conditions. The location search method configuration information can include multiple search methods, each with a corresponding priority. For example, there are clearance priority (prioritizing locations that need to be emptied) and shortest replenishment path priority (prioritizing locations with the shortest path from the destination shelving point or picking start point). The clearance priority rule has a priority of 1, and the shortest replenishment path priority rule has a priority of 2.
[0048] Then, the candidate replenishment source locations in the first round of sorting are re-sorted according to the location search method configuration information, and the first round of sorting results are updated accordingly to obtain the second round of sorting results. Specifically, after generating the first round of sorting results, the candidate replenishment source locations in the first round of sorting results can be sorted sequentially according to the priority corresponding to the location search method, and the priority of the first round of sorting results can be updated. Following the example above, the candidate replenishment source locations in the first round of sorting results can be sorted first according to the clearance priority rule, and then sorted again according to the shortest replenishment path priority rule. After all location search methods in the location search method configuration information have been traversed according to priority, the second round of sorting results after sorting according to the location search method configuration information is obtained. The setting of the location search method configuration information ensures that replenishment decisions not only meet the inventory turnover principle but also better meet the needs of warehouse layout and operational processes, thereby improving replenishment efficiency.
[0049] It should be noted that if, after iterating through all sorting rules in the replenishment source location configuration information, no available replenishment source location can be found, the search for available replenishment source location configuration information can continue until all preset replenishment source location configuration information has been traversed. Alternatively, if, after iterating through all sorting rules in the replenishment source location configuration information, multiple replenishment source locations meet both the configuration information and the product demand information, then a location can be randomly selected from these multiple replenishment source locations as the target replenishment source location.
[0050] Furthermore, the first ranking result corresponding to the replenishment source location configuration information is determined based on the initial source location priority, the first round ranking result, and the second round ranking result. Therefore, this application does not only retain the final replenishment source location ranking result, but also saves the priority ranking results of several key nodes in the entire ranking process. In this way, the embodiments of this application can achieve the traceability and interpretability of the replenishment source location recommendation decision process, providing data support for analyzing the rationality of the replenishment source location recommendation logic and optimizing configuration information.
[0051] In some embodiments, please refer to Figure 6 , Figure 6This is a flowchart illustrating the process of determining target replenishment source locations provided in this application. Specifically, the out-of-stock quantity of goods can be obtained first, representing the quantity of goods out of stock corresponding to the batch of out-of-stock goods. Then, the replenishment source location configuration information of the consignor is read based on the consignor information. If the consignor does not have replenishment source location configuration information, the default replenishment source location configuration information is read. Then, candidate replenishment source locations can be determined based on the source location range configuration information. Further, the candidate replenishment source locations sorted in the previous stage are sorted again based on the location search method configuration information to obtain the final replenishment source location sorting result. Then, the available inventory of the candidate replenishment source locations can be compared with the corresponding shortage quantity of the out-of-stock product batch. When the available inventory is less than the shortage quantity, it is determined whether the owner has replenishment source location configuration information of the next priority. If so, the above sorting steps are repeated according to the replenishment source location configuration information of the next priority. If not, it is determined whether the available inventory of all replenishment source locations is 0 (this step is executing the backup logic of replenishment source locations to make full use of all available inventory in the warehouse). If so, the replenishment source location is empty, and the entire warehouse is out of stock. There is no available inventory of the target out-of-stock product, and the replenishment quantity is equal to the product shortage quantity. If not, the replenishment source locations with out-of-stock product inventory in the entire warehouse are prioritized according to the location search method configuration information in the replenishment source location configuration information. Furthermore, it can be determined whether the warehouse location search method configuration information includes clearance. If it does not, the quantity to be replenished is equal to the quantity of goods out of stock. If it does, the quantity to be replenished is updated, and at this time the quantity to be replenished is equal to the total available inventory quantity of the warehouse location from which the replenishment is sourced.
[0052] The available inventory of candidate replenishment source locations is compared with the corresponding stockout quantity for the stockout batch. If the available inventory is greater than or equal to the stockout quantity, it is checked whether the location search method configuration includes clearance sales. If not, the replenishment quantity equals the stockout quantity; if so, the replenishment quantity is updated to equal the total available inventory quantity of the replenishment source location. Finally, the target replenishment source location and its corresponding replenishment quantity are determined based on the combined results.
[0053] In some embodiments, displaying multiple first sorting results of replenishment source locations and available inventory information for each replenishment source location on the source location decision information prompt page includes the following steps: Display multiple source storage location sorting result query controls on the source storage location decision information prompt page; In response to the triggering operation of the target source location sorting result query control in the multiple source location sorting result query control, the first sorting result of the replenishment source location corresponding to the target source location sorting result query control and the available inventory information of each replenishment source location are displayed.
[0054] In the embodiments of this application, please refer to Figure 4A The replenishment details page can include a source location decision information query control 420 (i.e., Figure 4A (In the "Source Location Analysis" option), the terminal responds to the trigger operation of the source location decision information query control 420, and can jump to display the source location decision information prompt page. Furthermore, multiple source location sorting result query controls can be displayed on the source location decision information prompt page. These multiple source location sorting result query controls can be presented in the form of controls or expandable lists. Each source location sorting result query control corresponds to the sorting result query control of a priority sorting stage in the replenishment source location decision process, such as the query control for the sorting result corresponding to the source location range configuration information, the query control for the sorting result corresponding to the inventory batch configuration information, and the query control for the sorting result corresponding to the location search method configuration information.
[0055] Then, in response to an object's triggering operation on any of the aforementioned controls (i.e., the target source warehouse location sorting result query control), the terminal can display the first sorting result of the replenishment source warehouse location corresponding to the sorting stage indicated by the target source warehouse location sorting result query control on the source warehouse location decision information prompt page. Specifically, the source warehouse location decision information prompt page can display available inventory information corresponding to all candidate replenishment source warehouse locations in this sorting stage, such as warehouse area code, warehouse location code, available inventory quantity, product batch, etc. It can also include the first sorting result corresponding to all candidate replenishment source warehouse locations in this sorting stage, the change of the sorting result in this stage compared to the priority sorting result in the previous stage, and the priority sorting result in the previous stage.
[0056] For example, please refer to Figures 7A to 7C , Figures 7A to 7C A schematic diagram illustrating the process of querying source location decision information provided in this application, as shown below. Figure 7A As shown, the source warehouse location decision information prompt page 700 displays the sorting results of different warehouse location priority sorting stages corresponding to the first priority replenishment source warehouse location configuration information. The source warehouse location decision information prompt page 700 includes multiple source warehouse location sorting result query controls, specifically including a lock candidate replenishment source warehouse location control 710, an inventory batch configuration information sorting result query control 720, and a warehouse location search method configuration information sorting result query control 730. In response to the trigger operation of the lock candidate replenishment source warehouse location control 710, the candidate replenishment source warehouse locations A, B, and C determined according to the source warehouse location range configuration information are displayed. The priorities corresponding to the warehouse locations are 1, 2, and 3 respectively. At this time, the change in priority from the previous priority and the previous priority are both empty.
[0057] Then, please refer to Figure 7B In response to the trigger operation of the inventory batch configuration information sorting result query control 720, the results obtained by sorting the candidate replenishment source locations according to the inventory batch configuration information are displayed, such as... Figure 7B As shown, the priorities for this replenishment of candidate replenishment source locations A, B, and C are 2, 1, and 3, respectively. Figure 7B The document also displays the current priority level and how it changes from the previous priority level. For further details, please refer to [link / reference]. Figure 7C In response to a trigger operation on the storage location search method configuration information sorting result query control 730, the result obtained by re-sorting the above sorting results according to the storage location search method configuration information is displayed, such as... Figure 7C As shown, the priorities for this replenishment of candidate replenishment source locations A, B, and C are 3, 1, and 2, respectively. Figure 7C The page also displays the current priority and how it changes from the previous priority. It should be noted that, in response to the triggering of the next priority control in the source warehouse location decision information prompt page 700, the priority ranking results of the next priority replenishment source warehouse location configuration information can be displayed.
[0058] Thus, the embodiments of this application can make the sorting logic and screening process of replenishment source locations encapsulated within the algorithm transparent. The object can not only intuitively obtain the replenishment source locations recommended by the WMS system, but also gradually trace back how the WMS system sorts the candidate replenishment source locations through multiple rounds of replenishment source location sorting strategies, and intuitively see the available inventory of each candidate replenishment source location, thereby improving the efficiency of the object in tracing the replenishment data generation process or the reasons for replenishment data anomalies.
[0059] In some embodiments, the replenishment details page includes a destination storage location decision information query control, which receives a traceability operation on the replenishment details page to trace the replenishment data, and displays a replenishment decision information prompt page corresponding to the replenishment data, including the following steps: In response to the triggering operation of the destination storage location decision information query control, a destination storage location decision information prompt page is displayed; The replenishment decision information prompt page displays multiple second sorting results for replenishment destination locations and the replenishment information for each replenishment destination location, including the following steps: The destination warehouse location decision information prompt page displays multiple second sorting results for replenishment destination warehouse locations and the replenishment information for each replenishment destination warehouse location.
[0060] In this embodiment, when an object has doubts about the replenishment data (e.g., the replenishment quantity of the destination warehouse) provided by the WMS system, it can initiate a traceability request for the replenishment destination warehouse by triggering this control (e.g., mouse click). Specifically, the terminal can respond to the triggering operation of the destination warehouse decision information query control and display a destination warehouse decision information prompt page. The triggering operation can be implemented through mouse events or voice command control, etc., which is not limited here. The terminal can respond to the triggering operation of the destination warehouse decision information query control and display a destination warehouse decision information prompt page. The destination warehouse decision information prompt page can be used to display the decision process of the replenishment destination warehouse corresponding to the target historical replenishment record and the replenishment information to be replenished. The decision process can include multiple second sorting results, and the replenishment information to be replenished can specifically include the warehouse code, inventory batch, and available inventory quantity (i.e., how much can be replenished to the replenishment destination warehouse) corresponding to each replenishment destination warehouse.
[0061] Please refer to Figure 4A In response to a trigger action on the actual replenishment data option in the 400 replenishment details page, the following is displayed: Figure 8 The page shown is as follows: Figure 8 As shown, the replenishment details page 400 displays the product name, product code, batch number, and suggested replenishment quantity of the target out-of-stock item. The replenishment details page 400 includes a destination storage location decision information query control 430 (i.e., the destination analysis option), which displays a destination storage location decision information prompt page. For details, please refer to... Figure 9A and Figure 9B , Figures 9A to 9B A schematic diagram illustrating the process of querying destination storage location decision information provided in this application, as shown below. Figure 9A As shown, the destination warehouse location decision information prompt page displays the warehouse location filtering results corresponding to the first priority replenishment destination warehouse location configuration information. Specifically, based on the rule of prioritizing the same batch of the same product, the replenishment destination warehouse location is filtered, resulting in warehouse locations A, B, and C, as shown below. Figure 9B As shown, the destination warehouse location decision information prompt page displays the warehouse location filtering results corresponding to the second priority replenishment destination warehouse location configuration information. Specifically, based on the rule of prioritizing empty warehouse locations, the replenishment destination warehouse location can be filtered to obtain warehouse locations D, E, and F.
[0062] Next, we will describe in detail the process of generating the second sorting result.
[0063] In some embodiments, the replenishment destination storage location configuration information includes destination storage location range configuration information, at least one destination storage location filtering rule, and the rule priority of each destination storage location filtering rule. The process of generating the second sorting result includes the following steps: Determine the candidate replenishment destination warehouse locations corresponding to the target out-of-stock goods based on the destination warehouse location range configuration information; Candidate replenishment destination warehouse locations are sorted according to the priority of the rules and the destination warehouse location screening rules, and the initial destination warehouse location priority is updated according to the results of each sorting. The corresponding second sorting result is determined based on the destination storage location priority after each update.
[0064] In this embodiment, the replenishment destination location configuration information is a set of rules used to guide the WMS system to automatically select and recommend destination locations for replenishment operations, thereby improving the efficiency of the replenishment process. The replenishment destination location configuration information is used to prioritize replenishment destination locations that meet the needs of out-of-stock goods. This configuration information is pre-defined; as described above, it represents a priority ranking strategy for replenishment destination locations. Multiple priority ranking strategies can be set, and each strategy includes a corresponding priority.
[0065] The replenishment destination location configuration information includes destination location range configuration information. This information is used to configure the range of destination locations that can be used for replenishment operations. For example, it can limit the locations in certain or functional warehouse areas (such as picking areas or storage areas) or exclude certain unavailable location states (such as disabled locations, virtual locations, or top-package locations). Based on the destination location range configuration information, candidate replenishment destination locations corresponding to the target out-of-stock items can be initially filtered from all warehouse locations, and initial destination location priorities can be assigned to these candidate locations (e.g., all candidate locations have the same priority initially).
[0066] The replenishment destination location configuration information also includes at least one destination location filtering rule and the rule priority of each destination location filtering rule. For example, the destination location filtering rule can include priority for the same product or the same batch, meaning it prioritizes replenishment destination locations that already store the target out-of-stock product and have the same required batch (e.g., production date). Alternatively, the destination location filtering rule can only include priority for the same product, meaning it prioritizes replenishment destination locations that already store the target out-of-stock product. Another example is that the destination location filtering rule can include priority for empty locations, meaning it prioritizes vacant locations. Destination location filtering rules can also include priority for nearest shelving, etc., without limitation. Similar to the replenishment source location configuration information, the replenishment destination location configuration information can also include sorting conditions such as location search method. Each sorting condition can include multiple attributes and their corresponding priorities, such as the same product or the same batch as the first priority, and empty locations as the second priority.
[0067] Furthermore, candidate replenishment destination warehouse locations can be sorted sequentially according to a preset priority order based on different destination warehouse location filtering rules, and the initial destination warehouse location priority can be updated sequentially based on the results of each sorting. For example, the highest priority rule (such as prioritizing the same batch of the same product) can be applied first to sort the candidate replenishment destination warehouse locations, and the initial destination warehouse location priority of the candidate replenishment destination warehouse locations can be updated based on the sorting results; then, the second highest priority rule (such as prioritizing empty warehouse locations) can be applied to adjust the previous round of sorting results, and the destination warehouse location priority can be updated again, and so on iteratively.
[0068] Then, the corresponding second sorting result can be determined according to the destination storage location priority after each update. Thus, this embodiment of the application does not only record the final destination storage location sorting, but also saves the storage location priority sorting status generated after each round of rule application, with each intermediate state constituting a second sorting result. For example, the initial destination storage location priority, the storage location sorting result after applying the same product and same batch priority rule, and the storage location sorting result after applying the empty storage location priority rule can be saved.
[0069] Thus, the embodiments of this application can find the optimal replenishment destination warehouse location under complex constraints through continuous filtering operations with multiple rules and priorities, so that the final replenishment data has high accuracy.
[0070] Please refer to Figure 10 , Figure 10This is a flowchart illustrating the process of determining the target replenishment destination warehouse location provided in this application. Specifically, the replenishment source warehouse location and its available inventory information determined in the aforementioned steps are first obtained, along with the quantity of out-of-stock goods. Then, the replenishment destination warehouse location configuration information of the consignor is read. Based on the replenishment destination warehouse location configuration information, candidate replenishment destination warehouse locations corresponding to the target out-of-stock goods are determined. Next, it is determined whether there are available destination warehouse locations among the candidate replenishment destination warehouse locations. If so, the available destination warehouse locations are sorted according to the warehouse location search method, warehouse location merchant order, and other configuration information to obtain the sorted replenishment destination warehouse locations. Then, it is first determined whether the inventory of the replenishment source warehouse location meets the inventory requirements of the highest priority replenishment destination warehouse location, such as whether the out-of-stock goods are the same or whether the out-of-stock batches are the same. If the requirements are not met, the next priority replenishment destination warehouse location is searched. If the requirements are met, the target replenishment source warehouse location, the corresponding target replenishment destination warehouse location, and the suggested replenishment quantity are determined. If no available replenishment destination location exists among the candidate replenishment destination locations, the system checks if there is an available replenishment destination location for the same product and batch in the entire warehouse picking area. If it does, the location is selected as the target destination location, and its location is obtained. If no available replenishment destination location exists, the system checks if there is an available replenishment destination location for the same product in the entire warehouse picking area. If it does, the location is selected as the target destination location, and its location is obtained. If not, the system checks if there are any empty locations in the entire warehouse. If not, it indicates that the entire warehouse lacks a replenishment destination location. If it does, the location is selected as the target destination location, and its location is obtained. Then, replenishment report data is generated by combining the target replenishment source location and the suggested replenishment quantity. If there are no available empty locations in the entire warehouse, the replenishment data report details are broken down according to the replenishment source location, and the replenishment destination locations are left empty, i.e., not filled, indicating that there are no available empty locations to use as replenishment destination locations.
[0071] In some embodiments, the out-of-stock demand information includes the out-of-stock batch and the corresponding out-of-stock quantity of the out-of-stock batch, and the replenishment information includes the replenishment quantity. The process of generating the replenishment quantity includes the following steps: Obtain the target source location priority after multiple sorting of candidate replenishment source locations based on replenishment source location configuration information; Based on the priority of the target source warehouse location, the inventory batches corresponding to the candidate replenishment source warehouse locations are matched with the out-of-stock product batches in turn. When an inventory batch matches an out-of-stock product batch, the available inventory quantity corresponding to the inventory batch is obtained, and the available inventory quantity is accumulated in turn according to the priority of the target source warehouse location to obtain the available replenishment inventory. The available replenishment inventory obtained from each accumulation is compared with the out-of-stock quantity of the goods, and the replenishment quantity corresponding to the out-of-stock batch is generated based on the comparison result.
[0072] This application describes a method for calculating replenishment quantity, where replenishment quantity represents the replenishment quantity of the batch of out-of-stock goods corresponding to the target out-of-stock goods. Specifically, the priority of the target source warehouse location can be obtained by first sorting the candidate replenishment source warehouse locations multiple times based on the replenishment source warehouse location configuration information; that is, the priority of the target source warehouse location is the final sorting result obtained based on the replenishment source warehouse location configuration information.
[0073] Then, based on the priority order of the target source warehouse locations mentioned above, all inventory batches in each candidate replenishment source warehouse location are matched with the required out-of-stock product batches. When an inventory batch in a replenishment source warehouse location matches the out-of-stock product batch required by the out-of-stock order, the available inventory quantity of that matching batch in that warehouse location (i.e., the quantity of goods currently available to perform this replenishment operation) can be obtained. Further, based on the priority order of the target source warehouse locations, the available inventory quantities of these successfully matched replenishment source warehouse locations are accumulated sequentially to obtain the total available replenishment inventory. For example, if warehouse location A with priority 1 has 20 matching batches and warehouse location B with priority 2 has 30 matching batches, the accumulation process is as follows: first accumulate the 20 items from warehouse location A (cumulative 20 items), then accumulate the 30 items from warehouse location B (cumulative 50 items).
[0074] Furthermore, the total available replenishment inventory obtained after each accumulation can be compared with the out-of-stock quantity (i.e., the total out-of-stock quantity of the target out-of-stock item), and the final replenishment quantity corresponding to the out-of-stock item batch can be generated based on the comparison result. Specifically, available inventory can be accumulated according to the priority of the target source location. When the accumulated total available replenishment inventory reaches or exceeds the out-of-stock quantity for the first time, the replenishment quantity equals the out-of-stock quantity, indicating sufficient inventory. If, after traversing all replenishment source locations matched with out-of-stock item batches, the accumulated total available replenishment inventory is still less than the out-of-stock quantity, the replenishment quantity equals the currently accumulated total available replenishment inventory, indicating insufficient inventory.
[0075] Thus, by combining the priority order of storage locations with batch date matching and inventory accumulation logic, this application achieves refined and transparent replenishment quantity calculation. This application not only provides the final suggested replenishment quantity, but also presents the composition and calculation process of the replenishment quantity to the user. Therefore, it can explain why the replenishment quantity is less than the shortage quantity when the user views the replenishment data. The user can clearly see which high-priority replenishment source storage locations are used to meet the demand for shortage goods and at which stage the inventory shortage occurs, thereby providing data support for inventory allocation and improving the interpretability and traceability of replenishment data.
[0076] Please see Figure 11This application embodiment also provides a replenishment data processing device 1100, which can implement the above-mentioned replenishment data processing method. The device includes: The first display unit 1101 is used to display a historical replenishment record query page, and to display at least one historical replenishment record on the historical replenishment record query page, with each historical replenishment record corresponding to a stock-out item; The second display unit 1102 is used to display a replenishment details page in response to the selection trigger of a target historical replenishment record in at least one historical replenishment record, and to display the replenishment data of the target out-of-stock product corresponding to the target historical replenishment record on the replenishment details page; The third display unit 1103 is used to receive the traceability operation of the replenishment data on the replenishment details page and display the replenishment decision information prompt page corresponding to the replenishment data; The fourth display unit 1104 is used to display multiple first sorting results of replenishment source locations and available inventory information of each replenishment source location on the replenishment decision information prompt page, and to display multiple second sorting results of replenishment destination locations and replenishment information to be replenished for each replenishment destination location on the replenishment decision information prompt page. The replenishment information to be replenished is generated based on the shortage demand information and available inventory information of the target out-of-stock goods. Each first sorting result is obtained by sorting the replenishment source locations based on preset replenishment source location configuration information, and each second sorting result is obtained by sorting the replenishment destination locations based on preset replenishment destination location configuration information.
[0077] The specific implementation of the replenishment data processing device is basically the same as the specific embodiment of the replenishment data processing method described above, and will not be repeated here.
[0078] This application also provides an electronic device, which includes a memory and a processor. The memory stores a computer program, and the processor executes the computer program to implement the above-described replenishment data processing method. This electronic device can be any smart terminal, including tablet computers, in-vehicle computers, etc.
[0079] Please see Figure 12 , Figure 12 The hardware structure of an electronic device according to another embodiment is illustrated. The electronic device includes: The processor 1201 can be implemented using a general-purpose central processing unit (CPU), microprocessor, application specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of this application. The memory 1202 can be implemented as a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RAM). The memory 1202 can store the operating system and other application programs. When the technical solutions provided in the embodiments of this specification are implemented through software or firmware, the relevant program code is stored in the memory 1202 and is called and executed by the processor 1201 to execute the replenishment data processing method of the embodiments of this application. The input / output interface 1203 is used to implement information input and output; The communication interface 1204 is used to enable communication and interaction between this device and other devices. Communication can be achieved through wired means (such as USB, network cable, etc.) or wireless means (such as mobile network, WIFI, Bluetooth, etc.). Bus 1205 transmits information between various components of the device (e.g., processor 1201, memory 1202, input / output interface 1203, and communication interface 1204); The processor 1201, memory 1202, input / output interface 1203 and communication interface 1204 are connected to each other within the device via bus 1205.
[0080] This application also provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the above-described replenishment data processing method.
[0081] Memory, as a non-transitory computer-readable storage medium, can be used to store non-transitory software programs and non-transitory computer-executable programs. Furthermore, memory may include high-speed random access memory, and may also include non-transitory memory, such as at least one disk storage device, flash memory device, or other non-transitory solid-state storage device. In some embodiments, memory may optionally include memory remotely located relative to the processor, and these remote memories can be connected to the processor via a network. Examples of such networks include, but are not limited to, the Internet, intranets, local area networks, mobile communication networks, and combinations thereof.
[0082] The embodiments described in this application are for the purpose of more clearly illustrating the technical solutions of the embodiments of this application, and do not constitute a limitation on the technical solutions provided by the embodiments of this application. As those skilled in the art will know, with the evolution of technology and the emergence of new application scenarios, the technical solutions provided by the embodiments of this application are also applicable to similar technical problems.
[0083] Those skilled in the art will understand that the technical solutions shown in the figures do not constitute a limitation on the embodiments of this application, and may include more or fewer steps than shown, or combine certain steps, or different steps.
[0084] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to achieve the purpose of this embodiment according to actual needs.
[0085] Those skilled in the art will understand that all or some of the steps in the methods disclosed above, as well as the functional modules / units in the systems and devices, can be implemented as software, firmware, hardware, or suitable combinations thereof.
[0086] The terms “first,” “second,” “third,” “fourth,” etc. (if present) in the specification and accompanying drawings of this application are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of this application described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms “comprising” and “having,” and any variations thereof, are intended to cover non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.
[0087] It should be understood that in this application, "at least one (item)" means one or more, and "more than" means two or more. "And / or" is used to describe the relationship between related objects, indicating that three relationships can exist. For example, "A and / or B" can represent three cases: only A exists, only B exists, and both A and B exist simultaneously, where A and B can be singular or plural. The character " / " generally indicates that the preceding and following related objects are in an "or" relationship. "At least one (item) of the following" or similar expressions refer to any combination of these items, including any combination of single or plural items. For example, at least one (item) of a, b, or c can represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, and c can be single or multiple.
[0088] In the several embodiments provided in this application, it should be understood that the disclosed apparatus and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative; for instance, the division of the units described above is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be through some interfaces; the indirect coupling or communication connection between apparatuses or units may be electrical, mechanical, or other forms.
[0089] The units described above as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment according to actual needs.
[0090] Furthermore, the functional units in the various embodiments of this application can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The integrated unit can be implemented in hardware or as a software functional unit.
[0091] If the integrated unit is implemented as a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, or all or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes multiple instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods of the various embodiments of this application. The aforementioned storage medium includes various media capable of storing programs, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.
[0092] The preferred embodiments of the present application have been described above with reference to the accompanying drawings, but this does not limit the scope of the claims of the present application. Any modifications, equivalent substitutions, and improvements made by those skilled in the art without departing from the scope and substance of the embodiments of the present application shall be within the scope of the claims of the present application.
Claims
1. A method for processing replenishment data, characterized in that, The method includes: Display a historical replenishment record query page, and display at least one historical replenishment record on the historical replenishment record query page, with each historical replenishment record corresponding to a stock-out item; In response to the selection of a target historical replenishment record from the at least one historical replenishment record, a replenishment details page is displayed, and replenishment data of the target out-of-stock product corresponding to the target historical replenishment record is displayed on the replenishment details page; The system receives a traceability operation on the replenishment details page to trace the replenishment data, and displays a replenishment decision information prompt page corresponding to the replenishment data. The replenishment decision information prompt page displays multiple first sorting results for replenishment source locations and available inventory information for each replenishment source location. The replenishment decision information prompt page also displays multiple second sorting results for replenishment destination locations and replenishment information for each replenishment destination location. The replenishment information is generated based on the shortage demand information of the target out-of-stock item and the available inventory information. Each first sorting result is obtained by sorting the replenishment source locations based on preset replenishment source location configuration information, and each second sorting result is obtained by sorting the replenishment destination locations based on preset replenishment destination location configuration information.
2. The method according to claim 1, characterized in that, The replenishment details page includes a source location decision information query control. The receiving operation on the replenishment details page to trace the replenishment data, and the display of the replenishment decision information prompt page corresponding to the replenishment data, include: In response to the triggering operation of the source storage location decision information query control, a source storage location decision information prompt page is displayed; The display of multiple first sorting results of replenishment source locations and available inventory information for each replenishment source location on the replenishment decision information prompt page includes: The source warehouse location decision information prompt page displays multiple first sorting results of replenishment source warehouse locations and available inventory information for each of the replenishment source warehouse locations.
3. The method according to claim 2, characterized in that, The process of displaying multiple first sorting results of replenishment source locations and available inventory information for each replenishment source location on the source location decision information prompt page includes: Display multiple source storage location sorting result query controls on the source storage location decision information prompt page; In response to a trigger operation on the target source location sorting result query control among the multiple source location sorting result query controls, the available inventory information of each replenishment source location is displayed as the first sorting result of the replenishment source location corresponding to the target source location sorting result query control.
4. The method according to claim 1, characterized in that, The replenishment details page includes a destination warehouse location decision information query control. The receiving operation on the replenishment details page to trace the replenishment data, and the display of the replenishment decision information prompt page corresponding to the replenishment data, include: In response to the triggering operation of the destination storage location decision information query control, a destination storage location decision information prompt page is displayed; The process of displaying multiple second sorting results of replenishment destination locations and replenishment information for each replenishment destination location on the replenishment decision information prompt page includes: The destination warehouse location decision information prompt page displays multiple second sorting results for replenishment destination warehouse locations and the replenishment information for each of the replenishment destination warehouse locations.
5. The method according to claim 2, characterized in that, The replenishment source location configuration information includes source location range configuration information, inventory batch configuration information, and location search method configuration information. The generation process of the first sorting result includes the following steps: Based on the source location range configuration information, the candidate replenishment source location corresponding to the target out-of-stock product is determined, and the candidate replenishment source location includes the corresponding initial source location priority; The candidate replenishment source locations are sorted according to the inventory batch configuration information, and the priority of the initial source locations is updated according to the sorting results of the inventory batches to obtain the first round of sorting results; The candidate replenishment source warehouse locations in the first round of sorting results are sorted according to the warehouse location search method configuration information, and the first round of sorting results are updated according to the results after sorting by warehouse location search method to obtain the second round of sorting results; The corresponding first sorting result is determined based on the initial source location priority, the first round sorting result, and the second round sorting result, respectively.
6. The method according to claim 4, characterized in that, The replenishment destination storage location configuration information includes destination storage location range configuration information, at least one destination storage location filtering rule, and the rule priority of each of the destination storage location filtering rules. The process of generating the second sorting result includes the following steps: Based on the destination storage location range configuration information, the candidate replenishment destination storage location corresponding to the target out-of-stock product is determined, and the candidate replenishment destination storage location includes the corresponding initial destination storage location priority; The candidate replenishment destination warehouse locations are sorted sequentially according to the priority of the rules and the destination warehouse location screening rules, and the initial destination warehouse location priority is updated sequentially according to the results of each sorting. The corresponding second sorting result is determined based on the destination storage location priority after each update.
7. The method according to claim 5, characterized in that, The out-of-stock demand information includes the batch of out-of-stock goods and the quantity of goods out of stock corresponding to the batch of out-of-stock goods. The replenishment information includes the replenishment quantity. The process of generating the replenishment quantity includes the following steps: Obtain the target source location priority after sorting the candidate replenishment source locations multiple times based on the replenishment source location configuration information; According to the priority of the target source warehouse location, the inventory batches corresponding to the candidate replenishment source warehouse location are matched with the out-of-stock product batches in turn. When the inventory batch matches the out-of-stock product batch, the available inventory quantity corresponding to the inventory batch is obtained, and the available inventory quantity is accumulated in turn according to the priority of the target source warehouse location to obtain the available replenishment inventory. The available replenishment inventory obtained from each accumulation is compared with the out-of-stock quantity of the product, and the replenishment quantity corresponding to the out-of-stock product batch is generated based on the comparison result.
8. A replenishment data processing device, characterized in that, The device includes: The first display unit is used to display a historical replenishment record query page, and to display at least one historical replenishment record on the historical replenishment record query page, each of the historical replenishment records corresponding to a stock-out item; The second display unit is configured to display a replenishment details page in response to the selection trigger of a target historical replenishment record in the at least one historical replenishment record, and to display the replenishment data of the target out-of-stock product corresponding to the target historical replenishment record on the replenishment details page; The third display unit is used to receive the traceability operation of the replenishment data on the replenishment details page and display the replenishment decision information prompt page corresponding to the replenishment data; The fourth display unit is used to display multiple first sorting results of replenishment source warehouse locations and available inventory information of each replenishment source warehouse location on the replenishment decision information prompt page, and to display multiple second sorting results of replenishment destination warehouse locations and replenishment information to be replenished for each replenishment destination warehouse location on the replenishment decision information prompt page. The replenishment information to be replenished is generated based on the shortage demand information of the target out-of-stock product and the available inventory information. Each first sorting result is obtained by sorting the replenishment source warehouse locations based on preset replenishment source warehouse location configuration information, and each second sorting result is obtained by sorting the replenishment destination warehouse locations based on preset replenishment destination warehouse location configuration information.
9. An electronic device, characterized in that, The electronic device includes a memory and a processor, the memory storing a computer program, and the processor executing the computer program to implement the replenishment data processing method according to any one of claims 1 to 7.
10. A computer-readable storage medium storing a computer program, characterized in that, When the computer program is executed by the processor, it implements the replenishment data processing method according to any one of claims 1 to 7.