Feature: the system automatically generates the quantity of stock to be prepared according to the sales volume, inventory and other data for users to stock up in advance.
【1】Conditions for triggering Stock-up Suggestions: (purchase days + safety days) * average daily sales > available stock + in transit stock
【2】Calculation formula of Stock-up Suggestions = (purchase frequency + purchase days + safety days) * average daily sales - (in transit stock + available stock)
Purchase frequency : how often you purchase
Purchase days: estimated days from purchase order to warehouse receipt
Safety days: the safety days that the remaining stock can support sales
Average daily sales : the average daily sales volume calculated according to the proportion average of avg3, avg7, avg15 and avg30
Calculation formula = avg3 * avg3 proportion coefficient + avg7 * avg7 proportion coefficient + avg15 * avg15 proportion coefficient + avg30 * avg30 proportion coefficient
Available stock: the available stock of the Merchant SKU, which can be viewed in the Merchant SKU list and Inventory List
In transit : purchase in transit + transfer in transit of the Merchant SKU, which can be viewed in the Merchant SKU list and Inventory List
How to use Stock-up Suggestion
Step 1: fill in the purchase days and safety days of Merchant SKU
There are two methods to edit purchase days and safety days
The system will not generate a stock-up suggestion for the Merchant SKU without Purchase Days and Safety Days.
Method1: Edit in Inventory List
Method2: Edit in Pruchase suggestion
Step 2: Set the Stock-up Suggestion Strategy
①. Purchasing frequency: how often you need to purchase, it depends on your actual situation
②. Daily sales trend: set the weight coefficient to judge the importance of each index. For example, if you think the 3-day average daily sales is more important, then you increase the weight coefficient of avg3.
It should be noted that the sum of weight coefficients must be 100%, that is, the sum of weight coefficients of avg3, avg7, avg15 and avg30 must be equal to 100%. Avg3 is the 3-day average daily sales; Avg7 is the 7-day average daily sales; Avg15 is the average daily sales of 15 days; Avg30 is the average daily sales of 30 days
Volatility Rise: (avg3 daily sales + avg7 daily sales) > (avg15 daily sales + avg30 daily sales)
Volatility Drop: (avg3 daily sales + avg7 daily sales) < (avg15 daily sales + avg30 daily sales)
③. Purchase Days: The estimated time taken from purchase creation to purchase receiving
Safety Days: Buffer time to prevent purchased products from not arriving on time
You can set default Purchase Days and Safety Days here.
④. Sales coefficient: used to calculate sales volume. When the sales volume increases during the promotion period, multiply the original daily average sales volume by the interval value set in the corresponding date to make the final average sales volume more reasonable.
For example, the sales volume on November 11 is about five times that of normal sales, so we can set the sales coefficient on November 11 as 1 / 5, that is, 0.2
Step 3: After triggering the Stock-up Suggestion, you can generate a purchase order with one click, either in bulk or single
Conditions for triggering Stock-up Suggestions: (purchase days + safety days) * average daily sales > available stock + in transit stock