CN106372980A - Cross-e-commerce channel order information acquisition and management method - Google Patents

Abstract

The invention discloses a method for collecting and managing order information across e-commerce channels. Orders are placed on an e-commerce platform, and orders successfully paid by users are collected; it is judged whether the order exists in an e-commerce order storage database, and if so, exit; otherwise, Write the order into the e-commerce order storage database; operate the order; after the operation is completed, write the push message to the message queue; read the unsent message, call the e-commerce platform interface, and complete the order synchronization. The order collection of the present invention realizes automation, and can be unattended 24 hours a day, and all orders are automatically collected into the order database, saving labor costs.

Description

A method for collecting and managing order information across e-commerce channels

technical field

The invention relates to the field of Internet e-commerce, in particular to a method for collecting and managing order information across e-commerce channels.

Background technique

The development of e-commerce is a product of the era of Internet society. With the development of network technology, e-commerce occupies an increasing proportion in the economy. E-commerce reduces the cost of commodity management and logistics, and greatly shortens the distance between enterprises and consumers. At the same time, it promotes message symmetry and reduces transaction costs. E-commerce has become an important sales channel for many emerging companies, and more and more traditional companies have begun to transform to e-commerce.

In recent years, e-commerce has developed rapidly in my country, and many e-commerce platforms have developed, such as Tmall under Alibaba, JD.com under JD.com, and Suning.com under Suning. Enterprises can use the popularity and credibility of these platforms to sell their products.

Due to the different operating models and data specifications between different platforms, it is impossible to form a unified management rule, so there are some problems.

1. The rules formulated by each platform are different, so enterprises cannot formulate a unified method for effective management. The commonly used method is to manage the data of one e-commerce platform by multiple people or manage the data of multiple e-commerce platforms by one person. It is particularly prone to confusion in management.

2. Each platform has its own database, and the database formats are different, so enterprises cannot manage inventory and orders in a unified manner.

The settlement methods used by each platform are different, which greatly increases the workload of financial personnel during financial settlement, and because of the different settlement methods, errors are prone to occur during reconciliation.

Contents of the invention

The technical problem to be solved by the present invention is to provide a method for collecting and managing order information across e-commerce channels in view of the deficiencies in the prior art.

In order to solve the above technical problems, the technical solution adopted in the present invention is: a method for collecting and managing order information across e-commerce channels, comprising the following steps:

1) Place an order on the e-commerce platform and collect the order that the user paid successfully;

2) Determine whether the order exists in the e-commerce order storage database, if so, exit; otherwise, enter step 3);

3) Write the order into the e-commerce order storage database;

4) Operate the order;

5) After the operation is completed, write the push message to the message queue;

6) Read unsent messages, call the e-commerce platform interface, and complete order synchronization.

In step 4), the following operations are performed on the order: modify the basic information of the order, ship the order, close the order, and complete the order.

The process of modifying the basic information of an order includes:

1) Read the basic information of the current order in the order database;

2) Determine whether the current status of the order is information that can be modified, if not, end; if so, go to step 3);

3) Read the order information of the e-commerce platform;

4) Determine whether the order status of the e-commerce platform is that the information can be modified, if not, then end; otherwise, enter step 5);

5) Modify the order information of the e-commerce platform;

6) Judging whether the order information of the e-commerce platform is successfully modified, if not, then end; otherwise, modify the order information in the order database.

The order shipping process includes:

1) Read the basic information of the order in the order database;

2) Fill in the logistics information;

3) Call the order delivery API of the e-commerce platform;

4) Determine whether the e-commerce platform order delivery is successful, if not, end; otherwise, modify the order status in the order database to delivery.

The process of closing an order includes:

1) Read the order information in the order database;

2) Read the real-time information of the e-commerce platform order;

3) Determine whether the order status in the e-commerce platform is closed, if not, end; otherwise, update the order status in the order database to be closed.

The process of completing an order includes:

1) Read the shipped orders in the order database;

2) Obtain the current order status of the e-commerce platform through the API;

3) Determine whether the status of the e-commerce platform is completed order, if not, end; otherwise, update the order status of the order database as completed.

Compared with the prior art, the beneficial effects of the present invention are: the present invention formulates different collection mechanisms according to the rules of each e-commerce platform, and collects the collected data into the system order database and the platform order storage database. Ensure the unity of data, and retain the characteristics of e-commerce platform orders; order collection is automated, and can be unattended 24 hours a day, and all orders are automatically collected into the order database, saving labor costs; using a unified order management method, Users only need to be familiar with the operation method of the order system to greatly reduce the operations on the e-commerce platform. It saves most of the personnel training expenses, and can reduce the administrator's operation steps, greatly reducing the error rate; the operation of the order in the system will be effectively logged. Responsibilities can be clearly distinguished through the operation log; all order data is collected in one database, which can be more convenient for statistics. Especially in inventory, sales, and reconciliation, the data can be made more complete; B/S mode is used for remote management, and the client is free of installation and maintenance, and all updates are deployed once. It has good scalability and flexibility.

Description of drawings

Fig. 1 is the overall architecture diagram of the present invention;

Fig. 2 is the flow chart of overall method of the present invention;

Fig. 3 is the flowchart of order basic information modification among the present invention;

Fig. 4 is the flowchart of the order shipment in the order processing process in the present invention;

Fig. 5 is a flow chart of closing an order in the order processing process in the present invention;

Fig. 6 is a flow chart of order completion in the order processing process of the present invention.

detailed description

The present invention will be described in detail below in conjunction with accompanying drawings and specific embodiments

The structure of the order collection and management of the present invention is shown in FIG. 1 . Including a variety of e-commerce platforms, automatic collection tasks corresponding to multiple e-commerce platforms, e-commerce platform order information databases corresponding to multiple e-commerce platforms, order databases collected by this system, and B/S operations for unified management of orders in this system The message queue that needs to be used for system and operation record synchronization, and the message push task that needs to be used when communicating with various e-commerce platforms.

The overall flow of the system of the present invention is shown in FIG. 2 . The user places an order on the e-commerce platform, and the automatic collection task collects the order successfully paid by the user, and does not continue to execute if it exists. If it does not exist, it will be stored in the order database of the e-commerce platform in the system, and stored in the order database of this system. Each e-commerce platform uses different labels for identification, and saves the order number of the e-commerce platform. The system administrator operates the order through this system, such as: modifying the delivery address and order delivery. After the operation is completed, the system writes the push message to the message queue, and the message push service calls the e-commerce platform interface to complete order synchronization.

The overall process of modifying the basic information of the order by the system of the present invention is shown in FIG. 3 . The administrator is operating the order through this system, such as modifying the delivery address. The system communicates with the e-commerce platform in real time to obtain the information of the e-commerce platform. If the e-commerce platform allows execution, a push message is sent to the e-commerce platform. After the e-commerce platform successfully executes, modify the order information in the local system database.

The delivery process of the system of the present invention is shown in FIG. 4 . The administrator obtains the order information through this system, and fills in the delivery order number, logistics name and other contents when the delivery is allowed. The system communicates with the e-commerce platform in real time and pushes the delivery information to the e-commerce platform. If the e-commerce platform executes successfully, update the order status in the system database as delivered. And generate a new delivery order. If the execution of the e-commerce platform is unsuccessful, it will return through the transaction and notify the administrator that the order delivery failed.

The system closing order process of the present invention is shown in FIG. 5 . According to different e-commerce platforms, orders are closed. The administrator communicates with the e-commerce platform through the system to obtain the current status of the order on the e-commerce platform. If the current status of the order in the e-commerce platform is closed. then update the order status in the system database to closed. Otherwise, prompt the user to operate on the e-commerce platform first.

The order completion process of the system of the present invention is shown in FIG. 6 . The e-commerce synchronization automatic task is started by a background task. Get orders that have been in delivery for a while. Obtain the current status of the order in the e-commerce platform through the e-commerce platform interface. If the status of the order in the e-commerce platform is order completion, update the order status in the system database to be completed. Otherwise, wait for the next execution of the e-commerce synchronization automatic task.

Claims (6)

1. A method for collecting and managing order information across e-commerce channels, comprising the following steps: 1) Place an order on the e-commerce platform and collect the order that the user paid successfully; 2) Determine whether the order exists in the e-commerce order storage database, if so, exit; otherwise, enter step 3); 3) Write the order into the e-commerce order storage database; 4) Operate the order; 5) After the operation is completed, write the push message to the message queue; 6) Read unsent messages, call the e-commerce platform interface, and complete order synchronization. 2. The method for collecting and managing order information across e-commerce channels according to claim 1, wherein in step 4), the following operations are performed on the order: modifying basic information of the order, shipping the order, closing the order, and completing the order. 3. The method for collecting and managing order information across e-commerce channels according to claim 2, wherein the process of modifying basic order information includes: 1) Read the basic information of the current order in the order database; 2) Determine whether the current status of the order is information that can be modified, if not, end; if so, go to step 3); 3) Read the order information of the e-commerce platform; 4) Determine whether the order status of the e-commerce platform is that the information can be modified, if not, then end; otherwise, enter step 5); 5) Modify the order information of the e-commerce platform; 6) Judging whether the order information of the e-commerce platform is successfully modified, if not, then end; otherwise, modify the order information in the order database. 4. The method for collecting and managing order information across e-commerce channels according to claim 2, wherein: The order shipping process includes: 1) Read the basic information of the order in the order database; 2) Fill in the logistics information; 3) Call the order delivery API of the e-commerce platform; 4) Determine whether the e-commerce platform order delivery is successful, if not, end; otherwise, modify the order status in the order database to delivery. 5. The method for collecting and managing order information across e-commerce channels according to claim 2, wherein: The process of closing an order includes: 1) Read the order information in the order database; 2) Read the real-time information of the e-commerce platform order; 3) Determine whether the order status in the e-commerce platform is closed, if not, end; otherwise, update the order status in the order database to be closed. 6. The method for collecting and managing order information across e-commerce channels according to claim 2, wherein: The process of completing an order includes: 1) Read the shipped orders in the order database; 2) Obtain the current order status of the e-commerce platform through the API; 3) Determine whether the status of the e-commerce platform is completed order, if not, end; otherwise, update the order status of the order database as completed.