CN115147049A

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

Info

Publication number: CN115147049A
Application number: CN202210836640.0A
Authority: CN
Inventors: 徐金龙; 卢凡; 周传旭; 吴志刚
Original assignee: Yuanguang Software Co Ltd
Current assignee: Yuanguang Software Co Ltd
Priority date: 2022-07-15
Filing date: 2022-07-15
Publication date: 2022-10-04

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 and device, storage medium and computer equipment

Technical Field

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

Background

In order to improve market competitiveness, expand sales channels and adopt different sourcing purchasing modes to become choices of more and more enterprises, the diversity of material purchasing and sales order data sources of the enterprises is determined, and the data formats of orders from different sources have great difference. And the order number is huge for group type enterprises in electronic commerce acquisition and marketing service scenes. Corporate enterprises typically use enterprise information management systems (e.g., ERP systems, etc.) for order fulfillment processes, cost accounting, and receipt and payment settlement management. Under the conditions of various order sources and huge order data volume, how to quickly and effectively load order data into an enterprise information management system as the basis of subsequent business processing is always a problem concerned by related business personnel for material management and technical personnel of the information system, and the problems existing in the prior art for loading the order data comprise:

1. the order data sources are many, and the data acquisition is difficult. Orders from multiple sources, off-line, on-line (and involving multiple different e-commerce platforms on-line), are typically of different data types, integrity, etc., which adds difficulty to the batch collection of data.

2. Different order states and difficult differentiation processing. Due to different service modes, asynchronous loading of acquisition and marketing service and system data and other factors, the conditions that the order state and subsequent service processing requirements are different when data acquisition is loaded exist, and the requirements for loading orders in different service modes and different states into a system are different, for example: when the order is loaded in the initial state of the self-operation stock preparation mode, only a sales order is formed; when the order is loaded in the initial state of the self-operation and sales-and-sales-mode, a sales order and a corresponding purchase order are required to be formed; the self-operation and sales-and-sales mode delivery state order needs to form a sale order, a purchase warehousing order and a sale ex-warehousing order.

3. The order data volume is large, and the batch processing is difficult. Due to the fact that the business volume of large group enterprises is large, the order quantity is large generally, particularly under the electricity and commerce acquisition and distribution mode, the order quantity can reach hundreds of thousands of orders per month, a series of complex affairs such as data acquisition, verification, processing and order pushing are needed when data are loaded, and high-efficiency mass data loading processing is difficult.

Based on the above situation, the conventional order data loading mode generally adopts manual order-by-order entry or data segmentation integration of each business link (supported by different data interfaces of different data items such as orders, warehousing orders and the like, if part of business data has no integration source, partial integration and partial manual entry are adopted), the efficiency is low, the cost is high, and the risk of human errors caused by manually establishing the upstream and downstream data association relationship exists.

Disclosure of Invention

The embodiment of the application provides an order batch loading method, an order batch loading device, a storage medium and computer equipment, and can solve the problems of low efficiency, high cost and high error probability in manual order data loading in the prior art. The technical scheme is as follows:

in a first aspect, an embodiment of the present application provides an order batch loading method, where the method includes:

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;

writing the enterprise order data into a database;

reading the enterprise order data from the database, and analyzing the business mode and the order state of the enterprise order data;

determining the type of a document to be generated according to the business mode and the order state;

preprocessing the enterprise order data to obtain complete data required by the bill type;

generating one or more target documents according to the complete data, and establishing an upstream and downstream incidence relation of each target document;

distributing a document number for the generated target document, and writing the target document and the specified field information into an order execution ledger of the enterprise information management system according to the document number to complete the loading of the original order data.

In a second aspect, an embodiment of the present application provides an order batch loading apparatus, where the apparatus includes:

the order data acquisition unit is used for acquiring 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; writing the enterprise order data into a database;

the order data loading unit is used for reading the enterprise order data from the database and analyzing the business mode and the order state of the enterprise order data; determining the type of a document to be generated according to the business mode and the order state; preprocessing the enterprise order data to obtain complete data required by the bill type; generating one or more target documents according to the complete data, and establishing an upstream and downstream incidence relation of each target document; distributing a document number for the generated target document, and writing the target document and the specified field information into an order execution ledger of the enterprise information management system according to the document number to complete the loading of the original order data.

In a third aspect, embodiments of the present application provide a computer storage medium storing a plurality of instructions adapted to be loaded by a processor and to perform the above-mentioned 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 adapted to be loaded by the processor and to perform the above-mentioned method steps.

The beneficial effects brought by the technical scheme provided by some embodiments of the application at least comprise:

the order data of different data sources, different business modes and different order states in large batch are efficiently and stably loaded into the enterprise information management system by executing data acquisition, data verification, data conversion, data filling and automatic loading and pushing through 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.

Drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the embodiments or the prior art descriptions will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and other drawings can be obtained by those skilled in the art without creative efforts.

Fig. 1 is a schematic diagram of a network architecture provided in an embodiment of the present application;

FIG. 2 is a flowchart illustrating an order batch loading method according to an embodiment of the present disclosure;

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

fig. 4 is a schematic diagram of a message format of the e-commerce server provided in the embodiment of the present application;

FIG. 5 is a configuration representation of a verification rule provided by an embodiment of the present application;

FIG. 6 is a block diagram of an order batch loading apparatus according to the present invention;

fig. 7 is a block diagram of a computer device provided in the present application.

Detailed Description

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

It should be noted that, the order batch loading method provided by the present application is generally executed by a computer device, and accordingly, the order batch loading apparatus is generally disposed in the computer device.

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 computer device 101 and server 102 may be via a network, which is the medium used to provide the communication links between the various elements described above. The network may include various types of wired or wireless communication links, such as: the wired communication link includes an optical fiber, a twisted pair wire, or a coaxial cable, etc., and the WIreless communication link includes a bluetooth communication link, a WIreless-FIdelity (Wi-Fi) communication link, or a microwave communication link, etc.

The computer device 101 collects original order data, processes the original order data, and loads the processed order data into an 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 a plurality of 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 a plurality of software or software modules (for example, to provide distributed services), or may be implemented as a single software or software module, and are not limited in this regard.

Various communication client applications may be installed on the computer device of the present application, for example: video recording applications, video playing applications, voice interaction applications, search-type applications, instant messaging tools, mailbox clients, social platform software, and the like.

The computer device may be hardware or software. When the computer device is hardware, it may be various computer devices having a display screen, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like. When the computer device is software, the software may be installed in the computer device listed above. Which may be implemented as multiple software or software modules (e.g., to provide distributed services) or as a single software or software module, and is not particularly limited herein.

When the computer equipment is hardware, the computer equipment can also be provided with display equipment and a camera, the display equipment can display various equipment capable of realizing the display function, and the camera is used for collecting video streams; for example: the display device may be a cathode ray tube (CR) display, a light-emitting diode (LED) display, an electronic ink screen, a Liquid Crystal Display (LCD), a Plasma Display Panel (PDP), or the like. The user can utilize the display device on the computer device to view the displayed information such as characters, pictures, videos and the like.

It should be understood that the number of computer devices, networks, and servers in fig. 1 is illustrative only. Any number of computer devices, networks, and servers are possible, as desired for an implementation.

The order batch loading method provided by the embodiment of the present application will be described in detail below with reference to fig. 2. The order batch loading device in the embodiment of the present application may be a computer device shown in fig. 1.

Referring to fig. 2, a flow chart of an order batch loading method according to an embodiment of the present application is provided. As shown in fig. 2, the method of the embodiment of the present application may include the steps of:

s201, collecting original order data.

The original order data represent the attributes of the order, and the computer equipment can acquire the original order data in an online mode or an offline mode, wherein the online mode is as follows: providing a form template by computer equipment, filling the form template by a user, and obtaining a final electronic form after filling, wherein the computer equipment acquires original order data based on the electronic form in an offline mode: the computer equipment is pre-configured with an integrated interface, and the e-commerce platform calls the integrated interface to push original order data to the computer equipment. The amount of raw order data collected by the computer device may be one or more.

In this embodiment, a data model of original order data is defined uniformly, where the original order data includes a plurality of fields and field values of the fields; the fields of the original order data are divided into main table fields and sub table fields, the main table fields represent basic information of the order, and the sub table fields represent attribute information of the materials. Further, the main table fields are: one or more of an order ID, an order date, a clerk ID, a business department ID, a customer ID, a sales type, an e-commerce platform, an order status, and a business model; the sub-table fields are: one or more of a supplier ID, an item code, a material ID, a material code, an amount, a tax rate, a cost amount, a sales amount.

For example: referring to fig. 3, which is a schematic diagram of a form template, a computer device displays the form template shown in fig. 3 through a display unit, where a first cell in each column in the form template corresponds to one field, a plurality of fields included in the form template are not described herein again, and each field is configured with a filling requirement, for example: for order dates, the fill requirements are: fill in yyyy/mm/dd format date, for example: 2020/07/01, the user fills in according to the filling requirement to improve the accuracy. Specifically, each line corresponds to one piece of original order data, and the user may fill a field value in a cell of the form template through an input device (e.g., a mouse, a keyboard, a touch screen, etc.). Further, a plurality of fields included in the form template are divided into two types, namely a main form field and a sub-form field, and cells in which the main form field and the sub-form field are located can be distinguished by adopting different filling colors respectively, for example: the filling color of the cell where the main table field is located is dark gray, and the filling color of the cell where the sub table field is located is light gray. Further, the form template includes a plurality of fields divided into mandatory fields and optional fields, and the mandatory fields and the optional fields may be distinguished by different colors, for example: the font color of the mandatory field is red, the font color of the selected field is black, the mandatory field represents a field of which a user must fill a field value, the selected field represents a field of which the user can select the filled field value, and if the computer device detects that the cell of the column in which the mandatory field is located does not fill the field value, an error is reported to prompt the user.

For example: referring to fig. 4, which is a schematic diagram of a message, the e-commerce platform pushes the message to the computer device through the message format of fig. 4, where the message includes input parameters and output parameters, and the input parameters and the output parameters are as shown in fig. 4, which is not described herein again, the computer device receives the message pushed from the e-commerce platform, analyzes the message to obtain field values of each field, and generates original order data based on the field values obtained by the analysis.

And S202, verifying the original order data.

The computer equipment is pre-configured with a verification rule, the verification rule is used for verifying the field value of each field in the original order data, different fields are associated with different verification rules, and when the computer equipment detects that the field value of a certain field cannot be verified, a verification prompt message is displayed through the display unit. Further, the transaction rule includes an integrity check for checking whether field values of respective fields in the original order data are null, and a compliance check for checking whether the field values are within a preset range.

For example, referring to the configuration table of the check rule shown in fig. 5, the check rule and the check prompt of each field are configured in the configuration table, for example: the order date check rules are: the mandatory field is in a format of YYYY-MM-DD, the computer equipment detects whether the field value of the order date is filled based on the verification rule, and if not, a verification prompt 'the mandatory field cannot be empty' is displayed through a display unit; and detecting whether the filling format of the order date is YYYY-MM-DD or not, and if not, displaying a verification prompt 'the date format needs to be YYYY-MM-DD' through a display unit. The check rule and the check prompt of other fields in the configuration table can be seen from fig. 5, and are not described herein again.

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

The enterprise information management system may not be able to identify some fields and field values in the original order data, and the computer device may convert the field information (i.e., the fields and the field values) in the original order data into field information that is identifiable by the enterprise information management system according to a preset mapping conversion table, for example: the field information includes the following fields: and converting the material name, the current unit and the like into the enterprise order data.

And S204, writing the enterprise order data into a database.

The database is generally a relational database, for example: SQL database, etc. to write the enterprise order data into the data table in the database, and the user can check, modify and delete the enterprise order data in the database.

S205, reading the enterprise order data from the database, and analyzing the business mode and the order state of the enterprise order data.

The enterprise order data includes fields for business model and order status.

And S206, determining the type of the document to be generated according to the business mode and the order state.

The computer equipment is preconfigured with a business mode and a mapping type between an order state and a document type, different order states and different document types are associated with different business modes, the business mode comprises self-operation and self-operation stock keeping and platform service, and the order state comprises to-be-delivered goods, to-be-received goods and to-be-settled goods.

The self-operation and self-sale is one of self-operation, the profit mode is mainly to earn the difference between sale and purchase, the business comprises the complete business processes of purchase, sale, warehousing and ex-warehouse, but the business process does not have stock, after a client places an order (a sales order), the client automatically generates a corresponding purchase order to be pushed to a provider, the provider directly delivers goods, but the settlement is also the settlement between the client and an E-business company, and the E-business company and the provider settle the settlement.

The self-operation stock is also a self-operation one, the profit mode is the same as the self-operation proxy sale, the difference is that the stock exists, a purchase order is firstly placed for a supplier, the stock is put on shelf and then sold, and the delivery is carried out according to the sales order of a client, which is similar to the mode of the current Jingdong self-operation shop.

The platform service, namely the E-business company does not participate in the transaction process between the customer and the supplier, the customer places an order directly to the supplier who places the order on the E-business platform, and the E-business company collects commissions (also called platform service fee) according to the amount of the order.

For example, the association between business model, order status and document type is as follows.

TABLE 1

When there are a plurality of document types in the table, a specific generation order, that is, an upstream-downstream relationship between the respective documents is indicated by "→" in table 1.

And S207, preprocessing the order data of the enterprise to obtain complete data required by the bill type.

The different document types correspond to different fields and field values, a certain field possibly without a document in the enterprise order data or the field value of the certain field is empty, and the computer equipment preprocesses the enterprise order data according to preprocessing rules to obtain the complete field and the field value (namely complete data) required for generating the document type.

For example, the preprocessing rules are shown in the contents of table 2.

TABLE 2

And S208, generating one or more target documents according to the complete data, and establishing an upstream and downstream incidence relation of each target document.

And if the number of the target documents is multiple, establishing an upstream and downstream incidence relation of each target document according to the content in the table 1. In the process of generating the target document, the downstream document can be generated only after the upstream document is generated. For example: the purchase warehousing entry must be generated after the purchase order is generated.

Furthermore, when a target document is generated, the document is created and audited, and is split into a plurality of small short transactions for processing (for example, the previous long transaction is cut into 4 short transactions of order generation, order form account write-back (order signing data), push-out/put-in order, order form account write-back (in-out and direct sending data), the order form generation is successful and the order form data is written into the stored order form data immediately instead of the order form data being written into the last transaction until all the transactions are successful), so that the problem that the execution time of the transaction is too long and the system is locked is avoided, and the system concurrency is improved. And meanwhile, when a plurality of orders are pushed in batches, all document number sections are distributed at one time through number section distribution, documents are stored and taken from the distributed document number sections according to document types, and the documents are taken when the documents are stored, so that multiple database interaction is avoided.

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

The document number is distributed to each generated target document, the document number is used for uniquely representing the identity of the document, and the document number can be represented in a form of letters and numbers, for example: the document number of a certain sales order is XSDD20211102001, and the document number of a certain purchase order is CGDD20211102001. The order ledger write back service is then invoked to write the target order and specified fields and field values to the order fulfillment ledger of the enterprise information management system, for example: and writing related data such as the number of in and out warehouses, the amount of money and the like into an order execution standing book so as to facilitate the tracing and the checking of a user, and supporting the selection of standing book data to see through generated orders and in and out warehouse bill documents.

Further, optionally, the present application further supports tracking the loading result of the original order data, including: when the original order data is loaded successfully, popping up a success prompt message; wherein the success prompt message comprises the number of the original order data;

and when the original order data fails to be loaded, executing rollback operation, setting the original order data to be in a to-be-loaded state, and re-executing the step of verifying the original order data.

After the original order data is successfully loaded, updating the order loading state to be completed, and popping up success prompt information, wherein the success prompt information can be as follows: "load XX pieces of order information", the user can check the completion status on the original order data loading function page, and if the data is repeatedly loaded (that is, the original order data is completely the same), the main data status is abnormal, and the like, the user sends the failure order information and the failure reason when the data loading fails. And after the data loading fails, executing data rollback operation, rolling back to the to-be-loaded state of the original order data, and enabling the user to perform the loading operation again after the original order data is modified according to the failure reason. If the system cannot execute the rollback operation when the network or service interruption problem occurs, the user can query the record which is always in the loading state in the loading page to execute the cancel operation, and the user is triggered to roll back to the initial state for loading again.

Furthermore, the multi-order is processed in batches through multiple threads (the number of concurrent threads is defined by combining the resource condition of the server), a long transaction is adopted to ensure the atomicity and consistency of the whole process when the system processes logic such as association of upstream and downstream documents, but more transactions are executed in the order loading process, the condition that a user queues and waits after sending an instruction for executing the loading transaction and even is dead due to table locking is avoided, the transaction is cut into a background to be executed in an asynchronous mode, and a result tracking processing unit is used for processing message feedback and exception processing in the executing process.

When order data are loaded into the enterprise information management system, the embodiment of the application realizes that the order data of different data sources, different service modes and different order states in large batch are efficiently and stably loaded into the enterprise information management system through data acquisition, data verification, data conversion and automatic order loading push of a pre-configured data model and an asynchronous processing technology of multithreading and long-term transaction cutting. The problems of low order data loading efficiency, high cost and poor experience in the prior art are solved, and the timeliness of enterprise internal business processing can be effectively improved.

The following are embodiments of the apparatus of the present application that may be used to perform embodiments of the method of the present application. For details which are not disclosed in the embodiments of the apparatus of the present application, reference is made to the embodiments of the method of the present application.

Referring to fig. 6, a block diagram of an order batch loading apparatus provided in an exemplary embodiment of the present application is shown, which is hereinafter referred to as the apparatus 6. The apparatus 6 may be implemented as all or part of a computer device in software, hardware or a combination of both. The device 6 comprises: an order data acquisition unit 601 and an order data loading unit 602.

An order data acquisition unit 601, configured to acquire 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; writing the enterprise order data into a database;

an order data loading unit 602, configured to read the enterprise order data from the database, and analyze a service mode and an order state of the enterprise order data; determining the type of the document to be generated according to the business mode and the order state; preprocessing the enterprise order data to obtain complete data required by the bill type; generating one or more target documents according to the complete data, and establishing an upstream and downstream incidence relation of each target document; distributing a document number for the generated target document, and writing the target document and the specified field information into an order execution ledger of the enterprise information management system according to the document number to complete the loading of the original order data.

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

and carrying out integrity check and compliance check on the original order data.

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

acquiring original order data based on a form template;

and collecting original order data in the E-business server.

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

converting the field information in the original order data into field information supported by an enterprise information management system according to a preset mapping relation table; wherein, the field information in the original order data comprises: material archives and units of contact.

In one or more possible embodiments, the raw order data includes: a basic information main table and a material information sub table; the basic information main table comprises the following fields: order ID, order date, clerk ID, business department ID, customer ID, sales type, order status, and business mode;

the material information sub-table comprises the following fields: supplier ID, item code, item ID, item code, quantity, tax rate, cost amount, sales amount.

In one or more possible embodiments, further comprising:

the result tracking processing unit is used for popping up a success prompt message when the original order data is successfully loaded; wherein the success prompt message comprises the number of the original order data;

and when the original order data fails to be loaded, executing rollback operation, setting the original order data to be in a state to be loaded, and re-executing the step of verifying the original order data.

In one or more possible embodiments, the business mode is self-operation and self-sale, and when the order state is to be delivered, the target documents to be generated are a sales order and a purchase order;

the business mode is self-operation and sales, and when the order state is to receive goods or settle accounts, the target documents to be generated are a sales order, a purchase warehousing entry and a sales warehousing entry;

the business mode is self-operation stock, and the target document to be generated is a sales order when the order state is to be delivered, received or settled;

the business mode is platform service, the order state is to-be-delivered, 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 order batch loading method, only the division of the above functional modules is taken as an example, and in practical applications, the above function distribution may be completed by different functional modules according to needs, that is, the internal structure of the device may be divided into different functional modules to complete all or part of the above functions. In addition, the order batch loading device and the order batch loading method provided by the above embodiments belong to the same concept, and details of implementation processes thereof are referred to in the method embodiments, and are not described herein again.

The above-mentioned serial numbers of the embodiments of the present application are merely for description and do not represent the merits of the embodiments.

An embodiment of the present application further provides a computer storage medium, where the computer storage medium may store a plurality of instructions, where the instructions are suitable for being loaded by a processor and executing the method steps in the embodiment shown in fig. 2, and a specific execution process may refer to a specific description of the embodiment shown in fig. 2, which is not described herein again.

The present application further provides a computer program product, which stores at least one instruction, and the at least one instruction is loaded and executed by the processor to implement the order batch loading method according to the above embodiments.

Referring to fig. 7, a block diagram of a computer device is provided according to 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, a user interface 703, memory 705, at least one communication bus 702.

Wherein a communication bus 702 is used to enable connective 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 standard wireless interface.

The network interface 704 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface), among others.

Processor 701 may include one or more processing cores, among other things. The processor 701 interfaces with various components throughout the computer device 700 using various interfaces and connections to perform various functions of the computer device 700 and process data by executing or performing instructions, programs, code sets, or instruction sets stored in the memory 705, as well as invoking data stored in the memory 705. Alternatively, the processor 701 may be implemented in hardware using at least one of Digital Signal Processing (DSP), field-Programmable gate Array (FPGA), and Programmable Logic Array (PLA). The processor 701 may integrate one or a combination of a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), a modem, and the like. Wherein, the CPU mainly processes an operating system, a user interface, an application program and the like; the GPU is used for rendering and drawing the content required to be displayed by the display screen; the modem is used to handle wireless communications. It is understood that the modem may not be integrated into the processor 701, and may be implemented by a single chip.

The Memory 705 may include a Random Access Memory (RAM) or a Read-Only Memory (Read-Only Memory). Optionally, the memory 705 includes a non-transitory computer-readable medium. The memory 705 may be used to store instructions, programs, code sets, or instruction sets. The memory 705 may include a program storage area and a data storage area, wherein the program storage area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playing function, an image playing function, etc.), instructions for implementing the various method embodiments described above, and the like; the storage data area may store data and the like referred to in the above respective method embodiments. The memory 705 may optionally be at least one memory device located remotely from the processor 701. As shown in fig. 7, the memory 705, which is a kind of computer storage medium, may include therein 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 as an interface for providing input for a user, and acquiring data input by the user; the processor 701 may be configured to call the application program stored in the memory 705, and specifically execute the method shown in fig. 2, where a specific process may be shown in fig. 2 and is not described herein again.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above may be implemented by a computer program, which may be stored in a computer readable storage medium and executed by a computer to implement the processes of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory or a random access memory.

The above disclosure is only for the purpose of illustrating the preferred embodiments of the present application and is not to be construed as limiting the scope of the present application, so that the present application is not limited thereto, and all equivalent variations and modifications can be made to the present application.

Claims

1. A method for batch loading orders is characterized by comprising the following steps:

collecting original order data;

verifying the original order data;

writing the enterprise order data into a database;

2. The method of claim 1, wherein said verifying said raw order data comprises:

3. The method of claim 1 or 2, said collecting raw order data comprising:

acquiring original order data based on a form template;

original order data is collected in the e-commerce server.

4. The method of claim 3, wherein converting the raw order data into enterprise order data supported by an enterprise information management system comprises:

converting field information in the original order data into field information supported by an enterprise information management system according to a preset mapping relation table; wherein, the field information in the original order data comprises: material archives and units of contact.

5. The method of claim 1, 2 or 4, wherein the raw order data comprises: a basic information main table and a material information sub table; the basic information main table comprises the following fields: order ID, order date, clerk ID, business department ID, customer ID, sales type, order status, and business mode;

the material information sub-table comprises the following fields: supplier ID, item code, material ID, material code, quantity, tax rate, cost amount, sales amount.

6. The method of claim 5, further comprising:

when the original order data is loaded successfully, popping up a success prompt message; wherein the success prompt message comprises the number of the original order data;

7. The method of claim 6,

the business mode is self-operation and agency, and when the order state is to be issued, the target documents to be generated are a sales order and a purchase order;

8. An order batch loading apparatus, comprising:

the order data loading unit is used for reading the enterprise order data from the database and analyzing the business mode and the order state of the enterprise order data; determining the type of the document to be generated according to the business mode and the order state; preprocessing the enterprise order data to obtain complete data required by the bill type; generating one or more target documents according to the complete data, and establishing an upstream and downstream incidence relation of each target document; distributing a document number for the generated target document, and writing the target document and the specified field information into an order execution ledger of the enterprise information management system according to the document number to complete the loading of the original order data.

9. A computer storage medium, characterized in that it stores a plurality of instructions adapted to be loaded by a processor and to perform the method steps according to any one of claims 1 to 7.

10. A computer device, comprising: a processor and a memory; wherein the memory stores a computer program adapted to be loaded by the processor and to perform the method steps of any of claims 1 to 7.