CN110766520A

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

Info

Publication number: CN110766520A
Application number: CN201910970189.XA
Authority: CN
Inventors: 刘建洋; 杨程成; 黄瑾; 史凯丽; 聂鑫鑫
Original assignee: Suning Cloud Computing Co Ltd
Current assignee: Suning Cloud Computing Co Ltd
Priority date: 2019-10-12
Filing date: 2019-10-12
Publication date: 2020-02-07
Also published as: CA3157818A1; WO2021068607A1

Abstract

The invention discloses a multi-system multi-shop order fusion method and device, computer equipment and a storage medium. The method comprises the following steps: acquiring order information of target commodities in different shops in a plurality of systems; fusing order information of the target commodity in a plurality of systems to establish a fused data information table; and capturing data in the fusion data information table according to the instruction, and performing instruction operation. By adopting the method, the order data of multiple systems and multiple shops can be fused, and the working efficiency of after-sale marketing activities is greatly improved.

Description

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

Technical Field

The invention belongs to the technical field of data processing, and particularly relates to a multi-system multi-shop order fusion method and device, computer equipment and a storage medium.

Background

At the present stage, electronic commerce in China is rapidly increased, and an attitude system with complete functions is preliminarily formed; the fields related to the e-commerce are wider and wider, and the e-commerce industry is also diversified. The continuous popularization of electronic commerce directly drives the development of the industries of service types such as logistics, finance and IT, and the development of various sub-industries in a commercial ecological circle such as third-party payment, electronic authentication, network information security, network insurance and the like matched with the industries.

Meanwhile, a plurality of E-business enterprises do not operate independently, but promote self business operation in a cooperative and mutual-aid mode, and the E-business enterprises respectively take the needs and develop together. Some large-scale e-commerce home systems cooperate with each other through a third-party system, so that the third-party system needs to receive order data issued by different systems. At present, a third-party system generally pulls orders of merchant system stores in a pull-order mode, the order obtaining mode of the system is single, expansibility is not available, interface display is also performed according to order information of a merchant store of a certain party, although a store switching function is available, if the order details of other systems are inconsistent with the order information of the merchant system store, the interface cannot be compatible with other types of order data.

For example, the order data of one merchant system store has no correlation with related data thereof, such as commodity information, commodity stock information, invoice information, gift information and the like in an order, the corresponding functional module needs to be found each time of relationship data query, a commodity code or merchant system store order number is input for query, and one relationship data needs to be found and queried once. If batch query is encountered, not only is time consumed, but also operation errors are easily caused by switching back and forth, and as a result, the service operation efficiency is low, and the user experience is influenced.

Disclosure of Invention

The invention aims to solve the technical problems and provides a multi-system multi-store order fusion method, a multi-system multi-store order fusion device, a computer device and a storage medium, which are used for solving the order management problem of the same commodity in different systems and different stores.

The technical solution for realizing the purpose of the invention is as follows: a multi-system multi-store order fusion method, the method comprising:

acquiring order information of target commodities in different shops in a plurality of systems;

fusing order information of the target commodity in a plurality of systems to establish a fused data information table;

and capturing data in the fusion data information table according to the instruction, and performing instruction operation.

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

acquiring an order warehousing time slice of the system, and determining time slice parameters according to the order warehousing time slice;

and calling a data interface of a preset third-party data system in a concurrent mode to pull the shop order data according to the time slicing parameters.

Further, determining time slice parameters according to the order warehousing time slice comprises:

and dividing the order warehousing time slice into a plurality of sub time slices, and taking the slicing parameters of the sub time slices as the determined time slicing parameters, wherein different sub time slices correspond to different threads.

Further, according to the time slicing parameters, calling a data interface of a preset third-party data system in a concurrent mode to pull the shop order data, and the method comprises the following steps:

calling a side system order data interface to obtain order record number;

obtaining the system shop orders of the party in pages according to the order record number;

and the orders are listed and then stored in a third-party data system main base, and are pushed to an order list of a large database of the other party system.

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

and the third-party data system packages the order data object by analyzing and pulling the application interface data of the shop order data and stores the order data object in the fusion data information table.

Further, the instructions include marketing campaign instructions.

Further, the marketing campaign instructions include:

screening out order data in the matched fusion data information table according to the serial number of the movable commodity;

aiming at the screened order data, storing the order data as marketing activity data as statistical basic data of a fusion data information table;

and screening out orders meeting the marketing conditions and orders not meeting the marketing conditions according to the activity rules.

Further, the instructions include construction work order instructions.

Further, the instructions include invoicing instructions.

A multi-system multi-store order fusion apparatus, the apparatus comprising:

the system comprises an acquisition module, a storage module and a display module, wherein the acquisition module is used for acquiring order information of target commodities in different shops in a plurality of systems;

the fusion module is used for fusing order information of the target commodity in a plurality of systems and establishing a fusion data information table;

and the instruction operation module is used for capturing data in the fusion data information table according to the instruction and carrying out instruction operation.

A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:

A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:

Compared with the prior art, the invention has the following remarkable advantages: according to the multi-system multi-store order fusion method, the multi-system multi-store order fusion device, the computer equipment and the storage medium, aiming at order management problems of the same commodity in different systems and different stores, multi-system multi-store order data are pulled in a slicing mode, correlated commodity information in sub-orders is analyzed, fusion order data are combed, marketing activities are managed through the fusion data, an after-sale service support system can be established, and meanwhile business support data for promoting the after-sale activities can be generated in a statistical mode; the technical problem of multi-system and multi-shop order combination is solved, and the working efficiency of after-sale marketing activities is greatly improved.

Drawings

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

FIG. 2 is a flow diagram of a multi-system multi-store order fusion method, under an embodiment.

FIG. 3 is a network topology diagram of an order system in one embodiment.

Fig. 4 is a sequence diagram of order slice management in one embodiment.

FIG. 5 is a sequence diagram of order synchronization execution, under an embodiment.

FIG. 6 is a block diagram of an embodiment of a multi-system multi-store order fusion apparatus.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

The multi-system multi-shop order fusion method can be applied to the application environment shown in FIG. 1. The first system 101 and the second system 102 communicate with the server 103 through a network, and the third-party system server 103 and the terminal 104 communicate through the network. The third-party system server 103 may be implemented by an independent system or a system cluster formed by a plurality of systems, the first system 101 may refer to a commodity server of one e-commerce platform, the second system 102 may refer to a commodity server of another e-commerce platform, the first system 101 and the second system 102 may be one or a plurality of systems, 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 multi-system multi-store order fusion method is provided, which is described by taking the method as an example applied to the server in fig. 1, and includes the following steps:

the target item is set, and the order O1 generated at the first system 101 and the order O2, the order O1 and the order O2 generated at the second system 102 are isolated from each other, and it is now necessary to perform after-sales tracking on the order of the item and initiate marketing campaigns, such as order gift campaigns.

Step 1, obtaining order information of target commodities in different shops in a plurality of systems;

specifically, the first system 101 cloud platform pull-order application accesses the first system 101 cloud system order form table and reads the pushed order form when the first system 101 cloud platform pull-order application pushes the second system 102 online store order form to the first system 101 cloud system order form table. The target goods can adopt SKU information as an index identification to capture orders of the system shop.

And the third-party system adopts a fragment concurrency technology to fragment the order according to the library entry time, and calls a data interface of the third-party data system in a concurrent mode to pull the order data of the online shop.

Further, dividing the order warehousing time slice into a plurality of sub-time slices, and taking the slicing parameters of the sub-time slices as the determined time slicing parameters, wherein different sub-time slices correspond to different threads.

Calling a first system order data interface to obtain order record number;

obtaining the orders of the first system shop in pages according to the order record number;

and the orders are listed and then stored in a third-party data system main base, and are pushed to an order list of a second system big database.

Step 2, fusing order information of the target commodity in a plurality of systems, and establishing a fusion data information table;

and the third-party data system packages the order data object by analyzing the pull order application interface data of the cloud system of the first system 101 and stores the order data object in the fusion data information table.

And 3, capturing data in the fusion data information table according to the instruction, and performing instruction operation. The instructions include marketing campaign instructions, construction work order instructions, invoicing instructions, and the like.

The implementation of the marketing campaign instructions comprises:

The process of implementing the marketing campaign by the system is described with specific examples:

1) inputting commodity numbers in batches;

2) screening a big data platform of a third-party data system according to the commodity number to inquire a corresponding order;

3) secondary filtering is conducted on the screened order list data;

4) setting orders (such as gifts) meeting marketing conditions;

5) setting orders which do not meet the participation marketing condition;

6) and exporting an order report meeting the marketing condition.

7) And business personnel perform after-sale tracking according to the order report, so that the efficiency of processing the marketing order is improved.

In one embodiment, as shown in fig. 4, the obtaining of order information of the target product in different stores in the multiple systems may include the following steps:

step 101, obtaining an order warehousing time slice of the system, and determining time slice parameters according to the order warehousing time slice;

and step 102, calling a data interface of a preset third-party data system in a concurrent mode to pull the shop order data according to the time slicing parameters.

Here, the order warehousing time slice is divided into a plurality of sub-time slices, and the slice parameters of the sub-time slices are used as the determined time slice parameters, wherein different sub-time slices correspond to different threads.

By adopting the scheme of the embodiment, the order data of the first system and the second system can be completely acquired in a quasi-real-time manner.

In one embodiment, the determining the time slice parameter according to the order warehousing time slice may include: dividing the order warehousing time slice into a plurality of sub time slices, and taking the slicing parameters of the sub time slices as the determined time slicing parameters, wherein different sub time slices correspond to different threads.

By adopting the scheme of the embodiment, the real-time performance of order data acquisition of the system can be further improved.

In one embodiment, as shown in fig. 4 and 5, the above-mentioned pulling the store order data according to the time slicing parameter and by calling the data interface of the preset third-party data system in a multi-thread concurrent manner may include the following steps:

step 201, calling a first system order data interface to obtain order record number;

step 202, obtaining orders of the first system shop in a paging mode according to the order record number;

and step 203, storing the order list in a third-party data system master library, and pushing the order list to a second-system big database order list.

By adopting the scheme of the embodiment, the fusion and carding of the order data can be executed every time the order data of the first system and the second system of one page are acquired, and the real-time performance of the acquisition of the order data of the first system and the second system can be further improved.

The multi-system multi-store order fusion method in one embodiment can further comprise the following steps: and constructing a marketing activity system by fusing order data. The process of constructing a marketing campaign system is described as follows:

according to the activity rule, the orders meeting the marketing condition and the orders not meeting the marketing condition are screened out, and then the activity data of the orders, such as gift delivery, can be maintained.

Besides the marketing activities, a work order system, an invoice system and the like can be built by fusing order data.

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

the method comprises the steps that a first system online store background pushes a first system store order to a first system order form, a first system cloud platform pull order application accesses the first system order form, and the pushed order is read.

And step two, the third-party management system adopts a fragment concurrency technology, namely, orders are fragmented according to the warehousing time, and the third-party management system calls an RSF interface of a third-party data system to pull the order data of the online shop in a concurrency mode. Dividing the order warehousing time slice into a plurality of sub time slices, and taking the slicing parameters of the sub time slices as the determined time slicing parameters, wherein different sub time slices correspond to different threads; and calling a data interface of a preset third-party data system in a concurrent mode to pull the shop order data according to the time slicing parameters.

And step three, the third-party data system packages the order data object by analyzing the pull order application interface data of the first system and stores the order data object in the order basic table of the multi-shop.

And step four, the marketing campaign system screens the matched multi-shop order data according to the campaign commodities.

And fifthly, additionally storing the screened order data as marketing activity data as report statistics basic data, maintaining order activity data such as gift delivery according to activity rules, and constructing a work order, an invoice system and the like by fusing the order data.

The 'fragment concurrent' order fusion scheme in the embodiment can completely acquire the order information of the first system in a quasi-real-time manner, establish the order information bases of the first system and the second system, and generate order fusion.

In one embodiment, as shown in fig. 6, there is provided a multi-system multi-store order fusion apparatus, including: an obtaining module 105, a fusing module 106, and an instruction operating module 107, wherein:

an obtaining module 105, configured to obtain order information of a target product in different stores in multiple systems;

the fusion module 106 is used for fusing order information of the target commodity in a plurality of systems and establishing a fusion data information table;

and the instruction operation module 107 is used for capturing data in the fusion data information table according to the instruction and performing instruction operation.

In one embodiment, the obtaining module 105 may obtain order information of the target product in different stores in the plurality of systems; dividing the order warehousing time slice into a plurality of sub time slices, and taking the slicing parameters of the sub time slices as the determined time slicing parameters, wherein different sub time slices correspond to different threads; and calling a data interface of a preset third-party data system in a concurrent mode to pull the shop order data according to the time slicing parameters.

In one embodiment, the obtaining module 105 may call a side system order data interface to obtain the order record number; obtaining the system shop orders of the party in pages according to the order record number; and the orders are listed and then stored in a third-party data system main base, and are pushed to an order list of a large database of the other party system.

In one embodiment, the fusion module fuses order information of the target commodity in a plurality of systems by analyzing application interface data of the pull shop order data to establish a fusion data information table.

In one embodiment, the instruction operation module 107 may establish an after-sales service support system according to a marketing campaign instruction, a construction work order instruction, an invoice issuing instruction, and the like, to implement a marketing campaign. Aiming at the screened order data, storing the order data as marketing activity data as statistical basic data of a fusion data information table; and screening out orders meeting the marketing conditions and orders not meeting the marketing conditions according to the activity rules.

In one embodiment, the computer device is provided, and the computer device may be a server. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile 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 an operating system and computer programs in the non-volatile storage medium. The database of the computer equipment is used for storing data required in the process of fusing the data of the multi-system multi-shop orders. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a multi-system multi-store order fusion method.

Those skilled in the art will appreciate that the above-described arrangements are not intended to limit the computer apparatus to which the present teachings apply, and that a particular computer apparatus may comprise more or less components than those described, or some components may be combined, or have a different arrangement of components.

In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:

In one embodiment, the processor executes a computer program to achieve the above-mentioned obtaining of order information of target commodities in different stores in a plurality of systems; acquiring an order warehousing time slice of the system, and determining time slice parameters according to the order warehousing time slice; and calling a data interface of a preset third-party data system in a concurrent mode to pull the shop order data according to the time slicing parameters.

In one embodiment, when the processor executes the computer program to implement the step of determining the time slice parameters according to the order entry time slice, the following steps are specifically implemented:

In one embodiment, when the processor executes the computer program to realize the above time slicing-based parameter and call a data interface of a preset third-party data system in a multi-thread concurrent manner to pull the shop order data, the following steps are specifically realized: calling a side system order data interface to obtain order record number; obtaining the system shop orders of the party in pages according to the order record number; and the orders are listed and then stored in a third-party data system main base, and are pushed to an order list of a large database of the other party system.

In one embodiment, the processor executes a computer program to realize the above-mentioned fusion of order information of the target product in multiple systems, and when a fusion data information table is established, the order data object is packaged and stored in the fusion data information table by analyzing and pulling application interface data of the shop order data.

In one embodiment, the processor, when executing the computer program, further implements the marketing campaign by: screening out order data in the matched fusion data information table according to the serial number of the movable commodity; aiming at the screened order data, storing the order data as marketing activity data as statistical basic data of a fusion data information table; and screening out orders meeting the marketing conditions and orders not meeting the marketing conditions according to the activity rules.

In one embodiment, the processor, when executing the computer program, also implements a construction work order system and an invoice system.

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 can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims

1. A multi-system multi-store order fusion method is characterized by comprising the following steps:

2. The method as claimed in claim 1, wherein the obtaining of order information of the target product in different stores in a plurality of systems comprises:

3. The method of claim 2, wherein determining time slice parameters from the order-entry time slices comprises:

4. The method according to claim 2, wherein the step of pulling the shop order data by calling a data interface of a preset third-party data system in a concurrent manner according to the time slicing parameters comprises:

calling a side system order data interface to obtain order record number;

5. The method according to claim 1, wherein the fusing the order information of the target product in the plurality of systems to establish a fused data information table comprises:

6. The method of claim 1, wherein the instructions comprise marketing campaign instructions.

7. The method of claim 6, wherein the marketing campaign instructions comprise:

8. The method of claim 1, wherein: the instructions include a construction work order instruction.

9. The method of claim 1, wherein: the instructions include invoicing instructions.

10. A multi-system multi-store order fusion apparatus, the apparatus comprising:

11. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 9 are implemented when the computer program is executed by the processor.

12. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 9.