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.