CN111062756A - Sales data analysis method and system - Google Patents
Sales data analysis method and system Download PDFInfo
- Publication number
- CN111062756A CN111062756A CN201911303140.5A CN201911303140A CN111062756A CN 111062756 A CN111062756 A CN 111062756A CN 201911303140 A CN201911303140 A CN 201911303140A CN 111062756 A CN111062756 A CN 111062756A
- Authority
- CN
- China
- Prior art keywords
- data
- replenishment
- sales
- preset threshold
- time
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
Abstract
The sales data analysis method comprises the steps of obtaining first sales data in unit time, obtaining second user data of registered users, obtaining third commodity data of each type of commodity, generating reference sales data, generating first replenishment data and generating second replenishment data: multiplying the first replenishment data by (1+ a first floating coefficient) and converting into second captured data; and converting the second replenishment data into final replenishment data and outputting the final replenishment data to a server. According to the method and the device, the number of potential users is obtained by judging the number of registered users in the first preset threshold range by the user, the number of the potential users is compared with a second preset threshold with a larger number and a third preset threshold with a smaller number, the third preset threshold is corrected through the first floating coefficient, and final replenishment data which is more fit with the reality is obtained, so that the management level of sales data and the management level of enterprises are improved, and the phenomenon that stock is too much and overdue or out of stock cannot be sold is avoided.
Description
Technical Field
The present invention relates to a big data analysis processing system, and more particularly, to a system for raising management level through analysis processing of sales data.
Background
The sales data, which is generally used for recording sales, may specifically be: sales quantity, sales unit price, total sales amount, gross sales interest rate, sales cost, time of sale, location of sale, etc.
People often neglect to utilize their value with respect to sales data. People can economically determine or predict future sales data by utilizing previous sales data.
But the above data only stay in cold investigation patterns for past data such as: summer is more than the summer and winter is more than the winter.
In the current mobile internet era, more and more users can enable the server to receive more data related to behaviors through mobile phones, and the data related to the behaviors is combined with the past sales data, so that the sales management level is improved, and the mobile internet era is a blank of the current market.
Therefore, there is a need for a sales data analysis method that can combine the user's behavior with the sales data to improve the management level.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a sales data analysis method which can combine the user behavior with the sales data to improve the management level.
The invention relates to a sales data analysis method, which comprises the following steps
Acquiring first sales data in unit time, wherein the first sales data comprise first time data, first position data, first money data, first category data and first quantity data;
acquiring second user data of the registered user, wherein the second user data comprises second quantity data, second time data and second position data;
acquiring third commodity data of each type of commodity, wherein the third commodity data comprises third replenishment transportation time data and third commodity source location position data;
storing first sales data, second user data and third commodity data in each unit time;
generating reference sales data: searching and storing first sales data closest to the current time in first time data of the first sales data, and converting the first sales data into reference sales data;
generating first replenishment data: generating first replenishment data according to the difference value between the first category data and the first quantity data of the reference sales data and the first category data and the first quantity data of the current real-time first sales data;
generating second replenishment data: generating distance data according to first position data of the first sales data and second position data of the second user data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is larger than a second preset threshold value, multiplying the first replenishment data by (1+ a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is smaller than a third preset threshold value, multiplying the first replenishment data by (1-a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is more than a third preset threshold value and less than a second preset threshold value, converting the first replenishment data into second replenishment data;
and converting the second replenishment data into final replenishment data and outputting the final replenishment data to a server.
The invention relates to a sales data analysis method, wherein the distance data is in a circular range formed by taking a first preset threshold as a radius, and the distance data is a linear distance or a navigation distance between first position data of first sales data and second position data of second user data.
The invention relates to a sales data analysis method, which further comprises the following steps after second replenishment data are generated:
generating third replenishment data: generating at least 2 circular rings with the same ring width and a circle with the first radius as the ring width in a circular range formed by taking the first position as the center of a circle and the distance data with the first preset threshold as the radius, and arranging the circular rings and the circle with the first radius as the ring width into an a-th area according to the arrangement of the first position from near to far, wherein the a-bits are non-zero natural numbers arranged from small to large; when the number of the registered users changed into the unconsumed registered user in the area B is larger than that of the registered users changed into the unconsumed registered user in the area B, wherein B is larger than B, the second replenishment data is multiplied by (1+ a second floating coefficient) and is converted into third replenishment data; when the number of the registered users changed from the unconsumed registered user in the area B to the unconsumed registered user in the area B is less than or equal to the number of the registered users changed from the unconsumed registered user in the area B to the unconsumed registered user in the area B, wherein B is more than B, the second replenishment data is multiplied by (1-a second floating coefficient) and is converted into third replenishment data; wherein the larger B is, the smaller the second floating coefficient is;
and converting the third replenishment data into final replenishment data and outputting the final replenishment data to a server.
The invention is a sales data analysis method wherein a second floating factor between regions closer to the first location is greater than a second floating factor between regions further from the first location.
The invention relates to a sales data analysis method, wherein in the step of generating third replenishment data, the method further comprises the following steps:
and according to the sequence number a of the a-th area, generating second floating coefficients of the a-th area and the a + 1-th area according to the following formula: second coefficient of fluctuation ═ e-(a+c)Wherein C is a constant.
The invention relates to a sales data analysis method, wherein the step of searching and storing first sales data closest to the current time in first time data of the first sales data comprises the following steps:
judging whether the first time data of the current time is legal holiday or double-holiday; if so, searching the first sales data of the first time data of the serial number of the date of the stored legal holiday or the serial number of the date of the double holiday by using the serial number of the date of the current legal holiday or the serial number of the date of the double holiday as the first sales data which is closest to the current time in the searched and stored first time data; if not, judging whether the first time data of the current time is cold-hot holiday or not, if so, searching the first sales data of the first time data of the serial number of the date of the stored legal holiday or the serial number of the date of the double holiday by using the serial number of the date of the cold-hot holiday as the first sales data which is closest to the current time in the searched first time data of the stored first sales data; if the data is not on the chilly or hotly holiday, the first sales data of the first time data with the serial number of the Monday to Friday with the closest date as the serial number of the date of the legal holiday or the serial number of the date of the double holiday which is searched and stored is the first sales data which is closest to the current time in the searched and stored first sales data.
The invention relates to a sales data analysis method, wherein the first preset threshold value can be [1m, 20km ].
The invention relates to a sales data analysis method, wherein the second preset threshold value can be [3, + ∞ ].
The invention relates to a sales data analysis method, wherein the third preset threshold value can be [1, + ∞ ].
The invention relates to a system for analyzing sales data, which comprises
The system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring first sales data in unit time, and the first sales data comprise first time data, first position data, first money data, first category data and first quantity data;
the second acquisition module is used for acquiring second user data of the registered user, wherein the second user data comprises second quantity data, second time data and second position data;
the third acquisition module is used for acquiring third commodity data of each type of commodity, and the third commodity data comprises third replenishment transportation time data and third commodity source location position data;
a database for storing first sales data, second user data, and third product data for each unit time;
the reference sales data generation module is used for searching for first sales data which are closest to the current time in the first time data of the stored first sales data and converting the first sales data into reference sales data;
the first replenishment data generation module is used for generating first replenishment data according to the difference value between the first category data and the first quantity data of the reference sales data and the first category data and the first quantity data of the current real-time first sales data;
the second replenishment data generation module is used for generating distance data according to the first position data of the first sales data and the second position data of the second user data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is larger than a second preset threshold value, multiplying the first replenishment data by (1+ a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is smaller than a third preset threshold value, multiplying the first replenishment data by (1-a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is more than a third preset threshold value and less than a second preset threshold value, converting the first replenishment data into second replenishment data;
and the processor is used for converting the second replenishment data into final replenishment data and outputting the final replenishment data to a server.
The sales data analysis method of the present invention is different from the prior art in that the sales data analysis method of the present invention can capture the historical first sales data of the closest date by the algorithm and then generate the first replenishment data by using the captured first sales data as the reference sales data and combining the current real-time first sales data. And then, the number of potential users is obtained by judging the number of registered users within the range of the first preset threshold value by the users, the number of potential users is compared with a second preset threshold value with a larger number and a third preset threshold value with a smaller number, and the number of potential users is corrected by the first floating coefficient so as to obtain final replenishment data which is more fit with the reality, so that the management level of sales data and the management level of enterprises are improved, and the phenomenon that stock is too much and overdue or the stock is short of the sales cannot be caused is avoided.
A sales data analysis method according to the present invention will be further described with reference to the accompanying drawings.
Drawings
FIG. 1 is a flow chart diagram of a method of sales data analysis.
Detailed Description
As shown in FIG. 1, a sales data analysis method of the present invention comprises
Acquiring first sales data in unit time, wherein the first sales data comprise first time data, first position data, first money data, first category data and first quantity data;
acquiring second user data of the registered user, wherein the second user data comprises second quantity data, second time data and second position data;
acquiring third commodity data of each type of commodity, wherein the third commodity data comprises third replenishment transportation time data and third commodity source location position data;
storing first sales data, second user data and third commodity data in each unit time;
generating reference sales data: searching and storing first sales data closest to the current time in first time data of the first sales data, and converting the first sales data into reference sales data;
generating first replenishment data: generating first replenishment data according to the difference value between the first category data and the first quantity data of the reference sales data and the first category data and the first quantity data of the current real-time first sales data;
generating second replenishment data: generating distance data according to first position data of the first sales data and second position data of the second user data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is larger than a second preset threshold value, multiplying the first replenishment data by (1+ a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is smaller than a third preset threshold value, multiplying the first replenishment data by (1-a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is more than a third preset threshold value and less than a second preset threshold value, converting the first replenishment data into second replenishment data;
and converting the second replenishment data into final replenishment data and outputting the final replenishment data to a server.
The invention can use the first sales data with the most recent date as reference sales data after capturing the first sales data with the algorithm and generates the first replenishment data by combining the current real-time first sales data. And then, the number of potential users is obtained by judging the number of registered users within the range of the first preset threshold value by the users, the number of potential users is compared with a second preset threshold value with a larger number and a third preset threshold value with a smaller number, and the number of potential users is corrected by the first floating coefficient so as to obtain final replenishment data which is more fit with the reality, so that the management level of sales data and the management level of enterprises are improved, and the phenomenon that stock is too much and overdue or the stock is short of the sales cannot be caused is avoided.
The final replenishment data can be used as data for scheduling the articles, when the final replenishment data exceeds a fourth preset threshold, the stock is added, and when the final replenishment data exceeds a fifth preset threshold, the placement position of the final replenishment data is adjusted, so that the final replenishment data attracts consumers to purchase other articles through flow products.
The fourth preset threshold may be 300. The fifth preset threshold may be 500.
The second user data comprises second quantity data, second time data and second position data, and further comprises new users, old users, users who have forwarded advertisements and frequency lottery data.
Wherein, the first sales data closest to the current time can be trained by an algorithm to select the first sales data closest to the historical contemporaneous occurrence. The first sales data closest to the point represents sales results that have occurred on the same day in the past, that is, the first time data represents a date, the first location data represents a store location, the first amount data represents a daily sales amount, the first item data represents an item type, and the first quantity data represents a quantity of sales.
Wherein, the first preset threshold value can be [1m, 20km ], preferably 5 km.
Wherein, the second preset threshold value can be [3, + ∞ ], and is preferably 30.
Wherein, the third preset threshold value can be [1, + ∞ ], preferably 10.
Among them, the first floating coefficient may be [ 1%, 70% ], preferably 20%.
As a further explanation of the present invention, the distance data is within a circular range formed with a first preset threshold as a radius, and the distance data is a straight line distance or a navigation distance between the first location data of the first sales data and the second location data of the second user data.
The invention judges whether the first preset threshold value can constitute a potential user or not by judging the number of users in the circular range formed by the radius as described above, and helps the system of the invention to better analyze whether the system can influence the replenishment data as the potential user or not.
Wherein, the straight line distance is a more objective distance.
Wherein, the navigation distance can be bus or driving or walking, and is preferably the walking distance.
As a further explanation of the present invention, generating the second replenishment data further comprises:
generating third replenishment data: generating at least 2 circular rings with the same ring width and a circle with the first radius as the ring width in a circular range formed by taking the first position as the center of a circle and the distance data with the first preset threshold as the radius, and arranging the circular rings and the circle with the first radius as the ring width into an a-th area according to the arrangement of the first position from near to far, wherein the a-bits are non-zero natural numbers arranged from small to large; when the number of the registered users changed into the unconsumed registered user in the area B is larger than that of the registered users changed into the unconsumed registered user in the area B, wherein B is larger than B, the second replenishment data is multiplied by (1+ a second floating coefficient) and is converted into third replenishment data; when the number of the registered users changed from the unconsumed registered user in the area B to the unconsumed registered user in the area B is less than or equal to the number of the registered users changed from the unconsumed registered user in the area B to the unconsumed registered user in the area B, wherein B is more than B, the second replenishment data is multiplied by (1-a second floating coefficient) and is converted into third replenishment data; wherein the larger B is, the smaller the second floating coefficient is;
and converting the third replenishment data into final replenishment data and outputting the final replenishment data to a server.
According to the method, users in distance data within a first preset threshold value are configured into a plurality of areas by a plurality of circular rings and a circle with the radius as the width of the circular rings, and when the number of registered users from far to near is increased by taking a first position as a circle center, the number of registered users in the area with a smaller sequence number is increased, the potential sales volume is increased possibly, and the shortage of goods is serious, so that the second replenishment data is changed into third replenishment data in a mode of 1+ a second floating coefficient; on the contrary, when the registered quantity from near to far is increased, the second replenishment data is changed into third replenishment data in a mode of 1-a second floating coefficient; and if the distance and the distance are not changed, the second replenishment data is directly converted into third replenishment data.
In short, the invention influences the replenishment quantity according to the distance hierarchy, that is, the ring of each segment is collected, and whether the ring is moved forward or away when the user goes forward is judged, so that the replenishment quantity is influenced.
The second floating coefficient is decreased progressively according to the sequence number of the area from the first position, for example, the circle center is the first area, and then the second area and the third area are provided. Then the second floating factor for a registered user walking from the third area to the second area is not as great as the second floating factor for the second area walking into the first area. Because it is farther from the first location, it may influence the decision weight of whether the user is a potential user to be smaller.
Of course, the second coefficient of variation between each region may also be the same, for example 0.1% to 70%, preferably 5%.
Wherein, the value range of a +0 to a + n can be [1, + ∞ ].
Wherein, the value range of B-B can be [1, + ∞ ].
The current real-time first sales data can be understood as the current inventory or the quantity of the placed goods in the store.
Wherein the first sales data may be: 12 and 1 in 2019, the daily sales volume is as follows: cola 100 bottles are sold in the eastern monoshop, which may be a real-time sales volume.
Wherein the second user data may be: at 5 pm on 12/1/2019, 30 users are within 100 meters of east single shop, which may be real-time data.
Wherein the third merchandise data may be: the coke source is in a warehouse 5 kilometers from the eastern monoshop, with a restocking transit time of 15 minutes, which may be real-time data. Of course, the source of the goods may be a warehouse in the Guangdong province 1500 kilometers away from the east single store, and the replenishment transportation time is about 5 days.
As a further explanation of the invention, a second floating coefficient between regions closer to the first location is greater than a second floating coefficient between regions farther from the first location.
The invention can configure the second floating coefficient according to the decreasing of the second floating coefficient between the areas with different distances from the first position through the second floating coefficient of the fluctuation, and can configure the second floating coefficient which is more relevant according to the distance of the areas.
For example,
the second floating coefficient between the first area and the second area is 20 percent;
the second floating coefficient between the second area and the third area is 10 percent;
the second floating coefficient between the third area and the fourth area is 7 percent;
the second floating coefficient between the fourth region and the fifth region is 5%.
The second floating coefficient is decreased progressively according to the sequence number of the area from the first position, for example, the circle center is the first area, and then the second area and the third area are provided. Then the second floating factor for a registered user walking from the third area to the second area is not as great as the second floating factor for the second area walking into the first area. Because it is farther from the first location, it may influence the decision weight of whether the user is a potential user to be smaller.
As a further explanation of the present invention, the step of generating the third replenishment data further includes:
and according to the sequence number a of the a-th area, generating second floating coefficients of the a-th area and the a + 1-th area according to the following formula: second coefficient of fluctuation ═ e-(a+c)Wherein C is a constant.
The invention utilizes the monotonous decreasing trend of the negative power of e through the formula, and the trend gradually approaches to 0 to be used as the weight of the number of people in each section for influencing the replenishment data for the possibility of purchasing or not to be purchased, and forms the decreasing trend of different degrees by adjusting the values of different constants C to influence the generation of different second floating coefficients.
It is emphasized that the value of C in summer is less than the value of C in spring and autumn and less than the value of C in winter. Since people in summer have a large range of activity and a strong desire to move, the geographic location has less weight on whether to be a potential purchase.
Wherein, the value range of C in the above formula may be (1, + ∞), and C is preferably 3, and more preferably, C is 2 in summer, 3 in spring and autumn, and 4 in winter.
As a further explanation of the present invention, the step of searching for the first sales data closest to the current time among the first time data of the stored first sales data includes the steps of:
judging whether the first time data of the current time is legal holiday or double-holiday; if so, searching the first sales data of the first time data of the serial number of the date of the stored legal holiday or the serial number of the date of the double holiday by using the serial number of the date of the current legal holiday or the serial number of the date of the double holiday as the first sales data which is closest to the current time in the searched and stored first time data; if not, judging whether the first time data of the current time is cold-hot holiday or not, if so, searching the first sales data of the first time data of the serial number of the date of the stored legal holiday or the serial number of the date of the double holiday by using the serial number of the date of the cold-hot holiday as the first sales data which is closest to the current time in the searched first time data of the stored first sales data; if the data is not on the chilly or hotly holiday, the first sales data of the first time data with the serial number of the Monday to Friday with the closest date as the serial number of the date of the legal holiday or the serial number of the date of the double holiday which is searched and stored is the first sales data which is closest to the current time in the searched and stored first sales data.
The first time data and the current first time data stored in the mode are balanced between specific double holidays, legal holidays, summer-cold holidays and workdays, because the sales volume of commodities is often influenced by the holidays, and when the stored time points are captured, the relationship among the double holidays, the legal holidays, the summer-cold holidays and the workdays is not ignored only by considering the same date, so that the most real and closest replenishment data are influenced by considering the time points which correspond to the time relations, the replenishment is more scientific, and the phenomena of stock overstock and shortage of stocks cannot be generated.
Wherein, the serial number of the date can be the day before, the first day, the second day and the day after the holiday of the legal holiday. For example, the spring festival seven days is the previous day, the first day of vacation, the second day of vacation, the third day of vacation, the fourth day of vacation, the fifth day of vacation, the sixth day of vacation, the seventh day of vacation, and the last day of vacation to search the same, i.e., the closest first time data stored. The same theory of double holidays states that each year has a specific legal holiday, but if there are more double holidays, the closest double holiday or the date of the X double holiday in the same year should be determined.
Wherein, the legal holidays comprise spring festival 7-day holidays, national day 7-day holidays and the like.
As a further explanation of the present invention, the first preset threshold may be [1m, 20km ].
Wherein, the first preset threshold value can be [1m, 20km ], preferably 5 km.
As a further explanation of the present invention, the second preset threshold may be [3, + ∞).
Wherein, the second preset threshold value can be [3, + ∞), preferably 30.
As a further explanation of the present invention, the third preset threshold may be [1, + ∞ ].
Wherein, the third preset threshold value can be [1, + ∞ ], preferably 10.
The invention relates to a system for analyzing sales data, which comprises
The system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring first sales data in unit time, and the first sales data comprise first time data, first position data, first money data, first category data and first quantity data;
the second acquisition module is used for acquiring second user data of the registered user, wherein the second user data comprises second quantity data, second time data and second position data;
the third acquisition module is used for acquiring third commodity data of each type of commodity, and the third commodity data comprises third replenishment transportation time data and third commodity source location position data;
a database for storing first sales data, second user data, and third product data for each unit time;
the reference sales data generation module is used for searching for first sales data which are closest to the current time in the first time data of the stored first sales data and converting the first sales data into reference sales data;
the first replenishment data generation module is used for generating first replenishment data according to the difference value between the first category data and the first quantity data of the reference sales data and the first category data and the first quantity data of the current real-time first sales data;
the second replenishment data generation module is used for generating distance data according to the first position data of the first sales data and the second position data of the second user data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is larger than a second preset threshold value, multiplying the first replenishment data by (1+ a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is smaller than a third preset threshold value, multiplying the first replenishment data by (1-a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is more than a third preset threshold value and less than a second preset threshold value, converting the first replenishment data into second replenishment data;
and the processor is used for converting the second replenishment data into final replenishment data and outputting the final replenishment data to a server.
The above-mentioned embodiments are merely illustrative of the preferred embodiments of the present invention, and do not limit the scope of the present invention, and various modifications and improvements of the technical solution of the present invention by those skilled in the art should fall within the protection scope defined by the claims of the present invention without departing from the spirit of the present invention.
Claims (10)
1. A sales data analysis method is characterized in that: comprises that
Acquiring first sales data in unit time, wherein the first sales data comprise first time data, first position data, first money data, first category data and first quantity data;
acquiring second user data of the registered user, wherein the second user data comprises second quantity data, second time data and second position data;
acquiring third commodity data of each type of commodity, wherein the third commodity data comprises third replenishment transportation time data and third commodity source location position data;
storing first sales data, second user data and third commodity data in each unit time;
generating reference sales data: searching and storing first sales data closest to the current time in first time data of the first sales data, and converting the first sales data into reference sales data;
generating first replenishment data: generating first replenishment data according to the difference value between the first category data and the first quantity data of the reference sales data and the first category data and the first quantity data of the current real-time first sales data;
generating second replenishment data: generating distance data according to first position data of the first sales data and second position data of the second user data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is larger than a second preset threshold value, multiplying the first replenishment data by (1+ a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is smaller than a third preset threshold value, multiplying the first replenishment data by (1-a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is more than a third preset threshold value and less than a second preset threshold value, converting the first replenishment data into second replenishment data;
and converting the second replenishment data into final replenishment data and outputting the final replenishment data to a server.
2. The sales data analysis method according to claim 1, wherein: the distance data is in a circular range formed by taking a first preset threshold as a radius, and the distance data is a straight line distance or a navigation distance between first position data of the first sales data and second position data of the second user data.
3. The sales data analysis method according to claim 2, wherein: after the second replenishment data is generated, the method further comprises the following steps:
generating third replenishment data: generating at least 2 circular rings with the same ring width and a circle with the first radius as the ring width in a circular range formed by taking the first position as the center of a circle and the distance data with the first preset threshold as the radius, and arranging the circular rings and the circle with the first radius as the ring width into an a-th area according to the arrangement of the first position from near to far, wherein the a-bits are non-zero natural numbers arranged from small to large; when the number of the registered users changed into the unconsumed registered user in the area B is larger than that of the registered users changed into the unconsumed registered user in the area B, wherein B is larger than B, the second replenishment data is multiplied by (1+ a second floating coefficient) and is converted into third replenishment data; when the number of the registered users changed from the unconsumed registered user in the area B to the unconsumed registered user in the area B is less than or equal to the number of the registered users changed from the unconsumed registered user in the area B to the unconsumed registered user in the area B, wherein B is more than B, the second replenishment data is multiplied by (1-a second floating coefficient) and is converted into third replenishment data; wherein the larger B is, the smaller the second floating coefficient is;
and converting the third replenishment data into final replenishment data and outputting the final replenishment data to a server.
4. A sales data analysis method according to claim 3, wherein: a second coefficient of float between regions closer to the first location is greater than a second coefficient of float between regions farther from the first location.
5. The sales data analysis method according to claim 4, wherein: the step of generating third replenishment data further includes:
according to the sequence number a of the a-th area, the second floating coefficients of the a-th area and the a + 1-th area are generated according to the following formula: second coefficient of fluctuation ═ e-(a+c)Wherein C is a constant.
6. The sales data analysis method according to claim 5, wherein: the searching and storing step of the first sales data closest to the current time in the first time data of the first sales data includes the steps of:
judging whether the first time data of the current time is legal holiday or double-holiday; if so, searching the first sales data of the first time data of the serial number of the date of the stored legal holiday or the serial number of the date of the double holiday by using the serial number of the date of the current legal holiday or the serial number of the date of the double holiday as the first sales data which is closest to the current time in the searched and stored first time data; if not, judging whether the first time data of the current time is cold-hot holiday or not, if so, searching the first sales data of the first time data of the serial number of the date of the stored legal holiday or the serial number of the date of the double holiday by using the serial number of the date of the cold-hot holiday as the first sales data which is closest to the current time in the searched first time data of the stored first sales data; if the data is not on the chilly or hotly holiday, the first sales data of the first time data with the serial number of the Monday to Friday with the closest date as the serial number of the date of the legal holiday or the serial number of the date of the double holiday which is searched and stored is the first sales data which is closest to the current time in the searched and stored first sales data.
7. The sales data analysis method according to claim 1, wherein: the first preset threshold may be [1m, 20km ].
8. The sales data analysis method according to claim 1, wherein: the second preset threshold may be [3, + ∞).
9. The sales data analysis method according to claim 1, wherein: the third preset threshold may be [1, + ∞).
10. A system for a sales data analysis method according to claim 1, characterized in that: comprises that
The system comprises a first acquisition module, a second acquisition module and a third acquisition module, wherein the first acquisition module is used for acquiring first sales data in unit time, and the first sales data comprise first time data, first position data, first money data, first category data and first quantity data;
the second acquisition module is used for acquiring second user data of the registered user, wherein the second user data comprises second quantity data, second time data and second position data;
the third acquisition module is used for acquiring third commodity data of each type of commodity, and the third commodity data comprises third replenishment transportation time data and third commodity source location position data;
a database for storing first sales data, second user data, and third product data for each unit time;
the reference sales data generation module is used for searching for first sales data which are closest to the current time in the first time data of the stored first sales data and converting the first sales data into reference sales data;
the first replenishment data generation module is used for generating first replenishment data according to the difference value between the first category data and the first quantity data of the reference sales data and the first category data and the first quantity data of the current real-time first sales data;
the second replenishment data generation module is used for generating distance data according to the first position data of the first sales data and the second position data of the second user data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is larger than a second preset threshold value, multiplying the first replenishment data by (1+ a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is smaller than a third preset threshold value, multiplying the first replenishment data by (1-a first floating coefficient) and converting the first replenishment data into second capture data; when the first position data is used as the circle center, the distance data is in a circular range formed by taking a first preset threshold value as the radius, and the number of the registered users is more than a third preset threshold value and less than a second preset threshold value, converting the first replenishment data into second replenishment data;
and the processor is used for converting the second replenishment data into final replenishment data and outputting the final replenishment data to a server.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911303140.5A CN111062756B (en) | 2019-12-17 | 2019-12-17 | Sales data analysis method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911303140.5A CN111062756B (en) | 2019-12-17 | 2019-12-17 | Sales data analysis method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111062756A true CN111062756A (en) | 2020-04-24 |
| CN111062756B CN111062756B (en) | 2021-10-22 |
Family
ID=70302011
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911303140.5A Active CN111062756B (en) | 2019-12-17 | 2019-12-17 | Sales data analysis method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111062756B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112991071A (en) * | 2021-04-28 | 2021-06-18 | 南京玄德毅信息技术有限公司 | Financial product market promotion strategy optimization system and method based on big data |
| CN113393268A (en) * | 2021-06-11 | 2021-09-14 | 武汉阿杜拉电子商务有限公司 | Intelligent commodity retail sales management platform based on big data analysis and cloud computing |
| WO2022041828A1 (en) * | 2020-08-24 | 2022-03-03 | 北京沃东天骏信息技术有限公司 | Method and device for displaying data |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7480623B1 (en) * | 2000-03-25 | 2009-01-20 | The Retail Pipeline Integration Group, Inc. | Method and system for determining time-phased product sales forecasts and projected replenishment shipments for a retail store supply chain |
| CN106971249A (en) * | 2017-05-05 | 2017-07-21 | 北京挖玖电子商务有限公司 | A kind of Method for Sales Forecast and replenishing method |
| CN107194761A (en) * | 2017-05-05 | 2017-09-22 | 北京挖玖电子商务有限公司 | The area authorization guard method of merchandise sales |
| CN110335090A (en) * | 2019-07-12 | 2019-10-15 | 创新奇智(南京)科技有限公司 | Replenishing method and system, electronic equipment based on Sales Volume of Commodity forecast of distribution |
| CN110348635A (en) * | 2019-07-12 | 2019-10-18 | 创新奇智(成都)科技有限公司 | Intelligent replenishing method, storage medium, system and device based on end-to-end study |
| CN110363454A (en) * | 2018-04-09 | 2019-10-22 | 杉数科技(北京)有限公司 | For determining the method and device of commodity replenishment quantity |
-
2019
- 2019-12-17 CN CN201911303140.5A patent/CN111062756B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7480623B1 (en) * | 2000-03-25 | 2009-01-20 | The Retail Pipeline Integration Group, Inc. | Method and system for determining time-phased product sales forecasts and projected replenishment shipments for a retail store supply chain |
| CN106971249A (en) * | 2017-05-05 | 2017-07-21 | 北京挖玖电子商务有限公司 | A kind of Method for Sales Forecast and replenishing method |
| CN107194761A (en) * | 2017-05-05 | 2017-09-22 | 北京挖玖电子商务有限公司 | The area authorization guard method of merchandise sales |
| CN110363454A (en) * | 2018-04-09 | 2019-10-22 | 杉数科技(北京)有限公司 | For determining the method and device of commodity replenishment quantity |
| CN110335090A (en) * | 2019-07-12 | 2019-10-15 | 创新奇智(南京)科技有限公司 | Replenishing method and system, electronic equipment based on Sales Volume of Commodity forecast of distribution |
| CN110348635A (en) * | 2019-07-12 | 2019-10-18 | 创新奇智(成都)科技有限公司 | Intelligent replenishing method, storage medium, system and device based on end-to-end study |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2022041828A1 (en) * | 2020-08-24 | 2022-03-03 | 北京沃东天骏信息技术有限公司 | Method and device for displaying data |
| CN112991071A (en) * | 2021-04-28 | 2021-06-18 | 南京玄德毅信息技术有限公司 | Financial product market promotion strategy optimization system and method based on big data |
| CN113393268A (en) * | 2021-06-11 | 2021-09-14 | 武汉阿杜拉电子商务有限公司 | Intelligent commodity retail sales management platform based on big data analysis and cloud computing |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111062756B (en) | 2021-10-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111062756B (en) | Sales data analysis method and system | |
| KR101071997B1 (en) | Contactpoint navigation system and method | |
| US8694346B2 (en) | Travel-related prediction system | |
| US7577579B2 (en) | Method of predicting sales based on triple-axis mapping of customer value | |
| CN105225129B (en) | Mobile O2O recommendation method and system thereof | |
| US20050251468A1 (en) | Process management system | |
| US20070124194A1 (en) | Systems and methods to facilitate keyword portfolio management | |
| CN113553540A (en) | Commodity sales prediction method | |
| CN101385018A (en) | Using estimated ad qualities for ad filtering, ranking and promotion | |
| CN102272758A (en) | Automated specification, estimation, discovery of causal drivers and market response elasticities or lift factors | |
| CN107077687A (en) | Obtain the data relevant with consumer, the processing data and the output that the consumer's quotation being electronically generated is provided | |
| CN109493151A (en) | Method for Sales Forecast method and system | |
| US8341009B1 (en) | Information modeling and projection for geographic regions having insufficient sample size | |
| TW202139098A (en) | Consumption prediction system and consumption prediction method | |
| JP2018139036A (en) | Analysis device | |
| Han et al. | Impact of different types of in-store displays on consumer purchase behavior | |
| EP2343683A1 (en) | Data relationship preservation in a multidimension data hierarchy | |
| Hilbert et al. | Mapping the cost of a balanced diet, as a function of travel time and food price | |
| Biryukov et al. | Formation of a tourism entrepreneurial environment in the conditions of competition | |
| CN109949065B (en) | Method and device for analyzing attribute data | |
| CN111339389A (en) | Early warning method and system for identifying online store transfer | |
| CN116452299A (en) | Intelligent recommendation system and method for electronic commerce | |
| KR102362347B1 (en) | Supply chain management system | |
| KR102316797B1 (en) | Incentive calculation and payment system | |
| CN114331535A (en) | Information issuing system and method based on intelligent shopping cart |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20210129 Address after: 102400 no.1-q115, area 1, Guba Road, Chengguan Street, Fangshan District, Beijing Applicant after: BEIJING MAERMALA TECHNOLOGY Co.,Ltd. Address before: 518000 Room 01-03, 2nd Floor, Block C, Shenzhen Bay Science and Technology Eco-Park, Yuehai Street, Nanshan District, Shenzhen City, Guangdong Province Applicant before: Shenzhen Chenghe Run Culture Communication Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20210926 Address after: 518000 Room 01-03, 2nd Floor, Block C, Shenzhen Bay Science and Technology Eco-Park, Yuehai Street, Nanshan District, Shenzhen City, Guangdong Province Applicant after: Shenzhen Chenghe Run Culture Communication Co.,Ltd. Address before: 102400 no.1-q115, area 1, Guba Road, Chengguan Street, Fangshan District, Beijing Applicant before: BEIJING MAERMALA TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |