WO2021068607A1

WO2021068607A1 - Multi-system multi-store order integrating method and apparatus, computer device and storage medium

Info

Publication number: WO2021068607A1
Application number: PCT/CN2020/105641
Authority: WO
Inventors: 刘建洋; 杨程成; 黄瑾; 史凯丽; 聂鑫鑫
Original assignee: 苏宁云计算有限公司
Priority date: 2019-10-12
Filing date: 2020-07-29
Publication date: 2021-04-15
Also published as: CN110766520A; CA3157818A1

Abstract

A multi-system multi-store order fusion method and apparatus, a computer device, and a storage medium. The method comprises: acquiring order information of a target product from different stores in multiple systems (S1); integrating the order information of the target product in multiple systems and establishing an integration data information table (S2); and extracting data in the integration data information table according to an instruction and performing an instruction operation (S3). The present method can achieve the integration of order data from multiple systems and multiple stores so as to greatly improve the efficiency of after-sales marketing activities.

Description

Multi-system multi-store order fusion method, device, computer equipment and storage medium

Technical field

The invention belongs to the field of data processing technology, and specifically, is a method, device, computer equipment and storage medium for order fusion of multiple systems and multiple stores.

Background technique

At this stage, my country's e-commerce is growing rapidly, and a fully functional business system has initially formed; e-commerce involves more and more fields, and the e-commerce industry is also diverse. The continuous popularization of e-commerce will directly lead to the development of service types such as animal streaming, finance and IT, and drive the development of various sub-formats in the e-commerce ecosystem such as third-party payment, electronic authentication, network information security, and network insurance.

At the same time, many e-commerce companies no longer operate alone, but promote their own business operations through cooperation and mutual assistance, each taking what they need and developing together. Some large e-commerce merchant systems cooperate through third-party systems, so third-party systems need to accept order data issued by different systems. At present, the third-party system generally pulls orders from the merchant system stores by way of ordering. The system obtains orders in a single way and has no scalability. The interface display is also displayed based on the order information of a certain merchant’s store. Although there is a store switching function, if The order details of other systems are inconsistent with the order information of the merchant system store, and the interface cannot be compatible with other types of order data.

For example, there is no correlation between the order data of a merchant’s system store and the related data, such as product information in the order, product inventory information, invoice information, gift information, etc., each time the relationship data query needs to find the corresponding functional module, enter it Product code or merchant system store order number query, a kind of relational data needs to find a functional module and query it once. If you encounter batch queries, it not only consumes time, but also easily causes operational errors when switching back and forth. As a result, business operation efficiency is lower and user experience is affected.

Summary of the invention

The purpose of the present invention is to provide a multi-system and multi-store order fusion method, device, computer equipment and storage medium to solve the above-mentioned technical problem, which is used to solve the order management problem of the same product in different systems and different stores.

The technical solution to achieve the objective of the present invention is: a multi-system multi-store order fusion method, the method includes:

Obtain the order information of the target product in different stores in multiple systems;

Integrate the order information of the target product in multiple systems, and establish a fusion data information table;

Grab the data in the fusion data information table according to the instruction, and perform the instruction operation.

Further, the obtaining order information of different stores of the target commodity in multiple systems includes:

Acquiring an order warehousing time slice of the system, and determining a time slicing parameter according to the order warehousing time slice;

According to the time slicing parameter, the data interface of a preset third-party data system is called in a concurrent manner to pull store order data.

Further, determining the time slicing parameters according to the order warehousing time slicing includes:

The order storage time slice is divided into multiple sub-time slices, and the slice parameter of the sub-time slice is used as the determined time slice parameter, where different sub-time slices correspond to different threads.

Further, according to the time slicing parameters, the data interface of a preset third-party data system is called in a concurrent manner to fetch store order data, including:

Call the order data interface of one party's system to obtain the number of order records;

According to the number of order records, obtain the orders of the party's system store by page;

After the order is listed, it is stored in the main database of the third-party data system and pushed to the order table of the large database of the other party's system.

Further, the fusion of the order information of the target commodity in multiple systems to establish a fusion data information table includes:

The third-party data system parses and pulls the application interface data of the store order data, encapsulates the order data object, and stores it in the fusion data information table.

Further, the instruction includes a marketing activity instruction.

Further, the marketing activity instruction includes:

Filter out the order data in the matching fusion data information table according to the number of the active product;

For the order data that has been screened out, it is stored as marketing activity data, which is used as the statistical basic data of the fusion data information table;

According to the activity rules, the orders that meet the marketing conditions and the orders that do not meet the marketing conditions are screened out.

Further, the instruction includes a construction work order instruction.

Further, the instruction includes an invoice issuance instruction.

A multi-system and multi-store order fusion device, the device comprising:

The acquisition module is used to acquire the order information of the target product in different stores in multiple systems;

The fusion module is used to integrate the order information of the target product in multiple systems and establish a fusion data information table;

The instruction operation module captures the data in the fusion data information table according to the instruction and performs instruction operations.

A computer device includes a memory, a processor, and a computer program that is stored in the memory and can run on the processor, and the processor implements the following steps when the processor executes the computer program:

Integrate the order information of the target product in multiple systems and establish a fusion data information table;

A computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the following steps are implemented:

Compared with the prior art, the present invention has significant advantages: the above-mentioned multi-system and multi-store order fusion method, device, computer equipment and storage medium realize the multi-system order management problem caused by the same product in different systems and different stores. Multi-store order data is pulled in shards, the related product information in the sub-orders is analyzed, and the order data is sorted out, and after-sales service support system can be established through the integrated data management marketing activities. At the same time, it can generate statistics and generate business support data to promote after-sales activities. ; Solve the technical problems of multi-system and multi-store order merging, and greatly improve the work efficiency of after-sales marketing activities.

Description of the drawings

Fig. 1 is an application environment diagram of a multi-system multi-store order fusion method in an embodiment.

FIG. 2 is a schematic flowchart of a method for order fusion of multiple systems and multiple stores in an embodiment.

Figure 3 is a network topology diagram of the order system in an embodiment.

Fig. 4 is a sequence diagram of order fragment management in an embodiment.

Fig. 5 is a sequence diagram of order synchronization execution in an embodiment.

Fig. 6 is a structural block diagram of a multi-system and multi-store order fusion device in an embodiment.

Detailed ways

In order to make the purpose, technical solutions, and advantages of this application clearer, the following further describes this application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not used to limit the present application.

The multi-system multi-store order fusion method provided by this application can be applied to the application environment as shown in FIG. 1. Among them, the first system 101 and the second system 102 communicate with the server 103 through the network, and the third-party system server 103 communicates with the terminal 104 through the network. Among them, the third-party system server 103 can be implemented by an independent system or a system cluster composed of multiple systems. The first system 101 can refer to the commodity server of one party's e-commerce platform, and the second system 102 can refer to the other party's e-commerce platform. The commodity server, the first system 101 and the second system 102 may be one or more, and the terminal 104 may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices.

In one embodiment, as shown in FIG. 2, a method for multi-system and multi-store order fusion is provided. Taking the method applied to the server in FIG. 1 as an example for description, the method includes the following steps:

Set the target product, the order O1 generated in the first system 101, and the order O2 generated in the second system 102, the order O1 and the order O2 are isolated from each other, now it is necessary to carry out after-sales tracking of the order of the product and initiate marketing Activities, such as order gifts activities, etc.

Step 1. Obtain the order information of the target product in different stores in multiple systems;

Specifically, the first system 101 online store backstage pushes the second system 102 online store order to the first system 101 cloud system order table, and the first system 101 cloud platform pull order application accesses the first system 101 cloud system order table, and reads the order form. Push orders. Among them, the target product can use the SKU information as an index mark to capture the order of the system store.

The third-party system adopts the sharding concurrency technology to divide the order according to the storage time, and uses the concurrent method to call the data interface of the third-party data system to pull the online store order data.

Further, the order storage time slice is divided into multiple sub-time slices, and the slice parameter of the sub-time slice is used as the determined time slice parameter, wherein different sub-time slices correspond to different threads.

Call the order data interface of the first system to obtain the number of order records;

According to the number of order records, the first system store orders are obtained in pages;

After the orders are listed, they are stored in the main database of the third-party data system and pushed to the order table of the second system's large database.

Step 2: Integrate the order information of the target product in multiple systems, and establish a fusion data information table;

The third-party data system analyzes the application interface data of the first system 101 cloud system, encapsulates the order data object, and stores it in the fusion data information table.

Step 3: Grab the data in the fusion data information table according to the instruction, and perform the instruction operation. The instructions include marketing activity instructions, construction work order instructions, invoice issuance instructions, and the like.

The implementation of the marketing activity instruction includes:

Combine specific examples to describe the process of system implementation of marketing activities:

1) Enter the product number in batches;

2) Filter the corresponding order to the big data platform of the third-party data system according to the product number;

3) Secondary filtering for the filtered order list data;

4) Set up orders that meet the marketing conditions (such as gifts);

5) Set up orders that do not meet the conditions for participating in marketing;

6) Export the order report that meets the marketing conditions.

7) The business personnel conduct after-sales tracking according to the order report, which improves the efficiency of processing marketing orders.

In one of the embodiments, as shown in FIG. 4, the above-mentioned obtaining order information of different stores of the target product in multiple systems may include the following steps:

Step 101: Obtain an order warehousing time slice of the system, and determine a time slicing parameter according to the order warehousing time slice;

Step 102: According to the time slicing parameter, a data interface of a preset third-party data system is called in a concurrent manner to fetch store order data.

Here, the order storage time slice is divided into multiple sub-time slices, and the slice parameter of the sub-time slice is used as the determined time slice parameter, wherein different sub-time slices correspond to different threads.

With the solution of this embodiment, the order data of the first system and the second system can be obtained in quasi real-time and complete.

In one of the embodiments, the above-mentioned determining the time slice parameter based on the order warehousing time slice may include the step of dividing the order warehousing time slice into multiple sub-time slices, and using the slicing parameter of the sub-time slice as the determining time slice. Slice parameters, where different sub-time slices correspond to different threads.

Using the solution of this embodiment can further improve the real-time performance of the system's order data acquisition.

In one of the embodiments, as shown in Figures 4 and 5, the aforementioned data interface of a preset third-party data system is called to fetch store order data based on time slicing parameters and in a multi-threaded concurrent manner, which may include the following step:

Step 201, call the order data interface of the first system to obtain the number of order records;

Step 202, according to the number of order records, obtain the first system store orders in pages;

In step 203, the order list is stored in the main database of the third-party data system and pushed to the order table of the large database of the second system.

With the solution of this embodiment, every time a page of order data of the first system and the second system is obtained, the fusion of order data can be performed, which can further improve the real-time acquisition of the order data of the first system and the second system. Sex.

In one of the embodiments, the multi-system multi-store order fusion method may further include: building a marketing activity system by fusing order data. The process of building a marketing activity system is described as follows:

For the order data that has been screened out, it is stored as marketing activity data, which serves as basic data for statistics of the fusion data information table;

According to the activity rules, the orders that meet the marketing conditions and the orders that do not meet the marketing conditions are filtered out, and then the order activity data can be maintained, such as giving gifts.

In addition to the above marketing activities, you can also integrate order data to build a work order system, an invoice system, and so on.

In order to facilitate the understanding of the solution of the present invention, a specific example is used for description below. In this specific example, the order of the online shop of the first system is taken as an example, and the above-mentioned server includes three systems of a third-party data system, a third-party management system, and a third-party workbench, but this does not constitute a limitation on the solution of the present invention. . The multi-system multi-store order fusion method in this specific example includes the following steps:

Step 1: The first system online shop pushes the first system store orders to the first system order table, and the first system cloud platform ordering application accesses the first system order table to read the pushed orders.

Step 2: The third-party management system adopts the sharding concurrency technology, that is, the order is sharded according to the storage time, and the RSF interface of the third-party data system is used in a concurrent way to pull the online store order data. That is, the order storage time slice is divided into multiple sub-time slices, and the slice parameter of the sub-time slice is used as the determined time slice parameter, wherein different sub-time slices correspond to different threads; according to the time slice The data interface of the preset third-party data system is called to fetch store order data in a concurrent manner.

Step 3: The third-party data system analyzes the application interface data of the first system to encapsulate the order data object, and stores it in the multi-store order base table.

Step 4: The marketing activity system filters the matching multi-store order data according to the active products.

Step 5: Save the filtered order data as marketing activity data as the basic data for report statistics. According to the activity rules, maintain the order activity data, such as giving gifts. You can also integrate order data to build a work order, invoice system, and so on.

The order fusion solution of "sharding concurrent" in this embodiment can obtain the order information of the first system in quasi real-time and complete, and establish the order information database of the first system and the second system to generate order fusion.

In one embodiment, as shown in FIG. 6, a multi-system and multi-store order fusion device is provided, which includes: an acquisition module 105, a fusion module 106, and an instruction operation module 107, wherein:

The obtaining module 105 is used to obtain the order information of the target product in different stores in multiple systems;

The fusion module 106 is used to integrate the order information of the target product in multiple systems and establish a fusion data information table;

The instruction operation module 107 captures the data in the fusion data information table according to the instruction, and performs instruction operations.

In one of the embodiments, the acquiring module 105 can acquire the order information of the target product in different stores in multiple systems; divide the order storage time slice into multiple sub-time slices, and use the slicing parameters of the sub-time slices as the total value. The time slicing parameter is determined, wherein different sub-time slices correspond to different threads; according to the time slicing parameter, the data interface of a preset third-party data system is called in a concurrent manner to pull store order data.

In one of the embodiments, the obtaining module 105 can call the order data interface of a party's system to obtain the number of order records; according to the number of order records, obtain the orders of the party's system store in pages; the order list is stored in the main database of the third-party data system , And push to the order table of the big database of the other party's system.

In one of the embodiments, the fusion module analyzes and pulls the application interface data of the store order data, integrates the order information of the target product in multiple systems, and establishes a fusion data information table.

In one of the embodiments, the instruction operation module 107 can establish an after-sales service support system according to marketing activity instructions, construction work order instructions, invoice issuance instructions, etc., to implement marketing activities. For the order data that has been screened out, it is stored as marketing activity data, which serves as the basic data for statistics in the fusion data information table; according to the activity rules, orders that meet the marketing conditions and orders that do not meet the marketing conditions are screened out.

In one embodiment, a computer device is provided, and the computer device may be a server. The computer equipment includes a processor, a memory, a network interface, and a database connected through a system bus. Among them, the processor of the computer device is used to provide calculation and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage medium. The database of the computer equipment is used to store the data needed in the process of multi-system and multi-store order fusion data. The network interface of the computer device is used to communicate with an external terminal through a network connection. The computer program is executed by the processor to realize a multi-system multi-store order fusion method.

Those skilled in the art can understand that the above structure does not constitute a limitation on the computer equipment to which the solution of the present application is applied. The specific computer equipment may include more or less components than the above, or combine certain components, or have Different component arrangements.

In one embodiment, a computer device is provided, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, and the processor implements the following steps when the processor executes the computer program:

In one of the embodiments, the processor executes the computer program to realize the aforementioned acquisition of order information of different stores of the target product in multiple systems; acquire the order storage time slice of the system, and determine the time according to the order storage time slice Sharding parameters; according to the time slicing parameters, the data interface of a preset third-party data system is called in a concurrent manner to pull store order data.

In one of the embodiments, when the processor executes the computer program to implement the above-mentioned step of determining the time slicing parameter according to the order warehousing time slicing, the following steps are specifically implemented:

In one of the embodiments, when the processor executes the computer program to implement the above-mentioned time-slicing parameters, and uses a multi-threaded concurrent method to call a preset data interface of a third-party data system to fetch store order data, the following steps are specifically implemented: Call the order data interface of one party's system to obtain the number of order records; according to the number of order records, obtain the orders of the party's system store by page; the order list is stored in the main database of the third-party data system, and pushed to the other party's large database order table .

In one of the embodiments, the processor executes the computer program to realize the aforementioned fusion of the order information of the target product in multiple systems. When the fusion data information table is established, the application interface data of the store order data is parsed and pulled, and the order is encapsulated. The data object is stored in the fusion data information table.

In one of the embodiments, when the processor executes the computer program, the marketing activity also implements the following steps: according to the serial number of the active product, the order data in the matching fusion data information table is filtered out; for the order data that has been filtered out , Stored as marketing activity data, as the basic statistics of the fusion data information table; according to the rules of the activity, the orders that meet the marketing conditions and the orders that do not meet the marketing conditions are screened out.

In one of the embodiments, the processor also implements the construction work order system and the invoice system when executing the computer program.

A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be implemented by instructing relevant hardware through a computer program. The computer program can be stored in a non-volatile computer readable storage. In the medium, when the computer program is executed, it may include the procedures of the above-mentioned method embodiments. Wherein, any reference to memory, storage, database or other media used in the embodiments provided in this application may include non-volatile and/or volatile memory. Non-volatile memory may include read only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. As an illustration and not a limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous chain Channel (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

The technical features of the above embodiments can be combined arbitrarily. In order to make the description concise, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features, they should be It is considered as the range described in this specification.

The above-mentioned embodiments only express several implementation manners of the present application, and their description is relatively specific and detailed, but they should not be understood as a limitation on the scope of the invention patent. It should be pointed out that for those of ordinary skill in the art, without departing from the concept of this application, several modifications and improvements can be made, and these all fall within the protection scope of this application. Therefore, the scope of protection of the patent of this application shall be subject to the appended claims.

Claims

A multi-system multi-store order fusion method, characterized in that the method includes:

Obtain the order information of the target product in different stores in multiple systems;

Integrate the order information of the target product in multiple systems, and establish a fusion data information table;

Grab the data in the fusion data information table according to the instruction, and perform the instruction operation.
The method according to claim 1, wherein said obtaining order information of different stores of the target commodity in multiple systems comprises:

Acquiring an order warehousing time slice of the system, and determining a time slicing parameter according to the order warehousing time slice;

According to the time slicing parameter, the data interface of a preset third-party data system is called in a concurrent manner to pull store order data.
The method according to claim 2, wherein determining the time slicing parameter according to the time slicing of the order storage includes:

The order storage time slice is divided into multiple sub-time slices, and the slice parameter of the sub-time slice is used as the determined time slice parameter, where different sub-time slices correspond to different threads.
The method according to claim 2, characterized in that, according to the time slicing parameter, using a concurrent method to call a preset data interface of a third-party data system to fetch store order data, comprising:

Call the order data interface of one party's system to obtain the number of order records;

According to the number of order records, obtain the orders of the party's system store by page;

After the order is listed, it is stored in the main database of the third-party data system and pushed to the order table of the large database of the other party's system.
The method according to claim 1, wherein said fusing the order information of the target product in multiple systems to establish a fusion data information table comprises:

The third-party data system parses and pulls the application interface data of the store order data, encapsulates the order data object, and stores it in the fusion data information table.
The method according to claim 1, wherein the instruction includes a marketing activity instruction.
The method according to claim 6, wherein the marketing activity instruction comprises:

Filter out the order data in the matching fusion data information table according to the number of the active product;

For the order data that has been screened out, it is stored as marketing activity data, which serves as basic data for statistics of the fusion data information table;

According to the activity rules, the orders that meet the marketing conditions and the orders that do not meet the marketing conditions are screened out.
The method according to claim 1, wherein the instruction includes a construction work order instruction.
The method according to claim 1, wherein the instruction includes an invoice issuance instruction.
A multi-system and multi-store order fusion device, characterized in that the device comprises:

The acquisition module is used to acquire the order information of the target product in different stores in multiple systems;

The fusion module is used to integrate the order information of the target product in multiple systems and establish a fusion data information table;

The instruction operation module captures the data in the fusion data information table according to the instruction and performs instruction operations.
A computer device, comprising a memory, a processor, and a computer program stored on the memory and running on the processor, wherein the processor implements any one of claims 1 to 9 when the computer program is executed The steps of the method.
A computer-readable storage medium having a computer program stored thereon, wherein the computer program implements the steps of the method according to any one of claims 1 to 9 when the computer program is executed by a processor.