Order processing method, device, computer system and readable storage medium

Abstract

The present disclosure provides an order processing method, including: obtaining an order detail table, wherein the order detail table includes multiple order records, each order record includes an order ID, a main product ID, and / or a package product ID associated with the main product, a transaction volume, and promotion information; according to the transaction volume in each order record, each order record is split into N sub-order records, wherein each sub-order record has a corresponding sub-order tag, and N is equal to the transaction volume in the order record; obtaining a delivery return sub-table, wherein the delivery return sub-table includes multiple delivery records, each delivery record includes a product serial number, an order ID, a main product ID, and a delivery record tag; and according to the sub-order tag of each sub-order record and the delivery record tag in each delivery record, determining the delivery record that matches each sub-order record. The present disclosure also provides an order processing device, a computer system, and a computer-readable storage medium.

Description

Technical Field

[0001] The present disclosure relates to the fields of computer technology, Internet technology, warehousing and logistics, and electronic technology, and more specifically, to an order processing method, device, computer system, and readable storage medium. Background Art

[0002] Electronic data interchange (EDI) refers to the transmission of standard economic information through a communication network in accordance with a set of universal standard formats, and the exchange and automatic processing of data between trading partners' electronic computer systems. EDI is not a simple data exchange between users. EDI users need to send information in accordance with the internationally accepted message format, and the recipient also needs to process the message in accordance with the internationally unified grammatical rules, and trigger EDI comprehensive processing in other related systems. The entire process is completed automatically without human intervention, which reduces errors and improves efficiency. Before converting the product order data into a universal standard format, it is necessary to associate the product promotion information in the order data with the serial number of the corresponding product in the logistics warehouse data.

[0003] In the process of realizing the concept of the present disclosure, the inventors found that there are at least the following problems in the related technology: in the process of associating the product promotion information in the order data with the serial number of the corresponding product in the material warehouse data, it is easy to have the problem of docking data anomalies, resulting in the inability to accurately obtain the associated information. Summary of the invention

[0004] In view of this, the present disclosure provides an order processing method, device, computer system and computer-readable storage medium.

[0005] One aspect of the present disclosure provides an order processing method, comprising: obtaining an order detail table, wherein the order detail table includes a plurality of order records, each of the plurality of order records including an order identifier, a main product identifier, and / or a package product identifier associated with the main product, a transaction volume, and promotion information;

[0006] According to the transaction amount in each order record, split each order record into N sub-order records, wherein each sub-order record has a corresponding sub-order tag, and N is equal to the transaction amount in the order record;

[0007] Obtaining a shipment return sub-table, wherein the shipment return sub-table includes a plurality of shipment records, each of the plurality of shipment records including a product serial number, an order identifier, a main product identifier, and a shipment record label; and

[0008] According to the sub-order tag of each sub-order record and the outbound record tag in each outbound record, the outbound record that matches each sub-order record is determined.

[0009] According to an embodiment of the present disclosure, after splitting each of the order records into N sub-order records, the method further includes:

[0010] Identify multiple sub-order records with the same order ID and main product ID; and

[0011] A sub-order tag is set for each of said sub-order records.

[0012] According to an embodiment of the present disclosure, setting a sub-order tag for each sub-order record includes:

[0013] sorting multiple sub-order records with the same order ID and main product ID; and

[0014] The sequence number obtained by sorting is used as the sub-order label of each of the sub-order records.

[0015] According to an embodiment of the present disclosure, splitting each order record into N sub-order records includes:

[0016] Convert the transaction amount in each of the order records into a separable string, wherein the transaction amount in the order record and the string length of the separable string are numerically the same; and

[0017] According to the length of the character string in each of the order records, each of the sub-order records is split into N sub-order records, where N is equal to the length of the character string.

[0018] According to an embodiment of the present disclosure, after determining the outbound record that matches each of the sub-order records, the method further includes:

[0019] The package product identifier associated with the main product in the sub-order record is filled back to replace the main product identifier.

[0020] According to an embodiment of the present disclosure, after the package product identifier associated with the main product in the sub-order record is backfilled to replace the main product identifier, the method further includes:

[0021] An order-and-delivery association table is generated according to each of the sub-order records and each delivery record that matches the sub-order record, wherein the order-and-delivery association table includes multiple order-and-delivery association records, and each of the multiple order-and-delivery association records includes an order ID, a main product ID, or a package product ID associated with the main product, a product serial number, and promotional information.

[0022] According to an embodiment of the present disclosure, the main product identifier and the package product identifier associated with the main product are product type identifiers.

[0023] Another aspect of the present disclosure provides an order processing device, comprising:

[0024] A first acquisition module is used to acquire an order detail table, wherein the order detail table includes a plurality of order records, and each of the plurality of order records includes an order identifier, a main product identifier, and / or a package product identifier associated with the main product, a transaction volume, and promotion information;

[0025] a splitting module, configured to split each order record into N sub-order records according to the transaction amount in each order record, wherein each sub-order record has a corresponding sub-order tag, and N is equal to the transaction amount in the order record;

[0026] A second acquisition module is used to acquire a shipment return sub-table, wherein the shipment return sub-table includes a plurality of shipment records, each of the plurality of shipment records includes a product serial number, an order identifier, a main product identifier and a shipment record label; and

[0027] A matching module is used to determine the outbound record that matches each sub-order record based on the sub-order tag of each sub-order record and the outbound record tag in each outbound record.

[0028] Another aspect of the present disclosure provides a computer-readable storage medium storing computer-executable instructions, which are used to implement the above method when executed.

[0029] Another aspect of the present disclosure provides a computer program, which includes computer executable instructions, and the instructions are used to implement the method described above when executed.

[0030] According to the embodiments of the present disclosure, each order record is split into N sub-order records according to the transaction volume in each order record, wherein each sub-order record has a corresponding sub-order tag; and each of the multiple outbound records in the outbound return sub-table includes an outbound record tag; and a technical means is used to determine the outbound record matching each sub-order record according to the sub-order tag of each sub-order record and the outbound record tag in each outbound record. Therefore, the technical problem of abnormality in matching the product promotion information in the order data with the serial number of the corresponding product in the material outbound data is at least partially overcome, thereby achieving the technical effect of accurately obtaining related information. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] The above and other objects, features and advantages of the present disclosure will become more apparent through the following description of the embodiments of the present disclosure with reference to the accompanying drawings, in which:

[0032] Figure 1 An exemplary system architecture to which the method and apparatus for order processing disclosed herein can be applied is schematically shown;

[0033] Figure 2 A flowchart of an order processing method according to an embodiment of the present disclosure is schematically shown;

[0034] Figure 3 A flowchart of splitting sub-order records according to an embodiment of the present disclosure is schematically shown;

[0035] Figure 4 A flowchart of an order processing method according to another embodiment of the present disclosure is schematically shown;

[0036] Figure 5 A flowchart of sub-order label setting according to an embodiment of the present disclosure is schematically shown;

[0037] Figure 6 A flowchart of an order processing method according to another embodiment of the present disclosure is schematically shown;

[0038] Figure 7 A block diagram schematically shows an order processing device according to an embodiment of the present disclosure; and

[0039] Figure 8 A block diagram of a computer system suitable for implementing an order processing method according to an embodiment of the present disclosure is schematically shown. DETAILED DESCRIPTION

[0040] Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. However, it should be understood that these descriptions are exemplary only and are not intended to limit the scope of the present disclosure. In the following detailed description, for ease of explanation, many specific details are set forth to provide a comprehensive understanding of the embodiments of the present disclosure. However, it is apparent that one or more embodiments may also be implemented without these specific details. In addition, in the following description, descriptions of known structures and technologies are omitted to avoid unnecessary confusion of the concepts of the present disclosure.

[0041] The terms used herein are only for describing specific embodiments and are not intended to limit the present disclosure. The terms "comprise", "include", etc. used herein indicate the existence of the features, steps, operations and / or components, but do not exclude the existence or addition of one or more other features, steps, operations or components.

[0042] All terms (including technical and scientific terms) used herein have the meanings commonly understood by those skilled in the art, unless otherwise defined. It should be noted that the terms used herein should be interpreted as having a meaning consistent with the context of this specification, and should not be interpreted in an idealized or overly rigid manner.

[0043] In the case of using expressions such as "at least one of A, B, and C, etc.", it should generally be interpreted in accordance with the meaning of the expression generally understood by those skilled in the art (for example, "a system having at least one of A, B, and C" should include but is not limited to a system having A alone, B alone, C alone, A and B, A and C, B and C, and / or A, B, C, etc.). In the case of using expressions such as "at least one of A, B, or C, etc.", it should generally be interpreted in accordance with the meaning of the expression generally understood by those skilled in the art (for example, "a system having at least one of A, B, or C" should include but is not limited to a system having A alone, B alone, C alone, A and B, A and C, B and C, and / or A, B, C, etc.).

[0044] With the popularization and application of e-commerce on the Internet, enterprises can automatically transmit documents such as orders, delivery notes, invoices, etc. to partners through communication networks. The information development of enterprises has expanded from within the enterprise to industry partners. In order to reduce communication costs, realize data sharing, improve terminal sales efficiency and incentivize the accuracy of settlement data, the sales platform needs to connect and share data with each store merchant on the sales situation of the products sold. The shared data generally includes IMEI (International Mobile Equipment Identity) level data of warehouse purchase / sales / adjustment, as well as sales prices, promotional information and serial numbers of corresponding products.

[0045] However, in the process of implementing the present disclosure, the inventors discovered that when associating order data containing sales prices and promotional information with logistics warehouse data containing product serial numbers, a many-to-many association would occur, resulting in a mismatch with reality and abnormal docking data.

[0046] The embodiment of the present disclosure provides an order processing method, device, computer system and computer-readable storage medium. The method includes obtaining an order detail table, wherein the order detail table includes multiple order records, each of the multiple order records includes an order ID, a main product ID, and / or a package product ID associated with the main product, a transaction volume and promotion information; according to the transaction volume in each order record, each order record is split into N sub-order records, wherein each sub-order record has a corresponding sub-order tag, and N is equal to the transaction volume in the order record; obtaining a delivery return sub-table, wherein the delivery return sub-table includes multiple delivery records, each of the multiple delivery records includes a product serial number, an order ID, a main product ID and a delivery record tag; and according to the sub-order tag of each sub-order record and the delivery record tag in each delivery record, determining the delivery record that matches each sub-order record.

[0047] Figure 1 The exemplary system architecture 100 to which the order processing method and apparatus according to the embodiment of the present disclosure can be applied is schematically shown. It should be noted that: Figure 1 What is shown is merely an example of a system architecture to which the embodiments of the present disclosure can be applied, in order to help those skilled in the art understand the technical content of the present disclosure, but it does not mean that the embodiments of the present disclosure cannot be used in other devices, systems, environments or scenarios.

[0048] like Figure 1 As shown, the system architecture 100 according to this embodiment may include terminal devices 101, 102, 103, a network 104 and a server 105. The network 104 is used to provide a medium for communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired and / or wireless communication links, etc.

[0049] Users can use terminal devices 101, 102, 103 to interact with server 105 through network 104 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 101, 102, 103, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients and / or social platform software, etc. (only as examples).

[0050] The terminal devices 101 , 102 , and 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, and desktop computers.

[0051] The server 105 may be a server that provides various services, such as a background management server (only an example) that provides support for websites browsed by users using the terminal devices 101, 102, and 103. The background management server may analyze and process the received data such as user requests, and feed back the processing results (such as web pages, information, or data obtained or generated according to user requests) to the terminal device.

[0052] It should be noted that the order processing method provided in the embodiment of the present disclosure can generally be executed by the server 105. Accordingly, the order processing device provided in the embodiment of the present disclosure can generally be set in the server 105. The order processing method provided in the embodiment of the present disclosure can also be executed by a server or server cluster that is different from the server 105 and can communicate with the terminal devices 101, 102, 103 and / or the server 105. Accordingly, the order processing device provided in the embodiment of the present disclosure can also be set in a server or server cluster that is different from the server 105 and can communicate with the terminal devices 101, 102, 103 and / or the server 105. Alternatively, the order processing method provided in the embodiment of the present disclosure can also be executed by the terminal devices 101, 102, or 103, or can also be executed by other terminal devices different from the terminal devices 101, 102, or 103. Accordingly, the order processing device provided in the embodiment of the present disclosure can also be set in the terminal devices 101, 102, or 103, or can be set in other terminal devices different from the terminal devices 101, 102, or 103.

[0053] For example, the order details table and the outbound return sub-table may be originally stored in any one of the terminal devices 101, 102, or 103 (for example, the terminal device 101, but not limited thereto), or stored in an external storage device and may be imported into the terminal device 101. Then, the terminal device 101 may locally execute the order processing method provided by the embodiment of the present disclosure, or send the pending order details table and the outbound return sub-table to other terminal devices, servers, or server clusters, and the order processing method provided by the embodiment of the present disclosure may be executed by other terminal devices, servers, or server clusters that receive the pending order details table and the outbound return sub-table.

[0054] It should be understood that Figure 1 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.

[0055] Figure 2 The flowchart of the order processing method according to the embodiment of the present disclosure is schematically shown.

[0056] It should be noted that, unless it is explicitly stated that there is a sequence of execution between different operations shown in the flowchart in the embodiments of the present disclosure, or there is a sequence of execution between different operations in technical implementation, otherwise, the execution order of multiple operations may not be prioritized, and multiple operations may also be executed simultaneously.

[0057] like Figure 2 As shown, the method includes operations S210 to S240.

[0058] In operation S210, an order details table is obtained, wherein the order details table includes multiple order records, each of the multiple order records includes an order ID, a main product ID, and / or a package product ID associated with the main product, a transaction volume, and promotion information.

[0059] In operation S220, each order record is split into N sub-order records according to the transaction volume in each order record, wherein each sub-order record has a corresponding sub-order tag, and N is equal to the transaction volume in the order record.

[0060] In operation S230, a delivery return sub-table is obtained, wherein the delivery return sub-table includes a plurality of delivery records, and each of the plurality of delivery records includes a product serial number, an order identifier, a main product identifier, and a delivery record label.

[0061] In operation S240, the outbound record that matches each sub-order record is determined based on the sub-order tag of each sub-order record and the outbound record tag in each outbound record.

[0062] According to an embodiment of the present disclosure, Table 1 schematically shows an order details table of an embodiment of the present disclosure. As shown in Table 1, the order details table may be a statistics of information such as transaction volume and sales price for multiple products within a period of time; wherein the identifier may be a number, a QR code or other uniquely identifiable identifier. The main product may be a single product such as an electronic product, a book, clothing or food; the set product associated with the main product may be a set of a single product such as an electronic product, a book, clothing or food and another related product sold together with the single product.

[0063] More specifically, for example, the main product may be a mobile phone, and the package product associated with the main product may be a combination package of a mobile phone and earphones, or a combination package of a mobile phone and a mobile phone case, etc.

[0064] In actual operation, the main product and the package product associated with the main product can participate in different promotion activities. The package product identifier associated with the main product includes the same character field as the main product identifier.

[0065] Table 1

[0066] Order ID Main product logo Package product logo Trading Volume Promotional Information Order-1 Sku-1 Virtual-sku-1 2 ** Order-1 Sku-1 3 *** Order-2 Sku-1 2 *

[0067] According to an embodiment of the present disclosure, Table 2 schematically shows a dispatch return sub-table of an embodiment of the present disclosure. As shown in Table 2, the dispatch record in the dispatch return sub-table only records the main product identifier, that is, the main product identifier recorded in the dispatch record may represent the main product or a package product associated with the main product; the dispatch record cannot truly reflect the actual situation of the dispatched product.

[0068] Table 2

[0069] Product serial number Order ID Main product logo Serial-1 Order-1 Sku-1 Serial-2 Order-1 Sku-1 Serial-3 Order-1 Sku-1 Serial-4 Order-1 Sku-1 Serial-5 Order-1 Sku-1 Serial-6 Order-2 Sku-1 Serial-7 Order-2 Sku-1

[0070] Therefore, in the actual order processing process, when there are multiple outbound shipment records with the same order ID and the same main product ID, if the order records in the order details table are directly associated with the outbound shipment records in the outbound return sub-table based on the order ID and the main product ID, a many-to-many situation will appear in the docking data, which does not match the actual sales situation and the docking data is abnormal.

[0071] According to the embodiment of the present disclosure, the corresponding sub-order tag in each sub-order record becomes another identifier that distinguishes it from other sub-order records; and the outbound record tag in the outbound record also becomes another identifier that distinguishes it from other outbound records. Therefore, according to the sub-order tag of each sub-order record and the outbound record tag in each outbound record, it is possible to achieve one-to-one docking of each sub-order record with each outbound record, determine the outbound record that matches each sub-order record, and avoid many-to-many data docking.

[0072] Reference below Figure 3 to Figure 6 , combined with specific embodiments Figure 2 The method shown is further explained.

[0073] Figure 3 The flowchart of splitting sub-order records according to an embodiment of the present disclosure is schematically shown.

[0074] like Figure 3 As shown, splitting each order record into N sub-order records includes operations S221 to S222. Among them:

[0075] In operation S221, the transaction amount in each order record is converted into a separable character string, wherein the transaction amount in the order record and the character string length of the separable character string are numerically the same.

[0076] In operation S222, each sub-order record is split into N sub-order records according to the length of the character string in each order record, where N is equal to the length of the character string.

[0077] According to an embodiment of the present disclosure, the transaction volume in each order record is converted into a splittable string, but it is not limited thereto, and can also be any identifier that can identify its transaction volume. In an embodiment of the present disclosure, the splittable string is set according to a user defined function UDF (User defined function).

[0078] According to an embodiment of the present disclosure, according to the length of the string in each order record, the EXPLODE function and / or the SPLIT function are used to split the separable string, and each sub-order record is split into N sub-order records, where N is equal to the string length. The EXPLODE function and / or the SPLIT function can be a custom splitting function.

[0079] According to an embodiment of the present disclosure, Table 3 schematically shows an order detail table that converts the transaction volume in Table 1 into a splittable string. As shown in Table 3, after operations S221 to S222, each sub-order record in Table 1 is successfully and accurately split into N sub-order records, where N is equal to the string length.

[0080] Table 3

[0081]

[0082] Figure 4 The flowchart of an order processing method according to another embodiment of the present disclosure is schematically shown.

[0083] like Figure 4 As shown, after each order record is split into N sub-order records, the order processing method further includes operations S410 to S420. In this embodiment, in addition to operations S410 to S420, operations S210 to S240 are also included. For descriptions of operations S210 to S240, reference can be made to the above Figure 2 The description in will not be repeated here.

[0084] In operation S410, a plurality of sub-order records having the same order ID and main product ID are determined.

[0085] In operation S420, a sub-order tag is set for each sub-order record.

[0086] According to an embodiment of the present disclosure, after obtaining the outbound return sub-table, an outbound record tag may also be set for each outbound record. For example, multiple outbound records with the same order ID and main product ID are first determined, and then an outbound record tag is set for each outbound record.

[0087] Based on the above operations, it is helpful to determine the outbound record matching each sub-order record according to the sub-order tag of each sub-order record and the outbound record tag in each outbound record. It is not only convenient to process, but also helpful to improve the accuracy and efficiency of data docking.

[0088] Figure 5 A flowchart for setting sub-order labels according to an embodiment of the present disclosure is schematically shown.

[0089] like Figure 5 As shown, setting a sub-order label for each sub-order record includes operations S421 to S422.

[0090] In operation S421, multiple sub-order records with the same order ID and main product ID are sorted.

[0091] In operation S422, the sorted serial number is used as the sub-order label of each sub-order record.

[0092] According to an embodiment of the present disclosure, Table 4 schematically shows an order detail table after Table 3 is set with an order sub-record tag. As shown in Table 4, operation S410 is combined with operations S421 to S422 to become a preferred implementation. That is, after determining multiple sub-order records with the same order identifier and main product identifier, the sequence number obtained by sorting is used as the sub-order tag of each sub-order record, making the sub-order tag setting operation convenient and simple.

[0093] Table 4

[0094]

[0095] According to an embodiment of the present disclosure, setting a shipment record label for each shipment record may also include: sorting multiple shipment records with the same order identifier and main product identifier, and using the sorted serial number as the shipment record label for each shipment record.

[0096] Table 5 schematically shows the outbound return table after the outbound record label is set according to Table 2. As shown in Table 5, the outbound record label is set in the same way as the sub-order label, which is conducive to the subsequent connection between the outbound record label and the sub-order label.

[0097] Table 5

[0098] Product serial number Order ID Main product logo Outbound record label Serial-1 Order-1 Sku-1 1 Serial-2 Order-1 Sku-1 2 Serial-3 Order-1 Sku-1 3 Serial-4 Order-1 Sku-1 4 Serial-5 Order-1 Sku-1 5 Serial-6 Order-2 Sku-1 6 Serial-7 Order-2 Sku-1 7

[0099] According to the embodiment of the present disclosure, the sub-order label is not limited to the serial number, and can also be any barcode, QR code, etc. that the user can accept. However, according to the embodiment of the present disclosure, the selection of the serial number is more intuitive and easy to read, making the order processing simple and effective.

[0100] Figure 6 An order processing method according to another embodiment of the present disclosure is schematically illustrated.

[0101] like Figure 6 As shown, after determining the outbound record that matches each sub-order record, the order processing method further includes operations S610 to S620. In this embodiment, in addition to S610 to S620, operations S210 to S240 are also included. For the description of operations S210 to S240, please refer to the above Figure 2 The description in will not be repeated here.

[0102] In operation S610, the package product identifier associated with the main product in the sub-order record is backfilled to replace the main product identifier.

[0103] In operation S620, an order-and-delivery association table is generated based on each sub-order record and the delivery record that matches each sub-order record, wherein the order-and-delivery association table includes multiple order-and-delivery association records, and each of the multiple order-and-delivery association records includes an order ID, a main product ID, or a package product ID associated with the main product, a product serial number, and promotional information.

[0104] According to other embodiments of the present disclosure, the main product identifier and the package product identifier associated with the main product may be, but is not limited to, a product type identifier.

[0105] It is worth mentioning that if the order involves a package product associated with the main product, the relevant sub-order record in the order details table will not only reflect the package product ID associated with the main product, but also the main product ID.

[0106] Table 6 schematically shows the order and delivery association table after backfilling and replacement. As shown in Table 6, after the main product ID is used for association and docking and the corresponding product serial number is obtained, the package product ID associated with the main product in the sub-order record is backfilled to replace the main product ID to reflect the actual sales order record.

[0107] Table 6

[0108]

[0109] According to an embodiment of the present disclosure, Table 7 schematically shows an order-outbound association table organized according to Table 6. As shown in Table 7, each of the multiple order-outbound association records ultimately only reflects the order ID, the main product ID, or the package product ID associated with the main product (i.e., the product ID), the product serial number, and promotional information, etc., which will be beneficial for users to view and analyze the processed orders, thereby reducing communication costs, improving terminal sales efficiency, and incentivizing settlement data accuracy.

[0110] Table 7

[0111] Order ID Product Identification Promotional Information Serial Number Order ID Order-1 Virtual-sku-1 ** Serial-1 Order-1 Order-1 Virtual-sku-1 ** Serial-2 Order-1 Order-1 Sku-1 *** Serial-3 Order-1 Order-1 Sku-1 *** Serial-4 Order-1 Order-1 Sku-1 *** Serial-5 Order-1 Order-2 Sku-1 * Serial-6 Order-2 Order-2 Sku-1 * Serial-7 Order-2

[0112] Figure 7 The block diagram of an order processing device according to an embodiment of the present disclosure is schematically shown.

[0113] like Figure 7 As shown, the order processing device 700 includes a first acquisition module 710 , a splitting module 720 , a second acquisition module 730 and a matching module 740 .

[0114] A first acquisition module 710 is used to acquire an order detail table, wherein the order detail table includes multiple order records, each of which includes an order ID, a main product ID, and / or a package product ID associated with the main product, a transaction volume, and promotion information;

[0115] A splitting module 720, configured to split each order record into N sub-order records according to the transaction amount in each order record, wherein each sub-order record has a corresponding sub-order tag, and N is equal to the transaction amount in the order record;

[0116] The second acquisition module 730 is used to acquire a shipment return sub-table, wherein the shipment return sub-table includes multiple shipment records, each of which includes a product serial number, an order identifier, a main product identifier, and a shipment record label; and

[0117] The matching module 740 is used to determine the outbound record that matches each sub-order record based on the sub-order tag of each sub-order record and the outbound record tag in each outbound record.

[0118] According to an embodiment of the present disclosure, the order processing device 700 further includes: a determination module and a setting module.

[0119] a determination module, configured to determine, after splitting each order record into N sub-order records, a plurality of sub-order records having the same order identifier and main product identifier; and

[0120] The settings module is used to set the sub-order label for each sub-order record.

[0121] According to an embodiment of the present disclosure, the setting module includes a sorting unit and a signing unit.

[0122] A sorting unit, used to sort multiple sub-order records having the same order ID and main product ID; and

[0123] A labeling unit is provided, which is used to use the sequence number obtained by sorting as the sub-order label of each sub-order record.

[0124] According to an embodiment of the present disclosure, the splitting module 720 includes: a conversion unit and a splitting unit.

[0125] a conversion unit, configured to convert the transaction amount in each order record into a separable string, wherein the transaction amount in the order record and the string length of the separable string are numerically the same; and

[0126] The splitting unit is used to split each sub-order record into N sub-order records according to the length of the string in each order record, where N is equal to the length of the string.

[0127] According to an embodiment of the present disclosure, the order processing device 700 further includes: a backfill module.

[0128] The backfill module is used to backfill the package product identifier associated with the main product in the sub-order record to replace the main product identifier after determining the outbound record matching each sub-order record.

[0129] According to an embodiment of the present disclosure, the order processing apparatus 700 further includes: a generating module.

[0130] A generation module is used to generate an order and shipment association table according to each sub-order record and the shipment record matching each sub-order record after backfilling the package product identifier associated with the main product in the sub-order record to replace the main product identifier, wherein the order and shipment association table includes multiple order and shipment association records, and each order and shipment association record in the multiple order and shipment association records includes an order identifier, a main product identifier, or a package product identifier associated with the main product, a product serial number and promotion information.

[0131] According to an embodiment of the present disclosure, the main product identifier and the package product identifier associated with the main product are product type identifiers.

[0132] According to the embodiments of the present invention, any one or more of the modules, submodules, units, and subunits, or at least part of the functions of any one of them can be implemented in one module. According to the embodiments of the present invention, any one or more of the modules, submodules, units, and subunits can be split into multiple modules for implementation. According to the embodiments of the present invention, any one or more of the modules, submodules, units, and subunits can be at least partially implemented as hardware circuits, such as field programmable gate arrays (FPGAs), programmable logic arrays (PLAs), systems on chips, systems on substrates, systems on packages, application specific integrated circuits (ASICs), or can be implemented by hardware or firmware in any other reasonable way of integrating or packaging the circuit, or implemented in any one of the three implementation methods of software, hardware, and firmware, or in any appropriate combination of any of them. Alternatively, according to the embodiments of the present invention, one or more of the modules, submodules, units, and subunits can be at least partially implemented as computer program modules, and when the computer program modules are run, the corresponding functions can be performed.

[0133] For example, the order processing device 700 includes any of the first acquisition module 710, the splitting module 720, the second acquisition module 730, and the matching module 740, which can be combined into one module / unit / sub-unit for implementation, or any one of the modules / units / sub-units can be split into multiple modules / units / sub-units. Alternatively, at least part of the functions of one or more of these modules / units / sub-units can be combined with at least part of the functions of other modules / units / sub-units and implemented in one module / unit / sub-unit. According to an embodiment of the present disclosure, the order processing device 700 includes at least one of the first acquisition module 710, the splitting module 720, the second acquisition module 730, and the matching module 740, which can be at least partially implemented as a hardware circuit, such as a field programmable gate array (FPGA), a programmable logic array (PLA), a system on a chip, a system on a substrate, a system on a package, an application specific integrated circuit (ASIC), or can be implemented by hardware or firmware such as any other reasonable way of integrating or packaging the circuit, or implemented in any one of the three implementation methods of software, hardware, and firmware, or in any appropriate combination of any of them. Alternatively, the order processing device 700 includes at least one of the first acquisition module 710, the splitting module 720, the second acquisition module 730, and the matching module 740, which can be at least partially implemented as a computer program module, and when the computer program module is executed, the corresponding function can be executed.

[0134] It should be noted that the order processing device part in the embodiment of the present disclosure corresponds to the order processing method part in the embodiment of the present disclosure. The description of the order processing device part specifically refers to the order processing method part, which will not be repeated here.

[0135] Figure 8 A block diagram of a computer system suitable for implementing the method described above according to an embodiment of the present disclosure is schematically shown. Figure 8 The computer system shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0136] like Figure 8 As shown, the computer system 800 according to the embodiment of the present disclosure includes a processor 801, which can perform various appropriate actions and processes according to the program stored in the read-only memory (ROM) 802 or the program loaded from the storage part 808 to the random access memory (RAM) 803. The processor 801 may include, for example, a general-purpose microprocessor (such as a CPU), an instruction set processor and / or a related chipset and / or a special-purpose microprocessor (for example, an application-specific integrated circuit (ASIC)), etc. The processor 801 may also include an onboard memory for caching purposes. The processor 801 may include a single processing unit or multiple processing units for performing different actions of the method flow according to the embodiment of the present disclosure.

[0137] In RAM 803, various programs and data required for the operation of system 800 are stored. Processor 801, ROM 802 and RAM 803 are connected to each other through bus 804. Processor 801 performs various operations of the method flow according to the embodiment of the present disclosure by executing the program in ROM 802 and / or RAM 803. It should be noted that the program can also be stored in one or more memories other than ROM 802 and RAM 803. Processor 801 can also perform various operations of the method flow according to the embodiment of the present disclosure by executing the program stored in the one or more memories.

[0138] According to an embodiment of the present disclosure, the system 800 may further include an input / output (I / O) interface 805, which is also connected to the bus 804. The system 800 may further include one or more of the following components connected to the I / O interface 805: an input section 806 including a keyboard, a mouse, etc.; an output section 807 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage section 808 including a hard disk, etc.; and a communication section 809 including a network interface card such as a LAN card, a modem, etc. The communication section 809 performs communication processing via a network such as the Internet. A drive 810 is also connected to the I / O interface 805 as needed. A removable medium 811, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 810 as needed, so that a computer program read therefrom is installed into the storage section 808 as needed.

[0139] According to an embodiment of the present disclosure, the method flow according to an embodiment of the present disclosure can be implemented as a computer software program. For example, an embodiment of the present disclosure includes a computer program product, which includes a computer program carried on a computer-readable storage medium, and the computer program contains a program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 809, and / or installed from the removable medium 811. When the computer program is executed by the processor 801, the above-mentioned functions defined in the system of the embodiment of the present disclosure are executed. According to an embodiment of the present disclosure, the system, equipment, device, module, unit, etc. described above can be implemented by a computer program module.

[0140] The present disclosure also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiments; or may exist independently without being assembled into the device / apparatus / system. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed, the method according to the embodiment of the present disclosure is implemented.

[0141] According to an embodiment of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium. For example, it may include, but is not limited to: a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present disclosure, a computer-readable storage medium may be any tangible medium containing or storing a program that may be used by or in combination with an instruction execution system, apparatus, or device.

[0142] For example, according to an embodiment of the present disclosure, the computer-readable storage medium may include the ROM 802 and / or the RAM 803 described above and / or one or more memories other than the ROM 802 and the RAM 803 .

[0143] The flowcharts and block diagrams in the accompanying drawings illustrate the possible architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each box in the flowchart or block diagram may represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of the code contains one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box may also occur in an order different from that marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flowchart, and the combination of boxes in the block diagram or flowchart, can be implemented with a dedicated hardware-based system that performs the specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions. It can be understood by those skilled in the art that the features recorded in the various embodiments and / or claims of the present disclosure can be combined and / or combined in a variety of ways, even if such a combination or combination is not explicitly recorded in the present disclosure. In particular, without departing from the spirit and teaching of the present disclosure, the features described in the various embodiments and / or claims of the present disclosure may be combined and / or combined in a variety of ways. All of these combinations and / or combinations fall within the scope of the present disclosure.

[0144] The embodiments of the present disclosure are described above. However, these embodiments are only for illustrative purposes and are not intended to limit the scope of the present disclosure. Although the embodiments are described above separately, this does not mean that the measures in the various embodiments cannot be used in combination to advantage. The scope of the present disclosure is defined by the attached claims and their equivalents. Without departing from the scope of the present disclosure, those skilled in the art may make a variety of substitutions and modifications, which should all fall within the scope of the present disclosure.

Claims

1. An order processing method, comprising: Obtaining an order details table, wherein the order details table includes a plurality of order records, and each of the plurality of order records includes an order ID, a main product ID, and / or a package product ID associated with the main product, a transaction volume, and promotion information; According to the transaction amount in each order record, split each order record into N sub-order records, wherein each sub-order record has a corresponding sub-order tag, and N is equal to the transaction amount in the order record; Obtaining a shipment return sub-table, wherein the shipment return sub-table includes a plurality of shipment records, each of the plurality of shipment records including a product serial number, an order identifier, a main product identifier, and a shipment record label; and Determine the outbound record that matches each of the sub-order records according to the sub-order tag of each of the sub-order records and the outbound record tag in each of the outbound records; Wherein, after splitting each of the order records into N sub-order records, the method further includes: Identify multiple sub-order records with the same order ID and main product ID; and Setting a sub-order tag for each of the sub-order records; After obtaining the outbound return sub-table, the method further includes: Identify multiple outbound records with the same order ID and primary product ID; and The shipment record label is set for each shipment record in the same manner as the sub-order label is set.

2. The method according to claim 1, wherein: The step of setting a sub-order label for each sub-order record includes: sorting multiple sub-order records with the same order ID and main product ID; and The sequence number obtained by sorting is used as the sub-order label of each of the sub-order records.

3. The method according to claim 1, wherein: The step of splitting each order record into N sub-order records includes: Convert the transaction amount in each of the order records into a separable string, wherein the transaction amount in the order record and the string length of the separable string are numerically the same; and According to the length of the character string in each order record, each sub-order record is split into N sub-order records, wherein N is equal to the length of the character string.

4. The method according to claim 1, wherein: After determining the outbound shipment record that matches each of the sub-order records, the method further includes: The package product identifier associated with the main product in the sub-order record is filled back to replace the main product identifier.

5. The method according to claim 4, wherein: After the package product identifier associated with the main product in the sub-order record is filled in to replace the main product identifier, the method further includes: An order-and-delivery association table is generated according to each of the sub-order records and each delivery record that matches the sub-order record, wherein the order-and-delivery association table includes multiple order-and-delivery association records, and each of the multiple order-and-delivery association records includes an order ID, a main product ID, or a package product ID associated with the main product, a product serial number, and promotional information.

6. The method according to claim 1, wherein: The main product identifier and the package product identifier associated with the main product are product type identifiers.

7. An order processing device, comprising: A first acquisition module is used to acquire an order detail table, wherein the order detail table includes a plurality of order records, and each of the plurality of order records includes an order ID, a main product ID, and / or a package product ID associated with the main product, a transaction volume, and promotion information; a splitting module, configured to split each order record into N sub-order records according to the transaction amount in each order record, wherein each sub-order record has a corresponding sub-order tag, and N is equal to the transaction amount in the order record; A second acquisition module is used to acquire a shipment return sub-table, wherein the shipment return sub-table includes a plurality of shipment records, each of the plurality of shipment records includes a product serial number, an order identifier, a main product identifier and a shipment record label; and A matching module, used for determining the outbound record that matches each of the sub-order records according to the sub-order tag of each of the sub-order records and the outbound record tag in each of the outbound records; The order processing device also includes: a determination module, configured to determine, after splitting each order record into N sub-order records, a plurality of sub-order records having the same order identifier and main product identifier; and A setting module, used for setting the sub-order label for each sub-order record; The order processing device is also used for: Identify multiple outbound records with the same order ID and primary product ID; and The same method as setting the sub-order label is used to set the shipment record label for each shipment record.

8. A computer system comprising: one or more processors; a memory for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the method according to any one of claims 1 to 6.

9. A computer-readable storage medium having executable instructions stored thereon, wherein when the instructions are executed by a processor, the processor implements the method according to any one of claims 1 to 6.

Images