CN115147049A - Order batch loading method, device, storage medium and computer equipment - Google Patents

Abstract

The embodiment of the application discloses an order batch loading method and device, a storage medium and computer equipment, and relates to the field of data processing. According to the method and the system, a large quantity of order data with different data sources, different service modes and different order states are efficiently and stably loaded into the enterprise information management system through data acquisition, data verification, data conversion, data filling and automatic loading and order pushing of the pre-configured data model. The problems of low order data loading efficiency, high cost and high error probability in the prior art are solved, and the timeliness of enterprise internal business processing can be effectively improved.

Description

Order batch loading method, device, storage medium and computer equipment

technical field

The present application relates to the field of financial risk prediction, and in particular, to a method, device, storage medium and computer equipment for batch loading of orders.

Background technique

In order to enhance market competitiveness, expanding sales channels and adopting different sourcing and procurement methods have become the choices of more and more enterprises, which determines the diversity of data sources for enterprise material procurement and sales orders. difference. For group-type enterprises involved in e-commerce procurement and sales business scenarios, the number of orders is huge. Group companies usually use enterprise information management systems (such as ERP systems, etc.) for order fulfillment process, cost accounting and payment and settlement management. In the case of various order sources and huge order data, how to quickly and effectively load order data into the enterprise information management system as the basis for subsequent business processing has always been a concern of material management-related business personnel and information system technicians. Problems with loading order data in the prior art include:

1. There are many sources of order data, and data collection is difficult. Orders from multiple sources offline and online (and online also involves multiple different e-commerce platforms) usually have different data types and integrity, which makes it difficult to collect data in batches.

2. Different order statuses make it difficult to process them differently. Due to different business models, the purchasing and sales business is not synchronized with the system data loading and other factors, there are situations in which the order status and subsequent business processing requirements are different when data collection and loading are loaded. Different business models and different status orders have different requirements when loading into the system. , for example: only a sales order needs to be formed when an order in the initial state of self-operated stocking mode is loaded; a sales order and corresponding purchase order must be formed when an order in the initial state of self-operated consignment mode is loaded; the order in the delivery state of self-operated consignment mode needs to form sales, Purchase order, purchase receipt, and sales issue.

3. The amount of order data is large, and it is difficult to process in batches. Due to the large volume of business, large group companies usually have a large number of orders. Especially in the e-commerce procurement and sales model, the monthly order volume can reach hundreds of thousands. For a series of complex transactions such as processing and pushing orders, it is difficult to efficiently batch data load processing.

Based on the above situation, the traditional way of order data loading generally adopts manual order-by-order entry or segmented integration of data in each business link (different data items such as orders and storage orders are supported by different data interfaces. If some business data does not have an integrated source, use the Partial integration, part manual entry), low efficiency, high cost, and the risk of human error due to manual establishment of upstream and downstream data associations.

SUMMARY OF THE INVENTION

The embodiments of the present application provide a method, apparatus, storage medium and computer equipment for batch loading of orders, which can solve the problems of low efficiency, high cost and error-proneness in manual loading of order data in the prior art. The technical solution is as follows:

In a first aspect, an embodiment of the present application provides a method for batch loading of orders, the method comprising:

Collect raw order data;

verifying the original order data;

After the verification is passed, the original order data is converted into enterprise order data supported by the enterprise information management system;

writing the enterprise order data into the database;

Read the enterprise order data from the database, and parse the business model and order status of the enterprise order data;

Determine the document type to be generated according to the business model and order status;

Preprocessing the enterprise order data to obtain complete data required by the document type;

Generate one or more target documents according to the complete data, and establish the upstream and downstream associations of each target document;

Assign a document number to the generated target document, and write the target document and specified field information into the order execution ledger of the enterprise information management system according to the document number, so as to complete the loading of the original order data .

In a second aspect, an embodiment of the present application provides an order batch loading device, the device comprising:

an order data collection unit for collecting original order data; verifying the original order data; after the verification is passed, converting the original order data into enterprise order data supported by an enterprise information management system; data is written to the database;

an order data loading unit, configured to read the enterprise order data from the database, and parse the business mode and order status of the enterprise order data; determine the document type to be generated according to the business mode and the order status; Preprocessing the enterprise order data to obtain complete data required by the document type; generating one or more target documents according to the complete data, and establishing the upstream and downstream associations of each target document; for the generated target document Allocating a document number, and writing the target document and specified field information into the order execution ledger of the enterprise information management system according to the document number, so as to complete the loading of the original order data.

In a third aspect, an embodiment of the present application provides a computer storage medium, where the computer storage medium stores a plurality of instructions, and the instructions are suitable for being loaded by a processor and executing the above method steps.

In a fourth aspect, an embodiment of the present application provides a computer device, which may include: a processor and a memory; wherein, the memory stores a computer program, and the computer program is adapted to be loaded by the processor and execute the above method steps .

The beneficial effects brought by the technical solutions provided by some embodiments of the present application include at least:

Execute data collection, data verification, data conversion, data filling and automatic loading of push orders through the pre-configured data model, and realize the efficient and stable loading of large batches of order data from different data sources, different business models, and different order statuses into enterprise information management system. Solving the problems of low efficiency, high cost and error-proneness in order data loading in the prior art can effectively improve the timeliness of internal business processing of the enterprise.

Description of drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the following briefly introduces the accompanying drawings required for the description of the embodiments or the prior art. Obviously, the drawings in the following description are only These are some embodiments of the present application. For those of ordinary skill in the art, other drawings can also be obtained based on these drawings without any creative effort.

1 is a schematic diagram of a network architecture provided by an embodiment of the present application;

2 is a schematic flowchart of a method for batch loading of orders provided by an embodiment of the present application;

3 is a schematic diagram of a form template provided by an embodiment of the present application;

4 is a schematic diagram of a message format of an e-commerce server provided by an embodiment of the present application;

5 is a schematic diagram of a configuration table of a verification rule provided by an embodiment of the present application;

6 is a structural block diagram of an order batch loading device provided by the present application;

FIG. 7 is a structural block diagram of a computer device provided by the present application.

Detailed ways

In order to make the objectives, technical solutions and advantages of the present application clearer, the embodiments of the present application will be described in further detail below with reference to the accompanying drawings.

It should be noted that the method for batch loading of orders provided in this application is generally performed by computer equipment, and correspondingly, the apparatus for batch loading of orders is generally set in the computer equipment.

FIG. 1 shows an exemplary system architecture of an order batch loading method or an order batch loading apparatus that can be applied to the present application.

As shown in FIG. 1 , the system architecture may include: a computer device 101 and a server 102 . Communication between the computer device 101 and the server 102 may be performed through a network, and the network is used as a medium for providing communication links between the above-mentioned various units. The network may include various types of wired communication links or wireless communication links, for example: wired communication links include optical fibers, twisted pair or coaxial cables, etc. -FIdelity, Wi-Fi) communication link or microwave communication link, etc.

The computer device 101 collects the original order data, processes the original order data, and loads the processed order data into the enterprise information management system deployed in the server 102 .

It should be noted that the computer device 101 and the server 102 may be hardware or software. When the computer device 101 and the server 102 are hardware, they may be implemented as a distributed server cluster composed of multiple servers, or may be implemented as a single server. When the computer device 101 and the server 102 are software, they may be implemented as multiple software or software modules (for example, for providing distributed services), or may be implemented as a single software or software module, which is not specifically limited herein.

Various communication client applications can be installed on the computer equipment of the present application, such as video recording applications, video playback applications, voice interaction applications, search applications, instant communication tools, email clients, social platform software, and the like.

Computer equipment can be hardware or software. When the computer device is hardware, it can be a variety of computer devices having a display screen, including but not limited to smartphones, tablet computers, laptop computers, desktop computers, and the like. When the computer equipment is software, it can be installed in the computer equipment listed above. It can be implemented as multiple software or software modules (for example, used to provide distributed services), or can be implemented as a single software or software module, which is not specifically limited here.

When the computer device is hardware, a display device and a camera can also be installed on it. The display device can be a variety of devices that can realize the display function, and the camera is used to capture video streams; for example, the display device can be a cathode ray tube display ( Cathode ray tube display (CR), light-emitting diode display (LED), electronic ink screen, liquid crystal display (LCD), plasma display panel (PDP), etc. . The user can use the display device on the computer device to view the displayed text, picture, video and other information.

It should be understood that the numbers of computer devices, networks, and servers in FIG. 1 are merely illustrative. There can be any number of computer devices, networks, and servers, depending on the implementation needs.

The method for batch loading of orders provided by the embodiment of the present application will be described in detail below with reference to FIG. 2 . The apparatus for batch loading of orders in this embodiment of the present application may be the computer device shown in FIG. 1 .

Referring to FIG. 2 , a schematic flowchart of a method for batch loading orders is provided in an embodiment of the present application. As shown in FIG. 2 , the method of the embodiment of the present application may include the following steps:

S201. Collect original order data.

Among them, the original order data represents the attributes of the order, and the computer equipment can collect the original order data through online or offline methods. The offline method is: the computer equipment provides a form template, the user fills in the form template, and the final form is obtained after the filling is completed. Electronic form, the computer equipment collects the original order data based on the electronic form, and the offline method is: the computer equipment is pre-configured with an integrated interface, and the e-commerce platform calls the integrated interface to push the original order data to the computer equipment. The quantity of the original order data collected by the computer equipment may be one or more pieces.

In this embodiment, the data model of the original order data is uniformly defined, and the original order data includes multiple fields and field values of each field; the fields of the original order data are further divided into main table fields and sub-table fields, and the main table fields represent The basic information of the order, the sub-table field represents the attribute information of the material. Further, the main table fields are: one or more of order ID, order date, salesperson ID, business department ID, customer ID, sales type, e-commerce platform, order status and business model; the sub table fields are: One or more of Supplier ID, Item ID, Material ID, Material ID, Quantity, Tax Rate, Cost Amount, and Sales Amount.

For example, referring to the schematic diagram of the table template shown in FIG. 3, the computer equipment device displays the table template shown in FIG. 3 through the display unit. The first cell of each column in the table template corresponds to a field, and the table template contains multiple fields. It will not be repeated here. Each field is configured with filling requirements. For example: for the order date, the filling requirements are: fill in the date in yyyy/mm/dd format, for example: 2020/07/01, the user fills in according to the filling requirements to improve the accuracy Rate. Specifically, each row corresponds to a piece of original order data, and the user can fill in field values in the cells of the form template through an input device (eg, mouse, keyboard, touch screen, etc.). Further, the multiple fields included in the table template are divided into two types: main table fields and sub table fields. The cells where the main table fields and sub table fields are located can be distinguished by different fill colors, for example: The fill color of the cell is dark gray, and the fill color of the cell where the subtable field is located is light gray. Further, the multiple fields included in the form template are divided into required fields and optional fields. Required fields and optional fields can be distinguished by different colors. For example, the font color of required fields is red, and the font color of optional fields is red. The font color of the field is black, the required field indicates the field that the user must fill in the field value, the optional field indicates the field that the user can optionally fill in the field value, if the computer device detects that the cell of the column where the required field is located does not have the field value filled , an error will be reported to the user.

For example, see Figure 4, which is a schematic diagram of a message. The e-commerce platform pushes a message to a computer device through the message format shown in Figure 4. The message includes input parameters and output parameters. The input parameters and output parameters are shown in Figure 4. , which is not repeated here, the computer device receives the message pushed from the e-commerce platform, parses the message to obtain the field value of each field, and generates the original order data based on the field value obtained by the analysis.

S202, verify the original order data.

Among them, the computer device is preconfigured with verification rules, and the verification rules are used to verify the field value of each field in the original order data. Different fields are associated with different verification rules, and the computer device detects the field value of a certain field. When the verification fails, a verification prompt message will be displayed through the display unit. Further, the transaction rules include integrity check and compliance check. The integrity check is used to check whether the field value of each field in the original order data is empty, and the compliance check is used to check the field value. is within the preset range.

For example, referring to the configuration table of the verification rules shown in Figure 5, the configuration table is configured with the verification rules and verification prompts of each field. For example, the verification rules for the order date are: required fields and the format is YYYY -MM-DD, the computer device detects whether the field value of the order date is filled in based on the verification rule. If it is not, it will display the verification prompt "Required fields cannot be empty" through the display unit; check whether the filling format of the order date is YYYY-MM-DD, if not, the verification prompt "The date format must be YYYY-MM-DD" will be displayed on the display unit. The verification rules and verification prompts of other fields in the configuration table can be referred to as shown in FIG. 5, and will not be repeated here.

S203, after the verification is passed, convert the original order data into enterprise order data supported by the enterprise information management system.

Among them, the enterprise information management system may not be able to identify some fields and field values in the original order data. At this time, the computer equipment can convert the field information (ie fields and field values) in the original order data according to the preset mapping conversion table. It is the field information identifiable by the enterprise information management system. For example, the field information includes the following fields: material name, transaction unit, etc., which are converted to obtain enterprise order data.

S204, write the enterprise order data into the database.

Among them, the database is generally a relational database, such as a SQL database, etc., the enterprise order data is written into the data table in the database, and the user can view, modify and delete the enterprise order data in the database.

S205, read the enterprise order data from the database, and analyze the business mode and order status of the enterprise order data.

Among them, the enterprise order data includes fields of business model and order status.

S206. Determine the document type to be generated according to the business model and the order status.

Among them, the computer equipment is pre-configured with the business model and the mapping type between the order status and the document type. Different order statuses and business models are associated with different document types. The business model includes self-operated consignment sales, self-operated stockpiling and platform services. Including pending shipment, pending receipt and pending settlement.

Among them, self-operated consignment sales are a type of self-operated sales. The profit model is mainly to earn the price difference between sales and purchases. The business includes the complete business process of purchase, sales, warehousing, and warehousing, but there is no inventory, and customers place orders (sales orders). ), the corresponding purchase order is automatically generated and pushed to the supplier, and the supplier will deliver the goods directly, but the settlement is still between the customer and the e-commerce company, and the e-commerce company and the supplier.

Self-operated stocking is also a kind of self-operated. The profit model is the same as self-operated consignment sales. The difference is that there is inventory. First, place purchase orders for suppliers, put them on the shelves, and then sell them. Camp store model.

Platform service means that e-commerce companies do not participate in the transaction process between customers and suppliers. Customers place orders directly to suppliers who open stores on the e-commerce platform. The e-commerce company charges a certain percentage of commission (also called platform service fee) according to the order amount. .

For example, the relationship between business model, order status and document type is shown below.

Table 1

When there are multiple document types in the table, "→" in Table 1 indicates that each document has a specific generation order, that is, the upstream and downstream association relationship.

S207 , preprocessing the enterprise order data to obtain complete data required by the document type.

Among them, different document types correspond to different fields and field values. There may not be a certain field of the document in the enterprise order data or the field value of a certain field is empty. At this time, the computer equipment preprocesses the enterprise order data according to the preprocessing rules. Get the complete fields and field values (ie complete data) required to generate this document type.

For example, the preprocessing rules are shown in Table 2.

Table 2

S208 , generate one or more target documents according to the complete data, and establish an upstream-downstream association relationship of each target document.

Among them, one or more target documents are generated according to the above document types and complete data. If the number of target documents is multiple, the upstream and downstream associations of each target document are established according to the content of Table 1. In the process of generating the target document, the downstream document must be generated after the upstream document is generated. For example: the purchase receipt document must be generated after the purchase order is generated.

Further, when generating the target document, create and review long transactions through documents, and split them into multiple small short transactions for processing (for example: cut the previous long transactions into order generation, write back the order ledger (order signing data) ), push/receive order, write-back order ledger (inbound and outbound data) 4 short transactions. Order generation is successfully written and stored order data is immediately written instead of waiting for the final transaction to be successful), to avoid the transaction execution If the time is too long, the system locks the table and improves the system concurrency. When pushing multiple orders in batches at the same time, all the document number segments are allocated at one time through number segment allocation. When storing documents, they are taken from the allocated document number segments according to the document type, so that they can be retrieved when they are used, avoiding multiple database interactions.

S209 , assigning a document number to the generated target document, and writing the target document and specified field information into the order execution ledger of the enterprise information management system according to the document number, so as to complete the loading of the original order data.

Among them, a document number is assigned to each generated target document. The document number is used to uniquely represent the identity of the document. The document number can be expressed in the form of letters + numbers. For example, the document number of a sales order is XSDD20211102001. The document number is CGDD20211102001. Then call the order ledger write-back service to write the target order and the specified fields and field values to the order execution ledger of the enterprise information management system, for example, write the relevant data such as the inbound and outbound quantity and amount into the order execution ledger, so that Users can trace and view, and support the selection of ledger data to penetrate and view the generated orders, inbound and outbound documents.

Further, optionally, the present application also supports tracking processing of the loading result of the original order data, including: when the original order data is successfully loaded, a success prompt message pops up; wherein, the success prompt message includes the original order the number of pieces of data;

When the original order data fails to be loaded, a rollback operation is performed, the original order data is set to a state to be loaded, and the step of verifying the original order data is re-executed.

Among them, after the original order data is successfully loaded, the update order loading status is completed, and a successful prompt message pops up. The successful prompt message can be: "Load XX order information", and the user can view it on the original order data loading function page. Completion status, such as repeated data loading (that is, the original order data is exactly the same), abnormal master data status, etc. encountered during the loading process, resulting in the failure of data loading to send the failed order information and the reason for the failure. After data loading fails, perform a data rollback operation to roll back to the pending state of the original order data. The user can perform the loading operation again after rectifying the original order data according to the reason for the failure. In case of network or service interruption, the system cannot perform the rollback operation. The user can query the records that have been in the loading state on the loading page and perform the cancel operation, triggering a rollback to the initial state and reloading.

Further, the present application processes multiple orders in batches through multi-threading (the number of concurrent threads is defined in combination with server resource conditions). Usually, the system uses long transactions to ensure the atomicity and consistency of the entire process when processing logic such as the association of upstream and downstream documents. However, considering that there are many transactions executed during the order loading process, to avoid the situation that the user waits in line or even gets stuck due to the lock table after issuing the execution load transaction command, the transaction is cut and executed in the background in an asynchronous way, and the result tracking processing unit is used for Handle message feedback and exception handling during execution.

When loading order data into the enterprise information management system, the embodiments of the present application perform data collection, data verification, data conversion, and automatic loading of push orders through a preconfigured data model, as well as asynchronous multi-threading and long-transaction cutting. The processing technology enables large quantities of order data from different data sources, different business models, and different order statuses to be efficiently and stably loaded into the enterprise information management system. Solving the problems of low order data loading efficiency, high cost and poor experience in the prior art can effectively improve the timeliness of internal business processing of the enterprise.

The following are apparatus embodiments of the present application, which can be used to execute the method embodiments of the present application. For details not disclosed in the device embodiments of the present application, please refer to the method embodiments of the present application.

Please refer to FIG. 6 , which shows a structural block diagram of an apparatus for batch loading of orders provided by an exemplary embodiment of the present application, hereinafter referred to as apparatus 6 . The apparatus 6 can be implemented by software, hardware or a combination of the two to become all or a part of the computer equipment. The device 6 includes: an order data collection unit 601 and an order data loading unit 602 .

The order data collection unit 601 is used to collect original order data; verify the original order data; after the verification is passed, convert the original order data into enterprise order data supported by an enterprise information management system; The order data is written to the database;

Order data loading unit 602, configured to read the enterprise order data from the database, and parse the business mode and order status of the enterprise order data; determine the document type to be generated according to the business mode and order status ; Preprocess the enterprise order data to obtain the complete data required by the document type; generate one or more target documents according to the complete data, and establish the upstream and downstream associations of each target document; The document is assigned a document number, and the target document and the specified field information are written into the order execution ledger of the enterprise information management system according to the document number, so as to complete the loading of the original order data.

In one or more possible embodiments, the verifying the original order data includes:

Perform integrity check and compliance check on the original order data.

In one or more possible embodiments, the collecting raw order data includes:

Collect raw order data based on form templates;

The raw order data is collected in the e-commerce server.

In one or more possible embodiments, the converting the original order data into enterprise order data supported by an enterprise information management system includes:

According to the preset mapping relationship table, the field information in the original order data is converted into the field information supported by the enterprise information management system; wherein, the field information in the original order data includes: material file and exchange unit.

In one or more possible embodiments, the original order data includes: a main table of basic information and a sub-table of material information; the fields included in the main table of basic information are: order ID, order date, salesperson ID, business Department ID, Customer ID, Sales Type, Order Status and Business Model;

The fields included in the material information sub-table are: supplier ID, item code, material ID, material code, quantity, tax rate, cost amount, and sales amount.

In one or more possible embodiments, it also includes:

a result tracking processing unit, configured to pop up a success prompt message when the original order data is loaded successfully; wherein, the success prompt message includes the number of pieces of the original order data;

When the original order data fails to be loaded, a rollback operation is performed, the original order data is set to a state to be loaded, and the step of verifying the original order data is re-executed.

In one or more possible embodiments, the business model is self-operated and self-selling, the order status is to be shipped, and the target documents to be generated are sales orders and purchase orders;

When the business model is self-operated agency sales, the order status is to be received or to be settled, and the target documents to be generated are sales orders, purchase orders, purchase receipt documents and sales receipt documents;

When the business model is self-operated stocking, and the order status is to be shipped, to be received, or to be settled, the target document to be generated is a sales order;

The business model is platform service, the order status is to be shipped, to be received or to be settled, and the target document to be generated is a sales order.

It should be noted that, when the apparatus 6 provided in the above embodiment executes the method for batch loading of orders, only the division of the above functional modules is used as an example for illustration. In practical applications, the above functions may be allocated to different functional modules as required. Completion means dividing the internal structure of the device into different functional modules to complete all or part of the above functions. In addition, the apparatus for batch loading of orders provided by the above embodiments and the embodiments of the method for batch loading of orders belong to the same concept, and the implementation process thereof is detailed in the method embodiments, which will not be repeated here.

The above-mentioned serial numbers of the embodiments of the present application are only for description, and do not represent the advantages or disadvantages of the embodiments.

Embodiments of the present application further provide a computer storage medium, where the computer storage medium can store multiple instructions, and the instructions are suitable for being loaded by a processor and executing the method steps of the embodiment shown in FIG. 2 above. For the process, reference may be made to the specific description of the embodiment shown in FIG. 2 , which will not be repeated here.

The present application also provides a computer program product, the computer program product stores at least one instruction, and the at least one instruction is loaded and executed by the processor to implement the method for batch loading of orders as described in each of the above embodiments.

Referring to FIG. 7 , a structural block diagram of a computer device is provided in an embodiment of the present application. As shown in FIG. 7 , the computer device 700 may include: at least one processor 701 , at least one network interface 704 , user interface 703 , memory 705 , and at least one communication bus 702 .

Among them, the communication bus 702 is used to realize the connection and communication between these components.

The user interface 703 may include a display screen (Display) and a camera (Camera), and the optional user interface 703 may also include a standard wired interface and a wireless interface.

Wherein, the network interface 704 may optionally include a standard wired interface and a wireless interface (eg, a WI-FI interface).

The processor 701 may include one or more processing cores. The processor 701 uses various interfaces and lines to connect various parts of the entire computer device 700, and executes by running or executing the instructions, programs, code sets or instruction sets stored in the memory 705, and calling the data stored in the memory 705. Various functions of computer device 700 and processing data. Optionally, the processor 701 may use at least one of digital signal processing (Digital Signal Processing, DSP), field-programmable gate array (Field-Programmable Gate Array, FPGA), and programmable logic array (Programmable Logic Array, PLA). implemented in hardware. The processor 701 may integrate one or a combination of a central processing unit (Central Processing Unit, CPU), a graphics processing unit (Graphics Processing Unit, GPU), a modem, and the like. Among them, the CPU mainly handles the operating system, user interface, and application programs; the GPU is used to render and draw the content that needs to be displayed on the display screen; the modem is used to handle wireless communication. It can be understood that, the above-mentioned modem may not be integrated into the processor 701, but is implemented by a single chip.

The memory 705 may include random access memory (Random Access Memory, RAM), or may include read-only memory (Read-Only Memory). Optionally, the memory 705 includes a non-transitory computer-readable storage medium. Memory 705 may be used to store instructions, programs, codes, sets of codes, or sets of instructions. The memory 705 may include a stored program area and a stored data area, wherein the stored program area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playback function, an image playback function, etc.), Instructions and the like used to implement the above method embodiments; the storage data area may store the data and the like involved in the above method embodiments. The memory 705 can optionally also be at least one storage device located remote from the aforementioned processor 701 . As shown in FIG. 7 , the memory 705 as a computer storage medium may include an operating system, a network communication module, a user interface module and an application program.

In the computer device 700 shown in FIG. 7 , the user interface 703 is mainly used to provide an input interface for the user, and obtain the data input by the user; and the processor 701 can be used to call the application program stored in the memory 705, and specifically execute the following steps: For the method shown in FIG. 2, reference may be made to the specific process shown in FIG. 2, and details are not repeated here.

Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented by instructing relevant hardware through a computer program, and the program can be stored in a computer-readable storage medium. During execution, the processes of the embodiments of the above-mentioned methods may be included. Wherein, the storage medium can be a magnetic disk, an optical disk, a read-only storage memory, or a random storage memory, and the like.

The above disclosures are only the preferred embodiments of the present application, and of course, the scope of the rights of the present application cannot be limited by this. Therefore, equivalent changes made according to the claims of the present application are still within the scope of the present application.

Claims (10)

1. A method for batch loading of orders, comprising: Collect raw order data; verifying the original order data; After the verification is passed, the original order data is converted into enterprise order data supported by the enterprise information management system; writing the enterprise order data into the database; Read the enterprise order data from the database, and parse the business model and order status of the enterprise order data; Determine the document type to be generated according to the business model and order status; Preprocessing the enterprise order data to obtain complete data required by the document type; Generate one or more target documents according to the complete data, and establish the upstream and downstream associations of each target document; Assign a document number to the generated target document, and write the target document and specified field information into the order execution ledger of the enterprise information management system according to the document number, so as to complete the loading of the original order data . 2. The method according to claim 1, wherein the verifying the original order data comprises: Perform integrity check and compliance check on the original order data. 3. The method according to claim 1 or 2, said collecting original order data, comprising: Collect raw order data based on form templates; The raw order data is collected in the e-commerce server. 4. The method according to claim 3, wherein the converting the original order data into enterprise order data supported by an enterprise information management system comprises: According to the preset mapping relationship table, the field information in the original order data is converted into the field information supported by the enterprise information management system; wherein, the field information in the original order data includes: material file and exchange unit. 5. The method according to claim 1, 2 or 4, wherein the original order data comprises: a main table of basic information and a sub-table of material information; the fields included in the main table of basic information are: order ID , order date, salesperson ID, business department ID, customer ID, sales type, order status and business model; The fields included in the material information sub-table are: supplier ID, item code, material ID, material code, quantity, tax rate, cost amount, and sales amount. 6. The method of claim 5, further comprising: When the original order data is loaded successfully, a success prompt message pops up; wherein, the success prompt message includes the number of pieces of the original order data; When the original order data fails to be loaded, a rollback operation is performed, the original order data is set to a state to be loaded, and the step of verifying the original order data is re-executed. 7. The method of claim 6, wherein The business model is self-operated consignment sales, the order status is to be shipped, and the target documents to be generated are sales orders and purchase orders; When the business model is self-operated agency sales, the order status is to be received or to be settled, and the target documents to be generated are sales orders, purchase orders, purchase receipt documents and sales receipt documents; When the business model is self-operated stocking, and the order status is to be shipped, to be received, or to be settled, the target document to be generated is a sales order; The business model is platform service, the order status is to be shipped, to be received or to be settled, and the target document to be generated is a sales order. 8. An order batch loading device, comprising: an order data collection unit for collecting original order data; verifying the original order data; after the verification is passed, converting the original order data into enterprise order data supported by an enterprise information management system; data is written to the database; an order data loading unit, configured to read the enterprise order data from the database, and parse the business mode and order status of the enterprise order data; determine the document type to be generated according to the business mode and the order status; Preprocessing the enterprise order data to obtain complete data required by the document type; generating one or more target documents according to the complete data, and establishing the upstream and downstream associations of each target document; for the generated target document Allocating a document number, and writing the target document and specified field information into the order execution ledger of the enterprise information management system according to the document number, so as to complete the loading of the original order data. 9. A computer storage medium, characterized in that the computer storage medium stores a plurality of instructions, the instructions are suitable for being loaded by a processor and performing the method steps of any one of claims 1-7. 10. A computer device, comprising: a processor and a memory; wherein the memory stores a computer program, the computer program is adapted to be loaded by the processor and execute any one of claims 1 to 7 method steps for the item.

Images