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

Abstract

The invention provides a warehouse data processing method and device, a storage medium and electronic equipment, and relates to the technical field of computers. The method comprises the following steps: generating a serial number detection rule and a timed detection task of an article according to detection parameter information of the article in a warehouse; executing a timed detection task, and regularly performing traversal query in a warehouse article management database to obtain a warehousing serial number of the to-be-detected article meeting the serial number detection rule; verifying the warehousing serial number to obtain an abnormal serial number, and generating a serial number change task corresponding to the abnormal serial number; and 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. According to the method, the serial numbers of the articles in the warehouse can be actively detected, the abnormal serial numbers are inquired, the abnormal serial numbers are changed through the serial number changing task, the labor cost is reduced, the articles with the abnormal serial numbers are prevented from being delivered out of the warehouse, and the article complaint rate is reduced.

Description

Technical Field

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

[0002] In the warehouse production system, the scanning serial number is often wrong. When the items are put into the warehouse, the item code, barcode or storage location code is mistakenly entered as the serial number. When the items are checked out of the warehouse or picked out of the warehouse, the warehouse staff will find that the serial number of the item is wrong, and then manually modify the correct serial number, which increases labor costs. In addition, if the items have been shipped out, they cannot be traced, which increases the complaint rate of the items.

[0003] It should be noted that the information disclosed in the above background technology section is only used to enhance the understanding of the background of the present disclosure, and therefore may include information that does not constitute the prior art known to ordinary technicians in the field. Summary of the invention

[0004] The purpose of the present disclosure is to provide a warehouse data processing method, a warehouse data processing device, a computer-readable storage medium and an electronic device, which can actively detect the serial numbers of items in the warehouse, query abnormal serial numbers, and then change the abnormal serial numbers through serial number change tasks, thereby reducing labor costs, avoiding the release of items with abnormal serial numbers, and reducing the item complaint rate.

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

[0006] According to one aspect of the present disclosure, there is provided a warehouse data processing method, comprising: acquiring detection parameter information of items in the warehouse, generating serial number detection rules for the items and a scheduled detection task corresponding to the serial number detection rule according to the detection parameter information; executing the scheduled detection task, periodically performing traversal queries in a warehouse item management database, and obtaining the incoming serial numbers of the items to be detected that meet the serial number detection rule; verifying the incoming serial numbers of the items to be detected, obtaining abnormal serial numbers in the incoming serial numbers, and generating a serial number change task corresponding to the abnormal serial number; executing the serial number change task, obtaining a target serial number corresponding to the abnormal serial number, and using the target serial number to update the abnormal serial number in the warehouse item management database.

[0007] In an optional embodiment of the present disclosure, the serial number detection rule includes the detection parameter information, and the scheduled detection task includes the operation cycle of the serial number detection rule; wherein, executing the scheduled detection task, regularly performing traversal queries in the warehouse item management database, and obtaining the entry serial numbers of the items to be detected that meet the serial number detection rule, includes: according to the operation cycle of the serial number detection rule, regularly performing traversal queries in the warehouse item management database, determining the items to be detected that meet the detection parameter information, and obtaining the entry serial numbers of the items to be detected.

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

[0009] In an optional embodiment of the present disclosure, the verifying the storage serial number of the item to be detected to obtain an abnormal serial number in the storage serial number includes: obtaining a serial number verification rule corresponding to the item to be detected; verifying the storage serial number using the serial number verification rule corresponding to the item to be detected; if the verification fails, determining that the storage serial number is an abnormal serial number.

[0010] In an optional embodiment of the present 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 a 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: length information of the verification serial number, character type information contained in the verification serial number, prefix information of the verification serial number, suffix information of the verification serial number, and characteristic character information of the verification serial number.

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

[0012] In an optional embodiment of the present disclosure, the number of the incoming serial numbers is one or more; wherein the method further includes: checking for duplicates on one or more of the incoming serial numbers to obtain repeated serial numbers in one or more of the incoming serial numbers; determining the duplicate serial number items corresponding to the repeated serial numbers; verifying whether the incoming serial numbers corresponding to the duplicate serial number items in the warehouse item management database are incorrect; if so, obtaining the correct serial number corresponding to the duplicate serial number item, and using the obtained correct serial number to change the incoming serial number corresponding to the duplicate serial number item in the warehouse item management database.

[0013] According to another aspect of the present disclosure, there is provided a warehouse data processing device, comprising: a detection rule and task generation module, for acquiring detection parameter information of items in the warehouse, and generating, according to the detection parameter information, a serial number detection rule for the item and a scheduled detection task corresponding to the serial number detection rule; an incoming serial number acquisition module, for executing the scheduled detection task, and performing traversal queries in a warehouse item management database at regular intervals to obtain the incoming serial numbers of the items to be detected that satisfy the serial number detection rule; an incoming serial number verification module, for verifying the incoming serial numbers of the items to be detected, obtaining abnormal serial numbers in the incoming serial numbers, and generating a serial number change task corresponding to the abnormal serial number; and an incoming serial number change module, for executing the serial number change task, obtaining a target serial number corresponding to the abnormal serial number, and using the target serial number to update the abnormal serial number in the warehouse item management database.

[0014] In an optional embodiment of the present disclosure, the serial number detection rule includes the detection parameter information, and the scheduled detection task includes the operation cycle of the serial number detection rule; wherein the entry serial number acquisition module is also used to: according to the operation cycle of the serial number detection rule, regularly perform traversal queries in the warehouse item management database to determine the items to be detected that meet the detection parameter information, and obtain the entry serial numbers of the items to be detected.

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

[0016] In an optional embodiment of the present disclosure, the entry serial number verification module is further used to: obtain the serial number verification rule corresponding to the item to be detected; verify the entry serial number using the serial number verification rule corresponding to the item to be detected; if the verification fails, determine that the entry serial number is an abnormal serial number.

[0017] In an optional embodiment of the present disclosure, the incoming serial number verification module is further used to: obtain the serial number verification rules corresponding to the items to be detected from the warehouse item management system, or generate the serial number verification rules corresponding to the items to be detected; wherein the serial number verification rules corresponding to the items to be detected include one or more of the following options: length information of the verification serial number, character type information contained in the verification serial number, prefix information of the verification serial number, suffix information of the verification serial number, and characteristic character information of the verification serial number.

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

[0019] In an optional embodiment of the present disclosure, the number of the incoming serial numbers is one or more; wherein the device also includes an incoming serial number duplication checking module, which is used to: check the duplication of one or more of the incoming serial numbers to obtain repeated serial numbers in one or more of the incoming serial numbers; determine the duplicate serial number items corresponding to the repeated serial numbers; verify whether the incoming serial numbers corresponding to the duplicate serial number items 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 incoming serial number corresponding to the duplicate serial number item in the warehouse item management database.

[0020] According to another aspect of the present disclosure, there is provided a computer-readable storage medium on which a computer program is stored, and the computer program implements the above-mentioned warehouse data processing method when executed by a processor.

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

[0022] The warehouse data processing method of the disclosed embodiment, after obtaining the detection parameter information of the items in the warehouse, generates the serial number detection rules and the timing detection tasks of the items according to the detection parameter information, and then executes the timing detection tasks, and uses the serial number detection rules to query the warehouse item management database regularly to obtain the storage serial numbers of the items to be detected that meet the serial number detection rules in the database, and then checks these storage serial numbers to obtain abnormal serial numbers, and then initiates the abnormal serial number change task to change the abnormal serial number to the target serial number (that is, the correct serial number). On the one hand, the storage serial numbers in the warehouse management database can be actively detected through the timing detection tasks and the serial number detection rules, and the abnormal serial numbers can be queried, so as to solve the problem that the serial number errors of the items are found manually when the items are checked or picked out of the warehouse, reduce the labor cost, and detect the abnormal serial numbers in time; on the other hand, after obtaining the abnormal serial number, the abnormal serial number change task is actively initiated to change the abnormal serial number to the correct sequence, which can reduce the serial number error rate in the database, reduce the probability of the items with the wrong serial number being out of the warehouse, and thus reduce the complaint rate of the items.

[0023] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] The accompanying drawings herein are incorporated into the specification and constitute a part of the specification, illustrate embodiments consistent with the present disclosure, and together with the specification are used to explain the principles of the present disclosure. Obviously, the accompanying drawings described below are only some embodiments of the present disclosure, and for ordinary technicians in this field, other accompanying drawings can be obtained based on these accompanying drawings without creative work.

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

[0026] Figure 2 is a flow chart of a warehouse data processing method according to an exemplary embodiment;

[0027] Figure 3 is a flow chart of obtaining an abnormal sequence number according to an exemplary embodiment;

[0028] Figure 4 is a flow chart showing a method of changing a sequence number of an abnormal sequence number according to an exemplary embodiment;

[0029] Figure 5 is a flowchart of performing duplicate checking on one or more warehoused serial numbers according to an exemplary embodiment;

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

[0031] Figure 7 is a block diagram of a warehouse data processing device according to an exemplary embodiment; and

[0032] Figure 8 It is a structural block diagram of an electronic device according to an exemplary embodiment. DETAILED DESCRIPTION

[0033] In order to enable ordinary persons in the art to better understand the technical solutions of the present disclosure, the technical solutions in the embodiments of the present disclosure will be clearly and completely described below in conjunction with the accompanying drawings.

[0034] It should be noted that the terms "first", "second", etc. in the specification and claims of the present disclosure 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 numbers used in this way can be interchanged where appropriate, so that the embodiments of the present disclosure described herein can be implemented in an order other than those illustrated or described herein.

[0035] The following example embodiments can be implemented in a variety of forms and should not be construed as being limited to the examples set forth herein; on the contrary, these embodiments are provided so that the present disclosure will be more comprehensive and complete, and the concepts of the example embodiments are fully conveyed to those skilled in the art. The described features, structures, or characteristics may be combined in one or more embodiments in any suitable manner. In the following description, many specific details are provided to provide a full understanding of the embodiments of the present disclosure. However, those skilled in the art will appreciate that the technical solutions of the present disclosure may be practiced while omitting one or more of the specific details, or other methods, components, devices, steps, etc. may be adopted. In other cases, known technical solutions are not shown or described in detail to avoid obscuring various aspects of the present disclosure.

[0036] In addition, the accompanying drawings are only schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the figures represent the same or similar parts, and their repeated description will be omitted. Some of the block diagrams shown in the accompanying drawings are functional entities and do not necessarily correspond to physically or logically independent entities. These functional entities can be implemented in software form, or implemented in one or more hardware modules or integrated circuits, or implemented in different networks and / or processor devices and / or microcontroller devices.

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

[0038] Figure 1 1 is a schematic diagram of a system architecture of 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 is used to provide a medium for a communication link between the client 103 and the server 101. The network 102 may include various connection types, such as wired, wireless communication links or optical fiber cables, etc.

[0039] Among them, server 101 can be an independent physical server, or a server cluster or distributed system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, 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 of a network platform, and the network platform can be, for example, a trading platform, a live broadcast platform, a social platform, or a music platform, etc., which is not limited in the embodiments of the present disclosure. Among them, the server can be a single server or a cluster formed by multiple servers, and the present disclosure does not limit the specific architecture of the server.

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

[0041] In the disclosed embodiment, the server 101 can: obtain detection parameter information of items in the warehouse, and generate serial number detection rules for the items and scheduled detection tasks corresponding to the serial number detection rules based on the detection parameter information; execute the scheduled detection tasks, perform traversal queries in the warehouse item management database at regular intervals, and obtain the incoming serial numbers of the items to be detected that meet the serial number detection rules; verify the incoming serial numbers, obtain abnormal serial numbers in the incoming serial numbers, and generate a serial number change task corresponding to the abnormal serial numbers; 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.

[0042] It should be understood that Figure 1 The number of servers 101, networks 102 and clients 103 is merely illustrative, and any number of terminal devices, networks and servers may be provided according to actual needs.

[0043] In order to enable ordinary persons in the art to better understand the technical solution of the present disclosure, the technical solution of text opinion recognition in the embodiment of the present disclosure will be described in more detail below with reference to the accompanying drawings and embodiments.

[0044] Figure 2 FIG. 1 is a flowchart of a warehouse data processing method according to an exemplary embodiment. Figure 2 , this method is applied to Figure 1 The server shown in the figure specifically includes the following steps.

[0045] Step S210: Acquire detection parameter information of items in the warehouse, and generate serial number detection rules for the items and scheduled detection tasks corresponding to the serial number detection rules according to the detection parameter information.

[0046] The items in the warehouse can be understood as items stored in the warehouse, i.e., items entering the warehouse. In the disclosed embodiment, the detection parameter information may include one or more of the following options: supplier information corresponding to the item, item level information, item classification information, item coding information, item storage location information, and item entry time information.

[0047] Among them, the supplier information corresponding to the item can be understood as the owner of the item, such as the supplier of item A is a certain manufacturer. The item grade information may include the item quality grade, that is, the item is graded according to the quality of the item. For example, if the item is a certain fruit, the single fruit with a mass of more than 500 grams is classified as grade 1, the single fruit with a mass of 300 to 500 grams is classified as grade 2, and the single fruit with a mass of less than 300 grams is classified as grade 3. Of course, the item grade information may also include the item material grade, the item application scope grade or other grade information, which is not limited in the embodiments of the present disclosure.

[0048] Item classification information refers to the category to which an item belongs, such as a mobile phone belongs to the electronic product category and a refrigerator belongs to the household appliance category. Item coding information may refer to an item information identification code, specifically including an item classification code, an item reference name code, and an item attribute code. Of course, the item coding information may also be an item batch code or other coding information, which is not limited in the embodiments of the present disclosure.

[0049] The item storage location information refers to the location information of the item in the warehouse, and the item storage time information refers to the specific time when the item is stored. It should be noted that the detection parameter information may also include other information, such as the latest review time information of the item and the information of the item participating in an activity.

[0050] In this step, the detection parameter information of the items in the warehouse can be obtained according to actual needs, and then the serial number detection rule and the scheduled detection task corresponding to the detection rule can be generated according to the obtained detection parameter information. For example, if it is desired to detect the serial number of the item of the specified item supplier P in the warehouse, then the detection parameter information is the item supplier information P, and then the serial number detection rule corresponding to the item supplier information P is generated, so that the serial numbers of all items corresponding to the item supplier information P in the warehouse can be obtained through the serial number detection rule. The scheduled detection task corresponding to the serial number detection rule may include the operation cycle of the rule, such as once a day, that is, the serial number detection rule is executed once a day.

[0051] Step S220: Execute the scheduled detection task, perform a traversal query in the warehouse item management database at a scheduled time, and obtain the storage serial numbers of the items to be detected that meet the serial number detection rules.

[0052] Among them, the warehouse item management database is used to store information about items in the warehouse, such as supplier information corresponding to the items, item grade information, item classification information, item coding information, item storage location information, item entry serial number, and item entry time information.

[0053] In this step, through the scheduled detection task, a traversal query is performed regularly in the warehouse item management database to query the items that meet the serial number detection rules, that is, the items to be detected, and obtain the storage serial number of the items to be detected, that is, the serial number entered when the items to be detected are put into the warehouse.

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

[0055] Furthermore, executing a scheduled inspection task, regularly performing a traversal query in the warehouse item management database, and obtaining the storage serial numbers of the items to be inspected that meet the serial number inspection rules may include: according to the operation cycle of the serial number inspection rules, regularly performing a traversal query in the warehouse item management database, determining the items to be inspected that meet the inspection parameter information, and obtaining the storage serial numbers of the items to be inspected.

[0056] The warehouse item management database stores the entry serial number of the item. For example, when the item enters the warehouse, the item is scanned to obtain the serial number of the item, and then the scanned serial number is stored in the warehouse item management database.

[0057] In the disclosed embodiment, the serial number detection rule is generated based on the detection parameter information, and the detection parameter information can be understood as the information of the items that need to be serial number detected. According to the operation cycle of the serial number detection rule, the warehouse item management database is traversed to query the items that meet the detection rule, that is, the items to be detected, and the storage serial number of the items to be detected is obtained. Among them, the items that meet the detection rule are the items to be detected, that is, the items that meet the detection parameter information. For example, the detection parameter information is the coding information of the specified item, and the serial number detection rule corresponding to the coding information of the specified item is generated, so that the items corresponding to the coding information of the specified item in the warehouse, that is, the items to be detected, can be queried through the serial number detection rule, and the storage serial number of the items to be detected can be obtained.

[0058] Step S230: verify the storage serial numbers of the items to be inspected, obtain abnormal serial numbers in the storage serial numbers, and generate serial number change tasks corresponding to the abnormal serial numbers.

[0059] Among them, the number of items to be detected is one or more, that is, the number of the obtained storage serial numbers is one or more. In this step, each storage serial number is verified, and if the verification fails, the storage serial number is determined to be an abnormal serial number. After verifying each storage serial number, the abnormal serial number among all the storage serial numbers can be obtained, and then the serial number change task corresponding to the abnormal serial number 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 corresponding to the item is obtained, that is, the correct serial number, and the target serial number is used to replace the abnormal serial number stored in the warehouse item management database to complete the change of the abnormal serial number. Specifically, after the item corresponding to the abnormal serial number is queried, the storage location of the item in the warehouse can be queried, the item can be obtained according to the storage location, the item can be scanned to obtain the target serial number, or the target serial number of the item can be obtained manually.

[0062] The warehouse data processing method of the disclosed embodiment, after obtaining the detection parameter information of the items in the warehouse, generates the serial number detection rules and the timing detection tasks of the items according to the detection parameter information, and then executes the timing detection tasks, and uses the serial number detection rules to query the warehouse item management database regularly to obtain the storage serial numbers of the items to be detected that meet the serial number detection rules in the database, and then checks these storage serial numbers to obtain abnormal serial numbers, and then initiates the abnormal serial number change task to change the abnormal serial number to the target serial number (that is, the correct serial number). On the one hand, the storage serial numbers in the warehouse management database can be actively detected through the timing detection tasks and the serial number detection rules, and the abnormal serial numbers can be queried, so as to solve the problem that the serial number errors of the items are found manually when the items are checked or picked out of the warehouse, reduce the labor cost, and detect the abnormal serial numbers in time; on the other hand, after obtaining the abnormal serial number, the abnormal serial number change task is actively initiated to change the abnormal serial number to the correct sequence, which can reduce the serial number error rate in the database, reduce the probability of the items with the wrong serial number being out of the warehouse, and thus reduce the complaint rate of the items.

[0063] Figure 3 is a flowchart of obtaining an abnormal serial number according to an exemplary embodiment. As described above, the number of the storage serial number is one or more. Figure 3 In the process of obtaining an abnormal sequence number shown in the embodiment, an incoming sequence number is used as an example to illustrate whether the incoming sequence number is an abnormal sequence number. In the embodiment of the present disclosure, each incoming sequence number is judged to obtain an abnormal sequence number among one or more incoming sequence numbers.

[0064] exist Figure 3 In the embodiment, the above Figure 2 In the embodiment, step S230 of verifying the storage serial numbers of the items to be inspected and obtaining abnormal serial numbers in the storage serial numbers may further include the following steps.

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

[0066] The serial number verification rule refers to a rule for verifying whether the serial number of an item is abnormal. Further, obtaining the serial number verification rule corresponding to the item to be detected may include: 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.

[0067] The serial number verification rules corresponding to different items may be different. Specifically, the serial number verification rules corresponding to items with the same supplier information are the same, the serial number verification rules corresponding to items with the same coding information are the same, and the serial number verification rules corresponding to items with the same classification are the same. In other words, the serial number verification rules correspond to the serial number detection rules, and the serial number verification rules corresponding to one or more storage serial numbers obtained through the same serial number detection rule are the same. When generating the serial number detection rule, the serial number verification rule corresponding to the detection rule can be generated.

[0068] The method of obtaining serial number verification rules in the embodiment of the present disclosure may include: the warehouse item management system issues serial number verification rules corresponding to each item, and obtains the serial number verification rules corresponding to the item to be inspected from the verification rules issued by the warehouse item management system; and generates serial number verification rules corresponding to the item to be inspected.

[0069] The serial number verification rules corresponding to 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.

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

[0071] Verifying the prefix information of the serial number refers to verifying whether the prefix of the serial number of the item to be tested meets the preset prefix condition, where the preset prefix condition refers to the information contained in the prefix of the correct serial number of the item to be tested. Verifying the suffix information of the serial number refers to verifying whether the suffix of the serial number of the item to be tested meets the preset suffix condition, where the preset suffix condition refers to the information contained in the suffix of the correct serial number of the item to be tested. Verifying the characteristic character information of the serial number refers to verifying whether the serial number of the item to be tested contains specified characters, where the specified characters refer to the characters that the correct serial number of the item to be tested needs to contain.

[0072] In step S232, the serial number of the incoming item is verified using the serial number verification rule corresponding to the item to be detected.

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

[0074] After obtaining the serial number verification rule corresponding to the item to be detected, the serial number of the entry is verified using the serial number verification rule corresponding to the item to be detected. If the verification fails, that is, the entry serial number does not meet the serial number verification rule corresponding to the item to be detected, the entry serial number is considered to be an abnormal serial number.

[0075] For example, the incoming serial number is SN00000001, determine the item to be detected corresponding to the incoming serial number, and obtain the serial number verification rule S corresponding to the item to be detected. The serial number verification rule S includes four rule items, specifically: Rule item 1, verify whether the serial number length is 10; Rule item 2, verify whether the serial number prefix is ​​"SN"; Rule item 3, verify whether the serial number suffix is ​​"A"; Rule item 4, verify whether the serial number character category only includes numbers and letters. The four rule items in the serial number verification rule S verify the incoming serial number SN00000001, and find that the suffix of the incoming serial number SN00000001 is not "A", that is, the incoming serial number SN00000001 does not meet the rule item 3, then the incoming serial number SN00000001 fails the verification, and the incoming serial number SN00000001 is considered to be an abnormal serial number.

[0076] In the disclosed embodiment, in the process of verifying each incoming serial number, the to-be-detected item corresponding to the incoming serial number is determined, the serial number verification rule corresponding to the to-be-detected item is obtained, and then the incoming serial number is verified using the serial number verification rule corresponding to the to-be-detected item, so that the serial number that does not meet the verification rule can be quickly obtained, avoiding the discovery of the serial number error of the item when the item is reviewed or picked out of the warehouse. Moreover, the serial number verification rules for different items can be different. In the disclosed embodiment, the serial number verification rule corresponding to the to-be-detected item can be used to verify the incoming serial number, that is, the appropriate serial number verification rule can be used for verification, which can further speed up the speed of obtaining the serial number that does not meet the verification rule.

[0077] Figure 4 The present invention is a flowchart of changing a sequence number of an abnormal sequence number according to an exemplary embodiment. Figure 4 The specific steps of changing the abnormal serial number according to the serial number change task and storing the changed serial number in the warehouse item management database are shown.

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

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

[0080] The serial number change task includes an abnormal serial number that needs to be changed. In this step, the abnormal serial number in the serial number change task can be obtained, and the abnormal serial number item corresponding to the abnormal serial number can be determined. Specifically, the item corresponding to the abnormal serial number, that is, the abnormal serial number item, is queried in the warehouse item management database.

[0081] In step S242, the warehouse item management database is checked to see whether the incoming serial number corresponding to the item with the abnormal serial number is correct.

[0082] In step S243, if yes, the target serial number corresponding to the item with the abnormal serial number is obtained, and the acquired target serial number is used to change the incoming serial number corresponding to the item with the abnormal serial number in the warehouse item management database.

[0083] After determining the abnormal serial number item, further verify whether the serial number corresponding to the abnormal serial number item in the warehouse item management database is incorrect. If it is determined to be incorrect, the abnormal serial number item can be scanned to obtain the correct serial number, that is, the target serial number, and then the abnormal serial number corresponding to the abnormal serial number item in the warehouse item management database is deleted, and the correct serial number is stored in the warehouse item management database.

[0084] Specifically, after the serial number change task is generated, the serial number change task can be sent to the corresponding warehouse operation staff. Then, the staff checks whether the abnormal serial number of the abnormal serial number item stored in the warehouse item management database is consistent with the actual serial number of the abnormal item. If they are inconsistent, it is determined that the serial number stored in the warehouse item management database is incorrect, and the staff can scan the correct serial number to replace the incorrect serial number in the warehouse item management database.

[0085] In other words, after the serial number change task is generated, the abnormal serial number in the serial number change task is determined, the abnormal serial number item corresponding to the abnormal serial number is determined, and then the specific storage location of the abnormal serial number item is determined, and the camera function of the specific storage location is started to scan the abnormal serial number item to obtain the scanned serial number, that is, the target serial number. The scanned serial number is compared with the serial number of the abnormal serial number item in the warehouse item management database. If there is a discrepancy, it is determined that the serial number stored in the warehouse item management database is incorrect, and the scanned serial number is used to replace the incorrect serial number in the warehouse item management database.

[0086] In the disclosed embodiment, after the serial number change task is generated, the serial number change task can be actively executed, and in the process of executing the serial number change task, the abnormal serial number item corresponding to the abnormal serial number is first determined, and then the serial number of the abnormal serial number item in the warehouse item management database is checked to see if it is wrong. If it is wrong, the serial number is changed. In this way, by actively initiating the execution of the serial number change task, the incorrect serial number in the warehouse item management database can be changed, thereby reducing the serial number error rate, and further improving the efficiency of item delivery.

[0087] In the disclosed embodiment, after obtaining one or more storage serial numbers, one or more storage serial numbers may be checked for duplicates, and the duplicate serial numbers may be changed. Figure 5 The present invention is a flowchart of performing duplicate checking on one or more warehoused serial numbers according to an exemplary embodiment.

[0088] Figure 5 The specific steps of checking one or more incoming serial numbers for duplicates to obtain duplicate serial numbers and changing the duplicate serial numbers are shown. Figure 5 In the embodiment, the following steps are specifically included.

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

[0090] In step S502, the serial number duplicated items corresponding to the duplicate serial numbers are determined.

[0091] In step S503, the serial numbers corresponding to the items with duplicate serial numbers in the warehouse item management database are checked to see if they are correct.

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

[0093] The serial number can be understood as the unique identification / unique code of the item, so the serial numbers of different items are different. When obtaining one or more warehousing serial numbers, if there are duplicates in the obtained warehousing serial numbers, it means that the duplicate serial numbers are wrong. In this case, the duplicate serial number items corresponding to the duplicate serial numbers are determined from the warehouse item management database, and then the serial numbers corresponding to the duplicate serial number items in the warehouse item management database are verified to be correct. If there is an error, the correct serial number corresponding to the duplicate serial number item is obtained, and then the serial number corresponding to the duplicate serial number item in the warehouse item management database is changed using the obtained correct serial number.

[0094] For example, if there are two duplicate entry serial numbers, determine that the two entry serial numbers correspond to item 1 and item 2 respectively, then check whether the serial number corresponding to item 1 in the warehouse item management database is incorrect, and check whether the serial number corresponding to 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 of item 1 and use the correct serial number of item 1 to replace the incorrect serial number of item 1 in the warehouse item management database.

[0095] In the disclosed embodiment, after obtaining one or more storage serial numbers, the obtained storage serial numbers can be checked for duplication to obtain duplicate serial numbers, and then the re-read serial numbers can be checked to obtain the incorrect serial numbers, and finally the incorrect serial numbers can be changed. In this way, the incorrect serial numbers in the storage serial numbers can be quickly obtained and changed, so that the serial number error rate can be reduced, and the efficiency of item out of the warehouse can be improved.

[0096] Figure 6 FIG. 1 is a flowchart of a warehouse data processing method according to another exemplary embodiment. Figure 6 As shown, the warehouse data processing method may include the following steps.

[0097] Step S601: Acquire detection parameter information of items in the warehouse, and generate serial number detection rules of the items and scheduled detection tasks corresponding to the serial number detection rules according to the detection parameter information.

[0098] The detection parameter information includes one or more of the following options: supplier information corresponding to the item, item level information, item classification information, item coding information, item storage location information, and item storage time information. The serial number detection rule includes the detection parameter information, and the scheduled detection task includes the operation cycle of the serial number detection rule.

[0099] Step S602: according to the operation cycle of the serial number detection rule, a traversal query is periodically performed in the warehouse item management database to determine the items to be detected that meet the detection parameter information, and obtain the storage serial number of the items to be detected.

[0100] Therein, the number of objects to be inspected that meet the inspection parameter information is one or more, and the number of storage serial numbers obtained is one or more.

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

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

[0103] Step S605: Execute the sequence number change task through the above steps S241 to S243 to change the abnormal sequence number to the target sequence number, that is, the correct sequence number.

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

[0105] In addition, after step S602, the above steps S501 to S504 can also be executed to check one or more incoming serial numbers for duplication, obtain duplicate serial numbers, and then verify the reread serial numbers to obtain the incorrect serial numbers, and finally change the incorrect serial numbers. If the abnormal items corresponding to the abnormal serial numbers are determined according to the serial number change task, then steps S603 to S605 are executed. In this case, before executing steps S603 to S605, the reread serial numbers can be deleted from one or more incoming serial numbers.

[0106] Figure 7 FIG. 1 is a block diagram of a warehouse data processing device according to an exemplary embodiment. Figure 7As shown, the warehouse data processing device 700 includes a detection rule and task generation module 710, a storage serial number acquisition module 720, a storage serial number verification module 730 and a storage serial number change module 740.

[0107] Among them, the detection rule and task generation module 710 can be used to: obtain the detection parameter information of the items in the warehouse, and generate the serial number detection rules of the items and the scheduled detection tasks corresponding to the serial number detection rules according to the detection parameter information; the incoming serial number acquisition module 720 can be used to: execute the scheduled detection tasks, perform traversal queries in the warehouse item management database at regular intervals, and obtain the incoming serial numbers of the items to be detected that meet the serial number detection rules; the incoming serial number verification module 730 can be used to: verify the incoming serial numbers of the items to be detected, obtain the abnormal serial numbers in the incoming serial numbers, and generate the serial number change tasks corresponding to the abnormal serial numbers; the incoming serial number change module 740 can be used to: execute the serial number change tasks, 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.

[0108] In an optional embodiment of the present disclosure, the serial number detection rule includes detection parameter information, and the scheduled detection task includes the operation cycle of the serial number detection rule; wherein the entry serial number acquisition module 720 is also used to: according to the operation cycle of the serial number detection rule, regularly traverse and query the warehouse item management database to determine the items to be detected that meet the detection parameter information, and obtain the entry serial numbers of the items to be detected.

[0109] In an optional embodiment of the present disclosure, the detection parameter information includes one or more of the following options: supplier information corresponding to the item, item level information, item classification information, item coding information, item storage location information, and item storage time information.

[0110] In an optional embodiment of the present disclosure, the incoming serial number verification module 730 is further used to: obtain the serial number verification rule corresponding to the item to be detected; verify the incoming serial number using the serial number verification rule corresponding to the item to be detected; if the verification fails, determine that the incoming serial number is an abnormal serial number.

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

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

[0113] In an optional embodiment of the present disclosure, the number of the storage serial number is one or more. Figure 7 The device 700 shown also includes an incoming serial number duplicate checking module 750, which is used to: check one or more incoming serial numbers for duplicates, and obtain duplicate serial numbers in one or more incoming serial numbers; determine the duplicate serial number items corresponding to the duplicate serial numbers; verify whether the incoming serial numbers corresponding to the duplicate serial number items 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 incoming serial number corresponding to the duplicate serial number item in the warehouse item management database.

[0114] Regarding the device in the above embodiment, the specific manner in which each module performs operations has been described in detail in the embodiment of the method, and will not be elaborated here.

[0115] Figure 8 is a structural block diagram of an electronic device according to an exemplary embodiment. Figure 8 800 according to this embodiment of the present disclosure is described. Figure 8 The electronic device 800 shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

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

[0117] The storage unit stores program codes, which can be executed by the processing unit 810, so that the processing unit 810 performs the steps according to various exemplary embodiments of the present disclosure described in the above “Exemplary Method” section of this specification. For example, the processing unit 810 can perform the following steps: Figure 2 Follow the steps shown in .

[0118] The 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, such program modules 825 including but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment.

[0120] Bus 830 may represent one or more of several types of bus structures, including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or a local bus using any of a variety of bus architectures.

[0121] The electronic device 800 may also communicate with one or more external devices 870 (e.g., keyboards, pointing devices, Bluetooth devices, etc.), may also communicate with one or more devices that enable a user to interact with the electronic device 800, and may communicate with any device that enables the electronic device 800 to communicate with one or more other computing devices (e.g., routers, modems, etc.). Such communication may be performed via an input / output (I / O) interface 850. Furthermore, the electronic device 800 may also communicate with one or more networks (e.g., local area networks (LANs), wide area networks (WANs), and public networks, such as the Internet) via a network adapter 860. As shown, the network adapter 860 communicates with other modules of the electronic device 800 via a bus 830. It should be understood that, although not shown in the figure, other hardware and software modules may be used in conjunction with the 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, etc.

[0122] Through the description of the above embodiments, it is easy for those skilled in the art to understand that the example embodiments described here can be implemented by software, or by software combined with necessary hardware. Therefore, the technical solution according to the embodiment of the present disclosure can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a USB flash drive, a mobile hard disk, etc.) or on a network, and includes several instructions to enable a computing device (which can be a personal computer, a server, a terminal device, or a network device, etc.) to execute the method according to the embodiment of the present disclosure.

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

[0124] In an exemplary embodiment, a computer program product is also provided, including a computer program and instructions. When the computer program and the instructions are executed by a processor, the online file processing method in the above embodiment is implemented.

[0125] Those skilled in the art will readily appreciate other embodiments of the present disclosure after considering the specification and practicing the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the present disclosure that follow the general principles of the present disclosure and include common knowledge or customary techniques in the art that are not disclosed in the present disclosure. The specification and examples are intended to be exemplary only, and the true scope and spirit of the present disclosure are indicated by the following claims.

[0126] It should be understood that the present disclosure is not limited to the exact structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A warehouse data processing method, characterized in that: include: Acquire detection parameter information of items in the warehouse, and generate serial number detection rules for the items and scheduled detection tasks corresponding to the serial number detection rules according to the detection parameter information; Execute the scheduled detection task, perform traversal query in the warehouse item management database at regular intervals, and obtain the storage serial numbers of the items to be detected that meet the serial number detection rules; Verify the storage serial number of the item to be detected, obtain abnormal serial numbers in the storage serial numbers, and generate a serial number change task corresponding to the abnormal serial number; 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.

2. The method according to claim 1, characterized in that: The sequence number detection rule includes the detection parameter information, and the scheduled detection task includes the operation cycle of the sequence number detection rule; The executing of the timed detection task, performing a traversal query in the warehouse item management database at a regular interval, and obtaining the storage serial number of the item to be detected that meets the serial number detection rule, includes: According to the operation cycle of the serial number detection rule, a traversal query is periodically performed in the warehouse item management database to determine the items to be detected that meet the detection parameter information, and obtain the storage serial number of the items to be detected.

3. The method according to claim 2, characterized in that 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 coding information, item storage location information, and item storage time information.

4. The method according to claim 1, characterized in that: The step of verifying the storage serial numbers of the items to be detected to obtain abnormal serial numbers in the storage serial numbers includes: Obtaining a serial number verification rule corresponding to the item to be detected; Verify the storage serial number using the serial number verification rule corresponding to the item to be detected; If the verification fails, it is determined that the storage serial number is an abnormal serial number.

5. The method according to claim 4, characterized in that The obtaining of the serial number verification rule corresponding to the object to be detected includes: Obtaining a serial number verification rule corresponding to the item to be detected from a warehouse item management system, or generating a serial number verification rule corresponding to the item to be detected; The serial number verification rule corresponding to the item to be detected includes one or more of the following options: verification of serial number length information, verification of character type information contained in the serial number, verification of serial number prefix information, verification of serial number suffix information, and verification of serial number characteristic character information.

6. The method according to claim 1, characterized in that The executing the serial number changing task, obtaining the target serial number corresponding to the abnormal serial number, and updating the abnormal serial number in the warehouse item management database by using the target serial number, comprises: Execute the serial number change task to determine the abnormal serial number item corresponding to the abnormal serial number; Verify whether the warehouse serial number corresponding to the item with abnormal serial number in the warehouse item management database is correct; If so, the target serial number corresponding to the item with the abnormal serial number is obtained, and the acquired target serial number is used to change the storage serial number corresponding to the item with the abnormal serial number in the warehouse item management database.

7. The method according to any one of claims 1 to 6, characterized in that: The number of the storage serial numbers is one or more; Wherein, the method further comprises: Performing a duplicate check on one or more of the incoming serial numbers to obtain duplicate serial numbers in the one or more incoming serial numbers; Determine the duplicate serial number item corresponding to the duplicate serial number; Verify whether the serial numbers of the items with duplicate serial numbers in the warehouse item management database are correct; If so, the correct serial number corresponding to the item with the duplicate serial number is obtained, and the obtained correct serial number is used to change the storage serial number corresponding to the item with the duplicate serial number in the warehouse item management database.

8. A warehouse data processing device, characterized in that: include: A detection rule and task generation module, used to obtain detection parameter information of items in the warehouse, and generate serial number detection rules of items and scheduled detection tasks corresponding to the serial number detection rules according to the detection parameter information; The module for acquiring the incoming serial number is used to execute the timed detection task, perform a traversal query in the warehouse item management database at regular intervals, and obtain the incoming serial number of the item to be detected that meets the serial number detection rule; The storage serial number verification module is used to verify the storage serial number of the item to be detected, obtain the abnormal serial number in the storage serial number, and generate the serial number change task corresponding to the abnormal serial number; The incoming serial number changing module is used to execute the serial number changing 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.

9. A computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the warehouse data processing method according to any one of claims 1 to 7.

10. An electronic device, characterized in that: include: processor; and a memory for storing executable instructions for the processor; Wherein, the processor is configured to execute the warehouse data processing method as described in any one of claims 1 to 7 by executing the executable instructions.

Images