Warehouse data processing method and device, storage medium and electronic equipment

Abstract

The present disclosure provides a warehouse data processing method and device, a storage medium and an electronic device, and relates to the technical field of computers. The method comprises: generating a serial number detection rule and a timing detection task of an article according to detection parameter information of the article in a warehouse; executing the timing detection task to perform traversal query in a warehouse article management database at regular intervals to obtain an entry serial number of a to-be-detected article satisfying the serial number detection rule; checking the entry serial number to obtain an abnormal serial number and generating a serial number change task corresponding to the abnormal serial number; executing the serial number change task to obtain a target serial number and updating the abnormal serial number in the warehouse article management database by using the target serial number. The method can actively detect the serial number of the article in the warehouse, query the abnormal serial number, and then change the abnormal serial number through the serial number change task, thereby reducing the labor cost, avoiding the delivery of the article with the abnormal serial number, and reducing the article complaint rate.

Description

Technical Field

[0001] This disclosure relates to the field of computer technology, and in particular to a warehouse data processing method, a warehouse data processing apparatus, a computer-readable storage medium, and an electronic device. Background Technology

[0002] In warehouse production systems, serial number scanning errors frequently occur. When goods are received, item codes, barcodes, or storage location codes are mistakenly entered as serial numbers. Warehouse staff only discover the incorrect serial numbers during outbound verification or picking, requiring manual correction and increasing labor costs. Furthermore, if goods have already left the warehouse, traceability is impossible, increasing the complaint rate.

[0003] It should be noted that the information disclosed in the background section above is only used to enhance the understanding of the background of this disclosure, and therefore may include information that does not constitute prior art known to those skilled in the art. Summary of the Invention

[0004] The purpose of this disclosure is to provide a warehouse data processing method, a warehouse data processing device, a computer-readable storage medium, and an electronic device that can proactively detect the serial numbers of items in the warehouse, query abnormal serial numbers, and then change the abnormal serial numbers through a serial number change task, thereby reducing labor costs, preventing items with abnormal serial numbers from leaving the warehouse, and reducing the item complaint rate.

[0005] Other features and advantages of this disclosure will become apparent from the following detailed description, or may be learned in part from practice of this disclosure.

[0006] According to one aspect of this disclosure, a warehouse data processing method is provided, comprising: acquiring detection parameter information of items in a warehouse; generating a serial number detection rule for the items and a timed detection task corresponding to the serial number detection rule based on the detection parameter information; executing the timed detection task to periodically traverse and query a warehouse item management database to obtain the entry serial number of the item to be detected that satisfies the serial number detection rule; verifying the entry serial number of the item to be detected to obtain an abnormal serial number in the entry serial number, and generating a serial number change task corresponding to the abnormal serial number; executing the serial number change task to obtain a target serial number corresponding to the abnormal serial number, and updating the abnormal serial number in the warehouse item management database using the target serial number.

[0007] In an optional embodiment of this disclosure, the serial number detection rule includes the detection parameter information, and the timed detection task includes the running cycle of the serial number detection rule; wherein, executing the timed detection task, which involves periodically traversing and querying the warehouse item management database to obtain the entry serial number of the item to be detected that satisfies the serial number detection rule, includes: periodically traversing and querying the warehouse item management database according to the running cycle of the serial number detection rule, determining the item to be detected that satisfies the detection parameter information, and obtaining the entry serial number of the item to be detected.

[0008] In an optional embodiment of this disclosure, the detection parameter information includes one or more of the following options: supplier information corresponding to the item, item grade information, item classification information, item code information, item storage location information, and item warehousing time information.

[0009] In an optional embodiment of this disclosure, the step of verifying the warehousing serial number of the item to be inspected to obtain an abnormal serial number in the warehousing serial number includes: obtaining the serial number verification rule corresponding to the item to be inspected; verifying the warehousing serial number using the serial number verification rule corresponding to the item to be inspected; and determining that the warehousing serial number is an abnormal serial number if the verification fails.

[0010] In an optional embodiment of this disclosure, obtaining the serial number verification rule corresponding to the item to be detected includes: obtaining the serial number verification rule corresponding to the item to be detected from the warehouse item management system, or generating the serial number verification rule corresponding to the item to be detected; wherein, the serial number verification rule corresponding to the item to be detected includes one or more of the following options: verifying the length information of the serial number, verifying the character type information contained in the serial number, verifying the prefix information of the serial number, verifying the suffix information of the serial number, and verifying the characteristic character information of the serial number.

[0011] In an optional embodiment of this disclosure, the step of executing the serial number change task, obtaining the target serial number corresponding to the abnormal serial number, and updating the abnormal serial number in the warehouse item management database using the target serial number includes: executing the serial number change task, determining the abnormal item corresponding to the abnormal serial number; verifying whether the inbound serial number corresponding to the abnormal item in the warehouse item management database is incorrect; if so, obtaining the target serial number corresponding to the abnormal item, and changing the inbound serial number corresponding to the abnormal item in the warehouse item management database using the obtained target serial number.

[0012] In an optional embodiment of this disclosure, the number of the inbound serial numbers is one or more; wherein, the method further includes: performing a duplicate check on one or more inbound serial numbers to obtain duplicate serial numbers among the one or more inbound serial numbers; determining the duplicate item corresponding to the duplicate serial number; verifying whether the inbound serial number corresponding to the duplicate item in the warehouse item management database is incorrect; if so, obtaining the correct serial number corresponding to the duplicate item, and using the obtained correct serial number to change the inbound serial number corresponding to the duplicate item in the warehouse item management database.

[0013] According to another aspect of this disclosure, a warehouse data processing apparatus is provided, comprising: a detection rule and task generation module, configured to acquire detection parameter information of items in a warehouse, and generate a serial number detection rule for the items and a timed detection task corresponding to the serial number detection rule based on the detection parameter information; an inbound serial number acquisition module, configured to execute the timed detection task, periodically traversing and querying a warehouse item management database to obtain the inbound serial number of the item to be detected that satisfies the serial number detection rule; an inbound serial number verification module, configured to verify the inbound serial number of the item to be detected, obtain abnormal serial numbers in the inbound serial number, and generate a serial number change task corresponding to the abnormal serial number; and an inbound serial number change module, configured to execute the serial number change task, obtain a target serial number corresponding to the abnormal serial number, and update the abnormal serial number in the warehouse item management database using the target serial number.

[0014] In an optional embodiment of this disclosure, the serial number detection rule includes the detection parameter information, and the timed detection task includes the running cycle of the serial number detection rule; wherein, the warehousing serial number acquisition module is further configured to: periodically traverse and query the warehouse item management database according to the running cycle of the serial number detection rule, determine the item to be detected that meets the detection parameter information, and obtain the warehousing serial number of the item to be detected.

[0015] In an optional embodiment of this disclosure, the detection parameter information includes one or more of the following options: supplier information corresponding to the item, item grade information, item classification information, item code information, item storage location information, and item warehousing time information.

[0016] In an optional embodiment of this disclosure, the warehousing serial number verification module is further configured to: obtain the serial number verification rule corresponding to the item to be inspected; verify the warehousing serial number using the serial number verification rule corresponding to the item to be inspected; and determine that the warehousing serial number is an abnormal serial number if the verification fails.

[0017] In an optional embodiment of this disclosure, the inbound serial number verification module is further configured to: obtain the serial number verification rule corresponding to the item to be inspected from the warehouse item management system, or generate the serial number verification rule corresponding to the item to be inspected; wherein, the serial number verification rule corresponding to the item to be inspected includes one or more of the following options: verification serial number length information, verification serial number character type information, verification serial number prefix information, verification serial number suffix information, and verification serial number feature character information.

[0018] In an optional embodiment of this disclosure, the inbound serial number change module is further configured to: execute the serial number change task, determine the serial number abnormal item corresponding to the abnormal serial number; verify whether the inbound serial number corresponding to the serial number abnormal item in the warehouse item management database is incorrect; if so, obtain the target serial number corresponding to the serial number abnormal item, and use the obtained target serial number to change the inbound serial number corresponding to the serial number abnormal item in the warehouse item management database.

[0019] In an optional embodiment of this disclosure, the number of the inbound serial numbers is one or more; wherein, the device further includes an inbound serial number deduplication module, used for: performing deduplication on one or more of the inbound serial numbers to obtain duplicate serial numbers among the one or more inbound serial numbers; determining the duplicate item corresponding to the duplicate serial number; verifying whether the inbound serial number corresponding to the duplicate item in the warehouse item management database is incorrect; if so, obtaining the correct serial number corresponding to the duplicate item, and using the obtained correct serial number to change the inbound serial number corresponding to the duplicate item in the warehouse item management database.

[0020] According to another aspect of this disclosure, a computer-readable storage medium is provided having a computer program stored thereon, which, when executed by a processor, implements the above-described warehouse data processing method.

[0021] According to another aspect of this disclosure, an electronic device is provided, comprising: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to perform the above-described warehouse data processing method by executing the executable instructions.

[0022] The warehouse data processing method of this disclosure, after obtaining the detection parameter information of items in the warehouse, generates serial number detection rules and timed detection tasks based on the detection parameter information, and then executes the timed detection tasks. The serial number detection rules are used to periodically query the warehouse item management database to obtain the inbound serial numbers of the items to be detected that meet the serial number detection rules. These inbound serial numbers are then verified to identify abnormal serial numbers. An abnormal serial number change task is then initiated to change the abnormal serial number to the target serial number (i.e., the correct serial number). On the one hand, the method proactively detects inbound serial numbers in the warehouse management database through timed detection tasks and serial number detection rules, identifying abnormal serial numbers. This solves the problem of discovering incorrect serial numbers manually during item outbound verification or item picking, reducing labor costs and enabling timely detection of abnormal serial numbers. On the other hand, proactively initiating an abnormal serial number change task after obtaining it to change the abnormal serial number to the correct serial number reduces the serial number error rate in the database, lowers the probability of items with incorrect serial numbers leaving the warehouse, and thus reduces the item complaint rate.

[0023] It should be understood that the above general description and the following detailed description are exemplary and explanatory only, and are not intended to limit this disclosure. Attached Figure Description

[0024] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this disclosure and, together with the description, serve to explain the principles of this disclosure. It is obvious that the drawings described below are merely some embodiments of this disclosure, and those skilled in the art can obtain other drawings based on these drawings without any inventive effort.

[0025] Figure 1 This is a schematic diagram of the system architecture of a warehouse data processing method according to an exemplary embodiment;

[0026] Figure 2 This is a flowchart illustrating a warehouse data processing method according to an exemplary embodiment;

[0027] Figure 3 This is a flowchart illustrating the process of obtaining an anomaly sequence number according to an exemplary embodiment;

[0028] Figure 4 This is a flowchart illustrating the serial number change of an abnormal serial number according to an exemplary embodiment;

[0029] Figure 5 This is a flowchart illustrating a deduplication process for one or more inbound serial numbers according to an exemplary embodiment.

[0030] Figure 6 This is a flowchart illustrating a warehouse data processing method according to yet another exemplary embodiment;

[0031] Figure 7 This is a block diagram illustrating a warehouse data processing apparatus according to an exemplary embodiment; and

[0032] Figure 8 This is a structural block diagram of an electronic device according to an exemplary embodiment. Detailed Implementation

[0033] To enable those skilled in the art to better understand the technical solutions of this disclosure, the technical solutions in the embodiments of this disclosure will be clearly and completely described below with reference to the accompanying drawings.

[0034] It should be noted that the terms "first," "second," etc., used in the specification, claims, and accompanying drawings of this disclosure are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of this disclosure described herein can be implemented in orders other than those illustrated or described herein.

[0035] The following exemplary embodiments can be implemented in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided to make this disclosure more comprehensive and complete, and to fully convey the concept of the exemplary embodiments to those skilled in the art. The described features, structures, or characteristics can be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided to give a full understanding of embodiments of this disclosure. However, those skilled in the art will recognize that the technical solutions of this disclosure can be practiced with one or more of the specific details omitted, or other methods, components, apparatus, steps, etc., can be employed. In other instances, well-known technical solutions are not shown or described in detail to avoid obscuring various aspects of this disclosure.

[0036] Furthermore, the accompanying drawings are merely illustrative of this disclosure and are not necessarily drawn to scale. The same reference numerals in the drawings denote the same or similar parts, and therefore repeated descriptions of them will be omitted. Some block diagrams shown in the drawings are functional entities and do not necessarily correspond to physically or logically independent entities. These functional entities may be implemented in software, in one or more hardware modules or integrated circuits, or in different network and / or processor devices and / or microcontroller devices.

[0037] It should be noted that the collection, gathering, updating, analysis, processing, use, transmission, and storage of user personal information involved in this disclosed technical solution all comply with relevant laws and regulations, are used for legitimate purposes, and do not violate public order and good morals. Necessary measures are taken to prevent unauthorized access to user personal information data and to safeguard user personal information security, network security, and national security.

[0038] Figure 1 This is a schematic diagram of a system architecture for a warehouse data processing method according to an exemplary embodiment. The system architecture includes a server 101, a network 102, and a client 103. The network 102 serves as a medium for providing a communication link between the client 103 and the server 101. The network 102 may include various connection types, such as wired or wireless communication links or fiber optic cables, etc.

[0039] Server 101 can be a standalone physical server, a server cluster or distributed system composed of multiple physical servers, or a cloud server providing basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDN (Content Delivery Network), and big data and artificial intelligence platforms. In some practical applications, server 101 can also be a server for a network platform, such as a trading platform, live streaming platform, social platform, or music platform, etc., which is not limited in this embodiment. The server can be a single server or a cluster of multiple servers, and the specific architecture of the server is not limited in this disclosure.

[0040] Client 103 may be, but is not limited to, electronic devices such as smartphones, desktop computers, tablets, laptops, smart speakers, digital assistants, AR (Augmented Reality) devices, VR (Virtual Reality) devices, and smart wearable devices. Alternatively, client 103 may also be a personal computer, such as a laptop or desktop computer. Optionally, the operating system running on the electronic device may include, but is not limited to, Android, iOS, Linux, and Windows.

[0041] In this embodiment of the disclosure, server 101 can: obtain detection parameter information of items in the warehouse; generate serial number detection rules for items and corresponding timed detection tasks based on the detection parameter information; execute the timed detection tasks, periodically traversing and querying the warehouse item management database to obtain the entry serial numbers of the items to be detected that meet the serial number detection rules; verify the entry serial numbers to obtain abnormal serial numbers in the entry serial numbers, and generate serial number change tasks corresponding to the abnormal serial numbers; execute the serial number change tasks to obtain the target serial number corresponding to the abnormal serial numbers, and update the abnormal serial numbers in the warehouse item management database using the target serial number.

[0042] It should be understood that Figure 1 The number of servers 101, networks 102, and clients 103 shown is merely illustrative; any number of terminal devices, networks, and servers can be included as needed.

[0043] To enable those skilled in the art to better understand the technical solutions of this disclosure, the technical solutions for text viewpoint recognition of the embodiments of this disclosure will be described in more detail below with reference to the accompanying drawings and examples.

[0044] Figure 2 This is a flowchart illustrating a warehouse data processing method according to an exemplary embodiment. See also... Figure 2 This method is applied to Figure 1 The server shown includes the following steps.

[0045] Step S210: Obtain the detection parameter information of the items in the warehouse, and generate the serial number detection rules of the items and the corresponding timed detection tasks based on the detection parameter information.

[0046] In this context, "items in the warehouse" can be understood as items stored in the warehouse, i.e., items that have entered the warehouse. In this embodiment of the disclosure, the detection parameter information may include one or more of the following options: supplier information corresponding to the item, item grade information, item classification information, item code information, item storage location information, and item entry time information.

[0047] The supplier information for an item can be understood as the owner of the item, such as a manufacturer supplying item A. Item grade information can include quality grade, meaning the item is graded according to its quality. For example, if the item is a fruit, items weighing over 500 grams are classified as Grade 1, items weighing between 300 and 500 grams are classified as Grade 2, and items weighing less than 300 grams are classified as Grade 3. Of course, item grade information can also include material grade, application range grade, or other grade information; this embodiment does not limit this.

[0048] Item classification information refers to the category to which an item belongs, such as mobile phones belonging to the category of electronic products and refrigerators belonging to the category of home appliances. Item coding information can refer to item information identification codes, specifically including item classification codes, item base name codes, and item attribute codes. Of course, item coding information can also be item batch codes or other coding information, which is not limited in this embodiment.

[0049] Item storage location information refers to the location of items in the warehouse, while item entry time information refers to the specific time the items were entered into the warehouse. It should be noted that the detection parameter information may also include other information, such as the item's most recent verification time and information about any activities the item participated in.

[0050] In this step, detection parameter information for items in the warehouse can be obtained according to actual needs. Then, a serial number detection rule and a corresponding scheduled detection task can be generated based on this information. For example, if the goal is to detect the serial numbers of items from a specific supplier P in the warehouse, the detection parameter information is supplier P. A serial number detection rule corresponding to supplier P is then generated. This rule allows the acquisition of the serial numbers of all items corresponding to supplier P in the warehouse. The scheduled detection task corresponding to this rule can include its execution cycle, such as once a day, meaning the rule is executed once daily.

[0051] Step S220: Execute a scheduled detection task, periodically traverse and query the warehouse item management database to obtain the entry serial number of the item to be detected that meets the serial number detection rules.

[0052] The warehouse inventory management database is used to store inventory information in the warehouse, such as supplier information, inventory grade information, inventory classification information, inventory code information, inventory storage location information, inventory entry serial number, and inventory entry time information.

[0053] In this step, a scheduled detection task is used to periodically traverse and query the warehouse item management database to find items that meet the serial number detection rules, i.e., the items to be detected, and obtain the entry serial number of the items to be detected, which is the serial number entered when the items to be detected are put into the warehouse.

[0054] In this embodiment, the serial number detection rule includes detection parameter information, and the timed detection task includes the execution cycle of the serial number detection rule. Specifically, the execution cycle of the detection rule can be set according to actual needs, or the detection parameter information can include the execution cycle of the detection rule. For example, it can be set to detect once a day, once every 3 days, or once every hour. If it is set to detect once every hour, then the time for executing the serial number detection rule is 00:00, 01:00, 02:00...23:00.

[0055] Furthermore, a scheduled detection task is performed, which involves periodically traversing and querying the warehouse item management database to obtain the entry serial number of the item to be detected that meets the serial number detection rules. This can include: according to the running cycle of the serial number detection rules, periodically traversing and querying the warehouse item management database to determine the item to be detected that meets the detection parameter information and obtaining the entry serial number of the item to be detected.

[0056] The warehouse inventory management database stores the item's entry serial number. For example, when an item is received, it is scanned to obtain its serial number, which is then stored in the warehouse inventory management database.

[0057] In this embodiment, the serial number detection rule is generated based on detection parameter information, which can be understood as information about the items that need to be detected by serial number. The system iterates through the warehouse item management database according to the serial number detection rule's operating cycle, queries for items that meet the detection rule (i.e., items to be detected), and obtains the inbound serial number of these items. Items that meet the detection rule are the items to be detected, meaning they conform to the detection parameter information. For example, if the detection parameter information is a specified item code, a serial number detection rule corresponding to that specified item code is generated. This serial number detection rule allows the system to query the items in the warehouse corresponding to the specified item code (i.e., the items to be detected) and obtain their inbound serial numbers.

[0058] Step S230: Verify the entry serial number of the item to be inspected, obtain the abnormal serial number in the entry serial number, and generate the serial number change task corresponding to the abnormal serial number.

[0059] The number of items to be inspected is one or more, meaning the number of inbound serial numbers obtained is one or more. In this step, each inbound serial number is verified. If the verification fails, the inbound serial number is determined to be an abnormal serial number. After verifying each inbound serial number, the abnormal serial numbers among all inbound serial numbers can be obtained, and then the corresponding serial number transformation task is generated.

[0060] Step S240: Execute the serial number change task, obtain the target serial number corresponding to the abnormal serial number, and use the target serial number to update the abnormal serial number in the warehouse item management database.

[0061] In this step, the serial number change task is executed. The item corresponding to the abnormal serial number is queried, the target serial number (i.e., the correct serial number) is obtained, and the abnormal serial number stored in the warehouse item management database is replaced with the target serial number to complete the change. Specifically, after finding the item corresponding to the abnormal serial number, its storage location in the warehouse can be found. The item is then retrieved according to its storage location, and scanned to obtain the target serial number. Alternatively, the target serial number can be obtained manually.

[0062] The warehouse data processing method of this disclosure, after obtaining the detection parameter information of items in the warehouse, generates serial number detection rules and timed detection tasks based on the detection parameter information, and then executes the timed detection tasks. The serial number detection rules are used to periodically query the warehouse item management database to obtain the inbound serial numbers of the items to be detected that meet the serial number detection rules. These inbound serial numbers are then verified to identify abnormal serial numbers. An abnormal serial number change task is then initiated to change the abnormal serial number to the target serial number (i.e., the correct serial number). On the one hand, the method proactively detects inbound serial numbers in the warehouse management database through timed detection tasks and serial number detection rules, identifying abnormal serial numbers. This solves the problem of discovering incorrect serial numbers manually during item outbound verification or item picking, reducing labor costs and enabling timely detection of abnormal serial numbers. On the other hand, proactively initiating an abnormal serial number change task after obtaining it to change the abnormal serial number to the correct serial number reduces the serial number error rate in the database, lowers the probability of items with incorrect serial numbers leaving the warehouse, and thus reduces the item complaint rate.

[0063] Figure 3 This is a flowchart illustrating the process of obtaining an abnormal serial number according to an exemplary embodiment. As explained above, the number of inbound serial numbers is one or more. Figure 3 In the process of obtaining abnormal serial numbers shown in the embodiment, taking an inbound serial number as an example, it is explained that the inbound serial number is determined as to whether it is an abnormal serial number. In this embodiment of the disclosure, each inbound serial number is judged to obtain one or more abnormal serial numbers among the inbound serial numbers.

[0064] exist Figure 3 In the embodiments, the above Figure 2 In the embodiment, step S230, which verifies the warehousing serial number of the item to be tested and obtains the abnormal serial number in the warehousing serial number, may further include the following steps.

[0065] In step S231, the serial number verification rule corresponding to the item to be detected is obtained.

[0066] Serial number verification rules refer to the rules used to verify whether the serial number of an item is abnormal. Furthermore, obtaining the serial number verification rules for the item to be checked can include: obtaining the serial number verification rules for the item to be checked from the warehouse item management system, or generating the serial number verification rules for the item to be checked.

[0067] Different items may have different serial number verification rules. Specifically, items with the same supplier information have the same serial number verification rules, items with the same coding information have the same serial number verification rules, and items with the same category have the same serial number verification rules. In other words, serial number verification rules correspond to serial number detection rules; one or more inbound serial numbers obtained through the same serial number detection rule will have the same serial number verification rule. When generating a serial number detection rule, a corresponding serial number verification rule can also be generated.

[0068] The method for obtaining serial number verification rules in this embodiment may include: the warehouse item management system issuing serial number verification rules for each item; obtaining the serial number verification rules for the item to be tested from the verification rules issued by the warehouse item management system; and generating the serial number verification rules for the item to be tested.

[0069] The serial number verification rules for the items to be tested include one or more of the following options: verifying the length information of the serial number, verifying the character type information contained in the serial number, verifying the prefix information of the serial number, verifying the suffix information of the serial number, and verifying the characteristic character information of the serial number.

[0070] Verifying the serial number length information means verifying whether the length of the serial number of the item to be tested is within a preset length range, where the preset length range refers to the correct serial number length of the item to be tested. Verifying the character type information contained in the serial number means verifying whether the character type contained in the serial number of the item to be tested is a preset character type, where the preset character type refers to the character type contained in the correct serial number of the item to be tested.

[0071] Verifying the serial number prefix information means checking whether the prefix of the serial number of the item to be tested meets the preset prefix conditions, where the preset prefix conditions refer to the information contained in the correct serial number prefix of the item to be tested. Verifying the serial number suffix information means checking whether the suffix of the serial number of the item to be tested meets the preset suffix conditions, where the preset suffix conditions refer to the information contained in the correct serial number suffix of the item to be tested. Verifying the serial number characteristic character information means checking whether the serial number of the item to be tested contains specified characters, where the specified characters are the characters that the correct serial number of the item to be tested must contain.

[0072] In step S232, the serial number of the item to be inspected is verified using the serial number verification rules.

[0073] In step S233, if the verification fails, the entry serial number is determined to be an abnormal serial number.

[0074] After obtaining the serial number verification rules for the item to be inspected, the incoming serial number is verified using these rules. If the verification fails, meaning the incoming serial number does not meet the serial number verification rules for the item to be inspected, then the incoming serial number is considered an abnormal serial number.

[0075] For example, given the inbound serial number SN00000001, we determine the item to be inspected corresponding to this serial number and obtain the serial number verification rule S for that item. Serial number verification rule S includes four rule items: Rule 1, verifying if the serial number length is 10; Rule 2, verifying if the serial number prefix is ​​"SN"; Rule 3, verifying if the serial number suffix is ​​"A"; and Rule 4, verifying if the serial number character category only includes numbers and letters. The four rule items in serial number verification rule S verify the inbound serial number SN00000001. If the suffix of SN00000001 is not "A," meaning SN00000001 does not meet rule 3, then the verification of SN00000001 fails, and SN00000001 is considered an abnormal serial number.

[0076] In this embodiment, during the verification of each inbound serial number, the item to be inspected corresponding to the inbound serial number is determined, and the serial number verification rule corresponding to the item to be inspected is obtained. Then, the inbound serial number is verified using the serial number verification rule corresponding to the item to be inspected. This can quickly identify serial numbers that do not conform to the verification rule, avoiding the discovery of serial number errors only during item outbound verification or item picking and outbound. Furthermore, the serial number verification rules for different items can be different. In this embodiment, the serial number verification rule corresponding to the item to be inspected can be used to verify the inbound serial number, that is, using an appropriate serial number verification rule can further accelerate the speed of obtaining serial numbers that do not conform to the verification rule.

[0077] Figure 4 This is a flowchart illustrating the serial number change of an abnormal serial number according to an exemplary embodiment. Figure 4 The document illustrates the specific steps for modifying abnormal serial numbers based on serial number modification tasks and storing the modified serial numbers in the warehouse item management database.

[0078] exist Figure 4 In the embodiments, the above Figure 2 Step S240 in the embodiment may further include the following steps.

[0079] In step S241, a serial number change task is executed to determine the abnormal serial number corresponding to the abnormal item.

[0080] The serial number change task includes abnormal serial numbers that need to be changed. In this step, we can obtain the abnormal serial numbers in the serial number change task, identify the abnormal serial number item corresponding to the abnormal serial number, specifically, query the warehouse item management database for the item corresponding to the abnormal serial number, i.e., the item with the abnormal serial number.

[0081] In step S242, the system verifies whether the inbound serial number corresponding to the abnormal serial number of the item in the warehouse item management database is incorrect.

[0082] In step S243, if so, the target serial number corresponding to the item with the abnormal serial number is obtained, and the inbound serial number corresponding to the item with the abnormal serial number in the warehouse item management database is changed using the obtained target serial number.

[0083] After identifying an item with an abnormal serial number, further verify whether the serial number corresponding to that item is incorrect in the warehouse item management database. If an error is found, scan the item to obtain the correct serial number, i.e., the target serial number. Then, delete the abnormal serial number corresponding to that item from the warehouse item management database and store the correct serial number in the warehouse item management database.

[0084] Specifically, after generating the serial number change task, it can be sent to the relevant warehouse operations staff. The staff then checks whether the abnormal serial number of the item stored in the warehouse item management database matches the actual serial number of the abnormal item. If they don't match, it's determined that the serial number stored in the warehouse item management database is incorrect, and the staff can scan for the correct serial number to replace the incorrect serial number in the warehouse item management database.

[0085] Alternatively, after generating the serial number change task, the abnormal serial number in the task is identified, the corresponding abnormal item is determined, and then the specific storage location of the abnormal item is determined. The camera function at that storage location is activated to scan the abnormal item, obtaining the scanned serial number, which is the target serial number. This scanned serial number is compared with the serial number of the abnormal item in the warehouse item management database. If they do not match, the serial number stored in the warehouse item management database is incorrect, and the scanned serial number replaces the incorrect serial number in the database.

[0086] In this embodiment, after generating a serial number change task, the task can be actively executed. During the execution of the task, the abnormal serial number corresponds to an abnormal item, and the serial number of the abnormal item in the warehouse item management database is checked for errors. If an error is found, the serial number is changed. Thus, by actively initiating and executing the serial number change task, erroneous serial numbers in the warehouse item management database can be corrected, thereby reducing the serial number error rate and improving item outbound efficiency.

[0087] In this embodiment of the disclosure, after obtaining one or more inbound serial numbers, duplicate serial numbers can be checked for duplicates and the serial numbers can be changed. Figure 5 This is a flowchart illustrating a deduplication process for one or more inbound serial numbers, according to an exemplary embodiment.

[0088] Figure 5 This document illustrates the specific steps for deduplicating one or more inbound serial numbers to identify duplicate serial numbers, and then modifying the serial numbers of these duplicates. Figure 5 The embodiment specifically includes the following steps.

[0089] In step S501, duplicate serial numbers are checked for one or more inbound serial numbers to obtain duplicate serial numbers among the one or more inbound serial numbers.

[0090] In step S502, the duplicate serial number corresponding to the duplicate serial number is determined.

[0091] In step S503, the serial numbers corresponding to duplicate items in the warehouse item management database are verified to be correct.

[0092] In step S504, if so, the correct serial number corresponding to the duplicate serial number of the item is obtained, and the obtained correct serial number is used to change the entry serial number of the item with the duplicate serial number in the warehouse item management database.

[0093] A serial number can be understood as a unique identifier / code for an item; therefore, different items have different serial numbers. If one or more inbound serial numbers are obtained, and duplicate serial numbers are found, then the duplicate serial numbers are incorrect. In this case, the system identifies the duplicate item corresponding to the duplicate serial number from the warehouse item management database and verifies whether the serial number corresponding to the duplicate item in the database is correct. If an error is found, the correct serial number corresponding to the duplicate item is obtained, and then the correct serial number is used to update the serial number corresponding to the duplicate item in the warehouse item management database.

[0094] For example, if two inbound serial numbers are duplicated, determine that these two serial numbers correspond to item 1 and item 2 respectively. Then, verify whether the serial number corresponding to item 1 and item 2 in the warehouse item management database is incorrect. If the serial number corresponding to item 1 is incorrect, obtain the correct serial number for item 1 and replace the incorrect serial number for item 1 in the warehouse item management database with the correct serial number for item 1.

[0095] In this embodiment of the disclosure, after obtaining one or more inbound serial numbers, the obtained inbound serial numbers can be checked for duplicates to identify duplicate serial numbers. Then, the duplicate serial numbers are verified to identify erroneous serial numbers, and finally, the erroneous serial numbers are corrected. In this way, erroneous serial numbers can be quickly identified and corrected, thereby reducing the serial number error rate and improving the efficiency of item outbound processing.

[0096] Figure 6 This is a flowchart illustrating a warehouse data processing method according to yet another exemplary embodiment. For example... Figure 6 As shown, the warehouse data processing method may include the following steps.

[0097] Step S601: Obtain the detection parameter information of the items in the warehouse, and generate the serial number detection rules of the items and the corresponding timed detection tasks based on the detection parameter information.

[0098] The detection parameter information includes one or more of the following options: supplier information for the item, item grade information, item classification information, item code information, item storage location information, and item warehousing time information. The serial number detection rule includes detection parameter information, and the scheduled detection task includes the execution cycle of the serial number detection rule.

[0099] Step S602: According to the operating cycle of the serial number detection rule, periodically traverse and query the warehouse item management database to determine the items to be detected that meet the detection parameter information and obtain the warehouse entry serial number of the items to be detected.

[0100] Among them, the number of items to be tested that meet the detection parameter information is one or more, and the number of obtained warehousing serial numbers is one or more.

[0101] Step S603: Verify each inbound serial number through the above steps S231 to S233 to obtain one or more abnormal serial numbers among the inbound serial numbers.

[0102] Step S604: Generate a serial number change task corresponding to the abnormal serial number.

[0103] Step S605: Execute the serial number change task through the above steps S241 to S243 to change the abnormal serial number to the target serial number, i.e., the correct serial number.

[0104] It should be noted that there can be one or more abnormal serial numbers. In step S604, a serial number change task corresponding to each abnormal serial number can be generated, and then the generated serial number change task can be executed to change the abnormal serial numbers. In step S605, a serial number change task corresponding to all abnormal serial numbers can also be generated, and then the serial number change task can be executed to change all abnormal serial numbers.

[0105] Additionally, after step S602, steps S501 to S504 can be executed to check for duplicates in one or more inbound serial numbers, obtain duplicate serial numbers, then verify the duplicate serial numbers to identify erroneous serial numbers, and finally modify the erroneous serial numbers. If the task is changed based on the serial number, the abnormal item corresponding to the abnormal serial number is determined. Then, steps S603 to S605 are executed. In this case, before executing steps S603 to S605, the duplicate serial numbers can be deleted from one or more inbound serial numbers.

[0106] Figure 7 This is a block diagram illustrating a warehouse data processing apparatus according to an exemplary embodiment. Figure 7As shown, the warehouse data processing device 700 includes a detection rule and task generation module 710, an inbound serial number acquisition module 720, an inbound serial number verification module 730, and an inbound serial number modification module 740.

[0107] The detection rule and task generation module 710 can be used to: obtain detection parameter information of items in the warehouse, and generate serial number detection rules and corresponding timed detection tasks based on the detection parameter information; the inbound serial number acquisition module 720 can be used to: execute timed detection tasks, periodically traverse and query the warehouse item management database to obtain the inbound serial number of the item to be detected that meets the serial number detection rules; the inbound serial number verification module 730 can be used to: verify the inbound serial number of the item to be detected, obtain abnormal serial numbers in the inbound serial number, and generate a serial number change task corresponding to the abnormal serial number; the inbound serial number change module 740 can be used to: execute the serial number change task, obtain the target serial number corresponding to the abnormal serial number, and update the abnormal serial number in the warehouse item management database using the target serial number.

[0108] In an optional embodiment of this disclosure, the serial number detection rule includes detection parameter information, and the timed detection task includes the running cycle of the serial number detection rule; wherein, the warehousing serial number acquisition module 720 is further used to: periodically traverse and query the warehouse item management database according to the running cycle of the serial number detection rule, determine the items to be detected that meet the detection parameter information, and obtain the warehousing serial number of the items to be detected.

[0109] In the optional embodiments of this disclosure, the detection parameter information includes one or more of the following options: supplier information corresponding to the item, item grade information, item classification information, item code information, item storage location information, and item warehousing time information.

[0110] In an optional embodiment of this disclosure, the warehousing serial number verification module 730 is further configured to: obtain the serial number verification rules corresponding to the item to be inspected; verify the warehousing serial number using the serial number verification rules corresponding to the item to be inspected; and determine that the warehousing serial number is an abnormal serial number if the verification fails.

[0111] In an optional embodiment of this disclosure, the inbound serial number verification module 730 is further configured to: obtain the serial number verification rule corresponding to the item to be inspected from the warehouse item management system, or generate the serial number verification rule corresponding to the item to be inspected; wherein, the serial number verification rule corresponding to the item to be inspected includes one or more of the following options: the length information of the verification serial number, the character type information contained in the verification serial number, the prefix information of the verification serial number, the suffix information of the verification serial number, and the characteristic character information of the verification serial number.

[0112] In an optional embodiment of this disclosure, the inbound serial number change module 740 is further configured to: execute a serial number change task, determine the abnormal serial number corresponding to the abnormal item; verify whether the inbound serial number corresponding to the abnormal item in the warehouse item management database is incorrect; if so, obtain the target serial number corresponding to the abnormal item, and use the obtained target serial number to change the inbound serial number corresponding to the abnormal item in the warehouse item management database.

[0113] In an optional embodiment of this disclosure, the number of inbound serial numbers is one or more. Figure 7 The apparatus 700 shown also includes an inbound serial number deduplication module 750, used for: deduplicating one or more inbound serial numbers to obtain duplicate serial numbers among the one or more inbound serial numbers; identifying duplicate items corresponding to the duplicate serial numbers; verifying whether the inbound serial numbers corresponding to the duplicate items in the warehouse item management database are incorrect; if so, obtaining the correct serial number corresponding to the duplicate items and using the obtained correct serial number to change the inbound serial number corresponding to the duplicate items in the warehouse item management database.

[0114] Regarding the apparatus in the above embodiments, the specific manner in which each module performs its operation has been described in detail in the embodiments related to the method, and will not be elaborated upon here.

[0115] Figure 8 This is a structural block diagram of an electronic device according to an exemplary embodiment. Referring below... Figure 8 To describe an electronic device 800 according to such an embodiment of the present disclosure. Figure 8 The electronic device 800 shown is merely an example and should not impose any limitation on the functionality and scope of use of the embodiments disclosed herein.

[0116] like Figure 8 As shown, the electronic device 800 is presented in the form of a general-purpose computing device. The components of the electronic device 800 may include, but are not limited to: at least one processing unit 810, at least one storage unit 820, a bus 830 connecting different system components (including storage unit 820 and processing unit 810), and a display unit 840.

[0117] The storage unit stores program code, which can be executed by the processing unit 810 to perform the steps described in the "Exemplary Methods" section of this specification according to various exemplary embodiments of this disclosure. For example, the processing unit 810 can perform actions such as... Figure 2 The steps are shown in the figure.

[0118] Storage unit 820 may include a readable medium in the form of a volatile storage unit, such as a random access memory unit (RAM) 821 and a cache memory unit 822, and may further include a read-only memory unit (ROM) 823.

[0119] The storage unit 820 may also include a program / utility 824 having a set (at least one) of program modules 825, including but not limited to: an operating system, one or more application programs, other program modules, and program data, each or some combination of these examples may include an implementation of a network environment.

[0120] Bus 830 can represent one or more of several types of bus structures, including a memory cell bus or memory cell controller, a peripheral bus, a graphics acceleration port, a processing unit, or a local bus using any of the various bus structures.

[0121] Electronic device 800 can also communicate with one or more external devices 870 (e.g., keyboard, pointing device, Bluetooth device, etc.), one or more devices that enable a user to interact with electronic device 800, and any device that enables electronic device 800 to communicate with one or more other computing devices (e.g., router, modem, etc.). This communication can be performed via input / output (I / O) interface 850. Furthermore, electronic device 800 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and public networks such as the Internet) via network adapter 860. As shown, network adapter 860 communicates with other modules of electronic device 800 via bus 830. It should be understood that, although not shown in the figures, other hardware and software modules can be used in conjunction with electronic device 800, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0122] From the above description of the embodiments, those skilled in the art will readily understand that the exemplary embodiments described herein can be implemented by software or by combining software with necessary hardware. Therefore, the technical solutions according to the embodiments of this disclosure can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (such as a CD-ROM, USB flash drive, external hard drive, etc.) or on a network, including several instructions to cause a computing device (such as a personal computer, server, terminal device, or network device, etc.) to execute the methods according to the embodiments of this disclosure.

[0123] In an exemplary embodiment, a computer-readable storage medium including instructions is also provided, such as a memory including instructions that can be executed by a processor of the device to perform the described method. Optionally, the computer-readable storage medium may be a ROM, random access memory (RAM), CD-ROM, magnetic tape, floppy disk, and optical data storage device, etc.

[0124] In an exemplary embodiment, a computer program product is also provided, including a computer program and instructions, which, when executed by a processor, implement the online file processing method described in the above embodiments.

[0125] Other embodiments of this disclosure will readily occur to those skilled in the art upon consideration of the specification and practice of the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of this disclosure that follow the general principles of this disclosure and include common knowledge or customary techniques in the art not disclosed herein. The specification and examples are to be considered exemplary only, and the true scope and spirit of this disclosure are indicated by the following claims.

[0126] It should be understood that this disclosure is not limited to the precise structures described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of this disclosure is limited only by the appended claims.

Claims

1. A warehouse data processing method, characterized in that, include: Obtain the detection parameter information of items in the warehouse, and generate the item serial number detection rule and the corresponding timed detection task based on the detection parameter information; the detection parameter information includes one or more of the following options: the supplier information corresponding to the item, the item grade information, the item classification information, the item code information, the item storage location information, and the item entry time information. The scheduled detection task is executed, and the warehouse item management database is periodically traversed and queried to obtain the entry serial number of the item to be detected that meets the serial number detection rules. The entry serial number of the item to be inspected is verified to obtain the abnormal serial number in the entry serial number, and a serial number change task corresponding to the abnormal serial number is generated. Execute the serial number change task to obtain the target serial number corresponding to the abnormal serial number, and use the target serial number to update the abnormal serial number in the warehouse item management database.

2. The method according to claim 1, characterized in that, The serial number detection rule includes the detection parameter information, and the timed detection task includes the running cycle of the serial number detection rule; The execution of the scheduled detection task, which involves periodically traversing and querying the warehouse item management database to obtain the entry serial numbers of the items to be detected that meet the serial number detection rules, includes: According to the operating cycle of the serial number detection rule, the warehouse item management database is periodically traversed and queried to determine the item to be detected that meets the detection parameter information, and the warehouse entry serial number of the item to be detected is obtained.

3. The method according to claim 1, characterized in that, The step of verifying the entry serial number of the item to be inspected and obtaining the abnormal serial number in the entry serial number includes: Obtain the serial number verification rules corresponding to the item to be detected; The entry serial number is verified using the serial number verification rules corresponding to the item to be detected; If the verification fails, the inbound serial number is determined to be an abnormal serial number.

4. The method according to claim 3, characterized in that, The rules for obtaining the serial number verification of the item to be detected include: Obtain the serial number verification rules corresponding to the item to be tested from the warehouse item management system, or generate the serial number verification rules corresponding to the item to be tested. The serial number verification rules for the item to be detected include one or more of the following options: verifying the length information of the serial number, verifying the character type information contained in the serial number, verifying the prefix information of the serial number, verifying the suffix information of the serial number, and verifying the characteristic character information of the serial number.

5. The method according to claim 1, characterized in that, The step of executing the serial number change task, obtaining the target serial number corresponding to the abnormal serial number, and updating the abnormal serial number in the warehouse item management database using the target serial number includes: Execute the serial number change task to identify the abnormal item corresponding to the abnormal serial number; Verify whether the inbound serial numbers corresponding to the abnormal items in the warehouse item management database are correct; If so, obtain the target serial number corresponding to the item with the abnormal serial number, and use the obtained target serial number to change the inbound serial number corresponding to the item with the abnormal serial number in the warehouse item management database.

6. The method according to any one of claims 1 to 5, characterized in that, The number of the inbound serial numbers may be one or more; The method further includes: Perform a duplicate check on one or more of the inbound serial numbers to obtain duplicate serial numbers among the one or more inbound serial numbers; Identify the duplicate item corresponding to the duplicate serial number; Verify whether the inbound serial numbers corresponding to the duplicate serial numbers in the warehouse item management database are incorrect; If so, obtain the correct serial number corresponding to the duplicate serial number item, and use the obtained correct serial number to change the inbound serial number corresponding to the duplicate serial number item in the warehouse item management database.

7. A warehouse data processing device, characterized in that, include: The detection rule and task generation module is used to obtain the detection parameter information of items in the warehouse, and generate the item serial number detection rule and the corresponding timed detection task based on the detection parameter information; the detection parameter information includes one or more of the following options: the supplier information corresponding to the item, the item grade information, the item classification information, the item code information, the item storage location information, and the item entry time information. The inbound serial number acquisition module is used to execute the scheduled detection task, and periodically traverse and query the warehouse item management database to obtain the inbound serial number of the item to be detected that meets the serial number detection rules. The inbound serial number verification module is used to verify the inbound serial number of the item to be inspected, obtain abnormal serial numbers in the inbound serial number, and generate a serial number change task corresponding to the abnormal serial number. The inbound serial number change module is used to execute the serial number change task, obtain the target serial number corresponding to the abnormal serial number, and update the abnormal serial number in the warehouse item management database using the target serial number.

8. A computer-readable storage medium having a computer program stored thereon, the computer program being executed by a processor to implement the warehouse data processing method as described in any one of claims 1 to 6.

9. An electronic device, characterized in that, include: processor; and memory for storing the executable instructions of the processor; The processor is configured to perform the warehouse data processing method as described in any one of claims 1 to 6 by executing the executable instructions.

Images