Inventory Manager Calculations and Sales History

You choose how many days of past sales you want us to use for inventory calculations. You can choose between 15, 30, 60, 90, or 120 days. This allows you to determine the right time frame for each of your products or orders. You know your products best and their sales history.

The number of days you choose for Sales History will be averaged over the same number of days to calculate your Average Daily Sales. Average Daily sales will be used to determine when you will likely run out of stock, how much inventory you should order, and when. So it's important to make sure you are using the best Sales History number for your product. 

A shorter time frame, like 15 or even 30 days, will capture short-term trends. 

A longer time frame, like 90 or 120 days, will smooth out spikes in sales a bit more. 

If a holiday has just passed, you would probably want to select a longer timeframe so that your average daily sales are not inflated, which may cause you to overorder. 

Alternatively, if you were out of stock for several weeks during a long timeframe, your Average Daily Sales may be too low, causing you to underorder. 

We recommend you check your sales history and choose a timeframe that most closely represents what you expect your sales to be for the time frame you are ordering for. 

You can also use Analytics & Performance to get a better picture and select the best Sales History timeframe.

4. Timeframe.png 

In addition to the 10 columns enabled by default, there are several options you can select/de-select. You can customize your columns by clicking the arrow to expand the drop-down menu. Next, check or uncheck the metrics you want to see on your inventory summary.

1. Columns GIF.gif

These are the columns enabled by default:

  • Preview
  • ASIN
  • SKU
  • Product Title
  • Inventory Status  
  • Date to  Reorder 
  • Reorder Quantity 
  • Reorder Cost 
  • Reorder Profit 
  • Reorder Days of Supply
  • Inventory Level 

These are the additional metrics you can select:

  • Inbound Level
  • Inventory-Level Cost 
  • Inventory Level Profit 
  • Inventory Level Revenue 
  • Average Daily Sales 
  • Product Lead Time
  • Days Remaining 
  • Sales History 
  • Average Profit Per Unit 

Here's an example of the inventory summary you'll see:

5. Table.png

Click the arrow next to the Product Image to access a snapshot of that product's inventory:

6. Snapshot.png

If you want a detailed explanation of each column and its corresponding formula, please make sure you read our article on 📖 Inventory Manager Metrics


Was this article helpful?
0 out of 0 found this helpful