Order processing method and device, equipment, readable storage medium and program product

Abstract

The invention relates to an order processing method, device and equipment, a readable storage medium and a program product. The method comprises the following steps: after a target platform successfully logs in a user account, entering an order page of the target platform; in response to an order acquisition operation for the order page, performing order acquisition in the order page to obtain order information; analyzing the product basic specification template and the product logistics specification template to obtain basic specification information and logistics specification information of order products in the order information; and filling a standard template based on the order information and the basic specification information and the logistics specification information of the order product in the order information to obtain a target order file. By adopting the method, the order processing efficiency and accuracy can be improved.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to an order processing method, device, equipment, readable storage medium and program product. Background Art

[0002] In traditional technology, order processing usually relies on manual operations. Users need to log in to the e-commerce platform, manually obtain order information, and then manually search for relevant information about the order products in the order information, and then manually process the order information and related information. In this process, manual processing is not only time-consuming and labor-intensive, but also prone to information entry and processing errors. Especially when facing a large number of orders, manual operations are inefficient and it is easy to miss key data or have inconsistent formats, resulting in low efficiency and poor accuracy in order processing. Summary of the invention

[0003] Based on this, it is necessary to provide an order processing method, apparatus, computer equipment, computer-readable storage medium and computer program product that can improve the accuracy and efficiency of order processing in response to the above technical problems.

[0004] In a first aspect, the present application provides an order processing method, the method comprising:

[0005] After successfully logging into the target platform, enter the target platform's order page;

[0006] In response to an order collection operation on the order page, order collection is performed on the order page to obtain order information;

[0007] Parsing the product basic specification template and the product logistics specification template to obtain basic specification information and logistics specification information of the order product in the order information;

[0008] The standard template is filled based on the order information and the basic specification information and logistics specification information of the order products in the order information to obtain a target order file.

[0009] In one embodiment, the order information includes a product identifier of the order product; the parsing of the product basic specification template and the product logistics specification template to obtain the basic specification information and logistics specification information of the order product in the order information includes:

[0010] Parsing the product basic specification template and the product logistics specification template to obtain basic specification information of multiple products and logistics specification information of the multiple products;

[0011] Based on the product identification, basic specification information and logistics specification information of the order product are extracted from the basic specification information of the multiple products and the logistics specification information of the multiple products.

[0012] In one embodiment, the method further comprises:

[0013] If the target basic specification information and the target logistics specification information corresponding to the target product identifier are not found from the basic specification information of the multiple products and the logistics specification information of the multiple products, generating abnormal prompt information based on the order information corresponding to the target product identifier;

[0014] Output the abnormal prompt information and order information adjustment box;

[0015] In response to the adjusted product identification input in the order information adjustment box, the basic specification information and logistics specification information of the order product are extracted from the basic specification information of the multiple products and the logistics specification information of the multiple products based on the adjusted product identification.

[0016] In one embodiment, the standard template includes conventional fields, including a basic order field, a basic product specification field, and a basic logistics specification field; the standard template is filled based on the order information and the basic specification information and logistics specification information of the order product in the order information to obtain a target order file, including:

[0017] Determine the basic order field value corresponding to the basic order field in the order information, determine the basic product specification field value corresponding to the basic product specification field in the basic specification information, and determine the basic logistics specification field value corresponding to the basic logistics specification field in the basic specification information;

[0018] The basic order field, the basic product specification field and the basic logistics specification field in the standard template are filled based on the basic order field value, the basic product specification field value and the basic logistics specification field value to obtain a target order file.

[0019] In one embodiment, the standard template further includes a derived field; the basic product specification field and the basic logistics specification field in the standard template are filled based on the basic product specification field value and the basic logistics specification field value to obtain the target order file, including:

[0020] Determining a target field associated with the derived field in basic information; the basic information includes at least one of basic specification information and logistics specification information;

[0021] According to the processing method associated with the derived field, the field value corresponding to the target field is processed to obtain a derived field value;

[0022] Based on the basic order field value, the basic product specification field value, the basic logistics specification field value and the derived field value, the basic product specification field, the basic logistics specification field and the derived field in the standard template are filled respectively to obtain the target order file.

[0023] In one embodiment, the method comprises:

[0024] Displaying a candidate template list; the candidate template list includes at least one candidate standard template;

[0025] In response to an editing operation on a target standard template in the candidate template list, displaying a template editing page;

[0026] In response to a derived field adding operation triggered on the target editing page, generating an updated standard template including the added derived field;

[0027] In response to a selection operation triggered in the candidate template list, the standard template specified by the selection operation is determined as the standard template to be filled in the field.

[0028] In a second aspect, the present application further provides an order processing device, the device comprising:

[0029] The order page entry module is used to enter the order page of the target platform after successfully logging into the user account on the target platform;

[0030] An order collection module, configured to, in response to an order collection operation on the order page, collect orders on the order page to obtain order information;

[0031] A specification information acquisition module is used to parse the product basic specification template and the product logistics specification template to obtain the basic specification information and logistics specification information of the order product in the order information;

[0032] The data filling module is used to fill the standard template based on the order information and the basic specification information and logistics specification information of the order products in the order information to obtain the target order file.

[0033] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the above method when executing the computer program.

[0034] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, wherein the computer program implements the steps of the above method when executed by a processor.

[0035] In a fifth aspect, the present application also provides a computer program product, including a computer program, which implements the steps of the above method when executed by a processor.

[0036] The above-mentioned order processing method, device, computer equipment, computer-readable storage medium and computer program product automatically enter the order page of the target platform after successfully logging into the user account on the target platform, and respond to the order collection operation on the order page, perform order collection on the order page to obtain order information, thereby avoiding the tedious operation of manual search and manual entry into the order page. Through automated order collection, order information can be quickly obtained, thereby avoiding the time waste and information omission problems of manual search. The product basic specification template and the product logistics specification template are automatically parsed to obtain the basic specification information and logistics specification information of the order product in the order information, thereby ensuring the accuracy of the relevant information of the acquired order product. The standard template is filled in based on the order information and the basic specification information and logistics specification information of the order product in the order information to obtain the target order file, thereby avoiding errors and inefficiencies in manual processing, reducing the risk of data loss and format inconsistency, and improving the accuracy of order processing. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0038] Figure 1 An application environment diagram of an order processing method in an embodiment;

[0039] Figure 2 A schematic diagram of a flow chart of an order processing method in one embodiment;

[0040] Figure 3 A schematic diagram of order information in one embodiment;

[0041] Figure 4 A schematic diagram of a basic product specification template in one embodiment;

[0042] Figure 5 A schematic diagram of a product logistics specification template in one embodiment;

[0043] Figure 6 is a schematic diagram of a target order file in one embodiment;

[0044] Figure 7 is a schematic diagram of a target order file in another embodiment;

[0045] Figure 8 is a structural block diagram of an order processing device in one embodiment;

[0046] Fig. 9 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0047] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0048] The order processing method provided in the embodiment of the present application can be Figure 1 The terminal 102 shown in the figure executes, after the terminal 102 successfully logs in the user account on the target platform, it enters the order page of the target platform; in response to the order collection operation on the order page, it collects the order on the order page to obtain the order information; it parses the product basic specification template and the product logistics specification template to obtain the basic specification information and logistics specification information of the order product in the order information; it fills the standard template based on the order information and the basic specification information and logistics specification information of the order product in the order information to obtain the target order file. Among them, the terminal 102 can be, but is not limited to, various personal computers and laptops.

[0049] In an exemplary embodiment, Figure 2 As shown, an order processing method is provided, which is applied to Figure 1 The terminal 102 is used as an example for explanation, and the following steps are included:

[0050] S202, after successfully logging into the user account on the target platform, enter the order page of the target platform.

[0051] The target platform refers to the e-commerce platform, enterprise management platform or any order-related system platform where users perform order processing operations.

[0052] A user account refers to the unique identity used by a user to register and log in on a target platform (such as an e-commerce platform, enterprise management platform, or order processing system).

[0053] The order page refers to a page on the target platform (such as an e-commerce platform, enterprise management system, etc.) that is specifically used to display, manage and process order information.

[0054] Specifically, the terminal can pre-install an order collection tool on the browser, and run the order collection tool when order data collection is needed. The order collection tool controls the browser to open the target platform, the account and password of the target platform and automatically log in. After successfully logging in to the user account on the target platform, it automatically enters the order page.

[0055] Among them, when the order collection tool is used to control the browser to open the target platform, the order collection tool can also shield the automation features through code injection and other methods to avoid being detected by the platform to ensure the execution of order data collection.

[0056] For example, the terminal uses Selenium to control the browser to open the order page of the e-commerce platform and automatically log in to the account. The system shields the browser's automated feature identification by injecting JavaScript code to reduce the platform's automated detection. Selenium is an open source automated testing tool that allows developers and testers to use programming languages ​​(such as Python, Java, C#, Ruby, etc.) to control and operate the browser.

[0057] S204, in response to the order collection operation on the order page, order collection is performed on the order page to obtain order information.

[0058] The order collection operation may be a user clicking a collection button on an order page, or may be an automatic triggering operation of an order collection tool after entering the order page.

[0059] Specifically, in response to the order collection operation on the order page, the terminal locates the order on the order page through the order collection tool, and traverses the information contained in each order, such as the order number, logistics number, product identification, product name, quantity, price, order time and other information. If the order information is displayed across multiple pages (for example, paginated display), the order collection tool can also automatically trigger a click operation on "next page" to turn to the next page until the order information of all orders has been collected, and the collected order information is stored, specifically in a database, a CSV file, or an Excel spreadsheet, etc.

[0060] Among them, the product identification is a mark or code used to uniquely identify the product, which can be specifically the SKU (Stock Keeping Unit) identification. SKU (Stock Keeping Unit) is a unique identifier used to identify and track product inventory. Each SKU represents an independent product, and each product has its own unique SKU. SKU is a code composed of letters and numbers, which can be defined by manufacturers, retailers or e-commerce platforms for classification, management and storage of products.

[0061] For example, the terminal collects order information on the order page through Selenium. If the order information is displayed across multiple pages, after each page is processed, the collected data is temporarily stored in a data structure in memory (such as ArrayList), and unused data is cleaned up regularly. Figure 3 It is a schematic diagram of collecting order information in an embodiment.

[0062] S206, parsing the product basic specification template and the product logistics specification template to obtain basic specification information and logistics specification information of the order product in the order information.

[0063] The basic product specification template defines the core features of the product, which may be related to the physical properties, technical parameters and appearance design of the product. It may include product identification and corresponding specification information. The specification information may include product model, size, weight, color, material, power, capacity, brand, applicable scenarios and other information. Figure 4 A schematic diagram of a basic product specification template.

[0064] The product logistics specification template defines key attributes related to product transportation, storage and distribution, which may include product identification and corresponding logistics specification information. The logistics specification information may include product weight, packaging size, packaging weight, packaging materials, carriers and other information. Figure 5 A schematic diagram of a product logistics specification template in one embodiment.

[0065] Specifically, the terminal obtains the product basic specification template and the product logistics specification template, and calls the file parsing interface to parse the product basic specification template and the product logistics specification template to obtain the parsing result, and extracts the basic specification information and logistics specification information of the order product in the order information from the parsing result.

[0066] In one embodiment, the order information includes a product identification of the order product, and the terminal parses the product basic specification template and the product logistics specification template to obtain the basic specification information and logistics specification information of the order product in the order information. The process includes the following steps: parsing the product basic specification template and the product logistics specification template to obtain basic specification information of multiple products and logistics specification information of multiple products; extracting the basic specification information and logistics specification information of the order product from the basic specification information of multiple products and the logistics specification information of multiple products based on the product identification.

[0067] Specifically, the terminal obtains the product basic specification template and the product logistics specification template, and calls the file parsing interface to parse the product basic specification template and the product logistics specification template to obtain basic specification information corresponding to multiple product identifiers and logistics specification information corresponding to multiple product identifiers. The terminal extracts the product identifier from the collected order information, and extracts the basic specification information of the order product corresponding to the product identifier in the order information from the basic specification information corresponding to the multiple product identifiers, and extracts the logistics specification information of the order product corresponding to the product identifier in the order information from the logistics specification information corresponding to the multiple product identifiers.

[0068] For example, the terminal reads various local template files (such as SKU templates, weight templates, power specification templates, etc.) and parses their contents in a tabular form. During the parsing process, each row of data is mapped to a key-value pair structure (such as HashMap) for subsequent processing. Then, the system matches the collected order information with the parsed template data, compares the SKU and weight information based on the transaction number, and generates an order segmentation list containing SKU, product weight, logistics number, etc. Among them, HashMap is a commonly used data structure in Java and belongs to the implementation class of the Map interface. It stores data in the form of key-value pairs, so that the corresponding value can be quickly retrieved according to the key.

[0069] S208, filling in the standard template based on the order information and the basic specification information and logistics specification information of the order product in the order information to obtain a target order file.

[0070] A standard template is a predefined file or structure, usually used to store and process information in a standardized manner. It defines the format, structure, and layout of the file to ensure that data can be consistently input, processed, and output in different systems or processes. The format of a standard template can be an Excel file (.xls or .xlsx), a CSV file, an XML file, etc., and can be set according to business needs and data processing methods.

[0071] Specifically, the terminal can obtain the standard template to be filled, load the template file of the standard template, and find the fields or placeholders that need to be filled in the standard template, fill the extracted order information into the corresponding position in the template, and fill the corresponding basic specification information and logistics specification information extracted into the corresponding position in the template according to the product identification (such as SKU identification) of the order product in the order information. After filling, save the file in the target format (such as Excel, CSV, etc.). This file is the target order file, which contains the filled order data. In addition, according to business needs, you can choose to save the target order file in a local folder, store it in the cloud, or send it to relevant personnel by email or other means.

[0072] It should be noted that during the filling process, the cell format of each field is strictly defined in accordance with the template and remains consistent. For example, after the order is broken down into individual products, the system matches the SKU and logistics number one by one to ensure that the SKU information and power specifications match accurately. After the filling is completed, the system stores the file in the specified output directory.

[0073] In addition, verification and fault-tolerance mechanisms can also be executed during the entire data flow processing. For example, before and after each key step such as collecting order information, matching templates, and exporting files, check whether the file exists and whether the data format is correct. If an error occurs, a prompt box will pop up to display specific exception information (such as "order not imported", "weight template does not exist", etc.). During the data filling stage, if key fields such as weight and SKU are found to be missing, the system will skip the line or fill in default values ​​to ensure the structure of the exported target order file is complete.

[0074] In addition, when implementing the above order processing method, a user interaction interface can also be provided, such as a JFrame window, to display the file path selection, data import, error prompts and other contents to facilitate user operation. The user can select the order file path through the "Browse" button, start data processing through the "Start" button, and view the import and export status through the pop-up window.

[0075] In the above order processing method, after successfully logging into the user account on the target platform, the order page of the target platform is automatically entered. In response to the order collection operation on the order page, order collection is performed on the order page to obtain order information, thereby avoiding the tedious operation of manual search and manual entry into the order page. Through automated order collection, order information can be quickly obtained, thereby avoiding the time waste and information omission problems of manual search. The product basic specification template and the product logistics specification template are automatically parsed to obtain the basic specification information and logistics specification information of the order product in the order information, thereby ensuring the accuracy of the relevant information of the acquired order product. The standard template is filled in based on the order information and the basic specification information and logistics specification information of the order product in the order information to obtain the target order file, thereby avoiding errors and inefficiencies in manual processing, reducing the risk of data loss and format inconsistency, and improving the accuracy of order processing.

[0076] In one embodiment, the above-mentioned order processing method also includes the following steps: if the target basic specification information and the target logistics specification information corresponding to the target product identifier are not found from the basic specification information of multiple products and the logistics specification information of multiple products, then generating abnormal prompt information based on the order information corresponding to the target product identifier; outputting the abnormal prompt information and the order information adjustment box; in response to the adjusted product identifier input in the order information adjustment box, extracting the basic specification information and the logistics specification information of the order product from the basic specification information of multiple products and the logistics specification information of multiple products based on the adjusted product identifier.

[0077] Specifically, the terminal searches for the basic specification information of the order product corresponding to the product identifier in the order information in the basic specification information corresponding to the multiple product identifiers, and searches for the logistics specification information of the order product corresponding to the product identifier in the order information in the logistics specification information corresponding to the multiple product identifiers. It can be understood that there can be multiple product identifiers in the order information. If the target basic specification information and the target logistics specification information corresponding to the target product identifier are not found, it may be that the target product identifier in the collected order information is incorrect. Then, an abnormal prompt information can be generated based on the order information corresponding to the target product identifier, and displayed with the generated abnormal prompt information so that the user can check and verify the abnormal target product identifier. At the same time, an order information adjustment box can also be displayed. The user can enter the adjusted product identifier in the order information adjustment box. The terminal responds to the adjusted product identifier entered in the order information adjustment box, and extracts the basic specification information and logistics specification information of the order product corresponding to the adjusted product identifier in the order information from the basic specification information of multiple products and the logistics specification information of multiple products based on the adjusted product identifier. In addition, the terminal also replaces the target product identifier in the collected order information based on the adjusted product identifier to obtain the updated order information.

[0078] In the above embodiment, when the terminal fails to find the target product identification from the basic specifications and logistics specification information, it generates exception prompt information in time, which can avoid filling erroneous data into the final order file; allowing users to quickly adjust the product identification when facing an exception without interrupting the entire order processing flow. By introducing exception prompts and order information adjustment boxes in the order processing process, this design method effectively reduces data errors, improves data accuracy, and enhances system flexibility.

[0079] In one embodiment, the standard template includes general fields, which include basic order fields, basic product specification fields and basic logistics specification fields; the terminal fills the standard template based on the order information and the basic specification information and logistics specification information of the order product in the order information, and the process of obtaining the target order file includes the following steps: determining the basic order field value corresponding to the basic order field in the order information, determining the basic product specification field value corresponding to the basic product specification field in the basic specification information, and determining the basic logistics specification field value corresponding to the basic logistics specification field in the basic specification information; filling the basic order field, basic product specification field and basic logistics specification field in the standard template based on the basic order field value, basic product specification field value and basic logistics specification field value to obtain the target order file.

[0080] Among them, the basic order fields refer to the basic fields that describe the order, such as the order number, the product name of the order product, the product identification of the order product, the transaction quantity corresponding to the order product, etc. The basic product specification fields are the fields that describe the basic specifications of the product, such as the product name, product identification, product model, product color, product size, product weight, product material, product function, etc. The basic logistics specification fields are the fields that describe the basic specifications of the product logistics, such as the logistics number, packaging size, packaging weight, product weight, transportation company, freight unit price, etc.

[0081] For example, the terminal fills in the order number, product name, product identification and transaction quantity in the order information into the corresponding positions of the standard template, fills in the product model, color, size, weight and other information in the product specification information into the corresponding positions of the standard template, and fills in the logistics number, packaging size, packaging weight, product weight, transportation company, freight unit price and other information in the logistics specification information into the corresponding positions of the standard template, such as Figure 6 The figure shows a target order file obtained after filling in a standard template in one embodiment.

[0082] In the above embodiment, the terminal can ensure that the data in each field is accurate when filling in the data by matching the values ​​of the basic order field, basic product specification field and basic logistics specification field in the order information with the corresponding fields in the standard template. By automatically filling in the template, the time for manual search and entry is saved, which can greatly improve the processing efficiency, especially when the order quantity is large.

[0083] In one embodiment, the standard template also includes derived fields; the terminal fills the basic product specification field and the basic logistics specification field in the standard template based on the basic product specification field value and the basic logistics specification field value, and the process of obtaining the target order file includes the following steps: determining the target field associated with the derived field in the basic information; the basic information includes at least one of the basic specification information and the logistics specification information; according to the processing method associated with the derived field, the field value corresponding to the target field is processed to obtain the derived field value; based on the basic order field value, the basic product specification field value, the basic logistics specification field value and the derived field value, the basic product specification field, the basic logistics specification field and the derived field in the standard template are filled respectively to obtain the target order file.

[0084] Among them, a derived field refers to a field whose field value needs to be calculated based on the values ​​of other fields. The target fields associated with a derived field refer to the basic data fields used to calculate or derive the derived field. For example, the derived field is the order cost field, which is a field calculated based on the product cost plus the logistics cost in the order. The target field can be the purchase unit price and logistics unit price of the product. The processing method of the derived field association refers to the logic or algorithm used to calculate the derived field value, which describes how to calculate the value of the derived field based on the values ​​of other fields.

[0085] Specifically, the terminal determines the derived fields in the standard template, and searches for the target field corresponding to the derived field in at least one of the basic specification information and the logistics specification information, and obtains the field value corresponding to the target field, and processes the field value corresponding to the target field according to the processing method associated with the derived field to obtain the derived field value; based on the basic order field value, the basic product specification field value, the basic logistics specification field value and the derived field value, the basic product specification field, the basic logistics specification field and the derived field in the standard template are filled in respectively to obtain the target order file.

[0086] like Figure 7 The target order file obtained after filling another standard template in one embodiment is shown, and the standard template includes a derived field "order cost field".

[0087] In the above embodiment, by using derived fields in the standard template, the terminal can not only automatically process the basic information in the order, but also further improve the accuracy, completeness and consistency of the data. The calculation and automatic filling of derived fields provide more intelligent support for order processing, improve efficiency, reduce manual operation errors, and also enhance data analysis capabilities and business decision support.

[0088] In one embodiment, the above-mentioned order processing method also includes the following steps: displaying a candidate template list; the candidate template list includes at least one candidate standard template; in response to an editing operation on a target standard template in the candidate template list, displaying a template editing page; in response to a derivative field adding operation triggered on the target editing page, generating an updated standard template containing the added derivative field; in response to a selection operation triggered on the candidate template list, determining the standard template specified by the selection operation as the standard template to be filled with fields.

[0089] Among them, the editing operation can specifically be an operation of clicking on the edit button; the template editing page is used to allow users to modify and customize the details of the template. Specifically, the regular fields or derived fields in the template can be modified on the target editing page, and the corresponding processing method of the derived fields can be set.

[0090] In one embodiment, the terminal displays a template editing page in response to an editing operation on a target standard template in a candidate template list, obtains new derived fields added by the user in response to a derivative field adding operation triggered on the target editing page, and generates an updated standard template containing the added derived fields based on the new derived fields; or obtains derived fields modified by the user in response to a derivative field modification operation triggered on the target editing page, and generates an updated standard template containing the modified derived fields based on the modified derived fields.

[0091] In one embodiment, the user can select the candidate standard templates in the displayed candidate template list, that is, select the standard template he wants to use. In response to the selection operation triggered in the candidate template list, the terminal determines the standard template specified by the selection operation as the standard template to be filled in the fields. After that, the collected order information and the basic specification information and logistics specification information of the order products in the order information can be filled into the selected standard template to obtain the target order file.

[0092] In the above embodiment, the terminal effectively improves the automation and efficiency of order processing, reduces human errors, ensures data consistency, and improves user experience and system maintainability through flexible template management, automatic calculation of derived fields, and custom functions of templates. These advantages work together to optimize the company's order management process, improve work efficiency, and adapt to changing business needs.

[0093] The present application also provides an application scenario, which applies the above order processing method. The order processing can be implemented through an order processing system, which includes a data collection and preprocessing module, a data analysis and processing module, an Excel filling and exporting module, a data verification and fault tolerance module, and an interface display module. The data collection and preprocessing module is used to control the browser to open the order page of the e-commerce platform with the help of Selenium and automatically log in to the account. The system shields the browser's automatic feature identification by injecting JavaScript code to reduce the platform's automatic detection. After successful login, the system uses Selenium to identify the order items on the page, and gradually turns the pages to obtain key information such as transaction numbers and logistics numbers of all orders; the data parsing and processing module is used to process and read and export data from Excel templates based on the Apache POI tool; the Excel filling and exporting module is used to open various template files stored locally, and fill in the corresponding fields line by line according to the order data. For each order line, the system writes information such as logistics number, transaction number, SKU, product name and weight. During the filling process, the cell format of each field is strictly defined in accordance with the template definition and remains unified. After the order is decomposed into a single product, the system matches the SKU and logistics number one by one to ensure that the SKU information and power specifications match accurately. After filling, the system stores the file in the specified output directory; the data verification and fault tolerance module is used to check whether the file exists and whether the data format is correct before and after each key step such as collecting order information, matching templates, and exporting files. If an error occurs, a prompt box will pop up to display specific abnormal information (such as "order not imported", "weight template does not exist", etc.). During the data filling stage, if key fields such as weight and SKU are found to be missing, the system will skip the row or fill in default values ​​to ensure that the exported Excel file structure is complete; the interface display module is used to provide a JFrame window to display file path selection, data import, error prompts and other content to facilitate user operation. Users can select the order file path through the "Browse" button, start data processing through the "Start" button, and view the import and export status through the pop-up window.

[0094] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0095] Based on the same inventive concept, the embodiment of the present application also provides an order processing device for implementing the order processing method involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations in one or more order processing device embodiments provided below can refer to the limitations on the order processing method above, and will not be repeated here.

[0096] In an exemplary embodiment, Figure 8 As shown, an order processing device is provided, including: an order page entry module 802, an order collection module 804, a specification information acquisition module 806 and a data filling module 808, wherein:

[0097] The order page entry module 802 is used to enter the order page of the target platform after successfully logging into the user account on the target platform;

[0098] An order collection module 804 is used to collect orders on the order page in response to an order collection operation on the order page to obtain order information;

[0099] The specification information acquisition module 806 is used to parse the product basic specification template and the product logistics specification template to obtain the basic specification information and logistics specification information of the order product in the order information;

[0100] The data filling module 808 is used to fill the standard template based on the order information and the basic specification information and logistics specification information of the order products in the order information to obtain the target order file.

[0101] In the above embodiment, after the target platform successfully logs in to the user account, the order page of the target platform is automatically entered. In response to the order collection operation on the order page, order collection is performed on the order page to obtain order information, thereby avoiding the tedious operation of manual search and manual entry into the order page. Through automated order collection, order information can be quickly obtained, thereby avoiding the time waste and information omission problems of manual search. The product basic specification template and the product logistics specification template are automatically parsed to obtain the basic specification information and logistics specification information of the order product in the order information, thereby ensuring the accuracy of the relevant information of the acquired order product. The standard template is filled in based on the order information and the basic specification information and logistics specification information of the order product in the order information to obtain the target order file, thereby avoiding errors and inefficiencies in manual processing, reducing the risk of data loss and format inconsistency, and improving the accuracy of order processing.

[0102] In one of the embodiments, the order information includes a product identification of the order product; the specification information acquisition module 806 is also used to: parse the product basic specification template and the product logistics specification template to obtain basic specification information of multiple products and logistics specification information of multiple products; based on the product identification, extract the basic specification information and logistics specification information of the order product from the basic specification information of multiple products and the logistics specification information of multiple products.

[0103] In one of the embodiments, the device also includes an information adjustment module, which is used to: generate abnormal prompt information based on the order information corresponding to the target product identifier if the target basic specification information and the target logistics specification information corresponding to the target product identifier are not found from the basic specification information of multiple products and the logistics specification information of multiple products; output the abnormal prompt information and the order information adjustment box; in response to the adjusted product identifier input in the order information adjustment box, extract the basic specification information and logistics specification information of the order product from the basic specification information of multiple products and the logistics specification information of multiple products based on the adjusted product identifier.

[0104] In one embodiment, the standard template includes general fields, and the general fields include basic product specification fields and basic logistics specification fields; the data filling module 808 is also used to: determine the basic order field value corresponding to the basic order field in the order information, determine the basic product specification field value corresponding to the basic specification information of the basic product specification field, and determine the basic logistics specification field value corresponding to the basic specification information of the basic logistics specification field; based on the basic order field value, the basic product specification field value and the basic logistics specification field value, the basic order field, the basic product specification field and the basic logistics specification field in the standard template are filled to obtain the target order file.

[0105] In one of the embodiments, the standard template also includes derived fields; the data filling module 808 is also used to: determine the target field associated with the derived field in the basic information; the basic information includes at least one of basic specification information and logistics specification information; according to the processing method associated with the derived field, the field value corresponding to the target field is processed to obtain the derived field value; based on the basic order field value, the basic product specification field value, the basic logistics specification field value and the derived field value, the basic product specification field, the basic logistics specification field and the derived field in the standard template are filled respectively to obtain the target order file.

[0106] In one of the embodiments, the device also includes a standard template determination module, which is used to: display a candidate template list; the candidate template list includes at least one candidate standard template; in response to an edit operation on a target standard template in the candidate template list, display a template editing page; in response to a derivative field adding operation triggered on the target editing page, generate an updated standard template including the added derivative field; in response to a selection operation triggered on the candidate template list, determine the standard template specified by the selection operation as the standard template to be filled in the field.

[0107] Each module in the above order processing device can be implemented in whole or in part by software, hardware or a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute the operations corresponding to each module.

[0108] In an exemplary embodiment, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as shown in FIG. Fig. 9As shown. The computer device includes a processor, a memory, an input / output interface, a communication interface, a display unit and an input device. The processor, the memory and the input / output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The input / output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be implemented through WIFI, a mobile cellular network, near field communication (NFC) or other technologies. When the computer program is executed by the processor, an order processing method is implemented. The display unit of the computer device is used to form a visually visible picture, which can be a display screen, a projection device or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, trackball or touchpad set on the computer device shell, or an external keyboard, touchpad or mouse.

[0109] Those skilled in the art will understand that Fig. 9 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0110] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above-mentioned method embodiments when executing the computer program.

[0111] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0112] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0113] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0114] A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment method can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile memory and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, an artificial intelligence (AI) processor, etc., but are not limited to this.

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

[0116] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. An order processing method, characterized in that: The method comprises: After successfully logging into the target platform, enter the target platform's order page; In response to an order collection operation on the order page, order collection is performed on the order page to obtain order information; Parsing the product basic specification template and the product logistics specification template to obtain basic specification information and logistics specification information of the order product in the order information; The standard template is filled based on the order information and the basic specification information and logistics specification information of the order products in the order information to obtain a target order file.

2. The method according to claim 1, characterized in that The order information includes a product identifier of the order product; the basic product specification template and the product logistics specification template are parsed to obtain the basic specification information and logistics specification information of the order product in the order information, including: Parsing the product basic specification template and the product logistics specification template to obtain basic specification information of multiple products and logistics specification information of the multiple products; Based on the product identification, basic specification information and logistics specification information of the order product are extracted from the basic specification information of the multiple products and the logistics specification information of the multiple products.

3. The method according to claim 2, characterized in that The method further comprises: If the target basic specification information and the target logistics specification information corresponding to the target product identifier are not found from the basic specification information of the multiple products and the logistics specification information of the multiple products, generating abnormal prompt information based on the order information corresponding to the target product identifier; Output the abnormal prompt information and order information adjustment box; In response to the adjusted product identification input in the order information adjustment box, the basic specification information and logistics specification information of the order product are extracted from the basic specification information of the multiple products and the logistics specification information of the multiple products based on the adjusted product identification.

4. The method according to claim 1, characterized in that: The standard template includes conventional fields, including basic order fields, basic product specification fields, and basic logistics specification fields; the standard template is filled based on the order information and the basic specification information and logistics specification information of the order product in the order information to obtain a target order file, including: Determine the basic order field value corresponding to the basic order field in the order information, determine the basic product specification field value corresponding to the basic product specification field in the basic specification information, and determine the basic logistics specification field value corresponding to the basic logistics specification field in the basic specification information; The basic order field, the basic product specification field and the basic logistics specification field in the standard template are filled based on the basic order field value, the basic product specification field value and the basic logistics specification field value to obtain a target order file.

5. The method according to claim 4, characterized in that The standard template also includes a derived field; the basic product specification field and the basic logistics specification field in the standard template are filled based on the basic product specification field value and the basic logistics specification field value to obtain a target order file, including: Determining a target field associated with the derived field in basic information; the basic information includes at least one of basic specification information and logistics specification information; According to the processing method associated with the derived field, the field value corresponding to the target field is processed to obtain a derived field value; Based on the basic order field value, the basic product specification field value, the basic logistics specification field value and the derived field value, the basic product specification field, the basic logistics specification field and the derived field in the standard template are filled respectively to obtain the target order file.

6. The method according to claim 1, characterized in that The method comprises: Displaying a candidate template list; the candidate template list includes at least one candidate standard template; In response to an editing operation on a target standard template in the candidate template list, displaying a template editing page; In response to a derived field adding operation triggered on the target editing page, generating an updated standard template including the added derived field; In response to a selection operation triggered in the candidate template list, the standard template specified by the selection operation is determined as the standard template to be filled in the field.

7. An order processing device, characterized in that: The device comprises: The order page entry module is used to enter the order page of the target platform after successfully logging into the user account on the target platform; An order collection module, configured to, in response to an order collection operation on the order page, collect orders on the order page to obtain order information; A specification information acquisition module is used to parse the product basic specification template and the product logistics specification template to obtain the basic specification information and logistics specification information of the order product in the order information; The data filling module is used to fill the standard template based on the order information and the basic specification information and logistics specification information of the order products in the order information to obtain the target order file.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images