The Listing Mirror Inventory Forecasting tool allows you to easily and accurately calculate how much inventory to reorder so you can rest assured to never miss a sale while avoiding pricey storage fees. Using an algorithm based on your real sales data, you can feel confident in our numbers.
Use our suggested quantity to create purchase orders with virtually no manual entry.
Where to Find Forecasting
It is located in the Inventory header in the navigation.
The Algorithm
We calculate your recommended order quantity via a transparent equation.
((Daily Sales * Stock Coverage) - In Stock Qty - Incoming Qty) = Order Qty
Now, let's break down what each of those items means.
Daily Sales is your units sold per day. We calculate this as your Total Sales divided by the days you have selected in 'for enough stock to cover'. However, that does not take into account the days where you had no stock. What we really want to find is the number of sales you could have made had you been adequately stocked. To compute that, we divide by the percentage of days that you had stock. Finally, any uplift you have predicted is factored into the final result.
Clicking the units sold per day number will open a modal explaining how the number was calculated.
Stock coverage is the number of days you select in the 'for enough stock to cover' field.
In Stock Qty is the amount of already purchased stock you have sitting in a warehouse.
Incoming Qty is the amount of already purchase stock you have in route to a warehouse.
Configuring your Recommended Amount
In order to give you the Order Qty that will best suit your needs, we ask three (3) things.
1. What range of previous sales data would you like to use? Select any of our range options and we will take all sales during that time into account when calculating your recommended order quantity. You may wish to increase or decrease this selection based on how long you've been selling on a new channel if that channel's sales have affected your stock.
2. How long do you want to stock out before having to reorder? Ordering too much stock can result in storage fees. Too little stock and you have to pay higher shipping fees for two separate orders. Finding that sweet spot really helps your profitability. We recommend stocking out as long as your warehouses allows without charging fees.
3. Has your store experienced any trend in sales? If you're looking to order a seasonal item that you know is going to experience a substantial uptick in sales, move that uplift slider to the right. If you are expecting a downward trend in sales overall due to vacation mode, move that slider to the left.
Helpful tip: If you expect your sales to double, make your uplift 100%.
Filtering your Results
By warehouse. By default we will assume that you are looking to restock your Merchant Fulfilled (MF) warehouse. If instead you are looking to send inventory to Fulfilled by Amazon (FBA) or another Third Party Logistic (3PL), use the warehouse selectors to update the page.
We only count sales that would affect those warehouses. For example, if you are looking to restock your FBA warehouse and you had 5 Amazon sales and 5 eBay sales that were MCF'ed via that FBA inventory, then we would count all 10 of those orders as previous sales.
You can select as many warehouses as you'd like to restock. Just be aware that if you are issuing a purchase order, all the inventory will be delivered to one address and you will need to split it from there.
By vendor. If you would like to only see items in a certain vendor's catalog, use this dropdown to select that vendor. This will decrease the results shown in the list to only items offered by that vendor. Read more about vendor catalogs here.
Customizing your Columns
See as many, or as few columns, as you'd like. Narrow down the forecast to only data that you wish to see. Click 'Customize View' in the top right corner and select the information that is important to you. Our column options are:
Preview. Provides an image of your product.
SKU. Provides the SKU of the product that is a link to its product page.
Title. Provides the product title of the product.
SKU / Title. If you wish to take up less room on the forecast with the SKU and Title information (one column as opposed to two columns), you can use this option and turn off the individual SKU and Title columns.
Vendor. Provides the cheapest vendor for which that product is offered. As determined by your Vendor Catalog.
Order Qty. This is computed using the following equation: ((Daily Sales * Stock Coverage) - In Stock Qty - Incoming Qty). It cannot be removed as a column from the forecast. You can override our suggestion by clicking the qty and then entering in a new amount.
Total Sales. Provides the overall number of quantity sold for that product in the time period chosen for the 'Based on previous sales of' setting.
Units Sold per Day. We calculate this as your Total Sales divided by the days you have selected in 'for enough stock to cover'. However, that does not take into account the days where you had no stock. What we really want to find is the number of sales you could have made had you been adequately stocked. To compute that, we divide by the percentage of days that you had stock. Finally, any uplift you have predicted is factored into the final result.
In Stock. The quantity you currently have in stock for the warehouse(s) selected.
Incoming Stock. The quantity you have in transit. We determine this amount from the purchase orders that you have issued, but have not yet received.
Days until 0 Qty. This is (In Stock Qty / Units Sold per Day).
Cost per Item. We pull in the cost either from the Product Catalog, or from the Vendor Catalog if you have the item attached to a Vendor. You can update the cost here by clicking on it and entering in a new cost. That cost will then be updated in all applicable areas of the site- either Product Catalog or Vendor Catalog.
Total Cost. This is the (Cost per Item * Order Qty).
Interacting with the Forecasting Table
Sorting. You can sort based on any column header you wish, both in an ascending and descending order. Simply click the column header once to sort by it. Click it again to toggle between ascending and descending order.
Updating the Order Qty. While we will fill in the Order Qty column with our calculated amount, you can override this simply by entering a new number in the field. That number will then be used on any purchase orders created.
Action Items. You can perform actions on specific items by selecting the checkboxes to the left of the row. You can reset quantities back to our recommended amounts, set quantities to a specific amount in bulk, or assign vendors to an item in bulk.
Create a Purchase order
When you're ready to order more stock, simply select the items from the forecast that you wish to order and click "Create Purchase Order". Read more about purchase orders here.
FAQs (Frequently Asked Questions)
Why can't I view the forecast?
If you are seeing a message like the one shown below, you will need to upgrade your plan in order to gain access. Learn more about managing your subscription here.
I am new to Listing Mirror. Will forecasting work for me?
Listing Mirror will start calculating order quantities as soon as you begin your trial, but it will be using limited sales knowledge since we've only just begun importing your orders. As you stay and grow with our platform, the calculations will be able to use more data.
Comments
0 comments
Please sign in to leave a comment.