See which stock to ship before it expires
A live rotation and expiry dashboard for Odoo Inventory. Age, FSN velocity, and lot-level expiry status for every product, warehouse, and location — with proactive alerts before stock writes off.
Perishable, batch-tracked, and expiry-sensitive inventory ages out before it moves. Standard Odoo inventory reports show what is on hand today, not how old it is, how fast it turns, or which lots are closing in on their expiry date — so warehouse teams write off stock, fail traceability audits, and lose margin they never saw coming.
Warehouse Stock Rotation Report generates a point-in-time snapshot of every on-hand bucket — product, lot, and location — with age, expiry state, and a Fast / Slow / Non-Moving classification. Filter by warehouse, category, and date range from an interactive wizard, then work from a live dashboard instead of a static export.
This app speaks your language.
Tell us the language your team works in and we translate this module for you, free of charge — so everyone works in the language they know best.
Request my free translation →No hidden fees. No subscription.
Everything a rotation report should do
Every capability below is implemented in the module.
Age-based rotation report
Every on-hand quantity is broken down by product, lot, and location with the number of days since receipt, so the oldest stock is always visible first.
Fast / Slow / Non-Moving classification
Configurable velocity thresholds label every line Fast, Slow, or Non-Moving from real outgoing-move history, turning raw age data into a dead-stock signal procurement can act on.
Lot-level expiry tracking
Expiration and removal dates from product_expiry drive an Expired / Expiring Soon / OK status per lot, with a configurable warning threshold in days.
Days-of-stock coverage
On-hand quantity divided by daily velocity shows how many days of cover each product has left, flagging overstock before it becomes write-off risk.
Interactive filter wizard
Warehouse managers generate a report themselves by warehouse, product category, date range, and thresholds — no developer or admin configuration required.
Live rotation dashboard
List, kanban, pivot, and graph views of every snapshot line with expiry and FSN badges give an always-on view of rotation health, not a report you have to re-run to check.
Proactive expiry alerts
A daily scheduled action finds lots approaching their expiry threshold and creates a follow-up activity automatically, so at-risk stock is flagged before it lapses.
Scheduled email digest
A configurable weekly cron generates a fresh report and emails a KPI summary to every Stock Rotation Manager, so reviews happen without anyone remembering to pull a report.
PDF and Excel export
Print a formatted PDF rotation report straight from the record, or use Odoo's native list export for an Excel copy of every line — ready for audits and offline review.
How it works
Set your filters
Open the New Report wizard and choose a warehouse, product category, date range, and expiry / velocity thresholds — or leave them at the configured defaults.
Generate the snapshot
One click builds a frozen snapshot line for every on-hand product, lot, and location bucket with age, expiry state, and FSN classification already calculated.
Work the dashboard
Review the KPI band, list, and kanban dashboard for expiring lots and non-moving stock, or drop into pivot and graph views to spot patterns by warehouse or category.
Export or automate
Print the PDF report, export the line list to Excel, or let the scheduled digest and expiry-alert activities keep managers informed automatically.
See it in action
From the reports list to the printable PDF — every screen shown here runs on real seeded data.
Every generated report at a glance, with expiring and non-moving line counts and a status badge per report.
A single report's filters, KPI band, statusbar, and embedded lines — with full chatter history for an audit trail.
Every snapshot line with age, expiry date, days-to-expiry, velocity, days-of-stock, and FSN badges, color-coded by risk.
The same data as per-product cards — on-hand quantity, age, expiry status, and FSN class at a glance.
The interactive wizard lets any warehouse user filter by warehouse, category, date range, and thresholds — no configuration needed.
Default expiry threshold, velocity window, and Fast / Slow thresholds are configurable in one place.
A formatted PDF export with the KPI summary header and full line table, ready to print or archive.
Frequently asked
Which Odoo versions does this support?
The module ships for Odoo 17.0, 18.0, and 19.0, with the same rotation, expiry, and FSN logic on every version.
What do I need installed for it to work?
It depends only on the standard stock, product_expiry, and mail apps — no extra paid modules or external services are required.
How is Fast / Slow / Non-Moving decided?
Each product's average daily outgoing quantity over a configurable window is compared to Fast and Slow velocity thresholds you set in Settings or per report; anything below the Slow threshold is Non-Moving.
Can I get reports without opening Odoo every day?
Yes. A daily scheduled action raises expiry-alert activities on at-risk lots, and an optional weekly digest email sends the report's KPIs to your Stock Rotation Managers automatically.
Get in Touch
Have questions or need customization? Every purchase includes 30 days of free support — we are here to help.
Visit Our Website
www.cerevantix.comExplore our apps, services, and portfolio.
Empowering growth through technology.
Warehouse Stock Rotation Report: age, expiry, and FSN velocity analysis for every product, lot, and warehouse — with proactive alerts and scheduled digests, right inside Odoo Inventory.
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Inventory (stock) |
| Lines of code | 985 |
| Technical Name |
cerevantix_warehouse_stock_rotation_report |
| License | OPL-1 |
| Website | https://cerevantix.com |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module