Knowledge Base

Inventory Management

One of the “Big Three” areas that ManageByStats helps you manage is inventory.  The others, of course, are customers and sales.

Inventory Management is the section devoted to that, and it ties in with the Restock Alerts Dashlets on the Dashboard.

Estimated Restock Date is computed based on the criteria explained below.

Use the Refresh Inventory button to update inventory on demand.  (If you have over 100 products this button will not show.)  Note, inventory info is updated automatically daily.

 

 

Inventory Management shows how many total items are accounted for, including those immediately on hand (InStock) and those on hand and inbound (Total).

Note, you can show and hide items that have been hidden from inventory. See Hiding Products in this section, under Products > SKUs.

 

 

You can select which columns you want to view, using the COLUMNS button.  See section below.

Following are the main columns:

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.

Total Supply Cost: if Costs are entered (see Settings | SKUs | Editing COGs), the system will calculate the value of the inventory based on the COGs entered and number of units.  This is for the Total number of units in supply.

InStock Supply Quantity: this is what’s in stock; units that are available at Amazon for shipping.

InStock Supply Cost: if Costs are entered (see Settings | SKUs | Editing COGs), the system will calculate the value of the inventory based on the COGs entered and number of units.  This is for the InStock supply units.

Units Sold: the number of units shipped in the last XX days.

Restock Lead Time: this is the lead time to restock, or to order products so they are in stock before the current stock runs out.

Stock Cover Trailing: based on the last XX days of sales activity (the number selected under "Columns" (see below) for "Stock Cover Trailing"), how long the current stock will last.  Calculation is based on Total Supply Quantity, or 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.

Estimated Re-stock Date: when you should order, based on the above criteria. There are two options for this. "Smallest" and "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".

And we have "Smallest" - that takes the minimum Stock Cover days value from all these - the worst-case of these.  So 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.

Change Settings: clicking the Edit icon takes you to an edit page for that product SKU:

You can set the Restock Lead Time and 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.

Selecting Columns

You can select and add multiple other columns:

"Smallest" would be the shortest number of days worth of Stock remaining, based on the smallest, most active period of sales.

For example, based on the last day of sales (1 day), if it was a slow day, the system might suggest a longer period of time you can expect to have stock.  However, if the prior 7 days were the most agressive in terms of sales, that would lead to a calculation of less time you can expect to have stock.

"Smallest" will look for and use the busiest trailing period in order to give you the number of days you can expect to have stock (at that rate of sales).

Stock cover trailing smallest shows the smallest cover trailing from all periods.  If you wants to show another range, 30 days, for example, select one of those.

Filter By Tags

If you've added tags to your SKUs (see the page Products > Product Tags in this menu section), you can filter by them, to only see items of your inventory matching those tags.