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.

1Conditions for triggering Stock-up Suggestions: (purchase days + safety days) * average daily sales > available stock + in transit stock

2Calculation 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

Tips:

  1. If the purchase order is still in the draft box, the stock-up suggestion list will exist

  1. If the purchase order has been on the way and the purchased stock is sufficient [(purchase days + safety days) * average daily sales > available inventory + in transit inventory)], the stock-up suggestion list will not exist

  1. Our system calculates once a day automatically

  1. If you want to view real-time suggestions, you can click the calculate button manually