CN115456739B - Data management method and related device - Google Patents

Data management method and related device Download PDF

Info

Publication number
CN115456739B
CN115456739B CN202211408766.4A CN202211408766A CN115456739B CN 115456739 B CN115456739 B CN 115456739B CN 202211408766 A CN202211408766 A CN 202211408766A CN 115456739 B CN115456739 B CN 115456739B
Authority
CN
China
Prior art keywords
target
warehousing
border
cross
batch
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202211408766.4A
Other languages
Chinese (zh)
Other versions
CN115456739A (en
Inventor
胡海金
王志超
林海平
徐鹏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Meiyunji Network Technology Co ltd
Original Assignee
Shenzhen Meiyunji Network Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shenzhen Meiyunji Network Technology Co ltd filed Critical Shenzhen Meiyunji Network Technology Co ltd
Priority to CN202211408766.4A priority Critical patent/CN115456739B/en
Publication of CN115456739A publication Critical patent/CN115456739A/en
Application granted granted Critical
Publication of CN115456739B publication Critical patent/CN115456739B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/083Shipping
    • G06Q10/0831Overseas transactions
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Marketing (AREA)
  • Development Economics (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The application provides a data management method and a related device, wherein the method comprises the following steps: the cross-border e-commerce management server acquires ex-warehouse information of a target product from the cross-border e-commerce platform server; inquiring a target warehousing queue according to the target inventory product category number, and determining a target warehousing batch number corresponding to the target inventory product category number; inquiring a pre-stored cost information set according to the target warehousing batch number to acquire cost information of a target product corresponding to the ex-warehouse information; and sending cost information of the target product corresponding to the ex-warehouse information to the electronic equipment logging in the target management account. The method and the device are beneficial to improving the efficiency of cross-border e-commerce data management.

Description

Data management method and related device
Technical Field
The present application belongs to the technical field of data management, and in particular, to a data management method and a related apparatus.
Background
At present, with the development of cross-border e-commerce industry, operators of cross-border e-commerce are gradually increased, and in the operation process of the cross-border e-commerce, the operators usually need to manage cost information of sold products, but a part of cost information is usually lost in a financial statement output by a current cross-border e-commerce platform, if the operators need to check the cost information of operated shops, actual cost information of each sold product needs to be checked manually, and the efficiency of data management is low.
Disclosure of Invention
The application provides a data management method and a related device, aiming at improving the efficiency of cross-border e-commerce data management.
In a first aspect, the present application provides a data management method, applied to a cross-border e-commerce management server in a cross-border e-commerce management system, where the cross-border e-commerce management system includes the cross-border e-commerce management server and a cross-border e-commerce platform server, and the cross-border e-commerce management server is in communication connection with the cross-border e-commerce platform server, and the method includes:
obtaining outbound information of a target product from the cross-border e-commerce platform server, wherein the outbound information comprises a target stock product type number and a target shop number, the target stock product type number is a product type number of the target product in a distribution generation warehouse managed by the cross-border e-commerce platform server, and the target shop number is used for indicating a target shop selling the target product in the cross-border e-commerce platform;
inquiring a target warehousing queue according to the target inventory product category number, and determining a target warehousing batch number corresponding to the target inventory product category number, wherein the target warehousing queue is a warehousing queue corresponding to the target store number in a plurality of pre-stored warehousing queues, the target warehousing queue is generated according to warehousing information of at least one batch of products of the target store from the cross-border e-commerce platform server, and the warehousing information of each batch of products comprises: the warehousing batch number of each batch of products is generated by the cross-border e-commerce platform server when each batch of products is warehoused in the generation warehouse;
inquiring a pre-stored cost information set according to the target warehousing batch number to acquire cost information of the target product corresponding to the ex-warehouse information, wherein the cost information set comprises a corresponding relation between the warehousing batch number and the product cost information;
sending cost information of the target product corresponding to the ex-warehouse information to electronic equipment for logging in a target management account, wherein the target management account is associated with one or more cross-border e-commerce platform accounts in the cross-border e-commerce platform server, the one or more cross-border e-commerce platform accounts comprise a target platform account, the target platform account is associated with one or more shops, and the one or more shops comprise the target shop.
In a second aspect, the present application provides a data management apparatus for a cross-border e-commerce management server in a cross-border e-commerce management system, where the cross-border e-commerce management system includes the cross-border e-commerce management server and a cross-border e-commerce platform server, and the cross-border e-commerce management server is communicatively connected to the cross-border e-commerce platform server, the apparatus includes:
a first obtaining unit, configured to obtain ex-warehouse information of a target product from the cross-border e-commerce platform server, where the ex-warehouse information includes a target stock product category number and a target shop number, the target stock product category number is a product category number of the target product in a distribution warehouse managed by the cross-border e-commerce platform server, and the target shop number is used to indicate a target shop selling the target product in the cross-border e-commerce platform;
a determining unit, configured to query a target warehousing queue according to the target inventory product category number, and determine a target warehousing batch number corresponding to the target inventory product category number, where the target warehousing queue is a warehousing queue corresponding to the target store number in a plurality of pre-stored warehousing queues, the target warehousing queue is generated according to warehousing information of at least one batch of products of the target store from the cross-border e-commerce platform server, and the warehousing information of each batch of products includes: the warehousing batch number of each batch of products is generated by the cross-border e-commerce platform server when each batch of products is warehoused in the generation warehouse;
the second acquisition unit is used for inquiring a pre-stored cost information set according to the target warehousing batch number and acquiring the cost information of the target product corresponding to the ex-warehouse information, wherein the cost information set comprises the corresponding relation between the warehousing batch number and the product cost information;
a sending unit, configured to send cost information of the target product corresponding to the outbound information to an electronic device that logs in a target management account, where the target management account is associated with one or more cross-border e-commerce platform accounts in the cross-border e-commerce platform server, the one or more cross-border e-commerce platform accounts include a target platform account, the target platform account is associated with one or more shops, and the one or more shops include the target shop.
In a third aspect, the present application provides a server, comprising:
one or more processors;
one or more memories for storing programs,
the one or more memories and the program are configured to control, by the one or more processors, the server to perform the instructions of the steps in any of the methods of the first aspect of the embodiments of the present application.
In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program for electronic data exchange, and wherein the computer program causes a computer to perform some or all of the steps as described in any one of the methods of the first aspect of the embodiments of the present application.
In a fifth aspect, the present application provides a computer program, wherein the computer program is operable to cause a computer to perform some or all of the steps as described in any one of the methods of the first aspect of the embodiments of the present application. The computer program may be a software installation package.
It can be seen that, in the embodiment of the application, the cross-border e-commerce management server can automatically query the target warehousing queue corresponding to the target product selling shop prestored in the local terminal according to the target product ex-warehouse information fed back by the cross-border e-commerce platform, so as to obtain the target warehousing batch number corresponding to the target inventory product category number in the target product ex-warehouse information, and can automatically query the prestored cost information set according to the target warehousing batch number, so as to determine the cost information of the target product corresponding to the ex-warehouse information, and push the cost information to the electronic device managing the target management account of the cross-border e-commerce platform account corresponding to the target shop. Through the interaction of the cross-border e-commerce management server and the cross-border e-commerce platform server, tedious checking work is not needed to be carried out manually, the cross-border e-commerce management server can automatically determine cost information corresponding to products sold in the cross-border e-commerce platform server, and the efficiency of cross-border e-commerce data management is improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a schematic architecture diagram of a cross-border e-commerce management system provided in an embodiment of the present application;
fig. 2 is a schematic structural diagram of a server according to an embodiment of the present disclosure;
fig. 3 is a flowchart of a data management method according to an embodiment of the present application;
FIG. 4 is a schematic diagram of a cost information display interface provided by an embodiment of the present application;
fig. 5 is a block diagram illustrating functional units of a data management device according to an embodiment of the present application
Fig. 6 is a block diagram of functional units of another data management apparatus according to an 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 above-described drawings are used for distinguishing between different objects and not for describing a particular order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. 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 listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus.
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.
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 can be combined with other embodiments.
In order to better explain the embodiments of the present application, some terms related to the embodiments of the present application are explained below.
ASIN (Amazon Standard Identification Number) is a unique Number automatically generated by a cross-border e-commerce platform server for the testing (product detail display interface) of each product, which is equivalent to the identity card of the product.
The MSKU is a number of an online product (namely, a stage from shelving to the beginning of selling of the cross-border e-commerce platform), and refers to a number which needs to be customized by a seller when the seller puts in a commodity and shelves the cross-border e-commerce platform for selling.
Correspondence between ASIN and MSKU: typically, one ASIN corresponds to one MSKU. That is, on the cross-border e-commerce platform, only one online product is searched by the ASIN. However, a follow-selling phenomenon exists in part of cross-border e-commerce platforms, namely, in the listing, the situation that other shops or the shop of the company sell online products exists, at the moment, the MSKU of different online products are different, and therefore, the situation that one ASIN corresponds to a plurality of MSKU exists.
Referring to fig. 1, fig. 1 is a schematic diagram illustrating an architecture of a cross-border e-commerce management system according to an embodiment of the present disclosure. The cross-border e-commerce management system 10 may specifically include a cross-border e-commerce management server 100 and a cross-border e-commerce platform server 200, the cross-border e-commerce management server 100 and the cross-border e-commerce platform server 200 are communicatively connected, and in addition, the cross-border e-commerce management server 100 and the cross-border e-commerce platform server 200 may also be communicatively connected to one or more electronic devices 300.
The cross-border e-commerce management server 100 may obtain store data, order data, and the like in the cross-border e-commerce platform by accessing an interface of the cross-border e-commerce platform server 200, and the cross-border e-commerce management server 100 may process the obtained data from the cross-border e-commerce platform server 200, thereby outputting a visual interface to be displayed at a client of a user.
In a specific implementation, a user may register and/or log in a cross-border e-commerce management account through the electronic device 300 (specifically, the user may register and/or log in through a webpage, a client, or an applet, which is not specifically limited herein), so as to communicate with the cross-border e-commerce management server 100 through the electronic device 300 to request a service, where after logging in the cross-border e-commerce management account, the user may authorize the cross-border e-commerce management account to manage one or more cross-border e-commerce platform accounts in an associated manner, where each cross-border e-commerce platform account may also correspondingly manage one or more shops in the cross-border e-commerce platform.
Specifically, the stores in the cross-border e-commerce platform can be divided according to the dimension of the sites, each site can be a country, meanwhile, a plurality of districts can be divided according to geographic positions, each district comprises a plurality of sites in the same geographic position area, for convenience of management, the stores under one cross-border e-commerce platform account can be set to belong to the same district, and each country in the district is a site and corresponds to one store. After the user authorizes the cross-border e-commerce management account to be associated with a certain cross-border e-commerce platform account, the cross-border e-commerce management account may be authorized by default to be associated with each shop corresponding to the cross-border e-commerce platform account, or the authorization state of the shop may be managed and adjusted independently according to needs, which is not limited specifically here.
In specific implementation, the cross-border e-commerce platform can also provide generation services, namely a seller user sends a product to a generation warehouse of the cross-border e-commerce platform in advance, and when an order is generated in a shop in the cross-border e-commerce platform, the cross-border e-commerce platform can provide related services such as product delivery and the like; therefore, the cross-border e-commerce platform server 200 can also manage warehousing and ex-warehouse information of products in the generation warehouse, and the cross-border e-commerce management server 100 can also acquire warehousing and ex-warehouse information of the products in the generation warehouse through related interfaces of the cross-border e-commerce platform server 200. Specifically, when warehousing the product into the warehouse, the cross-border e-commerce platform server 200 may generate warehousing information for each batch of warehoused products, where the warehousing information for each batch of products may include, for example: the cross-border e-commerce platform server 200 generates a warehousing batch number for the batch of products, the cross-border e-commerce platform server 200 generates a stock product category number for the batch of products, and the warehousing quantity of the batch of products. Accordingly, when a product is ex-warehouse from a delivery warehouse, the cross-border e-commerce platform server 200 may also record ex-warehouse information of the product, including, for example: the shop number of the shop selling the product in the cross-border e-commerce platform and the stock product category number corresponding to the product.
Further, the cross-border e-commerce management server 100 may obtain product warehousing information corresponding to each store from the cross-border e-commerce platform server 200 (periodically or triggered by a user operation instruction, which is not specifically limited herein), and generate a warehousing queue corresponding to each store according to the warehousing information of each batch of products corresponding to each store, so as to facilitate subsequent data query. In addition, the cross-border e-commerce management server can also respond to a cost entry instruction of a user containing the warehousing batch number information, and associate the cost information entered by the user with the warehousing batch number in the cost entry instruction to generate and store a cost information set so as to facilitate subsequent data query.
On this basis, in the embodiment of the present application, the cross-border e-commerce management server 100 may obtain the ex-warehouse information of the target product from the cross-border e-commerce platform server 200 (including the target inventory product category number of the target product in the generation warehouse and the target store number of the store selling the target product in the cross-border e-commerce platform), so as to query the target warehousing queue corresponding to the target store number according to the target inventory product category number, determine the target warehousing batch number corresponding to the target inventory product category number, and further query the cost information set according to the target warehousing batch number, thereby obtaining the cost information of the target product corresponding to the ex-warehouse information, and further send the cost information to the target management account number authorized to manage the target store. Specifically, the data sent by the cross-border e-commerce management server 100 may be visual interface data including the cost information, for example, after the cross-border e-commerce management server 100 sends the cost information, the electronic device 300 logging in the target management account may display a cost information display interface of a target product corresponding to the ex-warehouse information, and the information presented in the cost information display interface may include: the selling data of the target product on the cross-border e-commerce platform (such as a target shop number for selling the target product, a sales order number and a sales quantity corresponding to the sales order), the ex-warehouse time of the target product and a target inventory product category number of the target product are provided for the user to view. It should be noted that, the information that can be presented in the cost information presentation interface is only an exemplary illustration, and in practical applications, the information that can be presented in the cost information presentation interface may be more or less, and is not limited specifically here.
In addition, in a specific implementation, for a product that is warehoused in the delivery warehouse, the cross-border e-commerce platform server 200 may store the stock product type number corresponding to the product in association with the MSKU of the product, and when the online product is sold, the cross-border e-commerce platform server 200 may specifically determine the corresponding stock product type number according to the MSKU of the product, thereby generating corresponding product delivery information.
For example, the cross-border e-commerce platform in this embodiment may be an Amazon platform, and the delivery warehouse may be an Amazon logistics (FBA) warehouse, for example, although this is merely an exemplary illustration, and the cross-border e-commerce platform in practical applications is not limited to the Amazon platform, and the delivery warehouse is not limited to the FBA warehouse.
The server in the present application may be configured as shown in fig. 2, and may include a processor 110, a memory 120, a communication interface 130, and one or more programs 121, where the one or more programs 121 are stored in the memory 120 and configured to be executed by the processor 110, and the one or more programs 121 include instructions for executing any step of the above method embodiments. Wherein the communication interface 130 is used to support the server to communicate with other devices. In a specific implementation, the processor 110 is configured to perform any one of the steps performed by the electronic device in the method embodiments described below, and when performing data transmission such as sending, optionally invokes the communication interface 130 to complete the corresponding operation. It should be noted that the schematic structural diagram of the server is merely an example, and more or fewer components may be specifically included, which is not limited herein.
The embodiment of the present application provides a data management method, and the following describes the embodiment of the present application in detail.
Referring to fig. 3, fig. 3 is a flowchart of a data management method according to an embodiment of the present application. The data management method can be applied to a cross-border e-commerce management server 100 in a cross-border e-commerce management system 10 shown in fig. 1, wherein the cross-border e-commerce management system 10 comprises the cross-border e-commerce management server 100 and a cross-border e-commerce platform server 200, and the cross-border e-commerce management server 100 is in communication connection with the cross-border e-commerce platform server 200, as shown in fig. 3, the data management method comprises the following steps:
step 201, obtaining the ex-warehouse information of the target product from the cross-border e-commerce platform server.
The ex-warehouse information comprises a target stock product type number and a target shop number, the target stock product type number is the product type number of the target product in a distribution warehouse managed by the cross-border e-commerce platform server, and the target shop number is used for indicating a target shop selling the target product in the cross-border e-commerce platform.
In the specific implementation, the inventory product category numbers of the products are set for facilitating the distinguishing management of different categories of products in the product storage and delivery stage of the delivery service, and the MSKU of the online products is set for distinguishing different categories of products sold in the cross-border e-commerce platform, so that when the products are warehoused in the cross-border e-commerce platform server and the cross-border e-commerce platform server generates the product category numbers for the products, the association relationship between the product category numbers and the MSKU of the products needs to be established (the MSKU can be attached to the warehoused products through a label, and the MSKU of the products is determined by scanning the label on the products during warehousing), when the products are sold, the inventory product category numbers of the sold products are accurately obtained according to the MSKU of the sold products, and the products are accurately warehoused and the export information is generated.
Step 202, inquiring a target warehousing queue according to the target inventory product category number, and determining a target warehousing batch number corresponding to the target inventory product category number.
The target warehousing queue is a warehousing queue corresponding to the target store number in a plurality of pre-stored warehousing queues, the target warehousing queue is generated according to warehousing information of at least one batch of products of the target store from the cross-border e-commerce platform server, and the warehousing information of each batch of products comprises: the warehousing batch number of each batch of products is generated by the cross-border e-commerce platform server when each batch of products is warehoused in the generation warehouse.
Wherein, the numbers of the produced warehousing batches of any two different warehousing batches of products are different, namely, each warehousing batch of products is uniquely corresponding to the warehousing batch number thereof.
In a specific implementation, the cross-border e-commerce management server may be triggered or set by a user operation instruction to periodically acquire product warehousing information of the target store from the cross-border e-commerce platform server, and complete a target warehousing queue of the target store pre-stored in the current segment according to the acquired product warehousing information, for example, the product warehousing information of the target store acquired by the cross-border e-commerce management server from the cross-border e-commerce platform server may include: and the warehousing time of the warehousing information of the target shop is the time for acquiring the warehousing information of the target shop for the last time and the warehousing information within the current moment at the cross-border e-commerce management server.
For example, the cross-border e-commerce management server acquires warehousing information of the store a from the cross-border e-commerce platform server at 10 month and 1 day to complete a warehousing queue corresponding to the store a, if the time for acquiring the warehousing information of the store a last time by the cross-border e-commerce management server is 9 month and 10 days, the warehousing time of the warehousing information of the store a acquired by the cross-border e-commerce management server is 9 month and 10 days to 10 month and 1 day (avoiding missing of product warehousing information of a new warehousing generation warehouse after acquiring the warehousing information by 9 month and 10 days), and meanwhile, for repeated data which may be acquired, the repeated data in the warehousing queue is deleted, for example, data of the same warehousing batch number in 9 month and 10 days is acquired twice, and the deleted repeated data including the warehousing batch number is only retained by one.
In a specific implementation, the stock product category number and the warehousing lot number of each batch of products can be generated according to a specific strategy, for example, the warehousing lot number and the stock product category number can be respectively composed of a specific character and a variable one-bit or multi-bit number, for example, each stock product category number is composed of "FNSKU" plus a number, and each warehousing lot number is composed of "FBA" plus a number. Assuming that the target warehousing queue includes two warehousing information, warehousing information 1: FNSKU01, FBA001, warehousing information 2: and FNSKU02 and FBA002, wherein if the type number of the target inventory product in the ex-warehouse information is FNSKU02, the target warehousing queue is inquired, and then the number of the target warehousing batch can be determined to be FBA002. It should be noted that the above numbering manner of the stock product category number and the warehousing batch number is only an exemplary illustration, and the generation policy of each number in practical application is not limited thereto, and may be, for example, a pure number or a pure text number, and the like, which is not limited in this time.
Step 203, inquiring a pre-stored cost information set according to the target warehousing batch number, and acquiring the cost information of the target product corresponding to the ex-warehouse information.
And the cost information set comprises the corresponding relation between the warehousing batch number and the product cost information.
In specific implementation, a user can send a cost information input instruction carrying a warehousing batch number to the cross-border e-commerce management platform through the electronic equipment, the cross-border e-commerce management server responds to the cost information input instruction and receives cost information from the electronic equipment, and then the received cost information and the warehousing batch number carried in the cost information input instruction can be correlated, so that a cost information set is generated and stored.
The cost information of each batch of products may include, for example, the purchase cost of the batch of products and a head Cheng Yunfei (the stored value of the cost information may be, for example, the average purchase cost and the head distance freight rate of each product in the batch of products, or the total purchase cost and the total head distance freight rate of the batch of products, which is not specifically limited herein), where the head distance freight rate is the freight cost generated from the domestic shipment to the distribution warehouse of the cross-border e-commerce platform after purchasing the batch of products.
Step 204, sending cost information of the target product corresponding to the outbound information to an electronic device logging in a target management account, wherein the target management account is associated with one or more cross-border e-commerce platform accounts in the cross-border e-commerce platform server, the one or more cross-border e-commerce platform accounts comprise a target platform account, the target platform account is associated with one or more shops, and the one or more shops comprise the target shop.
In a specific implementation, the data sent by the cross-border e-commerce management server to the electronic device may be visual interface data including the cost information, for example, the visual interface data is cost information display interface data, the electronic device may present a cost information display interface after receiving the data, and the information presented in the cost information display interface may include: the sale data of the target product on the cross-border e-commerce platform (such as a target shop number for selling the target product, a sales order number and a sale quantity corresponding to the sales order), the ex-warehouse time of the target product and a target inventory product category number of the target product are provided for the user to view. It should be noted that, the information that can be presented in the cost information presentation interface is only an exemplary illustration, and in practical applications, the information that can be presented in the cost information presentation interface may be more or less, and is not limited specifically here.
It can be seen that, in the embodiment of the application, the cross-border e-commerce management server can automatically query the target warehousing queue corresponding to the target product selling shop prestored in the local terminal according to the target product ex-warehouse information fed back by the cross-border e-commerce platform, so as to obtain the target warehousing batch number corresponding to the target inventory product category number in the target product ex-warehouse information, and can automatically query the prestored cost information set according to the target warehousing batch number, so as to determine the cost information of the target product corresponding to the ex-warehouse information, and push the cost information to the electronic device managing the target management account of the cross-border e-commerce platform account corresponding to the target shop. Through the interaction of the cross-border e-commerce management server and the cross-border e-commerce platform server, the cross-border e-commerce management server can automatically determine the cost information corresponding to the sold product in the cross-border e-commerce platform server without performing complicated checking work manually, and the efficiency of cross-border e-commerce data management is improved.
In one possible example, the warehousing information of each batch of products further includes: the step of warehousing time, in which under the condition that the earlier warehousing time of the products in the target warehousing queue is ranked more backward, the target warehousing queue is queried according to the target warehousing product category number, and the target warehousing batch number corresponding to the target warehousing product category number is determined, includes: and traversing the target warehousing queue in a reverse order, and determining the first traversed warehousing batch number corresponding to the target inventory product class number as the target warehousing batch number.
In the specific implementation, the warehousing information in the target warehousing queue is sorted according to the warehousing time, and the warehousing data can be input based on a first-in first-out strategy.
In the specific implementation, the cross-border e-commerce management server can locally store the inventory allowance corresponding to each warehousing batch number in a related manner, the inventory allowance is used for indicating the remaining inventory of the batch products corresponding to each warehousing batch number in the generation warehouse, and after the cross-border e-commerce management server determines a certain warehousing batch number as a target warehousing batch number, namely after the cross-border e-commerce management server acquires the ex-warehouse information of the target product corresponding to the warehousing batch number, the cross-border e-commerce management server can adjust the remaining inventory of the warehousing batch according to the ex-warehouse information so as to ensure the accuracy of the remaining inventory. Meanwhile, when inquiring the cost information according to the ex-warehouse information of the target product, the cross-border e-commerce management server can screen and hide the product batch with the inventory allowance of 0 in the target store, namely, only the in-warehouse information of the product batch with the inventory allowance larger than 0 is included in the in-warehouse queue corresponding to each store when inquiring the cost information, so that the data processing efficiency is improved.
For example, still take the example that each inventory product category number is composed of "FNSKU" plus numbers, and each warehousing lot number is composed of "FBA" plus numbers, assuming the target warehousing queue is as follows:
FNSKU321, no. 20 warehouse, FBA0321;
……
FNSKU111, no. 10 warehousing, FBA0111;
FNSKU1, no. 1 warehouse entry, FBA0001;
the warehousing information of three batches of products is exemplarily shown in the target warehousing queue, and taking the warehousing information with the warehousing time of 20 as an example, the warehousing information represents that the warehousing time of the batch of products is 20, the stock product category number of the batch of products is FNSKU321, and the warehousing batch number is FBA0321. Assuming that the target inventory product type number in the ex-warehouse information is FNSKU111, the cross-border e-commerce management server traverses the target warehousing queue from FNSKU1, no. 1 warehousing, FBA0001 to FNSKU321, no. 20 warehousing, FBA0321, and when the FNSKU111, no. 10 warehousing and FBA0111 are traversed, the inventory product type number of the FNSKU111 appears for the first time, so that the FBA0111 can be determined as the target warehousing number batch. It should be noted that the generation strategy of the stock product category number, the warehousing batch number, and the specific representation form of the target warehousing queue are not limited to the example form in this example, and the user may arbitrarily set the generation strategy as needed, and is not specifically limited here.
As can be seen, in this example, under the condition that the product warehousing information with the earlier warehousing time in the target warehousing queue is ranked more backward, the cross-border e-commerce management server traverses the target warehousing queue in reverse order, determines the first traversed warehousing batch number corresponding to the target inventory product category number as the target warehousing batch number, and the data processing conforms to the first-in first-out strategy.
In one possible example, the warehouse-out information further includes a target warehouse-out quantity, and the determining, as the target warehouse-in batch number, the warehouse-in batch number corresponding to the target warehouse-in product category number that is traversed to first includes: when the target ex-warehouse quantity is equal to 1, determining the warehousing batch number corresponding to the target inventory product category number and traversed first as the target warehousing batch number; when the target ex-warehouse quantity is greater than 1, determining whether the inventory allowance corresponding to the warehousing batch number corresponding to the target inventory product category number traversed first is not less than the target ex-warehouse quantity; if so, determining the warehousing batch number corresponding to the target inventory product category number traversed by the first traversal as the target warehousing batch number; if not, the target warehousing queue is traversed in a reverse order continuously to determine at least one warehousing batch number corresponding to the target inventory product category number until the sum of the determined warehousing margins corresponding to a plurality of warehousing batch numbers corresponding to the target inventory product category number is not less than the target ex-warehouse quantity, and the warehousing batch numbers corresponding to the target inventory product category number are determined as the target warehousing batch number.
For example, still take the example that each inventory product category number is composed of "FNSKU" plus numbers, and each warehousing lot number is composed of "FBA" plus numbers, assuming the target warehousing queue is as follows:
FNSKU321, no. 20 warehouse, FBA0321;
……
FNSKU111, no. 12, binned, FBA0123;
……
FNSKU111, no. 10 warehousing, FBA0111;
FNSKU1, no. 1 warehouse entry, FBA0001;
assuming that the target stock product number is FNSKU111, number "FNSKU111, 10 warehousing, FBA0111" and "FNSKU111, 12 warehousing, no warehousing information with other stock product numbers being" FNSKU111 "exists between two pieces of warehousing information of FBA0123", the stock surplus corresponding to the warehouse batch number FBA0123 inquired at the current time is 30, and the stock surplus corresponding to the warehouse batch number FBA0111 is 10.
When the target ex-warehouse quantity is 1, determining that the warehousing batch number FBA0111 is the target warehousing batch number, and immediately updating the inventory allowance corresponding to the warehousing batch number FBA0111 to be 10-1=9; when the target ex-warehouse quantity is 12, because 12 is greater than the inventory margin 10 corresponding to the warehousing batch number FBA0111, the warehousing queue is continuously traversed in a reverse order, and the second warehousing batch number FBA0123 corresponding to the target inventory product number FNSKU111 is traversed, at this time, because the sum of the inventory margins 10+30=40 corresponding to the warehousing batch number FBA0123 and the warehousing batch number FBA0111 is greater than the target ex-warehouse quantity 12, the traversal is stopped, and the target warehousing batch number is determined to include two warehousing batch numbers: the warehousing batch number FBA0123 and the warehousing batch number FBA0111.
As can be seen, in this example, the target warehousing batch number is determined according to the target ex-warehouse quantity in the ex-warehouse information and the traversed warehousing allowance of the warehousing batch number matched with the target inventory product category number, which is beneficial to improving the accuracy of determining the target warehousing batch number.
In one possible example, in a case that the target warehousing batch number includes a plurality of numbers, the querying a pre-stored cost information set according to the target warehousing batch number to obtain the cost information of the target product corresponding to the ex-warehouse information includes: determining a plurality of target product cost information corresponding to a plurality of target warehousing batch numbers from the cost information set; determining the difference value between the sum of warehousing quantities corresponding to each target warehousing batch number and the target ex-warehouse quantity except for a reference warehousing batch number, wherein the reference warehousing batch number is the last traversed warehousing batch number in the target warehousing batch numbers; determining the ex-warehouse quantity corresponding to reference cost information in the target product cost information as the difference value, wherein the reference cost information is the target product cost information corresponding to the reference warehousing batch number; determining the ex-warehouse quantity corresponding to each target product cost information except the reference cost information in the plurality of target product cost information as: and inventory allowance corresponding to the target warehousing batch number corresponding to each target product cost information.
In the specific implementation, considering that one sales order in the cross-border e-commerce platform may include a plurality of products with the same stock product type, when the products with the same stock product type respectively correspond to a plurality of different target warehousing batch numbers, since the cost information of different warehousing batch numbers may be different, the ex-warehouse quantity respectively corresponding to each target warehousing batch number is respectively calculated, so that the accuracy of the determined cost information can be further improved,
for example, still taking the example that each inventory product category number is composed of "FNSKU" plus number, and each warehousing lot number is composed of "FBA" plus number, assume that the target warehousing queue is as follows:
FNSKU321, no. 20 warehouse, FBA0321;
……
FNSKU111, no. 12, binned, FBA0123;
……
FNSKU111, no. 10 warehousing, FBA0111;
FNSKU1, no. 1 warehouse entry, FBA0001;
assuming that the target stock product number is FNSKU111, number "FNSKU111, 10 warehousing, FBA0111" and "FNSKU111, 12 warehousing, no warehousing information with other stock product numbers being" FNSKU111 "exists between two pieces of warehousing information of FBA0123", the stock surplus corresponding to the warehouse batch number FBA0123 inquired at the current time is 30, and the stock surplus corresponding to the warehouse batch number FBA0111 is 10. The cost information corresponding to the warehousing batch number FBA0123 is cost data 1, and the cost information corresponding to the warehousing batch number FBA0111 is cost data 2.
When the target ex-warehouse quantity is 12, determining that the target warehousing batch number comprises two warehousing batch numbers: when the warehousing batch number FBA0123 and the warehousing batch number FBA0111 are determined, the cost data 1 is determined as the cost information corresponding to the reference warehousing batch number (i.e. the last traversed target warehousing batch number) FBA0123, then the reference cost information, that is, the ex-warehouse quantity corresponding to the data 1 is the difference 2 between the sum 10 of the inventory margins of each target warehousing batch number except the reference warehousing batch number FBA0123 and the target ex-warehouse quantity 12, the cost data 2 is used as the cost information of other target products except the reference cost information, and the corresponding ex-warehouse quantity is determined as the inventory margin 10 corresponding to the target warehousing batch number FBA0111 corresponding to the cost data 2. Meanwhile, the cross-border e-commerce management server can update the inventory allowance corresponding to each target warehousing batch number according to the ex-warehouse quantity corresponding to each target warehousing batch number, the inventory allowance corresponding to FBA0111 is 0 after updating, and the inventory allowance corresponding to FBA0123 is 30-2=28.
In a specific implementation, for a case that a same sales order of a cross-border e-commerce platform includes a plurality of different stock product category numbers in a same target store, that is, the same order includes a plurality of different target products in the same target store, the data management method described in the embodiment of the present application may be respectively executed for each category of target product, so that cost information of each category of target product is determined, and the cost information may be transmitted to an electronic device together for a user to view.
Referring to fig. 4, fig. 4 is an exemplary cost information display interface. The interface data including the cost information transmitted to the electronic device by the cross-border e-commerce management server will be described with reference to fig. 4.
The cost information display interface data can include various control information besides cost information, such as a large area selection control, a shop selection control, a time selection control, a type selection control and the like, other contents can be selected in each control in a pull-down mode through an inverted triangle pull-down box control, such as other large areas, shop screening, time setting (for example, time setting can be performed by inputting a starting date and an ending date in the time selection control), a selection type (taking the type of order delivery screening as an example in fig. 4) and the like, an MSKU number to be screened can be input in an input box control, and a data screening function according to the MSKU number can be realized through a magnifier control search. In addition, the cost information display interface data may further include, for example, "127 pieces" of similar display data presenting the total amount of screening data, and a sequential switching control (in fig. 4, the time column includes two triangular control groups) that can be switched to display the data in different time sequences in sequence. Specifically, the cost information corresponding to different orders in the cost information display interface may be displayed in rows, and the information displayed in each row includes time (i.e., ex-warehouse time) corresponding to the cost information (purchase cost + head Cheng Yunfei), a picture (which may be a product picture, for example), an MSKU number, an order number corresponding to the MSKU (e.g., an order number of a sales order in a cross-border electricity provider platform), a shop (shop/site where the order product is sold), a type (i.e., a shipping type), and a quantity.
As can be seen, in this example, in the case that the same target inventory product category number corresponds to a plurality of different target warehousing batch numbers in the same ex-warehouse information, the cross-border e-commerce management server determines, according to the inventory allowance and the target ex-warehouse quantity of each target warehousing batch number, the specific ex-warehouse quantity corresponding to the plurality of target cost information corresponding to the plurality of target warehousing batch numbers, which is respectively corresponding to the plurality of target warehousing batch numbers, so as to further improve the accuracy of cost information acquisition and ensure the reliability of data management.
In one possible example, before the querying a target warehousing queue according to the target inventory product category number, the method further comprises: inquiring a mapping relation list between the warehousing queue and the shop number; and determining a warehousing queue corresponding to the target shop number from the plurality of warehousing queues as the target warehousing queue.
As can be seen, in this example, for the case that a plurality of shops are correspondingly managed by one cross-border data management account, each shop is provided with an independent warehousing queue, and data of each shop can be managed respectively.
In one possible example, the determining, as the target warehousing queue, a warehousing queue corresponding to the target store number from a plurality of warehousing queues includes: determining a reference warehousing queue corresponding to the target shop number from a plurality of warehousing queues; if the reference warehousing queue comprises a plurality of warehousing sub-queues, inquiring a mapping relation list between the category number of the inventory products and the warehousing sub-queues; and determining the warehousing sub-queue corresponding to the target inventory product category number from the warehousing sub-queues to serve as the target warehousing queue.
In specific implementation, each target inventory product category number may be set to correspond to a separate warehousing sub-queue, or multiple target inventory product category numbers may be set to correspond to the same separate warehousing sub-queue. When the target warehousing queue is determined, if the target shop number only corresponds to one reference warehousing queue and the reference warehousing queue is not divided into a plurality of warehousing sub-queues, the single reference warehousing queue can be directly determined as the target warehousing queue, if one reference warehousing queue corresponding to the target shop number comprises a plurality of warehousing sub-queues, the warehousing sub-queue corresponding to the target inventory product category number can be further determined from the plurality of warehousing sub-queues as the target warehousing queue according to the mapping relation between the warehousing sub-queue and the inventory product category number.
Further, in practical application, the warehousing queue of the store is divided into a plurality of warehousing sub-queues according to the stock product category numbers under the condition that the total number of the stock product categories corresponding to the products in the same store is greater than the preset number, and the warehousing batch number of the products of each stock product category number in the preset time period is greater than the preset value. That is, for the situation that the same store sells a plurality of different types of products and the warehousing batch quantity of each product is large in a period of time, the data query time can be saved by dividing the product into a plurality of warehousing sub-queues, and for the stores with small product type total number or small warehousing batch quantity of store products, the response timeliness requirement of the data query can be met by corresponding one warehousing queue to one store.
In this example, each store includes a plurality of warehousing sub-queues divided according to the target product category, so that the data volume of each warehousing queue can be further reduced, and the data query efficiency can be improved.
In one possible example, the method further comprises: determining the number of warehousing batches corresponding to each inventory product category number laid by the target store within a preset time period; determining the inventory product category number corresponding to each delivery order laid by the target store in the preset time period; determining a candidate stock product category number from each stock product category number, wherein the warehousing batch number of the candidate stock product category number is greater than a first preset number, and the order number corresponding to the candidate stock product category number in each delivery order is less than a second preset number; determining that each candidate inventory product category number corresponds to a separate warehousing sub-queue respectively; and determining that the category numbers of other inventory products except the candidate inventory product category number all correspond to the same warehousing sub-queue.
In the specific implementation, the cross-border e-commerce management server can count the warehousing batch number and the sales frequency of different types of products in the same shop within a period of time (a period of time closest to the current time can be selected, or for products such as clothes and the like of which the sales conditions are influenced by seasons, the current month of the previous year can be selected), so that the products with more warehousing number and less ex-warehousing number are individually listed, and the data query of other types of products is prevented from being influenced by data accumulation.
The first preset quantity can be set as the average value of the quantity of warehousing batches of each stock product category number of the target store in a preset time period, and the second preset quantity can be set as the average value of the quantity of orders corresponding to each stock product category number of the target store in the preset time period.
As can be seen, in this example, according to the number of warehousing batches corresponding to each stock product category number of the target store within the preset time period and the stock product category number corresponding to the delivery order within the preset time period of the target store, the correspondence between the plurality of warehousing sub-queues of the target store and the stock product category number is determined, which is beneficial to improving the data query efficiency.
Referring to fig. 5, fig. 5 is a block diagram of functional units of a data management device according to an embodiment of the present application, where the data management device 30 may be applied to a cross-border e-commerce management server 100 in a cross-border e-commerce management system 10 shown in fig. 1, the cross-border e-commerce management system 10 includes the cross-border e-commerce management server 100 and a cross-border e-commerce platform server 200, the cross-border e-commerce management server 100 is communicatively connected to the cross-border e-commerce platform server 200, and the data management device 30 includes:
a first obtaining unit 301, configured to obtain ex-warehouse information of a target product from the cross-border e-commerce platform server, where the ex-warehouse information includes a target stock product category number and a target shop number, the target stock product category number is a product category number of the target product in a distribution agency managed by the cross-border e-commerce platform server, and the target shop number is used to indicate a target shop selling the target product in the cross-border e-commerce platform;
a determining unit 302, configured to query a target warehousing queue according to the target inventory product category number, and determine a target warehousing batch number corresponding to the target inventory product category number, where the target warehousing queue is a warehousing queue corresponding to the target store number in a plurality of pre-stored warehousing queues, the target warehousing queue is generated according to warehousing information of at least one batch of products of the target store from the cross-border e-commerce platform server, and warehousing information of each batch of products includes: the warehousing batch number of each batch of products is generated by the cross-border e-commerce platform server when each batch of products is warehoused in the generation warehouse;
a second obtaining unit 303, configured to query a pre-stored cost information set according to the target warehousing batch number, and obtain cost information of the target product corresponding to the ex-warehouse information, where the cost information set includes a correspondence between a warehousing batch number and product cost information;
a sending unit 304, configured to send cost information of the target product corresponding to the outbound information to an electronic device that logs in a target management account, where the target management account is associated with one or more cross-border e-commerce platform accounts in the cross-border e-commerce platform server, the one or more cross-border e-commerce platform accounts include a target platform account, the target platform account is associated with one or more shops, and the one or more shops include the target shop.
In one possible example, the warehousing information of each batch of products further includes: the warehousing time, in a case that the earlier warehousing time of the product in the target warehousing queue is later in the ranking, the determining unit 302 is specifically configured to: and traversing the target warehousing queue in a reverse order, and determining the first traversed warehousing batch number corresponding to the target inventory product class number as the target warehousing batch number.
In a possible example, the ex-warehouse information further includes a target ex-warehouse quantity, and in the aspect that the warehousing batch number corresponding to the target inventory product category number and traversed first is determined as the target warehousing batch number, the determining unit 302 is specifically configured to: when the target ex-warehouse quantity is equal to 1, determining the warehousing batch number corresponding to the target inventory product category number and traversed first as the target warehousing batch number; when the target ex-warehouse quantity is more than 1, determining whether the inventory allowance corresponding to the warehousing batch number corresponding to the target inventory product category number traversed first is not less than the target ex-warehouse quantity; if so, determining the warehousing batch number corresponding to the target inventory product category number traversed by the first step as the target warehousing batch number; if not, the target warehousing queue is traversed in a reverse order continuously to determine at least one warehousing batch number corresponding to the target inventory product type number until the sum of the determined warehousing margins corresponding to a plurality of warehousing batch numbers corresponding to the target inventory product type number is not less than the target ex-warehouse quantity, and the warehousing batch numbers corresponding to the target inventory product type number are determined as the target warehousing batch number.
In a possible example, when the target lot number includes a plurality of lot numbers, the second obtaining unit 303 is specifically configured to: determining a plurality of target product cost information corresponding to a plurality of target warehousing batch numbers from the cost information set; determining the difference value between the sum of warehousing quantities corresponding to each target warehousing batch number and the target ex-warehouse quantity except for a reference warehousing batch number, wherein the reference warehousing batch number is the last traversed warehousing batch number in the target warehousing batch numbers; determining the ex-warehouse quantity corresponding to reference cost information in the target product cost information as the difference value, wherein the reference cost information is the target product cost information corresponding to the reference warehousing batch number; determining the ex-warehouse quantity corresponding to each target product cost information except the reference cost information in the plurality of target product cost information as: and inventory allowance corresponding to the target warehousing batch number corresponding to each target product cost information.
In one possible example, the data management device 30 is further configured to: before the target warehousing queue is inquired according to the target inventory product category number, inquiring a mapping relation list of the warehousing queue and the shop number; and determining a warehousing queue corresponding to the target shop number from the plurality of warehousing queues as the target warehousing queue.
In one possible example, in the aspect that the warehousing queue corresponding to the target store number is determined from the plurality of warehousing queues as the target warehousing queue, the data management device 30 is specifically configured to: determining a reference warehousing queue corresponding to the target shop number from a plurality of warehousing queues; if the reference warehousing queue comprises a plurality of warehousing sub-queues, inquiring a mapping relation list between the category number of the inventory products and the warehousing sub-queues; and determining the warehousing sub-queue corresponding to the target inventory product category number from the warehousing sub-queues to serve as the target warehousing queue.
In one possible example, the data management device 30 is further configured to: determining the number of warehousing batches corresponding to each inventory product category number laid by the target store within a preset time period; determining the inventory product type number corresponding to each delivery order laid by the target store in the preset time period; determining a candidate stock product category number from each stock product category number, wherein the warehousing batch number of the candidate stock product category number is greater than a first preset number, and the order number corresponding to the candidate stock product category number in each delivery order is less than a second preset number; determining that each candidate inventory product category number corresponds to a separate warehousing sub-queue respectively; and determining that the category numbers of other inventory products except the candidate inventory product category number all correspond to the same warehousing sub-queue.
In the case of using an integrated unit, the functional units of another data management device provided in the embodiment of the present application constitute a block diagram, as shown in fig. 6. In fig. 6, the data management apparatus includes: a processing module 310 and a communication module 311. The processing module 310 is used for controlling and managing actions of the data management apparatus, for example, steps performed by the first obtaining unit 301, the determining unit 302, the second obtaining unit 303, the sending unit 304, and/or other processes for performing the techniques described herein. The communication module 311 is used to support interaction between the data management apparatus and other devices. As shown in fig. 6, the data management apparatus may further include a storage module 312, and the storage module 312 is used for storing program codes and data of the data management apparatus.
The Processing module 310 may be a Processor or a controller, and may be, for example, a Central Processing Unit (CPU), a general-purpose Processor, a Digital Signal Processor (DSP), an ASIC, an FPGA or other programmable logic device, a transistor logic device, a hardware component, or any combination thereof. Which may implement or perform the various illustrative logical blocks, modules, and circuits described in connection with the disclosure. The processor may also be a combination of computing functions, e.g., comprising one or more microprocessors, DSPs, and microprocessors, and the like. The communication module 311 may be a transceiver, an RF circuit or a communication interface, etc. The storage module 312 may be a memory.
All relevant contents of each scene related to the method embodiment may be referred to the functional description of the corresponding functional module, and are not described herein again. The data management device can perform the steps performed by the cross-border e-commerce management server in the data management method shown in fig. 3.
Embodiments of the present application also provide a computer storage medium, wherein the computer storage medium stores a computer program for electronic data exchange, the computer program enables 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 a server.
Embodiments of the present application also provide a computer program product, which includes a computer program operable to cause a computer to perform some or all of the steps of any one of the methods as set forth in the above method embodiments.
The computer program product may be a software installation package, the computer comprising a server.
It should be understood that, in the various embodiments of the present application, the sequence numbers of the above-mentioned processes do not mean the execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present application.
In the several embodiments provided in the present application, it should be understood that the disclosed method, apparatus and system may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative; for example, the division of the unit is only a logic function division, and there may be another division manner in actual implementation; for example, various elements or components may be combined or may be integrated into another system, or some features may be omitted, or not implemented. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical 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 place, or may be distributed on a plurality of 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 invention may be integrated into one processing unit, or each unit may be physically included alone, or two or more units may be integrated into one unit. The integrated unit can be realized in a form of hardware, or in a form of hardware plus a software functional unit.
The integrated unit implemented in the form of a software functional unit may be stored in a computer-readable storage medium. The software functional unit is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, an electronic device, or a network device) to execute some steps of the methods according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a portable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other media capable of storing program codes.
Although the present invention is disclosed above, the present invention is not limited thereto. Various changes and modifications can be easily made by those skilled in the art without departing from the spirit and scope of the present invention, and it is within the scope of the present invention to include different functions, combination of implementation steps, software and hardware implementations.

Claims (10)

1. A data management method is applied to a cross-border e-commerce management server in a cross-border e-commerce management system, wherein the cross-border e-commerce management system comprises the cross-border e-commerce management server and a cross-border e-commerce platform server, and the cross-border e-commerce management server is in communication connection with the cross-border e-commerce platform server, and the method comprises the following steps:
obtaining outbound information of a target product from the cross-border e-commerce platform server, wherein the outbound information comprises a target stock product type number and a target shop number, the target stock product type number is a product type number of the target product in a distribution generation warehouse managed by the cross-border e-commerce platform server, and the target shop number is used for indicating a target shop selling the target product in the cross-border e-commerce platform;
inquiring a target warehousing queue according to the target inventory product category number, and determining a target warehousing batch number corresponding to the target inventory product category number, wherein the target warehousing queue is a warehousing queue corresponding to the target store number in a plurality of pre-stored warehousing queues, the target warehousing queue is generated according to warehousing information of at least one batch of products of the target store from the cross-border e-commerce platform server, and the warehousing information of each batch of products comprises: the warehousing batch number of each batch of products is generated by the cross-border e-commerce platform server when each batch of products is warehoused in the generation warehouse;
inquiring a pre-stored cost information set according to the target warehousing batch number to acquire cost information of the target product corresponding to the ex-warehouse information, wherein the cost information set comprises a corresponding relation between the warehousing batch number and the product cost information;
sending cost information of the target product corresponding to the ex-warehouse information to electronic equipment logging in a target management account, wherein the target management account is associated with one or more cross-border e-commerce platform accounts in the cross-border e-commerce platform server, the one or more cross-border e-commerce platform accounts comprise a target platform account, the target platform account is associated with one or more shops, and the one or more shops comprise the target shop.
2. The method of claim 1, wherein the warehousing information of each batch of products further comprises: the step of determining the warehousing time, in which the target warehousing queue is queried according to the target warehousing product category number under the condition that the product warehousing information with the earlier warehousing time in the target warehousing queue is ranked more backward, and the target warehousing batch number corresponding to the target warehousing product category number is determined, includes:
and traversing the target warehousing queue in a reverse order, and determining the first traversed warehousing batch number corresponding to the target inventory product class number as the target warehousing batch number.
3. The method according to claim 2, wherein the ex-warehouse information further includes a target ex-warehouse quantity, and the determining the first traversed warehousing batch number corresponding to the target inventory product category number as the target warehousing batch number includes:
when the target ex-warehouse quantity is equal to 1, determining the warehousing batch number corresponding to the target inventory product category number and traversed first as the target warehousing batch number;
when the target ex-warehouse quantity is more than 1, determining whether the inventory allowance corresponding to the warehousing batch number corresponding to the target inventory product category number traversed first is not less than the target ex-warehouse quantity;
if so, determining the warehousing batch number corresponding to the target inventory product category number traversed by the first traversal as the target warehousing batch number;
if not, the target warehousing queue is traversed in a reverse order continuously to determine at least one warehousing batch number corresponding to the target inventory product category number until the sum of the determined warehousing margins corresponding to a plurality of warehousing batch numbers corresponding to the target inventory product category number is not less than the target ex-warehouse quantity, and the warehousing batch numbers corresponding to the target inventory product category number are determined as the target warehousing batch number.
4. The method according to claim 3, wherein, in case that the target warehousing batch number includes a plurality of numbers, the querying a pre-stored cost information set according to the target warehousing batch number to obtain the cost information of the target product corresponding to the ex-warehouse information comprises:
determining a plurality of target product cost information corresponding to a plurality of target warehousing batch numbers from the cost information set;
determining the difference value between the sum of warehousing quantities corresponding to each target warehousing batch number and the target ex-warehouse quantity except for a reference warehousing batch number, wherein the reference warehousing batch number is the last traversed warehousing batch number in the target warehousing batch numbers;
determining the ex-warehouse quantity corresponding to reference cost information in the target product cost information as the difference value, wherein the reference cost information is the target product cost information corresponding to the reference warehousing batch number;
determining the ex-warehouse quantity corresponding to each target product cost information except the reference cost information in the plurality of target product cost information as follows: and inventory allowance corresponding to the target warehousing batch number corresponding to each target product cost information.
5. The method according to any one of claims 1-4, wherein prior to said querying a target warehousing queue according to said target inventory product category number, said method further comprises:
inquiring a mapping relation list between the warehousing queue and the shop number;
and determining a warehousing queue corresponding to the target shop number from the plurality of warehousing queues as the target warehousing queue.
6. The method according to claim 5, wherein the determining, as the target warehousing queue, the warehousing queue corresponding to the target store number from the plurality of warehousing queues comprises:
determining a reference warehousing queue corresponding to the target shop number from a plurality of warehousing queues;
if the reference warehousing queue comprises a plurality of warehousing sub-queues, inquiring a mapping relation list between the category number of the inventory products and the warehousing sub-queues;
and determining the warehousing sub-queue corresponding to the target inventory product category number from the warehousing sub-queues to serve as the target warehousing queue.
7. The method of claim 6, further comprising:
determining the number of warehousing batches corresponding to each inventory product category number laid by the target store within a preset time period;
determining the inventory product category number corresponding to each delivery order laid by the target store in the preset time period;
determining a candidate stock product category number from each stock product category number, wherein the warehousing batch number of the candidate stock product category number is greater than a first preset number, and the order number corresponding to the candidate stock product category number in each delivery order is less than a second preset number;
determining that each candidate inventory product category number corresponds to a separate warehousing sub-queue respectively;
and determining that the category numbers of other inventory products except the candidate inventory product category number all correspond to the same warehousing sub-queue.
8. A data management device applied to a cross-border e-commerce management server in a cross-border e-commerce management system, wherein the cross-border e-commerce management system comprises the cross-border e-commerce management server and a cross-border e-commerce platform server, and the cross-border e-commerce management server is connected with the cross-border e-commerce platform server in a communication manner, and the device comprises:
a first obtaining unit, configured to obtain ex-warehouse information of a target product from the cross-border e-commerce platform server, where the ex-warehouse information includes a target stock product category number and a target shop number, the target stock product category number is a product category number of the target product in a distribution warehouse managed by the cross-border e-commerce platform server, and the target shop number is used to indicate a target shop selling the target product in the cross-border e-commerce platform;
a determining unit, configured to query a target warehousing queue according to the target inventory product category number, and determine a target warehousing batch number corresponding to the target inventory product category number, where the target warehousing queue is a warehousing queue corresponding to the target store number in a plurality of pre-stored warehousing queues, the target warehousing queue is generated according to warehousing information of at least one batch of products of the target store from the cross-border e-commerce platform server, and the warehousing information of each batch of products includes: the warehousing batch number of each batch of products is generated by the cross-border e-commerce platform server when each batch of products is warehoused in the generation warehouse;
the second acquisition unit is used for inquiring a pre-stored cost information set according to the target warehousing batch number and acquiring the cost information of the target product corresponding to the ex-warehouse information, wherein the cost information set comprises the corresponding relation between the warehousing batch number and the product cost information;
a sending unit, configured to send cost information of the target product corresponding to the outbound information to an electronic device that logs in a target management account, where the target management account is associated with one or more cross-border e-commerce platform accounts in the cross-border e-commerce platform server, the one or more cross-border e-commerce platform accounts include a target platform account, the target platform account is associated with one or more shops, and the one or more shops include the target shop.
9. A server, characterized in that the server comprises:
one or more processors;
one or more memories for storing programs,
the one or more memories and the program are configured to control the server, by the one or more processors, to perform the steps in the method of any of claims 1-7.
10. 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 one of claims 1-7.
CN202211408766.4A 2022-11-11 2022-11-11 Data management method and related device Active CN115456739B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211408766.4A CN115456739B (en) 2022-11-11 2022-11-11 Data management method and related device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211408766.4A CN115456739B (en) 2022-11-11 2022-11-11 Data management method and related device

Publications (2)

Publication Number Publication Date
CN115456739A CN115456739A (en) 2022-12-09
CN115456739B true CN115456739B (en) 2023-01-31

Family

ID=84295762

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211408766.4A Active CN115456739B (en) 2022-11-11 2022-11-11 Data management method and related device

Country Status (1)

Country Link
CN (1) CN115456739B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117495424B (en) * 2023-12-29 2024-06-04 深圳赛盒科技有限公司 FBA (film base station) head management method, system, equipment and storage medium

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2002087551A (en) * 2000-09-12 2002-03-27 Namitei Kk Rental warehouse system, article delivering method in electronic commerce using rental warehouse system, and method of managing rental warehouse
CN110807596A (en) * 2019-11-06 2020-02-18 广东卓志供应链科技有限公司 Cross-border e-commerce consignment warehouse storage management system and method
CN111784466A (en) * 2020-07-01 2020-10-16 刘万云 Cross-border e-commerce transaction system
CN112884394A (en) * 2020-03-19 2021-06-01 上海爱奇尔贸易有限公司 Head-trip freight flattening algorithm based on FBA order purchase, sale and storage and flattening system thereof
CN113762858A (en) * 2020-11-24 2021-12-07 北京沃东天骏信息技术有限公司 Inventory management method and device
WO2022183626A1 (en) * 2021-03-04 2022-09-09 深圳市爱云信息科技有限公司 Tms saas supply chain logistics information platform

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA3119943A1 (en) * 2019-03-14 2020-09-17 Attabotics Inc. Multi-entity inventory management using storage bin and inventory reassignment

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2002087551A (en) * 2000-09-12 2002-03-27 Namitei Kk Rental warehouse system, article delivering method in electronic commerce using rental warehouse system, and method of managing rental warehouse
CN110807596A (en) * 2019-11-06 2020-02-18 广东卓志供应链科技有限公司 Cross-border e-commerce consignment warehouse storage management system and method
CN112884394A (en) * 2020-03-19 2021-06-01 上海爱奇尔贸易有限公司 Head-trip freight flattening algorithm based on FBA order purchase, sale and storage and flattening system thereof
CN111784466A (en) * 2020-07-01 2020-10-16 刘万云 Cross-border e-commerce transaction system
CN113762858A (en) * 2020-11-24 2021-12-07 北京沃东天骏信息技术有限公司 Inventory management method and device
WO2022183626A1 (en) * 2021-03-04 2022-09-09 深圳市爱云信息科技有限公司 Tms saas supply chain logistics information platform

Also Published As

Publication number Publication date
CN115456739A (en) 2022-12-09

Similar Documents

Publication Publication Date Title
CN111612594A (en) Localized merchant retail system
CA2288142A1 (en) Network computer trading system
KR101322466B1 (en) Apparatus and method for processing a waybill
US20220092669A1 (en) Dynamic Cannabis Delivery Platform
US20050033664A1 (en) System and method for providing selective content in an electronic commerce environment
CN115456739B (en) Data management method and related device
CN106709785B (en) Display method and device
CN111798293A (en) Cloud storage order processing method and device, computer equipment and storage medium
CA2880014C (en) Transaction support system
CN111062660A (en) Online mall inventory quantity calculation method and device
CN117709326A (en) E-commerce commodity customs reporting method and system
CN116595390A (en) Commodity information processing method and electronic equipment
CN109559068B (en) Network transaction method, network transaction platform and storage equipment thereof
CN111831964B (en) Data report information processing method and device and computer system
KR20220006330A (en) System for Delivering Mobile Phone for Performing Simultaneously Purchasing and Marketing Online
KR20210000183A (en) Online shopping mall Server and Method for Running Online shopping mall
CN112288507A (en) Method and device for determining display information
CN115344791B (en) Batch cost query method based on cross-border e-commerce and related device
US20060255133A1 (en) Commodity managing apparatus to manage commodity, commodity managing method, and program for managing commodities
CN113435979B (en) Management method and system for online transaction
CN114092163B (en) Electronic shelf label price changing method and device, electronic equipment and storage medium
KR20000036568A (en) System and method for selling merchandise by using network
KR102595066B1 (en) Car resource information integrated management system
CN111833151B (en) Cloud ecological service method, cloud server, system, device and readable storage medium
CN114187074B (en) Order generation method, device, equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant