Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
      • Get a Tailored Demo
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +32 2 290 34 90
    • Get a Tailored Demo
  • Pricing
  • Help
  1. APPS
  2. Warehouse
  3. Stock Demand Trends and Forecast v 19.0
  4. Sales Conditions FAQ

Stock Demand Trends and Forecast

by faOtools https://faotools.com/apps/odoo-stock-demand-trends-and-forecast
Odoo

$ 228.39

v 19.0 Third Party 47
Live Preview
Apps purchases are linked to your Odoo account, please sign in or sign up first.
Versions 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0
You bought this module and need support? Click here!
Versions 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0
  • Description
  • Manifest
  • License
Support & Demo

Request a free demo: To see the app in action, copy this link into your browser https://faotools.com/s/o57j28 and ask for a personalized live-preview database. No phone number or credit card required, only a short email sign-up.

Contact us: For any questions about this app, copy this link https://faotools.com/s/zi29ul and reach the team directly.

In Short

Enterprise Community Odoo.sh

Stock Demand Trends and Forecast is an Odoo 19 Warehouse app (19.0.1.0.8). The tool to calculate stock demand trends and make predictions for future demand statistically.

Hold too much stock and you bury cash in the warehouse; hold too little and you break the supply chain. Stock Demand Trends and Forecast turns your Odoo stock-move history into a statistical demand forecast, so replenishment and capacity planning rest on data instead of guesswork.

Build reusable reports straight from your stock moves, split them by day, week, month, quarter, or year, and project future demand with proven statsmodels methods such as ARIMA, SARIMAX, and Holt-Winters. Slice by product, category, warehouse, location, operation type, or stock rule; run several series and models at once; and validate any model against real history before you trust it - all in pivot, graph, chart, or Excel.

Pricing

The current price of Stock Demand Trends and Forecast is 198 (one-time purchase for Odoo 19, all-inclusive Odoo Apps Store price).

No additional paid dependencies are required: the price above covers the full functionality out of the box on top of a standard Odoo installation.

Perfect for

Replenishment & reordering

Forecast demand per product or warehouse to set smarter reorder points and avoid both stockouts and overstock.

Procurement & supply chain

Anticipate future needs so purchasing and inbound logistics stay ahead of demand.

Warehouse & operations

Plan space, staffing, and moves around statistically projected volumes, not last month's guess.

Inventory demand report

Ready to evaluate?

Add to cart now or start with a free demo request.

To purchase the app, click the Add to Cart button at the top of this Odoo Apps Store page.

Start a free demo: https://faotools.com/s/o57j28

Free personalized demo. No phone number or credit card required. Free life-time updates and expert support within the major Odoo version.

  • Features
  • Guidelines
  • FAQ
  • Screenshots
  • Releases
  • Support & Demo free

Why teams choose it

Key benefits before you dive into the details

Scientific, not guesswork

Demand forecasts are built with the proven statsmodels library, so every prediction rests on real statistical methods.

Interactive analysis

Recalculate stock-demand series instantly, switch between saved reports, and adjust settings in a few clicks.

Pivot, chart, or Excel

Study historical and forecast demand as a table, line graph, or bar chart, or export it to Excel.

Focused or company-wide

Narrow to specific products, warehouses, or locations, or analyse global demand, and group into many series.

Any interval, any horizon

Work in days, weeks, months, quarters, or years and predict as many future periods as you need.

Proven before trusted

Backtest models against real history with built-in hypothesis testing before acting on a forecast.

Bar graph of the stocks forecast

Flexible report configuration

Reusable reports, deep warehouse filters, and consistent measures

Build reports your way

  • Create as many reports as you need, each based on Odoo stock moves
  • Save and reuse them, switch instantly, or experiment in real time without saving
  • Choose the interval: yearly, quarterly, monthly, weekly, or daily
  • Predict an unlimited number of future periods
  • Show data as a table, line graph, or bar chart, or export it to Excel
  • Grant access to any WMS user via the Inventory > Stock Demand Forecast group

Filter, group & measure

  • Filter by product category, template, variant, unit of measure, source location, warehouse, operation type, stock rule, or company
  • Add any custom rule with Odoo's dynamic domain constructor
  • Choose which move states count: done, available, waiting, new, cancelled, and more
  • Run several grouped series at once - by variant, location, warehouse, operation type, stock rule, and more
  • Show statistical measures: count, mean, standard deviation, min, max, and quartiles
  • With mixed units of measure, grouping stays consistent by unit or variant, and figures can be shortened (e.g. 192,217 -> 200k) or shown precisely
Inventory report settings

Ready to evaluate?

Add to cart now or start with a free demo request.

To purchase the app, click the Add to Cart button at the top of this Odoo Apps Store page.

Start a free demo: https://faotools.com/s/o57j28

Free personalized demo. No phone number or credit card required. Free life-time updates and expert support within the major Odoo version.

Statistical models

Proven statsmodels engine, and you decide how to use it

Powered by proven statsmodels

  • Forecasts run on the trusted Python statsmodels package
  • Six models included: AutoReg, ARDL, ARIMA, SARIMAX, Holt-Winters (HWES), and Simple Exponential Smoothing (SES)
  • Every model exposes its own parameters, with an in-app Help tab explaining each one
  • Keep and reuse an unlimited number of configured models

You stay in control

  • Nobody understands your demand tendencies better than you - choose the model and parameters that fit your business
  • Compare several models side by side to see which predicts best
  • Adjust and re-run flexibly from the forecast manager
  • Expect to experiment: some parameter sets return no or unrealistic predictions, and that is perfectly normal
Stats model: SARIMAX example

Hypothesis Testing

Backtest a model against real demand before you rely on it

Backtest against real history

  • Forecast a past period you already have actuals for and overlay the prediction against real demand
  • Turn on Hypothesis Testing to see how well a model and its parameters fit
  • Example: train on 2017 - 2021, forecast 2022, then compare with what actually happened

Compare models with confidence

  • Test several statistical models at the same time
  • Instantly see which approach tracks reality most closely
  • Decide whether a model is good enough or whether to keep experimenting
Line chart comparing predicted and actual stock demand to validate the forecast model

Ready to evaluate?

Add to cart now or start with a free demo request.

To purchase the app, click the Add to Cart button at the top of this Odoo Apps Store page.

Start a free demo: https://faotools.com/s/o57j28

Free personalized demo. No phone number or credit card required. Free life-time updates and expert support within the major Odoo version.

What you need for reliable results

Clear conditions for a reliable forecast

Enough history

Trends need a solid volume of past stock moves; a few recent days can't reveal one. Make sure every filter and grouped series has enough data.

Real, non-chaotic trends

Statistics extend patterns that already exist. Random, trendless movements won't predict well, so know which assumption (e.g. seasonality) you are testing.

A statistical mindset

There is no one-click "general" forecast. Value comes from a basic grasp of statistics and a willingness to experiment with each unique case.

Help notes for statistical models and parameters
Python dependencies

To guarantee the tool works correctly, a number of Python libraries are required: pandas, numpy, statsmodels, scipy, xlsxwriter. To install those packages execute the command:

pip3 install pandas numpy statsmodels scipy xlsxwriter

If you run Odoo on Python prior to or equal to version 3.7, please install the following versions of the packages pandas==1.3.5, statsmodels==0.13.1

Server memory limits

Running the statistical analysis and making the forecast is quite a resource-demanding operation. If users face the hanging interface, make sure that server memory limits and timeouts are enough. Otherwise, increase those settings.

What are the update policies of your tools?

According to the current Odoo Apps Store policies:

  • Every module bought for version 12.0 and prior gives you access to all versions up to 12.0.
  • Starting from version 13.0, every module version should be purchased separately.
  • Disregarding the version, purchasing a tool grants you a right to all updates and bug fixes within a major version.

Please note that the faOtools team does not control those policies. For all questions, please contact the Odoo Apps Store representatives directly.

How can I install your app on Odoo.sh?

The most straightforward approach is to use the Odoo store's built-in workflow:

1. Open the module's page and click the button Deploy on odoo.sh

2. After that, you will be redirected to the GitHub page. Log in to your account, then click 'Create a new repo' or use an existing one. Please ensure your repository is private. It is not permitted to publish the apps under the OPL-1 license. If necessary, create a new repo for your Odoo.sh project

3. Then, go to odoo.sh and click the Deploy button. In the pop-up window, submit the decision and click 'Continue.' This action will trigger the installation process.

These steps will install the app for your project's production branch. If you want to deploy the apps for other branches or update the module, you should undertake the following actions:

1. Upload the source code for the app from the Odoo store

2. Commit the module to a required GitHub repository. Ensure none of the app folders/files are ignored (i.e., not included in your repo's .gitignore). Repositories are automatically created by odoo.sh and may include some crucial items by default (e.g., /lib). You should upload all module directories, subdirectories, and files without exceptions

3. Deploy a target branch of the odoo.sh project or, if your settings assume that, wait until it is automatically built.

How should I install your app on my own server?
1. Unzip the source code of the purchased tools in one of your Odoo add-ons' directories;
2. Re-start the Odoo server;
3. Turn on developer mode (technical settings);
4. Update the apps' list (the apps' menu);
5. Find the app and push the button 'Activate'/'Install';
6. Follow the guidelines on the app's page if those exist.
I noticed that your app has extra add-ons. May I purchase them afterwards?

Yes, sure. Simultaneously, Odoo automatically adds all dependencies to a cart, so you should exclude previously purchased tools to avoid double payment.

I deployed your app on Odoo.sh and see warning/error in tests

A red/orange warning does not influence the app's features. Regretfully, sometimes our modules do not pass standard automatic tests since the latter assume behavior that conflicts with our app's goals. For example, we change the price calculation, while the standard Odoo module tests compare the final price to a standard algorithm.

So, first of all, please check the deployed database features. Does everything work correctly?

If you still assume that the warning influences real features, please contact us and forward full installation logs and the full list of deployed modules (including core and third-party ones).

May I buy your app from your company directly?

No, we only distribute the tools through the official Odoo apps store.

I would like to get a discount

Regretfully, we do not have the technical means to provide individual prices. 

May I install the app on my Odoo Online (SaaS) database?

No, third-party apps can not be used on Odoo Online. Unfortunately, Odoo SaaS blocks such a possibility.

Your tool has dependencies on other app(s). Should I purchase those?

Yes, our tool requires all modules marked in dependencies to work correctly. The price marked on the app page already includes all necessary dependencies.

What is the price for the module in US Dollars? Why did it change?

The price for our modules is set in euros. The Odoo store converts prices to other currencies according to its internal exchange rate. Thus, the price in US Dollars may change when the exchange rate is updated.

Inventory demand analysis and forecast

Inventory demand report

The chart of stock moves series and prediction

Bar graph of the stocks forecast

Flexible stock demand report configuration

Inventory report settings

Excel table of warehouse demand prediction

Stock demand forecast: xlsx

Statistical model to forecast stock demand

Statsmodel settings

Leverage Python statsmodels features

Stats model: SARIMAX example

Check hypotheses for inventory trends

Statsmodels: test assumptions

Forecast vs. real demand on a line chart

Line chart comparing predicted and actual stock demand to validate the forecast model

The analysis requires a basic understanding of statistics

Help notes for statistical models and parameters
19.0.1.0.8
  • The app is published to version 19.
18.0.1.0.8
  • The issue with almost invisible filters has been fixed.
18.0.1.0.7
  • The issue with the untranslated warnings has been fixed.
18.0.1.0.6
  • The archived ribbon for inactive records is added for the form views of models and saved reports.
18.0.1.0.5
  • The app is published to version 18.
17.0.1.0.6
  • The analysis algorithm has been optimized to remove excess reading.

Odoo demonstration databases (live previews)

For this app, we might provide a free personalized demo database.

To demand such a database, press the button "Live Preview" on the top of this page or copy the link https://faotools.com/s/o57j28

You do not need a phone number or credit card to contact us. You should only pass a short email sign-up, which does not take more than 30 seconds.

By your request, we will prepare an individual live preview database, where you can apply any tests and check assumptions for about two weeks.

Demo database QR code

Bug reporting

If you encounter bugs or inconsistent behavior, do not hesitate to contact us. We guarantee to provide fixes within 60 days of purchase and are intensely interested in improving our tools even after this period.

To send us a bug report, press the "Website" link at the top of this page and push the button "Bug Report" (the tab Support). Alternatively, copy the link https://faotools.com/s/l7f48m

You do not need a phone number or credit card to contact us. You should only pass a short email sign-up, which does not take more than 30 seconds.

Please include as many details as possible in your request: screenshots, Odoo server logs, a full description of how to reproduce your problem, and so on. Usually, it takes a few business days to prepare a working plan for an issue (if a bug is confirmed) or provide you with guidelines on what should be done (otherwise).

Bug Report QR code

Public features requests and module ideas (free development)

We are strongly motivated to improve our tools and would be grateful for any feedback. If your requirements are of public use and might be efficiently implemented, the team will include those in our to-do list.

Such a to-do list is processed regularly and does not assume extra fees. Although we cannot promise deadlines and final design, it might be a good way to get desired features without investments and risks.

To share ideas, press the "Website" link at the top of this page and push the button "Share Features Ideas" (the tab Support). Alternatively, copy the link https://faotools.com/s/n5n80a

You do not need a phone number or credit card to contact us. You should only pass a short email sign-up, which does not take more than 30 seconds.

Module Ideas QR code

Questions and misc issues

Feel free to contact us with any other concerns, doubts, or questions: press the "Website" link at the top of this page and push the button "Raise Question" (the tab Support). Alternatively, copy the link https://faotools.com/s/zi29ul

You do not need a phone number or credit card to contact us. You should only pass a short email sign-up, which does not take more than 30 seconds.

Questions QR code

About the team

faOtools (faotools.com, former odootools.com) is the developers and business analysts team that helps you extend Odoo's potential. Since 2012, we have worked side by side with end users for whom Odoo is the primary business tool, turning their real needs into ready-to-use apps.

Trusted since 2012

More than a decade focused on Odoo. Many customers have relied on faOtools since Odoo v8, upgrade after upgrade.

102 published apps

102 apps published and maintained on the Odoo Apps Store, covering a wide range of real business needs.

Approved by real users

Our tools are built and hardened with feedback from companies running Odoo in production, and carry strong five-star ratings on the Odoo Store.

Free lifetime support

Free support and bug fixes for the entire lifetime of the Odoo major version you purchased - no recurring support fee.

Free live demos

Try most tools on a live demo database before you buy, so you know exactly what you are getting.

Compatible with core Odoo

Our modules complement standard Odoo apps and follow Odoo's philosophy - they extend the core, they never fight it.

Ready to use out of the box

Designed around real-life scenarios with clean defaults and clear documentation - install and start using them right away.

OPL-1 and AI-friendly

Distributed under the Odoo Proprietary License: you may build your own modules - including AI-assisted adaptations - on top of ours as a dependency.

Open to your ideas

Share a request. If it is useful for everyone, we often add the feature to the app at no extra cost.

You may like the tools

Cloud Storage Solutions
Cloud Storage Solutions

The tool to flexibly structure Odoo attachments in folders and synchronize directories with cloud clients: Google Drive, OneDrive/SharePoint, Nextcloud/ownCloud, Dropbox, Amazon S3, Box, and NAS. DMS. File Manager. Document management system

398
Password Manager
Password Manager

The tool to safely keep passwords in Odoo for shared use. Shared vaults

198 168
KnowSystem: Knowledge Base System
KnowSystem: Knowledge Base System

The tool to build a deep and structured knowledge base for internal and external use. Knowledge System. KMS. Wiki-like revisions.

398
MCP Server. AI Chats and LLM Odoo Integration
MCP Server. AI Chats and LLM Odoo Integration

The tool to manage your Odoo from your favorite AI chats through MCP. Claude. Any MCP-supporting AI.

198
OneDrive / SharePoint Odoo Integration
OneDrive / SharePoint Odoo Integration

The tool to automatically synchronize Odoo attachments with OneDrive files in both ways

487
KPI Balanced Scorecard
KPI Balanced Scorecard

The tool to set up KPI targets and control their fulfillment by periods. KPI dashboards. Dashboard designer. KPI charts

198
Universal Appointments and Time Reservations
Universal Appointments and Time Reservations

The tool for time-based service management from booking appointments to sales and reviews

398
Advanced Variant Prices
Advanced Variant Prices

The tool to configure variant prices based on attributes coefficients and surpluses

98
Vendor Product Management
Vendor Product Management

The tool to administrate vendor data about products, prices, and available stocks

98
More Apps by faOtools
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies • Inventory (stock)
• Discuss (mail)
Lines of code 1702
Technical Name stock_qty_forecast
LicenseSee License tab
Websitehttps://faotools.com/apps/odoo-stock-demand-trends-and-forecast
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

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with