A computer system for monitoring commodity prices on an e-commerce platform
By obtaining inventory unit data on the e-commerce platform and dividing stages according to the update time, and calculating the weighted average price, the problem of unsold goods affecting the market average price is solved, and the accuracy and efficiency of price monitoring are improved.
Patent Information
- Application Number
- CN202111172572.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2021-10-08
- Publication Date
- 2024-11-05
- Estimated Expiration
- 2041-10-08
AI Technical Summary
The accuracy of commodity price monitoring in the prior art in e-commerce platforms is low, especially the inaccuracy of market average prices caused by unsold goods not being adjusted in time.
By obtaining the inventory unit data of the e-commerce platform, dividing different time stages according to the update time of the data, calculating the average price of each stage, determining the target price based on the weight allocation, and using the controller to monitor and process the price.
It improves the efficiency and accuracy of product price monitoring on e-commerce platforms, reduces the impact of unsold goods on the market average price, and enhances the representativeness of price monitoring.
Smart Images

Figure CN113869987B_ABST
Abstract
Description
Technical Field
[0001] 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
[0002] 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.
[0003] The basis for price monitoring is to refer to the market average price of such goods, which is usually the average selling price of all the same goods listed for sale on the e-commerce platform at that time, 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.
[0004] 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
[0005] 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:
[0006] The data acquisition interface is used to obtain the inventory unit data corresponding to target products of different specifications on the e-commerce platform;
[0007] 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;
[0008] A configuration interface is 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;
[0009] 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.
[0010] Optionally, the computer system for monitoring commodity prices on the e-commerce platform further includes:
[0011] 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.
[0012] Optionally, the computer system for monitoring commodity prices on the e-commerce platform further includes:
[0013] 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, coding update time, and parameter update time of the inventory unit data.
[0014] Optionally, the computer system for monitoring commodity prices on the e-commerce platform further includes:
[0015] 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.
[0016] 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.
[0017] Optionally, the operator comprises:
[0018] A first determining module, configured to determine the effective inventory unit data corresponding to the target commodity as target inventory unit data;
[0019] 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.
[0020] Optionally, the division module is further 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.
[0021] Optionally, the controller includes:
[0022] 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;
[0023] 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.
[0024] 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.
[0025] Optionally, the configuration interface is further used to pre-configure the threshold range according to target monitoring requirements.
[0026] 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
[0027] 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.
[0028] Figure 1 A schematic diagram of the structure of a computer system for monitoring commodity prices on an e-commerce platform provided in this application;
[0029] Figure 2 A schematic diagram of a commodity aggregation operation provided for this application;
[0030] Figure 3 A specific commodity aggregation operation schematic diagram provided for this application;
[0031] Figure 4 A specific difference data threshold range is provided for this application. DETAILED DESCRIPTION
[0032] 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.
[0033] 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.
[0034] Figure 1 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. Figure 1As shown, the computer system for monitoring commodity prices on an e-commerce platform includes:
[0035] 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.
[0036] In this embodiment, the data acquisition interface 01 is first used to obtain the inventory unit data corresponding to the target products of different specifications in the e-commerce platform. The inventory unit data (SKU, Stock Keeping Unit) is the smallest unit that can clearly specify the product specifications, prices and inventory during the transaction process. The product in the usual sense is precisely the SKU. In order to effectively manage and control the background product data, so as to quickly find the corresponding inventory unit data, the computer system used to monitor the product prices of the e-commerce platform is also provided with an aggregation port, which is used to aggregate the target products of different product types and different specifications corresponding to the product types in the e-commerce platform according to a preset period. Through the product specification aggregation action, all products of the same brand, model and sales specification 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 products and specifications is one-to-many, and multiple product specifications correspond to one product. The relationship between product specifications and commodities is as follows: Figure 2 and Figure 3 As shown, 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.
[0037] 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.
[0038] 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.
[0039] 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.
[0040] 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.
[0041] 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 prices of the target products of different specifications in the e-commerce platform. The matching module is used to obtain the target products with abnormal prices according to the threshold range of the difference data, so as to remove the target products with abnormal prices from the shelves. The platform products are price monitored or inspected based on the weighted average transaction price calculated in the above steps, and the abnormal product price monitoring results are output. On this basis, the computer system for monitoring the product prices of the e-commerce platform also includes an output interface for outputting and displaying the target products with abnormal prices. The weighted average sales price of the product specifications is used as a reference by the second determination module and the matching module to perform a system inspection on all the products on sale in the platform. Figure 4 Several types of pre-set price monitoring and their segmentation thresholds are shown. Of course, the threshold range can be flexibly set according to actual conditions. 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. The commodity SKU is price-classified, and then the commodity data of each price segment is output on demand. The embodiment of the present application fully complies with the law of market fluctuations, effectively improves the accuracy and referenceability of the market average reference price, greatly improves the efficiency of commodity price monitoring, and effectively solves the technical bottleneck of commodity price monitoring difficulties in the e-commerce field.
[0042] 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.
[0043] 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.
[0044] 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
1. A computer system for monitoring commodity prices on an e-commerce platform, characterized in that: include: 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 is 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; A controller, configured 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; The computer system for monitoring commodity prices on the e-commerce platform also includes: a first filter, configured to filter the inventory unit data whose update time is lower than a first preset threshold value to obtain the filtered inventory unit data; wherein the update time is any one or more of a price update time, an inventory update time, a code update time, and a parameter update time of the inventory unit data; a second filter, for marking the target commodities of different specifications for validity based on the quantity of the filtered SKU data of the target commodities of different specifications; The second filter is further used to determine the quantity of the filtered inventory unit data of the target commodity of different specifications, and mark the target commodity of the specification corresponding to the filtered inventory unit data whose quantity is greater than a second preset threshold as valid; Wherein, 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.
2. The computer system for monitoring commodity prices on an e-commerce platform according to claim 1, characterized in that: Also 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.
3. The computer system for monitoring commodity prices on an e-commerce platform according to claim 1, characterized in that: 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.
4. The computer system for monitoring commodity prices on an e-commerce platform according to any one of claims 1 to 3, characterized in that: The controller comprises: 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.
5. The computer system for monitoring commodity prices on an e-commerce platform according to claim 4, characterized in that: It also includes an output interface for outputting and displaying the target commodity with abnormal price.
6. The computer system for monitoring commodity prices on an e-commerce platform according to claim 4, characterized in that: The configuration interface is also used to pre-configure the threshold range according to target monitoring requirements.
Citation Information
Patent Citations
Method for monitoring public procurement big data
CN107507075A
System and method for automatically selecting non-real-time advertisements according to time dimensions
CN112488760A
E-commerce price index
US8374907B1
Method and apparatus for pushing effective price tag, computer device, and storage medium
WO2021042824A1
Cited By
E-commerce platform numerical value splitting and price interval dynamic sorting and returning system
CN120634637A
