CN115526686A

CN115526686A - E-commerce ERP system with profit trial calculation function and computer equipment

Info

Publication number: CN115526686A
Application number: CN202211194362.XA
Authority: CN
Inventors: 王志超; 陈孝欣; 佘禹然; 林海平; 吴春秀; 陈寿宝
Original assignee: Shenzhen Meiyunji Network Technology Co ltd
Current assignee: Shenzhen Meiyunji Network Technology Co ltd
Priority date: 2022-09-28
Filing date: 2022-09-28
Publication date: 2022-12-27
Also published as: CN115471126A; CN115496406A; CN115471127A

Abstract

The application discloses an E-commerce ERP system with a profit trial calculation function and computer equipment, which are used for managing Amazon shops and comprise a profit trial calculation module, a commodity module, a sales module and an authority management module; profit trial-calculation module is used for calculating one or more in the three income index of product gross profit, gross profit rate and selling price can manually be revised in the profit trial-calculation module selling price gross profit or the numerical value of gross profit rate when revising the numerical value of one of them income index, the numerical value of other two income indexes can be based on the corresponding result of the automatic calculation of field value logic of profit trial-calculation module, realizes the numerical value linkage of three income index, makes the system can be used as new product pricing, online product price adjustment or the instrument of adjusting the price when data is unusual, and the time manpower is saved in the help operation to improve the simple operation nature.

Description

E-commerce ERP system with profit trial calculation function and computer equipment

Technical Field

The application relates to the technical field of computers, in particular to an e-commerce ERP system with a charge pre-estimation function, a profit trial calculation function, a list interface switching function and an operation management function, a realization method of the corresponding functions and computer equipment.

Background

With the rise of electronic commerce, it is very common for an e-commerce enterprise (seller) to simultaneously set up a store on a plurality of different e-commerce platforms (such as amazon, arbiba, kyoton, walma, etc.), or to set up a plurality of stores on one e-commerce platform. In order to improve the management efficiency of the e-commerce Enterprise on a plurality of stores, an e-commerce management software system (referred to as "e-commerce ERP", "ERP system" or "system" in the present application) developed based on ERP (Enterprise Resource Planning) gradually starts to be used by each e-commerce Enterprise for managing domestic e-commerce or cross-border e-commerce services, so that one e-commerce ERP system can simultaneously manage a plurality of stores, and the efficiency of each link of store operation is greatly improved. A SaaS ERP system developed based on a cloud platform is an important development direction of E-business ERP, and SaaS is short for Software-as-a-Service.

The e-commerce ERP system accesses shops under the e-commerce platform through established rules, needs to realize diversified functional requirements, processes dynamic data of each link of an order, follows various rules of the e-commerce platform, has huge management data, and simultaneously needs to meet the characteristic of convenient operation of a user (seller), so that the existing commercialized e-commerce ERP system is in a stage of gradually updating and improving functions, functional algorithms and rules formulated by software enterprises in developing the e-commerce ERP system are basically different, and related functional modules such as a commodity module, a sales module, a purchasing module, a logistics module, a warehouse module, a financial module, an advertisement module, a customer service module, a data module and the like often have the defects of data loss, errors, update delay, insufficient accuracy and the like when used in a specific scene, and the use effect of the ERP system is directly influenced.

Taking the cross-border service of the amazon e-commerce platform as an example for management, when counting sales orders, the existing ERP system usually counts order data in a shifted state (indicating that the orders are in a shipped state) and a pending state (indicating that the orders are in a to-be-completed state), and because the orders are not settled in the pending state, the ERP system cannot obtain real background sales data of the amazon stores, so that the existing ERP system cannot count sales, and only counts sales; that is, the existing ERP system cannot further calculate data related to the sales of the order in the pending state, for example, the profit (mainly gross profit) of the original order (referring to the order before settlement) cannot be estimated, so that the user (ERP system operator) cannot immediately see the profit that may be brought by the original order when the user starts to place the order.

In addition, the existing ERP system does not have the functions of profit trial calculation, operation management and the like, or the corresponding functions are not perfect; the visibility of an information list interface of the conventional ERP system is poor, and the information list interface can not be flexibly adjusted according to scenes.

Other technical issues relating to e-commerce ERP function modules are explained further below. The above is only for the purpose of assisting understanding of the technical solutions of the present application, and does not represent an admission that the above is prior art.

Content of application

The electronic commerce ERP system has a cost estimation function and aims to further improve sales data of sales orders, so that when real data of a shop background cannot be obtained by the system, related benefits of the sales orders can be estimated reasonably in advance, and the accuracy of the electronic commerce ERP system in a data acquisition delay stage is improved. In addition, the E-business ERP system further has the new functions of profit trial calculation, operation management, list interface switching and the like, and the management accuracy and efficiency of the ERP system are improved.

In order to achieve the purpose, the E-commerce ERP system with the expense estimation function is used for managing Amazon shops and is characterized by comprising a commodity module, a sales module, a financial module, a data module and an authority management module.

The authority management module is used for managing the authority and other authorities for accessing the shop, and after the shop is authorized to be allowed to access, the E-commerce ERP system with the expense estimation function can obtain the background data of the shop. The commodity module is used for managing local commodities and recording commodity attributes of the local commodities.

The sales module comprises a sales order module and an online product module, and after the shop authorization is finished, the online product module can import the online product information of the authorized shop; online product information from an authorized store can be synchronously recorded in the online product module and used as local basic information, the local basic information comprises local product price, the online product information of the authorized store comprises online product price, and the online product price synchronously recorded in the online product module for the first time is initial data of the local product price. That is, the online product module may import online product information of an authorized store as local basic information, where a product price in the online product information is an online product price, and a product price in the local basic information is a local product price.

The sales order module is used for managing sales orders of online products of stores, the sales orders have a shifted state and a pending state, and sales of the products in the sales order module can be valued according to the states of the orders in a specific sequence: when a sales order is in a pending state, (1) the sales volume of the product is firstly valued as item price (which refers to commodity price) corresponding to an amazon background all order report; (2) if the sales order does not exist in the all order report, the sales amount of the product takes the product amount of the latest order; (3) and if no order is recently issued, automatically taking the local product price in the local basic information to realize the estimation of the product sales.

When a sales order is in a pending state, one or more of the sales module, the financial module, or the data module calculates potential order revenue for the sales order based on the product sales amount, the potential order revenue being an estimate of revenue charge for the pending order prior to completing payment.

According to the E-commerce ERP system, the sales of the sales order in the pending state is estimated by setting a three-level value taking mode for the sales of the product, so that the ERP system can reasonably estimate the related income of the sales order in advance when the real data of the shop background cannot be obtained, the profit estimation of the order before settlement (the original order) is further realized, and a user can see the income possibly brought by the original order when just starting to place the order; sales may be counted in sales statistics and product performance. In addition, due to the fact that the updating time of the sales order is different from that of the amazon background all order report, the amazon report has a problem, and statistics of all reports are delayed greatly, so that the sales data estimated by the e-commerce ERP system according to a specific sequence are more accurate, estimation of initial profit can be usually about 3 days earlier than that of the amazon background report, and the problem that the e-commerce ERP system loses order sales when orders are not paid due to the delay of the store background data is solved.

The value taking modes of three levels of the product sales amount are shown in fig. 2, item price in a first level (S1.1) value platform report, product amount of a latest order is taken as a second level (S1.2), and local product price is taken as a third level (S1.3), wherein the value taking mode of the first level is usually closest to the actual product sales amount after order payment is completed, and the value taking mode of the third level is possibly deviated from the actual product sales amount after order payment is completed by a certain amount relative to the value taking modes of the first and second levels, and is not influenced by past product sales records, so that successful value taking can be ensured. That is, because the factors of order cancellation, refund, goods return, cost sharing and the like are not considered, the value of the sales volume of the product and the final sales volume may be deteriorated to a certain extent, but relatively reasonable data can be obtained in the original order, so that the overall estimation of the income of the original order is realized.

In other embodiments, the value of the product sales may be one or two of the three levels (S1.1, S1.2, S1.3), for example, the values of the second level (S1.2) and the third level (S1.3) are also applicable to other e-commerce platforms other than amazon platforms.

In addition, the authority management module or other modules of the E-commerce ERP system can further improve the estimation of corresponding order commodity tax on pending state orders or other unsettled orders according to the basic tax rate preset by the shop site, improve the data accuracy of the E-commerce ERP system in links of expense estimation, profit trial calculation and the like, and realize that the calculation of multiple benefits such as expense estimation, profit trial calculation and the like is earlier than that of an E-commerce platform.

Furthermore, the E-commerce ERP system further has a product profit trial calculation function, and a corresponding profit trial calculation module is arranged and comprises a first profit trial calculation module and a second profit trial calculation module. The first profit trial calculation module is arranged at the position of the online product module or other approximate function modules and is mainly used for pricing new products and calculating the initial profit of pending orders; the second profit trial calculation module is arranged at the position of the product analysis module, the tool module or other approximate function modules and is mainly used for analyzing whether gross profits generated by pricing of products meet expectations or not after the products are sold, so that the products can be priced again conveniently. The profit trial calculation module is used as a tool for pricing new products, adjusting prices of online products or adjusting prices when data is abnormal, and can help operators to save time and labor. The seller can conveniently and visually adjust the data corresponding to the commodities. The profit trial calculation module completes profit calculation under various scenes according to specific value logic, and the specific implementation scheme and other technical effects are explained later.

Further, the e-commerce ERP system further has a list interface switching function. In each functional module of the e-commerce ERP system, some functional modules include a large number of fields, for example, on-line product modules in the sales module include thirty fields and corresponding data such as product sales status, pictures, ASIN, MSKU, parent ASIN, FNSKU, product name, item name, SKU, store, site, price, offer price, gross profit, gross interest rate, estimated cost, sales volume, sales amount, advertisement expense, star rating, purchase cost, head cost, latest update time, creation time, and the like, and if the thirty fields and corresponding data are all embodied in a list interface according to a conventional processing method, the visibility of the list interface is poor, and it is difficult for an operator to view key data in a targeted manner. Therefore, the e-commerce ERP system is provided with a list interface switching function, fields corresponding to the function modules are managed in a classified mode, display contents of the list interface are adjusted flexibly, and accordingly visibility of the list interface is improved.

Furthermore, the e-commerce ERP system further has an operation management function and is correspondingly provided with an operation management module. In the operation management process, because the operation work is complicated and the completion condition of the operation target is difficult to track, the whole plan can not always fall to the right place, and the planned events can be forgotten to be done at a certain time point, so that the optimal time for adjusting and optimizing the product is missed. Therefore, the main functions of the operation management module are decomposed into three tool modules, namely an operation plan module, an operation pending module and an operation note module. The operating management module has the working principle that: the management actions of operators are connected in series through an operation plan, the key indexes are quantized, and the completion conditions of the key indexes are tracked through a visual scheme; establishing a key task by combining key indexes, and converting the key task into an operation task (namely operation backlog); in the process of executing an operation task or achieving an operation target, supporting an operator to deposit an operation method or key actions as operation notes; and finally, combining with a data billboard, enabling a user to perform a duplication action of an operation plan through data analysis, and performing systematic precipitation on an operation growth method which accords with the product category and the company scale. The whole operation process forms a closed loop through mutual connection of the operation plan, the operation to be done and the operation notes, the operation data are fed back and recorded in real time, and a user is reminded of timely processing the operation tasks or adjusting the operation method, so that the operation working efficiency is greatly improved. Therefore, the operation method of the user and the key thing for growth are recorded in the operation management module, so that the user can gradually perfect the service growth method. Through the operation management module, future work, repeated historical work and record can be planned better, and therefore fine operation is well performed. Specific embodiments and other technical effects are described later.

Further, the application also provides a server, the server comprises a memory and a processor, the e-commerce ERP system of the application is stored in the memory, and the processor can run the operation instructions of the e-commerce ERP system and execute the function implementation method of each functional module.

Further, the application also provides computer equipment which comprises a memory and a processor, wherein the e-commerce ERP system is stored in the memory, and the processor can run the operation instruction of the e-commerce ERP system and execute the function implementation method of each functional module.

Claim that: for simplicity of description, the present application mainly describes related technical solutions based on amazon platform, and it should be noted that the e-commerce platform referred to in the present application may also be one or more other e-commerce platforms besides amazon. The E-commerce ERP system comprises one or more of a commodity module, a sales module, a purchasing module, a logistics module, a warehouse module, a financial module, an advertisement module, a customer service module, a tool module, a permission management module, a data module and other functional modules, wherein the functional modules can be mutually fused, can also exist independently, and can also be a sub-module with one functional module as another functional module. The operator of the ERP system may also be called a store manager, a seller, an operator, or a user, and the identity of the operator is not strictly limited unless specifically stated.

The term "E-business" in this application (English words in this application do not distinguish between capital and lowercase):

(1) Headway refers to the initial delivery of a product to a warehouse (e.g., amazon warehouse, etc.).

(2) Pending means that the sales order is Pending or Pending for payment; unshipped means that the sales order is in an undelivered state; shifted indicates that the sales order is in a shipped state.

(3) listing refers to a product detail page or an online product.

(4) SKU (Stock Keeping Unit) refers to the code of the inventory item; an SPU (Standard Product Unit) refers to a standardized Product Unit, and an SPU is the smallest Unit of commodity information aggregation, and is a set of reusable and easily retrievable standardized information, and the set describes the characteristics of a Product, that is, a commodity with the same attribute value and characteristics can be called an SPU.

(5) ASIN is the product number for the Amazon platform, and may be referred to broadly in this application as the trademark number for the E-commerce platform.

(6) MSKU (Merchant Stock Keeping Unit) refers to online commodity code; an SPU may contain multiple SKUs, and an SKU may contain multiple MSKUs.

(7) ERP (Enterprise Resource Planning) is an Enterprise Resource Planning.

(8) The FBA (fusion by Amazon) refers to a seller transporting a commodity to an Amazon operation center (i.e., an FBA head-end), and Amazon is responsible for storing and managing the commodity, picking up and packaging the commodity and providing quick delivery, and providing local language service for customer service and return and change of goods.

(9) The FBM (Fulfillment By Myself) refers to Amazon self-delivery, and sellers self-deliver orders for Amazon sales, and a series of processes such as inventory, packaging, delivery, customer service and the like need the sellers to be in charge of themselves; the platform self-delivery can be generally referred to in the application, and sellers need to take the responsibility of the sellers in a series of processes such as inventory, packaging, delivery, customer service and the like.

(10) ROI (Return On Investment) refers to the input-output ratio.

(11) The VAT (Value-added Tax) Tax rate refers to the Value-added Tax rate.

(12) refraralfee refers to platform fees, storageFee refers to warehousing fees, and pickAndPackFee refers to distribution fees.

(13) USD is U.S. dollars, U.S. currency units; buyBox refers to a shopping cart for e-commerce platforms.

(14) review refers to the product rating that the customer left after purchasing the product, and represents the number of reviews when making a statistic.

(15) ACoS is the percentage of advertisement spending versus advertisement sales over a specified time range; ROAS is the return rate of advertising spending over a specified time frame, which is given by the sales generated by the advertisement divided by the advertising spending; ACoTS is the percentage of the advertisement cost to the total sales of the store over a specified time frame, calculated by dividing the advertisement cost by the total sales; ASoTS is the percentage of advertisement sales to total store sales over a specified time frame, calculated by dividing advertisement sales by total store sales.

Drawings

The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings:

FIG. 1 is a functional block diagram of an embodiment of an ERP system of an applicant;

fig. 2 is a value sequence diagram of sales of a product when a sales order is in a pending state in an embodiment of the e-commerce ERP system of the present application;

FIG. 3 is a functional diagram of a portion of a sales module in an embodiment of the applicant ERP system;

FIG. 4 is a diagram illustrating price and profit data acquisition for a product in an embodiment of the ERP system of the applicant;

FIG. 5 is a field value sequence diagram of a product profit trial calculation in an embodiment of the applicant ERP system;

FIG. 6 is a schematic diagram of a list interface of functional modules in an embodiment of the application, e-commerce ERP system;

fig. 7 is a schematic view of an operation management process in an embodiment of the applicant ERP system;

fig. 8 is a logic diagram of a last cycle value in an embodiment of the applicant ERP system.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more clearly understood, the following detailed description is made for embodiments of the present application with reference to the accompanying drawings. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

Referring to fig. 1 and 2 in combination, the present application provides an e-commerce ERP system, which, in an embodiment of the present application, may be used to manage amazon stores or stores of other e-commerce platforms, and the e-commerce ERP system may include a goods module, a sales module, a purchasing module, a logistics module, a warehouse module, a finance module, an advertisement module, a customer service module, a tool module, a data module, and an authority management module.

The system comprises a permission management module, an e-commerce ERP system and a data processing module, wherein the permission management module is used for managing the permission of accessing the shop and the management of other permissions, and after the shop is authorized to be allowed to access, the e-commerce ERP system can acquire background data of the shop; the commodity module is used for managing local commodities and recording commodity attributes of the local commodities, wherein the commodity attributes can comprise information such as item names, pictures, commodity codes (SKUs), purchasing cost, weight, size and the like.

In one embodiment, the commodity module includes a commodity list, and the commodity list is used for managing local commodities and recording commodity attributes of the local commodities. The commodity attribute information in the commodity module can be further divided into basic information, logistics information, purchasing information and boxing information. The basic information may include information such as developers of the goods, on-sale status, goods classification, goods sources and goods remarks. The logistics information may include customs clearance name, customs clearance unit price, customs clearance weight, customs code, and default heading cost and FBA freight declaration rate for different countries that may be pre-filled. The purchasing information can include purchasing cost, purchasing duration (delivery date), purchaser, commodity size, product weight, supplier information, and an option module for setting whether to open the quality inspection process. The boxing information may include the size, weight, and number of products boxed.

As shown in FIG. 3, the sales module includes a sales order module and an online product module, and after the authorization of the store is completed, the online product module can import the online product information of the authorized store; the online product information from the authorized stores can be synchronously recorded in the online product module and used as local basic information; the local basic information comprises local product price, the online product information of the authorized shop comprises online product price, and the online product price which is synchronized and recorded on the online product module for the first time can be used as initial data of the local product price. The local base information may include an item number (ASIN), the status of the item (on/off sale), the product name, stock item code (SKU), store site, purchase cost, headway cost, etc. The purchase cost and the head course cost can be manually modified, and the manual modification mode can be that document information in a specific format, such as an EXCEL form in an attachment format, is manually imported, so that the import efficiency of data is improved. The local basic information can be calibrated in time by manually modifying the local basic information, and the data accuracy of the ERP system is improved.

The sales order module is used for managing sales orders of online products of the shop, the sales orders have a shifted state and a pending state, and sales of the products in the sales order module can be valued according to the states of the orders according to a specific sequence so as to achieve estimation of the sales of the products.

As shown in fig. 2, when the sales order is in pending state or other non-settlement state, the value taking method and sequence of the product sales amount are as follows: (S1.1) taking the sales volume of the product as an item price corresponding to the Amazon background Alloder report; (S1.2) if the sales order is not in the all order report, taking the product amount of the latest order for the product sales; (S1.3) if no order is recently issued, automatically taking the price of the local product in the local basic information.

When the sales order is in the pending state or other outstanding state, one or more of the sales module, financial module, tools module, or data module may calculate a potential order revenue for the sales order based on the product sales amount when calculating the product sales amount, the potential order revenue being an estimate of revenue charge for the pending order or other outstanding order before payment is completed. Therefore, the profit of the sales order (original order) before the settlement is estimated is realized, and the user can see the possible income brought by the original order when the order is just started.

Further, in an embodiment, the authority management module may be configured to manage the authority of the store, and manually input a corresponding basic tax rate according to attributes of sites of the store located in different countries and regions, where the basic tax rate may be used to estimate corresponding commodity taxes of the sales order when the sales order is in a pending state or other unsettled states, so as to improve accuracy of data of the e-commerce ERP system. One or more of the sales module, financial module, tools module, or data module may calculate an estimated tax for a sales order in pending or otherwise unsettled status based on the base tax rate. If the operator managing the ERP system does not input the base tax rate at the rights management module, the base tax rate defaults to zero. When one or more of the sales module financial module or the data module calculates the expected tax of the sales order in pending state or other unsettled state, whether the base tax rate is zero or not is verified in advance; if the base tax rate is zero, the ERP system prompts the operator to pre-input the base tax rate of the corresponding store site.

In other embodiments, the online product module may further include a price adjusting module, and the price may be further adjusted based on the local product price through the price adjusting module. The price adjusting mode comprises adjusting the price according to the price percentage, adjusting the price according to the price amount or modifying the price into a fixed price, and the adjusted price data can be used for updating the online product price of the corresponding shop. The local base information may also include the inventory quantity of the goods, which may be manually modified.

In addition, the online product module can synchronously update the online product information of the authorized shop, after the corresponding product is set or the shop is synchronously updated, the local basic information of the corresponding product can be correspondingly updated, and the updated online product information from the authorized shop can be recorded in the online product module again to serve as new local basic information.

As shown in fig. 3, the online product module further has a function of prohibiting synchronization, and when one or more data in the local basic information are set to prohibit synchronization, the local basic information prohibited from being synchronized is not updated due to the product synchronization operation. The on-line product information of the shop may contain some data which does not need to be synchronized, such as data related to expense estimation (such as estimated expense of on-line product manually input, number of products which can be sold, head cost, purchase cost, etc.), and the data of the local basic information is generally more accurate than amazon background data or has no relevant data in amazon background, and the data does not need to be updated synchronously again. The selective setting of the local basic information more accurate than amazon background data to inhibit synchronization can reduce the risk that important local basic data is modified due to synchronization operation.

The online product module also has a function of releasing the forbidden synchronization, and after the local basic information is set to be forbidden to be synchronized, the local basic information which is set before is canceled by setting the forbidden synchronization, so that the modification authority of the local basic information is restored to the initial state.

Before canceling the synchronization prohibition setting, the online product module reminds an operator whether to determine to cancel the synchronization; if the user selects to confirm that the synchronization is canceled, the online product module is switched to an interface for authority verification, and whether the operator has the authority for canceling the synchronization prohibition is judged through the verification of the shop account and the password on the interface for authority verification; if the authority verification passes, the prior prohibited synchronization setting is cancelled; if the authorization verification is not passed or fails, the prior inhibit synchronization continues to be valid. Therefore, the permission level for canceling the prohibited synchronous setting is improved, and the safety of the ERP system data is guaranteed. In other embodiments, the authorization verification may also be added before the inhibit synchronization is set.

The sales order module comprises an order list, the order list summarizes all or part of sales order information under the e-commerce ERP system account, and the sales order information comprises information such as an order number, a shop name, order time and an order state; the sales order information is embodied in a list form, so that more sales order information can be displayed, and the convenience of data viewing is improved. The sales order information also comprises sales income and product amount, wherein the sales income refers to the total amount of the order, and the product amount refers to the sales price of the product; and when the sales order is in a pending state or other unsettled states, the product sum value is the product sales amount of the order in the pending state.

The sales order also comprises a common order and a promotion order, and when the sales order is a promotion order, a corresponding promotion identifier, such as a character of 'promotion', is noted in the column of the order number in the order list, so that another column of the list is avoided being added, and the display space of the sales order is saved.

The sales order information further comprises a refund order, a return order and a change order, the order list has a data screening function, the attributes of the refund order, the return order and the change order are not displayed in the order list in an unscreened state, when the refund order, the return order or the change order are screened, the order list only displays/represents the sales order meeting the screening condition, and a corresponding mark, such as a mark 'refund', 'return' or 'change' word, is remarked in a column of the order number in the order list. Through the screening operation, the order attributes which are not displayed in the non-screened state of the order list are reflected in the screened order list. Compared with a conventional screening mode, the screening mode can enable the order list to display more order information in a limited display area. The formats of the horizontal information and the vertical information can be readjusted by the screened order list, so that the data related to the screening conditions can be more visually displayed by the screened order list. The screening scheme displays the screening result in a mode of redrawing the order list, and can quickly convert the numerous and complicated order list into data which preferentially reflects the relevant screening conditions.

In an embodiment, the e-commerce ERP system of the present application further has a list interface switching function, one or more functional modules of the system have corresponding list interfaces, and the list interfaces are used for displaying field information of the corresponding functional modules. The list interface comprises a list display window and a screening tool, the list display window comprises a list and a self-defined column tool, and the list comprises a plurality of longitudinal columns and at least one transverse row;

the vertical column is used for displaying field information (including field names and corresponding data, as shown in fig. 6, the vertical column has a plurality of columns including X1, X2-Xn, xa, xb), the first row of the horizontal row (e.g., row Y1 in fig. 6) is used for displaying the field names and is used as a header of the list, the other horizontal rows (e.g., rows Y2-Yn in fig. 6) except the header are used for displaying the data of the fields, and the list manages the field information of all products in the corresponding function module.

Each longitudinal column has a corresponding width, the initial width dimension of the list is a fixed value, when the sum of the widths of the plurality of longitudinal columns is greater than the initial width dimension of the list, the list automatically generates a sliding bar in the width direction, and the sliding bar can slide left and right and extend the width dimension of the list, so that the list can display more longitudinal columns, namely more field information.

Each horizontal row and column has a corresponding height, the initial height size of the list is a fixed value, when the sum of the heights of the multiple horizontal rows is greater than the initial height size of the list, the list can automatically page the horizontal rows exceeding the height, so that the sum of the heights of all the horizontal rows under each page is equal to or less than the initial height size of the list, each page has a corresponding page number identifier, and the selection of the corresponding page number identifier can jump to the corresponding product field page. The screening tool can set screening conditions, and according to the set screening conditions, the list can automatically display transverse rows and columns meeting the conditions so as to conveniently view the number of the transverse rows and the corresponding field information.

The user-defined column tool comprises a field selection tool and a field sorting tool, the field selection tool collects all field names of the corresponding functional modules, the field names are further grouped according to a fixed column and a non-fixed column, and selectable fields in all the field names of the functional modules are respectively arranged in the fixed column and the non-fixed column; if the function module contains the non-selectable item field, setting the non-selectable item field in a fixed column; the non-selectable field is the field in the list that defaults to the selected state.

The longitudinal rows in the fixed row keep fixed positions when the sliding strip slides, and the longitudinal rows in the non-fixed row correspondingly change positions when the sliding strip slides. As shown in FIG. 6, the vertical columns X1, X2, xa and Xb can be fixed columns, X3-Xn are non-fixed columns, and when the slide bar is slid, the vertical columns X1, X2, xa and Xb are kept fixed, and the vertical columns X3-Xn are shifted correspondingly to slide along with the slide bar.

After the selectable item fields are selected in the field selection tool, the selected fields in the non-fixed columns can be automatically added into the field sorting tool and are arranged in the display interface of the field sorting tool from top to bottom, the positions of the fields are dragged up and down, and the positions and the sequence of the fields in the non-fixed columns can be correspondingly adjusted, wherein the vertical column corresponding to the field positioned at the top is arranged at the leftmost side of the non-fixed columns, and the vertical column corresponding to the field positioned at the bottom is arranged at the rightmost side of the non-fixed columns; that is, the fields displayed in the field sorting tool display interface in the top-to-bottom order are arranged in the non-fixed column in the left-to-right order. The vertical columns of the list only show the vertical column of the selected field name and the vertical column of the system default to the selected state. Through nimble adjustment field order and position, can concentrate quick demonstration with important field information to improve the visibility on list interface, compromise easy and simple to handle and the succinct advantage of field data display.

When setting the field selection tool, if the number of the selected selectable item fields is less, so that the sum of the widths of the plurality of vertical columns displayed by the list is smaller than the width size of the list, the widths of the plurality of vertical columns are automatically increased, and the sum of the widths of the plurality of vertical columns is equal to the width size of the list; so that a plurality of longitudinal columns are arranged uniformly in the list. The width of the longitudinal columns can be adjusted, and the width of the corresponding longitudinal column can be adjusted by dragging the boundary line between two adjacent longitudinal columns; for example, by dragging the boundary line between the longitudinal columns X3 and X4 in fig. 6, the width dimension of the longitudinal column X3 is increased or decreased accordingly.

In an embodiment, the number of the plurality of fields of a certain functional module may be set to a fixed value, for example, only 6 fields of the plurality of fields are displayed in the list, and when the selected field names reach 6 fields, the custom column tool may uniformly lock the remaining selectable fields to an unselected state, so as to prevent an operator from continuously selecting other fields, thereby saving the selection time and taking into account the advantages of simple operation and concise interface.

Further, when the field data in the list exceeds 200 characters, the system automatically filters the characters beyond 200 characters to make the field data in the list more brief so as to improve the visibility of the list interface.

Furthermore, if the list has a plurality of pages, when the user inputs information on the current page and switches to another page, the list can keep the input information of the current page, and the input information is prevented from being lost.

Furthermore, when the user-defined column tool sets the column which is wanted to be displayed, the currently stored column is displayed by default, and repeated selection of field types or repeated reading and setting of the user-defined tool are avoided.

Furthermore, one or more vertical columns in the list are provided with an ascending tool and a descending tool, when the ascending tool of a certain vertical column is selected, a plurality of transverse rows are arranged in an ascending order according to the field data of the vertical column, and when the descending tool of a certain vertical column is selected, a plurality of transverse rows are arranged in a descending order according to the field data of the vertical column.

Further, when all fields of the function module include the ASIN and the MSKU, the ASIN and the MSKU are combined in the same vertical column to display corresponding field information. When all fields of a function module include profit and profit margin, the profit and profit margin are merged to display the corresponding field information in the same vertical column. That is, two or more fields close to each other in the plurality of fields of the function module may be merged in the same vertical column to display the corresponding field information thereof, so as to reduce the number of the vertical columns and make the data display more centralized.

In one embodiment, the fields of the function module include a plurality of primary fields, each primary field has one or more secondary fields, the primary field or the secondary field is used as a header of the list, and the header has a field switching function. When a certain primary field is selected to be switched, all the unfixed columns of the table are automatically switched to new longitudinal columns, and the head fields of the new longitudinal columns are all the secondary fields under the selected primary field. When a certain secondary field is selected to be switched, all the unfixed columns of the table are automatically switched into a new longitudinal column, and the header fields of the new longitudinal column are all the primary fields. The list is automatically switched through the field hierarchical relation, multiple fields with functions are prevented from being selected one by one, the data screening and switching efficiency is improved, and field information of the header does not need to be set one by one.

In one embodiment, the purchasing module has a corresponding list interface, the list interface of the purchasing module is a purchase order, the list of the purchase order further comprises an independent prompt window, and the prompt window displays and records the number of the urgent purchase orders. And selecting a prompt window of the urgent purchase order, and automatically switching and displaying all urgent purchase orders in a list of the purchase orders. The urgent purchase order is particularly important information in the purchase order and is displayed in a separate window, namely, an independent prompt window is further added on the basis of the structure of the longitudinal columns and the transverse rows of the list, and compared with the conventional list, the management priority of the list field information is improved, and the visibility of a list interface is improved. The purchase order list records all pending orders, completed and cancelled purchase orders. One or more purchase orders in the purchase order list are selected, corresponding combined purchase orders can be printed, and the total number of commodities, the purchase quantity, the freight charge and the total amount in the selected purchase orders are automatically calculated through the combined purchase orders.

In one embodiment, the sales module includes an online product module having a corresponding listing interface, the listing interface of the online product module being an online product listing.

The fields of the online product module comprise product sale state, pictures, ASIN, MSKU, operation, FNSKU, product name, SKU, shop, site, price, estimated cost, sales volume, purchase cost and head cost, wherein the sale state, the pictures, the ASIN, the MSKU and the operation fields are fixed columns of the online product list, the sale state, the pictures, the ASIN and the MSKU fields are arranged on the left side of the online product list, and the operation fields are arranged on the left side of the online product list; the FNSKU, product name, SKU, shop, site, price, estimated cost, sales volume, purchase cost and head cost fields are non-fixed columns of the online product list, and the non-fixed columns are arranged in the middle of the online product list to improve the visibility of the list interface. The predicted cost represents the predicted cost of each sold commodity, the predicted cost is automatically synchronized according to the sequence and only synchronizes products which are shelved or have bills in the current month and the first three natural months, and manual synchronization is not limited.

In one embodiment, a profit trial tool is arranged in the longitudinal column corresponding to the operation field, the profit trial tool comprises a profit trial module, and the profit trial module can acquire background data of a shop or local data of an e-commerce ERP system according to a preset logic to automatically calculate gross profits of products. Each field of the profit trial calculation module is preferentially valued from background data of the shop, and when one or more interfaces corresponding to each field of the profit trial calculation module fail to take values, the field failing to take values further takes values of local data of the e-commerce ERP system, as shown in fig. 4 and 5.

And a synchronous product tool is arranged in the vertical column corresponding to the operation field, and is used for synchronizing basic information of the local product and the online product. And a pairing releasing tool is also arranged in the vertical column corresponding to the operation field and is used for releasing the pairing of the local product and the online product.

In the commercial e-commerce ERP, the local basic information in the online product module is mainly input by the synchronous store import of the e-commerce platform, so that the system is more suitable for batch automatic operation and is convenient for an ERP system to automatically manage more stores. In practical use, the probability that amazon returned products cannot be sold is higher, but a small part of cost is available, so that the ERP system of the application also supports manual modification of local basic information of return orders according to practical situations, and the product inventory quantity, logistics cost and sales price of the return orders can be modified.

In other embodiments, for an invoice payment order in a sales order, since the settlement period of the invoice payment order is long, even if the order is changed into a shifted state, as long as the order is not settled, the system cannot obtain a real numerical value, before the order is settled, the ERP system of the present application still obtains the value of the order in the pending state, and after the payment is settled, the fee data is updated. The Invoice order refers to an order with an Invoice as a payment mode (PBI for short), and the Invoice order is a new payment mode introduced by amazon, and allows a customer to delay payment of the order money, namely a payment mode for goods on credit. With invoice payment, an amazon business purchasing mall buyer meeting the requirements can purchase goods at amazon and obtain a bill invoice for the order.

The authority management module is also provided with an exchange rate setting interface, the exchange rate setting interface comprises a main currency and a plurality of auxiliary currencies, each auxiliary currency has an official exchange rate and a my exchange rate relative to the main currency, the official exchange rate is an official exchange rate value acquired from the internet at a corresponding time, and the my exchange rate is a manually input exchange rate value. The official exchange rate can be a converted price of the foreign exchange quotation of 'Chinese Union of silver' which is updated once a day in the morning, and the historical data is the exchange rate of the first day in the month. After setting the rate, the rate of my exchange in the current month will remain unchanged, and the rate in the next month will be initialized as the official rate. The exchange rate setting interface also has an automatic synchronization function, the automatic synchronization function has two states of opening and closing, and when the automatic synchronization function is set to be in the opening state, the my exchange rate at the beginning of each month can be automatically synchronized to be the official exchange rate; when set to the off state, my exchange rate will remain unchanged unless modified by a human.

The exchange rate setting interface is also provided with a synchronous official exchange rate module, the month time and currency needing to be synchronized are selected on the synchronous official exchange rate module interface, and after the synchronization is set, the my exchange rate of the selected month can be kept consistent with the official exchange rate. By setting the exchange rate setting interface, the use requirements of scenes such as manually input exchange rate, automatically synchronizing official exchange rate, synchronizing official exchange rate at specific time and the like can be met. The exchange rate setting interface is also provided with a time display window, and the time display window displays the latest official exchange rate updating time, so that the operator is better reminded of the acquisition time of the exchange rate data.

In an embodiment, the e-commerce ERP system of the present application further has a product profit trial calculation function, and a profit trial calculation module (which may also be referred to as a profit trial calculation tool) is correspondingly disposed. As shown in fig. 4, the profit trial module may obtain the background data of the store or the local data of the e-commerce ERP system according to a predetermined logic for calculating the gross profit or the gross profit margin of the product; and when one or more interfaces corresponding to the fields of the profit trial calculation module fail to take values, the fields failing to take values further take values of local data of the e-commerce ERP system.

When data values of products (also called local products or local commodities) used for calculating gross profits are taken, the products have a scene A, a scene B and a scene C, wherein the scene B refers to a scene where the products have MSKU (the scene B can be understood as a scene where local products have already been paired with store online products and corresponding field information of the online products can be obtained according to the MSKU), the scene C refers to a scene where the products have SKU (the scene C can be understood as a scene where the local products have not been paired with stores and corresponding field information of the local products can be obtained according to the SKU), and the scene A refers to a scene where the products do not have MSKU and SKU (the local products under the scene A can be understood as new products or products ready for shelving and no sales records before, and at the moment, profit trial calculation tools under the scene A are mainly used for pricing new products); and when taking values, each field of the profit trial calculation module follows corresponding logic according to the scene A, the scene B and the scene C, and each field takes values according to the sequence of the scene B, the scene C and the scene A, so that the field data can be acquired and the accuracy of the data is considered.

The fields of the profit calculation module may include one or more of country, exchange rate, delivery type, product size unit, weight unit, item type, buyer shipping cost, purchase cost, type of headway charge, headway logistics for headway charge, headway Cheng Fei, platform cost, warehouse cost, delivery cost, reporting price, VAT tax, tariff tax rate, advertising cost, promotional cost, assessment cost, return cost, and other costs. Wherein the country field is used to calculate the units of exchange rate and cost; the cost of the product is the sum of the purchase cost, the head trip cost and the tariff cost when the delivery type is FBA, and the cost of the product is the sum of the purchase cost and the tariff cost when the delivery type is FBM; the product type, size, weight and unit field are used for calculating head cost, platform cost, storage cost and delivery cost; the initial program cost can be calculated by the system according to the charging mode of the initial program cost, the type of the initial program cost and the initial program logistics field data of the initial program cost, and can also be manually input; and selecting the commodity class according to the classification of the E-commerce platform. The logic of values of the fields of the profit calculation module is as follows (table 1).

TABLE 1

The value logic and corresponding description of each field of the profit trial calculation module in table 1:

(1) And when the value logic is a C scene, the country field value is from the site country corresponding to the selected SKU (at the moment, the country field can not be switched), and when the value logic is an A or B scene, the country field value is from each site country of Amazon.

(2) Exchange rate: the exchange rate field sets the exchange rate of the latest month of the interface, preferentially takes my exchange rate, and takes the official exchange rate if the my exchange rate is null.

(3) Delivery type: and when the value logic is a B scene, the delivery type field value is from the delivery type corresponding to the selected MSKU, and when the value logic is an A or B scene, the delivery type field value is from the manually selected FBA or FMB.

(4) The size of the commodity: and when the value logic is the scene A, the commodity size field takes the manually input data, when the value logic is the scene B, the commodity size field takes the data acquired through the Amazon calculator interface, and when the value logic is the scene C, the commodity size field takes the commodity specification data of the SKU.

(5) Unit of size of the commodity: when the value logic is a scene A, the commodity size unit takes manually selected cm or in, when the value logic is a scene B, the commodity size unit takes data (the unit cannot be switched) acquired through an Amazon calculator interface, and when the value logic is a scene C, the commodity size unit takes the commodity specification unit of the SKU information.

(6) Weight: and when the value logic is the scene A, the weight field takes the manually input data, when the value logic is the scene B, the weight field takes the data acquired through the Amazon calculator interface, and when the value logic is the scene C, the weight field takes the commodity weight of the SKU information.

(7) Weight unit: when the value logic is an A scene, the weight unit takes manually selected kg or Ib, when the value logic is a B scene, the weight unit takes data (the unit cannot be switched at this moment) acquired through an Amazon calculator interface, and when the value logic is a C scene, the weight unit takes commodity weight data (namely local data of an ERP system, the unit is converted into kg at this moment) derived from SKU information.

(8) The freight fee of the buyer: and when the value logic is an A or C scene, the buyer freight field takes the manually input data, and when the value logic is a B scene, the buyer freight field takes the data acquired through the Amazon calculator interface.

(9) And (3) purchasing cost: and when the value logic is the scene A, the purchase cost field takes the manually input data, when the value logic is the scene B, the purchase cost field takes the purchase price of the stock list of the SKU matched with the MSKU, if the purchase price is empty, the purchase cost field takes the purchase cost of the commodity, and when the value logic is the scene C, the purchase cost field takes the purchase cost of the SKU information.

(10) Charging mode of head course charge: and when the value logic is A, B or C scene, the charging mode field value of the head program cost is manually selected according to the charging weight, the real weight or the volume weight.

(11) Type of head end cost: when the value logic is A, B or C scene, the type field value of the head program cost is manually selected, the system head program logistics is used, and the head program cost is calculated or customized according to unit price, wherein the customized head program cost is obtained by manually inputting data, when the value of the head Cheng Fei field fails, the head program cost is emptied to be a default value, and the unit defaults to be USD.

(12) First pass logistics for first pass costs: when the value logic is A, B or C scene, the head course logistics value system of the head course cost carries the head course logistics name.

(13) Platform cost: when the value logic is A, B or a C scene, after the sale price, the weight and the size of a commodity are input, the platform Fei Quzhi calls refrarefee data acquired by an Amazon calculator interface.

(14) Storage fee: when the value logic is A, B or C scene, after the weight and the size of the commodity are input, the warehouse Fei Quzhi calls the storageFee data acquired by the Amazon calculator interface.

(15) And (4) distribution fee: when the value logic is A, B or C scene, after the weight and size of the commodity are input, the delivery Fei Quzhi calls the pickAndPackFee data acquired by the amazon calculator interface (in the embodiment of other platforms, the platform fee, the storage fee and the delivery fee are calculated according to the charging standard of the corresponding platform or directly acquired from the corresponding background interface data).

(16) And (3) applying quotation: when the value logic is A, B or C scene, if the commodity list in the commodity module has a filling customs declaration unit price, declaring a price value customs declaration unit price; otherwise, the quote value is zero or null.

(17) VAT tax: when the value logic is A, B or C scene, VAT tax is equal to the sale price (VAT tax rate/(1 + VAT tax rate)), wherein the VAT tax rate takes the base tax rate in the authority management module.

(18) Tariff: when the value logic is A, B or the C scene, the tariff is equal to the quote price/tariff tax rate, wherein the tariff tax rate is the tariff rate filled in the commodity attribute information of the commodity module.

(19) And (3) advertising fee: when the value logic is A, B or C scene, the advertisement fee field takes the manually entered data.

(20) And (4) popularization fee: and when the value logic is A, B or C scene, the promotion fee field takes the manually entered data.

(21) Evaluation fee: and when the value logic is A, B or C scene, the evaluation field takes the manually entered data.

(22) And (4) returning goods fee: and when the value logic is A, B or C scene, the return charge field takes the manually-entered data.

(23) Other costs: when the value logic is A, B or the C scenario, the other charges field takes the manually entered data (the other charges may be other one or more non-statistical charges for the order or store dimensions that are shared on each product as other charges to be accounted for in the product's profit).

In addition, the profit trial module may also include a sales price, profit margin, profit, or ROI (i.e., input-to-output ratio) field. When the delivery type of the commodity is the FBA mode, ROI = profit/(purchase cost + head cost + tariff cost); when the delivery type of the goods is the FBM mode, ROI = profit/(procurement cost + tariff charge).

When the value taking of each field of the profit trial calculation module fails, the default value of the corresponding field in the value table 1 is taken; a value with a default value of null indicates a value calculated as zero. When the ERP system is changed from an amazon management platform to other E-business platforms, relevant field data refer to field data values of the amazon platform.

The amazon calculator referred to in table 1 is a revenue calculator provided by the amazon platform, and the amazon calculator can calculate data such as commission, delivery fee, warehousing cost, value-added tax fee and the like of the platform in advance according to information such as store sites, product sizes, weights, sales prices, commodity classifications and the like (for other e-commerce platforms, the data are calculated according to fee collection rules such as platform commission, delivery fee, warehousing cost fee and the like correspondingly). The profit trial calculation module integrates the calculation logic of the amazon calculator through the preset field value logic, so that various expenses expected to be generated by the product can be automatically calculated in advance, and then the profit, the profit margin and the selling price can be further calculated; the method has the advantages that the condition that operators count product attribute data one by one is avoided, and the manual operation of the Amazon platform is realized, so that the profit calculation efficiency is greatly improved, the manual calculation error is also avoided, the profit trial calculation result is close to the profit after the actual completion of the order as much as possible, and the calculation accuracy of the system is improved.

In other embodiments, the fields in Table 1 may be further divided into finer fields, such as dividing advertising fees into multiple types of advertising fees; or combining a plurality of fields into one field, such as combining advertisement fee and promotion fee into advertisement fee; that is, the fields in table 1 are only for convenience of summarizing the costs incurred in the product sales process as a whole, and are not limited to specific costs.

As shown in table 1 and fig. 5, for the value sequence of the same field in the profit calculation module, the value sequence is as follows:

(1) s2.1: firstly, judging whether the value of a product field is a B scene, if so, taking the value of the corresponding field according to the field logic of the B scene, otherwise, taking the value according to S2.2; (2) s2.2: further judging whether the value of the product field is a C scene, if so, taking the value of the corresponding field according to the field logic of the C scene, otherwise, taking the value according to S2.3; (3) s2.3: further judging whether the value of the product field is in a scene A, if so, logically taking the value of the corresponding field according to the field of the scene A, otherwise, taking the value according to S2.4; (4) s2.4: the default value of the product field is valued.

The gross profit (which may be collectively referred to herein as profit) and/or the gross profit margin (which may be collectively referred to herein as profit) of the profit calculation module is calculated from the sales price, the buyer's freight, the purchasing cost, the top Cheng Fei, the platform fee, the warehousing fee, the delivery fee, the VAT tax, the customs duty, the advertisement fee, the promotion fee, the evaluation fee, the return fee, and other fees, wherein the gross profit = the income-cost; gross profit margin = (income-cost)/income, income = sale price + buyer transportation charge, cost = purchase cost + head Cheng Fei + platform charge + warehouse charge + delivery charge + VAT charge + tariff + advertising charge + promotion charge + assessment charge + return charge + other charges. The profit trial calculation module can be used as a tool for pricing new products, adjusting prices of online products or adjusting prices when data is abnormal, and the profit trial calculation module helps to save time and labor in operation; the system automatically completes the conversion of units, size units and weight units with different costs, avoids the manual calculation error, improves the operation convenience of the ERP system and enables the data to be more accurate. That is, the profit trial calculation module can multidimensionally accurately calculate amazon's cost expense, helps the seller to estimate commodity pricing more accurately.

Further, after the profit trial module calculates the initial gross profit and/or the gross profit margin, the selling price, the gross profit or the gross profit margin may be manually modified. When the target sale price is manually input, the profit trial calculation module can automatically calculate new gross profit or gross profit rate according to the field value logic. When the target gross profit is manually input, the profit trial calculation module can automatically calculate a new sale price or gross profit rate according to the field value logic. When the target gross profit margin is manually input, the profit trial calculation module can automatically calculate new sale price or gross profit according to the field value logic. The data among three revenue indexes of the sales price, the gross profit and the gross profit margin are mutually linked, the numerical value of one revenue index is modified, the numerical values of the other two revenue indexes can be linked based on the value logic of each field in the profit trial calculation module, and an operator can flexibly set the price according to the target sales price, the target gross profit or the target gross profit margin, so that the operator or a shop manager can conveniently implement new product pricing or adjust the price of an online product, and the operator can know the profit condition of the product in advance before the payment of the sales order is not completed. Namely, the profit trial calculation module supports bidirectional inversion calculation of price and profit rate, and commodity pricing strategies are optimized better.

When one of the data of the product type, the weight, the size and the price is changed when the profit is calculated through the sale price, the profit trial calculation module requests an interface for Amazon to capture the data (such as storage cost, transportation cost and platform cost) again. When one of the grade, size and weight is changed when the sales price is calculated through profit or profit rate, the profit trial calculation module will request the interface for Amazon to capture data (such as storage cost and transportation cost) again, and the platform cost is calculated through the ERP system.

The profit trial calculation module can include two kinds of forms of first profit trial calculation module and second profit trial calculation module, and first profit trial calculation module sets up in online product module, can transfer first profit trial calculation module from online product module to can go to adjust the selling price of online product through the condition of profit and profit margin. The second profit trial calculation module can set up the product analysis module in the data module, can transfer the second profit trial calculation module from the product analysis module to when product data is unusual, the accessible is seen profit and is judged whether can go the adjustment commodity price. The second profit trial calculation module can be arranged on the tool module, and the second profit trial calculation module can be called from the tool module, so that the selling price of the online product can be adjusted through the condition of profit and profit margin. The first profit trial calculation module corresponds to a scene A of the profit trial calculation module data values, and the second profit trial calculation module corresponds to a scene B and a scene C of the profit trial calculation module data values. That is, the profit trial calculation module has a plurality of entries, and the problem that can solve at every entry is also different, can fetch the use at any time, and it is very convenient to use.

The profit calculation module may further include a search tool (or called a screening tool) by which products requiring calculation of profit, profit margin or sale price can be selected by their MSKU, SKU, ASIN, FNSKU or product name. Each field and the corresponding value of the profit trial calculation module can be displayed on a display interface of the profit trial calculation module. When a certain product is selected through the search tool, the value of each field of the product can be automatically updated at the corresponding display position, so that the situation that an operator manually searches and inputs related field data or information is avoided, and the efficiency of the trial calculation is improved. After the profit of the product is calculated, the selected product can be removed through the search tool, and after the selected product is removed, the profit, profit margin or selling price of the next product can be calculated continuously.

The profit trial calculation module can also comprise a result display interface, and after the profit trial calculation of the product is completed or the price adjustment is completed, the total income, the total expenditure, the gross profit rate, the ROI value and the corresponding units can be displayed on the result display interface, so that the income indexes of the product are displayed in a concentrated manner, and the better pricing, price adjustment and management of operators are facilitated.

In one embodiment, the product analysis module comprises a product analysis list summarizing cost information for all or a portion of the sales orders, the cost information comprising profits and profit margins automatically calculated by the profit auditor module; when the data of the profit or the profit margin is negative, the negative data is marked with red color so as to better give a better mind to operators to adjust the price or the sales strategy in time. That is, when the product data is found to be abnormal, it is possible to judge whether the price of the product needs to be adjusted by checking the profit.

When the profit trial calculation module takes the selling price, the profit trial calculation module can take the value according to the specific sequence of S1.1, S1.2 and S1.3 in FIG. 2, namely: firstly, taking a value as an item price corresponding to the amazon background all order report; if the sales order does not exist in the all order report, the product sales price takes the product amount of the latest order; if no order has been made recently, the local product price in the local basic information is automatically valued.

In one embodiment, the profit trial module further includes a trial template, and each field data of the profit trial module may be stored in the trial template. When the field data of the profit trial calculation module is fixed, the field data can be additionally stored as a trial calculation template, and then the approximate trial calculation template can be selected to quickly fill in trial calculation information; the existing trial calculation template can be continuously edited, and the addition, deletion, storage and use of the trial calculation template are supported. Thereby improving the data entry efficiency of the profit trial calculation module. In addition, when one or more of the size, the weight, the freight charge of a buyer, the purchasing cost, the advertising fee, the promotion fee, the evaluation fee, the return fee and other fees of the commodity are manually input into data, the manually input data can be synchronized with the commodity attribute of the local commodity, the manual input one by one is avoided, and the operation efficiency is improved. The advertisement fee, the promotion fee and the evaluation fee can be data which can be manually input by values, and can also be corresponding data imported from a related platform report or a data interface.

In an embodiment, the e-commerce ERP system further has an operation management function, and is correspondingly provided with an operation management module and a data billboard. The operation management module comprises an operation plan, an operation to-do and an operation note.

The operation plan module is used for creating and managing operation plans, each operation plan is created based on a corresponding product, and the creation information of each operation plan comprises product information (namely commodity information, including information of products ASIN, MSKU, names of products and the like), an operation plan name, a start date D1 of the operation plan, an end date D2 of the operation plan, an operation target and an operation task, and also comprises shop information (including shop names and site information) and an operation responsible person. As shown in fig. 8, the time between D1 and D2 is the statistical period N (also referred to as the current period) of the operation plan, the creation date of the operation plan is D0, and the end date D2 of the operation plan cannot be later than the creation date D0 of the operation plan.

The operation target is expressed by quantified numerical values, the operation target comprises one or more of a sales index, an advertisement index and an inventory index, an operator can select and set corresponding numerical values of the sales index, the advertisement index or the inventory index as the operation target, and the operation task is decomposed into one or more task items according to the operation target, each task item has a corresponding deliverable, a task state, a task starting time and a task ending time, the deliverable is used as evidence for completing the corresponding task item, for example, the task is 'finished FBA delivery', and the deliverable can be an FBA cargo part number. The task item and the deliverable are both unnecessary filling items, if the deliverable is filled, the corresponding task item needs to be filled, otherwise, an operation error is prompted, such as 'please fill the task item corresponding to the deliverable'; the system automatically checks whether the task theme is repeated with other task themes, and if the task theme is repeated, corresponding prompts are given.

After the operation plan is created, the operation plan is automatically added to the operation to-do module to serve as the to-do operation tasks (operation to do for short) in the operation to-do module, the operation to-do module tracks the progress and the state of each operation task, and the number of the operation tasks required to be processed every day can be counted. When the corresponding operation task is selected, the state of the operation task can be edited, and after the corresponding delivery is submitted, the corresponding operation task can be modified into the finished state; when the operation task needs to be cancelled, after the reason for canceling the remark in the corresponding remark column, the corresponding operation task can be modified into a cancelled state. And if the reason for canceling the operation task is not remarked in the corresponding remark column, prompting to fill out the reason for canceling the operation task by the system.

The operation note module is used for recording relevant information of products or shops in the daily operation process by operators, the data billboard records and displays operation data of the products, and the data billboard can check the completion condition of an operation target at corresponding time; through the combination with the data billboard, a user can perform planned duplication actions through data analysis, and systematic deposition is performed on the operation growth method which accords with the product category and the company scale. The whole operation process forms a closed loop through mutual connection of the operation plan, the operation to be done and the operation notes, the operation data are fed back and recorded in real time, and a user is reminded of timely processing the operation tasks or adjusting the operation method, so that the operation working efficiency is greatly improved.

In one embodiment, as shown in fig. 8, after the operator selects D1 and D2 as the start date and the end date of the operation plan, respectively, the operation plan module may automatically calculate the start date D3 and the end date D4 of the previous period (also referred to as the previous period), where the time of the previous period is earlier than the time of the statistical period, and the time of the previous period is the same as the time of the statistical period. And the product operation data (such as sales volume, order volume, gross profit rate, review, advertisement click volume, exposure, advertisement click rate, order conversion rate, ACOS and other operation data) in the last period is used as a reference for counting the product operation data in the period. D0, D1, D2, D3, D4 and N take the unit of day, N = D2-D1+1= D4-D3+1, and the logic of the start date D3 and the end date D4 of the previous cycle is:

(1) When D0 ≦ D1, D3= D0-N, D4= D3+ N-1;

(2) When D0 > D1, D3= D1-N, D4= D3+ N-1;

the value taking mode can exclude the operation data in the neutral date when the neutral date exists between the creation date D0 of the operation plan and the start date D1 of the operation plan, so that the reference value of the product operation data in the previous period is improved, and the operation index is set more accurately.

In one embodiment, when the operator selects to set the sales index as the operation target, the sales index includes one or more sub-sales indexes of sales, orders, interest rate and review, each sub-sales index having a corresponding calculation manner (e.g., cumulative, 3-day average, 7-day average, 14-day average, 30-day average or historical cumulative, the calculation manner is shown in table 2). The operation plan module may calculate the value of the sub-sales index of the previous cycle in a calculation manner of the sub-sales index and display the calculation result at a corresponding position of the operation plan to be used as a reference for setting the sub-sales index.

When the operator selects and sets the advertisement index as the operation target, the advertisement index includes one or more sub-advertisement indexes in advertisement click rate, exposure, advertisement click rate, order conversion rate and ACOS, each sub-advertisement index has a corresponding calculation mode (the calculation mode is as shown in table 2), and the operation plan module can calculate the numerical value of the sub-advertisement index in the last period according to the calculation mode of the sub-advertisement index and display the calculation result at the corresponding position of the operation plan to serve as the reference for setting the sub-advertisement index.

When the operator selects and sets the inventory index as the operation target, the inventory index comprises one or more sub-inventory indexes of inventory turnover rate, inventory turnover days and shortage days, each sub-inventory index has a corresponding calculation mode (the calculation mode is shown in table 2), and the operation planning module can calculate the numerical value of the sub-inventory index of the last period according to the calculation mode of the sub-inventory index and display the calculation result at the corresponding position of the operation plan to be used as the reference for setting the sub-inventory index.

TABLE 2

As shown in Table 2, the sales metrics may include one or more sub-sales metrics of sales, orders, gross rates, and reviews, the advertising metrics may include one or more sub-advertising metrics of advertisement click rate, exposure, advertisement click rate, order conversion rate, and ACOS, and the inventory metrics may include one or more sub-inventory metrics of inventory turnover rate, number of inventory turnover days, and number of stock out days. The measurement mode of sales, sales volume, order volume, gross interest rate and review (number of comments) is that the higher the data is, the better the data is; the measurement mode of the advertisement click rate, the exposure, the advertisement click rate and the order conversion rate is that the higher the data is, the better the data is, and the measurement mode of the ACOS is that the lower the data is, the better the data is; the inventory turnover rate is measured in a mode that the higher the data is, the better the inventory turnover rate is, and the inventory turnover days and the stock shortage days are measured in a mode that the lower the data is, the better the inventory turnover rate is. ACoS is the percentage of advertisement spending versus advertisement sales over a specified time frame.

For the sub-operation index with the higher data and the better data in the measurement mode, the calculation formula of the achievement rate is as follows: achievement rate = actual performance/target performance 100%; for the sub-operation index with the measurement mode of lower data and better data, the calculation formula of the achievement rate is as follows: achievement rate = (2-actual performance/target performance) × 100%; the larger the numerical value of the achievement rate is, the higher the conformity degree is, the achievement goal is that the achievement rate is greater than or equal to 100%, the limit value of the achievement rate is 100% at most and 0% at least, and when the numerical value of the achievement rate exceeds the limit value, the limit value is taken. The achievement rates of the two measurement modes are unified, so that the increase and decrease conditions and the conformity degree of the operation indexes can be conveniently judged by all the indexes according to the data size of the achievement rates.

In table 2, the accumulation calculation method refers to an accumulated number in a selected time, but the review number is calculated as a value-history accumulated number.

Furthermore, a new operation task can be added to the operation pending module, or an existing operation task can be deleted. When the operation backlog is added in the operation backlog module, the newly added operation backlog can be independently associated with the ASIN or the associated operation plan of the product, or not associated with the product and the operation plan. When the operation notes are added to the operation note module, the newly added operation notes can be individually associated with the ASIN of the product or the associated operation plan, or are not associated with the product and the operation plan. That is, the operation backlog and the operation note can be created independently, for example, in a new product import stage (without ASIN), and the operation backlog and the operation note can also be created, so that the operation convenience is improved. If the ASIN or the operation plan of the product is related to the operation to be done or the operation notes, the corresponding operation tasks or the corresponding operation notes can be screened through the ASIN or the MSKU and other information of the product in the operation plan, the operation to be done and the operation notes. The operation plan, the operation pending or the operation note support are created according to ASIN, MSKU and FNSKU, and the flexibility of creation is improved.

The operation to-do module summarizes all operation tasks, can display the task state, the delivery, the task starting time and the task ending time of the operation tasks, and can mark the task overdue at the task ending time position when the operation tasks are not overdue, so as to better remind operation operators.

The data billboard is provided with an entrance to be handled in operation and an entrance to be handled in operation, the operation interface (the operation interface is also called as a display interface) of the module to be handled in operation can be switched through the entrance to be handled in operation, the operation interface of the module to be handled in operation can be switched through the entrance to be handled in operation, and operation convenience is improved. In addition, a treasure box is further arranged on the front end page of the ERP system and serves as a global inlet of the ERP system, the treasure box can be arranged at the position of a navigation bar of the front end page of the ERP system, and when interfaces without functional modules are switched, the treasure box is always fixed on an operation interface of the system. The department box is provided with an entrance for handling operation and an entrance for operation notes, the operation to be handled and the operation notes can be created directly through the department box, and the operation convenience is improved.

The operation plan module displays various operation plans in a list form, the list of the operation plans displays the comprehensive achievement rate of the operation target corresponding to the current day, and the comprehensive achievement rate is the achievement proportion of the corresponding operation target. Such as: if an operation target comprises N task items, when only M task items are completed at a certain time, the comprehensive achievement rate of the corresponding operation target at the time is M/N x 100%; the comprehensive achievement rate is the average value of the achievement rates of all the operation indexes in the corresponding operation plan. The comprehensive achievement rate can display the completion progress of the operation task in a progress bar mode, and the numerical value of the comprehensive achievement rate is remarked near the progress bar.

When the operation plan module displays each operation plan in a list form, and when the cursor is placed on the comprehensive achievement rate, the detailed operation index achievement condition is displayed by the bubble floating window.

When the operation task is created, a process reminding date can be set, when the time reaches the process reminding date and the operation task item does not reach the average value of the preset tasks, the operation planning module calculates the average minimum number of tasks required to be completed every day in the remaining completion time, and the calculation result is displayed on a comprehensive achievement rate interface so as to remind an operator to accelerate the processing of the task item.

In an embodiment, the ERP system further comprises a message module, the message module can be arranged at a navigation bar of a front-end page of the ERP system, the message module is provided with a current day to-do reminding window, and the system displays tasks to be handled in the current day to-do reminding window every day and/or tasks to be handled which are overdue in the current day to-do reminding window every day.

The operation interface of the operation to-be-handled module is provided with a list mode and a calendar mode, the states of the operation to-be-handled module can be switched mutually, all operation tasks are collected in a list mode in the list mode state of the operation to-be-handled module, and all operation tasks are collected in a calendar mode in the calendar mode state of the operation to-be-handled module. The calendar mode to be handled in operation takes the whole month as a display interface, the calendar mode is displayed in a box every day, and the total number of operation plans of the day is marked at the lower right corner of the box; the operation tasks are gathered and displayed in the box, and the operation tasks in different states are distinguished in different identification modes, such as: the black font represents to-do in progress, the red font represents to-do not completed after expiration, the gray font represents to-do completed, and the gray strikethrough font represents to-do task cancelled. And when the operation notes exist in a certain day, small dots are identified or other identifications are made under the corresponding date, and the contents of all the operation notes in the day can be displayed by clicking the small dots. Therefore, the operation data can be displayed better, and the operation note information in the corresponding time (including new creation, modification, deletion and the like) can be checked and edited conveniently when the operation is to be done.

Correspondingly, the operation interface of the operation note module is provided with a calendar mode, and the operation notes are collected in a calendar mode in the calendar mode state. The calendar mode of the operation notes takes the whole month as a display interface, the operation notes are displayed in a frame every day, and the total number of the operation notes of the current day is marked at the lower right corner of the frame; operational notes are aggregated and displayed within a box. The calendar mode interface of the operation notes is also provided with a calendar window to be handled, the calendar window takes the whole month as a display interface, the operation details to be handled in the current month are summarized and displayed in the bottom area outside the calendar window, when the operation is to be handled in a certain day, small dots are identified or other identifications are made under the corresponding date, and all the operation contents to be handled in the current day can be displayed by clicking the small dots. Therefore, the operation data can be displayed better, and the operation to-be-handled information in the corresponding time can be checked and edited conveniently when the operation notes are checked.

In an embodiment, the operation management module may only have an operation plan, an operation tool module to be handled, and no operation note module, and may also improve the execution efficiency of the operation plan to a certain extent.

The above description is only a preferred embodiment of the present application, and not intended to limit the scope of the present application, and all equivalent modifications made by the present specification and drawings or directly/indirectly applied to other related technical fields within the inventive concept of the present application are included in the scope of the present application.

Claims

1. An E-commerce ERP system with a profit trial calculation function is used for managing Amazon shops and is characterized by comprising a profit trial calculation module, a commodity module, a sales module and an authority management module;

the profit trial calculation module is used for calculating one or more of three profit indexes of gross profit, gross profit rate and sale price of a product, the profit trial calculation module can manually modify the value of the sale price, the gross profit or the gross profit rate, when the value of one profit index is modified, the values of other two profit indexes can automatically calculate corresponding results based on field value logic of the profit trial calculation module, and the numerical linkage of the three profit indexes is realized;

the profit trial calculation module comprises the fields of country, exchange rate, delivery type, commodity size unit, weight unit, buyer freight, purchase cost, head Cheng Fei, platform cost, warehousing cost, delivery cost, declaration price, VAT tax, tariff rate, advertisement cost, promotion cost, evaluation cost, return cost and other cost, and when calculating the product profit index, the value logic of each field has a scene A, a scene B, a scene C and a default value, wherein the scene B is a scene that the product has MSKU, the scene C is a scene that the product has SKU, the scene A is a scene that the product does not have SKU and SKU, and the sequence of the value of each field is as follows:

(1) S2.1: firstly, judging whether the field value is a B scene, if so, taking the value of the field according to the field logic of the B scene, otherwise, taking the value according to S2.2;

(2) S2.2: further judging whether the field value is a C scene, if so, taking the value of the field according to the field logic of the C scene, otherwise, taking the value according to S2.3;

(3) S2.3: further judging whether the field value is in A scene, if so, taking the field value according to the field logic of the A scene, otherwise, taking the field value according to S2.4;

(4) S2.4: the fields take values by default.

2. The e-commerce ERP system with profit trial calculation function of claim 1, wherein the fields of the profit trial calculation module include the buyer's shipping cost, the purchasing cost, the head Cheng Fei, the platform cost, the warehousing cost, the delivery cost, the bid price, the VAT tax rate, the tariff tax, the advertising cost, the promotion cost, the evaluation cost, the return cost and the other costs, and the value logic of each field is:

(1) The freight fee of the buyer: when the value logic is an A or C scene, the buyer freight field takes the manually input data, when the value logic is a B scene, the buyer freight field takes the data acquired through an Amazon calculator interface, and when the value of the buyer freight field fails, the buyer freight field takes the null as a default value;

(2) And (3) purchasing cost: when the value logic is an A scene, the procurement cost field takes values of manually input data, when the value logic is a B scene, the procurement cost field takes values of procurement prices of SKU inventory lists matched with MSKU pairs, if the procurement prices are null, the procurement cost field takes values of the procurement costs of commodities, when the value logic is a C scene, the procurement cost field takes values of the procurement costs of SKU information, and when the procurement cost field fails, the procurement costs are taken as default values;

(3) Head Cheng Fei: when the value logic is A, B or C scene, the head Cheng Fei is obtained in a manual input mode or a system calculation mode; the head Cheng Fei takes a manually input numerical value in a manual input mode; in the mode of system calculation, one of the charging weight, the real weight or the volume weight is selected as the charging mode of the head program cost, the head program logistics of the system is selected to be used or the head program cost is calculated according to the unit price, and then the system calculates the head Cheng Fei according to the charging mode of the selected head program cost and the type of the head program cost; when the value of the header Cheng Fei field fails, taking null as a default value;

(4) Platform cost: when the value taking logic is A, B or C scene, after commodity selling price, weight and size are input, the platform Fei Quzhi calls data obtained by an Amazon calculator interface, and when the value taking of the platform fee field fails, the platform fee field is emptied to be a default value;

(5) Storage fee: when the value logic is A, B or C scene, after the weight and the size of a commodity are input, the storage Fei Quzhi calls data acquired by an Amazon calculator interface, and when the value of the storage fee field fails, the storage fee field is emptied to be a default value;

(6) And (4) distribution fee: when the value logic is A, B or C scene, after the weight and the size of the commodity are input, the delivery Fei Quzhi calls data obtained by an Amazon calculator interface, and when the value of the delivery expense field fails, the delivery expense field is emptied to be a default value;

(7) And (3) applying quotation: when the value logic is A, B or C scene, if the commodity list in the commodity module has a customs clearance filling unit price, the declaration price value is the customs clearance unit price, otherwise, the declaration price value is null;

(8) VAT tax: when the value logic is A, B or a C scene, the VAT tax is equal to a sale price (VAT tax rate/(1 + VAT tax rate)), wherein the VAT tax rate takes the basic tax rate in the authority management module, and when the value of the VAT tax field fails, the VAT tax field takes a null value as a default value;

(9) Tariff: when the value logic is A, B or C scene, the tariff is equal to the quoted price and the tariff rate, wherein the tariff rate is the tariff rate of the return filled in the commodity attribute information of the commodity module, and when the value of the tariff field fails, the empty is taken as a default value;

(10) And (3) advertising fee: when the value logic is A, B or C scene, the advertisement fee field value is manually input data, and when the advertisement fee field value fails, the advertisement fee field value is nulled to be a default value;

(11) And (3) popularization fee: when the value logic is A, B or C scene, the promotion fee field value is manually input data, and when the promotion fee field value fails, the promotion fee field value is null to be a default value;

(12) Evaluation fee: when the value logic is A, B or C scene, the evaluation field value is manually input data, and when the evaluation field value fails, the evaluation field value is nulled to be a default value;

(13) And (4) returning goods fee: when the value logic is A, B or C scene, the return charge field value is manually input data, and when the return charge field value fails, the return charge field value is emptied to be a default value;

(14) Other costs: and when the value taking logic is A, B or C scene, the other expense field values manually input data, and when the other expense field values fail to take, taking null as a default value.

3. The e-commerce ERP system with profit trial calculation function of claim 1, wherein the right management module further has an exchange rate setting interface including a main currency and a plurality of sub-currencies each having an official exchange rate with respect to the main currency and a my exchange rate, the official exchange rate being an official exchange rate value obtained from the internet at a corresponding time, the my exchange rate being a manually inputted exchange rate value, the fields of the profit trial calculation module including the country, the exchange rate, the delivery type, the size of the good, the weight and the weight unit, and a logic of taking values of the fields:

(1) The state field value is from the site country corresponding to the selected SKU when the value logic is in a C scene, the country field value is from each site country of Amazon when the value logic is in an A or B scene, and the United states is taken as a default value when the country field value fails;

(2) Exchange rate: the exchange rate field takes the exchange rate of the latest month of the exchange rate setting interface, preferentially takes the my exchange rate, if the my exchange rate is empty, takes the official exchange rate, and if the exchange rate field fails to take the exchange rate of the default country as the default value;

(3) The distribution type is as follows: when the value logic is a B scene, the distribution type field value is from a distribution type corresponding to the selected MSKU, when the value logic is an A or B scene, the distribution type field value is from an FBA or an FMB selected manually, and when the distribution type field value fails, the FBA is taken as a default value;

(4) The size of the commodity: when the value logic is a scene A, the commodity size field takes manually input data, when the value logic is a scene B, the commodity size field takes data acquired through an Amazon calculator interface, when the value logic is a scene C, the commodity size field takes commodity specification data of SKU, and when the commodity size field fails to take null as a default value;

(5) Unit of size of the commodity: when the value logic is a scene A, the commodity size unit takes manually selected cm or in, when the value logic is a scene B, the commodity size unit takes the data acquired by an Amazon calculator interface, when the value logic is a scene C, the commodity size unit takes the commodity specification unit of SKU information, and when the value of the commodity size unit field fails, the cm is taken as a default value;

(6) Weight: when the value logic is a scene A, the weight field takes manually input data, when the value logic is a scene B, the weight field takes data acquired through an Amazon calculator interface, when the value logic is a scene C, the weight field takes the commodity weight of SKU information, and when the value logic fails, the weight field takes the empty as a default value;

(7) Weight unit: when the value logic is a scene A, the weight unit value is manually selected kg or Ib, when the value logic is a scene B, the weight unit value is data acquired through an Amazon calculator interface, when the value logic is a scene C, the weight unit field value is commodity weight data derived from SKU information, and when the value logic is failed, the kg is taken as a default value.

4. The e-commerce ERP system with profit trial calculation function of claim 1 further comprising a tool module, the sales module comprising a sales order module and an online product module;

the profit trial calculation module comprises a first profit trial calculation module and a second profit trial calculation module, the first profit trial calculation module is arranged in the online product module, and the first profit trial calculation module can be called from the online product module;

the second profit trial calculation module is arranged in a product analysis module in the data module or arranged in a tool module, and the second profit trial calculation module can be called from the product analysis module or the tool module.

5. The e-commerce ERP system with profit amortization function of claim 4 wherein the product analysis module includes a product analysis listing summarizing cost information for all sales orders including the profits and the profit margins automatically calculated by the profit amortization module; and when the data of the profit or the profit margin is negative, red marks are made on the negative data.

6. The e-commerce ERP system with profit trial calculation function of claim 1, wherein the selling price takes values in a specific chronological order;

firstly, taking a value as an item price corresponding to the amazon background all order report; if the sales order does not exist in the all order report, the product sales price takes the product amount of the latest order; and if no order is recently issued, automatically valuing the local product price in the local basic information.

7. The e-commerce ERP system with profit trial calculation function of claim 1, wherein the profit trial calculation module further comprises a trial calculation template in which each field data of the profit trial calculation module can be stored;

when the field data of the profit trial calculation module is fixed, the field data can be additionally stored as a trial calculation template, and then the approximate trial calculation template can be selected to quickly fill in trial calculation information; the existing trial calculation template can be continuously edited, and the addition, deletion, storage and use of the trial calculation template are supported.

8. The e-commerce ERP system with profit trial calculation function of claim 1, wherein the exchange rate setting interface further has an automatic synchronization function having two states of on and off; when the state is set to be on, the my exchange rate is automatically synchronized to be the official exchange rate at the beginning of each month; when set to the off state, the my exchange rate will remain unchanged.

9. The e-commerce ERP system with profit trial calculation function of claim 8 wherein the exchange rate setting interface further has a synchronization official exchange rate module, at which month time and currency type to be synchronized are selected, and after setting synchronization, my exchange rate of the selected month is kept consistent with the official exchange rate;

and/or the exchange rate setting interface is also provided with a time display window, and the time display window displays the latest official exchange rate updating time.

10. A computer device, characterized in that the computer device comprises a memory, a processor, the e-commerce ERP system with profit trial calculation function as claimed in any one of claims 1 to 9 is stored in the memory, and the processor can run the operation instructions of the e-commerce ERP system with profit trial calculation function.