Intelligent order auditing method and device and medium

Abstract

The invention discloses an intelligent order auditing method and device and a medium, and relates to the field of e-commerce order auditing, and the method comprises the steps: screening out a plurality of target orders from an order set based on a preset intelligent auditing rule table; the preset intelligent auditing rule table comprises a user operation authority rule; sorting the plurality of target orders based on a preset reservation rule table; for the plurality of sorted target orders, sequentially executing the following operations from front to back: determining warehouses corresponding to the target orders according to a preset warehouse dividing rule table; according to the inventory data in the warehouse, carrying out inventory allocation on the target order to obtain an allocation result; when the distribution result is that distribution succeeds, the target order is audited, and an audit result is obtained; the auditing result is that the auditing is passed or not passed. According to the invention, reasonable order auditing can be automatically carried out.

Description

Technical Field

[0001] The present invention relates to the field of e-commerce order review, and in particular to an intelligent order review method, device and medium. Background Art

[0002] Traditional order review has the following problems: 1) Large-volume orders require multiple operations to complete the review; 2) The order of order review depends on the order of operations. Post-payment orders may be reviewed and sent to the warehouse for shipment first, which is not a reasonable order; 3) Pre-sale orders have not yet reached the delivery time, but because they occupy the inventory of spot orders, they are shipped first, which may cause dissatisfaction among buyers. Summary of the invention

[0003] The purpose of the present invention is to provide an intelligent order review method, device and medium, which perform order inventory queuing reservation and can automatically perform reasonable order review.

[0004] To achieve the above object, the present invention provides the following solutions:

[0005] In a first aspect, the present invention provides an intelligent order review method, comprising:

[0006] Obtain the preset intelligent review rule table, preset reservation rule table and preset warehouse sub-warehouse rule table;

[0007] Based on the preset intelligent review rule table, multiple target orders are screened out from the order set; the preset intelligent review rule table includes user operation authority rules;

[0008] Based on the preset reservation rule table, sorting multiple target orders;

[0009] For the sorted multiple target orders, perform the following operations from front to back:

[0010] Determine the warehouse corresponding to the target order according to the preset warehouse division rule table;

[0011] According to the inventory data in the warehouse, inventory is allocated for the target order to obtain an allocation result; when the allocation result is a successful allocation, it indicates that the warehouse has stock; when the allocation result is a failed allocation, it indicates that the warehouse is out of stock;

[0012] When the allocation result is successful, the target order is reviewed and a review result is obtained; the review result is either passed or failed.

[0013] Optionally, the orders in the order set are all paid but unshipped orders; the target order is an order for which the object currently performing the review operation has operation authority;

[0014] The user operation authority rule indicates whether the user has the authority to operate the order.

[0015] Optionally, the rule fields in the preset reservation rule table include one or more of whether to reserve inventory, spot order priority, pre-sale order priority, store / distributor priority, order label priority, payment time and planned delivery time.

[0016] Optionally, when the target order is reviewed, the object performing the review operation is a user or a scheduled review task.

[0017] Optionally, the preset intelligent review rule table, preset reservation rule table and preset warehouse sub-warehouse rule table corresponding to different merchants are all different.

[0018] Optionally, the method further comprises:

[0019] Paginate the sorted multiple target orders based on the preset paging size;

[0020] When any target order on a page is reviewed and the review result is passed, a delivery order is generated;

[0021] If negative inventory exists when performing inventory deduction based on multiple 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 quantity of the target order in the current page, and reallocate it to obtain the allocation result.

[0022] Optionally, the method further comprises:

[0023] Save order review monitoring logs asynchronously.

[0024] In a second aspect, the present invention further provides a computer device, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the intelligent order review method.

[0025] In a third aspect, the present invention further provides a computer-readable storage medium having a computer program stored thereon, which implements an intelligent order review method when executed by a processor.

[0026] According to the specific embodiments provided by the present invention, the present invention discloses the following technical effects: the present invention first obtains a preset intelligent review rule table, a preset reserved rule table and a preset warehouse division rule table. These three rule tables all support custom settings, realize personalized process customization and provide a data basis for the subsequent order review automation. Then, the orders are screened according to the preset intelligent review rule table, and the orders are sorted according to the preset reserved rule table. Since the inventory queuing mechanism is integrated, it can intelligently help merchants solve the problem of the order of inventory allocation, making the review order more reasonable. For multiple target orders after sorting, warehouse division is first performed according to the preset warehouse division rule table, and then inventory is allocated for the orders. When the allocation is successful, the order is reviewed and the review results are obtained. The present invention solves the problem of multiple clicks for large-volume orders. It only needs one-click start to automatically execute the subsequent order review steps, optimizing the merchant review process. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0028] Figure 1 The figure is a flow chart of the intelligent order review method of the present invention. DETAILED DESCRIPTION

[0029] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0030] The purpose of the present invention is to provide an intelligent order review method, device and medium, which can perform order inventory queuing reservation and automatically process order review operations through user-configured intelligent review rules and inventory reservation rules.

[0031] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, the present invention is further described in detail below with reference to the accompanying drawings and specific embodiments.

[0032] Example 1

[0033] like Figure 1 As shown, the present invention provides an intelligent order review method, comprising:

[0034] Step 100, obtain the preset intelligent review rule table, the preset reservation rule table and the preset warehouse sub-rule table.

[0035] The preset intelligent review rule table, preset reserved rule table and preset warehouse rule table corresponding to different merchants are different and can be adjusted as needed. A merchant can have multiple rules in the preset intelligent review rule table.

[0036] Step 200, based on the preset intelligent review rule table, multiple target orders are screened out from the order set; the preset intelligent review rule table includes user operation authority rules. Among them, the orders in the order set are all paid but unshipped orders; the target orders are orders for which the object currently performing the review operation has operation authority. In other words, the target orders are orders that can be reviewed or orders that need to reserve inventory, and the orders that can be reviewed are generally: not pre-sent and waiting for electronic waybills, or the current user has the order authority, or the order meets the intelligent review rules.

[0037] The user operation authority rule indicates whether the user has the operation authority for the order. For example, some merchants configure the authority according to the store or distributor of the order, and a certain user can only view the orders of these stores or distributors.

[0038] Step 300, based on the preset reservation rule table, multiple target orders are sorted; that is, the inventory reservation order queuing sub-process can be entered at this time. In a specific practical application, the operation corresponding to the sorting is to load all the paid but unshipped target orders.

[0039] Because orders can be split / merged, it is more accurate to queue according to the details. Based on this, the present invention queues the order details according to the configuration of inventory reservation (i.e., the preset reservation rule table). Among them, the rule fields in the preset reservation rule table include one or more of whether to reserve inventory, spot order priority, pre-sale order priority, store / distributor priority, order tag priority, payment time and planned delivery time.

[0040] Step 400: for the sorted target orders, perform the following operations in order from front to back:

[0041] (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 (MultipleWarehouseRule). Because the inventory is in the warehouse dimension, the warehouse needs to be calculated before allocating the inventory.

[0042] (402) Based on the inventory data in the warehouse, inventory is allocated for the target order to obtain an allocation result; when the allocation result is a successful allocation, it indicates that the warehouse is in stock; when the allocation result is a failed allocation, it indicates that the warehouse is out of stock. At this time, there is no need to judge the inventory again through the audit logic, thereby improving performance.

[0043] Specifically, the inventory is allocated according to the order of the details, and the actual inventory is allocated according to the inventory that should be occupied by the details. The inventory is deducted in the memory. The inventory in the database may have changed during the execution process. This step is just to pre-allocate the inventory in the memory. The audit logic will verify the inventory table when the inventory is put into the warehouse. For example, when the payment time in the order details is used as the sorting basis and multiple orders are arranged from front to back, the order with the first payment time is deducted from the memory and the allocation result is obtained.

[0044] When the allocation result is successful, the corresponding target order can meet the following conditions at the same time: the current user has the operation authority and the order is in stock.

[0045] (403) When the allocation result is successful, the target order is reviewed and a review result is obtained; the review result is either passed or failed. After the review of one target order is completed, the next target order is reviewed in sequence until all target orders in the sequence are reviewed. In a specific practical application, in order to improve processing efficiency, multiple target orders can be reviewed simultaneously in batches.

[0046] In a specific example, the order review monitoring log is saved asynchronously. It should be noted that when the review is passed, the outbound order and the modification of the order status and the order operation log can be obtained at the same time. These are saved synchronously, so as to obtain the order review monitoring log for the overall intelligent order review.

[0047] In another specific example, when the target order is audited, the object performing the audit operation is a user or a scheduled audit task. When it is a user, the audit is started manually by clicking; when it is a scheduled audit task, the audit is automatically performed periodically.

[0048] In another application example, the method further includes:

[0049] (1) Based on the preset paging size, the sorted multiple target orders are paginated.

[0050] (2) When any target order on a page is reviewed and the review result is passed, a delivery order is generated.

[0051] (3) If negative inventory exists when performing inventory deduction based on multiple 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 quantity of the target order in the current page, and reallocate it to obtain an allocation result.

[0052] It should be noted that negative inventory may be only one product, while other products are in stock, so most of the orders in the current page are in stock and can be reviewed and approved. However, because the inventory is not allocated, it is unknown which order will be reduced and enter the out-of-stock state. Therefore, in the actual algorithm application, in the step of allocating inventory for the target order according to the inventory data in the warehouse, the target order to be reduced is determined, and then the quantity is reduced to obtain the allocation result again. In other words, if there is negative inventory, roll back the order review operation of the current page, reload the order and inventory data in the order collection, and during the loading process at this time, the number of loaded orders will be reduced, and re-allocation and review will be performed. In a specific practical application, the above re-review operation is performed up to 3 times.

[0053] The following is an application example of the present invention:

[0054] If there are two stores, namely store A and store B, and both store A and store B have 5 orders that have been paid but not shipped, the payment order is as follows: A1, A2, A3, B1, B2, B3, A4, A5, B4, B5. The operating user only has the authority of store B (corresponding to the authority determined by the user operation authority rules above); the merchant has configured reserved inventory, payment time sorting, and the intelligent review rules are configured with weight 0kg~2kg (corresponding to the rules in the preset reserved rule table above); order B1 has 3 items sku001, weight 3kg; other orders have only 1 item sku001, weight 1kg. There are a total of 10 sku001 stocks, and when they are allocated, order A5 has inventory, while B4 and B5 have no inventory.

[0055] Because there is no authority from store A, the five orders of store A are only responsible for occupying inventory (so far, the step of screening out multiple target orders from the order set based on the preset intelligent review rule table is completed, and the screened target orders are B1-B5); orders B1-B5 are processed in payment order. During the processing, because the weight of order B1 is 3kg and does not meet the intelligent review rule (0-2kg), the review will skip order B1, but the inventory of order B1 will still be reserved. The sorting step is completed, and the final sorting result is: B2, B3, B4, B5; in this example, the warehouse division step is skipped, and the inventory data in the warehouse is directly determined; B2 and B3 are allocated to inventory, so orders B2 and B3 are reviewed and approved, and orders B4 and B5 are out of stock; after orders B2 and B3 are reviewed and approved, the corresponding delivery orders and monitoring logs are directly generated.

[0056] Example 2

[0057] A computer device includes: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the intelligent order review method in Example 1.

[0058] Example 3

[0059] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the intelligent order review method in Example 1.

[0060] Example 4

[0061] A computer device, which may be a database. The computer device includes a processor, a memory, an input / output interface (I / O for short) and a communication interface. The processor, the memory and the input / output interface are connected via a system bus, and the communication interface is connected to the system bus via the input / output interface. The processor of the computer device is used to provide computing and control capabilities. 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 pending transactions. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal via a network connection. When the computer program is executed by the processor, the intelligent order review method in Example 1 is implemented.

[0062] 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 used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the object or fully authorized by all parties, and the collection, use and processing of relevant data need to comply with relevant laws, regulations and standards of relevant countries and regions.

[0063] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in 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 random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access 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 and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited thereto. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited thereto.

[0064] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0065] The principles and implementation methods of the present invention are described in this article using specific examples. The description of the above embodiments is only used to help understand the method and core idea of ​​the present invention. At the same time, for those skilled in the art, according to the idea of ​​the present invention, there will be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be understood as limiting the present invention.

Claims

1. An intelligent order review method, characterized in that: Methods include: Obtain the preset intelligent review rule table, preset reservation rule table and preset warehouse sub-warehouse rule table; Based on the preset intelligent review rule table, multiple target orders are screened out from the order set; The preset intelligent audit rule table includes user operation authority rules; Based on the preset reservation rule table, sorting multiple target orders; For the sorted multiple target orders, perform the following operations from front to back: Determine the warehouse corresponding to the target order according to the preset warehouse division rule table; According to the inventory data in the warehouse, inventory is allocated for the target order to obtain an allocation result; when the allocation result is a successful allocation, it indicates that the warehouse has stock; when the allocation result is a failed allocation, it indicates that the warehouse is out of stock; When the allocation result is successful, the target order is reviewed and a review result is obtained; the review result is either passed or failed.

2. The intelligent order review method according to claim 1 is characterized in that: The orders in the order set are all paid but unshipped orders; the target order is the order for which the object currently performing the review operation has the operation authority; The user operation authority rule indicates whether the user has the authority to operate the order.

3. The intelligent order review method according to claim 1 is characterized in that: The rule fields in the preset reservation rule table include one or more of whether to reserve inventory, spot order priority, pre-sale order priority, store / distributor priority, order label priority, payment time and planned delivery time.

4. The intelligent order review method according to claim 2 is characterized in that: When the target order is reviewed, the object performing the review operation is a user or a scheduled review task.

5. The intelligent order review method according to claim 1 is characterized in that: The preset intelligent review rule table, preset reservation rule table and preset warehouse rule table corresponding to different merchants are different.

6. The intelligent order review method according to claim 1 is characterized in that: The method also includes: Paginate the sorted multiple target orders based on the preset paging size; When any target order on a page is reviewed and the review result is passed, a delivery order is generated; If negative inventory exists when performing inventory deduction based on multiple 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 quantity of the target order in the current page, and reallocate it to obtain the allocation result.

7. The intelligent order review method according to claim 1 is characterized in that: The method also includes: Save order review monitoring logs asynchronously.

8. A computer device comprising: A memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the smart order review method according to any one of claims 1 to 7.

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

Images