A system and method for selling fresh fruit purchased in-transit inventory in advance
By designing a system for on-transit inventory early sales of fresh fruits and using dynamic adjustments to the on-transit sales ratio, the problem of short shelf life of fresh fruits being unable to be sold in advance is solved, and accurate assessment of on-transit inventory and increased sales opportunities are achieved, oversold order refunds are avoided, and user experience is improved.
Patent Information
- Application Number
- CN202411764492.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-04
- Publication Date
- 2025-03-21
- Estimated Expiration
- 2044-12-04
AI Technical Summary
Due to the short shelf life and small spot inventory, fresh fruits cannot be sold in advance. Virtual receipt increases inventory management risks, which is prone to losses during transportation, affecting user experience.
A system for early sales of fresh fruit purchases in transit stocks is designed, including procurement task generation module, inventory reservation module, inventory update module, sales ratio adjustment module and inventory alarm module. Through dynamic adjustment of the in transit proportions, early sales of fresh fruits in transit stocks is achieved.
It realizes an accurate assessment of the fluctuations in the transportation loss data of fresh fruits during historical transportation, ensures the accuracy of available inventory on the way, avoids oversold order refunds, improves user experience, and increases sales opportunities for fresh fruits during the way.
Smart Images

Figure CN119250703B_ABST
Abstract
Description
Technical Field
[0001] The present invention belongs to the technical field of sales management, and in particular relates to a system and method for selling fresh fruit purchased in-transit inventory in advance. Background Art
[0002] In the supply chain industry, fresh fruits usually cannot be stocked in advance due to their short shelf life, and the spot inventory is small. If they are sold only based on the spot inventory, they need to wait until the fresh fruits are purchased and stored to increase the spot inventory before they can be sold, thus losing the sales opportunities during the process of purchasing fresh fruits.
[0003] If, after initiating a purchase, virtual receipt is used to increase spot inventory for sale in advance, firstly, the physical quantity in the warehouse does not match the spot inventory, which may easily lead to inventory management risks. Secondly, fresh fruits are more likely to be damaged during the purchase and transportation process, and are more likely to be rejected due to quality inspection failures during the warehousing process, resulting in the physical quantity arriving at the warehouse being less than the virtual receipt quantity, and the physical quantity is insufficient to fulfill the contract, resulting in oversold orders and returns, affecting user experience.
[0004] In view of the above technical problems, the present invention proposes a system and method for selling fresh fruit purchased in-transit inventory in advance. Summary of the invention
[0005] To achieve the purpose of the present invention, the present invention adopts the following technical solutions:
[0006] According to one aspect of the present invention, a system and method for pre-selling fresh fruit purchased in-transit inventory is provided.
[0007] A system for selling fresh fruit in-transit inventory in advance, specifically comprising:
[0008] Procurement task generation module, warehousing reservation module, inventory update module, saleable ratio adjustment module, inventory alarm module;
[0009] The procurement task generation module is responsible for generating procurement tasks;
[0010] The warehousing reservation module is responsible for initiating purchase warehousing reservations and determining the in-transit saleable proportion of the purchase quantity of each fresh fruit product;
[0011] The inventory update module is responsible for updating the in-transit saleable inventory and sales inventory of different fresh fruit products according to the in-transit saleable ratio;
[0012] The saleable ratio adjustment module is responsible for adjusting the saleable ratio of goods in transit according to the sales situation of fresh fruit goods and the physical arrival situation of the warehouse, and updating the saleable inventory in transit and the sales inventory;
[0013] The inventory alarm module is responsible for updating the in-transit saleable inventory, spot saleable inventory and sales inventory according to the actual quantity received by the warehouse when the fresh fruit goods arrive at the warehouse, and clearing all the in-transit saleable inventory after the latest warehousing time of the fresh fruit goods, updating the sales inventory, and issuing an alarm for oversold goods.
[0014] A further technical solution is that the purchasing task includes fresh fruit products and the purchase quantity of each product.
[0015] On the other hand, the present application provides a method for selling fresh fruit purchased in-transit inventory in advance, which is applied to the above-mentioned system for selling fresh fruit purchased in-transit inventory in advance, and specifically includes:
[0016] S1: based on the analysis result of the type of fresh fruit, determine the historical transportation damage data of the fresh fruit in the historical transportation process, and when the fluctuation of the historical transportation damage data of the fresh fruit is within a preset range, proceed to the next step;
[0017] S2 determines the cargo damage data of the fresh fruits in different sales time periods based on the transportation time based on the historical cargo damage data of the fresh fruits, and determines the fresh fruits that need to be sold in advance in transit based on the cargo damage data in different sales time periods, and uses them as the fresh fruits to be sold in advance;
[0018] S3 uses the current purchase volume of the fresh fruit sold in advance and the transportation data of different types of transportation methods as basic transportation data, and determines the matching transportation times and data matching coefficient of the fresh fruit sold in advance based on the matching results of the basic transportation data and the historical transportation data;
[0019] S4 obtains historical transportation loss data of different matching transportation times, and determines the in-transit saleable inventory of the advance fresh fruit in combination with the data matching coefficient and the current purchase volume, and performs in-transit sale processing of the advance fresh fruit based on the in-transit saleable inventory.
[0020] A further technical solution is that the historical transportation damage data of the fresh fruit during historical transportation includes the transportation damage volume and transportation damage rate at different historical transportation times.
[0021] A further technical solution is to determine whether the fluctuation of the historical transportation loss data of the fresh fruit is within a preset range, specifically including:
[0022] Determine the amount of transportation loss of the fresh fruit at different historical transportation times based on the historical transportation loss data of the fresh fruit during the historical transportation process;
[0023] Determining the number of historical transportations in different transportation loss intervals based on the transportation loss volume, and determining the distribution dispersion coefficients of different transportation loss intervals according to the proportions of the number of historical transportations in different transportation loss intervals;
[0024] The transport loss volume interval with a distribution dispersion coefficient greater than a preset dispersion coefficient is used as a screening interval, and whether the fluctuation of the historical transport loss data of the fresh fruit is within a preset range is determined according to the number of the screening intervals.
[0025] A further technical solution is that, when the number of the screening intervals is greater than the number of preset intervals, it is determined that the fluctuation of the historical transportation loss data of the fresh fruit is not within a preset range.
[0026] A further technical solution is that when the fluctuation of the historical transportation loss data of the fresh fruit is not within a preset range, it is determined that the fresh fruit cannot be sold in advance.
[0027] A further technical solution is that the method for determining the in-transit saleable inventory of the fresh fruit sold in advance is:
[0028] Determine the historical loss rates of different matching transport times based on the historical loss data of different matching transport times;
[0029] The predicted loss rate of the fresh fruit sold in advance is determined according to the historical loss rate of different matching transportation times and the data matching coefficient, and the in-transit saleable inventory of the fresh fruit sold in advance is determined based on the predicted loss rate and the current purchase volume.
[0030] The beneficial effects of the present invention are:
[0031] Based on the analysis results of the types of fresh fruits, it is determined whether the fluctuation of the historical transportation damage data of the fresh fruits in the historical transportation process is within a preset range, thereby realizing the fluctuation of the historical transportation damage data of the fresh fruits in the historical transportation process, and screening the types of fresh fruits with large fluctuations, avoiding the occurrence of technical problems such as the inability to accurately determine the in-transit saleable inventory during the in-transit sales process due to large fluctuations in historical transportation damage data, realizing the determination of the types of fresh fruits with less fluctuations in transportation damage data, and also laying the foundation for further determination of advance sales results.
[0032] The in-transit saleable inventory of fresh fruits for advance sale is determined based on the historical transportation loss data of different matching transportation times, the data matching coefficient and the current purchasing volume. This not only takes into account the difference in the reference value of the historical cargo damage rate due to the difference in the data matching coefficient for different matching transportation times, but also takes into account the historical cargo damage rate for different matching transportation times, thereby achieving accurate determination of the cargo damage rate of the advance sale results and accurate evaluation of the in-transit saleable inventory.
[0033] The appropriate in-transit saleable ratio is set based on historical arrival conditions, and the in-transit saleable ratio is dynamically adjusted based on actual arrival conditions, so as to maximize the sales opportunities of fresh fruits in transit while avoiding overselling and order returns that affect user experience.
[0034] Other features and advantages will be described in the following description. The objects and other advantages of the present invention are realized and obtained by the structures particularly pointed out in the description and drawings.
[0035] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, preferred embodiments are given below and described in detail with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS
[0036] The above and other features and advantages of the present invention will become more apparent by describing in detail exemplary embodiments thereof with reference to the accompanying drawings;
[0037] Figure 1 It is a framework diagram of a system for selling fresh fruit purchased in-transit inventory in advance;
[0038] Figure 2 It is a flow chart of a method for selling fresh fruit purchased in-transit inventory in advance;
[0039] Figure 3 It is a flow chart of the method for determining fresh fruits that need to be sold in advance on the way;
[0040] Figure 4 It is a flow chart of a method for determining matching transportation times for selling fresh fruit in advance;
[0041] Figure 5 It is a flow chart of a method for determining the in-transit saleable inventory of fresh fruits for advance sale. DETAILED DESCRIPTION
[0042] In order to enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in the embodiments of this specification will be clearly and completely described below in conjunction with the drawings in the embodiments of this specification. Obviously, the described embodiments are only part of the embodiments of this specification, not all of the embodiments. Based on the embodiments of this specification, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of this specification.
[0043] Embodiment 1 To solve the above-mentioned problem, according to one aspect of the present invention, Figure 1 As shown, a system for selling fresh fruit in-transit inventory in advance is provided, which specifically includes:
[0044] Procurement task generation module, warehousing reservation module, inventory update module, saleable ratio adjustment module, inventory alarm module;
[0045] The procurement task generation module is responsible for generating procurement tasks;
[0046] The warehousing reservation module is responsible for initiating purchase warehousing reservations and determining the in-transit saleable proportion of the purchase quantity of each fresh fruit product;
[0047] The inventory update module is responsible for updating the in-transit saleable inventory and sales inventory of different fresh fruit products according to the in-transit saleable ratio;
[0048] The saleable ratio adjustment module is responsible for adjusting the saleable ratio of goods in transit according to the sales situation of fresh fruit goods and the physical arrival situation of the warehouse, and updating the saleable inventory in transit and the sales inventory;
[0049] The inventory alarm module is responsible for updating the in-transit saleable inventory, spot saleable inventory and sales inventory according to the actual quantity received by the warehouse when the fresh fruit goods arrive at the warehouse, and clearing all the in-transit saleable inventory after the latest warehousing time of the fresh fruit goods, updating the sales inventory, and issuing an alarm for oversold goods.
[0050] Step S1: Generate a fresh fruit purchase order, including the purchased goods and the purchase quantity. For example, the purchase order PNOXXX contains two fresh fruit goods sku1 and sku2, the purchase quantity of sku1 is 100, and the purchase quantity of sku2 is 80.
[0051] Step S2: Initiate a purchase and warehousing appointment. The system calculates the default in-transit saleable ratio based on the physical arrival of each fresh fruit product in the last seven days. The purchasing staff can manually adjust the in-transit saleable ratio based on the quality of the goods purchased on that day. The specific calculation is based on the following formula:
[0052]
[0053] Indicates the default proportion of goods in transit for sale.
[0054] Indicates the calculation date before The number of physical goods arriving in a day.
[0055] Indicates the calculation date before Purchase quantity per day.
[0056] Indicates the number of historical days used to calculate the default in-transit saleable ratio. .
[0057] The system will increase its in-transit saleable inventory and sales inventory based on the purchase quantity and the final in-transit saleable ratio, using the following formula for calculation:
[0058]
[0059]
[0060] in:
[0061] The purchase quantity.
[0062] The proportion of goods in transit that can be sold. This is the initial saleable quantity in transit, which needs to be rounded down.
[0063] The actual quantity of goods arrived.
[0064] It is the in-transit saleable inventory. The minimum value is zero and cannot be negative.
[0065] In stock.
[0066] For sold inventory.
[0067] For sales inventory, the minimum is zero and cannot be negative.
[0068] For example, if the in-transit saleable ratio of fresh fruit sku1 is set to 70%, and the in-transit saleable ratio of fresh fruit sku2 is set to 85%, the sales inventory of each product is as follows:
[0069]
[0070] Step S3: If the fresh fruit product is selling well and is expected to arrive at the warehouse on the same day, the in-transit saleable ratio of the product can be increased to increase its in-transit saleable inventory and sales inventory. For example, the fresh fruit product sku1 has been sold out, as shown in the following figure:
[0071] The in-transit saleable ratio of product sku1 can be increased from 70% to 80%, which increases the sales inventory by 10.
[0072]
[0073] If the arrival of fresh fruit products on the same day is poor, the in-transit saleable ratio of the products needs to be lowered to reduce the in-transit saleable inventory and sales inventory, to avoid overselling and return orders that affect user experience. For example, if the arrival of fresh fruit sku2 on the same day is poor, the in-transit saleable ratio of sku2 can be lowered from 85% to 75%, reducing sales inventory by 7%.
[0074]
[0075] Step S4: When the physical goods arrive at the warehouse, the in-transit saleable inventory is reduced according to the physical goods received by the warehouse (the in-transit saleable inventory can be reduced to zero at most and cannot be negative), and the spot saleable inventory is increased at the same time. If the physical goods received ratio (physical goods received quantity divided by the purchase quantity) is greater than the in-transit saleable ratio, the sales inventory will be increased. For example, if 90 pieces of sku1 and 40 pieces of sku2 arrive at the warehouse, the sales inventory changes of each product are as follows:
[0076]
[0077] Step S5: After the latest time that the goods are theoretically put into storage, all the in-transit saleable inventory of the day needs to be cleared and adjusted back to the spot inventory for sale. This can avoid that some warehouses that sell based on the in-transit saleable inventory have no physical goods to fulfill the contract. If the spot inventory is less than the sold inventory at this time, it is considered that the goods have been oversold and an alarm will be issued through the system. For example, if the physical arrival of goods sku1 and sku2 has not changed, and after clearing the in-transit saleable inventory, the spot inventory of goods sku2 is less than the sold inventory, then an oversold warning will be issued for goods sku2.
[0078]
[0079] Embodiment 2 The second aspect, as Figure 2 As shown, the present invention provides a method for selling fresh fruit purchased in-transit inventory in advance, which is applied to the above-mentioned system for selling fresh fruit purchased in-transit inventory in advance, and specifically includes:
[0080] S1: based on the analysis result of the type of fresh fruit, determine the historical transportation damage data of the fresh fruit in the historical transportation process, and when the fluctuation of the historical transportation damage data of the fresh fruit is within a preset range, proceed to the next step;
[0081] S2 determines the cargo damage data of the fresh fruits in different sales time periods based on the transportation time based on the historical cargo damage data of the fresh fruits, and determines the fresh fruits that need to be sold in advance in transit based on the cargo damage data in different sales time periods, and uses them as the fresh fruits to be sold in advance;
[0082] S3 uses the current purchase volume of the fresh fruit sold in advance and the transportation data of different types of transportation methods as basic transportation data, and determines the matching transportation times and data matching coefficient of the fresh fruit sold in advance based on the matching results of the basic transportation data and the historical transportation data;
[0083] S4 obtains historical transportation loss data of different matching transportation times, and determines the in-transit saleable inventory of the advance fresh fruit in combination with the data matching coefficient and the current purchase volume, and performs in-transit sale processing of the advance fresh fruit based on the in-transit saleable inventory.
[0084] Furthermore, the historical transportation damage data of the fresh fruit during historical transportation includes the transportation damage volume and transportation damage rate at different historical transportation times.
[0085] Furthermore, when selling fresh fruits in advance, the impact of out-of-stock conditions also needs to be considered. Specifically, when the supplier's out-of-stock quantity, out-of-stock rate, or the number of times the supplier has goods but the quality of the goods does not meet the requirements and is rejected by the warehouse, if any one of the requirements is not met, it is determined that the fresh fruits do not belong to the fresh fruits sold in advance.
[0086] It should be noted that the determination of the fluctuation of the historical transportation loss data of the fresh fruit within the preset range specifically includes:
[0087] Determine the amount of transportation loss of the fresh fruit at different historical transportation times based on the historical transportation loss data of the fresh fruit during the historical transportation process;
[0088] Determining the number of historical transportations in different transportation loss intervals based on the transportation loss volume, and determining the distribution dispersion coefficients of different transportation loss intervals according to the proportions of the number of historical transportations in different transportation loss intervals;
[0089] The transport loss volume interval with a distribution dispersion coefficient greater than a preset dispersion coefficient is used as a screening interval, and whether the fluctuation of the historical transport loss data of the fresh fruit is within a preset range is determined according to the number of the screening intervals.
[0090] Specifically, when the number of the screening intervals is greater than the number of preset intervals, it is determined that the fluctuation of the historical transportation loss data of the fresh fruit is not within the preset range.
[0091] It should also be noted that when the fluctuation of the historical transportation loss data of the fresh fruit is not within the preset range, it is determined that the fresh fruit cannot be sold in advance.
[0092] It is understandable that determining the fluctuation of the historical transportation loss data of the fresh fruit within a preset range specifically includes:
[0093] Determine the transportation loss rate of the fresh fruit at different historical transportation times based on the historical transportation loss data of the fresh fruit during the historical transportation process;
[0094] Determine the historical transportation times within different transportation loss rate intervals based on the transportation loss rate, and use the transportation loss rate interval in which the historical transportation times are greater than the preset transportation times as the screening interval;
[0095] It is determined according to the number of screening intervals whether the fluctuation of the historical transportation loss data of the fresh fruit is within a preset range.
[0096] Optionally, determining whether the fluctuation of the historical transportation loss data of the fresh fruit is within a preset range specifically includes:
[0097] S11 divides the historical transportation times into different transportation groups according to the transportation volume and transportation duration in different historical transportation processes based on the historical transportation damage data of the fresh fruit during the historical transportation process;
[0098] S12 determines the dispersion coefficient of cargo damage distribution in different transport groups based on the historical transport times in different transport damage volume ranges in different transport groups;
[0099] S13 determines the weight coefficients of different transport groups based on the historical transport times in different transport groups, and determines the comprehensive discrete coefficient in combination with the discrete coefficient of cargo damage distribution in different transport groups, and determines whether the fluctuation of the historical transport damage data of the fresh fruit is within a preset range based on the comprehensive discrete coefficient.
[0100] Furthermore, when the comprehensive dispersion coefficient is not within the preset dispersion coefficient interval, it is determined that the fluctuation of the historical transportation loss data of the fresh fruit is not within the preset range.
[0101] It should also be noted that the above step S11 includes steps S111-S113, which are specifically:
[0102] S111 determines the damage rate of the fresh fruit in different historical transportation processes based on the historical damage data of the fresh fruit in the historical transportation process. When the number of historical transportations whose deviation from the damage benchmark rate is not within the preset range does not meet the requirement, it is determined that the fluctuation of the historical damage data of the fresh fruit is not within the preset range. When the number of historical transportations whose deviation from the damage benchmark rate is not within the preset range meets the requirement, the process proceeds to step S112.
[0103] S112 determines the loss deviation of different historical transport times according to the deviation from the loss reference rate, and determines the deviation transport times of the historical transport times according to the loss deviation. When there is no deviation transport time with a loss deviation greater than the preset deviation, the process proceeds to step S114. When there is a deviation transport time with a loss deviation greater than the preset deviation, the process proceeds to step S113.
[0104] S113 determines the loss rate deviation coefficient based on the loss deviation amounts of different deviation transport times. When the loss rate deviation coefficient does not meet the requirement, it is determined that the fluctuation of the historical loss data of the fresh fruit is not within the preset range. When the loss rate deviation coefficient meets the requirement, the process proceeds to step S114.
[0105] S114 divides the historical transportation times into different transportation groups according to the transportation volumes and transportation durations in different historical transportation processes, and proceeds to step S12.
[0106] Optionally, the above step S12 includes steps S121-S123, specifically:
[0107] S121 determines the cargo damage distribution dispersion coefficients in different transport groups based on the historical transport times in different transport damage volume intervals. If there is a transport group whose cargo damage distribution dispersion coefficient does not meet the requirement, the process proceeds to step S122. If there is no transport group whose cargo damage distribution dispersion coefficient does not meet the requirement, the process proceeds to step S13.
[0108] S122: The transport group whose cargo damage distribution dispersion coefficient does not meet the requirement is regarded as a distribution discrete transport group. When the number of the distribution discrete transport groups does not meet the requirement, it is determined that the fluctuation of the historical transportation damage data of the fresh fruit is not within the preset range. When the number of the distribution discrete transport groups meets the requirement, the process proceeds to step S123.
[0109] S123 determines the total historical transportation times of the distributed discrete transportation groups based on the historical transportation times of different distributed discrete transportation groups. When the total historical transportation times do not meet the requirements, it is determined that the fluctuation of the historical transportation loss data of the fresh fruit is not within the preset range. When the total historical transportation times meet the requirements, proceed to step S13.
[0110] Optionally, the above step S13 includes steps S131-S132, specifically:
[0111] S131 determines the weight coefficients of different transport groups according to the historical transport times in different transport groups, and performs modified discrete coefficients of different transport groups in combination with the cargo damage distribution discrete coefficients in different transport groups. When the number of transport groups whose modified discrete coefficients do not meet the requirements does not meet the requirements, it is determined that the fluctuation of the historical transport damage data of the fresh fruit is not within the preset range. When the number of transport groups whose modified discrete coefficients do not meet the requirements meets the requirements, the process proceeds to step S132.
[0112] S132 determines the weight coefficients of different transport groups based on the historical transport times in different transport groups, and determines the comprehensive discrete coefficient based on the discrete coefficients of cargo damage distribution in different transport groups, and determines whether the fluctuation of the historical transport damage data of the fresh fruit is within a preset range based on the comprehensive discrete coefficient.
[0113] Furthermore, the cargo damage data within the sales period includes the distribution range of the historical cargo damage rate within the sales period.
[0114] Specifically, Figure 3 As shown, the method for determining the fresh fruits that need to be sold in advance is:
[0115] Determine the distribution range of cargo damage rates in different sales time periods based on cargo damage data in different sales time periods, and determine the benchmark cargo damage rates in different sales time periods through the distribution range;
[0116] Determine the safe selling time by using the benchmark cargo damage rate and the preset cargo damage rate threshold;
[0117] The safe selling time is used to determine whether the fresh fruit is fresh fruit that needs to be sold in advance while on the way.
[0118] Furthermore, the safe selling time period is the longest selling time period corresponding to the benchmark cargo damage rate being less than the preset cargo damage rate threshold.
[0119] It can be understood that the benchmark cargo damage rate is the middle value of the distribution range of the cargo damage rate in the sales market cycle.
[0120] It should be noted that the method for determining the fresh fruits that need to be sold in advance is:
[0121] Based on the cargo damage data in different sales time periods, the distribution range of cargo damage rates in different sales time periods is determined, and reference cargo damage rates in different sales time periods are obtained by calculating the number of occurrences of different cargo damage rates;
[0122] Determine the safe selling time by using the reference cargo damage rate and the preset cargo damage rate threshold;
[0123] The safe selling time is used to determine whether the fresh fruit is fresh fruit that needs to be sold in advance while on the way.
[0124] It should also be noted that the method for determining the fresh fruits that need to be sold in advance is:
[0125] S21 determines the distribution range of the cargo damage rate in different sales time periods based on the cargo damage data in different sales time periods, and determines the reference cargo damage rate in different sales time periods according to the number of occurrences of different cargo damage rates, and determines the reference cargo damage rate in different sales time periods and the reference coefficient of the reference cargo damage rate;
[0126] S22: determining the storage difficulty coefficient of the fresh fruit based on the reference cargo damage rates of different selling time periods and the reference coefficients of the reference cargo damage rates;
[0127] S23 determines whether the fresh fruit is fresh fruit that needs to be sold in advance on the way based on the storage difficulty coefficient.
[0128] Specifically, Figure 4 As shown, the method for determining the matching transportation times for selling fresh fruits in advance is:
[0129] Determine the deviation between the purchase quantity of the fresh fruit sold in advance and the purchase quantity of different historical transportation times based on the current purchase quantity of the fresh fruit sold in advance, and determine the purchase quantity matching coefficient of different historical transportation times based on the deviation of the purchase quantity;
[0130] Determine the deviation of the transportation mileage of the fresh fruit sold in advance from different historical transportation times in different transportation modes according to the transportation data of the fresh fruit sold in advance in different transportation modes, and determine the transportation mode matching coefficient of different historical transportation times based on the deviation of the transportation mileage of the fresh fruit sold in advance in different transportation modes;
[0131] The data matching coefficients of different historical transportation times are determined according to the transportation mode matching coefficients and the purchase quantity matching coefficients of different historical transportation times, and whether the historical transportation times are matching transportation times is determined based on the data matching coefficients.
[0132] It can be understood that the data matching coefficient of the historical transportation times is determined based on the average value of the transportation mode matching coefficients of different historical transportation times and the purchase volume matching coefficients.
[0133] Further, when the data matching coefficient of the historical transportation times is greater than a preset matching coefficient threshold, it is determined that the historical transportation times belong to the matching transportation times.
[0134] In one embodiment, the method for determining the matching transportation times for selling fresh fruits in advance is:
[0135] The current purchase quantity of the fresh fruit sold in advance is used to determine the deviation between the purchase quantity of the fresh fruit sold in advance and the purchase quantity of different historical transportation times. When the deviation between the purchase quantity of different historical transportation times is not within a preset range:
[0136] It is determined that the historical transportation times do not belong to the matching transportation times;
[0137] When the deviation of the purchase quantity from different historical transport times is within the preset range:
[0138] Determine the deviation of the transportation mileage of the fresh fruit sold in advance and different historical transportation times according to the transportation data of different types of transportation modes of the fresh fruit sold in advance, and when the deviation of the transportation mileage does not meet the requirement, determine that the historical transportation times do not belong to the matching transportation times;
[0139] When the deviation of the transport mileage meets the requirements:
[0140] According to the transportation data of different types of transportation modes of the fresh fruit sold in advance, the deviation of the transportation mileage of the fresh fruit sold in advance and different historical transportation times in different types of transportation modes is determined. When there is a transportation mode in which the deviation of the transportation mileage does not meet the requirements: it is determined that the historical transportation times do not belong to the matching transportation times;
[0141] When there is no mode of transport whose transport mileage deviation does not meet the requirements:
[0142] Based on the deviation of the transport mileage of different types of transport modes, the transport mileage deviation coefficient of different types of transport modes is determined. When the number of transport modes whose transport mileage deviation coefficient is not within the preset deviation range does not meet the requirements:
[0143] It is determined that the historical transportation times do not belong to the matching transportation times;
[0144] When the number of transport modes whose transport mileage deviation coefficient is not within the preset deviation range meets the requirements:
[0145] Determine the transport mode matching coefficients of different historical transport times based on the transport mileage deviation coefficients of different types of transport modes, and when the transport mode matching coefficients do not meet the requirements, determine that the historical transport times do not belong to the matching transport times;
[0146] When the matching coefficient of the transportation mode meets the requirements:
[0147] Based on the deviation of the purchase quantity, the purchase quantity matching coefficient of different historical transportation times is determined, and the data matching coefficient of different historical transportation times is determined according to the transportation mode matching coefficient and the purchase quantity matching coefficient of different historical transportation times. Based on the data matching coefficient, it is determined whether the historical transportation times are matching transportation times.
[0148] Furthermore, the data matching coefficient has a value range between 0 and 1, wherein the larger the data matching coefficient is, the higher the matching degree between the historical transportation times and the transportation data of the fresh fruit sold in advance is.
[0149] Specifically, Figure 5 As shown, the method for determining the in-transit saleable inventory of the fresh fruit sold in advance is:
[0150] Determine the historical loss rates of different matching transport times based on the historical loss data of different matching transport times;
[0151] The predicted loss rate of the fresh fruit sold in advance is determined according to the historical loss rate of different matching transportation times and the data matching coefficient, and the in-transit saleable inventory of the fresh fruit sold in advance is determined based on the predicted loss rate and the current purchase volume.
[0152] Optionally, the above step S21 includes steps S211-S213, which are specifically:
[0153] S211 determines the distribution range of the cargo damage rate in different sales time periods based on the cargo damage data in different sales time periods, and makes reference cargo damage rates for different sales time periods according to the number of occurrences of different cargo damage rates. The shortest sales time period in which the reference cargo damage rate is greater than the preset cargo damage rate is used as the safe sales time period. When the safe sales time period is less than the preset time period, it is determined that the fresh fruit is fresh fruit that needs to be sold in advance while in transit. When the safe sales time period is not less than the preset time period, the process proceeds to step S212.
[0154] S212: When the safe selling time is within the preset time range, the process proceeds to step S213; when the safe selling time is not within the preset time range, it is determined that the fresh fruit does not belong to the fresh fruit that needs to be sold in advance on the way;
[0155] S213 determines the reference coefficients of the reference damage rates of different selling time periods according to the number of occurrences of the reference damage rates of different selling time periods, and according to the reference damage rates of different selling time periods and the reference coefficients of the reference damage rates, takes the selling time period with a reference coefficient greater than a preset reference coefficient as the reference time period; when the shortest reference time period in which the reference damage rate is greater than the preset damage rate is within the preset time range, it is determined that the fresh fruit is fresh fruit that needs to be sold in advance while in transit; when the shortest reference time period in which the reference damage rate is greater than the preset damage rate is not within the preset time range, proceeds to step S22.
[0156] Optionally, the above step S22 includes steps S221-S223, specifically:
[0157] S221 determines the variation of the reference damage rates between different selling time periods based on the reference damage rates of different selling time periods, and determines the variable time period in the selling time period based on the variation. When the duration corresponding to the variable time period is less than the preset time threshold, proceed to step S222; when the duration corresponding to the variable time period is not less than the preset time threshold, proceed to step S213;
[0158] S222 determines the comprehensive reference coefficient of the variable time period based on the variable time period and the reference coefficient of the reference cargo damage amount of the variable time period. When the comprehensive reference coefficient is greater than the preset reference coefficient threshold, it is determined that the fresh fruit is fresh fruit that needs to be sold in advance on the way; when the comprehensive reference coefficient is not greater than the preset reference coefficient threshold, proceed to step S223;
[0159] S223 determines the preservation difficulty coefficient of the fresh fruit based on the reference damage rates of different selling periods and the reference coefficients of the reference damage rates, and proceeds to step S23.
[0160] Each embodiment in this specification is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device, equipment, and non-volatile computer storage medium embodiments, since they are basically similar to the method embodiments, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.
[0161] The above is a description of a specific embodiment of the specification. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recorded in the claims can be performed in an order different from that in the embodiments and still achieve the desired results. In addition, the processes depicted in the drawings do not necessarily require the specific order or continuous order shown to achieve the desired results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
[0162] The above description is only one or more embodiments of this specification and is not intended to limit this specification. For those skilled in the art, one or more embodiments of this specification may have various changes and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of one or more embodiments of this specification shall be included in the scope of the claims of this specification.
Claims
1. A method for selling fresh fruit purchased in-transit inventory in advance, characterized in that: Applied to a system for selling fresh fruit in-transit inventory in advance, the system includes a purchasing task generation module, a warehousing reservation module, an inventory update module, a saleable ratio adjustment module, and an inventory alarm module; The procurement task generation module is responsible for generating procurement tasks; The warehousing reservation module is responsible for initiating purchase warehousing reservations and determining the proportion of the purchase quantity that can be sold in transit for each fresh fruit product; The inventory update module is responsible for updating the in-transit saleable inventory and sales inventory of different fresh fruit products according to the in-transit saleable ratio; The saleable ratio adjustment module is responsible for adjusting the saleable ratio of goods in transit according to the sales situation of fresh fruit goods and the physical arrival situation of the warehouse, and updating the saleable inventory in transit and the sales inventory; The inventory alarm module is responsible for updating the in-transit saleable inventory, spot saleable inventory and sales inventory according to the actual warehouse receipt quantity when the fresh fruit goods arrive at the warehouse, and clearing all the in-transit saleable inventory after the latest storage time of the fresh fruit goods, updating the sales inventory, and issuing an alarm for oversold goods; The method specifically includes: Based on the analysis result of the type of fresh fruit, determine the historical transportation damage data of the fresh fruit during the historical transportation process, and when the fluctuation of the historical transportation damage data of the fresh fruit is within a preset range, proceed to the next step; Based on the historical cargo damage data of the fresh fruits, cargo damage data of the fresh fruits in different sales time periods based on the transportation time are determined, and based on the cargo damage data in different sales time periods, fresh fruits that need to be sold in advance while in transit are determined, and the fruits are used as fresh fruits to be sold in advance; The current purchase volume of the fresh fruit sold in advance and the transportation data of different types of transportation modes are used as basic transportation data, and the matching transportation times and data matching coefficients of the fresh fruit sold in advance are determined based on the matching results of the basic transportation data and the historical transportation data; The historical transportation loss data of different matching transportation times are obtained, and the in-transit saleable inventory of the advance fresh fruit is determined in combination with the data matching coefficient and the current purchase volume, and the in-transit sale processing of the advance fresh fruit is performed based on the in-transit saleable inventory.
2. The method for selling fresh fruit purchased in-transit inventory in advance as claimed in claim 1, characterized in that: The historical transportation damage data of fresh fruits during historical transportation includes the transportation damage volume and transportation damage rate at different historical transportation times.
3. The method for selling fresh fruit purchased in-transit inventory in advance as claimed in claim 1, characterized in that: Determine that the fluctuation of the historical transportation loss data of the fresh fruit is within a preset range, specifically including: Determine the amount of transportation loss of the fresh fruit at different historical transportation times based on the historical transportation loss data of the fresh fruit during the historical transportation process; Determining the number of historical transportations in different transportation loss intervals based on the transportation loss volume, and determining the distribution dispersion coefficients of different transportation loss intervals according to the proportions of the number of historical transportations in different transportation loss intervals; The transport loss volume interval with a distribution dispersion coefficient greater than a preset dispersion coefficient is used as a screening interval, and whether the fluctuation of the historical transport loss data of the fresh fruit is within a preset range is determined according to the number of the screening intervals.
4. The method for selling fresh fruit purchased in-transit inventory in advance as claimed in claim 3, characterized in that: When the number of the screening intervals is greater than the number of preset intervals, it is determined that the fluctuation of the historical transportation loss data of the fresh fruit is not within the preset range.
5. The method for selling fresh fruit purchased in-transit inventory in advance as claimed in claim 1, characterized in that: When the fluctuation of the historical transportation loss data of the fresh fruit is not within a preset range, it is determined that the fresh fruit cannot be sold in advance.
6. The method for selling fresh fruit purchased in-transit inventory in advance as claimed in claim 1, characterized in that: The cargo damage data within the sales period includes the distribution range of the historical cargo damage rate within the sales period.
7. The method for selling fresh fruit purchased in-transit inventory in advance as claimed in claim 1, characterized in that: The method for determining the fresh fruits that need to be sold in advance is: Determine the distribution range of cargo damage rates in different sales time periods based on cargo damage data in different sales time periods, and determine the benchmark cargo damage rates in different sales time periods through the distribution range; Determine the safe selling time by using the benchmark cargo damage rate and the preset cargo damage rate threshold; The safe selling time is used to determine whether the fresh fruit is fresh fruit that needs to be sold in advance while on the way.
8. The method for selling fresh fruit purchased in-transit inventory in advance as claimed in claim 7, characterized in that: The safe selling time period is the longest selling time period corresponding to the benchmark cargo damage rate being less than the preset cargo damage rate threshold.
Citation Information
Patent Citations
Inventory information processing method and device for business objects
CN106156975A
Inventory data processing method and device, electronic equipment and storage medium
CN116934214A