Intelligent order review method, apparatus, and medium

Abstract

The present application relates to the technical field of electronic commerce order review. Disclosed are an intelligent order review method, an apparatus, and a medium. The method comprises: on the basis of a preset intelligent review rule table, singling out a plurality of target orders from an order set; sorting the plurality of target orders on the basis of a preset reservation rule table, and then successively executing the following operations from front to back: determining, on the basis of a preset warehouse allocation rule table, warehouses corresponding to the target orders, allocating stock to the target orders on the basis of inventory data in the warehouses and, when an allocation result indicates successful allocation, reviewing the target orders to obtain a review result, the review result being that the review has passed or the review has not passed. The present application can automatically and reasonably review orders.

Description

An intelligent order auditing method, device and medium

[0001] The present application claims priority to the Chinese patent application No. 202411044991.3, filed on July 31, 2024, and entitled "An intelligent order auditing method, device and medium", the whole content of which is incorporated herein by reference. TECHNICAL FIELD

[0002] The present application relates to the technical field of e-commerce order auditing, in particular to an intelligent order auditing method, device and medium. BACKGROUND

[0003] In some cases, the order auditing has the following problems: 1) A large number of orders need to be operated multiple times to complete the auditing; 2) The order auditing sequence depends on the operation sequence, and the order paid later may be audited first to the warehouse for delivery, which is not reasonable; 3) The pre-sale order has not reached the delivery time, and since it occupies the inventory of the stock order, it is delivered first, which may lead to the dissatisfaction of the buyer.

[0004] SUMMARY

[0005] The purpose of the present application is to provide an intelligent order auditing method, device and medium, which reserves order inventory queuing and can automatically perform reasonable order auditing.

[0006] To achieve the above purpose, the present application provides the following technical solutions:

[0007] In some embodiments, an intelligent order auditing method is introduced. The method includes obtaining a preset intelligent auditing rule table, a preset reservation rule table and a preset warehouse division rule table. The method further includes filtering a plurality of target orders from an order set based on the preset intelligent auditing rule table; the preset intelligent auditing rule table includes user operation permission rules. The method further includes sorting the plurality of target orders based on the preset reservation rule table. The method further includes performing the following operations in sequence from front to back for the sorted plurality of target orders: determining the warehouse corresponding to the target order according to the preset warehouse division rule table; allocating inventory for the target order according to the inventory data in the warehouse to obtain an allocation result; when the allocation result is allocation success, it represents that the warehouse has goods; when the allocation result is allocation failure, it represents that the warehouse is out of stock; when the allocation result is allocation success, the target order is audited to obtain an audit result; the audit result is audit pass or audit fail.

[0008] In some embodiments, a computer device is also introduced, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor executes the computer program to implement the intelligent order auditing method.

[0009] In some embodiments, a computer readable storage medium is also introduced, which stores a computer program, and the computer program is executed by a processor to implement the intelligent order auditing method.

[0010] According to the specific embodiments provided in the present application, the following technical effects are disclosed: firstly, the preset intelligent auditing rule table, the preset reservation rule table and the preset warehouse rule table are obtained, all of which support custom setting, realizing personalized process customization and providing data basis for subsequent order auditing automation. Then, order screening is performed according to the preset intelligent auditing rule table, and order sorting is performed according to the preset reservation rule table, and since the inventory queuing mechanism is integrated, the order of inventory allocation can be intelligently helped to solve the problem of the merchant, so that the auditing order is more reasonable. For the multiple target orders after sorting, the warehouse is divided according to the preset warehouse rule table, and then the inventory is allocated for the order, and when the allocation is successful, the order is audited and the auditing result is obtained. The present application solves the problem of multiple clicks of large batches of orders, and only needs one key to start, so that the subsequent order auditing steps can be automatically executed, and the merchant auditing process is optimized. BRIEF DESCRIPTION OF DRAWINGS

[0011] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the following will briefly introduce the drawings needed in the embodiments. Obviously, the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can also be obtained without creative labor.

[0012] Fig. 1 is a flowchart of an intelligent order auditing method according to one or more embodiments. DETAILED DESCRIPTION

[0013] The technical solutions in the embodiments of the present application will be described clearly and completely in the following with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only some embodiments of the present application, not all embodiments. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative labor are within the scope of protection of the present application.

[0014] The purpose of the present application is to provide an intelligent order auditing method, device and medium, which performs order inventory queuing reservation through user-configured intelligent auditing rules and inventory reservation rules, and automatically processes the auditing operation of the order.

[0015] In order to make the above objectives, characteristics and advantages of the present application more apparent, more comprehensible, the present application will be further described in detail below with reference to the drawings and specific embodiments.

[0016] In an exemplary embodiment, the intelligent order auditing method provided by the embodiments of the present application is shown in FIG. 1, which is executed by a computer device or a computer apparatus, specifically, can be executed by a terminal or a server alone or jointly. In the embodiments of the present application, the method comprises the following steps 100-400. In a specific application scenario, the terminal communicates with the server through a network. The data storage system stores the required preset intelligent auditing rule table, preset reservation rule table and preset warehouse rule table and other data. The data storage system can be set up alone, integrated on the server, or placed on the cloud or other servers. The terminal can send the preset intelligent auditing rule table, the preset reservation rule table and the preset warehouse rule table to the server, execute steps 100-400 on the server, obtain the final auditing result, and then feed back to the terminal, such as visual display on the terminal. The specific implementation content of each step is as follows.

[0017] Step 100, obtaining the preset intelligent auditing rule table, the preset reservation rule table and the preset warehouse rule table. The preset intelligent auditing rule table, the preset reservation rule table and the preset warehouse rule table corresponding to different merchants are different, and can also be adjusted as needed. There can be multiple rules in the preset intelligent auditing rule table of one merchant.

[0018] Step 200, based on the preset intelligent auditing rule table, filtering a plurality of target orders from the order set; the preset intelligent auditing rule table includes user operation permission rules. Among them, the orders in the order set are all paid but not shipped orders; the target order is an order that the current execution auditing operation object has operation permission, in other words, the target order is an order that can be audited or needs to reserve inventory, and the order that can be audited is generally: not pre-released waiting for electronic face sheet, or the current user has the order permission, or the order meets the intelligent auditing rule.

[0019] The user operation permission rule represents whether there is operation permission on the order, such as: some merchants configure permissions according to the shops or distributors of the order, and a certain user can only see the orders of these shops or distributors.

[0020] Step 300, based on the preset reservation rule table, sorting the plurality of target orders; that is, at this time, the inventory reservation order queuing sub-process can be entered. In a specific practical application, the sorting operation corresponds to loading all paid but not shipped target orders.

[0021] Because the order can be split / combined, the queuing according to the details is more accurate. Based on this, the application queues the order details according to the configuration of inventory reservation (i.e., the preset reservation rule table). The rule field in the preset reservation rule table includes one or more of whether to reserve inventory, priority of stock order, priority of pre-sale order, priority of shop / distributor, priority of order label, payment time, and planned shipping time.

[0022] Step 400, for the sorted multiple target orders, sequentially perform the following steps (401)-(403) from front to back.

[0023] (401) According to the preset warehouse rule table, determine the warehouse corresponding to the target order. Specifically, calculate the warehouse to which the order belongs according to the warehouse strategy (Multiple Warehouse Rule). Because the inventory is to the warehouse dimension, the warehouse needs to be calculated before the inventory is allocated.

[0024] (402) According to the inventory data in the warehouse, allocate the inventory for the target order to obtain an allocation result; when the allocation result is allocation success, it indicates that the warehouse has goods; when the allocation result is allocation failure, it indicates that the warehouse is out of stock, and at this time, there is no need to judge the inventory again through the audit logic, thereby improving the performance.

[0025] Specifically, allocate the inventory according to the queuing order of the details, allocate the actual inventory according to the inventory that should be occupied by the details, and deduct the inventory in the memory. During the execution process, the inventory in the database may have changed. This step only pre-allocates the inventory in the memory, and the logic of the audit will check the inventory table when the warehouse is dropped. For example, taking the payment time in the order details corresponding to the target order as the basis for sorting, arrange the multiple target orders from front to back, then sequentially perform the memory deduction, and obtain the allocation result. When the allocation result is allocation success, the corresponding target order can simultaneously satisfy: the current user has operation permission, and the order has inventory.

[0026] (403) When the allocation result is allocation success, audit the target order and obtain an audit result; the audit result is audit pass or audit fail. After completing the audit of one target order, audit the next target order in sequence until all target orders in the sequence are audited. In a specific actual application, in order to improve the processing efficiency, multiple target orders can be audited at the same time in batches.

[0027] In one specific example, the order audit monitoring log is saved in an asynchronous manner. It should be noted that the audit pass can obtain the warehouse-out order and the modification of the order state and the order operation log at the same time, which are saved synchronously, thereby obtaining the order audit monitoring log for the whole intelligent order audit.

[0028] In another specific example, when the target order is audited, the subject performing the auditing operation is a user or a timing auditing task. When it is a user, the user manually clicks to start the auditing; when it is a timing auditing task, the auditing is performed automatically periodically.

[0029] In another application example, the method further comprises the following three steps: 1) page the sorted plurality of target orders based on a preset page size. 2) when any target order in a page is audited and the result of the auditing is that the auditing is passed, generate a warehouse-out order. 3) if there is negative inventory when the inventory of the plurality of warehouse-out orders corresponding to the current page is deducted, return to the step of allocating the inventory for the target order based on the inventory data in the warehouse, reduce the number of target orders in the current page to re-allocate and obtain an allocation result.

[0030] It should be noted that the negative inventory may be only one product, and other products have inventory, so most of the orders in the current page have inventory and can pass the auditing. However, because the inventory is not allocated, it is not known which order to reduce to enter the out-of-stock state, so in the actual algorithm application, the target order to be reduced is determined in the step of allocating the inventory for the target order based on the inventory data in the warehouse, and then the number is reduced to obtain an allocation result again. Or, if there is negative inventory, the operation of auditing the orders in the current page is rolled back, and the orders and inventory data in the order set are reloaded. At this time, the number of orders loaded in the loading process is reduced, and the allocation and auditing are re-performed. In a specific actual application, the above re-auditing operation is performed at most 3 times.

[0031] The following is an application example of the present application: if there are two stores, store A and store B, and store A and store B both have 5 orders paid but not shipped, the payment order is as follows: A1, A2, A3, B1, B2, B3, A4, A5, B4, B5. The operation user only has the permission of store B (corresponding to the permission determined by the user operation permission rule above); the merchant configures reserved inventory, payment time order, and intelligent auditing rule configured with weight 0kg-2kg (corresponding to the rule in the preset reservation rule table above); order B1 has 3 products sku001, and the weight is 3kg; other orders all have only 1 product sku001, and the weight is 1kg. The total inventory of sku001 is 10, and when allocating, orders A1 to A5 all have inventory, and B4 and B5 do not have inventory.

[0032] Because there is no shop A permission, shop A 5 orders are only responsible for occupying inventory (so far, the step of filtering a plurality of target orders from the order set based on the preset intelligent audit rule table is completed, and the target orders filtered are B1-B5); processing orders B1-B5 in payment order, during processing, because the weight of order B1 is 3kg and does not meet the intelligent audit rule (0kg-2kg), the audit will skip order B1, but still reserve the inventory of order B1, thus completing the sorting step, and the final sorting result obtained is: B2, B3, B4, B5; In this example, the step of distributing the warehouse is skipped, and the inventory data in the warehouse is directly determined; B2, B3 are allocated to inventory, so that orders B2 and B3 pass the audit, and orders B4 and B5 enter the out-of-stock state; After orders B2 and B3 pass the audit, corresponding outbound orders and monitoring logs are directly generated.

[0033] In another exemplary embodiment, the present application provides a computer device, comprising: a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor executing the computer program to implement the intelligent order audit method described above.

[0034] In another exemplary embodiment, the present application also provides a computer readable storage medium having a computer program stored thereon, which is executed by a processor to implement the intelligent order audit method described above.

[0035] In another exemplary embodiment, the present application also provides a computer device, which can be a database. The computer device includes a processor, a memory, an input / output interface (I / O) and a communication interface. Wherein the processor, the memory and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. Wherein, the processor of the computer device is used to provide computing and control capability. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store transactions to be processed. The input / output interface of the computer device is used to exchange information between the processor and external devices. The communication interface of the computer device is used to communicate with external terminals through network connection. The computer program is executed by the processor to implement the intelligent order audit method in embodiment 1.

[0036] It should be noted that the object information (including but not limited to object device information, object personal information, etc.) and data (including but not limited to data for analysis, stored data, displayed data, etc.) involved in the present application are all information and data authorized by the object or fully authorized by all parties, and the collection, use and processing of related data need to comply with relevant laws, regulations and standards of the country and region.

[0037] It can be understood by those skilled in the art that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing related hardware through a computer program. The computer program can be stored in a non-volatile computer readable storage medium, and when executed, can include the processes of the above-mentioned embodiments. Any reference to memory, database or other medium used in the embodiments provided by the present application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration but not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM), etc. The database involved in the embodiments provided by the present application can include at least one of a relational database and a non-relational database. The non-relational database can include a distributed database based on a block chain, etc., without being limited thereto. The processor involved in the embodiments provided by the present application can be a general-purpose processor, a central processing unit, a graphics processing unit, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., without being limited thereto.

[0038] The technical features of the above embodiments can be combined arbitrarily. In order to make the description concise, not all possible combinations of the technical features in the above embodiments are described, but as long as the combinations of the technical features do not exist contradictory, they should be considered as the scope of the present application.

[0039] The principles and implementation manners of the present application are described herein by using specific examples, and the above examples are only used to help understand the method of the present application and its core idea; meanwhile, for those skilled in the art, according to the idea of the present application, the specific implementation manners and application ranges will have changes. In conclusion, the content of the specification should not be understood as a limitation of the present application.

Claims

1. An intelligent order review method, characterized in that, The method comprises: obtaining a preset intelligent audit rule table, a preset reservation rule table and a preset warehouse division rule table; based on the preset intelligent audit rule table, filtering a plurality of target orders from an order set; the preset intelligent audit rule table includes a user operation permission rule; based on the preset reservation rule table, sorting the plurality of target orders; for the sorted plurality of target orders, the following operations are sequentially executed from front to back: determining the warehouse corresponding to the target order according to the preset warehouse division rule table; based on the inventory data in the warehouse, performing inventory allocation for the target order to obtain an allocation result; when the allocation result is allocation success, it represents that the warehouse has goods; when the allocation result is allocation failure, it represents that the warehouse is out of stock; when the allocation result is allocation success, auditing the target order and obtaining an audit result; the audit result is audit pass or audit fail.

2. The intelligent order review method of claim 1, wherein, The orders in the order set are all paid orders that have not been shipped; the target order is an order that the object of the current audit operation has operation permission; the user operation permission rule represents whether there is operation permission for the order.

3. The intelligent order review method of claim 1, wherein, The rule field in the preset reservation rule table includes one or more of whether to reserve inventory, priority of ready-to-ship orders, priority of pre-sale orders, priority by store / distributor, order label priority, payment time and planned shipping time.

4. The intelligent order review method of claim 2, wherein, When auditing the target order, the object of the audit operation is a user or a timed audit task.

5. The intelligent order review method of claim 1, wherein, The preset intelligent audit rule table, the preset reservation rule table and the preset warehouse division rule table corresponding to different merchants are all different.

6. The intelligent order review method of claim 1, wherein, The method further comprises: based on a preset page size, paging the sorted plurality of target orders; when auditing any target order in a page and the audit result is audit pass, generating a delivery order; if there is negative inventory when performing inventory deduction according to the plurality of delivery orders corresponding to the current page, return to the step of allocating inventory for the target order based on the inventory data in the warehouse, reduce the number of target orders in the current page to perform allocation again to obtain an allocation result.

7. The intelligent order review method of claim 1, wherein, The method further comprises: saving order audit monitoring logs in an asynchronous manner.

8. A computer apparatus comprising: A memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor executes the computer program to implement the intelligent order audit method of any one of claims 1-7.

9. A computer-readable storage medium having stored thereon a computer program, characterized in that, The computer program is executed by the processor to implement the intelligent order audit method of any one of claims 1-7.

Images