CN113869987B - A computer system for monitoring commodity prices on an e-commerce platform - Google Patents

Abstract

The present application discloses a computer system for monitoring commodity prices on an e-commerce platform, including: a data acquisition interface for acquiring inventory unit data corresponding to target commodities of different specifications on the e-commerce platform; an operator for dividing the inventory unit data according to the update time of the inventory unit data, obtaining the inventory unit data of different time stages, and calculating the stage average price corresponding to all inventory unit data in each time stage; a configuration interface for assigning corresponding weights to each time stage, and determining the target price of the target commodity using the weights of all time stages and the stage average price; a controller for monitoring the price of the target commodity on the e-commerce platform based on the target price, so as to perform corresponding processing on the target commodity with abnormal price. Through data interaction between the data acquisition interface, the operator, the configuration interface and the controller, the efficiency and accuracy of commodity price monitoring on the e-commerce platform are improved.

Description

A computer system for monitoring commodity prices on an e-commerce platform

Technical Field

The present invention relates to the field of computer technology, and in particular to a computer system for monitoring commodity prices on an e-commerce platform.

Background Art

In e-commerce platforms, there are a lot of different merchants, and the same type of goods are sold by multiple different merchants. The prices of goods sold by each merchant are set by each merchant, and they are relatively independent, which is not conducive to the management of e-commerce platforms. Therefore, it is particularly important to monitor the prices of goods set by each merchant.

The basis for price monitoring is to refer to the market average price of such goods, which is usually the average sales price of all the same goods listed for sale on the e-commerce platform at that moment, or the weighted average calculation of the hot selling price, the highest price, and the lowest price at that time. However, after the merchants put the goods on the shelves, some merchants will not adjust the prices of the goods in time, and even some long-term unsalable goods are on sale without any treatment. Directly incorporating the prices of these goods into the calculation of the market average reference price will inevitably affect the accuracy of this reference price, and unsalable goods have a greater impact on price accuracy. The market average price obtained by the above method without considering this influencing factor is relatively low in accuracy for price monitoring of platform goods. For example, a merchant puts a product A on the shelves. One year after product A is launched, product B is launched. Some merchants reduce the price of the goods, while some merchants do not adjust the price and still maintain the price when it is put on the shelves. In fact, the more representative reference price at this time should be the price after the reduction. If it is simply calculated according to the average transaction price of all the listed sales prices of product A, the real market reference price will be raised.

Therefore, how to improve the efficiency and accuracy of commodity price monitoring on e-commerce platforms is a technical problem that technical personnel in this field need to solve urgently.

Summary of the invention

In view of this, the purpose of the present invention is to provide a computer system for monitoring commodity prices on an e-commerce platform, which can improve the efficiency and accuracy of commodity price monitoring on the e-commerce platform. Specifically, it includes:

The data acquisition interface is used to obtain the inventory unit data corresponding to target products of different specifications on the e-commerce platform;

A computing unit, configured to divide the SKU data according to the update time of the SKU data to obtain the SKU data of different time periods, and calculate the stage average price corresponding to all the SKU data in each time period;

A configuration interface, used to assign a corresponding weight to each of the time stages, and determine the target price of the target commodity of different specifications by using the weights of all the time stages and the average price of the stages;

The controller is used to monitor the prices of the target commodities of different specifications in the e-commerce platform based on the target prices, so as to perform corresponding processing on the target commodities with abnormal prices.

Optionally, the computer system for monitoring commodity prices on the e-commerce platform further includes:

The aggregation port is used to aggregate target commodities of different commodity types and different specifications corresponding to the commodity types in the e-commerce platform according to a preset period.

Optionally, the computer system for monitoring commodity prices on the e-commerce platform further includes:

The first filter is used to filter the inventory unit data whose update time is lower than a first preset threshold to obtain the filtered inventory unit data; wherein the update time is any one or more of the price update time, inventory update time, code update time, and parameter update time of the inventory unit data.

Optionally, the computer system for monitoring commodity prices on the e-commerce platform further includes:

The second filter is used to mark the target commodities of different specifications for validity based on the quantity of the filtered inventory unit data of the target commodities of different specifications.

Optionally, the second filter is further used to determine the quantity of the filtered inventory unit data of the target product of different specifications, and mark the target product of the specification corresponding to the filtered inventory unit data whose quantity is greater than a second preset threshold as valid.

Optionally, the operator comprises:

A first determining module, configured to determine the effective inventory unit data corresponding to the target commodity as target inventory unit data;

The division module is used to divide the target inventory unit data according to the update time of the target inventory unit data to obtain the target inventory unit data in different time stages.

Optionally, the division module is also used to divide the target inventory unit data according to the price update time, inventory update time, code update time or parameter update time of the target inventory unit data to obtain the target inventory unit data in different time stages.

Optionally, the controller includes:

A second determination module is used to determine the difference data between the target price and the prices of the target commodity of different specifications on the e-commerce platform;

The matching module is used to obtain the target commodity with abnormal price according to the threshold range of the difference data, so as to remove the target commodity with abnormal price from the shelves.

Optionally, the computer system for monitoring commodity prices on the e-commerce platform further includes an output interface for outputting and displaying the target commodity with abnormal price.

Optionally, the configuration interface is further used to pre-configure the threshold range according to target monitoring requirements.

In this application, the data acquisition interface is used to obtain the inventory unit data corresponding to the target goods of different specifications in the e-commerce platform; the operator is used to divide the inventory unit data according to the update time of the inventory unit data to obtain the inventory unit data of different time stages, and calculate the stage average price corresponding to all the inventory unit data in each time stage; the configuration interface is used to assign corresponding weights to each time stage, and use the weights of all the time stages and the stage average price to determine the target prices of the target goods of different specifications; the controller is used to monitor the prices of the target goods of different specifications in the e-commerce platform based on the target price, so as to deal with the target goods with abnormal prices accordingly. It can be seen that this application first uses the data acquisition interface to obtain the inventory unit data, and then uses the operator to divide the inventory unit data according to the update time of the inventory unit data and calculate the stage average price corresponding to all the inventory unit data in each divided time stage, and then assigns weights to each time stage through the configuration interface to determine the corresponding target price; finally, the controller is used to monitor the price based on the target price. Through data interaction among the data acquisition interface, operator, configuration interface and controller in the computer system, the efficiency and accuracy of commodity price monitoring on the e-commerce platform are improved.

BRIEF DESCRIPTION OF THE DRAWINGS

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying creative work.

FIG1 is a schematic diagram of a computer system structure for monitoring commodity prices on an e-commerce platform provided by the present application;

FIG2 is a schematic diagram of a commodity aggregation operation provided by the present application;

FIG3 is a schematic diagram of a specific commodity aggregation operation provided by the present application;

FIG. 4 is a specific difference data threshold range provided in this application.

DETAILED DESCRIPTION

The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

The existing basis for price monitoring is to refer to the market average price of this type of goods, but because unsalable goods have a greater impact on price accuracy, the accuracy of price monitoring of platform goods using the market average price obtained by the above method without considering this influencing factor is relatively low. In response to the above technical defects, the present application provides a computer system for monitoring the price of goods on an e-commerce platform. First, a data acquisition interface is used to obtain inventory unit data, and then the inventory unit data is divided according to the update time of the inventory unit data using an operator and the stage average price corresponding to all inventory unit data in each time stage after the division is calculated. Then, a weight is assigned to each time stage through a configuration interface to determine the corresponding target price; finally, a controller is used to perform price monitoring based on the target price. Through the data interaction between the data acquisition interface, the operator, the configuration interface and the controller in the computer system, the efficiency and accuracy of commodity price monitoring on the e-commerce platform are improved.

FIG1 is a schematic diagram of a computer system structure for monitoring commodity prices on an e-commerce platform provided in an embodiment of the present application. Referring to FIG1 , the computer system for monitoring commodity prices on an e-commerce platform includes:

A data acquisition interface 01 is used to obtain the inventory unit data corresponding to target commodities of different specifications in the e-commerce platform; an operator 02 is used to divide the inventory unit data according to the update time of the inventory unit data to obtain the inventory unit data of different time stages, and calculate the stage average price corresponding to all the inventory unit data in each time stage; a configuration interface 03 is used to assign corresponding weights to each time stage, and determine the target prices of the target commodities of different specifications using the weights of all the time stages and the stage average price; a controller 04 is used to monitor the prices of the target commodities of different specifications in the e-commerce platform based on the target prices, so as to perform corresponding processing on the target commodities with abnormal prices.

In this embodiment, the data acquisition interface 01 is first used to obtain the inventory unit data corresponding to the target goods of different specifications in the e-commerce platform. The inventory unit data (SKU, Stock Keeping Unit) is the smallest unit that can clearly define the specifications, prices and inventory of goods in the transaction process. The goods in the usual sense are precisely SKUs. In order to effectively control the background commodity data and quickly find the corresponding inventory unit data, the computer system for monitoring the commodity prices of the e-commerce platform is also provided with an aggregation port, which is used to aggregate the target goods of different commodity types and different specifications corresponding to the commodity types in the e-commerce platform according to a preset period. Through the product specification aggregation action, all the same brand, same model, and same sales specification goods on the e-commerce platform can be regularly aggregated to form the initial basis for price calculation. Among them, the product in the product specification is generally understood as "brand + model", and the specification can be understood as the product specification used for pricing and selling under the product, such as memory capacity, hard disk size, etc. The relationship between the product and the specification is one-to-many, and one product corresponds to multiple product specifications. The relationship between product specifications and commodities is shown in Figures 2 and 3, including but not limited to: there can be multiple different products under one background category, there can be multiple different product specifications under one product, multiple different commodities can be associated with the same product, and multiple different SKUs can be associated with the same product specification.

Furthermore, in order to ensure data accuracy, the computer system for monitoring commodity prices on the e-commerce platform also includes a first filter and a second filter, which are used to clean the acquired inventory unit data, remove SKUs whose price update time is outside the specified threshold, and mark the validity of product specifications to obtain the data finally used to calculate the target price. Specifically, the first filter is used to filter the inventory unit data whose update time is lower than the first preset threshold to obtain the filtered inventory unit data; wherein the update time is any one or more of the price update time, inventory update time, coding update time, and parameter update time of the inventory unit data. For each product specification, its price update time is obtained, and invalid reference price commodities are filtered according to the specified threshold t, such as commodities with a price update time greater than 1 year, in order to reduce the interference of unsalable commodities that have not been updated for a long time on the final reference price.

The second filter is used to mark the validity of the target commodities of different specifications based on the number of the filtered inventory unit data of the target commodities of different specifications. On this basis, the second filter is used to determine the number of the filtered inventory unit data of the target commodities of different specifications, and the target commodities of the corresponding specifications of the filtered inventory unit data whose number is greater than the second preset threshold are marked as valid. Since the number of SKUs is very small, there may be only a few reference commodities, or even only the current reference commodity. At this time, if the reference price is calculated, the error and fluctuation may be very large. Therefore, in order to reduce the error caused by some unpopular commodities in the calculation of the reference price, it is necessary to determine the sample validity. The determination rule is whether the number of remaining SKUs exceeds the specified threshold m, for example 10. If m>10, mark this product specification as a valid sample.

In this embodiment, the operator 02 specifically includes a first determination module and a division module, wherein the first determination module is used to determine the inventory unit data corresponding to the valid target commodity as the target inventory unit data. The division module is used to divide the target inventory unit data according to the update time of the target inventory unit data to obtain the target inventory unit data of different time stages. The division module is also used to divide the target inventory unit data according to the price update time, inventory update time, code update time or parameter update time of the inventory unit data of the target inventory unit data to obtain the target inventory unit data of different time stages. All SKUs on sale associated with product specifications are more accurately divided into three time periods according to their price update time in the remaining SKUs after filtering, for example, the past 3 months, the past 4-6 months, and the past 7-12 months, and the average sales price of each time period is calculated as a, b, and c. It can be understood that in addition to the SKU price update time, it includes but is not limited to SKU inventory update, SKU code update, SKU parameter update, SKU creation time, commodity update time, etc.

In this embodiment, the configuration interface 03 is used to assign corresponding weights to each of the time stages, and use the weights of all the time stages and the average prices of the stages to determine the target prices of the target commodities of different specifications. The configuration interface 03 calculates the weighted average sales price n of the product specifications in a three-stage attenuation weighted manner and records it in the product specifications, and calculates it according to the following formula: n=a*50%+b*30%+c*20%. The core idea is that the prices recently updated and adjusted by the supplier are closer to and reflect the market conditions at this stage than the prices updated in the long term. The longer the price is updated, the weaker its representativeness for the market conditions. It should be noted that the attenuation period in this embodiment is not limited to three sections, but can be 2 sections, 4 ends, 5 ends or even more periods, and the attenuation weight is not limited to the 532 attenuation ratio. For example, attenuation ratios of 721, 631, etc. also belong to the protection scope of the embodiments of this application.

In this embodiment, the controller 04 specifically includes a second determination module and a matching module. The second determination module is used to determine the difference data between the target price and the price of the target commodity of different specifications in the e-commerce platform. The matching module is used to obtain the target commodity with abnormal price according to the threshold range of the difference data, so as to remove the target commodity with abnormal price from the shelves. The platform commodities are price monitored or inspected based on the weighted average transaction price calculated in the above steps, and the abnormal commodity price monitoring results are output. On this basis, the computer system for monitoring the commodity prices of the e-commerce platform also includes an output interface for outputting and displaying the target commodity with abnormal price. The weighted average sales price on the product specifications is used as a reference basis by the second determination module and the matching module to perform a system inspection on all the commodities on sale in the platform. Figure 4 shows several types of pre-set price monitoring and their segmentation thresholds, and of course the threshold range can be flexibly set according to the actual situation. Among them, the difference data z is calculated by comparing the price x of the SKU with the reference price n, which can be expressed as z=x/n, and the commodity SKU is price classified, and then the commodity data of each price segment is output as needed. The embodiments of the present application fully comply with the laws of market fluctuations, effectively improve the accuracy and referenceability of the market average reference price, greatly improve the efficiency of commodity price monitoring, and effectively solve the technical bottleneck of commodity price monitoring difficulties in the e-commerce field.

It can be seen that the data acquisition interface in the embodiment of the present application is used to obtain the inventory unit data corresponding to the target goods of different specifications in the e-commerce platform; the operator is used to divide the inventory unit data according to the update time of the inventory unit data to obtain the inventory unit data of different time stages, and calculate the stage average price corresponding to all the inventory unit data in each time stage; the configuration interface is used to assign corresponding weights to each time stage, and use the weights of all the time stages and the stage average price to determine the target price of the target goods of different specifications; the controller is used to monitor the price of the target goods of different specifications in the e-commerce platform based on the target price, so as to perform corresponding processing on the target goods with abnormal prices. The embodiment of the present application first uses the data acquisition interface to obtain the inventory unit data, and then uses the operator to divide the inventory unit data according to the update time of the inventory unit data and calculate the stage average price corresponding to all the inventory unit data in each divided time stage, and then assigns weights to each time stage through the configuration interface to determine the corresponding target price; finally, the controller is used to perform price monitoring based on the target price. Through data interaction among the data acquisition interface, operator, configuration interface and controller in the computer system, the efficiency and accuracy of commodity price monitoring on the e-commerce platform are improved.

Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the statement "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.

The computer system for monitoring the commodity prices of the e-commerce platform provided by the present invention is introduced in detail above. The principle and implementation mode of the present invention are explained in this article by using specific examples. The description of the above embodiments is only used to help understand the method of the present invention and its core idea. At the same time, for those skilled in the art, according to the idea of the present invention, there will be changes in the specific implementation mode and the scope of application. In summary, the content of this specification should not be understood as limiting the present invention.

Claims (6)

1. A computer system for monitoring a commodity price of an e-commerce platform, comprising:

the data acquisition interface is used for acquiring stock quantity unit data corresponding to target commodities with different specifications in the electronic commerce platform;

the computing device is used for dividing the stock quantity unit data according to the updating time of the stock quantity unit data so as to obtain the stock quantity unit data of different time phases, and calculating phase average prices corresponding to all the stock quantity unit data in each time phase;

The configuration interface is used for distributing corresponding weights for all the time phases and determining target prices of the target commodities with different specifications by utilizing the weights of all the time phases and the average prices of the phases;

The controller is used for monitoring the prices of the target commodities with different specifications in the electronic commerce platform based on the target price so as to correspondingly process the target commodities with abnormal prices;

Wherein, the computer system for monitoring commodity price of the e-commerce platform further comprises:

The first filter is used for filtering the stock quantity unit data with the update time lower than a first preset threshold value to obtain filtered stock quantity unit data; wherein the update time is any one or more of price update time, inventory update time, coding update time and parameter update time of the inventory unit data;

A second filter for validity-marking the target commodity of different specifications based on the number of the stock quantity unit data of the target commodity after the filtering of different specifications;

The second filter is further configured to determine the number of the filtered stock quantity unit data of the target commodities with different specifications, and mark the target commodities with the specifications corresponding to the filtered stock quantity unit data with the number greater than a second preset threshold value as valid;

wherein the operator includes:

a first determining module, configured to determine the inventory unit data corresponding to the valid target commodity as target inventory unit data;

the dividing module is used for dividing the target stock quantity unit data according to the updating time of the target stock quantity unit data so as to obtain the target stock quantity unit data in different time phases.

2. The computer system for monitoring the price of goods on an e-commerce platform of claim 1, further comprising:

And the aggregation port is used for conducting aggregation operation on target commodities of different commodity types and different specifications corresponding to the commodity types in the electronic commerce platform according to a preset period.

3. The computer system for monitoring commodity price for an e-commerce platform according to claim 1, wherein said partitioning module is further configured to partition said target inventory unit data according to a price update time, an inventory update time, a code update time, or a parameter update time of said inventory unit data of said target inventory unit data to obtain said target inventory unit data for different time periods.

4. A computer system for monitoring the price of goods on an e-commerce platform according to any one of claims 1 to 3, wherein the controller comprises:

the second determining module is used for determining difference data between the target price and the prices of the target commodities with different specifications in the electronic commerce platform;

And the matching module is used for obtaining the target commodity with abnormal price according to the threshold range of the difference data so as to take off the shelf of the target commodity with abnormal price.

5. The computer system for monitoring the price of goods on an e-commerce platform of claim 4 further comprising an output interface for output display of the target goods for price anomalies.

6. The computer system for monitoring commodity prices for an e-commerce platform according to claim 4, wherein the configuration interface is further configured to pre-configure the threshold range based on a target monitoring demand.