CN115330468A

CN115330468A - Data processing method and related device

Info

Publication number: CN115330468A
Application number: CN202211250278.5A
Authority: CN
Inventors: 王志超; 刘继超; 沈永权; 胡仪
Original assignee: Shenzhen Meiyunji Network Technology Co ltd
Current assignee: Shenzhen Meiyunji Network Technology Co ltd
Priority date: 2022-10-13
Filing date: 2022-10-13
Publication date: 2022-11-11
Anticipated expiration: 2042-10-13
Also published as: CN115330468B

Abstract

The embodiment of the application discloses a data processing method and a related device, wherein the method comprises the following steps: the local management server calculates a first profit report and an employee performance report of each shop in a target period according to a first exchange rate of the target period from target data acquired by the E-commerce platform server, and then independently stores the target data, the first profit report and the employee performance report; and receiving actual data sent by the E-commerce platform server on a settlement day, obtaining a second profit report corresponding to the actual data of the target period according to a second exchange rate of the settlement day, and determining corresponding processing measures according to the error data determined by the calculation result and the business profit difference. Therefore, the system can seal the account and reduce the influence caused by the difference between the target data and the actual data.

Description

Data processing method and related device

Technical Field

The present application relates to the field of data processing technology, which is specially adapted for administrative, business, financial, management, supervision, or forecasting purposes in the new generation of information technology industry, and in particular, to a data processing method and related apparatus.

Background

Cross-border e-commerce has become a bright spot and an important driving force for the growth of foreign trade in China, and a cross-border e-commerce platform mainly provides two types of data on the aspect of store operation: 1. statistical data, which is generally sales data in a certain time interval, can be obtained by a local management server; 2. detail data, namely data of each order, is generally provided by a cross-border e-commerce platform on a fixed settlement day and can be completely acquired in a long period. The local management server calculates the operation profit and the employee bonus according to the data in the target period and the current exchange rate. However, when the actual data provided by the cross-border e-commerce platform is acquired after a long period of time, the order data and exchange rate corresponding to the same period of time may fluctuate, and finally, the problem of inconsistency of calculating profit data of the same period of time at different times may occur.

Therefore, a data processing method is needed to solve the above problems.

Disclosure of Invention

The embodiment of the application provides a data processing method and a related device, and the target data, a first profit report and an employee performance report of each shop in a target period can be independently stored after the first profit report and the employee performance report of each shop in the target period are calculated according to a first exchange rate of the target period through target data acquired by a local management server from an e-commerce platform server; and receiving actual data sent by the E-commerce platform server on the settlement day, obtaining a second profit report corresponding to the actual data of the target period according to a second exchange rate of the settlement day, and determining corresponding processing measures according to the error data determined by the calculation result and the business profit difference. Therefore, the system can seal the account and reduce the influence caused by the difference between the target data and the actual data.

In a first aspect, an embodiment of the present application provides a data processing method, which is applied to an enterprise resource management system, where the enterprise resource management system includes a local management server, and the local management server is in communication connection with an e-commerce platform server, and the method includes:

acquiring target data of at least one shop in a target period from the e-commerce platform server, wherein the target data comprises site information and business data, and the site information is used for indicating the business country of each shop in the at least one shop;

determining first exchange rate information of the business country corresponding to each shop in the target period according to the site information;

according to the first exchange rate information and the business data, calculating the business profit and the staff performance of each shop in the target period, and respectively obtaining a first profit report and a staff performance report, wherein the first profit report comprises the business profit corresponding to each shop in at least one shop, and the staff performance report comprises the staff performance corresponding to each shop;

storing the target data, the first profit report and the employee performance report into a database of the local management server;

receiving actual data of the at least one store sent by the E-commerce platform server on a settlement day, wherein the actual data comprises actual data corresponding to each store in the at least one store in the target period;

determining second exchange rate information of the business country corresponding to each shop on the settlement day according to the site information;

calculating the actual operating profit of each shop in the target period according to the second exchange rate information and the actual data of the at least one shop laid in the target period to obtain a second profit report;

and determining the business profit difference of each shop according to the first profit report and the second profit report, and determining a difference processing scheme according to the business profit difference.

In a second aspect, an embodiment of the present application provides a data processing apparatus, which is applied to an enterprise resource management system, where the enterprise resource management system includes a local management server, and the local management server is in communication connection with an e-commerce platform server; the device comprises an acquisition unit, a determination unit, a calculation unit, a storage unit, a receiving unit and a processing unit:

the acquisition unit is used for acquiring target data of at least one shop in a target period from the E-commerce platform server, wherein the target data comprises site information which is used for indicating the business country of each shop in the at least one shop;

the determining unit is used for determining first exchange rate information of the business country of each shop in the target period according to the site information;

the calculation unit is used for calculating the operating profit and the employee performance of each shop in the target period according to the first exchange rate information and the operating data to respectively obtain a first profit report and an employee performance report, wherein the first profit report comprises the operating profit corresponding to each shop in at least one shop, and the employee performance report comprises the employee performance corresponding to each shop;

the storage unit is used for storing the target data, the business profit report and the employee performance report into a local database;

the receiving unit is used for receiving actual data of the at least one shop sent by the E-commerce platform server on a settlement day, wherein the actual data comprises actual data corresponding to the target period of the at least one shop;

the determining unit is further configured to determine second exchange rate information of the business country corresponding to each store on the settlement day according to the site information;

the calculating unit is further configured to calculate an actual operating profit of the target period according to the second exchange rate information and the actual data of the at least one shop laid in the target period, so as to obtain a second profit report;

and the processing unit is used for determining the operating profit difference of each shop according to the first profit report and the second profit report and determining a difference processing scheme according to the operating profit difference.

In a third aspect, an embodiment of the present application provides an electronic device, including a processor, a memory, a communication interface, and one or more programs, where the one or more programs are stored in the memory and configured to be executed by the processor, and the program includes instructions for executing steps in any method of the first aspect of the embodiment of the present application.

In a fourth aspect, the present application provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program for electronic data exchange, where the computer program makes a computer perform part or all of the steps described in any one of the methods of the first aspect of the present application.

In a fifth aspect, the present application provides a computer program product, wherein the computer program product includes a non-transitory computer-readable storage medium storing a computer program, and 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 product may be a software installation package.

In the embodiment of the application, the target data, the first profit report and the employee performance report of each shop in the target period are independently stored after the first profit report and the employee performance report of each shop in the target period are calculated according to the first exchange rate of the target period by the local management server according to the target data acquired from the e-commerce platform server; and receiving actual data sent by the E-commerce platform server on a settlement day, obtaining a second profit report corresponding to the actual data of the target period according to a second exchange rate of the settlement day, and determining corresponding processing measures according to the error data determined by the calculation result and the business profit difference. Therefore, the system can seal account and reduce the influence caused by the difference between the target data and the actual data.

Drawings

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

Fig. 1 is a schematic system architecture diagram of an enterprise resource management system according to an embodiment of the present application;

fig. 2 is a schematic flowchart of a data processing method according to an embodiment of the present application;

FIG. 3 is a schematic diagram of an interface for data acquisition according to an embodiment of the present disclosure;

fig. 4 is a schematic structural diagram of an electronic device provided in an embodiment of the present application;

fig. 5 is a schematic structural diagram of functional units of a data processing 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 foregoing drawings are used for distinguishing between different objects and not for describing a particular sequential order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover 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.

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

In order to better understand the solution of the embodiments of the present application, the following first describes the electronic devices, related terms, concepts and related backgrounds to which the embodiments of the present application may relate.

The electronic device may be a portable electronic device, such as a cell phone, a tablet computer, a wearable electronic device with wireless communication capabilities (e.g., a smart watch), etc., that also contains other functionality, such as personal digital assistant and/or music player functionality. Exemplary embodiments of the portable electronic device include, but are not limited to, portable electronic devices that carry an IOS system, an Android system, a Microsoft system, or other operating system. The portable electronic device may also be other portable electronic devices such as a Laptop computer (Laptop) or the like. It should also be understood that in other embodiments, the electronic device may not be a portable electronic device, but may be a desktop computer. The electronic device may include an electronic device for data processing in the embodiment of the present application.

Enterprise Resource Planning (ERP) system is a set of system facing enterprise process management, and in 1990, gao Dena consult companies (gartnergroupcinc) in the united states, originally defined as application software, is gradually accepted by the industry, and is now one of the modern enterprise management theories. The ERP system is a management platform which is established on the basis of information technology and provides decision operation means for enterprise decision layers and employees by using a systematized management idea. The main implementation object is an enterprise, and the purpose is to reasonably allocate resources (including factors such as sales, property, supply, property and production) in all aspects of the enterprise so as to make the resources fully exert the efficiency, and make the enterprise comprehensively exert energy in the intense market competition, thereby obtaining the best economic benefit. The ERP system is oriented to workflow, emphasizes the capability of controlling enterprise management in advance, and considers the operations in aspects of finance, manufacturing management, sales management, logistics management, inventory management, purchasing management, human resources and the like as a dynamic and pre-controllable organic whole. The ERP system fully carries out the management thought of a supply chain, and develops a set of management thought which can be manufactured completely according to the requirements of customers by combining the requirements of users, the manufacturing requirements in enterprises and the manufacturing resource construction of external suppliers.

ASIN (AmazonStandardIdentificationNumber) is a unique number automatically generated by Amazon for each commodity's liking, which is equivalent to the identification card of the commodity.

Referring to fig. 1, fig. 1 is a schematic diagram of a system architecture of an enterprise resource management system. The method specifically comprises the following steps: the system comprises a user side, a local management server and an e-commerce platform server; the local management server is in communication connection with the user side and the E-commerce platform server respectively. The user side is used for representing each operating shop side, the local management server is used for helping the user to finely manage various sales activities of the user on the cross-border e-commerce platform, usually, the user needs to acquire shop data, order data and the like from the cross-border e-commerce platform server through an interface, and after the shop data, the order data and the like are acquired and then are subjected to some operation or processing by the local management server, and a visual interface is output to the user side for display.

For a better understanding of the above system architecture, the present application is described in detail below with reference to specific embodiments.

Referring to fig. 2, fig. 2 is a schematic flowchart of a data processing method, which is applied to an enterprise resource management system according to an embodiment of the present application, where the enterprise resource management system includes a local management server, and the local management server is in communication connection with an e-commerce platform server, as shown in fig. 2, the data processing method specifically includes the following steps:

s201, obtaining target data of at least one shop in a target period from the E-commerce platform server.

Wherein the target data includes site information indicating a business country of each of the at least one store and business data.

Illustratively, the local management server responds to the control operation of a manager, and establishes a communication connection with the e-commerce platform server. The method includes the steps of obtaining target data of a target period from an e-commerce platform, wherein the target period can be in a unit of week, month or quarter, and can be specifically set according to actual requirements of management personnel, and is not specifically limited herein. Target data includes, but is not limited to: site information for each store, number of ASINs, sales, advertising sales, refunds, etc. Specifically, please refer to table 1 for one possible presentation form of the target data, and the included data items and their corresponding values:

TABLE 1

Shop mark	Site information	ASIN number	Sales amount	Amount of sales	Refund amount	Refund amount
							101	A	3	＄12，134	94	132	-1754.5
102	B	4	＄1，144	23	30	-439.08
							103	C	2	＄13，120	38	50	-582.78

The local management server as described in table 1 obtains one possible target data from the e-commerce platform server, where the store identifier is used to characterize each store, the site information is used to characterize the country of business to which each store faces, the ASIN number represents the product number, and the target data further includes the sales amount, refund amount, and the like corresponding to each product.

S202, determining first exchange rate information of the business country corresponding to each shop in the target period according to the site information.

Specifically, because the exchange rate change has real-time performance and regional performance, after the local management server obtains the target data of the target period, the local management server obtains the exchange rate information corresponding to the regions with different current times according to the business country faced by each shop, and obtains the first exchange rate information.

S203, according to the first exchange rate information and the business data, calculating the business profit and the staff performance of each shop in the target period, and respectively obtaining a first profit report and a staff performance report.

The first profit report comprises business profits corresponding to each shop in at least one shop, and the staff performance report comprises staff performance corresponding to each shop.

Specifically, the local management server calculates the operating profit corresponding to each store and the employee performance of the employee in the target period respectively according to the target data of each store in the target period in the acquired target data and the first exchange rate information determined in step S202.

And S204, storing the target data, the first profit report and the employee performance report into a database of the local management server.

Specifically, the local management server stores the acquired target data of the target period, and the first profit report and the employee performance report of the target period calculated in step S203 into the database of the local management server.

S205, receiving the actual data of the at least one shop sent by the E-commerce platform server on the settlement date.

The actual data comprises actual data corresponding to each shop in the at least one shop in the target period.

Illustratively, the local management server receives the actual data statistical report of each shop periodically transmitted by the e-commerce platform on a settlement day, wherein the settlement day is after the target period and contains the target period. In practical applications, the settlement day may be several weeks or several months after the target period, and is not particularly limited herein.

S206, determining second exchange rate information of the business country corresponding to each shop on the settlement day according to the site information.

Specifically, as described in step S202, the exchange rate varies depending on the region and time, and the local management server determines the second exchange rate of the business country to which each store faces the settlement day and the settlement day based on the site information, and obtains the second exchange rate information.

S207, calculating the actual operating profit of the target period according to the second exchange rate information and the actual data of the at least one shop laid in the target period to obtain a second profit report.

Specifically, the calculation of the process is the same as that described in step S203, and the local management server calculates the actual operating profit of each store in the target period according to the second exchange rate information and the actual data of each store to obtain a second profit report, where the second profit report includes each store and the actual operating profit corresponding to each store.

S208, determining the operating profit difference of each shop according to the first profit report and the second profit report, and determining a difference processing scheme according to the operating profit difference.

Specifically, the local management server obtains a first profit report calculated according to the target data from the database, and compares the second profit report with the first profit report to determine the operating profit difference of each shop in the target period. Wherein the calculated profit difference may be a positive value, i.e., the operating profit calculated on the settlement day based on the actual data and the second rate is higher than the operating profit calculated on the target data and the first rate; it may also be negative, i.e. the operating profit calculated on the basis of the actual data and the second rate on the settlement day is lower than the operating profit calculated on the basis of the objective data and the first rate.

Further, the local management server determines a difference processing scheme according to the calculated difference of operating profits. Since the first profit statement and employee performance statement calculated from the objective data will determine the current employee prize award and budget designation for each store at the next period. The difference in business profits will affect the statistics of each store to be abnormal, and therefore, the difference processing scheme needs to be determined according to the difference in business profits.

Specifically, the deficit processing scheme includes: and when the business profit difference value is a negative value, the processing scheme of how the current difference part makes up is adopted.

The local management server is used for acquiring target data from the e-commerce platform server, calculating a first profit report and an employee performance report of each shop in a target period according to a first exchange rate of the target period, and then independently storing the target data, the first profit report and the employee performance report; and receiving actual data sent by the E-commerce platform server on the settlement day, obtaining a second profit report corresponding to the actual data of the target period according to a second exchange rate of the settlement day, and determining corresponding processing measures according to the error data determined by the calculation result and the business profit difference. Therefore, the system can seal account and reduce the influence caused by the difference between the target data and the actual data.

In one possible example, the method for obtaining target data of at least one shop target period from the e-commerce platform server includes the following specific steps: responding to login operation of a manager, and establishing communication connection with the e-commerce platform server according to the login operation, wherein the login operation means that the manager realizes that the local management server establishes communication connection with the e-commerce platform server through a management account, and the management account is used for managing the at least one shop; responding to the setting operation of the administrator, and setting a first time node and a second time node according to the setting operation, wherein the first time node and the second time node are respectively used for representing the starting time and the ending time of the target period; in response to a selection operation of the administrator, selecting at least one data item of the target data according to the selection operation, wherein each data item of the at least one data item is used for characterizing a data category, and the data category comprises one or more of the following: the site information, store data, merchandise data, sales data, and cost data; acquiring a numerical value corresponding to each data item from the E-commerce platform server according to the at least one data item; and determining the target data according to each data item and the value corresponding to each data item.

Specifically, the local management server establishes a communication connection with the e-commerce platform server in response to a login operation of a manager. The method comprises the steps that one account of a manager can manage operation of at least one shop, and after login is successful through the account and a password corresponding to the account, relevant data of the managed at least one shop can be obtained from an e-commerce platform server through a local management server.

Specifically, after the local management server is successfully connected with the e-commerce platform server, the start-stop time of the target period is selected from the corresponding position of the e-commerce platform server in response to the setting operation of the manager.

Further, the local management server responds to the data item selection operation of the manager, wherein the selection operation is used for setting the data items contained in the target data which the manager desires to acquire and the data corresponding to each data item. Wherein the data items include, but are not limited to: site information of each store, store data, commodity data, sales data, cost data, and the like. And the local management server acquires target data corresponding to the selection operation from the E-commerce platform server according to the selection operation. Specifically, the contents of the target data may refer to those shown in table 1 above. It should be noted that the contents shown in table 1 are only a part of contents that the local management server can obtain from the e-commerce platform server, and in addition to the above contents, there may be other data related to store operation, and are not limited in detail here.

Specifically, as shown in fig. 3, fig. 3 is a schematic interface diagram for data acquisition according to an embodiment of the present application. After a manager logs in the system through an account, the top selection bar can be selected: commodity, sales, advertising, purchasing, data and finance, selecting a target entry, and performing data acquisition. In the scheme, a manager can acquire target data through a data column inlet. The method specifically comprises the following steps: selecting the starting and ending time of a target period through a time setting function box, and selecting a target country through a 'all countries' drop-down box after determining an order, a sales volume and a sales volume as data items, wherein the target country is represented through site information; a target store is selected via an "all stores" drop-down box, wherein the target store is characterized by a store identification.

Specifically, as shown in fig. 3, the target data obtained according to the selection operation may include data items: store identification, site information, number of ASINs, sales amount, refund amount, and refund amount. In practical application, the data items can be selectively added or deleted according to the requirements of management personnel to obtain target data.

As can be seen, in this example, after the local management server establishes a communication connection with the e-commerce platform server by responding to a login operation of a manager, the local management server obtains the required target data according to the selection operation, and the target data can be used for calculating the operating profit of the store and the performance of the staff. Therefore, the target data in the target period can be acquired more efficiently and accurately, and the efficiency of data interaction and data management is improved.

In one possible example, the store data includes identification information of the each store; the method for calculating the operating profit and the employee performance of each shop in the target period can comprise the following steps: acquiring the sales data and the cost data of each store from the target data according to the identification information, wherein the identification information is used for uniquely identifying each store, the sales data comprises sales volume information, price information and refund amount of each commodity in at least one commodity of each store, and the cost data comprises cost of each commodity and transportation expense cost; determining the operating profit of each store in the target period according to the first exchange rate information, the sales data and the cost data of each store; and determining the first profit report according to the operating profits of each shop in the target period.

Specifically, the local management server can establish communication connection with the e-commerce platform server through a respective account by each manager of at least one manager, and each account can manage a plurality of shops.

Specifically, the local management server obtains target data corresponding to each store from the target data through the identification information of each store. Wherein the target data includes, but is not limited to, sales data and cost data for each store. Sales data includes, but is not limited to: the commodity number, sales information, price information and refund information of each commodity in the at least one commodity; the refund information includes a refund amount and a refund amount. Cost information includes, but is not limited to: cost per goods information, transportation cost information, advertising cost information, and the like.

Further, the local management server calculates the corresponding operating profit according to the sales data and the cost data of each shop in the target period and the first exchange rate information of the current target period. That is, the total amount of cost and the total amount of refund corresponding to the cost data are subtracted from the total amount of sales corresponding to the sales data, and the operating profit of each shop in the target period is determined.

In this example, in the embodiment of the present application, the target data corresponding to each store is respectively obtained from the target data through the identification information of the store, and further, the operating profit obtained in the target period of each store is determined according to the target data corresponding to each store and the first exchange rate information.

In one possible example, the following steps may also be included: acquiring the sales amount information and the price information of each commodity of each store; respectively calculating the sales volume and the total sales volume of each commodity according to the sales volume information and the price information of each commodity; calculating first ratio information of the sales amount and the total sales amount of each commodity; calculating second proportion information between the refund amount and the sales amount of each commodity; determining the employee performance of the employees of each store in the target period according to the first specific gravity information and the second specific gravity information; and obtaining the staff performance report according to the staff performance.

Illustratively, each store corresponds to at least one employee for store operation, and each employee of the at least one employee has its corresponding employee number. The local management server can determine the commodities which are managed and sold by each employee according to the employee numbers, acquire sales information and price information corresponding to each commodity from the target data according to the number information of each commodity, calculate the sales of each commodity, and further determine the total sales of each shop in a target period according to the sales of each commodity.

Further, the percentage of the sales amount of each commodity in the total sales amount is calculated to obtain first ratio information, wherein the first ratio information is used for representing the percentage information of the sales amount of the commodity which is managed by each employee in the total sales amount.

For example, in the actual sale process, there may be a case where the goods are returned by the buyer after sale for various reasons. And the E-commerce platform server records the data of the refund of the commodity while recording the data of the sale of the commodity.

Specifically, the local management server acquires refund records and associated staff information of each commodity according to the commodity number, and second proportion information is obtained by calculating refund amount of each commodity and proportion of refund amount to total sales amount.

Further, the local management server can determine the performance of each employee according to the weight by setting the first proportion information and the second proportion information to influence the weight on the performance assessment of each employee, so as to obtain an employee performance report. Wherein the employee performance report includes performance information for each employee in each store. The first specific gravity information and the second specific gravity information may be set by a developer of the enterprise resource management system or may be set by each store manager, and are not particularly limited herein.

As can be seen, in this example, the employee performance of each employee is determined according to the weight by calculating the first proportion information of the sales amount and the total sales amount of each employee sales commodity and the second proportion information of the refund amount and the total sales amount, so that the employee performance report corresponding to each store can be obtained.

In one possible example, the enterprise resource management system further comprises a user terminal, wherein the user terminal is used for providing a visual interface of each store for business personnel of each store, and the user terminal is connected with the local management server; after the first profit report and the employee performance report are obtained respectively, the method can comprise the following steps: acquiring profit statements corresponding to adjacent periods of the target period from the database; determining the profit growth rate of each shop according to the first profit report and the profit reports of the adjacent periods; determining a budget statement and a financial resource allocation scheme of each shop in the next period according to the profit growth rate; and sending the first profit report, the budget report and the financial resource allocation scheme to the user terminal, wherein the budget report and the financial resource allocation scheme are used for providing reference basis for the user to set budget for the shop operation of the next period.

Illustratively, after the local management server acquires target data of a target period and calculates a first profit statement corresponding to each store in the target period according to the target data, the target data and the first profit statement are correspondingly stored in a storage module of the target period.

Further, the local management server obtains a profit report corresponding to the historical period adjacent to the target period, and determines the profit growth rate corresponding to each store according to the profit report corresponding to the historical period and the first profit report. And determining a budget statement and a financial resource allocation scheme of each shop in the next period according to the calculated profit growth rate. Wherein the history period may be one or more adjacent periods. The budget statement and the financial resource allocation scheme of the next period of each shop are determined according to the growth rate, which can be budget setting and allocation schemes corresponding to the growth rates of different intervals preset in the local management server, the interval corresponding to the calculated profit growth rate is determined according to the calculated profit growth rate, and then the budget statement and the financial resource allocation scheme of the next period are set according to the preset scheme corresponding to the interval.

Further, the local management server determines the corresponding user side according to the store identification and sends the budget report and the financial resource allocation scheme of each store to the corresponding user side. After receiving the report and the allocation scheme, the user terminal can use the report and the allocation scheme as reference data, set or modify the budget report and the financial resource allocation scheme, and upload the modified budget report and the financial resource allocation scheme to the local management server. Alternatively, the store may perform the next cycle of store operations directly according to the budget statement and the financial resource allocation plan.

As can be seen, in this example, the local management server determines the profit growth rate of each store according to the first profit statement and the profit statement of the historical period, and then sets the budget statement and the financial resource allocation plan of the next period for each store according to the profit growth rate. And sending the budget report and the financial resource allocation scheme to the user side, and selecting whether to carry out the shop operation of the next period according to the scheme or to set by the user side according to the budget report and the financial resource allocation scheme. Thus, effective utilization of data can be realized, and the experience of the user can be improved.

In one possible example, after determining the difference in operating profit for each store, the method may include the steps of: according to the identification information of each shop, acquiring the target data of each shop in the target period from the database; according to the target data and the actual data corresponding to each shop, calculating data similarity, and determining difference data and the data items corresponding to the difference data; after adding an abnormal tag to the difference data, associating the difference data and the abnormal tag to the corresponding data item, and deleting non-abnormal data, wherein the abnormal tag is used for identifying data in which the actual data is inconsistent with the target data, and the non-abnormal data is used for representing repeated data of the target data and the actual data corresponding to the target period.

Specifically, the local management server calculates the operating profit difference of each store according to the first profit report and the second profit report. The received actual data corresponding to at least one shop sent by the e-commerce platform server on the settlement date also needs to be stored in the database. However, the database stores target data corresponding to each store in a target period. Actual data received in a settlement day includes actual data corresponding to a target period, and a large amount of data of the actual data may be repeated data, and only a small amount of data has difference. In order to ensure the integrity of the target data and the actual data, the data storage can be realized by removing the repeated data and reserving the differential data.

Specifically, the local management server acquires target data corresponding to each store from the database through the identification information of each store.

Further, according to the start-stop time of the target period, actual data corresponding to the target period is obtained from the actual data. And respectively acquiring actual data of each shop according to the identification information of each shop.

Further, according to data items in the target data and the actual data, data similarity calculation is carried out, and the difference data and the data items corresponding to the difference data are determined. Wherein, the data item corresponding to the difference data comprises: the actual data and the target data comprise data items, but the values corresponding to the data items are different; and the actual data includes a data item in which the target data does not exist.

Further, the local management server adds an exception tag to the exception data, wherein the exception tag is used for identifying data with inconsistency between the actual data and the target data. Further, the abnormal data with the abnormal labels added in the actual data is associated to a database, and the data items corresponding to all shops. And deleting repeated data, wherein the repeated data refers to the condition that the data items and the corresponding numerical values of the target data and the actual data corresponding to each shop in the target period are the same, and deleting the repeated data from the actual data.

As can be seen, in this example, similarity calculation is performed on target data and actual data corresponding to each store in a target period, and data with actual data different from the target data is stored in a data item corresponding to the target period and identified by an abnormal tag; and meanwhile, deleting repeated data in the actual data. Therefore, the target data and the actual data can be completely stored, the repeated data is removed, the repeated storage of the data is avoided, and the storage space of the database is wasted.

In one possible example, the exception data includes at least one exception data, each exception data of the at least one exception data corresponds to one of the exception tags; the method of determining a difference processing scheme according to the operating profit difference may include the steps of: if the business profit difference is a positive value, the budget report of the next period is adjusted up according to the business profit difference; if the operating profit difference value is a negative value, determining a data item associated with the abnormal label according to the abnormal label; acquiring first data and second data corresponding to the data items associated with the abnormal tags, wherein the first data is data in the target data corresponding to the target period, and the second data is data in the actual data corresponding to the target period; calculating an anomaly difference between the first data and the second data, wherein the anomaly difference comprises a positive anomaly difference and a negative anomaly difference; and according to the business profit difference and the negative abnormal difference, the budget limit of the data item corresponding to the negative abnormal difference is adjusted downwards.

Specifically, after the local management server calculates according to the data similarity, it is determined that the difference data between the target data and the actual data corresponding to the target period includes at least one item, and each abnormal data in the at least one item of abnormal data corresponds to one abnormal label.

Further, the local management server obtains a first profit report corresponding to the target period from the database, and performs business profit difference calculation on the business profits of each store in the first profit report and the business profits of each store in the second profit report according to the identification information of each store to obtain the business profit difference of each store.

Further, the positive and negative of the operation profit difference are determined. If the difference value of the current operating profits is positive, calculating the proportion between the difference value of the operating profits and the operating profits corresponding to the first profit report. If the specific gravity exceeds the preset threshold value, adjusting the budget report of the shop in the next period according to the business profit difference, namely, up-regulating the budget cost upper limit of the shop in the next period, and taking the business profit difference as the supplementary fund of the budget cost. If the specific gravity is lower than the preset threshold value, the business profit difference value is directly used as the pure profit calculation of the next period. The preset threshold value is used for determining whether the business profit difference exceeds the limit or not, and influences the profit calculation of the next period. The threshold may be preset by a system developer, or may be set by each store operation manager, and is not specifically limited herein.

Further, if the difference value of the current operating profit is a negative value, obtaining abnormal data from the database according to the abnormal tag, wherein the abnormal data comprises data items and numerical values corresponding to the abnormal data. And calculating the difference between the target data and the actual data in the abnormal data, and if the difference corresponding to each abnormal data is a positive value, indicating that the exchange rate change is the influence factor with a negative business profit difference. Therefore, the budget limit of the next period of the shop can be adjusted according to the business profit difference; and if the difference corresponding to the abnormal data is a negative value, taking the data item corresponding to the abnormal data as a data item influencing the final business profit difference, and adjusting the budget limit of the data item in the next period.

It can be seen that, in this example, the business profit difference of the target period calculated by comparing the first profit statement and the second profit statement to determine the target data and the actual data, and then determine the corresponding processing scheme according to the business profit difference, so can realize that the difference of calculating business profits around the factor of data difference and exchange rate change is reduced, and the problem that account data is difficult to be self-consistent is brought for every shop.

Referring to fig. 4, fig. 4 is a schematic structural diagram of an electronic device, as shown in fig. 4, which includes a processor, a memory, a communication interface, and one or more programs, which are stored in the memory and configured to be executed by the processor, the server being applied to a data processing system, the programs including instructions for performing the following steps:

determining first exchange rate information of the business country of each store in the target period according to the site information;

receiving actual data of the at least one shop sent by the E-commerce platform server on a settlement day, wherein the actual data comprises actual data corresponding to the target period of the at least one shop;

calculating the actual operating profit of the target period according to the second exchange rate information and the actual data of the at least one shop laid in the target period to obtain a second profit report;

According to the data processing method described in the embodiment of the application, the target data, the first profit report and the staff performance report of each shop in the target period are calculated according to the first exchange rate of the target period and the target data obtained from the e-commerce platform server through the local management server, and then are independently stored; and receiving actual data sent by the E-commerce platform server on the settlement day, obtaining a second profit report corresponding to the actual data of the target period according to a second exchange rate of the settlement day, and determining corresponding processing measures according to the error data determined by the calculation result and the business profit difference. Therefore, the system can seal the account and reduce the influence caused by the difference between the target data and the actual data.

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

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

In the case of dividing each functional module by corresponding functions, fig. 5 shows a functional unit configuration diagram of a data processing apparatus, as shown in fig. 5, the data processing apparatus 500 is applied to a server, and the data processing apparatus 500 may include an acquisition unit 501, a determination unit 502, a calculation unit 503, a storage unit 504, a reception unit 505, and a processing unit 506:

wherein,

the acquisition unit 501 may be used to support the server performing step S201 described above, and/or other processes for the techniques described herein.

The determination unit 502 may be used to support the server performing the above-described steps S202, S206, and/or other processes for the techniques described herein.

The computing unit 503 may be used to support the server performing steps S203, S207 described above, and/or other processes for the techniques described herein.

The storage unit 504 may be used to support the server performing step S204 described above, and/or other processes for the techniques described herein.

The receiving unit 505 may be used to support the server performing step S205 described above, and/or other processes for the techniques described herein.

The processing unit 506 may be used to support the server performing step S208 described above, and/or other processes for the techniques described herein.

According to the data processing device provided by the embodiment of the application, the local management server obtains the target data from the e-commerce platform server through the obtaining unit, the calculating unit calculates the first profit report and the employee performance report of each shop in the target period according to the first exchange rate of the target period, and then the storage unit stores the target data, the first profit report and the employee performance report separately; the receiving unit is used for receiving actual data sent by the E-commerce platform server on a settlement day, the calculating unit is used for obtaining a second profit statement corresponding to the actual data of the target period according to a second exchange rate of the settlement day, and the determining unit is used for determining corresponding processing measures according to error data and business profit difference determined by the calculating unit. Therefore, the system can seal the account and reduce the influence caused by the difference between the target data and the actual data.

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

The server provided by the embodiment is used for executing the data processing method, so that the same effect as the implementation method can be achieved.

Where an integrated unit is employed, the server may include a processing module, a storage module, and a communication module. The processing module may be configured to control and manage actions of the server, for example, may be configured to support the server to execute the steps performed by the determining unit 502. The storage module may be used to support server execution, storage of program code and data, and the like. And the communication module can be used for supporting the communication between the server and other equipment.

The processing module may be a processor or a controller, among others. Which may implement or perform the various illustrative logical blocks, modules, and circuits described in connection with the disclosure. A processor may also be a combination of computing functions, e.g., a combination comprising one or more microprocessors, a combination of Digital Signal Processing (DSP) and microprocessors, etc. The storage module may be a memory. The communication module may specifically be a radio frequency circuit, a bluetooth chip, a Wi-Fi chip, or other devices that interact with other servers.

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 comprising a non-transitory computer readable storage medium storing a computer program operable to cause a computer to perform some or all of the steps of any of the methods as described in the above method embodiments. The computer program product may be a software installation package, the computer comprising a server.

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

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

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

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

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

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

Those skilled in the art will appreciate that all or part of the steps of the methods of the above embodiments may be implemented by a program, which is stored in a computer-readable memory, the memory including: flash memory disks, read-only memories (ROMs), random Access Memories (RAMs), magnetic or optical disks, and the like.

The foregoing embodiments have been described in detail, and specific examples are used herein to explain the principles and implementations of the present application, where the above description of the embodiments is only intended to help understand the method and its core ideas of the present application; meanwhile, for a person skilled in the art, according to the idea of the present application, the specific implementation manner and the application scope may be changed, and in summary, the content of the present specification should not be construed as a limitation to the present application.

Claims

1. A data processing method is applied to an enterprise resource management system, the enterprise resource management system comprises a local management server, and the local management server is in communication connection with an e-commerce platform server, and the method comprises the following steps:

the method comprises the steps that target data of at least one shop in a target period are obtained from an e-commerce platform server, wherein the target data comprise site information and business data, and the site information is used for indicating business countries corresponding to all shops in the at least one shop;

according to the first exchange rate information and the business data, the business profit and the employee performance of each shop in the target period are calculated, and a first profit report and an employee performance report are obtained respectively, wherein the first profit report comprises the business profit corresponding to each shop in at least one shop, and the employee performance report comprises the employee performance corresponding to each shop;

2. The method of claim 1, wherein obtaining goal data for at least one store-on-goal period from the e-commerce platform server comprises:

responding to login operation of a manager, and establishing communication connection with the e-commerce platform server according to the login operation, wherein the login operation means that the manager realizes that the local management server establishes communication connection with the e-commerce platform server through a management account, and the management account is used for managing the at least one shop;

responding to the setting operation of the administrator, and setting a first time node and a second time node according to the setting operation, wherein the first time node and the second time node are respectively used for representing the starting time and the ending time of the target period;

in response to a selection operation of the administrator, selecting at least one data item of the target data according to the selection operation, wherein each data item of the at least one data item is used for characterizing a data category, and the data category comprises one or more of the following: the site information, store data, merchandise data, sales data, and cost data;

acquiring a numerical value corresponding to each data item from the E-commerce platform server according to the at least one data item;

and determining the target data according to each data item and the value corresponding to each data item.

3. The method of claim 2, wherein the store data includes identification information of the each store;

the calculating the operating profit and the employee performance of each shop in the target period comprises the following steps:

acquiring the sales data and the cost data of each store from the target data according to the identification information, wherein the identification information is used for uniquely identifying each store, the sales data comprises sales volume information, price information and refund amount of each commodity in at least one commodity of each store, and the cost data comprises cost of each commodity and transportation expense cost;

determining the operating profit of each store in the target period according to the first exchange rate information, the sales data and the cost data of each store;

and determining the first profit report according to the operating profits of each shop in the target period.

4. The method of claim 3, further comprising:

acquiring the sales amount information and the price information of each commodity of each store;

respectively calculating the sales volume and the total sales volume of each commodity according to the sales volume information and the price information of each commodity;

calculating first ratio information of the sales amount and the total sales amount of each commodity;

calculating second proportion information between the refund amount and the sales amount of each commodity;

determining the employee performance of the employees of each store in the target period according to the first specific gravity information and the second specific gravity information;

and obtaining the staff performance report according to the staff performance.

5. The method of claim 4, wherein the enterprise resource management system further comprises a user terminal, wherein the user terminal is used for providing a visual interface of each store to business personnel of each store, and the user terminal is connected with the local management server;

after the first profit report and the employee performance report are obtained respectively, the method further comprises the following steps:

acquiring profit statements corresponding to adjacent periods of the target period from the database;

determining the profit growth rate of each shop according to the first profit report and the profit reports corresponding to the adjacent periods;

determining a budget statement and a financial resource allocation scheme of each shop in the next period according to the profit growth rate;

and sending the first profit statement, the budget statement and the financial resource allocation scheme to the user terminal, wherein the budget statement and the financial resource allocation scheme are used for providing reference basis for setting budget for the shop operation of the next period performed by the user.

6. The method of claim 5, wherein after determining the difference in business profit for each store, the method further comprises:

according to the identification information of each shop, acquiring the target data of each shop in the target period from the database;

according to the target data and the actual data corresponding to each shop, calculating data similarity, and determining difference data and the data items corresponding to the difference data;

after adding an abnormal tag to the difference data, associating the difference data and the abnormal tag to the corresponding data item, and deleting non-abnormal data, wherein the abnormal tag is used for identifying data in which the actual data is inconsistent with the target data, and the non-abnormal data is used for representing repeated data of the target data and the actual data corresponding to the target period.

7. The method of claim 6, wherein the exception data comprises at least one exception data, each exception data of the at least one exception data corresponding to one of the exception tags;

the determining a difference processing scheme according to the operating profit difference comprises the following steps:

if the business profit difference is a positive value, the budget report of the next period is adjusted up according to the business profit difference;

if the business profit difference is a negative value, determining a data item related to the abnormal label according to the abnormal label;

acquiring first data and second data corresponding to the data items associated with the abnormal tags, wherein the first data is data in the target data corresponding to the target period, and the second data is data in the actual data corresponding to the target period;

calculating an anomaly difference between the first data and the second data, wherein the anomaly difference comprises a positive anomaly difference and a negative anomaly difference;

and according to the business profit difference and the negative abnormal difference, the budget limit of the data item corresponding to the negative abnormal difference is adjusted downwards.

8. The data processing device is applied to an enterprise resource management system, wherein the enterprise resource management system comprises a local management server which is in communication connection with an e-commerce platform server; the device comprises an acquisition unit, a determination unit, a calculation unit, a storage unit, a receiving unit and a processing unit:

the acquisition unit is used for acquiring target data of at least one shop laid in a target period from the e-commerce platform server, wherein the target data comprises site information and business data, and the site information is used for indicating a business country corresponding to each shop in the at least one shop;

the determining unit is used for determining first exchange rate information of the business country corresponding to each shop in the target period according to the site information;

and the processing unit is used for determining the business profit difference of each shop according to the first profit report and the second profit report and determining a difference processing scheme according to the business profit difference.

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

10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program, which is executed by a processor to implement the method according to any one of claims 1-7.