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
- The first location created when an Easyecom account is set up.
- Acts as the central control location for the account.
- Has visibility of all child locations.
- Used to manage account level configurations.
Child Location
- A location created under the Primary Location.
- Represents a specific warehouse/location.
- Has access only to its own location data.
- Used for location specific operations.
Step-by-Step Execution
Step 1: Go to Import Thresholds
Go to Menu → Masters → Product Master
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
Click Download Sample Sheet (A template file is downloaded)
Fill the columns as per the guide mentioned below:
Column
| Mandatory | Description |
| Location Key | Yes | Warehouse ID |
| SKU Code | Yes | Active SKU for which threshold is to be set |
| Threshold Quantity | Yes | Numeric value ≥ 0 |
Step 3: Upload Inventory Threshold File
Click Choose File
Select the filled sample sheet.
Checkbox: Apply to all child locations (if required)
This updates threshold in all child locations
Does not work when child location IDs are included in the sample sheet and the Apply to all child locations option is selected.
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
Thresholds apply only to that child location
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:
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.