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


    • Related Articles

    • FAQ Inventory

      1. Can I add my manufacturing unit as a vendor in Vendor Master. Also can I raise Purchase Orders to my factory from EasyEcom? Yes you can raise Purchase Orders to your factory from EasyEcom. However, please note you will not be able to manage raw ...

    • Manage Inventory - Starter Plan

      Software Plan: Starter Account Type: Seller Account & Aggregator 3PL Inventory Type: Non-Serialized Feature Description This knowledge base article provides a clear and concise guide for sellers using the Easyecom Starter Plan on how to manage their ...

    • Inventory Reconciliation Report

      Software Plan: Growth & Enterprise Account Type : Seller Account & Aggregator 3PL Inventory Type : Serialized & Non-Serialized Overview This report provides SKU-level inventory reconciliation by comparing the opening and closing inventory balances ...

    • Inventory Ledger Report / Inventory Reconciliation

      What is inventory ledger report ? The Inventory Ledger report is like a bank statement for a warehouse inventory. It provides end-to-end inventory reconciliation capability by showing your starting inventory balance, received Inventory, customer ...

    • Inventory Forecasting and Planning

      Inventory forecasting and planning are important for all retail companies especially in the field of eCommerce. It helps brands in reducing their storage costs, more efficient production planning, reduces non-sellable stock, increases customer ...