Stagnated Inventory helps you identify products that haven’t moved in a specified number of days. Use this report to find slow-moving stock, make reordering decisions, and optimize warehouse space by clearing out dead inventory.
Identify products taking up valuable warehouse space without generating sales.
Lower storage fees and holding costs by clearing out slow-moving inventory.
Make better purchasing decisions by identifying products that don’t sell.
Convert stagnant stock back into cash through clearance sales or liquidation.
The system identifies stagnated products using these criteria:
Included Products:
UnitsInStock > 0)Discontinued = 'N')QtyHold = 0)StatusType = 'Shipped') in the configured periodStatusType = 'Received') in the configured periodConfigured Period:
The number of days is set in your account’s premium services settings (Stagnated_Inventory field). This determines how far back the system looks for product movement.
Example: If your threshold is 90 days, the report shows products that haven’t been shipped or received in the last 90 days.
Navigate to Stagnated Inventory from the catalog menu or visit /stagnated.php directly.
The report displays:
Open Stagnated Inventory
Navigate to Stagnated Inventory from the inventory menu.
Review the Threshold
Check the Stagnated Inventory Days displayed at the top. This shows your configured period (e.g., 90 days).
Search and Filter Products
Use the search boxes above each column to filter:
Analyze the Results
Review products sorted by quantity in stock (highest to lowest) and supplier name.
Key Questions to Ask:
Download CSV for Analysis
Click Download CSV to export the full report for spreadsheet analysis.
Take Action
Based on your analysis:
The stagnated inventory report updates automatically:
The number of days for stagnated inventory is configured in your account’s premium services settings.
Common Thresholds:
The system considers a product as “moved” if it has either:
Shipment Activity:
StatusType = 'Shipped'Receipt Activity:
StatusType = 'Received'Not Considered Movement:
Check stagnated inventory report monthly to identify trends early.
Don’t discontinue seasonal items just because they’re temporarily stagnant.
Group by supplier to identify vendors with consistently slow-moving products.
Create a clear process for handling stagnated inventory (clearance, liquidation, return to supplier).
Products with high quantities are more urgent to address than low-quantity stagnation.
Compare stagnated inventory with sales reports to understand demand patterns.
Once you’ve identified stagnated products, consider these actions:
Discontinue
Mark the SKU as discontinued if you no longer want to stock it. This prevents new orders while allowing existing inventory to sell through.
When to Use: Product permanently discontinued, low demand, supplier issues.
Clearance Sale
Reduce prices to move inventory quickly and free up space.
When to Use: Excess stock, seasonal items out of season, product refresh.
Transfer to Other DC
Move inventory to a distribution center where demand is higher.
When to Use: Multi-location operations, regional demand variations.
Return to Supplier
Negotiate returns or exchanges with your supplier.
When to Use: Vendor agreements allow returns, overstocked items, damaged/defective.
Liquidation
Sell to liquidation companies or secondary marketplaces at reduced prices.
When to Use: High-volume stagnation, warehouse space critical, product obsolete.
Bundling
Create product bundles or kits to include slow-moving items with popular products.
When to Use: Complementary products, promotional opportunities.
The CSV export includes:
File Location: export_csv_inventory/[CompanyName]
File Format: Standard CSV (comma-separated values) compatible with Excel, Google Sheets, and other spreadsheet software.
Use the CSV export for:
Problem: Report shows no stagnated inventory.
Possible Reasons:
Solutions:
UnitsInStock > 0)Problem: Product appears in report but you know it sold recently.
Possible Causes:
Solutions:
Problem: Cannot download CSV file.
Solutions:
export_csv_inventory/Next Steps: Catalog Overview | SKU Management | Distribution Centers