Order batch collection method and device, equipment and storage medium

Abstract

The invention relates to the technical field of data processing, in particular to an order batch collection method and device, equipment and a storage medium, and the method comprises the steps: obtaining real-time order data, and carrying out the preprocessing of the real-time order data, and obtaining the preprocessed real-time order data; performing data extraction processing on the preprocessed real-time order data to obtain a warehouse-out data table; updating the ex-warehouse data table based on the obtained and preset sorting area table and ex-warehouse data to obtain a sorting data table; based on the obtained parcel collection scanning information and the sorting data table, whether parcel collection abnormal conditions exist or not is judged, the sorting data table is updated based on a judgment result, and a parcel collection data table is obtained; based on the obtained warehouse-out scanning information and the parcel collection data table, whether warehouse-out abnormal conditions exist or not is judged, the parcel collection data table is updated based on a judgment result, and the warehouse-out data table is obtained; according to the method disclosed by the invention, batch processing of order data can be realized in a sorting link, a parcel collection link and a warehouse-out link, and the order processing efficiency is improved.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a method, device, equipment and storage medium for collecting batch orders. Background Art

[0002] In a busy e-commerce warehouse environment, the number of order packages processed daily can easily exceed hundreds of thousands. This huge workload places extremely high demands on logistics efficiency and accuracy. In the traditional operation mode, a large amount of human resources is often required. Specifically, the sorting personnel use handheld barcode scanning equipment to collect and scan each package one by one to confirm its outbound status. Subsequently, the sorting personnel are required to perform tedious stacking operations for subsequent sorting and transportation. This process not only consumes a lot of manpower costs, but also increases the complexity and difficulty of the operation, posing a severe test on the physical strength and endurance of the operators.

[0003] What is even more difficult is that even under such high-intensity operations, it is still difficult to completely avoid human omissions; occasional omissions, such as failure to promptly scan a package for collection, will result in the loss of key collection records in its logistics trajectory; the lack of collection records not only affects the customer's real-time tracking experience of the package status, but may also trigger a series of chain reactions, such as inaccurate data statistics, complicated settlement process, and may even damage the reputation of the e-commerce platform and customer trust.

[0004] It can be seen that the existing technology still needs to be improved and enhanced. Summary of the invention

[0005] In order to overcome the deficiencies of the prior art, an object of the present invention is to provide a method for collecting orders in batches, which has the advantages of high order processing efficiency and low labor costs.

[0006] A first aspect of the present invention provides a method for batch collection of orders, comprising: obtaining real-time order data including multiple real-time orders, and preprocessing the real-time order data to obtain preprocessed real-time order data; performing data extraction processing on the preprocessed real-time order data to obtain a delivery data table, wherein the delivery data table includes delivery information corresponding to each real-time order; obtaining a preset sorting area table, and updating the delivery data table based on the sorting area table and the delivery information corresponding to each real-time order to obtain a sorting data table; obtaining scanning information of items to be collected, matching the collection scanning information with the sorting data table to determine whether there is an abnormal collection situation, and updating the sorting data table based on the determination result to obtain a collection data table; obtaining delivery scanning information, matching the delivery scanning information with the collection data table to determine whether there is an abnormal delivery situation, and updating the collection data table based on the determination result to obtain a delivery data table.

[0007] Optionally, in a first implementation method of the first aspect of the present invention, the acquiring of real-time order data including multiple real-time orders and preprocessing of the real-time order data to obtain preprocessed real-time order data includes: acquiring real-time order data including multiple real-time orders, the real-time data of each real-time order including order ID, order time, order source, product information and user information, and storing the acquired real-time order data in Redis; performing data cleaning processing on the real-time order data to obtain cleaned real-time order data; performing conversion processing on the cleaned real-time order data to obtain standardized real-time order data; performing statistical processing on the standardized real-time order data to obtain preprocessed real-time order data.

[0008] Optionally, in a second implementation method of the first aspect of the present invention, the pre-processed real-time order data is subjected to data extraction processing to obtain an outbound data table, wherein the outbound data table includes outbound information corresponding to each real-time order, including: based on the acquired and preset outbound keyword information, a hash algorithm is used to perform data extraction processing on the real-time order data to obtain real-time outbound data, wherein the real-time outbound data includes commodity information corresponding to each real-time order; the total amount of commodities is calculated based on the commodity information corresponding to each real-time order, and an outbound number corresponding to each real-time order is generated according to a preset outbound number generation rule; the real-time outbound data, the total amount of commodities and the outbound number are converted into fields for table construction, and indexes are added to the fields according to preset query rules to construct an outbound data table, wherein the outbound data table includes outbound information corresponding to each real-time order.

[0009] Optionally, in a third implementation of the first aspect of the present invention, the obtaining of a preset sorting area table, updating the outbound delivery data table based on the sorting area table and the outbound delivery information corresponding to each real-time order, and obtaining the sorting data table, includes: obtaining a preset sorting area table, the sorting area table including sorting area location information, sorting area number and sorting jurisdiction; performing address standardization processing on the address information corresponding to each real-time order included in the outbound delivery information to obtain standardized outbound delivery information; using a regular expression to match the standardized outbound delivery information with the sorting jurisdiction in the preset sorting area table to assign a sorting area number to each real-time order; converting the standardized outbound delivery information and the sorting area number into fields for table construction, and adding indexes to the fields according to the preset query construction to construct the sorting data table.

[0010] Optionally, in a fourth implementation method of the first aspect of the present invention, the address information included in the outbound information and corresponding to each real-time order is subjected to address standardization processing to obtain standardized outbound information, including: utilizing an address resolution algorithm to parse the address information included in the outbound information and corresponding to each real-time order to obtain address composition information; formatting and recombining the address composition information according to a preset address specification standard to obtain standard address information, integrating multiple standard address information and other information in the outbound information to obtain standardized outbound information; when an abnormality occurs in the parsing process and the formatting process, the real-time order with the abnormality will be transferred to a pre-built abnormal order list.

[0011] Optionally, in a fifth implementation manner of the first aspect of the present invention, the acquiring of scanning information of items to be picked up, matching of the scanning information of items to be picked up with the sorting data table to determine whether there is any abnormal situation in picking up items, and updating of the sorting data table based on the determination result to obtain the collection data table includes: acquiring scanning information of items to be picked up, the scanning information of items to be picked up including a scanned image of items to be picked up and a scanned time of items to be picked up; performing text extraction processing on the scanned image of items to be picked up using image recognition software to obtain a scanned text of items to be picked up; matching of the scanned text of items to be picked up with the sorting data table using an exact matching algorithm to determine whether the order information included in the scanned text of items to be picked up exists in the sorting data table; if not, transferring the real-time order corresponding to the scanning information of items to be picked up to a pre-built abnormal order list; if so, updating the sorting data table based on the scanned time of items to be picked up to obtain the collection data table.

[0012] Optionally, in a sixth implementation method of the first aspect of the present invention, the obtaining of outbound scanning information, matching of the outbound scanning information with the collection data table to determine whether there is an outbound abnormality, and updating the collection data table based on the determination result to obtain the outbound data table includes: obtaining shipment scanning information, the shipment scanning information including a shipment scanning image and a shipment scanning time; performing text extraction processing on the shipment scanning image using image recognition software to obtain a shipment scanning text; matching of the shipment scanning text with the collection data table using an exact matching algorithm to determine whether the order information included in the shipment scanning text exists in the collection data table; if not, transferring the real-time order corresponding to the shipment scanning information to a pre-built abnormal order list; if so, updating the collection data table based on the shipment scanning time to obtain the outbound data table.

[0013] According to a second aspect of the present invention, there is provided an order batch collection device, comprising: a processing module, configured to obtain real-time order data including a plurality of real-time orders, and pre-process the real-time order data to obtain pre-processed real-time order data; an extraction module, configured to perform data extraction processing on the pre-processed real-time order data to obtain a delivery data table, wherein the delivery data table comprises delivery information corresponding to each real-time order; a first updating module, configured to obtain a preset sorting area table, and update the delivery data table based on the sorting area table and the delivery information corresponding to each real-time order to obtain a sorting data table; a second updating module, configured to obtain scanning information of items to be collected, match the collection scanning information with the sorting data table to determine whether there is an abnormal collection situation, and update the sorting data table based on the determination result to obtain a collection data table; a third updating module, configured to obtain delivery scanning information, match the delivery scanning information with the collection data table to determine whether there is an abnormal collection situation, and update the collection data table based on the determination result to obtain a delivery data table.

[0014] Optionally, in a first implementation method of the second aspect of the present invention, the processing module includes: a first acquisition unit, used to acquire real-time order data including multiple real-time orders, the real-time data of each real-time order including order ID, order time, order source, product information and user information, and storing the acquired real-time order data in Redis; a cleaning unit, used to perform data cleaning processing on the real-time order data to obtain cleaned real-time order data; a conversion unit, used to convert the cleaned real-time order data to obtain standardized real-time order data; a statistical unit, used to perform statistical processing on the standardized real-time order data to obtain preprocessed real-time order data.

[0015] Optionally, in a second implementation of the second aspect of the present invention, the extraction module includes: a first extraction unit, used to perform data extraction processing on the real-time order data using a hash algorithm based on the acquired and preset outbound keyword information to obtain real-time outbound data, wherein the real-time outbound data includes commodity information corresponding to each real-time order; a calculation unit, used to calculate the total amount of commodities based on the commodity information corresponding to each real-time order, and generate an outbound number corresponding to each real-time order according to a preset outbound number generation rule; a first construction unit, used to convert the real-time outbound data, the total amount of commodities and the outbound number into fields for table construction, and add indexes to the fields according to preset query rules to construct an outbound data table, wherein the outbound data table includes the outbound information corresponding to each real-time order.

[0016] Optionally, in a third implementation of the second aspect of the present invention, the first update module includes: a second acquisition unit, used to acquire a preset sorting area table, the sorting area table including sorting area location information, sorting area number and sorting jurisdiction; a standardization unit, used to perform address standardization processing on the address information included in the outbound information and corresponding to each real-time order, to obtain standardized outbound information; a first matching unit, used to use a regular expression to match the standardized outbound information with the sorting jurisdiction in the preset sorting area table, so as to assign a sorting area number to each real-time order; a second construction unit, used to convert the standardized outbound information and the sorting area number into fields for table construction, and add indexes to the fields according to the preset query construction to construct a sorting data table.

[0017] Optionally, in a fourth implementation method of the second aspect of the present invention, the standardization unit includes: a parsing unit, which is used to use an address parsing algorithm to parse the address information included in the outbound information and corresponding to each real-time order to obtain address composition information; a combining unit, which is used to format and recombine the address composition information according to a preset address specification standard to obtain standard address information, integrate multiple standard address information and other information in the outbound information to obtain standardized outbound information; and a transferring unit, which is used to transfer the real-time order with the abnormal situation to a pre-built abnormal order list when an abnormal situation occurs in the parsing process and the formatting process.

[0018] Optionally, in a fifth implementation of the second aspect of the present invention, the second update module includes: a third acquisition unit, used to acquire scanning information of items to be picked up, the scanning information of items to be picked up includes a scanning image of the items to be picked up and a scanning time of the items to be picked up; a second extraction unit, used to perform text extraction processing on the scanning image of the items to be picked up using image recognition software to obtain a scanning text of the items to be picked up; a second matching unit, used to match the scanning text of the items to be picked up and the sorting data table using an exact matching algorithm to determine whether the order information included in the scanning text of the items to be picked up exists in the sorting data table; a first transfer unit, used to transfer the real-time order corresponding to the scanning information of the items to be picked up to a pre-built abnormal order list if it does not exist; and a first update unit, used to update the sorting data table based on the scanning time of the items to be picked up if it exists to obtain a collection data table.

[0019] Optionally, in a sixth implementation of the second aspect of the present invention, the third update module includes: a fourth acquisition unit, used to acquire shipping scan information, the shipping scan information including a shipping scan image and a shipping scan time; a third extraction unit, used to use image recognition software to perform text extraction processing on the shipping scan image to obtain a shipping scan text; a third matching unit, used to use an exact matching algorithm to match the shipping scan text and the collection data table to determine whether the order information included in the shipping scan text exists in the collection data table; a second transfer unit, used to transfer the real-time order corresponding to the shipping scan information to a pre-built abnormal order list if it does not exist; and a second update unit, used to update the collection data table based on the shipping scan time if it exists to obtain a warehouse data table.

[0020] The third aspect of the present invention provides a batch order collection device, which includes: a memory and at least one processor, wherein the memory stores instructions; at least one of the processors calls the instructions in the memory to enable the batch order collection device to perform each step of the batch order collection method described in any one of the above items.

[0021] A fourth aspect of the present invention provides a computer-readable storage medium having instructions stored thereon, which, when executed by a processor, implement the various steps of any of the above-mentioned methods for collecting batch orders.

[0022] In the technical solution of the present invention, preprocessed real-time order data is obtained by acquiring real-time order data and performing preprocessing; data extraction processing is performed on the preprocessed real-time order data to obtain a delivery data table; the delivery data table is updated based on the acquired, preset sorting area table and the delivery data to obtain a sorting data table; based on the acquired pick-up scanning information and the sorting data table, it is determined whether there is an abnormal pick-up situation, and based on the determination result, the sorting data table is updated to obtain the pick-up data table; based on the acquired delivery scanning information and the pick-up data table, it is determined whether there is an abnormal delivery situation, and based on the determination result, the pick-up data table is updated to obtain the delivery data table; the method disclosed in the present application can realize batch processing of order data in the sorting link, the pick-up link and the delivery link, effectively improves the order processing efficiency, greatly reduces labor costs, and can avoid data loss problems caused by manual operations, providing sufficient data support for warehouse management and decision-making. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] Figure 1 A first flow chart of a method for collecting orders in batches provided in an embodiment of the present invention;

[0024] Figure 2A second flow chart of the method for collecting orders in batches provided in an embodiment of the present invention;

[0025] Figure 3 A third flow chart of the method for collecting orders in batches provided in an embodiment of the present invention;

[0026] Figure 4 A fourth flow chart of the method for collecting orders in batches provided in an embodiment of the present invention;

[0027] Figure 5 A fifth flow chart of the method for collecting orders in batches provided in an embodiment of the present invention;

[0028] Figure 6 A sixth flow chart of the method for collecting orders in batches provided in an embodiment of the present invention;

[0029] Figure 7 A seventh flow chart of the method for collecting orders in batches provided in an embodiment of the present invention;

[0030] Figure 8 A schematic diagram of the structure of a device for collecting batch orders provided by an embodiment of the present invention;

[0031] Fig. 9 A schematic diagram of the structure of a device for collecting batch orders according to an embodiment of the present invention. DETAILED DESCRIPTION

[0032] The present invention provides a method, device, equipment and storage medium for batch collection of orders. In the present invention, the terms "first", "second", "third", "fourth", etc. (if any) in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments described herein can be implemented in an order other than that illustrated or described herein. In addition, the terms "including" or "having" and any variations thereof are intended to cover non-exclusive inclusions. For example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0033] For ease of understanding, the specific process of the embodiment of the present invention is described below. Figure 1 An embodiment of the method for collecting orders in batches in the embodiment of the present invention includes:

[0034] 101. Acquire real-time order data including a plurality of real-time orders, and pre-process the real-time order data to obtain pre-processed real-time order data;

[0035] In this embodiment, by acquiring and processing order data in real time, the immediate updating of logistics information can be ensured, thereby improving the efficiency and accuracy of order processing; at the same time, the automated data processing process reduces manual intervention and reduces the error rate.

[0036] 102. Perform data extraction processing on the pre-processed real-time order data to obtain a delivery data table, wherein the delivery data table includes delivery information corresponding to each real-time order;

[0037] 103. Obtain a preset sorting area table, and update the outbound data table based on the sorting area table and outbound information corresponding to each real-time order to obtain a sorting data table;

[0038] In this embodiment, the outbound data table is updated based on the sorting area table and the outbound information to form a sorting data table, thereby realizing intelligent sorting of orders, ensuring that the goods can be accurately and quickly allocated to the corresponding sorting areas, and improving the accuracy and efficiency of sorting.

[0039] 104. Obtain scanning information of items to be picked up, match the scanning information of items to be picked up with the sorting data table to determine whether there is an abnormal situation in picking up items, and update the sorting data table based on the determination result to obtain a picking up item data table;

[0040] 105. Obtain outbound scanning information, match the outbound scanning information with the pickup data table to determine whether there is an outbound abnormality, and update the pickup data table based on the determination result to obtain an outbound data table;

[0041] In this embodiment, by matching the pickup scanning information and the sorting data table, as well as the outbound scanning information and the pickup data table, abnormal situations in the pickup and outbound process, such as missed scanning, wrong scanning, etc., can be discovered in time; the data table is automatically updated based on the judgment results to ensure the accuracy of logistics information, which helps to reduce logistics delays and losses and provide a basis for subsequent processing.

[0042] The present application discloses a method for batch collection of orders, which obtains preprocessed real-time order data by acquiring real-time order data and performing preprocessing; extracts and processes the preprocessed real-time order data to obtain a delivery data table; updates the delivery data table based on the acquired, preset sorting area table and the delivery data to obtain a sorting data table; determines whether there is an abnormal collection situation based on the acquired collection scanning information and the sorting data table, and updates the sorting data table based on the determination result to obtain the collection data table; determines whether there is an abnormal delivery situation based on the acquired delivery scanning information and the collection data table, and updates the collection data table based on the determination result to obtain the delivery data table; the method disclosed in the present application can realize batch processing of order data in the sorting link, collection link and delivery link, effectively improves order processing efficiency, greatly reduces labor costs, and can avoid data loss problems caused by manual operations, providing sufficient data support for warehouse management and decision-making.

[0043] See also Figure 2 The second embodiment of the method for collecting orders in batches in the embodiment of the present invention includes:

[0044] 201. Acquire real-time order data including multiple real-time orders, where the real-time data of each real-time order includes order ID, order time, order source, product information, and user information, and store the acquired real-time order data in Redis;

[0045] 202. Perform data cleaning on the real-time order data to obtain cleaned real-time order data;

[0046] In this embodiment, by performing data cleaning processing on the real-time order data to remove or correct errors, duplications, missing values, etc. in the real-time order data, and identifying and filtering out abnormal values ​​or data that does not comply with business rules, the data quality can be effectively improved to provide a reliable basis for subsequent analysis.

[0047] 203. Convert the cleaned real-time order data to obtain standardized real-time order data;

[0048] In this embodiment, the cleaned real-time order data is converted into a standardized format or structure, such as a JSON object, and then the data is encoded, normalized or standardized to complete the conversion processing of the cleaned real-time order data; by performing the conversion processing, the consistency and comparability of the data can be improved, and the storage, retrieval and analysis of the data can be facilitated.

[0049] 204. Perform statistical processing on the standardized real-time order data to obtain pre-processed real-time order data;

[0050] In this embodiment, statistical processing of standardized real-time order data is completed by performing statistical operations such as classification and sorting on the standardized real-time order data; through statistical processing, the basic situation and trend of the real-time order data can be quickly understood, which is convenient for logistics management personnel to perform decision analysis and business adjustments.

[0051] See also Figure 3 The third embodiment of the method for collecting orders in batches in the embodiment of the present invention includes:

[0052] 301. According to the acquired and preset warehouse delivery keyword information, a hash algorithm is used to perform data extraction processing on the real-time order data to obtain real-time warehouse delivery data, wherein the real-time warehouse delivery data includes commodity information corresponding to each real-time order;

[0053] In this embodiment, a hash algorithm is used to traverse and compare the real-time order data, and data related to shipment is extracted from the real-time order data according to a preset shipment keyword information library. The hash algorithm is known for its efficient search and comparison speed, and can quickly extract shipment-related data from large-scale real-time order data, thereby improving data processing efficiency. It is combined with a preset shipment keyword information library for precise matching, thereby ensuring the accuracy of the extracted real-time shipment data and reducing the possibility of human intervention and errors.

[0054] 302. Calculate the total amount of goods according to the goods information corresponding to each real-time order, and generate a delivery number corresponding to each real-time order according to a preset delivery number generation rule;

[0055] In this embodiment, the total amount of goods in each order can be accurately calculated through the product information of the real-time order, avoiding possible errors in manual calculations, improving the accuracy of order processing, and providing data support when merchants create bills; further, according to the preset outbound number generation rules, a corresponding outbound number can be automatically generated for each real-time order, improving outbound efficiency and reducing the complexity and error rate of manual operations.

[0056] 303. Convert the real-time outbound data, the total amount of goods, and the outbound number into fields for table construction, and add indexes to the fields according to preset query rules to construct an outbound data table, wherein the outbound data table includes outbound information corresponding to each real-time order;

[0057] In this embodiment, by adding indexes to the fields used for table construction, the organization of outbound data is made more orderly and efficient, which helps to improve the query speed and accuracy of data, reduces query time, and improves work efficiency; by constructing an outbound data table, rapid verification and batch processing of data during the outbound process can be achieved, thereby improving outbound efficiency.

[0058] See also Figure 4 The fourth embodiment of the method for collecting orders in batches in the embodiment of the present invention includes:

[0059] 401. Obtain a preset sorting area table, wherein the sorting area table includes sorting area location information, sorting area number and sorting jurisdiction;

[0060] 402. Performing address standardization processing on the address information corresponding to each real-time order included in the outbound information to obtain standardized outbound information;

[0061] 403. Use regular expressions to match the outbound information after specification with the sorting jurisdiction in the preset sorting area table to assign a sorting area number to each real-time order;

[0062] In this embodiment, by matching the outbound information with the preset sorting area table through regular expressions, fast and accurate sorting area number matching can be achieved, which greatly improves the order processing efficiency; the powerful matching ability of regular expressions can handle various complex outbound information formats, ensuring that each order can be correctly assigned to the corresponding sorting area; when the parcel completes the scan for pending items, the matched sorting area number corresponding to the real-time order is displayed on the display device, and the operator can quickly sort the parcel according to the sorting area number, which greatly improves the sorting efficiency and sorting standardization.

[0063] 404. Convert the standardized outbound information and the sorting area number into fields for table construction, and add indexes to the fields according to the preset query construction to construct a sorting data table.

[0064] See also Figure 5 The fifth embodiment of the method for collecting orders in batches in the embodiment of the present invention includes:

[0065] 501. Using an address resolution algorithm, the address information corresponding to each real-time order included in the outbound information is analyzed and processed to obtain address composition information;

[0066] 502. According to the preset address specification standard, the address component information is formatted and recombined to obtain standard address information, and multiple standard address information and other information in the outbound information are integrated to obtain standardized outbound information;

[0067] In this embodiment, the address information in the outbound information is accurately parsed and formatted through the address resolution algorithm and the preset address specification standard, thereby avoiding outbound errors or delays caused by inaccurate or non-standard address information, and improving the accuracy and standardization of the outbound information; further, by automatically processing the address information in the outbound information, the workload of manual operation and verification is reduced, and the work efficiency and accuracy are improved.

[0068] 503. When an abnormality occurs in the parsing process and the formatting process, the real-time order with the abnormality is transferred to the pre-built abnormal order list;

[0069] In this embodiment, when the address information cannot be parsed or formatted, it indicates that there may be an abnormality in the address information, that is, the address may not exist or is incomplete. At this time, the real-time order with the abnormality needs to be transferred to the pre-built abnormal order list for manual verification of the abnormal order.

[0070] See also Figure 6 The sixth embodiment of the method for collecting orders in batches in the embodiment of the present invention includes:

[0071] 601. Obtaining scanning information of items to be picked up, where the scanning information of items to be picked up includes a scanning image of the items to be picked up and a scanning time of the items to be picked up;

[0072] 602. Perform text extraction processing on the scanned image of the item to be picked up using image recognition software to obtain the scanned text of the item to be picked up;

[0073] Image recognition software is a program that can automatically analyze image content and extract useful information. In this embodiment, the image recognition software is used to perform text extraction processing on the scanned image of the item to be collected, thereby generating the scanned text of the item to be collected; the extraction process involves multiple steps such as image preprocessing, feature extraction, and pattern recognition, aiming to accurately extract the required text information from the image.

[0074] 603. Use an exact matching algorithm to match the scanned text of the item to be picked up with the sorting data table to determine whether the order information included in the scanned text of the item to be picked up exists in the sorting data table;

[0075] In this embodiment, the exact matching algorithm is used to match the scanned text of the items to be picked up and the sorting data table; specifically, the exact matching algorithm will check the order information in the scanned text of the items to be picked up item by item, and compare it with the records in the sorting data table. Only when there is a completely identical record of the order information in the scanned text of the items to be picked up in the sorting data table, the exact matching algorithm will determine that the order information exists in the sorting data table.

[0076] 604. If it does not exist, the real-time order corresponding to the scanned information of the item to be picked up is transferred to the pre-built abnormal order list;

[0077] 605. If it exists, update the sorting data table based on the scanning time of the items to be picked up to obtain the item collection data table;

[0078] In this embodiment, the scanning time of the items to be picked up is allocated to the information position of the corresponding real-time order in the sorting data table to update the sorting data table.

[0079] In this embodiment, after completing the batch scanning of pending items of real-time order data, it is determined whether there is any real-time order in the collection data table that does not match the corresponding pending item scanning time. If so, the real-time order without pending item scanning time is transferred to the pre-built abnormal order list, so as to promptly discover and process abnormal orders that have not been scanned for pending items, which can shorten customer waiting time, improve customer satisfaction and loyalty, and win a good word-of-mouth and reputation for the company.

[0080] See also Figure 7 The seventh embodiment of the method for collecting orders in batches in the embodiment of the present invention includes:

[0081] 701. Obtain shipment scanning information, where the shipment scanning information includes a shipment scanning image and a shipment scanning time;

[0082] 702. Perform text extraction processing on the shipment scan image using image recognition software to obtain shipment scan text;

[0083] 703. Use an exact matching algorithm to match the shipment scan text and the pickup data table to determine whether the order information included in the shipment scan text exists in the pickup data table;

[0084] 704. If it does not exist, the real-time order corresponding to the shipment scanning information is transferred to the pre-built abnormal order list;

[0085] 705. If it exists, update the collection data table based on the shipment scanning time to obtain the shipment data table;

[0086] In this embodiment, the shipment scanning time is allocated to the information position of the corresponding real-time order in the collection data table to update the collection data table.

[0087] In this embodiment, after completing the batch outbound scanning of real-time order data, it is determined whether there is any real-time order in the shipping data table that does not match the corresponding shipping scanning time. If so, the real-time order without a shipping scanning time will be transferred to the pre-built abnormal order list, so as to promptly discover and process abnormal orders that have not been scanned for shipping, which can shorten customer waiting time, improve customer satisfaction and loyalty, and win a good reputation for the company.

[0088] The above describes the method for collecting orders in batches in the embodiment of the present invention. The following describes the device for collecting orders in batches in the embodiment of the present invention. Figure 8 In one embodiment of the present invention, an order batch collection device includes:

[0089] The processing module 801 is used to obtain real-time order data including multiple real-time orders, and pre-process the real-time order data to obtain pre-processed real-time order data; the extraction module 802 is used to perform data extraction processing on the pre-processed real-time order data to obtain a delivery data table, and the delivery data table includes delivery information corresponding to each real-time order; the first updating module 803 is used to obtain a preset sorting area table, and update the delivery data table based on the sorting area table and the delivery information corresponding to each real-time order to obtain a sorting data table; the second updating module 804 is used to obtain scanning information of items to be picked up, match the scanning information of the items to be picked up with the sorting data table to determine whether there is an abnormal situation of picking up items, and update the sorting data table based on the judgment result to obtain the item picking data table; the third updating module 805 is used to obtain delivery scanning information, match the delivery scanning information with the item picking data table to determine whether there is an abnormal situation of outgoing shipment, and update the item picking data table based on the judgment result to obtain the delivery data table.

[0090] In this embodiment, the processing module 801 includes: a first acquisition unit 8011, which is used to acquire real-time order data including multiple real-time orders, the real-time data of each real-time order includes order ID, order time, order source, product information and user information, and the acquired real-time order data is stored in Redis; a cleaning unit 8012, which is used to perform data cleaning processing on the real-time order data to obtain cleaned real-time order data; a conversion unit 8013, which is used to convert the cleaned real-time order data to obtain standardized real-time order data; a statistical unit 8014, which is used to perform statistical processing on the standardized real-time order data to obtain pre-processed real-time order data.

[0091] In this embodiment, the extraction module 802 includes: a first extraction unit 8021, which is used to perform data extraction processing on the real-time order data using a hash algorithm based on the acquired and preset outbound keyword information to obtain real-time outbound data, and the real-time outbound data includes the commodity information corresponding to each real-time order; a calculation unit 8022, which is used to calculate the total amount of commodities based on the commodity information corresponding to each real-time order, and generate an outbound number corresponding to each real-time order according to a preset outbound number generation rule; a first construction unit 8023, which is used to convert the real-time outbound data, the total amount of commodities and the outbound number into fields for table construction, and add indexes to the fields according to the preset query rules to construct an outbound data table, and the outbound data table includes the outbound information corresponding to each real-time order.

[0092] In this embodiment, the first update module 803 includes: a second acquisition unit 8031, which is used to acquire a preset sorting area table, wherein the sorting area table includes sorting area location information, sorting area number and sorting jurisdiction; a standardization unit 8032, which is used to perform address standardization processing on the address information included in the outbound information and corresponding to each real-time order to obtain standardized outbound information; a first matching unit 8033, which is used to match the standardized outbound information with the sorting jurisdiction in the preset sorting area table using a regular expression to assign a sorting area number to each real-time order; and a second construction unit 8034, which is used to convert the standardized outbound information and the sorting area number into fields for table construction, and add indexes to the fields according to the preset query construction to construct a sorting data table.

[0093] In this embodiment, the standardization unit 8032 includes: a parsing unit 80321, which is used to use an address parsing algorithm to parse the address information included in the outbound information and corresponding to each real-time order to obtain address composition information; a combining unit 80322, which is used to format and recombine the address composition information according to a preset address specification standard to obtain standard address information, integrate multiple standard address information and other information in the outbound information to obtain standardized outbound information; a transferring unit 80323, which is used to transfer the real-time order with the abnormal situation to a pre-built abnormal order list when an abnormal situation occurs in the parsing process and the formatting process.

[0094] In this embodiment, the second update module 804 includes: a third acquisition unit 8041, which is used to acquire the scan information of the items to be picked up, and the scan information of the items to be picked up includes the scan image of the items to be picked up and the scan time of the items to be picked up; a second extraction unit 8042, which is used to perform text extraction processing on the scan image of the items to be picked up using image recognition software to obtain the scan text of the items to be picked up; a second matching unit 8043, which is used to match the scan text of the items to be picked up with the sorting data table using an exact matching algorithm to determine whether the order information included in the scan text of the items to be picked up exists in the sorting data table; a first transfer unit 8044, which is used to transfer the real-time order corresponding to the scan information of the items to be picked up to the pre-built abnormal order list if it does not exist; and a first update unit 8045, which is used to update the sorting data table based on the scan time of the items to be picked up if it exists to obtain the collection data table.

[0095] In this embodiment, the third update module 805 includes: a fourth acquisition unit 8051, which is used to acquire the shipment scan information, and the shipment scan information includes the shipment scan image and the shipment scan time; a third extraction unit 8052, which is used to use image recognition software to perform text extraction processing on the shipment scan image to obtain the shipment scan text; a third matching unit 8053, which is used to match the shipment scan text and the collection data table using an exact matching algorithm to determine whether the order information included in the shipment scan text exists in the collection data table; a second transfer unit 8054, which is used to transfer the real-time order corresponding to the shipment scan information to the pre-built abnormal order list if it does not exist; a second update unit 8055, which is used to update the collection data table based on the shipment scan time if it exists to obtain the outbound data table.

[0096] Based on the same idea as the method in the above embodiment, the device provided by the present application can implement the method in the above embodiment.

[0097] above Figure 8 The order batch collection device in the embodiment of the present invention is described in detail from the perspective of modular functional entities. The order batch collection device in the embodiment of the present invention is described in detail from the perspective of hardware processing.

[0098] Fig. 9 is a schematic diagram of the structure of a batch order collection device provided by an embodiment of the present invention. The batch order collection device 900 may have relatively large differences due to different configurations or performances, and may include one or more processors (central processing units, CPU) 910 (for example, one or more processors) and a memory 920, and one or more storage media 930 (for example, one or more mass storage devices) storing application programs 933 or data 932. Among them, the memory 920 and the storage medium 930 can be short-term storage or permanent storage. The program stored in the storage medium 930 may include one or more modules (not shown in the figure), and each module may include a series of instruction operations in the batch order collection device 900. Furthermore, the processor 910 can be configured to communicate with the storage medium 930, and execute a series of instruction operations in the storage medium 930 on the batch order collection device 900 to implement the steps of the batch order collection method provided in the above-mentioned method embodiments.

[0099] The order batch collection device 900 may also include one or more power supplies 940, one or more wired or wireless network interfaces 950, one or more input and output interfaces 960, and / or one or more operating systems 931, such as Windows Server, Mac OS X, Unix, Linux, FreeBSD, etc. It will be appreciated by those skilled in the art that Fig. 9 The structure of the order batch collection equipment shown does not constitute a limitation of the order batch collection equipment, and may include more or fewer components than shown in the figure, or a combination of certain components, or a different arrangement of components.

[0100] The present invention also provides a computer-readable storage medium, which may be a non-volatile computer-readable storage medium or a volatile computer-readable storage medium. Instructions are stored in the computer-readable storage medium. When the instructions are executed on a computer, the computer executes the steps of the method for batch collecting orders.

[0101] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working process of the above-described system, device, or unit can refer to the corresponding process in the aforementioned method embodiment and will not be repeated here.

[0102] If the integrated unit is implemented in the form of 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 the present invention is essentially 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. The computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM), random access memory (RAM), disk or optical disk and other media that can store program codes.

[0103] Finally, it should be noted that the above description is only a preferred example of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art can still modify the technical solutions described in the aforementioned embodiments or replace some of the technical features therein by equivalents. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A method for collecting orders in batches, characterized in that: include: Acquire real-time order data including a plurality of real-time orders, and pre-process the real-time order data to obtain pre-processed real-time order data; Performing data extraction processing on the pre-processed real-time order data to obtain a delivery data table, wherein the delivery data table includes delivery information corresponding to each real-time order; Obtaining a preset sorting area table, and updating the outbound data table based on the sorting area table and outbound information corresponding to each real-time order to obtain a sorting data table; Obtaining scanning information of items to be picked up, matching the scanning information of items to be picked up with the sorting data table to determine whether there is an abnormal situation in picking up items, and updating the sorting data table based on the determination result to obtain a picking up item data table; Obtain outbound scanning information, match the outbound scanning information with the collection data table to determine whether there is an outbound abnormality, and update the collection data table based on the determination result to obtain the outbound data table.

2. The method for collecting orders in batches according to claim 1, characterized in that: The acquiring of real-time order data including a plurality of real-time orders and preprocessing the real-time order data to obtain preprocessed real-time order data includes: Acquire real-time order data including multiple real-time orders, where the real-time data of each real-time order includes order ID, order time, order source, product information and user information, and store the acquired real-time order data in Redis; Perform data cleaning on the real-time order data to obtain cleaned real-time order data; The cleaned real-time order data is converted and processed to obtain standardized real-time order data; The standardized real-time order data is statistically processed to obtain preprocessed real-time order data.

3. The method for collecting orders in batches according to claim 1, characterized in that: The pre-processed real-time order data is subjected to data extraction processing to obtain a delivery data table, wherein the delivery data table includes delivery information corresponding to each real-time order, including: According to the acquired and preset outbound keyword information, a hash algorithm is used to extract and process the real-time order data to obtain real-time outbound data, wherein the real-time outbound data includes commodity information corresponding to each real-time order; Calculate the total amount of goods according to the goods information corresponding to each real-time order, and generate a delivery number corresponding to each real-time order according to a preset delivery number generation rule; The real-time outbound data, the total amount of goods and the outbound number are converted into fields for table construction, and indexes are added to the fields according to preset query rules to construct an outbound data table, which includes outbound information corresponding to each real-time order.

4. The method for collecting orders in batches according to claim 1, characterized in that: The obtaining of a preset sorting area table, and updating the outbound data table based on the sorting area table and outbound information corresponding to each real-time order to obtain the sorting data table, includes: Obtaining a preset sorting area table, wherein the sorting area table includes sorting area location information, sorting area number and sorting jurisdiction; Performing address standardization processing on the address information corresponding to each real-time order included in the outbound information to obtain standardized outbound information; Regular expressions are used to match the outbound information after specification with the sorting jurisdiction in the preset sorting area table to assign a sorting area number to each real-time order; The standardized outbound information and the sorting area number are converted into fields for table construction, and indexes are added to the fields according to the preset query construction to construct a sorting data table.

5. The method for collecting orders in batches according to claim 4, characterized in that: The address information included in the delivery information and corresponding to each real-time order is subjected to address standardization processing to obtain standardized delivery information, including: Using the address resolution algorithm, the address information corresponding to each real-time order included in the outbound information is analyzed and processed to obtain the address composition information; According to the preset address specification standard, the address component information is formatted and recombined to obtain standard address information, and multiple standard address information and other information in the outbound information are integrated to obtain standardized outbound information; When an exception occurs in the parsing process and the formatting process, the real-time order with the exception is transferred to a pre-built exception order list.

6. The method for collecting orders in batches according to claim 1, characterized in that: The acquiring of the scanned information of the items to be picked up, matching the scanned information of the items to be picked up with the sorting data table to determine whether there is an abnormal situation in picking up items, and updating the sorting data table based on the determination result to obtain the picking up item data table includes: Obtaining scanning information of items to be picked up, wherein the scanning information of items to be picked up includes a scanning image of the items to be picked up and a scanning time of the items to be picked up; Using image recognition software to perform text extraction processing on the scanned image of the item to be picked up to obtain the scanned text of the item to be picked up; Using an exact matching algorithm to match the scanned text of the item to be picked up and the sorting data table to determine whether the order information included in the scanned text of the item to be picked up exists in the sorting data table; If it does not exist, the real-time order corresponding to the scanned information of the item to be picked up will be transferred to the pre-built abnormal order list; If it exists, the sorting data table is updated based on the scanning time of the items to be picked up to obtain the item collection data table.

7. The method for collecting orders in batches according to claim 1, characterized in that: The obtaining of the outbound scanning information, matching the outbound scanning information with the pickup data table to determine whether there is an outbound abnormality, and updating the pickup data table based on the determination result to obtain the outbound data table includes: Acquire shipment scanning information, wherein the shipment scanning information includes a shipment scanning image and a shipment scanning time; Using image recognition software to perform text extraction processing on the shipment scan image to obtain the shipment scan text; Using an exact matching algorithm to match the shipment scan text and the collection data table to determine whether the order information included in the shipment scan text exists in the collection data table; If it does not exist, the real-time order corresponding to the shipment scanning information is transferred to the pre-built abnormal order list; If it exists, the collection data table is updated based on the shipment scanning time to obtain the shipment data table.

8. A device for collecting batch orders, characterized in that: include: A processing module, used for acquiring real-time order data including a plurality of real-time orders, and preprocessing the real-time order data to obtain preprocessed real-time order data; An extraction module is used to perform data extraction processing on the pre-processed real-time order data to obtain a delivery data table, wherein the delivery data table includes delivery information corresponding to each real-time order; A first updating module is used to obtain a preset sorting area table, and update the outbound data table based on the sorting area table and outbound information corresponding to each real-time order to obtain a sorting data table; The second updating module is used to obtain the scanning information of the items to be picked up, match the scanning information of the items to be picked up with the sorting data table to determine whether there is an abnormal situation of picking up items, and update the sorting data table based on the determination result to obtain the picking up data table; The third updating module is used to obtain the outbound scanning information, match the outbound scanning information with the collection data table to determine whether there is an outbound abnormality, and update the collection data table based on the determination result to obtain the outbound data table.

9. A device for collecting batch orders, characterized in that: The order batch collection device comprises: a memory and at least one processor, wherein instructions are stored in the memory; At least one of the processors calls the instructions in the memory so that the batch order collection device executes each step of the batch order collection method as described in any one of claims 1-7.

10. A computer-readable storage medium having instructions stored thereon, characterized in that: When the instructions are executed by the processor, the various steps of the method for batch collecting orders as described in any one of claims 1 to 7 are implemented.

Images