Inventory Threshold for Low Stock Alerts

Inventory Threshold for Low Stock Alerts

Description

Inventory Threshold feature allows sellers' to define a minimum inventory threshold for SKUs at a warehouse location. Once this threshold is breached system triggers an action. 

When inventory reaches or goes below this quantity, the system triggers a threshold-based report to the users. This feature is beneficial to support inventory planning.

Use Case

Use this when you want to:
  • Maintain warehouse-specific inventory thresholds
  • Monitor low stock per location
  • Apply thresholds to all child locations from the primary location
  • Bulk update inventory thresholds using bulk import

Access & Permissions

Inventory Threshold import and export actions are available only to users with the following roles:
- Vendor Admin
- Warehouse Manager

Other users do not have access to these actions.

Pre Read

Primary Location
  1. The first location created when an Easyecom account is set up.
  2. Acts as the central control location for the account.
  3. Has visibility of all child locations.
  4. Used to manage account level configurations.
Child Location
  1. A location created under the Primary Location.
  2. Represents a specific warehouse/location.
  3. Has access only to its own location data.
  4. Used for location specific operations.

Step-by-Step Execution

Step 1: Go to Import Thresholds

  1. Go to Menu → Masters → Product Master
  2. Click on Import Thresholds.

Step 1A: Download Existing Inventory Threshold Report (Optional)

Click Download Existing Inventory Threshold List to download and review the current inventory threshold data.




Step 2: Download & Fill the Sample Sheet

  1. Click Download Sample Sheet (A template file is downloaded)
  2. Fill the columns as per the guide mentioned below:
Column
Mandatory
Description
Location KeyYesWarehouse ID
SKU CodeYesActive SKU for which threshold is to be set
Threshold QuantityYesNumeric value ≥ 0 



Step 3: Upload Inventory Threshold File

  1. Click Choose File
  2. Select the filled sample sheet.
  3. Checkbox: Apply to all child locations (if required)
    1. This updates threshold in all child locations
    2. Does not work when child location IDs are included in the sample sheet and the Apply to all child locations option is selected.
    3. Visible only when logged in to Primary Location

Once Uploaded, check the status of import action to ensure successfully finished import

When uploading from a Child Location

  1. Thresholds apply only to that child location
  2. Apply-to-all option is not available

Inventory Threshold Alert Setting

To receive inventory threshold alert emails on the registered email, the following setting must be enabled:
  1. Go to Account Settings → Other Settings

     2. Enable Send Inventory Threshold Mail

If this setting is disabled, inventory thresholds will still be applied, but alert emails will not be sent.


FAQs

Q1. Can thresholds be set for all child locations at once?
Yes. From the primary location, use the Apply to all child locations option while uploading the file.

Q2. Can thresholds be set from a child location?
Yes. From a child location, thresholds apply only to that specific location.

Q3. What happens if both, child location IDs are entered in the sample sheet and the 'apply to all child locations' is enabled together?
The system throws an error. Only one method can be used at a time.



    • Related Articles

    • 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 ...
    • How is inventory synced/pushed through EasyEcom? (Inventory Synchronization)

      At EasyEcom, we deeply value our partnership with you and are dedicated to delivering services that continually evolve to meet your ever-changing needs. In this document, we present changes aimed at enhancing the Inventory sync between your EasyEcom ...
    • Inventory Reconciliation Report

      Software Plan: Growth & Enterprise Account Type : Seller Account & Aggregator 3PL Inventory Type : Serialized & Non-Serialized Feature description This report offers a comprehensive SKU-level inventory reconciliation, ensuring accurate tracking of ...
    • Defining Inventory Threshold Channel Wise

      You can now list a fixed inventory count  (more or less than the actual inventory available at the warehouse)  channel-wise based on your requirement.  With the functionality of listing a higher inventory count, you increase the chances of potential ...
    • Inventory Snapshot

      Inventory snapshot reports help retailers in keeping a track of their inventory and thereby help you in inventory analytics.  EasyEcom’s inventory snapshot is beneficial to retailers like you as it provides you with: ​ 1. Status Report-  This report ...