CN115358684B

CN115358684B - Data pairing method and related device based on Stock Keeping Unit (SKU)

Info

Publication number: CN115358684B
Application number: CN202211291021.4A
Authority: CN
Inventors: 王志超; 林海平; 徐鹏; 胡海金
Original assignee: Shenzhen Meiyunji Network Technology Co ltd
Current assignee: Shenzhen Meiyunji Network Technology Co ltd
Priority date: 2022-10-21
Filing date: 2022-10-21
Publication date: 2023-01-31
Anticipated expiration: 2042-10-21
Also published as: CN115358684A

Abstract

The embodiment of the application discloses a data pairing method based on Stock Keeping Unit (SKU) and a related device, wherein the method comprises the following steps: the method comprises the steps that a shop management server obtains an online product SKU, a plurality of stock commodity SKUs and pairing rule information; determining parameter information corresponding to the pairing rule information; according to the parameter information, performing parameter adjustment on a preset pairing rule to obtain a pairing rule; selecting and reassembling a first pairing rule and/or a second pairing rule and/or a third pairing rule included in the pairing rule to obtain a target pairing rule; and executing a target pairing rule, and screening a target stock product SKU corresponding to the on-line product SKU from the plurality of stock product SKUs. By adopting the embodiment of the application, the plurality of SKU pairing rules can be executed according to the rules set by the user and the priority of the rules, so that the pairing of the on-line product SKU and the stock product SKU is realized, and the user experience is favorably improved.

Description

Data pairing method and related device based on Stock Keeping Unit (SKU)

Technical Field

The application relates to the technical field of internet, in particular to a data pairing method based on Stock Keeping Unit (SKU) and a related device.

Background

The development of computer technology has led to the proliferation of online transactions, and the e-commerce platform provides an important channel for users to operate stores to sell commodities, so that in order to facilitate users to place corresponding commodities in a local warehouse according to commodity orders, the e-commerce platform often provides the users with matching rules of online product SKUs and stock commodity SKUs, but the rules provided are often single, and the experience of the users in using the matching rules is poor.

Disclosure of Invention

The embodiment of the application provides a data pairing method based on Stock Keeping Unit (SKU) and a related device, which can execute a plurality of SKU pairing rules according to rule parameters set by a user and the priority of the rules, realize the pairing of the on-line product SKU and the stock keeping product SKU, and are favorable for improving the user experience.

In a first aspect, an embodiment of the present application provides a data pairing method based on stock keeping unit SKU, which is applied to a store management server of a cross-border e-commerce management system, where the cross-border e-commerce management system includes the store management server, a cross-border e-commerce platform server and a client device, the store management server is in communication connection with the cross-border e-commerce platform server, the client device is in communication connection with the store management server, the store management server is configured to obtain multiple stock item SKU and pairing rule information sent by the client device and synchronize item information in the cross-border e-commerce platform server, and the item information is used for the SKU management server to generate an online product, and the method includes:

acquiring the on-line product SKU, the plurality of stock product SKUs and the pairing rule information, wherein the on-line product SKU comprises M characters, M is a positive integer greater than 1, each stock product SKU comprises N characters, and N is a positive integer greater than 1;

determining parameter information corresponding to the pairing rule information, wherein the parameter information at least comprises one of the following: first parameter information, second parameter information, and third parameter information;

according to the parameter information, performing parameter adjustment on a preset pairing rule to obtain a pairing rule, wherein the pairing rule comprises a first pairing rule, a second pairing rule and a third pairing rule, the first pairing rule corresponds to the first parameter information, the second pairing rule corresponds to the second parameter information, and the third pairing rule corresponds to the third parameter information;

selecting and recombining the first pairing rule and/or the second pairing rule and/or the third pairing rule included in the pairing rule to obtain a target pairing rule;

determining the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule according to the rule priority of the first pairing rule and/or the second pairing rule and/or the third pairing rule;

and executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, and screening the target inventory commodities SKU corresponding to the on-line product SKU from the inventory commodities SKUs.

In a second aspect, an embodiment of the present application provides a data pairing device based on stock keeping unit SKU, which is applied to a store management server of a cross-border e-commerce management system, where the cross-border e-commerce management system includes the store management server, a cross-border e-commerce platform server and a client device, the store management server is in communication connection with the cross-border e-commerce platform server, the client device is in communication connection with the store management server, the store management server is configured to obtain multiple stock item SKU and pairing rule information sent by the client device and synchronize item information in the cross-border e-commerce platform server, and the item information is used for the store management server to generate an online product SKU, and the device includes: an acquisition unit, a generation unit, a screening unit and a determination unit, wherein,

the acquisition unit is configured to acquire the online product SKU, the multiple stock product SKUs, and the pairing rule information, where the online product SKU includes M characters, M is a positive integer greater than 1, each stock product SKU includes N characters, and N is a positive integer greater than 1;

the determining unit is configured to determine parameter information corresponding to the pairing rule information, where the parameter information includes at least one of: first parameter information, second parameter information, and third parameter information;

the adjusting unit is configured to perform parameter adjustment on a preset pairing rule according to the parameter information to obtain a pairing rule, where the pairing rule includes a first pairing rule, a second pairing rule, and a third pairing rule, the first pairing rule corresponds to the first parameter information, the second pairing rule corresponds to the second parameter information, and the third pairing rule corresponds to the third parameter information;

the recombining unit is configured to select and recombine the first pairing rule and/or the second pairing rule and/or the third pairing rule included in the pairing rule to obtain a target pairing rule;

the determining unit is further configured to determine, according to a rule priority of the first pairing rule and/or the second pairing rule and/or the third pairing rule, a sequence of execution of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule;

the screening unit is configured to execute the target pairing rule according to an execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, and screen the multiple stock commodity SKUs to obtain a target stock commodity SKU corresponding to the online product SKU.

In a third aspect, embodiments of the present application provide an electronic device, including a processor, a memory, a communication interface, and one or more programs, stored in the memory and configured to be executed by the processor, the programs including instructions for performing some or all of the steps as described in the first aspect of embodiments of the present application.

In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program for electronic data exchange, where the computer program enables a computer to perform some or all of the steps described in the first aspect of the embodiment of the present application.

It can be seen that, in the embodiment of the present application, the store management server can obtain online product SKUs, multiple stock product SKUs, and pairing rule information, and determine parameter information corresponding to the pairing rule information, where the parameter information at least includes one of the following: the method comprises the steps of obtaining a matching rule by adjusting parameters of preset matching rules according to the parameter information, wherein the matching rule comprises a first matching rule, a second matching rule and a third matching rule, the first matching rule corresponds to first parameter information, the second matching rule corresponds to second parameter information, the third matching rule corresponds to third parameter information, selecting the first matching rule and/or the second matching rule and/or the third matching rule included in the matching and repeating matching rule to obtain a target matching rule, further determining the execution sequence of the first matching rule and/or the second matching rule and/or the third matching rule in the target matching rule according to the rule priority of the first matching rule and/or the second matching rule and/or the third matching rule, and finally executing the target matching rule according to the execution sequence of the first matching rule and/or the second matching rule and/or the third matching rule in the target matching rule to obtain the inventory of corresponding SKU products from a plurality of selected commodities. Therefore, the multiple SKU pairing rules can be executed according to the rule parameters set by the user and the priority of the rules, the pairing of the on-line product SKU and the stock product SKU is realized, and the user experience is favorably improved.

Drawings

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

FIG. 1a is a schematic diagram of an architecture of a stock keeping unit SKU-based data pairing system according to an embodiment of the present application;

FIG. 1b is a schematic diagram of an architecture of another SKU-based data pairing system according to an embodiment of the present application;

FIG. 2a is a schematic flow chart diagram illustrating a method for data matching based on stock keeping unit SKU according to an embodiment of the present application;

FIG. 2b is a schematic flow chart diagram illustrating another method for data matching based on stock keeping unit SKU according to the embodiment of the present application;

fig. 3 is a schematic structural diagram of an electronic device according to an embodiment of the present application;

FIG. 4a is a schematic diagram of a stock keeping unit SKU-based data pairing apparatus according to an embodiment of the present application;

FIG. 4b is a schematic diagram of another data pairing apparatus based on stock keeping unit SKU according to the embodiment of the present application.

Detailed Description

In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.

The terms "first," "second," and the like in the description and claims of the present application and in the foregoing drawings are used for distinguishing between different objects and not for describing a particular sequential order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover a non-exclusive inclusion. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements but may alternatively include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the application. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is explicitly and implicitly understood by one skilled in the art that the embodiments described herein may be combined with other embodiments.

1) The electronic device according to the embodiment of the present application may include various handheld devices, vehicle-mounted devices, wearable devices, computing devices or other processing devices connected to a wireless modem, which have wireless communication functions, and various forms of User Equipment (UE), mobile Stations (MS), terminal devices (terminal device), and the like. For convenience of description, the above-mentioned devices are collectively referred to as electronic devices. In some examples, the electronic device includes a server that provides computing or application services for other client devices (e.g., terminal devices such as PCs, smartphones, ATMs, etc.) in a network, and the server may also be a cloud server, or a store management server, or a cross-border e-commerce platform server, etc.

2) SKUs (Stock Keeping Unit), which is used as a Unit of Stock entrance and exit metering, may be in units of pieces, boxes, trays, and the like. For electronic commerce, a SKU corresponds to a commodity, and is a commodity code used for identifying a commodity By an electronic commodity plate and facilitating unified management of purchasing, warehousing, FBA (bulk By Amazon, amazon logistics) delivery and replenishment, and meanwhile, a commodity also corresponds to a plurality of SKUs, for example: if a garment has multiple colors, the SKUs corresponding to different colors are different.

At present, stock commodity SKU is often set by user definition, and a SKU matching rule provided by a store management server for a user is convenient for realizing the matching of an online product SKU and the stock commodity SKU, but the SKU matching rule provided by the store management server for the user is single, the user cannot flexibly adjust the matching rule according to the stock commodity SKU set by the user to complete the SKU matching, and the user experience is poor.

In view of the above problems, the present application provides a data pairing method and related apparatus based on stock keeping unit SKU, which will be described in detail below.

Referring to fig. 1a, fig. 1a is a schematic diagram of an architecture of a stock keeping unit SKU-based data pairing system according to an embodiment of the present application, which may include a store management server 100a, a client device 100b, and a cross-border e-commerce platform server 100c.

The shop management server 100a is in communication connection with the cross-border e-commerce platform server 100c, the client device 100b is in communication connection with the shop management server 100a, the shop management server 100a can acquire a plurality of stock commodity SKUs and pairing rule information sent by the client device 100b and can synchronize the commodity information in the cross-border e-commerce platform server 100c, the shop management server 100a can generate online product SKUs according to the commodity information, and the shop management server 100a can send a rule parameter adjustment prompt, a pairing success prompt and a parameter adjustment prompt to the client device 100b.

The ASIN (Amazon Standard Identification Number) is a unique Number automatically generated by Amazon for each product on the Amazon platform, the ASIN is associated with product information, a user can find a unique corresponding product by searching the ASIN on the Amazon platform, and one ASIN corresponds to one MSKU.

The MSKU is a SKU of an online product provided by the Amazon platform for a user, and is a SKU generated for the product by the Amazon platform after the user puts the product in a store on the Amazon platform, wherein the MSKU is the same as or different from the SKU of the online product, the SKU of the online product is generated on a store management server, and the MSKU corresponds to the SKU of an inventory product, namely, on the Amazon platform, each product in the store corresponds to one MSKU and one SKU of the inventory product.

The system comprises an online product SKU, a product management server and a product management server, wherein the online product SKU is used for identifying online products and is used for facilitating unified management of sales, delivery replenishment and the like. And the stock commodity SKU is used for uniformly managing warehousing, purchasing, delivery replenishment and the like by a user. After the on-line product SKU and the stock product SKU are matched on the store management server, the user can find the stock product SKU according to the on-line product SKU in the order, and then find the product of the stock product SKU in the local warehouse through the stock product SKU so as to conveniently send the product to the corresponding buyer.

Wherein, the cross-border e-commerce platform can be an amazon platform. The store management server can provide real-time summary of data such as advertisements, orders, cost, profits and the like for a cross-border e-commerce platform, graphically display data such as advertisements, orders, cost, profits and the like, aggregate display advertisement data across stores, sites, types and hierarchical interfaces, generate a multi-dimensional advertisement report, calculate inventory data such as dynamic sales, display inventory conditions, display logistics conditions, display local, overseas, on-the-way and FBA (fiber bulk freight analysis), intensively check a logistics track to quickly find logistics abnormal conditions, support batch payment in multiple payment modes, seamlessly connect financial payment processes, synchronize purchase order states in real time, support inventory management of multiple stores, multiple SKUs, combined products and processed products, support FBA (fuzzy component By Myself-distribution) local bins, overseas bins and other delivery modes, accurately check conditions according to sites, ASIN and salesman, and comprehensively display services such as data such as benefits, store fees, advertisements, tax fees and the like.

The cross-border e-commerce platform server 100c may include n sites, each site corresponding to at least one store, and each store corresponding to commodity information and a plurality of stock commodity SKUs.

The client device 100b may send the ASIN to the store management server 100a, and the store management server 100a synchronizes relevant data corresponding to a plurality of sites in the cross-border e-commerce platform server 100c according to the obtained ASIN, for example: the store management server 100a may synchronize the related data corresponding to the site 1, the related data corresponding to the site 2, and the related data corresponding to the site k in the cross-border e-commerce platform server 100c, where the related data may include at least one of the following: logistics information, purchasing information, boxing information, sales information, commodity information, inventory information, and the like, without limitation.

Wherein, only one shop can be operated to an account in cross-border electricity merchant platforms such as amazon platform, and the user needs frequently to change the account simultaneously or log in the real-time view and the processing of the data of a plurality of shops with many terminals logging in the account when seting up a plurality of shops, very inconvenient, for example: the sales volume of the plurality of stores is checked and counted, the order information, the logistics information and the like of the plurality of stores are checked, much time and energy are consumed in managing the plurality of stores, the store management server 100a can synchronize the relevant data of the plurality of stores of the user on a cross-border electricity business platform such as an amazon platform in real time, the user can conveniently check the relevant data of the plurality of stores in real time, and processing operation is performed on the relevant data.

The store management server 100a may acquire stock commodities SKU and ASIN from the client device 100b, store the stock commodities SKU in a stock commodity SKU database in the store management server 100a, store the ASIN in an ASIN database in the store management server 100a, synchronize commodity information corresponding to a site in the cross-border platform server 100c, store the commodity information in a commodity information database in the store management server 100a, generate an online product SKU of the corresponding commodity according to the commodity information, and store the online product SKU in an online product database in the store management server 100 a.

In this case, the store management server 100a may transmit the pairing status of the online product SKU and the stock product SKU and the pairing result to the client device 100b.

As shown in fig. 1b, the schematic structural diagram of another data pairing system based on stock keeping unit SKU provided in this embodiment of the present application is a rule setting interface in the store management server 100a, and includes three pairing rules, which are a first pairing rule, a second pairing rule, and a third pairing rule in sequence, and after the pairing rules are set, the set rules can be tested by clicking a test.

The first pairing rule is that pairing is carried out when an online product SKU and an inventory product SKU are completely consistent, the second pairing rule is that designated symbols are removed from the online product SKU, namely characters are preset, if the symbols are completely consistent with the inventory product SKU, pairing is carried out, a user can set which symbol or which symbols the designated symbols are specific, and the third pairing rule is that after the online product SKU is intercepted according to the number of digits, pairing is carried out if the symbols are completely consistent with the inventory product SKU, the user can set the number of characters from the number-first character.

The store management server 100a may establish communication connection with a plurality of client apparatuses 100b, the store management server 100a may transmit related information to the plurality of client apparatuses 100b, respectively, and the store management server 100a may simultaneously receive information such as ASIN and stock product SKU transmitted from the plurality of client apparatuses 100b.

In one possible example, the store management server 100a may obtain a plurality of stock product SKUs, pairing rule information, and ASIN sent by the client device 100b, synchronize the product information in the cross-border e-commerce platform server 100c according to the ASIN, the store management server 100a generates an online product SKU according to the product information, stores the online product SKU in an online product SKU database in the store management server 100a, the store management server 100a further determines parameter information corresponding to the pairing rule information, performs parameter adjustment on a preset pairing rule according to the parameter information to obtain a pairing rule, further the store management server 100a selects and recombines a first pairing rule and/or a second pairing rule and/or a third store pairing rule included in the pairing rule to obtain a target pairing rule, determines an execution order of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule according to a rule priority of the first pairing rule and/or the second pairing rule and/or the third pairing rule, determines an execution order of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule in the store management server 100a corresponding order to obtain a pairing rule, and a corresponding pairing rule in the inventory SKU pairing rule or the pairing rule in the pairing rule, and/or the pairing rule in the target pairing rule execution order to obtain a pairing rule, and a pairing rule in the pairing rule. Therefore, the plurality of SKU pairing rules can be executed according to the rule parameters and the priority of the rules set by the user, the pairing of the on-line product SKU and the stock commodity SKU is realized, and the improvement of the user experience is facilitated.

It should be noted that, in the present application, a plurality may refer to two or more, and details are not described later.

Referring to fig. 2a, fig. 2a is a schematic flowchart of a data pairing method based on stock-keeping unit SKU according to an embodiment of the present application, and is applied to a store management server of a cross-border e-commerce management system, where the cross-border e-commerce management system includes the store management server, a cross-border e-commerce platform server, and a client device, the store management server is in communication connection with the cross-border e-commerce platform server, the client device is in communication connection with the store management server, the store management server is configured to obtain a plurality of stock-keeping product SKUs and pairing rule information sent by the client device and synchronize product information in the cross-border e-commerce platform server, and the product information is used for the store management server to generate an online product.

S201, obtaining the on-line product SKU, the plurality of stock product SKUs and the pairing rule information, wherein the on-line product SKU comprises M characters, M is a positive integer larger than 1, each stock product SKU comprises N characters, and N is a positive integer larger than 1.

The pairing rule information specifically includes a first pairing rule and/or a second pairing rule and/or a third pairing rule.

The shop management server can acquire ASIN, a plurality of stock commodity SKUs and pairing information from the client equipment, acquire commodity information related to the ASIN from a cross-border e-commerce platform server such as an Amazon platform according to the ASIN, and further generate an online product SKU according to the commodity information.

Wherein, the commodity information may include at least one of: brand, model, commodity category, inventory address, quality inspection process, transportation of hazardous materials, size, weight, box size, single box weight, purchase duration, purchaser, developer, remark, price, date of manufacture, place of manufacture, color, grade, use, and the like.

Wherein, the on-line product SKU and stock product SKU are both SKU codes, i.e. a string of characters consisting of a plurality of numbers, letters and symbols, each of which may comprise a plurality of fields, each of which may consist of a plurality of numbers and letters, the fields being for indicating at least one of: brand information, model information, commodity category information, stock address information, shop information, price information, production date information, place of production information, color information, grade information, usage information, and the like, for example: SKU1:1-phone-1234-9, where field 9 indicates that the inventory address is warehouse number 9, field 1234 indicates that the brand code is 1234, field 1 indicates store number 1, and field phone indicates that the goods category is cell phone.

The stock product SKU is a SKU code which is set by a user in the store management server in a user-defined manner according to the product information, namely, the stock product SKU, and the on-line product SKU and the stock product SKU may be the same or different, and when the on-line product SKU and the stock product SKU are different, the length of the character string of the on-line product SKU is greater than the length of the stock product SKU, for example: the online product SKU may include a store field indicating store information, while the stock item SKU does not include a field indicating store information.

The store management server can store the obtained ASIN, stock commodity SKU and online product SKU in an ASIN database, a stock commodity SKU database and an online product SKU database in the store management server respectively.

S202, determining parameter information corresponding to the pairing rule information, wherein the parameter information at least comprises one of the following: first parameter information, second parameter information, and third parameter information.

The first parameter information corresponds to the first pairing, the second parameter information corresponds to the second pairing, and the third parameter information corresponds to the third pairing rule.

The first parameter information refers to that all characters are completely consistent, the second parameter information refers to an appointed symbol in an online product, namely a preset character, and the third parameter information refers to the number of characters intercepted from which character of an online product SKU.

Wherein the parameter information is also sent by the client device to the store management server.

S203, adjusting parameters of a preset pairing rule according to the parameter information to obtain a pairing rule, wherein the pairing rule comprises a first pairing rule, a second pairing rule and a third pairing rule, the first pairing rule corresponds to the first parameter information, the second pairing rule corresponds to the second parameter information, and the third pairing rule corresponds to the third parameter information.

The preset matching rules are preset by the shop management server, the preset matching rules can be the same or different for different users, the preset matching rules can be different in number and matching rule parameters, the difference of online product SKUs can be different due to the fact that the different types of commodities in the user shop are considered, the difference can include the difference of the number of character digits and the difference of characters, and therefore the shop management server can preset the preset rules suitable for the users according to the types of the commodities in the user shop.

The shop management server can adjust the first matching rule according to the first parameter information, adjust the second matching rule according to the second parameter information, and adjust the third matching rule according to the third parameter information.

S204, selecting and recombining the first pairing rule and/or the second pairing rule and/or the third pairing rule included in the pairing rule to obtain a target pairing rule;

the shop management server can select and reconfigure the first pairing rule and/or the second pairing rule and/or the third pairing rule in the pairing rules according to the pairing rule information, so that the user can select the pairing rule to be executed according to the requirement.

The target pairing rule may be a first pairing rule, may be a second pairing rule, may be a third pairing rule, may be a first pairing rule and a second pairing rule, may be a third pairing rule and a first pairing rule, may be a second pairing rule and a second pairing rule, and may be a first pairing rule, a second pairing rule and a third pairing rule.

S205, determining the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule according to the rule priority of the first pairing rule and/or the second pairing rule and/or the third pairing rule.

The priority of the pairing rule determines the execution sequence of the pairing rule, for example: if the first pairing rule is larger than the second pairing rule, the first pairing rule is preferentially executed, the second pairing rule is executed only when the target inventory commodity SKU cannot be screened, if the second pairing rule is larger than the third pairing rule at the same time, the first pairing rule is preferentially executed, the second pairing rule is executed again when the target inventory commodity SKU cannot be screened, and finally the third pairing rule is executed if the target inventory commodity SKU cannot be screened.

S206, executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, and screening the multiple stock-keeping goods SKUs to obtain a target stock-keeping goods SKU corresponding to the on-line product SKU.

After a target inventory commodity SKU corresponding to the online product SKU is screened from the multiple inventory commodity SKUs, the association relationship between the online product SKU and the target inventory commodity SKU is established, that is, a user can find the corresponding target inventory commodity SKU according to the online product SKU in the commodity order and find the inventory commodity corresponding to the online product in the commodity order in the local warehouse according to the target inventory commodity SKU for delivery.

It can be seen that, in the embodiment of the present application, the store management server can obtain an online product SKU, multiple stock product SKUs, and pairing rule information, and determine parameter information corresponding to the pairing rule information, where the parameter information at least includes one of the following: the method comprises the steps of obtaining a pairing rule by adjusting parameters of preset pairing rules according to the parameter information, wherein the pairing rule comprises a first pairing rule, a second pairing rule and a third pairing rule, the first pairing rule corresponds to first parameter information, the second pairing rule corresponds to second parameter information, the third pairing rule corresponds to third parameter information, selecting the first pairing rule and/or the second pairing rule and/or the third pairing rule included in the pairing and reassembling rule to obtain a target pairing rule, determining the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule according to the rule priority of the first pairing rule and/or the second pairing rule and/or the third pairing rule, executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, and finally, selecting commodities from a plurality of commodities to obtain a target SKU inventory product corresponding to the SKU on-line. Therefore, the multiple SKU pairing rules can be executed according to the rule parameters set by the user and the priority of the rules, the pairing of the on-line product SKU and the stock product SKU is realized, and the user experience is favorably improved.

In one possible example, if the target pairing rule comprises the first pairing rule; in the aspect of executing the target pairing rule, the method may include the following steps: and comparing all the characters in the on-line product SKU and each stock keeping product SKU in the plurality of stock keeping product SKUs one by taking the first character in the on-line product SKU and each stock keeping product SKU in the plurality of stock keeping product SKUs as a comparison benchmark, and screening the stock keeping product SKUs which are the same as all the characters in the on-line product SKU from the plurality of stock keeping product SKUs as the target stock keeping product SKU.

Wherein, considering that the user sets the online product SKU and the stock commodity SKU to be identical for the convenience of management, the first pairing rule is to pair the stock commodities identical to all characters in the online product SKU.

In a specific implementation, the store management server compares each character from left to right one by one from a first character in each stock product SKU in an online product SKU and a plurality of stock product SKUs, if the existing characters are different, the comparison is stopped, and if the online product SKU is the same as all the characters in the stock product SKU compared with the online product SKU, the stock product SKU is used as a target stock product SKU.

Optionally, the first pairing rule in the store management server is that all characters in the online product SKU and each stock item SKU in the multiple stock item SKUs are compared one by one with a first character in the online product SKU as a comparison reference, the same number of characters is recorded, and the stock item SKU in the multiple stock item SKU, in which the number of characters is greater than a preset threshold value, is used as a target stock item SKU, where the preset threshold value may be set by a user or a store management server.

In this example, the store management server can execute the first pairing rule, compare each stock product SKU in the stock product SKUs with all characters in the online product SKU one by one, and screen out the target stock product SKU, which is beneficial to accurately determining the target stock product SKU.

In one possible example, if the target pairing rule includes the second pairing rule; in the aspect of executing the target pairing rule, the method may include: identifying a preset symbol in the online product SKU, and extracting at least one character behind the preset symbol in the online product SKU to obtain a first target field; and taking the first target field and the first character in each stock keeping product SKU in the stock keeping product SKUs as a comparison benchmark, comparing all the characters in the first target field and each stock keeping product SKU in the stock keeping product SKUs one by one, and screening the stock keeping product SKUs which are the same as all the characters in the first target field from the stock keeping product SKUs to serve as the target stock keeping product SKU.

Wherein the preset symbol may be a symbol of, "&", "#", "/", "-", etc.

The shop management server may identify the preset symbol in the online product SKU from a first character on the left side of all characters in the online product SKU, or identify the preset symbol in the online product SKU from a first character on the right side of all characters in the online product SKU.

Considering that the number of characters of an online product SKU is greater than that of stock product SKU, when the store management server generates the online product SKU, the characters indicating different information in the online product SKU and the stock product SKU are placed on the left side or the right side of the online product SKU, and the characters indicating different information in the online product SKU and other characters are separated by preset symbols, for example: the characters corresponding to the store information and other characters are separated by "&", that is, the left side of "&" is the character indicating the store information, the right side is the other characters or that is, the left side of "&" is the other characters, and the right side is the character indicating the store information.

In specific implementation, the shop management server identifies a preset symbol from a first character on the left or right in an on-line product SKU, after the preset symbol is found, at least one character is selected from the next character of the preset symbol, the at least one character forms a first target field, the first target field and the first character in each stock product SKU in the stock product SKUs are taken as a comparison benchmark, all characters in the first target field and each stock product SKU in the stock product SKUs are compared one by one, and stock product SKUs identical to all characters in the first target field are screened from the stock product SKUs to serve as the target stock product SKU.

In this example, the store management server provides a second targeted matching rule according to the difference between the on-line product SKU and the stock product SKU, and executes the second matching rule, which is favorable for improving the matching success rate.

In one possible example, if the target pairing rule comprises the third pairing rule; in the aspect of executing the target pairing rule, the method may further include: selecting M characters from the nth character in the SKU of the online product to obtain a second target field, wherein n is a positive integer smaller than M, and M is a positive integer smaller than M; and taking the second target field and the first character in each stock keeping product SKU in the stock keeping product SKUs as a comparison benchmark, comparing all the characters in the second target field and each stock keeping product SKU in the stock keeping product SKUs one by one, and screening the stock keeping product SKUs which are the same as all the characters in the second target field from the stock keeping product SKUs as the target stock keeping product SKU.

Wherein n + M < M, n is a positive integer less than M, and M is a positive integer less than M.

The system comprises a client device, a shop management server and a system management server, wherein the shop management server comprises an online product SKU generation rule, the client device can send online product SKU generation rule parameter information to the shop management server, and the shop management server can adjust the online product SKU generation rule according to the online product SKU generation rule parameter information.

Considering that the user does not set characters and other characters indicating different information in the on-line product SKU isolated by the preset symbols or the set positions of the preset symbols are disordered, at this time, after the store management server adjusts the on-line product SKU generation rule according to the on-line product SKU generation parameter information, the generated on-line product SKU cannot be screened to obtain the target stock product SKU by executing the second pairing rule. In order to deal with the situation, the store management server provides a third pairing rule, and can select characters which indicate the same information as the stock product SKUs from the online product SKUs to form a second target field, and compare the second target field with all the characters in each stock product SKU in the stock product SKUs to obtain the target stock product SKU in a screening mode.

If the nth character is the last character in the SKU, the shop management server sends a rule setting error prompt to a user corresponding to the user end equipment so as to prompt the user to adjust the parameter information.

In the specific implementation, the store management server selects m characters from the nth character in the on-line product SKU, the m characters form a second target field, the store management server compares the second target field with all characters in each stock product SKU one by taking the first character on the left side in each stock product SKU in the second target field and the stock product SKUs as a comparison standard, and selects the stock product SKU with the same characters as all characters in the second target field from the stock product SKUs as the target stock product SKU.

In this example, the store management server provides a third targeted pairing rule according to the difference between the online product SKU and the stock product SKU caused by the participation of the user in setting the online product generation rule, and executes the third pairing rule, which is favorable for improving the pairing success rate.

In one possible example, the priority of the first pairing rule is greater than the priority of the second pairing rule, which is greater than the priority of the third pairing rule; when the target pairing rule includes the first pairing rule, the second pairing rule, and the third pairing rule, in the aspect of executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, the method may further include the following steps: executing the first pairing rule, and if stock product SKUs with the same characters as all the on-line product SKUs are screened out from the stock product SKUs to serve as the target stock product SKU, terminating executing the target pairing rule; if the stock product SKU with the same characters as all the on-line product SKUs is not screened out from the stock product SKUs, the second pairing rule is executed; if stock product SKUs which are the same as all the characters in the first target field are screened out from the plurality of stock product SKUs to serve as the target stock product SKU, terminating execution of the target pairing rule; and if the stock product SKUs with the same characters as all the characters in the first target field are not screened out from the stock product SKUs, executing the third pairing rule.

In a specific implementation, the store management server compares each character from left to right one by one from a first character in an online product SKU and each stock product SKU in a plurality of stock product SKUs, if all characters in the online product SKU and the stock product SKU compared with the online product SKU are the same, taking the stock product SKU as a target stock product SKU, if the existing character comparison is different, identifying a predetermined symbol starting with the first character to the left or right in the line product SKU, after finding the predetermined symbol, selecting at least one character starting with the next character of the predetermined symbol, the at least one character forms a first target field, the first target field and a first character in each stock keeping item SKU in the stock keeping item SKUs are taken as comparison reference, all characters in the first target field and each stock keeping item SKU in the stock keeping item SKUs are compared one by one, if the stock keeping item SKU with the same characters as all the characters in the first target field can be screened out from the stock keeping item SKUs to be taken as the target stock keeping item SKU, terminating the execution of the target pairing rule, if the stock commodity SKU with the same characters as all the characters in the first target field cannot be screened from the stock commodity SKUs to serve as the target stock commodity SKU, selecting m characters from the nth character in the on-line product SKU, the m characters form a second target field, the store management server takes the second target field and the first left character in each stock product SKU in the stock product SKUs as a comparison standard, compares the second target field with all characters in each stock product SKU in the stock product SKUs one by one, and selects the stock product SKU which is the same as all characters in the second target field from the stock product SKUs as the target stock product SKU.

As can be seen, in this example, the store management server may execute the target pairing rule according to the priority of the pairing rule, which is beneficial to accurate pairing of an online product SKU and an inventory product SKU and is beneficial to improving user experience.

In one possible example, before executing the target pairing rule, the method may further include the following steps: acquiring an online product test SKU and an inventory commodity test SKU sent by the client equipment; testing the target pairing rule according to the on-line product test SKU and the inventory commodity test SKU to obtain a first test result; if the first test result indicates that the on-line product test SKU and the inventory commodity test SKU are successfully paired, sending a pairing success prompt to the client device; and if the first test result indicates that the pairing of the on-line product test SKU and the inventory commodity test SKU is unsuccessful, sending a rule parameter adjustment prompt to the client device, wherein the rule parameter adjustment prompt is used for prompting a user corresponding to the client device to adjust the parameter information.

As shown in fig. 1b, before executing the target pairing rule, the user may click to test and input the on-line product test SKU and the stock commodity test SKU to test whether the target pairing rule can realize the pairing between the on-line product test SKU and the stock commodity test SKU, so as to determine whether to adjust the parameters of the target pairing rule.

After receiving the rule parameter adjustment prompt, the user corresponding to the client device can adjust the parameter information to obtain target parameter information, and the target parameter information is sent to the shop management server.

In the concrete implementation, the client device sends an online product test SKU and an inventory commodity test SKU to the store management server, after the store management server receives the online product test SKU and the inventory commodity test SKU, a target matching rule is executed according to the online product test SKU and the inventory commodity test SKU, a first test result is obtained, if the first test result indicates that the online product test SKU and the inventory commodity test SKU are successfully matched, a successful matching prompt is sent to the client device, if the first test result indicates that the online product test SKU and the inventory commodity test SKU are unsuccessfully matched, a rule parameter adjustment prompt is sent to the client device, and user adjustment parameter information corresponding to the client device is prompted.

Therefore, in the example, the shop management server provides a target matching rule test for the user corresponding to the client, so that the user can find the defects of the target matching rule in time, the SKU matching efficiency is improved, and the user experience is improved.

In one possible example, the method may further include the steps of: storing historical parameter information in a parameter database in the store management server, wherein the store management server is further configured to send a plurality of parameter recommendation information to the client device, wherein the parameter recommendation information is used to determine the parameter information; the historical parameter information comprises a plurality of parameters; if the store management server is configured to resynchronize the merchandise information in the cross-border e-commerce platform server and/or the first test result indicates that the pairing of the online product test SKU and the stock merchandise test SKU is unsuccessful, the method may further include: acquiring a plurality of historical parameter information from the parameter database; according to a plurality of pieces of historical parameter information, the parameter recommendation information is adjusted to obtain a plurality of pieces of target parameter recommendation information; and when the client equipment sends the parameter information to the shop management server, sending the target parameter recommendation information to the client equipment.

In order to improve user experience, the shop management server may obtain commodity type information included in the commodity information, and recommend, according to the commodity type information, parameter recommendation information generated by other users having similar commodity types in a parameter database or the shop management server itself to the user corresponding to the client, so that the user can determine the parameter information or adjust the parameter information according to the parameter recommendation information.

The shop management server can adjust a plurality of parameter recommendation information according to the historical parameter information to obtain target parameter recommendation information more in line with the use of the user, and sends the target parameter recommendation information to the user corresponding to the client.

Therefore, the shop management server can recommend target parameter recommendation information suitable for the user to use for the user corresponding to the client, so that the user can conveniently determine the matching rule information and the parameter information, and the user experience can be improved.

In one possible example, the store management server comprises a default pairing rule and an alternative pairing rule, the store management server can obtain historical online product SKU and corresponding historical target inventory product SKU which are successfully paired historically from the online product SKU database and the inventory product SKU database, test the target pairing rule according to the historical online product SKU and the historical target inventory product SKU to obtain a second test result, if the second test result indicates that the historical online product SKU and the historical target inventory product SKU are successfully paired, the target pairing rule is set as the default pairing rule, and if the second test result indicates that the historical online product SKU and the historical target inventory product SKU are not successfully paired, the target pairing rule is set as the alternative pairing rule.

The shop management server can simultaneously store a plurality of target pairing rules, the target pairing rule for pairing the historical online product SKU successfully paired with the corresponding historical target inventory commodity SKU which is successfully paired at the same time is used as a default pairing rule, and the target pairing rule for pairing the historical online product SKU which is not successfully paired with the corresponding historical target inventory commodity SKU which is not successfully paired at the same time is used as a candidate pairing rule, so that the target pairing rule can be checked and selectively used by a user, and the user experience is improved.

In one possible example, fig. 2b is a schematic flowchart of another data pairing method based on SKU, provided by an embodiment of the present application, where as shown in the drawing, the priority of the first pairing rule is greater than the priority of the third pairing rule; when the target pairing rule includes the first pairing rule and the third pairing rule, in the aspect of executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, the method may further include the following steps:

s207, comparing all characters in the on-line product SKU and each stock product SKU in the stock product SKUs one by taking the first character in the on-line product SKU and each stock product SKU in the stock product SKUs as a comparison standard, and terminating executing the target pairing rule if stock product SKUs identical to all characters in the on-line product SKU are screened out from the stock product SKUs as the target stock product SKU;

s208, if stock product SKUs which are the same as all characters in the on-line product SKU are not screened out from the stock product SKUs to serve as the target stock product SKU, selecting m characters from the nth character in the on-line product SKU to obtain the second target;

s209, taking the second target field and the first character in each stock product SKU in the stock product SKUs as a comparison standard, comparing the second target field and all the characters in each stock product SKU in the stock product SKUs one by one, and screening the stock product SKUs which are the same as all the characters in the second target field from the stock product SKUs to serve as the target stock product SKU.

When the target pairing rule includes the first pairing rule and the third pairing rule, and does not include the second pairing rule, and the priority of the first pairing rule is greater than the priority of the third pairing rule, the step of executing the target pairing rule is to execute the steps S207 to S209 in sequence.

As can be seen, in this example, the store management server may execute the target pairing rule according to the priority of the pairing rule, which is beneficial to accurate pairing of an online product SKU and an inventory product SKU, and is beneficial to improving user experience.

Referring to fig. 3, fig. 3 is a schematic structural diagram of an electronic device, applied to a store management server of a cross-border e-commerce management system, where the cross-border e-commerce management system includes the store management server, a cross-border e-commerce platform server and a client device, the store management server is in communication connection with the cross-border e-commerce platform server, the client device is in communication connection with the store management server, the store management server is configured to obtain multiple stock product SKU and matching rule information sent by the client device and synchronize product information in the cross-border e-commerce platform server, and the product information is used by the store management server to generate an online product SKU, as shown in the figure, the electronic device includes a processor, a memory, a communication interface, and one or more programs, where the one or more programs are stored in the memory, and the one or more programs are configured to be executed by the processor according to the following steps:

and executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, and screening the multiple stock-keeping commodity SKUs to obtain a target stock-keeping commodity SKU corresponding to the on-line product SKU.

It can be seen that the electronic device described in the embodiment of the present application may obtain an online product SKU, multiple stock product SKUs, and pairing rule information, and determine parameter information corresponding to the pairing rule information, where the parameter information at least includes one of the following: the method comprises the steps of obtaining a matching rule by adjusting parameters of preset matching rules according to the parameter information, wherein the matching rule comprises a first matching rule, a second matching rule and a third matching rule, the first matching rule corresponds to first parameter information, the second matching rule corresponds to second parameter information, the third matching rule corresponds to third parameter information, selecting the first matching rule and/or the second matching rule and/or the third matching rule included in the matching and repeating matching rule to obtain a target matching rule, further determining the execution sequence of the first matching rule and/or the second matching rule and/or the third matching rule in the target matching rule according to the rule priority of the first matching rule and/or the second matching rule and/or the third matching rule, and finally executing the target matching rule according to the execution sequence of the first matching rule and/or the second matching rule and/or the third matching rule in the target matching rule to obtain the inventory of corresponding SKU products from a plurality of selected commodities. Therefore, the plurality of SKU pairing rules can be executed according to the rule parameters and the priority of the rules set by the user, the pairing of the on-line product SKU and the stock commodity SKU is realized, and the improvement of the user experience is facilitated.

In one possible example, if the target pairing rule comprises the first pairing rule; in the aspect of executing the target pairing rule, the program includes instructions for:

and comparing all the characters in the on-line product SKU and each stock keeping product SKU in the stock keeping product SKUs one by taking the first character in the on-line product SKU and each stock keeping product SKU in the stock keeping product SKUs as a comparison standard, and screening the stock keeping product SKU with the same characters as all the characters in the on-line product SKU from the stock keeping product SKUs as the target stock keeping product SKU.

In one possible example, if the target pairing rule includes the second pairing rule; in the aspect of executing the target pairing rule, the program includes instructions for:

identifying a preset symbol in the on-line product SKU, and extracting at least one character behind the preset symbol in the on-line product SKU to obtain a first target field;

and comparing the first target field with the first character in each stock product SKU in the stock product SKUs one by taking the first target field and the first character in each stock product SKU in the stock product SKUs as a comparison standard, and screening the stock product SKUs which are the same as all the characters in the first target field from the stock product SKUs as the target stock product SKU.

In one possible example, if the target pairing rule comprises the third pairing rule; in the above program for executing the target pairing rule, the program includes instructions for:

selecting M characters from the nth character in the SKU of the online product to obtain a second target field, wherein n is a positive integer smaller than M, and M is a positive integer smaller than M;

and taking the second target field and the first character in each stock keeping product SKU in the stock keeping product SKUs as a comparison benchmark, comparing all the characters in the second target field and each stock keeping product SKU in the stock keeping product SKUs one by one, and screening the stock keeping product SKUs which are the same as all the characters in the second target field from the stock keeping product SKUs as the target stock keeping product SKU.

In one possible example, the priority of the first pairing rule is greater than the priority of the second pairing rule, which is greater than the priority of the third pairing rule; when the target pairing rule includes the first pairing rule, the second pairing rule, and the third pairing rule, in the aspect of executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule, and/or the third pairing rule in the target pairing rule, the foregoing procedure includes instructions for executing the following steps:

executing the first pairing rule, and if stock product SKUs with the same characters as all the on-line product SKUs are screened out from the stock product SKUs to serve as the target stock product SKU, stopping executing the target pairing rule;

executing the second pairing rule if an inventory item SKU with the same characters as all the online product SKUs is not screened from the plurality of inventory item SKUs as the target inventory item SKU;

if stock product SKUs which are the same as all the characters in the first target field are screened out from the plurality of stock product SKUs to serve as the target stock product SKU, terminating execution of the target pairing rule;

and if the stock product SKUs with the same characters as all the characters in the first target field are not screened out from the stock product SKUs, executing the third pairing rule.

In one possible example, prior to executing the target pairing rule, the program further includes instructions for performing the steps of:

acquiring an online product test SKU and an inventory commodity test SKU sent by the client equipment;

testing the target pairing rule according to the on-line product test SKU and the inventory commodity test SKU to obtain a first test result;

if the first test result indicates that the on-line product test SKU and the inventory commodity test SKU are successfully paired, sending a pairing success prompt to the client device;

and if the first test result indicates that the pairing of the on-line product test SKU and the inventory commodity test SKU is unsuccessful, sending a rule parameter adjustment prompt to the client device, wherein the rule parameter adjustment prompt is used for prompting a user corresponding to the client device to adjust the parameter information.

In one possible example, the program further includes instructions for performing the steps of:

storing historical parameter information in a parameter database in the store management server, wherein the store management server is further configured to send a plurality of parameter recommendation information to the client device, wherein the parameter recommendation information is used to determine the parameter information;

the historical parameter information comprises a plurality of pieces; if the store management server is configured to resynchronize the merchandise information in the cross-border e-commerce platform server, and/or the first test result indicates that the pairing of the online product test SKU and the stock merchandise test SKU is unsuccessful, the method further comprises:

acquiring a plurality of historical parameter information from the parameter database;

according to the plurality of pieces of historical parameter information, adjusting the plurality of pieces of parameter recommendation information to obtain a plurality of pieces of target parameter recommendation information;

when the client device transmits the parameter information to the shop management server, the target parameter recommendation information is transmitted to the client device.

The above description has introduced the solution of the embodiment of the present application mainly from the perspective of the method-side implementation process. It is understood that the electronic device comprises corresponding hardware structures and/or software modules for performing the respective functions in order to realize the functions. Those of skill in the art will readily appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments provided herein may be implemented as hardware or combinations of hardware and computer software. Whether a function is performed as hardware or computer software drives hardware depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.

In the embodiment of the present application, the electronic device may be divided into the functional units according to the method example, for example, each functional unit may be divided corresponding to each function, or two or more functions may be integrated into one processing unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit. It should be noted that the division of the unit in the embodiment of the present application is schematic, and is only a logic function division, and there may be another division manner in actual implementation.

In the case of dividing each functional module by corresponding functions, fig. 4a is a schematic diagram of a stock-keeping-unit-SKU-based data pairing apparatus, as shown in fig. 4a, applied to a store management server of a cross-border e-commerce management system, the cross-border e-commerce management system including the store management server, a cross-border e-commerce platform server and a client device, the store management server being in communication connection with the cross-border e-commerce platform server, the client device being in communication connection with the store management server, the store management server being configured to acquire a plurality of stock product SKUs and pairing rule information sent by the client device and synchronize product information in the cross-border e-commerce platform server, the product information being used for the store management server to generate an online product SKU, and the stock-keeping-unit-SKU-based data pairing apparatus 400 may include: acquisition unit 401, determination unit 402, adjustment unit 403, reassembly unit 404, and filtering unit 405, wherein,

the obtaining unit 401 is configured to obtain the online product SKU, the plurality of stock product SKUs, and the pairing rule information, where the online product SKU includes M characters, M is a positive integer greater than 1, each stock product SKU includes N characters, and N is a positive integer greater than 1;

the determining unit 402 is configured to determine parameter information corresponding to the pairing rule information, where the parameter information at least includes one of: first parameter information, second parameter information, and third parameter information;

the adjusting unit 403 is configured to perform parameter adjustment on a preset pairing rule according to the parameter information to obtain a pairing rule, where the pairing rule includes a first pairing rule, a second pairing rule, and a third pairing rule, the first pairing rule corresponds to the first parameter information, the second pairing rule corresponds to the second parameter information, and the third pairing rule corresponds to the third parameter information;

the recombining unit 404 is configured to select and recombine the first pairing rule and/or the second pairing rule and/or the third pairing rule included in the pairing rule to obtain a target pairing rule;

the determining unit 402 is further configured to determine, according to a rule priority of the first pairing rule and/or the second pairing rule and/or the third pairing rule, an execution order of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule;

the screening unit 405 is configured to execute the target pairing rule according to an execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, and screen the multiple stock-keeping good SKUs to obtain a target stock-keeping good SKU corresponding to the online product SKU.

It can be seen that the data pairing device based on stock keeping unit SKU described in the embodiment of the present application can acquire an online product SKU, a plurality of stock keeping product SKUs, and pairing rule information, and determine parameter information corresponding to the pairing rule information, where the parameter information at least includes one of the following: the method comprises the steps of obtaining a pairing rule by adjusting parameters of preset pairing rules according to the parameter information, wherein the pairing rule comprises a first pairing rule, a second pairing rule and a third pairing rule, the first pairing rule corresponds to first parameter information, the second pairing rule corresponds to second parameter information, the third pairing rule corresponds to third parameter information, selecting the first pairing rule and/or the second pairing rule and/or the third pairing rule included in the pairing and reassembling rule to obtain a target pairing rule, determining the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule according to the rule priority of the first pairing rule and/or the second pairing rule and/or the third pairing rule, executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, and finally, selecting commodities from a plurality of commodities to obtain a target SKU inventory product corresponding to the SKU on-line. Therefore, the multiple SKU pairing rules can be executed according to the rule parameters set by the user and the priority of the rules, the pairing of the on-line product SKU and the stock product SKU is realized, and the user experience is favorably improved.

In one possible example, if the target pairing rule comprises the first pairing rule; in the aspect of executing the target pairing rule, the screening unit 405 is specifically configured to:

and comparing all the characters in the on-line product SKU and each stock keeping product SKU in the plurality of stock keeping product SKUs one by taking the first character in the on-line product SKU and each stock keeping product SKU in the plurality of stock keeping product SKUs as a comparison benchmark, and screening the stock keeping product SKUs which are the same as all the characters in the on-line product SKU from the plurality of stock keeping product SKUs as the target stock keeping product SKU.

In one possible example, if the target pairing rule comprises the second pairing rule; in terms of the executing the target pairing rule, the screening unit 405 is specifically configured to:

In one possible example, if the target pairing rule comprises the third pairing rule; in the aspect of executing the target pairing rule, the screening unit 405 is specifically configured to:

selecting M characters from the nth character in the SKU to obtain a second target field, wherein n is a positive integer smaller than M, and M is a positive integer smaller than M;

In one possible example, the priority of the first pairing rule is greater than the priority of the second pairing rule, which is greater than the priority of the third pairing rule; when the target pairing rule includes the first pairing rule, the second pairing rule, and the third pairing rule, in terms of executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule, and/or the third pairing rule in the target pairing rule, the screening unit 405 is specifically configured to:

executing the first pairing rule, and if stock product SKUs with the same characters as all the on-line product SKUs are screened out from the stock product SKUs to serve as the target stock product SKU, terminating executing the target pairing rule;

if the stock product SKU with the same characters as all the on-line product SKUs is not screened out from the stock product SKUs, the second pairing rule is executed;

and if the stock product SKU with the same characters as all the characters in the first target field is not screened out from the plurality of stock product SKUs as the target stock product SKU, executing the third pairing rule.

In one possible example, as shown in fig. 4b, the stock keeping unit SKU-based data pairing apparatus 400 further comprises a testing unit 406 and a sending unit 407, wherein before the target pairing rule is executed, the testing unit 406 is specifically configured to:

and if the first test result indicates that the on-line product test SKU and the inventory commodity test SKU are not successfully paired, sending a rule parameter adjustment prompt to the client device, wherein the rule parameter adjustment prompt is used for reminding a user corresponding to the client device to adjust the parameter information.

In one possible example, the sending unit 407 is specifically configured to:

the historical parameter information comprises a plurality of pieces; if the store management server is configured to resynchronize the commodity information in the cross-border e-commerce platform server and/or the first test result indicates that the pairing of the online product test SKU and the stock commodity test SKU is unsuccessful, the method further comprises:

It should be noted that all relevant contents of each step related to the method embodiment may be referred to the functional description of the corresponding functional module, and are not described herein again.

The electronic device provided by the embodiment is used for executing the data pairing method based on the stock keeping unit SKU, so that the same effect as the implementation method can be achieved.

Embodiments of the present application also provide a computer storage medium, where the computer storage medium stores a computer program for electronic data exchange, the computer program enabling a computer to execute part or all of the steps of any one of the methods described in the above method embodiments, and the computer includes an electronic device.

Embodiments of the present application also provide a computer program product comprising a non-transitory computer readable storage medium storing a computer program operable to cause a computer to perform some or all of the steps of any of the methods as described in the above method embodiments. The computer program product may be a software installation package, the computer comprising the control platform.

It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present application is not limited by the order of acts described, as some steps may occur in other orders or concurrently depending on the application. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required in this application.

In the foregoing embodiments, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.

In the embodiments provided in the present application, it should be understood that the disclosed apparatus may be implemented in other manners. For example, the above-described embodiments of the apparatus are merely illustrative, and for example, the above-described division of the units is only one type of division of logical functions, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of some interfaces, devices or units, and may be an electric or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one position, or may be distributed on multiple network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit may be implemented in the form of hardware, or may also be implemented in the form of a software functional unit.

The integrated unit may be stored in a computer readable memory if it is implemented in the form of a software functional unit and sold or used as a stand-alone product. Based on such understanding, the technical solution of the present application may be substantially implemented or a part of or all or part of the technical solution contributing to the prior art may be embodied in the form of a software product stored in a memory, and including several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the above-mentioned method of the embodiments of the present application. And the aforementioned memory comprises: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk, and various media capable of storing program codes.

Those skilled in the art will appreciate that all or part of the steps in the methods of the above embodiments may be implemented by associated hardware instructed by a program, which may be stored in a computer-readable memory, which may include: flash memory disks, read-only memory, random access memory, magnetic or optical disks, and the like.

The foregoing detailed description of the embodiments of the present application has been presented to illustrate the principles and implementations of the present application, and the above description of the embodiments is only provided to help understand the method and the core concept of the present application; meanwhile, for a person skilled in the art, according to the idea of the present application, the specific implementation manner and the application scope may be changed, and in summary, the content of the present specification should not be construed as a limitation to the present application.

Claims

1. A data pairing method based on Stock Keeping Units (SKUs) is applied to a shop management server of a cross-border e-commerce management system, the cross-border e-commerce management system comprises the shop management server, a cross-border e-commerce platform server and a client device, the shop management server is in communication connection with the cross-border e-commerce platform server, the client device is in communication connection with the shop management server, the cross-border e-commerce platform comprises n sites, each site corresponds to at least one shop, the shop management server is used for acquiring a plurality of stock SKUs and pairing rule information sent by the client device and synchronizing commodity information corresponding to the at least one shop in the cross-border e-commerce platform server, and the commodity information is used for the shop management server to generate online products, and the method comprises the following steps:

executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, and screening the multiple stock-keeping commodity SKUs to obtain a target stock-keeping commodity SKU corresponding to the on-line product SKU, wherein the priority of the first pairing rule is greater than that of the second pairing rule, and the priority of the second pairing rule is greater than that of the third pairing rule; when the target pairing rule includes the first pairing rule, the second pairing rule, and the third pairing rule, the executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule includes: executing the first pairing rule, and if stock product SKUs with the same characters as all the on-line product SKUs are screened out from the stock product SKUs to serve as the target stock product SKU, terminating executing the target pairing rule; executing the second pairing rule if an inventory item SKU with all characters in the online product SKU is not screened from the plurality of inventory item SKUs as the target inventory item SKU, wherein executing the second pairing rule comprises: identifying a preset symbol in the on-line product SKU, and extracting at least one character behind the preset symbol in the on-line product SKU to obtain a first target field; taking the first target field and a first character in each stock product SKU in the stock product SKUs as a comparison benchmark, comparing all characters in the first target field and each stock product SKU in the stock product SKUs one by one, and screening the stock product SKUs which are the same as all characters in the first target field from the stock product SKUs as the target stock product SKU; if stock product SKUs which are the same as all the characters in the first target field are screened out from the plurality of stock product SKUs to serve as the target stock product SKU, terminating execution of the target pairing rule; if the stock keeping good SKU with the same characters as all the characters in the first target field is not screened out from the stock keeping good SKUs as the target stock keeping good SKU, executing the third pairing rule, wherein the executing the third pairing rule comprises: selecting M characters from the nth character in the SKU to obtain a second target field, wherein n is a positive integer smaller than M, and M is a positive integer smaller than M; taking the second target field and a first character in each stock product SKU in the stock product SKUs as a comparison benchmark, comparing all characters in the second target field and each stock product SKU in the stock product SKUs one by one, and screening the stock product SKUs which are the same as all characters in the second target field from the stock product SKUs as the target stock product SKU;

the method further comprises the following steps:

acquiring a historical online product SKU successfully paired in history and a corresponding historical target inventory commodity SKU; testing the target pairing rule according to the historical online product SKU and the historical target inventory product SKU to obtain a second test result, wherein the second test result is used for indicating whether the historical online product SKU and the historical target inventory product SKU are successfully paired when the target pairing rule is executed by the historical online product SKU and the historical target inventory product SKU; if the second test result indicates that the historical online product and the historical target inventory product SKU are successfully paired, taking the target pairing rule as a default pairing rule; and if the second test result indicates that the pairing of the historical online product and the historical target inventory commodity SKU is unsuccessful, taking the target pairing rule as a candidate pairing rule.

2. The method of claim 1, wherein if the target pairing rule comprises the first pairing rule; the executing the target pairing rule includes:

3. The method of claim 1, wherein prior to executing the target pairing rule, the method further comprises:

4. The method of claim 3, further comprising:

the historical parameter information comprises a plurality of parameters; if the store management server is configured to resynchronize the merchandise information in the cross-border e-commerce platform server, and/or the first test result indicates that the pairing of the online product test SKU and the stock merchandise test SKU is unsuccessful, the method further comprises:

obtaining a plurality of historical parameter information from the parameter database;

according to a plurality of pieces of historical parameter information, the parameter recommendation information is adjusted to obtain a plurality of pieces of target parameter recommendation information;

5. A data pairing device based on Stock Keeping Unit (SKU) is applied to a shop management server of a cross-border E-commerce management system, wherein the cross-border E-commerce management system comprises the shop management server, a cross-border E-commerce platform server and a client device, the shop management server is in communication connection with the cross-border E-commerce platform server, the client device is in communication connection with the shop management server, the shop management server is used for acquiring a plurality of stock product SKUs and pairing rule information sent by the client device and synchronizing product information in the cross-border E-commerce platform server, and the product information is used for the shop management server to generate an online product SKU, and the data pairing device comprises: an acquisition unit, a determination unit, an adjustment unit, a reorganization unit and a screening unit, wherein,

the obtaining unit is configured to obtain the online product SKU, the plurality of stock product SKUs, and the pairing rule information, where the online product SKU includes M characters, M is a positive integer greater than 1, each stock product SKU includes N characters, and N is a positive integer greater than 1;

the determining unit is configured to determine parameter information corresponding to the pairing rule information, where the parameter information at least includes one of: first parameter information, second parameter information, and third parameter information;

the screening unit is configured to execute the target pairing rule according to an execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule, and screen the multiple stock commodity SKUs to obtain a target stock commodity SKU corresponding to the online product SKU, where a priority of the first pairing rule is greater than a priority of the second pairing rule, and a priority of the second pairing rule is greater than a priority of the third pairing rule; when the target pairing rule includes the first pairing rule, the second pairing rule, and the third pairing rule, the executing the target pairing rule according to the execution sequence of the first pairing rule and/or the second pairing rule and/or the third pairing rule in the target pairing rule includes: executing the first pairing rule, and if stock product SKUs with the same characters as all the on-line product SKUs are screened out from the stock product SKUs to serve as the target stock product SKU, stopping executing the target pairing rule; executing the second pairing rule if an inventory item SKU with all characters in the online product SKU is not screened from the plurality of inventory item SKUs as the target inventory item SKU, wherein executing the second pairing rule comprises: identifying a preset symbol in the on-line product SKU, and extracting at least one character behind the preset symbol in the on-line product SKU to obtain a first target field; comparing the first target field with a first character in each stock product SKU in the stock product SKUs one by taking the first target field and the first character in each stock product SKU in the stock product SKUs as a comparison reference, and screening the stock product SKUs which are the same as all the characters in the first target field from the stock product SKUs as the target stock product SKU; if stock product SKUs which are the same as all the characters in the first target field are screened out from the plurality of stock product SKUs to serve as the target stock product SKU, terminating execution of the target pairing rule; executing the third pairing rule if the stock product SKU with the same characters as all the characters in the first target field is not screened out from the plurality of stock product SKUs as the target stock product SKU, wherein the executing the third pairing rule comprises: selecting M characters from the nth character in the SKU of the online product to obtain a second target field, wherein n is a positive integer smaller than M, and M is a positive integer smaller than M; taking the second target field and a first character in each stock product SKU in the stock product SKUs as a comparison benchmark, comparing all characters in the second target field and each stock product SKU in the stock product SKUs one by one, and screening the stock product SKUs which are the same as all characters in the second target field from the stock product SKUs as the target stock product SKU;

the acquisition unit is further used for acquiring historical online product SKUs successfully paired in history and corresponding historical target inventory commodity SKUs; testing the target pairing rule according to the historical online product SKU and the historical target inventory product SKU to obtain a second test result, wherein the second test result is used for indicating whether the historical online product SKU and the historical target inventory product SKU are successfully paired when the target pairing rule is executed by the historical online product SKU and the historical target inventory product SKU; if the second test result indicates that the historical online products and the historical target inventory commodity SKU are successfully paired, taking the target pairing rule as a default pairing rule; and if the second test result indicates that the historical online product and the historical target inventory product SKU are not successfully paired, taking the target pairing rule as a candidate pairing rule.

6. An electronic device comprising a processor, a memory, a communication interface, and one or more programs stored in the memory and configured to be executed by the processor, the programs comprising instructions for performing the steps in the method of any of claims 1-4.

7. A computer-readable storage medium, characterized in that a computer program for electronic data exchange is stored, wherein the computer program causes a computer to perform the method according to any of the claims 1-4.