CN112348427A - Order processing method, device, computer system and readable storage medium - Google Patents
Order processing method, device, computer system and readable storage medium Download PDFInfo
- Publication number
- CN112348427A CN112348427A CN202010976574.8A CN202010976574A CN112348427A CN 112348427 A CN112348427 A CN 112348427A CN 202010976574 A CN202010976574 A CN 202010976574A CN 112348427 A CN112348427 A CN 112348427A
- Authority
- CN
- China
- Prior art keywords
- order
- record
- sub
- warehouse
- records
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 25
- 238000012545 processing Methods 0.000 claims abstract description 30
- 238000000034 method Methods 0.000 claims description 38
- 230000015654 memory Effects 0.000 claims description 10
- 238000012163 sequencing technique Methods 0.000 claims description 5
- 230000000875 corresponding effect Effects 0.000 description 14
- 230000006870 function Effects 0.000 description 13
- 238000010586 diagram Methods 0.000 description 12
- 238000004891 communication Methods 0.000 description 11
- 238000004590 computer program Methods 0.000 description 11
- 238000003032 molecular docking Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 7
- 230000002159 abnormal effect Effects 0.000 description 4
- 230000001737 promoting effect Effects 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 210000001503 joint Anatomy 0.000 description 3
- 108010001267 Protein Subunits Proteins 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000004806 packaging method and process Methods 0.000 description 2
- 239000000758 substrate Substances 0.000 description 2
- 230000002596 correlated effect Effects 0.000 description 1
- 238000013497 data interchange Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000002372 labelling Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012856 packing Methods 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
Landscapes
- Business, Economics & Management (AREA)
- Economics (AREA)
- Engineering & Computer Science (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Accounting & Taxation (AREA)
- Operations Research (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present disclosure provides an order processing method, including: obtaining an order list, wherein the order list comprises a plurality of order records, and each order record comprises an order mark, a main product mark and/or a package product mark, a transaction amount and promotion information which are related to the main product; splitting 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 label, and N is equal to the transaction amount in the order record; acquiring an ex-warehouse return sub-table, wherein the ex-warehouse return sub-table comprises a plurality of ex-warehouse records, and each ex-warehouse record comprises a product serial number, an order mark, a main product mark and an ex-warehouse record label; and determining the ex-warehouse record matched with each sub-order record according to the sub-order label of each sub-order record and the ex-warehouse record label in each ex-warehouse record. The present disclosure also provides an order processing apparatus, a computer system, and a computer-readable storage medium.
Description
Technical Field
The present disclosure relates to the field of computer technologies/internet technologies/warehouse logistics/electronic technologies, and more particularly, to an order processing method, an order processing apparatus, a computer system, and a readable storage medium.
Background
Electronic Data Interchange (EDI) refers to the exchange and automatic processing of standard economic information between Electronic computer systems of trading partners by transmitting it via communication networks according to the same set of specified common standard formats. EDI is not simple data exchange among users, EDI users need to send information according to international universal message formats, and receivers also need to process messages according to internationally and uniformly specified grammatical rules and cause EDI comprehensive processing of other related systems. The whole process is automatically completed without manual intervention, thereby reducing errors and improving efficiency. And product promotion information in the order data needs to be associated with the serial number of the corresponding product in the logistics outlet data before converting the product order data into a common standard format.
In the process of implementing the concept disclosed herein, the inventor finds that in the related art, at least the problem that the docking data is abnormal easily occurs in the process of associating the product promotion information in the order data with the serial number of the corresponding product in the material delivery data, so that the associated information cannot be accurately acquired.
Disclosure of Invention
In view of the above, the present disclosure provides an order processing method, apparatus, computer system and computer-readable storage medium.
One aspect of the present disclosure provides an order processing method, including: obtaining an order detail table, wherein the order detail table comprises a plurality of order records, and each order record in the plurality of order records comprises an order identifier, a main product identifier, and/or a package product identifier, a transaction amount and promotion information which are associated with the main product;
dividing 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 label, and N is equal to the transaction amount in the order record;
obtaining an ex-warehouse return sub-table, wherein the ex-warehouse return sub-table comprises a plurality of ex-warehouse records, and each ex-warehouse record in the plurality of ex-warehouse records comprises a product serial number, an order mark, a main product mark and an ex-warehouse record label; and
and determining the ex-warehouse record matched with each sub-order record according to the sub-order label of each sub-order record and the ex-warehouse record label in each ex-warehouse record.
According to an embodiment of the present disclosure, after splitting each of the order records into N sub-order records, the method further includes:
determining a plurality of sub-order records with the same order identification and main product identification; and
and setting a sub-order label for each sub-order record.
According to an embodiment of the present disclosure, the setting of the sub-order label for each sub-order record includes:
sequencing a plurality of sub-order records with the same order identification and main product identification; and
and taking the sequenced serial number as a sub-order label of each sub-order record.
According to an embodiment of the present disclosure, splitting each of the order records into N sub-order records includes:
converting the transaction amount in each order record into a detachable character string, wherein the transaction amount in the order record is the same as the character string length of the detachable character string in value; and
and splitting each sub-order record into N sub-order records according to the length of the character string in each order record, wherein N is equal to the length of the character string.
According to an embodiment of the present disclosure, after determining the ex-warehouse record matched with each sub-order record, the method further includes:
backfilling the package product identification associated with the main product in the sub-order record in place of the main product identification.
According to an embodiment of the present disclosure, after backfilling the package product identification associated with the main product in the sub-order record in place of the main product identification, the method further comprises:
and generating an order and ex-warehouse association table according to each sub-order record and each ex-warehouse record matched with the sub-order record, wherein the order and ex-warehouse association table comprises a plurality of order and ex-warehouse association records, and each order and ex-warehouse association record in the plurality of order and ex-warehouse association records comprises an order identifier, a main product identifier, or a package product identifier, a product serial number and promotion information associated with the main product.
According to the embodiment of the disclosure, the main product identifier and the package product identifier associated with the main product are product type identifiers.
Another aspect of the present disclosure provides an order processing apparatus including:
the system comprises a first obtaining module, a second obtaining module and a third obtaining module, wherein the first obtaining module is used for obtaining an order list, the order list comprises a plurality of order records, and each order record in the plurality of order records comprises an order mark, a main product mark and/or a package product mark, a transaction amount and promotion information which are related to the main product;
the splitting module is used for splitting 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 label, and N is equal to the transaction amount in the order record;
the second obtaining module is used for obtaining an ex-warehouse return sub-table, wherein the ex-warehouse return sub-table comprises a plurality of ex-warehouse records, and each ex-warehouse record in the plurality of ex-warehouse records comprises a product serial number, an order mark, a main product mark and an ex-warehouse record label; and
and the matching module is used for determining the ex-warehouse record matched with each sub-order record according to the sub-order label of each sub-order record and the ex-warehouse record label in each ex-warehouse record.
Another aspect of the present disclosure provides a computer-readable storage medium storing computer-executable instructions for implementing the method as described above when executed.
Another aspect of the disclosure provides a computer program comprising computer executable instructions for implementing the method as described above when executed.
According to the embodiment of the disclosure, each order record is divided into N sub-order records according to the transaction amount in each order record, wherein each sub-order record has a corresponding sub-order label; each ex-warehouse record in the ex-warehouse return sub-table comprises an ex-warehouse record label; and determining the ex-warehouse record matched with each sub-order record according to the sub-order label of each sub-order record and the ex-warehouse record label in each ex-warehouse record, so that the technical problem that the product promotion information in the order data and the serial number of the corresponding product in the material ex-warehouse data are abnormal in butt joint is at least partially solved, and the technical effect of accurately obtaining the associated information is further achieved.
Drawings
The above and other objects, features and advantages of the present disclosure will become more apparent from the following description of embodiments of the present disclosure with reference to the accompanying drawings, in which:
FIG. 1 schematically illustrates an exemplary system architecture to which the disclosed method and apparatus for order processing may be applied;
FIG. 2 schematically illustrates a flow chart of an order processing method according to an embodiment of the present disclosure;
FIG. 3 schematically illustrates a flow diagram for splitting a sub-order record, according to an embodiment of the present disclosure;
FIG. 4 schematically illustrates a flow diagram of an order processing method according to another embodiment of the present disclosure;
FIG. 5 schematically illustrates a flow diagram of sub-order label settings in accordance with an embodiment of the present disclosure;
FIG. 6 schematically illustrates a flow chart of an order processing method according to another embodiment of the present disclosure;
FIG. 7 schematically illustrates a block diagram of an order processing apparatus according to an embodiment of the present disclosure; and
FIG. 8 schematically illustrates a block diagram of a computer system suitable for implementing an order processing method according to an embodiment of the present disclosure.
Detailed Description
Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is illustrative only and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present disclosure.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. The terms "comprises," "comprising," and the like, as used herein, specify the presence of stated features, steps, operations, and/or components, but do not preclude the presence or addition of one or more other features, steps, operations, or components.
All terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art unless otherwise defined. It is noted that the terms used herein should be interpreted as having a meaning that is consistent with the context of this specification and should not be interpreted in an idealized or overly formal sense.
Where a convention analogous to "at least one of A, B and C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B and C" would include but not be limited to systems that have a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.). Where a convention analogous to "A, B or at least one of C, etc." is used, in general such a construction is intended in the sense one having skill in the art would understand the convention (e.g., "a system having at least one of A, B or C" would include but not be limited to systems that have a alone, B alone, C alone, a and B together, a and C together, B and C together, and/or A, B, C together, etc.).
With the popularization and application of electronic commerce of the internet, the enterprises can automatically transmit documents such as orders, invoices and the like to partners through a communication network. The informatization development of enterprises is expanded from the interior of the enterprise to the partners of the industry. In order to reduce communication cost, realize data sharing, improve terminal sales efficiency and encourage settlement data accuracy, the sales platform needs to perform data docking and sharing with each store merchant according to the sales condition of the sales product. The shared data content typically includes IMEI (International Mobile Equipment Identity) level data of the warehousing/selling/tuning, as well as sales prices, promotional information, and serial numbers of corresponding products.
However, in the process of implementing the present disclosure, the inventor finds that when the order data containing sales price and promotion information is correlated and docked with the logistics warehouse-out data containing product serial number, many-to-many correlation occurs, which results in mismatching with reality and the problem of abnormal docking data.
The embodiment of the disclosure provides an order processing method, an order processing device, a computer system and a computer readable storage medium. The method comprises the steps of obtaining an order list, wherein the order list comprises a plurality of order records, and each order record in the plurality of order records comprises an order mark, a main product mark and/or a package product mark, a transaction amount and promotion information which are related to the main product; splitting 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 label, and N is equal to the transaction amount in the order record; the method comprises the steps of obtaining an ex-warehouse return sub-table, wherein the ex-warehouse return sub-table comprises a plurality of ex-warehouse records, and each ex-warehouse record in the plurality of ex-warehouse records comprises a product serial number, an order mark, a main product mark and an ex-warehouse record label; and determining the ex-warehouse record matched with each sub-order record according to the sub-order label of each sub-order record and the ex-warehouse record label in each ex-warehouse record.
Fig. 1 schematically illustrates an exemplary system architecture 100 to which the order processing method and apparatus may be applied, according to an embodiment of the present disclosure. It should be noted that fig. 1 is only an example of a system architecture to which the embodiments of the present disclosure may be applied to help those skilled in the art understand the technical content of the present disclosure, and does not mean that the embodiments of the present disclosure may not be applied to other devices, systems, environments or scenarios.
As shown in fig. 1, 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 serves as a medium for providing communication links between the terminal devices 101, 102, 103 and the server 105. Network 104 may include various connection types, such as wired and/or wireless communication links, and so forth.
The user may use the terminal devices 101, 102, 103 to interact with the server 105 via the network 104 to receive or send messages or the like. The terminal devices 101, 102, 103 may have installed thereon various communication client applications, such as a shopping-like application, a web browser application, a search-like application, an instant messaging tool, a mailbox client, and/or social platform software, etc. (by way of example only).
The terminal devices 101, 102, 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.
The server 105 may be a server providing various services, such as a background management server (for example only) providing support for websites browsed by users using the terminal devices 101, 102, 103. The background management server may analyze and perform other processing on the received data such as the user request, and feed back a processing result (e.g., a webpage, information, or data obtained or generated according to the user request) to the terminal device.
It should be noted that the order processing method provided by the embodiment of the present disclosure may be generally executed by the server 105. Accordingly, the order processing apparatus provided by the embodiments of the present disclosure may be generally disposed in the server 105. The order processing method provided by the embodiment of the present disclosure may also be executed by a server or a server cluster that is different from the server 105 and is capable of communicating with the terminal devices 101, 102, 103 and/or the server 105. Accordingly, the order processing apparatus provided by the embodiment of the present disclosure may also be disposed in a server or a server cluster different from the server 105 and capable of communicating with the terminal devices 101, 102, 103 and/or the server 105. Alternatively, the order processing method provided by the embodiment of the present disclosure may also be executed by the terminal device 101, 102, or 103, or may also be executed by another terminal device different from the terminal device 101, 102, or 103. Accordingly, the order processing apparatus provided by the embodiment of the present disclosure may also be disposed in the terminal device 101, 102, or 103, or in another terminal device different from the terminal device 101, 102, or 103.
For example, the order list and the ex-warehouse return sub-list 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 may be stored on 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 to-be-processed order detail table and the ex-warehouse return sub-table to other terminal devices, servers, or server clusters, and execute the order processing method provided by the embodiment of the present disclosure by the other terminal devices, servers, or server clusters that receive the to-be-processed order detail table and the ex-warehouse return sub-table.
It should be understood that the number of terminal devices, networks, and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
FIG. 2 schematically shows a flow chart of an order processing method according to an embodiment of the present disclosure.
It should be noted that, unless explicitly stated that there is an execution sequence between different operations or there is an execution sequence between different operations in technical implementation, the execution sequence between multiple operations may not be sequential, or multiple operations may be executed simultaneously in the flowchart in this disclosure.
As shown in fig. 2, the method includes operations S210 to S240.
In operation S210, an order list is obtained, where the order list includes a plurality of order records, and each order record in the plurality of order records includes an order identifier, a main product identifier, and/or a package product identifier, a transaction amount, and promotion information associated with the main product.
In operation S220, each order record is divided into N sub-order records according to the transaction amount in each order record, where each sub-order record has a corresponding sub-order label, and N is equal to the transaction amount in the order record.
In operation S230, a warehouse-out return sub-table is obtained, where the warehouse-out return sub-table includes a plurality of warehouse-out records, and each warehouse-out record in the plurality of warehouse-out records includes a product serial number, an order identifier, a main product identifier, and a warehouse-out record label.
In operation S240, the ex-warehouse record matched with each sub-order record is determined according to the sub-order label of each sub-order record and the ex-warehouse record label in each ex-warehouse record.
Table 1 schematically shows an order list of an embodiment of the present disclosure, according to an embodiment of the present disclosure. As shown in table 1, the order list may be statistics of information such as transaction amount and selling price for a plurality of products over a period of time; wherein the identification can be a number, a two-dimensional code or other uniquely identifiable identification. The main product can be any single product of electronic products, books, clothes or food, etc.; the set product associated with the main product may be a set of one single product of electronic products, books, clothes or food, and another related product sold in association therewith.
More specifically, for example, the main product may be a mobile phone, and the set product associated with the main product may be a combination set of the mobile phone and the headset, or a combination set of the mobile phone and the mobile phone shell, and the like.
In practice, the master product, and the package products associated with the master product, may participate in different promotional programs. The package product identification associated with the master product includes the same character field as the master product identification.
TABLE 1
| Order identification | Main product identification | Package packing product mark | Amount of transaction | Promotional information |
| Order-1 | Sku-1 | Virtual-sku-1 | 2 | ** |
| Order-1 | Sku-1 | 3 | *** | |
| Order-2 | Sku-1 | 2 | * |
Table 2 schematically shows an ex-warehouse return sublist of an embodiment of the present disclosure, according to an embodiment of the present disclosure. As shown in table 2, only the primary product identifier is recorded in the ex-warehouse record in the ex-warehouse return sub-table, that is, the primary product identifier recorded in the ex-warehouse record may represent the primary product, and may also represent the package product associated with the primary product; the ex-warehouse record cannot truly reflect the actual situation of the ex-warehouse product.
TABLE 2
| Product serial number | Order identification | Main product identification |
| 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 |
Therefore, in the actual order processing process, when a plurality of ex-warehouse records with the same order identification and the same main product identification appear, if the order records in the order detail table are associated with the ex-warehouse records in the ex-warehouse return branch table directly according to the order identification and the main product identification, many-to-many situations can occur in the docking data, the docking data are not matched with the actual sales situation, and the docking data are abnormal.
According to the embodiment of the disclosure, the corresponding sub-order label in each sub-order record becomes another identifier different from other sub-order records; the label of the outbound record in the outbound record also becomes another identifier different from other outbound records. Therefore, according to the sub-order labels of each sub-order record and the ex-warehouse record labels in each ex-warehouse record, each sub-order record can be in one-to-one butt joint with each ex-warehouse record, the ex-warehouse record matched with each sub-order record is determined, and the multi-to-multi data butt joint situation is avoided.
The method shown in fig. 2 is further described with reference to fig. 3-6 in conjunction with specific embodiments.
FIG. 3 schematically illustrates a flow diagram for splitting a sub-order record, according to an embodiment of the disclosure.
As shown in fig. 3, splitting each order record into N sub-order records includes operations S221 to S222. Wherein:
in operation S221, the transaction amount in each order record is converted into a detachable string, wherein the transaction amount in the order record is numerically the same as the string length of the detachable string.
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.
According to the embodiment of the present disclosure, the transaction amount in each order record is converted into a detachable character string, but the present disclosure is not limited thereto, and may be any identifier that can identify the transaction amount. In an embodiment of the present disclosure, the detachable string is set according to a User defined function UDF (User defined function).
According to the embodiment of the disclosure, according to the length of the character string in each order record, the EXPLODE function and/or the SPLIT function are/is used for segmenting the splittable character string, and each sub-order record is SPLIT into N sub-order records, wherein N is equal to the length of the character string. Wherein, the EXPLODE function and/or the SPLIT function can be a custom SPLIT function.
Table 3 schematically illustrates an order list for converting the transaction amount of table 1 into a splittable string, according to an embodiment of the disclosure. 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 length of the character string.
TABLE 3
FIG. 4 schematically shows a flow chart of an order processing method according to another embodiment of the present disclosure.
As shown in fig. 4, after splitting each order record 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, and the description about operations S210 to S240 may refer to the description in fig. 2, which is not described herein again.
In operation S410, a plurality of sub-order records having the same order identification as the main product identification are determined.
In operation S420, a sub-order tag is set for each sub-order record.
According to the embodiment of the disclosure, after the ex-warehouse return sub-table is obtained, an ex-warehouse record label can be set for each ex-warehouse record. For example, a plurality of ex-warehouse records with the same order identifier and main product identifier are determined, and then an ex-warehouse record label is set for each ex-warehouse record.
Based on the operation, when the delivery record matched with each sub-order record is determined according to the sub-order label of each sub-order record and the delivery record label in each delivery record, the processing is convenient, and the accuracy and the efficiency of data docking are improved.
FIG. 5 schematically shows a flow chart for setting a sub-order label according to an embodiment of the disclosure.
As shown in fig. 5, setting the sub-order label for each sub-order record includes operations S421 to S422.
In operation S421, a plurality of sub-order records having the same order identifier and main product identifier are sorted.
In operation S422, the sequence number obtained by sorting is used as a sub-order label of each sub-order record.
According to the embodiment of the present disclosure, table 4 schematically shows the order detail table after the order sub-record label is set in table 3, and as shown in table 4, combining operation S410 with operations S421 to S422 becomes a preferred embodiment. Namely, after a plurality of sub-order records with the same order mark and the same main product mark are determined, the sequence number obtained by sequencing is used as the sub-order label of each sub-order record, so that the operation of setting the sub-order label is convenient and simple.
TABLE 4
According to an embodiment of the present disclosure, setting a shipping record label for each shipping record may also include: and sequencing a plurality of ex-warehouse records with the same order identification and main product identification, and taking the sequence number obtained by sequencing as an ex-warehouse record label of each ex-warehouse record.
Table 5 schematically shows the ex-warehouse return table after the ex-warehouse record label is set according to table 2, and as shown in table 5, the ex-warehouse record label is set by the same method as the sub-order label setting, which is beneficial to the subsequent docking between the ex-warehouse record label and the sub-order label.
TABLE 5
| Product serial number | Order identification | Main product identification | Warehouse-out 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 |
According to the embodiment of the disclosure, the sub-order label is not limited to the serial number, and may be any acceptable barcode, two-dimensional code, or the like. According to the embodiment of the disclosure, the selection of the serial number is more intuitive and convenient to read, so that the order processing is simple and effective.
FIG. 6 schematically illustrates an order processing method according to another embodiment of the present disclosure.
As shown in fig. 6, after determining the ex-warehouse record matched with 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, and the description about operations S210 to S240 may refer to the description in fig. 2, which is not described herein again.
In operation S610, the package product identification associated with the main product in the sub-order record is backfilled with a replacement main product identification.
In operation S620, an order and ex-warehouse association table is generated according to each sub-order record and the ex-warehouse record matched with each sub-order record, wherein the order and ex-warehouse association table includes a plurality of order and ex-warehouse association records, and each order and ex-warehouse association record in the plurality of order and ex-warehouse association records includes an order identifier, a main product identifier, or a package product identifier associated with a main product, a product serial number, and promotion information.
According to other embodiments of the present disclosure, the primary product identifier and the package product identifier associated with the primary product may be, but are not limited to, a product type identifier.
It should be noted that if the order relates to a package product associated with the main product, the package product identifier associated with the main product is not reflected but is also reflected in the related sub-order record in the order list.
Table 6 schematically shows the order and ex-warehouse association table after backfilling replacement. As shown in table 6, after the main product identifier is used for association and docking and the corresponding product serial number is obtained, the main product identifier is replaced by the package product identifier associated with the main product in the sub-order record, so as to reflect the actual sale of the order record.
TABLE 6
According to the embodiment of the disclosure, table 7 schematically shows the order and ex-warehouse association table sorted according to table 6, as shown in table 7, each of the multiple order and ex-warehouse association records finally only reflects information such as an order identifier, a main product identifier, or a package product identifier (i.e., a product identifier) associated with a main product, a product serial number, promotion information, and the like, which is beneficial for a user to view and analyze the processed order, thereby reducing communication cost, improving terminal sales efficiency and motivating settlement data accuracy.
TABLE 7
| Order identification | Product identification | Promotional information | Serial number | Order identification |
| 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 |
Fig. 7 schematically shows a block diagram of an order processing apparatus according to an embodiment of the present disclosure.
As shown in fig. 7, the order processing apparatus 700 includes a first obtaining module 710, a splitting module 720, a second obtaining module 730, and a matching module 740.
A first obtaining module 710, configured to obtain an order detail table, where the order detail table includes a plurality of order records, and each order record in 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 amount, and promotion information;
a splitting module 720, configured to split each order record into N sub-order records according to the transaction amount in each order record, where each sub-order record has a corresponding sub-order label, and N is equal to the transaction amount in the order record;
the second obtaining module 730 is configured to obtain a warehouse-out return sub-table, where the warehouse-out return sub-table includes multiple warehouse-out records, and each warehouse-out record in the multiple warehouse-out records includes a product serial number, an order identifier, a main product identifier, and a warehouse-out record label; and
and the matching module 740 is configured to determine the ex-warehouse record matched with each sub-order record according to the sub-order label of each sub-order record and the ex-warehouse record label in each ex-warehouse record.
According to an embodiment of the present disclosure, the order processing apparatus 700 further includes: the device comprises a determining module and a setting module.
The determining module is used for determining a plurality of sub order records with the same order identification and main product identification after splitting each order record into N sub order records; and
and the setting module is used for setting a sub-order label for each sub-order record.
According to an embodiment of the present disclosure, a setup module includes a sorting unit and a setup labeling unit.
The ordering unit is used for ordering the plurality of sub-order records with the same order identification and main product identification; and
and the label setting unit is used for taking the sequenced serial numbers as the sub-order labels of each sub-order record.
According to an embodiment of the present disclosure, the splitting module 720 includes: a conversion unit and a splitting unit.
The conversion unit is used for converting the transaction amount in each order record into a detachable character string, wherein the transaction amount in the order record is the same as the character string length of the detachable character string in value; and
and the splitting unit is used for splitting each sub-order record into N sub-order records according to the length of the character string in each order record, wherein N is equal to the length of the character string.
According to an embodiment of the present disclosure, the order processing apparatus 700 further includes: and a backfill module.
And the backfilling module is used for backfilling the packaged product identification related to the main product in the sub-order record to replace the main product identification after determining the ex-warehouse record matched with each sub-order record.
According to an embodiment of the present disclosure, the order processing apparatus 700 further includes: and generating a module.
And the generating module is used for generating an order and ex-warehouse association table according to the ex-warehouse record matched with each sub-order record and each sub-order record after the main product identifier is replaced by the package product identifier associated with the main product in the sub-order records, wherein the order and ex-warehouse association table comprises a plurality of order and ex-warehouse association records, and each order and ex-warehouse association record in the plurality of order and ex-warehouse association records comprises an order identifier, a main product identifier or a package product identifier, a product serial number and promotion information associated with the main product.
According to an embodiment of the present disclosure, the master product identifier and the package product identifier associated with the master product are product type identifiers.
Any number of modules, sub-modules, units, sub-units, or at least part of the functionality of any number thereof according to embodiments of the present disclosure may be implemented in one module. Any one or more of the modules, sub-modules, units, and sub-units according to the embodiments of the present disclosure may be implemented by being split into a plurality of modules. Any one or more of the modules, sub-modules, units, sub-units according to embodiments of the present disclosure may be implemented at least in part 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 may be implemented in any other reasonable manner of hardware or firmware by integrating or packaging a circuit, or in any one of or a suitable combination of software, hardware, and firmware implementations. Alternatively, one or more of the modules, sub-modules, units, sub-units according to embodiments of the disclosure may be at least partially implemented as a computer program module, which when executed may perform the corresponding functions.
For example, any number of the order processing apparatus 700 including the first obtaining module 710, the splitting module 720, the second obtaining module 730, and the matching module 740 may be combined and implemented in one module/unit/sub-unit, or any one of the modules/units/sub-units may be split into a plurality of modules/units/sub-units. Alternatively, at least part of the functionality of one or more of these modules/units/sub-units may be combined with at least part of the functionality of other modules/units/sub-units and implemented in one module/unit/sub-unit. According to an embodiment of the present disclosure, at least one of the order processing apparatus 700 including the first obtaining module 710, the splitting module 720, the second obtaining module 730, and the matching module 740 may 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 may be implemented by hardware or firmware in any other reasonable manner of integrating or packaging a circuit, or implemented by any one of three implementations of software, hardware, and firmware, or an appropriate combination of any several of them. Alternatively, at least one of the order processing apparatus 700 comprising the first obtaining module 710, the splitting module 720, the second obtaining module 730, and the matching module 740 may be at least partially implemented as a computer program module which, when executed, may perform a corresponding function.
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, and the description of the order processing device part specifically refers to the order processing method part, which is not described herein again.
FIG. 8 schematically illustrates a block diagram of a computer system suitable for implementing the above-described method, according to an embodiment of the present disclosure. The computer system illustrated in FIG. 8 is only one example and should not impose any limitations on the scope of use or functionality of embodiments of the disclosure.
As shown in fig. 8, a computer system 800 according to an embodiment of the present disclosure includes a processor 801 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)802 or a program loaded from a storage section 808 into a Random Access Memory (RAM) 803. The processor 801 may include, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or associated chipset, and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), among others. The processor 801 may also include 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 flows according to embodiments of the present disclosure.
In the RAM 803, various programs and data necessary for the operation of the system 800 are stored. The processor 801, the ROM 802, and the RAM 803 are connected to each other by a bus 804. The processor 801 performs various operations of the method flows according to the embodiments of the present disclosure by executing programs in the ROM 802 and/or RAM 803. Note that the programs may also be stored in one or more memories other than the ROM 802 and RAM 803. The processor 801 may also perform various operations of method flows according to embodiments of the present disclosure by executing programs stored in the one or more memories.
According to embodiments of the present disclosure, method flows according to embodiments of the present disclosure may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable storage medium, the computer program containing program code for performing the method illustrated by the flow chart. In such an embodiment, the computer program can be downloaded and installed from a network through the communication section 809 and/or installed from the removable medium 811. The computer program, when executed by the processor 801, performs the above-described functions defined in the system of the embodiments of the present disclosure. The systems, devices, apparatuses, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the present disclosure.
The present disclosure also provides a computer-readable storage medium, which may be contained in the apparatus/device/system described in the above embodiments; or may exist separately and not be assembled into the device/apparatus/system. The computer-readable storage medium carries one or more programs which, when executed, implement the method according to an embodiment of the disclosure.
According to an embodiment of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium. Examples may include, but are not limited to: a portable computer diskette, 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 disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
For example, according to embodiments of the present disclosure, a computer-readable storage medium may include the ROM 802 and/or RAM 803 described above and/or one or more memories other than the ROM 802 and RAM 803.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions. Those skilled in the art will appreciate that various combinations and/or combinations of features recited in the various embodiments and/or claims of the present disclosure can be made, even if such combinations or combinations are not expressly recited in the present disclosure. In particular, various combinations and/or combinations of the features recited in the various embodiments and/or claims of the present disclosure may be made without departing from the spirit or teaching of the present disclosure. All such combinations and/or associations are within the scope of the present disclosure.
The embodiments of the present disclosure have been described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described separately above, this does not mean that the measures in the embodiments cannot be used in advantageous combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be devised by those skilled in the art without departing from the scope of the present disclosure, and such alternatives and modifications are intended to be within the scope of the present disclosure.
Claims (10)
1. An order processing method, comprising:
obtaining an order detail table, wherein the order detail table comprises a plurality of order records, and each order record in the plurality of order records comprises an order identifier, a main product identifier, and/or a package product identifier, a transaction amount and promotion information which are associated with the main product;
dividing 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 label, and N is equal to the transaction amount in the order record;
obtaining an ex-warehouse return sub-table, wherein the ex-warehouse return sub-table comprises a plurality of ex-warehouse records, and each ex-warehouse record in the plurality of ex-warehouse records comprises a product serial number, an order mark, a main product mark and an ex-warehouse record label; and
and determining the ex-warehouse record matched with each sub-order record according to the sub-order label of each sub-order record and the ex-warehouse record label in each ex-warehouse record.
2. The method of claim 1, wherein after splitting each of the order records into N sub-order records, the method further comprises:
determining a plurality of sub-order records with the same order identification and main product identification; and
and setting a sub-order label for each sub-order record.
3. The method of claim 2, wherein said setting a sub-order label for each said sub-order record comprises:
sequencing a plurality of sub-order records with the same order identification and main product identification; and
and taking the sequenced serial number as a sub-order label of each sub-order record.
4. The method of claim 1, wherein the splitting each of the order records into N sub-order records comprises:
converting the transaction amount in each order record into a detachable character string, wherein the transaction amount in the order record is the same as the character string length of the detachable character string in value; and
and splitting each sub-order record into N sub-order records according to the length of the character string in each order record, wherein N is equal to the length of the character string.
5. The method of claim 1, wherein upon determining an outbound record that each of the sub-order records matches, the method further comprises:
backfilling the package product identification associated with the main product in the sub-order record in place of the main product identification.
6. The method of claim 5, wherein after backfilling the package product identification associated with a primary product in the sub-order record in place of the primary product identification, the method further comprises:
and generating an order and ex-warehouse association table according to each sub-order record and each ex-warehouse record matched with the sub-order record, wherein the order and ex-warehouse association table comprises a plurality of order and ex-warehouse association records, and each order and ex-warehouse association record in the plurality of order and ex-warehouse association records comprises an order identifier, a main product identifier, or a package product identifier, a product serial number and promotion information associated with the main product.
7. The method of claim 1, wherein the master product identifier and the package product identifier associated with the master product are product type identifiers.
8. An order processing apparatus comprising:
the system comprises a first obtaining module, a second obtaining module and a third obtaining module, wherein the first obtaining module is used for obtaining an order list, the order list comprises a plurality of order records, and each order record in the plurality of order records comprises an order mark, a main product mark and/or a package product mark, a transaction amount and promotion information which are related to the main product;
the splitting module is used for splitting 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 label, and N is equal to the transaction amount in the order record;
the second obtaining module is used for obtaining an ex-warehouse return sub-table, wherein the ex-warehouse return sub-table comprises a plurality of ex-warehouse records, and each ex-warehouse record in the plurality of ex-warehouse records comprises a product serial number, an order mark, a main product mark and an ex-warehouse record label; and
and the matching module is used for determining the ex-warehouse record matched with each sub-order record according to the sub-order label of each sub-order record and the ex-warehouse record label in each ex-warehouse record.
9. A computer system, comprising:
one or more processors;
a memory for storing one or more programs,
wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of any of claims 1-7.
10. A computer readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to carry out the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010976574.8A CN112348427A (en) | 2020-09-16 | 2020-09-16 | Order processing method, device, computer system and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010976574.8A CN112348427A (en) | 2020-09-16 | 2020-09-16 | Order processing method, device, computer system and readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112348427A true CN112348427A (en) | 2021-02-09 |
Family
ID=74357924
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010976574.8A Pending CN112348427A (en) | 2020-09-16 | 2020-09-16 | Order processing method, device, computer system and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112348427A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115936155A (en) * | 2023-03-15 | 2023-04-07 | 自由飞越国际航空技术服务(北京)有限公司 | Air ticket order information management system based on data profiling |
| CN116402438A (en) * | 2023-03-29 | 2023-07-07 | 乐麦信息技术(杭州)有限公司 | Warehouse management method and system |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2000043931A2 (en) * | 1999-01-25 | 2000-07-27 | Lilly Software Associates, Inc. | Distribution center management system |
| TW201617983A (en) * | 2014-11-14 | 2016-05-16 | Pchome Online Inc | Distribution center management method and system |
| CN106469357A (en) * | 2015-08-18 | 2017-03-01 | 易电商（上海）信息科技有限公司 | A kind of storage management method and system |
| CN108022064A (en) * | 2016-11-03 | 2018-05-11 | 北京西南物流中心有限公司 | A kind of logistics outbound review packing method and system |
| CN108062703A (en) * | 2017-12-18 | 2018-05-22 | 赵志勇 | A kind of cargo managing method, system and platform |
| CN108985678A (en) * | 2018-06-15 | 2018-12-11 | 太仓市智联信息科技有限公司 | A kind of warehouse ex-warehouse system |
| CN110826944A (en) * | 2018-08-07 | 2020-02-21 | 北京京东尚科信息技术有限公司 | Order processing method and device, electronic equipment and medium |
| KR20200104037A (en) * | 2019-02-26 | 2020-09-03 | 주식회사 스페이스리버 | Goods Receipt and Issue Management System using binary management user interface |
-
2020
- 2020-09-16 CN CN202010976574.8A patent/CN112348427A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2000043931A2 (en) * | 1999-01-25 | 2000-07-27 | Lilly Software Associates, Inc. | Distribution center management system |
| TW201617983A (en) * | 2014-11-14 | 2016-05-16 | Pchome Online Inc | Distribution center management method and system |
| CN106469357A (en) * | 2015-08-18 | 2017-03-01 | 易电商（上海）信息科技有限公司 | A kind of storage management method and system |
| CN108022064A (en) * | 2016-11-03 | 2018-05-11 | 北京西南物流中心有限公司 | A kind of logistics outbound review packing method and system |
| CN108062703A (en) * | 2017-12-18 | 2018-05-22 | 赵志勇 | A kind of cargo managing method, system and platform |
| CN108985678A (en) * | 2018-06-15 | 2018-12-11 | 太仓市智联信息科技有限公司 | A kind of warehouse ex-warehouse system |
| CN110826944A (en) * | 2018-08-07 | 2020-02-21 | 北京京东尚科信息技术有限公司 | Order processing method and device, electronic equipment and medium |
| KR20200104037A (en) * | 2019-02-26 | 2020-09-03 | 주식회사 스페이스리버 | Goods Receipt and Issue Management System using binary management user interface |
Non-Patent Citations (1)
| Title |
|---|
| 章志华;陆海良;: "基于多库协同的订单特性分析", 中国流通经济, no. 12, 23 December 2012 (2012-12-23), pages 86 - 93 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115936155A (en) * | 2023-03-15 | 2023-04-07 | 自由飞越国际航空技术服务(北京)有限公司 | Air ticket order information management system based on data profiling |
| CN116402438A (en) * | 2023-03-29 | 2023-07-07 | 乐麦信息技术(杭州)有限公司 | Warehouse management method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107665225B (en) | Information pushing method and device | |
| CN107463675B (en) | Data processing method and system | |
| CN105488125A (en) | Page access method and apparatus | |
| CN112348427A (en) | Order processing method, device, computer system and readable storage medium | |
| CN113034077A (en) | Information processing method, system, electronic device, storage medium, and program product | |
| CN107977876B (en) | Method and device for processing order information | |
| CN110634007A (en) | Data processing method, device, system and computer readable medium | |
| CN110956417B (en) | Store commodity processing method and device | |
| WO2019015254A1 (en) | Information processing method and device | |
| US20240054451A1 (en) | Inventory information processing method and device | |
| CN108536715B (en) | Preview page generation method, device, equipment and storage medium | |
| US10467585B2 (en) | Beverage product acquisition and inventory management system | |
| CN110557684B (en) | Information processing method, system, electronic device, and computer-readable medium | |
| CN111754284A (en) | Order processing method, system, computing device and medium | |
| CN110895763A (en) | Commodity supply chain tracing method and device | |
| CN113515332B (en) | Data generation method, device, equipment and storage medium | |
| CN107845004B (en) | Information pushing method and device | |
| US10354313B2 (en) | Emphasizing communication based on past interaction related to promoted items | |
| CN113610417A (en) | Data processing method, device, computer system and storage medium | |
| CN110751496B (en) | Commodity price detection method and device | |
| US8538813B2 (en) | Method and system for providing an SMS-based interactive electronic marketing offer search and distribution system | |
| CN111861293A (en) | Method and apparatus for transmitting information | |
| CN110298528B (en) | Method and device for grouping articles | |
| CN113222680A (en) | Method and device for generating order | |
| CN113112285A (en) | Data analysis method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |