Inventory Planning by Days Report

Inventory Planning by Days Report

Overview

The Inventory Planning by Days report helps you plan inventory using historical order data for a selected number of days and the current available inventory.

The report provides SKU-level data based on the number of orders received during the selected period and the available inventory. You can select the number of days for which you want to analyze the data and review the current inventory status of each product.

How to View the Inventory Planning by Days Report

Step 1: Navigate to Reports > Report Dashboard.

Step 2: Under Warehouse & Inventory Reports, click Inventory Planning by Days.


The Inventory Planning by Days page opens with 30 days entered by default in the Number Of Days field. Additionally, you can select one or multiple locations to find out for combined or individual child locations.


Note:

  1. If you want to analyze data for a different number of days, change the value in the Number Of Days field. The report data is displayed based on the selected number of days.
  2. You can also use the Search bar to search for a specific SKU.
  3. The report can be viewed/downloaded for maximum of 31 days.

Report Parameters

The report displays the following parameters:

  • Brand
  • Model
  • Category
  • Image
  • SKU
  • Product Name
  • Total Quantity Ordered
  • Current Available Inventory
  • Quantity To Be Ordered
  • Quantity in Purchase Order
  • Stock Out Duration (Days)

Calculation Logic

The report calculates inventory coverage based on the order history for the selected number of days and the current available inventory.

Total Orders: Number of orders received during the selected period. Cancelled and returned orders are excluded.

Available Quantity: Current marketplace pushed inventory.

Average Orders: Average number of orders per day, calculated as:

Total Orders ÷ Number of Days Selected

Days Left: Estimated number of days the available inventory will last, calculated as:

Available Quantity ÷ Average Orders

The Average Orders value is rounded to two decimal places before calculating Days Left. Days Left is displayed as a rounded whole number.

Example

If 7 days are selected for SKU ABC, and the SKU has 5 total orders and an available quantity of 43:
Average Orders = 5 ÷ 7 = 0.71
Days Left = 43 ÷ 0.71 = 61 days
This means the current available inventory is estimated to last for approximately 61 days based on the average orders during the selected period.

How to Download the Report

Click Export CSV to download the report directly in CSV format.

Video