Mall commodity shelf life management method and system
Through prediction and dynamic price adjustment based on historical sales data, real-time temperature monitoring and recycling of expired goods, the challenges of shelf life management in traditional commodity management methods are solved, and the effects of inventory optimization and environmental protection are achieved.
Patent Information
- Application Number
- CN202411160087.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-22
- Publication Date
- 2024-11-29
AI Technical Summary
Traditional commodity management methods rely on manual experience and are difficult to effectively manage and control the shelf life of commodities, resulting in stock backlogs or expired commodities, which cannot meet the rapidly changing market demand.
By collecting historical sales data of goods, predicting sales trends and inventory demand, dynamic price adjustments, coordinating replenishment volume, monitoring storage temperature in real time, and establishing a mechanism for recycling expired goods to form a shelf life management method and system for mall products.
It effectively reduces the risk of expiration, optimizes inventory management, extends the shelf life of goods, reduces quality decline caused by improper storage, and reduces environmental pollution and economic losses.
Smart Images

Figure CN119048073A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to a method and system for managing the shelf life of goods in a shopping mall, and in particular to the technical field of goods management. Background Art
[0002] With the development of e-commerce and the diversification of consumer demand, the retail industry is facing more and more challenges. One of them is how to effectively manage and control the shelf life of goods to ensure the freshness and quality of goods while reducing losses caused by expiration. Traditional commodity management methods often rely on manual experience to make decisions. This method is prone to mistakes when faced with a large number of goods and rapidly changing market demands, resulting in inventory backlogs or expired goods. Summary of the invention
[0003] Purpose of the invention: One purpose is to propose a method for managing the shelf life of goods in a shopping mall to solve the above-mentioned problems existing in the prior art; a further purpose is to propose a system for implementing the above-mentioned method.
[0004] Technical solution: A method for managing the shelf life of goods in a shopping mall, comprising:
[0005] Step 1: First, collect the historical sales data of the product and predict the future sales trend and inventory demand of the product;
[0006] Step 2: Dynamically adjust prices based on sales trends, market demand, seasonal changes, and information about products approaching their expiration dates;
[0007] Step 3: Share data with suppliers and distributors based on inventory demand and coordinate the replenishment of goods;
[0008] Step 4: Monitor the storage temperature of replenished goods in real time and adjust the ambient temperature according to the demand of goods;
[0009] Step 5: Reclaim expired goods from storage and replenishment products.
[0010] In a further embodiment, the historical sales data of the commodity is used to identify the peak sales period and predict future trends; the forecast calculation method of the commodity sales volume is as follows:
[0011] Forecast sales = a + b × historical sales + c × promotional activities + d × seasonal factors
[0012] In the formula, a represents basic sales volume, which is the expected sales baseline; b represents the historical sales impact coefficient; c represents the promotional activity impact coefficient, which reflects the effect of promotional activities on sales growth; d represents the seasonal factor impact coefficient, which reflects the potential impact of different seasons on sales; historical sales represents sales data over a certain period of time in the past, which is used to capture sales patterns and trends; promotional activity impact represents the specific impact of past promotional activities on sales based on data from past promotional activities; seasonal factors represent the impact of seasonal changes on commodity sales.
[0013] In a further embodiment, the specific calculation method of dynamic price adjustment is as follows:
[0014]
[0015] In the formula, base price represents the initial or standard selling price of the product; α represents the price sensitivity coefficient, which reflects the impact of price changes on sales; β represents the adjustment rate parameter, which represents the expiration date of the product; τ represents the current date of the product, which calculates the remaining time until the product expires; τ represents the time decay constant, which makes the price respond more quickly to the state approaching the expiration date; tanh represents the hyperbolic tangent function, which is used to simulate the smooth transition of prices over time.
[0016] In a further embodiment, the coordinated replenishment quantity is calculated as follows:
[0017]
[0018] In the formula, K represents the ordering cost, which is the fixed cost for each order; D represents the annual demand, which is the estimated total number of goods needed in a year; h represents the holding cost, which is the cost incurred by holding inventory; actual demand represents the actual market demand forecast; and predicted demand represents the demand predicted by historical data trends.
[0019] In a further embodiment, the supplier receives the product in-and-out plan, and then formulates the in-and-out plan with the distributor, and judges whether the received calculation and formulated plan need to be adjusted. If adjustment is required, it returns to the stage of formulating the in-and-out plan. If not, it formulates the in-and-out plan table, and then reviews the in-and-out plan table. After the review, the products are prepared, and after preparation, they are allocated for shipment to the distributor.
[0020] The distributor conducts a warehouse entry process check on the supplier's goods to see if the product information exists. If not, the distributor adds the product information. If it exists, the distributor fills in the warehouse entry form and updates the product inventory data.
[0021] The distributor checks the outbound delivery process to see if the outbound delivery quantity is less than the inventory quantity. If so, the distributor fills out the outbound delivery form. If not, the distributor reconfirms the outbound delivery and then feeds back the inventory of the goods to the supplier to formulate the purchase information.
[0022] In a further embodiment, the ambient temperature setting is calculated as follows:
[0023]
[0024] Wherein, the new freshness index represents a metric used to evaluate the freshness of goods under current storage conditions; the closer the index value is to 1, the closer the storage conditions are to the ideal state; the actual temperature / humidity represents the current temperature and humidity readings in the warehouse or storage area; the ideal temperature / humidity represents the set target temperature and humidity; σ represents the tolerance parameter of temperature / humidity, the allowable deviation range of temperature and humidity; exp represents an exponential function, which is used to deal with the nonlinear effect of deviation and enhance the sensitivity of the freshness index to temperature and humidity deviation.
[0025] In a further embodiment, the indoor temperature and humidity sensor is first started, and the LCD connected to the temperature and humidity sensor is displayed with a delay, and then the temperature and humidity of the goods stored in the room are detected, and then the temperature and humidity are displayed through the LCD to judge the indoor temperature and humidity. If the stored temperature value is higher than the temperature value that the goods themselves need to store, the first relay is energized, the red light is on, and the temperature adjustment device is started. If the stored temperature value is higher than the humidity value that the goods themselves need to store, the second relay is energized, the yellow light is on, and the humidity adjustment device is started.
[0026] In a further embodiment, the real-time recovery is calculated as follows:
[0027]
[0028] In the formula, the recycling rate represents a metric used to evaluate the efficiency and effectiveness of the recycling strategy;
[0029] γ represents the recycling incentive coefficient, which reflects the incentive intensity of the recycling strategy.
[0030] The amount of recycled goods refers to the number of expired or about-to-expire goods actually recycled within a certain period of time;
[0031] The reference quantity represents a preset benchmark quantity, which is the target quantity of goods to be recycled or the recycling quantity in the same period in the past;
[0032] log represents a logarithmic function, which is used to smooth the nonlinear relationship between recovery efficiency and recovery amount.
[0033] A shopping mall commodity shelf life management system, used to implement a shopping mall commodity shelf life management method, comprising:
[0034] Data forecasting module: first collects historical sales data of products and forecasts future sales trends and inventory requirements of products;
[0035] Intelligent pricing module: Dynamically adjust prices based on sales trends, market demand, seasonal changes, and information about products approaching their expiration dates;
[0036] Supply chain collaboration module: Share data with suppliers and distributors based on inventory demand and coordinate the replenishment of goods;
[0037] Fresh-keeping application module: real-time monitoring of the storage temperature of replenished goods and adjustment of the ambient temperature according to the demand of goods;
[0038] Environmental management module: Recycling of expired goods for storage and replenishment.
[0039] Beneficial effects: The present invention proposes a method and system for managing the shelf life of goods in a shopping mall. By collecting historical sales data of goods, the future sales trend and inventory demand of goods are predicted; according to the predicted sales trend and inventory demand, combined with the information that the goods are approaching the shelf life, a dynamic pricing strategy is adopted to adjust the price of goods to reduce the risk of expiration; suppliers and distributors share data, and adjust the replenishment quantity according to the predicted inventory demand and actual demand to maintain an appropriate inventory level and reduce the risk of out-of-stock or excess; by real-time monitoring of the storage temperature and humidity of goods, ensure that the goods are stored under optimal conditions, extend the shelf life, and reduce the quality degradation caused by improper storage; establish an expired product recycling mechanism, recycle expired or about to expire goods, and reduce environmental pollution. BRIEF DESCRIPTION OF THE DRAWINGS
[0040] Figure 1 It is a schematic diagram of the method flow of the present invention.
[0041] Figure 2 It is a schematic diagram of the system flow of the present invention. DETAILED DESCRIPTION
[0042] The applicant believes that traditional commodity management methods often rely on manual experience to make decisions, which is prone to errors when faced with a large number of commodities and rapidly changing market demands, resulting in inventory backlogs or expired goods.
[0043] In order to solve the problems existing in the prior art, the present invention adopts a method and system for managing the shelf life of goods in a shopping mall, which enables the motor to adjust different torque values according to the thickness of the sludge and deal with obstacles.
[0044] The present invention will be further described in detail below through embodiments and in conjunction with the accompanying drawings.
[0045] In this application, we propose a shopping mall commodity shelf life management system and a system for implementing the method, wherein the shopping mall commodity shelf life management system includes the following steps:
[0046] Step 1: First, collect the historical sales data of the goods and predict the future sales trend and inventory demand of the goods; optimize inventory management, reduce excess and out-of-stock situations, and ensure the efficient operation of the supply chain;
[0047] Through the historical sales data of the product, we can identify the peak sales period and predict future trends. The sales volume of the product is predicted as follows:
[0048] Forecast sales = a + b × historical sales + c × promotional activities + d × seasonal factors
[0049] In the formula, a represents basic sales volume, which is the expected sales baseline; b represents the historical sales impact coefficient; c represents the promotional activity impact coefficient, which reflects the effect of promotional activities on sales growth; d represents the seasonal factor impact coefficient, which reflects the potential impact of different seasons on sales; historical sales represents sales data over a certain period of time in the past, which is used to capture sales patterns and trends; promotional activity impact represents the specific impact of past promotional activities on sales based on data from past promotional activities; seasonal factors represent the impact of seasonal changes on commodity sales.
[0050] Step 2: Use sales trends to dynamically adjust prices based on market demand, seasonal changes, and information about products approaching their expiration dates. The goal is to boost sales and reduce losses from expired, unsold goods. Through precise pricing strategies, improve sales efficiency and profits while ensuring that consumers receive reasonable prices.
[0051] The specific calculation method of dynamic price adjustment is as follows:
[0052]
[0053] In the formula, base price represents the initial or standard selling price of the product; α represents the price sensitivity coefficient, which reflects the impact of price changes on sales; β represents the adjustment rate parameter, which represents the expiration date of the product; β represents the current date of the product, which calculates the remaining time before the product expires; τ represents the time decay constant, which makes the price respond more quickly to the state approaching the expiration date; tanh represents the hyperbolic tangent function, which is used to simulate the smooth transition of prices over time.
[0054] By setting parameters α, β and τ, prices are automatically adjusted to optimize inventory sales strategies.
[0055] For example, if a product is about to expire in a month, the price can be adjusted based on the product’s sales history, current inventory levels, and market demand forecasts to avoid a situation where all products are not sold before they expire.
[0056] Step 3: Share data with suppliers and distributors based on inventory demand and coordinate the replenishment of goods; by improving the transparency and responsiveness of the supply chain, companies can respond to market changes more quickly and reduce inventory backlogs and expiration risks.
[0057] The coordinated replenishment quantity is calculated as follows:
[0058]
[0059] In the formula, K represents the ordering cost, which is the fixed cost for each order; D represents the annual demand, which is the estimated total number of goods needed in a year; h represents the holding cost, which is the cost incurred by holding inventory; actual demand represents the actual market demand forecast; and predicted demand represents the demand predicted by historical data trends.
[0060] First, the supplier receives the product in and out plan, and then formulates the in and out plan with the distributor. It determines whether the received calculation and formulated plan need to be adjusted. If adjustment is required, it returns to the stage of formulating the in and out plan. If not, it formulates the in and out plan table, reviews the in and out plan table, prepares the products after the review, and distributes them to the distributor for shipment.
[0061] The distributor conducts a warehouse entry process check on the supplier's goods to see if the product information exists. If not, the distributor adds the product information. If it exists, the distributor fills in the warehouse entry form and updates the product inventory data.
[0062] The distributor checks the outbound delivery process to see if the outbound delivery quantity is less than the inventory quantity. If so, the distributor fills out the outbound delivery form. If not, the distributor reconfirms the outbound delivery and then feeds back the inventory of the goods to the supplier to formulate the purchase information.
[0063] Step 4: Monitor the storage temperature of replenished goods in real time and adjust the ambient temperature according to the demand of goods, which can significantly improve the freshness and availability of goods and reduce the loss of goods caused by unsuitable environment;
[0064] The ambient temperature setting is calculated as follows:
[0065]
[0066] Wherein, the new freshness index represents a metric used to evaluate the freshness of goods under current storage conditions; the closer the index value is to 1, the closer the storage conditions are to the ideal state; the actual temperature / humidity represents the current temperature and humidity readings in the warehouse or storage area; the ideal temperature / humidity represents the set target temperature and humidity; σ represents the tolerance parameter of temperature / humidity, the allowable deviation range of temperature and humidity; exp represents an exponential function, which is used to deal with the nonlinear effect of deviation and enhance the sensitivity of the freshness index to temperature and humidity deviation.
[0067] First, start the indoor temperature and humidity sensor, and display the delayed display on the LCD connected to the temperature and humidity sensor. Then, detect the temperature and humidity of the goods stored indoors, and then display the temperature and humidity on the LCD to judge the indoor temperature and humidity. If the stored temperature value is higher than the temperature value that the goods need to store, the first relay is energized, the red light is on, and the temperature adjustment device is started. If the stored temperature value is higher than the humidity value that the goods need to store, the second relay is energized, the yellow light is on, and the humidity adjustment device is started. By controlling the storage environment, the ideal fresh-keeping temperature and humidity of the goods are matched, thereby extending their shelf life. By installing temperature and humidity sensors and connecting to automatic control, the environment for real-time monitoring and adjustment of the goods storage is monitored. According to the fresh-keeping requirements of different goods, the temperature and humidity are automatically adjusted to keep them in the best state.
[0068] For example, for meat products that need to be stored at low temperatures, the temperature is controlled to fluctuate within a set low temperature range to prevent bacterial growth and product spoilage;
[0069] Step 5, Environmental Management Module: Recycling of expired goods for storage and replenishment products,
[0070] Real-time recycling is calculated as follows:
[0071]
[0072] In the formula, the recycling rate represents a metric used to evaluate the efficiency and effectiveness of the recycling strategy;
[0073] γ represents the recycling incentive coefficient, which reflects the incentive intensity of the recycling strategy.
[0074] The amount of recycled goods refers to the number of expired or about-to-expire goods actually recycled within a certain period of time;
[0075] The reference quantity represents a preset benchmark quantity, which is the target quantity of goods to be recycled or the recycling quantity in the same period in the past;
[0076] log represents a logarithmic function, which is used to smooth the nonlinear relationship between recovery efficiency and recovery volume;
[0077] By setting the γ coefficient, the incentive intensity of the recycling strategy can be adjusted according to different environmental policies and business conditions; the shelf life management module combines real-time data monitoring and historical data analysis to identify products that have not been sold due to shelf life issues;
[0078] For example, expired food can be sorted and processed according to safety standards: some expired but still safe goods can be used as animal feed, while those that are completely unfit for consumption can enter the biodegradation or energy recovery process. By predicting the expiration risk of specific goods through data analysis, price cuts or other promotional measures can be taken in advance to reduce the number of goods that need to be recalled.
[0079] A shopping mall commodity shelf life management system, used to implement a shopping mall commodity shelf life management method, comprising:
[0080] Data forecasting module: first collects historical sales data of products and forecasts future sales trends and inventory requirements of products;
[0081] Intelligent pricing module: Dynamically adjust prices based on sales trends, market demand, seasonal changes, and information about products approaching their expiration dates;
[0082] Supply chain collaboration module: Share data with suppliers and distributors based on inventory demand and coordinate the replenishment of goods;
[0083] Fresh-keeping application module: real-time monitoring of the storage temperature of replenished goods and adjustment of the ambient temperature according to the demand of goods;
[0084] Environmental management module: Recycling of expired goods for storage and replenishment.
[0085] As described above, although the present invention has been shown and described with reference to specific preferred embodiments, it should not be construed as limiting the present invention itself. Various changes may be made to it in form and detail without departing from the spirit and scope of the present invention as defined in the appended claims.
Claims
1. A method for managing the shelf life of goods in a shopping mall, characterized in that: The steps include: Step 1: First, collect the historical sales data of the product and predict the future sales trend and inventory demand of the product; Step 2: Dynamically adjust prices based on sales trends, market demand, seasonal changes, and information about products approaching their expiration dates; Step 3: Share data with suppliers and distributors based on inventory demand and coordinate the replenishment of goods; Step 4: Monitor the storage temperature of replenished goods in real time and adjust the ambient temperature according to the demand of goods; Step 5: Reclaim expired goods from storage and replenishment products.
2. A method for managing the shelf life of goods in a shopping mall according to claim 1, characterized in that: Through the historical sales data of the product, we can identify the peak sales period and predict future trends. The sales volume of the product is predicted as follows: Forecast sales = a + b × historical sales + c × promotional activities + d × seasonal factors In the formula, a represents basic sales volume, which is the expected sales baseline; b represents the historical sales impact coefficient; c represents the promotional activity impact coefficient, which reflects the effect of promotional activities on sales growth; d represents the seasonal factor impact coefficient, which reflects the potential impact of different seasons on sales; historical sales represents sales data over a certain period of time in the past, which is used to capture sales patterns and trends; promotional activity impact represents the specific impact of past promotional activities on sales based on data from past promotional activities; seasonal factors represent the impact of seasonal changes on commodity sales.
3. A method for managing the shelf life of goods in a shopping mall according to claim 1, characterized in that: The specific calculation method of dynamic price adjustment is as follows: In the formula, base price represents the initial or standard selling price of the product; α represents the price sensitivity coefficient, which reflects the impact of price changes on sales; β represents the adjustment rate parameter, which represents the expiration date of the product; τ represents the current date of the product, which calculates the remaining time until the product expires; τ represents the time decay constant, which makes the price respond more quickly to the state approaching the expiration date; tanh represents the hyperbolic tangent function, which is used to simulate the smooth transition of prices over time.
4. A method for managing the shelf life of goods in a shopping mall according to claim 1, characterized in that: The coordinated replenishment quantity is calculated as follows: In the formula, K represents the ordering cost, which is the fixed cost of each order; D represents the annual demand, which is the estimated total number of goods required in a year; h represents the holding cost, which is the cost incurred by holding inventory; actual demand represents the actual demand forecast of the market; Forecasted demand represents the demand volume predicted by historical data trends.
5. A method for managing the shelf life of goods in a shopping mall according to claim 1, characterized in that: The supplier receives the product in-and-out plan, and then formulates the in-and-out plan with the distributor. The supplier determines whether the received calculation and formulated plan need to be adjusted. If adjustment is required, the supplier returns to the stage of formulating the in-and-out plan. If not, the supplier formulates the in-and-out plan table, reviews the in-and-out plan table, prepares the products after the review, and distributes them to the distributor for shipment. Distributors conduct warehouse entry inspections on suppliers’ products to check whether product information exists. If not, they add product information. If it exists, fill in the warehouse entry form and then update the product inventory data; The distributor checks the outbound delivery process to see if the outbound delivery quantity is less than the inventory quantity. If so, the distributor fills out the outbound delivery form. If not, the distributor reconfirms the outbound delivery and then feeds back the inventory of the goods to the supplier to formulate the purchase information.
6. A method for managing the shelf life of goods in a shopping mall according to claim 1, characterized in that: The ambient temperature setting is calculated as follows: In the formula, the new freshness index represents a metric used to evaluate the freshness of the product under the current storage conditions; The closer the index value is to 1, the closer the storage conditions are to the ideal state; the actual temperature / humidity represents the current temperature and humidity readings in the warehouse or storage area; the ideal temperature / humidity represents the set target temperature and humidity; σ represents the tolerance parameter of temperature / humidity, the allowable temperature and humidity deviation range; exp represents the exponential function, which is used to deal with the nonlinear effect of deviation and enhance the sensitivity of the freshness index to temperature and humidity deviation.
7. A method for managing the shelf life of goods in a shopping mall according to claim 6, characterized in that: First, start the indoor temperature and humidity sensor, and display the delayed display on the LCD connected to the temperature and humidity sensor. Then, detect the temperature and humidity of the goods stored indoors. Then, display the temperature and humidity on the LCD to judge the indoor temperature and humidity. If the stored temperature value is higher than the temperature value that the goods need to store, the first relay is energized, the red light is on, and the temperature adjustment device is started. If the stored temperature value is higher than the humidity value that the goods need to store, the second relay is energized, the yellow light is on, and the humidity adjustment device is started.
8. A method for managing the shelf life of goods in a shopping mall according to claim 1, characterized in that: Real-time recycling is calculated as follows: In the formula, the recycling rate represents a metric used to evaluate the efficiency and effectiveness of the recycling strategy; γ represents the recycling incentive coefficient, which reflects the incentive intensity of the recycling strategy. The amount of recycled goods refers to the number of expired or about-to-expire goods actually recycled within a certain period of time; The reference quantity represents a preset benchmark quantity, which is the target quantity of goods to be recycled or the recycling quantity in the same period in the past; log represents a logarithmic function, which is used to smooth the nonlinear relationship between recovery efficiency and recovery amount.
9. A shopping mall product shelf life management system, used to implement the method described in any one of claims 1 to 8, characterized in that: include: Data forecasting module: first collects historical sales data of products and forecasts future sales trends and inventory requirements of products; Intelligent pricing module: Dynamically adjust prices based on sales trends, market demand, seasonal changes, and information about products approaching their expiration dates; Supply chain collaboration module: Share data with suppliers and distributors based on inventory demand and coordinate the replenishment of goods; Fresh-keeping application module: real-time monitoring of the storage temperature of replenished goods and adjustment of the ambient temperature according to the demand of goods; Environmental management module: Recycling of expired goods for storage and replenishment.
Citation Information
Cited By
Cloud baking raw material supply chain optimization management system
CN119312991A
Inventory management method and system for critical insurance risk commodities
CN121258376A
