Inventory replenishment report

  Plan availability 

  Pro   Enterprise    |     Advanced  

 

The Inventory replenishment report helps you plan the purchase of products you reorder frequently. You can use this report to:

  • Make sure you always keep your top-selling products in stock and never miss a sale.
  • Predict when products might run out.
  • Understand customer demand for products with seasonal swings.
  • Estimate the cost of an order.

What can it tell you?

The report presents information about what products you have and what you’ve sold.

  • SKU name: The name and SKU of the product.
  • Closing inventory: Your inventory at the end of your selected date range. If that is today then it equals your current stock on hand.
  • Items sold: The total items you sold in your selected date range.
  • Items sold per day: The average daily sales in your selected date range.
  • Days cover: The number of days before your closing inventory will run out based on items sold per day.
  • Average cost: The average unit cost of on-hand inventory during your selected date range.

  Tip

Check out how you can customize your inventory reports.


Tips on using the replenishment report

Find out what you have and what’s running low

The report shows your top-selling products first, which includes all inventory. Change the report measure to Low inventory to focus on products below their reorder point. Change the measure to On-hand inventory to focus on products you currently have in stock.

Inventory-Replenishment-On-Hand.png

Order based on customer demand

Let’s say you sell socks and you need to understand which type is selling out fast or might sell out in an upcoming season. Change the date range to show sales last week, or a similar period in the past.

Inventory-Replenishment-Date.png

Plan stock transfers between outlets

Have multiple stores? Select Format results and choose By outlet to see customer demand and inventory in each store to plan your stock transfers. 

Inventory-Replenishment-Outlet.png

Plan supplier orders

You can export the replenishment report and use it to calculate how much inventory you need to cover your next period. If you want to add more columns to your report, click the + sign next to SKU name to add Supplier code, Brand, Supplier, Type, or Tag columns. 

add_columns.png

If you'd like to add more measures to your report, click the + sign next to the Avg cost column.

add_measures.png

From here, you can select a variety of measures to include in your report.

choose_measures.png

When finished selecting everything you want to be included in the report, click Export report.

Inventory-Replenishment-Export.png

Did this answer your question?
Have more questions? Contact us so that we can help you out.