An e-commerce operation data analysis system

Abstract

The application relates to the technical field of e-commerce operation, in particular to an e-commerce operation data analysis system; the system comprises a data access module, an index mapping module, an exchange rate conversion module, a financial calculation engine, a data export module and a permission control module; the data access module is connected with the index mapping module; the index mapping module is connected with the exchange rate conversion module and the financial calculation engine; the system can automatically identify and adapt the heterogeneous table formats of multiple platforms and ERP systems such as Taobao, Jingdong, Douyin and AliExpress, supports the data import and conversion of multiple platforms / multiple table formats into system standard operation indexes, and the field names do not need to be manually pretreated, so that the data aggregation efficiency is improved.

Description

Technical Field

[0001] This invention relates to the field of e-commerce operation technology, specifically to an e-commerce business data analysis system. Background Technology

[0002] With the rapid development of e-commerce, brands and e-commerce service providers often operate on multiple e-commerce platforms simultaneously (such as Taobao, JD.com, Pinduoduo, Douyin, AliExpress, Amazon, etc.). Significant differences exist in the backend data structures, field naming rules, and exported file formats of each platform, making it difficult to uniformly aggregate and analyze operational data from multiple platforms.

[0003] Existing e-commerce data analysis systems or ERP modules typically suffer from the following technical deficiencies:

[0004] Firstly, the system uses hard-coded matching for the field names in the imported tables. However, the table headers exported by different e-commerce platforms are not consistent, so it cannot adapt to the naming differences of the same semantic fields on different platforms. For example, the naming differences between payment amount and transaction amount lead to a lot of manual intervention for field alignment during data import, resulting in low automation and low processing efficiency.

[0005] Secondly, the calculation formulas for the indicators are fixed, and the financial calculation formulas built into the system cannot be adjusted, which cannot meet the customized needs of different projects / organizations for revenue / gross profit / store profitability / project profit and other metrics.

[0006] Furthermore, the lack of accurate currency conversion in cross-border data means that for cross-border e-commerce businesses, the system often uses a fixed exchange rate or the exchange rate at the end of the period for conversion within the overall calculation cycle, ignoring the need for accurate currency conversion based on the transaction date. This results in inconsistencies in the definition of historical financial data and affects the accuracy of data analysis.

[0007] Finally, existing systems mostly focus on profit calculation at the store level. Data from various sources such as ERP, store backend, and billing statements have different formats and lack a unified adapter and scalable mapping mechanism. Therefore, they cannot link the profits of multiple stores with the fixed costs of the project and cannot meet the differentiated profit calculation needs under the outsourced operation model. To address these issues, an e-commerce operation data analysis system is proposed. Summary of the Invention

[0008] The purpose of this invention is to provide an e-commerce business data analysis system that solves the problem that current traditional e-commerce business data analysis systems can only connect to a single platform, cannot flexibly adapt to data formats of multiple platforms, and are difficult to support custom indicators and financial models.

[0009] To achieve the above objectives, the present invention provides the following technical solution: an e-commerce operation data analysis system, comprising a data access module, an indicator mapping module, a currency conversion module, a financial calculation engine, a data export module, and an access control module. The data access module is data-connected to the indicator mapping module, which is also data-connected to the currency conversion module and the financial calculation engine. The financial calculation engine is data-connected to the data export module. The access control module is electrically connected to the data access module, the indicator mapping module, the financial calculation engine, and the data export module. The data access module consists of multiple import adapters, including an operational data adapter, an order data adapter, a billing data adapter, an ERP report adapter, and a system table adapter. Each adapter template in the block corresponds to a data source format, used to automatically convert heterogeneous table formats into standard system operating indicators. It supports template configuration, alias mapping, order-level daily aggregation, data integrity verification, and import coverage strategies. The indicator mapping module maintains a set of aliases for each standard operating indicator to match field names with the same semantics but different headers from different e-commerce platforms or reports. Indicators are divided into multiple indicator groups, and a sign (positive / negative) is specified for each indicator in the calculation within each group. During data import, field mapping is completed based on the aliases, and the mapped indicator values ​​are weighted and summed according to the signs within the group to obtain the segment values ​​such as revenue, cost, and gross profit, to deduce store profitability and project profit. This point directly covers the innovative combination of alias mechanism, indicator groups, and sign calculation.

[0010] Preferably, the financial calculation engine also supports automatically switching the profit calculation method according to the project type, including:

[0011] For self-operated projects, the profit calculation formula is: Σ Store Profit - Project Fixed Costs;

[0012] For outsourced operation projects, the profit calculation formula is: actual revenue received - fixed costs of the project;

[0013] Supports the allocation and calculation of fixed costs such as personnel costs and venue costs according to the distribution method of project members.

[0014] Preferably, when importing foreign currency amount indicators, the exchange rate conversion module obtains and uses the stored exchange rate of the day based on the recorded business date and converts the amount into the local currency for calculation, while retaining the original foreign currency value as a reference.

[0015] Compared with the prior art, the beneficial effects of the present invention are as follows:

[0016] This invention uses an import adapter system and alias mapping mechanism to decompose e-commerce operating indicators in a multi-dimensional and dynamic manner. It allows each operating indicator to independently define and maintain a set of aliases to adapt to semantically similar fields on multiple platforms. The system can automatically identify and adapt heterogeneous table formats from multiple platforms such as Taobao, JD.com, Douyin, AliExpress, and ERP systems. It supports importing data from multiple platforms / table formats and converting it into the system's standard operating indicators without the need for manual preprocessing of field names, thus improving data aggregation efficiency.

[0017] This invention performs local currency conversion by real-time capture or retrieval of exchange rates based on business dates. It supports data import from cross-border / foreign currency platforms. For non-RMB-based monetary indicators, the system captures and stores the exchange rate for each record's corresponding date, then converts the amount into the local currency for calculation and display, while retaining the original currency value for reference. This ensures that each transaction is converted at the exchange rate of the day, avoiding financial data deviations caused by using fixed exchange rates. At the same time, retaining the original foreign currency value serves as an audit trail, improving the traceability and accuracy of historical data.

[0018] This invention utilizes a customizable indicator group and symbol mechanism, allowing users to dynamically configure financial calculation formulas based on their business needs. Each indicator is categorized into an indicator group, and within each group, it participates in calculations using positive / negative symbols. This supports obtaining store / project-level profitability and profit through calculations (e.g., revenue = payment amount - refund amount - order replenishment amount; project profit = Σ store profit - project fixed costs). Without modifying the underlying system code, it can adapt to the personalized business analysis standards of different enterprises or projects. The system supports various project types, including self-operated and outsourced operations, and can automatically associate and allocate store profits with the project's fixed costs such as manpower and location, reducing secondary development costs. Attached Figure Description

[0019] Figure 1 This is a schematic diagram of the overall logical structure of the present invention;

[0020] Figure 2 This is a schematic diagram of the data access module of the present invention;

[0021] Figure 3 This is a schematic diagram of the index mapping module of the present invention;

[0022] Figure 4 This is a schematic diagram of the data export module of the present invention;

[0023] Figure 5 This is a schematic diagram of the financial calculation engine of the present invention;

[0024] Figure 6 This is a schematic diagram of the access control module of the present invention;

[0025] Figure 7This is a schematic diagram of the overall workflow of the present invention. Detailed Implementation

[0026] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0027] Please see Figure 1 , Figure 2 , Figure 3 , Figure 4 , Figure 5 , Figure 6 , Figure 7An e-commerce business data analysis system includes a data access module, an indicator mapping module, a currency conversion module, a financial calculation engine, a data export module, and an access control module. The data access module is connected to the indicator mapping module, the indicator mapping module is connected to the currency conversion module and the financial calculation engine, the financial calculation engine is connected to the data export module, and the access control module is connected to the data access module, the indicator mapping module, the financial calculation engine, and the data export module. By importing an adapter system and alias mapping mechanism, e-commerce operating indicators are broken down into multi-dimensional and dynamic components. Each operating indicator can independently define and maintain a set of aliases to adapt to semantically similar fields across multiple platforms. The system can automatically identify and adapt heterogeneous table formats from multiple platforms such as Taobao, JD.com, Douyin, AliExpress, and ERP systems. It supports importing data from multiple platforms / table formats and converting it into standard operating indicators, eliminating the need for manual preprocessing of field names and improving data aggregation efficiency. By using real-time capture or reading of exchange rates based on business dates for local currency conversion, the system supports data import from cross-border / foreign currency platforms. For non-RMB-based monetary indicators, the system captures and stores the exchange rate for the corresponding date of each record, then converts the amount into the local currency for calculation and display, while retaining the original currency value for reference. This ensures that every transaction... Transactions are converted at the exchange rate of the day, avoiding financial data deviations caused by using a fixed exchange rate. The original foreign currency value is retained as an audit trail, improving the traceability and accuracy of historical data. Through a customizable indicator group and symbol mechanism, users can dynamically configure financial calculation formulas according to their business needs, categorizing each indicator into groups and using positive / negative symbols within each group. This supports calculating store / project level profits and earnings (e.g., revenue = payment amount - refund amount - order replenishment amount; project profit = Σ store profit - project fixed costs). Without modifying the underlying system code, it can adapt to the personalized business analysis standards of different enterprises or projects. The system supports various project types, including self-operated and outsourced operations, and can automatically associate and allocate store profits with project fixed costs such as manpower and location, reducing secondary development costs.

[0028] In this embodiment, the data access module consists of multiple import adapters, including an operational data adapter, an order data adapter, a billing data adapter, an ERP report adapter, and a system table adapter. The system automatically identifies the format and structure of uploaded files, including detecting the column names and data types of the tables, identifying the original platform source of the files, verifying the integrity and standardization of the data, and converting it into a standardized data stream.

[0029] In this embodiment, each adapter template of the data access module corresponds to a data source format, which is used to automatically convert heterogeneous table formats into standard system operating indicators, and supports template configuration, alias mapping, order-level daily aggregation, data integrity verification and import coverage strategies.

[0030] In this embodiment, the financial calculation engine also supports automatically switching the profit calculation method according to the project type, including:

[0031] For self-operated projects, the profit calculation formula is: Σ Store Profit - Project Fixed Costs;

[0032] For outsourced operation projects, the profit calculation formula is: actual revenue received - fixed costs of the project;

[0033] Supports the allocation and calculation of fixed costs such as personnel costs and venue costs according to the distribution method of project members.

[0034] In this embodiment, when importing foreign currency amount indicators, the exchange rate conversion module obtains and uses the stored exchange rate of the day based on the recorded business date and converts the amount into the local currency for calculation, while retaining the original foreign currency value as a reference.

[0035] In this embodiment, the indicator mapping module maintains a set of aliases for each standard operating indicator to match field names with the same semantics but different headers from different e-commerce platforms or reports;

[0036] Divide the indicators into multiple indicator groups, and within each group, assign a sign (positive / negative) to each indicator for calculation.

[0037] During data import, field mapping is completed based on aliases, and the mapped indicator values ​​are weighted and summed according to the symbols within the group to obtain segment values ​​such as revenue, cost, and gross profit, thereby deriving store profitability and project profit; this point directly covers the innovative combination of alias mechanism, indicator group, and symbol calculation.

[0038] Detailed implementation: First, users import raw data files in Excel / CSV formats from different e-commerce platforms (Taobao, JD.com, Douyin, AliExpress, etc.), ERP systems, or manually entered data through the upload interface in batches. The system automatically detects the table structure, column name characteristics, and data source of the uploaded files through its built-in format recognition module, and intelligently matches the corresponding import adapter, such as the Taobao operation data adapter and the AliExpress bill adapter. Each adapter adopts a modular design, encapsulates the parsing rules of a specific platform, and is responsible for parsing the raw table data into an intermediate format that the system can process, and completing data integrity verification.

[0039] The parsed data then enters the indicator mapping module, which maintains a standard operating indicator library, such as payment amount and refund amount, and configures a set of aliases for each standard indicator, such as mapping the semantic fields transaction amount and actual amount received to payment amount. The system automatically maps the original field names of different platforms to unified standard operating indicators based on the alias mechanism, solving the problem of field naming differences across multiple platforms. The mapped indicators are then divided into preset indicator groups (such as revenue group, cost group, and marketing expense group). For cross-border data, the currency conversion module intervenes, obtaining the exchange rate of the day from the exchange rate interface or local cache based on the business date of each record, converting the foreign currency amount into RMB base currency, while retaining the original foreign currency value to ensure the accuracy and traceability of financial data.

[0040] The standardized data is then fed into the financial calculation engine. The engine reads the calculation sign set by the user for each indicator in the indicator group configuration module: a positive sign (+) for revenue and a negative sign (-) for expenses. The engine performs a signed summation of the values ​​of all indicators within each indicator group, generating a summary value for each financial segment, such as revenue and cost segments. Based on this, the engine further performs multi-level profit calculations:

[0041] Store-level profitability: Calculates the profitability of a single store based on the aggregated values ​​of each financial segment;

[0042] Project-level profit: The system employs a differentiated profit model based on project type (self-operated / outsourced). For self-operated projects, profit is the sum of profits from all associated stores minus fixed costs such as project personnel and location; for outsourced projects, profit is the actual revenue received minus fixed costs. Fixed costs can be automatically allocated and calculated based on dimensions such as personnel and time.

[0043] Finally, the calculated data results enter the output layer. First, they undergo strict verification by the access control module to confirm whether the current user has the permission to view and export the corresponding project or financial data. The verified data is displayed in real time in the visualization dashboard in the form of charts, dashboards, etc., supporting views such as store operation overview, project profit analysis, and multi-dimensional data comparison. Users can customize the configuration and export standard format Excel reports through the report generation module. All export operations are recorded in the audit log for easy traceability.

[0044] Example 1:

[0045] Applicable to: Brands that operate multiple self-owned platforms (such as Tmall, JD.com, Douyin, etc.).

[0046] First, users create a project in the system and associate it with three stores operated by the brand: Tmall, JD.com, and Douyin. The system generates a unique identifier for each store and binds it to the project.

[0047] Users can export operational data tables (Excel / CSV format) from the backends of each platform and import them in batches via the system's data upload interface. The system supports uploading multiple files simultaneously and automatically identifies the file types.

[0048] The system then performs format checks on each uploaded file, including column name characteristics, data source fields such as platform identifiers, and table structure. Based on the recognition results, it automatically calls the corresponding import adapter.

[0049] Taobao Adapter (parses Tmall tables);

[0050] JD.com adapter (parsing JD.com tables);

[0051] TikTok adapter (parses TikTok tables);

[0052] Each adapter then parses the original table data into a temporary data table. The indicator mapping module automatically maps field names from different platforms to the system's standard operating indicators based on a pre-defined alias library.

[0053] The payment amount on Tmall, the transaction amount on JD.com, and the actual payment amount on Douyin are all mapped to the standard indicator payment amount; other fields such as refund amount, shipping fee, and discount amount are also mapped according to the alias rules; after the mapping is completed, the system generates standardized intermediate data, including fields such as store ID, date, indicator name, and indicator value.

[0054] The system then assigns each indicator to its corresponding group based on the project's pre-defined indicator group configuration:

[0055] Revenue group: includes payment amount (+), refund amount (-), order replacement amount (-), etc.;

[0056] Cost group: includes product cost (-), packaging cost (-), etc.;

[0057] Marketing expense group: includes promotion expenses (-), commissions (-), etc.;

[0058] The indicator groups and symbols can be customized by the user when creating the project, and the system will automatically perform subsequent calculations according to the configuration.

[0059] Then, the financial calculation engine summarizes the signed cumulative values ​​of each indicator group for each store to generate daily store profit: Store Profit = Revenue Group Summary Value + Cost Group Summary Value + Marketing Expense Group Summary Value; The calculation results are stored in the database and linked with the original data for easy traceability.

[0060] Meanwhile, the system aggregates the daily profits of all stores based on the relationship between the project and the store, thus obtaining the total project profit. If the project involves fixed costs (such as labor and venue), the user can enter the fixed cost amount in the project settings. The system will then allocate these costs daily or monthly and calculate the project's net profit: Project Profit = Total Project Profit - Fixed Cost Allocation.

[0061] Finally, the system verifies whether the current user has permission to view the project data. If successful, the following content is displayed in the data dashboard: real-time operating data for each store (payment amount, refunds, promotion fees), daily profit trend charts for each store, a summary table of total project profits, a project-level profit analysis report, and the ability for users to export project-level profit reports (Excel format). The system records export logs for subsequent auditing.

[0062] The beneficial effects of this embodiment are: it enables automated access and unified calculation of data from multiple platforms without the need for manual field alignment; it supports project-level profit analysis, helping brands quickly grasp the overall business situation.

[0063] Example 2:

[0064] Target audience: Sellers on cross-border platforms such as AliExpress and Amazon.

[0065] First, users log in to the system, select the corresponding cross-border store, and upload the billing form exported from the AliExpress backend. The system supports formats such as xlsx and csv; the system automatically recognizes that the file source is the AliExpress platform and calls the AliExpress import adapter for parsing; the adapter extracts key fields from the table, including transaction amount, transaction date, product name, order number, etc.

[0066] The indicator mapping module then maps the transaction amount field to the standard indicator payment amount. Simultaneously, the system detects that the currency unit in the column containing this field is a non-RMB base currency, automatically marks it as requiring currency conversion, and records the original currency type and amount value.

[0067] The currency conversion module then checks the local cache for the exchange rate of other currencies to RMB for each record based on the business date. If the cache is not found, it calls the external exchange rate interface to obtain the exchange rate for that day and stores it in the cache for later reuse. The obtained exchange rate is used to convert the payment amount from other currencies to RMB, generating a new field "Payment Amount_Base Currency". At the same time, the original fields "Payment Amount_Original Currency" and "Original Currency" are retained for reference.

[0068] After the conversion, the system standardizes the data into a unified indicator structure. Based on the project's pre-defined indicator groups, payment amounts in local currency are categorized into the revenue group and assigned a positive sign. The financial calculation engine calculates store profitability by summarizing daily revenue and payment amounts in local currency, combined with other cost indicators such as refund amounts. All financial data is presented in RMB local currency to ensure consistency in internal reports.

[0069] Finally, the system stores both the original amounts in other currencies and the converted RMB amounts in the database, and records the exchange rate and date used. Users can switch between viewing dual-currency data in the data dashboard, facilitating cross-border reconciliation and financial auditing. The system verifies the user's access permissions to cross-border store data, and once approved, displays it in the financial dashboard, such as daily revenue, the impact curve of exchange rate fluctuations on revenue, and a list of original amounts in other currencies. Users can export financial statements containing both currencies, and the system automatically records the export operation.

[0070] The beneficial effects of this embodiment are: accurate exchange rate conversion based on the transaction date, avoiding financial errors caused by exchange rate fluctuations; preservation of original currency data to meet cross-border reconciliation and auditing needs; and an exchange rate caching mechanism to improve processing efficiency and reduce external interface calls.

[0071] Example 3:

[0072] Target audience: Outsourced operation service providers who manage multiple client projects.

[0073] First, the user creates a new project in the system and selects the project to be managed by the system in the project properties. The system then automatically loads the corresponding profit calculation template based on the project type.

[0074] Then the user associates the project with Customer A's Douyin store and imports the store's operational data (same as the data import process in Example 1). The system completes standardized processing such as field mapping and indicator classification.

[0075] Users enter monthly fixed costs in the project settings:

[0076] Human resource costs: salaries and social security contributions for operations staff;

[0077] Location costs: office space allocation, equipment depreciation, etc.;

[0078] Other costs: software service fees, travel expenses, etc.;

[0079] The system supports automatically allocating fixed costs to each project based on rules such as project members and working hours.

[0080] Subsequently, for outsourced operation projects, profit calculation will no longer be based on store profits, but on the actual revenue received by the project (i.e., the outsourced operation service fee paid by the customer). Users will enter the service fee amount paid by customer A on a monthly basis through the financial entry function.

[0081] The financial calculation engine automatically switches the profit calculation formula based on the project type "outsourced operation project":

[0082] Project profit = Actual revenue received - Fixed cost allocation. Store profit data is for reference only and is not directly included in the profit calculation of the managed project. The system summarizes the actual revenue received monthly and deducts the fixed cost allocation for the month to generate the monthly project profit.

[0083] The system then allows users to filter and view profit reports for all projects by the "Self-operated / Agency-operated" tag. Users can simultaneously view the "Σ Store Profit - Fixed Costs" for self-operated projects and the "Actual Revenue - Fixed Costs" for agency-operated projects, facilitating overall profitability analysis.

[0084] The system strictly controls access permissions to financial data: project profit reports are only accessible to project managers, finance directors, and other relevant roles; operations staff can only view store operation data and cannot access fixed costs and actual revenue information.

[0085] The project dashboard displays: monthly profit trend, fixed cost composition, comparison of actual revenue and store profit, and project profit margin.

[0086] Finally, users can export a detailed project profit statement, including actual receipts, fixed costs, and final profit. All financial entries and modifications are logged to ensure data traceability.

[0087] The beneficial effects of this embodiment are: it supports differentiated profit models for outsourced and self-operated projects, accurately reflecting the profitability of different business models; it automatically allocates fixed costs, reducing errors from manual calculations; and it ensures the security of customer financial data through access control.

[0088] Although embodiments of the invention have been shown and described, it will be understood by those skilled in the art that various changes, modifications, substitutions and alterations can be made to these embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the appended claims and their equivalents.

Claims

1. An e-commerce business data analysis system, characterized in that: The system includes a data access module, an indicator mapping module, a currency conversion module, a financial calculation engine, a data export module, and an access control module. The data access module is connected to the indicator mapping module, which in turn is connected to both the currency conversion module and the financial calculation engine. The financial calculation engine is connected to the data export module. The access control module is connected to both the data access module and the indicator mapping module, as well as the financial calculation engine and the data export module. The data access module consists of multiple import adapters: an operational data adapter, an order data adapter, a billing data adapter, an ERP report adapter, and a system table adapter. Each component of the data access module... Each adapter template corresponds to a data source format, used to automatically convert heterogeneous table formats into standard system operating indicators. It supports template configuration, alias mapping, order-level daily aggregation, data integrity verification, and import coverage strategies. The indicator mapping module maintains a set of aliases for each standard operating indicator to match field names with the same semantics but different headers from different e-commerce platforms or reports. Indicators are divided into multiple indicator groups, and a sign (positive / negative) is specified for each indicator in the calculation within each group. During data import, field mapping is completed based on the aliases, and the mapped indicator values ​​are weighted and summed according to the signs within the group to obtain segment values ​​such as revenue, cost, and gross profit, to deduce store profitability and project profit. This point directly covers the innovative combination of aliasing mechanisms, indicator groups, and symbolic computation.

2. The e-commerce operation data analysis system according to claim 1, characterized in that: The financial calculation engine also supports automatically switching the profit calculation method based on project type, including: For self-operated projects, the profit calculation formula is: Σ Store Profit - Project Fixed Costs; For outsourced operation projects, the profit calculation formula is: actual revenue received - fixed costs of the project; Supports the allocation and calculation of fixed costs such as personnel costs and venue costs according to the distribution method of project members.

3. The e-commerce operation data analysis system according to claim 1, characterized in that: When importing foreign currency amount indicators, the exchange rate conversion module obtains and uses the stored exchange rate of the day based on the recorded business date and converts the amount into the local currency for calculation, while retaining the original foreign currency value as a reference.

Images