Real-time dynamic order picking control system based on intelligent handheld terminal

Abstract

The invention relates to the technical field of logistics warehouse management, in particular to a real-time dynamic goods picking control system based on an intelligent handheld terminal, and aims to solve the problems that in the prior art, through communication between an intelligent container and the handheld terminal, a prompt device is used for accurately positioning and reminding a picker, so that goods are quickly and accurately picked, and goods picking efficiency is improved. The picking efficiency is obviously improved, but the risk of stock overstock and shortage is increased because a safe stock and replenishment strategy cannot be set by integrating historical sales data and demand prediction; according to the invention, inventory data is updated in real time through the order inventory management module, replenishment suggestions and early warning notifications are automatically generated, safe inventory and replenishment strategies are set based on historical sales data and demand prediction, inventory overstock and shortage risks are reduced, orders are dynamically allocated, resource utilization is optimized, the order state is updated in real time through the hand-held terminal, and the system is convenient to use. And the visual management capability is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of logistics warehousing management, and more specifically, to a real-time dynamic picking control system based on an intelligent handheld terminal. Background Art

[0002] Warehouse management plays an important role in the daily operation and management of overseas warehouses, and picking operations are the core link. The manual operation mode of traditional warehouses has problems such as low efficiency, prone to errors, and difficulty in data traceability. In recent years, the application of smart handheld terminals in warehouse management has become increasingly widespread. Through PDA, information management and operations of multiple links such as product warehousing, shelving, outbound, inventory, picking, etc. are realized, which greatly improves the efficiency and accuracy of warehouse management.

[0003] The patent application with reference publication number CN115394007A discloses a method for picking items, a smart container, and a system for picking items, and relates to the field of warehousing and logistics technology. A specific implementation of the method includes: receiving a picking task, which indicates one or more items to be picked and location information of the items to be picked; broadcasting a near-field message to one or more smart containers in the warehouse based on the location information; using one or more smart containers to determine whether the items to be picked are stored on their corresponding shelves based on the location information in the near-field message; if so, controlling the prompt device corresponding to the shelf where the items to be picked are located to send a prompt message, so that the user of the handheld terminal can perform the picking task according to the prompt message. This implementation can remind the picker through the prompt device on the container when the picker approaches the target container storing the items to be picked, so that the picker can pick the goods accurately and quickly, saving picking time and improving picking efficiency;

[0004] However, the existing technology uses prompt devices to accurately locate and remind pickers through communication between smart containers and handheld terminals, thereby achieving fast and accurate goods picking and significantly improving picking efficiency. However, it cannot set safety stock and replenishment strategies based on historical sales data and demand forecasts, which increases the risk of inventory backlogs and shortages. It also cannot update inventory and order status in real time, cannot support dynamic scheduling, cannot ensure that high-priority tasks are given priority, and cannot optimize warehouse resource utilization.

[0005] To this end, we propose a real-time dynamic picking control system based on intelligent handheld terminals to address the above problems. Summary of the invention

[0006] The purpose of the present invention is to provide a real-time dynamic picking control system based on an intelligent handheld terminal, which solves the problem that the prior art uses communication between intelligent cabinets and handheld terminals, uses prompt devices to accurately locate and remind pickers, realizes fast and accurate goods picking, and significantly improves picking efficiency. However, it cannot set safety inventory and replenishment strategies based on historical sales data and demand forecasts, increases the risk of inventory backlog and shortage, and cannot update inventory and order status in real time, cannot support dynamic scheduling, cannot ensure priority processing of high-priority tasks, and cannot optimize warehouse resource utilization.

[0007] The purpose of the present invention is achieved through the following technical solutions:

[0008] A real-time dynamic picking control system based on an intelligent handheld terminal, characterized in that it includes a management platform, a user authority management module, an order inventory management module, a picking task management module, a handheld terminal operation feedback module, and a data analysis exception processing module;

[0009] User rights management module, used for user login, rights management and activity log recording;

[0010] The order inventory management module is used to process customer orders, monitor inventory in real time, update inbound and outbound information, track order status, and provide inventory warnings and automatic replenishment suggestions;

[0011] The picking task management module is used to automatically generate picking tasks based on order requirements and inventory status, support real-time dynamic scheduling, and confirm goods through barcode scanning;

[0012] Handheld terminal operation feedback module, used for task reception, real-time data update and status feedback;

[0013] The data analysis exception handling module is used to collect and summarize data, generate statistical reports, monitor picking efficiency and error rate in real time, and record and manage picking exceptions.

[0014] As a preferred implementation of the present invention, the specific implementation process of the user rights management module is as follows:

[0015] User login: The user enters the username and password to log in. The system checks whether the username exists. If it does, the password is encrypted with the same encryption algorithm and compared. After a successful match, the system sends a text message verification code to the user's mobile phone for secondary verification. If the verification is successful, a session token is generated and stored in the user's browser cookie. Subsequent requests carry this token for system verification;

[0016] Permission management: Create a role table and a permission table in the MySQL database, define roles and permissions respectively, associate roles and permissions through the role permission table, and the administrator adjusts user roles or permissions through the user management interface. Use SpringSecurity's @PreAuthorize annotation to implement permission checks on methods. The permission management system supports dynamic adjustment, and administrators can update user permissions in real time.

[0017] Activity logging: Create an activity log table in the MySQL database to record logs of key operations. Administrators can retrieve logs for specific time periods, users, or operation types through the log query interface.

[0018] As a preferred embodiment of the present invention, the specific process of the order inventory management module processing customer orders, real-time monitoring of inventory, updating in-and-out warehouse information, and tracking order status is as follows:

[0019] The system receives orders from customers or sales channels through APIs or interfaces, and then verifies the completeness and accuracy of the orders. Next, the orders are assigned to the corresponding warehouses or distribution centers based on inventory availability and order priority. Finally, after the order is confirmed, an order number is generated and the customer is notified that the order has been received.

[0020] Use smart handheld terminals to scan inventory tags and update the inventory database in real time. Through the wireless network, the data of the handheld terminal is synchronized to the central inventory management system in real time. The update of inventory quantity follows the following formula: inventory quantity = current inventory quantity + incoming quantity - outgoing quantity;

[0021] When products enter the warehouse, the handheld terminal automatically records the quantity entering the warehouse and updates the inventory database by scanning the product barcode. When products leave the warehouse, the handheld terminal automatically records the quantity leaving the warehouse and updates the inventory database by scanning the order barcode.

[0022] At each stage of order receipt, processing, shipment and completion, the handheld terminal updates the order status in real time. The status change process is: order status = initial status → processing → shipped → completed.

[0023] As a preferred implementation of the present invention, the specific process of the order inventory management module providing inventory warning and automatic replenishment suggestion is as follows:

[0024] Get the historical sales data of each product, and set the safety stock quantity of each product based on the historical sales data and demand forecast. The demand forecast is to estimate the sales demand in the future based on the historical sales data and other relevant factors. The specific calculation formula is as follows:

[0025] Forecast demand = b1 × current sales volume + (1-b1) × previous period forecast demand;

[0026] Among them, the predicted demand is the sales demand expected in a certain period of time in the future, b1 is the preset impact factor coefficient, ranging from 0 to 1, indicating the impact of the current sales volume, the current sales volume is the latest actual sales volume, and the previous period predicted demand is the sales demand predicted last time;

[0027] The safety stock quantity of each product is calculated based on the demand forecast and lead time. The lead time is the time from order placement to delivery. The formula for calculating the safety stock quantity is as follows: Safety stock quantity = average daily sales volume × lead time;

[0028] When the system detects that the current inventory quantity is lower than the safety inventory quantity, an inventory warning will be triggered. When the inventory warning is triggered, the system will automatically generate a warning notification and notify relevant personnel via email, SMS or system information. After the inventory warning is triggered, the following processing measures will be taken: The system automatically generates a replenishment recommendation quantity. The specific calculation formula is as follows:

[0029] R = D × T + LS;

[0030] Among them, R is the recommended replenishment quantity, D is the average daily sales volume, T is the replenishment cycle, L is the safety stock quantity, and S is the current inventory quantity;

[0031] Adjust the purchasing plan according to the recommended replenishment quantity;

[0032] Adjust sales strategies based on inventory warnings.

[0033] As a preferred implementation of the present invention, the specific process of the picking task management module automatically generating the picking task is as follows:

[0034] The system first analyzes the demand for each order and determines the items and quantities that need to be picked. The order demand is expressed by the following formula:

[0035]

[0036] Among them, DX represents the order demand, that is, the total quantity of all commodities in the order, qm represents the quantity of the mth commodity, and n represents the number of types of commodities in the order;

[0037] The system needs to check the current inventory status to ensure that there is enough inventory to meet order requirements. The inventory status is expressed by the following formula:

[0038] Inventory availability = current inventory - order demand;

[0039] Inventory availability refers to the remaining quantity after deducting the order demand from the current inventory quantity. If the inventory availability is greater than or equal to 0, the inventory is sufficient. If the inventory availability is less than 0, the inventory is insufficient.

[0040] According to the order requirements and inventory status, the system generates a picking task, specifies the goods to be picked and their quantity, and the picking task is expressed by the following formula: Picking task = {goods code, quantity, picking location, batch information, packaging requirements, picking time, remarks}.

[0041] As a preferred implementation of the present invention, the specific process of the picking task management module supporting real-time dynamic scheduling is as follows:

[0042] Get the total order amount of each order. The system calculates the order priority based on the order urgency, customer importance and total order amount. The order priority is expressed by the following formula:

[0043] Order priority = c1 × order urgency + c2 × customer importance + c3 × total order amount;

[0044] Wherein, c1, c2 and c3 represent the weight of order urgency, the weight of customer importance and the weight of total order amount respectively, c1, c2 and c3 are all greater than 0 and c1+c2+c3=1;

[0045] If the order priority value is close to 1, it means that the order priority is very high and needs to be processed first;

[0046] If the order priority value is close to 0, it means that the order priority is very low and can be processed later;

[0047] The order urgency is expressed by the following formula:

[0048]

[0049] The delivery date is the delivery date specified in the order, the current date is the current date and time, and the maximum allowable time difference is the maximum allowable time difference set by the enterprise, indicating the maximum allowable time from order generation to delivery;

[0050] If the order urgency value is close to 1, it means the order is very urgent;

[0051] If the order urgency value is close to 0, it means that the order is relatively not urgent;

[0052] The total transaction amount of each user is obtained, and the users are divided into ordinary customers, important customers and core customers according to the preset total transaction amount standard. When the user is judged as an ordinary customer, the corresponding customer importance value is marked as 0.3; when the user is judged as an important customer, the corresponding customer importance value is marked as 0.6; when the user is judged as a core customer, the corresponding customer importance value is marked as 1.0.

[0053] As a preferred embodiment of the present invention, the system sorts the picking tasks according to the order priority. First, the system obtains all the picking tasks that have not been processed, then calculates the priority of each picking task, and finally, uses a sorting algorithm to sort the picking tasks. The sorting is based on the order priority. The picking tasks with high priority are arranged in front, and the picking tasks with low priority are arranged in the back.

[0054] During the picking task execution process, the system will monitor the changes in inventory status and order priority in real time, and dynamically adjust the execution order of the picking tasks according to these changes. The specific steps are as follows:

[0055] The system continuously monitors the inventory status. Whenever the inventory quantity changes, the feasibility of each picking task is recalculated. If the priority of an order changes, the system will recalculate the priority of the order. The picking tasks are reordered according to the latest priority and inventory status. The system executes the tasks in the adjusted picking task order. Tasks with high priority are executed first, and tasks with low priority are executed when there is sufficient inventory.

[0056] As a preferred embodiment of the present invention, the specific process of the picking task management module confirming the goods by barcode scanning is as follows:

[0057] The picker uses a handheld terminal to scan the barcode of the goods, and the system records the picked goods and their quantities. First, the system verifies whether the scanned barcode is consistent with the product barcode specified in the picking task. If it is consistent, the scan is confirmed to be valid, otherwise it is invalid. Next, the system will perform goods confirmation. This process requires that the scan confirmation and quantity confirmation are true at the same time, that is, the barcode matches and the picking quantity is correct. Once the goods are confirmed successfully, the system will update the inventory status and reduce the corresponding inventory quantity. Finally, the system will update the order status and mark it as picked.

[0058] As a preferred embodiment of the present invention, the specific process of the handheld terminal operation feedback module for task reception, real-time data update and status feedback is as follows:

[0059] The system assigns picking tasks to appropriate pickers based on the dynamic scheduling algorithm and pushes the tasks to the handheld terminal through the wireless network. The pickers check the task list on the terminal and confirm receipt. The task status changes from "pending" to "received" and the timer starts.

[0060] During the task execution, the picker records the picked goods and their quantity by scanning the barcode of the goods. The system synchronizes the data in real time and updates the inventory status and order status. The inventory update formula is: inventory quantity = current inventory quantity - picking quantity. The order status is updated to "picked";

[0061] In addition, pickers update the task status in real time through handheld terminals and provide feedback on abnormal situations when they encounter them. The system immediately processes the information and notifies relevant personnel.

[0062] As a preferred embodiment of the present invention, the specific process of the data analysis exception processing module generating statistical reports and managing picking exceptions is as follows:

[0063] The system collects data uploaded by handheld terminals in real time through wireless networks, and aggregates these data into a central database through the background management system. Based on the aggregated data, the system automatically generates various statistical reports;

[0064] Through the backend management system, the system monitors the picking efficiency and error rate of pickers in real time, calculates the picking efficiency and error rate, and visualizes the real-time data in the form of charts;

[0065] In addition, the system records the exception information fed back by the pickers, classifies and manages the exception information, automatically or manually handles the exceptions according to the exception type and priority, and finally feeds back the exception handling results to the relevant personnel.

[0066] Compared with the prior art, the advantages of the present invention are:

[0067] (1) In the present invention, the order inventory management module is used to update inventory data in real time, automatically generate replenishment suggestions and early warning notifications, set safety inventory and replenishment strategies based on historical sales data and demand forecasts, reduce inventory backlogs and shortage risks, dynamically allocate orders, optimize resource utilization, and update order status in real time through handheld terminals to improve visual management capabilities;

[0068] (2) In the present invention, the picking task management module automatically analyzes order requirements, checks inventory status, generates comprehensive picking tasks, confirms goods through barcode scanning, updates inventory and order status in real time, supports dynamic scheduling, ensures that high-priority tasks are processed first, and optimizes warehouse resource utilization. BRIEF DESCRIPTION OF THE DRAWINGS

[0069] Figure 1 is a system block diagram of the present invention;

[0070] Figure 2 This is a system block diagram of Embodiment 1 of the present invention;

[0071] Figure 3 It is a logical flow diagram of the present invention. DETAILED DESCRIPTION

[0072] The following will combine the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all the embodiments. All other embodiments obtained by ordinary technicians in this field without creative work based on the embodiments of the present invention belong to the scope of protection of the present invention.

[0073] Embodiment 1: Figure 2 and Figure 3 As shown, the present invention proposes a real-time dynamic picking control system based on an intelligent handheld terminal, including a management platform, a user authority management module, an order inventory management module, a picking task management module, a handheld terminal operation feedback module, and a data analysis exception processing module;

[0074] The management platform is connected to the data analysis exception handling module, the user authority management module, and the handheld terminal operation feedback module in a two-way communication manner. The management platform is connected to the order inventory management module in a one-way communication manner. The order inventory management module is connected to the picking task management module in a one-way communication manner. The picking task management module is connected to the handheld terminal operation feedback module in a one-way communication manner. The MySQL database, inventory database, central inventory management system, background management system, and central database are all set in the management platform. The sorting algorithm and dynamic scheduling algorithm both use existing algorithms. The sorting algorithm is an algorithm that arranges a set of data in a specific order. The dynamic scheduling algorithm is an algorithm that dynamically adjusts the order of task execution according to the current state at runtime. The above algorithms all use existing technologies and are not elaborated on here.

[0075] User rights management module, used for user login, rights management and activity log recording;

[0076] The specific implementation process of the user rights management module is as follows:

[0077] User login: The user enters the username (such as email address) and password to log in. The system checks whether the username exists. If it does, the password is encrypted with the same encryption algorithm (such as SHA-256) and compared. After a successful match, the system sends a text message verification code to the user's mobile phone for secondary verification. If the verification is successful, a session token (such as JWT) is generated and stored in the user's browser cookie. Subsequent requests carry this token for verification by the system. Using text message verification codes for secondary verification can enhance security;

[0078] Permission management: Create a role table and a permission table in the MySQL database, define roles (such as administrators, pickers) and permissions (such as creating orders, viewing inventory), associate roles with permissions through the role permission table, and the administrator adjusts user roles or permissions through the user management interface. Use Spring Security's @PreAuthorize annotation to implement permission checks on methods. The permission management system supports dynamic adjustment, and administrators can update user permissions in real time to ensure permission consistency.

[0079] Activity log recording: Create an activity log table in the MySQL database to record key operations (such as user login, permission change, order creation, etc.). The log contains the operation time, type, operator and result information. The administrator can retrieve the log of a specific time period, user or operation type through the log query interface for auditing and tracing, ensuring that the system operation is transparent, secure, compliant and traceable, and supporting system management;

[0080] The order inventory management module is used to process customer orders, monitor inventory in real time, update inbound and outbound information, track order status, and provide inventory warnings and automatic replenishment suggestions;

[0081] The specific process of the order inventory management module to process customer orders, monitor inventory in real time, update inbound and outbound information, and track order status is as follows:

[0082] The system receives orders from customers or sales channels through APIs or interfaces, then verifies the completeness and accuracy of the order to ensure that the product code, quantity, customer information, etc. are valid; then, the order is allocated to the corresponding warehouse or distribution center based on inventory status and order priority; finally, after the order is confirmed, an order number is generated and the customer is notified that the order has been received;

[0083] Use a smart handheld terminal to scan inventory tags and update the inventory database in real time (inventory quantity = current inventory quantity + scanned quantity). Through the wireless network, synchronize the data of the handheld terminal to the central inventory management system in real time (real-time inventory = local inventory + synchronized inventory). The update of inventory quantity follows the following formula: inventory quantity = current inventory quantity + incoming quantity - outgoing quantity;

[0084] When a product enters the warehouse, by scanning the product barcode (the barcode is a barcode or a QR code), the handheld terminal automatically records the quantity entered and updates the inventory database (inventory quantity = current inventory quantity + quantity entered); when a product leaves the warehouse, by scanning the order barcode, the handheld terminal automatically records the quantity left and updates the inventory database (inventory quantity = current inventory quantity - quantity left);

[0085] At each stage of order receipt, processing, delivery and completion, the handheld terminal updates the order status in real time. The status change process is: order status = initial status → processing → shipped → completed;

[0086] The specific process of the order inventory management module providing inventory warnings and automatic replenishment suggestions is as follows:

[0087] Get the historical sales data of each product. The historical sales data includes sales order records, sales delivery records, and sales return records. Set the safety stock quantity of each product based on the historical sales data and demand forecast. The demand forecast is to estimate the sales demand in the future based on the historical sales data and other relevant factors. The specific calculation formula is as follows:

[0088] Forecast demand = b1 × current sales volume + (1-b1) × previous period forecast demand;

[0089] Among them, the predicted demand is the sales demand expected in a certain period of time in the future, b1 is the preset impact factor coefficient, ranging from 0 to 1, indicating the impact of the current sales volume, the current sales volume is the latest actual sales volume, and the previous period predicted demand is the sales demand predicted last time;

[0090] The safety stock quantity of each product is calculated based on the demand forecast and lead time. The lead time is the time from order placement to delivery. The formula for calculating the safety stock quantity is as follows: Safety stock quantity = average daily sales volume × lead time;

[0091] When the system detects that the current inventory quantity is lower than the safety inventory quantity, an inventory warning will be triggered. When the inventory warning is triggered, the system will automatically generate a warning notification and notify relevant personnel via email, SMS or system information. The warning notification content includes product code, current inventory quantity, safety inventory quantity, warning time, etc. After the inventory warning is triggered, the following processing measures are taken: The system automatically generates a replenishment recommendation quantity. The specific calculation formula is as follows:

[0092] R = D × T + LS;

[0093] Among them, R is the recommended replenishment quantity, D is the average daily sales volume, T is the replenishment cycle, L is the safety stock quantity, and S is the current inventory quantity;

[0094] Adjust the purchasing plan according to the recommended replenishment quantity to ensure sufficient inventory;

[0095] Adjust sales strategies based on inventory warnings to avoid inventory shortages affecting sales;

[0096] The specific process of automatically generating picking tasks by the picking task management module is as follows:

[0097] The system first analyzes the demand for each order and determines the items and quantities that need to be picked. The order demand is expressed by the following formula:

[0098]

[0099] Among them, DX represents the order demand, that is, the total quantity of all commodities in the order, qm represents the quantity of the mth commodity, and n represents the number of types of commodities in the order;

[0100] The system needs to check the current inventory status to ensure that there is enough inventory to meet order requirements. The inventory status is expressed by the following formula:

[0101] Inventory availability = current inventory - order demand;

[0102] Inventory availability refers to the remaining quantity after deducting the order demand from the current inventory quantity. If the inventory availability is greater than or equal to 0, the inventory is sufficient. If the inventory availability is less than 0, the inventory is insufficient.

[0103] According to the order requirements and inventory status, the system generates a picking task, specifies the goods to be picked and their quantity, and the picking task is expressed by the following formula: Picking task = {goods code, quantity, picking location, batch information, packaging requirements, picking time, remarks}, where the goods code is the unique identifier of the goods, the quantity is the number of goods to be picked, the picking location is the specific storage location of the goods in the warehouse, and the inventory management system is queried according to the goods code to obtain the specific storage location of each goods in the warehouse, the batch information is the batch number of the goods, and for items that need to track batches, the batch number of the goods is obtained from the inventory management system, the packaging requirements are the special packaging requirements of the goods, and the special packaging requirements are extracted from the order, such as shockproof, moisture-proof, etc. If there is no clear packaging requirement, the default packaging standard is used, the picking time is the estimated picking start time and end time, and the picking start time and end time are estimated according to the urgency of the order and the work arrangement of the warehouse, and the remarks are other matters that need to be noted, which can be input from the order system or manually;

[0104] The order inventory management module updates inventory data in real time, automatically generates replenishment suggestions and early warning notifications, sets safety inventory and replenishment strategies based on historical sales data and demand forecasts, reduces inventory backlogs and shortage risks, dynamically allocates orders, optimizes resource utilization, and updates order status in real time through handheld terminals to improve visual management capabilities;

[0105] The picking task management module is used to automatically generate picking tasks based on order requirements and inventory status, support real-time dynamic scheduling, and confirm goods through barcode scanning;

[0106] The specific process of the picking task management module supporting real-time dynamic scheduling is as follows:

[0107] Get the total order amount of each order. The system calculates the order priority based on the order urgency, customer importance and total order amount. The order priority is expressed by the following formula:

[0108] Order priority = c1 × order urgency + c2 × customer importance + c3 × total order amount;

[0109] Wherein, c1, c2 and c3 represent the weight of order urgency, the weight of customer importance and the weight of total order amount respectively, c1, c2 and c3 are all greater than 0 and c1+c2+c3=1;

[0110] By analyzing historical data, we can understand the influence of the weight of order urgency, the weight of customer importance, and the weight of total order amount. Based on historical data, we can determine the specific values ​​of c1, c2, and c3 to ensure that the calculated order priority can accurately reflect the actual situation of the user's order.

[0111] If the order priority value is close to 1, it means that the order priority is very high and needs to be processed first;

[0112] If the order priority value is close to 0, it means that the order priority is very low and can be processed later;

[0113] The order urgency is expressed by the following formula:

[0114]

[0115] The delivery date is the delivery date specified in the order, the current date is the current date and time, and the maximum allowable time difference is the maximum allowable time difference set by the enterprise, indicating the maximum allowable time from order generation to delivery;

[0116] If the order urgency value is close to 1, it means the order is very urgent;

[0117] If the order urgency value is close to 0, it means that the order is relatively not urgent;

[0118] Obtain the total transaction amount of each user, and classify the user into ordinary customers, important customers, and core customers according to the preset total transaction amount standard. When a user is determined to be an ordinary customer, the corresponding customer importance value is marked as 0.3; when a user is determined to be an important customer, the corresponding customer importance value is marked as 0.6; when a user is determined to be a core customer, the corresponding customer importance value is marked as 1.0;

[0119] The system sorts the picking tasks according to the order priority. First, the system obtains all the picking tasks that have not been processed. Then, it calculates the priority of each picking task. Finally, it uses a sorting algorithm (such as quick sort, merge sort, etc.) to sort the picking tasks. The sorting is based on the order priority. The picking tasks with high priority are placed in front, and the picking tasks with low priority are placed in the back.

[0120] During the picking task execution process, the system will monitor the changes in inventory status and order priority in real time, and dynamically adjust the execution order of the picking tasks according to these changes. The specific steps are as follows:

[0121] The system continuously monitors the inventory status. Whenever the inventory quantity changes, the feasibility of each picking task is recalculated. If the priority of an order changes (for example, the customer's importance increases or the total amount of the order increases), the system will recalculate the priority of the order and reorder the picking tasks according to the latest priority and inventory status. The system executes the tasks in the adjusted picking order. Tasks with higher priorities are executed first, and tasks with lower priorities are executed when there is sufficient inventory.

[0122] In the process of dynamic scheduling, insufficient inventory or other abnormal situations may occur. The system will handle them according to the specific situation: if a picking task cannot be executed due to insufficient inventory, the system will temporarily suspend the task and recalculate the priority and execution order of other tasks; after the inventory is replenished, the system will reactivate the task and adjust the execution order; if an order is cancelled, the system will immediately remove the picking task of the order from the pending tasks and reorder the remaining tasks;

[0123] The specific process of the picking task management module confirming the goods through barcode scanning is as follows:

[0124] The picker uses a handheld terminal to scan the barcode of the goods, and the system records the picked goods and their quantities. First, the system verifies whether the scanned barcode is consistent with the barcode of the product specified in the picking task. If it is consistent, the scan is confirmed to be valid, otherwise it is invalid. Then, the system will confirm the goods. This process requires that the scan confirmation and quantity confirmation are true at the same time, that is, the barcode matches and the picking quantity is correct. Once the goods are confirmed successfully, the system will update the inventory status and reduce the corresponding inventory quantity. Finally, the system will update the order status and mark it as picked;

[0125] The picking task management module automatically analyzes order requirements, checks inventory status, generates comprehensive picking tasks, confirms goods through barcode scanning, updates inventory and order status in real time, supports dynamic scheduling, ensures that high-priority tasks are processed first, and optimizes warehouse resource utilization.

[0126] Embodiment 2: The technical solution of the embodiment of the present invention is different from that of embodiment 1 in that:

[0127] like Figure 1 As shown, the handheld terminal operation feedback module is used for task reception, real-time data update and status feedback;

[0128] The specific process of the handheld terminal operation feedback module for task reception, real-time data update and status feedback is as follows:

[0129] Based on the dynamic scheduling algorithm, the system comprehensively considers factors such as the current location of the picker, task priority, and inventory status, assigns the picking task to the appropriate picker, and pushes the task to the handheld terminal through the wireless network. The picker checks the task list on the terminal and confirms receipt. The task status changes from "pending" to "received", and the timer starts.

[0130] During the task execution, the picker records the picked goods and their quantity by scanning the barcode of the goods. The system synchronizes the data in real time and updates the inventory status and order status. The inventory update formula is: inventory quantity = current inventory quantity - picking quantity. The order status is updated to "picked";

[0131] In addition, the pickers can update the task status (such as "picking", "completed") in real time through handheld terminals, and feedback abnormal information when encountering abnormal situations. The system will immediately handle it and notify relevant personnel;

[0132] The handheld terminal operation feedback module improves the transparency and efficiency of warehouse operations through intelligent task allocation, real-time data update and status feedback. The system intelligently allocates tasks according to the dynamic scheduling algorithm to reduce the moving distance of pickers. Pickers record the picked goods by scanning barcodes. The system updates the inventory and order status in real time. The handheld terminal updates the task status in real time and feedbacks information in abnormal situations to ensure that problems are solved in time. The data analysis module improves the system's intelligence and data-driven capabilities by collecting data, generating reports, and monitoring picking efficiency and error rates, helping enterprises optimize picking operations and providing scientific decision-making support.

[0133] Data analysis exception handling module, used for data collection and aggregation, generating statistical reports, real-time monitoring of picking efficiency and error rate, and recording and managing picking exceptions;

[0134] The specific process of the data analysis exception handling module to generate statistical reports and manage picking exceptions is as follows:

[0135] The system collects data uploaded by handheld terminals in real time through wireless networks, including task status, picking quantity, inventory update, order status, etc., and summarizes these data into the central database through the backend management system. Based on the summarized data, the system automatically generates various statistical reports, such as picking efficiency report, error rate report, inventory change report and order status report. The report content covers the picker's working time, task completion quantity, picking efficiency, error number, error type, inventory quantity change, current order status, etc.

[0136] Through the backend management system, the system monitors the picking efficiency and error rate of pickers in real time, calculates the picking efficiency and error rate, and visualizes the real-time data in the form of charts, including picking efficiency trend charts, error rate trend charts, picker performance rankings, etc.

[0137] In addition, the system records the abnormal information reported by the pickers, such as insufficient inventory, barcode errors, quantity errors, equipment failures, etc., and classifies and manages the abnormal information. It automatically or manually handles the abnormal situation according to the type and priority of the abnormal situation, such as reallocating tasks, updating inventory status, notifying relevant personnel, and finally feeding back the abnormal handling results to the relevant personnel;

[0138] The data analysis exception handling module collects and summarizes handheld terminal data in real time to generate picking efficiency, error rate, inventory change and order status reports. The system monitors the efficiency and error rate of pickers in real time, and displays trends and performance rankings through charts to help managers identify problems in a timely manner. The system records and classifies abnormal information, such as insufficient inventory, barcode errors, etc., automatically or manually handles abnormal situations, and feeds back the results to ensure that problems are resolved in a timely manner. This module significantly improves the intelligence and refinement of warehouse management, improves the efficiency and accuracy of data processing, and provides enterprises with efficient and reliable warehouse management solutions.

[0139] The working principle of the present invention is as follows: when in use, the inventory data is updated in real time through the order inventory management module, replenishment suggestions and early warning notifications are automatically generated, safety inventory and replenishment strategies are set based on historical sales data and demand forecasts, inventory backlogs and shortage risks are reduced, orders are dynamically allocated, resource utilization is optimized, order status is updated in real time through handheld terminals, visual management capabilities are improved, and order requirements are automatically analyzed through the picking task management module, inventory status is checked, comprehensive picking tasks are generated, goods are confirmed through barcode scanning, inventory and order status are updated in real time, dynamic scheduling is supported, high-priority tasks are guaranteed to be given priority, and warehouse resource utilization is optimized.

[0140] The above are only preferred specific implementation modes of the present invention; however, the protection scope of the present invention is not limited thereto; any technician familiar with the technical field within the technical scope disclosed by the present invention; any equivalent replacement or change based on the technical solution and improved concept of the present invention shall be covered within the protection scope of the present invention.

Claims

1. A real-time dynamic picking control system based on an intelligent handheld terminal, characterized in that: It includes management platform, user authority management module, order inventory management module, picking task management module, handheld terminal operation feedback module, and data analysis exception handling module; User rights management module, used for user login, rights management and activity log recording; The order inventory management module is used to process customer orders, monitor inventory in real time, update inbound and outbound information, track order status, and provide inventory warnings and automatic replenishment suggestions; The picking task management module is used to automatically generate picking tasks based on order requirements and inventory status, support real-time dynamic scheduling, and confirm goods through barcode scanning; Handheld terminal operation feedback module, used for task reception, real-time data update and status feedback; The data analysis exception handling module is used to collect and summarize data, generate statistical reports, monitor picking efficiency and error rate in real time, and record and manage picking exceptions.

2. According to claim 1, a real-time dynamic picking control system based on an intelligent handheld terminal is characterized in that: The specific implementation process of the user rights management module is as follows: User login: The user enters the username and password to log in. The system checks whether the username exists. If it does, the password is encrypted with the same encryption algorithm and compared. After a successful match, the system sends a text message verification code to the user's mobile phone for secondary verification. If the verification is successful, a session token is generated and stored in the user's browser cookie. Subsequent requests carry this token for system verification; Permission management: Create a role table and a permission table in the MySQL database, define roles and permissions respectively, associate roles and permissions through the role permission table, and the administrator adjusts user roles or permissions through the user management interface. Use SpringSecurity's @PreAuthorize annotation to implement permission checks on methods. The permission management system supports dynamic adjustment, and administrators can update user permissions in real time. Activity logging: Create an activity log table in the MySQL database to record logs of key operations. Administrators can retrieve logs for a specific time period, user, or operation type through the log query interface.

3. According to claim 1, a real-time dynamic picking control system based on an intelligent handheld terminal is characterized in that: The specific process of the order inventory management module processing customer orders, real-time inventory monitoring, updating in and out of storage information, and tracking order status is as follows: The system receives orders from customers or sales channels through APIs or interfaces, and then verifies the completeness and accuracy of the orders. Next, the orders are assigned to the corresponding warehouses or distribution centers based on inventory availability and order priority. Finally, after the order is confirmed, an order number is generated and the customer is notified that the order has been received. Use smart handheld terminals to scan inventory tags and update the inventory database in real time. Through the wireless network, the data of the handheld terminal is synchronized to the central inventory management system in real time. The update of inventory quantity follows the following formula: inventory quantity = current inventory quantity + incoming quantity - outgoing quantity; When products enter the warehouse, the handheld terminal automatically records the quantity entering the warehouse and updates the inventory database by scanning the product barcode. When products leave the warehouse, the handheld terminal automatically records the quantity leaving the warehouse and updates the inventory database by scanning the order barcode. At each stage of order receipt, processing, shipment and completion, the handheld terminal updates the order status in real time. The status change process is: order status = initial status → processing → shipped → completed.

4. A real-time dynamic picking control system based on an intelligent handheld terminal according to claim 3, characterized in that: The specific process of the order inventory management module providing inventory warning and automatic replenishment suggestions is as follows: Get the historical sales data of each product, and set the safety stock quantity of each product based on the historical sales data and demand forecast. The demand forecast is to estimate the sales demand in the future based on the historical sales data and other relevant factors. The specific calculation formula is as follows: Forecast demand = b1 × current sales volume + (1-b1) × previous period forecast demand; Among them, the predicted demand is the sales demand expected in a certain period of time in the future, b1 is the preset impact factor coefficient, ranging from 0 to 1, indicating the impact of the current sales volume, the current sales volume is the latest actual sales volume, and the previous period predicted demand is the sales demand predicted last time; The safety stock quantity of each product is calculated based on the demand forecast and lead time. The lead time is the time from order placement to delivery. The formula for calculating the safety stock quantity is as follows: Safety stock quantity = average daily sales volume × lead time; When the system detects that the current inventory quantity is lower than the safety inventory quantity, an inventory warning will be triggered. When the inventory warning is triggered, the system will automatically generate a warning notification and notify relevant personnel via email, SMS or system information. After the inventory warning is triggered, the following processing measures will be taken: The system automatically generates a replenishment recommendation quantity. The specific calculation formula is as follows: R = D × T + LS; Among them, R is the recommended replenishment quantity, D is the average daily sales volume, T is the replenishment cycle, L is the safety stock quantity, and S is the current inventory quantity; Adjust the purchasing plan according to the recommended replenishment quantity; Adjust sales strategies based on inventory warnings.

5. According to the real-time dynamic picking control system based on the intelligent handheld terminal of claim 1, it is characterized in that: The specific process of automatically generating picking tasks by the picking task management module is as follows: The system first analyzes the demand for each order and determines the items and quantities that need to be picked. The order demand is expressed by the following formula: Among them, DX represents the order demand, that is, the total quantity of all commodities in the order, qm represents the quantity of the mth commodity, and n represents the number of types of commodities in the order; The system needs to check the current inventory status to ensure that there is enough inventory to meet order requirements. The inventory status is expressed by the following formula: Inventory availability = current inventory - order demand; Inventory availability refers to the remaining quantity after deducting the order demand from the current inventory quantity. If the inventory availability is greater than or equal to 0, the inventory is sufficient. If the inventory availability is less than 0, the inventory is insufficient. According to the order requirements and inventory status, the system generates a picking task, specifies the goods to be picked and their quantity, and the picking task is expressed by the following formula: Picking task = {goods code, quantity, picking location, batch information, packaging requirements, picking time, remarks}.

6. A real-time dynamic picking control system based on an intelligent handheld terminal according to claim 5, characterized in that: The specific process of the picking task management module supporting real-time dynamic scheduling is as follows: Get the total order amount of each order. The system calculates the order priority based on the order urgency, customer importance and total order amount. The order priority is expressed by the following formula: Order priority = c1 × order urgency + c2 × customer importance + c3 × total order amount; Wherein, c1, c2 and c3 represent the weight of order urgency, the weight of customer importance and the weight of total order amount respectively, c1, c2 and c3 are all greater than 0 and c1+c2+c3=1; If the order priority value is close to 1, it means that the order priority is very high and needs to be processed first; If the order priority value is close to 0, it means that the order priority is very low and can be processed later; The order urgency is expressed by the following formula: The delivery date is the delivery date specified in the order, the current date is the current date and time, and the maximum allowable time difference is the maximum allowable time difference set by the enterprise, indicating the maximum allowable time from order generation to delivery; If the order urgency value is close to 1, it means the order is very urgent; If the order urgency value is close to 0, it means that the order is relatively not urgent; The total transaction amount of each user is obtained, and the users are divided into ordinary customers, important customers and core customers according to the preset total transaction amount standard. When the user is judged as an ordinary customer, the corresponding customer importance value is marked as 0.3; when the user is judged as an important customer, the corresponding customer importance value is marked as 0.6; when the user is judged as a core customer, the corresponding customer importance value is marked as 1.

0.

7. A real-time dynamic picking control system based on an intelligent handheld terminal according to claim 6, characterized in that: The system sorts the picking tasks according to the order priority. First, the system obtains all the picking tasks that have not been processed. Then, it calculates the priority of each picking task. Finally, it uses the sorting algorithm to sort the picking tasks. The sorting is based on the order priority. The picking tasks with high priority are placed in front, and the picking tasks with low priority are placed in the back. During the picking task execution process, the system will monitor the changes in inventory status and order priority in real time, and dynamically adjust the execution order of the picking tasks according to these changes. The specific steps are as follows: The system continuously monitors the inventory status and recalculates the feasibility of each picking task whenever the inventory quantity changes. If the priority of an order changes, the system will recalculate the priority of the order. The picking tasks are reordered according to the latest priority and inventory status. The system executes the tasks in the adjusted picking task order. Tasks with high priority are executed first, and tasks with low priority are executed when there is sufficient inventory.

8. The real-time dynamic picking control system based on an intelligent handheld terminal according to claim 7, characterized in that: The specific process of the picking task management module confirming the goods through barcode scanning is as follows: The picker uses a handheld terminal to scan the barcode of the goods, and the system records the picked goods and their quantities. First, the system verifies whether the scanned barcode is consistent with the product barcode specified in the picking task. If it is consistent, the scan is confirmed to be valid, otherwise it is invalid. Next, the system will perform goods confirmation. This process requires that the scan confirmation and quantity confirmation are true at the same time, that is, the barcode matches and the picking quantity is correct. Once the goods are confirmed successfully, the system will update the inventory status and reduce the corresponding inventory quantity. Finally, the system will update the order status and mark it as picked.

9. The real-time dynamic picking control system based on an intelligent handheld terminal according to claim 1, characterized in that: The specific process of the handheld terminal operation feedback module for task reception, real-time data update and status feedback is as follows: The system assigns picking tasks to appropriate pickers based on the dynamic scheduling algorithm and pushes the tasks to the handheld terminal through the wireless network. The pickers check the task list on the terminal and confirm receipt. The task status changes from "pending" to "received" and the timer starts. During the task execution, the picker records the picked goods and their quantity by scanning the barcode of the goods. The system synchronizes the data in real time and updates the inventory status and order status. The inventory update formula is: inventory quantity = current inventory quantity - picking quantity. The order status is updated to "picked"; In addition, pickers update the task status in real time through handheld terminals and provide feedback on abnormal situations when they encounter them. The system immediately processes the information and notifies relevant personnel.

10. The real-time dynamic picking control system based on an intelligent handheld terminal according to claim 1, characterized in that: The specific process of the data analysis exception handling module generating statistical reports and managing picking exceptions is as follows: The system collects data uploaded by handheld terminals in real time through wireless networks, and aggregates these data into a central database through the background management system. Based on the aggregated data, the system automatically generates various statistical reports; Through the backend management system, the system monitors the picking efficiency and error rate of pickers in real time, calculates the picking efficiency and error rate, and visualizes the real-time data in the form of charts; In addition, the system records the exception information fed back by the pickers, classifies and manages the exception information, automatically or manually handles the exceptions according to the exception type and priority, and finally feeds back the exception handling results to the relevant personnel.

Images