Sale Customer Order Frequency
This module adds computed fields to partners to analyze their order frequency.
Fields added to Contact/Partner:
- Average duration between orders
- Days since last order
- Days until next order
auto_awesome What this module does
AI-generated from the code · Odoo 18.0Adds three order-frequency indicators to contacts: average days between orders, days since the last order and days before the next expected order. They are calculated automatically from confirmed sales orders and shown on the contact form and list.
This module helps you see how regularly a customer orders, directly on their contact record.
On the contact form, in the Sales section, you get three read-only values: - Average Duration Between Orders: the average number of days between two confirmed orders. - Days Since Last Order: how many days have passed since the customer's most recent confirmed order. - Days Before Next Order: how many days remain before the next order is expected, based on the average rhythm.
The same three columns can be added to the contact list view; the "days before next order" column is shown by default, while the other two are hidden until you choose to display them.
The values are computed automatically from the customer's sales orders. Only orders in the confirmed (sale) state with an order date are counted. If the customer has no confirmed order, all three values are zero. With only one order, the average and the days-before-next-order stay zero, while days since last order is still calculated. With two or more orders, the average is the number of days between the first and last confirmed order divided by the number of intervals, and the days before the next order is that average minus the days already elapsed since the last order.
The fields are stored on the contact and recalculated when the related sales orders change date or status. No new menus or reports are added.
Depends on
Models and fields (1)
- res.partner · extends an existing modeldays_since_last_order, days_until_next_order (Days Before Next Order), average_order_duration (Average Duration Between Orders)
Text generated by AI (DeepSeek) from reading the Odoo 18.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 1 confirmed, 8 with no information of 9 versions.
Sources · Odoo 18.0
Confirmed on 2026-11-03 in branch 18.0 of OCA/partner-contact.
terminal Installation and usage
OCA documentation · Odoo 18.0Usage
Source · Odoo 18.0To use this module, you need to:
- Go to Contacts.
- Open a partner form.
- In the Sales & Purchase tab, look for the following fields in the Sale group:
- Average order duration: Average number of days between confirmed orders.
- Days since last order: Number of days elapsed since the last confirmed order.
- Days until next order: Estimated number of days until the next order based on the average duration.
These fields are computed based on confirmed sale orders (state="sale").
No verified information in OCA: Installation, Configuration.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.