Knowledge Base

Restock Alerts

Restock Alerts show you inventory that needs to be restocked.  They are a handy form of visual alert to let you know when stock is running low.  They base their info on recent sales volume, current stock and settings you make (see below).

When you choose to add a Restock Alert you get the following default options:

You can select which account, and which columns you’d like to display.

Notice that when creating a Restock Alert dashlet the default is set to Stock Trailing 30 days, but the Restock Date is set to smallest.

Stock Cover Trailing is how much stock you have on hand (how long it will last), based on that trailing number of days.  For example:

Stock Cover Trailing 30 Days means the system looks at your sales over the last 30 days, and using that estimates how many days or months worth of stock you have left.  The calculation is based on averaging that same volume going forward.

Stock Cover Trailing 7 Days will do the same thing looking at your prior 7 days worth of sales, etc.

Stock Cover Trailing Smallest looks at your biggest single sales day in the last 30 days. "Smallest" means the shortest number of days (or earliest restock date). Stock cover (how many days worth of stock are left) can be calculated using the sales over various time spans. The default is using the average daily sales over the last 30 days.

But we also calculate stock cover using average sales for Yesterday, last 7 days, 90 days, 180 days and 365 days. So, "Smallest" takes the minimum Stock Cover days value from all these - the worst-case of these. On 30 days, average daily sales may be 20, but if you sold 30 Yesterday your stock cover based on Yesterday would be shorter, so "Days covered" would be smaller for Yesterday than it is for 30 days, giving an earlier restock date.

Estimated Restock Date is when the system estimates you should place your order.  It bases this on a comparison of:

Restock Lead Time is set by you, and is how long you need to get new inventory from your manufacturer to Amazon.  The default is 5 weeks.  You can set it by clicking the edit button:

When creating a new Restock Alert dashlet, the default option for Estimated Restock Date is “smallest”.  What that means is that the calculations for restock are performed on your biggest sales day in the last 30 days.

As an example if you normally sell 3 items of this SKU per day on the average, then suddenly consume 21 in a day, 7X your normal daily sales, the restock would be calculated on a consumption of inventory at this rate.

In order to match your Stock Cover Trailing estimate with your Estimated Restock Date, set your Stock Cover Trailing Smallest and Estimate Restock Date Smallest OR Stock Cover Trailing 30 Days and Estimate Restock Date 30 days.

SKU shows the SKU, Name is the product name.  You can also choose to show the Product Image and Brand.

Total Supply Quantity: This is the total number of units in supply, including any units that are showing as on their way to Amazon, even if they have not yet arrived.

InStock Supply Quantity: this is what’s in stock and ready to ship, not in transit or moving between warehouses.  These are units that are available at Amazon for shipping to customers.

InStock Supply Cots: the cost of the stock you have on hand, based on COGs you've entered in the SKUs section of your MBS.

Units sold: the number of units sold to customers in the specified period.

Stock Update Date: when these values were last updated.

When editing the Restock Lead Time, you can also choose to make a product Visible (checked) or hide it.  By default all products are Visible.  If you uncheck the Visible box that product will not show in the Restock Alerts.  This can help with clutter if you have products you don’t need to monitor.